| | |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 修改 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="model"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public bool UpdateDeliveryTimeTime(EC_OrderExtend model) |
|---|
| | | { |
|---|
| | | |
|---|
| | | Model.EC_OrderExtend trueModel = model; |
|---|
| | | if (trueModel == null) |
|---|
| | | { |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | IList<SqlParameter> sqlParms = new List<SqlParameter>() |
|---|
| | | { |
|---|
| | | |
|---|
| | | new SqlParameter("@Keyid",trueModel.Keyid), |
|---|
| | | |
|---|
| | | new SqlParameter("@DelayTime",trueModel.DelayTime), |
|---|
| | | |
|---|
| | | }; |
|---|
| | | string sql = " Update EC_OrderBasic Set [DeliveryTime]=@DelayTime where [Keyid]=@Keyid ; Update [EC_OrderExtend] Set [DelayTime]=@DelayTime where [Keyid] = @Keyid ;"; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | | throw ex; |
|---|
| | | } |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 修改 |
|---|
| | | /// </summary> |
|---|
| | |
|---|
| | | left join [Sys_Dictionary] expiretype on expiretype.DicType='到期时间' and expiretype.MeanValue = oc.Expiretype |
|---|
| | | left join ( select ob.BuyerId,sum(ob.SumPrice) SumPrice,sum(ts.PayedMoney) PayedMoney ,COUNT(*) as shuliang |
|---|
| | | from EC_OrderBasic ob Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid) Inner Join Pay_TradingSingle as ts On(ob.Keyid = ts.OrderId) |
|---|
| | | left join EC_AwbInfo ea on ob.Keyid = ea.Keyid |
|---|
| | | left join EC_AwbInfo ea on ob.Keyid = ea.Keyid Inner Join OA_CorporateClients occ on ob.BuyerId = occ.Keyid where (occ.WanjieTime IS NULL OR DATEDIFF(DAY,occ.WanjieTime,ob.CreateTime)>=0) |
|---|
| | | |
|---|
| | | group by ob.BuyerId ) ob on oc.Keyid = ob.BuyerId |
|---|
| | | |
|---|
