//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执行情况-BUYER ");
xls.NewRow(0);
xls.Cell(0, "鼎桥物料编码", style);
xls.Cell(1, "鼎桥物料描述", 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, "让步接收数量", style);
xls.Cell(11, "特采放行数量", style);
int rowNum = 1;
IQCExecSummaryBuyer[] rs = _WarehouseFacade.GetIQCExecBuyerSummary(
FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text),
txtDQMCodeQuery.Text,
txtDQMDESCQuery.Text,
txtVendorCodeQuery.Text,
txtVendorNameQuery.Text);
for (int i = 0; i < rs.Length; i++)
{
xls.NewRow(rowNum);
string DQMCODE = rs[i].DQMCODE;
xls.Cell(0, DQMCODE, style);
string MDESC = rs[i].MDESC;
xls.Cell(1, MDESC, style);
string VENDORCODE = rs[i].VENDORCODE;
xls.Cell(2, VENDORCODE, style);
string VENDORNAME = rs[i].VENDORNAME;
xls.Cell(3, VENDORNAME, style);
string QTY = rs[i].QTY.ToString();
xls.Cell(4, QTY, style);
string SAMPLESIZE = rs[i].SAMPLESIZE.ToString();
xls.Cell(5, SAMPLESIZE, style);
string NGQTY = rs[i].NGQTY.ToString();
xls.Cell(6, NGQTY, style);
string NGPER = rs[i].NGPER;
xls.Cell(7, NGPER, style);
string ReturnQTY = rs[i].ReturnQTY.ToString();
xls.Cell(8, ReturnQTY, style);
string ReformQTY = rs[i].ReformQTY.ToString();
xls.Cell(9, ReformQTY, style);
string GiveQTY = rs[i].GiveQTY.ToString();
xls.Cell(10, GiveQTY, style);
string AcceptQTY = rs[i].AcceptQTY.ToString();
xls.Cell(11, AcceptQTY, 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);
}