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)); }