private void btnSelect_Click(object sender, EventArgs e)
{
string sql = "insert USERINFO(CustoNo,CustoName,CustoSex,CustoTel,PassportType,CustoID,CustoAdress,CustoBirth,CustoType)";
sql += " values('" + txtCustoNo.Text + "','" + txtCustoName.Text + "','" + cboSex.Text + "','" + txtTel.Text + "','" + cboPassport.SelectedIndex + "','" + txtCardID.Text + "','" + txtCustoAdress.Text + "','" + dtpBirthday.Value + "','" + cboCustoType.SelectedIndex + "') ";
MySqlConnection con = DBHelper.GetConnection();
con.Open();
int i = DBHelper.ExecuteNonQuery(sql);
Room r = new Room();
r.CheckTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
r.CustoNo = txtCustoNo.Text;
r.PersonNum = "1";
r.RoomStateId = 1;
r.RoomNo = dataGridView1.SelectedRows[0].Cells["clReserRoom"].Value.ToString();
int n = RoomManager.UpdateRoomInfo(r);
int j = ReserManager.DeleteReserInfo(dataGridView1.SelectedRows[0].Cells["clReserId"].Value.ToString());
MessageBox.Show("操作成功");
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = ReserManager.SelectReserAll();
//LoadCustomer();
foreach (Control Ctrol in gbCustoInfo.Controls)
{
if (Ctrol is TextBox)
{
Ctrol.Text = "";
}
}
con.Close();
}
private void FrmReserList_Load(object sender, EventArgs e)
{
CmpSetDgv();
cboCustoType.SelectedIndex = 0;
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = ReserManager.SelectReserAll();
}
