private void 取消预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { if (CureentCt.Tag.ToString() == "正式") { MessageBox.Show("预约状态是“正式”,不能转为正式!"); return; } if (MessageBox.Show("你确定取消该预约吗?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (CureentCt.Name != string.Empty) { try { int recordid = int.Parse(CureentCt.Name); string sqlstring = "Update Booking set State='取消',Success=0 where ID=" + recordid; SQLDbHelper.ExecuteSql(sqlstring); CureentCt.Tag = "取消"; CureentCt.BackColor = Color.Gray; int doubleid = ClsBLL.GetDoubleID(recordid, DateTime.Parse(labDateTime.Text)); if (doubleid > -1) { foreach (Control ct in dataGridView1.Controls) { if (ct.Name == doubleid.ToString()) { sqlstring = "Update Booking set State='取消',Success=0 where ID=" + doubleid; SQLDbHelper.ExecuteSql(sqlstring); ct.Tag = "取消"; ct.BackColor = Color.Gray; } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } }
private void 除预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { if (CureentCt.Tag.ToString() == "正式") { MessageBox.Show("预约状态是“正式”,不能转为正式!"); return; } if (MessageBox.Show("你确定删除该预约吗?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (CureentCt.Name != string.Empty) { try { int recordid = int.Parse(CureentCt.Name); string sqlstring = "Delete from Booking where ID=" + recordid; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { dataGridView1.Controls.Remove(CureentCt); } int doubleid = ClsBLL.GetDoubleID(recordid, DateTime.Parse(labDateTime.Text)); if (doubleid > -1) { foreach (Control ct in dataGridView1.Controls) { if (ct.Name == doubleid.ToString()) { sqlstring = "Delete From Booking where ID=" + doubleid; dataGridView1.Controls.Remove(ct); } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } }
private void 转为正式预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { if (CureentCt.Tag.ToString() == "正式") { MessageBox.Show("预约状态是“正式”,不能转为正式!"); return; } if (MessageBox.Show("你确定执行提交预约吗?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (CureentCt.Name != string.Empty) { try { frmCarTop fct = new frmCarTop(int.Parse(CureentCt.Name)); fct.Left = CureentCt.Left + 100; fct.Top = CureentCt.Top + panel1.Height + panel4.Height - 100; if (fct.ShowDialog() == DialogResult.OK) { int recordid = int.Parse(CureentCt.Name); //判断是否有两个类型预约 int doubleid = ClsBLL.GetDoubleID(recordid, DateTime.Parse(labDateTime.Text)); if (doubleid > -1) { foreach (Control ct in dataGridView1.Controls) { if (ct.Name == doubleid.ToString()) { ct.Tag = "正式"; ct.BackColor = Color.Blue; ct.ForeColor = Color.White; } } } CureentCt.Tag = "正式"; CureentCt.BackColor = Color.Blue; CureentCt.ForeColor = Color.White; try { DataTable DtTime = SQLDbHelper.Query("Select DelayBook,IsBook from Booking where ID=" + recordid).Tables[0]; if (DtTime.Rows.Count > 0) { if (DtTime.Rows[0]["IsBook"].ToString() == "0") { string txt = CureentCt.Text; CureentCt.Text = txt.Replace("预", "自"); CureentCt.Refresh(); } if (DtTime.Rows[0]["DelayBook"] != null && DtTime.Rows[0]["DelayBook"].ToString().IndexOf("迟到") > -1) { string txt = CureentCt.Text; CureentCt.Text = txt.Replace("预", "迟"); CureentCt.Text = txt.Replace("自", "迟"); CureentCt.Refresh(); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } 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); } }