protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; string strCurrQty = "0"; string strKey = this.txtTicketNoQuery.Text + ":" + item.Sequence.ToString(); decimal deLeft = item.Qty - item.ActualQty; string strReturnQty = "0"; string strReturnScrapQty = "0"; Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { item.Sequence, item.ItemCode, item.ItemName, item.MOCode, Math.Round(item.Qty, 2), Math.Round(deLeft, 2), Math.Round(Convert.ToDecimal(strCurrQty), 2), Math.Round(Convert.ToDecimal(strReturnQty), 2), Math.Round(Convert.ToDecimal(strReturnScrapQty), 2), "" }); item = null; return(row); }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { if (this.IsFTicket) { WarehouseTicketDetail2 item = (WarehouseTicketDetail2)obj; return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { "false", item.Sequence, item.ItemCode, item.ItemName, item.MOCode, Math.Round(item.SingleQTY, 2).ToString(), Math.Round(item.Qty, 2).ToString(), Math.Round(item.Qty, 2).ToString(), Math.Round(item.ActualQty, 2).ToString() })); } WarehouseTicketDetail item2 = (WarehouseTicketDetail)obj; return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { "false", item2.Sequence, item2.ItemCode, item2.ItemName, item2.MOCode, "", Math.Round(item2.Qty, 2).ToString(), Math.Round(item2.Qty, 2).ToString(), Math.Round(item2.ActualQty, 2).ToString() }));; }
protected override string[] FormatExportRecord(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; string[] strArr = new string[] { item.Sequence.ToString(), item.ItemCode, item.ItemName, item.Qty.ToString(), item.ActualQty.ToString() }; item = null; return(strArr); }
protected override string[] FormatExportRecord(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; string strCurrQty = "0"; decimal deLeft = item.Qty - item.ActualQty; string[] strValue = new string[] { item.Sequence.ToString(), item.ItemCode, item.ItemName, item.MOCode, item.Qty.ToString(), deLeft.ToString(), strCurrQty }; item = null; return(strValue); }
protected override string[] FormatExportRecord(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; WarehouseTicket tkt = (WarehouseTicket)httkt[item.TicketNo]; string[] strArr = new string[] { item.TicketNo, item.ActualQty.ToString(), tkt.TicketUser, tkt.TransactionUser, FormatHelper.ToDateString(tkt.TicketDate), FormatHelper.ToDateString(tkt.TransactionDate) }; item = null; return(strArr); }
private void gridWebGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { if (e.Item.ItemIndex >= 0) { WarehouseTicketDetail item = (WarehouseTicketDetail)objsDataSource[e.Item.ItemIndex]; e.Item.Cells[0].Text = item.Sequence.ToString(); e.Item.Cells[1].Text = item.ItemCode; e.Item.Cells[2].Text = item.ItemName; e.Item.Cells[3].Text = item.MOCode; e.Item.Cells[4].Text = item.Qty.ToString(); //e.Item.Cells[5].Text = item.ActualQty.ToString(); //e.Item.Cells[6].Text = (item.Qty - item.ActualQty).ToString(); //e.Item.Cells[6].Text = e.Item.Cells[4].Text.TrimEnd('0'); //e.Item.Cells[6].Text = e.Item.Cells[4].Text.TrimEnd('.'); } }
private Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { item.Sequence, item.ItemCode, item.ItemName, item.MOCode, Math.Round(item.Qty, 2).ToString(), "" }); item = null; return(row); }
protected override string[] FormatExportRecord(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; string strQty = item.Qty.ToString(); string[] strValue = new string[] { item.Sequence.ToString(), item.ItemCode, item.ItemName, item.MOCode, //strQty, Math.Round(item.ActualQty, 2).ToString() }; item = null; return(strValue); }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { item.Sequence, item.ItemCode, item.ItemName, item.MOCode, Math.Round(item.Qty, 2), Math.Round(item.ActualQty, 2) }); item = null; return(row); }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; WarehouseTicket tkt = (WarehouseTicket)httkt[item.TicketNo]; Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { GetTicketNoDisplay(item), Math.Round(item.ActualQty, 2), tkt.TicketUser, tkt.TransactionUser, FormatHelper.ToDateString(tkt.TicketDate), FormatHelper.ToDateString(tkt.TransactionDate) }); item = null; return(row); }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; WarehouseTicket tkt = (WarehouseTicket)httkt[item.TicketNo]; string strFactoryCode, strSegCode, strWarehouseCode; string strQty, strActualQty; if (tkt.FactoryCode == this.drpFactoryCodeQuery.SelectedValue && /* tkt.SegmentCode == this.drpSegmentCodeQuery.SelectedValue && */ tkt.WarehouseCode == FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.drpWarehouseCodeQuery.Text))) { strFactoryCode = tkt.FactoryCode; //strSegCode = tkt.SegmentCode; strWarehouseCode = tkt.WarehouseCode; strQty = (-1 * item.ActualQty).ToString(); strActualQty = item.FromWarehouseQty.ToString(); } else { strFactoryCode = tkt.TOFactoryCode; //strSegCode = tkt.TOSegmentCode; strWarehouseCode = tkt.TOWarehouseCode; strQty = item.ActualQty.ToString(); strActualQty = item.ToWarehouseQty.ToString(); } Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { strFactoryCode, //strSegCode, strWarehouseCode, item.ItemCode, item.ItemName, GetTicketNoDisplay(tkt), httranstype[tkt.TransactionTypeCode], Math.Round(Convert.ToDecimal(strQty), 2), Math.Round(Convert.ToDecimal(strActualQty), 2), tkt.TransactionUser, FormatHelper.ToDateString(tkt.TransactionDate) }); item = null; tkt = null; return(row); }
protected void cmdSave_ServerClick(object sender, System.EventArgs e) { if (txtMOCodeEdit.Enabled == true && FormatHelper.CleanString(this.txtMOCodeEdit.Text) == string.Empty) { throw new Exception("$CS_MO_NotExit"); } if (facade == null) { facade = new BenQGuru.eMES.SelectQuery.SPFacade(base.DataProvider); } BenQGuru.eMES.Material.WarehouseFacade _facade = new BenQGuru.eMES.Material.WarehouseFacade(this.facade.DataProvider); ArrayList list = new ArrayList(); for (int i = 0; i < this.gridSelected.Rows.Count; i++) { if (IsDecimal(this.gridSelected.Rows[i].Cells[3].Text) && decimal.Parse(this.gridSelected.Rows[i].Cells[3].Text) != 0) { WarehouseTicketDetail item = _facade.CreateNewWarehouseTicketDetail(); item.TicketNo = this.GetRequestParam("ticketno"); item.ItemCode = this.gridSelected.Rows[i].Cells[1].Text; item.ItemName = this.gridSelected.Rows[i].Cells[2].Text; item.MOCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeEdit.Text)); item.Qty = decimal.Parse(this.gridSelected.Rows[i].Cells[3].Text); item.ActualQty = 0; item.MaintainUser = this.GetUserCode(); list.Add(item); } } if (FormatHelper.CleanString(this.txtMOCodeEdit.Text) != string.Empty) { BenQGuru.eMES.MOModel.MOFacade mof = new BenQGuru.eMES.MOModel.MOFacade(this.facade.DataProvider); BenQGuru.eMES.Domain.MOModel.MO mo = (BenQGuru.eMES.Domain.MOModel.MO)mof.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeEdit.Text))); if (mo == null || (mo.MOStatus != MOManufactureStatus.MOSTATUS_RELEASE && mo.MOStatus != MOManufactureStatus.MOSTATUS_OPEN && mo.MOStatus != MOManufactureStatus.MOSTATUS_PENDING)) { throw new Exception("$CS_MO_NotExit"); } } _facade.AddWarehouseTicketDetail(list); this.Page.RegisterStartupScript("close window", "<script language='javascript'>CloseWindow();</script>"); }
protected override void DeleteDomainObjects(ArrayList domainObjects) { if (_facade == null) { _facade = new WarehouseFacade(base.DataProvider); } if (domainObjects != null && domainObjects.Count > 0) { for (int i = 0; i < domainObjects.Count; i++) { WarehouseTicketDetail item = (WarehouseTicketDetail)domainObjects[i]; if (item.ActualQty > 0) { throw new Exception("$Add_Ticket_Detail_StatusTransaction [$WarehouseItemCode=" + item.ItemCode + "]"); } } } this._facade.DeleteWarehouseTicketDetail((WarehouseTicketDetail[])domainObjects.ToArray(typeof(WarehouseTicketDetail))); this.ViewState["ItemQty"] = null; this.ExecuteClientFunction("CmdSaveEnable", string.Empty); }
//选择来源工厂、工段,查询所有仓库 /* * 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); * 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) { WarehouseTicketDetail item = (WarehouseTicketDetail)obj; WarehouseTicket tkt = (WarehouseTicket)httkt[item.TicketNo]; string strFactoryCode, strSegCode, strWarehouseCode; string strQty, strActualQty; if (tkt.FactoryCode != string.Empty) { strFactoryCode = tkt.FactoryCode; //strSegCode = tkt.SegmentCode; strWarehouseCode = tkt.WarehouseCode; strQty = (-1 * item.ActualQty).ToString(); strActualQty = item.FromWarehouseQty.ToString(); } else { strFactoryCode = tkt.TOFactoryCode; //strSegCode = tkt.TOSegmentCode; strWarehouseCode = tkt.TOWarehouseCode; strQty = item.ActualQty.ToString(); strActualQty = item.ToWarehouseQty.ToString(); } string[] strArr = new string[] { strFactoryCode, //strSegCode, strWarehouseCode, item.ItemCode, item.ItemName, GetTicketNoDisplay(tkt), httranstype[tkt.TransactionTypeCode].ToString(), strQty, strActualQty, tkt.TransactionUser, FormatHelper.ToDateString(tkt.TransactionDate) }; item = null; tkt = null; return(strArr); }
protected void cmdSave_ServerClick(object sender, EventArgs e) { if (_facade == null) { _facade = new WarehouseFacade(base.DataProvider); } if (ValidateInput()) { for (int i = 0; i < this.gridHelper.Grid.Rows.Count; i++) { UltraGridRow row = this.gridHelper.Grid.Rows[i]; WarehouseTicketDetail item = (WarehouseTicketDetail)this._facade.GetWarehouseTicketDetail(row.Cells.FromKey("TicketSeq").Value.ToString(), this.txtTicketNo.Value); if (item != null && item.ActualQty <= 0) { item.Qty = Convert.ToDecimal(row.Cells.FromKey("ItemQty").Value); this._facade.UpdateWarehouseTicketDetail(item); } } } this.cmdQuery_Click(null, null); }
private string GetTicketNoDisplay(WarehouseTicketDetail item) { string strTicketNo = ""; string strHideList = ","; try { string strPath = this.MapPath("TransTypeMoStock.xml"); System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); doc.Load(strPath); System.Xml.XmlElement eleDoc = doc.DocumentElement; TransactionType.TRANSACTION_MAPPING = new Hashtable(); System.Xml.XmlNode elemap = eleDoc.SelectSingleNode("//TransTypeMapping"); if (elemap != null) { for (int i = 0; i < elemap.ChildNodes.Count; i++) { if (elemap.ChildNodes[i].NodeType == System.Xml.XmlNodeType.Element) { if (elemap.ChildNodes[i].Attributes["HideTicketNo"] != null && elemap.ChildNodes[i].Attributes["HideTicketNo"].Value == "Yes") { strHideList += elemap.ChildNodes[i].Attributes["Code"].Value + ","; } } } } } catch { strHideList = ""; } if (strHideList.IndexOf("," + this.GetRequestParam("transtype") + ",") < 0 || item.TicketNo.Substring(0, 1) != "-") { strTicketNo = item.TicketNo; } return(strTicketNo); }