/// <summary> /// 增加一条数据 /// </summary> public bool Add(Class_SQL.Model.Sys_UserReister model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.UserID != null) { strSql1.Append("UserID,"); strSql2.Append("'" + model.UserID + "',"); } if (model.UserName != null) { strSql1.Append("UserName,"); strSql2.Append("'" + model.UserName + "',"); } if (model.UserPassword != null) { strSql1.Append("UserPassword,"); strSql2.Append("'" + model.UserPassword + "',"); } if (model.PhoneNumber != null) { strSql1.Append("PhoneNumber,"); strSql2.Append("'" + model.PhoneNumber + "',"); } if (model.UserType != null) { strSql1.Append("UserType,"); strSql2.Append("'" + model.UserType + "',"); } if (model.BirthDate != null) { strSql1.Append("BirthDate,"); strSql2.Append("'" + model.BirthDate + "',"); } if (model.UserAddress != null) { strSql1.Append("UserAddress,"); strSql2.Append("'" + model.UserAddress + "',"); } strSql.Append("insert into Sys_UserReister("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Class_SQL.Model.Sys_UserReister model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_UserReister set "); if (model.UserName != null) { strSql.Append("UserName='******',"); } if (model.UserPassword != null) { strSql.Append("UserPassword='******',"); } if (model.PhoneNumber != null) { strSql.Append("PhoneNumber='" + model.PhoneNumber + "',"); } if (model.UserType != null) { strSql.Append("UserType='" + model.UserType + "',"); } if (model.BirthDate != null) { strSql.Append("BirthDate='" + model.BirthDate + "',"); } if (model.UserAddress != null) { strSql.Append("UserAddress='" + model.UserAddress + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where UserID='" + model.UserID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Class_SQL.Model.Sys_UserReister GetModel(string UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" UserID,UserName,UserPassword,PhoneNumber,UserType,BirthDate,UserAddress "); strSql.Append(" from Sys_UserReister "); strSql.Append(" where UserID='" + UserID + "' "); Class_SQL.Model.Sys_UserReister model = new Class_SQL.Model.Sys_UserReister(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Class_SQL.Model.Sys_UserReister DataRowToModel(DataRow row) { Class_SQL.Model.Sys_UserReister model = new Class_SQL.Model.Sys_UserReister(); if (row != null) { if (row["UserID"] != null) { model.UserID = row["UserID"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["UserPassword"] != null) { model.UserPassword = row["UserPassword"].ToString(); } if (row["PhoneNumber"] != null) { model.PhoneNumber = row["PhoneNumber"].ToString(); } if (row["UserType"] != null) { model.UserType = row["UserType"].ToString(); } if (row["BirthDate"] != null && row["BirthDate"].ToString() != "") { model.BirthDate = DateTime.Parse(row["BirthDate"].ToString()); } if (row["UserAddress"] != null) { model.UserAddress = row["UserAddress"].ToString(); } } return(model); }