protected override string[] FormatExportRecord(object obj)
{
MOStock stock = (MOStock)obj;
string dNGRateManual, dNGRateFromItem, dWearOffRateTotal;
if (stock.IssueQty != 0)
{
dNGRateManual = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
dNGRateFromItem = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
}
else
{
dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
}
string[] strArr =
new string[] { stock.MOCode,
stock.ItemCode,
GetItemName(stock.ItemCode),
Math.Round(stock.ReceiptQty, 2).ToString(),
Math.Round(stock.IssueQty, 2).ToString(),
Math.Round(stock.ScrapQty, 2).ToString(),
Math.Round(stock.ReturnQty, 2).ToString(),
Math.Round(stock.ReturnScrapQty, 2).ToString(),
Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2).ToString(),
dNGRateManual,
dNGRateFromItem,
dWearOffRateTotal };
stock = null;
return(strArr);
}
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj)
{
MOStock stock = (MOStock)obj;
string dNGRateManual, dNGRateFromItem, dWearOffRateTotal;
string dMOWasteRate = "0%"; //工单损耗率
string dMOScrapRate = "0%";; //工单报废率
#region 工单损耗率,工单报废率 不显示不计算
// decimal wasteRate = 0;
// decimal scrapRate = 0;
// if(stock.MOLoadingQty !=0 && (stock.MOLoadingQty + stock.TSLoadingQty) != 0 )
// if(stock.MOStatus == BenQGuru.eMES.Web.Helper.MOManufactureStatus.MOSTATUS_CLOSE)
// {
// wasteRate = (stock.ScrapQty + stock.TSUnCompletedQty) / stock.MOLoadingQty;
// scrapRate = (stock.ScrapQty + stock.TSUnCompletedQty) / (stock.MOLoadingQty + stock.TSLoadingQty);
// }
// else
// {
// wasteRate = stock.ScrapQty/ stock.MOLoadingQty;
// scrapRate = stock.ScrapQty / (stock.MOLoadingQty + stock.TSLoadingQty);
// }
// if(wasteRate != 0)
// {
// dMOWasteRate = wasteRate.ToString("##.##%");
// }
// if(scrapRate != 0)
// {
// dMOScrapRate = scrapRate.ToString("##.##%");
// }
#endregion
if (stock.IssueQty != 0)
{
dNGRateManual = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
dNGRateFromItem = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
}
else
{
dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
}
Infragistics.WebUI.UltraWebGrid.UltraGridRow row =
new Infragistics.WebUI.UltraWebGrid.UltraGridRow(
new object[] {
stock.MOCode,
stock.ItemCode,
GetItemName(stock.ItemCode),
Math.Round(stock.ReceiptQty, 2).ToString(),
Math.Round(stock.IssueQty, 2).ToString(),
Math.Round(stock.ScrapQty, 2).ToString(),
Math.Round(stock.ReturnQty, 2).ToString(),
Math.Round(stock.ReturnScrapQty, 2).ToString(),
Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2),
dNGRateManual,
dNGRateFromItem,
//dMOWasteRate,
//dMOScrapRate,
dWearOffRateTotal
});
stock = null;
return(row);
}
protected override string[] FormatExportRecord(object obj)
{
/*
* MOStock stock = (MOStock)obj;
* string dNGRateManual, dNGRateFromItem, dWearOffRateTotal;
* if (stock.IssueQty != 0)
* {
* dNGRateManual = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
* dNGRateFromItem = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
* dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
* }
* else
* {
* dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
* }
* string[] strArr =
* new string[]{ stock.MOCode,
* stock.ItemCode,
* GetItemName(stock.ItemCode),
* Math.Round(stock.ReceiptQty, 2).ToString(),
* Math.Round(stock.IssueQty, 2).ToString(),
* Math.Round(stock.ScrapQty, 2).ToString(),
* Math.Round(stock.ReturnQty, 2).ToString(),
* Math.Round(stock.ReturnScrapQty, 2).ToString(),
* Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2).ToString(),
* dNGRateManual,
* dNGRateFromItem,
* dWearOffRateTotal
* };
* stock = null;
* return strArr;
*/
MOStock stock = (MOStock)obj;
string dNGRateManual, dNGRateFromItem, dWearOffRateTotal;
string dMOWasteRate = "0%"; //工单损耗率
string dMOScrapRate = "0%";; //工单报废率
#region 工单损耗率,工单报废率 不显示不计算
// decimal wasteRate = 0;
// decimal scrapRate = 0;
// if(stock.MOLoadingQty !=0 && (stock.MOLoadingQty + stock.TSLoadingQty) != 0 )
// if(stock.MOStatus == BenQGuru.eMES.Web.Helper.MOManufactureStatus.MOSTATUS_CLOSE)
// {
// wasteRate = (stock.ScrapQty + stock.TSUnCompletedQty) / stock.MOLoadingQty;
// scrapRate = (stock.ScrapQty + stock.TSUnCompletedQty) / (stock.MOLoadingQty + stock.TSLoadingQty);
// }
// else
// {
// wasteRate = stock.ScrapQty/ stock.MOLoadingQty;
// scrapRate = stock.ScrapQty / (stock.MOLoadingQty + stock.TSLoadingQty);
// }
// if(wasteRate != 0)
// {
// dMOWasteRate = wasteRate.ToString("##.##%");
// }
// if(scrapRate != 0)
// {
// dMOScrapRate = scrapRate.ToString("##.##%");
// }
#endregion
if (stock.IssueQty != 0)
{
dNGRateManual = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
dNGRateFromItem = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
}
else
{
dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
}
//
if (htMOList == null)
{
htMOList = new Hashtable();
}
if (htMOList.Contains(stock.MOCode) == false)
{
if (moFacade == null)
{
moFacade = new BenQGuru.eMES.MOModel.MOFacade(this.DataProvider);
}
Domain.MOModel.MO mo = (Domain.MOModel.MO)moFacade.GetMO(stock.MOCode);
if (sbomFacade == null)
{
sbomFacade = new BenQGuru.eMES.MOModel.SBOMFacade(this.DataProvider);
}
object[] objsBom = sbomFacade.Query(mo.ItemCode);
object[] objValue = new object[] { mo, objsBom };
htMOList.Add(stock.MOCode, objValue);
}
object[] objMOValue = (object[])htMOList[stock.MOCode];
Domain.MOModel.MO moValue = (Domain.MOModel.MO)objMOValue[0];
string strMOQty = Convert.ToInt32(moValue.MOPlanQty).ToString();
object[] objMOBom = (object[])objMOValue[1];
string strMOMaterialQty = "0";
if (objMOBom != null)
{
for (int i = 0; i < objMOBom.Length; i++)
{
Domain.MOModel.SBOM sbom = (Domain.MOModel.SBOM)objMOBom[i];
if (sbom.SBOMItemCode == stock.ItemCode)
{
strMOMaterialQty = Math.Round(moValue.MOPlanQty * sbom.SBOMItemQty, 2).ToString();
break;
}
}
}
string strDiffMaterialQty = "0";
try
{
decimal dTmp = Convert.ToDecimal(strMOMaterialQty) - stock.ReceiptQty + stock.ReturnScrapQty + stock.ReturnQty;
strDiffMaterialQty = Math.Round(dTmp, 2).ToString();
}
catch {}
string strMemoQty = this.GetMemoQty(stock.MOCode, stock.ItemCode);
//
string[] row =
new string[] {
stock.MOCode,
stock.ItemCode,
GetItemName(stock.ItemCode),
strMOQty,
strMOMaterialQty,
Math.Round(stock.ReceiptQty, 2).ToString(),
strDiffMaterialQty,
Math.Round(stock.IssueQty, 2).ToString(),
Math.Round(stock.ScrapQty, 2).ToString(),
Math.Round(stock.ReturnQty, 2).ToString(),
Math.Round(stock.ReturnScrapQty, 2).ToString(),
Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2).ToString(),
strMemoQty,
""
};
stock = null;
return(row);
}
