public override void OnParseFilterOptions(ParseFilterOptionsEventArgs e) { string PRODMaterialQuality = Convert.ToString(e.TargetData["F_PAEZ_Material_Id"]); string MaterialQualityFilterProd = ""; //int a = e.SourceBusinessInfo.GetEntryCount(); //Entity FillStatus = e.SourceBusinessInfo.GetEntity("FBillHead"); //DynamicObject FillStatusObj = new DynamicObject(FillStatus.DynamicObjectType); //string FillStatusSqlFilter = Convert.ToString(FillStatusObj["FBillStatus"]); ////先查物料表 查出物料ID 然后去合同信息过滤数据 //DynamicObject[] lotMasters = null; //string filter = string.Format("F_BEM_CZ ='{0}'", PRODMaterialQuality); //OQLFilter of = OQLFilter.CreateHeadEntityFilter(filter); //lotMasters = BusinessDataServiceHelper.Load(this.Context, "BD_MATERIAL", null, of); //if (lotMasters.Count() > 0) //{ // foreach (DynamicObject objma in lotMasters) // { // materialList.Add(Convert.ToString(objma[0])); // } //} // string sqlSearchCondition = " FMATERIALID in ('{0}')" + string.Join("','", materialList); MaterialQualityFilterProd = String.Format(" F_PAEZ_PRODUCTMATERIAL = {0} ", PRODMaterialQuality); // MaterialQualityFilterProd = sqlSearchCondition; if (String.IsNullOrEmpty(e.FilterOptionsSQL)) { e.FilterOptionsSQL = MaterialQualityFilterProd; } }