public void Insert(int publishmentSystemId, int couponId, int totalNum)
{
var couponSnList = CouponManager.GetCouponSN(totalNum);
foreach (var sn in couponSnList)
{
string sqlString =
$"INSERT INTO {TableName} (PublishmentSystemID, CouponID, SN, Status) VALUES ({publishmentSystemId}, {couponId}, '{sn}', '{ECouponStatusUtils.GetValue(ECouponStatus.Unused)}')";
ExecuteNonQuery(sqlString);
}
DataProviderWx.CouponDao.UpdateTotalNum(couponId, DataProviderWx.CouponSnDao.GetTotalNum(publishmentSystemId, couponId));
}
