/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(HoistingSafetyRequest request)
{
//组装查询语句
#region 模糊搜索条件
var where = new Where <TbHoistingSafety>();
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(p => p.ProcessFactoryCode == request.ProcessFactoryCode);
}
if (!string.IsNullOrWhiteSpace(request.SuperviseUser))
{
where.And(p => p.SuperviseUser.Like(request.SuperviseUser));
}
//if (!string.IsNullOrEmpty(request.ProjectId))
// where.And(p => p.ProjectId == request.ProjectId);
#endregion
try
{
var ret = Db.Context.From <TbHoistingSafety>()
.Select(
TbHoistingSafety._.All,
TbCompany._.CompanyFullName.As("ProcessFactoryName")
, TbSysDictionaryData._.DictionaryText.As("TzWorkZgzNew")
, TbUser._.UserName
, TbDataManage._.DataName.As("HoistFileName"))
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.LeftJoin <TbSysDictionaryData>((a, c) => a.TzWorkZgz == c.DictionaryCode && c.FDictionaryCode == "TzWorkZgz")
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbDataManage>((a, c) => a.HoistFileCode == c.FileCode && a.ProcessFactoryCode == c.ProcessFactoryCode)
.AddSelect(Db.Context.From <TbSysDictionaryData>().Select(p => p.DictionaryText)
.Where(TbSysDictionaryData._.DictionaryCode == TbHoistingSafety._.MechanicsIsNormal && TbSysDictionaryData._.FDictionaryCode == "MechanicsIsNormal"), "MechanicsIsNormalNew")
.AddSelect(Db.Context.From <TbSysDictionaryData>().Select(p => p.DictionaryText)
.Where(TbSysDictionaryData._.DictionaryCode == TbHoistingSafety._.KzIsSolid && TbSysDictionaryData._.FDictionaryCode == "KzIsSolid"), "KzIsSolidNew")
.AddSelect(Db.Context.From <TbSysDictionaryData>().Select(p => p.DictionaryText)
.Where(TbSysDictionaryData._.DictionaryCode == TbHoistingSafety._.IsProhibition && TbSysDictionaryData._.FDictionaryCode == "IsProhibition"), "IsProhibitionNew")
.AddSelect(Db.Context.From <TbUser>().Select(p => p.UserName)
.Where(TbUser._.UserCode == TbHoistingSafety._.SuperviseUser), "SuperviseUserName")
.Where(where).OrderBy(d => d.ID).ToPageList(request.rows, request.page);
return(ret);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(HoistingSafetyRequest request)
{
var data = _hoistSafetyLogic.GetDataListForPage(request);
return(Content(data.ToJson()));
}
