private void 中断ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt == null) { return; } DoubleClickButton bt = (DoubleClickButton)CureentCt; int recordid = int.Parse(bt.Name); if (中断ToolStripMenuItem.Text == "中断") { frmPause fpr = new frmPause(recordid); if (fpr.ShowDialog() == DialogResult.OK) { 刷新ToolStripMenuItem_Click(null, null); } } else { //设置中断并开始的记录 ClsBLL.ServicePauseStart(recordid); string[] strs = bt.ImageKey.Split(new Char[] { ',' }); string startdate = strs[4]; //中断之前的开始时间 string plancomplete = strs[5]; //预计完成时间 DateTime PlanEndDate = DateTime.Parse(plancomplete).AddMinutes(ClsBLL.Pausemins(recordid, DateTime.Parse(startdate))); //新的预计完成时间 string sqlstring = "Update Booking Set PlanCompleteTime='" + PlanEndDate + "',State='维修进行中' where ID=" + recordid; SQLDbHelper.ExecuteSql(sqlstring); ClsBLL.AddMsg(recordid, "车牌号码:" + strs[1] + ",中断后继续维修"); 刷新ToolStripMenuItem_Click(null, null); } }
private void 完工ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt == null) { return; } DoubleClickButton bt = (DoubleClickButton)CureentCt; string[] strs = bt.ImageKey.Split(new Char[] { ',' }); int recordid = int.Parse(bt.Name); string sqlstring = "Update booking set State='完工', EndServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' where ID=" + recordid; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ClsBLL.AddMsg(recordid, "车牌号码:" + strs[1] + ",完工"); if (bt.Tag.ToString() == "中断" || bt.Tag.ToString() == "过时") { ClsBLL.ServicePauseStart(recordid);//结束中断 } sqlstring = @"Select Count(*) from Booking A,(Select CarNo,VIN,CreateDate From Booking Where ID=" + recordid + ")B"; sqlstring += " Where A.CarNo=B.CarNo And A.VIN=B.VIN And A.CreateDate=B.CreateDate and A.State<>'完工'"; int r = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); if (r > 0) { MessageBox.Show("还有" + r.ToString() + "张分单未完工!"); ClsBLL.AddMsg(recordid, "车牌号码:" + bt.Tag.ToString() + "还有" + r.ToString() + "张分单未完工!" + ClsBLL.UserName); } bt.BackColor = Color.Blue; bt.Tag = "完工"; } }
private void button1_Click(object sender, EventArgs e) { if (comboBox2.Text == textBox1.Text || comboBox2.Text == string.Empty) { MessageBox.Show("ÐÞ¸Ä״̬²»ÄÜΪ¿Õ»òÐÞ¸Ä״̬²»ÄܵÈÓÚÔ״̬£¡"); return; } string sqlstring = "Update Booking Set State='" + comboBox2.Text + "' Where ID=" + RecordID; try { SQLDbHelper.ExecuteSql(sqlstring); if (textBox1.Text == "ÖжÏ") { ClsBLL.ServicePauseStart(RecordID); } ClsBLL.AddSysLog(RecordID, "ÐÞ¸Ä״̬,Ô״̬:" + textBox1.Text + ",ÏÖÔÚ״̬:" + comboBox2.Text + "£¬³µÅƺÅÂë:" + SQLDbHelper.ExecuteScalar("Select CarNo from Booking Where ID=" + RecordID).ToString()); MessageBox.Show("Ð޸ijɹ¦£¡"); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { if (Bt.Tag.ToString() == "中断") //如果是中断状态,做了延迟到明天的动作 { ClsBLL.ServicePauseStart(RecordID); } string sqlstring = string.Empty; try { if (comboBox1.Text == string.Empty) { MessageBox.Show("延迟中断原因不能为空!"); return; } sqlstring = "Insert into DelayService(BookID,Worker,StartServiceTime,PlanCompleteTime,DelayReason) select ID,Worker,StartServiceTime,PlanCompleteTime,'" + comboBox1.Text + "' from Booking where ID=" + RecordID; sqlstring += ";Update booking set State='延时到明天',DelayComplete='延时到明天' where ID=" + RecordID; Bt.BackColor = Color.Orange; Bt.Tag = "延时到明天"; ClsBLL.AddMsg(RecordID, "车牌号码:" + CarNo + "维修延时到明天--" + ClsBLL.UserName); if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { DialogResult = DialogResult.OK; this.Close(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { decimal servicehours = 0; string sqlstring = string.Empty; if (state == "中断" || state == "过时") { ClsBLL.ServicePauseStart(RecordID);//如果是中断则结束中断 } if (txtHours.Text != string.Empty) { servicehours = decimal.Parse(txtHours.Text); if (servicehours < 50) { MessageBox.Show("维修工时错误!"); return; } else { servicehours = decimal.Parse(servicehours.ToString()) / 100; } } decimal hours = servicehours + decimal.Parse(txtServiceHour.Text) / 100; //新的计划完成时间=当前时间+追加工时 DateTime plancompletetime = PlanCompleteTime.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); if (state == "中断") { plancompletetime = plancompletetime.AddMinutes(ClsBLL.Pausemins(RecordID, StartServiceTime)); } if (plancompletetime.CompareTo(DateTime.Today.AddHours(9)) == -1) //如果小于今天 { plancompletetime = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); } try { sqlstring = "Update booking set State='维修进行中',ServiceHour=" + hours + ",PlanCompleteTime='" + plancompletetime + "',EndServiceTime=Null,ServiceItem=ServiceItem + '," + txtItem.Text + "',Remark=isnull(Remark,'')+',追加维修项目' where ID=" + RecordID; if (txtHours.Text != string.Empty) { sqlstring += ";Insert Into ServiceAddHours(BookID,OldHours,AddHours,AddItem,Worker,AddTime)values(" + RecordID + "," + decimal.Parse(txtServiceHour.Text) / 100 + "," + decimal.Parse(txtHours.Text) / 100 + ",'" + txtAddItem.Text + "','" + worker + "','" + DateTime.Today.ToShortTimeString() + "')"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { DialogResult = DialogResult.OK; ClsBLL.AddMsg(RecordID, "车牌号码:" + this.Text + txtHours.Text + "TU--" + ClsBLL.UserName); this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { decimal servicehours = 0; string sqlstring = string.Empty; if (state == "中断" || state == "过时") { ClsBLL.ServicePauseStart(RecordID);//如果是中断则结束中断 } if (txtHours.Text != string.Empty) { servicehours = decimal.Parse(txtHours.Text); if (servicehours < 50) { MessageBox.Show("维修工时错误!"); return; } else { servicehours = decimal.Parse(servicehours.ToString()) / 100; } } decimal hours = servicehours + decimal.Parse(textBox1.Text) / 100; //新的计划完成时间=当前时间+追加工时 DateTime plancompletetime = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); try { sqlstring = "Insert Into Reservice(BookID,Worker,PlanCompleteTime,StartServiceTime,EndServiceTime,AddHours)Select ID,Worker,PlanCompleteTime,StartServiceTime,EndServiceTime," + servicehours + " From Booking Where ID=" + RecordID; sqlstring += ";Update booking set State='维修进行中',ServiceHour=" + hours + ",StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',EndServiceTime=Null,PlanCompleteTime='" + plancompletetime + "',Worker='" + comboBox1.Text + "',Remark=isnull(Remark,'')+',返修' where ID=" + RecordID; if (txtHours.Text != string.Empty) { sqlstring += ";Insert Into ServiceAddHours(BookID,OldHours,AddHours,Worker,AddTime)values(" + RecordID + "," + decimal.Parse(textBox1.Text) / 100 + "," + decimal.Parse(txtHours.Text) / 100 + ",'" + comboBox1.Text + "','" + DateTime.Today.ToShortTimeString() + "')"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { DialogResult = DialogResult.OK; ClsBLL.AddMsg(RecordID, "车牌号码:" + this.Text + txtHours.Text + "TU--" + ClsBLL.UserName); this.Close(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { decimal addhours = 0; decimal newhours = 0; decimal starthours = 0; if (state == "中断" || state == "过时") { ClsBLL.ServicePauseStart(RecordID);//如果是中断则结束中断 } if (txtAddHours.Text != string.Empty) { addhours = decimal.Parse(txtAddHours.Text); addhours = decimal.Parse(addhours.ToString()) / 100; } newhours = addhours + decimal.Parse(txtHours.Text) / 100; //新的计划完成时间=当前时间+追加工时 starthours = ClsBLL.GetFactHours(RecordID); if (newhours > starthours) { starthours = newhours - starthours; //预计维修工时减实际做过 } DateTime plancompletetime = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(starthours * 60))); try { string sqlstring = "Update booking set State='维修进行中',StartServiceTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "',Worker='" + comboBox1.Text + "' ,ServiceHour=" + newhours + ",PlanCompleteTime='" + plancompletetime + "',Remark=isnull(Remark,'')+'," + this.Text + txtAddHours.Text + "TU' where ID=" + RecordID; if (txtAddHours.Text != string.Empty) { sqlstring += ";Insert Into ServiceAddHours(BookID,OldHours,AddHours,Worker,AddTime)values(" + RecordID + "," + decimal.Parse(txtHours.Text) / 100 + "," + decimal.Parse(txtAddHours.Text) / 100 + ",'" + comboBox1.Text + "','" + DateTime.Today.ToShortTimeString() + "')"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { DialogResult = DialogResult.OK; ClsBLL.AddMsg(RecordID, "车牌号码:" + this.Text + txtAddHours.Text + "TU--" + ClsBLL.UserName); this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void wbt_MouseUp(object sender, MouseEventArgs e) { if (!ClsBLL.IsPower("派工")) { MessageBox.Show("你没有权限派工!"); ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } if (IsMove) { decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - dataGridView1.ColumnHeadersHeight)); decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString()); Rowindex = int.Parse(decimal.Round(top / height, 0).ToString()); int left = ((Control)sender).Left; int startleft = dataGridView1.Columns[0].Width + dataGridView1.Columns[1].Width; Colindex = (left - startleft) / dataGridView1.Columns[2].Width; Colindex = Colindex + 2; if (top == 0 || left < dataGridView1.Columns[0].Width) { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } if (Rowindex == -1) { Rowindex = 0; } ((Control)sender).Top = Rowindex * dataGridView1.Rows[0].Height + dataGridView1.ColumnHeadersHeight; ((Control)sender).Left = (Colindex - 2) * dataGridView1.Columns[2].Width + startleft; try { if (Rowindex > -1) { if (((Control)sender).Name != string.Empty) { string sqlstring = string.Empty; DoubleClickButton bt = (DoubleClickButton)((Control)sender); //记录ID int recordid = int.Parse(bt.Name); string[] strinfo = bt.ImageKey.Split(new Char[] { ',' }); if (strinfo[1] == "延时到明天") { //延时到明天的单,第二天派工时确认追加工时,预计完成时间是当前时间加上追加工时 if (ClsBLL.GetFendanNum(recordid) > 1) { //如果有两张同时延时到明天的单,则进入分单界面。 frmServiceItem fsi = new frmServiceItem(recordid); if (fsi.ShowDialog() == DialogResult.OK) { 刷新ToolStripMenuItem_Click(null, null); } else { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } } else { frmAddHour2Day frmaddhour = new frmAddHour2Day(recordid); if (frmaddhour.ShowDialog() == DialogResult.OK) { ClsBLL.AddMsg(recordid, "车牌号码:" + strinfo[2] + ",派工给" + ClsBLL.GetWorker(recordid)); 刷新ToolStripMenuItem_Click(null, null); } else { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } } } else { //维修工时 decimal servicehours = ClsBLL.GetServiceHour(recordid); //维修工人 string serviceworker = dataGridView1.Rows[Rowindex].Cells[1].Value.ToString(); DateTime DtPlanComplete = DateTime.Now.AddMinutes(double.Parse(Convert.ToString(servicehours * 60))); 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='" + serviceworker + "',State='维修进行中' where ID=" + recordid; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ClsBLL.AddMsg(recordid, "车牌号码:" + strinfo[2] + ",派工给" + serviceworker); ClsBLL.ServicePauseStart(recordid); 刷新ToolStripMenuItem_Click(null, null); } } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } IsMove = false; }
private void bt_MouseUp(object sender, MouseEventArgs e) { if (IsMove) { if (((Control)sender).Tag.ToString() != "维修进行中" && ((Control)sender).Tag.ToString() != "中断") { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } decimal top = decimal.Parse(Convert.ToString(((Control)sender).Top - dataGridView1.ColumnHeadersHeight)); decimal height = decimal.Parse(dataGridView1.Rows[0].Height.ToString()); Rowindex = int.Parse(decimal.Round(top / height, 0).ToString()); if (Math.Abs(((Control)sender).Top - PcStartTop) < dataGridView1.Rows[2].Height / 2) { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } if (top == 0) { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } if (Rowindex == -1) { Rowindex = 0; } ((Control)sender).Top = Rowindex * dataGridView1.Rows[0].Height + dataGridView1.ColumnHeadersHeight; try { if (Rowindex > -1) { if (((Control)sender).Name != string.Empty) { //记录ID int recordid = int.Parse(((Control)sender).Name); //维修工时 decimal servicehours = ClsBLL.GetServiceHour(recordid); //维修工人 string serviceworker = dataGridView1.Rows[Rowindex].Cells[1].Value.ToString(); if (MessageBox.Show("你确定要把该单转给<" + serviceworker + ">做吗?", "", MessageBoxButtons.YesNo) == DialogResult.No) { ((Control)sender).Top = PcStartTop; ((Control)sender).Left = PcStartLeft; return; } DoubleClickButton bt = (DoubleClickButton)((Control)sender); string[] strs = bt.ImageKey.Split(new Char[] { ',' }); string startdate = strs[4]; //计划完成工作时间 = 开始工作时间 + 维修工时 string plancomplete = strs[5]; //预计完成时间 if (((Control)sender).Tag.ToString() == "中断") { ClsBLL.ServicePauseStart(recordid); plancomplete = DateTime.Parse(plancomplete).AddMinutes(ClsBLL.Pausemins(recordid, DateTime.Parse(startdate))).ToShortDateString(); } string sqlstring = "Insert Into BookingAdd(BookID,OldWorker,StartServiceTime)Select ID,Worker,StartServiceTime from Booking where ID=" + recordid; sqlstring += ";Update Booking Set StartServiceTime='" + DateTime.Now.ToString() + "',PlanCompleteTime='" + plancomplete + "', Worker='" + serviceworker + "',State='维修进行中' where ID=" + recordid; SQLDbHelper.ExecuteSql(sqlstring); ClsBLL.AddMsg(recordid, "车牌号码:" + strs[1] + ",该单转给<" + serviceworker + ">做"); 刷新ToolStripMenuItem_Click(null, null); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } IsMove = false; }