public static EntityData GetV_MaterialCostByCode(string code) { EntityData data2; try { MaterialCostStrategyBuilder builder = new MaterialCostStrategyBuilder(); builder.AddStrategy(new Strategy(MaterialCostStrategyName.MaterialCostCode, code)); string queryString = builder.BuildQueryViewString(); QueryAgent agent = new QueryAgent(); EntityData data = agent.FillEntityData("MaterialCost", queryString); agent.Dispose(); data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
private void BuildSearchString() { string IsEmpty = Request["IsEmpty"] + ""; string MaterialTypeCode = Request["MaterialTypeCode"] + ""; string Unit = Request["Unit"] + ""; string Price0 = Request["Price0"] + ""; string Price1 = Request["Price1"] + ""; string Project = Request["Project"] + ""; string BiddingDate0 = Request["BiddingDate0"] + ""; string BiddingDate1 = Request["BiddingDate1"] + ""; string Description = Request["Description"] + ""; string DescriptionEn = Request["DescriptionEn"] + ""; string Category = Request["Category"] + ""; string AreaCode = Request["AreaCode"] + ""; string chkSearch = Request["ChkSearch"] + ""; string RootGroupCode = this.txtRootGroupCode.Value; MaterialCostStrategyBuilder sb = new MaterialCostStrategyBuilder(); if (IsEmpty == "1") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.False)); } if (Unit != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.Unit, "%" + Unit + "%")); } if (Price0.Trim() != "" || Price1.Trim() != "") { ArrayList ar = new ArrayList(); ar.Add(Price0.Trim()); ar.Add(Price1.Trim()); sb.AddStrategy(new Strategy(MaterialCostStrategyName.PriceRange, ar)); } if (Project != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.Project, "%" + Project + "%")); } if (BiddingDate0.Trim() != "" || BiddingDate1.Trim() != "") { ArrayList ar = new ArrayList(); ar.Add(BiddingDate0.Trim()); ar.Add(BiddingDate1.Trim()); sb.AddStrategy(new Strategy(MaterialCostStrategyName.BiddingDateRange, ar)); } if (Description != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.Description, "%" + Description + "%")); } if (DescriptionEn != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.DescriptionEn, "%" + DescriptionEn + "%")); } if (Category != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.Category, "%" + Category + "%")); } if (AreaCode != "") { sb.AddStrategy(new Strategy(MaterialCostStrategyName.AreaCode, "%" + AreaCode + "%")); } if (chkSearch == "1" && (MaterialTypeCode != "")) { ArrayList arS = new ArrayList(); arS.Add(MaterialTypeCode); arS.Add("0"); sb.AddStrategy(new Strategy(MaterialCostStrategyName.GroupCodeEx, arS)); } //只显示某个枝条 if (RootGroupCode != "") { ArrayList arS = new ArrayList(); arS.Add(RootGroupCode); arS.Add("0"); sb.AddStrategy(new Strategy(MaterialCostStrategyName.GroupCodeEx, arS)); } ArrayList arA = new ArrayList(); arA.Add(user.UserCode); arA.Add(user.BuildStationCodes()); sb.AddStrategy(new Strategy(MaterialCostStrategyName.AccessRange, arA)); // sb.AddStrategy( new Strategy( MaterialCostStrategyName.SubjectSetCode,subjectSetCode )); //排序 string sortsql = BLL.GridSort.GetSortSQL(ViewState); string sql = sb.BuildMainQueryString(); if (sortsql != "") { //点列标题排序 sql = sql + " order by " + sortsql; } this.ViewState.Add("SqlString", sql); }