protected void Page_Load(object sender, EventArgs e)
{
string custname = Request.QueryString["custname"];
string partsdrawing = Request.QueryString["partsdrawing"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
WorkOrder wo = new WorkOrder();
wo.CustName = custname;
wo.PartsdrawingCode = partsdrawing;
if (!string.IsNullOrEmpty(starttime))
{
wo.StartTime = Convert.ToDateTime(starttime);
}
if (!string.IsNullOrEmpty(endtime))
{
wo.EndTime = Convert.ToDateTime(endtime);
}
IList <WorkOrder> objs = _bal.FindWorkOrderInfo(wo);
if (objs == null || objs.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("QualityQuery");
row = hssfSheet.CreateRow(0);
//填充头
string objhead = "客户名称,工件图号,工单号码,工件名称,计划数量,产出数量,不良数量,不良率";
for (int i = 0; i < objhead.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objhead.Split(',')[i]);
}
for (int i = 1; i < objs.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objs[i - 1].CustName);
cell = row.CreateCell(1);
cell.SetCellValue(objs[i - 1].PartsdrawingCode);
cell = row.CreateCell(2);
cell.SetCellValue(objs[i - 1].WO);
cell = row.CreateCell(3);
cell.SetCellValue(objs[i - 1].ProductName);
cell = row.CreateCell(4);
cell.SetCellValue(objs[i - 1].PlanQuantity.ToString());
cell = row.CreateCell(5);
cell.SetCellValue(objs[i - 1].QUANTITY.ToString());
int failcount = _bal.FindFailCountbyWorkOrder(objs[i - 2].WO, "");
string failrate = (Math.Round((double)(failcount * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
cell = row.CreateCell(6);
cell.SetCellValue(failcount.ToString());
cell = row.CreateCell(7);
cell.SetCellValue(failrate);
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "QualityQuery" + DateTime.Now.ToString("yyyyMMddHHmmss");
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", fileName));
Response.AddHeader("Content-Length", file.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.BinaryWrite(file.GetBuffer());
Response.Flush();
Response.End();
}