仲 晓 静毕业论文

徐州建筑职业技术学院毕业设计说明书

this.huiyuanguanli1.DataSource = db.DefaultView; zichushihua();//会员资料初始化

czjl();//充值记录控件初始化 } } catch {

MessageBox.Show(\连接表有问题\); }

}

}

17

徐州建筑职业技术学院毕业设计说明书

5．2会员充值信息设计表

{

//首先连接数据库，然后充值

try//连接表 {

using (SqlConnection con = new SqlConnection(strConn)) {

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(\充值日期,实收金额,实际充

值 from VIEW_stu where 会员卡号='\ + this.num.Text + \, con);

da.Fill(dt);

this.xiaofeijil.DataSource = dt.DefaultView; } } catch {

MessageBox.Show(\连接表有问题\); }

}

18

徐州建筑职业技术学院毕业设计说明书

private void chongzhi_Click(object sender, EventArgs e) {

huiyuancz dg1 = new huiyuancz(); dg1.hyczstate = 1;

dg1.hycz_num = this.huiyuanguanli1[0,

this.huiyuanguanli1.CurrentCell.RowIndex].Value.ToString().Trim(); dg1.ShowDialog(); chushihua();

}

private void 会员充值ToolStripMenuItem_Click(object sender, EventArgs e) {

huiyuancz dg1 = new huiyuancz(); dg1.hyczstate = 1;

dg1.hycz_num = this.huiyuanguanli1[0,

this.huiyuanguanli1.CurrentCell.RowIndex].Value.ToString().Trim(); dg1.ShowDialog(); chushihua();

}

5.3 会员添加信息的设计

private void zjia_Click(object sender, EventArgs e) {

19

徐州建筑职业技术学院毕业设计说明书

add dlg = new add(); dlg.ShowDialog();

zichushihua();//会员资料初始化 czjl();//充值记录控件初始化

}

private void 会员添加ToolStripMenuItem_Click(object sender, EventArgs e) {

add dlg = new add(); dlg.ShowDialog(); chushihua();

}

5.4会员补卡信息的设计

private void 会员补卡ToolStripMenuItem_Click(object sender, EventArgs e) {

huiyuanbk dg2 = new huiyuanbk(); dg2.hybk_num1 = this.huiyuanguanli1[0,

this.huiyuanguanli1.CurrentCell.RowIndex].Value.ToString().Trim(); dg2.ShowDialog(); chushihua();

20