作业本送货变二级菜单

username@email.com

3 天以前 e8e3122fdc4844202fb9e05477d47139e47a8aae

 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",string.IsNullOrEmpty(trueModel.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 + "'";