protected void Page_Load(object sender, EventArgs e)
{
string workorder = Request.QueryString["workorder"];
string status = Request.QueryString["status"];
string partsdrawingno = Request.QueryString["partsdrawingno"];
string order = Request.QueryString["order"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
DateTime dtstart = DateTime.Today.AddDays(-100);
DateTime dtend = DateTime.Now;
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
dtstart = Convert.ToDateTime(starttime);
dtend = Convert.ToDateTime(endtime);
}
WorkOrderDetails wo = new WorkOrderDetails();
wo.WO = workorder;
wo.STATUS = status == "4"?"":status;
wo.PartsdrawingCode = partsdrawingno;
wo.OrderNumber = order;
wo.StartTime = dtstart;
wo.EndTime = dtend;
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
IList <WorkOrderDetails> woobjs = _bal.FindWorkOrderDetailsInfo(wo);
WsSystem ws = new WsSystem();
if (woobjs == null || woobjs.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("WorkOrderInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "工单单号,订单单号,零件图号,工单状态,机床类型,机床名称,负责人员,产品名称,计划开始,计划结束,批次,计划数量,产出数量,计划检验,计划入库,操作人,时间,工序,工序号";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
if (woobjs != null)
{
for (int i = 2; i <= woobjs.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(woobjs[i - 2].WO);
cell = row.CreateCell(1);
cell.SetCellValue(woobjs[i - 2].OrderNumber);
cell = row.CreateCell(2);
cell.SetCellValue(woobjs[i - 2].PartsdrawingCode);
cell = row.CreateCell(3);
cell.SetCellValue(woobjs[i - 2].StatusMemo);
cell = row.CreateCell(4);
cell.SetCellValue(woobjs[i - 2].MachineType);
cell = row.CreateCell(5);
cell.SetCellValue(woobjs[i - 2].MachineName);
cell = row.CreateCell(6);
cell.SetCellValue(woobjs[i - 2].WorkerName);
cell = row.CreateCell(7);
cell.SetCellValue(woobjs[i - 2].ProductName);
cell = row.CreateCell(8);
cell.SetCellValue(woobjs[i - 2].StartTime.ToString());
cell = row.CreateCell(9);
cell.SetCellValue(woobjs[i - 2].EndTime.ToString());
cell = row.CreateCell(10);
cell.SetCellValue(woobjs[i - 2].BatchNumber);
cell = row.CreateCell(11);
cell.SetCellValue(woobjs[i - 2].PlanQuantity.ToString());
cell = row.CreateCell(12);
cell.SetCellValue(woobjs[i - 2].QUANTITY.ToString());
cell = row.CreateCell(13);
cell.SetCellValue(woobjs[i - 2].CheckTime.ToString());
cell = row.CreateCell(14);
cell.SetCellValue(woobjs[i - 2].InstockTime.ToString());
cell = row.CreateCell(15);
cell.SetCellValue(ws.FindUserNameByCode(woobjs[i - 2].UpdatedBy));
cell = row.CreateCell(16);
cell.SetCellValue(woobjs[i - 2].UpdatedDate == null ? woobjs[i - 2].CreatedDate.ToString() : woobjs[i - 2].UpdatedDate.ToString());
cell = row.CreateCell(17);
cell.SetCellValue(woobjs[i - 2].StationName.ToString());
cell = row.CreateCell(18);
cell.SetCellValue(woobjs[i - 2].RouteCode.ToString());
}
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "WorkOrderInfo" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string partsdrawingno = Request.QueryString["partsdrawingno"];
string custcode = Request.QueryString["custcode"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
DateTime dtstart = DateTime.Today.AddDays(-100);
DateTime dtend = DateTime.Now;
if (custcode == "-1")
{
custcode = "";
}
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
dtstart = Convert.ToDateTime(starttime);
dtend = Convert.ToDateTime(endtime);
}
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
IList <PartsdrawingCode> woobjs = _bal.FindPartsdrawingInfo(partsdrawingno, custcode, starttime, endtime);
WsSystem ws = new WsSystem();
if (woobjs == null || woobjs.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("PartsdrawingInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "零件图号,客户名称,客户代码,产品名称,投产总数,质量编号,交付数量,炉批号,交付时间,创建人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
if (woobjs != null)
{
for (int i = 2; i <= woobjs.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(woobjs[i - 2].PartsCode);
cell = row.CreateCell(1);
cell.SetCellValue(woobjs[i - 2].CustName);
cell = row.CreateCell(2);
cell.SetCellValue(woobjs[i - 2].CustCode);
cell = row.CreateCell(3);
cell.SetCellValue(woobjs[i - 2].ProductName);
cell = row.CreateCell(4);
cell.SetCellValue(woobjs[i - 2].PlanQuantity.ToString());
cell = row.CreateCell(5);
cell.SetCellValue(woobjs[i - 2].QualityCode);
cell = row.CreateCell(6);
cell.SetCellValue(woobjs[i - 2].AskQuantity.ToString());
cell = row.CreateCell(7);
cell.SetCellValue(woobjs[i - 2].BatchNumber);
cell = row.CreateCell(8);
cell.SetCellValue(woobjs[i - 2].AskDate.ToString());
cell = row.CreateCell(9);
cell.SetCellValue(ws.FindUserNameByCode(woobjs[i - 2].UpdatedBy));
cell = row.CreateCell(10);
cell.SetCellValue(woobjs[i - 2].UpdatedDate == null ? woobjs[i - 2].CreatedDate.ToString() : woobjs[i - 2].UpdatedDate.ToString());
}
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "PartsdrawingInfo" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string codename = Request.QueryString["codename"];
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
WsSystem ws = new WsSystem();
IList <BasCode> objods = _bal.FindBasCode("", codename);//.FindFailItems(failcode,failtype);
if (objods == null || objods.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("CodeQuery");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "编码名称,编码类型,前缀字符,日期格式,绑定序列,编码长度,操作人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
for (int i = 1; i < objods.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objods[i - 1].NAME);
cell = row.CreateCell(1);
cell.SetCellValue(objods[i - 1].TYPE);
cell = row.CreateCell(2);
cell.SetCellValue(objods[i - 1].PREFIX);
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].DateFormat);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].BindSequence);
cell = row.CreateCell(5);
cell.SetCellValue(objods[i - 1].CodeLen.ToString());
cell = row.CreateCell(6);
cell.SetCellValue(ws.FindUserNameByCode(objods[i - 1].UpdatedBy));
cell = row.CreateCell(7);
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "CodeQuery" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string sn = Request.QueryString["sn"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
DateTime dtstart = DateTime.Today.AddDays(-7);
DateTime dtend = DateTime.Now;
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
dtstart = Convert.ToDateTime(starttime);
dtend = Convert.ToDateTime(endtime);
}
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
IList <CartonInfo> objods = _bal.FindCartonInfo(sn, "", "", dtstart, dtend);
WsSystem ws = new WsSystem();
if (objods == null || objods.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("CartonInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "箱号,订单号码,零件图号,质量编号,数量,操作人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
for (int i = 1; i < objods.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objods[i - 1].CSN);
cell = row.CreateCell(1);
cell.SetCellValue(objods[i - 1].OrderNumber);
cell = row.CreateCell(2);
cell.SetCellValue(objods[i - 1].PartsdrawingCode);
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].QualityCode);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].QUANTITY.ToString());
cell = row.CreateCell(5);
cell.SetCellValue(ws.FindUserNameByCode(objods[i - 1].UpdatedBy));
cell = row.CreateCell(6);
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "CartonInfo" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string equipcode = Request.QueryString["equipcode"];
string equipname = Request.QueryString["equipname"];
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
WsSystem ws = new WsSystem();
IList <BasEquipment> objods = _bal.FindBasEquipment(equipcode, equipname);//.FindFailItems(failcode,failtype);
if (objods == null || objods.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("EquipmentQuery");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "设备编号,国别厂家,设备名称,机床类型,轴数,型号,功率,车间位置,状态,出厂编号,启用日期,更新人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
for (int i = 1; i < objods.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objods[i - 1].CODE);
cell = row.CreateCell(1);
cell.SetCellValue(objods[i - 1].COMPANY);
cell = row.CreateCell(2);
cell.SetCellValue(objods[i - 1].MachineName);
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].MachineType);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].AxisNumber);
cell = row.CreateCell(5);
cell.SetCellValue(objods[i - 1].MODEL);
cell = row.CreateCell(6);
cell.SetCellValue(objods[i - 1].POWER);
cell = row.CreateCell(7);
cell.SetCellValue(objods[i - 1].LOCATION);
cell = row.CreateCell(8);
cell.SetCellValue(objods[i - 1].STATUS);
cell = row.CreateCell(9);
cell.SetCellValue(objods[i - 1].OutCode);
cell = row.CreateCell(10);
cell.SetCellValue(objods[i - 1].UseDate.ToString());
cell = row.CreateCell(11);
cell.SetCellValue(ws.FindUserNameByCode(objods[i - 1].UpdatedBy));
cell = row.CreateCell(12);
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "EquipmentQuery" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string psn = Request.QueryString["psn"];
string partsdrawing = Request.QueryString["partsdrawing"];
string wo = Request.QueryString["wo"];
string status = Request.QueryString["status"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
WsSystem ws = new WsSystem();
UnsurenessHistory uh = new UnsurenessHistory();
uh.PSN = psn;
uh.WorkOrder = wo;
uh.STATUS = status;
uh.PartsdrawingCode = partsdrawing;
if (!string.IsNullOrEmpty(starttime))
{
uh.CreatedDate = Convert.ToDateTime(starttime);
}
if (!string.IsNullOrEmpty(endtime))
{
uh.UpdatedDate = Convert.ToDateTime(endtime);
}
IList <UnsurenessHistory> objs = _bal.FindUnsurenessHistory(uh);
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("UnsurenessQuery");
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].PSN);
cell = row.CreateCell(1);
cell.SetCellValue(objs[i - 1].WorkOrder);
cell = row.CreateCell(2);
cell.SetCellValue(objs[i - 1].FailMemo);
cell = row.CreateCell(3);
cell.SetCellValue(objs[i - 1].MEMO);
cell = row.CreateCell(4);
cell.SetCellValue(objs[i - 1].StationName);
cell = row.CreateCell(5);
cell.SetCellValue(objs[i - 1].QUANTITY.ToString());
cell = row.CreateCell(6);
cell.SetCellValue(objs[i - 1].MSN);
cell = row.CreateCell(7);
cell.SetCellValue(objs[i - 1].PartsdrawingCode);
cell = row.CreateCell(8);
cell.SetCellValue(objs[i - 1].ProductName);
cell = row.CreateCell(9);
cell.SetCellValue(objs[i - 1].BatchNumber);
cell = row.CreateCell(10);
cell.SetCellValue(ws.FindUserNameByCode(objs[i - 1].UpdatedBy));
cell = row.CreateCell(11);
cell.SetCellValue(objs[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "UnsurenessQuery" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string sn = Request.QueryString["sn"];
string materialname = Request.QueryString["materialname"];
string custname = Request.QueryString["custname"];
string batchnumber = Request.QueryString["batchnumber"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
DateTime dtstart = DateTime.Today.AddDays(-7);
DateTime dtend = DateTime.Now;
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
dtstart = Convert.ToDateTime(starttime);
dtend = Convert.ToDateTime(endtime);
}
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
IList <MaterialStockHistory> objods = _bal.FindMaterialHistory("", "1^3", sn, materialname, custname, starttime, endtime, batchnumber);
WsSystem ws = new WsSystem();
if (objods == null || objods.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("MaterialInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "来料条码,工单号码,物料代码,物料名称,批号,数量,发料仓库,源单单号,发料员,领料员,领料时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
for (int i = 1; i < objods.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objods[i - 1].MSN);
cell = row.CreateCell(1);
cell.SetCellValue(objods[i - 1].WorkOrder);
cell = row.CreateCell(2);
cell.SetCellValue(objods[i - 1].MaterialCode);
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].MaterialName);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].BatchNumber);
cell = row.CreateCell(5);
cell.SetCellValue(objods[i - 1].QUANTITY.ToString());
cell = row.CreateCell(6);
IList <BasBase> ibb = _bal.FindBaseBySubCode(objods[i - 1].StockHouse);
cell.SetCellValue(ibb[0].SubName);
cell = row.CreateCell(7);
cell.SetCellValue(objods[i - 1].DOCUMENTID);
cell = row.CreateCell(8);
cell.SetCellValue(ws.FindUserNameByCode(objods[i - 1].UpdatedBy));
cell = row.CreateCell(9);
cell.SetCellValue(objods[i - 1].MaterialHandler);
cell = row.CreateCell(10);
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "MaterialInfo" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string startTime = Request.QueryString["startTime"];
string endTime = Request.QueryString["endTime"];
string custCode = Request.QueryString["custCode"];
SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
WsSystem ws = new WsSystem();
IList <BasCustom> objods = _bal.FindBasCustom(custCode, "");//.FindBasCode("", codename);//.FindFailItems(failcode,failtype);
if (objods == null || objods.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("CustQuery");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "客户代码,客户名称,地址,运输方式,收货地点,联系人,电话,传真,开票名称,操作人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
for (int i = 1; i < objods.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objods[i - 1].CODE);
cell = row.CreateCell(1);
cell.SetCellValue(objods[i - 1].NAME);
cell = row.CreateCell(2);
cell.SetCellValue(objods[i - 1].ADDRESS);
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].TransType);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].ReceiveArea);
cell = row.CreateCell(5);
cell.SetCellValue(objods[i - 1].CONTACT);
cell = row.CreateCell(6);
cell.SetCellValue(objods[i - 1].MOBILE);
cell = row.CreateCell(7);
cell.SetCellValue(objods[i - 1].FAX);
cell = row.CreateCell(8);
cell.SetCellValue(objods[i - 1].InvoiceName);
cell = row.CreateCell(9);
cell.SetCellValue(ws.FindUserNameByCode(objods[i - 1].UpdatedBy));
cell = row.CreateCell(10);
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "CustQuery" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string startTime = Request.QueryString["startTime"];
string endTime = Request.QueryString["endTime"];
string baseCode = Request.QueryString["baseName"];
BasicBO _bal = BLLFactory.GetBal <BasicBO>(userInfo);
IList <BasBase> baseInfo = _bal.FindBaseByCode(startTime, endTime, baseCode);
WsSystem ws = new WsSystem();
if (baseInfo == null || baseInfo.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("BaseInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "信息编号,信息名称,子信息编码,子信息名称,操作人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
if (baseInfo != null)
{
for (int i = 2; i <= baseInfo.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(baseInfo[i - 2].CODE);
cell = row.CreateCell(1);
cell.SetCellValue(baseInfo[i - 2].NAME);
cell = row.CreateCell(2);
cell.SetCellValue(baseInfo[i - 2].SubCode);
cell = row.CreateCell(3);
cell.SetCellValue(baseInfo[i - 2].SubName);
cell = row.CreateCell(4);
cell.SetCellValue(ws.FindUserNameByCode(baseInfo[i - 2].UpdatedBy));
cell = row.CreateCell(5);
cell.SetCellValue(baseInfo[i - 2].UpdatedDate == null ? baseInfo[i - 2].CreatedDate.ToString() : baseInfo[i - 2].UpdatedDate.ToString());
}
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "BaseInfo" + 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();
}
protected void Page_Load(object sender, EventArgs e)
{
string workorder = Request.QueryString["workorder"];
string status = Request.QueryString["status"];
string productname = Request.QueryString["productname"];
string batchnumber = Request.QueryString["batchnumber"];
string starttime = Request.QueryString["starttime"];
string endtime = Request.QueryString["endtime"];
DateTime dtstart = DateTime.Today.AddDays(-7);
DateTime dtend = DateTime.Now;
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
dtstart = Convert.ToDateTime(starttime);
dtend = Convert.ToDateTime(endtime);
}
WareHouseBO _bal = BLLFactory.GetBal <WareHouseBO>(userInfo);
WsSystem ws = new WsSystem();
IList <ProductStock> objstock = null;
IList <ProductStockHistory> objhistory = null;
if (status == "2")
{
objstock = _bal.FindProductStockInfo(workorder, productname, batchnumber, starttime, endtime);
}
else
{
if (status == "3")
{
status = "";
}
objhistory = _bal.FindProductStockHistory(status, workorder, productname, batchnumber, starttime, endtime);
}
if (objstock == null && objhistory.Count == 0)
{
Response.Write("no data");
return;
}
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
Row row = null;
Cell cell = null;
Sheet hssfSheet = hssfWorkbook.CreateSheet("ProductInfo");
row = hssfSheet.CreateRow(0);
//填充头
string objs = "产品条码,工单号码,交货单位,单据编号,收货仓库,产品代码,产品名称,单位,数量,批号,保管员,移交人,时间";
for (int i = 0; i < objs.Split(',').Length; i++)
{
cell = row.CreateCell(i);
cell.SetCellValue(objs.Split(',')[i]);
}
if (objstock != null)
{
for (int i = 1; i < objstock.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objstock[i - 1].PSN);
cell = row.CreateCell(1);
cell.SetCellValue(objstock[i - 1].WorkOrder);
cell = row.CreateCell(2);
cell.SetCellValue(objstock[i - 1].MANUFACTURE);
cell = row.CreateCell(3);
cell.SetCellValue(objstock[i - 1].DOCUMENTID);
cell = row.CreateCell(4);
cell.SetCellValue(objstock[i - 1].StockHouse);
cell = row.CreateCell(5);
cell.SetCellValue(objstock[i - 1].ProductCode);
cell = row.CreateCell(6);
cell.SetCellValue(objstock[i - 1].ProductName);
cell = row.CreateCell(7);
cell.SetCellValue(objstock[i - 1].UNIT);
cell = row.CreateCell(8);
cell.SetCellValue(objstock[i - 1].QUANTITY.ToString());
cell = row.CreateCell(9);
cell.SetCellValue(objstock[i - 1].BatchNumber);
cell = row.CreateCell(10);
cell.SetCellValue(ws.FindUserNameByCode(objstock[i - 1].UpdatedBy));
cell = row.CreateCell(11);
cell.SetCellValue(ws.FindUserNameByCode(objstock[i - 1].FromBy));
cell = row.CreateCell(12);
cell.SetCellValue(objstock[i - 1].UpdatedDate == null ? objstock[i - 1].CreatedDate.ToString() : objstock[i - 1].UpdatedDate.ToString());
}
}
else
{
for (int i = 1; i < objhistory.Count + 1; i++)
{
row = hssfSheet.CreateRow(i);
cell = row.CreateCell(0);
cell.SetCellValue(objhistory[i - 1].PSN);
cell = row.CreateCell(1);
cell.SetCellValue(objhistory[i - 1].WorkOrder);
cell = row.CreateCell(2);
cell.SetCellValue(objhistory[i - 1].MANUFACTURE);
cell = row.CreateCell(3);
cell.SetCellValue(objhistory[i - 1].DOCUMENTID);
cell = row.CreateCell(4);
cell.SetCellValue(objhistory[i - 1].StockHouse);
cell = row.CreateCell(5);
cell.SetCellValue(objhistory[i - 1].ProductCode);
cell = row.CreateCell(6);
cell.SetCellValue(objhistory[i - 1].ProductName);
cell = row.CreateCell(7);
cell.SetCellValue(objhistory[i - 1].UNIT);
cell = row.CreateCell(8);
cell.SetCellValue(objhistory[i - 1].QUANTITY.ToString());
cell = row.CreateCell(9);
cell.SetCellValue(objhistory[i - 1].BatchNumber);
cell = row.CreateCell(10);
cell.SetCellValue(ws.FindUserNameByCode(objhistory[i - 1].UpdatedBy));
cell = row.CreateCell(11);
cell.SetCellValue(ws.FindUserNameByCode(objhistory[i - 1].FromBy));
cell = row.CreateCell(12);
cell.SetCellValue(objhistory[i - 1].UpdatedDate == null ? objhistory[i - 1].CreatedDate.ToString() : objhistory[i - 1].UpdatedDate.ToString());
}
}
MemoryStream file = new MemoryStream();
hssfWorkbook.Write(file);
String fileName = "ProductInfo" + 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();
}
