private void 取消预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { if (CureentCt.Tag.ToString() != "预约") { MessageBox.Show("改预约状态是“" + CureentCt.Tag.ToString() + "”,不能取消!"); 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; } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } }
private void 转为正式预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { if (CureentCt.Tag.ToString() != "预约") { MessageBox.Show("改预约状态是“" + CureentCt.Tag.ToString() + "”,不能转为正式!"); 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; fct.ShowDialog(); int recordid = int.Parse(CureentCt.Name); string sqlstring = "Update Booking set State='正式',Success=1,ComeTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' where ID=" + recordid; SQLDbHelper.ExecuteSql(sqlstring); CureentCt.Tag = "正式"; CureentCt.BackColor = Color.Blue; } 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); } }
public static void AddMsg(int bookid, string msg) { string sqlstring = "Insert Into UpdateMsg(BookID,Message,Creator)Values(" + bookid + ",'" + msg + "','" + ClsBLL.UserName + "')"; sqlstring += ";Insert Into SysLog(BookID,Message,Creator)Values(" + bookid + ",'" + msg + "','" + ClsBLL.UserName + "')"; SQLDbHelper.ExecuteSql(sqlstring); }
private void 除预约ToolStripMenuItem_Click(object sender, EventArgs e) { if (CureentCt != null) { 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); } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } }
private void button23_Click(object sender, EventArgs e) { if (MessageBox.Show("你确定要删除吗?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (gcRo.Visible) { if (gridView1.GetRowCellValue(selectrow, "完工时间") != null && gridView1.GetRowCellValue(selectrow, "完工时间").ToString() != string.Empty) { MessageBox.Show("该单已经完工不能删除!"); return; } } string sqlstring = "Delete from Booking Where ID=" + recordid + ";Delete from BookingAdd Where BookID=" + recordid + ";Delete from DelayService Where BookID=" + recordid; sqlstring += ";Delete from ServiceAddHours Where BookID=" + recordid + ";Delete from ServicePause Where BookID=" + recordid; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { if (gcRo.Visible) { gridView1.DeleteRow(selectrow); } else { gridView22.DeleteRow(selectrow); } } } }
/// <summary> /// 维修中断记录 /// </summary> public static void AddServicePause(int id, string worker, string reason) { string sqlstring = "Insert ServicePause(BookID,PauseTime,Reason,Worker) values (" + id + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "','" + reason + "','" + worker + "')"; sqlstring += ";Update Booking Set State='中断' Where ID=" + id; SQLDbHelper.ExecuteSql(sqlstring); }
private void btnSaveUser_Click(object sender, EventArgs e) { if (txtUserID.Text == string.Empty || txtUserName.Text == string.Empty) { MessageBox.Show("用户名或用户密码不能为空!"); return; } sqlstring = "Select Count(*) from SysUser where UserID='" + txtUserID.Text + "'"; if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) > 0) { MessageBox.Show(txtUserID.Text + "已经存在!"); return; } sqlstring = "Insert into SysUser(UserID,UserName,Pwd)values('" + txtUserID.Text + "','" + txtUserName.Text + "','" + txtPwd.Text + "')"; if (!txtUserID.Enabled) { sqlstring = "Update SysUser Set UserName='******',Pwd='" + txtPwd.Text + "' Where UserID='" + txtUserID.Text + "'"; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { MessageBox.Show("新增用户成功!"); TreeNode tn = new TreeNode(); tn.Text = txtUserName.Text + "(" + txtUserID.Text + ")"; tn.Tag = txtUserID.Text; treeView1.Nodes[0].Nodes.Add(tn); txtPwd.Text = string.Empty; txtUserID.Text = string.Empty; txtUserName.Text = string.Empty; } }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { try { int val = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } catch { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "0"; } string workercode = dataGridView1.Rows[e.RowIndex].Cells[0].Tag.ToString(); string day = dataGridView1.Columns[e.ColumnIndex].Tag.ToString(); string sqlstring = "Update WorkerPlan Set WorkDay=" + int.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()) + " where WorkerCode='" + workercode + "' And Wyear=" + DateTime.Today.Year + " and Wmonth=" + nUDMonth.Value + " And Wday=" + day; sqlstring += ";Update WorkerPlan Set IsWork=0 where WorkDay=0 And WorkerCode='" + workercode + "' And Wyear=" + DateTime.Today.Year + " and Wmonth=" + nUDMonth.Value + " And Wday=" + day; SQLDbHelper.ExecuteSql(sqlstring); if (int.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()) < 8) { DataGridViewCellStyle dgvct = new DataGridViewCellStyle(); dgvct.ForeColor = Color.Red; dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Style = dgvct; } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void AddWorkerPlan() { try { DataTable Dt = SQLDbHelper.Query("Select * from Worker Where WorkerCode not in (Select WorkerCode from WorkerPlan)").Tables[0]; for (int i = 2009; i < 2013; i++) { for (int j = 1; j < 13; j++) { for (int d = 1; d < 32; d++) { string sqlstring = ""; for (int m = 0; m < Dt.Rows.Count; m++) { sqlstring += ";Insert into WorkerPlan(Wyear,Wmonth,Wday,workercode)values(" + i + "," + j + "," + d + ",'" + Dt.Rows[m]["WorkerCode"].ToString() + "')"; } if (sqlstring.Length > 1) { SQLDbHelper.ExecuteSql(sqlstring.Substring(1)); } } } } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
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 洗车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; 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 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 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 (textBox2.Text != textBox3.Text) { MessageBox.Show("确认密码不对!"); return; } string sqlstring = "Select count(*) from SysUser where UserID='" + ClsBLL.UserID + "' and Pwd='" + textBox1.Text + "'"; try { if (int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()) == 0) { MessageBox.Show("原密码错误!"); textBox1.Text = string.Empty; textBox1.Focus(); return; } sqlstring = "Update SysUser Set Pwd='" + textBox2.Text + "' Where UserID='" + ClsBLL.UserID + "'"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { MessageBox.Show("修改成功!"); this.Close(); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
private void btnSavePower_Click(object sender, EventArgs e) { if (treeView1.SelectedNode.Tag != null) { string userid = treeView1.SelectedNode.Tag.ToString(); string sqlstring = "Delete from SysPower where UserID='" + userid + "'"; bool chilrencheck = false; for (int i = 0; i < treeView2.Nodes[0].Nodes.Count; i++) { for (int j = 0; j < treeView2.Nodes[0].Nodes[i].Nodes.Count; j++) { if (treeView2.Nodes[0].Nodes[i].Nodes[j].Checked) { sqlstring += ";Insert Into SysPower(UserID,FunID)values('" + userid + "'," + int.Parse(treeView2.Nodes[0].Nodes[i].Nodes[j].Tag.ToString()) + ")"; chilrencheck = true; } } if (chilrencheck) { sqlstring += ";Insert Into SysPower(UserID,FunID)values('" + userid + "'," + int.Parse(treeView2.Nodes[0].Nodes[i].Tag.ToString()) + ")"; } chilrencheck = false; } if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { MessageBox.Show("保存成功!"); } } }
private void button2_Click(object sender, EventArgs e) { string sqlstring = string.Empty; string wherestr = "'ComeType'"; sqlstring = "Insert Into Setting(KeyWord,KeyWord_Value) Values('ComeType','" + Convert.ToInt16(chkComeType.Checked).ToString() + "')"; foreach (Control ct in tabPage3.Controls) { if (ct.Name.StartsWith("txtSet")) { wherestr += ",'" + ct.Name + "'"; string val = ct.Text; if (val == string.Empty) { val = "0"; } sqlstring += ";Insert Into Setting(KeyWord,KeyWord_Value) Values('" + ct.Name + "','" + val + "')"; } } if (sqlstring.Length > 1) { sqlstring = "Delete from Setting where KeyWord in (" + wherestr + ");" + sqlstring; try { SQLDbHelper.ExecuteSql(sqlstring); MessageBox.Show("保存成功!"); } catch (Exception Err) { MessageBox.Show(Err.Message); } } }
//修改配件 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(); } }
/// <summary> /// 批量保存系统词典 /// </summary> /// <returns></returns> public static void SaveItem(System.Windows.Forms.TreeView treeView) { DataTable Dt = null; string sqlstr = null; try { Dt = new DataTable(); DataSet ds = new DataSet(); sqlstr = "select * from SysDictionary where 1=0"; ds = SQLDbHelper.Query(sqlstr); Dt = ds.Tables[0]; for (int i = 0; i < treeView.Nodes[0].Nodes.Count; i++) { for (int j = 0; j < treeView.Nodes[0].Nodes[i].Nodes.Count; j++) { DataRow Dr = Dt.NewRow(); Dr["ItemName"] = treeView.Nodes[0].Nodes[i].Text; Dr["Items"] = treeView.Nodes[0].Nodes[i].Nodes[j].Text; Dt.Rows.Add(Dr); } } SQLDbHelper.ExecuteSql("Delete from SysDictionary"); SQLDbHelper.UpdateTable(ds, sqlstr); } catch (Exception Err) { throw Err; } finally { //DbHelperSQL._connection.Close(); //Member.Common.DbHelper._connection.Close(); } }
private void ÐݼÙToolStripMenuItem_Click(object sender, EventArgs e) { if (CurWorkerCode > -1) { string sqlstring = "Update WorkerPlan Set IsWork=0,WorkDay=0 Where WorkerCode=" + CurWorkerCode + " And Wyear=" + dateTimePicker1.Value.Year + " and Wmonth=" + dateTimePicker1.Value.Month + " and Wday=" + dateTimePicker1.Value.Day + ""; SQLDbHelper.ExecuteSql(sqlstring); dataGridView1.SelectedRows[0].Cells["ColWorkDay"].Value = 0; } }
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 除用户ToolStripMenuItem_Click(object sender, EventArgs e) { if (treeView1.SelectedNode.Nodes.Count == 0) { sqlstring = "Delete from SysUser where UserID='" + treeView1.SelectedNode.Tag.ToString() + "'"; sqlstring += ";Delete from SysPower Where UserID='" + treeView1.SelectedNode.Tag.ToString() + "'"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { treeView1.Nodes[0].Nodes.Remove(treeView1.SelectedNode); } } }
private void frmMsg_Load(object sender, EventArgs e) { this.Left = Screen.PrimaryScreen.WorkingArea.Width - this.Width; this.Top = Screen.PrimaryScreen.WorkingArea.Height - this.Height; string sqlstring = "Insert Into UserMsg(UserName,MsgID)values('" + ClsBLL.UserName + "'," + MsgID + ")"; try { SQLDbHelper.ExecuteSql(sqlstring); } catch { } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { string workercode = dataGridView1.SelectedRows[0].Cells["Column3"].Value.ToString(); try { if (SQLDbHelper.ExecuteSql("Delete from Worker where Workercode='" + workercode + "'") > 0) { dataGridView1.Rows.Remove(dataGridView1.SelectedRows[0]); } } catch (Exception Err) { MessageBox.Show(Err.Message); } }
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 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 取消预约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 button1_Click(object sender, EventArgs e) { if (comboBox1.Text == string.Empty || textBox1.Text == string.Empty || textBox2.Text == string.Empty || textBox3.Text == string.Empty) { MessageBox.Show("请填写完整!"); return; } if (textBox1.Enabled) { string sqlstring = "Select count(*) from Worker where WorkerCode='" + textBox1.Text + "'"; int rs = int.Parse(SQLDbHelper.ExecuteScalar(sqlstring).ToString()); if (rs > 0) { MessageBox.Show("工号:" + textBox1.Text + "已经存在!"); return; } sqlstring = "Insert Into Worker(WorkerGroup,WorkerCode,WorkerName,Position,HourRate) values('" + comboBox1.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + comboBox2.Text + "'," + textBox3.Text + ")"; try { SQLDbHelper.ExecuteSql(sqlstring); MessageBox.Show("保存成功!"); ShowGrid(); textBox1.Text = string.Empty; textBox2.Text = string.Empty; //AddWorkerPlan(); } catch (Exception Err) { MessageBox.Show(Err.Message); } } else //修改 { string sqlstring = "Update Worker Set WorkerGroup='" + comboBox1.Text + "',WorkerName='" + textBox2.Text + "',HourRate=" + textBox3.Text + ",Position='" + comboBox2.Text + "' Where WorkerCode='" + textBox1.Text + "'"; if (SQLDbHelper.ExecuteSql(sqlstring) > 0) { ShowGrid(); textBox1.Text = string.Empty; textBox2.Text = string.Empty; textBox3.Text = "1"; } } }