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 完工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 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 (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 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;
}
