private void button1_Click(object sender, RoutedEventArgs e) { if (dt.Rows.Count <= 1) { System.Windows.MessageBox.Show("没有数据,无法导出", "提示"); return; } SaveFileDialog sfd = new SaveFileDialog(); string filename; sfd.InitialDirectory = System.Environment.CurrentDirectory; filename = MyDateTimeUtil.Format(Convert.ToDateTime(DatePicker1.Text), "yyyyMMdd"); //if (DatePicker2.Text == "") { filename = DatePicker1.Text; } if (DatePicker2.Text != "") { filename = filename + "-" + MyDateTimeUtil.Format(Convert.ToDateTime(DatePicker2.Text), "yyyyMMdd"); } sfd.FileName = filename + "自助入住记录统计"; sfd.RestoreDirectory = true; sfd.Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls |CSV文件(*.csv) | *.csv"; if (sfd.ShowDialog() == DialogResult.OK) { if (sfd.FileName.ToLower().EndsWith("csv")) { CsvUtil cu = new CsvUtil(); cu.ExportDataToCVS(sfd.FileName, dt); System.Windows.MessageBox.Show("成功导出CSV文件", "成功"); } else { Type officeType = Type.GetTypeFromProgID("Excel.Application"); if (officeType == null) { Console.WriteLine("没安装!"); System.Windows.MessageBox.Show("提示", "请先安装office2007以上版本办公软件"); return; } else { Console.WriteLine("已安装!"); ExcelUtil eu = new ExcelUtil(); eu.DataTabletoExcel(dt, sfd.FileName); System.Windows.MessageBox.Show("成功导出EXCEL文件", "成功"); } } } //var dialog = new FolderBrowserDialog(); //dialog.ShowDialog(); //folderpathTB.Text = dialog.SelectedPath; // excelUtil eu = new excelUtil(); //eu.DataTabletoExcel(dt, System.Environment.CurrentDirectory + "\\temp.xlsx"); //eu.DataTabletoExcel(dt, dialog.SelectedPath + "\\temp.xlsx"); }
private void button_Click(object sender, RoutedEventArgs e) { //只选了主选项不选副选项一律输出整张表内容 //DataTable displayData = new DataTable(); String condition = ""; if (DatePicker1.Text != "") { condition += "and PAYTIME>='" + MyDateTimeUtil.Format(Convert.ToDateTime(DatePicker1.Text + " 00:00:01"), "yyyy-MM-dd HH:mm:ss") + "'"; } if (DatePicker2.Text != "") { condition += "and PAYTIME<='" + MyDateTimeUtil.Format(Convert.ToDateTime(DatePicker2.Text + " 23:59:59"), "yyyy-MM-dd HH:mm:ss") + "'"; } if (roomNo.Text != "") { condition += " and ROOMNO='" + roomNo.Text + "'"; } if (guestName.Text != "") { condition += " and GUESTNAME like '%" + guestName.Text + "%'"; } //System.Windows.MessageBox.Show(condition); if (condition.Equals("")) { System.Windows.MessageBox.Show("请输入查询条件"); return; } dt = dbutil.query(displayColumns, condition); SelectDisplayColumns(dt); double total = 0; foreach (DataRow row in dt.Rows) { total += double.Parse(row["总价"].ToString()); } dt = UpdateDataTable(dt); //dt.Columns[9].DataType = typeof(string); //string s = dt.Columns[10].ColumnName; DataRow newRow; newRow = dt.NewRow(); //if (dt.Rows.Count == 0) // { newRow["入住天数"] = "汇总"; // } // else { newRow["单价"] = " 总数:"; } //newRow["总价"] = dt.Rows.Count; newRow["单价"] = dt.Rows.Count + "个订单"; newRow["总价"] = "¥" + total; dt.Rows.Add(newRow); dataGrid.ItemsSource = dt.DefaultView; setColumnsWidth(); }