//增加 private void tpbAdd_Click(object sender, EventArgs e) { VipsModel vip = new VipsModel(); vip.VipID1 = -1; MemberEditorForm mef = new MemberEditorForm(vip); mef.Show(); this.Hide(); }
//查询 private void tpbSelect_Click(object sender, EventArgs e) { string name = tpbText.Text.Trim(); VipsModel vip = new VipsModel(); vip.VipID21 = name; vip.VipName1 = name; DataTable dt = VipsBLL.getSelectVip(vip); dataGridView1.DataSource = dt; }
//修改 private void tpbUpdate_Click(object sender, EventArgs e) { int index = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value); string name = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToString(); string sex = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToString(); string top = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value.ToString(); string tel = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[5].Value.ToString(); string startTime = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[6].Value.ToString(); string endTime = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[7].Value.ToString(); VipsModel vip = new VipsModel(index, name, sex, top, tel, startTime, endTime); MemberEditorForm mef = new MemberEditorForm(vip); mef.Show(); this.Hide(); }
//删除 private void tpbDelete_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("确定删除该行数据?", "温馨提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { int index = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value); VipsModel vip = new VipsModel(); vip.VipID1 = index; int result = VipsBLL.getDeleteVip(vip); if (result > 0) { MessageBox.Show("OK"); MemberManagementForm_Load(null, null); } else { MessageBox.Show("NO"); } } }
private void button1_Click(object sender, EventArgs e) { if (vip.VipID1 == -1) { //新增 string name = txtName.Text.Trim(); string tel = txtTel.Text.Trim(); string sex = txtSex.Text.Trim(); string top = txtTop.Text.Trim(); string index = VipsBLL.getTableVipIndex(top).ToString(); string startTime = DateTime.Now.ToString("yyyy-MM-dd"); string endTime2 = dtpTime.Text.Trim(); string endTime = ""; string[] time = endTime2.Split('.'); for (int i = 0; i < time.Length; i++) { endTime += time[i]; } VipsModel vip2 = new VipsModel(name, sex, index, tel, startTime, endTime); int result = VipsBLL.getAddVip(vip2); if (result > 0) { MessageBox.Show("OK"); this.Close(); MemberManagementForm mmf = new MemberManagementForm(); mmf.Show(); } else { MessageBox.Show("NO"); } } else { //修改 //新增 string name = txtName.Text.Trim(); string tel = txtTel.Text.Trim(); string sex = txtSex.Text.Trim(); string top = txtTop.Text.Trim(); string index = VipsBLL.getTableVipIndex(top).ToString(); string startTime = ""; string endTime2 = dtpTime.Text.Trim(); string endTime = ""; string[] time = endTime2.Split('.'); for (int i = 0; i < time.Length; i++) { endTime += time[i]; } VipsModel vip2 = new VipsModel(vip.VipID1, name, sex, index, tel, startTime, endTime); int result = VipsBLL.getUpdateVip(vip2); if (result > 0) { MessageBox.Show("OK"); this.Close(); MemberManagementForm mmf = new MemberManagementForm(); mmf.Show(); } else { MessageBox.Show("NO"); } } }
public MemberEditorForm(VipsModel vip) { this.vip = vip; InitializeComponent(); }
//删除 public static int getDeleteVip(VipsModel vip) { return(VipsDAL.getDeleteVip(vip)); }
//查询 public static DataTable getSelectVip(VipsModel vip) { return(VipsDAL.getSelectVip(vip)); }
//添加管理员 public static int getAddVip(VipsModel vip) { return(VipsDAL.getAddVip(vip)); }
//查询 public static DataTable getSelectVip(VipsModel vip) { string sql = string.Format(@"select VipID '会员编号',VipName '会员姓名',VipSex '性别',VGName '会员等级',VGDiscount '会员折扣率',VipTel '联系电话',CONVERT(varchar(10),VipStartDate,21) '办理日期',CONVERT(varchar(10),VipEndDate,21) '到期日期' from Vips vs join VIPGrade vg on vs.GradeID=vg.VGID where VipID like '%{0}%' or VipName like '%{1}%'", vip.VipID21, vip.VipName1); return(DBHelper.getTable(sql)); }
//删除 public static int getDeleteVip(VipsModel vip) { string sql = string.Format(@"delete Vips where VipID={0}", vip.VipID1); return(DBHelper.getExecuteNonQuery(sql)); }
//修改 public static int getUpdateVip(VipsModel vip) { string sql = string.Format(@"update Vips set VipName='{0}',VipSex='{1}',GradeID={2},VipTel='{3}',VipEndDate='{4}' from Vips where VipID = {5}", vip.VipName1, vip.VipSex1, vip.GradeID1, vip.VipTel1, vip.VipEndDate1, vip.VipID1); return(DBHelper.getExecuteNonQuery(sql)); }
//添加管理员 public static int getAddVip(VipsModel vip) { string sql = string.Format(@"insert into Vips values('{0}','{1}',{2},'{3}','{4}','{5}')", vip.VipName1, vip.VipSex1, vip.GradeID1, vip.VipTel1, vip.VipStartDate1, vip.VipEndDate1); return(DBHelper.getExecuteNonQuery(sql)); }