Ejemplo n.º 1
0
    public IList <TextValueInfo> GetLabelParams(string labelType, string pid)
    {
        SystemBO _bal = BLLFactory.GetBal <SystemBO>(WebHelper.GetUserInfo());

        //RouteBO _bal = BLLFactory.GetBal<RouteBO>(WebHelper.GetUserInfo());
        return(_bal.ListLabelParams(labelType, pid));
    }
Ejemplo n.º 2
0
    public SPMessage GetLabelParameters(string data, string labelId)
    {
        SystemBO _bal = BLLFactory.GetBal <SystemBO>(WebHelper.GetUserInfo());

        return(_bal.GetLabelParameters(data, labelId));

        //SPMessage ret = new SPMessage();
        //ret.Result = "OK";
        //ret.Message = "VarPsn =lt12312";
        //return ret;
    }
Ejemplo n.º 3
0
    public string GetTplDownloadUrl()
    {
        UserInfo userInfo = WebHelper.GetUserInfo();
        SystemBO _bal     = BLLFactory.GetBal <SystemBO>(WebHelper.GetUserInfo());
        IList <SysMidsvcConfig> svcList = _bal.GetMidsvcList();

        if (svcList.Count() > 0)
        {
            return(svcList[0].MidSvcUrl + "/DownloadPrintTpl.ashx");
        }

        return(ConstantsHelper.GetHelper(userInfo.SiteCode, userInfo.BUCode).GetSystemConfig("LABEL_TPL_DL_URL"));
    }
Ejemplo n.º 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        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 <MaterialStock> objods = _bal.FindStockInfo("0^2", 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].MaterialCode);
            cell = row.CreateCell(2);
            cell.SetCellValue(objods[i - 1].MaterialName);
            cell = row.CreateCell(3);
            cell.SetCellValue(objods[i - 1].BatchNumber);
            cell = row.CreateCell(4);
            cell.SetCellValue(objods[i - 1].BasQty.ToString());
            cell = row.CreateCell(5);
            cell.SetCellValue(objods[i - 1].DOCUMENTID);
            cell = row.CreateCell(6);
            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();
    }
Ejemplo n.º 5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string month = Request.QueryString["month"];
        int    iYear = DateTime.Now.Year;

        if (string.IsNullOrEmpty(month) || month == "0")
        {
            month = DateTime.Now.Month.ToString();
            if (month.Length == 1)
            {
                month = "0" + month;
            }
        }
        month = iYear + "-" + month;
        SystemBO          _bal = BLLFactory.GetBal <SystemBO>(userInfo);
        IList <BasCustom> cus  = _bal.FindCustName();

        if (cus == null || cus.Count == 0)
        {
            Response.Write("no data");
            return;
        }


        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        Row          row          = null;
        Cell         cell         = null;
        Sheet        hssfSheet    = hssfWorkbook.CreateSheet("CustPassRate");

        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 < cus.Count + 1; i++)
        {
            int[]  allRate      = _bal.FindCustQty(month, cus[i - 1].NAME);
            int    QUANTITY     = (allRate[0] + allRate[1]);
            int    PassCount    = allRate[0];
            int    FailCount    = allRate[1];
            int    ReturnCount  = allRate[2];
            int    SecondPass   = allRate[3];
            int    DiscardCount = allRate[4];
            double PassRate     = QUANTITY == 0 ? 0 : (Math.Round((double)(PassCount * 100 / QUANTITY), 2));
            double FailRate     = QUANTITY == 0 ? 0 : (Math.Round(100 - (double)(PassCount * 100 / QUANTITY), 2));
            double ReturnRate   = QUANTITY == 0 ? 0 : (Math.Round((double)(ReturnCount * 100 / QUANTITY), 2));
            double SecPassRate  = QUANTITY == 0 ? 0 : (Math.Round((double)(SecondPass * 100 / QUANTITY), 2));
            double DiscardRate  = QUANTITY == 0 ? 0 : (Math.Round((double)(DiscardCount * 100 / QUANTITY), 2));
            row  = hssfSheet.CreateRow(i);
            cell = row.CreateCell(0);
            cell.SetCellValue(cus[i - 1].NAME);
            cell = row.CreateCell(1);
            cell.SetCellValue(QUANTITY);
            cell = row.CreateCell(2);
            cell.SetCellValue(PassCount);
            cell = row.CreateCell(3);
            cell.SetCellValue(FailCount);
            cell = row.CreateCell(4);
            cell.SetCellValue(ReturnCount);
            cell = row.CreateCell(5);
            cell.SetCellValue(SecondPass);
            cell = row.CreateCell(6);
            cell.SetCellValue(DiscardCount);
            cell = row.CreateCell(7);
            cell.SetCellValue(PassRate + "%");
            cell = row.CreateCell(8);
            cell.SetCellValue(FailRate + "%");
            cell = row.CreateCell(9);
            cell.SetCellValue(ReturnRate + "%");
            cell = row.CreateCell(10);
            cell.SetCellValue(SecPassRate + "%");
            cell = row.CreateCell(11);
            cell.SetCellValue(DiscardRate + "%");
        }
        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "CustPassRate" + 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();
    }
