public static DataTable GetSalBudgetBeforePeriodSum(string ProjectCode, int IYear) { DataTable table2; try { SalBudgetDtlStrategyBuilder builder = new SalBudgetDtlStrategyBuilder(); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.ProjectCode, ProjectCode)); ArrayList pas = new ArrayList(); pas.Add("0"); pas.Add(IYear.ToString()); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.IYearRange, pas)); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.IMonth, "0")); string queryString = builder.BuildQuerySumString(); QueryAgent agent = new QueryAgent(); DataTable table = agent.ExecSqlForDataSet(queryString).Tables[0]; agent.Dispose(); table2 = table; } catch (Exception exception) { throw exception; } return(table2); }
public static EntityData GetSalBudgetDtlByProjectYM(string ProjectCode, int IYear, int IMonth) { EntityData data2; try { SalBudgetDtlStrategyBuilder builder = new SalBudgetDtlStrategyBuilder(); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.ProjectCode, ProjectCode)); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.IYear, IYear.ToString())); builder.AddStrategy(new Strategy(SalBudgetDtlStrategyName.IMonth, IMonth.ToString())); string queryString = builder.BuildMainQueryString(); QueryAgent agent = new QueryAgent(); EntityData data = agent.FillEntityData("SalBudgetDtl", queryString); agent.Dispose(); data2 = data; } catch (Exception exception) { throw exception; } return(data2); }