/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.transInfo DataRowToModel(DataRow row)
{
Model.transInfo model = new Model.transInfo();
if (row != null)
{
if (row["transDate"] != null && row["transDate"].ToString() != "")
{
model.transDate = DateTime.Parse(row["transDate"].ToString());
}
if (row["cardID"] != null)
{
model.cardID = row["cardID"].ToString();
}
if (row["transType"] != null)
{
model.transType = row["transType"].ToString();
}
if (row["transMoney"] != null && row["transMoney"].ToString() != "")
{
model.transMoney = decimal.Parse(row["transMoney"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <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);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.transInfo GetModel(DateTime transDate)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" transDate,cardID,transType,transMoney,remark ");
strSql.Append(" from transInfo ");
strSql.Append(" where transDate='" + transDate + "' ");
Model.transInfo model = new Model.transInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.transInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update transInfo set ");
if (model.cardID != null)
{
strSql.Append("cardID='" + model.cardID + "',");
}
if (model.transType != null)
{
strSql.Append("transType='" + model.transType + "',");
}
if (model.transMoney != null)
{
strSql.Append("transMoney=" + model.transMoney + ",");
}
if (model.remark != null)
{
strSql.Append("remark='" + model.remark + "',");
}
else
{
strSql.Append("remark= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where transDate='" + model.transDate + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
