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);
}
}