private object GetData(PagerQuery<PagerInfo, CriteriaRetroaction, IEnumerable<RetroactionListModel>> pagerQuery = null)
{
var pageInfo = new PagerInfo(this.HttpContext);
if (pagerQuery == null)
{
pagerQuery = new PagerQuery<PagerInfo, CriteriaRetroaction, IEnumerable<RetroactionListModel>>(pageInfo, new CriteriaRetroaction(), null);
}
else
{
if (string.IsNullOrWhiteSpace(pagerQuery.Search.lease_holder) && this.CurrentUser.Userid != "0505")
{
pagerQuery.Search.lease_holder = this.CurrentUser.Userid;
}
int recordCount = 0;
int TotalPages = 0;
var resultMsg = string.Empty;
var data = this.facade.QueryWebproCusreturnListPager(out resultMsg, out recordCount, out TotalPages, pagerQuery.Search, pageInfo.PageSize, pageInfo.CurrentPageIndex).ToList<RetroactionListModel>();
pageInfo.RecordCount = recordCount;
pagerQuery.Pager = pageInfo;
pagerQuery.Pager.TotalPages = TotalPages;
pagerQuery.DataList = data;
}
pagerQuery.Search.CustomerNameList = DropDownListFor.GetCustomerNameSelect(this.CurrentUser.Userid, "", null, true);
return pagerQuery;
}
//
// GET: /IPAccess/IPAccess/
public ActionResult Index(int pageIndex = 1, int pageSize = 20)
{
int count = 0;
List<Models.IPAccess> ipaccess = _IIPAccessService.GetIPAccessAll(pageIndex, pageSize, out count);
PagerInfo pager = new PagerInfo(pageIndex, pageSize, count);
PagerQuery<PagerInfo, List<Models.IPAccess>, string> query = new PagerQuery<PagerInfo, List<Models.IPAccess>, string>(pager, ipaccess, "");
ViewBag.navigation = new Navigation
{
Level = new List<string> { "系統設定", "登入IP管理" },
HaveButton = false
};
return View(query);
}
public ActionResult Index(PagerQuery<PagerInfo, CriteriaRetroaction, IEnumerable<RetroactionListModel>> pagerQuery = null)
{
try
{
//权限验证
this.HasActionPower();
return View(GetData(pagerQuery));
}
catch (Exception ex)
{
var model = new PagerQuery<PagerInfo, CriteriaRetroaction, IEnumerable<RetroactionListModel>>(new PagerInfo(this.HttpContext), new CriteriaRetroaction(), null);
var msgT = Server.UrlEncode("系统出现错误,请联系客服或管理员处理!");
var msgD = Server.UrlEncode(ex.Message);
UrlHelper url = new UrlHelper(this.Request.RequestContext);
this.Response.Redirect(url.Action("Index", "Error", new { msgTitle = msgT, msgDetail = msgD }));
return View(GetData(pagerQuery));
}
}
public ActionResult TennisAlliance(string keyWords, int pageIndex = 1, int pageSize = 20)
{
int count = 0;
List<TennisAlliance> pagedList = _ITennisAllianceService.GetTennisAllianceByCondition(keyWords, pageIndex, pageSize, out count);
PagerInfo pager = new PagerInfo(pageIndex, pageSize, count);
PagerQuery<PagerInfo, List<TennisAlliance>, string> query = new PagerQuery<PagerInfo, List<TennisAlliance>, string>(pager, pagedList, keyWords);
ViewBag.navigation = new Navigation
{
Level = new List<string> { "網球", "聯盟資料" },
Area = RouteData.DataTokens["area"].ToString(),
Controller = RouteData.Values["controller"].ToString(),
Action = "Index",
HaveButton = true,
ButtonText = "回賽程頁",
Parameter = new List<Parameter>{
new Parameter("date",DateTime.Now.ToString("yyyy-MM-dd")),
}
};
return View(query);
}
/// <summary>
/// 主頁顯示
/// </summary>
/// <returns></returns>
public ActionResult Index(string gameType = "IHBF", string keyWords = null, int pageIndex = 1, string sMsg = null)
{
int count = 0;
List<IceHockeyAlliance> ia = _IIceHockeyAllianceService.getAllianceListByIHBF(gameType, keyWords, pageIndex, pageSize, out count);
PagerInfo pager = new PagerInfo(pageIndex, pageSize, count);
PagerQuery<PagerInfo, List<IceHockeyAlliance>, string> query = new PagerQuery<PagerInfo, List<IceHockeyAlliance>, string>(pager, ia, keyWords);
ViewBag.PageCount = count;
ViewBag.gameType = gameType.ToUpper();
ViewBag.navigation = new Navigation
{
Level = new List<string> { AppData.GetGameTypeName(gameType), "聯盟管理" },
Area = RouteData.DataTokens["area"].ToString(),
Controller = "IHBFSchedules",
Action = "Index",
HaveButton = true,
Parameter = new List<Models.ViewModel.Parameter> {
new Parameter("date", DateTime.Now.ToString("yyyy-MM-dd")),
new Parameter("gameType", gameType)
},
ButtonText = "返回賽程"
};
return View(query);
}
public static async Task <PagerResult <R> > ListByPageAsync <T, R>(this IMediator mediator, PagerQuery <T> t)
{
return(await mediator.RequestAsync <PagerQuery <T>, PagerResult <R> >(t));
}
//
// GET: /Blog/
public ActionResult Index(int pageIndex = 1, string searchKey = "", int searchFlag = 0)
{
ViewBag.skin = GlobalVar.skin;
int pageSize = (searchFlag != 0 ? 99999 : 5);
//从数据库在取得数据，并返回总记录数
var temp = from d in db.Blogs
where (searchFlag == 0?1 == 1:(searchFlag == 1 ? d.keyword.Contains(searchKey) : d.title.Contains(searchKey) || d.keyword.Contains(searchKey) ||
d.author.Contains(searchKey) || d.content.Contains(searchKey)))
orderby d.id descending
select d;
int count = temp.Count();
var tag = from d in db.Blogs
select d.keyword;
List <string> list = new List <string>();
foreach (var item in tag)
{
list.AddRange(item.Split('|'));
}
var best = from d in db.Blogs
orderby d.viewCount descending
select d;
BlogRight <IEnumerable <string>, IQueryable <Blogs> > blogright =
new BlogRight <IEnumerable <string>, IQueryable <Blogs> >(list.Distinct <string>(), best.Take(5));
PagerInfo pager = new PagerInfo();
pager.CurrentPageIndex = pageIndex;
pager.PageSize = pageSize;
pager.RecordCount = count;
PagerQuery <PagerInfo, IQueryable <Blogs>, BlogRight <IEnumerable <string>, IQueryable <Blogs> > > query
= new PagerQuery <PagerInfo, IQueryable <Blogs>, BlogRight <IEnumerable <string>,
IQueryable <Blogs> > >(pager, temp.Skip <Blogs>((pageIndex - 1) * pageSize).Take <Blogs>(pageSize), blogright);
return(View(query));
}
public ActionResult <Pager <DocInstitutionView> > GetDocInstitutions(PagerQuery <DocInstitutionQuery> para)
{
return(bll.GetDocInstitutions(para));
}
private object GetData(PagerQuery<PagerInfo, CriteriaImport, IEnumerable<ImportListModel>> pagerQuery = null)
{
var pageInfo = new PagerInfo(this.HttpContext);
if (pagerQuery == null)
{
pagerQuery = new PagerQuery<PagerInfo, CriteriaImport, IEnumerable<ImportListModel>>(pageInfo, new CriteriaImport(), null);
}
else
{
int recordCount = 0;
int TotalPages = 0;
var resultMsg = string.Empty;
}
return pagerQuery;
}
public async Task <PagerResult <PurchaseListApiModel> > GetPagerListAsync(PagerQuery <PurchaseListQueryModel> query)
{
return(await _purchaseRespository.GetPagerListAsync(query));
}
//列表页
public ActionResult List()
{
Comm_Platform_Worker workerModel = Session["worker"] as Comm_Platform_Worker;
if (workerModel == null)
{
redirectTo();
return(null);
}
string region_code = CommonFunc.SafeGetStringFromObj(workerModel.region_code);
string dell_user_name = CommonFunc.SafeGetStringFromObj(workerModel.user_name);
string name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["name"]).Trim());
string sex = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["sex"]).Trim());
string birthdateBegin = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["txtBirthDateBegin"]).Trim());
string birthdateEnd = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["txtBirthDateEnd"]).Trim());
string id_card_number = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["idCard"]).Trim());
string address = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request["address"]).Trim());
string s = string.Empty;
//获取区域代码
if (!string.IsNullOrEmpty(CommonFunc.SafeGetStringFromObj(Request["ddlProvince"])))
{
s = CommonFunc.SafeGetStringFromObj(Request["ddlProvince"]);
}
if (!string.IsNullOrEmpty(CommonFunc.SafeGetStringFromObj(Request["ddlCity"])))
{
s = CommonFunc.SafeGetStringFromObj(Request["ddlCity"]);
}
if (!string.IsNullOrEmpty(CommonFunc.SafeGetStringFromObj(Request["ddlCounty"])))
{
s = CommonFunc.SafeGetStringFromObj(Request["ddlCounty"]);
}
if (!string.IsNullOrEmpty(CommonFunc.SafeGetStringFromObj(Request["ddlStreet"])))
{
s = CommonFunc.SafeGetStringFromObj(Request["ddlStreet"]);
}
if (!string.IsNullOrEmpty(CommonFunc.SafeGetStringFromObj(Request["ddlCommunity"])))
{
s = CommonFunc.SafeGetStringFromObj(Request["ddlCommunity"]);
}
if (s.Length > region_code.Length)
{
region_code = s;
}
int pageIndex = CommonFunc.SafeGetIntFromObj(this.Request["pageIndex"], 1);
int pageSize = this.Request["pageSize"] == null ? PageSize.GetPageSize : int.Parse(Request["pageSize"]);
int totalCount = 0;
CommonParam commonParam = new CommonParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount,
region_code = region_code,
name = name,
sex = sex,
txtBirthDateBegin = birthdateBegin,
txtBirthDateEnd = birthdateEnd,
idCard = id_card_number,
address = address
};
var list = mT_BC_RadiotherapyService.LoadSearchEntities(commonParam);
totalCount = commonParam.TotalCount;
int PageCount = Convert.ToInt32(Math.Ceiling((double)totalCount / pageSize));
List <MT_BC_Radiotherapy> result = new List <MT_BC_Radiotherapy>();
result.AddRange(list);
PagerInfo pager = new PagerInfo();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = totalCount;
PagerQuery <PagerInfo, List <MT_BC_Radiotherapy> > query = new PagerQuery <PagerInfo, List <MT_BC_Radiotherapy> >(pager, result);
ViewData.Model = query;
ViewBag.dell_user_name = dell_user_name;
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
return(View());
}
/// <summary>
/// 企业安全风险分级管控表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult <Pager <DSReport> > GetDSReport(PagerQuery <DSReportQuery> query)
{
try
{
var dps = rpsDP.Queryable();
var empIds = dps.Select(s => s.Principal);
var emps = rpsEmp.Queryable(p => empIds.Contains(p.ID));
var dlvs = rpsDict.Queryable(p => p.ParentID == OptionConst.DangerLevel);
var dprs = rpsDPR.Queryable();
var retemp = from dpr in dprs.ToList()
let dp = dps.FirstOrDefault(p => p.ID == dpr.DangerPointID)
let emp = emps.FirstOrDefault(p => p.ID == dp.Principal)
let org = rpsOrg.GetModel(p => p.ID == emp.OrgID)
let whysIds = JsonConvert.DeserializeObject <IEnumerable <Guid> >(dp.WXYSJson)
let whyss = rpsDict.Queryable(p => whysIds.Contains(p.ID)).Select(s => s.DictName)
let drs = rpsDR.Queryable(p => p.SubjectID == dpr.SubjectID)
let dangers = rpsDanger.Queryable(p => drs.Select(s => s.DangerID).Contains(p.ID))
let lv = dlvs.OrderByDescending(o => o.LECD_DMinValue).FirstOrDefault(p => dangers.Select(s => s.DangerLevel).Contains(p.ID))
where emp.CNName.Contains(query.Query.KeyWord) || query.Query.KeyWord == string.Empty
select new DSReport
{
DangerPoint = dp.Name,
ControlMeasure = dp.ControlMeasure,
WHYSDict = whyss,
Principal = emp.CNName,
Subject = dpr.SubjectName,
DLevel = lv == null ? "" : lv.DictName,
Org = org.OrgName
};
string excel = "";
if (query.ToExcel)
{
var exc = from dpr in dprs.ToList()
let dp = dps.FirstOrDefault(p => p.ID == dpr.DangerPointID)
let emp = emps.FirstOrDefault(p => p.ID == dp.Principal)
let org = rpsOrg.GetModel(p => p.ID == emp.OrgID)
let whysIds = JsonConvert.DeserializeObject <IEnumerable <Guid> >(dp.WXYSJson)
let whyss = rpsDict.Queryable(p => whysIds.Contains(p.ID)).Select(s => s.DictName)
let drs = rpsDR.Queryable(p => p.SubjectID == dpr.SubjectID)
let dangers = rpsDanger.Queryable(p => drs.Select(s => s.DangerID).Contains(p.ID))
let lv = dlvs.OrderByDescending(o => o.LECD_DMinValue).FirstOrDefault(p => dangers.Select(s => s.DangerLevel).Contains(p.ID))
where emp.CNName.Contains(query.Query.KeyWord) || query.Query.KeyWord == string.Empty
select new
{
风险点 = dp.Name,
检查主体 = dpr.SubjectName,
风险等级 = lv == null ? "" : lv.DictName,
危险有害因素 = string.Join("\n", whyss),
管控措施 = dp.ControlMeasure,
负责部门 = org.OrgName,
负责人 = emp.CNName,
};
excel = Command.CreateExcel(exc.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <DSReport>().GetCurrentPage(retemp, query.PageSize, query.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <DSReport> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <DSReport> >(ex));
}
}
public ActionResult List(PagerQuery<PagerInfo, CriteriaDetaildata, IEnumerable<DetaildataListModel>> model = null)
{
this.ShowMessage("ceshi2222");
return View();
}
private PagerQuery<PagerInfo, CriteriaDetaildata, IEnumerable<DetaildataListModel>> GetData(PagerQuery<PagerInfo, CriteriaDetaildata, IEnumerable<DetaildataListModel>> model = null)
{
if (model == null)
{
model = new PagerQuery<PagerInfo, CriteriaDetaildata, IEnumerable<DetaildataListModel>>();
}
var recordCount = decimal.Zero;
var resultMsg = string.Empty;
var pager = new PagerInfo(this.HttpContext);
IFacadeDetaildata dataFacade= new FacadeDetaildata();
IEnumerable<DetaildataListModel> listModel = new List<DetaildataListModel>();
DataSet data = dataFacade.QueryDetaildataListPager(out resultMsg, out recordCount, model.Search, pager.PageSize, pager.CurrentPageIndex);
// todo : tolist
pager.RecordCount = (int)recordCount;
model.Pager = pager;
model.DataList = listModel;
return model;
}
public async Task <JsonResult> ListAsync(PagerQuery <ListWhitePhoneRequest> query)
{
var data = await _mediator.ListByPageAsync <ListWhitePhoneRequest, ListWhitePhoneResponse>(query);
return(Json(data));
}
public async Task <PagerResult <CheckListApiModel> > GetPagerListAsync(PagerQuery <CheckListQueryModel> query, int hospitalId)
{
return(await _checkListRespository.GetPagerListAsync(query, hospitalId));
}
/// <summary>
/// 获取作业单表列表
/// </summary>
/// <param name="Para"></param>
/// <returns></returns>
public ActionResult <Pager <OpreateBillModel> > GetList(PagerQuery <string> Para)
{
try
{
var bills = rpsOpreateBill.Queryable(q => q.BillName.Contains(Para.KeyWord) || Para.KeyWord == "");
var opretions = _work.Repository <Basic_Opreation>().Queryable(q => bills.Select(s => s.OpreationID).Contains(q.ID));
var emps = _work.Repository <Basic_Employee>().Queryable(q => bills.Select(s => s.PrincipalEmployeeID).Contains(q.ID));
var retemp = from bill in bills
let opreation = opretions.FirstOrDefault(q => q.ID == bill.OpreationID)
let emp = emps.FirstOrDefault(q => q.ID == bill.PrincipalEmployeeID)
orderby bill.BillCode
select new OpreateBillModel
{
BillCode = bill.BillCode,
OpreationID = bill.OpreationID,
ID = bill.ID,
Description = bill.Description,
OrgID = emp.OrgID,
BillLong = bill.BillLong,
BillName = bill.BillName,
CreateDate = bill.CreateDate,
CreateMan = bill.CreateMan,
EndTime = bill.EndTime,
OpreationName = opreation == null ? "" : opreation.Name,
PrincipalEmployeeID = bill.PrincipalEmployeeID,
StartTime = bill.StartTime,
State = (PublicEnum.BillFlowState)bill.State,
StateName =
bill.State == (int)PublicEnum.BillFlowState.approved ? "审批通过" :
bill.State == (int)PublicEnum.BillFlowState.audited ? "已审核" :
bill.State == (int)PublicEnum.BillFlowState.cancel ? "已作废" :
bill.State == (int)PublicEnum.BillFlowState.check ? "已验收" :
bill.State == (int)PublicEnum.BillFlowState.deny ? "已拒绝" :
bill.State == (int)PublicEnum.BillFlowState.normal ? "待审批" :
bill.State == (int)PublicEnum.BillFlowState.pending ? "审批中" :
bill.State == (int)PublicEnum.BillFlowState.recalled ? "已撤回" :
bill.State == (int)PublicEnum.BillFlowState.stop ? "已终止" :
bill.State == (int)PublicEnum.BillFlowState.Reback ? "已回退" : "未知",
PrincipalEmployeeName = emp == null ? "" : emp.CNName
};
var excel = "";
if (Para.ToExcel)
{
var res = from bill in bills
let opreation = opretions.FirstOrDefault(q => q.ID == bill.OpreationID)
let emp = emps.FirstOrDefault(q => q.ID == bill.PrincipalEmployeeID)
orderby bill.BillCode
select new
{
作业编号 = bill.BillCode,
作业名称 = bill.BillName,
开始时间 = bill.StartTime,
结束时间 = bill.EndTime,
作业发起人 = bill.CreateMan,
作业发起时间 = bill.CreateDate,
作业负责人 = emp == null ? "" : emp.CNName,
作业流程 = opreation == null ? "" : opreation.Name,
作业时长 = bill.BillLong,
作业申请描述 = bill.Description,
状态 =
bill.State == (int)PublicEnum.BillFlowState.approved ? "审批通过" :
bill.State == (int)PublicEnum.BillFlowState.audited ? "已审核" :
bill.State == (int)PublicEnum.BillFlowState.cancel ? "已作废" :
bill.State == (int)PublicEnum.BillFlowState.check ? "已验收" :
bill.State == (int)PublicEnum.BillFlowState.deny ? "已拒绝" :
bill.State == (int)PublicEnum.BillFlowState.normal ? "待审批" :
bill.State == (int)PublicEnum.BillFlowState.pending ? "审批中" :
bill.State == (int)PublicEnum.BillFlowState.recalled ? "已撤回" :
bill.State == (int)PublicEnum.BillFlowState.stop ? "已终止" :
bill.State == (int)PublicEnum.BillFlowState.Reback ? "已回退" : "未知",
};
excel = Command.CreateExcel(res.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <OpreateBillModel>().GetCurrentPage(retemp, Para.PageSize, Para.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <OpreateBillModel> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <OpreateBillModel> >(ex));
}
}
/// <summary>
/// 隐患整改情况
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult <Pager <CtrReport> > GetCtrReport(PagerQuery <CtrReportQuery> query)
{
try
{
var ctrs = rpsTCtr.Queryable();
var subs = rpsTCD.Queryable();
var emps = rpsEmp.Queryable();
var ctrfs = rpsTCF.Queryable();
var dps = rpsDP.Queryable();
var dprs = rpsDPR.Queryable();
var checks = rpsTBS.Queryable();
var bills = rpsTB.Queryable();
var dangers = rpsDanger.Queryable();
var TLevels = rpsDict.Queryable(p => p.ParentID == OptionConst.TroubleLevel);
var retemp = from ctr in ctrs
let dp = dps.FirstOrDefault(p => p.ID == ctr.DangerPoint)
let tcd = subs.FirstOrDefault(p => p.TroubleControlID == ctr.ID)
let subid = checks.FirstOrDefault(p => p.ID == tcd.BillSubjectsID)
let sub = dprs.FirstOrDefault(p => p.SubjectID == subid.SubjectID)
let danger = dangers.FirstOrDefault(p => p.ID == subid.DangerID)
let bill = bills.FirstOrDefault(p => p.ID == ctr.BillID)
let bemp = emps.FirstOrDefault(p => p.ID == bill.EmployeeID)
let pemp = emps.FirstOrDefault(p => p.ID == ctr.PrincipalID)
let aemp = emps.FirstOrDefault(p => p.ID == ctr.AcceptorID)
let ctrf = ctrfs.OrderByDescending(o => o.FlowDate).FirstOrDefault(p => p.ControlID == ctr.ID && p.FlowType == (int)PublicEnum.EE_TroubleFlowState.TroubleR)
let tlv = TLevels.FirstOrDefault(p => p.ID == ctr.TroubleLevel)
orderby tlv.MinValue descending
select new CtrReport
{
DangerPoint = dp.Name,
Subject = sub.SubjectName,
Danger = danger.Name,
BEmp = bemp.CNName,
CheckResult = subid.TaskResultMemo,
Principal = pemp.CNName,
CreateDate = ctr.CreateDate,
CtrTarget = ctr.ControlDescription,
Acceptor = aemp == null ? "" : aemp.CNName,
IsAccepte = (PublicEnum.EE_TroubleState)ctr.State,
AccepteDate = ctrf == null ? null : (DateTime?)ctrf.FlowDate,
TLevel = tlv.DictName,
};
string excel = "";
if (query.ToExcel)
{
var exc = from ctr in ctrs
let dp = dps.FirstOrDefault(p => p.ID == ctr.DangerPoint)
let tcd = subs.FirstOrDefault(p => p.TroubleControlID == ctr.ID)
let subid = checks.FirstOrDefault(p => p.ID == tcd.BillSubjectsID)
let sub = dprs.FirstOrDefault(p => p.SubjectID == subid.SubjectID)
let danger = dangers.FirstOrDefault(p => p.ID == subid.DangerID)
let bill = bills.FirstOrDefault(p => p.ID == ctr.BillID)
let bemp = emps.FirstOrDefault(p => p.ID == bill.EmployeeID)
let pemp = emps.FirstOrDefault(p => p.ID == ctr.PrincipalID)
let aemp = emps.FirstOrDefault(p => p.ID == ctr.AcceptorID)
let ctrf = ctrfs.OrderByDescending(o => o.FlowDate).FirstOrDefault(p => p.ControlID == ctr.ID && p.FlowType == (int)PublicEnum.EE_TroubleFlowState.TroubleR)
let tlv = TLevels.FirstOrDefault(p => p.ID == ctr.TroubleLevel)
orderby tlv.MinValue descending
select new
{
风险点 = dp.Name,
检查主体 = sub.SubjectName,
风控项 = danger.Name,
检查人 = bemp.CNName,
检查情况 = subid.TaskResultMemo,
隐患发现时间 = ctr.CreateDate,
隐患等级 = tlv.DictName,
整改目标 = ctr.ControlDescription,
整改负责人 = pemp.CNName,
验收时间 = ctrf == null ? null : (DateTime?)ctrf.FlowDate,
验收情况 = (PublicEnum.EE_TroubleState)ctr.State,
验收人 = aemp == null ? "" : aemp.CNName,
};
excel = Command.CreateExcel(exc.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <CtrReport>().GetCurrentPage(retemp, query.PageSize, query.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <CtrReport> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <CtrReport> >(ex));
}
}
public async Task <PagerResult <PurchaseSettingThresholdListApiModel> > GetPagerListAsync(PagerQuery <PurchaseSettingThresholdListQueryModel> query)
{
var sql = from r in _context.PurchaseSettingThreshold
join p in _context.PurchaseSetting on r.PurchaseSettingId equals p.Id
join u in _context.User on r.CreateUserId equals u.Id
join t in _context.DataPurchaseThresholdType on r.ThresholdTypeId equals t.Id
orderby r.Id descending
select new PurchaseSettingThresholdListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
CreateUserName = u.Username,
DownQty = r.DownQty,
UpQty = r.UpQty,
HospitalGoods = new GetHospitalGoodsResponse
{
Id = r.HospitalGoodsId,
},
ThresholdType = t,
};
var data = new PagerResult <PurchaseSettingThresholdListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
}
}
return(data);
}
public async Task <JsonResult> GetListAsync(PagerQuery <PurchaseGoodsListQueryModel> query)
{
var data = await _PurchaseGoodsService.GetPagerListAsync(query);
return(Json(data));
}
public async Task <CheckListPreviewApiModel> GetPagerPreviewListAsync(int checkListId, PagerQuery <CheckListGoodsPreviewQueryModel> query)
{
return(new CheckListPreviewApiModel
{
CheckListGoods = await _CheckListGoodsContext.GetPagerPreviewListAsync(checkListId, query),
Amount = _CheckListGoodsContext.GetPreviewListAmount(checkListId),
});
}
private object GetData(PagerQuery<PagerInfo, CriteriaNuclearButton, IEnumerable<NuclearButtonListModel>> pagerQuery = null)
{
var pageInfo = new PagerInfo(this.HttpContext);
if (pagerQuery == null)
{
pagerQuery = new PagerQuery<PagerInfo, CriteriaNuclearButton, IEnumerable<NuclearButtonListModel>>(pageInfo, new CriteriaNuclearButton(), null);
pagerQuery.Search.WayOutStartTime = DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd");
pagerQuery.Search.WayOutEndTime = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
int recordCount = 0;
int TotalPages = 0;
var resultMsg = string.Empty;
if (string.IsNullOrWhiteSpace(pagerQuery.Search.CustomerName)&&this.CurrentUser.Userid!="0505")
{
pagerQuery.Search.CustomerName = this.CurrentUser.Userid;
}
if (!string.IsNullOrWhiteSpace(pagerQuery.Search.WayOutStartTime))
{
pagerQuery.Search.WayOutStartTime += " 00:00:00";
}
if (!string.IsNullOrWhiteSpace(pagerQuery.Search.WayOutEndTime))
{
pagerQuery.Search.WayOutEndTime += " 23:59:59";
}
if (!string.IsNullOrWhiteSpace(pagerQuery.Search.CargoType))
{
pagerQuery.Search.CargoTypeTest = Universal.GetStatusName(_Dictionary.CargoType, pagerQuery.Search.CargoType);
}
if (!string.IsNullOrWhiteSpace(pagerQuery.Search.ApprovalStatus))
{
decimal status = Convert.ToDecimal(pagerQuery.Search.ApprovalStatus);
pagerQuery.Search.ApprovalStatus = ((int)status).ToString();
}
var data = this.facadeVHk.QueryV_HKListPager(out resultMsg, out recordCount, out TotalPages, pagerQuery.Search, pageInfo.PageSize, pageInfo.CurrentPageIndex).ToList<NuclearButtonListModel>();
pageInfo.RecordCount = recordCount;
pagerQuery.Pager = pageInfo;
pagerQuery.Pager.TotalPages = TotalPages;
pagerQuery.DataList = data;
}
pagerQuery.Search.CargoTypeList = DropDownListFor.GetCargoTypeSelect(null, true);
pagerQuery.Search.CustomerNameList = DropDownListFor.GetCustomerNameSelect(this.CurrentUser.Userid, pagerQuery.Search.CargoType, null, true);
pagerQuery.Search.WayOutList = DropDownListFor.GetWayOutSelect(null, true);
pagerQuery.Search.LockStatusList = DropDownListFor.GetLockingStatusSelect(null, false);
pagerQuery.Search.ApprovalStatusList = DropDownListFor.GetApprovalStatusSelect(null, true);
return pagerQuery;
}
public ActionResult <Pager <OpreationView> > GetOpreationPage(PagerQuery <OpreationQuery> para)
{
return(bll.GetOpreationPage(para));
}
public ActionResult Index(PagerQuery<PagerInfo, CriteriaImport, IEnumerable<ImportListModel>> pagerQuery=null)
{
return View(GetData(pagerQuery));
}
public async Task <JsonResult> GetListAsync(PagerQuery <PurchaseSettingThresholdListQueryModel> query)
{
var data = await _purchaseSettingThresholdService.GetPagerListAsync(query);
return(Json(data));
}
public PagerResult <UserListApiModel> GetPagerList(PagerQuery <UserListQueryModel> query)
{
return(_userRespository.GetPagerList(query));
}
public async Task <PagerResult <CheckListGoodsListApiModel> > GetPagerListAsync(PagerQuery <CheckListGoodsQueryModel> query)
{
return(await _CheckListGoodsContext.GetPagerListAsync(query));
}
public PagerResult <RoleListApiModel> GetPagerList(PagerQuery <RoleListQueryModel> query)
{
return(_roleContext.GetPagerList(query));
}
public async Task <PagerResult <PrescriptionListApiModel> > GetPagerListAsync(PagerQuery <PrescriptionListQueryModel> query, int hospitalId)
{
return(await _prescriptionRespository.GetPagerListAsync(query, hospitalId));
}
public async Task <JsonResult> GetListAsync(PagerQuery <PurchaseSettingListQueryModel> query)
{
var data = await _purchaseSettingService.GetPagerListAsync(query, HospitalDepartment.Hospital.Id);
return(Json(data));
}
private PagerQuery <PagerInfo, CriteriaDetaildata, IEnumerable <DetaildataListModel> > GetData(PagerQuery <PagerInfo, CriteriaDetaildata, IEnumerable <DetaildataListModel> > model = null)
{
if (model == null)
{
model = new PagerQuery <PagerInfo, CriteriaDetaildata, IEnumerable <DetaildataListModel> >();
}
var recordCount = decimal.Zero;
var resultMsg = string.Empty;
var pager = new PagerInfo(this.HttpContext);
IFacadeDetaildata dataFacade = new FacadeDetaildata();
IEnumerable <DetaildataListModel> listModel = new List <DetaildataListModel>();
DataSet data = dataFacade.QueryDetaildataListPager(out resultMsg, out recordCount, model.Search, pager.PageSize, pager.CurrentPageIndex);
// todo : tolist
pager.RecordCount = (int)recordCount;
model.Pager = pager;
model.DataList = listModel;
return(model);
}
//对应的多条列表
public ActionResult ListAll()
{
Comm_Platform_Worker workerModel = Session["worker"] as Comm_Platform_Worker;
string region_code = CommonFunc.SafeGetStringFromObj(workerModel.region_code);
string dell_user_name = CommonFunc.SafeGetStringFromObj(workerModel.user_name);
string resident_id = CommonFunc.SafeGetStringFromObj(Request.QueryString["resident_id"]);
string resident_name = CommonFunc.SafeGetStringFromObj(Request.QueryString["resident_name"]);
int pageIndex = CommonFunc.SafeGetIntFromObj(this.Request["pageIndex"], 1);
int pageSize = this.Request["pageSize"] == null ? PageSize.GetPageSize : int.Parse(Request["pageSize"]);
int totalCount = 0;
var disease_HospitalizationList = disease_Hospitalization_ConsultationRecordService.LoadPageEntities(pageSize, pageIndex, out totalCount, t => (t.resident_id.Contains(resident_id)) && (t.type.Contains("Therioma")), t => t.hospitalization_date, false);
int PageCount = Convert.ToInt32(Math.Ceiling((double)totalCount / pageSize));
List <Chronic_disease_Hospitalization_ConsultationRecord> result = new List <Chronic_disease_Hospitalization_ConsultationRecord>();
result.AddRange(disease_HospitalizationList);
PagerInfo pager = new PagerInfo();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = totalCount;
PagerQuery <PagerInfo, List <Chronic_disease_Hospitalization_ConsultationRecord> > query = new PagerQuery <PagerInfo, List <Chronic_disease_Hospitalization_ConsultationRecord> >(pager, result);
ViewData.Model = query;
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
ViewBag.dell_user_name = dell_user_name;
ViewBag.resident_id = resident_id;
ViewBag.resident_name = resident_name;
return(View());
}
public ActionResult List(PagerQuery <PagerInfo, CriteriaDetaildata, IEnumerable <DetaildataListModel> > model = null)
{
this.ShowMessage("ceshi2222");
return(View());
}
/// <summary>
/// 企业安全风险三清单
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult <Pager <DPReport> > GetDPReport(PagerQuery <DPReportQuery> query)
{
try
{
var dps = rpsDP.Queryable();
var empIds = dps.Select(s => s.Principal);
var emps = rpsEmp.Queryable(p => empIds.Contains(p.ID));
var dlvs = rpsDict.Queryable(p => p.ParentID == OptionConst.DangerLevel);
var retemp = from dp in dps.ToList()
let emp = emps.FirstOrDefault(p => p.ID == dp.Principal)
let whysIds = JsonConvert.DeserializeObject <IEnumerable <Guid> >(dp.WXYSJson)
let whyss = rpsDict.Queryable(p => whysIds.Contains(p.ID)).Select(s => s.DictName)
let lv = dlvs.FirstOrDefault(p => p.ID == dp.DangerLevel)
where (dp.DangerLevel == query.Query.DLevel || query.Query.DLevel == Guid.Empty) && (emp.CNName.Contains(query.Query.KeyWord) || dp.Name.Contains(query.Query.KeyWord) || query.Query.KeyWord == string.Empty)
select new DPReport
{
Consequence = dp.Consequence,
DangerPoint = dp.Name,
EmergencyMeasure = dp.EmergencyMeasure,
ControlMeasure = dp.ControlMeasure,
Principal = emp.CNName,
Tel = emp.Tel,
WHYSDict = whyss,
DLevel = lv.DictName
};
string excel = "";
if (query.ToExcel)
{
var exc = from dp in dps.ToList()
let emp = emps.FirstOrDefault(p => p.ID == dp.Principal)
let whysIds = JsonConvert.DeserializeObject <IEnumerable <Guid> >(dp.WXYSJson)
let whyss = rpsDict.Queryable(p => whysIds.Contains(p.ID)).Select(s => s.DictName)
let lv = dlvs.FirstOrDefault(p => p.ID == dp.DangerLevel)
where (dp.DangerLevel == query.Query.DLevel || query.Query.DLevel == Guid.Empty) && (emp.CNName.Contains(query.Query.KeyWord) || dp.Name.Contains(query.Query.KeyWord) || query.Query.KeyWord == string.Empty)
select new
{
风险点 = dp.Name,
风险因素 = string.Join("\n", whyss.ToArray()),
后果 = dp.Consequence,
风险等级 = lv.DictName,
管控措施 = dp.ControlMeasure,
应急处理措施 = dp.EmergencyMeasure,
负责人 = emp.CNName,
报告电话 = emp.Tel,
};
excel = Command.CreateExcel(exc.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <DPReport>().GetCurrentPage(retemp, query.PageSize, query.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <DPReport> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <DPReport> >(ex));
}
}
public async Task <PagerResult <StoreInoutGoodsListApiModel> > GetPagerListAsync(PagerQuery <StoreInoutGoodsListQueryModel> query)
{
return(await _StoreInoutGoodsContext.GetPagerListAsync(query));
}
/// <summary>
/// 设备设施风险分级控制清单
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult <Pager <SubDReport> > GetSubDReport(PagerQuery <SubDReportQuery> query)
{
try
{
var dps = rpsDP.Queryable();
var dpIds = dps.Select(s => s.ID);
var orgs = rpsOrg.Queryable();
var emps = rpsEmp.Queryable();
var drs = rpsDR.Queryable();
var dangers = rpsDanger.Queryable();
var dprs = rpsDPR.Queryable(p => dpIds.Contains(p.DangerPointID));
var DLevels = rpsDict.Queryable(p => p.ParentID == OptionConst.DangerLevel);
var ss = rpsSS.Queryable();
var ssds = rpsDSS.Queryable();
var retemp = from dp in dps
let org = orgs.FirstOrDefault(p => p.ID == dp.OrgID)
let pemp = emps.FirstOrDefault(p => p.ID == dp.Principal)
let cdprs = dprs.Where(p => p.DangerPointID == dp.ID)
let dplv = DLevels.FirstOrDefault(p => p.ID == dp.DangerLevel)
orderby dplv.LECD_DMaxValue descending
select new SubDReport
{
DangerPoint = dp.Name,
Consequence = dp.Consequence,
POrg = org.OrgName,
Principal = pemp.CNName,
DangerSubs = from dpr in cdprs
let cdangers = dangers.Where(p => drs.Where(q => q.SubjectID == dpr.SubjectID).Select(s => s.DangerID).Contains(p.ID))
orderby dpr.SubjectType
select new DangerSub
{
Sub = dpr.SubjectName,
SubType = dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Device ? "设备设施"
: dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Opreate ? "作业"
: dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Post ? "岗位" : "",
Dangers = from d in cdangers
let dlv = DLevels.FirstOrDefault(p => p.ID == d.DangerLevel)
let css = ss.Where(p => ssds.Where(q => q.DangerID == d.ID).Select(s => s.SafetyStandardID).Contains(p.ID))
select new RDanger
{
DangerName = d.Name,
DLevel = dlv.DictName,
Standards = from cs in css
select new Standard
{
Accident = cs.Accident,
Controls = cs.Controls,
Engineering = cs.Engineering,
Individual = cs.Individual
}
}
}
};
string excel = "";
if (query.ToExcel)
{
var sw = new List <object>();
var dpss = from dp in dps
let dplv = DLevels.FirstOrDefault(p => p.ID == dp.DangerLevel)
orderby dplv.LECD_DMaxValue descending
select dp;
foreach (var dp in dpss)
{
var cdprs = dprs.Where(p => p.DangerPointID == dp.ID);
var org = orgs.FirstOrDefault(p => p.ID == dp.OrgID);
var pemp = emps.FirstOrDefault(p => p.ID == dp.Principal);
foreach (var dpr in cdprs)
{
var cdangers = dangers.Where(p => drs.Where(q => q.SubjectID == dpr.SubjectID).Select(s => s.DangerID).Contains(p.ID));
foreach (var d in cdangers)
{
sw.Add(new
{
风险点 = dp.Name,
主体类型 = dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Device ? "设备设施"
: dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Opreate ? "作业"
: dpr.SubjectType == (int)PublicEnum.EE_SubjectType.Post ? "岗位" : "",
主体名称 = dpr.SubjectName,
风控项名称 = d.Name,
风险等级 = DLevels.FirstOrDefault(p => p.ID == d.DangerLevel).DictName,
工程技术 = string.Join("\n", ss.Where(p => ssds.Where(q => q.DangerID == d.ID).Select(s => s.SafetyStandardID).Contains(p.ID)).Select(s => s.Individual)),
管理措施 = string.Join("\n", ss.Where(p => ssds.Where(q => q.DangerID == d.ID).Select(s => s.SafetyStandardID).Contains(p.ID)).Select(s => s.Controls)),
个体防护措施 = string.Join("\n", ss.Where(p => ssds.Where(q => q.DangerID == d.ID).Select(s => s.SafetyStandardID).Contains(p.ID)).Select(s => s.Individual)),
应急处置措施 = string.Join("\n", ss.Where(p => ssds.Where(q => q.DangerID == d.ID).Select(s => s.SafetyStandardID).Contains(p.ID)).Select(s => s.Accident)),
符合标准情况及后果 = dp.Consequence,
责任单位 = org.OrgName,
责任人 = pemp.CNName
});
}
}
}
excel = Command.CreateExcel(sw.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <SubDReport>().GetCurrentPage(retemp, query.PageSize, query.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <SubDReport> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <SubDReport> >(ex));
}
}
/// <summary>
/// 分页获取风险点模型
/// </summary>
/// <param name="pointName"></param>
/// <returns></returns>
public ActionResult <Pager <DangerPointView> > GetDangerPointPages(PagerQuery <DangerPointQuery> pointName)
{
try
{
var page = rpsdp.Queryable(p => (p.Name.Contains(pointName.Query.KeyWord) || pointName.Query.KeyWord == string.Empty) &&
(pointName.Query.DLevel == p.DangerLevel || pointName.Query.DLevel == Guid.Empty));
//风险等级
var lvids = page.Select(s => s.DangerLevel);
var lvs = work.Repository <Core.Model.DB.Basic_Dict>().Queryable(p => lvids.Contains(p.ID));
//负责人员
var empids = page.Select(s => s.Principal);
var emps = work.Repository <Core.Model.DB.Basic_Employee>().Queryable(p => empids.Contains(p.ID));
var org = work.Repository <Core.Model.DB.Basic_Org>().Queryable();
var retemp = from p in page
let lv = lvs.FirstOrDefault(q => q.ID == p.DangerLevel)
let emp = emps.FirstOrDefault(q => q.ID == p.Principal)
let porg = org.FirstOrDefault(p => p.ID == emp.OrgID)
orderby p.Code ascending
select new DangerPointView
{
ID = p.ID,
QRCoderUrl = p.QRCoderUrl,
Name = p.Name,
Memo = p.Memo,
EmergencyMeasure = p.EmergencyMeasure,
ControlMeasure = p.ControlMeasure,
Code = p.Code,
DangerLevelName = lv.DictName,
PrincipalName = emp.CNName,
WarningSign = p.WarningSign,
DangerPointImg = p.DangerPointImg,
Consequence = p.Consequence,
OrgName = porg.OrgName
};
string excel = "";
if (pointName.ToExcel)
{
var sw = from p in page
let lv = lvs.FirstOrDefault(q => q.ID == p.DangerLevel)
let emp = emps.FirstOrDefault(q => q.ID == p.Principal)
let porg = org.FirstOrDefault(p => p.ID == emp.OrgID)
orderby p.Code ascending
select new
{
编号 = p.Code,
风险点名称 = p.Name,
描述 = p.Memo,
应急处理措施 = p.EmergencyMeasure,
管理措施 = p.ControlMeasure,
风险等级 = lv.DictName,
后果 = p.Consequence,
负责人部门 = porg.OrgName,
负责人 = emp.CNName
};
excel = Command.CreateExcel(sw.AsEnumerable(), AppUser.OutPutPaht);
}
var re = new Pager <DangerPointView>().GetCurrentPage(retemp, pointName.PageSize, pointName.PageIndex);
re.ExcelResult = excel;
return(new ActionResult <Pager <DangerPointView> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <DangerPointView> >(ex));
}
}
public ActionResult <Pager <OpreateBillModel> > GetList(PagerQuery <string> Para)
{
return(bll.GetList(Para));
}
/// <summary>
/// 风险点配置关系
/// </summary>
/// <param name="pointID"></param>
/// <returns></returns>
public ActionResult <Pager <DangerPointRelationView> > GetDangerPointRelationPages(PagerQuery <Guid> pointID)
{
try
{
var page = rpsdpr.Queryable(p => p.DangerPointID == pointID.Query);
var retemp = from pg in page.ToList()
orderby pg.SubjectName descending
select new DangerPointRelationView
{
ID = pg.ID,
SubjectType = Command.GetItems(typeof(PublicEnum.EE_SubjectType)).FirstOrDefault(p => p.Value == pg.SubjectType).Caption,
SubjectName = pg.SubjectName
};
var re = new Pager <DangerPointRelationView>().GetCurrentPage(retemp, pointID.PageSize, pointID.PageIndex);
return(new ActionResult <Pager <DangerPointRelationView> >(re));
}
catch (Exception ex)
{
return(new ActionResult <Pager <DangerPointRelationView> >(ex));
}
}
public async Task <PagerResult <StoreRecordListApiModel> > GetPagerListAsync(PagerQuery <StoreRecordListQueryModel> query)
{
return(await _storeRecordRespository.GetPagerListAsync(query));
}
public ActionResult BKOSTeam(BKOSTeamQuery queryModel, int pageIndex = 1, int pageSize = 100)
{
int count = 0;
List<BKOSTeam> pagedList = _IBKOSTeamService.GetBKOSTeamByCondition(queryModel, pageIndex, pageSize, out count).ToList();
PagerInfo pager = new PagerInfo(pageIndex, pageSize, count);
PagerQuery<PagerInfo, List<BKOSTeam>, BKOSTeamQuery> query = new PagerQuery<PagerInfo, List<BKOSTeam>, BKOSTeamQuery>(pager, pagedList, queryModel);
ViewBag.SelectAlliances = _IBKOSAllianceService.QueryAll().ToList().Select(p => new SelectListItem { Text = p.ShowName, Value = p.AllianceID.ToString(), Selected = queryModel != null && queryModel.AllianceID == p.AllianceID });
ViewBag.navigation = new Navigation
{
Level = new List<string> { "奧訊籃球", "隊伍管理" },
Area = RouteData.DataTokens["area"].ToString(),
Controller = RouteData.Values["controller"].ToString(),
Action = "Index",
HaveButton = true,
ButtonText = "回賽程頁",
Parameter = new List<Parameter>{
new Parameter("date",DateTime.Now.ToString("yyyy-MM-dd")),
}
};
return View(query);
}
