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