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