| | |
|---|
| | | if (EndPlanStartTime.HasValue) |
|---|
| | | condition += string.Format(" and CAST(a.PlanStartTime AS DATE) <='{0}'", EndPlanStartTime); |
|---|
| | | |
|---|
| | | |
|---|
| | | decimal heji1 = 0; |
|---|
| | | var ssss = _dataBase.SelectModel<Model.OA_WorkPlan>(" sum(a.[PlanMoney]) as PlanMoney ", " OA_WorkPlan AS a ", condition); |
|---|
| | | if (ssss.Count > 0) |
|---|
| | | { |
|---|
| | | var aaaaa = ssss.First(); |
|---|
| | | heji1 += (aaaaa.PlanMoney.HasValue ? aaaaa.PlanMoney.Value : 0); |
|---|
| | | } |
|---|
| | | pagination.heji1 = heji1; |
|---|
| | | |
|---|
| | | return _dataBase.SelectModelPage<Model.OA_WorkPlan>(pagination, " a.*,b.Name as SentStaffName,c.Name as ReciveStaffName,d.Name as ApprovalStaffName,e.Name as EvaluationStaff,f.Name as PlanDataTypeName ", " OA_WorkPlan AS a LEFT JOIN dbo.EC_MemberBasic AS b ON a.SentStaffId = b.MemberId LEFT JOIN dbo.EC_MemberBasic AS c ON a.ReciveStaffId = c.MemberId LEFT JOIN dbo.EC_MemberBasic AS d ON a.ApprovalStaffId = d.MemberId LEFT JOIN dbo.EC_MemberBasic AS e ON a.EvaluationStaffId = e.MemberId LEFT JOIN dbo.Sys_Dictionary AS f ON a.PlanDataType = f.MeanValue AND f.DicType='工作计划性质' ", " a.PlanStartTime desc", " PlanStartTime desc ", condition); |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
