private void btn_Save_Click(object sender, EventArgs e)
{
string name = txt_Name.Text.Trim();
string company = txt_Company.Text.Trim();
string sex = rbtn_Sex1.Checked == true ? "男":"女";
string age = nudown_Age.Value.ToString();
string telephone = txt_Telephone.Text.Trim();
string address=txt_Address.Text.Trim();
if(name=="")
{
lbl_Note.Text = "姓名不能为空！";
lbl_Note.ForeColor = Color.Red;
txt_Name.Focus();
}
else if(lbl_Status.Text=="添加")
{
SqlConnection conn = new SqlConnection("Data Source=ZYC-PC;database=DB_CASE0705;UID =sa;PWD=liuqiang123 ");
conn.Open();
string str = string.Format("insert into Customer_Info values('{0}','{1}','{2}',{3},'{4}','{5}')",name,company,sex,age,telephone,address);
SqlCommand cmd = new SqlCommand(str,conn);
int i = cmd.ExecuteNonQuery();
if(i>0)
{
lbl_Note.Text = "恭喜您，客户信息添加成功！";
lbl_Note.ForeColor = Color.Blue;
ClearTexBox();
//
DataBind_Customer();
}
else
{
lbl_Note.Text = "对不起，客户信息添加失败！";
lbl_Note.ForeColor = Color.Red;
}
conn.Close();
}
//修改操作
else
{
SqlConnection conn = new SqlConnection("Data Source=ZYC-PC;database=DB_CASE0705;UID =sa;PWD=liuqiang123 ");
conn.Open();
string str = string.Format("update Customer_Info set CustomerName='{0}',Company='{1}',Sex='{2}',Age={3},Telephone='{4}',Address='{5}' where CustomerID={6}", name, company, sex, age, telephone, address, customerid);
SqlCommand cmd = new SqlCommand(str, conn);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
lbl_Note.Text = "恭喜您，客户信息修改成功！";
lbl_Note.ForeColor = Color.Blue;
ClearTexBox();
//
DataBind_Customer();
}
else
{
lbl_Note.Text = "对不起，客户信息修改失败！";
lbl_Note.ForeColor = Color.Red;
}
conn.Close();
}
}
protected void ClearTexBox()
{
txt_Name.Text = "";
txt_Company.Text = "";
txt_Telephone.Text = "";
txt_Address.Text = "";
rbtn_Sex1.Checked = true;
nudown_Age.Value = 1;
lbl_Status.Text = "添加";
customerid = "";
}
private void Form1_Load(object sender, EventArgs e)
{
DataBind_Customer();
}
protected void DataBind_Customer()
{
SqlConnection conn = new SqlConnection("Data Source=ZYC-PC;database=DB_CASE0705;UID =sa;PWD=liuqiang123 ");
conn.Open();
string str = "select * from Customer_Info";
SqlDataAdapter da = new SqlDataAdapter(str,conn);
DataTable dt = new DataTable();
da.Fill(dt);
lv_Customer.Items.Clear();
foreach(DataRow dr in dt.Rows)
{
ListViewItem myitem = new ListViewItem(dr["CustomerID"].ToString());
myitem.SubItems.Add(dr["CustomerName"].ToString());
myitem.SubItems.Add(dr["Company"].ToString());
myitem.SubItems.Add(dr["Sex"].ToString());
myitem.SubItems.Add(dr["Age"].ToString());
myitem.SubItems.Add(dr["Telephone"].ToString());
myitem.SubItems.Add(dr["Address"].ToString());
lv_Customer.Items.Add(myitem);
}
conn.Close();
}
string customerid = "";
private void lv_Customer_SelectedIndexChanged(object sender, EventArgs e)
{
if(lv_Customer.SelectedItems.Count>0)
{
ListViewItem myitem = lv_Customer.SelectedItems[0];
customerid = myitem.SubItems[0].Text;
txt_Name.Text= myitem.SubItems[1].Text;
txt_Company.Text = myitem.SubItems[2].Text;
rbtn_Sex1.Checked = myitem.SubItems[3].Text== "男"?true:false;
rbtn_Sex1.Checked = myitem.SubItems[3].Text == "男"?true:false;
nudown_Age.Value = decimal.Parse(myitem.SubItems[4].Text);
txt_Telephone.Text = myitem.SubItems[5].Text;
txt_Address.Text = myitem.SubItems[6].Text;
lbl_Status.Text = "修改";
}
}
private void btn_Del_Click(object sender, EventArgs e)
{
if(customerid=="")
{
MessageBox.Show("请先选择要删除的客户信息！");
}
else
{
DialogResult result = MessageBox.Show("确定要删除选中的客户信息？","删除提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if(result==DialogResult.Yes)
{
SqlConnection conn = new SqlConnection("Data Source=ZYC-PC;database=DB_CASE0705;UID =sa;PWD=liuqiang123 ");
conn.Open();
string str = string.Format("delete from Customer_Info where CustomerID={0}", customerid);
SqlCommand cmd = new SqlCommand(str, conn);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
lbl_Note.Text = "恭喜您，客户信息删除成功！";
lbl_Note.ForeColor = Color.Blue;
ClearTexBox();
//
DataBind_Customer();
}
else
{
lbl_Note.Text = "对不起，客户信息删除失败！";
lbl_Note.ForeColor = Color.Red;
}
conn.Close();
}
}
}
private void btn_Cancel_Click(object sender, EventArgs e)
{
ClearTexBox();
lbl_Note.Text = "";
}
评论