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); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.cardinfo model, out string cardID) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); cardID = ""; //62212611 。1-6表示银行 7-8省份。9-15位才是自己的账户号,最后一位仍然是校验码 。中间7位 //获取最新的银行卡号。新卡的账号。是卡号9-15位的数字+1.。最后一位是随机数 string ss = getMaxCardID(); if (ss == "") { cardID = "622126110000001"; } //第一个开卡的人 else { int xx = int.Parse(ss.Substring(8, 7)) + 1; if (xx == 10000000) { return(false); } //超额了 cardID = ss.Substring(0, 8) + xx.ToString("D7"); } Random r = new Random(); cardID = cardID + r.Next(0, 10); model.cardID = cardID; if (model.cardID != null) { strSql1.Append("cardID,"); strSql2.Append("'" + model.cardID + "',"); } if (model.curType != null) { strSql1.Append("curType,"); strSql2.Append("'" + model.curType + "',"); } if (model.savingType != null) { strSql1.Append("savingType,"); strSql2.Append("'" + model.savingType + "',"); } if (model.openDate != null) { strSql1.Append("openDate,"); strSql2.Append("'" + model.openDate + "',"); } if (model.openMoney != null) { strSql1.Append("openMoney,"); strSql2.Append("" + model.openMoney + ","); } if (model.balance != null) { strSql1.Append("balance,"); strSql2.Append("" + model.balance + ","); } if (model.pass != null) { strSql1.Append("pass,"); strSql2.Append("'" + model.pass + "',"); } if (model.IsReportLoss != null) { strSql1.Append("IsReportLoss,"); strSql2.Append("" + (model.IsReportLoss? 1 : 0) + ","); } if (model.customerID != null) { strSql1.Append("customerID,"); strSql2.Append("" + model.customerID + ","); } strSql.Append("insert into cardinfo("); 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) { //增加交易记录 Model.transInfo t = new Model.transInfo(); t.cardID = model.cardID; t.transDate = model.openDate; t.transMoney = model.openMoney; t.transType = "存入"; t.remark = "开户存入"; DAL.transInfo dalt = new DAL.transInfo(); dalt.Add(t); return(true); } else { return(false); } }