public long AddRechargeBlance(RechargeRequestInfo rechargeRequest)
{
if (rechargeRequest != null)
{
MySqlParameter[] parameters =
{
new MySqlParameter("?TradeDate", MySqlDbType.Int32),
new MySqlParameter("?RechargeBlance", MySqlDbType.DateTime),
new MySqlParameter("?UserId", MySqlDbType.Int32),
new MySqlParameter("?PaymentGateway", MySqlDbType.Decimal),
(MySqlParameter)DbHelperMySQL.CreateReturnParam("Status", MySqlDbType.Int32, 4),
(MySqlParameter)DbHelperMySQL.CreateReturnParam("RechargeId", MySqlDbType.Int32, 4)
};
parameters[0].Value = rechargeRequest.TradeDate;
parameters[1].Value = rechargeRequest.RechargeBlance;
parameters[2].Value = rechargeRequest.UserId;
parameters[3].Value = rechargeRequest.PaymentGateway;
//TODO: 存储过程
DbHelperSQL.RunProcedure("sp_cf_rechargeRequest_Create", parameters);
if ((int)parameters[4].Value == 0)
{
return((long)parameters[5].Value);
}
}
return(0L);
}
