存款取款功能

1.DAL--transInfo增加add方法--增加交易记录

/// <summary>

/// 增加一条数据

/// </summary>

public bool Add(Model.transInfo model)

{

StringBuilder strSql=new StringBuilder();

StringBuilder strSql1=new StringBuilder();

StringBuilder strSql2=new StringBuilder();

if (model.transDate != null)

{

strSql1.Append("transDate,");

strSql2.Append("'"+model.transDate+"',");

}

if (model.cardID != null)

{

strSql1.Append("cardID,");

strSql2.Append("'"+model.cardID+"',");

}

if (model.transType != null)

{

strSql1.Append("transType,");

strSql2.Append("'"+model.transType+"',");

}

if (model.transMoney != null)

{

strSql1.Append("transMoney,");

strSql2.Append(""+model.transMoney+",");

}

if (model.remark != null)

{

strSql1.Append("remark,");

strSql2.Append("'"+model.remark+"',");

}

strSql.Append("insert into transInfo(");

strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));

strSql.Append(")");

strSql.Append(" values (");

strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));

strSql.Append(")");

int rows=DbHelperSQL.ExecuteSql(strSql.ToString());

if (rows > 0)

{

return true;

}

else

{

return false;

}

}

2.DAL--cardinfo增加UpdateBalance方法--更新账户余额

public bool UpdateBalance(string CardID, decimal MoneyNum,string remark)

        {

//增加交易记录

            Model.transInfo t = new Model.transInfo();

            t.cardID = CardID;

            t.transDate = DateTime.Now;

            t.transMoney = Math.Abs(MoneyNum);

            t.transType = "存入";

            t.remark = remark;

string sql = "update  cardinfo set balance=balance+" + MoneyNum + " where cardID='" + CardID + "' and IsReportLoss=0";

if (MoneyNum < 0)

            {

//先判断余额是否足

                Model.cardinfo c  = GetModel(CardID);

if (c != null)

                {

if(c.balance<Math.Abs( MoneyNum))

                    { return false; }

                }

else

                {

return false;

                }

                t.transType = "支取";

            }

if (DbHelperSQL.ExecuteSql(sql) >= 1)//存取款成功 则增加交易记录

            {

                DAL.transInfo dalt = new DAL.transInfo();

                dalt.Add(t);

return true;

            }

return false;

        }

3.BLL--cardinfo增加UpdateBalance方法

/// <summary>

/// 存取款

/// <param name = "CardID" ></ param >

/// < param name="MoneyNum">负数为取款</param>

/// <returns></returns>

/// </summary>

public bool UpdateBalance(string CardID, decimal MoneyNum,string remark)

        {

return dal.UpdateBalance(CardID, MoneyNum,remark);

        }

4.WinF--getMoney窗体

1）为窗体类增加卡号字段

2）编写取款按钮单击方法

代码如下：

5.WinF--SetMoney窗体

1）为窗体类增加卡号字段

2）编写存款按钮单击方法

代码如下：

6.WinF--main窗体---编写存款、取款菜单项代码