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 洗车ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt == null) { return; } DoubleClickButton bt = (DoubleClickButton)CureentCt; int recordid = int.Parse(bt.Name); string[] strs = bt.ImageKey.Split(new Char[] { ',' }); string 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() + "张分单未完工,不能洗车。"); return; } sqlstring = "Update A set A.State='洗车'"; sqlstring += " From Booking A,(Select CarNo,BookTime From Booking Where ID=" + recordid + ") B"; sqlstring += " Where A.CarNo=B.CarNo And Substring(convert(nvarchar(50),A.booktime,120),1,10)=substring(convert(nvarchar(50),B.booktime,120),1,10)"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ClsBLL.AddMsg(recordid, "车牌号码:" + strs[1] + ",洗车"); foreach (Control ct in dataGridView1.Controls) { if (ct.Text == bt.Text) { dataGridView1.Controls.Remove(ct); } } } }
private void label1_Click(object sender, EventArgs e) { if (MessageBox.Show("你确定要关闭系统吗?", "关闭系统", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (DateTime.Now.Hour > 16) { object obj = SQLDbHelper.ExecuteScalar("Select Position from Worker Where WorkerName='" + ClsBLL.UserName + "'"); if (obj != null) { string usergroup = obj.ToString(); if (usergroup == "主管") { string sqlstring = "Select count(*) from Booking Where StartServiceTime between '" + DateTime.Today.ToShortDateString() + "' and '" + DateTime.Now.ToString() + "' and ServiceType='" + ClsBLL.UserGroup + "' and State in ('中断','维修进行中','过时')"; int bills = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); if (bills > 0) { string message = "有" + bills.ToString() + "张单没有完成,请处理完之后再关闭系统!!!"; if (MessageBox.Show(message, "系统提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { ClsBLL.AddMsg(-1, message + "--" + ClsBLL.UserName); return; } } } } } this.Close(); } }
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 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 button1_Click(object sender, EventArgs e) { try { if (comboBox1.Text == string.Empty) { MessageBox.Show("请选择中断原因!"); return; } ClsBLL.AddServicePause(RecordID, Worker, comboBox1.Text); ClsBLL.AddMsg(RecordID, "车牌号码:" + CarNo + "维修中断,原因是" + comboBox1.Text + "--" + ClsBLL.UserName); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void button1_Click(object sender, EventArgs e) { string sqlstring = string.Empty; if (IntTag == 0) { sqlstring = "Update Booking set ParkSite='" + textBox1.Text + "' Where ID=" + RecordID; } else { sqlstring = "Update A set A.State='洗车',A.ParkSite='" + textBox1.Text + "',A.ClearCarTime='" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm") + "'"; sqlstring += " From Booking A,(Select CarNo,BookTime From Booking Where ID=" + RecordID + ") B"; sqlstring += " Where A.CarNo=B.CarNo And substring(convert(nvarchar(50),A.booktime,120),1,10)=substring(convert(nvarchar(50),B.booktime,120),1,10)"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { DialogResult = DialogResult.OK; } ClsBLL.AddMsg(RecordID, "车牌号码:" + CarNo + "现在开始洗车--" + ClsBLL.UserName); this.Close(); }
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; }
private void btnSave_Click(object sender, EventArgs e) { if (!CheckReg()) { return; } string sqlstring = string.Empty; if (IsUpdateParts) //配件部修改零件 { SaveParts(); return; } if (!CheckText()) { return; } DateTime BookTime = DateTime.Parse(dateTimePicker1.Value.ToShortDateString() + " " + numericUpDown1.Value.ToString() + ":" + numericUpDown2.Value.ToString()); int IsBook = 1; //if (!checkBox1.Visible) //按照设置的规则确定是预约来店还是自行来店 //{ // string hou = ClsBLL.GetSet("txtSet8"); // int hourset = 3; // if (hou != string.Empty) hourset = int.Parse(hou); // TimeSpan ts = BookTime.Subtract(DateTime.Now); // if (ts.Hours >= hourset) // { // checkBox1.Checked = true; // } // else // { // checkBox2.Checked = true; // } //} //if (checkBox2.Checked) IsBook = 0; int IsRemind = 0; int IsRemindSuc = 1; string RemindResult = string.Empty; if (chkIsRemind.Checked) { IsRemind = 1; if (radioButton2.Checked) { IsRemindSuc = 0; RemindResult = cmbRemindResult.Text; if (RemindResult == string.Empty) { MessageBox.Show("请选择提醒结果!"); return; } } } string sendservice = string.Empty; if (chkReCar.Checked) { sendservice = "代步车"; } if (chkRentCar.Checked) { sendservice += ",出租车"; } if (chkSend.Checked) { sendservice += ",接送"; } if (sendservice.StartsWith(",")) { sendservice = sendservice.Substring(1); } decimal RunKM = 0; if (txtRunKM.Text != string.Empty) { RunKM = decimal.Parse(txtRunKM.Text); } decimal servicehours = decimal.Parse(txtBookHour.Text) / 100; string sertype1 = string.Empty; string sertype2 = string.Empty; if (chkJD.Checked) { sertype1 = "机电维修"; if (RID == -1 && CheckExsit(sertype1)) { return; } } if (chkBJ.Checked) { sertype2 = "车身维修"; if (RID == -1 && CheckExsit(sertype2)) { return; } } int ID = -1; try { if (RID == -1) //新增 { int BookIndex = 0; decimal jdhour = servicehours; decimal cshour = servicehours; if (panWorkHours.Visible) { jdhour = decimal.Parse(txtJDHours.Text) / 100; cshour = decimal.Parse(txtCSHours.Text) / 100; } if (sertype1 != string.Empty) { sqlstring = "Insert Into Booking(BookIndex,BookTime,CarNo,CarType,ServiceItem,ServiceType,LinkMan,Tel,BookHour,ServiceHour,Creator,Remark,VIN,IsBook,IsRemind,IsRemindSuc,RemindResult,PreSA,RunKM,Email,SendService)"; sqlstring += "Values('" + BookIndex + "','" + BookTime + "','" + txtCarNo.Text + "','" + cmbCarType.Text + "'"; sqlstring += ",'" + txtServiceItem.Text + "','" + sertype1 + "','" + txtLinkMan.Text + "','" + txtTel.Text + "'," + jdhour + "," + jdhour + ",'" + ClsBLL.UserName + "','" + txtRemark.Text + "'"; sqlstring += ",'" + txtVIN.Text + "'," + IsBook + "," + IsRemind + "," + IsRemindSuc + ",'" + RemindResult + "'"; sqlstring += ",'" + cmbPreSA.Text + "'," + RunKM + ",'" + txtEmail.Text + "','" + sendservice + "')"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ID = int.Parse(SQLDbHelper.ExecuteScalar("Select Max(ID) as MaxID from Booking").ToString()); ClsBLL.AddSysLog(ID, "新增预约,车牌号码:" + txtCarNo.Text + ",维修类型:" + sertype1); AddCarHandle(ID); } } if (sertype2 != string.Empty) { sqlstring = "Insert Into Booking(BookIndex,BookTime,CarNo,CarType,ServiceItem,ServiceType,LinkMan,Tel,BookHour,ServiceHour,Creator,Remark,VIN,IsBook,IsRemind,IsRemindSuc,RemindResult,PreSA,RunKM,Email,SendService)"; sqlstring += "Values('" + BookIndex + "','" + BookTime + "','" + txtCarNo.Text + "','" + cmbCarType.Text + "'"; sqlstring += ",'" + txtServiceItem.Text + "','" + sertype2 + "','" + txtLinkMan.Text + "','" + txtTel.Text + "'," + cshour + "," + cshour + ",'" + ClsBLL.UserName + "','" + txtRemark.Text + "'"; sqlstring += ",'" + txtVIN.Text + "'," + IsBook + "," + IsRemind + "," + IsRemindSuc + ",'" + RemindResult + "'"; sqlstring += ",'" + cmbPreSA.Text + "'," + RunKM + ",'" + txtEmail.Text + "','" + sendservice + "')"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ID = int.Parse(SQLDbHelper.ExecuteScalar("Select Max(ID) as MaxID from Booking").ToString()); ClsBLL.AddSysLog(ID, "新增预约,车牌号码:" + txtCarNo.Text + ",维修类型:" + sertype2); AddCarHandle(ID); } } MessageBox.Show("新增成功!"); this.Close(); } else { //修改 string delay = string.Empty; //if (DateT.CompareTo(BookTime) != 0) delay = "延迟预约"; string updatesertype = sertype1; if (updatesertype == string.Empty) { updatesertype = sertype2; } //if (sertype1 != string.Empty && sertype2 != string.Empty) updatesertype = servicetypeold; if (updatesertype != servicetypeold) { if (CheckExsit(updatesertype)) { return; } } sqlstring = "Update Booking Set BookTime='" + BookTime + "',CarNo='" + txtCarNo.Text + "'"; sqlstring += ",CarType='" + cmbCarType.Text + "',ServiceItem='" + txtServiceItem.Text + "',ServiceType='" + updatesertype + "'"; sqlstring += ",LinkMan='" + txtLinkMan.Text + "',Tel='" + txtTel.Text + "',UpdateDate='" + DateTime.Now + "'"; sqlstring += ",DelayBook='" + delay + "',BookHour=" + servicehours + ",ServiceHour=" + servicehours + ",Remark=isnull(Remark,'')+'," + txtRemark.Text + "'"; sqlstring += ",VIN='" + txtVIN.Text + "',IsRemind=" + IsRemind + ",IsBook=" + IsBook; sqlstring += ",IsRemindSuc=" + IsRemindSuc + ",RemindResult='" + RemindResult + "',LastUpdate='" + ClsBLL.UserName + "'"; sqlstring += ",PreSA='" + cmbPreSA.Text + "',RunKM=" + RunKM + ",Email='" + txtEmail.Text + "',SendService='" + sendservice + "'"; sqlstring += " Where ID=" + RID; if (State == "失约" || State == "取消") { sqlstring += ";Update A Set A.State='预约' From Booking A,(Select CarNo,booktime From Booking Where ID=" + RID + ") B"; sqlstring += " Where A.CarNo=B.CarNo And substring(convert(nvarchar(50),A.booktime,120),1,10)=substring(convert(nvarchar(50),B.booktime,120),1,10)"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { int doubleid = ClsBLL.GetDoubleID(RID, BookTime); if (doubleid > -1) { //修改公共部分 sqlstring = "Update A Set A.BookTime='" + BookTime + "',A.CarNo='" + txtCarNo.Text + "'"; sqlstring += ",A.CarType='" + cmbCarType.Text + "',A.LinkMan='" + txtLinkMan.Text + "',A.Tel='" + txtTel.Text + "'"; sqlstring += ",A.DelayBook='" + delay + "',A.VIN='" + txtVIN.Text + "',A.IsRemind=" + IsRemind + ",A.IsBook=" + IsBook; sqlstring += ",A.IsRemindSuc=" + IsRemindSuc + ",A.RemindResult='" + RemindResult + "',A.LastUpdate='" + ClsBLL.UserName + "'"; sqlstring += ",A.PreSA='" + cmbPreSA.Text + "',A.RunKM=" + RunKM + ",A.Email='" + txtEmail.Text + "',A.SendService='" + sendservice + "'"; sqlstring += " From Booking A,(Select ID,CarNo,BookTime From Booking Where ID=" + RID + ") B"; sqlstring += " Where A.CarNo=B.CarNo And substring(convert(nvarchar(50),A.booktime,120),1,10)=substring(convert(nvarchar(50),B.booktime,120),1,10) And A.ID<>B.ID"; SQLDbHelper.ExecuteSql(sqlstring); } ClsBLL.AddSysLog(RID, "修改预约,车牌号码:" + txtCarNo.Text); //if (sertype1 != string.Empty && sertype2!=string.Empty) //{ //修改时增加维修类型 // string temptype = "机电维修"; // if (servicetypeold == "机电维修") // { // temptype = "车身维修"; // } // if (CheckExsit(temptype)) return; // sqlstring = "Insert Into Booking(BookIndex,booktime,carno,vin,cartype,linkman,tel,bookhour,servicehour,serviceitem,"; // sqlstring += "servicetype,state,CarTopNo,Creator,Createdate,Updatedate,Success,ComeTime,AssignTime,PlanOutTime,PlanCompleteTime,StartServiceTime,Remark,IsBook,IsRemind,IsRemindSuc,"; // sqlstring += "RemindResult,Receiver,LastUpdate,PreSA,RunKM,Email,SendService,PreParts,Parts)"; // sqlstring += "Select BookIndex,booktime,carno,vin,cartype,linkman,tel,bookhour,servicehour, serviceitem,"; // sqlstring += "'"+ temptype +"' as Servicetype,state,CarTopNo,Creator,Createdate,Updatedate,Success,ComeTime,AssignTime,PlanOutTime,PlanCompleteTime,StartServiceTime,Remark,IsBook,IsRemind,IsRemindSuc,"; // sqlstring += "RemindResult,Receiver,LastUpdate,PreSA,RunKM,Email,SendService,PreParts,Parts from booking where ID=" + RID; // SQLDbHelper.ExecuteSql(sqlstring); //} MessageBox.Show("修改成功!"); this.DialogResult = DialogResult.OK; } if (decimal.Parse(txtBookHour.Text) != bookhoursold * 100) { ClsBLL.AddMsg(RID, "车牌号码:" + txtCarNo.Text + "修改了预约维修工时。--" + ClsBLL.UserName); } } this.Close(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }