/// <summary> /// 增加一条数据 /// </summary> public long Add(lgk.Model.tb_goodsCar model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_goodsCar model) { return(dal.Update(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <lgk.Model.tb_goodsCar> DataTableToList(DataTable dt) { List <lgk.Model.tb_goodsCar> modelList = new List <lgk.Model.tb_goodsCar>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { lgk.Model.tb_goodsCar model; for (int n = 0; n < rowsCount; n++) { model = new lgk.Model.tb_goodsCar(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.GoodsTypeName = dt.Rows[n]["GoodsTypeName"].ToString(); model.Pic1 = dt.Rows[n]["Pic1"].ToString(); model.Remarks = dt.Rows[n]["Remarks"].ToString(); if (dt.Rows[n]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString()); } if (dt.Rows[n]["Goods002"].ToString() != "") { model.Goods002 = int.Parse(dt.Rows[n]["Goods002"].ToString()); } if (dt.Rows[n]["Goods005"].ToString() != "") { model.Goods005 = decimal.Parse(dt.Rows[n]["Goods005"].ToString()); } if (dt.Rows[n]["Goods006"].ToString() != "") { model.Goods006 = int.Parse(dt.Rows[n]["Goods006"].ToString()); } if (dt.Rows[n]["BuyUser"].ToString() != "") { model.BuyUser = long.Parse(dt.Rows[n]["BuyUser"].ToString()); } if (dt.Rows[n]["TotalMoney"].ToString() != "") { model.TotalMoney = decimal.Parse(dt.Rows[n]["TotalMoney"].ToString()); } if (dt.Rows[n]["TotalGoods006"].ToString() != "") { model.TotalGoods006 = int.Parse(dt.Rows[n]["TotalGoods006"].ToString()); } if (dt.Rows[n]["GoodsID"].ToString() != "") { model.GoodsID = int.Parse(dt.Rows[n]["GoodsID"].ToString()); } if (dt.Rows[n]["ShopPrice"].ToString() != "") { model.ShopPrice = decimal.Parse(dt.Rows[n]["ShopPrice"].ToString()); } model.GoodsCode = dt.Rows[n]["GoodsCode"].ToString(); model.GoodsName = dt.Rows[n]["GoodsName"].ToString(); if (dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["RealityPrice"].ToString() != "") { model.RealityPrice = decimal.Parse(dt.Rows[n]["RealityPrice"].ToString()); } if (dt.Rows[n]["TypeID"].ToString() != "") { model.TypeID = int.Parse(dt.Rows[n]["TypeID"].ToString()); } model.TypeIDName = dt.Rows[n]["TypeIDName"].ToString(); if (dt.Rows[n]["GoodsType"].ToString() != "") { model.GoodsType = int.Parse(dt.Rows[n]["GoodsType"].ToString()); } modelList.Add(model); } } return(modelList); }