//充值 private void button2_Click(object sender, EventArgs e) { if (lab_kahao.Text != "") { if (lab_zhuangtai.Text == "报销" || lab_zhuangtai.Text == "挂失") { MessageBox.Show("会员卡以报销或挂失不可进行此操作"); return; } Frm_HuiYuanChongZhi frm = new Frm_HuiYuanChongZhi(); frm.kaHao = lab_kahao.Text; frm.Show(); } else { MessageBox.Show("请选择会员!"); } }
private void 会员充值ToolStripMenuItem1_Click(object sender, EventArgs e) { Frm_HuiYuanChongZhi frm = new Frm_HuiYuanChongZhi(); frm.Show(); }
public void JieZhang() { DialogResult dr = MessageBox.Show("确定结账?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); if (dr == DialogResult.OK) { string sql = $"select * from ShouQuYiFu as sqyf inner join HuiYuan as hy on hy.HuiYuanID = sqyf.HuiYuan where hy.HuiYuanID = {kaHao} and ShiFouJieZhang = '否' "; DataTable dt = db.GetData(sql); if (dt.Rows.Count != 0) { string sql3 = $"select * from HuiYuan as hy inner join HuiYuanZhongLei as hyzl on hyzl.HuiYuanZhongLeiID = hy.ZhongLei inner join HuiYuanZhuangTai as hyzt on hyzt.HuiYuanZhuanTaiID = hy.ZhuangTai inner join HuiYuanTime as hytime on hytime.ShiJianID = hy.ShiJian where HuiYuanID = {kaHao}"; DataTable dt3 = db.GetData(sql3); double xiaoFeiZong = double.Parse(dt3.Rows[0]["XiaoFeiZongE"].ToString()); double yuE = double.Parse(dt3.Rows[0]["YuE"].ToString()); if (yuE >= jiaGe) { yuE = yuE - jiaGe; xiaoFeiZong += jiaGe; string sql4 = $"update HuiYuan set XiaoFeiZongE = {xiaoFeiZong} , YuE = {yuE} where huiyuanid = {kaHao}"; int enq4 = db.Update(sql4); if (enq4 > 0) { MessageBox.Show("结账成功!"); ChaTian(); TianYi(); for (int a = 0; a < dt.Rows.Count; a++) { if (a == dt.Rows.Count) { break; } string syid = dt.Rows[a]["ShouQuYiFuID"].ToString(); DataTable dt2 = db.GetData(sql); string sql2 = $"update ShouQuYiFu set ShiFouJieZhang = '是' where ShouQuYiFuID = {syid} and ShiFouJieZhang = '否'"; int enq = db.Update(sql2); } //ChaTian(); //TianYi(); } } else { string str = $"当前账户余额不足,是否充值?还差:{jiaGe - yuE}元"; DialogResult dr2 = MessageBox.Show(str, "提示!", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); if (dr2 == DialogResult.Yes) { Frm_HuiYuanChongZhi frm = new Frm_HuiYuanChongZhi(); frm.kaHao = kaHao; frm.Show(); } } } else { MessageBox.Show("当前没有可结的账单!"); } } }