Ejemplo n.º 6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string   workorder      = Request.QueryString["workorder"];
        string   station        = Request.QueryString["station"];
        string   partsdrawingno = Request.QueryString["partsdrawingno"];
        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);
        }

        SystemBO            _bal   = BLLFactory.GetBal <SystemBO>(userInfo);
        IList <TrackingWip> woobjs = _bal.FindSNTrackingWIP(workorder, partsdrawingno, station, dtstart, dtend);
        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("SNTrackingWIPInfo");

        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].PSN);
                cell = row.CreateCell(1);
                cell.SetCellValue(woobjs[i - 2].MSN);
                cell = row.CreateCell(2);
                cell.SetCellValue(woobjs[i - 2].WorkOrder);
                cell = row.CreateCell(3);
                cell.SetCellValue(woobjs[i - 2].PartsdrawingCode);
                cell = row.CreateCell(4);
                cell.SetCellValue(woobjs[i - 2].BatchNumber);
                cell = row.CreateCell(5);
                cell.SetCellValue(woobjs[i - 2].StationName);
                cell = row.CreateCell(6);
                cell.SetCellValue(woobjs[i - 2].STATUS);
                cell = row.CreateCell(7);
                cell.SetCellValue(woobjs[i - 2].TaskTime);
                cell = row.CreateCell(8);
                cell.SetCellValue(woobjs[i - 2].NextStation);
                cell = row.CreateCell(9);
                cell.SetCellValue(woobjs[i - 2].CreatedDate.ToString());
                cell = row.CreateCell(10);
                cell.SetCellValue(woobjs[i - 2].UpdatedBy);
            }
        }

        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "SNTrackingWIPInfo" + 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();
    }
Ejemplo n.º 7
0
    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();
    }
Ejemplo n.º 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string month = Request.QueryString["month"];
        int    iYear = DateTime.Now.Year;

        if (string.IsNullOrEmpty(month) || month == "0")
        {
            month = DateTime.Now.Month.ToString();
            if (month.Length == 1)
            {
                month = "0" + month;
            }
        }
        month = iYear + "-" + month;
        SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
        IList <RealtimeStatistics> machines = _bal.findMachineCode();
        List <YieldInfo>           bs       = new List <YieldInfo>();

        for (int i = 0; i < machines.Count; i++)
        {
            YieldInfo bbtemp = new YieldInfo();
            bbtemp.WO = machines[i].MachineName;


            int[] fails = _bal.FindMachineYield(machines[i].MachineName, month);
            bbtemp.QUANTITY     = (fails[0] + fails[1]);
            bbtemp.PassCount    = fails[0];
            bbtemp.FailCount    = fails[1];
            bbtemp.ReturnCount  = fails[2];
            bbtemp.SecondPass   = fails[3];
            bbtemp.DiscardCount = fails[4];
            bbtemp.PassRate     = (Math.Round((double)(bbtemp.PassCount * 100 / bbtemp.QUANTITY), 2)).ToString() + "%";
            bbtemp.FailRate     = (Math.Round(100 - (double)(bbtemp.PassCount * 100 / bbtemp.QUANTITY), 2)).ToString() + "%";
            bbtemp.ReturnRate   = (Math.Round((double)(bbtemp.ReturnCount * 100 / bbtemp.QUANTITY), 2)).ToString() + "%";
            bbtemp.SecPassRate  = (Math.Round((double)(bbtemp.SecondPass * 100 / bbtemp.QUANTITY), 2)).ToString() + "%";
            bbtemp.DiscardRate  = (Math.Round((double)(bbtemp.DiscardCount * 100 / bbtemp.QUANTITY), 2)).ToString() + "%";
            bs.Add(bbtemp);
        }


        if (bs == null || bs.Count == 0)
        {
            Response.Write("no data");
            return;
        }

        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        Row          row          = null;
        Cell         cell         = null;
        Sheet        hssfSheet    = hssfWorkbook.CreateSheet("PassRateQuery");

        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 j = 0; j < bs.Count; j++)
        {
            row  = hssfSheet.CreateRow(j + 1);
            cell = row.CreateCell(0);
            cell.SetCellValue(bs[j].WO);
            cell = row.CreateCell(1);
            cell.SetCellValue(bs[j].QUANTITY);
            cell = row.CreateCell(2);
            cell.SetCellValue(bs[j].PassCount);
            cell = row.CreateCell(3);
            cell.SetCellValue(bs[j].FailCount);
            cell = row.CreateCell(4);
            cell.SetCellValue(bs[j].ReturnCount);
            cell = row.CreateCell(5);
            cell.SetCellValue(bs[j].SecondPass);
            cell = row.CreateCell(6);
            cell.SetCellValue(bs[j].DiscardCount);
            cell = row.CreateCell(7);
            cell.SetCellValue(bs[j].PassRate);
            cell = row.CreateCell(8);
            cell.SetCellValue(bs[j].FailRate);
            cell = row.CreateCell(9);
            cell.SetCellValue(bs[j].ReturnRate);
            cell = row.CreateCell(10);
            cell.SetCellValue(bs[j].SecPassRate);
            cell = row.CreateCell(11);
            cell.SetCellValue(bs[j].DiscardRate);
        }

        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "PassRateQuery" + 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();
    }
