//修改配件 private void SaveParts() { string preparts = string.Empty; if (chkParts1.Checked) { preparts = chkParts1.Text; } if (chkParts2.Checked) { preparts = chkParts2.Text; } if (chkParts3.Checked) { preparts = chkParts3.Text; } if (preparts == string.Empty) { MessageBox.Show("请选择零件准备情况!"); return; } string sqlstring = "Update A set A.Parts='" + txtParts.Text + "',A.PreParts='" + preparts + "'"; sqlstring += " 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) { ClsBLL.AddSysLog(RID, "修改预约零件准备情况,车牌号码:" + txtCarNo.Text); this.DialogResult = DialogResult.OK; this.Close(); } }
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 (string.IsNullOrEmpty(cmbPreSA.Text)) { MessageBox.Show("接车人不能为空。"); return; } string sqlstring = "Update A set A.CarTopNo='" + textBox1.Text + "',A.Receiver='" + cmbPreSA.Text + "',A.PlanOutTime='" + dateTimePicker1.Text + " " + numericUpDown1.Value.ToString() + ":" + numericUpDown2.Value.ToString() + "'"; sqlstring += " ,State='正式',Success=1,ComeTime='" + DateTime.Now.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)"; try { if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { SQLDbHelper.ExecuteSql("Exec Sp_SetIsBook"); ClsBLL.AddSysLog(RecordID, "预约接车,车牌号码:" + SQLDbHelper.ExecuteScalar("Select CarNo from Booking Where ID=" + RecordID).ToString()); this.DialogResult = DialogResult.OK; } this.Close(); } catch (Exception Err) { MessageBox.Show(Err.Message); } }
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); } }