/// <summary> /// 更新一条数据 /// </summary> public bool Update(ML.Model.S_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update S_User set "); strSql.Append("LoginPwd=@LoginPwd,"); strSql.Append("NickName=@NickName,"); strSql.Append("Sex=@Sex,"); strSql.Append("Birthday=@Birthday,"); strSql.Append("PlaceBirth=@PlaceBirth,"); strSql.Append("PhoneNumber=@PhoneNumber,"); strSql.Append("IsEnabled=@IsEnabled,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("CreateUser=@CreateUser,"); strSql.Append("UpdateDate=@UpdateDate,"); strSql.Append("UpdateUser=@UpdateUser"); strSql.Append(" where LoginName=@LoginName "); SqlParameter[] parameters = { new SqlParameter("@LoginPwd", SqlDbType.VarChar, 100), new SqlParameter("@NickName", SqlDbType.NVarChar, 10), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Birthday", SqlDbType.Date, 3), new SqlParameter("@PlaceBirth", SqlDbType.NVarChar, 50), new SqlParameter("@PhoneNumber", SqlDbType.Char, 11), new SqlParameter("@IsEnabled", SqlDbType.Bit, 1), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.VarChar, 20), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.VarChar, 20), new SqlParameter("@LoginName", SqlDbType.VarChar, 20) }; parameters[0].Value = model.LoginPwd; parameters[1].Value = model.NickName; parameters[2].Value = model.Sex; parameters[3].Value = model.Birthday; parameters[4].Value = model.PlaceBirth; parameters[5].Value = model.PhoneNumber; parameters[6].Value = model.IsEnabled; parameters[7].Value = model.CreateDate; parameters[8].Value = model.CreateUser; parameters[9].Value = model.UpdateDate; parameters[10].Value = model.UpdateUser; parameters[11].Value = model.LoginName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ML.Model.S_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into S_User("); strSql.Append("LoginName,LoginPwd,NickName,Sex,Birthday,PlaceBirth,PhoneNumber,IsEnabled,CreateDate,CreateUser,UpdateDate,UpdateUser)"); strSql.Append(" values ("); strSql.Append("@LoginName,@LoginPwd,@NickName,@Sex,@Birthday,@PlaceBirth,@PhoneNumber,@IsEnabled,@CreateDate,@CreateUser,@UpdateDate,@UpdateUser)"); SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.VarChar, 20), new SqlParameter("@LoginPwd", SqlDbType.VarChar, 100), new SqlParameter("@NickName", SqlDbType.NVarChar, 10), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Birthday", SqlDbType.Date, 3), new SqlParameter("@PlaceBirth", SqlDbType.NVarChar, 50), new SqlParameter("@PhoneNumber", SqlDbType.Char, 11), new SqlParameter("@IsEnabled", SqlDbType.Bit, 1), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.VarChar, 20), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.VarChar, 20) }; parameters[0].Value = model.LoginName; parameters[1].Value = model.LoginPwd; parameters[2].Value = model.NickName; parameters[3].Value = model.Sex; parameters[4].Value = model.Birthday; parameters[5].Value = model.PlaceBirth; parameters[6].Value = model.PhoneNumber; parameters[7].Value = model.IsEnabled; parameters[8].Value = model.CreateDate; parameters[9].Value = model.CreateUser; parameters[10].Value = model.UpdateDate; parameters[11].Value = model.UpdateUser; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ML.Model.S_User GetModel(string LoginName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LoginName,LoginPwd,NickName,Sex,Birthday,PlaceBirth,PhoneNumber,IsEnabled,CreateDate,CreateUser,UpdateDate,UpdateUser from S_User "); strSql.Append(" where LoginName=@LoginName "); SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.VarChar, 20) }; parameters[0].Value = LoginName; ML.Model.S_User model = new ML.Model.S_User(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ML.Model.S_User DataRowToModel(DataRow row) { ML.Model.S_User model = new ML.Model.S_User(); if (row != null) { if (row["LoginName"] != null) { model.LoginName = row["LoginName"].ToString(); } if (row["LoginPwd"] != null) { model.LoginPwd = row["LoginPwd"].ToString(); } if (row["NickName"] != null) { model.NickName = row["NickName"].ToString(); } if (row["Sex"] != null && row["Sex"].ToString() != "") { if ((row["Sex"].ToString() == "1") || (row["Sex"].ToString().ToLower() == "true")) { model.Sex = true; } else { model.Sex = false; } } if (row["Birthday"] != null && row["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(row["Birthday"].ToString()); } if (row["PlaceBirth"] != null) { model.PlaceBirth = row["PlaceBirth"].ToString(); } if (row["PhoneNumber"] != null) { model.PhoneNumber = row["PhoneNumber"].ToString(); } if (row["IsEnabled"] != null && row["IsEnabled"].ToString() != "") { if ((row["IsEnabled"].ToString() == "1") || (row["IsEnabled"].ToString().ToLower() == "true")) { model.IsEnabled = true; } else { model.IsEnabled = false; } } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["CreateUser"] != null) { model.CreateUser = row["CreateUser"].ToString(); } if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "") { model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString()); } if (row["UpdateUser"] != null) { model.UpdateUser = row["UpdateUser"].ToString(); } } return(model); }