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);
}
