作业本送货变二级菜单

username@email.com

4 天以前 e8e3122fdc4844202fb9e05477d47139e47a8aae

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs

@@ -388,7 +388,7 @@
        /// <param name="MemberId"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_SpecialOrders> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string PrintName, string
CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime)
CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime, string PSF_PressesDesk)
        {
            try
            {
@@ -419,7 +419,10 @@
                {
                    Condition += string.Format(" and   PSO_OrderNum like '%{0}%'", PSO_OrderNum);
                }

                if (!string.IsNullOrEmpty(PSF_PressesDesk))
                {
                    Condition += string.Format(" and   a.[Keyid] not in ( select [SpecialOrderId] from [EC_SpecialForums] where  [PSF_PressesDesk] = '{0}')", PSF_PressesDesk);
                }

                return _dataBase.SelectModelPage<Model.EC_SpecialOrders>(pagination, " a.*,b.BuyerName as CustomName,b.DocumentName as PrintName ", " EC_SpecialOrders as a left join EC_OrderBasic as b on a.PO_OrderId = b.Keyid ", " PSO_OrderNum DESC ", " PSO_OrderNum DESC ", Condition);
            }