public void InsertBudgetMarketing(int OrganizationUnitID, int CustomerChannelID, int BrandID, int ExpenseCategoryID, string FPeriod, decimal? AOPBudget, decimal? AOPRBudget, decimal? ProjectionBudget, object AdjustBudgetStr, string ModifyReason, int UserID, int PositionID) { SqlTransaction transaction = null; try { ////事务开始 transaction = TableAdapterHelper.BeginTransaction(this.TABudgetMarketing); TableAdapterHelper.SetTransaction(this.TABudgetMarketingHistory, transaction); //增加重复验证 if ((int)this.TABudgetMarketing.SearchBudgetMarketingByIns(OrganizationUnitID, CustomerChannelID, BrandID, DateTime.Parse(FPeriod.Substring(0, 4) + "-" + FPeriod.Substring(4, 2) + "-01"), ExpenseCategoryID) > 0) { throw new MyException("预算重复设置", "budget exists "); } //增加上级或下级部门重复验证 if ((int)this.TABudgetMarketing.SearchBudgetMarketingByTreePath(GetTreePathByOUID(OrganizationUnitID), DateTime.Parse(FPeriod.Substring(0, 4) + "-" + FPeriod.Substring(4, 2) + "-01"), OrganizationUnitID) > 0) { throw new MyException("本财月预算重复(上级或下级部门已设置预算)!", "Budget of this month exists!"); } // 父表 Budget.BudgetMarketingDataTable table = new Budget.BudgetMarketingDataTable(); Budget.BudgetMarketingRow row = table.NewBudgetMarketingRow(); decimal? AdjustBudget = null; if (AdjustBudgetStr != null && !string.IsNullOrEmpty(AdjustBudgetStr.ToString())) { AdjustBudget = decimal.Parse(AdjustBudgetStr.ToString()); } row.OrganizationUnitID = OrganizationUnitID; row.CustomerChannelID = CustomerChannelID; row.BrandID = BrandID; row.ExpenseCategoryID = ExpenseCategoryID; row.FPeriod = DateTime.Parse(FPeriod.Substring(0, 4) + "-" + FPeriod.Substring(4, 2) + "-01"); row.AOPBudget = AOPBudget.GetValueOrDefault(); row.AOPRBudget = AOPRBudget.GetValueOrDefault(); row.ProjectionBudget = ProjectionBudget.GetValueOrDefault(); row.AdjustBudget = AdjustBudget.GetValueOrDefault(); if (ModifyReason != null) { row.ModifyReason = ModifyReason; } table.AddBudgetMarketingRow(row); this.TABudgetMarketing.Update(table); // 子表 Budget.BudgetMarketingHistoryDataTable tableDetail = new Budget.BudgetMarketingHistoryDataTable(); Budget.BudgetMarketingHistoryRow rowDetail = tableDetail.NewBudgetMarketingHistoryRow(); rowDetail.OrganizationUnitID = row.OrganizationUnitID; rowDetail.CustomerChannelID = row.CustomerChannelID; rowDetail.BrandID = row.BrandID; rowDetail.ExpenseCategoryID = row.ExpenseCategoryID; rowDetail.FPeriod = row.FPeriod; rowDetail.AOPBudget = row.AOPBudget; rowDetail.AOPRBudget = row.AOPRBudget; rowDetail.ProjectionBudget = row.ProjectionBudget; rowDetail.AdjustBudget = row.AdjustBudget; rowDetail.Action = "Create"; rowDetail.ModifyDate = DateTime.Now; rowDetail.PositionID = PositionID; rowDetail.UserID = UserID; if (ModifyReason != null) { rowDetail.ModifyReason = ModifyReason; } rowDetail.BudgetMarketingID = row.BudgetMarketingID; tableDetail.AddBudgetMarketingHistoryRow(rowDetail); this.TABudgetMarketingHistory.Update(tableDetail); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); } }
public void UpdateBudgetMarketing(int BudgetMarketingID, decimal? ProjectionBudget, decimal? AdjustBudget, string ModifyReason, int UserID, int PositionID) { SqlTransaction transaction = null; try { //事务开始 transaction = TableAdapterHelper.BeginTransaction(this.TABudgetMarketing); TableAdapterHelper.SetTransaction(this.TABudgetMarketingHistory, transaction); // 父表 Budget.BudgetMarketingRow row = this.TABudgetMarketing.GetDataByID(BudgetMarketingID)[0]; if (row.ProjectionBudget > ProjectionBudget) { decimal[] calculateAssistant = this.GetMarketingBudgetByOUID(row.OrganizationUnitID, row.FPeriod, row.CustomerChannelID, row.BrandID, row.ExpenseCategoryID); if (row.ProjectionBudget - ProjectionBudget > calculateAssistant[4]) { throw new MyException("本次修改导致原有记录超预算,不能修改,目前部门剩余预算为:" + calculateAssistant[4], "Over budget,modify failed,current remain budget is :" + calculateAssistant[4]); } } row.ProjectionBudget = ProjectionBudget.GetValueOrDefault(); row.AdjustBudget = AdjustBudget.GetValueOrDefault(); if (ModifyReason != null) { row.ModifyReason = ModifyReason; } this.TABudgetMarketing.Update(row); // 子表 Budget.BudgetMarketingHistoryDataTable tableDetail = new Budget.BudgetMarketingHistoryDataTable(); Budget.BudgetMarketingHistoryRow rowDetail = tableDetail.NewBudgetMarketingHistoryRow(); rowDetail.OrganizationUnitID = row.OrganizationUnitID; rowDetail.CustomerChannelID = row.CustomerChannelID; rowDetail.BrandID = row.BrandID; rowDetail.ExpenseCategoryID = row.ExpenseCategoryID; rowDetail.FPeriod = row.FPeriod; rowDetail.AOPBudget = row.AOPBudget; rowDetail.AOPRBudget = row.AOPRBudget; rowDetail.ProjectionBudget = row.ProjectionBudget; rowDetail.AdjustBudget = row.AdjustBudget; rowDetail.Action = "Modify"; rowDetail.ModifyDate = DateTime.Now; rowDetail.PositionID = PositionID; rowDetail.UserID = UserID; if (ModifyReason != null) { rowDetail.ModifyReason = ModifyReason; } rowDetail.BudgetMarketingID = row.BudgetMarketingID; tableDetail.AddBudgetMarketingHistoryRow(rowDetail); this.TABudgetMarketingHistory.Update(tableDetail); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); } }