public DataTable GetList(string TableOrViewName)
{
HardCodeDataContext dataContext = new HardCodeDataContext();
var ListResult = dataContext.ExecuteQuery <HCYesNo>(string.Format("exec spGetPaged '{0}','{1}','{2}','{3}',N'{4}'", TableOrViewName, "Code", 1000, 1, ""));
DataTable dt = new Converter <HCYesNo>().ToDataTable(ListResult);
return(dt);
}
public DataTable GetDataSource(SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
dataContext = new HardCodeDataContext();
string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = dataContext.ExecuteQuery <HCYesNo>(string.Format("exec spGetPaged '{0}','{1}','{2}','{3}',N'{4}'", TableOrViewName, SortString, PageSize, CurrentPage, WhereCond));
DataTable dt = new Converter <HCYesNo>().ToDataTable(ListResult);
return(dt);
}
public BaseBOLHardCode()
{
dataContext = new HardCodeDataContext();
}