学习三层中遇到的小问题。
WEB部分代码:
//响应单击,提交数据
protected void btnGo_Click(object sender, EventArgs e)
{
Model.Product mdl_product = new Model.Product();
//为实体赋值
mdl_product.ChannelID = 1016;
mdl_product.ClassID = int.Parse(ddl_class.SelectedValue);
mdl_product.Title = txtProductName.Text.Trim();
mdl_product.Content = ftbox_JianJie.Text;
if (BLL_Admin_Product.InsertProduct(mdl_product))
{
Response.Write(BLL.Common.showMessage("showMessage方法成功!"));
clearData();
}
else
{
BLL.Common.showMessage("信息提交失败!");
}
}
BLL部分代码:
#region 提交产品与服务数据
public bool InsertProduct(Model.Product mdl_product)
{
return DAL_Admin_product.InsertProduct(mdl_product);
}
#endregion
DAL部分代码:
#region 提交产品与服务数据
public bool InsertProduct(Model.Product mdl_product)
{
string strSQL = "INSERT INTO Product(ChannelID,ClassID,Title,UpdateTime,Content) VALUES("+mdl_product.ChannelID+","+mdl_product.ClassID+",'"+mdl_product.Title+"',"+DateTime.Now+",'"+mdl_product.Content+"')";
return db.ExecuteNonQuery(false, strSQL);
}
#endregion
MODEL部分代码:
namespace Model
{
/// <summary>
/// 实体层----产品与服务
/// 定义成员变量及属性
/// </summary>
public class Product
{
#region 定义类的内部变量
/// <summary>
/// 定义类的成员变量
/// </summary>
private int _ProductID;
private int _ChannelID;
private int _ClassID;
private string _Title;
private DateTime _UpdateTime;
private string _Content;
public int ProductID
{
get { return _ProductID; }
set { _ProductID=value; }
}
public int ChannelID
{
get { return _ChannelID; }
set { _ChannelID = value; }
}
public int ClassID
{
get { return _ClassID; }
set { _ClassID = value; }
}
public string Title
{
get { return _Title; }
set { _Title = value; }
}
public string Content
{
get { return _Content; }
set { _Content = value; }
}
public DateTime UpdateTime
{
get { return _UpdateTime; }
set { _UpdateTime = value; }
}
#endregion
}
}