protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("IQCCCOUNT", "创建IQC个数", null);
this.gridHelper.AddColumn("QCCOUNT", "QC检验个数", null);
this.gridHelper.AddColumn("SQECOUNT", "SQE判定个数", null);
this.gridHelper.AddColumn("AVERQCTIME", "平均QC检验时间", null);
this.gridHelper.AddColumn("AVERSQETIME", "平均SQE判定时间", null);
this.gridHelper.AddColumn("AVERIQCTIME", "平均IQC执行时间", null);
this.gridHelper.AddColumn("QTY", "来料总数", null);
this.gridHelper.AddColumn("SAMPLECOUNT", "样本总数", null);
this.gridHelper.AddColumn("NGQTY", "缺陷品总数", null);
this.gridHelper.AddColumn("RETURNQTY", "退换货数量", null);
this.gridHelper.AddColumn("REFORMQTY", "现场整改数量", null);
this.gridHelper.AddColumn("GIVEQTY", "让步接收数量", null);
this.gridHelper.AddColumn("ACCEPTQTY", "特采放行数量", null);
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
this.gridHelper.AddColumn(ecg.ErrorCodeGroup, ecg.ErrorCodeGroupDescription, null);
}
}
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
}
protected override DataRow GetGridRow(object obj)
{
if (facade == null)
{
facade = new WarehouseFacade(base.DataProvider);
}
DataRow row = this.DtSource.NewRow();
IQCSUMMARY s = (IQCSUMMARY)obj;
row["IQCCCOUNT"] = s.IQCCCOUNT;
row["QCCOUNT"] = s.QCCOUNT;
row["SQECOUNT"] = s.SQECOUNT;
row["AVERQCTIME"] = facade.QCAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["AVERSQETIME"] = facade.SQEAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["AVERIQCTIME"] = facade.IQCAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["QTY"] = s.QTY;
row["SAMPLECOUNT"] = s.SAMPLECOUNT;
row["NGQTY"] = s.NGQTY;
row["RETURNQTY"] = s.RETURNQTY;
row["REFORMQTY"] = s.REFORMQTY;
row["GIVEQTY"] = s.GIVEQTY;
row["ACCEPTQTY"] = s.ACCEPTQTY;
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
IQCSUMMARY[] summary = facade.EGGroupQty(ecg.ErrorCodeGroup,
txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text,
FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
int sum = 0;
foreach (IQCSUMMARY o in summary)
{
sum += o.NGQTY;
}
row[ecg.ErrorCodeGroup] = sum;
}
}
return(row);
}
protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("IQCNO", "IQC单号", null);
this.gridHelper.AddColumn("INVNO", "SAP单据号", null);
this.gridHelper.AddColumn("STTYPE", "入库类型", null);
this.gridHelper.AddColumn("StorageCode", "库位", null);
this.gridHelper.AddColumn("VENDORCODE", "供应商代码", null);
this.gridHelper.AddColumn("VendorName", "供应商名称", null);
this.gridHelper.AddColumn("DQMCODE", "鼎桥物料编码", null);
this.gridHelper.AddColumn("VENDORMCODE", "供应商物料编码", null);
this.gridHelper.AddColumn("MDESC1111", "鼎桥物料描述", null);
this.gridHelper.AddColumn("IQCTYPE", "检验方式", null);
this.gridHelper.AddColumn("AQLLEVEL", "AQL标准", null);
this.gridHelper.AddColumn("QTY", "来料数量", null);
this.gridHelper.AddColumn("IQCQTY", "样本数量", null);
this.gridHelper.AddColumn("NGQTY", "缺陷品数", null);
this.gridHelper.AddColumn("RETURNQTY", "退换货数量", null);
this.gridHelper.AddColumn("ReformQTY", "现场整改数量", null);
this.gridHelper.AddColumn("GiveQTY", "让步接收数量", null);
this.gridHelper.AddColumn("AcceptQTY", "特采放行数量", null);
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
this.gridHelper.AddColumn(ecg.ErrorCodeGroup, ecg.ErrorCodeGroupDescription, null);
}
}
this.gridHelper.AddColumn("CDATE", "创建时间", null);
this.gridHelper.AddColumn("QCFINISHDATE", "QC检验完成时间", null);
this.gridHelper.AddColumn("SEQFINISHDATE", "SQE判定完成时间", null);
this.gridHelper.AddColumn("IQCFINISHDATE", "IQC检验完成时间", null);
this.gridHelper.AddColumn("QCDATERANGE", "QC检验执行时间", null);
this.gridHelper.AddColumn("IQCSEQDATERANGE", "SQE判定执行时间", null);
this.gridHelper.AddColumn("IQCDATERANGE", "IQC检验执行时间", null);
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
}
private Dictionary <string, string> GetECodelist()
{
if (_SystemSettingFacade == null)
{
_SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
}
Dictionary <string, string> ECodelist = new Dictionary <string, string>();
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null)
{
foreach (ErrorCodeGroupA ecg in objs)
{
ECodelist.Add(ecg.ErrorCodeGroup, ecg.ErrorCodeGroupDescription);
}
}
return(ECodelist);
}
//protected override void gridWebGrid_ItemCommand(GridRecord row, string commandName)
//{
// if (commandName == "Edit")
// {
// object obj = this.GetEditObject(row);
// if (obj != null)
// {
// this.SetEditObject(obj);
// this.buttonHelper.PageActionStatusHandle(PageActionType.Update);
// }
// }
// else if (commandName == "LinkDetail")
// {
// string pickNo = row.Items.FindItemByKey("PickNo").Text.Trim();
// //string storageOut = row.Items.FindItemByKey("StorageOut").Text.Trim();
// Response.Redirect(this.MakeRedirectUrl("FCreatePickLineMP.aspx", new string[] { "ACT", "PickNo" }, new string[] { "LinkDetail", pickNo }));
// }
//}
protected override void cmdExport_Click(object sender, EventArgs e)
{
BenQGuru.eMES.Material.WarehouseFacade _WarehouseFacade = new BenQGuru.eMES.Material.WarehouseFacade(base.DataProvider);
List <string> ca = new List <string>();
XlsPackage xls = new XlsPackage();
IFont font = xls.Black;
font.FontHeightInPoints = 10;
ICellStyle style = xls.Normal;
style.SetFont(font);
xls.CreateSheet("IQC统计表");
xls.NewRow(0);
xls.Cell(0, "创建OQC个数", style);
xls.Cell(1, "QC检验个数", style);
xls.Cell(2, "SQE判定个数", style);
xls.Cell(3, "平均QC检验时间", style);
xls.Cell(4, "平均SQE判定时间", style);
xls.Cell(5, "平均IQC执行时间", style);
xls.Cell(6, "来料总数", style);
xls.Cell(7, "样本总数", style);
xls.Cell(8, "缺陷品总数", style);
xls.Cell(9, "退换货数量", style);
xls.Cell(10, "现场整改数量", style);
xls.Cell(11, "让步接收数量", style);
xls.Cell(12, "特采放行数量", style);
int cellNum = 13;
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
xls.Cell(cellNum, ecg.ErrorCodeGroupDescription, style);
cellNum++;
}
}
int rowNum = 1;
for (int i = 0; i < this.gridWebGrid.Rows.Count; i++)
{
xls.NewRow(rowNum);
string IQCCCOUNT = this.gridWebGrid.Rows[i].Items.FindItemByKey("IQCCCOUNT").Text;
xls.Cell(0, IQCCCOUNT, style);
string QCCOUNT = this.gridWebGrid.Rows[i].Items.FindItemByKey("QCCOUNT").Text;
xls.Cell(1, QCCOUNT, style);
string SQECOUNT = this.gridWebGrid.Rows[i].Items.FindItemByKey("SQECOUNT").Text;
xls.Cell(2, SQECOUNT, style);
string AVERQCTIME = this.gridWebGrid.Rows[i].Items.FindItemByKey("AVERQCTIME").Text;
xls.Cell(3, AVERQCTIME, style);
string AVERSQETIME = this.gridWebGrid.Rows[i].Items.FindItemByKey("AVERSQETIME").Text;
xls.Cell(4, AVERSQETIME, style);
string AVERIQCTIME = this.gridWebGrid.Rows[i].Items.FindItemByKey("AVERIQCTIME").Text;
xls.Cell(5, AVERIQCTIME, style);
string QTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("QTY").Text;
xls.Cell(6, QTY, style);
string SAMPLECOUNT = this.gridWebGrid.Rows[i].Items.FindItemByKey("SAMPLECOUNT").Text;
xls.Cell(7, SAMPLECOUNT, style);
string NGQTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("NGQTY").Text;
xls.Cell(8, NGQTY, style);
string RETURNQTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("RETURNQTY").Text;
xls.Cell(9, RETURNQTY, style);
string REFORMQTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("REFORMQTY").Text;
xls.Cell(10, REFORMQTY, style);
string GIVEQTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("GIVEQTY").Text;
xls.Cell(11, GIVEQTY, style);
string ACCEPTQTY = this.gridWebGrid.Rows[i].Items.FindItemByKey("ACCEPTQTY").Text;
xls.Cell(12, ACCEPTQTY, style);
int cellNum2 = 13;
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
string ngStr = this.gridWebGrid.Rows[i].Items.FindItemByKey(ecg.ErrorCodeGroup).Text;
xls.Cell(cellNum2, ngStr, style);
cellNum2++;
}
}
rowNum++;
}
string filename = string.Format("Export_{0}_{1}.{2}", FormatHelper.TODateInt(System.DateTime.Now).ToString(), FormatHelper.TOTimeInt(System.DateTime.Now).ToString(), "xls");
string filepath = string.Format(@"{0}{1}", this.DownloadPhysicalPath, filename);
FileStream file = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite);
xls.Save(file);
file.Close();
DownLoadFile1(filename);
}
//protected override void gridWebGrid_ItemCommand(GridRecord row, string commandName)
//{
// if (commandName == "Edit")
// {
// object obj = this.GetEditObject(row);
// if (obj != null)
// {
// this.SetEditObject(obj);
// this.buttonHelper.PageActionStatusHandle(PageActionType.Update);
// }
// }
// else if (commandName == "LinkDetail")
// {
// string pickNo = row.Items.FindItemByKey("PickNo").Text.Trim();
// //string storageOut = row.Items.FindItemByKey("StorageOut").Text.Trim();
// Response.Redirect(this.MakeRedirectUrl("FCreatePickLineMP.aspx", new string[] { "ACT", "PickNo" }, new string[] { "LinkDetail", pickNo }));
// }
//}
protected override void cmdExport_Click(object sender, EventArgs e)
{
BenQGuru.eMES.Material.WarehouseFacade _WarehouseFacade = new BenQGuru.eMES.Material.WarehouseFacade(base.DataProvider);
List <string> ca = new List <string>();
XlsPackage xls = new XlsPackage();
IFont font = xls.Black;
font.FontHeightInPoints = 10;
ICellStyle style = xls.Normal;
style.SetFont(font);
xls.CreateSheet("IQC明细表");
xls.NewRow(0);
xls.Cell(0, "IQC单号", style);
xls.Cell(1, "SAP单据号", style);
//xls.Cell(2, "SAP单据号", style);
xls.Cell(2, "入库类型", style);
xls.Cell(3, "库位", style);
xls.Cell(4, "供应商代码", style);
xls.Cell(5, "供应商名称", style);
xls.Cell(6, "鼎桥物料编码", style);
xls.Cell(7, "供应商物料编码", style);
xls.Cell(8, "鼎桥物料描述", style);
xls.Cell(9, "检验方式", style);
xls.Cell(10, "AQL标准", style);
xls.Cell(11, "来料数量", style);
xls.Cell(12, "样本数量", style);
xls.Cell(13, "缺陷品数", style);
xls.Cell(14, "退换货数量", style);
xls.Cell(15, "现场整改数量", style);
xls.Cell(16, "让步接收数量", style);
xls.Cell(17, "特采放行数量", style);
int cellNum = 18;
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
xls.Cell(cellNum, ecg.ErrorCodeGroupDescription, style);
cellNum++;
}
}
xls.Cell(cellNum++, "创建时间", style);
xls.Cell(cellNum++, "QC检验完成时间", style);
xls.Cell(cellNum++, "SQE判定完成时间", style);
xls.Cell(cellNum++, "IQC检验完成时间", style);
xls.Cell(cellNum++, "QC检验执行时间", style);
xls.Cell(cellNum++, "SQE判定执行时间", style);
xls.Cell(cellNum++, "IQC检验执行时间", style);
int rowNum = 1;
IQCDetailRecord[] iqcs = _WarehouseFacade.QueryIQCs(this.txtStorageCodeQuery.Text,
this.txtVendorCodeQuery.Text, this.drpStorageInTypeQuery.SelectedValue,
FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
InventoryFacade _InventoryFacade = new InventoryFacade(base.DataProvider);
for (int i = 0; i < iqcs.Length; i++)
{
xls.NewRow(rowNum);
string iqcNO = iqcs[i].IQCNO;
xls.Cell(0, iqcNO, style);
string invNo = iqcs[i].INVNO;
xls.Cell(1, invNo, style);
string stType = iqcs[i].STTYPE;
xls.Cell(2, stType, style);
string StorageCode = iqcs[i].StorageCode;
xls.Cell(3, StorageCode, style);
string VENDORCODE = iqcs[i].VENDORCODE;
xls.Cell(4, VENDORCODE, style);
string VendorName = iqcs[i].VendorName;
xls.Cell(5, VendorName, style);
string DQMCODE = iqcs[i].DQMCODE;
xls.Cell(6, DQMCODE, style);
string VENDORMCODE = iqcs[i].VENDORMCODE;
xls.Cell(7, VENDORMCODE, style);
Domain.MOModel.Material m = (Domain.MOModel.Material)_InventoryFacade.GetMaterialByDQMCode(iqcs[i].DQMCODE);
string MDESC = m.MchlongDesc;
xls.Cell(8, MDESC, style);
string IQCTYPE = iqcs[i].IQCTYPE;
xls.Cell(9, IQCTYPE, style);
string AQLLEVEL = iqcs[i].AQLLEVEL;
xls.Cell(10, AQLLEVEL, style);
string QTY = iqcs[i].QTY.ToString();
xls.Cell(11, QTY, style);
string IQCQTY = iqcs[i].SAMPLESIZE.ToString();
xls.Cell(12, IQCQTY, style);
string NGQTY = iqcs[i].NGQTY.ToString();
xls.Cell(13, NGQTY, style);
string RETURNQTY = iqcs[i].RETURNQTY.ToString();
xls.Cell(14, RETURNQTY, style);
string ReformQTY = iqcs[i].ReformQTY.ToString();
xls.Cell(15, ReformQTY, style);
string GiveQTY = iqcs[i].GiveQTY.ToString();
xls.Cell(16, GiveQTY, style);
string AcceptQTY = iqcs[i].AcceptQTY.ToString();
xls.Cell(17, AcceptQTY, style);
int cellNum2 = 18;
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
int num = _WarehouseFacade.GetErrorGroupNum(iqcs[i].IQCNO, ecg.ErrorCodeGroup);
xls.Cell(cellNum2, num, style);
cellNum2++;
}
}
string CDATE = iqcs[i].CDATE.ToString();
xls.Cell(cellNum2++, CDATE, style);
InvInOutTrans OCFinishInv = _WarehouseFacade.QCFinishDateTimeTrans(iqcs[i].IQCNO);
InvInOutTrans SQEFinishInv = _WarehouseFacade.SQEFinishDateTimeTrans(iqcs[i].IQCNO);
InvInOutTrans IQCFinishInv = SQEFinishInv ?? (OCFinishInv ?? null);
string QCFINISHDATEStr = OCFinishInv != null?FormatHelper.ToDateString(OCFinishInv.MaintainDate) : string.Empty;
string SEQFINISHDATEStr = SQEFinishInv != null?FormatHelper.ToDateString(SQEFinishInv.MaintainDate) : string.Empty;
string IQCFINISHDATEStr = IQCFinishInv != null?FormatHelper.ToDateString(IQCFinishInv.MaintainDate) : string.Empty;
decimal QCDATERANGE = OCFinishInv != null?Common.Totalday(OCFinishInv.MaintainDate, OCFinishInv.MaintainTime, iqcs[i].CDATE, iqcs[i].CTIME) : (decimal)0;
string IQCSEQDATERANGE = string.Empty;
string IQCDATERANGEStr = string.Empty;
if (OCFinishInv != null && SQEFinishInv != null)
{
IQCSEQDATERANGE = Common.Totalday(SQEFinishInv.MaintainDate, SQEFinishInv.MaintainTime, OCFinishInv.MaintainDate, OCFinishInv.MaintainTime).ToString();
}
if (IQCFinishInv != null)
{
IQCDATERANGEStr = Common.Totalday(IQCFinishInv.MaintainDate, IQCFinishInv.MaintainTime, iqcs[i].CDATE, iqcs[i].CTIME).ToString();
}
xls.Cell(cellNum2++, QCFINISHDATEStr, style);
xls.Cell(cellNum2++, SEQFINISHDATEStr, style);
xls.Cell(cellNum2++, IQCFINISHDATEStr, style);
xls.Cell(cellNum2++, QCDATERANGE.ToString(), style);
xls.Cell(cellNum2++, IQCSEQDATERANGE, style);
xls.Cell(cellNum2++, IQCDATERANGEStr, style);
rowNum++;
}
string filename = string.Format("Export_{0}_{1}.{2}", FormatHelper.TODateInt(System.DateTime.Now).ToString(), FormatHelper.TOTimeInt(System.DateTime.Now).ToString(), "xls");
string filepath = string.Format(@"{0}{1}", this.DownloadPhysicalPath, filename);
FileStream file = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite);
xls.Save(file);
file.Close();
DownLoadFile1(filename);
}
protected override DataRow GetGridRow(object obj)
{
if (facade == null)
{
facade = new WarehouseFacade(base.DataProvider);
}
DataRow row = this.DtSource.NewRow();
IQCDetailRecord s = (IQCDetailRecord)obj;
InventoryFacade _InventoryFacade = new InventoryFacade(base.DataProvider);
Domain.MOModel.Material m = (Domain.MOModel.Material)_InventoryFacade.GetMaterialByDQMCode(s.DQMCODE);
row["IQCNO"] = s.IQCNO;
row["INVNO"] = s.INVNO;
row["STTYPE"] = this.GetInvInName(s.STTYPE);
row["StorageCode"] = s.StorageCode;
row["VENDORCODE"] = s.VENDORCODE;
row["VendorName"] = s.VendorName;
row["DQMCODE"] = s.DQMCODE;
row["VENDORMCODE"] = s.VENDORMCODE;
row["MDESC1111"] = m.MchlongDesc;
row["IQCTYPE"] = s.IQCTYPE;
row["AQLLEVEL"] = s.AQLLEVEL;
row["QTY"] = s.QTY;
row["IQCQTY"] = s.SAMPLESIZE;
row["NGQTY"] = s.NGQTY;
row["RETURNQTY"] = s.RETURNQTY;
row["ReformQTY"] = s.ReformQTY;
row["GiveQTY"] = s.GiveQTY;
row["AcceptQTY"] = s.AcceptQTY;
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
row[ecg.ErrorCodeGroup] = facade.GetErrorGroupNum(s.IQCNO, ecg.ErrorCodeGroup);
}
}
row["CDATE"] = FormatHelper.ToDateString(s.CDATE);
InvInOutTrans OCFinishInv = facade.QCFinishDateTimeTrans(s.IQCNO);
InvInOutTrans SQEFinishInv = facade.SQEFinishDateTimeTrans(s.IQCNO);
InvInOutTrans IQCFinishInv = SQEFinishInv ?? (OCFinishInv ?? null);
row["QCFINISHDATE"] = OCFinishInv != null?FormatHelper.ToDateString(OCFinishInv.MaintainDate) : string.Empty;
row["SEQFINISHDATE"] = SQEFinishInv != null?FormatHelper.ToDateString(SQEFinishInv.MaintainDate) : string.Empty;
row["IQCFINISHDATE"] = IQCFinishInv != null?FormatHelper.ToDateString(IQCFinishInv.MaintainDate) : string.Empty;
row["QCDATERANGE"] = OCFinishInv != null?Common.Totalday(OCFinishInv.MaintainDate, OCFinishInv.MaintainTime, s.CDATE, s.CTIME) : 0;
if (OCFinishInv != null && SQEFinishInv != null)
{
row["IQCSEQDATERANGE"] = Common.Totalday(SQEFinishInv.MaintainDate, SQEFinishInv.MaintainTime, OCFinishInv.MaintainDate, OCFinishInv.MaintainTime);
}
else
{
row["IQCSEQDATERANGE"] = string.Empty;
}
if (IQCFinishInv != null)
{
row["IQCDATERANGE"] = Common.Totalday(IQCFinishInv.MaintainDate, IQCFinishInv.MaintainTime, s.CDATE, s.CTIME);
}
else
{
row["IQCDATERANGE"] = string.Empty;
}
return(row);
}
