protected void Save()
{
ShowShop.BLL.Product.ProductUnit bll = new ShowShop.BLL.Product.ProductUnit();
ShowShop.Model.Product.ProductUnit model = new ShowShop.Model.Product.ProductUnit();
model.Name = txtName.Text.Trim();
model.Sort = ChangeHope.Common.StringHelper.StringToInt(txtSort.Text.Trim());
if (ViewState["ID"] != null)
{
model.ID = int.Parse(ViewState["ID"].ToString());
bll.Update(model);
this.ltlMsg.Text = "操作成功，已保存该信息";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
else
{
bll.Add(model);
this.ltlMsg.Text = "操作成功，已保存该信息";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}
/// <summary>
/// 返回数据
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public ShowShop.Model.Product.ProductUnit GetModel(System.Data.DataRow row)
{
ShowShop.Model.Product.ProductUnit model = new ShowShop.Model.Product.ProductUnit();
if (row != null)
{
model.ID = int.Parse(row["id"].ToString());
model.Name = row["name"].ToString();
model.Sort = int.Parse(row["sort"].ToString());
return model;
}
else
{
return null;
}
}
/// <summary>
/// 得到指定条件的所有集合
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List<ShowShop.Model.Product.ProductUnit> GetAll(string strWhere)
{
List<ShowShop.Model.Product.ProductUnit> list = new List<ShowShop.Model.Product.ProductUnit>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,name,sort from yxs_productunit ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
strSql.Append(" order by sort asc");
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Product.ProductUnit model = new ShowShop.Model.Product.ProductUnit();
model.ID = reader.GetInt32(0);
model.Name = reader.GetString(1);
model.Sort = reader.GetInt32(2);
list.Add(model);
}
}
return list;
}
