/// <summary> /// 增加一条数据 /// </summary> public int Add(User model) { var id= dal.Add(model); if (id>0) { SetModelCache(id); } return id; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserInfo("); strSql.Append("UserName,ShowName,PassWord,Sex,PhoneNum,Email,Age,ImgUrl,IsEnable,CreateTime,UpdateTime)"); strSql.Append(" values ("); strSql.Append("@UserName,@ShowName,@PassWord,@Sex,@PhoneNum,@Email,@Age,@ImgUrl,@IsEnable,@CreateTime,@UpdateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar,100), new SqlParameter("@ShowName", SqlDbType.VarChar,100), new SqlParameter("@PassWord", SqlDbType.VarChar,20), new SqlParameter("@Sex", SqlDbType.Bit,1), new SqlParameter("@PhoneNum", SqlDbType.VarChar,20), new SqlParameter("@Email", SqlDbType.VarChar,50), new SqlParameter("@Age", SqlDbType.Int,4), new SqlParameter("@ImgUrl", SqlDbType.VarChar,-1), new SqlParameter("@IsEnable", SqlDbType.Bit,1), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime)}; parameters[0].Value = model.UserName; parameters[1].Value = model.ShowName; parameters[2].Value = model.PassWord; parameters[3].Value = model.Sex; parameters[4].Value = model.PhoneNum; parameters[5].Value = model.Email; parameters[6].Value = model.Age; parameters[7].Value = model.ImgUrl; parameters[8].Value = model.IsEnable; parameters[9].Value = model.CreateTime; parameters[10].Value = model.UpdateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public string RegistIn(FormCollection collection) { var userName = collection.Get("username"); var password = collection.Get("password"); var email = collection.Get("email"); var phone = collection.Get("phone"); if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password)) { return HttpRequestResult.StateNotNull; } var user = new User { UserName = userName, PassWord = password, Email = email, PhoneNum = phone, IsEnable = true, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; if (_userBll.Exists(user.UserName)) { return HttpRequestResult.StateExisted; } var flag = _userBll.Add(user); if (flag > 0) { return HttpRequestResult.StateOk; } return HttpRequestResult.StateError; }
/// <summary> /// 得到一个对象实体 /// </summary> public User DataRowToModel(DataRow row) { User model = new User(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["ShowName"] != null) { model.ShowName = row["ShowName"].ToString(); } if (row["PassWord"] != null) { model.PassWord = row["PassWord"].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["PhoneNum"] != null) { model.PhoneNum = row["PhoneNum"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["Age"] != null && row["Age"].ToString() != "") { model.Age = int.Parse(row["Age"].ToString()); } if (row["ImgUrl"] != null) { model.ImgUrl = row["ImgUrl"].ToString(); } if (row["IsEnable"] != null && row["IsEnable"].ToString() != "") { if ((row["IsEnable"].ToString() == "1") || (row["IsEnable"].ToString().ToLower() == "true")) { model.IsEnable = true; } else { model.IsEnable = false; } } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } } return model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("UserName=@UserName,"); strSql.Append("ShowName=@ShowName,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("Sex=@Sex,"); strSql.Append("PhoneNum=@PhoneNum,"); strSql.Append("Email=@Email,"); strSql.Append("Age=@Age,"); strSql.Append("ImgUrl=@ImgUrl,"); strSql.Append("IsEnable=@IsEnable,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("UpdateTime=@UpdateTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar,100), new SqlParameter("@ShowName", SqlDbType.VarChar,100), new SqlParameter("@PassWord", SqlDbType.VarChar,20), new SqlParameter("@Sex", SqlDbType.Bit,1), new SqlParameter("@PhoneNum", SqlDbType.VarChar,20), new SqlParameter("@Email", SqlDbType.VarChar,50), new SqlParameter("@Age", SqlDbType.Int,4), new SqlParameter("@ImgUrl", SqlDbType.VarChar,-1), new SqlParameter("@IsEnable", SqlDbType.Bit,1), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = model.UserName; parameters[1].Value = model.ShowName; parameters[2].Value = model.PassWord; parameters[3].Value = model.Sex; parameters[4].Value = model.PhoneNum; parameters[5].Value = model.Email; parameters[6].Value = model.Age; parameters[7].Value = model.ImgUrl; parameters[8].Value = model.IsEnable; parameters[9].Value = model.CreateTime; parameters[10].Value = model.UpdateTime; parameters[11].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
public bool SetUserDetail(User user) { var strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("ShowName=@ShowName,"); strSql.Append("Sex=@Sex,"); strSql.Append("PhoneNum=@PhoneNum,"); strSql.Append("Email=@Email,"); strSql.Append("Age=@Age,"); strSql.Append("UpdateTime=@UpdateTime"); strSql.Append(" where Id=@Id"); SqlParameter[] para = { new SqlParameter("@ShowName",SqlDbType.VarChar){Value = user.ShowName}, new SqlParameter("@Sex",SqlDbType.Bit){Value = user.Sex}, new SqlParameter("@PhoneNum",SqlDbType.VarChar){Value = user.PhoneNum}, new SqlParameter("@Email",SqlDbType.VarChar){Value = user.Email}, new SqlParameter("@Age",SqlDbType.Int){Value = user.Age}, new SqlParameter("@UpdateTime",SqlDbType.DateTime){Value = DateTime.Now}, new SqlParameter("@Id",SqlDbType.Int){Value = user.Id} }; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para); return rows > 0; }
/// <summary> /// 得到一个对象实体 /// </summary> public User GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserName,ShowName,PassWord,Sex,PhoneNum,Email,Age,ImgUrl,IsEnable,CreateTime,UpdateTime from UserInfo "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; User model = new 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 bool Update(User model) { var flag= dal.Update(model); if (true) { SetModelCache(model.Id); } return flag; }
public bool SetUserDetail(User user) { var flag = dal.SetUserDetail(user); if (flag) { SetModelCache(user.Id); } return flag; }
public string Regist(string userName, string passWord) { if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(passWord)) { return "用户名不能为空"; } var exist = _userBll.Exists(userName); if (exist) { return "用户名已存在"; } var model = new User { UserName = userName, PassWord = passWord, IsEnable = true, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; var result = _userBll.Add(model); if (result>0) { Session.Add("user",model); return HttpRequestResult.StateOk; } return HttpRequestResult.StateError; }
public string SetUserDetail(FormCollection collection) { var userId = collection.Get("userid"); var showName = collection.Get("showname"); var email = collection.Get("email"); var phone = collection.Get("phone"); var sex = collection.Get("sex"); var user = new User() { Id = Int32.Parse(userId), ShowName = showName, Email = email, PhoneNum = phone, Sex = Int32.Parse(sex) > 0, UpdateTime = DateTime.Now }; var flag = _userBll.SetUserDetail(user); if (flag) { return HttpRequestResult.StateOk; } else { return HttpRequestResult.StateError; } }