DataTable IBaseBOL <DataTable> .GetDetails(int Code)
{
var ListResult = dataContext.ExecuteQuery <HCYesNo>(string.Format("exec spGetDetail '{0}','{1}'", TableOrViewName, Code));
DataTable dt = new Converter <HCYesNo>().ToDataTable(ListResult);
return(dt);
}
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);
}