/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.MaterielStructMain model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.MaterielStructMain model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.MaterielStructMain> DataTableToList(DataTable dt) { List <Hownet.Model.MaterielStructMain> modelList = new List <Hownet.Model.MaterielStructMain>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.MaterielStructMain model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.MaterielStructMain(); if (dt.Rows[n]["MainID"].ToString() != "") { model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString()); } else { model.MainID = 0; } model.Ver = dt.Rows[n]["Ver"].ToString(); if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } else { model.MaterielID = 0; } if (dt.Rows[n]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString()); } else { model.DateTime = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } else { model.CompanyID = 0; } if (dt.Rows[n]["TaskID"].ToString() != "") { model.TaskID = int.Parse(dt.Rows[n]["TaskID"].ToString()); } else { model.TaskID = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["IsDefault"].ToString() != "") { if ((dt.Rows[n]["IsDefault"].ToString() == "1") || (dt.Rows[n]["IsDefault"].ToString().ToLower() == "true")) { model.IsDefault = true; } else { model.IsDefault = false; } } if (dt.Rows[n]["IsVerify"].ToString() != "") { model.IsVerify = int.Parse(dt.Rows[n]["IsVerify"].ToString()); } else { model.IsVerify = 0; } if (dt.Rows[n]["VerifyManID"].ToString() != "") { model.VerifyManID = int.Parse(dt.Rows[n]["VerifyManID"].ToString()); } else { model.VerifyManID = 0; } if (dt.Rows[n]["VerifyDateTime"].ToString() != "") { model.VerifyDateTime = DateTime.Parse(dt.Rows[n]["VerifyDateTime"].ToString()); } else { model.VerifyDateTime = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["Executant"].ToString() != "") { model.Executant = int.Parse(dt.Rows[n]["Executant"].ToString()); } else { model.Executant = 0; } if (dt.Rows[n]["Money"] != null && dt.Rows[n]["Money"].ToString() != "") { model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString()); } if (dt.Rows[n]["WorkingMoney"] != null && dt.Rows[n]["WorkingMoney"].ToString() != "") { model.WorkingMoney = decimal.Parse(dt.Rows[n]["WorkingMoney"].ToString()); } if (dt.Rows[n]["OutPrice"] != null && dt.Rows[n]["OutPrice"].ToString() != "") { model.OutPrice = decimal.Parse(dt.Rows[n]["OutPrice"].ToString()); } if (dt.Rows[n]["MaterielPro"] != null && dt.Rows[n]["MaterielPro"].ToString() != "") { model.MaterielPro = decimal.Parse(dt.Rows[n]["MaterielPro"].ToString()); } if (dt.Rows[n]["GrossProfit"] != null && dt.Rows[n]["GrossProfit"].ToString() != "") { model.GrossProfit = decimal.Parse(dt.Rows[n]["GrossProfit"].ToString()); } if (dt.Rows[n]["GrossPro"] != null && dt.Rows[n]["GrossPro"].ToString() != "") { model.GrossPro = decimal.Parse(dt.Rows[n]["GrossPro"].ToString()); } if (dt.Rows[n]["CMT"] != null && dt.Rows[n]["CMT"].ToString() != "") { model.CMT = decimal.Parse(dt.Rows[n]["CMT"].ToString()); } model.BySizeName = dt.Rows[n]["BySizeName"].ToString(); model.ExSize = dt.Rows[n]["ExSize"].ToString(); model.MaterielLoss = dt.Rows[n]["MaterielLoss"].ToString(); model.PackLoss = dt.Rows[n]["PackLoss"].ToString(); if (dt.Rows[n]["FillManID"] != null && dt.Rows[n]["FillManID"].ToString() != "") { model.FillManID = int.Parse(dt.Rows[n]["FillManID"].ToString()); } model.FillManName = dt.Rows[n]["FillManName"].ToString(); model.VerifyManName = dt.Rows[n]["VerifyManName"].ToString(); model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }