/// <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 <SysQueryEntity> inEnt)
{
ResultObj <int> reObj = new ResultObj <int>();
try
{
if (string.IsNullOrEmpty(inEnt.data.queryCfgJson))
{
inEnt.data.queryCfgJson = TypeChange.ObjectToStr((await _query.MakeQueryCfg(inEnt.data.code)).data);
}
if (string.IsNullOrEmpty(inEnt.data.rowsBtn))
{
inEnt.data.rowsBtn = @"
[{
""title"": ""修改"",
""class"": ""nb-edit"",
""readUrl"": ""user/*/singleByKey"",
""apiUrl"": ""user/*/save""
},
{
""title"": ""删除"",
""class"": ""nb-trash"",
""apiUrl"": ""user/*/delete"",
""confirmTip"": ""确定要删除吗？""
}
]";
}
if (string.IsNullOrEmpty(inEnt.data.heardBtn))
{
inEnt.data.heardBtn = @"
[{
""title"": ""添加"",
""class"": ""nb-plus"",
""click"": ""nowThis.Add('user/*/save')""
},
{
""title"": ""批量删除"",
""class"": ""ion-delete"",
""click"": ""nowThis.Exec('user/*/delete','id','删除要删除吗？')""
}
]
";
}
if (inEnt.data.id == 0)
{
reObj.data = await _query.Save(inEnt);
}
else
{
reObj.data = await _query.Update(inEnt);
}
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(typeof(QueryController), ex.ToString());
reObj.msg = ex.Message;
reObj.success = false;
}
return(reObj);
}
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);
}
public async Task <int> Save(DtoSave <SysQueryEntity> inEnt)
{
if (inEnt.data.id == 0)
{
inEnt.data.id = await SequenceRepository.GetNextID <SysQueryEntity>();
}
return(await dal.Save(inEnt));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="inEnt"></param>
/// <returns></returns>
public async Task <ResultObj <int> > Save(DtoSave <PsAdminEntity> inEnt)
{
var reObj = new ResultObj <int>();
inEnt.data.createTime = Helper.DataTimeHelper.getDateLong(DateTime.Now);
inEnt.data.id = await SequenceRepository.GetNextID <PsAdminEntity>();
reObj.data = await dbHelper.Save(inEnt);
reObj.success = reObj.data > 0;
return(reObj);
}
/// <summary>
/// 保存日志
/// </summary>
/// <param name="inObj"></param>
/// <returns></returns>
public async Task <ResultObj <int> > saveLog(WxQuestLogEntity inObj)
{
ResultObj <int> resultObj = new ResultObj <int>();
var saveEnt = new DtoSave <WxQuestLogEntity>()
{
data = inObj
};
saveEnt.data.id = await SequenceRepository.GetNextID <WxQuestLogEntity>();
resultObj.data = await dbHelper.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
{
reObj = await _respoitory.Save(inEnt);
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(typeof(QueryController), ex.ToString());
reObj.msg = ex.Message;
reObj.success = false;
}
return(reObj);
}
public async Task <ResultObj <int> > save(DtoSave <PsAdminEntity> inEnt)
{
ResultObj <int> reObj = new ResultObj <int>();
try
{
inEnt.data.userId = User.userId();
reObj = await _respoitory.Save(inEnt);
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(this.GetType(), ex.ToString());
reObj.msg = ex.Message;
reObj.success = false;
}
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);
}
public async Task <ResultObj <int> > Save(DtoSave <SysUserEntity> inEnt)
{
ResultObj <int> reObj = new ResultObj <int>();
try
{
if (inEnt.data.roleIdList == null)
{
inEnt.data.roleIdList = new List <int>();
}
dbHelper.TranscationBegin();
if (inEnt.data.id == 0)
{
DapperHelper <SysLoginEntity> dbHelperlog = new DapperHelper <SysLoginEntity>(dbHelper.GetConnection(), dbHelper.GetTransaction());
var addResult = await loginRepository.LoginReg(new LogingDto { loginName = inEnt.data.loginName, password = "******", userName = inEnt.data.name }, dbHelper, dbHelperlog);
if (!addResult.success)
{
return(addResult);
}
inEnt.data.id = addResult.data;
}
else
{
reObj.data = await dbHelper.Update(inEnt);
reObj.success = reObj.data > 0;
if (!reObj.success)
{
reObj.msg = "保存角色失败";
dbHelper.TranscationRollback();
return(reObj);
}
}
int v = await dbHelper.Exec("delete from sys_user_role where user_id = " + inEnt.data.id);
foreach (var item in inEnt.data.roleIdList)
{
var opNum = await dbHelper.Exec(string.Format("insert into sys_user_role(role_id,user_id) values({0},{1}) ", item, inEnt.data.id));
if (opNum != 1)
{
reObj.success = false;
reObj.msg = "保存用户模块失败";
dbHelper.TranscationRollback();
return(reObj);
}
}
reObj.success = true;
dbHelper.TranscationCommit();
}
catch (Exception e)
{
reObj.success = false;
reObj.msg = "保存用户失败";
LogHelper.WriteErrorLog(this.GetType(), reObj.msg, e);
dbHelper.TranscationRollback();
}
return(reObj);
}
public Task <int> Update(DtoSave <SysUserEntity> inObj)
{
return(dbHelper.Update(inObj));
}
/// <summary>
/// 保存操作记录
/// </summary>
/// <param name="inObj"></param>
/// <returns></returns>
public Task <int> Save(DtoSave <SysLoginHistoryEntity> inObj)
{
return(dbHelper.Save(inObj));
}
public async Task <int> Update(DtoSave <SysQueryEntity> inEnt)
{
return(await dal.Update(inEnt));
}
public Task <ResultObj <int> > Save(DtoSave <PsBatchEntity> inEnt)
{
return(_respoitory.Save(inEnt));
}
