/// <summary> /// 重启计划 /// </summary> /// <param name="keyValue"></param> /// <returns></returns> public bool DoAgin(string keyValue) { try { using (var tran = Trade_SQLDB.GetInstance().GetTransaction()) { //查询产品对应的订单明细 var orderdetailList = tbl_SalePlanDetai.Fetch(string.Format("select * from tbl_SalePlanDetai where SalePlanId='{0}'", keyValue)); foreach (var orderdetail in orderdetailList) { orderdetail.Status = (int)Trade.Model.Enums.ArrivalStatus.未到货; orderdetail.Update(); } //更改对应计划明细状态 Trade_SQLDB.GetInstance().Execute(string.Format("update tbl_SalePlan set PlanStatus='{0}' where SalePlanId='{1}'", (int)Trade.Model.Enums.PlanStatus.已生效, keyValue)); // Commit tran.Complete(); return(true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 处理到货业务 /// 更改对应相关产品的订单状态为到货 /// </summary> /// <param name="keys"></param> public bool DoDispose(string[] keys) { try { using (var tran = Trade_SQLDB.GetInstance().GetTransaction()) { foreach (var key in keys) { var plandetail = GetEntity(key); if (plandetail != null) { //查询产品对应的订单明细 var orderdetailList = tbl_OrderDetail.Fetch(string.Format("select * from tbl_OrderDetail where ProductId='{0}' and Status='{1}'", plandetail.ProductId, (int)Trade.Model.Enums.OrderDetailStatus.未到货)); foreach (var orderdetail in orderdetailList) { // Trade_SQLDB.GetInstance().Execute(string.Format("update tbl_OrderDetail set Status='{0}' where OrderdetailId='{1}'", (int)Trade.Model.Enums.OrderDetailStatus.已到货, orderdetail.OrderdetailId)); tbl_OrderDetail.Update("set Status=@0 where OrderdetailId=@1", (int)Trade.Model.Enums.OrderDetailStatus.已到货, orderdetail.OrderdetailId); } //更改对应计划明细状态 //Trade_SQLDB.GetInstance().Execute(string.Format("update tbl_SalePlanDetai set Status='{0}' where SalePlanDetaiId='{1}'", (int)Trade.Model.Enums.ArrivalStatus.已到货, plandetail.SalePlanDetaiId)); tbl_SalePlanDetai.Update("set Status=@0 where SalePlanDetaiId=@1", (int)Trade.Model.Enums.ArrivalStatus.已到货, plandetail.SalePlanDetaiId); } } // Commit tran.Complete(); return(true); } } catch (Exception ex) { throw ex; } }