public LookupData GetLookup(LookupCriteria criteria) { string sSQL = ""; //= criteria.SQL; if (!string.IsNullOrEmpty(criteria.LookupID)) { sSQL = string.Format("SELECT Code AS K,Value AS V,Par1 as P1,Par2 as P2 FROM APP_LookUp WHERE LookupID='{0}' and flagDelete=0", criteria.LookupID); sSQL += criteria.SQL; sSQL += " order by [SORTBY]"; } LookupData result = new LookupData() { LookupID = string.IsNullOrEmpty(criteria.LookupID) ? string.Empty : criteria.LookupID }; List <LookupDataItem> _Items = DataProvider.LoadData <LookupDataItem>(sSQL); result.Items.AddRange(_Items); return(result); }
public void GetLookUp(DataRequest request, DataResponse result, DataProvider datasource) { LookupCriteria criteria = TJson.Parse <LookupCriteria>(request["P0"]); result.Value = ToJson(new LookupOP(request.LogIn, datasource).GetLookup(criteria)); }