private void button1_Click(object sender, EventArgs e) { if (this.txtGrade.Text == "" || this.txtD.Text == "") { MessageBox.Show("数据部能为空"); } else { int a = Convert.ToInt32(this.txtid.Text); string b = this.txtGrade.Text; double c = Convert.ToDouble(this.txtD.Text); VipGrade v = new VipGrade(); v.VGID = a; v.VGName = b; v.VGDiscount = c; bool bb = VipsBLL.update(v); if (bb == true) { this.Close(); // MessageBox.Show("成功"); } else { MessageBox.Show("失败"); } } }
public static bool update(VipGrade list) { int count = VipsDAL.update(list); if (count >= 1) { return(true); } else { return(false); } }
public static int update(VipGrade list) { string sql = "update VIPGrade set VGName=@hui ,VGDiscount=@zhe where VGID=@id"; SqlParameter[] sps = new SqlParameter[] { new SqlParameter("@hui", list.VGName), new SqlParameter("@zhe", list.VGDiscount), new SqlParameter("@id", list.VGID) }; int count = DBHelper.ExecuteNonQuery(sql, sps); return(count); }
public static List <VipGrade> selectvip() { List <VipGrade> vip = new List <VipGrade>(); string sql = "select * from VIPGrade"; SqlDataReader sdr = DBHelper.ExecuteReader(sql, null); while (sdr.Read()) { VipGrade v = new VipGrade(); v.VGID = Convert.ToInt32(sdr["VGID"].ToString()); v.VGName = sdr["VGName"].ToString(); v.VGDiscount = Convert.ToDouble(sdr["VGDiscount"].ToString()); vip.Add(v); } sdr.Close(); return(vip); }