private void frmSelectBook_Load(object sender, EventArgs e) { this.Width = Screen.PrimaryScreen.WorkingArea.Width * 8 / 10; this.Height = Screen.PrimaryScreen.WorkingArea.Height * 8 / 10; this.Left = Screen.PrimaryScreen.WorkingArea.Width / 10; this.Top = Screen.PrimaryScreen.WorkingArea.Height * 17 / 100; this.Text = SelectDt.ToString("yyyy年MM月dd日") + "预约情况"; starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2")); TimeSpan ts = endtime.Subtract(starttime); int cols = ts.Hours * 2; if (ts.Minutes > 0) { cols++; } dataGridView1.Rows.Add(cols + 1); for (int i = 0; i < dataGridView1.Rows.Count; i++) { DateTime NewDt = starttime.AddMinutes(i * 30); dataGridView1.Rows[i].Cells[0].Value = NewDt.Hour.ToString() + ":" + NewDt.Minute.ToString().PadRight(2, char.Parse("0")); dataGridView1.Rows[i].Height = dataGridView1.Height / dataGridView1.Rows.Count; } dataGridView1.Columns[1].Width = dataGridView1.Width * 6 / 10; ShowGrid1(SelectDt); }
private void frmWork_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; label1.Text = DateTime.Now.ToString("yyyy年MM月dd日"); starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2")); TimeSpan ts = endtime.Subtract(starttime); int cols = ts.Hours; if (ts.Minutes > 0) { cols++; } for (int i = 0; i <= cols; i++) { DateTime NewDt = starttime.AddHours(i); dataGridView1.Columns.Add("Col" + NewDt.Hour.ToString(), NewDt.Hour.ToString() + ":00"); dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } ShowGrid(); int Interval = int.Parse(ClsBLL.GetSet("txtSet4")); timer1.Interval = Interval * 1000 * 60; timer1.Enabled = true; CheckPower(); }
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 bool CheckExsit() { DateTime BookTime = DateTime.Parse(dateTimePicker1.Value.ToShortDateString() + " " + numericUpDown1.Value.ToString() + ":" + numericUpDown2.Value.ToString()); string sqlstring = "Select count(*) from Booking where (VIN='" + txtVIN.Text + "' Or CarNo='" + txtCarNo.Text + "') and Booktime between '" + BookTime.ToShortDateString() + "' and '" + BookTime.AddDays(1).ToShortDateString() + "'"; try { if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) > 0) { if (MessageBox.Show("车牌号:" + txtCarNo.Text + "或者车架号: " + txtVIN.Text + " 在" + BookTime.ToShortDateString() + "已经预约过!你还要增加吗?", "", MessageBoxButtons.YesNo) == DialogResult.No) { return(true); } else { string stype = "车身维修"; if (chkJD.Checked) { stype = "机电维修"; } sqlstring = "Select count(*) from Booking where (VIN='" + txtVIN.Text + "' Or CarNo='" + txtCarNo.Text + "') and Booktime between '" + BookTime.ToShortDateString() + "' and '" + BookTime.AddDays(1).ToShortDateString() + "' And Servicetype='" + stype + "'"; if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) > 0) { MessageBox.Show("车牌号:" + txtCarNo.Text + "或者车架号: " + txtVIN.Text + " 在" + BookTime.ToShortDateString() + "已经预约过同类型的维修,不能预约"); return(true); } } } sqlstring = "Select Count(*) from Booking where booktime='" + BookTime + "' and ServiceType='" + ServiceType + "'"; int rs = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); int maxnum = int.Parse(ClsBLL.GetSet("txtSet6")); if (rs > maxnum) { MessageBox.Show("在同一时间点只能预约" + maxnum + "辆车!"); return(true); } return(false); } catch (Exception Err) { MessageBox.Show(Err.Message); return(false); } }
private void frmBook_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; try { string sqlstring = "Select * from WorkHours where DateIndex between '" + DateTime.Today.AddDays(1 - DateTime.Today.Day) + "' and '" + DateTime.Today.AddMonths(1).AddDays(-DateTime.Today.Day) + "'"; WorkHours = SQLDbHelper.Query(sqlstring).Tables[0]; starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2")); TimeSpan ts = endtime.Subtract(starttime); int cols = ts.Hours * 2; if (ts.Minutes > 0) { cols++; } dataGridView1.Rows.Add(cols + 1 + 1); for (int i = 1; i < dataGridView1.Rows.Count; i++) { DateTime NewDt = starttime.AddMinutes((i - 1) * 30); dataGridView1.Rows[i].Cells[0].Value = NewDt.Hour.ToString() + ":" + NewDt.Minute.ToString().PadRight(2, char.Parse("0")); } nUDMonth.Value = DateTime.Today.Month; btnMonth_Click(null, null); int Interval = int.Parse(ClsBLL.GetSet("txtSet3")); timer1.Interval = Interval * 1000 * 60; timer1.Enabled = true; CheckPower(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void frmBookNew_Load(object sender, EventArgs e) { string sqlstring = string.Empty; ClsBLL.IniCombox(cmbCarType, "车型"); ClsBLL.IniCombox(cmbRemindResult, "提醒失败"); ClsBLL.IniCombox(cmbPreSA, "SA"); if (ClsBLL.GetSet("ComeType") == "0") { checkBox1.Visible = true; checkBox2.Visible = true; } if (IsUpdateParts == false) { tabControl1.TabPages.RemoveAt(1); } if (RID == -1) //新增 { dateTimePicker1.Value = DateTime.Parse(CurrentDt.ToString("yyyy-MM-dd")); numericUpDown1.Value = CurrentDt.Hour; numericUpDown2.Value = CurrentDt.Minute; if (ServiceType.StartsWith("机电")) { chkJD.Checked = true; chkBJ.Checked = false; } else { chkJD.Checked = false; chkBJ.Checked = true; } } else //修改 { LoadBooking(); } }
private void Form2_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; try { starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2")); TimeSpan ts = endtime.Subtract(starttime); int cols = ts.Hours * 2; if (ts.Minutes > 0) { cols++; } dataGridView1.Rows.Add(cols + 1 + 1); for (int i = 1; i < dataGridView1.Rows.Count; i++) { DateTime NewDt = starttime.AddMinutes((i - 1) * 30); dataGridView1.Rows[i].Cells[0].Value = NewDt.Hour.ToString() + ":" + NewDt.Minute.ToString().PadRight(2, char.Parse("0")); } nUDYear.Value = DateTime.Today.Year; nUDMonth.Value = DateTime.Today.Month; btnMonth_Click(null, null); int Interval = int.Parse(ClsBLL.GetSet("txtSet3")); timer1.Interval = Interval * 1000 * 60; timer1.Enabled = true; CheckPower(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { //维修工时 if (dataGridView1.Rows.Count == 0) { return; } if (dataGridView1.Rows[0].Cells[1].Value == null) { MessageBox.Show("请填写分单派工!"); return; } DateTime starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); try { string worker = string.Empty; decimal servicehours = 0; servicehours = servicehours / 100; string serviceitem = string.Empty; int id = -1; DateTime StartServiceTime = DateTime.Now; DateTime DtPlanComplete = DateTime.Now; string insertstring = string.Empty; string sqlstring = "Select count(Distinct CreateDate) from Booking where AssignTime between '" + DateTime.Today.ToString() + "' and '" + DateTime.Today.AddDays(1).ToString() + "' And Remark like '%分单%'"; int fendan = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); fendan++; for (int i = 0; i < dataGridView1.Rows.Count; i++) { id = -1; if (dataGridView1.Rows[i].Cells[1].Value != null) { worker = dataGridView1.Rows[i].Cells[0].Value.ToString(); servicehours = decimal.Parse(dataGridView1.Rows[i].Cells[1].Value.ToString()); servicehours = servicehours / 100; serviceitem = dataGridView1.Rows[i].Cells[2].Value.ToString(); if (dataGridView1.Rows[i].Cells[3].Value != null) { id = int.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString()); } DtPlanComplete = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); if (DateTime.Now.CompareTo(starttime) < 0) { DtPlanComplete = starttime; } if (id == -1) { if (i == 0) //未派工,首次分单 { sqlstring = "Update Booking Set AssignTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',PlanCompleteTime='" + DtPlanComplete + "', Worker='" + worker + "',ServiceHour=" + servicehours + ",ServiceItem='" + serviceitem + "',State='维修进行中',Remark=isnull(Remark,'')+',分单" + fendan + "' where ID=" + RID; SQLDbHelper.ExecuteSql(sqlstring); } else { insertstring += ";Insert Into Booking(BookIndex,booktime,carno,vin,cartype,linkman,tel,worker,bookhour,servicehour,serviceitem,"; insertstring += "servicetype,state,CarTopNo,Creator,Createdate,Updatedate,Success,ComeTime,AssignTime,PlanOutTime,PlanCompleteTime,StartServiceTime,Remark,IsBook,IsRemind,IsRemindSuc,"; insertstring += "RemindResult,Receiver,LastUpdate,PreSA,RunKM,Email,SendService,PreParts,Parts)"; insertstring += "Select BookIndex,booktime,carno,vin,cartype,linkman,tel,'" + worker + "' as worker,bookhour," + servicehours + " as servicehour,'" + serviceitem + "' as serviceitem,"; insertstring += "Servicetype,'维修进行中',CarTopNo,Creator,Createdate,Updatedate,Success,ComeTime,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',PlanOutTime,'" + DtPlanComplete + "' as PlanCompleteTime,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' as StartServiceTime,Remark,IsBook,IsRemind,IsRemindSuc,"; insertstring += "RemindResult,Receiver,LastUpdate,PreSA,RunKM,Email,SendService,PreParts,Parts from booking where ID=" + RID; } } else //已派工,分单 { DataRow[] Drs = Dt.Select("ID=" + id); if (remark.IndexOf("分单") > -1) { if (Drs.Length > 0) { if (Drs[0]["State"].ToString() == "延时到明天") { decimal facthour = ClsBLL.GetFactHours(id); if (servicehours > facthour) { servicehours = servicehours - facthour; } DtPlanComplete = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); sqlstring = "Update Booking Set ServiceHour=" + servicehours + ",StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',PlanCompleteTime='" + DtPlanComplete + "',ServiceItem='" + serviceitem + "',State='维修进行中' where ID=" + id; } else { sqlstring = "Update Booking Set ServiceHour=" + servicehours + ",ServiceItem='" + serviceitem + "',State='维修进行中' where ID=" + id; } } } else { if (Drs[0]["State"].ToString() == "延时到明天") { decimal facthour = ClsBLL.GetFactHours(id); if (servicehours > facthour) { servicehours = servicehours - facthour; } DtPlanComplete = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); sqlstring = "Update Booking Set ServiceHour=" + servicehours + ",StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',PlanCompleteTime='" + DtPlanComplete + "',ServiceItem='" + serviceitem + "',State='维修进行中',Remark=isnull(Remark,'')+',分单" + fendan + "' where ID=" + id; } else { sqlstring = "Update Booking Set ServiceHour=" + servicehours + ",PlanCompleteTime='" + DtPlanComplete + "',ServiceItem='" + serviceitem + "',State='维修进行中',Remark=isnull(Remark,'')+',分单" + fendan + "' where ID=" + id; } } SQLDbHelper.ExecuteSql(sqlstring); } } } if (insertstring.StartsWith(";")) { SQLDbHelper.ExecuteSql(insertstring.Substring(1)); } MessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
/// <summary> /// 获取机电总维修工时 /// </summary> /// <returns></returns> public static decimal SumHours(DateTime CurrentDate, string servicetype) { decimal workhours = 0; //工作时间 //工人数量 int workers = 0; string sqlstring = "Select Count(*) from WorkerPlan Where Wyear=" + CurrentDate.Year + " and Wmonth=" + CurrentDate.Month + " and Wday=" + CurrentDate.Day + " and IsWork=1"; sqlstring += " And WorkerCode in (Select WorkerCode from Worker Where WorkerGroup='" + servicetype + "')"; try { DateTime DtEnd = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2")); DateTime DtStart = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1")); TimeSpan ts = DtEnd.Subtract(DtStart); workhours = ts.Hours + ts.Minutes / decimal.Parse(Convert.ToString(60)); workers = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); } catch (Exception Err) { throw Err; } return(workhours * workers); }