Beispiel #1
0
        /// <summary>
        /// 导数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            this.button1.Enabled = false;

            int beginYear = this.dateTimePicker1.Value.Year;
            int type      = (this.comboBox1.SelectedItem as ComboxItem).Valud;

            List <ReceiveData> receiveList = null;
            List <SendData>    sendList    = null;
            int count = 0;

            this.label4.Text = string.Format("开始:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            Application.DoEvents();
            var handle = new OaInfoHandle();

            switch (type)
            {
            case 2:
                sendList = new List <SendData>();

                var sends = handle.GetSends(beginYear);
                count = sends.Count;

                sendList.AddRange(handle.GetSends(sends));
                break;

            default:
                receiveList = new List <ReceiveData>();

                var receives = handle.GetReceiveses(beginYear, type);
                count = receives.Count;

                receiveList.AddRange(handle.GetReceiveses(receives));
                break;
            }

            this.label3.Text = string.Format("共{0}条数据。", count);
            Application.DoEvents();

            handle.ExcelImport(beginYear, type, sendList, receiveList);
            this.label5.Text     = string.Format("完成:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            this.button1.Enabled = true;
        }
Beispiel #2
0
        /// <summary>
        /// 导附件+数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            this.button2.Enabled = false;

            int beginYear = this.dateTimePicker1.Value.Year;
            int type      = (this.comboBox1.SelectedItem as ComboxItem).Valud;

            this.progressBar1.Minimum   = 0;
            this.progressBar1.BackColor = Color.Green;

            List <AnnexItem>   list        = new List <AnnexItem>();
            List <ReceiveData> receiveList = null;
            List <SendData>    sendList    = null;
            List <int>         idList      = new List <int>();
            int count      = 0;
            int annexCount = 0;

            this.label4.Text = string.Format("开始:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            Application.DoEvents();

            var handle = new OaInfoHandle();

            switch (type)
            {
            case 2:
                sendList = new List <SendData>();
                var sends = handle.GetSends(beginYear);
                count = sends.Count;

                list.AddRange(sends.Select(p => new AnnexItem()
                {
                    Index        = string.Format("{0:D8}", p.ID),
                    ID           = p.ID,
                    Title        = p.Title,
                    SerialNumber = p.SerialNumber,
                    FolderName   = string.Format("{0}年发文附件", p.SerialNumber.Substring(p.SerialNumber.IndexOf("[") + 1, 4))
                }));

                sendList.AddRange(handle.GetSends(sends));

                break;

            default:
                receiveList = new List <ReceiveData>();

                var receives = handle.GetReceiveses(beginYear, type);
                count = receives.Count;

                list.AddRange(receives.Select(p => new AnnexItem()
                {
                    Index        = string.Format("{0:D8}", p.ID),
                    ID           = p.ID,
                    Title        = p.Title,
                    SerialNumber = p.SerialNumber,
                    FolderName   = string.Format("{0}年{1}附件", p.GetDate.HasValue ? p.GetDate.Value.Year : 0, type == 1 ? "收文" : "信访")
                }));


                receiveList.AddRange(handle.GetReceiveses(receives));
                break;
            }
            this.label3.Text          = string.Format("数据{0}条 / ", count);
            this.progressBar1.Maximum = count;


            foreach (var r in list)
            {
                string ret = handle.GetAnnex(r);
                if (ret == "none")
                {
                    this.richTextBox1.Text += string.Format("{0}5  {1}({2} {3})  没有附件。", Environment.NewLine, r.ID, r.SerialNumber, r.Title);
                    Application.DoEvents();

                    if (receiveList != null)
                    {
                        receiveList.Remove(receiveList.Find(p => p.Receive.ID == r.ID));
                    }
                    if (sendList != null)
                    {
                        sendList.Remove(sendList.Find(p => p.Send.ID == r.ID));
                    }
                }
                else if (!string.IsNullOrEmpty(ret))
                {
                    this.richTextBox1.Text += string.Format("{0}{1}", Environment.NewLine, ret);
                    Application.DoEvents();

                    if (receiveList != null)
                    {
                        receiveList.Remove(receiveList.Find(p => p.Receive.ID == r.ID));
                    }
                    if (sendList != null)
                    {
                        sendList.Remove(sendList.Find(p => p.Send.ID == r.ID));
                    }
                }
                else
                {
                    annexCount++;
                }
                this.progressBar1.Value++;
                Application.DoEvents();
            }

            this.label3.Text = string.Format("数据{0}条 / 附件{1}条", count, annexCount);
            Application.DoEvents();


            handle.ExcelImport(beginYear, type, sendList, receiveList);

            this.label5.Text     = string.Format("完成:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            this.button2.Enabled = true;
        }
Beispiel #3
0
        /// <summary>
        /// 会签文
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            this.button3.Enabled = false;

            this.progressBar1.Minimum   = 0;
            this.progressBar1.BackColor = Color.Green;

            List <AnnexItem> list     = new List <AnnexItem>();
            List <SendData>  sendList = null;
            List <int>       idList   = new List <int>();
            int count      = 0;
            int annexCount = 0;

            this.label4.Text = string.Format("开始:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            Application.DoEvents();

            var handle = new OaInfoHandle();

            sendList = new List <SendData>();
            var sends = handle.GetSendLHFW();

            count = sends.Count;

            list.AddRange(sends.Select(p => new AnnexItem()
            {
                Index        = string.Format("{0:D8}", p.ID),
                ID           = p.ID,
                Title        = p.Title,
                SerialNumber = p.SerialNumber,
                FolderName   = "会签发文附件"
            }));

            sendList.AddRange(handle.GetSends(sends));

            this.label3.Text          = string.Format("数据{0}条 / ", count);
            this.progressBar1.Maximum = count;


            foreach (var r in list)
            {
                string ret = handle.GetAnnex(r);
                if (ret == "none")
                {
                    this.richTextBox1.Text += string.Format("{0}5  {1}({2} {3})  没有附件。", Environment.NewLine, r.ID, r.SerialNumber, r.Title);
                    Application.DoEvents();
                }
                else if (!string.IsNullOrEmpty(ret))
                {
                    this.richTextBox1.Text += string.Format("{0}{1}", Environment.NewLine, ret);
                    Application.DoEvents();
                }
                else
                {
                    annexCount++;
                }
                this.progressBar1.Value++;
                Application.DoEvents();
            }

            this.label3.Text = string.Format("数据{0}条 / 附件{1}条", count, annexCount);
            Application.DoEvents();


            handle.ExcelImport(DateTime.Now.Year, 2, sendList, null);

            this.label5.Text     = string.Format("完成:{0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            this.button3.Enabled = true;
        }