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