Ejemplo n.º 9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string   sn   = Request.QueryString["sn"];
        SystemBO _bal = BLLFactory.GetBal <SystemBO>(userInfo);
        IList <TrackingHistory> objods = _bal.FindSNTrackingInfo(sn);

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

        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 = 2; i <= objods.Count + 1; i++)
        {
            row  = hssfSheet.CreateRow(i);
            cell = row.CreateCell(0);
            cell.SetCellValue(objods[i - 2].PSN);
            cell = row.CreateCell(1);
            cell.SetCellValue(objods[i - 2].MSN);
            cell = row.CreateCell(2);
            cell.SetCellValue(objods[i - 2].WorkOrder);
            cell = row.CreateCell(3);
            cell.SetCellValue(objods[i - 2].PartsdrawingCode);
            cell = row.CreateCell(4);
            cell.SetCellValue(objods[i - 2].StationName);
            cell = row.CreateCell(5);
            cell.SetCellValue(objods[i - 2].MachineName);
            cell = row.CreateCell(6);
            cell.SetCellValue(objods[i - 2].UpdatedBy);
            cell = row.CreateCell(7);
            cell.SetCellValue(objods[i - 2].PartsName);
            cell = row.CreateCell(8);
            cell.SetCellValue(objods[i - 2].CreatedDate.ToString());
            cell = row.CreateCell(9);
            cell.SetCellValue(objods[i - 2].BatchNumber);
            cell = row.CreateCell(10);
            cell.SetCellValue(objods[i - 2].QUANTITY.ToString());
            cell = row.CreateCell(11);
            cell.SetCellValue(objods[i - 2].UpdatedBy);
        }
        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "SNTrackingInfo" + 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();
    }
Ejemplo n.º 10
0
    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();
    }
Ejemplo n.º 11
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();
    }
Ejemplo n.º 12
0
    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();
    }
Ejemplo n.º 13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string partsdrawingno = Request.QueryString["partcode"];
        //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);
        WsSystem ws   = new WsSystem();
        //IList<PartsdrawingCode> woobjs = _bal.FindPartsdrawingInfo(partsdrawingno, custcode, starttime, endtime);
        IList <TechnologyWip> baseInfo = _bal.FindTechnologyTask(partsdrawingno);

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

        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].PARTSDRAWINGNO);
                cell = row.CreateCell(1);
                cell.SetCellValue(baseInfo[i - 2].CustName);
                cell = row.CreateCell(2);
                cell.SetCellValue(baseInfo[i - 2].ProductName);
                cell = row.CreateCell(3);
                cell.SetCellValue(baseInfo[i - 2].StatusMemo);
            }
        }

        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "TechnologyTaskInfo" + 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();
    }
Ejemplo n.º 14
0
    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();
    }
