/// <summary>
/// 修改密码
/// </summary>
/// <param name="model">修改密码实体</param>
/// <returns>结果</returns>
public async Task <BaseResult> ChangePasswordAsync(ChangePasswordModel model)
{
BaseResult result = new BaseResult();
string oldPwd = await _repository.GetPasswordByIdAsync(model.Id);//数据库中的密码
if (oldPwd == AESEncryptHelper.Encode(model.OldPassword, CzarCmsKeys.AesEncryptKeys))
{
var count = await _repository.ChangePasswordByIdAsync(model.Id, AESEncryptHelper.Encode(model.NewPassword.Trim(), CzarCmsKeys.AesEncryptKeys));
if (count > 0)
{
result.ResultCode = ResultCodeAddMsgKeys.CommonObjectSuccessCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonObjectSuccessMsg;
}
else
{
result.ResultCode = ResultCodeAddMsgKeys.CommonExceptionCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonExceptionMsg;
}
}
else
{
result.ResultCode = ResultCodeAddMsgKeys.PasswordOldErrorCode;
result.ResultMsg = ResultCodeAddMsgKeys.PasswordOldErrorMsg;
}
return(result);
}
//添加新用户、也就是注册
public ActionResult InsertYongHu(B_AccountTable Account)
{
string str = "";
try
{
int user = (from tbuser in myModels.B_AccountTable
where tbuser.User == Account.User
select tbuser).Count();
if (user > 0)
{
str = "Exist";
}
else
{
string pw = AESEncryptHelper.AESEncrypt(Account.Password);
Account.Password = pw;
Account.Cancel = false;
myModels.B_AccountTable.Add(Account);
myModels.SaveChanges();
str = "success";
}
}
catch (Exception e)
{
}
return(Json(str, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 登录操作，成功则写日志
/// </summary>
/// <param name="model">登陆实体</param>
/// <returns>状态</returns>
public async Task <Manager> SignInAsync(LoginModel model)
{
model.Password = AESEncryptHelper.Encode(model.Password.Trim(), CzarCmsKeys.AesEncryptKeys);
model.UserName = model.UserName.Trim();
string conditions = $"select * from {nameof(Manager)} where IsDelete=0 ";//未删除的
conditions += $"and (UserName = @UserName or Mobile =@UserName or Email =@UserName) and Password=@Password";
var manager = await _repository.GetAsync(conditions, model);
if (manager != null)
{
manager.LoginLastIp = model.Ip;
manager.LoginCount += 1;
manager.LoginLastTime = DateTime.Now;
_repository.Update(manager);
await _managerLogRepository.InsertAsync(new ManagerLog()
{
ActionType = CzarCmsEnums.ActionEnum.SignIn.ToString(),
AddManageId = manager.Id,
AddManagerNickName = manager.NickName,
AddTime = DateTime.Now,
AddIp = model.Ip,
Remark = "用户登录"
});
}
return(manager);
}
/// <summary>
/// 登录操作，成功则写日志
/// </summary>
/// <param name="model">登陆实体</param>
/// <returns>状态</returns>
public Manager SignIn(LoginModel model)
{
model.Password = AESEncryptHelper.Encode(model.Password.Trim(), CzarCmsKeys.AesEncryptKeys);
model.UserName = model.UserName.Trim();
string conditions = "where IsDelete=0 ";//未删除的
conditions += $"and (UserName = @UserName or Mobile =@UserName or Email =@UserName) and Password=@Password";
var manager = _repository.GetList(conditions, model).FirstOrDefault();
if (manager != null)
{
manager.LoginLastIp = model.Ip;
manager.LoginCount += 1;
manager.LoginLastTime = DateTime.Now;
_repository.Update(manager);
_managerLogRepository.Insert(new ManagerLog()
{
ActionType = CzarCmsEnums.ActionEnum.SignIn.ToString(),
AddManageId = manager.Id,
AddManagerNickName = manager.NickName,
AddTime = DateTime.Now,
AddIp = model.Ip,
Remark = "用户登录"
});
}
return(manager);
}
public async Task <BaseResult> AddOrModifyAsync(ManagerAddOrModifyModel item)
{
var result = new BaseResult();
Manager manager;
if (item.Id == 0)
{
//TODO ADD
manager = _mapper.Map <Manager>(item);
manager.Password = AESEncryptHelper.Encode(CzarCmsKeys.DefaultPassword, CzarCmsKeys.AesEncryptKeys);
manager.LoginCount = 0;
manager.AddManagerId = 1;
manager.IsDelete = false;
manager.AddTime = DateTime.Now;
int?isresult = await _repository.InsertAsync(manager);
if (isresult > 0)
{
result.ResultCode = ResultCodeAddMsgKeys.CommonObjectSuccessCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonObjectSuccessMsg;
}
else
{
result.ResultCode = ResultCodeAddMsgKeys.CommonExceptionCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonExceptionMsg;
}
}
else
{
//TODO Modify
manager = await _repository.GetAsync(item.Id);
if (manager != null)
{
_mapper.Map(item, manager);
manager.ModifyManagerId = 1;
manager.ModifyTime = DateTime.Now;
if (_repository.Update(manager) > 0)
{
result.ResultCode = ResultCodeAddMsgKeys.CommonObjectSuccessCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonObjectSuccessMsg;
}
else
{
result.ResultCode = ResultCodeAddMsgKeys.CommonExceptionCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonExceptionMsg;
}
}
else
{
result.ResultCode = ResultCodeAddMsgKeys.CommonFailNoDataCode;
result.ResultMsg = ResultCodeAddMsgKeys.CommonFailNoDataMsg;
}
}
return(result);
}
//加密
private void BtnEncrypt_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSourceText.Text))
{
MessageBox.Show("没数据加毛密-_-!");
return;
}
else
{
txtResultText.Text = AESEncryptHelper.Encrypt(txtSourceText.Text);
}
}
public ActionResult insertUserPwP(B_AccountTable Account, B_UserTable User)
{
string strMed = "fail";
string password = AESEncryptHelper.AESEncrypt(Account.Password);
string Paypassword = AESEncryptHelper.AESEncrypt(User.PayPassword);
int intaccon = (from tbaccounnt in myDYXTEntities.B_AccountTable
where tbaccounnt.User == User.UserName
select tbaccounnt).Count();
if (intaccon == 0)
{
Account.User = User.UserName;
Account.Password = password;
Account.Cancel = false;
myDYXTEntities.B_AccountTable.Add(Account);
myDYXTEntities.SaveChanges();
int varuser = (from tbUSer in myDYXTEntities.B_UserTable
where tbUSer.UserName == User.UserName
select tbUSer).Count();
if (varuser == 0)
{
var varaccon = (from tbaccounnt in myDYXTEntities.B_AccountTable
where tbaccounnt.User == User.UserName
select tbaccounnt).Single();
User.AccountID = varaccon.AccountID;
User.PayPassword = Paypassword;
User.UserTypeID = 2;
User.Time = DateTime.Now;
User.PropertyAmounts = 0;
User.UsableMoney = 0;
User.FreezeMoney = 0;
User.WaitMoney = 0;
User.CompensatoryMoney = 0;
myDYXTEntities.B_UserTable.Add(User);
myDYXTEntities.SaveChanges();
strMed = "success";
}
else
{
strMed = "UserNamefail";//用户名已存在
}
}
else
{
strMed = "AccountUserfail";//账号名已存在
}
return(Json(strMed, JsonRequestBehavior.AllowGet));
}
public ActionResult updataPasswords(string YPassword, string QPassword)
{
string strMsg = "fali";
try
{
int yAccountID = Convert.ToInt32(Session["AccountID"]);
int dbUser = (from tbUser in myDYXTEntities.B_AccountTable
where tbUser.AccountID == yAccountID
select tbUser).Count();
if (dbUser > 0)
{
var varuser = (from tbUser in myDYXTEntities.B_AccountTable
where tbUser.AccountID == yAccountID
select new
{
tbUser.AccountID,
tbUser.User,
tbUser.Password
}).Single();
//将用户输入的密码进行AES265后与数据库中的密码对比
string password = AESEncryptHelper.AESEncrypt(YPassword);
if (varuser.Password.Trim().Equals(password))
{
var struser = (from tbUser in myDYXTEntities.B_AccountTable
where tbUser.AccountID == yAccountID
select tbUser).Single();
string qPassword = AESEncryptHelper.AESEncrypt(QPassword);
struser.Password = qPassword;
myDYXTEntities.Entry(struser).State = System.Data.Entity.EntityState.Modified;
myDYXTEntities.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "strpassword";//密码错误
}
}
else
{
strMsg = "nonexistent";
}
}
catch (Exception e)
{
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
//解密
private void BtnDecrypt_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSourceText.Text))
{
MessageBox.Show("没数据解毛密-_-!");
return;
}
else if (!IsBase64Formatted(txtSourceText.Text))
{
MessageBox.Show("别逗了,我只认识被我加过密的？");
return;
}
else
{
txtResultText.Text = AESEncryptHelper.Decrypt(txtSourceText.Text);
}
}
public async Task <Result <string> > ChangePwd(string oldPwd, string newPwd)
{
Result <string> result = new Result <string>();
var member = await _manageServices.QueryByID(1);
if (member.Password != AESEncryptHelper.Encode(oldPwd))
{
result.status = false;
result.message = "旧密码错误";
return(result);
}
member.Password = AESEncryptHelper.Encode(newPwd);
result.message = "修改密码成功！";
await _manageServices.Update(member);
return(result);
}
public async Task <IActionResult> Login(string userName, string passWord)
{
var(_bool, msg) = VerifyValiate();
if (!_bool)
{
return(Json(new { msg = msg, status = "error" }));
}
var manage = await _manageServices.QueryByID(1);
if (manage.Name == userName && manage.Password == AESEncryptHelper.Encode(passWord))
{
//登陆授权
var claims = new List <Claim>();
claims.Add(new Claim(ClaimTypes.Name, "name"));
var indentity = new ClaimsIdentity(claims, "denglu");
var principal = new ClaimsPrincipal(indentity);
await HttpContext.SignInAsync(
CookieAuthenticationDefaults.AuthenticationScheme,
principal);
//验证是否授权成功
if (principal.Identity.IsAuthenticated)
{
//return Redirect("/");
return(Json(new { msg = "登陆成功!", status = "ok" }));
}
else
{
return(Json(new { msg = "登陆失败!", status = "error" }));
}
}
else
{
return(Json(new { msg = "账号密码错误!", status = "error" }));
}
}
public static void ConfigurationAutoMapper()
{
DateTime?dt = null;
var minDt = DateTime.MinValue;
Mapper.Initialize(cfg => {
cfg.CreateMap <SysUserConfig, SysUserConfigDTO>();
cfg.CreateMap <SysUserConfigDTO, SysUserConfig>();
cfg.CreateMap <SysUser, SysUserDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToString()))
.ForMember(dest => dest.State, opt => opt.MapFrom(src => src.State.ToString()));
cfg.CreateMap <SysUserDTO, SysUser>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToInt()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToInt()))
.ForMember(dest => dest.State, opt => opt.MapFrom(src => src.State.ToInt()));
cfg.CreateMap <RecordManager, RecordManagerDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Type, opt => opt.MapFrom(src => ((RecordManagerTypeEnum)src.Type).ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.SysUserId, opt => opt.MapFrom(src => src.SysUserId.ToString()))
.ForMember(dest => dest.LastInTime, opt => opt.MapFrom(src => src.LastInTime > minDt ? src.LastInTime.ToString() : ""))
.ForMember(dest => dest.LastOutTime, opt => opt.MapFrom(src => src.LastOutTime > minDt ? src.LastOutTime.ToString() : ""))
.ForMember(dest => dest.ValideTime, opt => opt.MapFrom(src => src.ValideTime > minDt ? src.ValideTime.ToString() : ""))
.ForMember(dest => dest.RecordMGrade, opt => opt.MapFrom(src => src.RecordMGrade))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <RecordManagerDTO, RecordManager>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToLong()))
.ForMember(dest => dest.Type, opt => opt.MapFrom(src => (int)Enum.Parse(typeof(RecordManagerTypeEnum), src.Type)))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()))
.ForMember(dest => dest.SysUserId, opt => opt.MapFrom(src => src.SysUserId.ToInt()))
.ForMember(dest => dest.LastInTime, opt => opt.MapFrom(src => string.IsNullOrEmpty(src.LastInTime) ? dt : src.LastInTime.ToDateTime()))
.ForMember(dest => dest.LastOutTime, opt => opt.MapFrom(src => string.IsNullOrEmpty(src.LastOutTime) ? dt : src.LastOutTime.ToDateTime()))
.ForMember(dest => dest.ValideTime, opt => opt.MapFrom(src => string.IsNullOrEmpty(src.ValideTime) ? dt : src.ValideTime.ToDateTime()))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <Capture, CaptureDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Pass, opt => opt.MapFrom(src => src.Pass.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.StayTime, opt => opt.MapFrom(src => src.Pass == 1 && src.WithOut == 0 ? Utils.GetFriendlyTime(src.CreateTime) : ""))
.ForMember(dest => dest.IsAlarm, opt => opt.Ignore());
cfg.CreateMap <CaptureDTO, Capture>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToLong()))
.ForMember(dest => dest.Pass, opt => opt.MapFrom(src => src.Pass.ToInt()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()));
cfg.CreateMap <CaptureDTO, CaptureBackup>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToLong()))
.ForMember(dest => dest.Pass, opt => opt.MapFrom(src => src.Pass.ToInt()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()));
cfg.CreateMap <Layout, LayoutDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.SysUserId, opt => opt.MapFrom(src => src.SysUserId.ToString()))
.ForMember(dest => dest.IsValid, opt => opt.MapFrom(src => src.IsValid.ToString()))
.ForMember(dest => dest.ValideTime, opt => opt.MapFrom(src => src.ValideTime > minDt ? src.ValideTime.ToString() : ""))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <LayoutDTO, Layout>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToLong()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()))
.ForMember(dest => dest.SysUserId, opt => opt.MapFrom(src => src.SysUserId.ToInt()))
.ForMember(dest => dest.IsValid, opt => opt.MapFrom(src => src.IsValid))
.ForMember(dest => dest.ValideTime, opt => opt.MapFrom(src => string.IsNullOrEmpty(src.ValideTime) ? dt : src.ValideTime.ToDateTime()))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <Alarm, AlarmDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.CaptureId, opt => opt.MapFrom(src => src.CaptureId.ToString()))
.ForMember(dest => dest.AlarmTime, opt => opt.MapFrom(src => src.AlarmTime.ToString()))
.ForMember(dest => dest.HandlerTime, opt => opt.MapFrom(src => src.HandlerTime > minDt ? src.HandlerTime.ToString() : ""))
.ForMember(dest => dest.IsDeal, opt => opt.MapFrom(src => src.IsDeal.ToString()))
.ForMember(dest => dest.LetterCode, opt => opt.MapFrom(src => AESEncryptHelper.Decrypt(src.LetterCode)))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <AlarmDTO, Alarm>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToLong()))
.ForMember(dest => dest.CaptureId, opt => opt.MapFrom(src => src.CaptureId.ToLong()))
.ForMember(dest => dest.AlarmTime, opt => opt.MapFrom(src => src.AlarmTime.ToDateTime()))
.ForMember(dest => dest.HandlerTime, opt => opt.MapFrom(src => string.IsNullOrEmpty(src.HandlerTime) ? dt : src.HandlerTime.ToDateTime()))
.ForMember(dest => dest.Channel, opt => opt.MapFrom(src => src.Channel));
cfg.CreateMap <SysRoleDTO, SysRole>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToInt()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToInt()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()));
cfg.CreateMap <SysRole, SysRoleDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()));
cfg.CreateMap <SysChannel, SysChannelDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Name, opt => opt.MapFrom(src => src.Name.ToString()))
.ForMember(dest => dest.Description, opt => opt.MapFrom(src => src.Description.ToString()));
cfg.CreateMap <SysChannelDTO, SysChannel>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Name, opt => opt.MapFrom(src => src.Name.ToString()))
.ForMember(dest => dest.Description, opt => opt.MapFrom(src => src.Description.ToString()));
cfg.CreateMap <SysModule, SysModuleDTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.Enable, opt => opt.MapFrom(src => ((State)src.Enable).ToString()))
//.ForMember(dest => dest.ParentId, opt => opt.MapFrom(src => src.ParentId.ToString()))
.ForMember(dest => dest.Sort, opt => opt.MapFrom(src => src.Sort.ToString()));
cfg.CreateMap <SysModuleDTO, SysModule>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToInt()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToInt()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToDateTime()))
.ForMember(dest => dest.Enable, opt => opt.MapFrom(src => src.Enable.ToInt()))
//.ForMember(dest => dest.ParentId, opt => opt.MapFrom(src => src.ParentId.ToInt()))
.ForMember(dest => dest.Sort, opt => opt.MapFrom(src => src.Sort.ToInt()));
cfg.CreateMap <SysModuleOperate, SysModuleOperateDTO>()
.ForMember(dest => dest.SysRightOperateId, opt => opt.Ignore())
.ForMember(dest => dest.SysModuleOperateId, opt => opt.Ignore())
.ForMember(dest => dest.SysRightId, opt => opt.Ignore())
.ForMember(dest => dest.IsRightValid, opt => opt.Ignore())
.ForMember(dest => dest.KeyName, opt => opt.MapFrom(src => src.Name));
cfg.CreateMap <SysModuleOperateDTO, SysModuleOperate>()
.ForMember(dest => dest.Name, opt => opt.MapFrom(src => src.KeyName))
.ForMember(dest => dest.SysModule, opt => opt.Ignore())
.ForMember(dest => dest.SysRightOperates, opt => opt.Ignore());
cfg.CreateMap <SysErrorLog, SysErrorLogDTO>()
.ForMember(dest => dest.ErrTime, opt => opt.MapFrom(src => src.ErrTime.ToString()));
cfg.CreateMap <SysErrorLogDTO, SysErrorLog>()
.ForMember(dest => dest.ErrTime, opt => opt.MapFrom(src => src.ErrTime.ToDateTime()));
cfg.CreateMap <SysUserRightView, SysModuleOperateIndexDTO>()
.ForMember(dest => dest.KeyCode, opt => opt.MapFrom(src => src.KeyCode))
.ForMember(dest => dest.KeyName, opt => opt.MapFrom(src => src.Name))
.ForMember(dest => dest.IsValid, opt => opt.MapFrom(src => src.IsValid));
cfg.CreateMap <SysModule, SysModule2DTO>()
.ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID.ToString()))
.ForMember(dest => dest.Creater, opt => opt.MapFrom(src => src.Creater.ToString()))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom(src => src.CreateTime.ToString()))
.ForMember(dest => dest.Enable, opt => opt.MapFrom(src => ((State)src.Enable).ToString()))
//.ForMember(dest => dest.ParentId, opt => opt.MapFrom(src => src.ParentId.ToString()))
.ForMember(dest => dest.Sort, opt => opt.MapFrom(src => src.Sort.ToString()))
.ForMember(dest => dest.SubSysModules, opt => opt.Ignore());
cfg.CreateMap <SysRightOperate, SysRightOperateDTO>();
cfg.CreateMap <SysRightOperateDTO, SysRightOperate>();
});
}
public ActionResult UserLogin(B_AccountTable Account)
{
string str = ""; //
string strUser = Request["username"]; //用户名
string strPassword = Request["password"]; //密码
string strvalidCode = Request["validCode"]; //验证码
string strSession = "";
if (Session["vildeCode"] != null)
{
strSession = Session["vildeCode"].ToString();
if (strSession.Equals(strvalidCode, StringComparison.CurrentCultureIgnoreCase))
{
try
{
var list = (from tbUser in myModels.B_AccountTable
where tbUser.User == strUser.Trim()
select new
{
tbUser.User,
tbUser.Password,
tbUser.AccountID
}).Single();
string strpassword = AESEncryptHelper.AESEncrypt(strPassword);
if (strpassword == list.Password.Trim())
{
Session["AccountID"] = list.AccountID; // 传递 UserID
Session["Password"] = list.Password;
var BLoginDetai = (from tblo in myModels.B_UserLoginDetailTable
select new
{
tblo.AccountID,
}).ToList();
for (int i = 0; i < BLoginDetai.Count; i++)
{
if (BLoginDetai[i].AccountID == list.AccountID)
{
B_UserLoginDetailTable BLoginss = (from tblogin in myModels.B_UserLoginDetailTable
where tblogin.AccountID == list.AccountID
select tblogin).Single();
if (BLoginss.lastLoginTime == null || BLoginss.LoginFrequency == null)
{
BLoginss.RegisterTime = DateTime.Now;
BLoginss.lastLoginTime = DateTime.Now;
BLoginss.LoginFrequency = 1;
BLoginss.EndLoginTime = DateTime.Now;
myModels.Entry(BLoginss).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
else
{
BLoginss.lastLoginTime = BLoginss.EndLoginTime;
BLoginss.LoginFrequency = BLoginss.LoginFrequency + 1;
BLoginss.EndLoginTime = DateTime.Now;
myModels.Entry(BLoginss).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
break;
}
}
str = "success";
}
else
{
str = "fail";
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
else
{
str = "validCodeFail";
}
}
else
{
str = "writevalidCode";
}
return(Json(str, JsonRequestBehavior.AllowGet));
}
public ActionResult UserLogin(B_AccountTable B_Account)
{
string strMed = "fail";
string struser = Request["User"];; //用户
string strPassword = Request["password"];
string strvalidCode = Request["validCode"]; //验证码
string strSessionValidCode = ""; //获取 session中的验证码
try
{
strSessionValidCode = Session["ValidCode"].ToString();
}
catch (Exception)
{
return(Json("loginerror", JsonRequestBehavior.AllowGet));
}
//判断验证码
if (strSessionValidCode.Equals(strvalidCode.Trim(), StringComparison.InvariantCultureIgnoreCase))
{
try
{
//根据 UserNuber 查询用户
var dbUser = (from tbUser in myDYXTEntities.B_AccountTable
where tbUser.User == struser.Trim()
select new
{
tbUser.AccountID,
tbUser.User,
tbUser.Password
}).Single();
//将用户输入的密码进行AES265后与数据库中的密码对比
string password = AESEncryptHelper.AESEncrypt(strPassword);
if (dbUser.Password.Trim().Equals(password))
{
B_UserTable dbuser = (from tbuser in myDYXTEntities.B_UserTable
where tbuser.AccountID == dbUser.AccountID
select tbuser).Single();
if (dbuser.UserTypeID == 1 || dbuser.UserTypeID == 4 || dbuser.UserTypeID == 12)
{
Session["AccountID"] = dbUser.AccountID;
B_UserTable varFundCost = (from tbuser in myDYXTEntities.B_UserTable
where tbuser.AccountID == dbUser.AccountID
select tbuser).Single();
B_ManagerRecord ManagerRecord = new B_ManagerRecord();
ManagerRecord.UserID = varFundCost.UserID;
ManagerRecord.BearFruit = "成功".Trim();
ManagerRecord.Content = "用户" + varFundCost.UserName.Trim() + "在“" + DateTime.Now + "”登录后台";
ManagerRecord.LoginTime = DateTime.Now;
string IP = "";
try
{
string pHostName = Dns.GetHostName();//Dns类
IPHostEntry myAddress = Dns.GetHostEntry(pHostName);
//myAddress.Aliases
IPAddress[] myIPAddress = myAddress.AddressList;
foreach (IPAddress add in myIPAddress)
{
if (add.AddressFamily == AddressFamily.InterNetwork)
{
IP = add.ToString();
}
}
}
catch (Exception e)
{
}
ManagerRecord.LoginIP = IP;
myDYXTEntities.B_ManagerRecord.Add(ManagerRecord);
myDYXTEntities.SaveChanges();
strMed = "strsuccess";//登录成功
}
else
{
strMed = "strfail";//登录成功
}
}
else
{
strMed = "strpassword";//密码错误
}
}
catch (Exception e)
{
strMed = "usernoexsit";//没有此用户
}
}
else
{
strMed = "ValidCodeErro";//验证码错误
}
return(Json(strMed, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 确定认购
/// </summary>
/// <param name="bInvest"></param>
/// <param name="Loantitle"></param>
/// <param name="fenshu"></param>
/// <param name="LowestTenderMoney"></param>
/// <param name="Rate"></param>
/// <param name="PayPassword"></param>
/// <returns></returns>
public ActionResult InsertLoan(B_InvestTable bInvest, string Loantitle, int fenshu, string LowestTenderMoney, string Rate, string PayPassword)
{
string str = "";
int loanid = Convert.ToInt32(bInvest.LoanID);
B_LoanTable varB_LoanTable = (from tbtbB_Loan in myModels.B_LoanTable
where tbtbB_Loan.LoanID == loanid
select tbtbB_Loan).Single();
int userid = Convert.ToInt32(varB_LoanTable.UserID);
B_UserTable varuser = (from tbuser in myModels.B_UserTable
where tbuser.UserID == userid
select tbuser).Single();
string password = AESEncryptHelper.AESEncrypt(PayPassword);
if (varuser.PayPassword.Trim().Equals(password))
{
int accountID = Convert.ToInt32(Session["AccountID"].ToString());
var list = (from tbuser in myModels.B_UserTable
where tbuser.AccountID == accountID
select tbuser).Single();
bInvest.LoanTreetop = Loantitle;
decimal intLowestTenderMoney = Convert.ToDecimal(LowestTenderMoney);
bInvest.InvestMoney = fenshu * intLowestTenderMoney; //份数*最低投标金额
decimal rate = Convert.ToDecimal(Rate.ToString().Trim()); //年利率
bInvest.ReceivableInterest = (bInvest.InvestMoney * rate) / 100; //应收利息
bInvest.ReceivablePrincipal = bInvest.InvestMoney + bInvest.ReceivableInterest; //应收本息
bInvest.CountermandPrincipal = Convert.ToDecimal(0.00); //已收本息
bInvest.NotRetrievePrincipal = bInvest.ReceivablePrincipal; //未收本息
if (list.PropertyAmounts > bInvest.InvestMoney)
{
if (bInvest.LoanID != null)
{
bInvest.InvestTime = DateTime.Now;
bInvest.UserID = list.UserID;
bInvest.StatusID = 16;
bInvest.WhetherAttorn = false;
myModels.B_InvestTable.Add(bInvest);
myModels.SaveChanges();
//修改借款标表
B_LoanTable B_Loan = (from tbloan in myModels.B_LoanTable
where tbloan.LoanID == bInvest.LoanID
select tbloan).Single();
//B_Loan.LoanMoney = B_Loan.LoanMoney - bInvest.InvestMoney;//借款金额
int investTime;
investTime = Convert.ToInt32(B_Loan.InvestTime.ToString());//投资次数
investTime = investTime + 1;
B_Loan.InvestTime = Convert.ToInt32(investTime).ToString();
int grossscore;
grossscore = Convert.ToInt32(B_Loan.Grossscore); //总份数;
double scheduleinvestment; //进度
scheduleinvestment = Convert.ToDouble(B_Loan.Scheduleinvestment);
scheduleinvestment = Convert.ToDouble(Convert.ToDouble(fenshu) / Convert.ToDouble(grossscore)) * 100;
B_Loan.Scheduleinvestment = Convert.ToDecimal(scheduleinvestment + Convert.ToDouble(B_Loan.Scheduleinvestment));
int surplusLoan;//剩余份数
surplusLoan = Convert.ToInt32(B_Loan.SurplusLoan);
surplusLoan = (surplusLoan - fenshu);
B_Loan.SurplusLoan = Convert.ToDecimal(surplusLoan);
int alreadyLoan;//已被购买份数
alreadyLoan = Convert.ToInt32(B_Loan.AlreadyLoan);
B_Loan.AlreadyLoan = Convert.ToInt32(alreadyLoan + fenshu);
myModels.Entry(B_Loan).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
if (B_Loan.SurplusLoan == 0)
{
B_LoanTable bloan = (from tbloa in myModels.B_LoanTable
where tbloa.LoanID == bInvest.LoanID
select tbloa).Single();
bloan.StatusID = 28;
myModels.Entry(bloan).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
//修改用户表的金额
B_UserTable listS = (from tbuser in myModels.B_UserTable
where tbuser.AccountID == accountID
select tbuser).Single();
//listS.PropertyAmounts = listS.PropertyAmounts - bInvest.InvestMoney;
listS.UsableMoney = listS.UsableMoney - bInvest.InvestMoney;
listS.FreezeMoney = listS.FreezeMoney + bInvest.InvestMoney;
myModels.Entry(listS).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable();
Capitalrecord.UserID = list.UserID;
Capitalrecord.OperateTypeID = 4;
Capitalrecord.OpFare = Convert.ToDecimal(bInvest.InvestMoney);
Capitalrecord.Income = Convert.ToDecimal(0);
Capitalrecord.Expend = Convert.ToDecimal(bInvest.InvestMoney);
Capitalrecord.PropertyAmounts = list.PropertyAmounts;
Capitalrecord.Remarks = "用户" + "[" + list.UserName.Trim() + "]" + "，投资成功，可用余额减少" + bInvest.InvestMoney + "元";
Capitalrecord.operatetime = DateTime.Now;
myModels.B_CapitalrecordTable.Add(Capitalrecord);
myModels.SaveChanges();
str = "success";
}
else
{
str = "fail";
}
}
}
else
{
str = "failPayPassword";
}
return(Json(str, JsonRequestBehavior.AllowGet));
}
public Resp_Binary_Member <AlarmDTO> Add_One(CaptureDTO model)
{
var alert = false;
var capture = model.GetPrototype <CaptureDTO, Capture>();
if (capture.Pass == 1) //without代表该车出场
{
capture.WithOut = 0;
}
if (capture.Pass == 0)
{
capture.WithOut = 1;
}
var result = false;
var guid = Guid.NewGuid().ToString();
long layoutId = 0;
using (var context = new SKContext())
{
using (var tran = new TransactionScope())
{
var layout = context.Layouts.Where(d => d.CarNumber == model.CarNumber && d.IsValid == 1 && d.Channel == model.Channel).FirstOrDefault();
if (layout.IsNotNull())
{
if (layout.TriggerType == 2 || layout.TriggerType == model.Pass.ToInt()) //进出场控制
{
alert = true;
var lettercode = GetRandomNumberString(ConfigPara.LetterCount);
var alarm = new Alarm
{
CarNumber = model.CarNumber,
IsDeal = 0,
GUID = guid,
AlarmTime = DateTime.Now,
Channel = model.Channel,
LetterCode = AESEncryptHelper.Encrypt(lettercode)
};
_messageRepository.SendMessage(capture.ToJson(), capture.Channel);
capture.Alarms.Add(alarm);
layoutId = layout.ID;
//if (layout.Degree > 0)
// --layout.Degree;
//if (layout.Degree == 0)
// layout.IsValid = 0;
}
}
var captureback = model.GetPrototype <CaptureDTO, CaptureBackup>();
//当车出场时，将该车的进场记录的是否出场改为已出场
if (model.Pass.ToInt() == 0)
{
var in_captures = context.Captures.Where(t => t.CarNumber == model.CarNumber && t.Pass == 1 && t.WithOut == 0);
foreach (var item in in_captures)
{
item.WithOut = 1;
}
}
var recordM = context.RecordManagers.Where(t => t.CarNumber == model.CarNumber).OrderByDescending(t => t.ID).FirstOrDefault();
if (recordM.IsNotNull())
{
capture.BeiAn = recordM.Type;
captureback.BeiAn = recordM.Type;
if (model.Pass.ToInt() == 1) //进场修改备案最后一次进场时间
{
recordM.LastInTime = model.CreateTime.ToDateTime();
}
else if (model.Pass.ToInt() == 0) //出场修改备案最近一次出场时间
{
recordM.LastOutTime = model.CreateTime.ToDateTime();
}
}
else
{
capture.BeiAn = 2;
captureback.BeiAn = 2;
}
context.Captures.Add(capture);
context.CaptureBackups.Add(captureback);
context.SaveChanges();
tran.Complete();
result = true;
}
}
if (result)
{
if (alert)
{
// var req_dock = new Req_Warning
// {
// WARNINGDATE = DateTime.Now.ToString("yyyy-MM-dd hh: mm:ss"),
// CARNO = model.CarNumber,
// CARTYPE = model.CarType,
// inout = model.Pass.Equals("1") ? "进" : "出",
// bayonet = model.Channel,
// Remark = model.Remark
// };
// Docking(req_dock); //报警通知第三方
var alam = _alarmRepository.GetByWhere(t => t.GUID == guid).FirstOrDefault();
var dto = alam.ConvertoDto <Alarm, AlarmDTO>();
dto.LetterCode = alam.LetterCode;
return(new Resp_Binary_Member <AlarmDTO> {
message = "该车辆已中控报警！", flag = 2, LetterCode = dto.LetterCode, entity = dto, LayoutId = layoutId
});
}
return(new Resp_Binary_Member <AlarmDTO> {
message = "添加成功", flag = 1
});
}
return(new Resp_Binary_Member <AlarmDTO> {
message = "添加失败", flag = 0
});
}
