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