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