Ejemplo n.º 15
0
    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("YieldQuery");

        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].ProductName);
            cell = row.CreateCell(3);
            cell.SetCellValue(objs[i - 1].BatchNumber);
            cell = row.CreateCell(4);
            cell.SetCellValue((objs[i - 1].QUANTITY == null ? 0 : objs[i - 1].QUANTITY).ToString());
            int[]  fails       = _bal.FindYieldCountInfo("", objs[i - 1].PartsdrawingCode);
            int    passcount   = (int)(objs[i - 1].QUANTITY == null ? 0 : objs[i - 1].QUANTITY) - fails[0];
            string passrate    = (Math.Round((double)(passcount * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            string failrate    = (Math.Round((double)(fails[0] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            string returnrate  = (Math.Round((double)(fails[1] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            string secpassrate = (Math.Round((double)(fails[2] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            string dicardrate  = (Math.Round((double)(fails[3] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            cell = row.CreateCell(5);
            cell.SetCellValue(passcount.ToString());
            cell = row.CreateCell(6);
            cell.SetCellValue(fails[0].ToString());
            cell = row.CreateCell(7);
            cell.SetCellValue(fails[1].ToString());
            cell = row.CreateCell(8);
            cell.SetCellValue(fails[2].ToString());
            cell = row.CreateCell(9);
            cell.SetCellValue(fails[3].ToString());
            cell = row.CreateCell(10);
            cell.SetCellValue(passrate);
            cell = row.CreateCell(11);
            cell.SetCellValue(failrate);
            cell = row.CreateCell(12);
            cell.SetCellValue(returnrate);
            cell = row.CreateCell(13);
            cell.SetCellValue(secpassrate);
            cell = row.CreateCell(14);
            cell.SetCellValue(dicardrate);
        }
        MemoryStream file = new MemoryStream();

        hssfWorkbook.Write(file);
        String fileName = "YieldQuery" + 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();
    }
Ejemplo n.º 16
0
    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();
    }
Ejemplo n.º 17
0
    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();
    }
Ejemplo n.º 18
0
    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();
    }
Ejemplo n.º 19
0
    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();
    }
Ejemplo n.º 20
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();
    }
Ejemplo n.º 21
0
    public SPMessage GetLabelParameters(string data, string labelId)
    {
        SystemBO _bal = BLLFactory.GetBal <SystemBO>(WebHelper.GetUserInfo());

        return(_bal.GetLabelParameters(data, labelId));
    }
Ejemplo n.º 22
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string workorder    = Request.QueryString["workorder"];
        string partsdrawing = Request.QueryString["partsdrawing"];
        string starttime    = Request.QueryString["starttime"];
        string endtime      = Request.QueryString["endtime"];

        if (workorder == "undefined")
        {
            workorder = "";
        }
        if (partsdrawing == "undefined")
        {
            partsdrawing = "";
        }
        if (starttime == "undefined")
        {
            starttime = "";
        }
        if (endtime == "undefined")
        {
            endtime = "";
        }
        SystemBO  _bal = BLLFactory.GetBal <SystemBO>(userInfo);
        WorkOrder wo   = new WorkOrder();

        wo.WO = workorder;
        wo.PartsdrawingCode = partsdrawing;
        if (!string.IsNullOrEmpty(starttime) && starttime != "undefined")
        {
            wo.StartTime = Convert.ToDateTime(starttime);
        }

        if (!string.IsNullOrEmpty(endtime) && starttime != "undefined")
        {
            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("ProductMarQuery");

        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].OrderNumber);
            cell = row.CreateCell(1);
            cell.SetCellValue(objs[i - 1].WO);
            cell = row.CreateCell(2);
            cell.SetCellValue(objs[i - 1].PartsdrawingCode);
            cell = row.CreateCell(3);
            cell.SetCellValue(objs[i - 1].ProductName);
            cell = row.CreateCell(4);
            cell.SetCellValue(objs[i - 1].WorkerName);
            cell = row.CreateCell(5);
            cell.SetCellValue(objs[i - 1].MachineName);
            cell = row.CreateCell(6);
            cell.SetCellValue(objs[i - 1].PlanQuantity.ToString());
            cell = row.CreateCell(7);
            cell.SetCellValue(objs[i - 1].QUANTITY.ToString());
            cell = row.CreateCell(8);

            int[] fails     = _bal.FindYieldCountInfo("", objs[i - 1].PartsdrawingCode);
            int   passcount = (int)(objs[i - 1].QUANTITY == null ? 0 : objs[i - 1].QUANTITY) - fails[0];
            //string passrate = (Math.Round((double)(passcount * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            //string failrate = (Math.Round((double)(fails[0] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            //string returnrate = (Math.Round((double)(fails[1] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            //string secpassrate = (Math.Round((double)(fails[2] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            //string dicardrate = (Math.Round((double)(fails[3] * 100 / (objs[i - 1].QUANTITY == null ? 1 : objs[i - 1].QUANTITY)), 2)).ToString() + "%";
            cell.SetCellValue(passcount.ToString());

            cell = row.CreateCell(9);
            cell.SetCellValue(fails[3].ToString());
            cell = row.CreateCell(10);
            cell.SetCellValue(objs[i - 1].UnitTime.ToString());
            cell = row.CreateCell(11);
            cell.SetCellValue((objs[i - 1].QUANTITY * objs[i - 1].UnitTime).ToString());
            cell = row.CreateCell(12);
            cell.SetCellValue(_bal.FindActualTotalUnitTime(objs[i - 1].WO, objs[i - 1].PartsdrawingCode));
        }
        MemoryStream file = new MemoryStream();

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