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));
}
