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));
}
