From f0c21ec9c1e9c7cd5db58caeb760c7d7ca6df002 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 16 十二月 2025 08:47:56 +0800
Subject: [PATCH] 公文管理中，“主题词”和“抄送”的字体改为粗宋 完成
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_StaffDAL.cs | 18 +++++++++++++++---
1 files changed, 15 insertions(+), 3 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_StaffDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_StaffDAL.cs
index 5bf7d7d..1063f94 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_StaffDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_StaffDAL.cs
@@ -96,7 +96,13 @@
new SqlParameter("@ManageProvince", trueModel.ManageProvince) ,
new SqlParameter("@ManageCity", trueModel.ManageCity) ,
new SqlParameter("@ManageCountry", trueModel.ManageCountry) ,
- new SqlParameter("@ManageCountry1", trueModel.ManageCountry1)
+ new SqlParameter("@ManageCountry1", trueModel.ManageCountry1) ,
+ new SqlParameter("@BF_IsDeliverManage", trueModel.BF_IsDeliverManage) ,
+ new SqlParameter("@BF_IsDriver", trueModel.BF_IsDriver) ,
+ new SqlParameter("@BF_Isbaoxiaojingli", trueModel.BF_Isbaoxiaojingli) ,
+ new SqlParameter("@BF_IsBaoxiaozhuguan", trueModel.BF_IsBaoxiaozhuguan) ,
+ new SqlParameter("@BF_IsGongwen", trueModel.BF_IsGongwen.HasValue?trueModel.BF_IsGongwen.Value:false) ,
+ new SqlParameter("@BF_IsChangyongziliao", trueModel.BF_IsChangyongziliao.HasValue?trueModel.BF_IsChangyongziliao.Value:false) ,
};
try
{
@@ -186,7 +192,13 @@
new SqlParameter("@ManageProvince", trueModel.ManageProvince) ,
new SqlParameter("@ManageCity", trueModel.ManageCity) ,
new SqlParameter("@ManageCountry", trueModel.ManageCountry) ,
- new SqlParameter("@ManageCountry1", trueModel.ManageCountry1)
+ new SqlParameter("@ManageCountry1", trueModel.ManageCountry1) ,
+ new SqlParameter("@BF_IsDeliverManage", trueModel.BF_IsDeliverManage) ,
+ new SqlParameter("@BF_IsDriver", trueModel.BF_IsDriver) ,
+ new SqlParameter("@BF_Isbaoxiaojingli", trueModel.BF_Isbaoxiaojingli) ,
+ new SqlParameter("@BF_IsBaoxiaozhuguan", trueModel.BF_IsBaoxiaozhuguan) ,
+ new SqlParameter("@BF_IsGongwen", trueModel.BF_IsGongwen.HasValue?trueModel.BF_IsGongwen.Value:false) ,
+ new SqlParameter("@BF_IsChangyongziliao", trueModel.BF_IsChangyongziliao.HasValue?trueModel.BF_IsChangyongziliao.Value:false) ,
};
try
{
@@ -321,7 +333,7 @@
{
condition += " and a.DepartmentId = '" + DepartmentId + "'";
}
- return _dataBase.SelectModelPage<Model.OA_Staff>(pagination, " a.*,b.Name as DepartmentName ", " dbo.OA_Staff AS a LEFT JOIN dbo.OA_Department AS b ON a.DepartmentId = b.Keyid ", "a.Status DESC,a.DepartmentId ASC ", " Status DESC,DepartmentId ASC ", condition);
+ return _dataBase.SelectModelPage<Model.OA_Staff>(pagination, " a.*,b.Name as DepartmentName ", " dbo.OA_Staff AS a LEFT JOIN dbo.OA_Department AS b ON a.DepartmentId = b.Keyid ", "a.Status DESC,a.DepartmentId ASC ,a.SM_Post DESC", " Status DESC,DepartmentId ASC,SM_Post DESC ", condition);
}
catch (Exception ex)
{
--
Gitblit v1.9.1