private void LoadDataGridPlan()
{
try
{
ConstructAnnualPlanStrategyBuilder sb = new ConstructAnnualPlanStrategyBuilder("V_ConstructAnnualPlan");
string ProjectCode = this.txtProjectCode.Value;
if (ProjectCode != "")
{
sb.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.ProjectCode, ProjectCode));
}
int IYear = BLL.ConvertRule.ToInt(this.txtIYear.Value);
sb.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.IYear, IYear.ToString()));
// string PBSUnitCode = this.txtSearchPBSUnitCode.Value.Trim();
// if (PBSUnitCode != "")
// sb.AddStrategy(new Strategy(PBSUnitStrategyName.PBSUnitCode, PBSUnitCode));
string PBSUnitName = this.txtSearchPBSUnitName.Value.Trim();
if (PBSUnitName != "")
{
sb.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.PBSUnitName, PBSUnitName));
}
sb.AddOrder("PBSUnitName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("V_ConstructAnnualPlan", sql);
qa.Dispose();
string[] arrField = { "TotalBuildArea", "PTotalInvest", "InvestBefore", "PInvest", "LCFArea" };
decimal[] arrValue = BLL.MathRule.SumColumn(entity.CurrentTable, arrField);
this.txtSumTotalBuildArea.Value = BLL.MathRule.GetDecimalShowString(arrValue[0]);
this.txtSumPTotalInvest.Value = BLL.MathRule.GetDecimalShowString(arrValue[1]);
this.txtSumInvestBefore.Value = BLL.MathRule.GetDecimalShowString(arrValue[2]);
this.txtSumPInvest.Value = BLL.MathRule.GetDecimalShowString(arrValue[3]);
this.txtSumLCFArea.Value = BLL.MathRule.GetDecimalShowString(arrValue[4]);
dgPlanList.DataSource = entity;
dgPlanList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错：" + ex.Message));
}
}
public static EntityData GetConstructAnnualPlanByProjectYear(string ProjectCode, int IYear)
{
EntityData data2;
try
{
ConstructAnnualPlanStrategyBuilder builder = new ConstructAnnualPlanStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.ProjectCode, ProjectCode));
builder.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.IYear, IYear.ToString()));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("ConstructAnnualPlan", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
public static EntityData GetCurrConstructAnnualPlanByPBSUnit(string PBSUnitCode)
{
EntityData data2;
try
{
ConstructAnnualPlanStrategyBuilder builder = new ConstructAnnualPlanStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructAnnualPlanStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddOrder("IYear", false);
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("ConstructAnnualPlan", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
