From e8e3122fdc4844202fb9e05477d47139e47a8aae Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 12 十二月 2025 08:59:47 +0800
Subject: [PATCH] 作业本送货变二级菜单
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs | 25 +++++++++++++++++++++----
1 files changed, 21 insertions(+), 4 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
index 6a4ee89..8f6e6fa 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs
@@ -55,8 +55,9 @@
new SqlParameter("@DM_PrintTime", trueModel.DM_PrintTime) ,
new SqlParameter("@DM_PrintStatus", trueModel.DM_PrintStatus) ,
new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,
- new SqlParameter("@Operator", trueModel.Operator)
- };
+ new SqlParameter("@Operator", trueModel.Operator) ,
+ new SqlParameter("@Konghangshu", trueModel.Konghangshu.HasValue?trueModel.Konghangshu.Value:0) ,
+ };
try
{
_dataBase.Query("sp_OA_Document_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
@@ -101,7 +102,10 @@
new SqlParameter("@DM_PrintStatus", trueModel.DM_PrintStatus) ,
new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,
new SqlParameter("@Operator", trueModel.Operator),
- new SqlParameter("@Jusequanxian", trueModel.Jusequanxian),
+ 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
{
@@ -189,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
{
@@ -207,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