/// <summary> /// 获得数据列表 /// </summary> public List <ZhangWei.Model.Sale> DataTableToList(DataTable dt) { List <ZhangWei.Model.Sale> modelList = new List <ZhangWei.Model.Sale>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ZhangWei.Model.Sale model; for (int n = 0; n < rowsCount; n++) { model = new ZhangWei.Model.Sale(); if (dt.Rows[n]["Sale_ID"] != null && dt.Rows[n]["Sale_ID"].ToString() != "") { model.Sale_ID = int.Parse(dt.Rows[n]["Sale_ID"].ToString()); } if (dt.Rows[n]["SaleDate"] != null && dt.Rows[n]["SaleDate"].ToString() != "") { model.SaleDate = DateTime.Parse(dt.Rows[n]["SaleDate"].ToString()); } if (dt.Rows[n]["TradeNo"] != null && dt.Rows[n]["TradeNo"].ToString() != "") { model.TradeNo = dt.Rows[n]["TradeNo"].ToString(); } if (dt.Rows[n]["Dept_ID"] != null && dt.Rows[n]["Dept_ID"].ToString() != "") { model.Dept_ID = int.Parse(dt.Rows[n]["Dept_ID"].ToString()); } if (dt.Rows[n]["Employee_ID"] != null && dt.Rows[n]["Employee_ID"].ToString() != "") { model.Employee_ID = int.Parse(dt.Rows[n]["Employee_ID"].ToString()); } if (dt.Rows[n]["StoreHouse_ID"] != null && dt.Rows[n]["StoreHouse_ID"].ToString() != "") { model.StoreHouse_ID = int.Parse(dt.Rows[n]["StoreHouse_ID"].ToString()); } if (dt.Rows[n]["Address"] != null && dt.Rows[n]["Address"].ToString() != "") { model.Address = dt.Rows[n]["Address"].ToString(); } if (dt.Rows[n]["Account"] != null && dt.Rows[n]["Account"].ToString() != "") { model.Account = dt.Rows[n]["Account"].ToString(); } if (dt.Rows[n]["GatheringWay"] != null && dt.Rows[n]["GatheringWay"].ToString() != "") { model.GatheringWay = dt.Rows[n]["GatheringWay"].ToString(); } if (dt.Rows[n]["Customer"] != null && dt.Rows[n]["Customer"].ToString() != "") { model.Customer = int.Parse(dt.Rows[n]["Customer"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhangWei.Model.Sale model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhangWei.Model.Sale model) { return(dal.Add(model)); }