private void button3_Click(object sender, EventArgs e) { dataGridView1.Visible = false; dataGridView2.Visible = false; nUDMonth.Visible = false; panel2.Visible = true; panel2.Top = panel1.Height + panel4.Height; panel2.Height = this.Height - panel1.Height - panel4.Height; try { string sqlstring = "Select Distinct Creator from Booking"; DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; comboBox1.Items.Add("--全部--"); foreach (DataRow dr in Dt.Rows) { comboBox1.Items.Add(dr[0].ToString()); } sqlstring = "Select Distinct State from Booking"; DataTable Dt1 = SQLDbHelper.Query(sqlstring).Tables[0]; comboBox2.Items.Add("--全部--"); foreach (DataRow dr in Dt1.Rows) { comboBox2.Items.Add(dr[0].ToString()); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { string sqlstring = "Select * from View_Search"; string strWhere = " Where BookTime between '" + dateTimePicker1.Value.ToShortDateString() + "' and '" + dateTimePicker2.Value.AddDays(1).ToShortDateString() + "'"; if (comboBox1.Text != string.Empty && comboBox1.Text.IndexOf("全部") == -1) { strWhere += " And Creator ='" + comboBox1.Text + "'"; } if (comboBox2.Text != string.Empty && comboBox2.Text.IndexOf("全部") == -1) { strWhere += " And State ='" + comboBox2.Text + "'"; } if (comboBox3.Text != string.Empty && comboBox3.Text.IndexOf("全部") == -1) { strWhere += " And Receiver ='" + comboBox3.Text + "'"; } if (txtCarNo.Text != string.Empty) { strWhere = " Where CarNo like '%" + txtCarNo.Text + "%'"; } dataGridView3.DataSource = SQLDbHelper.Query(sqlstring + strWhere + " Order by Booktime desc").Tables[0]; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
/// <summary> /// 批量保存系统词典 /// </summary> /// <returns></returns> public static void SaveItem(System.Windows.Forms.TreeView treeView) { DataTable Dt = null; string sqlstr = null; try { Dt = new DataTable(); DataSet ds = new DataSet(); sqlstr = "select * from SysDictionary where 1=0"; ds = SQLDbHelper.Query(sqlstr); Dt = ds.Tables[0]; for (int i = 0; i < treeView.Nodes[0].Nodes.Count; i++) { for (int j = 0; j < treeView.Nodes[0].Nodes[i].Nodes.Count; j++) { DataRow Dr = Dt.NewRow(); Dr["ItemName"] = treeView.Nodes[0].Nodes[i].Text; Dr["Items"] = treeView.Nodes[0].Nodes[i].Nodes[j].Text; Dt.Rows.Add(Dr); } } SQLDbHelper.ExecuteSql("Delete from SysDictionary"); SQLDbHelper.UpdateTable(ds, sqlstr); } catch (Exception Err) { throw Err; } finally { //DbHelperSQL._connection.Close(); //Member.Common.DbHelper._connection.Close(); } }
private void LoadGridView1() { for (int i = 1; i < 32; i++) { DataGridViewTextBoxColumn dgcbc = new DataGridViewTextBoxColumn(); dgcbc.HeaderText = i.ToString(); dgcbc.Tag = i; dgcbc.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridView1.Columns.Add(dgcbc); } string sqlstring = "Select WorkerName,WorkerCode from Worker order by WorkerGroup desc"; try { DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; dataGridView1.Rows.Add(Dt.Rows.Count); for (int i = 0; i < Dt.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = Dt.Rows[i]["WorkerName"].ToString(); dataGridView1.Rows[i].Cells[0].Tag = Dt.Rows[i]["WorkerCode"].ToString(); dataGridView1.Rows[i].Height = (dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / Dt.Rows.Count; } nUDYear.Value = DateTime.Today.Year; nUDMonth.Value = DateTime.Today.Month; dataGridView1.ClearSelection(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void LoadTree() { sqlstring = "Select * from SysUser"; treeView1.Nodes[0].Nodes.Clear(); DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; foreach (DataRow dr in Dt.Rows) { TreeNode tn = new TreeNode(); tn.Text = dr["UserName"].ToString() + "(" + dr["UserID"].ToString() + ")"; tn.Tag = dr["UserID"].ToString(); treeView1.Nodes[0].Nodes.Add(tn); } treeView1.Nodes[0].Expand(); sqlstring = "Select * from SysFunction"; treeView2.Nodes[0].Nodes.Clear(); Dt = SQLDbHelper.Query(sqlstring).Tables[0]; foreach (DataRow dr in Dt.Select("FunParentID=-1")) { TreeNode tn = new TreeNode(); tn.Text = dr["FunName"].ToString(); tn.Tag = dr["ID"].ToString(); foreach (DataRow drc in Dt.Select("FunParentID=" + int.Parse(dr["ID"].ToString()))) { TreeNode tnc = new TreeNode(); tnc.Text = drc["FunName"].ToString(); tnc.Tag = drc["ID"].ToString(); tn.Nodes.Add(tnc); } treeView2.Nodes[0].Nodes.Add(tn); } treeView2.Nodes[0].Expand(); }
private void ShowGrid1(DateTime Dt, string wherestr) { labDateTime.Text = Dt.ToString("yyyy年MM月dd日"); index = 0; ClearContrl(); Cards = new int[dataGridView1.Rows.Count, 3]; for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Height = (dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / dataGridView1.Rows.Count; } try { string sqlstring = "Select * from Booking where Booktime between '" + Dt.ToShortDateString() + "' and '" + Dt.AddDays(1).ToShortDateString() + "'"; if (wherestr != string.Empty && btnPreview.Text != "全部") { sqlstring += " And (PreSA='" + ClsBLL.UserName + "' Or Receiver='" + ClsBLL.UserName + "')"; } sqlstring += " Order by BookTime"; DataTable DataBook = SQLDbHelper.Query(sqlstring).Tables[0]; //显示所有预约列表 CmbCars.Items.Clear(); foreach (DataRow dr in DataBook.Rows) { DateTime TempT = DateTime.Parse(dr["BookTime"].ToString()); CheckRowindex(TempT); AddCarCard(dr); } SumWorkHours(0, 0); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
//工单明细 private void btnQuery_Click(object sender, EventArgs e) { string sqlwhere = string.Empty; gridControl20.Visible = false; gcRo.Visible = true; 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 sqlstring = "Select * from View_SelectBooking Where " + sqlwhere; try { DataTable 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); } gcRo.DataSource = Dt; if (gridView1.Columns["单号"] != null) { gridView1.Columns["单号"].Visible = false; } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void ShowGrid() { int years = int.Parse(comboBox4.Text.Substring(0, 4)); int months = int.Parse(comboBox4.Text.Substring(comboBox4.Text.IndexOf("年") + 1, comboBox4.Text.IndexOf("月") - comboBox4.Text.IndexOf("年") - 1)); try { string sqlstring = string.Empty; sqlstring = "Exec Sp_BookRemindResult " + years + "," + months + ""; gridControl5.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; sqlstring = "Exec Sp_BookRemindFaild " + years + "," + months + ""; gridControl6.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; sqlstring = "Exec Sp_BookComeType " + years + "," + months + ""; gridControl7.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; sqlstring = "Exec Sp_BookState " + years + "," + months + ""; gridControl8.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void frmAddHour_Load(object sender, EventArgs e) { string sqlstring = "Select Worker,ServiceItem,StartServiceTime,PlanCompleteTime,EndServiceTime,ServiceHour,CarNo,State from Booking where ID=" + RecordID; try { DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; txtHours.Text = Convert.ToString(decimal.Floor(decimal.Parse(Dt.Rows[0]["ServiceHour"].ToString()) * 100)); worker = Dt.Rows[0]["Worker"].ToString(); txtOldWorker.Text = worker; state = Dt.Rows[0]["State"].ToString(); this.Text = Dt.Rows[0]["CarNo"].ToString() + " " + this.Text; sqlstring = "Select WorkerName,Worker.WorkerCode from WorkerPlan inner join Worker on WorkerPlan.WorkerCode=Worker.WorkerCode Where Wyear=" + DateTime.Today.Year + " and Wmonth=" + DateTime.Today.Month + " and Wday=" + DateTime.Today.Day + " and IsWork=1 and Workergroup in ('" + ClsBLL.UserGroup + "') order by Workergroup desc"; Dt = SQLDbHelper.Query(sqlstring).Tables[0]; for (int i = 0; i < Dt.Rows.Count; i++) { comboBox1.Items.Add(Dt.Rows[i]["WorkerName"].ToString()); } comboBox1.Text = worker; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void AddWorkerPlan() { try { DataTable Dt = SQLDbHelper.Query("Select * from Worker Where WorkerCode not in (Select WorkerCode from WorkerPlan)").Tables[0]; for (int i = 2009; i < 2013; i++) { for (int j = 1; j < 13; j++) { for (int d = 1; d < 32; d++) { string sqlstring = ""; for (int m = 0; m < Dt.Rows.Count; m++) { sqlstring += ";Insert into WorkerPlan(Wyear,Wmonth,Wday,workercode)values(" + i + "," + j + "," + d + ",'" + Dt.Rows[m]["WorkerCode"].ToString() + "')"; } if (sqlstring.Length > 1) { SQLDbHelper.ExecuteSql(sqlstring.Substring(1)); } } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void tabControl4_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox2.Text == string.Empty) { return; } button18.Enabled = false; try { int years = int.Parse(comboBox2.Text.Substring(0, 4)); int months = int.Parse(comboBox2.Text.Substring(comboBox2.Text.IndexOf("年") + 1, comboBox2.Text.IndexOf("月") - comboBox2.Text.IndexOf("年") - 1)); string servicename = gridView3.GetRowCellValue(selectrow, "维修工人").ToString(); if (tabControl4.SelectedIndex == 1 && selectrow > -1) { sqlstring = "Exec WorkerList " + years + "," + months + ",'" + servicename + "'"; DataTable WorkerListDt = SQLDbHelper.Query(sqlstring).Tables[0]; WorkerListDt.DefaultView.Sort = " 开始维修时间 Desc"; gridControl15.DataSource = WorkerListDt.DefaultView.Table; } if (tabControl4.SelectedIndex == 2 && selectrow > -1) { sqlstring = "Exec WorkerReService " + years + "," + months + ",'" + servicename + "'"; gridControl3.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } if (tabControl4.SelectedIndex == 3 && selectrow > -1) { sqlstring = "Exec WorkerAddItem " + years + "," + months + ",'" + servicename + "'"; gridControl19.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void LoadSysDictionary() { try { treeView3.Nodes[0].Nodes.Clear(); DataTable dt = SQLDbHelper.Query("Select * from SysDictionary").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TreeNode[] tns = treeView3.Nodes.Find(dt.Rows[i][0].ToString(), true); if (tns.Length > 0) { TreeNode tn = tns[0]; tn.Nodes.Add(dt.Rows[i][1].ToString()); } else { TreeNode tn = new TreeNode(); tn.Text = dt.Rows[i][0].ToString(); tn.Name = dt.Rows[i][0].ToString(); tn.Nodes.Add(dt.Rows[i][1].ToString()); treeView3.Nodes[0].Nodes.Add(tn); } } treeView3.Nodes[0].Expand(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
//异常查询 private void button20_Click(object sender, EventArgs e) { string sqlstring = "Exec BookingAbort '" + dateTimePicker1.Value.ToShortDateString() + "','" + dateTimePicker2.Value.ToShortDateString() + "'"; try { gridControl20.Visible = true; gcRo.Visible = false; gridControl20.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); gridControl20.Location = new System.Drawing.Point(0, 51); gridControl20.Margin = new System.Windows.Forms.Padding(0, 3, 0, 3); gridControl20.Size = gcRo.Size; DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; for (int i = 0; i < Dt.Rows.Count; i++) { Dt.Rows[i]["序号"] = Convert.ToString(i + 1); } gridControl20.DataSource = Dt; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { int years = int.Parse(comboBox6.Text.Substring(0, 4)); int months = int.Parse(comboBox6.Text.Substring(comboBox6.Text.IndexOf("年") + 1, comboBox6.Text.IndexOf("月") - comboBox6.Text.IndexOf("年") - 1)); try { string sqlstring = "Exec Sp_ServiceType " + years + "," + months + ""; gridControl1.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; sqlstring = "Exec Sp_ServiceEndType " + years + "," + months + ""; gridControl16.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; Dt = (DataTable)gridControl1.DataSource; chartControl1.Titles[0].Text = comboBox6.Text + tabControl5.SelectedTab.Text; chartControl1.Series[0].Points.Clear(); for (int i = 0; i < Dt.Rows.Count; i++) { string reason = Dt.Rows[i][0].ToString(); chartControl1.Series[0].Points.Add(new SeriesPoint(reason, new double[] { double.Parse(Dt.Rows[i][1].ToString()) })); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void tabControl6_SelectedIndexChanged(object sender, EventArgs e) { try { if (tabControl6.SelectedIndex == 1 && selectrow > -1) { if (comboBox3.Text == string.Empty) { return; } int years = int.Parse(comboBox3.Text.Substring(0, 4)); int months = int.Parse(comboBox3.Text.Substring(comboBox3.Text.IndexOf("年") + 1, comboBox3.Text.IndexOf("月") - comboBox3.Text.IndexOf("年") - 1)); if (gridView13.RowCount > 0) { string reason = gridView13.GetRowCellValue(selectrow, "中断原因").ToString(); sqlstring = "Exec Sp_BookPauseReason " + years + "," + months + ",'" + reason + "'"; try { gridControl12.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void ShowGrid1(DateTime Dt) { label1.Text = Dt.ToString("yyyy年MM月dd日"); index = 0; ClearContrl(); Cards = new int[dataGridView1.Rows.Count, 3]; for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Height = (dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / dataGridView1.Rows.Count; } try { string sqlstring = "Select * from Booking where Booktime between '" + Dt.ToShortDateString() + "' and '" + Dt.AddDays(1).ToShortDateString() + "'"; DataTable DataBook = SQLDbHelper.Query(sqlstring).Tables[0]; //显示所有预约列表 foreach (DataRow dr in DataBook.Rows) { DateTime TempT = DateTime.Parse(dr["BookTime"].ToString()); CheckRowindex(TempT); AddCarCard(dr); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void frmPause_Load(object sender, EventArgs e) { ClsBLL.IniCombox(comboBox1, "中断原因"); DataTable Dt = SQLDbHelper.Query("Select Worker,CarNo from Booking Where ID=" + RecordID).Tables[0]; CarNo = Dt.Rows[0]["CarNo"].ToString(); Worker = Dt.Rows[0]["Worker"].ToString(); this.Text = CarNo + "中断"; }
private void frmCarStateBoad_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; labDateTime.Text = DateTime.Today.ToString("yyyy年MM月dd日"); ClsBLL.IniCombox(comboBox1, "中断原因"); dataGridView1.Rows.Add((dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / dataGridView1.RowTemplate.Height); string sqlstring = "Select Items from SysDictionary where ItemName='SA'"; DataTable Dt2 = SQLDbHelper.Query(sqlstring).Tables[0]; cmbReceiver.Items.Add("--全部--"); foreach (DataRow dr in Dt2.Rows) { cmbReceiver.Items.Add(dr[0].ToString()); } ShowGrid(string.Empty); //dataGridView1.BackgroundColor = Color.PaleTurquoise; dataGridView1.ClearSelection(); int Interval = int.Parse(ClsBLL.GetSet("txtSet5")); timer1.Interval = Interval * 1000 * 60; timer1.Enabled = true; if (!ClsBLL.IsPower(btnToday.Text)) { btnToday.Enabled = false; } if (!ClsBLL.IsPower(btnMonth.Text)) { btnMonth.Enabled = false; } pn0.Left = (dataGridView1.Columns[0].Width - pn0.Width) / 2; pn1.Left = (dataGridView1.Columns[1].Width - pn1.Width) / 2 + dataGridView1.Columns[0].Width * 1; pn2.Left = (dataGridView1.Columns[2].Width - pn2.Width) / 2 + dataGridView1.Columns[0].Width * 2; pn3.Left = (dataGridView1.Columns[3].Width - pn3.Width) / 2 + dataGridView1.Columns[0].Width * 3; pn4.Left = (dataGridView1.Columns[4].Width - pn4.Width) / 2 + dataGridView1.Columns[0].Width * 4; pn0.Controls.Add(pic0Down); pic0Down.Top = pic0Up.Top; if (!ClsBLL.IsPower("追加项目")) { 追加项目ToolStripMenuItem.Visible = false; } if (!ClsBLL.IsPower("返修")) { 返修ToolStripMenuItem.Visible = false; } if (!ClsBLL.IsPower("修改状态")) { 修改状态ToolStripMenuItem.Visible = false; } }
//预约情况统计表 private void btnShowGraphi_Click(object sender, EventArgs e) { panel3.Visible = false; barChart.Visible = true; barChart.Left = panel3.Left; barChart.Top = panel3.Top; barChart.Width = panel3.Width; barChart.Height = panel3.Height; barChart.Left = tabControl2.Left; if (comboBox1.Text == string.Empty) { return; } int years = int.Parse(comboBox1.Text.Substring(0, 4)); int months = int.Parse(comboBox1.Text.Substring(comboBox1.Text.IndexOf("年") + 1, comboBox1.Text.IndexOf("月") - comboBox1.Text.IndexOf("年") - 1)); try { sqlstring = "exec Sp_BookGraphi " + years + "," + months; DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; barChart.Titles[0].Text = comboBox1.Text + "预约情况统计表"; barChart.Series.Clear(); Series series1 = new Series("预约车辆", ViewType.Bar); Series series2 = new Series("到场车辆", ViewType.Bar); for (int i = 1; i < 32; i++) { string datewhere = years.ToString() + "-" + months.ToString().PadLeft(2, char.Parse("0")) + "-" + i.ToString().PadLeft(2, char.Parse("0")); DataRow[] Dr1 = Dt.Select("bookday=" + i); double db1 = 0; if (Dr1.Length > 0) { db1 = double.Parse(Dr1.Length.ToString()); } DataRow[] Dr2 = Dt.Select("comeday=" + i); double db2 = 0; if (Dr2.Length > 0) { db2 = double.Parse(Dr2.Length.ToString()); } series1.Points.Add(new SeriesPoint(i.ToString() + "日", new double[] { db1 })); series2.Points.Add(new SeriesPoint(i.ToString() + "日", new double[] { db2 })); } barChart.Series.Add(series1); barChart.Series.Add(series2); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
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 frmSysLog_Load(object sender, EventArgs e) { string sqlstring = "Select BookID,Message,Creator,SUBSTRING(CONVERT(nvarchar(50), CreateDate, 120), 6, 11) as CreateDate from SysLog Where BookID=" + BookID + " Order by CreateDate"; try { dataGridView1.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void ShowGrid() { string sqlstring = "Select * from Worker"; try { DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; dataGridView1.DataSource = Dt; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void dateTimePicker1_ValueChanged(object sender, EventArgs e) { string sqlstring = @"Select Worker.*,WorkDay from Worker Inner join WorkerPlan on Worker.WorkerCode = WorkerPlan.Workercode where Wyear=" + dateTimePicker1.Value.Year + " and Wmonth=" + dateTimePicker1.Value.Month + " and wday=" + dateTimePicker1.Value.Day + ""; try { dataGridView1.DataSource = SQLDbHelper.Query(sqlstring).Tables[0]; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void nUDMonth_ValueChanged(object sender, EventArgs e) { label1.Text = DateTime.Today.Year.ToString() + "年" + nUDMonth.Value.ToString() + "月"; string sqlstring = "Select * from WorkerPlan where Wyear=" + DateTime.Today.Year + " and Wmonth=" + nUDMonth.Value; SqlCommand mycmd = SQLDbHelper.connection.CreateCommand(); mycmd.CommandText = sqlstring; Myda.SelectCommand = mycmd; DtPlan = new DataTable("WorkerPlan"); Myda.Fill(DtPlan); DtPlan = SQLDbHelper.Query(sqlstring).Tables[0]; LoadDate(); }
private void LoadSysSet() { DataTable DtSet = SQLDbHelper.Query("Select * from Setting").Tables[0]; foreach (Control ct in tabPage3.Controls) { if (ct.Name.StartsWith("txtSet")) { DataRow[] Drs = DtSet.Select("KeyWord='" + ct.Name + "'"); if (Drs.Length > 0) { ct.Text = Drs[0]["KeyWord_Value"].ToString(); } } } }
//查询 private void button19_Click(object sender, EventArgs e) { try { string servicename = gridView3.GetRowCellValue(selectrow, "维修工人").ToString(); string sqlstring = "Exec WorkerList2 '" + dateTimePicker3.Value.ToShortDateString() + "','" + dateTimePicker4.Value.AddDays(1).ToShortDateString() + "','" + servicename + "'"; DataTable WorkerListDt = SQLDbHelper.Query(sqlstring).Tables[0]; WorkerListDt.DefaultView.Sort = " 开始维修时间 Desc"; gridControl15.DataSource = WorkerListDt.DefaultView.Table; button18.Enabled = true; } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void txtCarNo_TextChanged(object sender, EventArgs e) { if (txtCarNo.Text.Length == 8) { string sqlstring = "Select * from Booking where CarNo='" + txtCarNo.Text + "'"; DataTable DtCar = SQLDbHelper.Query(sqlstring).Tables[0]; if (DtCar.Rows.Count > 0) { txtVIN.Text = DtCar.Rows[0]["VIN"].ToString(); cmbCarType.Text = DtCar.Rows[0]["CarType"].ToString(); txtLinkMan.Text = DtCar.Rows[0]["LinkMan"].ToString(); txtTel.Text = DtCar.Rows[0]["Tel"].ToString(); txtEmail.Text = DtCar.Rows[0]["Email"].ToString(); } } }
public XrCars(string combox) { InitializeComponent(); this.PaperKind = System.Drawing.Printing.PaperKind.A4Rotated; int years = int.Parse(combox.Substring(0, 4)); int months = int.Parse(combox.Substring(combox.IndexOf("年") + 1, combox.IndexOf("月") - combox.IndexOf("年") - 1)); try { string sqlstring = "select *,datepart(d,BookTime) as bookday,datepart(d,ComeTime) as comeday from Booking Where datepart(yyyy,CreateDate)=" + years + " and datepart(MM,CreateDate)=" + months; DataTable Dt = SQLDbHelper.Query(sqlstring).Tables[0]; //ChartControl barChart = new ChartControl(); barChart.Titles[0].Text = combox + "预约情况统计表"; barChart.Series.Clear(); Series series1 = new Series("预约车辆", ViewType.Bar); Series series2 = new Series("到场车辆", ViewType.Bar); for (int i = 1; i < 32; i++) { string datewhere = years.ToString() + "-" + months.ToString().PadLeft(2, char.Parse("0")) + "-" + i.ToString().PadLeft(2, char.Parse("0")); DataRow[] Dr1 = Dt.Select("bookday=" + i); double db1 = 0; if (Dr1.Length > 0) { db1 = double.Parse(Dr1.Length.ToString()); } DataRow[] Dr2 = Dt.Select("comeday=" + i); double db2 = 0; if (Dr2.Length > 0) { db2 = double.Parse(Dr2.Length.ToString()); } series1.Points.Add(new SeriesPoint(i.ToString() + "日", new double[] { db1 })); series2.Points.Add(new SeriesPoint(i.ToString() + "日", new double[] { db2 })); } barChart.Width = PageWidth - 20; barChart.Height = 500; barChart.Series.Add(series1); barChart.Series.Add(series2); } catch (Exception Err) { throw Err; } }
private void frmReport_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; sqlstring = @"select distinct cast(datepart(yy,EndServiceTime) as nvarchar(50)) + '年'+ cast(datepart(MM,EndServiceTime) as nvarchar(50)) + '月' as 年月 from Booking where EndServiceTime is not null order by 年月 desc"; CmbDt = SQLDbHelper.Query(sqlstring).Tables[0]; foreach (Control ct in this.panel2.Controls) { if (ct.Name.StartsWith("btnRt")) { if (!ClsBLL.IsPower(ct.Text)) { ct.Enabled = false; } } } if (!ClsBLL.IsPower("工单明细")) { btnQuery.Enabled = false; button10.Enabled = false; button20.Enabled = false; button21.Enabled = false; button22.Enabled = false; button23.Enabled = false; } if (!ClsBLL.IsPower("异常单查询")) { button20.Enabled = false; } if (!ClsBLL.IsPower("修改状态")) { button21.Enabled = false; } if (!ClsBLL.IsPower("操作日志")) { button22.Enabled = false; } if (!ClsBLL.IsPower("删除工单")) { button23.Enabled = false; } }
private void 修改ToolStripMenuItem_Click(object sender, EventArgs e) { try { string workercode = dataGridView1.SelectedRows[0].Cells["Column3"].Value.ToString(); DataTable Dt = SQLDbHelper.Query("Select * from Worker where Workercode='" + workercode + "'").Tables[0]; comboBox1.Text = Dt.Rows[0]["WorkerGroup"].ToString(); comboBox2.Text = Dt.Rows[0]["Position"].ToString(); textBox1.Text = workercode; textBox2.Text = Dt.Rows[0]["WorkerName"].ToString(); textBox3.Text = Dt.Rows[0]["HourRate"].ToString(); textBox1.Enabled = false; } catch (Exception Err) { MessageBox.Show(Err.Message); } }