From bda15c5427010f9a422fc5c2b338e7cfdd2117af Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 23 九月 2025 12:24:17 +0800
Subject: [PATCH] 体骄傲
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs | 141 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 137 insertions(+), 4 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
index fad64df..bbe7292 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
@@ -61,7 +61,9 @@
new SqlParameter("@PlanType", trueModel.PlanType) ,
new SqlParameter("@PlanDataType", trueModel.PlanDataType) ,
new SqlParameter("@PlanTitle", trueModel.PlanTitle) ,
- new SqlParameter("@PlanContent", trueModel.PlanContent)
+ new SqlParameter("@PlanContent", trueModel.PlanContent) ,
+ new SqlParameter("@HoubufapiaoStatus", trueModel.HoubufapiaoStatus.HasValue?trueModel.HoubufapiaoStatus.Value:3) ,
+ new SqlParameter("@WufapiaoStatus", trueModel.WufapiaoStatus.HasValue?trueModel.WufapiaoStatus.Value:3) ,
};
try
{
@@ -73,6 +75,71 @@
}
return true;
}
+
+
+
+ /// <summary>
+ /// 鏂板
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ public int InserModelAndGetId(OA_WorkPlan trueModel)
+ {
+
+ if (trueModel == null)
+ {
+ return 0;
+ }
+ IList<SqlParameter> sqlParms = new List<SqlParameter>()
+ {
+ new SqlParameter("@PlanRunTime", trueModel.PlanRunTime) ,
+ new SqlParameter("@PlanMoney", trueModel.PlanMoney) ,
+ new SqlParameter("@PlanRemark", trueModel.PlanRemark) ,
+ new SqlParameter("@PlanStartTime", trueModel.PlanStartTime) ,
+ new SqlParameter("@PlanPeople", trueModel.PlanPeople) ,
+ new SqlParameter("@PlanComplany", trueModel.PlanComplany) ,
+ new SqlParameter("@PlanStatus", trueModel.PlanStatus) ,
+ new SqlParameter("@ApprovalStaffId", trueModel.ApprovalStaffId) ,
+ new SqlParameter("@ApprovalStatus", trueModel.ApprovalStatus) ,
+ new SqlParameter("@ApprovalTime", trueModel.ApprovalTime) ,
+ new SqlParameter("@MemberId", trueModel.MemberId) ,
+ new SqlParameter("@ApprovalContent", trueModel.ApprovalContent) ,
+ new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,
+ new SqlParameter("@Operator", trueModel.Operator) ,
+ new SqlParameter("@EvaluationStatus", trueModel.EvaluationStatus) ,
+ new SqlParameter("@EvaluationContent", trueModel.EvaluationContent) ,
+ new SqlParameter("@EvaluationStaffId", trueModel.EvaluationStaffId) ,
+ new SqlParameter("@EvaluationTime", trueModel.EvaluationTime) ,
+ new SqlParameter("@RewardType", trueModel.RewardType) ,
+ new SqlParameter("@RewardContent", trueModel.RewardContent) ,
+ new SqlParameter("@RewardResult", trueModel.RewardResult) ,
+ new SqlParameter("@SentStaffId", trueModel.SentStaffId) ,
+ new SqlParameter("@RewardMoney", trueModel.RewardMoney) ,
+ new SqlParameter("@DepartId", trueModel.DepartId) ,
+ new SqlParameter("@ReciveStaffId", trueModel.ReciveStaffId) ,
+ new SqlParameter("@PlanType", trueModel.PlanType) ,
+ new SqlParameter("@PlanDataType", trueModel.PlanDataType) ,
+ new SqlParameter("@PlanTitle", trueModel.PlanTitle) ,
+ new SqlParameter("@PlanContent", trueModel.PlanContent) ,
+ new SqlParameter("@HoubufapiaoStatus", trueModel.HoubufapiaoStatus.HasValue?trueModel.HoubufapiaoStatus.Value:3) ,
+ new SqlParameter("@WufapiaoStatus", trueModel.WufapiaoStatus.HasValue?trueModel.WufapiaoStatus.Value:3) ,
+ };
+ string sql = "Insert Into OA_WorkPlan ([PlanRunTime],[PlanMoney],[PlanRemark],[PlanStartTime], [PlanPeople], [PlanComplany],[PlanStatus], [ApprovalStaffId],[ApprovalStatus], [ApprovalTime],[MemberId],[ApprovalContent],[LastUpdateTime],[Operator],EvaluationStatus,EvaluationContent,EvaluationStaffId,EvaluationTime,RewardType,RewardContent,RewardResult,SentStaffId,RewardMoney,DepartId,ReciveStaffId,PlanType,PlanDataType,PlanTitle,PlanContent,HoubufapiaoStatus,WufapiaoStatus)"
+ + " Values ( @PlanRunTime,@PlanMoney,@PlanRemark, @PlanStartTime, @PlanPeople, @PlanComplany, @PlanStatus, @ApprovalStaffId, @ApprovalStatus, @ApprovalTime,@MemberId,@ApprovalContent,@LastUpdateTime,@Operator,@EvaluationStatus,@EvaluationContent,@EvaluationStaffId,@EvaluationTime,@RewardType,@RewardContent,@RewardResult,@SentStaffId,@RewardMoney,@DepartId,@ReciveStaffId,@PlanType,@PlanDataType,@PlanTitle,@PlanContent,@HoubufapiaoStatus,@WufapiaoStatus )";
+
+ int id = 0;
+ try
+ {
+ id = _dataBase.InsertDataAndGetId(sql, sqlParms.ToArray<SqlParameter>());
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ return id;
+ }
+
+
/// <summary>
/// 淇敼
@@ -117,7 +184,9 @@
new SqlParameter("@PlanType", trueModel.PlanType) ,
new SqlParameter("@PlanDataType", trueModel.PlanDataType) ,
new SqlParameter("@PlanTitle", trueModel.PlanTitle) ,
- new SqlParameter("@PlanContent", trueModel.PlanContent)
+ new SqlParameter("@PlanContent", trueModel.PlanContent) ,
+ new SqlParameter("@HoubufapiaoStatus", trueModel.HoubufapiaoStatus.HasValue?trueModel.HoubufapiaoStatus.Value:3) ,
+ new SqlParameter("@WufapiaoStatus", trueModel.WufapiaoStatus.HasValue?trueModel.WufapiaoStatus.Value:3) ,
};
try
{
@@ -206,6 +275,41 @@
}
}
+
+ /// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public OA_WorkPlan GetModelByFukuanshenqid(string PlanComplany, string RewardType)
+ {
+ try
+ {
+ string condi = "";
+ if (!string.IsNullOrEmpty(PlanComplany))
+ {
+ condi = " a.PlanComplany = '"+ PlanComplany + "' ";
+ }
+ else if (!string.IsNullOrEmpty(RewardType))
+ {
+ condi = " a.RewardType = '" + RewardType + "' ";
+ }
+ else
+ {
+ return null;
+ }
+
+ IList<OA_WorkPlan> result = _dataBase.SelectModel<OA_WorkPlan>(" a.* ", " OA_WorkPlan a ", condi) as IList<OA_WorkPlan>;//鎵ц鏌ヨ
+
+ return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
/// <summary>
/// 鍒嗛〉鏌ヨ
/// </summary>
@@ -225,7 +329,7 @@
/// <param name="EvaluationStatus"></param>
/// <param name="RewardType"></param>
/// <returns></returns>
- public IEnumerable<Model.OA_WorkPlan> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, Guid SentStaffId, Guid ReciveStaffId, int? PlanType, int? PlanDataType, string PlanTitle, DateTime? BeginPlanStartTime, DateTime? EndPlanStartTime, DateTime? BeginPlanRunTime, DateTime? EndPlanRunTime, string PlanPeople, int? PlanStatus, int? ApprovalStatus, int? EvaluationStatus, int? RewardType)
+ public IEnumerable<Model.OA_WorkPlan> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, Guid SentStaffId, Guid ReciveStaffId, int? PlanType, int? PlanDataType, string PlanTitle, DateTime? BeginPlanStartTime, DateTime? EndPlanStartTime, DateTime? BeginPlanRunTime, DateTime? EndPlanRunTime, string PlanPeople, int? PlanStatus, int? ApprovalStatus, int? EvaluationStatus, int? RewardType, string RewardContent = null, string PlanContent = null, string BaocunStatus = null)
{
try
{
@@ -248,7 +352,14 @@
}
if (PlanDataType > 0)
+ {
condition += " and a.PlanDataType = '" + PlanDataType + "'";
+ }
+ else
+ {
+ condition += " and a.PlanDataType != '17' ";
+ }
+
if (!string.IsNullOrEmpty(PlanTitle))
condition += " and a.PlanTitle like '%" + PlanTitle + "%'";
@@ -262,9 +373,13 @@
if (ApprovalStatus >= 0)
{
if (ApprovalStatus == 1)
- condition += " and ( a.ApprovalStatus = '1' or a.ApprovalStatus = '3' )";
+ condition += " and (( a.PlanDataType = 17 and a.ApprovalStatus = '1' ) or ( a.PlanDataType != 17 and (a.ApprovalStatus = '3' or a.ApprovalStatus = '1') ))";
else
condition += " and a.ApprovalStatus = '" + ApprovalStatus + "'";
+ }
+ if (!string.IsNullOrEmpty(BaocunStatus))
+ {
+ condition += " and a.ApprovalStatus != '" + BaocunStatus + "'";
}
if (EvaluationStatus >= 0)
{
@@ -272,6 +387,14 @@
condition += " and ( a.EvaluationStatus = '1' or a.EvaluationStatus = '2' )";
else
condition += " and a.EvaluationStatus = '" + EvaluationStatus + "'";
+ }
+ if (!string.IsNullOrWhiteSpace(RewardContent))
+ {
+ condition += " and a.RewardContent like '%" + RewardContent + "%'";
+ }
+ if (!string.IsNullOrWhiteSpace(PlanContent))
+ {
+ condition += " and a.PlanContent like '%" + PlanContent + "%'";
}
if (RewardType > 0)
@@ -289,6 +412,16 @@
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)
--
Gitblit v1.9.1