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