private static void LoadPredictDetail(ProductNotice dmo) { if (dmo.Customer_ID == null) { throw new Exception("请先选择客户"); } if (dmo.Date == null) { throw new ArgumentException("请先选择日期"); } //var selectedList = new List<ProductNotice_Detail>(); var query = SaleForecastQuery((long)dmo.Customer_ID); using (var context = new TransactionContext()) { using (var reader = context.Session.ExecuteReader(query)) { while (reader.Read()) { var selectDmo = new ProductNotice_Detail(); selectDmo.DmoID = (long)reader[0]; selectDmo.DmoTypeID = B3FrameworksConsts.DmoTypeIDBases.B3Sale + 26; selectDmo.Goods_ID = (long)reader[1]; selectDmo.Number = (Money <decimal>?)reader[2]; selectDmo.Goods_MainUnit = reader[3].ToString(); selectDmo.Price = (Money <decimal>?)reader[4]; selectDmo.Money = (Money <金额>?)reader[5]; //selectedList.Add(selectDmo); dmo.Details.Add(selectDmo); } } } }
public void LoadPredictDetail(ProductNotice dmo) { if (dmo.Customer_ID == null) { throw new Exception("请先选择客户"); } if (dmo.Date == null) { throw new ArgumentException("请先选择生产日期"); } var goods = CheckCustomer(dmo.Customer_ID); var query = SaleForecastQuery(dmo.Customer_ID, dmo.Date); using (var reader = Session.ExecuteReader(query)) { while (reader.Read()) { if (goods != null && goods.ContainsKey((long)reader[1]) && goods[(long)reader[1]] == (long)reader[0]) { continue; } var selectDmo = new ProductNotice_Detail(); selectDmo.DmoID = (long)reader[0]; selectDmo.Goods_ID = (long)reader[1]; selectDmo.Number = (Money <decimal>?)reader[2]; selectDmo.Goods_MainUnit = reader[3] + ""; selectDmo.Price = (Money <decimal>?)reader[4]; selectDmo.Money = (Money <金额>?)reader[5]; selectDmo.SecondNumber = (Money <decimal>?)reader[6]; selectDmo.Goods_SecondUnit = reader[7] + ""; selectDmo.Remark = reader[8] + ""; selectDmo.Goods_Code = reader[9] + ""; selectDmo.Goods_Name = reader[10] + ""; selectDmo.Goods_Spec = reader[11] + ""; selectDmo.DmoTypeID = SaleForecastTypeID; dmo.Details.Add(selectDmo); } } }
protected virtual void AddBrandItem(ProductNotice_Detail detail) { }
protected virtual void AddToolsPanel(HLayoutPanel toobar) { toobar.Add(new SimpleLabel("选择存货")); var goodsSelect = new ChoiceBox(B3UnitedInfosConsts.DataSources.存货) { Width = Unit.Pixel(120), AutoPostBack = true, EnableMultiSelection = true, EnableInputArgument = true }; mDFContainer.AddNonDFControl(goodsSelect, "$SelectGoods"); toobar.Add(goodsSelect); goodsSelect.SelectedValueChanged += (sender, e) => { _detailGrid.GetFromUI(); last = Dmo.Details.LastOrDefault(); foreach (var sGoodsID in goodsSelect.GetValues()) { var goods = GoodsBL.Instance.Load(Convert.ToInt64(sGoodsID)); var detail = new ProductNotice_Detail(); detail.Goods_ID = goods.ID; DmoUtil.RefreshDependency(detail, "Goods_ID"); AddBrandItem(detail); Dmo.Details.Add(detail); } goodsSelect.DisplayValue = string.Empty; _detailGrid.DataBind(); var script = B3ButcheryWebUtil.SetCursorPositionScript(butcheryConfig.ProductNoticeCursorField, "$detailGrid", Dmo.Details.Count, _detailGrid.PageSize); if (!string.IsNullOrEmpty(script)) { Page.ClientScript.RegisterStartupScript(GetType(), "Startup", script, true); } }; var quickSelctButton = new DialogButton { Url = "~/B3UnitedInfos/Dialogs/QucicklySelectGoodsDetailsDialog.aspx", Text = "快速选择" }; quickSelctButton.Click += delegate { ReceiveSelectedGoodsDetailDialog(); }; toobar.Add(quickSelctButton); var dialogButton = new DialogButton { Url = "~/B3UnitedInfos/Dialogs/SelectGoodsDetailDialog.aspx", Text = "查询存货" }; toobar.Add(dialogButton); dialogButton.Click += delegate { ReceiveSelectedGoodsDetailDialog(); }; toobar.Add(new TSButton("载入预报")).Click += delegate { GetFromUI(); Dmo.Details.Clear(); mBL.LoadPredictDetail(Dmo); _detailGrid.DataBind(); //AspUtil.Alert(this, "载入预报成功"); }; }