/// <summary> /// 获得数据列表 /// </summary> public List <Model.tb_user> DataTableToList(DataTable dt) { List <Model.tb_user> modelList = new List <Model.tb_user>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.tb_user model; for (int n = 0; n < rowsCount; n++) { model = new Model.tb_user(); if (dt.Rows[n]["u_id"] != null && dt.Rows[n]["u_id"].ToString() != "") { model.u_id = int.Parse(dt.Rows[n]["u_id"].ToString()); } if (dt.Rows[n]["u_log"] != null && dt.Rows[n]["u_log"].ToString() != "") { model.u_log = dt.Rows[n]["u_log"].ToString(); } if (dt.Rows[n]["u_pwd"] != null && dt.Rows[n]["u_pwd"].ToString() != "") { model.u_pwd = dt.Rows[n]["u_pwd"].ToString(); } if (dt.Rows[n]["u_no"] != null && dt.Rows[n]["u_no"].ToString() != "") { model.u_no = dt.Rows[n]["u_no"].ToString(); } if (dt.Rows[n]["u_name"] != null && dt.Rows[n]["u_name"].ToString() != "") { model.u_name = dt.Rows[n]["u_name"].ToString(); } if (dt.Rows[n]["u_tel"] != null && dt.Rows[n]["u_tel"].ToString() != "") { model.u_tel = dt.Rows[n]["u_tel"].ToString(); } if (dt.Rows[n]["u_email"] != null && dt.Rows[n]["u_email"].ToString() != "") { model.u_email = dt.Rows[n]["u_email"].ToString(); } if (dt.Rows[n]["u_type"] != null && dt.Rows[n]["u_type"].ToString() != "") { model.u_type = int.Parse(dt.Rows[n]["u_type"].ToString()); } if (dt.Rows[n]["u_sex"] != null && dt.Rows[n]["u_sex"].ToString() != "") { model.u_sex = dt.Rows[n]["u_sex"].ToString(); } if (dt.Rows[n]["u_address"] != null && dt.Rows[n]["u_address"].ToString() != "") { model.u_address = dt.Rows[n]["u_address"].ToString(); } if (dt.Rows[n]["u_adddate"] != null && dt.Rows[n]["u_adddate"].ToString() != "") { model.u_adddate = dt.Rows[n]["u_adddate"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.tb_user model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.tb_user model) { return(dal.Add(model)); }