public void InsertPurchaseRestrictionSetting(Domain.PurchaseLimitationGroup setting) { using (var dbOperator = new DbOperator(Provider, ConnectionString)){ string sql = InsertPurchaseLimitationGroup(setting, dbOperator); dbOperator.ExecuteNonQuery(sql); } }
public void UpdatePurchaseRestrictionSetting(Domain.PurchaseLimitationGroup setting) { string sql = @"DELETE FROM Rebate FROM dbo.T_PurchaseLimitationGroup LimitationGroup INNER JOIN dbo.T_PurchaseLimitation Limitation ON Limitation.LimitationGroupId = LimitationGroup.Id INNER JOIN dbo.T_PurchaseLimitationRebate Rebate ON Limitation.Id = Rebate.LimitationId WHERE IncomeGroupId= @CurrentIncomeGroupId; DELETE FROM Limitation FROM dbo.T_PurchaseLimitationGroup LimitationGroup INNER JOIN dbo.T_PurchaseLimitation Limitation ON Limitation.LimitationGroupId = LimitationGroup.Id WHERE IncomeGroupId= @CurrentIncomeGroupId; DELETE FROM dbo.T_PurchaseLimitationGroup WHERE IncomeGroupId=@CurrentIncomeGroupId;"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("CurrentIncomeGroupId", setting.IncomeGroupId); sql += InsertPurchaseLimitationGroup(setting, dbOperator); dbOperator.ExecuteNonQuery(sql); } }