public static databases.baseDS.bizSubSectorRow FindAndCache(databases.baseDS.bizSubSectorDataTable tbl, string code) { databases.baseDS.bizSubSectorRow row = tbl.FindBycode(code); if (row != null) { return(row); } databases.baseDSTableAdapters.bizSubSectorTA dataTA = new databases.baseDSTableAdapters.bizSubSectorTA(); dataTA.ClearBeforeFill = false; dataTA.FillByCode(tbl, code); row = tbl.FindBycode(code); if (row != null) { return(row); } return(null); }
public databases.baseDS.bizSubSectorDataTable GetBizSubSectorByIndustry(string industryCode) { try { databases.baseDS.bizSubSectorDataTable tbl = new databases.baseDS.bizSubSectorDataTable(); databases.DbAccess.LoadDataByIndustryCode(tbl, industryCode); return tbl; } catch (Exception ex) { WriteSysLogLocal("WS026", ex); } return null; }
public databases.baseDS.bizSubSectorDataTable GetBizSubSector_BySuperSector(string codes) { try { databases.baseDS.bizSubSectorDataTable tbl = new databases.baseDS.bizSubSectorDataTable(); databases.DbAccess.LoadDataBySuperSectorCode(tbl, codes); return tbl; } catch (Exception ex) { WriteSysLogLocal("WS042", ex); } return null; }
public databases.baseDS.bizSubSectorDataTable GetBizSubSector() { try { databases.baseDS.bizSubSectorDataTable tbl = new databases.baseDS.bizSubSectorDataTable(); databases.DbAccess.LoadData(tbl); return tbl; } catch (Exception ex) { WriteSysLogLocal("WS025", ex); } return null; }