菜单 行政管理=》行政管理=》问题反馈 /Pages/business/DeliverPlanPaicheList.aspx 06

username@email.com

2025-05-09 66beb245e516809514642c00922f0339bf760518

 CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs

@@ -238,9 +238,68 @@



         


 


        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_DeliverPlan> SelectModelPageWenti(Pagination pa, Guid FirmId,
    string DeliveredTimeStart, string DeliveredTimeEnd, string DriverId, string Zerenren , string CustormerName , string Wanjiestatus )
        {
            string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 and od.DeliveredTime is not null and od.wentifankui is not null and od.wentifankui!=''  ";
            string sort = "DeliveredTime desc   ";
             

            if (!string.IsNullOrEmpty(DeliveredTimeStart))
            {
                Condition += " and DATEDIFF(day,'" + DeliveredTimeStart + "',od.[DeliveredTime]) >= 0    ";
            }

            if (!string.IsNullOrEmpty(DeliveredTimeEnd))
            {
                Condition += " and DATEDIFF(day,'" + DeliveredTimeEnd + "',od.[DeliveredTime]) <= 0    ";
            }

            if (!string.IsNullOrEmpty(DriverId))
                Condition += " and  od.DriverId = '" + DriverId + "'";

            if (!string.IsNullOrEmpty(Zerenren))
                Condition += " and  od.Zerenren = '" + Zerenren + "'";
            if (!string.IsNullOrEmpty(CustormerName))
                Condition += " and  od.CompanyName like '%" + CustormerName + "%'";


            
           
            if (!string.IsNullOrEmpty(Wanjiestatus))
            {
                if (Wanjiestatus == "1")
                {
                    Condition += " and   od.Wanjiestatus = 1 ";
                }
                else
                {
                    Condition += " and ( od.Wanjiestatus is null   or   od.Wanjiestatus = 0 )";
                }

            }


            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),

                new Criterion("orderBy",sort)
            };
            query.Criteria = criterias;
            return _IOA_DeliverPlanPaicheDAL.SelectModelPageWenti(query, pa);
        }


    }
}