protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; // try // { // int iCode = int.Parse(item.WarehouseCode); // item.WarehouseCode = new string('0', 4 - item.WarehouseCode.Length) + item.WarehouseCode; // } // catch // {} return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { item.FactoryCode, //item.SegmentCode, item.WarehouseCode, item.ItemCode, item.EAttribute1, Math.Round(Convert.ToDecimal(item.Qty), 2).ToString(), //离散数量 Math.Round(Convert.ToDecimal(item.LineQty), 2).ToString(), //在制品虚拆数量 Math.Round(item.Warehouse2LineQty, 2), Math.Round(item.PhysicalQty, 2), IsAllowed(item) })); }
//选择来源工厂、工段,查询所有仓库 /* * private void FillWarehouseFrom(object sender, System.EventArgs e) * { * this.drpWarehouseCodeQuery.Items.Clear(); * if (this.drpFactoryCodeQuery.SelectedValue == string.Empty) * { * this.drpSegmentCodeQuery.SelectedValue = string.Empty; * } * else * this.FillWarehouse(this.drpFactoryCodeQuery, this.drpSegmentCodeQuery, this.drpWarehouseCodeQuery); * } * private void FillWarehouse(DropDownList drpFactory, DropDownList drpSeg, DropDownList drp) * { * if(_facade==null){_facade = new WarehouseFacade(base.DataProvider);} * string factoryCode = drpFactory.SelectedValue; * string segCode = drpSeg.SelectedValue; * object[] objs = this._facade.GetWarehouseByFactorySeg(segCode, factoryCode, true); * drp.Items.Clear(); * drp.Items.Add(""); * if (objs != null) * { * for (int i = 0; i < objs.Length; i++) * { * Warehouse wh = (Warehouse)objs[i]; * drp.Items.Add(new ListItem(wh.WarehouseCode, wh.WarehouseCode)); * wh = null; * } * } * objs = null; * } */ #endregion #region Export protected override string[] FormatExportRecord(object obj) { string factoryCode, warehouseCode, itemCode, openQty, actualQty, cycleCode; WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; openQty = item.Qty.ToString(); actualQty = item.PhysicalQty.ToString(); cycleCode = item.CycleCountCode; if (this.ViewState["ADJUST_SUCCESS"] != null && this.ViewState["ADJUST_SUCCESS"].ToString() == "yes") { openQty = actualQty; } string[] strArr = new string[] { factoryCode, //segmentCode, warehouseCode, itemCode, GetItemName(itemCode), openQty, actualQty, (item.PhysicalQty - item.Qty).ToString() }; return(strArr); }
protected override string[] FormatExportRecord(object obj) { string factoryCode, warehouseCode, itemCode, warehouseQty, lingqty, openQty, actualQty, cycleCode; if (obj is WarehouseStock) { WarehouseStock item = (WarehouseStock)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; openQty = Math.Round(Convert.ToDecimal(item.OpenQty), 2).ToString(); actualQty = ""; cycleCode = ""; warehouseQty = ""; lingqty = ""; } else { WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; warehouseQty = Math.Round(Convert.ToDecimal(item.Qty), 2).ToString(); //离散数量 lingqty = Math.Round(Convert.ToDecimal(item.LineQty), 2).ToString(); //在制品虚拆数量 openQty = Math.Round(Convert.ToDecimal(item.Warehouse2LineQty), 2).ToString(); //账面数量 = 离散数量 + 在制品虚拆数量 actualQty = Math.Round(Convert.ToDecimal(item.PhysicalQty), 2).ToString(); cycleCode = item.CycleCountCode; } string[] strArr = new string[] {}; if (isWHCycle) { strArr = new string[] { factoryCode, //segmentCode, warehouseCode, itemCode, GetItemName(itemCode), warehouseQty, //离散数量 lingqty, //在制品虚拆数量 openQty, //账面数量 = 离散数量 + 在制品虚拆数量 "" }; } else { strArr = new string[] { factoryCode, //segmentCode, warehouseCode, itemCode, GetItemName(itemCode), openQty, "" }; } return(strArr); }
private string GetWarehouseStatusLabel(WarehouseCycleCountDetail item) { if (this.whstatus_normal == null) { this.whstatus_normal = this.languageComponent1.GetString(Warehouse.WarehouseStatus_Normal); this.whstatus_cycle = this.languageComponent1.GetString(Warehouse.WarehouseStatus_Cycle); } if (item.AdjustUser == this.GetUserCode()) { return(this.whstatus_normal); } else { return(this.whstatus_cycle); } }
protected void cmdUpdate_ServerClick(object sender, EventArgs e) { if (_facade == null) { _facade = new WarehouseFacede2(base.DataProvider); } object obj = this._facade.GetWarehouseCycleCountDetail(this.txtItemCode.Value, this.txtCycleCountCode.Value); if (obj == null) { return; } WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; item.PhysicalQty = decimal.Parse(this.txtActualQtyEdit.Text); this._facade.UpdateWarehouseCycleCountDetail(item); item = null; this.cmdQuery_Click(null, null); }
protected override void SetEditObject(object obj) { if (obj == null) { this.txtActualQtyEdit.Text = ""; return; } WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; this.txtActualQtyEdit.Text = item.PhysicalQty.ToString(); this.txtItemCode.Value = item.ItemCode; this.txtCycleCountCode.Value = item.CycleCountCode; item = null; this.txtActualQtyEdit.ReadOnly = false; this.cmdSave.Disabled = false; }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { string factoryCode, warehouseCode, itemCode, qty, lineqty, openQty, actualQty, cycleCode, diff; WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; qty = item.Qty.ToString(); lineqty = item.LineQty.ToString(); openQty = item.Warehouse2LineQty.ToString(); actualQty = item.PhysicalQty.ToString(); cycleCode = item.CycleCountCode; diff = (item.PhysicalQty - item.Warehouse2LineQty).ToString(); if (this.ViewState["ADJUST_SUCCESS"] != null && this.ViewState["ADJUST_SUCCESS"].ToString() == "yes") { openQty = actualQty; diff = "0"; } Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { factoryCode, //segmentCode, warehouseCode, GetWarehouseStatusLabel(item), itemCode, GetItemName(itemCode), Math.Round(Convert.ToDecimal(qty), 2), Math.Round(Convert.ToDecimal(lineqty), 2), Math.Round(Convert.ToDecimal(openQty), 2), Math.Round(Convert.ToDecimal(actualQty), 2), Math.Round(Convert.ToDecimal(diff), 2), cycleCode }); return(row); }
private string IsAllowed(WarehouseCycleCountDetail dtl) { if (_facade == null) { _facade = new WarehouseFacade(base.DataProvider); } if (htItems == null) { //将所有物料资料取出 htItems = new Hashtable(); object[] objs = this._facade.GetAllWarehouseItem(); if (objs != null) { for (int i = 0; i < objs.Length; i++) { WarehouseItem item = (WarehouseItem)objs[i]; htItems.Add(item.ItemCode, item.ItemName); item = null; } } objs = null; //取出Boolean的描述 strBoolYes = FormatHelper.DisplayBoolean("1", this.languageComponent1); strBoolNo = FormatHelper.DisplayBoolean("0", this.languageComponent1); } // try // { // int iCode = int.Parse(dtl.WarehouseCode); // dtl.WarehouseCode = new string('0', 4 - dtl.WarehouseCode.Length) + dtl.WarehouseCode; // } // catch // {} //获取仓库状态 if (!htWarehouse.ContainsKey(string.Format("{0}-{1}", dtl.FactoryCode, /*dtl.SegmentCode,*/ dtl.WarehouseCode))) { object obj = this._facade.GetWarehouse(dtl.WarehouseCode, /*dtl.SegmentCode,*/ dtl.FactoryCode); if (obj != null) { Warehouse wh = (Warehouse)obj; htWarehouse.Add(string.Format("{0}-{1}", dtl.FactoryCode, /*dtl.SegmentCode,*/ dtl.WarehouseCode), wh.WarehouseStatus); } else { htWarehouse.Add(string.Format("{0}-{1}", dtl.FactoryCode, /*dtl.SegmentCode,*/ dtl.WarehouseCode), Warehouse.WarehouseStatus_Closed); } obj = null; } dtl.ItemCode = dtl.ItemCode.ToUpper(); if (dtl.FactoryCode != string.Empty && /* dtl.SegmentCode != string.Empty && */ dtl.WarehouseCode != string.Empty && dtl.ItemCode != string.Empty && dtl.PhysicalQty >= 0 && htItems.ContainsKey(dtl.ItemCode) && htWarehouse[string.Format("{0}-{1}", dtl.FactoryCode, /*dtl.SegmentCode,*/ dtl.WarehouseCode)].ToString() == Warehouse.WarehouseStatus_Cycle) { return(strBoolYes); } else { return(strBoolNo); } }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { string factoryCode, warehouseCode, itemCode, warehouseQty, lingqty, openQty, actualQty, cycleCode; if (obj is WarehouseStock) { WarehouseStock item = (WarehouseStock)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; openQty = Math.Round(Convert.ToDecimal(item.OpenQty), 2).ToString(); actualQty = ""; cycleCode = ""; warehouseQty = ""; lingqty = ""; } else { WarehouseCycleCountDetail item = (WarehouseCycleCountDetail)obj; factoryCode = item.FactoryCode; //segmentCode = item.SegmentCode; warehouseCode = item.WarehouseCode; itemCode = item.ItemCode; warehouseQty = Math.Round(Convert.ToDecimal(item.Qty), 2).ToString(); //离散数量 lingqty = Math.Round(Convert.ToDecimal(item.LineQty), 2).ToString(); //在制品虚拆数量 openQty = Math.Round(Convert.ToDecimal(item.Warehouse2LineQty), 2).ToString(); //账面数量 = 离散数量 + 在制品虚拆数量 actualQty = Math.Round(Convert.ToDecimal(item.PhysicalQty), 2).ToString(); cycleCode = item.CycleCountCode; } Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new UltraGridRow(); if (isWHCycle) { row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { factoryCode, //segmentCode, warehouseCode, GetWarehouseStatusLabel(obj), itemCode, GetItemName(itemCode), warehouseQty, /* -------离散数量*/ lingqty, /* -------在制品虚拆数量*/ openQty, /* -------账面数量 = 离散数量 + 在制品虚拆数量*/ actualQty, GetWarehouseStatus(obj), cycleCode, "" }); } else { row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { factoryCode, //segmentCode, warehouseCode, GetWarehouseStatusLabel(obj), itemCode, GetItemName(itemCode), openQty, /* -------离散数量*/ actualQty, GetWarehouseStatus(obj), cycleCode, "" }); } return(row); }