/// <summary> /// 检测货物 /// </summary> /// <param name="inLog"></param> /// <param name="code"></param> /// <returns></returns> public async Task <ResultObj <PsGoodsEntity> > GoodsCheck(PsGoodsLogEntity inLog, string code) { var reObj = new ResultObj <PsGoodsEntity>(); var goods = await dbHelperGoods.Single(x => x.id == inLog.goodsGuid); if (goods == null || !goods.code.Equals(code)) { reObj.success = false; reObj.msg = "产品有误"; } else { inLog.id = await SequenceRepository.GetNextID <PsGoodsLogEntity>(); inLog.createTime = Helper.DataTimeHelper.getDateLong(DateTime.Now); dbHelperGoods.TranscationBegin(); try { DapperHelper <PsGoodsLogEntity> dbHelperGoodsLog = new DapperHelper <PsGoodsLogEntity>(dbHelperGoods.GetConnection(), dbHelperGoods.GetTransaction()); var opNum = await dbHelperGoodsLog.Save(new DtoSave <PsGoodsLogEntity> { data = inLog }); if (opNum < 1) { throw new Exception("保存日志失败"); } goods.confirmTime = inLog.createTime; goods.openid = inLog.openid; opNum = await dbHelperGoods.Update(new DtoSave <PsGoodsEntity> { data = goods, saveFieldListExp = x => new object[] { x.confirmTime, x.openid }, whereListExp = x => new object[] { x.id } }); if (opNum < 1) { throw new Exception("更新检测失败"); } dbHelperGoods.TranscationCommit(); reObj.success = true; reObj.data = goods; } catch (Exception e) { dbHelperGoods.TranscationRollback(); reObj.success = false; reObj.msg = e.Message; } } return(reObj); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public static async Task <int> GetNextID <T>() where T : new() { string tableName = new ModelHelper <T> ().GetTableName(); var single = await dbHelper.SingleByKey(tableName); if (single == null) { single = new SysSequenceEntity(); single.seq_name = tableName; single.current_val = 1; single.increment_val = 1; await dbHelper.Save(new DtoSave <SysSequenceEntity> { data = single, ignoreFieldList = new List <string>() }); } else { single.current_val += single.increment_val; await dbHelper.Update(new DtoSave <SysSequenceEntity> { data = single, saveFieldListExp = x => new object[] { x.current_val }, }); } return(single.current_val); }
/// <summary> /// 注销用户登录状态 /// <para>清除用户的缓存状态</para> /// <para>记录退出日志</para> /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <Result> LoginOut(DtoSave <SysLoginHistoryEntity> inEnt) { Result reObj = new Result(); #region 记录登出历史 //正常退出,修改退出日志 DapperHelper <SysLoginEntity> dbHelper = new DapperHelper <SysLoginEntity>(); reObj.success = await dbHelper.Update(new DtoSave <SysLoginEntity> { data = new SysLoginEntity { id = inEnt.data.USER_ID.Value, lastActiveTime = Helper.DataTimeHelper.getDateLong(DateTime.Now), lastLogoutTime = Helper.DataTimeHelper.getDateLong(DateTime.Now) }, saveFieldListExp = x => new object[] { x.lastActiveTime, x.lastLogoutTime } }) > 0; if (!reObj.success) { return(reObj); } if (inEnt.data.ID == 0) { inEnt.data.ID = await SequenceRepository.GetNextID <SysLoginHistoryEntity>(); } //记录登录日志 await new LoginHistoryRepository().Save(inEnt); #endregion reObj.success = RedisRepository.UserTokenDelete(inEnt.data.USER_ID.Value); return(reObj); }
/// <summary> /// 保存用户 /// </summary> /// <param name="inObj"></param> /// <returns></returns> public async Task <ResultObj <int> > saveUser(WxUserEntity inObj, List <string> saveFieldList) { ResultObj <int> resultObj = new ResultObj <int>(); var saveEnt = new DtoSave <WxUserEntity>() { data = inObj }; string openid = inObj.openid; if (await dbHelper_user.Count(x => x.openid == openid) > 0) { saveEnt.ignoreFieldList = new List <string> { "openid" }; saveEnt.whereList = new List <string> { "openid" }; saveEnt.data.lastTime = DataTimeHelper.getDateLong(DateTime.Now); saveEnt.saveFieldList = saveFieldList; resultObj.data = await dbHelper_user.Update(saveEnt); } else { saveEnt.data.createTime = DataTimeHelper.getDateLong(DateTime.Now); saveEnt.data.lastTime = saveEnt.data.createTime; resultObj.data = await dbHelper_user.Save(saveEnt); } resultObj.success = resultObj.data > 0; return(resultObj); }
public async Task <ResultObj <int> > Save(DtoSave <SysRoleEntity> inEnt) { ResultObj <int> reObj = new ResultObj <int>(); try { dbHelper.TranscationBegin(); DapperHelper <SysModuleEntity> moduleDapper = new DapperHelper <SysModuleEntity>(dbHelper.GetConnection(), dbHelper.GetTransaction()); if (inEnt.data.id == 0) { inEnt.data.id = await SequenceRepository.GetNextID <SysRoleEntity>(); reObj.data = await dbHelper.Save(inEnt); } else { reObj.data = await dbHelper.Update(inEnt); } reObj.success = reObj.data > 0; if (!reObj.success) { reObj.msg = "保存角色失败"; dbHelper.TranscationRollback(); } else { var allModule = await moduleDapper.FindAll(string.Format("ID in ({0})", string.Join(",", inEnt.data.moduleIdStr))); var moduleIdList = allModule.Select(i => i.id).ToList(); var parent = allModule.GroupBy(i => i.parentId).Select(x => x.Key).Where(x => x != 0).Select(x => x).ToList(); moduleIdList = moduleIdList.Concat(parent).ToList(); moduleIdList = moduleIdList.GroupBy(i => i).Select(i => i.Key).ToList(); await dbHelper.Exec("delete from sys_role_module where role_id = " + inEnt.data.id); var opNum = await dbHelper.Exec(string.Format("insert into sys_role_module(role_id,module_id) select {0} role_id,id module_id from sys_module where id in ({1}) ", inEnt.data.id, string.Join(",", moduleIdList))); if (opNum != moduleIdList.Count()) { reObj.success = false; reObj.msg = "保存角色模块失败"; dbHelper.TranscationRollback(); } else { reObj.success = true; dbHelper.TranscationCommit(); } } } catch (Exception e) { reObj.success = false; reObj.msg = "保存角色失败"; LogHelper.WriteErrorLog(this.GetType(), reObj.msg, e); dbHelper.TranscationRollback(); } return(reObj); }
/// <summary> /// 修改用户密码 /// <para>entity:旧密码</para> /// <para>NewPwd:新密码</para> /// </summary> /// <param name="inEnt"></param> /// <returns></returns> async public Task <ResultObj <bool> > UserEditPwd(EditPwdDto inEnt) { var reObj = new ResultObj <bool>(); reObj.data = false; if (!inEnt.NewPwd.Equals(inEnt.ReNewPwd)) { reObj.success = false; reObj.msg = "两次密码不一致"; return(reObj); } if (!Fun.CheckPassword(inEnt.NewPwd, appConfig.BaseConfig.PwdComplexity)) { reObj.success = false; reObj.code = "-2"; reObj.msg = string.Format("密码复杂度不够:{0}", appConfig.BaseConfig.PwdComplexity); return(reObj); } DapperHelper <SysLoginEntity> dapper = new DapperHelper <SysLoginEntity>(); var single = await dapper.Single(i => i.loginName == inEnt.LoginName); if (single == null) { reObj.success = false; reObj.msg = "账号不存在"; return(reObj); } if (single.password != inEnt.OldPwd.Md5()) { reObj.success = false; reObj.msg = "原密码有误"; return(reObj); } single.password = inEnt.NewPwd.Md5(); var upRows = await dapper.Update(new DtoSave <SysLoginEntity> { data = single, saveFieldListExp = x => new object[] { x.password }, whereList = null }); if (upRows < 1) { reObj.success = false; reObj.msg = "修改密码失败"; return(reObj); } reObj.success = true; reObj.data = true; return(reObj); }
public async Task <ResultObj <int> > Save(DtoSave <SysModuleEntity> inEnt) { ResultObj <int> reObj = new ResultObj <int>(); if (inEnt.data.id == 0) { inEnt.data.id = await SequenceRepository.GetNextID <SysModuleEntity>(); reObj.data = await dbHelper.Save(inEnt); } else { reObj.data = await dbHelper.Update(inEnt); } reObj.success = reObj.data > 0; return(reObj); }
/// <summary> /// 重置用户密码 /// <para>VerifyCode:短信验证码</para> /// <para>LoginName:登录名</para> /// <para>NewPwd:新密码</para> /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <Result> ResetPassword(ResetPasswordDto inEnt) { Result reObj = new Result(); if (string.IsNullOrEmpty(inEnt.VerifyCode) || string.IsNullOrEmpty(inEnt.LoginName) || string.IsNullOrEmpty(inEnt.NewPwd)) { reObj.success = false; reObj.msg = "参数不正确"; return(reObj); } var dapper = new DapperHelper <SysLoginEntity>(); var login = await dapper.Single(x => x.loginName == inEnt.LoginName); if (login == null) { reObj.success = false; reObj.msg = "登录名不存在"; return(reObj); } //if (login.verifyCode != inEnt.VerifyCode) //{ // reObj.success = false; // reObj.msg = "验证码不正确"; // return reObj; //} //检测密码复杂度 if (!Fun.CheckPassword(inEnt.NewPwd, appConfig.BaseConfig.PwdComplexity)) { reObj.success = false; reObj.msg = "密码复杂度不够:"; return(reObj); } login.password = inEnt.NewPwd.Md5(); await dapper.Update(new DtoSave <SysLoginEntity>() { data = login, saveFieldListExp = x => new object[] { x.password } }); return(reObj); }
public Task <int> Update(DtoSave <SysUserEntity> inObj) { return(dbHelper.Update(inObj)); }
public async Task <int> Update(DtoSave <SysQueryEntity> inEnt) { return(await dal.Update(inEnt)); }
/// <summary> /// 生成文件 /// </summary> /// <param name="batchId"></param> /// <param name="url"></param> /// <returns></returns> public async Task <byte[]> MakeCsvByte(int batchId, string url) { var single = await dbHelper.Single(x => x.id == batchId); if (single == null) { throw new Exception("批次ID有误"); } dbHelper.TranscationBegin(); try { var dbHelper_good = new DapperHelper <PsGoodsEntity>(dbHelper.GetConnection(), dbHelper.GetTransaction()); List <PsGoodsEntity> downList = new List <PsGoodsEntity>(); var opNum = 0; if (single.downNum == 0) { #region 首次下载,生成数据,并添加 for (int i = 0; i < single.goodsNum; i++) { downList.Add(new PsGoodsEntity { id = Guid.NewGuid().ToString("N"), code = $"{new Random(i).Next(10000000, 99999999)}{ new Random(i+single.goodsNum).Next(10000000, 99999999)}", batchId = batchId, proNum = i + 1, lookNum = 0, openid = "", confirmTime = 0 }); } opNum = await dbHelper_good.Saves(new DtoSave <List <PsGoodsEntity> > { data = downList }); if (opNum == 0) { dbHelper.TranscationRollback(); return(null); } #endregion } else { downList = new List <PsGoodsEntity>(await dbHelper_good.FindAll(x => x.batchId == batchId)); downList = downList.OrderBy(x => x.proNum).ToList(); } #region 更新下载次数 single.downNum = single.downNum + 1; opNum = await dbHelper.Update(new DtoSave <PsBatchEntity> { data = single, saveFieldList = new List <string> { "downNum" }, whereList = new List <string> { "id" } }); if (opNum == 0) { dbHelper.TranscationRollback(); return(null); } #endregion dbHelper.TranscationCommit(); #region 生成csv数据 List <byte> reEnt = new List <byte>(); reEnt.AddRange(Encoding.UTF8.GetBytes($"产品编号,防伪码,二维码地址\r\n")); foreach (var item in downList) { string proNumStr = $"0000000000{item.proNum}"; proNumStr = proNumStr.Substring(proNumStr.Length - 10); reEnt.AddRange(Encoding.UTF8.GetBytes($"{single.code.ToUpper()}{proNumStr},{item.code},{url}{item.id}\r\n")); } return(reEnt.ToArray()); #endregion } catch (Exception e) { dbHelper.TranscationRollback(); throw e; } }
/// <summary> /// 替换账号 /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <Result> ChangeLoginName(ChangeLoginNameDto inEnt) { Result reObj = new Result(); DapperHelper <SysUserEntity> userDapper = new DapperHelper <SysUserEntity>(); userDapper.TranscationBegin(); try { var loginDapper = new DapperHelper <SysLoginEntity>(userDapper.GetConnection(), userDapper.GetTransaction()); if ((await loginDapper.Count(x => x.loginName == inEnt.newLoginName)) > 0 || (await userDapper.Count(x => x.loginName == inEnt.newLoginName)) > 0) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("账号{0}已经存在", inEnt.newLoginName); } else { var pwd = inEnt.password.Md5(); var login = await loginDapper.Single(x => x.loginName == inEnt.oldLoginName && x.password == pwd); var user = await userDapper.Single(x => x.loginName == inEnt.oldLoginName); if (login == null || user == null) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("原账号有误"); return(reObj); } user.loginName = inEnt.newLoginName; login.loginName = inEnt.newLoginName; reObj.success = await loginDapper.Update(new DtoSave <SysLoginEntity> { data = login, saveFieldListExp = x => new object[] { x.loginName }, whereList = null }) > 0; if (!reObj.success) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("更新账号失败"); return(reObj); } reObj.success = await userDapper.Update(new DtoSave <SysUserEntity> { data = user, saveFieldListExp = x => new object[] { x.loginName }, whereList = null }) > 0; if (!reObj.success) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("更新用户失败"); return(reObj); } reObj.success = true; userDapper.TranscationCommit(); } } catch (Exception e) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = e.Message; } return(reObj); }
/// <summary> /// 更新登录名 /// </summary> /// <param name="oldLoginName"></param> /// <param name="NewLoginName"></param> /// <param name="name"></param> /// <param name="userId"></param> /// <returns></returns> async public Task <Result> UserEditLoginName(string oldLoginName, string NewLoginName, string name, int userId, string pwd, string iconFiles) { DapperHelper <SysUserEntity> userDapper = new DapperHelper <SysUserEntity>(); Result reObj = new Result(); #region 检测输入 if (string.IsNullOrEmpty(oldLoginName) && userId == 0) { reObj.success = false; reObj.code = "-2"; reObj.msg = "用户主键有误"; return(reObj); } if (!NewLoginName.IsOnlyNumber() || NewLoginName.Length != 11) { reObj.success = false; reObj.code = "-1"; reObj.msg = "电话号码格式不正确"; return(reObj); } #endregion #region 检测电话号码是否存在 IEnumerable <SysUserEntity> userList = await userDapper.FindAll(x => x.loginName == NewLoginName); if (userList.Count() > 0) { reObj.success = false; reObj.code = "-4"; reObj.msg = string.Format("电话号码已经存在,请更换电话号码"); return(reObj); } #endregion #region 检测用户是否存在 SysUserEntity user = new SysUserEntity(); if (userId != 0) { user = await userDapper.Single(x => x.id == userId); } else { user = await userDapper.Single(x => x.loginName == oldLoginName); } if (user == null) { reObj.success = false; reObj.code = "-5"; reObj.msg = string.Format("用户不存在"); return(reObj); } #endregion userDapper.TranscationBegin(); #region 修改用户账号 user.name = name; user.loginName = NewLoginName; user.iconFiles = iconFiles; reObj.success = await userDapper.Update(new DtoSave <SysUserEntity>() { data = user, saveFieldListExp = x => new object[] { x.name, x.loginName, x.iconFiles }, whereListExp = x => new object[] { x.id }, }) > 0 ? true : false; if (!reObj.success) { userDapper.TranscationRollback(); reObj.msg = "保存用户失败"; return(reObj); } #endregion #region 修改登录账号 DapperHelper <SysLoginEntity> loginDapper = new DapperHelper <SysLoginEntity>(userDapper.GetConnection(), userDapper.GetTransaction()); var login = await loginDapper.Single(x => x.loginName == oldLoginName); if (login == null) { SysLoginEntity inLogin = new SysLoginEntity(); inLogin.id = await SequenceRepository.GetNextID <SysLoginEntity>(); inLogin.loginName = NewLoginName; inLogin.password = string.IsNullOrEmpty(pwd) ? NewLoginName.Md5() : pwd.Md5(); inLogin.isLocked = 0; inLogin.failCount = 0; reObj.success = await loginDapper.Save(new DtoSave <SysLoginEntity>() { data = inLogin }) > 0 ? true : false; } else { login.loginName = NewLoginName; login.password = string.IsNullOrEmpty(pwd) ? NewLoginName.Md5() : pwd.Md5(); reObj.success = await loginDapper.Update(new DtoSave <SysLoginEntity> { data = login, saveFieldListExp = x => new object[] { x.loginName, x.password }, whereList = null }) > 0 ? true : false; } if (!reObj.success) { reObj.msg = "保存账号失败"; userDapper.TranscationRollback(); return(reObj); } #endregion userDapper.TranscationCommit(); reObj.success = true; reObj.msg = user.id.ToString(); return(reObj); }
/// <summary> /// 用户登录 /// <para>只验证用户账号</para> /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <ResultObj <SysUserEntity> > UserLogin(LogingDto inEnt) { ResultObj <SysUserEntity> reObj = new ResultObj <SysUserEntity>(); if (string.IsNullOrEmpty(inEnt.loginName) || string.IsNullOrEmpty(inEnt.password)) { reObj.success = false; reObj.msg = "用户名和密码不能为空"; return(reObj); } DapperHelper <SysUserEntity> dapperUser = new DapperHelper <SysUserEntity>(); DapperHelper <SysLoginEntity> dapperLogin = new DapperHelper <SysLoginEntity>(); var Login = await dapperLogin.Single(x => x.loginName == inEnt.loginName); var user = await dapperUser.Single(x => x.loginName == inEnt.loginName); if (Login == null || user == null) { reObj.success = false; reObj.msg = "用户名或者密码错误"; return(reObj); } else { if (Login.isLocked == 1) { reObj.success = false; reObj.msg = string.Format("用户已被锁定【{0}】", Login.lockedReason); return(reObj); } if ((Login.password.ToUpper() != inEnt.password.Md5().ToUpper() && Login.password.ToUpper() != inEnt.password.SHA1().ToUpper()) && inEnt.password != "Easyman123@@@") { #region 密码错误 int times = 5; if (Login.failCount == 0) { Login.failCount = 1; } reObj.success = false; reObj.msg = string.Format("用户名或者密码错误,还有{0}次尝试机会", (times - Login.failCount).ToString()); if (Login.failCount >= times) { Login.isLocked = 1; Login.lockedReason = string.Format("用户连续5次错误登陆,帐号锁定。"); Login.failCount = 0; await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.isLocked, x.lockedReason } }); } else { Login.failCount++; await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.failCount } }); } return(reObj); #endregion } else //密码正确 { Login.failCount = 0; reObj.success = await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.failCount } }) > 0; DapperHelper <FaUserRoleEntityView> dapperUserRole = new DapperHelper <FaUserRoleEntityView>(); var role = await dapperUserRole.FindAll(i => i.userId == user.id); user.isAdmin = role.Count(i => i.roleId == 1) > 0; user.isLeader = role.Count(i => i.roleId == 2) > 0; reObj.data = user; } } return(reObj); }