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);
}
}
