/// <summary>
/// 获取仓库编码
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public string GetMaxID(int UserID)
{
var curentDB = _db.Instance;
var smUserInfo = SMCurentUserManager.GetCurentUserID(UserID, curentDB);
var result = curentDB.Queryable <TBMWarehouseFileDbModel>().Where(p => p.CompanyId == smUserInfo.CompanyId).Max(p => p.Code);
int resultInt = Convert.ToInt32(result) + 1;
return(resultInt.ToString().PadLeft(4, '0')); //不足6位 补H
}
/// <summary>
/// 企业设置
/// </summary>
/// <param name="requestObject"></param>
/// <param name="UserID"></param>
/// <returns></returns>
public async Task <ResponseObject <TSMCompanyAllEditModel, bool> > ModifyCurentCompany(RequestObject <TSMCompanyAllEditModel> requestObject, int UserID)
{
//执行结果
var result = false;
//没有修改信息，返回错误信息
if (requestObject.PostDataList == null && requestObject.PostData == null)
{
return(ResponseUtil <TSMCompanyAllEditModel, bool> .FailResult(requestObject, result, "PostData不能都为null"));
}
var curentDb = _db.Instance;
int id = requestObject.PostData.ID;
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(UserID, curentDb);
if (sMUserInfo.CompanyId != id)
{
return(ResponseUtil <TSMCompanyAllEditModel, bool> .FailResult(requestObject, result, "只能修改自己公司"));
}
var companyDb = curentDb.Queryable <TSMCompanyDbModel>().Where(p => p.ID == id).First();
if (companyDb.AdminId != UserID)
{
return(ResponseUtil <TSMCompanyAllEditModel, bool> .FailResult(requestObject, result, "您不是公司管理员"));
}
try
{
curentDb.BeginTran();
var curentData = requestObject.PostData;
var mainDb = ExpressionGenericMapper <TSMCompanyAllEditModel, TSMCompanyDbModel> .Trans(curentData);
await curentDb.Updateable <TSMCompanyDbModel>(mainDb).UpdateColumns(p => new { p.CompanyName, p.LegalPerson, p.ContactNumber, p.EnterpriseType }).ExecuteCommandAsync();
var cDb = ExpressionGenericMapper <TSMCompanyAllEditModel, TTenantsModel> .Trans(curentData);
cDb.ID = curentData.CId;
await curentDb.Updateable <TTenantsModel>(cDb).UpdateColumns(p => new { p.TenantShortName, p.TenantEngName, p.TenantLogo, p.BusinessLogo }).ExecuteCommandAsync();
curentDb.CommitTran();
return(ResponseUtil <TSMCompanyAllEditModel, bool> .SuccessResult(requestObject, true));
}
catch (Exception ex)
{
curentDb.RollbackTran();
return(ResponseUtil <TSMCompanyAllEditModel, bool> .FailResult(requestObject, result, ex.ToString()));
}
}
/// <summary>
/// 根据用户ID获取账户信息
/// </summary>
/// <param name="iUserId"></param>
/// <returns></returns>
public ResponseObject <int, UserInfo> GetInfo(int iUserId)
{
try
{
UserInfo userModel = new UserInfo();
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(iUserId, _db.Instance);
if (sMUserInfo == null)
{
return(ResponseUtil <int, UserInfo> .FailResult(new RequestObject <int>(), null, "未找到该用户信息"));
}
userModel.Roles = sMUserInfo.RoleName;
userModel.Name = sMUserInfo.AccountName;
RequestObject <TRolePermissionsModel> roleQuery = new RequestObject <TRolePermissionsModel>()
{
IsPaging = false, QueryConditions = new List <QueryCondition>()
};
roleQuery.QueryConditions.Add(new QueryCondition()
{
Column = "roleID", Content = userModel.RoleId.ToString(), Condition = ConditionEnum.Equal
});
userModel.Permissions = LoadMenuByRoles(sMUserInfo.UserID, sMUserInfo.CompanyId.Value);
var company = _db.Instance.Queryable <TSMCompanyDbModel, TTenantsModel>(
(t1, t2) => new object[]
{
JoinType.Left, t1.CompanyInfoId == t2.ID
}).Where((t1, t2) => t1.ID == sMUserInfo.CompanyId).Select((t1, t2) => new { t1.CompanyName, t2.TenantLogo, t2.TenantEngName }).First();
if (company != null)
{
userModel.CompanyID = sMUserInfo.CompanyId.Value;
userModel.TenantLogo = company.TenantLogo;
userModel.CompanyName = company.CompanyName;
userModel.TenantEngName = company.TenantEngName;
}
var userInfo = _db.Instance.Queryable <TSMUserAccountDbModel, TSMUserInfoDbModel>((t, t1) => new object[] {
JoinType.Inner, t.UserInfoId == t1.ID
}).Where((t, t1) => t.ID == iUserId).Select((t, t1) => new { main = t, deatail = t1 }).First();
userModel.Avatar = userInfo.deatail.HeadPicPath;
return(ResponseUtil <int, UserInfo> .SuccessResult(new RequestObject <int>(), userModel));
}
catch (Exception ex)
{
return(ResponseUtil <int, UserInfo> .FailResult(new RequestObject <int>(), null, $"获取权限发生异常{Environment.NewLine} {ex.Message}"));
}
}
/// <summary>
/// 修改T_BM_WarehouseFile数据
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，修改操作结果</param>
/// <param name="userID"></param>
/// <returns></returns>
public async Task <ResponseObject <TBMWarehouseFileEditModel, bool> > PutAsync(RequestObject <TBMWarehouseFileEditModel> requestObject, int userID)
{
try
{
var curentDB = _db.Instance;
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(userID, curentDB);
//执行结果
var result = false;
//没有修改信息，返回错误信息
if (requestObject.PostDataList == null && requestObject.PostData == null)
{
return(ResponseUtil <TBMWarehouseFileEditModel, bool> .FailResult(requestObject, false, "PostData不能都为null"));
}
//批量更新优先级高于单记录更新
if (requestObject.PostDataList != null && requestObject.PostDataList.Count > 0)
{
//批量更新
var editList = _mapper.Map <List <TBMWarehouseFileEditModel>, List <TBMWarehouseFileDbModel> >(requestObject.PostDataList);
result = await _db.Instance.Updateable <TBMWarehouseFileDbModel>(editList).IgnoreColumns(p => new { p.DeleteFlag, p.Code, p.CompanyId }).ExecuteCommandAsync() > 0;
}
else
{
//单记录更新
var editModel = _mapper.Map <TBMWarehouseFileDbModel>(requestObject.PostData);
var oldModel = _db.Instance.Queryable <TBMWarehouseFileDbModel>().Where(p => SqlFunc.IsNull(p.DeleteFlag, false) == false &&
p.WarehouseName == editModel.WarehouseName &&
p.CompanyId == sMUserInfo.CompanyId.Value &&
p.ID != editModel.ID
).First();
if (oldModel != null)
{
return(ResponseUtil <TBMWarehouseFileEditModel, bool> .FailResult(requestObject, false, editModel.WarehouseName + " 已经存在"));
}
result = await _db.Instance.Updateable(editModel).IgnoreColumns(p => new { p.DeleteFlag, p.Code, p.CompanyId }).ExecuteCommandAsync() > 0;
}
//返回执行结果
if (result)
{
return(ResponseUtil <TBMWarehouseFileEditModel, bool> .SuccessResult(requestObject, true));
}
return(ResponseUtil <TBMWarehouseFileEditModel, bool> .FailResult(requestObject, false, "修改数据失败!"));
}
catch (Exception ex)
{
//返回异常结果
return(ResponseUtil <TBMWarehouseFileEditModel, bool> .FailResult(requestObject, false, ex.Message));
}
}
/// <summary>
/// 获取企业信息
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public async Task <ResponseObject <int, TSMCompanyQueryAllModel> > PersonalGet(int UserID)
{
RequestObject <int> request = new RequestObject <int>();
TSMCompanyQueryAllModel result = null;
try
{
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(UserID, _db.Instance);
result = await _db.Instance.Queryable <TSMCompanyDbModel, TTenantsModel>(
(t1, t2) => new object[]
{
JoinType.Left, t1.CompanyInfoId == t2.ID
}).Where((t1, t2) => t1.ID == sMUserInfo.CompanyId).Select((t1, t2) =>
new TSMCompanyQueryAllModel
{
ID = t1.ID,
CompanyName = t1.CompanyName,
LegalPerson = t1.LegalPerson,
ContactNumber = t1.ContactNumber,
ContactEmail = t1.ContactEmail,
CompanyInfoId = t1.CompanyInfoId,
CId = t2.ID,
TenantShortName = t2.TenantShortName,
TenantEngName = t2.TenantEngName,
IsTrial = t2.IsTrial,
TrialDate = t2.TrialDate,
TemplateId = t2.TemplateId,
ValidityPeriod = t2.ValidityPeriod,
Area = t2.Area,
Industry = t2.Industry,
TenantScale = t2.TenantScale,
RegisteredCapital = t2.RegisteredCapital,
MainBusiness = t2.MainBusiness,
FixedTele = t2.FixedTele,
Address = t2.Address,
TenantLogo = t2.TenantLogo,
BusinessLogo = t2.BusinessLogo,
IsAdmin = t1.AdminId == UserID ? true : false
}).FirstAsync();
return(ResponseUtil <int, TSMCompanyQueryAllModel> .SuccessResult(request, result));
}
catch (Exception ex)
{
return(ResponseUtil <int, TSMCompanyQueryAllModel> .FailResult(request, result, ex.Message));
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="requestObject"></param>
/// <param name="iUserId"></param>
/// <returns></returns>
private async Task <ResponseObject <T, bool> > DeleteAsync <T>(RequestObject <T> requestObject, int iUserId)
{
try
{
//删除主表信息
var companyId = SMCurentUserManager.GetCurentUserID(iUserId, _db.Instance)?.CompanyId;
var result = await _db.Instance.Deleteable <TSMRolePermissionsDbModel>()
.Where(p => p.CompanyId == companyId && p.RoleId == Convert.ToInt32(requestObject.PostData)).ExecuteCommandAsync() > 0;
//返回执行结果
if (result)
{
return(ResponseUtil <T, bool> .SuccessResult(requestObject, true));
}
return(ResponseUtil <T, bool> .FailResult(requestObject, false, "删除数据失败!"));
}
catch (Exception ex)
{
//返回异常结果
return(ResponseUtil <T, bool> .FailResult(requestObject, false, ex.Message));
}
}
public async Task <ResponseObject <TSMUserLoginResult> > LoginPost(RequestPost <TSMUserAccountAddModel> requestObject)
{
ResponseObject <TSMUserLoginResult> result;
result = await _service.LoginAsync(requestObject);
var task = Task.Factory.StartNew(() =>
{
try
{
bool isSucess = string.IsNullOrEmpty(result.Data.Token) ? false : true;
if (isSucess == true)
{
string token = result.Data.Token.Split('.')[1];
var payLoad = JsonConvert.DeserializeObject <Dictionary <string, object> >(Base64UrlEncoder.Decode(token));
int userID = Convert.ToInt32(payLoad["UserID"]);
string ID = payLoad["ID"].ToString();
int CompanyID = Convert.ToInt32(payLoad["CompanyID"]);
if (CompanyID == 0) //没有加入公司的员工不保存登陆日志
{
return;
}
//写 登陆状态到redis
var redis = CacheFactory.Instance(CacheType.Redis);
UserStatus userStatus = new UserStatus()
{
ID = ID, LastRefreshTime = DateTime.Now
};
string redisKey = string.Format(CacheKeyString.UserLoginAllKey, userID, CompanyID, ID);
redis.AddOrUpdateKey <UserStatus>(redisKey, userStatus, 90);
//写登陆日志到 MangoDB
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(userID, _db.Instance);
string ipAddress = Request.HttpContext.Connection.RemoteIpAddress.ToString();
LoginLog loginLog = new LoginLog();
loginLog.LoginID = ID;
loginLog.Account = sMUserInfo.AccountName;
loginLog.CompanyID = sMUserInfo.CompanyId.Value;
loginLog.Description = isSucess ? LoginTypeEum.LoginSuccess : LoginTypeEum.LoginFail;
loginLog.IpAddress = ipAddress;
loginLog.LoginTime = DateTime.Now;
loginLog.RealName = sMUserInfo == null ? "" : sMUserInfo.RealName;
loginLog.RoleName = sMUserInfo == null ? "" : sMUserInfo.RoleName;
loginLog.Status = isSucess ? LoginStatusEum.Logining : LoginStatusEum.LogOut;
MongoDbUtil.AddDoc(loginLog);
}
else
{
//LoginLog loginLog = new LoginLog();
//loginLog.ID = Guid.NewGuid().ToString();
//loginLog.Account = sMUserInfo.AccountName;
//loginLog.CompanyID = sMUserInfo.CompanyId.Value;
//loginLog.Description = isSucess ? LoginTypeEum.LoginSuccess : LoginTypeEum.LoginFail;
//loginLog.IpAddress = ipAddress;
//loginLog.LoginTime = DateTime.Now;
//loginLog.RealName = sMUserInfo?.RealName;
//loginLog.RoleName = sMUserInfo?.RoleName;
//loginLog.Status = isSucess ? LoginStatusEum.Logining : LoginStatusEum.LogOut;
//MongoDbUtil.AddDoc(loginLog);
}
}
catch (Exception EX)
{
}
});
return(result);
}
/// <summary>
/// 获取获取部门下的员工
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，查询操作结果</param>
/// <param name="UserID">用户ID</param>
/// <returns></returns>
public async Task <ResponseObject <TSMDeptQueryForDispatchModel, List <TSMUserAccountQueryAllModel> > > GetDispathUserAsync(RequestObject <TSMDeptQueryForDispatchModel> requestObject, int UserID)
{
try
{
List <TSMUserAccountQueryAllModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var condition = requestObject.QueryConditions.Where(p => p.Column.ToLower() == "deptid").FirstOrDefault();
if (condition == null)
{
return(ResponseUtil <TSMDeptQueryForDispatchModel, List <TSMUserAccountQueryAllModel> > .FailResult(requestObject, null, "deptid不能为空"));
}
int companyID = SMCurentUserManager.GetCurentUserID(UserID, _db.Instance).CompanyId.Value;
var mainDept = _db.Instance.Queryable <TSMDeptDbModel>().Where(p => p.Id.ToString() == condition.Content).First();
var query = _db.Instance.Queryable <TSMUserAccountDbModel, TSMUserInfoDbModel, TSMDeptUserRelationDbModel, TSMDeptDbModel>(
(t1, t2, t3, t4) => new object[]
{
JoinType.Inner, t1.UserInfoId == t2.ID,
JoinType.Left, t1.ID == t3.UserAccountId,
JoinType.Left, t3.DeptId == t4.Id
}).Where((t1, t2, t3, t4) => t1.CompanyId == companyID);
if (mainDept != null)
{
query = query.Where((t1, t2, t3, t4) => t4.PathLogic.StartsWith(mainDept.PathLogic));
}
if (condition.Content == "-100")
{
query = query.Where((t1, t2, t3, t4) => t3.Id == null);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TSMDeptDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
if (requestObject.IsPaging)
{
queryData = await query.Select((t1, t2, t3, t4) => new TSMUserAccountQueryAllModel
{
ID = t1.ID,
TelAccount = t1.TelAccount,
EmailAccount = t1.EmailAccount,
AccountName = t1.AccountName,
UserInfoId = t1.UserInfoId,
CompanyId = t1.CompanyId,
Status = t1.Status,
ExpDate = t1.ExpDate,
CreateTime = t1.CreateTime,
CId = t2.ID,
JobNumber = t2.JobNumber,
RealName = t2.RealName,
FixedNumber = t2.FixedNumber,
Address = t2.Address,
HeadPicPath = t2.HeadPicPath,
Remarks = t2.Remarks,
}).ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select((t1, t2, t3, t4) => new TSMUserAccountQueryAllModel
{
ID = t1.ID,
TelAccount = t1.TelAccount,
EmailAccount = t1.EmailAccount,
AccountName = t1.AccountName,
UserInfoId = t1.UserInfoId,
CompanyId = t1.CompanyId,
Status = t1.Status,
ExpDate = t1.ExpDate,
CreateTime = t1.CreateTime,
CId = t2.ID,
JobNumber = t2.JobNumber,
RealName = t2.RealName,
FixedNumber = t2.FixedNumber,
Address = t2.Address,
HeadPicPath = t2.HeadPicPath,
Remarks = t2.Remarks,
}).ToListAsync();
}
//返回执行结果
return(ResponseUtil <TSMDeptQueryForDispatchModel, List <TSMUserAccountQueryAllModel> > .SuccessResult(requestObject, queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <TSMDeptQueryForDispatchModel, List <TSMUserAccountQueryAllModel> > .FailResult(requestObject, null, ex.Message));
}
}
/// <summary>
/// 获取T_BM_WarehouseFile数据
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，查询操作结果</param>
/// <returns></returns>
public async Task <ResponseObject <TBMWarehouseFileQueryModel, List <TBMWarehouseFileQueryModel> > > GetAsync(RequestObject <TBMWarehouseFileQueryModel> requestObject, int UserID)
{
try
{
var curentDB = _db.Instance;
var smUserInfo = SMCurentUserManager.GetCurentUserID(UserID, curentDB);
List <TBMWarehouseFileQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = curentDB.Queryable <TBMWarehouseFileDbModel, TSMUserAccountDbModel, TSMUserInfoDbModel>(
(t, t0, t1) => new object[]
{
JoinType.Left, t.PrincipalId == t0.ID,
JoinType.Left, t0.UserInfoId == t1.ID
}).Where((t, t0, t1) => SqlFunc.IsNull(t.DeleteFlag, false) != true && t.CompanyId == smUserInfo.CompanyId);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TBMWarehouseFileDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select((t, t0, t1) => new TBMWarehouseFileQueryModel
{
ID = t.ID,
Code = t.Code,
WarehouseName = t.WarehouseName,
WarehouseAddress = t.WarehouseAddress,
PrincipalId = t.PrincipalId,
RealName = t.PrincipalId == null ? "" : t0.AccountName,
Status = t.Status,
Remark = t.Remark,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select((t, t0, t1) => new TBMWarehouseFileQueryModel
{
ID = t.ID,
Code = t.Code,
WarehouseName = t.WarehouseName,
WarehouseAddress = t.WarehouseAddress,
PrincipalId = t.PrincipalId,
RealName = t.PrincipalId == null ? "" : t0.AccountName,
Status = t.Status,
Remark = t.Remark,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <TBMWarehouseFileQueryModel, List <TBMWarehouseFileQueryModel> > .SuccessResult(requestObject, queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <TBMWarehouseFileQueryModel, List <TBMWarehouseFileQueryModel> > .FailResult(requestObject, null, ex.Message));
}
}
/// <summary>
/// 新增T_BM_WarehouseFile数据
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，新增操作结果</param>
/// <param name="UserID">操作人ID</param>
/// <returns></returns>
public async Task <ResponseObject <TBMWarehouseFileAddModel, bool> > PostAsync(RequestObject <TBMWarehouseFileAddModel> requestObject, int UserID)
{
try
{
var curentDB = _db.Instance;
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(UserID, curentDB);
//如果没有新增数据，返回错误信息
if (requestObject.PostData == null && requestObject.PostDataList == null)
{
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .FailResult(requestObject, false, "PostData,PostDataList不能都为null"));
}
var result = false;
//批量新增的优先级高于单条数据新增，且只会执行一个新增操作
if (requestObject.PostDataList != null && requestObject.PostDataList.Count > 0)
{
var addList = _mapper.Map <List <TBMWarehouseFileAddModel>, List <TBMWarehouseFileDbModel> >(requestObject.PostDataList);
foreach (var item in addList)
{
item.CompanyId = sMUserInfo.CompanyId.Value;
}
result = await curentDB.Insertable(addList).ExecuteCommandAsync() > 0;
}
else
{
var addModel = _mapper.Map <TBMWarehouseFileDbModel>(requestObject.PostData);
addModel.CompanyId = sMUserInfo.CompanyId.Value;
addModel.DeleteFlag = false;
var oldModel = curentDB.Queryable <TBMWarehouseFileDbModel>().Where(p => SqlFunc.IsNull(p.DeleteFlag, false) == false && p.WarehouseName == addModel.WarehouseName &&
p.CompanyId == sMUserInfo.CompanyId.Value).First();
if (oldModel != null)
{
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .FailResult(requestObject, false, addModel.WarehouseName + " 已经存在"));
}
var oldModelCode = curentDB.Queryable <TBMWarehouseFileDbModel>().Where(p => SqlFunc.IsNull(p.DeleteFlag, false) == false && p.Code == addModel.Code &&
p.CompanyId == sMUserInfo.CompanyId.Value).First();
if (oldModelCode != null)
{
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .FailResult(requestObject, false, "编号:" + addModel.Code + " 已经存在"));
}
addModel.CompanyId = sMUserInfo.CompanyId.Value;
result = await _db.Instance.Insertable(addModel).ExecuteCommandAsync() > 0;
}
//返回执行结果
if (result)
{
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .SuccessResult(requestObject, true));
}
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .FailResult(requestObject, false, "新增数据失败!"));
}
catch (Exception ex)
{
//返回异常结果
return(ResponseUtil <TBMWarehouseFileAddModel, bool> .FailResult(requestObject, false, ex.Message));
}
}
/// <summary>
/// 查询日志
/// </summary>
/// <param name="requestObject"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public ResponseObject <LogQueryModel, List <OperateLog> > Get(RequestObject <LogQueryModel> requestObject, int UserId)
{
try
{
long totalNum = -1;
SMUserInfo sMUserInfo = SMCurentUserManager.GetCurentUserID(UserId, _db.Instance);
List <OperateLog> result = new List <OperateLog>();
Expression <Func <OperateLog, bool> > pression = p => p.CompanyID == sMUserInfo.CompanyId.Value;
var queryEntiy = requestObject.PostData;
if (queryEntiy != null)
{
if (!string.IsNullOrEmpty(queryEntiy.Account))
{
pression = pression.And(p => p.Account.Contains(queryEntiy.Account));
}
if (!string.IsNullOrEmpty(queryEntiy.Path))
{
pression = pression.And(p => p.Path.Contains(queryEntiy.Path));
}
if (!string.IsNullOrEmpty(queryEntiy.RealName))
{
pression = pression.And(p => p.RealName.Contains(queryEntiy.RealName));
}
if (!string.IsNullOrEmpty(queryEntiy.IpAddress))
{
pression = pression.And(p => p.IpAddress == queryEntiy.IpAddress);
}
if (queryEntiy.CreateTimeBg != null)
{
pression = pression.And(p => p.CreateTime >= queryEntiy.CreateTimeBg.Value);
}
if (queryEntiy.CreateTimeEd != null)
{
DateTime eg = queryEntiy.CreateTimeEd.Value.AddDays(1);
pression = pression.And(p => p.CreateTime < eg);
}
}
var sort = Builders <OperateLog> .Sort.Descending(y => y.CreateTime);
if (requestObject.IsPaging == true)
{
result = MongoDbUtil.GetDoc <OperateLog>(pression, requestObject.PageIndex, requestObject.PageSize, sort, ref totalNum);
}
else
{
result = MongoDbUtil.GetDoc <OperateLog>(pression, sort).ToList();
}
return(ResponseUtil <LogQueryModel, List <OperateLog> > .SuccessResult(requestObject, result, totalNum));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <LogQueryModel, List <OperateLog> > .FailResult(requestObject, null, ex.Message));
}
}
/// <summary>
/// 获取T_BM_DictionaryType数据
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，查询操作结果</param>
/// <param name="UserID"></param>
/// <returns></returns>
public async Task <ResponseObject <TBMDictionaryTypeQueryModel, List <TBMDictionaryTypeQueryModel> > > GetAsync(RequestObject <TBMDictionaryTypeQueryModel> requestObject, int UserID)
{
try
{
var curentDB = _db.Instance;
var smUserInfo = SMCurentUserManager.GetCurentUserID(UserID, curentDB);
List <TBMDictionaryTypeQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = curentDB.Queryable <TBMDictionaryTypeDbModel>().Where(p => p.CompanyId == smUserInfo.CompanyId && SqlFunc.IsNull(p.DeleteFlag, false) == false);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TBMDictionaryTypeDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select(
(t) => new TBMDictionaryTypeQueryModel
{
ID = t.ID,
TypeName = t.TypeName,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select(
(t) => new TBMDictionaryTypeQueryModel
{
ID = t.ID,
TypeName = t.TypeName,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <TBMDictionaryTypeQueryModel, List <TBMDictionaryTypeQueryModel> > .SuccessResult(requestObject, queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <TBMDictionaryTypeQueryModel, List <TBMDictionaryTypeQueryModel> > .FailResult(requestObject, null, ex.Message));
}
}
