From a7711b47c02807531f04313ae829584310f37aba Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 28 十一月 2025 12:17:10 +0800
Subject: [PATCH] 你们明天在那个公文管理公文管理那个操作操作界面增加一个审核， 好点审核呢，实际上是修改这个只有我才有一个权限， 只是只有我一个人，因为现在来看他们。相当于说， 没经过我审核，他们整些你看嘛，发你妈一些公文， 像狗屎一样，格式都不对头，在这儿乱在这儿乱写啊， 必须就是我，我审核，我点审核，你相就是复制一个修改过嘛， 相当于就是。好，必须是我，我点了审核好后头我修改好了， 提交好了才能发布。只要我没在审核里头的话，好，这个就发布不了 。好怀疑着呢，怀疑怀疑着来修改，还是在修改里头整？
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
index 7f58467..8f6e6fa 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
@@ -105,6 +105,7 @@
new SqlParameter("@Jusequanxian",string.IsNullOrEmpty(trueModel.Jusequanxian)?"":trueModel.Jusequanxian) ,
new SqlParameter("@Konghangshu", trueModel.Konghangshu.HasValue?trueModel.Konghangshu.Value:0) ,
+ new SqlParameter("@Shifoushenpi",trueModel.Shifoushenpi.HasValue?trueModel.Shifoushenpi.Value:0) ,
};
try
{
@@ -192,7 +193,7 @@
/// </summary>
/// <param name="pagination"></param>
/// <returns></returns>
- public IEnumerable<Model.OA_Document> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _FirmId, DateTime? _BeginDM_PromulgatedDate, DateTime? _EndDM_PromulgatedDate, int? _DM_Status, int? _DM_PostingId, string _DM_PostingName, string _DM_PostingFirmName, string _DM_DocumentType, string _DM_DocumentNumber, string _DM_Title, string _DM_Content, string _DM_ThemeWords, string _DM_CCUnit, int? _DM_PrintNumber, int? _DM_Number, DateTime? _BeginDM_DelTime, DateTime? _EndDM_DelTime, DateTime? _BeginDM_PrintTime, DateTime? _EndDM_PrintTime, int? _DM_PrintStatus, DateTime? _BeginLastUpdateTime, DateTime? _EndLastUpdateTime, string _Operator)
+ public IEnumerable<Model.OA_Document> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _FirmId, DateTime? _BeginDM_PromulgatedDate, DateTime? _EndDM_PromulgatedDate, int? _DM_Status, int? _DM_PostingId, string _DM_PostingName, string _DM_PostingFirmName, string _DM_DocumentType, string _DM_DocumentNumber, string _DM_Title, string _DM_Content, string _DM_ThemeWords, string _DM_CCUnit, int? _DM_PrintNumber, int? _DM_Number, DateTime? _BeginDM_DelTime, DateTime? _EndDM_DelTime, DateTime? _BeginDM_PrintTime, DateTime? _EndDM_PrintTime, int? _DM_PrintStatus, DateTime? _BeginLastUpdateTime, DateTime? _EndLastUpdateTime, string _Operator, int? Shifoushenpi)
{
try
{
@@ -210,6 +211,19 @@
if (_DM_Status.HasValue)
condition += " and DM_Status = '" + _DM_Status + "'";
+ if (Shifoushenpi.HasValue)
+ {
+ if(Shifoushenpi.Value == 1)
+ {
+ condition += " and Shifoushenpi = " + Shifoushenpi + "";
+ }
+ else
+ {
+ condition += " and ( Shifoushenpi is null or Shifoushenpi = " + Shifoushenpi + " )";
+ }
+ }
+
+
if (_DM_PostingId.HasValue)
condition += " and DM_PostingId = '" + _DM_PostingId + "'";
--
Gitblit v1.9.1