void exportList() { if (cbListSend.SelectedItem == null) { MessageBox.Show("请先选择送审名单 "); return; } string fileName; string filepath = Microsoft.Win32.Registry.GetValue(@"HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders", "desktop", "").ToString(); if (!(String.IsNullOrEmpty(filepath))) { fileName = filepath + "\\" + txtDSN.Text + ".xlsx"; } else { System.Windows.Forms.SaveFileDialog saveFile = new System.Windows.Forms.SaveFileDialog(); saveFile.Filter = "Excel文件|*.xlsx"; if (saveFile.ShowDialog() == System.Windows.Forms.DialogResult.OK) { fileName = saveFile.FileName; } else { return; } } List <sp_SelectTable3ForExcel_Result> sendCollection = visaORM.sp_SelectTable3ForExcel(cbListSend.SelectedItem.ToString()).ToList(); if (cbVietnamCompany.SelectedItem == null) { MessageBox.Show("请选择越南公司"); return; } if (sendCollection.Count() > 0) { Excel.ExportC.ExportTable3(fileName, sendCollection, txtDate.Text.Substring(4, 2) + "/" + txtDate.Text.Substring(2, 2) + "/" + "20" + txtDate.Text.Substring(0, 2), txtDSN.Text, cbVietnamCompany.SelectedItem.ToString(), messages); //Excel.ExportC.PirntExcel(fileName); } }
void exportList() { try { if (string.IsNullOrEmpty(this.sendNoString)) { MessageBox.Show("请先选择送审名单 "); return; } string fileName; string filepath = Microsoft.Win32.Registry.GetValue(@"HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders", "desktop", "").ToString(); if (!(String.IsNullOrEmpty(filepath))) { fileName = filepath + "\\" + txtDSN.Text + ".xlsx"; } else { System.Windows.Forms.SaveFileDialog saveFile = new System.Windows.Forms.SaveFileDialog(); saveFile.Filter = "Excel文件|*.xlsx"; if (saveFile.ShowDialog() == System.Windows.Forms.DialogResult.OK) { fileName = saveFile.FileName; } else { return; } } int i = 0; List <sp_SelectTable3ForExcel_Result> sendCollection = visaORM.sp_SelectTable3ForExcel(this.sendNoString).ToList(); if (cbVietnamCompany.EditValue == null || cbVietnamCompany.EditValue.ToString() == "") { MessageBox.Show("请填写越南公司"); return; } if (sendCollection.Count() > 0) { Excel.ExportC.ExportTable3(fileName, sendCollection, txtDate.DateTime.ToString("MM/dd/yyyy"), txtDSN.Text, txtSpecial.Text, messages); //Excel.ExportC.(fileName); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }
private void GetSendListDetail(ComboBoxEdit cb) { if (cb.SelectedItem != null) { string SentNo = cb.SelectedItem.ToString(); var model = visaORM.SendInfo.FirstOrDefault(s => s.FSendNo == SentNo); if (model != null) { txtDSN.Text = model.FDSN; txtSendNo.Text = model.FSendNo; txtCompany.Text = model.FCreateCompany; txtDate.Text = model.FCDate; if (model.FCDate != null) { txtDate.Text = model.FCDate.ToString(); } //sendCollection = (from c in visaORM.Customer // join s in visaORM.SendInfo // on c.FID equals s.FCustomerID // where s.FSendNo == SentNo // select c).ToList(); // sendCollection = visaORM.sp_SelectTable3ForExcel(SentNo).ToList(); //gridMain.ItemsSource = sendCollection; foreach (var sObj in visaORM.sp_SelectTable3ForExcel(SentNo)) { sendCollection.Add(sObj); } gridMain.DataContext = sendCollection; } } else { gridMain.ItemsSource = null; } }