public void UserInfoUpdate(FormCollection form) { Web.Models.UserCenter.UserInfoUpdateModel viewModel = new Models.UserCenter.UserInfoUpdateModel(); viewModel.UserName = form["txtUserName"] ?? ""; viewModel.Email = form["txtEmail"] ?? ""; viewModel.Pwd = form["txtPwd"] ?? ""; ValidateModel(viewModel); XCLShouCang.BLL.v_UserInfo vBLL = new XCLShouCang.BLL.v_UserInfo(); XCLShouCang.BLL.UserInfo bll = new XCLShouCang.BLL.UserInfo(); XCLShouCang.Model.UserInfo model = bll.GetModel(base.CurrentUserModel.UserID); model.Email = viewModel.Email; model.UserName = viewModel.UserName; if (!string.Equals(viewModel.UserName, base.CurrentUserModel.UserName, StringComparison.CurrentCultureIgnoreCase) && bll.IsExists(viewModel.UserName)) { XCLNetTools.Message.Log.WriteMessage("该用户名已被占用,修改失败!"); return; } if (!string.IsNullOrEmpty(viewModel.Pwd)) { model.Pwd = XCLNetTools.StringHander.StringUtil.str_md5(viewModel.Pwd); } model.UpdateName = base.CurrentUserModel.UserName; model.UpdateTime = DateTime.Now; if (bll.Update(model)) { base.SetLogInfo(1, model); XCLNetTools.Message.Log.WriteMessage("修改成功!"); } else { XCLNetTools.Message.Log.WriteMessage("修改失败,请重试!"); } }
/// <summary> /// 增加一条数据 /// </summary> public long AddUserInfo(XCLShouCang.Model.UserInfo model) { SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@Pwd", SqlDbType.VarChar, 50), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Birthday", SqlDbType.SmallDateTime), new SqlParameter("@Tel", SqlDbType.VarChar, 50), new SqlParameter("@QQ", SqlDbType.BigInt, 8), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@OtherContactWay", SqlDbType.VarChar, 500), new SqlParameter("@ThirdLoginType", SqlDbType.VarChar, 50), new SqlParameter("@ThirdLoginToken", SqlDbType.VarChar, 50), new SqlParameter("@CreatorName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateName", SqlDbType.VarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.TinyInt, 1), new SqlParameter("@ResultCode", SqlDbType.Int, 4), new SqlParameter("@ResultMessage", SqlDbType.NVarChar, 1000), }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.UserName; parameters[2].Value = model.NickName; parameters[3].Value = model.RealName; parameters[4].Value = model.Pwd; parameters[5].Value = model.Age; parameters[6].Value = model.Birthday; parameters[7].Value = model.Tel; parameters[8].Value = model.QQ; parameters[9].Value = model.Email; parameters[10].Value = model.OtherContactWay; parameters[11].Value = model.ThirdLoginType; parameters[12].Value = model.ThirdLoginToken; parameters[13].Value = model.CreatorName; parameters[14].Value = model.CreateTime; parameters[15].Value = model.UpdateName; parameters[16].Value = model.UpdateTime; parameters[17].Value = model.IsDel; parameters[18].Direction = ParameterDirection.Output; parameters[19].Direction = ParameterDirection.Output; DbHelperSQL.RunProcedure("proc_UserInfo_ADD", parameters, "ds"); long userID = XCLNetTools.StringHander.Common.GetInt(parameters[0].Value); if (userID > 0) { return(userID); } else { throw new Exception(Convert.ToString(parameters[19].Value)); } }
public void LogOnSubmit(FormCollection form) { try { XCLShouCang.BLL.UserInfo bll = new XCLShouCang.BLL.UserInfo(); XCLShouCang.Model.UserInfo model = new XCLShouCang.Model.UserInfo(); Models.Login.LogOnModel viewModel = new Models.Login.LogOnModel(); viewModel.UserName = (form["txtUserName"] ?? "").Trim(); viewModel.Pwd = form["txtPwd"]; ValidateModel(viewModel); if (bll.IsExists(viewModel.UserName, XCLNetTools.StringHander.StringUtil.str_md5(viewModel.Pwd))) { var userInfo = bll.GetModel(viewModel.UserName); base.SetLogInfo(1, userInfo); XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel() { IsRefresh = true, IsSuccess = true, Message = "登录成功!" }; XCLNetTools.Message.Log.WriteMessage(msgModel); } else { XCLNetTools.Message.Log.WriteMessage("用户名或密码错误!"); } } catch { XCLNetTools.Message.Log.WriteMessage("登录失败,请重试!"); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(XCLShouCang.Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserInfo("); strSql.Append("UserName,NickName,RealName,Pwd,Age,Birthday,Tel,QQ,Email,OtherContactWay,ThirdLoginType,ThirdLoginToken,CreatorName,CreateTime,UpdateName,UpdateTime,IsDel)"); strSql.Append(" values ("); strSql.Append("@UserName,@NickName,@RealName,@Pwd,@Age,@Birthday,@Tel,@QQ,@Email,@OtherContactWay,@ThirdLoginType,@ThirdLoginToken,@CreatorName,@CreateTime,@UpdateName,@UpdateTime,@IsDel)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@Pwd", SqlDbType.VarChar, 50), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Birthday", SqlDbType.SmallDateTime), new SqlParameter("@Tel", SqlDbType.VarChar, 50), new SqlParameter("@QQ", SqlDbType.BigInt, 8), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@OtherContactWay", SqlDbType.VarChar, 500), new SqlParameter("@ThirdLoginType", SqlDbType.VarChar, 50), new SqlParameter("@ThirdLoginToken", SqlDbType.VarChar, 50), new SqlParameter("@CreatorName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateName", SqlDbType.VarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.UserName; parameters[1].Value = model.NickName; parameters[2].Value = model.RealName; parameters[3].Value = model.Pwd; parameters[4].Value = model.Age; parameters[5].Value = model.Birthday; parameters[6].Value = model.Tel; parameters[7].Value = model.QQ; parameters[8].Value = model.Email; parameters[9].Value = model.OtherContactWay; parameters[10].Value = model.ThirdLoginType; parameters[11].Value = model.ThirdLoginToken; parameters[12].Value = model.CreatorName; parameters[13].Value = model.CreateTime; parameters[14].Value = model.UpdateName; parameters[15].Value = model.UpdateTime; parameters[16].Value = model.IsDel; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
public XCLShouCang.Model.UserInfo GetModelByThirdLogin(string thirdLoginType, string thirdLoginToken) { XCLShouCang.Model.UserInfo model = null; DataTable dt = dal.GetModelByThirdLogin(thirdLoginType, thirdLoginToken); if (null != dt && dt.Rows.Count > 0) { model = dal.DataRowToModel(dt.Rows[0]); } return(model); }
public XCLShouCang.Model.UserInfo GetModel(string userName) { XCLShouCang.Model.UserInfo model = null; DataTable dt = dal.GetModelByUserName(userName); if (null != dt && dt.Rows.Count > 0) { model = dal.DataRowToModel(dt.Rows[0]); } return(model); }
/// <summary> /// 设置登录与退出的相关信息(session/cookie...) /// </summary> /// <param name="type">0:退出/1:登录</param> public void SetLogInfo(int type, XCLShouCang.Model.UserInfo userInfo) { switch (type) { //退出 case 0: XCLNetTools.StringHander.Common.DelCookies(BaseController.UserLoginCookieName); Session.Remove(BaseController.CurrentUserModelSessionName); Session.Remove(BaseController.UserLoginCookieName); break; //登录 case 1: this.CurrentUserModel = userInfo; string loginStr = XCLNetTools.StringHander.DESEncrypt.Encrypt(string.Format("{0}|{1}", this.CurrentUserModel.UserName, this.CurrentUserModel.Pwd)); XCLNetTools.StringHander.Common.SetCookies(BaseController.UserLoginCookieName, loginStr, 30); Session[BaseController.UserLoginCookieName] = loginStr; break; } }
/// <summary> /// 每个action之前登录操作 /// </summary> private void LogOn() { //先判断在session中存不存在,若不存在,则重新使用cookie进行登录。 XCLShouCang.Model.UserInfo tempUserModel = Session[BaseController.CurrentUserModelSessionName] as XCLShouCang.Model.UserInfo; if (null != tempUserModel) { return; } string userInfoCookie = XCLNetTools.StringHander.Common.GetCookies(BaseController.UserLoginCookieName); userInfoCookie = string.IsNullOrEmpty(userInfoCookie) ? Convert.ToString(Session[BaseController.UserLoginCookieName]) : userInfoCookie; if (!string.IsNullOrEmpty(userInfoCookie)) { string userInfo = ""; try { userInfo = XCLNetTools.StringHander.DESEncrypt.Decrypt(userInfoCookie); if (!string.IsNullOrEmpty(userInfo)) { string[] userArr = userInfo.Split('|'); if (null != userArr && userArr.Length == 2) { XCLShouCang.BLL.UserInfo bll = new XCLShouCang.BLL.UserInfo(); Web.Models.Login.LogOnModel logOnModel = new Models.Login.LogOnModel(); logOnModel.UserName = userArr[0]; logOnModel.Pwd = userArr[1]; if (bll.IsExists(logOnModel.UserName, logOnModel.Pwd)) { this.CurrentUserModel = bll.GetModel(logOnModel.UserName); } } } } catch (Exception ex) { throw ex; } } }
public void RegisterSubmit(FormCollection form) { XCLShouCang.BLL.UserInfo bll = new XCLShouCang.BLL.UserInfo(); XCLShouCang.Model.UserInfo model = new XCLShouCang.Model.UserInfo(); Models.Login.RegisterModel viewModel = new Models.Login.RegisterModel(); viewModel.UserName = (form["txtUserName"] ?? "").Trim(); viewModel.Pwd = form["txtPwd"] ?? ""; viewModel.ConfirmPwd = form["txtConfirmPwd"]; viewModel.Email = (form["txtEmail"] ?? "").Trim(); ValidateModel(viewModel); model.UserName = viewModel.UserName; model.Email = viewModel.Email; model.Pwd = XCLNetTools.StringHander.StringUtil.str_md5(viewModel.Pwd); if (bll.AddUserInfo(model) > 0) { XCLNetTools.Message.Log.WriteMessage(string.Format(@"恭喜您,注册成功!<a href=""{0}"">【马上登录】</a>", Url.Action("Index", "Login"))); } else { XCLNetTools.Message.Log.WriteMessage("注册失败,请重试!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.UserInfo GetModel(long UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserID,UserName,NickName,RealName,Pwd,Age,Birthday,Tel,QQ,Email,OtherContactWay,ThirdLoginType,ThirdLoginToken,CreatorName,CreateTime,UpdateName,UpdateTime,IsDel from UserInfo "); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt) }; parameters[0].Value = UserID; XCLShouCang.Model.UserInfo model = new XCLShouCang.Model.UserInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public ActionResult LoginByThird() { string thirdLoginType = XCLNetTools.StringHander.FormHelper.GetString("ThirdLoginType"); string thirdLoginToken = XCLNetTools.StringHander.FormHelper.GetString("ThirdLoginToken"); string nickName = XCLNetTools.StringHander.FormHelper.GetString("NickName"); XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel(); if (!string.IsNullOrEmpty(thirdLoginType) && !string.IsNullOrEmpty(thirdLoginToken)) { XCLShouCang.BLL.UserInfo bll = new XCLShouCang.BLL.UserInfo(); XCLShouCang.Model.UserInfo uModel = null; if (bll.IsExistsThirdLogin(thirdLoginType, thirdLoginToken)) { //使用该账号 uModel = bll.GetModelByThirdLogin(thirdLoginType, thirdLoginToken); base.SetLogInfo(1, uModel); msgModel.IsSuccess = true; } else { //系统自动创建新账号 uModel = new XCLShouCang.Model.UserInfo(); uModel.UserName = XCLNetTools.StringHander.RandomHelper.GenerateStringId(); uModel.NickName = nickName; uModel.ThirdLoginToken = thirdLoginToken; uModel.ThirdLoginType = thirdLoginType; long resultID = bll.AddUserInfo(uModel); if (resultID > 0) { base.SetLogInfo(1, bll.GetModel(resultID)); msgModel.IsSuccess = true; } } } return(Json(msgModel)); }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.UserInfo DataRowToModel(DataRow row) { XCLShouCang.Model.UserInfo model = new XCLShouCang.Model.UserInfo(); if (row != null) { if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = long.Parse(row["UserID"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["NickName"] != null) { model.NickName = row["NickName"].ToString(); } if (row["RealName"] != null) { model.RealName = row["RealName"].ToString(); } if (row["Pwd"] != null) { model.Pwd = row["Pwd"].ToString(); } if (row["Age"] != null && row["Age"].ToString() != "") { model.Age = int.Parse(row["Age"].ToString()); } if (row["Birthday"] != null && row["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(row["Birthday"].ToString()); } if (row["Tel"] != null) { model.Tel = row["Tel"].ToString(); } if (row["QQ"] != null && row["QQ"].ToString() != "") { model.QQ = long.Parse(row["QQ"].ToString()); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["OtherContactWay"] != null) { model.OtherContactWay = row["OtherContactWay"].ToString(); } if (row["ThirdLoginType"] != null) { model.ThirdLoginType = row["ThirdLoginType"].ToString(); } if (row["ThirdLoginToken"] != null) { model.ThirdLoginToken = row["ThirdLoginToken"].ToString(); } if (row["CreatorName"] != null) { model.CreatorName = row["CreatorName"].ToString(); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["UpdateName"] != null) { model.UpdateName = row["UpdateName"].ToString(); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } if (row["IsDel"] != null && row["IsDel"].ToString() != "") { model.IsDel = int.Parse(row["IsDel"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLShouCang.Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("UserName=@UserName,"); strSql.Append("NickName=@NickName,"); strSql.Append("RealName=@RealName,"); strSql.Append("Pwd=@Pwd,"); strSql.Append("Age=@Age,"); strSql.Append("Birthday=@Birthday,"); strSql.Append("Tel=@Tel,"); strSql.Append("QQ=@QQ,"); strSql.Append("Email=@Email,"); strSql.Append("OtherContactWay=@OtherContactWay,"); strSql.Append("ThirdLoginType=@ThirdLoginType,"); strSql.Append("ThirdLoginToken=@ThirdLoginToken,"); strSql.Append("CreatorName=@CreatorName,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("UpdateName=@UpdateName,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("IsDel=@IsDel"); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@Pwd", SqlDbType.VarChar, 50), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Birthday", SqlDbType.SmallDateTime), new SqlParameter("@Tel", SqlDbType.VarChar, 50), new SqlParameter("@QQ", SqlDbType.BigInt, 8), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@OtherContactWay", SqlDbType.VarChar, 500), new SqlParameter("@ThirdLoginType", SqlDbType.VarChar, 50), new SqlParameter("@ThirdLoginToken", SqlDbType.VarChar, 50), new SqlParameter("@CreatorName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateName", SqlDbType.VarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.TinyInt, 1), new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@UserName", SqlDbType.VarChar, 50) }; parameters[0].Value = model.NickName; parameters[1].Value = model.RealName; parameters[2].Value = model.Pwd; parameters[3].Value = model.Age; parameters[4].Value = model.Birthday; parameters[5].Value = model.Tel; parameters[6].Value = model.QQ; parameters[7].Value = model.Email; parameters[8].Value = model.OtherContactWay; parameters[9].Value = model.ThirdLoginType; parameters[10].Value = model.ThirdLoginToken; parameters[11].Value = model.CreatorName; parameters[12].Value = model.CreateTime; parameters[13].Value = model.UpdateName; parameters[14].Value = model.UpdateTime; parameters[15].Value = model.IsDel; parameters[16].Value = model.UserID; parameters[17].Value = model.UserName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLShouCang.Model.UserInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(XCLShouCang.Model.UserInfo model) { return(dal.Add(model)); }