private void SubmitButton_Click(object sender, EventArgs e)
{
if (BuyerButton.Checked == true && SellerButton.Checked == false)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = LoginInterface.initConn;
string id = IdBox.Text.ToString().Trim();
string usnm = UsernameBox.Text.ToString().Trim();
string pwd = PwdBox.Text.ToString().Trim();
string BuyerId = DsControl.CreateCustomerId().Trim();
string sql_key = "use Vickers " +
"create login " + usnm + " with password = '******';" +
"create user " + usnm + " for login " + usnm + " with default_schema=dbo;" +
"alter role buyers add member " + usnm + ";" +
"insert into dbo.Users values('" +
id + "','" + BuyerId + "',null,'" + usnm + "','" + pwd + "');" +
"insert into dbo.Customer values ('" +
BuyerId + "','" + usnm + "',null,null,'" + id.Trim() + "',null,null,null,null,null,null,null);";
cmd.CommandText = sql_key;
cmd.ExecuteNonQuery();
MessageBox.Show("添加成功！请关闭该页面");
}
if (SellerButton.Checked == true && BuyerButton.Checked == false)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = LoginInterface.initConn;
string id = IdBox.Text.ToString().Trim();
string usnm = UsernameBox.Text.ToString().Trim();
string pwd = PwdBox.Text.ToString().Trim();
string LandlordId = DsControl.CreateLandlordId().Trim();
string sql_key = "use Vickers " +
"create login " + usnm + " with password = '******';" +
"create user " + usnm + " for login " + usnm + " with default_schema=dbo;" +
"alter role sellers add member " + usnm + ";" +
"insert into dbo.Users values('" +
id + "',null,'" + LandlordId + "','" + usnm + "','" + pwd + "');" +
"insert into dbo.Landlord values ('" +
LandlordId + "','" + usnm + "',null,null,'" + id.Trim() + "',null,null,null,null,null);";
cmd.CommandText = sql_key;
cmd.ExecuteNonQuery();
MessageBox.Show("添加成功！请关闭该页面");
}
}
