| | |
|---|
| | | /// 查询来源 |
|---|
| | | /// </summary> |
|---|
| | | const string FROMSOUCEBEFORE = " ( select distinct od.*,d_Shifouwanjie.Name as TransferstatusName, " + |
|---|
| | | " oe.CompanyName as BuyerName,eo.shuliang, os.Name as BusinessManager,od.Dizhi+' 联系人：'+od.Lianxiren+' 电话：'+od.Dianhua as DizhiLianxirenDianhua, " + |
|---|
| | | " od.CompanyName as BuyerName,eo.shuliang, os.Name as BusinessManager,od.Dizhi+' 联系人：'+od.Lianxiren+' 电话：'+od.Dianhua as DizhiLianxirenDianhua, " + |
|---|
| | | " ocar.[CarNumber] as CarName,oss.Name as DriverName " + |
|---|
| | | " from [OA_DeliverPlan] od inner join [OA_CorporateClients] oe on oe.Keyid = od.[BuyerId] " + |
|---|
| | | " from [OA_DeliverPlan] od left join [OA_CorporateClients] oe on oe.Keyid = od.[BuyerId] " + |
|---|
| | | // " inner join (select count(*) as shuliang,eo.BuyerId,ISNULL(eoe.DelayTime,eo.DeliveryTime) DeliveryTime from [EC_OrderBasic] eo inner join [EC_OrderExtend] eoe on eo.Keyid=eoe.Keyid where eo.OrderState =4 group by eo.BuyerId,ISNULL(eoe.DelayTime,eo.DeliveryTime) ) eo on oe.Keyid =eo.BuyerId " + |
|---|
| | | " left join (select count(*) as shuliang,eoe.DeliveryOrderId from [EC_OrderBasic] eo ,[EC_OrderExtend] eoe where eoe.Keyid=eo.Keyid group by eoe.DeliveryOrderId ) eo on od.Keyid =eo.DeliveryOrderId " + // eo.OrderState =4 |
|---|
| | | " inner join [OA_CustomerCommunications] oc on oe.Keyid = oc.Keyid " + |
|---|
| | | // " inner join [OA_CustomerCommunications] oc on oe.Keyid = oc.Keyid " + |
|---|
| | | //" left join [OA_DeliverPlan] od on oe.Keyid = od.[BuyerId] and DATEDIFF(day,eo.[DeliveryTime], od.[DeliverTime])=0 " + |
|---|
| | | " left join [OA_Staff] os on oe.BusinessManagerId = os.Keyid " + |
|---|
| | | " left join [OA_Staff] os on od.BusinessManagerId = os.Keyid " + |
|---|
| | | " left join [OA_CarManage] ocar on od.[CarId] = ocar.Keyid " + |
|---|
| | | " left join [OA_Staff] oss on od.[DriverId] = oss.Keyid " + |
|---|
| | | " Left Join Sys_Dictionary as d_Shifouwanjie On(d_Shifouwanjie.DicType= '送货单移交状态' and od.[Transferstatus]= d_Shifouwanjie.MeanValue) where 0=0 "; |
|---|
| | |
|---|
| | | new SqlParameter("@Biddingcompany",trueModel.Biddingcompany), |
|---|
| | | new SqlParameter("@shifouDelivery",trueModel.shifouDelivery), |
|---|
| | | new SqlParameter("@Lianxiren",trueModel.Lianxiren), |
|---|
| | | new SqlParameter("@CompanyName",trueModel.CompanyName), |
|---|
| | | }; |
|---|
| | | try |
|---|
| | | { |
|---|
| | |
|---|
| | | new SqlParameter("@Biddingcompany",trueModel.Biddingcompany), |
|---|
| | | new SqlParameter("@shifouDelivery",trueModel.shifouDelivery), |
|---|
| | | new SqlParameter("@Lianxiren",trueModel.Lianxiren), |
|---|
| | | new SqlParameter("@CompanyName",trueModel.CompanyName), |
|---|
| | | }; |
|---|
| | | try |
|---|
| | | { |
|---|
