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