private void DeleteRegisterRoom(int room_num)
{
SqlConnection sql_connection = main_window.Sqlcon();
try
{
sql_connection.Open();
string commandStr = $"delete register where 房间号='{room_num}'";
SqlCommand sql_command = new SqlCommand(commandStr, sql_connection);
sql_command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sql_connection.Close();
}
}
private void AddRetister()
{
SqlConnection sql_connection = main_window.Sqlcon();
try
{
sql_connection.Open();
string commandStr = "insert register (房间号,房间类型,入住人,身份证号,联系方式,交易码,实收,房间状态,入住时间,备注)values" +
$"('{Convert.ToInt32(tbLiveInNum.Text)}','{cbLiveInType.Text}','{tbLiveInName.Text}','{tbLiveInId.Text}'," +
$"'{tbLiveInTel.Text}','{tbLiveInSign.Text}','{Convert.ToDecimal(tbLiveInIncome.Text)}'," +
$"'{cbLiveInStatus.Text}','{DateTime.Now}','{tbLiveInRemark.Text}')";
SqlCommand sql_command = new SqlCommand(commandStr, sql_connection);
sql_command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sql_connection.Close();
}
}
public DataSet CheckAccountValue()
{
SqlConnection sql_connection = main_window.Sqlcon();
DataSet data_set = new DataSet();
try
{
sql_connection.Open();
string adapterStr = "select * from account";
SqlDataAdapter sql_adapter = new SqlDataAdapter(adapterStr, sql_connection);
sql_adapter.Fill(data_set, "account");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sql_connection.Close();
}
return(data_set);
}
private void AddRoom()
{
SqlConnection sql_connection = main_window.Sqlcon();
try
{
sql_connection.Open();
string commandStr = "insert roomTable (房间号,房间类型,所在楼层,价格,房间状态,备注) values" +
$"('{tbAddroomNum.Text}','{cbAddroomType.Text}','{cbAddroomLevel.Text}'," +
$"'{tbAddroomPrice.Text}','{cbAddroomStatus.Text}','{tbAddroomRemark.Text}')";
SqlCommand sql_command = new SqlCommand(commandStr, sql_connection);
sql_command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sql_connection.Close();
}
}
private void AddAccount()
{
SqlConnection sql_connection = main_window.Sqlcon();
try
{
sql_connection.Open();
string commandStr = "insert account (username,pwd,权限,备注) values " +
$"('{tbAccount_name.Text}','{tbAccount_pwd.Text}','{cbAccount_power.Text}'," +
$"'{tbAccount_remark.Text}')";
SqlCommand sql_command = new SqlCommand(commandStr, sql_connection);
sql_command.ExecuteNonQuery();
}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
finally
{
sql_connection.Close();
}
}
