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