private void frmWork_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
label1.Text = DateTime.Now.ToString("yyyy年MM月dd日");
starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1"));
endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2"));
TimeSpan ts = endtime.Subtract(starttime);
int cols = ts.Hours;
if (ts.Minutes > 0)
{
cols++;
}
for (int i = 0; i <= cols; i++)
{
DateTime NewDt = starttime.AddHours(i);
dataGridView1.Columns.Add("Col" + NewDt.Hour.ToString(), NewDt.Hour.ToString() + ":00");
dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}
ShowGrid();
int Interval = int.Parse(ClsBLL.GetSet("txtSet4"));
timer1.Interval = Interval * 1000 * 60;
timer1.Enabled = true;
CheckPower();
}
private void CheckPower()
{
if (!ClsBLL.IsPower(button1.Text))
{
button1.Enabled = false;
}
if (!ClsBLL.IsPower(button2.Text))
{
button2.Enabled = false;
}
if (!ClsBLL.IsPower("删除预约"))
{
除预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("取消预约"))
{
取消预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("预约转正式"))
{
转为正式预约ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("更改预约时间"))
{
更改预约时间ToolStripMenuItem.Visible = false;
}
}
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 label1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("你确定要关闭系统吗？", "关闭系统", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (DateTime.Now.Hour > 16)
{
object obj = SQLDbHelper.ExecuteScalar("Select Position from Worker Where WorkerName='" + ClsBLL.UserName + "'");
if (obj != null)
{
string usergroup = obj.ToString();
if (usergroup == "主管")
{
string sqlstring = "Select count(*) from Booking Where StartServiceTime between '" + DateTime.Today.ToShortDateString() + "' and '" + DateTime.Now.ToString() + "' and ServiceType='" + ClsBLL.UserGroup + "' and State in ('中断','维修进行中','过时')";
int bills = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString());
if (bills > 0)
{
string message = "有" + bills.ToString() + "张单没有完成，请处理完之后再关闭系统！！！";
if (MessageBox.Show(message, "系统提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
ClsBLL.AddMsg(-1, message + "--" + ClsBLL.UserName);
return;
}
}
}
}
}
this.Close();
}
}
private void 洗车ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (CureentCt == null)
{
return;
}
DoubleClickButton bt = (DoubleClickButton)CureentCt;
int recordid = int.Parse(bt.Name);
string[] strs = bt.ImageKey.Split(new Char[] { ',' });
string 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() + "张分单未完工，不能洗车。");
return;
}
sqlstring = "Update A set A.State='洗车'";
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)";
if (SQLDbHelper.ExecuteSql(sqlstring) > 0)
{
ClsBLL.AddMsg(recordid, "车牌号码:" + strs[1] + ",洗车");
foreach (Control ct in dataGridView1.Controls)
{
if (ct.Text == bt.Text)
{
dataGridView1.Controls.Remove(ct);
}
}
}
}
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 (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)
{
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 中断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 frmSelectBook_Load(object sender, EventArgs e)
{
this.Width = Screen.PrimaryScreen.WorkingArea.Width * 8 / 10;
this.Height = Screen.PrimaryScreen.WorkingArea.Height * 8 / 10;
this.Left = Screen.PrimaryScreen.WorkingArea.Width / 10;
this.Top = Screen.PrimaryScreen.WorkingArea.Height * 17 / 100;
this.Text = SelectDt.ToString("yyyy年MM月dd日") + "预约情况";
starttime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet1"));
endtime = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " " + ClsBLL.GetSet("txtSet2"));
TimeSpan ts = endtime.Subtract(starttime);
int cols = ts.Hours * 2;
if (ts.Minutes > 0)
{
cols++;
}
dataGridView1.Rows.Add(cols + 1);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DateTime NewDt = starttime.AddMinutes(i * 30);
dataGridView1.Rows[i].Cells[0].Value = NewDt.Hour.ToString() + ":" + NewDt.Minute.ToString().PadRight(2, char.Parse("0"));
dataGridView1.Rows[i].Height = dataGridView1.Height / dataGridView1.Rows.Count;
}
dataGridView1.Columns[1].Width = dataGridView1.Width * 6 / 10;
ShowGrid1(SelectDt);
}
private void txtHours_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != char.Parse("."))
{
ClsBLL.Key_Number(e);
}
}
//修改配件
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 frmPause_Load(object sender, EventArgs e)
{
ClsBLL.IniCombox(comboBox1, "中断原因");
DataTable Dt = SQLDbHelper.Query("Select Worker,CarNo from Booking Where ID=" + RecordID).Tables[0];
CarNo = Dt.Rows[0]["CarNo"].ToString();
Worker = Dt.Rows[0]["Worker"].ToString();
this.Text = CarNo + "中断";
}
private void frmCarStateBoad_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
labDateTime.Text = DateTime.Today.ToString("yyyy年MM月dd日");
ClsBLL.IniCombox(comboBox1, "中断原因");
dataGridView1.Rows.Add((dataGridView1.Height - dataGridView1.ColumnHeadersHeight) / dataGridView1.RowTemplate.Height);
string sqlstring = "Select Items from SysDictionary where ItemName='SA'";
DataTable Dt2 = SQLDbHelper.Query(sqlstring).Tables[0];
cmbReceiver.Items.Add("--全部--");
foreach (DataRow dr in Dt2.Rows)
{
cmbReceiver.Items.Add(dr[0].ToString());
}
ShowGrid(string.Empty);
//dataGridView1.BackgroundColor = Color.PaleTurquoise;
dataGridView1.ClearSelection();
int Interval = int.Parse(ClsBLL.GetSet("txtSet5"));
timer1.Interval = Interval * 1000 * 60;
timer1.Enabled = true;
if (!ClsBLL.IsPower(btnToday.Text))
{
btnToday.Enabled = false;
}
if (!ClsBLL.IsPower(btnMonth.Text))
{
btnMonth.Enabled = false;
}
pn0.Left = (dataGridView1.Columns[0].Width - pn0.Width) / 2;
pn1.Left = (dataGridView1.Columns[1].Width - pn1.Width) / 2 + dataGridView1.Columns[0].Width * 1;
pn2.Left = (dataGridView1.Columns[2].Width - pn2.Width) / 2 + dataGridView1.Columns[0].Width * 2;
pn3.Left = (dataGridView1.Columns[3].Width - pn3.Width) / 2 + dataGridView1.Columns[0].Width * 3;
pn4.Left = (dataGridView1.Columns[4].Width - pn4.Width) / 2 + dataGridView1.Columns[0].Width * 4;
pn0.Controls.Add(pic0Down);
pic0Down.Top = pic0Up.Top;
if (!ClsBLL.IsPower("追加项目"))
{
追加项目ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("返修"))
{
返修ToolStripMenuItem.Visible = false;
}
if (!ClsBLL.IsPower("修改状态"))
{
修改状态ToolStripMenuItem.Visible = false;
}
}
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 CheckPower()
{
if (!ClsBLL.IsPower(btnWork.Text))
{
btnWork.Enabled = false;
}
if (!ClsBLL.IsPower(btnCarState.Text))
{
btnCarState.Enabled = false;
}
}
private void bt_DoubleClick(object sender, EventArgs e)
{
if (!ClsBLL.IsPower("查看维修信息"))
{
MessageBox.Show("你没有权限查看维修信息！");
return;
}
DoubleClickButton bt = (DoubleClickButton)((Control)sender);
frmBookLook fbn = new frmBookLook(int.Parse(bt.Name));
fbn.ShowDialog();
}
private void btnToday_Click(object sender, EventArgs e)
{
if (!ClsBLL.CheckFormIsOpen("frmBooking"))
{
frmBooking fcsb = new frmBooking();
fcsb.Show();
}
else
{
Form frm = Application.OpenForms["frmBooking"];
frm.Focus();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!ClsBLL.CheckFormIsOpen("frmWork"))
{
frmWork fw = new frmWork();
fw.Show();
}
else
{
Form frm = Application.OpenForms["frmWork"];
frm.Focus();
}
}
private void button2_Click(object sender, EventArgs e)
{
if (!ClsBLL.CheckFormIsOpen("frmCarStateBoad"))
{
frmCarStateBoad fcsb = new frmCarStateBoad();
fcsb.Show();
}
else
{
Form frm = Application.OpenForms["frmCarStateBoad"];
frm.Focus();
}
}
private void wbt_DoubleClick(object sender, EventArgs e)
{
if (!ClsBLL.IsPower("分单"))
{
return;
}
DoubleClickButton bt = (DoubleClickButton)((Control)sender);
frmServiceItem fsi = new frmServiceItem(int.Parse(bt.Name));
if (fsi.ShowDialog() == DialogResult.OK)
{
刷新ToolStripMenuItem_Click(null, null);
}
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
if (ClsBLL.CarBookRecord(textBox1.Text))
{
frmBookLook fbn = new frmBookLook(textBox1.Text);
fbn.Show();
}
else
{
MessageBox.Show("没有车牌号为“" + textBox1.Text + "”预约信息！");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (IsEdit)
{
ClsBLL.SaveItem(treeView3);
MessageBox.Show("保存成功！");
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message + Err.StackTrace.Substring(Err.StackTrace.IndexOf("行号")));
}
}
private void button1_Click(object sender, EventArgs e)
{
string sqlstring = "Select UserName from SysUser where UserID='" + textBox1.Text + "' and Pwd='" + textBox2.Text + "'";
try
{
object obj = SQLDbHelper.ExecuteScalar(sqlstring);
if (obj == null)
{
MessageBox.Show("用户名不存在或者密码错误！");
textBox1.Focus();
return;
}
else
{
//将计算机名称保存到数据库中
if (int.Parse(SQLDbHelper.ExecuteScalar("Select count(*) from VersionUser where Computer='" + Environment.MachineName + "'").ToString()) == 0)
{
SQLDbHelper.ExecuteSql("Insert into VersionUser(Computer,Ver)values('" + Environment.MachineName + "',0)");
}
else
{
int userver = int.Parse(SQLDbHelper.ExecuteScalar("Select ver from VersionUser where Computer='" + Environment.MachineName + "'").ToString());
int sysver = int.Parse(SQLDbHelper.ExecuteScalar("Select ver from VersionSys").ToString());
if (userver < sysver)
{
if (MessageBox.Show("软件有新的版本可以升级！你需要升级吗？", "软件升级", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SQLDbHelper.ExecuteSql("Update VersionUser Set Ver=" + sysver + " where Computer='" + Environment.MachineName + "'");
System.Diagnostics.Process.Start(Application.StartupPath + @"\Update.exe");
Application.Exit();
}
}
}
ClsBLL.UserID = textBox1.Text;
ClsBLL.UserName = obj.ToString();
ClsBLL.UserGroup = ClsBLL.GetUserGroup(ClsBLL.UserName);
AppConfig.ConfigSetValue(Application.ExecutablePath, "LastUserID", textBox1.Text);
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 frmReport_Load(object sender, EventArgs e)
{
this.Top = 0;
this.Left = 0;
this.Width = Screen.PrimaryScreen.WorkingArea.Width;
this.Height = Screen.PrimaryScreen.WorkingArea.Height;
sqlstring = @"select distinct cast(datepart(yy,EndServiceTime) as nvarchar(50)) + '年'+ cast(datepart(MM,EndServiceTime) as nvarchar(50)) + '月' as 年月 from Booking
where EndServiceTime is not null order by 年月 desc";
CmbDt = SQLDbHelper.Query(sqlstring).Tables[0];
foreach (Control ct in this.panel2.Controls)
{
if (ct.Name.StartsWith("btnRt"))
{
if (!ClsBLL.IsPower(ct.Text))
{
ct.Enabled = false;
}
}
}
if (!ClsBLL.IsPower("工单明细"))
{
btnQuery.Enabled = false;
button10.Enabled = false;
button20.Enabled = false;
button21.Enabled = false;
button22.Enabled = false;
button23.Enabled = false;
}
if (!ClsBLL.IsPower("异常单查询"))
{
button20.Enabled = false;
}
if (!ClsBLL.IsPower("修改状态"))
{
button21.Enabled = false;
}
if (!ClsBLL.IsPower("操作日志"))
{
button22.Enabled = false;
}
if (!ClsBLL.IsPower("删除工单"))
{
button23.Enabled = false;
}
}
//检查是否已经存在
private bool CheckExsit()
{
DateTime BookTime = DateTime.Parse(dateTimePicker1.Value.ToShortDateString() + " " + numericUpDown1.Value.ToString() + ":" + numericUpDown2.Value.ToString());
string sqlstring = "Select count(*) from Booking where (VIN='" + txtVIN.Text + "' Or CarNo='" + txtCarNo.Text + "') and Booktime between '" + BookTime.ToShortDateString() + "' and '" + BookTime.AddDays(1).ToShortDateString() + "'";
try
{
if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) > 0)
{
if (MessageBox.Show("车牌号：" + txtCarNo.Text + "或者车架号: " + txtVIN.Text + " 在" + BookTime.ToShortDateString() + "已经预约过！你还要增加吗？", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
return(true);
}
else
{
string stype = "车身维修";
if (chkJD.Checked)
{
stype = "机电维修";
}
sqlstring = "Select count(*) from Booking where (VIN='" + txtVIN.Text + "' Or CarNo='" + txtCarNo.Text + "') and Booktime between '" + BookTime.ToShortDateString() + "' and '" + BookTime.AddDays(1).ToShortDateString() + "' And Servicetype='" + stype + "'";
if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) > 0)
{
MessageBox.Show("车牌号：" + txtCarNo.Text + "或者车架号: " + txtVIN.Text + " 在" + BookTime.ToShortDateString() + "已经预约过同类型的维修,不能预约");
return(true);
}
}
}
sqlstring = "Select Count(*) from Booking where booktime='" + BookTime + "' and ServiceType='" + ServiceType + "'";
int rs = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString());
int maxnum = int.Parse(ClsBLL.GetSet("txtSet6"));
if (rs > maxnum)
{
MessageBox.Show("在同一时间点只能预约" + maxnum + "辆车！");
return(true);
}
return(false);
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
return(false);
}
}
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 dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (!ClsBLL.IsPower("新增预约"))
{
MessageBox.Show("你没有权限新增预约！");
return;
}
Colindex = e.ColumnIndex;
Rowindex = e.RowIndex;
if (e.RowIndex < 1)
{
return;
}
DateTime Date1 = DateTime.Parse(label1.Text);
DateTime Date2;
string cellval = dataGridView1.Rows[Rowindex].Cells[0].Value.ToString();
//if (Rowindex == dataGridView1.Rows.Count)
//{
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
//}
//else
//{
// if (dataGridView1.Rows[Rowindex - 1].Cells[0].Value.ToString() == cellval)
// {
// Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval).AddMinutes(30);
// }
// else
// {
Date2 = DateTime.Parse(Date1.ToString("yyyy-MM-dd") + " " + cellval);
// }
//}
if (Date2.CompareTo(DateTime.Now) > 0)
{
frmBookNew fm3 = new frmBookNew(Date2, dataGridView1.Columns[e.ColumnIndex].HeaderText);
fm3.AddCarHandle += new frmBookNew.AddCar(AddCarCard);
fm3.UpdateCardHoursdHandle += new frmBookNew.UpdateCardHours(SumWorkHours);
fm3.Show();
}
else
{
MessageBox.Show("选择的预约时间不能小于当前时间！");
}
}
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);
}
}
}
}
}
