作业本送货变二级菜单

username@email.com

3 天以前 e8e3122fdc4844202fb9e05477d47139e47a8aae

 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 + "'";