public void SaveItem(bjf_account submitItem)
{
if (submitItem.id == 0)
{
submitItem.createid = Convert.ToInt32(SessionHelper.GetSession("userid"));
submitItem.updateid = Convert.ToInt32(SessionHelper.GetSession("userid"));
submitItem.createtime = DateTime.Now;
submitItem.updatetime = DateTime.Now;
submitItem.mobile = EncryAndDecryptHelper.Encryption(submitItem.mobile);
submitItem.dbpassword = EncryAndDecryptHelper.Encryption(submitItem.dbpassword);
submitItem.domainname = string.Format("{0}.login.cn", submitItem.domainname);
submitItem.state = (int)AccountState.未创建;
this.Add(submitItem);
}
else
{
var item = this.GetItem(submitItem.id);
item.name = submitItem.name;
item.mobile = EncryAndDecryptHelper.Encryption(submitItem.mobile);
item.domainshortname = submitItem.domainshortname;
item.domainname = string.Format("{0}.login.cn", submitItem.domainname);
item.dbname = submitItem.dbname;
item.dbserver = submitItem.dbserver;
item.dbuserid = submitItem.dbuserid;
item.dbpassword = EncryAndDecryptHelper.Encryption(submitItem.dbpassword);
item.comment = submitItem.comment;
item.updateid = Convert.ToInt32(SessionHelper.GetSession("userid"));
item.updatetime = DateTime.Now;
this.Update(item);
}
this.Save();
}
public void SaveItem(bjf_user submitItem)
{
if (submitItem.id == 0)
{
submitItem.createid = 1;
submitItem.updateid = 1;
submitItem.createtime = DateTime.Now;
submitItem.updatetime = DateTime.Now;
submitItem.openid = OpenHelper.CreateOpenId();
submitItem.password = EncryAndDecryptHelper.Encryption(submitItem.password);
submitItem.idcard = EncryAndDecryptHelper.Encryption(submitItem.idcard);
submitItem.mobile = EncryAndDecryptHelper.Encryption(submitItem.mobile);
this.Add(submitItem);
}
else
{
var item = this.GetItemById(submitItem.id);
item.loginname = submitItem.loginname;
item.username = submitItem.username;
item.password = EncryAndDecryptHelper.Encryption(submitItem.password);
item.idcard = EncryAndDecryptHelper.Encryption(submitItem.idcard);
item.email = submitItem.email;
item.mobile = EncryAndDecryptHelper.Encryption(submitItem.mobile);
item.comment = submitItem.password;
item.isadmin = submitItem.isadmin;
item.updateid = 1;
item.updatetime = DateTime.Now;
this.Update(item);
}
this.Save();
}
public JsonState CheckLogin(LoginQuery query)
{
var json = new JsonState();
if (Session["ValidateCode"] == null)
{
json.state = 1; json.msg = "验证码已过期，请重新输入";
}
if (Session["ValidateCode"] != null && Session["ValidateCode"].ToString().ToLower() != query.ValidCode.ToLower()) //验证码忽略大小写
{
json.state = 1; json.msg = "验证码错误";
}
var item = UserManager.GetInstance().GetItemByLoginName(query.LoginName);
if (item == null)
{
json.state = 1; json.msg = "此用户不存在";
}
if (query.PassWord != EncryAndDecryptHelper.Decryption(item.password))
{
json.state = 1; json.msg = "用户密码不对";
}
return(json);
}
public bjf_account GetByMobile(string mobile)
{
var param = EncryAndDecryptHelper.Encryption(mobile);
return(this.SelectOne(m => m.isdelete == false && m.mobile == param));
}
/// <summary>
/// 获取数据库连接字符串
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public string GetDbConnectionString(bjf_account item)
{
return(string.Format(
"server={0};database={1};user id={2};password={3};Convert Zero Datetime=True;Allow Zero Datetime=True;Connect Timeout=21600;", item.dbserver, item.dbname, item.dbuserid, EncryAndDecryptHelper.Decryption(item.dbpassword)));
}
public ActionResult Login(LoginQuery query)
{
try
{
if (Session["ValidateCode"] == null)
{
return(Json(new { state = 1, msg = "验证码已过期，请重新输入" }));
}
if (Session["ValidateCode"].ToString().ToLower() != query.ValidCode.ToLower()) //验证码忽略大小写
{
return(Json(new { state = 1, msg = "验证码错误" }));
}
//判断用户信息
var item = UserManager.GetInstance().GetItemByLoginName(query.LoginName);
if (item == null)
{
return(Json(new { state = 1, msg = "此用户不存在." }));
}
if (query.PassWord != EncryAndDecryptHelper.Decryption(item.password))
{
return(Json(new { state = 1, msg = "用户密码不对." }));
}
var roleList = UserForRoleManager.GetInstance().GetListRole(item.id);
if (roleList.Count == 0)
{
return(Json(new { state = 1, msg = "当前用户暂未分配角色，不能使用系统." }));
}
//用户全部角色集合
string arrRoleid = "";
roleList.ForEach(m => arrRoleid += m.roleid + ",");
//用户可查看菜单集合
var menulist = RoleForMenuManager.GetInstance().GetListMenuId(roleList);
string arrMenuid = "";
menulist.ForEach(m => arrMenuid += m.ToString() + ",");
//记住用户名和密码
if (query.Rember != null)
{
//放进cookie中
Response.Cookies.Add(new HttpCookie("cookieLoginname", query.LoginName));
Response.Cookies.Add(new HttpCookie("cookiePassword", query.PassWord));
Response.Cookies["cookieLoginname"].Expires = DateTime.Now.AddDays(3);
Response.Cookies["cookiePassword"].Expires = DateTime.Now.AddDays(3);
}
//验证通过将用户信息记录进session
SessionHelper.SetSession("userinfo", item);
SessionHelper.SetSession("userid", item.id);
SessionHelper.SetSession("username", item.username);
SessionHelper.SetSession("rolelist", arrRoleid); //角色集合
SessionHelper.SetSession("menulist", menulist); //菜单集合
SessionHelper.SetSessionTimeout(20);
//写登录日志
LoginLogManager.GetInstance().SaveItem();
return(Json(new { state = 0, msg = "登录成功." }));
}
catch (Exception e)
{
LogHelper.log.Error(e.Message);
return(Json(new { state = 1, msg = e.Message }));
}
}
