//充值
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("当前没有可结的账单！");
}
}
}
