/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Tz888.Model.ConsumeRepay model)
{
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 30),
new SqlParameter("@RepayWay", SqlDbType.VarChar, 20),
new SqlParameter("@RepayMoney", SqlDbType.Float, 8),
new SqlParameter("@RepayStatus", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8),
new SqlParameter("@AuditMan", SqlDbType.VarChar, 30),
new SqlParameter("@RepayDate", SqlDbType.DateTime, 8),
new SqlParameter("@AuditStatus", SqlDbType.Int, 4),
new SqlParameter("@AuditDescript", SqlDbType.Text),
new SqlParameter("@flag", SqlDbType.VarChar, 30),
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.RepayWay;
parameters[2].Value = model.RepayMoney;
parameters[3].Value = model.RepayStatus;
parameters[4].Value = model.Createdate;
parameters[5].Value = model.AuditMan;
parameters[6].Value = model.RepayDate;
parameters[7].Value = model.AuditStatus;
parameters[8].Value = model.AuditDescript;
parameters[9].Value = "Insert";
bool b = DbHelperSQL.RunProcLob("ConsumeRepayInfo", parameters);
return(b);
}
/// <summary>
/// 审核
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Tz888.Model.ConsumeRepay model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RepayID", SqlDbType.Int, 4),
new SqlParameter("@AuditMan", SqlDbType.VarChar, 30),
new SqlParameter("@AuditStatus", SqlDbType.Int, 4),
new SqlParameter("@AuditDescript", SqlDbType.Text),
new SqlParameter("@RepayDate", SqlDbType.DateTime, 8),
new SqlParameter("@flag", SqlDbType.VarChar, 30),
};
parameters[0].Value = model.RepayID;
parameters[1].Value = model.AuditMan;
parameters[2].Value = model.AuditStatus;
parameters[3].Value = model.AuditDescript;
parameters[4].Value = model.RepayDate;
parameters[5].Value = "Update";
bool b = DbHelperSQL.RunProcLob("ConsumeRepayInfo", parameters);
return(b);
}