// POST: /Login/
public JsonResult Login(JObject data)
{
string UserCode = data.Value <string>("user_code");
string Password = data.Value <string>("password");
string IP = data.Value <string>("ip");
string City = data.Value <string>("city");
data["user_code"] = UserCode;
data["password"] = Md5Util.MD5(Password);
data["LoginIP"] = IP;
data["LoginCity"] = City;
AppConnectionString = ConfigurationManager.ConnectionStrings["app"].ConnectionString;
DataSet dt = base.RunProcedureDataSet(data, "vdp_sys_Login", "app");
//if (dt.Rows.Count > 0)
var ResultID = dt.Tables[0].Rows[0]["result_id"];
var ResultMsg = (string)dt.Tables[0].Rows[0]["result_msg"];
//var loginResult = Base_UserService.Instance.Login(UserCode, Md5Util.MD5(Password), IP, City);
if (ResultID.ToString() == "0")
{
Base_User b = new Base_User();
b.city = "";// (string)dt.Rows[0]["city"];
b.RealName = (string)dt.Tables[1].Rows[0]["real_name"];
b.DepartmentID = (int)dt.Tables[1].Rows[0]["department_id"];
b.UserId = (int)dt.Tables[1].Rows[0]["id"];
b.UserCode = (String)dt.Tables[1].Rows[0]["user_code"];
b.RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"];
b.DepartmentCode = ((int)dt.Tables[1].Rows[0]["department_id"]).ToString();
var loginer = new BaseLoginer
{
UserId = (int)dt.Tables[1].Rows[0]["id"], //. user.UserId,
UserCode = (string)dt.Tables[1].Rows[0]["user_code"], // user.UserCode,
// Password = (string)dt.Tables[1].Rows[0]["Password"],// user.Password,
UserName = (string)dt.Tables[1].Rows[0]["real_name"], // user.RealName,
RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"],
// DepartmentCode =((int)dt.Tables[1].Rows[0]["DepartmentID"]).ToString(),
Data = b,
IsAdmin = false
};
Session["logininfo"] = "";
//set timeout
var effectiveHours = Convert.ToInt32(60 * ConfigUtil.GetConfigDecimal("LoginEffectiveHours"));
//执行web登录
FormsAuth.SignIn(loginer.UserId.ToString(), loginer, effectiveHours);
}
else
{
LogHelper.Write("Login Failed！Account：" + UserCode + "，password：" + Password + "。reason：" + ResultMsg);
}
return(Json(new { s = ResultID, message = ResultMsg }, JsonRequestBehavior.DenyGet));
}
//修改自己密码
//POST /Home/ModifySelfPassword
public JsonResult ModifySelfPassword(JObject data)
{
string UserCode = CurrentUser.UserCode;
string Password = data.Value <string>("newpassword");
data["UserCode"] = UserCode;
data["Password"] = Md5Util.MD5(Password);
base.RunProcedureByName(data, "vdp_reset_pwd", "app");
return(Json(new { s = true, message = GetSysText("success") }, JsonRequestBehavior.DenyGet));
}
public JsonResult ResetPasswrod(JObject data)
{
string Password = data.Value <string>("pwd");
data["pwd"] = Md5Util.MD5(Password);
data["add_by"] = CurrentUser.UserId;
base.RunProcedureByName(data, "vdp_reset_password", "app");
return(Json(new { s = true, message = GetSysText("success") }, JsonRequestBehavior.DenyGet));
}
//动作：添加记录
// POST: /Sys/Base_User/Add
public JsonResult Add(JObject data)
{
var entity = data.ToObject <Base_User>();
entity.Password = Md5Util.MD5(entity.UserCode);//新增用户，密码默认和登录账号一样
int result = Base_UserService.Instance.Insert(entity);
CommandResult cmdResult = result > 0 ? CommandResult.Instance_Succeed : CommandResult.Instance_Error;
cmdResult.ResultMsg = "保存成功！";
return(JsonNet(cmdResult, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 修改自己的密码
/// </summary>
/// <param name="newPassword">新密码，未加密</param>
/// <returns>返回CommandResult</returns>
public CommandResult ModifySelfPassword(string newPassword, int userid)
{
CommandResult commandResult = new CommandResult();
var paramUpdate = ParamUpdate.Instance().Update("Base_User")
.Column("Password", Md5Util.MD5(newPassword))
.AndWhere("UserId", userid);
int n = this.Update(paramUpdate);
commandResult.ResultID = n > 0 ? 0 : -1;
commandResult.ResultMsg = n > 0 ? "密码修改成功" : "密码修改失败";
LogHelper.Write("修改个人密码。用户：" + this.CurrentBaseLoginer.UserName + "。结果：" + commandResult.ResultMsg);
return(commandResult);
}
// POST: /Login/
public JsonResult Login(JObject data)
{
string UserCode = data.Value <string>("usercode");
string Password = data.Value <string>("pwd");
string IP = data.Value <string>("ip");
string City = data.Value <string>("city");
var loginResult = Base_UserService.Instance.Login(UserCode, Md5Util.MD5(Password), IP, City);
if (loginResult.Succeed)
{
//登录成功后，查询当前用户数据
var user = Base_UserService.Instance.GetEntity(ParamQuery.Instance()
.AndWhere("UserCode", UserCode).AndWhere("Password", Md5Util.MD5(Password))
.AndWhere("Enabled", 1).AndWhere("IsAudit", 1));
//调用框架中的登录机制
var loginer = new BaseLoginer
{
UserId = user.UserId,
UserCode = user.UserCode,
Password = user.Password,
UserName = user.RealName,
Data = user,
IsAdmin = user.UserType == 1 //根据用户UserType判断。用户类型：0=未定义 1=超级管理员 2=普通用户 3=其他
};
//读取配置登录默认失效时长：小时
var effectiveHours = Convert.ToInt32(60 * ConfigUtil.GetConfigDecimal("LoginEffectiveHours"));
// 无限光年网络科技
//执行web登录
FormsAuth.SignIn(loginer.UserId.ToString(), loginer, effectiveHours);
LogHelper.Write("登录成功！用户：" + loginer.UserName + "，账号：" + UserCode + "，密码：" + Password);
//设置服务基类中，当前登录用户信息
//this.CurrentBaseLoginer = loginer;
//登陆后处理
//更新用户登陆次数及时间（存储过程登录，数据库已经处理）
//添加登录日志
string userinfo = string.Format("用户姓名：{0}，用户编号：{1}，登录账号：{2}，登录密码：{3}",
loginer.UserName, loginer.UserId, loginer.UserCode, loginer.Password);
Base_SysLogService.Instance.AddLoginLog(userinfo, IP, City);
//更新其它业务
}
else
{
LogHelper.Write("登录失败！账号：" + UserCode + "，密码：" + Password + "。原因：" + loginResult.ResultMsg);
}
return(Json(loginResult, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 重置某个用户的密码,新密码默认是：123456
/// </summary>
/// <param name="userId">用户编号</param>
/// <returns>返回CommandResult</returns>
public CommandResult ResetUserPassword(int userId, string userName, string userCode)
{
CommandResult cmdResult = CommandResult.Instance_Succeed;
cmdResult.ResultMsg = "密码重置成功";
string newPwd = Md5Util.MD5("123456");
var par = ParamUpdate.Instance().Update("Base_User")
.Column("Password", newPwd)
.Column("LastChangePassword", DateTime.Now)
.AndWhere("UserId", userId);
var result = Base_UserService.Instance.Update(par);
if (result == 0)
{
cmdResult.Set(false, "密码重置失败");
}
string logmsg = string.Format("用户密码重置。结果：{3}。用户：{0}-({1})，登录账号:{2}", userName, userId, userCode, cmdResult.ResultMsg);
LogHelper.Write(logmsg);
return(cmdResult);
}
// POST: /Login/
public JsonResult Login(JObject data)
{
string UserCode = data.Value <string>("user_code");
string Password = data.Value <string>("password");
string IP = data.Value <string>("ip");
string City = data.Value <string>("city");
data["user_code"] = UserCode;
data["password"] = Md5Util.MD5(Password);
data["LoginIP"] = IP;
data["LoginCity"] = City;
AppConnectionString = ConfigurationManager.ConnectionStrings["app"].ConnectionString;
DataSet dt = base.RunProcedureDataSet(data, "vdp_sys_Login", "app");
//if (dt.Rows.Count > 0)
var ResultID = dt.Tables[0].Rows[0]["result_id"];
var ResultMsg = (string)dt.Tables[0].Rows[0]["result_msg"];
//var loginResult = Base_UserService.Instance.Login(UserCode, Md5Util.MD5(Password), IP, City);
if (ResultID.ToString() == "0")
{
////登录成功后，查询当前用户数据
//var user = Base_UserService.Instance.GetEntity(ParamQuery.Instance()
// .AndWhere("UserCode", UserCode).AndWhere("Password", Md5Util.MD5(Password))
// .AndWhere("Enabled", 1).AndWhere("IsAudit", 1));
//user.DepartmentCode = "";
//调用框架中的登录机制
Base_User b = new Base_User();
b.city = "";// (string)dt.Rows[0]["city"];
b.RealName = (string)dt.Tables[1].Rows[0]["real_name"];
b.DepartmentID = (int)dt.Tables[1].Rows[0]["department_id"];
b.UserId = (int)dt.Tables[1].Rows[0]["id"];
b.UserCode = (String)dt.Tables[1].Rows[0]["user_code"];
b.RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"];
b.DepartmentCode = ((int)dt.Tables[1].Rows[0]["department_id"]).ToString();
var loginer = new BaseLoginer
{
UserId = (int)dt.Tables[1].Rows[0]["id"], //. user.UserId,
UserCode = (string)dt.Tables[1].Rows[0]["user_code"], // user.UserCode,
// Password = (string)dt.Tables[1].Rows[0]["Password"],// user.Password,
UserName = (string)dt.Tables[1].Rows[0]["real_name"], // user.RealName,
RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"],
// DepartmentCode =((int)dt.Tables[1].Rows[0]["DepartmentID"]).ToString(),
Data = b,
IsAdmin = false// user.UserType == 1 //根据用户UserType判断。用户类型：0=未定义 1=超级管理员 2=普通用户 3=其他
};
Session["logininfo"] = "";
//读取配置登录默认失效时长：小时
var effectiveHours = Convert.ToInt32(60 * ConfigUtil.GetConfigDecimal("LoginEffectiveHours"));
//执行web登录
FormsAuth.SignIn(loginer.UserId.ToString(), loginer, effectiveHours);
LogHelper.Write("登录成功！用户：" + loginer.UserName + "，账号：" + UserCode + "，密码：---");
//设置服务基类中，当前登录用户信息
//this.CurrentBaseLoginer = loginer;
//登陆后处理
//更新用户登陆次数及时间（存储过程登录，数据库已经处理）
//添加登录日志
string userinfo = string.Format("用户姓名：{0}，用户编号：{1}，登录账号：{2}，登录密码：{3}",
loginer.UserName, loginer.UserId, loginer.UserCode, "---" /*loginer.Password*/);
// Base_SysLogService.Instance.AddLoginLog(userinfo, IP, City);
//更新其它业务
}
else
{
LogHelper.Write("登录失败！账号：" + UserCode + "，密码：" + Password + "。原因：" + ResultMsg);
}
return(Json(new { s = ResultID, message = ResultMsg }, JsonRequestBehavior.DenyGet));
}
