C#三层架构-8.存款、取款功能设计.docVIP

存款取款功能 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; } } 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.balanceMath.Abs( MoneyNum)) { return false; } }