//修改配件
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);
}
}
