Example #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string              orderno       = Request.QueryString["orderno"];
        string              partdrawingno = Request.QueryString["partdrawingno"];
        SystemBO            _bal          = BLLFactory.GetBal <SystemBO>(userInfo);
        IList <OrderDetail> objods        = _bal.FindOrderInfo(orderno, partdrawingno);

        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("OrderStatusInfo");

        row = hssfSheet.CreateRow(0);
        //填充头
        string objs = "订单单号,零件图号,订单状态,客户名称,产品名称,订单数量,备注,交付时间,创建人,时间";

        for (int i = 0; i < objs.Split(',').Length; i++)
        {
            cell = row.CreateCell(i);
            cell.SetCellValue(objs.Split(',')[i]);
        }
        string strstatus = string.Empty;

        for (int i = 2; i <= objods.Count + 1; i++)
        {
            row  = hssfSheet.CreateRow(i);
            cell = row.CreateCell(0);
            cell.SetCellValue(objods[i - 2].OrderNo);
            cell = row.CreateCell(1);
            cell.SetCellValue(objods[i - 2].PartsdrawingCode);
            cell = row.CreateCell(2);
            switch (objods[i - 2].STATUS)
            {
            case "0":
                strstatus = "创建";
                break;

            case "1":
                strstatus = "发布";
                break;

            case "2":
                strstatus = "发货通知";
                break;

            case "3":
                strstatus = "关闭";
                break;

            default:
                strstatus = "状态异常";
                break;
            }
            cell.SetCellValue(strstatus);
            cell = row.CreateCell(3);
            cell.SetCellValue(objods[i - 2].CustName);
            cell = row.CreateCell(4);
            cell.SetCellValue(objods[i - 2].ProductName);
            cell = row.CreateCell(5);
            cell.SetCellValue(objods[i - 2].OrderQuantity.ToString());
            cell = row.CreateCell(6);
            cell.SetCellValue(objods[i - 2].BatchNumber);
            cell = row.CreateCell(7);
            cell.SetCellValue(objods[i - 2].OutDate.ToString());
            cell = row.CreateCell(8);
            cell.SetCellValue(objods[i - 2].UpdatedBy);
            cell = row.CreateCell(9);
            cell.SetCellValue(objods[i - 2].UpdatedDate.ToString());
        }
        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "OrderStatusInfo" + 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 partsdrawingno = Request.QueryString["partcode"];
        string order          = Request.QueryString["orderno"];
        //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);
        //}
        //WorkOrder wo = new WorkOrder();
        //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 <OrderDetail> objs = _bal.FindOrderInfo(order, partsdrawingno, "1");
        //IList<WorkOrder> woobjs = _bal.FindWorkOrderInfo(wo);
        WsSystem ws = new WsSystem();

        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("OrderInfo");

        row = hssfSheet.CreateRow(0);
        //填充头
        string strobjs = "订单单号,零件图号,状态,客户名称,投产总数,产品名称,交付时间";

        for (int i = 0; i < strobjs.Split(',').Length; i++)
        {
            cell = row.CreateCell(i);
            cell.SetCellValue(strobjs.Split(',')[i]);
        }
        if (objs != null)
        {
            for (int i = 2; i <= objs.Count + 1; i++)
            {
                row  = hssfSheet.CreateRow(i);
                cell = row.CreateCell(0);
                cell.SetCellValue(objs[i - 2].OrderNo);
                cell = row.CreateCell(1);
                cell.SetCellValue(objs[i - 2].PartsdrawingCode);
                cell = row.CreateCell(2);
                cell.SetCellValue(objs[i - 2].MEMO);
                cell = row.CreateCell(3);
                cell.SetCellValue(objs[i - 2].CustName);
                cell = row.CreateCell(4);
                cell.SetCellValue(objs[i - 2].OrderQuantity.ToString());
                cell = row.CreateCell(5);
                cell.SetCellValue(objs[i - 2].ProductName);
                cell = row.CreateCell(6);
                cell.SetCellValue(objs[i - 2].OutDate.ToString());
            }
        }

        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "OrderInfo" + 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();
    }