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