/// <summary>
/// 导出
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DataTable GetExportList(SafeCheckRequest request)
{
#region 模糊搜索条件
var where = new Where <TbSafeCheck>();
if (!string.IsNullOrWhiteSpace(request.CheckType))
{
where.And(d => d.CheckType == request.CheckType);
}
if (!string.IsNullOrWhiteSpace(request.SafeCheckCode))
{
where.And(d => d.SafeCheckCode.Like(request.SafeCheckCode));
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(d => d.ProcessFactoryCode == request.ProcessFactoryCode);
}
if (request.CheckTimeS.HasValue)
{
where.And(d => d.CheckTime >= request.CheckTimeS);
}
if (request.CheckTimeE.HasValue)
{
where.And(d => d.CheckTime <= request.CheckTimeE);
}
#endregion
try
{
var data = Db.Context.From <TbSafeCheck>()
.Select(
TbSafeCheck._.ID
, TbSafeCheck._.Examinestatus
, TbSafeCheck._.SafeCheckCode
, TbSafeCheck._.PartInUsers
, TbSafeCheck._.CheckTime
, TbSafeCheck._.Remark
, TbSafeCheck._.InsertUserCode
, TbSafeCheck._.InsertTime
, TbUser._.UserName
, TbCompany._.CompanyFullName.As("ProcessFactoryName")
, TbSysDictionaryData._.DictionaryText.As("CheckTypeName"))
.AddSelect(Db.Context.From <TbUser>()
.Select(p => p.UserName)
.Where(TbUser._.UserCode == TbSafeCheck._.CheckUser), "CheckUserName")
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.LeftJoin <TbSysDictionaryData>((a, c) => a.CheckType == c.DictionaryCode)
.Where(where)
.OrderByDescending(p => p.ID).ToDataTable();
return(data);
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetGridJson([FromUri] SafeCheckRequest request)
{
try
{
var data = _safeCheck.GetDataListForPage(request);
return(AjaxResult.Success(data).ToJsonApi());
}
catch (Exception)
{
return(AjaxResult.Error("操作失败").ToJsonApi());
}
}
/// <summary>
/// 获取数据列表(明细)
/// </summary>
public DataTable GetSafeCheckItemDataList(SafeCheckRequest request)
{
var where = new Where <TbSysDictionaryData>();
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where.And(d => d.DictionaryText.Like(request.keyword) || d.DictionaryOrder.Like(request.keyword));
}
where.And(p => p.FDictionaryCode == "SafeCheckItem");
try
{
var data = Db.Context.From <TbSysDictionaryData>()
.Select(
TbSysDictionaryData._.id
, TbSysDictionaryData._.DictionaryCode.As("CheckItem")
, TbSysDictionaryData._.DictionaryText.As("Content"))
.Where(where)
.ToDataTable();
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取列表数据(明细)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetSafeCheckItemGridJson(SafeCheckRequest request)
{
var data = _safeCheck.GetSafeCheckItemDataList(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(SafeCheckRequest request)
{
var data = _safeCheck.GetDataListForPage(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(SafeCheckRequest request)
{
#region 模糊搜索条件
var where = new Where <TbSafeCheck>();
if (!string.IsNullOrWhiteSpace(request.CheckType))
{
where.And(d => d.CheckType == request.CheckType);
}
if (!string.IsNullOrWhiteSpace(request.SafeCheckCode))
{
where.And(d => d.SafeCheckCode.Like(request.SafeCheckCode));
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(d => d.ProcessFactoryCode == request.ProcessFactoryCode);
}
if (request.CheckTimeS.HasValue)
{
where.And(d => d.CheckTime >= request.CheckTimeS);
}
if (request.CheckTimeE.HasValue)
{
where.And(d => d.CheckTime <= request.CheckTimeE);
}
#endregion
//#region 数据权限
////数据权限
//var authorizaModel = new AuthorizeLogic().CheckAuthoriza(new AuthorizationParameterModel() { FormCode = "SafeCheck",UserCode=request.UserCode });
//if (authorizaModel.IsAuthorize)
//{
// if (authorizaModel.Ids.Count > 0 && authorizaModel.UserCodes.Count > 0)
// where.And(d => d.InsertUserCode.In(authorizaModel.UserCodes) || d.ID.In(authorizaModel.Ids));
// else if (authorizaModel.Ids.Count > 0)
// where.Or(d => d.ID.In(authorizaModel.Ids));
// else if (authorizaModel.UserCodes.Count > 0)
// where.And(d => d.InsertUserCode.In(authorizaModel.UserCodes));
//}
//if (!string.IsNullOrEmpty(request.ProjectId))
// where.And(p => p.ProjectId == request.ProjectId);
//#endregion
try
{
var data = Db.Context.From <TbSafeCheck>()
.Select(
TbSafeCheck._.ID
, TbSafeCheck._.Examinestatus
, TbSafeCheck._.SafeCheckCode
, TbSafeCheck._.PartInUsers
, TbSafeCheck._.CheckTime
, TbSafeCheck._.Remark
, TbSafeCheck._.InsertUserCode
, TbSafeCheck._.InsertTime
, TbUser._.UserName
, TbCompany._.CompanyFullName.As("ProcessFactoryName")
, TbSysDictionaryData._.DictionaryText.As("CheckTypeName"))
.AddSelect(Db.Context.From <TbUser>()
.Select(p => p.UserName)
.Where(TbUser._.UserCode == TbSafeCheck._.CheckUser), "CheckUserName")
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.LeftJoin <TbSysDictionaryData>((a, c) => a.CheckType == c.DictionaryCode)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
