Esempio n. 1
0
    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();
    }