/// <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);
}