private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
if (radioButton2.Checked == true)
{
this.groupBox1.Enabled = false;
this.dataGridView1.Visible = true;
conn = CONN.Myconn();
conn.Open();
cmd = new SqlCommand("select * from VIP_INFORMATION", conn);
sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds, "VIP_INFORMATION");
this.dataGridView1.DataSource = ds.Tables[0];
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
cmd.Clone();
conn.Close();
this.groupBox3.Enabled = true;
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
if (radioButton2.Checked == true)
{
this.groupBox1.Enabled = false;
this.dataGridView1.Visible = true;
this.groupBox3.Enabled = true;
conn = CONN.Myconn();
conn.Open();
cmd = new SqlCommand("select BOOK_NUMBER as 图书编号,BOOK_NAME as 图书名称, BOOK_AUTHOR as 图书作者, BOOK_PUBLISHER as 出版社,BOOK_PRICE as 图书单价, BOOK_VARIETY as 图书类别, BOOK_RESERVE as 库存量 from BOOK_INFORMATION", conn);
sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds, "BOOK_INFORMATION");
this.dataGridView1.DataSource = ds.Tables[0];
cmd.Clone();
conn.Close();
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
}
}
private void button1_Click(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
string t2 = this.textBox2.Text.Trim();
if (textBox1.Text != "" && textBox2.Text != "")
{
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from USERS_INFORMATION where USERS_LOGINNAME='" + t1 + "' and USERS_PASSWORDS='" + t2 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
this.Hide();
主界面 frm2 = new 主界面();
frm2.authorization = sdr["USERS_AUTHORIZATIONS"].ToString().Trim();
frm2.name = t1;
frm2.time = DateTime.Now.ToLongDateString() + " " + DateTime.Now.DayOfWeek;
frm2.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("用户名或密码错误!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox2.Text = "";
this.textBox2.Focus();
}
}
else
{
MessageBox.Show("用户名或密码不能为空!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void textBox1_LostFocus(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from BOOK_INFORMATION where BOOK_NUMBER='" + t1 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
if (MessageBox.Show("图书编号已存在!是否显示", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
this.textBox2.Text = sdr[1].ToString().Trim();
this.textBox3.Text = sdr[2].ToString().Trim();
this.textBox4.Text = sdr[3].ToString().Trim();
this.textBox5.Text = sdr[4].ToString().Trim();
this.textBox6.Text = sdr[5].ToString().Trim();
this.textBox7.Focus();
}
else
{
this.textBox1.Text = "";
this.textBox1.Focus();
}
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
if (radioButton2.Checked == true)
{
this.groupBox1.Enabled = false;
this.dataGridView1.Visible = true;
this.groupBox3.Enabled = true;
conn = CONN.Myconn();
conn.Open();
cmd = new SqlCommand("select USERS_NUMBER as 用户编号,USERS_NAME as 姓名, USERS_SEX as 性别, USERS_LOGINNAME as 登录名,USERS_PASSWORDS as 密码, USERS_AUTHORIZATIONS as 权限 from USERS_INFORMATION", conn);
sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds, "USERS_INFORMATION");
this.dataGridView1.DataSource = ds.Tables[0];
cmd.Clone();
conn.Close();
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
}
}
private void button1_Click(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
string t2 = this.textBox2.Text.Trim();
string t3 = this.comboBox1.SelectedItem.ToString();
string t4 = "";
switch (comboBox2.SelectedItem.ToString())
{
case "VIP1": t4 = "1"; break;
case "VIP2": t4 = "2"; break;
case "VIP3": t4 = "3"; break;
case "VIP4": t4 = "4"; break;
case "VIP5": t4 = "5"; break;
}
if (t1 == "")
{
MessageBox.Show("会员编号不能为空!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from VIP_INFORMATION where VIP_NUMBER='" + t1 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
this.label8.Text = "该会员信息已存在!";
this.label8.Visible = true;
sdr.Close();
}
else
{
cmd.Clone();
cmd = new SqlCommand("insert VIP_INFORMATION values('" + t1 + "','" + t2 + "','" + t3 + "','" + t4 + "')", conn);
sdr.Close();
cmd.ExecuteScalar();
this.label8.Text = "增加成功!";
this.label8.Visible = true;
}
this.textBox1.Text = "";
this.textBox2.Text = "";
this.comboBox1.SelectedIndex = 0;
this.comboBox2.SelectedIndex = 0;
conn.Close();
}
this.textBox1.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
string t2 = this.textBox2.Text.Trim();
string t3 = this.comboBox1.SelectedItem.ToString().Trim();
string t4 = this.textBox4.Text.Trim();
string t5 = this.textBox5.Text.Trim();
string t6 = "";
switch (comboBox2.SelectedItem.ToString())
{
case "管理人员": t6 = "1"; break;
case "销售人员": t6 = "2"; break;
}
if (t1 == "")
{
MessageBox.Show("用户编号不能为空!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
conn = CONN.Myconn();
conn.Open();
cmd = new SqlCommand("select * from USERS_INFORMATION where USERS_NUMBER='" + t1 + "'", conn);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
this.label8.Text = "该用户信息已存在!";
this.label8.Visible = true;
sdr.Close();
}
else
{
cmd.Clone();
cmd = new SqlCommand("insert USERS_INFORMATION values('" + t1 + "','" + t2 + "','" + t3 + "','" + t4 + "','" + t5 + "','" + t6 + "')", conn);
sdr.Close();
cmd.ExecuteScalar();
this.label8.Text = "增加成功!";
this.label8.Visible = true;
}
this.textBox1.Text = "";
this.textBox1.Focus();
this.textBox2.Text = "";
this.comboBox1.SelectedItem = 0;
this.textBox4.Text = "";
this.textBox5.Text = "";
this.comboBox2.SelectedItem = 0;
conn.Close();
}
}
private void textBox1_LostFocus(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from USERS_INFORMATION where USERS_NUMBER='" + t1 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
if (MessageBox.Show("该用户编号已存在!请重新填写", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
this.textBox1.Text = "";
this.textBox1.Focus();
}
}
}
private void textBox5_LostFocus(object sender, EventArgs e)
{
string t1 = this.textBox5.Text.Trim();
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from BOOK_INFORMATION where BOOK_NUMBER='" + t1 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
}
else
{
if (this.textBox5.Text != "")
{
MessageBox.Show("该图书编号不存在!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox5.Text = "";
this.textBox5.Focus();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string t1 = this.textBox1.Text.Trim();
string t2 = this.textBox2.Text.Trim();
string t3 = this.textBox3.Text.Trim();
string t4 = this.textBox4.Text.Trim();
float t5;
if (float.TryParse(this.textBox5.Text.Trim(), out t5))
{
}
else
{
t5 = 0;
}
string t6 = this.textBox6.Text.Trim();
int t7;
if (int.TryParse(this.textBox7.Text.Trim(), out t7))
{
}
else
{
t7 = 0;
}
int number;
if (t1 == "")
{
MessageBox.Show("图书编号不能为空!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
SqlConnection conn = CONN.Myconn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from BOOK_INFORMATION where BOOK_NUMBER='" + t1 + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
this.label8.Text = "图书信息已存在!";
this.label8.Visible = true;
number = int.Parse(sdr["BOOK_RESERVE"].ToString().Trim());
sdr.Close();
cmd.Clone();
number = number + t7;
cmd = new SqlCommand("update BOOK_INFORMATION set BOOK_RESERVE=" + number + " where BOOK_NUMBER = '" + t1 + "'", conn);
cmd.ExecuteScalar();
string s = string.Format("新增{0}本图书后，总的库存量为{1}", t7, number);
this.label9.Text = s;
this.label9.Visible = true;
}
else
{
cmd.Clone();
cmd = new SqlCommand("insert BOOK_INFORMATION values('" + t1 + "','" + t2 + "','" + t3 + "','" + t4 + "'," + t5 + ",'" + t6 + "'," + t7 + ")", conn);
sdr.Close();
cmd.ExecuteScalar();
this.label8.Text = "增加成功!";
this.label8.Visible = true;
string s = string.Format("该图书入库后，总的库存量为{0}", t7);
this.label9.Text = s;
this.label9.Visible = true;
}
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
conn.Close();
}
}