private void btnBackMoney_Click(object sender, EventArgs e) //点击退款按钮 { //根据id清空其余额 string cardno = txtCardNo.Text.Trim(); Facade.Consumers consumer = new Facade.Consumers(); consumer.UpdateMoney(cardno, 0); //将一行退卡信息插入到数据库 Entity.BackMoney backmoney = new Entity.BackMoney(); backmoney.cardno = cardno; backmoney.money = txtMoney.Text.Trim(); backmoney.operater = Entity.GoAnyWhere.id; backmoney.time = DateTime.Now; int result = consumer.AddBackInfo(backmoney); if (result > 0) { MessageBox.Show("退卡成功!", "温馨提示"); } else { MessageBox.Show("退卡失败,请联系管理员!", "温馨提示"); } }
/// <summary> /// 添加一行退卡信息 /// </summary> /// <param name="backinfo"></param> /// <returns></returns> public int AddBackInfo(Entity.BackMoney backinfo) { string sql = "insert into BackMoney values('" + backinfo.cardno + "','" + backinfo.money + "','" + backinfo.operater + "','" + backinfo.time + "')"; return(sqlhelper.ExecuteNonQuery(sql)); }
/// <summary> /// 添加一行退卡信息 /// </summary> /// <param name="backinfo"></param> /// <returns></returns> public int AddBackInfo(Entity.BackMoney backinfo) { return(ic.AddBackInfo(backinfo)); }