コード例 #1
0
ファイル: w_Export.cs プロジェクト: samualtang/DZunshape
        //多条打码机的数据可以写到一个文件上发送过去,不过每次发送的明细不能超过一万条
        private void export(string synseq, string groupno, string linetype)//lineno打码机编号
        {
            this.btn_export.Enabled = false;
            panel2.Visible          = true;
            label2.Visible          = true;
            progressBar1.Visible    = true;
            label2.Text             = "数据查询中,准备进行数据导出...";
            label2.Refresh();
            int    taskseq = 0, seq = 1;
            String tasknum = "", cuscode = "", cusname = "", itemno = "", itemname = "", quantity = "", regioncode = "", orderdate = "", cuscodetmp = "";

            List <InfoExport> list = new List <InfoExport>();

            list = ExportClass.Export(Convert.ToDecimal(synseq));

            //取批次号
            //String batchcodesql = "select SEQ_ONEHAOGONGCHENG.Nextval from dual";

            int len = list.Count;


            String onesynseq = "0";//一号工程批次号


            //DataTable table = Db.Query(sql);
            //int len = table.Rows.Count;
            //String[] infostr = new String[len];

            if (len > 0)
            {
                InitSocket();
                //DataRow row = new DataRow();
                //创建到处目录
                String folder = "HighSpeedExportData";
                if (!Directory.Exists("D:\\" + folder))
                {
                    Directory.CreateDirectory("D:\\" + folder);
                }
                int    count = 0, fileSeq = 1, rowCcount = 0, bz = 0, succCount = 0;
                String fileNameStr = ""; String info = "", tmpInfo = "", tempCode = "", unSuccFile = "";
                for (int i = 0; i < len; i++)
                {
                    progressBar1.Value = ((i + 1) * 100 / len);
                    progressBar1.Refresh();

                    InfoExport infos = new InfoExport();
                    infos = list[i];

                    tasknum    = infos.SortNum.ToString();
                    cuscode    = infos.CustomerCode.ToString();
                    cusname    = infos.CustomerName.ToString();
                    itemno     = infos.CigaretteCode.ToString();
                    itemname   = infos.CigaretteName.ToString();
                    quantity   = infos.PokeNum.ToString();
                    regioncode = infos.RegionCode.ToString();
                    orderdate  = infos.Orderdate.ToString();
                    //lineno = row["SORTNAME"].ToString();
                    taskseq++;
                    rowCcount = rowCcount + 1;

                    label2.Text = "正在导出第" + fileSeq + "个文件...";
                    label2.Refresh();
                    //取下条记录比较车组与零售户
                    if (i + 1 < len)
                    {
                        cuscodetmp = list[i + 1].CustomerCode.ToString();
                        tempCode   = list[i + 1].RegionCode.ToString();
                    }
                    else
                    {
                        cuscodetmp = "";
                        tempCode   = "";
                    }
                    //infostr[i] = tasknum + taskseq + "," + tasknum + "," + cuscode + "," + cusname + "," + itemno + "," + itemname + "," + quantity + ",2," + seq + "," + regioncode + "," + regioncode + "," + orderdate + "," + orderdate + ",S1001,1";
                    tmpInfo = tmpInfo + tasknum + "," + tasknum + "," + cuscode + "," + cusname + "," + itemno + "," + itemname + "," + quantity + "," + onesynseq + "," + seq + "," + regioncode + "," + regioncode + "," + orderdate + "," + orderdate + ",1;\r\n";

                    if (cuscode != cuscodetmp)
                    {
                        taskseq = 0;
                        seq++;
                    }
                    //当下个车组与当前不同时
                    if (!tempCode.Equals(regioncode))
                    {
                        //判断累计记录数是否大于10000,大于则将之前的记录数导出,否则将记录数合并
                        if (rowCcount + count > 1000000000)
                        {
                            label2.Text = "正在压缩第" + fileSeq + "个文件...";
                            label2.Refresh();
                            //将之前的记录信息导出
                            DateTime dt       = DateTime.Now;
                            String   time     = string.Format("{0:yyyyMMddHHmmssfff}", dt);
                            String   filename = "RetailerOrder-" + time + "-" + synseq + "-" + fileSeq;
                            fileNameStr = fileNameStr + "," + filename + ".zip";
                            StreamWriter sw = new StreamWriter("D:\\HighSpeedExportData\\" + filename + ".Order", false, Encoding.UTF8);
                            sw.WriteLine(info.Substring(0, info.Length - 1));
                            sw.Close();//写入
                            //CompressFile("D:\\" + filename + ".Order");
                            GetFileToZip("D:\\HighSpeedExportData\\" + filename + ".Order", "D:\\HighSpeedExportData\\" + filename + ".zip", filename + ".Order");
                            //发送数据
                            label2.Text = "正在发送第" + fileSeq + "个文件";
                            label2.Refresh();
                            bz = sendFile("D:\\HighSpeedExportData\\" + filename + ".zip");
                            //记录发送成功数量和失败文件信息
                            if (bz == 0)
                            {
                                succCount   = succCount + 1;
                                label2.Text = "第" + fileSeq + "个文件发送完毕!";
                            }
                            else
                            {
                                unSuccFile  = unSuccFile + "," + filename + ".zip";
                                label2.Text = "第" + fileSeq + "个文件发送失败!";
                            }

                            label2.Refresh();
                            //记录新车组的信息
                            fileSeq = fileSeq + 1;
                            count   = rowCcount;
                            info    = tmpInfo;
                        }
                        else
                        {
                            count = rowCcount + count;
                            info  = info + tmpInfo;
                        }

                        //判断循环是否完成(是否为最后一条记录),如果是最后一条,则将剩余记录导出
                        if ("".Equals(tempCode))
                        {
                            //fileSeq = fileSeq + 1;
                            label2.Text = "正在压缩第" + fileSeq + "个文件";
                            label2.Refresh();
                            DateTime dt       = DateTime.Now;
                            String   time     = string.Format("{0:yyyyMMddHHmmssfff}", dt);
                            String   filename = "RetailerOrder-" + time + "-" + synseq + "-" + fileSeq;
                            fileNameStr = fileNameStr + "," + filename + ".zip";
                            StreamWriter sw = new StreamWriter("D:\\HighSpeedExportData\\" + filename + ".Order", false, Encoding.UTF8);
                            sw.WriteLine(info.Substring(0, info.Length - 1));
                            sw.Close();//写入
                            //CompressFile("D:\\" + filename + ".Order");
                            GetFileToZip("D:\\HighSpeedExportData\\" + filename + ".Order", "D:\\HighSpeedExportData\\" + filename + ".zip", filename + ".Order");
                            //发送数据
                            //sendFile("D:\\HighSpeedExportData\\" + filename + ".zip");
                            label2.Text = "正在发送第" + fileSeq + "个文件";
                            label2.Refresh();
                            bz = sendFile("D:\\HighSpeedExportData\\" + filename + ".zip");
                            //记录发送成功数量和失败文件信息
                            if (bz == 0)
                            {
                                succCount   = succCount + 1;
                                label2.Text = "第" + fileSeq + "个文件发送完毕!";
                            }
                            else
                            {
                                unSuccFile  = unSuccFile + "," + filename + ".zip";
                                label2.Text = "第" + fileSeq + "个文件发送失败!";
                            }

                            label2.Refresh();
                        }
                        tmpInfo   = "";
                        rowCcount = 0;
                    }
                }
                //在弹窗前关闭控件
                panel2.Visible       = false;
                label2.Visible       = false;
                progressBar1.Visible = false;

                String msg = "成功导出" + fileSeq + "个文件,成功发送" + succCount + "个文件!";
                //导出的文件的所有文件名
                if (!"".Equals(fileNameStr))
                {
                    fileNameStr = fileNameStr.Substring(1);
                }
                //发送失败的所有文件名
                if (!"".Equals(unSuccFile))
                {
                    unSuccFile = unSuccFile.Substring(1);
                    msg        = msg + "其中发送失败文件为(" + unSuccFile + ")!";
                }
                else
                {
                    msg = msg + "文件名为(" + fileNameStr + ")!";
                }

                MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                socketClient.Disconnect(false);
                socketClient.Close();
            }
            this.btn_export.Enabled = true;
        }
