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 转为正式预约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 { frmCarTop fct = new frmCarTop(int.Parse(CureentCt.Name)); fct.Left = CureentCt.Left + 100; fct.Top = CureentCt.Top + panel1.Height + panel4.Height - 100; if (fct.ShowDialog() == DialogResult.OK) { int recordid = int.Parse(CureentCt.Name); //判断是否有两个类型预约 int doubleid = ClsBLL.GetDoubleID(recordid, DateTime.Parse(labDateTime.Text)); if (doubleid > -1) { foreach (Control ct in dataGridView1.Controls) { if (ct.Name == doubleid.ToString()) { ct.Tag = "正式"; ct.BackColor = Color.Blue; ct.ForeColor = Color.White; } } } CureentCt.Tag = "正式"; CureentCt.BackColor = Color.Blue; CureentCt.ForeColor = Color.White; try { DataTable DtTime = SQLDbHelper.Query("Select DelayBook,IsBook from Booking where ID=" + recordid).Tables[0]; if (DtTime.Rows.Count > 0) { if (DtTime.Rows[0]["IsBook"].ToString() == "0") { string txt = CureentCt.Text; CureentCt.Text = txt.Replace("预", "自"); CureentCt.Refresh(); } if (DtTime.Rows[0]["DelayBook"] != null && DtTime.Rows[0]["DelayBook"].ToString().IndexOf("迟到") > -1) { string txt = CureentCt.Text; CureentCt.Text = txt.Replace("预", "迟"); CureentCt.Text = txt.Replace("自", "迟"); CureentCt.Refresh(); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } catch (Exception Err) { MessageBox.Show(Err.Message); } } } } }