private void button16_Click(object sender, EventArgs e) { try { if (tabControl6.SelectedIndex == 0) { Dt = (DataTable)gridControl11.DataSource; } if (tabControl6.SelectedIndex == 1) { Dt = (DataTable)gridControl12.DataSource; } if (tabControl6.SelectedIndex == 2) { XrPause xrp = new XrPause((DataTable)gridControl11.DataSource, comboBox3.Text + "异常情况统计"); xrp.ShowPreview(); return; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox3.Text + tabControl6.SelectedTab.Text); xr1.ShowPreview(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button15_Click(object sender, EventArgs e) { try { int dir = 1; if (tabControl4.SelectedIndex == 0) { Dt = (DataTable)gridControl2.DataSource; } if (tabControl4.SelectedIndex == 1) { Dt = (DataTable)gridControl15.DataSource; dir = 0; } if (tabControl4.SelectedIndex == 2) { Dt = (DataTable)gridControl3.DataSource; } if (tabControl4.SelectedIndex == 3) { Dt = (DataTable)gridControl19.DataSource; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, dir, comboBox2.Text + tabControl4.SelectedTab.Text); xr1.ShowPreview(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button5_Click(object sender, EventArgs e) { try { if (gridControl9.Visible) { Dt = (DataTable)gridControl9.DataSource; } if (gridControl13.Visible) { Dt = (DataTable)gridControl13.DataSource; } if (gridControl14.Visible) { Dt = (DataTable)gridControl14.DataSource; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox4.Text + tabControl3.SelectedTab.Text + "明细表"); xr1.ShowPreview(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button14_Click(object sender, EventArgs e) { try { if (barChart.Visible) { XrCars xrc = new XrCars(comboBox1.Text); xrc.ShowPreview(); } else { if (tabControl2.SelectedIndex == 0) { Dt = (DataTable)gcSA.DataSource; } if (tabControl2.SelectedIndex == 1) { Dt = (DataTable)gridControl4.DataSource; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox1.Text + tabControl2.SelectedTab.Text); xr1.ShowPreview(); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
//预览 private void button18_Click(object sender, EventArgs e) { Dt = (DataTable)gridControl15.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 0, dateTimePicker3.Value.ToString("MM月dd日") + "至" + dateTimePicker4.Value.ToString("MM月dd日") + tabControl4.SelectedTab.Text); xr1.ShowPreview(); } }
private void button10_Click(object sender, EventArgs e) { string sqlwhere = string.Empty; sqlwhere = "预约时间>'" + dateTimePicker1.Value.ToString("yy-MM-dd 00:00") + "' and 预约时间<'" + dateTimePicker2.Value.AddDays(1).ToString("yy-MM-dd 00:00") + "' And CreateDate>'" + dateTimePicker1.Value.ToShortDateString() + "'"; string where = gridView1.FilterPanelText; if (where.IndexOf("与") > -1) { where = where.Replace("与", "And"); } if (where.IndexOf("Like") > -1) { where = where.Replace("匹配(Like)", "like"); } if (where != string.Empty) { sqlwhere += "And " + where; } if (gcRo.Visible) { string sqlstring = "Select * from View_SelectBooking Where " + sqlwhere; Dt = SQLDbHelper.Query(sqlstring).Tables[0]; Dt.Columns.Remove("CreateDate"); for (int i = 0; i < Dt.Rows.Count; i++) { Dt.Rows[i]["序号"] = Convert.ToString(i + 1); } for (int i = 0; i < gridView1.Columns.Count - 1; i++) { if (!gridView1.Columns[i].Visible) { Dt.Columns.Remove(gridView1.Columns[i].Caption); } } Dt.Columns.Remove("单号"); if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 0, "预约工单明细表"); xr1.ShowPreview(); } } else { Dt = (DataTable)gridControl20.DataSource; Dt.Columns.Remove("单号"); if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 0, "异常工单明细表"); xr1.ShowPreview(); } } }
private void button13_Click(object sender, EventArgs e) { try { Dt = (DataTable)gridControl10.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox5.Text + "预约工时统计"); xr1.ShowPreview(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button17_Click(object sender, EventArgs e) { if (tabControl5.SelectedIndex == 0) { Dt = (DataTable)gridControl1.DataSource; } if (tabControl5.SelectedIndex == 1) { Dt = (DataTable)gridControl16.DataSource; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox6.Text + tabControl5.SelectedTab.Text); xr1.ShowPreview(); } }
private void button11_Click(object sender, EventArgs e) { try { if (tabControl3.SelectedIndex == 0) { Dt = (DataTable)gridControl5.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox4.Text + "电话提醒"); xr1.ShowPreview(); } Dt = (DataTable)gridControl6.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox4.Text + "电话提醒失败原因"); xr1.ShowPreview(); } } if (tabControl3.SelectedIndex == 1) { Dt = (DataTable)gridControl7.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox4.Text + "来店方式"); xr1.ShowPreview(); } } if (tabControl3.SelectedIndex == 2) { Dt = (DataTable)gridControl8.DataSource; if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox4.Text + "预约结果"); xr1.ShowPreview(); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button6_Click(object sender, EventArgs e) { try { if (tabControl7.SelectedIndex == 0) { Dt = (DataTable)gridControl7.DataSource; } if (tabControl7.SelectedIndex == 1) { Dt = (DataTable)gridControl8.DataSource; } if (Dt != null && Dt.Rows.Count > 0) { XrROList xr1 = new XrROList(Dt, 1, comboBox7.Text + tabControl7.SelectedTab.Text); xr1.ShowPreview(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }