public void InsertBudgetSalesFee(int CustomerID, int ExpenseItemID, DateTime Period, decimal OriginalBudget, decimal NormalBudget, decimal AdjustBudget, decimal TransferBudget, int UserID, int PositionID, String ModifyReason)
{
SqlTransaction transaction = null;
try {
////事务开始
transaction = TableAdapterHelper.BeginTransaction(this.TABudgetSales);
TableAdapterHelper.SetTransaction(this.TABudgetSalesHistory, transaction);
//检验重复性 客户、费用项、费用期间三项不能重复
int iCount = this.TABudgetSales.SearchBudgetSalesByIns(CustomerID, ExpenseItemID, Period).GetValueOrDefault();
if (iCount > 0)
{
throw new ApplicationException("客户、费用项、费用期间三项不能重复!");
}
// 父表
BudgetDS.BudgetSalesFeeDataTable table = new BudgetDS.BudgetSalesFeeDataTable();
BudgetDS.BudgetSalesFeeRow row = table.NewBudgetSalesFeeRow();
row.CustomerID = CustomerID;
row.ExpenseItemID = ExpenseItemID;
row.Period = Period;
row.OriginalBudget = OriginalBudget;
row.NormalBudget = NormalBudget;
row.AdjustBudget = AdjustBudget;
row.TransferBudget = TransferBudget;
row.ModifyReason = ModifyReason;
table.AddBudgetSalesFeeRow(row);
this.TABudgetSales.Update(table);
// 子表
BudgetDS.BudgetSalesFeeHistoryDataTable tableDetail = new BudgetDS.BudgetSalesFeeHistoryDataTable();
BudgetDS.BudgetSalesFeeHistoryRow rowDetail = tableDetail.NewBudgetSalesFeeHistoryRow();
rowDetail.BudgetSalesFeeID = row.BudgetSalesFeeID;
rowDetail.UserID = UserID;
rowDetail.PositionID = PositionID;
rowDetail.ModifyDate = DateTime.Now;
rowDetail.Action = "Create";
rowDetail.CustomerID = CustomerID;
rowDetail.ExpenseItemID = ExpenseItemID;
rowDetail.Period = Period;
rowDetail.OriginalBudget = OriginalBudget;
rowDetail.NormalBudget = NormalBudget;
rowDetail.AdjustBudget = AdjustBudget;
rowDetail.TransferBudget = TransferBudget;
rowDetail.ModifyReason = ModifyReason;
tableDetail.AddBudgetSalesFeeHistoryRow(rowDetail);
this.TABudgetSalesHistory.Update(tableDetail);
transaction.Commit();
} catch (Exception ex) {
transaction.Rollback();
throw ex;
} finally {
transaction.Dispose();
}
}
public void UpdateBudgetSalesFee(int BudgetSalesFeeID, decimal NormalBudget, decimal AdjustBudget, decimal TransferBudget, int UserID, int PositionID, String ModifyReason)
{
SqlTransaction transaction = null;
try {
////事务开始
transaction = TableAdapterHelper.BeginTransaction(this.TABudgetSales);
TableAdapterHelper.SetTransaction(this.TABudgetSalesHistory, transaction);
// 父表
BudgetDS.BudgetSalesFeeRow row = this.TABudgetSales.GetDataById(BudgetSalesFeeID)[0];
if (row.TotalBudget > (NormalBudget + AdjustBudget)) //如果是减少预算,要做检查
{
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = this.GetSalesBudgetByParameter(row.CustomerID, row.Period, new MasterDataBLL().GetExpenseItemByID(row.ExpenseItemID).ExpenseSubCategoryID);
if (row.TotalBudget - NormalBudget - AdjustBudget - TransferBudget > calculateAssistant[12])
{
throw new ApplicationException("本次修改导致原有记录超预算，不能修改");
}
}
row.NormalBudget = NormalBudget;
row.AdjustBudget = AdjustBudget;
row.TransferBudget = TransferBudget;
row.ModifyReason = ModifyReason;
this.TABudgetSales.Update(row);
// 子表
BudgetDS.BudgetSalesFeeHistoryDataTable tableDetail = new BudgetDS.BudgetSalesFeeHistoryDataTable();
BudgetDS.BudgetSalesFeeHistoryRow rowDetail = tableDetail.NewBudgetSalesFeeHistoryRow();
rowDetail.BudgetSalesFeeID = row.BudgetSalesFeeID;
rowDetail.UserID = UserID;
rowDetail.PositionID = PositionID;
rowDetail.ModifyDate = DateTime.Now;
rowDetail.Action = "Modify";
rowDetail.CustomerID = row.CustomerID;
rowDetail.ExpenseItemID = row.ExpenseItemID;
rowDetail.Period = row.Period;
rowDetail.OriginalBudget = row.OriginalBudget;
rowDetail.NormalBudget = NormalBudget;
rowDetail.AdjustBudget = AdjustBudget;
rowDetail.TransferBudget = TransferBudget;
rowDetail.ModifyReason = ModifyReason;
tableDetail.AddBudgetSalesFeeHistoryRow(rowDetail);
this.TABudgetSalesHistory.Update(tableDetail);
transaction.Commit();
} catch (Exception ex) {
transaction.Rollback();
throw ex;
} finally {
transaction.Dispose();
}
}
public void UpdateBudgetSalesFee(int BudgetSalesFeeID, decimal NormalBudget, decimal AdjustBudget,decimal TransferBudget, int UserID, int PositionID, String ModifyReason)
{
SqlTransaction transaction = null;
try {
////����ʼ
transaction = TableAdapterHelper.BeginTransaction(this.TABudgetSales);
TableAdapterHelper.SetTransaction(this.TABudgetSalesHistory, transaction);
// ����
BudgetDS.BudgetSalesFeeRow row = this.TABudgetSales.GetDataById(BudgetSalesFeeID)[0];
if (row.TotalBudget > (NormalBudget + AdjustBudget)) {//����Ǽ���Ԥ��,Ҫ�����
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = this.GetSalesBudgetByParameter(row.CustomerID, row.Period, new MasterDataBLL().GetExpenseItemByID(row.ExpenseItemID).ExpenseSubCategoryID);
if (row.TotalBudget - NormalBudget - AdjustBudget - TransferBudget > calculateAssistant[12]) {
throw new ApplicationException("�����ĵ���ԭ�м�¼��Ԥ�㣬������");
}
}
row.NormalBudget = NormalBudget;
row.AdjustBudget = AdjustBudget;
row.TransferBudget = TransferBudget;
row.ModifyReason = ModifyReason;
this.TABudgetSales.Update(row);
// �ӱ�
BudgetDS.BudgetSalesFeeHistoryDataTable tableDetail = new BudgetDS.BudgetSalesFeeHistoryDataTable();
BudgetDS.BudgetSalesFeeHistoryRow rowDetail = tableDetail.NewBudgetSalesFeeHistoryRow();
rowDetail.BudgetSalesFeeID = row.BudgetSalesFeeID;
rowDetail.UserID = UserID;
rowDetail.PositionID = PositionID;
rowDetail.ModifyDate = DateTime.Now;
rowDetail.Action = "Modify";
rowDetail.CustomerID = row.CustomerID;
rowDetail.ExpenseItemID = row.ExpenseItemID;
rowDetail.Period = row.Period;
rowDetail.OriginalBudget = row.OriginalBudget;
rowDetail.NormalBudget = NormalBudget;
rowDetail.AdjustBudget = AdjustBudget;
rowDetail.TransferBudget = TransferBudget;
rowDetail.ModifyReason = ModifyReason;
tableDetail.AddBudgetSalesFeeHistoryRow(rowDetail);
this.TABudgetSalesHistory.Update(tableDetail);
transaction.Commit();
} catch (Exception ex) {
transaction.Rollback();
throw ex;
} finally {
transaction.Dispose();
}
}
public void InsertBudgetSalesFee(int CustomerID, int ExpenseItemID, DateTime Period, decimal OriginalBudget, decimal NormalBudget, decimal AdjustBudget, decimal TransferBudget, int UserID, int PositionID, String ModifyReason)
{
SqlTransaction transaction = null;
try {
////����ʼ
transaction = TableAdapterHelper.BeginTransaction(this.TABudgetSales);
TableAdapterHelper.SetTransaction(this.TABudgetSalesHistory, transaction);
//�����ظ��� �ͻ�������������ڼ�������ظ�
int iCount = this.TABudgetSales.SearchBudgetSalesByIns(CustomerID, ExpenseItemID, Period).GetValueOrDefault();
if (iCount > 0) {
throw new ApplicationException("�ͻ�������������ڼ�������ظ�!");
}
// ����
BudgetDS.BudgetSalesFeeDataTable table = new BudgetDS.BudgetSalesFeeDataTable();
BudgetDS.BudgetSalesFeeRow row = table.NewBudgetSalesFeeRow();
row.CustomerID = CustomerID;
row.ExpenseItemID = ExpenseItemID;
row.Period = Period;
row.OriginalBudget = OriginalBudget;
row.NormalBudget = NormalBudget;
row.AdjustBudget = AdjustBudget;
row.TransferBudget = TransferBudget;
row.ModifyReason = ModifyReason;
table.AddBudgetSalesFeeRow(row);
this.TABudgetSales.Update(table);
// �ӱ�
BudgetDS.BudgetSalesFeeHistoryDataTable tableDetail = new BudgetDS.BudgetSalesFeeHistoryDataTable();
BudgetDS.BudgetSalesFeeHistoryRow rowDetail = tableDetail.NewBudgetSalesFeeHistoryRow();
rowDetail.BudgetSalesFeeID = row.BudgetSalesFeeID;
rowDetail.UserID = UserID;
rowDetail.PositionID = PositionID;
rowDetail.ModifyDate = DateTime.Now;
rowDetail.Action = "Create";
rowDetail.CustomerID = CustomerID;
rowDetail.ExpenseItemID = ExpenseItemID;
rowDetail.Period = Period;
rowDetail.OriginalBudget = OriginalBudget;
rowDetail.NormalBudget = NormalBudget;
rowDetail.AdjustBudget = AdjustBudget;
rowDetail.TransferBudget = TransferBudget;
rowDetail.ModifyReason = ModifyReason;
tableDetail.AddBudgetSalesFeeHistoryRow(rowDetail);
this.TABudgetSalesHistory.Update(tableDetail);
transaction.Commit();
} catch (Exception ex) {
transaction.Rollback();
throw ex;
} finally {
transaction.Dispose();
}
}