/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.MiniEmp model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.MiniEmp model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.MiniEmp> DataTableToList(DataTable dt) { List <Hownet.Model.MiniEmp> modelList = new List <Hownet.Model.MiniEmp>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.MiniEmp model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.MiniEmp(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } else { model.ID = 0; } model.Name = dt.Rows[n]["Name"].ToString(); if (dt.Rows[n]["IntroducerID"].ToString() != "") { model.IntroducerID = int.Parse(dt.Rows[n]["IntroducerID"].ToString()); } else { model.IntroducerID = 0; } model.IdentityCard = dt.Rows[n]["IdentityCard"].ToString(); if (dt.Rows[n]["Sex"].ToString() != "") { model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString()); } else { model.Sex = 0; } model.Sn = dt.Rows[n]["Sn"].ToString(); if (dt.Rows[n]["Province"].ToString() != "") { model.Province = int.Parse(dt.Rows[n]["Province"].ToString()); } else { model.Province = 0; } model.Address = dt.Rows[n]["Address"].ToString(); model.Phone = dt.Rows[n]["Phone"].ToString(); if (dt.Rows[n]["AccDate"].ToString() != "") { model.AccDate = DateTime.Parse(dt.Rows[n]["AccDate"].ToString()); } else { model.AccDate = DateTime.Parse("1900-1-1"); } model.WorkTypeID = dt.Rows[n]["WorkTypeID"].ToString(); if (dt.Rows[n]["PayID"].ToString() != "") { model.PayID = int.Parse(dt.Rows[n]["PayID"].ToString()); } else { model.PayID = 0; } if (dt.Rows[n]["DimDate"].ToString() != "") { model.DimDate = DateTime.Parse(dt.Rows[n]["DimDate"].ToString()); } else { model.DimDate = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["BedID"].ToString() != "") { model.BedID = int.Parse(dt.Rows[n]["BedID"].ToString()); } else { model.BedID = 0; } if (dt.Rows[n]["TableID"].ToString() != "") { model.TableID = int.Parse(dt.Rows[n]["TableID"].ToString()); } else { model.TableID = 0; } if (dt.Rows[n]["DepartmentID"].ToString() != "") { model.DepartmentID = int.Parse(dt.Rows[n]["DepartmentID"].ToString()); } else { model.DepartmentID = 0; } if (dt.Rows[n]["DegreeID"].ToString() != "") { model.DegreeID = int.Parse(dt.Rows[n]["DegreeID"].ToString()); } else { model.DegreeID = 0; } if (dt.Rows[n]["PolityID"].ToString() != "") { model.PolityID = int.Parse(dt.Rows[n]["PolityID"].ToString()); } else { model.PolityID = 0; } model.SOSPhone = dt.Rows[n]["SOSPhone"].ToString(); model.SOSMan = dt.Rows[n]["SOSMan"].ToString(); model.NowAddress = dt.Rows[n]["NowAddress"].ToString(); if (dt.Rows[n]["FillDate"].ToString() != "") { model.FillDate = DateTime.Parse(dt.Rows[n]["FillDate"].ToString()); } else { model.FillDate = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["FillUser"].ToString() != "") { model.FillUser = int.Parse(dt.Rows[n]["FillUser"].ToString()); } else { model.FillUser = 0; } if (dt.Rows[n]["LassMoney"].ToString() != "") { model.LassMoney = decimal.Parse(dt.Rows[n]["LassMoney"].ToString()); } else { model.LassMoney = 0; } if (dt.Rows[n]["Royalty"].ToString() != "") { model.Royalty = decimal.Parse(dt.Rows[n]["Royalty"].ToString()); } else { model.Royalty = 0; } model.Image = dt.Rows[n]["Image"].ToString(); if (dt.Rows[n]["IsUse"].ToString() != "") { if ((dt.Rows[n]["IsUse"].ToString() == "1") || (dt.Rows[n]["IsUse"].ToString().ToLower() == "true")) { model.IsUse = true; } else { model.IsUse = false; } } if (dt.Rows[n]["City"].ToString() != "") { model.City = int.Parse(dt.Rows[n]["City"].ToString()); } else { model.City = 0; } if (dt.Rows[n]["County"].ToString() != "") { model.County = int.Parse(dt.Rows[n]["County"].ToString()); } else { model.County = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["IDCardID"].ToString() != "") { model.IDCardID = Int64.Parse(dt.Rows[n]["IDCardID"].ToString()); } if (dt.Rows[n]["IsEnd"].ToString() != "") { model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString()); } else { model.IsEnd = 0; } if (dt.Rows[n]["Deposit"].ToString() != "") { model.Deposit = decimal.Parse(dt.Rows[n]["Deposit"].ToString()); } else { model.Deposit = 0; } if (dt.Rows[n]["NeedDeposit"].ToString() != "") { model.NeedDeposit = decimal.Parse(dt.Rows[n]["NeedDeposit"].ToString()); } else { model.NeedDeposit = 0; } model.DefaultWorkType = dt.Rows[n]["DefaultWorkType"].ToString(); if (dt.Rows[n]["BoardWages"] != null && dt.Rows[n]["BoardWages"].ToString() != "") { model.BoardWages = decimal.Parse(dt.Rows[n]["BoardWages"].ToString()); } if (dt.Rows[n]["HeTongDate"] != null && dt.Rows[n]["HeTongDate"].ToString() != "") { model.HeTongDate = DateTime.Parse(dt.Rows[n]["HeTongDate"].ToString()); } model.HeTongAmount = dt.Rows[n]["HeTongAmount"].ToString(); if (dt.Rows[n]["HeTongDQDate"] != null && dt.Rows[n]["HeTongDQDate"].ToString() != "") { model.HeTongDQDate = DateTime.Parse(dt.Rows[n]["HeTongDQDate"].ToString()); } if (dt.Rows[n]["IsCaicTiCheng"] != null && dt.Rows[n]["IsCaicTiCheng"].ToString() != "") { if ((dt.Rows[n]["IsCaicTiCheng"].ToString() == "1") || (dt.Rows[n]["IsCaicTiCheng"].ToString().ToLower() == "true")) { model.IsCaicTiCheng = true; } else { model.IsCaicTiCheng = false; } } if (dt.Rows[n]["MaxAmountDay"] != null && dt.Rows[n]["MaxAmountDay"].ToString() != "") { model.MaxAmountDay = int.Parse(dt.Rows[n]["MaxAmountDay"].ToString()); } model.BankNO = dt.Rows[n]["BankNO"].ToString(); model.BankAccountName = dt.Rows[n]["BankAccountName"].ToString(); model.BankName = dt.Rows[n]["BankName"].ToString(); model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }