public override string BuildSingleStrategyString(Strategy strategy) { ConstructPlanStepStrategyName name = (ConstructPlanStepStrategyName)strategy.Name; string text = ""; string parameter = ""; string text3 = ""; if (strategy.Type == StrategyType.Other) { switch (name) { case ConstructPlanStepStrategyName.VisualProgressIn: text3 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text3 != "") { text = string.Format(" VisualProgress in ({0}) ", text3); } return(text); case ConstructPlanStepStrategyName.VisualProgressNotIn: text3 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text3 != "") { text = string.Format(" VisualProgress not in ({0}) ", text3); } return(text); case ConstructPlanStepStrategyName.ProjectCode: parameter = strategy.GetParameter(0); return(string.Format(" exists(select * from PBSUnit where PBSUnitCode = a.PBSUnitCode and ProjectCode = '{0}') ", parameter)); } return(text); } return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); }
public override string BuildSingleStrategyString(Strategy strategy) { ConstructAnnualPlanStrategyName name = (ConstructAnnualPlanStrategyName)strategy.Name; string text = ""; string text3 = ""; if (strategy.Type == StrategyType.Other) { switch (name) { case ConstructAnnualPlanStrategyName.VisualProgressIn: text3 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text3 != "") { text = string.Format(" VisualProgress in ({0}) ", text3); } return(text); case ConstructAnnualPlanStrategyName.VisualProgressNotIn: text3 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text3 != "") { text = string.Format(" VisualProgress not in ({0}) ", text3); } return(text); } return(text); } return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); }
public override string BuildSingleStrategyString(Strategy strategy) { CostBudgetContractStrategyName name = (CostBudgetContractStrategyName)strategy.Name; string text2 = ""; string text3 = ""; if (strategy.Type == StrategyType.Other) { CostBudgetContractStrategyName name2 = name; if (name2 != CostBudgetContractStrategyName.False) { if (name2 != CostBudgetContractStrategyName.CostCodeIn) { return(text3); } } else { return("1=2"); } text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format(" CostCode in ({0}) ", text2); } return(text3); } return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); }
public override string BuildSingleStrategyString(Strategy strategy) { TempRoomOutStrategyName name = (TempRoomOutStrategyName)strategy.Name; string text2 = ""; string text3 = ""; if (strategy.Type == StrategyType.Other) { switch (name) { case TempRoomOutStrategyName.CheckState: return(string.Format("isnull(CheckState, 0) = '{0}'", strategy.GetParameter(0))); case TempRoomOutStrategyName.InBuildingCode: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format("exists(select * from TempRoomStructure s where s.TempBuildingCode in ({0}) and s.OutListCode = a.OutListCode)", text2); } return(text3); case TempRoomOutStrategyName.InBuildingName: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format("exists(select * from Building b, TempRoomStructure s where b.BuildingName in ({0}) and s.OutListCode = a.OutListCode and b.BuildingCode = s.TempBuildingCode)", text2); } return(text3); case TempRoomOutStrategyName.InChamberName: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format("exists(select * from Chamber c, TempRoomStructure s where c.ChamberName in ({0}) and s.OutListCode = a.OutListCode and c.ChamberCode = s.TempChamberCode)", text2); } return(text3); case TempRoomOutStrategyName.InRoomName: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format("exists(select * from Room r, TempRoomStructure s where r.RoomName in ({0}) and s.OutListCode = a.OutListCode and r.RoomCode = s.TempRoomCode)", text2); } return(text3); case TempRoomOutStrategyName.InRoomCode: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format("exists(select * from TempRoomStructure s where s.TempRoomCode in ({0}) and s.OutListCode = a.OutListCode)", text2); } return(text3); } return(text3); } return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); }
public override string BuildSingleStrategyString(Strategy strategy) { CostBudgetBackupDtlStrategyName name = (CostBudgetBackupDtlStrategyName)strategy.Name; string text2 = ""; string text3 = ""; if (strategy.Type != StrategyType.Other) { return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); } CostBudgetBackupDtlStrategyName name2 = name; if (name2 != CostBudgetBackupDtlStrategyName.False) { if (name2 != CostBudgetBackupDtlStrategyName.CostCodeIn) { if (name2 != CostBudgetBackupDtlStrategyName.GroupCodeEx) { return(text3); } string systemGroupCode = strategy.GetParameter(0); string parameter = strategy.GetParameter(1); if (parameter == null) { return(text3); } if (parameter != "0") { if (parameter != "1") { if (parameter != "2") { return(text3); } return(SystemGroupStrategyBuilder.BuildTreeNodeSearchString(systemGroupCode, TreeNodeSearchType.AllSubNotLeafNode, SystemClassDescription.GetItemTypeColumnName("CostBudgetSet"))); } } else { return(SystemGroupStrategyBuilder.BuildTreeNodeSearchString(systemGroupCode, TreeNodeSearchType.AllSubNodeIncludeSelf, SystemClassDescription.GetItemTypeColumnName("CostBudgetSet"))); } return(SystemGroupStrategyBuilder.BuildTreeNodeSearchString(systemGroupCode, TreeNodeSearchType.AllSubLeafNode, SystemClassDescription.GetItemTypeColumnName("CostBudgetSet"))); } text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format(" CostCode in ({0}) ", text2); } return(text3); } return("1=2"); }
public override string BuildSingleStrategyString(Strategy strategy) { RoomStrategyName name = (RoomStrategyName)strategy.Name; string text2 = ""; string text3 = ""; if (strategy.Type == StrategyType.Other) { switch (name) { case RoomStrategyName.InBuildingCode: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format(" BuildingCode in ({0}) ", text2); } return(text3); case RoomStrategyName.OutAspect: case RoomStrategyName.InOutAspect: return(text3); case RoomStrategyName.InvState: return(string.Format("isnull(InvState,'') ='{0}' ", strategy.GetParameter(0).Trim())); case RoomStrategyName.InInvState: text2 = StrategyConvert.BuildInStr(strategy.GetParameter(0)); if (text2 != "") { text3 = string.Format(" isnull(InvState, '') in ({0}) ", text2); } return(text3); case RoomStrategyName.OutState: return(string.Format("isnull(OutState,'') ='{0}' ", strategy.GetParameter(0).Trim())); case RoomStrategyName.SalState: return(string.Format("isnull(SalState,'') ='{0}' ", strategy.GetParameter(0).Trim())); case RoomStrategyName.False: return("1=2"); case RoomStrategyName.PBSTypeCodeAllChild: return(string.Format("(PBSTypeCode = '{0}' or PBSTypeFullID like '{0}-%')", strategy.GetParameter(0).Trim())); case RoomStrategyName.OutListCode: return(string.Format("exists(select 1 from TempRoomStructure t where t.TempRoomCode = a.RoomCode and t.OutListCode = '{0}')", strategy.GetParameter(0).Trim())); } return(text3); } return(StandardStrategyStringBuilder.BuildStrategyString(strategy)); }