/// <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; }
/// <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; }