//protected void RadComboBox1_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) //{ // int product = 0; // int.TryParse(RadComboBox1.SelectedValue, out product); // if (product != 0) // { // PDT_ProductBLL productbll = new PDT_ProductBLL(product); // if (productbll.Model == null) return; // PDT_Product p = productbll.Model; // Dictionary<string, Dictionary_Data> dic = DictionaryBLL.GetDicCollections("PDT_Packaging"); // string _T = dic[p.TrafficPackaging.ToString()].Name; // string _P = dic[p.Packaging.ToString()].Name; // #region 显示产品包装信息 // lb_TrafficPackagingName.Text = "元/" + _T + "(" + p.ConvertFactor.ToString() + _P + ")"; // #endregion // #region 获取销售该门店的价格 // decimal saleprice = PDT_StandardPriceBLL.GetSalePrice((int)ViewState["Client"], (int)Session["OwnerClient"], product); // if (saleprice > 0) // { // if (ddl_Unit.SelectedValue == "T") // tbx_Price.Text = (saleprice * p.ConvertFactor).ToString("0.###"); // else // tbx_Price.Text = saleprice.ToString("0.###"); // //tbx_Price.Enabled = false; // } // else // { // tbx_Price.Text = "0"; // //tbx_Price.Enabled = true; // } // #endregion // } //} protected void bt_Assign_Click(object sender, EventArgs e) { int deliveryman = 0, deliveryvehicle = 0, supplierwarehouse = 0; DateTime prearrivaldate = new DateTime(1900, 1, 1); if (Session["AssignFlag"] != null && (bool)Session["AssignFlag"]) { deliveryman = (int)Session["DeliveryMan"]; deliveryvehicle = (int)Session["DeliveryVehicle"]; supplierwarehouse = (int)Session["SupplierWareHouse"]; prearrivaldate = (DateTime)Session["PreArrivalDate"]; if ((int)ViewState["ID"] != 0) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); if (_bll.Model.State == 2) { int ret = _bll.CreateDelivery(supplierwarehouse, deliveryman, deliveryvehicle, prearrivaldate, (int)Session["UserID"]); if (ret > 0) { Response.Redirect("../Delivery/SaleOut/SaleOutDetail.aspx?ID=" + ret.ToString()); } else { MessageBox.Show(this, "派单失败!ret=" + ret.ToString()); } } } } }
/// <summary> /// 保存收款信息 /// </summary> private void SavePayInfo() { if ((int)ViewState["ID"] != 0) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); _bll.ClearPayInfo(); decimal amount = 0; if (decimal.TryParse(tbx_PayAmount1.Text, out amount) && amount != 0) { PBM_OrderPayInfoBLL paybll = new PBM_OrderPayInfoBLL(); paybll.Model.OrderID = _bll.Model.ID; paybll.Model.PayMode = int.Parse(ddl_PayMode1.SelectedValue); paybll.Model.Amount = amount; paybll.Model.ApproveFlag = 2; paybll.Model.InsertStaff = (int)Session["UserID"]; paybll.Add(); } if (decimal.TryParse(tbx_PayAmount2.Text, out amount) && amount != 0) { PBM_OrderPayInfoBLL paybll = new PBM_OrderPayInfoBLL(); paybll.Model.OrderID = _bll.Model.ID; paybll.Model.PayMode = int.Parse(ddl_PayMode2.SelectedValue); paybll.Model.Amount = amount; paybll.Model.ApproveFlag = 2; paybll.Model.InsertStaff = (int)Session["UserID"]; paybll.Add(); } } }
protected void bt_OK_Click(object sender, EventArgs e) { int client = 0, salesman = 0; int.TryParse(select_Client.SelectValue, out client); int.TryParse(ddl_Salesman.SelectedValue, out salesman); if (client == 0) { MessageBox.Show(this, "请正确选择零售店!"); return; } PBM_OrderBLL bll = new PBM_OrderBLL(); bll.Model.Supplier = (int)Session["OwnerClient"]; bll.Model.Client = client; bll.Model.SalesMan = salesman; bll.Model.Classify = (int)ViewState["Classify"] == 0 ? 1 : (int)ViewState["Classify"]; bll.Model.ArriveTime = DateTime.Parse(tbx_ArriveTime.Text); bll.Model.InsertStaff = (int)Session["UserID"]; bll.Model.State = 1; bll.Model.ApproveFlag = 2; int id = bll.Add(); Response.Redirect("OrderDetail.aspx?ID=" + id.ToString()); //Response.Redirect("SaleOutDeail.aspx?Supplier=" + ddl_Supplier.SelectedValue + // "&WareHouse=" + ddl_ClientWareHouse.SelectedValue + "&Salesman=" + ddl_Salesman.SelectedValue); }
protected void bt_OK_Click(object sender, EventArgs e) { int client = 0, salesman = 0; int.TryParse(select_Client.SelectValue, out client); int.TryParse(ddl_Salesman.SelectedValue, out salesman); if (client == 0) { MessageBox.Show(this, "请正确选择零售店!"); return; } PBM_OrderBLL bll = new PBM_OrderBLL(); bll.Model.Supplier = (int)Session["OwnerClient"]; bll.Model.Client = client; bll.Model.SalesMan = salesman; bll.Model.Classify = (int)ViewState["Classify"] == 0 ? 1 : (int)ViewState["Classify"]; bll.Model.ArriveTime = DateTime.Parse(tbx_ArriveTime.Text); bll.Model.InsertStaff = (int)Session["UserID"]; bll.Model.State = 1; bll.Model.ApproveFlag = 2; int id = bll.Add(); Response.Redirect("OrderDetail.aspx?ID=" + id.ToString()); //Response.Redirect("SaleOutDeail.aspx?Supplier=" + ddl_Supplier.SelectedValue + // "&WareHouse=" + ddl_ClientWareHouse.SelectedValue + "&Salesman=" + ddl_Salesman.SelectedValue); }
protected void bt_Assign_Click(object sender, EventArgs e) { int deliveryman = 0, deliveryvehicle = 0, supplierwarehouse = 0; DateTime prearrivaldate = new DateTime(1900, 1, 1); int.TryParse(ddl_DeliveryMan.SelectedValue, out deliveryman); int.TryParse(ddl_DeliveryVehicle.SelectedValue, out deliveryvehicle); int.TryParse(ddl_SupplierWareHouse.SelectedValue, out supplierwarehouse); DateTime.TryParse(tbx_PreArrivalDate.Text, out prearrivaldate); if (deliveryman == 0) { MessageBox.Show(this, "请选择订单配货时的发货员工!"); return; } if (supplierwarehouse == 0) { MessageBox.Show(this, "请选择订单配货时的发货仓库!"); return; } if (prearrivaldate < DateTime.Today) { MessageBox.Show(this, "要求送货日期不能小于今天!"); return; } int count = 0; foreach (GridViewRow row in gv_List.Rows) { int id = (int)gv_List.DataKeys[row.RowIndex]["PBM_Order_ID"]; CheckBox cbx = (CheckBox)row.FindControl("cbx"); if (cbx != null && cbx.Checked) { PBM_OrderBLL _bll = new PBM_OrderBLL(id); if (_bll.Model.State == 2) { int ret = _bll.CreateDelivery(supplierwarehouse, deliveryman, deliveryvehicle, prearrivaldate, (int)Session["UserID"]); if (ret > 0) { count++; } } } } MessageBox.Show(this, "成功派单" + count.ToString() + "条预售订单!"); BindGrid(); }
protected void bt_Assign_Click(object sender, EventArgs e) { int deliveryman = 0, deliveryvehicle = 0, supplierwarehouse = 0; DateTime prearrivaldate = new DateTime(1900, 1, 1); int.TryParse(ddl_DeliveryMan.SelectedValue, out deliveryman); int.TryParse(ddl_DeliveryVehicle.SelectedValue, out deliveryvehicle); int.TryParse(ddl_SupplierWareHouse.SelectedValue, out supplierwarehouse); DateTime.TryParse(tbx_PreArrivalDate.Text, out prearrivaldate); if (deliveryman == 0) { MessageBox.Show(this, "请选择订单配货时的发货员工!"); return; } if (supplierwarehouse == 0) { MessageBox.Show(this, "请选择订单配货时的发货仓库!"); return; } if (prearrivaldate < DateTime.Today) { MessageBox.Show(this, "要求送货日期不能小于今天!"); return; } int count = 0; foreach (GridViewRow row in gv_List.Rows) { int id = (int)gv_List.DataKeys[row.RowIndex]["PBM_Order_ID"]; CheckBox cbx = (CheckBox)row.FindControl("cbx"); if (cbx != null && cbx.Checked) { PBM_OrderBLL _bll = new PBM_OrderBLL(id); if (_bll.Model.State == 2) { int ret = _bll.CreateDelivery(supplierwarehouse, deliveryman, deliveryvehicle, prearrivaldate, (int)Session["UserID"]); if (ret > 0) count++; } } } MessageBox.Show(this, "成功派单" + count.ToString() + "条预售订单!"); BindGrid(); }
protected void bt_Cancel_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] != 0) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); int ret = _bll.Cancel((int)Session["UserID"], ""); if (ret == 0) { Response.Redirect("OrderList.aspx?Classify=" + _bll.Model.Classify.ToString()); } else { MessageBox.Show(this, "操作失败,返回值:" + ret.ToString()); } } }
protected void bt_Confirm_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] != 0) { if (!Save()) { return; } PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); int ret = _bll.Submit((int)Session["UserID"]); if (ret < 0) { MessageBox.Show(this, "对不起,订单提交失败!Ret=" + ret.ToString()); return; } else { Response.Redirect("OrderList.aspx?Classify=" + _bll.Model.Classify.ToString()); } } }
/// <summary> /// 保存收款信息 /// </summary> private void SavePayInfo() { if ((int)ViewState["ID"] != 0) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); _bll.ClearPayInfo(); decimal amount = 0; if (decimal.TryParse(tbx_PayAmount1.Text, out amount) && amount != 0) { PBM_OrderPayInfoBLL paybll = new PBM_OrderPayInfoBLL(); paybll.Model.OrderID = _bll.Model.ID; paybll.Model.PayMode = int.Parse(ddl_PayMode1.SelectedValue); paybll.Model.Amount = amount; paybll.Model.ApproveFlag = 2; paybll.Model.InsertStaff = (int)Session["UserID"]; paybll.Add(); } if (decimal.TryParse(tbx_PayAmount2.Text, out amount) && amount != 0) { PBM_OrderPayInfoBLL paybll = new PBM_OrderPayInfoBLL(); paybll.Model.OrderID = _bll.Model.ID; paybll.Model.PayMode = int.Parse(ddl_PayMode2.SelectedValue); paybll.Model.Amount = amount; paybll.Model.ApproveFlag = 2; paybll.Model.InsertStaff = (int)Session["UserID"]; paybll.Add(); } } }
private bool Save() { if (ViewState["Details"] == null) return false; ListTable<PBM_OrderDetail> Details = (ListTable<PBM_OrderDetail>)ViewState["Details"]; PBM_OrderBLL _bll; if ((int)ViewState["ID"] != 0) { //修改 _bll = new PBM_OrderBLL((int)ViewState["ID"]); } else { //新增 _bll = new PBM_OrderBLL(); } pl_detail.GetData(_bll.Model); #region 判断必填项 if (_bll.Model.Supplier == 0) { MessageBox.Show(this, "请正确选择供货商!"); return false; } if (_bll.Model.Client == 0) { MessageBox.Show(this, "请正确选择订货客户!"); return false; } #endregion //折扣价 _bll.Model.DiscountAmount = Details.GetListItem().Sum(p => (1 - p.DiscountRate) * Math.Round(p.Price * p.ConvertFactor, 2) * p.BookQuantity / p.ConvertFactor); //实际成交价 _bll.Model.ActAmount = Details.GetListItem().Sum(p => Math.Round(p.Price * p.ConvertFactor, 2) * p.BookQuantity / p.ConvertFactor) - _bll.Model.DiscountAmount - _bll.Model.WipeAmount; _bll.Model.ActAmount = Math.Round(_bll.Model.ActAmount, 2); if (_bll.Model.Classify == 2) _bll.Model.ActAmount = 0 - _bll.Model.ActAmount; //退库时,金额以负数计 if ((int)ViewState["ID"] != 0) { //修改 _bll.Model.UpdateStaff = (int)Session["UserID"]; #region 保存明细 if (ViewState["Details"] == null) return false; foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Added)) { _bll.AddDetail(d); } foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Modified)) { _bll.UpdateDetail(d); } foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Deleted)) { _bll.DeleteDetail(d.ID); } #endregion if (_bll.Update() == 0) { SavePayInfo(); return true; } } else { //新增 _bll.Model.InsertStaff = (int)Session["UserID"]; _bll.Items = Details.GetListItem(); ViewState["ID"] = _bll.Add(); if ((int)ViewState["ID"] > 0) { SavePayInfo(); return true; } } return false; }
private void BindData() { PBM_OrderBLL bll = new PBM_OrderBLL((int)ViewState["ID"]); if (bll.Model != null) { pl_detail.BindData(bll.Model); ViewState["Client"] = bll.Model.Client; ViewState["Supplier"] = bll.Model.Supplier; ViewState["Details"] = new ListTable<PBM_OrderDetail>(bll.Items, "ID"); ViewState["State"] = bll.Model.State; ViewState["Classify"] = bll.Model.Classify; #region 绑定收款信息 IList<PBM_OrderPayInfo> paylist = bll.GetPayInfoList(); if (paylist.Count > 0) { ddl_PayMode1.SelectedValue = paylist[0].PayMode.ToString(); tbx_PayAmount1.Text = paylist[0].Amount.ToString("0.##"); } if (paylist.Count > 1) { ddl_PayMode2.SelectedValue = paylist[1].PayMode.ToString(); tbx_PayAmount2.Text = paylist[1].Amount.ToString("0.##"); } #endregion BindGrid(); #region 界面控件可视状态 if (bll.Model.State != 1 || bll.Model.ApproveFlag != 2) { bt_OK.Visible = false; tb_AddDetail.Visible = false; bt_Delete.Visible = false; tr_AddDetail.Visible = false; pl_detail.SetControlsEnable(false); gv_List.Columns[gv_List.Columns.Count - 1].Visible = false; gv_List.Columns[gv_List.Columns.Count - 2].Visible = false; ddl_PayMode1.Enabled = false; ddl_PayMode2.Enabled = false; tbx_PayAmount1.Enabled = false; tbx_PayAmount2.Enabled = false; } if (bll.Model.State != 1) { bt_Submit.Visible = false; } if (bll.Model.State != 2) { bt_Cancel.Visible = false; bt_Assign.Visible = false; } #endregion } }
protected void bt_AddDetail_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] == 0) return; PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); if (ViewState["Details"] == null) return; ListTable<PBM_OrderDetail> Details = (ListTable<PBM_OrderDetail>)ViewState["Details"]; int product = 0; int.TryParse(select_Product.SelectValue, out product); //int.TryParse(RadComboBox1.SelectedValue, out product); if (product != 0) { PDT_ProductBLL productbll = new PDT_ProductBLL(product, true); if (productbll.Model == null) return; if (productbll.Model.ConvertFactor == 0) { productbll.Model.ConvertFactor = 1; productbll.Update(); } int quantity = 0; decimal price = 0; int.TryParse(tbx_Quantity.Text, out quantity); decimal.TryParse(tbx_Price.Text, out price); if (ddl_Unit.SelectedValue == "T") { //整件单位 quantity = quantity * productbll.Model.ConvertFactor; price = price / productbll.Model.ConvertFactor; } if (quantity == 0) { MessageBox.Show(this, "请填写数量!"); return; } PBM_OrderDetail d = null; if (ViewState["SelectedDetail"] != null) { d = (PBM_OrderDetail)ViewState["SelectedDetail"]; } else { d = new PBM_OrderDetail(); d.OrderID = (int)ViewState["ID"]; if (Details.GetListItem().Count == 0) d.ID = 1; else d.ID = Details.GetListItem().Max(p => p.ID) + 1; } d.Product = product; d.Price = price; //实际销售价 d.DiscountRate = 1; //默认全价 d.ConvertFactor = productbll.Model.ConvertFactor; d.BookQuantity = quantity; d.ConfirmQuantity = quantity; d.DeliveredQuantity = 0; d.SalesMode = int.Parse(ddl_SalesMode.SelectedValue); if (d.SalesMode == 2) { d.Price = 0; } if (ViewState["SelectedDetail"] != null) { Details.Update(d); ViewState["SelectedDetail"] = null; bt_AddDetail.Text = "新 增"; gv_List.SelectedIndex = -1; } else { Details.Add(d); } tbx_Quantity.Text = "0"; BindGrid(); } }
protected void bt_Submit_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] != 0) { if (Save()) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); int ret = _bll.Submit((int)Session["UserID"]); if (ret == 0) Response.Redirect("OrderList.aspx?Classify=" + _bll.Model.Classify.ToString()); else MessageBox.Show(this, "操作失败,返回值:" + ret.ToString()); } } }
protected void bt_Confirm_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] != 0) { if (!Save()) return; PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); int ret = _bll.Submit((int)Session["UserID"]); if (ret < 0) { MessageBox.Show(this, "对不起,订单提交失败!Ret=" + ret.ToString()); return; } else { Response.Redirect("OrderList.aspx?Classify=" + _bll.Model.Classify.ToString()); } } }
protected void bt_AddDetail_Click(object sender, EventArgs e) { if ((int)ViewState["ID"] == 0) { return; } PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); if (ViewState["Details"] == null) { return; } ListTable <PBM_OrderDetail> Details = (ListTable <PBM_OrderDetail>)ViewState["Details"]; int product = 0; int.TryParse(select_Product.SelectValue, out product); //int.TryParse(RadComboBox1.SelectedValue, out product); if (product != 0) { PDT_ProductBLL productbll = new PDT_ProductBLL(product, true); if (productbll.Model == null) { return; } if (productbll.Model.ConvertFactor == 0) { productbll.Model.ConvertFactor = 1; productbll.Update(); } int quantity = 0; decimal price = 0; int.TryParse(tbx_Quantity.Text, out quantity); decimal.TryParse(tbx_Price.Text, out price); if (ddl_Unit.SelectedValue == "T") { //整件单位 quantity = quantity * productbll.Model.ConvertFactor; price = price / productbll.Model.ConvertFactor; } if (quantity == 0) { MessageBox.Show(this, "请填写数量!"); return; } PBM_OrderDetail d = null; if (ViewState["SelectedDetail"] != null) { d = (PBM_OrderDetail)ViewState["SelectedDetail"]; } else { d = new PBM_OrderDetail(); d.OrderID = (int)ViewState["ID"]; if (Details.GetListItem().Count == 0) { d.ID = 1; } else { d.ID = Details.GetListItem().Max(p => p.ID) + 1; } } d.Product = product; d.Price = price; //实际销售价 d.DiscountRate = 1; //默认全价 d.ConvertFactor = productbll.Model.ConvertFactor; d.BookQuantity = quantity; d.ConfirmQuantity = quantity; d.DeliveredQuantity = 0; d.SalesMode = int.Parse(ddl_SalesMode.SelectedValue); if (d.SalesMode == 2) { d.Price = 0; } if (ViewState["SelectedDetail"] != null) { Details.Update(d); ViewState["SelectedDetail"] = null; bt_AddDetail.Text = "新 增"; gv_List.SelectedIndex = -1; } else { Details.Add(d); } tbx_Quantity.Text = "0"; BindGrid(); } }
/// <summary> /// 提交订货单,并输出提交后的订单信息 /// </summary> /// <param name="User"></param> /// <param name="OrderID">订货单ID</param> /// <param name="OrderInfo">输出:订货单结构</param> /// <param name="ErrorInfo">输出:出错信息</param> /// <returns>0:成功 小于0:失败</returns> public static int Order_Submit(UserInfo User, int OrderID, decimal WipeAmount, List<Order.OrderPayInfo> PayInfoList, out Order OrderInfo, out string ErrorInfo) { ErrorInfo = ""; OrderInfo = null; LogWriter.WriteLog("PBMIFService.Order_Submit:UserName="******",OrderID=" + OrderID.ToString()); if (OrderID <= 0) { ErrorInfo = "订货单ID无效"; return -1; } PBM_OrderBLL bll = new PBM_OrderBLL(OrderID); if (bll.Model == null) { ErrorInfo = "订货单ID无效"; return -1; } if (bll.Model.State > 1 || bll.Model.ApproveFlag == 1) { ErrorInfo = "订货单状态无效"; return -1; } if (User.OwnerType == 3 && bll.Model.Supplier != User.ClientID) { ErrorInfo = "不可提交该订货单"; return -2; } bll.Model.WipeAmount = WipeAmount; bll.Model.ActAmount = Math.Round((bll.Model.Classify == 2 ? -1 : 1) * bll.Items.Sum(p => p.DiscountRate * Math.Round(p.Price * p.ConvertFactor, 2) * p.ConfirmQuantity / p.ConvertFactor) - bll.Model.WipeAmount, 2); bll.Update(); #region 写入收款明细 //先清除之前的付款信息 if (bll.GetPayInfoList().Count > 0) bll.ClearPayInfo(); foreach (Order.OrderPayInfo item in PayInfoList) { PBM_DeliveryPayInfoBLL paybll = new PBM_DeliveryPayInfoBLL(); paybll.Model.DeliveryID = OrderID; paybll.Model.PayMode = item.PayMode; paybll.Model.Amount = item.Amount; paybll.Model.Remark = item.Remark; paybll.Model.ApproveFlag = 2; paybll.Model.InsertStaff = User.StaffID; paybll.Add(); } #endregion int ret = bll.Submit(User.StaffID); if (ret < 0) { ErrorInfo = "订货单提交失败!"; return -1; } OrderInfo = new Order(bll.Model.ID); return 0; }
/// <summary> /// 新增预售订单 /// </summary> /// <param name="User"></param> /// <param name="OrderInfo">发货单信息</param> /// <param name="ErrorInfo">出错消息</param> /// <returns></returns> public static int Order_Add(UserInfo User, Order OrderInfo, out string ErrorInfo) { ErrorInfo = ""; LogWriter.WriteLog("PBMIFService.Order_Add:UserName="******",OrderInfo=" + JsonConvert.SerializeObject(OrderInfo)); //经销商级人员,供货商只能是自己所属的经销商 if (User.OwnerType == 3) OrderInfo.Supplier = User.ClientID; //默认业务人员为当前员工 if (OrderInfo.SalesMan == 0) OrderInfo.SalesMan = User.StaffID; #region 必填字段校验 if (OrderInfo.Supplier == 0) { ErrorInfo = "无效的供货客户!"; return -2; } if (OrderInfo.Client == 0) { ErrorInfo = "无效的购买客户!"; return -2; } if (OrderInfo.Items == null || OrderInfo.Items.Count == 0) { ErrorInfo = "无销售产品明细!"; return -10; } #endregion PBM_OrderBLL bll = new PBM_OrderBLL(); #region 保存销售单头信息 bll.Model.SheetCode = ""; bll.Model.Supplier = OrderInfo.Supplier; bll.Model.Client = OrderInfo.Client; bll.Model.SalesMan = OrderInfo.SalesMan; bll.Model.Classify = (OrderInfo.Classify == 0 ? 1 : OrderInfo.Classify); //默认销售单 bll.Model.State = 1; //默认制单状态 bll.Model.StandardPrice = OrderInfo.StandardPrice; bll.Model.WipeAmount = OrderInfo.WipeAmount; bll.Model.ArriveTime = OrderInfo.ArriveTime < DateTime.Today ? DateTime.Today.AddDays(1) : OrderInfo.ArriveTime; bll.Model.WorkList = OrderInfo.WorkList; bll.Model.Remark = OrderInfo.Remark; bll.Model.ApproveFlag = 2; bll.Model.InsertStaff = User.StaffID; //订单来源 bll.Model["OrderSource"] = OrderInfo.OrderSource > 0 ? OrderInfo.OrderSource.ToString() : "2"; #endregion #region 循环处理每个订单明细 foreach (Order.OrderDetail item in OrderInfo.Items) { if (item.Product == 0) continue; if (item.BookQuantity <= 0 && item.ConfirmQuantity <= 0) continue; int bookquantity = item.BookQuantity <= 0 ? item.ConfirmQuantity : item.BookQuantity; PDT_ProductBLL productbll = new PDT_ProductBLL(item.Product); if (productbll.Model == null) { ErrorInfo = "无效产品项,产品ID:" + item.Product; return -11; } PDT_ProductExtInfo extinfo = productbll.GetProductExtInfo(bll.Model.Supplier); if (productbll.Model == null) { ErrorInfo = "产品不在销售商的经营目录中," + productbll.Model.FullName; return -11; } #region 新增商品明细 PBM_OrderDetail d = new PBM_OrderDetail(); d.Product = item.Product; d.SalesMode = item.SalesMode == 0 ? 1 : item.SalesMode; //默认为“销售” if (item.Price > 0) d.Price = item.Price; else d.Price = PDT_StandardPriceBLL.GetSalePrice(bll.Model.Client, bll.Model.Supplier, d.Product); //默认销售价 if (d.SalesMode == 1) d.DiscountRate = (item.DiscountRate <= 0 || item.DiscountRate > 1) ? 1 : item.DiscountRate; else d.DiscountRate = 0; //非销售时,0折销售 d.ConvertFactor = productbll.Model.ConvertFactor == 0 ? 1 : productbll.Model.ConvertFactor; d.BookQuantity = bookquantity; d.ConfirmQuantity = d.BookQuantity; d.Remark = item.Remark; bll.Items.Add(d); #endregion } #endregion //计算折扣金额 bll.Model.DiscountAmount = bll.Items.Sum(p => (1 - p.DiscountRate) * Math.Round(p.Price * p.ConvertFactor, 2) * p.ConfirmQuantity / p.ConvertFactor); //计算实际销售金额 bll.Model.ActAmount = Math.Round((bll.Model.Classify == 2 ? -1 : 1) * bll.Items.Sum(p => p.DiscountRate * Math.Round(p.Price * p.ConvertFactor, 2) * p.ConfirmQuantity / p.ConvertFactor) - bll.Model.WipeAmount, 2); int orderid = bll.Add(); if (orderid <= 0) { ErrorInfo = "销售订单保存失败!"; return orderid; } #region 判断订单是否直接提交 if (OrderInfo.State == 2) { LogWriter.WriteLog("PBMIFService.Order_Add:UserName="******",OrderID=" + orderid.ToString() + ",Auto submit order!"); Order OutOrderInfo; if (OrderInfo.PayInfos == null) OrderInfo.PayInfos = new List<Order.OrderPayInfo>(); int ret = Order_Submit(User, orderid, OrderInfo.WipeAmount, OrderInfo.PayInfos, out OutOrderInfo, out ErrorInfo); if (ret < 0) { LogWriter.WriteLog("PBMIFService.Order_Add:UserName="******",OrderID=" + orderid.ToString() + ",Auto submit failed!ErrorInfo=" + ErrorInfo); return ret; } } #endregion return orderid; }
private void FillModel(int OrderID) { PBM_OrderBLL bll = new PBM_OrderBLL(OrderID); if (bll.Model == null) { ID = -1; return; } PBM_Order m = bll.Model; ID = m.ID; SheetCode = m.SheetCode; Supplier = m.Supplier; Client = m.Client; SalesMan = m.SalesMan; Classify = m.Classify; StandardPrice = m.StandardPrice; State = m.State; DiscountAmount = m.DiscountAmount; WipeAmount = m.WipeAmount; ActAmount = m.ActAmount; ArriveTime = m.ArriveTime; SubmitTime = m.SubmitTime; ConfirmTime = m.ConfirmTime; InsertTime = m.InsertTime; Remark = m.Remark; WorkList = m.WorkList; ApproveFlag = m.ApproveFlag; int.TryParse(m["OrderSource"], out OrderSource); //订货单明细 Items = new List<OrderDetail>(); foreach (PBM_OrderDetail item in bll.Items) { Items.Add(new OrderDetail(item)); } //预收款信息列表 PayInfos = new List<OrderPayInfo>(); foreach (PBM_OrderPayInfo item in bll.GetPayInfoList()) { PayInfos.Add(new OrderPayInfo(item)); } #region 获取各字段ID对应的名称 if (Supplier > 0) { CM_Client c = new CM_ClientBLL(Supplier).Model; if (c != null) SupplierName = c.FullName; } if (Client > 0) { CM_Client c = new CM_ClientBLL(Client).Model; if (c != null) ClientName = c.FullName; } if (SalesMan > 0) { Org_Staff s = new Org_StaffBLL(SalesMan).Model; if (s != null) SalesManName = s.RealName; } if (StandardPrice > 0) { PDT_StandardPrice s = new PDT_StandardPriceBLL(StandardPrice).Model; if (s != null) StandardPriceName = s.Name; } #endregion #region 获取字典表名称 try { if (m.Classify > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderClassify")[m.Classify.ToString()]; if (dic != null) ClassifyName = dic.Name; } if (m.State > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderState")[m.State.ToString()]; if (dic != null) StateName = dic.Name; } if (OrderSource > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderSource")[OrderSource.ToString()]; if (dic != null) OrderSourceName = dic.Name; } } catch (System.Exception err) { LogWriter.WriteLog("MCSFramework.WSI.Order", err); } #endregion }
private void BindData() { PBM_OrderBLL bll = new PBM_OrderBLL((int)ViewState["ID"]); if (bll.Model != null) { pl_detail.BindData(bll.Model); ViewState["Client"] = bll.Model.Client; ViewState["Supplier"] = bll.Model.Supplier; ViewState["Details"] = new ListTable <PBM_OrderDetail>(bll.Items, "ID"); ViewState["State"] = bll.Model.State; ViewState["Classify"] = bll.Model.Classify; #region 绑定收款信息 IList <PBM_OrderPayInfo> paylist = bll.GetPayInfoList(); if (paylist.Count > 0) { ddl_PayMode1.SelectedValue = paylist[0].PayMode.ToString(); tbx_PayAmount1.Text = paylist[0].Amount.ToString("0.##"); } if (paylist.Count > 1) { ddl_PayMode2.SelectedValue = paylist[1].PayMode.ToString(); tbx_PayAmount2.Text = paylist[1].Amount.ToString("0.##"); } #endregion BindGrid(); #region 界面控件可视状态 if (bll.Model.State != 1 || bll.Model.ApproveFlag != 2) { bt_OK.Visible = false; tb_AddDetail.Visible = false; bt_Delete.Visible = false; tr_AddDetail.Visible = false; pl_detail.SetControlsEnable(false); gv_List.Columns[gv_List.Columns.Count - 1].Visible = false; gv_List.Columns[gv_List.Columns.Count - 2].Visible = false; ddl_PayMode1.Enabled = false; ddl_PayMode2.Enabled = false; tbx_PayAmount1.Enabled = false; tbx_PayAmount2.Enabled = false; } if (bll.Model.State != 1) { bt_Submit.Visible = false; } if (bll.Model.State != 2) { bt_Cancel.Visible = false; bt_Assign.Visible = false; } #endregion } }
private bool Save() { if (ViewState["Details"] == null) { return(false); } ListTable <PBM_OrderDetail> Details = (ListTable <PBM_OrderDetail>)ViewState["Details"]; PBM_OrderBLL _bll; if ((int)ViewState["ID"] != 0) { //修改 _bll = new PBM_OrderBLL((int)ViewState["ID"]); } else { //新增 _bll = new PBM_OrderBLL(); } pl_detail.GetData(_bll.Model); #region 判断必填项 if (_bll.Model.Supplier == 0) { MessageBox.Show(this, "请正确选择供货商!"); return(false); } if (_bll.Model.Client == 0) { MessageBox.Show(this, "请正确选择订货客户!"); return(false); } #endregion //折扣价 _bll.Model.DiscountAmount = Details.GetListItem().Sum(p => (1 - p.DiscountRate) * Math.Round(p.Price * p.ConvertFactor, 2) * p.BookQuantity / p.ConvertFactor); //实际成交价 _bll.Model.ActAmount = Details.GetListItem().Sum(p => Math.Round(p.Price * p.ConvertFactor, 2) * p.BookQuantity / p.ConvertFactor) - _bll.Model.DiscountAmount - _bll.Model.WipeAmount; _bll.Model.ActAmount = Math.Round(_bll.Model.ActAmount, 2); if (_bll.Model.Classify == 2) { _bll.Model.ActAmount = 0 - _bll.Model.ActAmount; //退库时,金额以负数计 } if ((int)ViewState["ID"] != 0) { //修改 _bll.Model.UpdateStaff = (int)Session["UserID"]; #region 保存明细 if (ViewState["Details"] == null) { return(false); } foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Added)) { _bll.AddDetail(d); } foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Modified)) { _bll.UpdateDetail(d); } foreach (PBM_OrderDetail d in Details.GetListItem(ItemState.Deleted)) { _bll.DeleteDetail(d.ID); } #endregion if (_bll.Update() == 0) { SavePayInfo(); return(true); } } else { //新增 _bll.Model.InsertStaff = (int)Session["UserID"]; _bll.Items = Details.GetListItem(); ViewState["ID"] = _bll.Add(); if ((int)ViewState["ID"] > 0) { SavePayInfo(); return(true); } } return(false); }
/// <summary> /// 取消预售订单 /// </summary> /// <param name="User"></param> /// <param name="OrderID"></param> /// <param name="CancelReason"></param> /// <param name="ErrorInfo"></param> /// <returns></returns> public static int Order_Cancel(UserInfo User, int OrderID, string CancelReason, out string ErrorInfo) { ErrorInfo = ""; LogWriter.WriteLog("PBMIFService.Order_Cancel:UserName="******",OrderID=" + OrderID.ToString() + ",CancelReason=" + CancelReason); if (OrderID <= 0) { ErrorInfo = "预售订单ID无效"; return -1; } PBM_OrderBLL bll = new PBM_OrderBLL(OrderID); if (bll.Model == null) { ErrorInfo = "预售订单ID无效"; return -1; } if (bll.Model.State > 2) { ErrorInfo = "预售订单状态无效"; return -1; } if (User.OwnerType == 3 && bll.Model.Supplier != User.ClientID) { ErrorInfo = "不可取消该销售单"; return -2; } int ret = bll.Cancel(User.StaffID, CancelReason); if (ret < 0) { ErrorInfo = "预售订单取消失败!"; return -1; } return 0; }
//protected void RadComboBox1_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) //{ // int product = 0; // int.TryParse(RadComboBox1.SelectedValue, out product); // if (product != 0) // { // PDT_ProductBLL productbll = new PDT_ProductBLL(product); // if (productbll.Model == null) return; // PDT_Product p = productbll.Model; // Dictionary<string, Dictionary_Data> dic = DictionaryBLL.GetDicCollections("PDT_Packaging"); // string _T = dic[p.TrafficPackaging.ToString()].Name; // string _P = dic[p.Packaging.ToString()].Name; // #region 显示产品包装信息 // lb_TrafficPackagingName.Text = "元/" + _T + "(" + p.ConvertFactor.ToString() + _P + ")"; // #endregion // #region 获取销售该门店的价格 // decimal saleprice = PDT_StandardPriceBLL.GetSalePrice((int)ViewState["Client"], (int)Session["OwnerClient"], product); // if (saleprice > 0) // { // if (ddl_Unit.SelectedValue == "T") // tbx_Price.Text = (saleprice * p.ConvertFactor).ToString("0.###"); // else // tbx_Price.Text = saleprice.ToString("0.###"); // //tbx_Price.Enabled = false; // } // else // { // tbx_Price.Text = "0"; // //tbx_Price.Enabled = true; // } // #endregion // } //} protected void bt_Assign_Click(object sender, EventArgs e) { int deliveryman = 0, deliveryvehicle = 0, supplierwarehouse = 0; DateTime prearrivaldate = new DateTime(1900, 1, 1); if (Session["AssignFlag"] != null && (bool)Session["AssignFlag"]) { deliveryman = (int)Session["DeliveryMan"]; deliveryvehicle = (int)Session["DeliveryVehicle"]; supplierwarehouse = (int)Session["SupplierWareHouse"]; prearrivaldate = (DateTime)Session["PreArrivalDate"]; if ((int)ViewState["ID"] != 0) { PBM_OrderBLL _bll = new PBM_OrderBLL((int)ViewState["ID"]); if (_bll.Model.State == 2) { int ret = _bll.CreateDelivery(supplierwarehouse, deliveryman, deliveryvehicle, prearrivaldate, (int)Session["UserID"]); if (ret > 0) Response.Redirect("../Delivery/SaleOut/SaleOutDetail.aspx?ID=" + ret.ToString()); else MessageBox.Show(this, "派单失败!ret=" + ret.ToString()); } } } }
/// <summary> /// 更新预售订单 /// </summary> /// <param name="User"></param> /// <param name="OrderInfo"></param> /// <param name="ErrorInfo"></param> /// <returns></returns> public static int Order_Update(UserInfo User, Order OrderInfo, out string ErrorInfo) { ErrorInfo = ""; LogWriter.WriteLog("PBMIFService.Order_Update:UserName="******",OrderInfo=" + JsonConvert.SerializeObject(OrderInfo)); if (OrderInfo.ID == 0) { ErrorInfo = "销售订单不存在,请先新增销售订单!"; return -1; } PBM_OrderBLL bll = new PBM_OrderBLL(OrderInfo.ID); if (bll.Model == null) { ErrorInfo = "订货单不存在,请先新增订货单!"; return -1; } if (bll.Model.State > 1 || bll.Model.ApproveFlag == 1) { ErrorInfo = "订货单状态不允许执行此操作!"; return -1; } if (bll.Model.Supplier == 0) bll.Model.Supplier = OrderInfo.Supplier; if (bll.Model.Client == 0) bll.Model.Client = OrderInfo.Client; //默认业务人员为当前员工 if (OrderInfo.SalesMan == 0) OrderInfo.SalesMan = User.StaffID; #region 必填字段校验 if (bll.Model.Supplier == 0) { ErrorInfo = "无效的供货客户!"; return -2; } if (User.OwnerType == 3 && bll.Model.Supplier != User.ClientID) { ErrorInfo = "无效的供货客户!"; return -2; } if (bll.Model.Client == 0) { ErrorInfo = "无效的购买客户!"; return -2; } if (OrderInfo.Items == null || OrderInfo.Items.Count == 0) { ErrorInfo = "无订货产品明细!"; return -10; } #endregion #region 保存订货单头信息 bll.Model.SalesMan = OrderInfo.SalesMan; bll.Model.WipeAmount = OrderInfo.WipeAmount; bll.Model.ArriveTime = OrderInfo.ArriveTime < DateTime.Today ? DateTime.Today.AddDays(1) : OrderInfo.ArriveTime; bll.Model.WorkList = OrderInfo.WorkList; bll.Model.Remark = OrderInfo.Remark; #endregion #region 循环处理每个订单明细 foreach (Order.OrderDetail item in OrderInfo.Items) { if (item.Product == 0) continue; if (item.BookQuantity <= 0 && item.ConfirmQuantity <= 0) { if (item.DetailID == 0) continue; else bll.DeleteDetail(item.DetailID); } int quantity = item.BookQuantity == 0 ? item.ConfirmQuantity : item.BookQuantity; string remark = item.Remark; PDT_ProductBLL productbll = new PDT_ProductBLL(item.Product); if (productbll.Model == null) { ErrorInfo = "无效产品项,产品ID:" + item.Product; return -11; } PDT_ProductExtInfo extinfo = productbll.GetProductExtInfo(bll.Model.Supplier); if (productbll.Model == null) { ErrorInfo = "产品不在销售商的经营目录中," + productbll.Model.FullName; return -11; } if (item.DetailID > 0) { PBM_OrderDetail d = bll.GetDetailModel(item.DetailID); d.ConvertFactor = productbll.Model.ConvertFactor == 0 ? 1 : productbll.Model.ConvertFactor; d.BookQuantity = quantity; d.ConfirmQuantity = quantity; d.Remark = item.Remark; bll.UpdateDetail(d); } else { #region 新增商品明细品项 PBM_OrderDetail d = new PBM_OrderDetail(); d.Product = item.Product; d.SalesMode = item.SalesMode == 0 ? 1 : item.SalesMode; //默认为“销售” d.Price = PDT_StandardPriceBLL.GetSalePrice(bll.Model.Client, bll.Model.Supplier, d.Product); if (d.SalesMode == 1) d.DiscountRate = (item.DiscountRate <= 0 || item.DiscountRate > 1) ? 1 : item.DiscountRate; else d.DiscountRate = 0; d.BookQuantity = quantity; d.ConfirmQuantity = d.BookQuantity; d.Remark = item.Remark; bll.AddDetail(d); #endregion } } #endregion //计算折扣金额 bll.Model.DiscountAmount = bll.Items.Sum(p => (1 - p.DiscountRate) * Math.Round(p.Price * p.ConvertFactor, 2) * p.ConfirmQuantity / p.ConvertFactor); //计算实际销售金额 bll.Model.ActAmount = Math.Round((bll.Model.Classify == 2 ? -1 : 1) * bll.Items.Sum(p => p.DiscountRate * Math.Round(p.Price * p.ConvertFactor, 2) * p.ConfirmQuantity / p.ConvertFactor) - bll.Model.WipeAmount, 2); int ret = bll.Update(); if (ret < 0) { ErrorInfo = "订货单保存失败!"; return ret; } return 0; }
private void FillModel(int OrderID) { PBM_OrderBLL bll = new PBM_OrderBLL(OrderID); if (bll.Model == null) { ID = -1; return; } PBM_Order m = bll.Model; ID = m.ID; SheetCode = m.SheetCode; Supplier = m.Supplier; Client = m.Client; SalesMan = m.SalesMan; Classify = m.Classify; StandardPrice = m.StandardPrice; State = m.State; DiscountAmount = m.DiscountAmount; WipeAmount = m.WipeAmount; ActAmount = m.ActAmount; ArriveTime = m.ArriveTime; SubmitTime = m.SubmitTime; ConfirmTime = m.ConfirmTime; InsertTime = m.InsertTime; Remark = m.Remark; WorkList = m.WorkList; ApproveFlag = m.ApproveFlag; int.TryParse(m["OrderSource"], out OrderSource); //订货单明细 Items = new List <OrderDetail>(); foreach (PBM_OrderDetail item in bll.Items) { Items.Add(new OrderDetail(item)); } //预收款信息列表 PayInfos = new List <OrderPayInfo>(); foreach (PBM_OrderPayInfo item in bll.GetPayInfoList()) { PayInfos.Add(new OrderPayInfo(item)); } #region 获取各字段ID对应的名称 if (Supplier > 0) { CM_Client c = new CM_ClientBLL(Supplier).Model; if (c != null) { SupplierName = c.FullName; } } if (Client > 0) { CM_Client c = new CM_ClientBLL(Client).Model; if (c != null) { ClientName = c.FullName; } } if (SalesMan > 0) { Org_Staff s = new Org_StaffBLL(SalesMan).Model; if (s != null) { SalesManName = s.RealName; } } if (StandardPrice > 0) { PDT_StandardPrice s = new PDT_StandardPriceBLL(StandardPrice).Model; if (s != null) { StandardPriceName = s.Name; } } #endregion #region 获取字典表名称 try { if (m.Classify > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderClassify")[m.Classify.ToString()]; if (dic != null) { ClassifyName = dic.Name; } } if (m.State > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderState")[m.State.ToString()]; if (dic != null) { StateName = dic.Name; } } if (OrderSource > 0) { Dictionary_Data dic = DictionaryBLL.GetDicCollections("PBM_OrderSource")[OrderSource.ToString()]; if (dic != null) { OrderSourceName = dic.Name; } } } catch (System.Exception err) { LogWriter.WriteLog("MCSFramework.WSI.Order", err); } #endregion }