public static DataTable Get()
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_Get_Demo";
return(Catalog_Access.ExecuteSelectCommand(command));
}
public static DataTable Get(int Code)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_Get_Demo_By_Code";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Code";
param.Value = Code;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
return(Catalog_Access.ExecuteSelectCommand(command));
}
public static DataTable Filter_Get(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_Filter_Get_Demo";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@DisplayLength";
param.Value = iDisplayLength;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@DisplayStart";
param.Value = iDisplayStart;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@SortCol";
param.Value = iSortCol_0;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@SortDir";
param.Value = sSortDir_0;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Search";
param.Value = sSearch;
param.DbType = DbType.String;
command.Parameters.Add(param);
return(Catalog_Access.ExecuteSelectCommand(command));
}