/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RepaymentRecordModel model)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append("insert into RepaymentRecord(");
//strSql.Append("RepayDate,Principal,Interest,CreateTime,CreateUserID,LoanID)");
//strSql.Append(" values (");
//strSql.Append("@RepayDate,@Principal,@Interest,@CreateTime,@CreateUserID,@LoanID)");
//strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RepayDate", SqlDbType.DateTime),
new SqlParameter("@Principal", SqlDbType.Decimal, 9),
new SqlParameter("@Interest", SqlDbType.Decimal, 9),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@LoanID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RepayDate;
parameters[1].Value = model.Principal;
parameters[2].Value = model.Interest;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
parameters[5].Value = model.LoanID;
object obj = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocal, CommandType.StoredProcedure, "Proc_RepaymentRecordAdd", parameters);
return(obj == null ? 0 : Convert.ToInt32(obj));
}
public string Add(RepaymentRecordModel model)
{
return(_bll.Add(model) > 1
? JsonConvert.SerializeObject(AlertHelper.SuccessMessage())
: JsonConvert.SerializeObject(AlertHelper.ErrorMessage()));
}
public int Add(RepaymentRecordModel model)
{
model.CreateTime = DateTime.Now;
model.CreateUserID = (int)SessionHelper.Get("UserID");
return(_dal.Add(model));
}
