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("", "0", sn, materialname, custname, starttime, endtime, batchnumber);
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].CustName);
cell = row.CreateCell(2);
if (objods[i - 1].CreatedDate != null)
{
cell.SetCellValue(objods[i - 1].CreatedDate.ToString());
}
else
{
cell.SetCellValue("");
}
cell = row.CreateCell(3);
cell.SetCellValue(objods[i - 1].StockHouse);
cell = row.CreateCell(4);
cell.SetCellValue(objods[i - 1].DOCUMENTID);
cell = row.CreateCell(5);
cell.SetCellValue(objods[i - 1].MaterialCode);
cell = row.CreateCell(6);
cell.SetCellValue(objods[i - 1].MaterialName);
cell = row.CreateCell(7);
cell.SetCellValue(objods[i - 1].BatchNumber);
cell = row.CreateCell(8);
IList <BasBase> ibb = _bal.FindBaseBySubCode(objods[i - 1].UNIT);
if (ibb != null && ibb.Count > 0)
{
cell.SetCellValue(ibb[0].SubName);
}
else
{
cell.SetCellValue(objods[i - 1].UNIT);
}
cell = row.CreateCell(9);
if (objods[i - 1].QUANTITY != null)
{
cell.SetCellValue(objods[i - 1].QUANTITY.ToString());
}
else
{
cell.SetCellValue("");
}
cell = row.CreateCell(10);
SysUser user = _bal.FindUserByCode(objods[i - 1].UpdatedBy);
if (user != null && !string.IsNullOrEmpty(user.UserCode))
{
cell.SetCellValue(user.UserName);
}
else
{
cell.SetCellValue(objods[i - 1].UpdatedBy);
}
cell = row.CreateCell(11);
cell.SetCellValue(objods[i - 1].MEMO);
}
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();
}