예제 #1
0
        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("退卡失败,请联系管理员!", "温馨提示");
            }
        }
예제 #2
0
        /// <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));
        }
예제 #3
0
 /// <summary>
 /// 添加一行退卡信息
 /// </summary>
 /// <param name="backinfo"></param>
 /// <returns></returns>
 public int AddBackInfo(Entity.BackMoney backinfo)
 {
     return(ic.AddBackInfo(backinfo));
 }