/// <summary> /// 获取延期申请列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Epm_PlanDelay> > GetPlanDelayList(QueryCondition qc) { Result <List <Epm_PlanDelay> > result = new Result <List <Epm_PlanDelay> >(); try { AddDefaultWeb(qc); qc.PageInfo = new PageListInfo(); if (!qc.SortList.Any()) { qc.SortList.Add(new SortExpression() { SortName = "ProjectId", SortType = eSortType.Desc }); } result = DataOperate.QueryListSimple <Epm_PlanDelay>(context, qc); } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, ""); result.AllRowsCount = -1; } return(result); }
///<summary> ///获取列表:新闻、资讯表 ///</summary> /// <param name="qc">查询条件</param> /// <returns>符合条件的数据集合</returns> public Result <List <Epm_News> > GetNewsList(QueryCondition qc) { qc = AddDefault(qc); Result <List <Epm_News> > result = new Result <List <Epm_News> >(); try { result = DataOperate.QueryListSimple <Epm_News>(context, qc); } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetNewsList"); } return(result); }
/// <summary> /// 获取问题回复列表 /// </summary> /// <param name="qc">查询条件</param> /// <returns></returns> public Result <List <Epm_QuestionTrack> > GetQuestionTrack(QueryCondition qc) { Result <List <Epm_QuestionTrack> > result = new Result <List <Epm_QuestionTrack> >(); try { result = DataOperate.QueryListSimple <Epm_QuestionTrack>(context, qc); } catch (Exception ex) { result.Exception = new ExceptionEx(ex, ""); result.Flag = EResultFlag.Failure; result.Data = null; result.AllRowsCount = 0; } return(result); }
/// <summary> /// 获取作业实景列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Epm_WorkUploadRealScene> > GetWorkRealSceneList(QueryCondition qc) { Result <List <Epm_WorkUploadRealScene> > result = new Result <List <Epm_WorkUploadRealScene> >(); try { result = DataOperate.QueryListSimple <Epm_WorkUploadRealScene>(context, qc); } catch (Exception ex) { result.Exception = new ExceptionEx(ex, "GetWorkRealSceneList"); result.Flag = EResultFlag.Failure; result.Data = null; result.AllRowsCount = -1; } return(result); }
/// <summary> /// 获取企业列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Base_Company> > GetCompanyListByType(QueryCondition qc) { qc = AddDefault(qc); Result <List <Base_Company> > result = new Result <List <Base_Company> >(); try { using (BasicDataContext baseDataContext = new BasicDataContext()) { result = DataOperate.QueryListSimple <Base_Company>(baseDataContext, qc); if (result.Flag == EResultFlag.Success && result.Data != null && result.Data.Any()) { string[] regionCodes = result.Data.Where(p => !string.IsNullOrWhiteSpace(p.Address)) .Select(p => p.Address.Split(',').LastOrDefault()).Distinct().ToArray(); if (regionCodes.Any()) { var regionModels = baseDataContext.Base_Region.Where(p => regionCodes.Contains(p.RegionCode)) .ToDictionary(p => p.RegionCode, p => p.Fullname); if (regionModels.Any()) { result.Data.ForEach(p => { if (!string.IsNullOrWhiteSpace(p.Address)) { string regeionCode = p.Address.Split(',').LastOrDefault(); if (regionModels.Keys.Contains(regeionCode)) { p.RegionName = regionModels[regeionCode]; } } }); } } } } } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetCompanyListByType"); } return(result); }
/// <summary> /// 获取签证列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Epm_Visa> > GetVisaListByQc(QueryCondition qc) { Result <List <Epm_Visa> > result = new Result <List <Epm_Visa> >(); try { AddDefaultWeb(qc); result = DataOperate.QueryListSimple <Epm_Visa>(context, qc); return(result); } catch (Exception ex) { result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetVisaListByQc"); result.AllRowsCount = -1; result.Data = null; } return(result); }
/// <summary> /// 获取可展示广告列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Epm_AdPutRecord> > GetAdShowList(QueryCondition qc) { Result <List <Epm_AdPutRecord> > result = new Result <List <Epm_AdPutRecord> >(); try { AddDefault(qc); qc.ConditionList.Add(new ConditionExpression() { ExpName = "State", ExpValue = 1, ExpOperater = eConditionOperator.Equal, ExpLogical = eLogicalOperator.And }); qc.ConditionList.Add(new ConditionExpression() { ExpName = "StartTime", ExpValue = DateTime.Now, ExpOperater = eConditionOperator.LessThanOrEqual, ExpLogical = eLogicalOperator.And }); qc.ConditionList.Add(new ConditionExpression() { ExpName = "EndTime", ExpValue = DateTime.Now, ExpOperater = eConditionOperator.GreaterThanOrEqual, ExpLogical = eLogicalOperator.And }); result = DataOperate.QueryListSimple <Epm_AdPutRecord>(context, qc); } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetAdList"); } finally { } return(result); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <Base_User> > GetUserList(QueryCondition qc) { qc = AddDefault(qc); Result <List <Base_User> > result = new Result <List <Base_User> >(); try { using (BasicDataContext baseDataContext = new BasicDataContext()) { result = DataOperate.QueryListSimple <Base_User>(baseDataContext, qc); } } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetUserList"); } return(result); }
/// <summary> /// 获取沟通列表集合 /// </summary> /// <param name="qc"></param> /// <returns></returns> public Result <List <QuestionModel> > GetQuestions(QueryCondition qc) { Result <List <QuestionModel> > result = new Result <List <QuestionModel> >(); try { if (qc == null) { qc = new QueryCondition() { PageInfo = new PageListInfo() { isAllowPage = true } }; } qc.ConditionList.Add(new ConditionExpression() { ExpName = "IsDelete", ExpValue = false, ExpLogical = eLogicalOperator.And, ExpOperater = eConditionOperator.Equal }); qc.SortList.Add(new SortExpression() { SortName = "OperateTime", SortType = eSortType.Desc }); var questionResult = DataOperate.QueryListSimple <Epm_Approver>(context, qc); if (questionResult.Flag == EResultFlag.Success && questionResult.Data != null && questionResult.Data.Any()) { List <QuestionModel> list = questionResult.Data.Select(p => new QuestionModel() { id = p.Id, name = p.Title ?? "", submitTime = p.SendTime, type = p.BusinessTypeNo ?? "", state = p.State ?? 0, createUserId = p.SendUserId ?? 0, submitUserName = p.SendUserName ?? "", workContent = p.Content ?? "", businessId = p.BusinessId ?? 0, businessState = p.BusinessState ?? 0, projectId = p.ProjectId ?? 0, projectName = p.ProjectName ?? "", businessChild = p.BussinesChild, action = p.Action }).ToList(); var businessIds = list.Select(p => p.businessId).Distinct().ToList(); if (businessIds.Any()) { // 业务问题数 var questions = DataOperateBusiness <Epm_Question> .Get().GetList(p => businessIds.Contains(p.BusinessId.Value)); var questionCount = questions.GroupBy(p => p.BusinessId).Select(p => new { key = p.Key, count = p.Count(x => x.BusinessId == p.Key) }).ToDictionary(p => p.key, p => p.count); // 问题回复数 var questionTracks = DataOperateBusiness <Epm_QuestionTrack> .Get().GetList(p => businessIds.Contains(p.QuestionId.Value)); var questionTrackCount = questionTracks.GroupBy(p => p.QuestionId).Select(p => new { key = p.Key, count = p.Count(x => x.QuestionId == p.Key) }).ToDictionary(p => p.key, p => p.count); list.ForEach(p => { p.answerCount = questionCount.ContainsKey(p.businessId) ? questionCount[p.businessId] : (questionTrackCount.ContainsKey(p.businessId) ? questionTrackCount[p.businessId] : 0); }); } result.Data = list; result.AllRowsCount = questionResult.AllRowsCount; result.Flag = EResultFlag.Success; } else { string msg = "暂无相关数据!"; if (result.Exception != null) { msg = result.Exception.Decription; } throw new Exception(msg); } } catch (Exception ex) { result.Data = null; result.AllRowsCount = 0; result.Flag = EResultFlag.Success; result.Exception = new ExceptionEx(ex, "GetQuestions"); } return(result); }
/// <summary> /// 获取登录用户待办事项总数和未读消息总数 /// </summary> /// <returns></returns> public Result <Dictionary <string, int> > GetApproverCount(long UserId) { Result <Dictionary <string, int> > result = new Result <Dictionary <string, int> >(); int approvalCount = 0; int unreadMsg = 0; Dictionary <string, int> dic = new Dictionary <string, int>(); try { QueryCondition approverQc = new QueryCondition() { PageInfo = new PageListInfo() { isAllowPage = false } }; AddDefault(approverQc); approverQc.ConditionList.Add(new ConditionExpression() { ExpName = "ApproverId", ExpValue = UserId, ExpOperater = eConditionOperator.Equal, ExpLogical = eLogicalOperator.And }); approverQc.ConditionList.Add(new ConditionExpression() { ExpName = "IsApprover", ExpValue = false, ExpOperater = eConditionOperator.Equal, ExpLogical = eLogicalOperator.And }); var approverResult = DataOperate.QueryListSimple <Epm_Approver>(context, approverQc); approvalCount = approverResult.AllRowsCount; QueryCondition msgQc = new QueryCondition() { PageInfo = new PageListInfo() { isAllowPage = false } }; AddDefault(msgQc); msgQc.ConditionList.Add(new ConditionExpression() { ExpName = "SendId", ExpValue = UserId, ExpOperater = eConditionOperator.Equal, ExpLogical = eLogicalOperator.And }); msgQc.ConditionList.Add(new ConditionExpression() { ExpName = "IsRead", ExpValue = false, ExpOperater = eConditionOperator.Equal, ExpLogical = eLogicalOperator.And }); var msgResult = DataOperate.QueryListSimple <Epm_Approver>(context, msgQc); unreadMsg = msgResult.Data.Count; } finally { dic.Add("approvalCount", approvalCount); dic.Add("unreadMsg", unreadMsg); result.Data = dic; result.Flag = EResultFlag.Success; } return(result); }
///<summary> ///获取列表: ///</summary> /// <param name="qc">查询条件</param> /// <returns>符合条件的数据集合</returns> public Result <List <TrainView> > GetTrainList(QueryCondition qc) { qc = AddDefaultWeb(qc); Result <List <TrainView> > result = new Result <List <TrainView> >(); try { QueryCondition qcTrain = new QueryCondition(); qcTrain.PageInfo = qc.PageInfo; qcTrain.SortList = qc.SortList; QueryCondition qcCompany = new QueryCondition(); foreach (var item in qc.ConditionList) { if (item.ExpName == "CompanyIds") { qcCompany.ConditionList.Add(new ConditionExpression() { ExpName = "CompanyId", ExpValue = item.ExpValue, ExpLogical = item.ExpLogical, ExpOperater = item.ExpOperater }); } else if (item.ExpName == "CompanyNames") { qcCompany.ConditionList.Add(new ConditionExpression() { ExpName = "CompanyName", ExpValue = item.ExpValue, ExpLogical = item.ExpLogical, ExpOperater = item.ExpOperater }); } else { qcTrain.ConditionList.Add(item); } } var res = DataOperate.QueryListSimple <Epm_Train>(context, qcTrain); List <TrainView> list = new List <TrainView>(); if (res.Data.Count > 0)//显示单位 { ConditionExpression ce = new ConditionExpression(); ce.ExpName = "TrainId"; ce.ExpValue = string.Join(",", res.Data.Select(t => t.Id)); ce.ExpOperater = eConditionOperator.In; qcCompany.ConditionList.Add(ce); var companys = DataOperate.QueryListSimple <Epm_TrainCompany>(context, qcCompany); foreach (Epm_Train item in res.Data) { var com = companys.Data.Where(t => t.TrainId == item.Id).ToList(); list.Add(EmpToView(item, com)); } } result.AllRowsCount = res.AllRowsCount; result.Flag = res.Flag; result.Data = list; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetTrainList"); } return(result); }