/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SystemInterestSettlement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemInterestSettlement(");
strSql.Append("UserId,ClaimsId,GetInterestDate,BalanceDate,BalanceMoney,BalanceStatus,BalanceType");
strSql.Append(") values (");
strSql.Append("@UserId,@ClaimsId,@GetInterestDate,@BalanceDate,@BalanceMoney,@BalanceStatus,@BalanceType");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@ClaimsId", SqlDbType.Int, 4),
new SqlParameter("@GetInterestDate", SqlDbType.VarChar, 20),
new SqlParameter("@BalanceDate", SqlDbType.VarChar, 20),
new SqlParameter("@BalanceMoney", SqlDbType.Decimal, 9),
new SqlParameter("@BalanceStatus", SqlDbType.Int, 4),
new SqlParameter("@BalanceType", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.ClaimsId;
parameters[2].Value = model.GetInterestDate;
parameters[3].Value = model.BalanceDate;
parameters[4].Value = model.BalanceMoney;
parameters[5].Value = model.BalanceStatus;
parameters[6].Value = model.BalanceType; return(db.ExecNon(strSql.ToString(), parameters));
}
///// <summary>
///// 更新一条数据
///// </summary>
//public bool Update(SystemInterestSettlement model)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("update SystemInterestSettlement set ");
// strSql.Append(" UserId = @UserId , ");
// strSql.Append(" ClaimsId = @ClaimsId , ");
// strSql.Append(" GetInterestDate = @GetInterestDate , ");
// strSql.Append(" BalanceDate = @BalanceDate , ");
// strSql.Append(" BalanceMoney = @BalanceMoney , ");
// strSql.Append(" BalanceStatus = @BalanceStatus , ");
// strSql.Append(" BalanceType = @BalanceType ");
// strSql.Append(" where ID=@ID ");
// SqlParameter[] parameters = {
// new SqlParameter("@ID", SqlDbType.Int,4) ,
// new SqlParameter("@UserId", SqlDbType.Int,4) ,
// new SqlParameter("@ClaimsId", SqlDbType.Int,4) ,
// new SqlParameter("@GetInterestDate", SqlDbType.VarChar,20) ,
// new SqlParameter("@BalanceDate", SqlDbType.VarChar,20) ,
// new SqlParameter("@BalanceMoney", SqlDbType.Decimal,9) ,
// new SqlParameter("@BalanceStatus", SqlDbType.Int,4) ,
// new SqlParameter("@BalanceType", SqlDbType.Int,4)
// };
// parameters[0].Value = model.ID;
// parameters[1].Value = model.UserId;
// parameters[2].Value = model.ClaimsId;
// parameters[3].Value = model.GetInterestDate;
// parameters[4].Value = model.BalanceDate;
// parameters[5].Value = model.BalanceMoney;
// parameters[6].Value = model.BalanceStatus;
// parameters[7].Value = model.BalanceType;
// return sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false;
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemInterestSettlement GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, UserId, ClaimsId, GetInterestDate, BalanceDate, BalanceMoney, BalanceStatus, BalanceType ");
strSql.Append(" from SystemInterestSettlement ");
strSql.Append(" where ");
strSql.Append(where);
var dt = db.GetTable(strSql.ToString());
SystemInterestSettlement model = null;
if (dt.Rows.Count > 0)
{
model = Mapper.DynamicMap <IDataReader, List <SystemInterestSettlement> >(dt.CreateDataReader()).FirstOrDefault();
}
return(model);
}
