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