public static List <VipGradeMDL> getlist(VipGradeMDL vg) { string sql = "select * from vipgrade where 1=1"; List <SqlParameter> list = new List <SqlParameter>(); List <VipGradeMDL> list1 = new List <VipGradeMDL>(); if (vg != null) { if (vg.vgid > 0) { sql += " and vgid=@vgid"; list.Add(new SqlParameter("@vgid", vg.vgid)); } } using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, list.ToArray())) { while (sda.Read()) { VipGradeMDL v = new VipGradeMDL(); v.vgid = Convert.ToInt32(sda[0]); v.vgname = sda[1].ToString(); v.vgdiscount = Convert.ToDouble(sda[2]); list1.Add(v); } return(list1); } }
public static int deletevg(VipGradeMDL vg) { string sql = "delete from vipgrade where vgid=@vgid"; SqlParameter[] spt = { new SqlParameter("@vgid", vg.vgid) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int insertvg(VipGradeMDL vg) { string sql = "insert into vipgrade values(@vgname,@vgdiscount)"; SqlParameter[] spt = { new SqlParameter("@vgname", vg.vgname), new SqlParameter("@vgdiscount", vg.vgdiscount) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int updatevg(VipGradeMDL vg) { string sql = "update vipgrade set vgname=@vgname,vgdiscount=@vgdiscount where vgid=@vgid"; SqlParameter[] spt = { new SqlParameter("@vgname", vg.vgname), new SqlParameter("@vgdiscount", vg.vgdiscount), new SqlParameter("@vgid", vg.vgid) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { new Warning("信息填写不完整", 图标.Yes).Show(); return; } try { if (VipGradeMDL.upin == 1) { VipGradeMDL vg = new VipGradeMDL(); vg.vgname = textBox1.Text; vg.vgdiscount = double.Parse(textBox2.Text); int i = VipGradeBLL.insertvg(vg); if (i > 0) { this.Close(); } else { MessageBox.Show("增加失败"); } } else { VipGradeMDL vg = new VipGradeMDL(); vg.vgname = textBox1.Text; vg.vgdiscount = double.Parse(textBox2.Text); vg.vgid = VipGradeMDL.id; int i = VipGradeBLL.updatevg(vg); if (i > 0) { this.Close(); } else { MessageBox.Show("修改失败"); } } } catch (Exception) { MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button14_Click(object sender, EventArgs e) { if (listView3.SelectedItems.Count > 0) { VipGradeMDL vg = new VipGradeMDL(); vg.vgid = int.Parse(listView3.SelectedItems[0].SubItems[0].Text); int i = VipGradeBLL.deletevg(vg); if (i > 0) { listView4.Items.Clear(); listView3.Items.Clear(); panel4_VisibleChanged(null, null); } else { MessageBox.Show("删除失败"); } } }
public static int deletevg(VipGradeMDL vg) { return(VipGradeDAL.deletevg(vg)); }
public static int updatevg(VipGradeMDL vg) { return(VipGradeDAL.updatevg(vg)); }
public static int insertvg(VipGradeMDL vg) { return(VipGradeDAL.insertvg(vg)); }
public static List <VipGradeMDL> getlist(VipGradeMDL vg) { return(VipGradeDAL.getlist(vg)); }