/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhangWei.Model.EUser model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhangWei.Model.EUser model) { return(dal.Update(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <ZhangWei.Model.EUser> DataTableToList(DataTable dt) { List <ZhangWei.Model.EUser> modelList = new List <ZhangWei.Model.EUser>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ZhangWei.Model.EUser model; for (int n = 0; n < rowsCount; n++) { model = new ZhangWei.Model.EUser(); if (dt.Rows[n]["UserId"] != null && dt.Rows[n]["UserId"].ToString() != "") { model.UserId = int.Parse(dt.Rows[n]["UserId"].ToString()); } if (dt.Rows[n]["UserName"] != null && dt.Rows[n]["UserName"].ToString() != "") { model.UserName = dt.Rows[n]["UserName"].ToString(); } if (dt.Rows[n]["PassWord"] != null && dt.Rows[n]["PassWord"].ToString() != "") { model.PassWord = dt.Rows[n]["PassWord"].ToString(); } if (dt.Rows[n]["Email"] != null && dt.Rows[n]["Email"].ToString() != "") { model.Email = dt.Rows[n]["Email"].ToString(); } if (dt.Rows[n]["Name"] != null && dt.Rows[n]["Name"].ToString() != "") { model.Name = dt.Rows[n]["Name"].ToString(); } if (dt.Rows[n]["Sex"] != null && dt.Rows[n]["Sex"].ToString() != "") { model.Sex = dt.Rows[n]["Sex"].ToString(); } if (dt.Rows[n]["Age"] != null && dt.Rows[n]["Age"].ToString() != "") { model.Age = int.Parse(dt.Rows[n]["Age"].ToString()); } if (dt.Rows[n]["ID_Card"] != null && dt.Rows[n]["ID_Card"].ToString() != "") { model.ID_Card = dt.Rows[n]["ID_Card"].ToString(); } if (dt.Rows[n]["Phone"] != null && dt.Rows[n]["Phone"].ToString() != "") { model.Phone = dt.Rows[n]["Phone"].ToString(); } if (dt.Rows[n]["MobilPhone"] != null && dt.Rows[n]["MobilPhone"].ToString() != "") { model.MobilPhone = dt.Rows[n]["MobilPhone"].ToString(); } if (dt.Rows[n]["Address"] != null && dt.Rows[n]["Address"].ToString() != "") { model.Address = dt.Rows[n]["Address"].ToString(); } if (dt.Rows[n]["Postalcode"] != null && dt.Rows[n]["Postalcode"].ToString() != "") { model.Postalcode = dt.Rows[n]["Postalcode"].ToString(); } if (dt.Rows[n]["Work"] != null && dt.Rows[n]["Work"].ToString() != "") { model.Work = dt.Rows[n]["Work"].ToString(); } if (dt.Rows[n]["Income"] != null && dt.Rows[n]["Income"].ToString() != "") { model.Income = decimal.Parse(dt.Rows[n]["Income"].ToString()); } if (dt.Rows[n]["Integral"] != null && dt.Rows[n]["Integral"].ToString() != "") { model.Integral = int.Parse(dt.Rows[n]["Integral"].ToString()); } if (dt.Rows[n]["CreateTime"] != null && dt.Rows[n]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[n]["CreateTime"].ToString()); } if (dt.Rows[n]["LaseLogin"] != null && dt.Rows[n]["LaseLogin"].ToString() != "") { model.LaseLogin = DateTime.Parse(dt.Rows[n]["LaseLogin"].ToString()); } modelList.Add(model); } } return(modelList); }