public static TabInfo ToTabInfo(DataRow row)
{
TabInfo tab = new TabInfo();
tab.billkey = (string)row["billkey"];
tab.checkTime = (string)row["checkTime"];
tab.createTime = (string)row["createTime"];
tab.custCount = (int)(row["custCount"]);
tab.envName = (string)row["envName"];
tab.startTime = (string)row["startTime"];
tab.status = (string)row["status"];
tab.tabName = (string)row["tabName"];
tab.id = (int)row["id"];
return tab;
}
public static void AddTabInfo(TabInfo tab)
{
string sql = "INSERT INTO `yooga`.`TabInfo`(`tabName`,`envName`,`status`,`createTime`,`startTime`,`checkTime`,`billkey`,`custCount`) VALUES (@tabName,@envName,@status,@createTime,@startTime,@checkTime,@billkey,@custCount)";
try
{
DbUtil.ExecuteNonQuery(sql,
new MySqlParameter("@tabName", tab.tabName),
new MySqlParameter("@envName", tab.envName),
new MySqlParameter("@status", tab.status),
new MySqlParameter("@createTime", tab.createTime),
new MySqlParameter("@startTime", tab.startTime),
new MySqlParameter("@checkTime", tab.checkTime),
new MySqlParameter("@billkey", tab.billkey),
new MySqlParameter("@custCount", tab.custCount));
}
catch (Exception ex)
{
throw new Exception("新增失败" + ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string envName = cbEnv.Text.Trim();
string tabName = tbTabName.Text.Trim();
if (tabName == "" || envName == "")
{
MessageBox.Show("餐桌名称和餐桌环境不能为空");
}
else
{
TabInfo tab = new TabInfo();
tab.billkey = "";
tab.checkTime = "";
tab.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
tab.custCount = 0;
tab.envName = envName;
tab.startTime = "";
tab.status = "空闲";
tab.tabName = tabName;
TabInfoService.AddTabInfo(tab);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
}