コード例 #2
0
        async private void Button_Click(object sender, RoutedEventArgs e)
        {
            progressBar.Visibility = Visibility.Visible;
            exportBtn.IsEnabled    = false;
            //DbAccess da = new DbAccess();
            await da.InitCon();

            dt = await da.ExecuteQuery();


            // var masterDatas = new List<MasterData>();
            await Task.Factory.StartNew(() =>
            {
                // var masterDatas = new List<MasterData>();
                mainMasterData = ts.GetDataTables(dt);


                var result = mainMasterData.SelectMany(m => m.ReferenceRanges, (MasterData, ReferenceRange) => new { MasterData, ReferenceRange }).ToList();
                foreach (var item in result)
                {
                    FullData f = new FullData()
                    {
                        PanelId        = item.MasterData.PanelId,
                        PanelName      = item.MasterData.PanelName,
                        TestId         = item.MasterData.TestId,
                        TestName       = item.MasterData.TestName,
                        LabsectionId   = item.MasterData.LabsectionId,
                        Labsection     = item.MasterData.Labsection,
                        Units          = item.MasterData.Units,
                        TubeId         = item.MasterData.TubeId,
                        TubeName       = item.MasterData.TubeName,
                        SampleTypeId   = item.MasterData.SampleTypeId,
                        SampleTypeName = item.MasterData.SampleTypeName,
                        RefRangeType   = item.ReferenceRange.RefRangeType,
                        Sex            = item.ReferenceRange.Sex,
                        SpecialPeriod  = item.ReferenceRange.SpecialPeriod,
                        TimeScale      = item.ReferenceRange.TimeScale,
                        From           = item.ReferenceRange.From,
                        To             = item.ReferenceRange.To,
                        DiscardLow     = item.ReferenceRange.DiscardLow,
                        PanicLow       = item.ReferenceRange.PanicLow,
                        RefRange       = item.ReferenceRange.RefRange,
                        PanicHigh      = item.ReferenceRange.PanicHigh,
                        DiscardHigh    = item.ReferenceRange.DiscardHigh
                    };


                    fD.Add(f);
                }
            });

            progressBar.Visibility = Visibility.Collapsed;
            using (SaveFileDialog sf = new SaveFileDialog
            {
                Filter = "Excel File|*.xlsx",
                Title = "Save an Excel File"
            })
            {
                sf.ShowDialog();
                var name = sf.FileName;


                if (name != "")
                {
                    FileInfo    f  = new FileInfo(name);
                    ExportClass ex = new ExportClass(fD, f);
                    progressBar.Visibility = Visibility.Visible;
                    await ex.Export();

                    progressBar.Visibility = Visibility.Collapsed;
                    exportBtn.IsEnabled    = true;
                    System.Windows.MessageBox.Show("File created!");
                }
            }
        }