public DataTable FindList(string Keywords, int groupdoc, int cateid, int agentId, int doctypeId, int AreaId, bool?Status, string lang, DateTime?fromDate, DateTime?toDate, ePower.Core.PagingInfo paging)
{
Db db = new Db();
DbParameter[] param = new DbParameter[12];
param[0] = new DbParameter("@keyword", Keywords);
param[1] = new DbParameter("@CateOfficialID", cateid);
param[2] = new DbParameter("@DocTypeId", doctypeId);
if (fromDate != null)
{
param[3] = new DbParameter("@FromDate", fromDate);
}
else
{
param[3] = new DbParameter("@FromDate", DBNull.Value);
}
if (toDate != null)
{
param[4] = new DbParameter("@ToDate", toDate);
}
else
{
param[4] = new DbParameter("@ToDate", DBNull.Value);
}
if (Status != null)
{
param[5] = new DbParameter("@Status", Status);
}
else
{
param[5] = new DbParameter("@Status", DBNull.Value);
}
param[6] = new DbParameter("@GroupDoc", groupdoc);
param[7] = new DbParameter("@AreaId", AreaId);
param[8] = new DbParameter("@Language", lang);
param[9] = new DbParameter("@CurrentPage", paging.CurrentPage);
param[10] = new DbParameter("@PageSize", paging.PageSize);
param[11] = new DbParameter("@AgentId", agentId);
return(db.GetDataTable("_DocumentSearch", param, CommandType.StoredProcedure));
}
public DataTable FindList(string Keywords, int groupdoc, int cateid, int agentId, int doctypeId, int AreaId, bool?Status, string lang, DateTime?fromDate, DateTime?toDate, ePower.Core.PagingInfo paging)
{
return(typesDAO.FindList(Keywords, groupdoc, cateid, agentId, doctypeId, AreaId, Status, lang, fromDate, toDate, paging));
}