/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_goods model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_goods model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <lgk.Model.tb_goods> DataTableToList(DataTable dt)
{
List <lgk.Model.tb_goods> modelList = new List <lgk.Model.tb_goods>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
lgk.Model.tb_goods model;
for (int n = 0; n < rowsCount; n++)
{
model = new lgk.Model.tb_goods();
if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["GoodsCode"] != null && dt.Rows[n]["GoodsCode"].ToString() != "")
{
model.GoodsCode = dt.Rows[n]["GoodsCode"].ToString();
}
if (dt.Rows[n]["GoodsName"] != null && dt.Rows[n]["GoodsName"].ToString() != "")
{
model.GoodsName = dt.Rows[n]["GoodsName"].ToString();
}
if (dt.Rows[n]["Price"] != null && dt.Rows[n]["Price"].ToString() != "")
{
model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString());
}
if (dt.Rows[n]["RealityPrice"] != null && dt.Rows[n]["RealityPrice"].ToString() != "")
{
model.RealityPrice = decimal.Parse(dt.Rows[n]["RealityPrice"].ToString());
}
if (dt.Rows[n]["Standard"] != null && dt.Rows[n]["Standard"].ToString() != "")
{
model.Standard = dt.Rows[n]["Standard"].ToString();
}
if (dt.Rows[n]["IsHave"] != null && dt.Rows[n]["IsHave"].ToString() != "")
{
model.IsHave = int.Parse(dt.Rows[n]["IsHave"].ToString());
}
if (dt.Rows[n]["TypeID"] != null && dt.Rows[n]["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(dt.Rows[n]["TypeID"].ToString());
}
if (dt.Rows[n]["GoodsType"] != null && dt.Rows[n]["GoodsType"].ToString() != "")
{
model.GoodsType = int.Parse(dt.Rows[n]["GoodsType"].ToString());
}
if (dt.Rows[n]["Pic1"] != null && dt.Rows[n]["Pic1"].ToString() != "")
{
model.Pic1 = dt.Rows[n]["Pic1"].ToString();
}
if (dt.Rows[n]["Pic2"] != null && dt.Rows[n]["Pic2"].ToString() != "")
{
model.Pic2 = dt.Rows[n]["Pic2"].ToString();
}
if (dt.Rows[n]["Pic3"] != null && dt.Rows[n]["Pic3"].ToString() != "")
{
model.Pic3 = dt.Rows[n]["Pic3"].ToString();
}
if (dt.Rows[n]["Pic4"] != null && dt.Rows[n]["Pic4"].ToString() != "")
{
model.Pic4 = dt.Rows[n]["Pic4"].ToString();
}
if (dt.Rows[n]["Pic5"] != null && dt.Rows[n]["Pic5"].ToString() != "")
{
model.Pic5 = dt.Rows[n]["Pic5"].ToString();
}
if (dt.Rows[n]["Summary"] != null && dt.Rows[n]["Summary"].ToString() != "")
{
model.Summary = dt.Rows[n]["Summary"].ToString();
}
if (dt.Rows[n]["Remarks"] != null && dt.Rows[n]["Remarks"].ToString() != "")
{
model.Remarks = dt.Rows[n]["Remarks"].ToString();
}
if (dt.Rows[n]["AddTime"] != null && dt.Rows[n]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString());
}
if (dt.Rows[n]["Goods001"] != null && dt.Rows[n]["Goods001"].ToString() != "")
{
model.Goods001 = int.Parse(dt.Rows[n]["Goods001"].ToString());
}
if (dt.Rows[n]["Goods002"] != null && dt.Rows[n]["Goods002"].ToString() != "")
{
model.Goods002 = int.Parse(dt.Rows[n]["Goods002"].ToString());
}
if (dt.Rows[n]["Goods003"] != null && dt.Rows[n]["Goods003"].ToString() != "")
{
model.Goods003 = dt.Rows[n]["Goods003"].ToString();
}
if (dt.Rows[n]["Goods004"] != null && dt.Rows[n]["Goods004"].ToString() != "")
{
model.Goods004 = dt.Rows[n]["Goods004"].ToString();
}
if (dt.Rows[n]["Goods005"] != null && dt.Rows[n]["Goods005"].ToString() != "")
{
model.Goods005 = decimal.Parse(dt.Rows[n]["Goods005"].ToString());
}
if (dt.Rows[n]["Goods006"] != null && dt.Rows[n]["Goods006"].ToString() != "")
{
model.Goods006 = decimal.Parse(dt.Rows[n]["Goods006"].ToString());
}
if (dt.Rows[n]["Goods007"] != null && dt.Rows[n]["Goods007"].ToString() != "")
{
model.Goods007 = DateTime.Parse(dt.Rows[n]["Goods007"].ToString());
}
if (dt.Rows[n]["Goods008"] != null && dt.Rows[n]["Goods008"].ToString() != "")
{
model.Goods008 = DateTime.Parse(dt.Rows[n]["Goods008"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}