/// <summary> /// 修改采购计划单 /// </summary> /// <param name="info"> </param> /// <returns> </returns> public bool UpdateInfo(MMS_Delivery_Detail info) { var query = from item in dc.MMS_Delivery_Detail where item.Delivery_id == info.Delivery_id select item; BatchEvaluate.Eval(info, query.First()); dc.SubmitChanges(); return(true); }
/// <summary> /// 修改采购计划单 /// </summary> /// <param name="info"> </param> /// <returns> </returns> public bool UpdateInfo(MMS_Delivery_Detail info) { return(dao.UpdateInfo(info)); }
/// <summary> /// 插入采购计划单 /// </summary> /// <param name="info"> </param> /// <returns> </returns> public int InsertInfo(MMS_Delivery_Detail info) { return(dao.InsertInfo(info)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Buffer = true; context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1.0); context.Response.AddHeader("pragma", "no-cache"); context.Response.AddHeader("cache-control", ""); context.Response.CacheControl = "no-cache"; string Action = context.Request["action"]; int OutNum = 0; string Num = context.Request["num"]; var text = context.Request["key"]; try { if (text != null) { string[] str_data = text.Split(','); foreach (string str in str_data) { string str_replace = str.Replace('\"', ' '); str_replace = str_replace.Replace('[', ' '); str_replace = str_replace.Replace(']', ' '); str_replace = str_replace.Trim(); MMS_PurchasePlanDetail purPlanDetail = PurchasePlanService.Instance.GetInfoDetail(Convert.ToInt32(str_replace)); List <MMS_PurchaseDetail> Listpurdetail = PurchaseService.Instance.GetDetailPriceList(purPlanDetail.ProductCode, purPlanDetail.Price); Listpurdetail.Select(item => item.Quantity - item.UseQuantity > 0); Listpurdetail.OrderBy(item => item.PurchaseBillCode); if (Num.Trim() == "") { OutNum = purPlanDetail.Quantity; } else { OutNum = Convert.ToInt32(Num); } foreach (MMS_PurchaseDetail purdetail in Listpurdetail) { Int32 i = 0; if (purdetail.Quantity - purdetail.UseQuantity >= OutNum - purPlanDetail.CheckQuantity && OutNum - purPlanDetail.CheckQuantity > 0) { i = OutNum - Convert.ToInt32(purPlanDetail.CheckQuantity); purdetail.UseQuantity = purdetail.UseQuantity + (OutNum - Convert.ToInt32(purPlanDetail.CheckQuantity)); PurchaseService.Instance.UpdateInfoDetail(purdetail); purPlanDetail.CheckQuantity = OutNum; PurchasePlanService.Instance.UpdateInfoDetail(purPlanDetail); MMS_Delivery_Detail deliverDetail = new MMS_Delivery_Detail(); deliverDetail.PurchaseBillCode = purPlanDetail.PurchaseBillCode; deliverDetail.ProductCode = purPlanDetail.ProductCode; deliverDetail.Lot = purdetail.Lot; deliverDetail.Quantity = i; deliverDetail.Price = purdetail.Price; // deliverDetail.Operator = RequestSession.GetSessionUser().UserAccount.ToString(); deliverDetail.OperatorDate = DateTime.Now; DeliveryInfoService.Instance.InsertInfo(deliverDetail); break; } else { if (purdetail.Quantity - purdetail.UseQuantity > 0) { if ((OutNum - purPlanDetail.CheckQuantity) > (purdetail.Quantity - purdetail.UseQuantity)) { i = Convert.ToInt32(purdetail.Quantity) - Convert.ToInt32(purdetail.UseQuantity); purPlanDetail.CheckQuantity = Convert.ToInt32(purPlanDetail.CheckQuantity) + (Convert.ToInt32(purdetail.Quantity) - Convert.ToInt32(purdetail.UseQuantity)); PurchasePlanService.Instance.UpdateInfoDetail(purPlanDetail); purdetail.UseQuantity = purdetail.Quantity; PurchaseService.Instance.UpdateInfoDetail(purdetail); } MMS_Delivery_Detail deliverDetail = new MMS_Delivery_Detail(); deliverDetail.PurchaseBillCode = purPlanDetail.PurchaseBillCode; deliverDetail.ProductCode = purPlanDetail.ProductCode; deliverDetail.Lot = purdetail.Lot; deliverDetail.Quantity = i; deliverDetail.Price = purdetail.Price; // deliverDetail.Operator = HttpContext.Current.Session["UserName"].ToString(); deliverDetail.OperatorDate = DateTime.Now; DeliveryInfoService.Instance.InsertInfo(deliverDetail); } } } } } else { context.Session.Abandon(); context.Session.Clear(); context.Response.Write(1); context.Response.End(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 插入发货单 /// </summary> /// <param name="info"> </param> /// <returns> </returns> public int InsertInfo(MMS_Delivery_Detail info) { dc.MMS_Delivery_Detail.InsertOnSubmit(info); dc.SubmitChanges(); return(info.Delivery_id); }