//增加
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));
}
