public static DataSet Search(int pageSize, int pageIndex, out int pageCount, string keyword, DateTime beg, DateTime end, Guid catalogId, Guid userId)
{
/** 使用索引搜索开始 *****************************/
if (ResourceIndex.IsUsingIndex)
{
return(ResourceIndex.Search(pageSize, pageIndex, out pageCount, keyword + " " + catalogId, beg, end));
}
/** 使用索引搜索结束 *******************************/
pageCount = 0;
string sqlWhere = string.Empty;
if (!string.IsNullOrEmpty(keyword))
{
sqlWhere += " And (Keyword like '%" + keyword + "%' or Caption like '%" + keyword + "%' or ItemSerialNumber like '%" + keyword + "%')";
}
if (catalogId != Guid.Empty)
{
sqlWhere += " And ic.catalogId='" + catalogId.ToString() + "'";
}
if (beg != DateTime.MaxValue &&
end != DateTime.MaxValue)
{
sqlWhere += " And datediff(d,'" + beg.ToShortDateString() + "',i.uploadDate)>=0 And datediff(d,'" + end.ToShortDateString() + "',i.uploadDate)<=0";
}
QJVRMS.Business.SearchWS.SearchService ss = new QJVRMS.Business.SearchWS.SearchService();
return(ss.Search(sqlWhere, userId, pageIndex, pageSize));
}
/// <summary>
///按关键字或编号，上传时间，有效期，分类，审核状态搜索资源，
/// </summary>
/// <returns></returns>
public static DataSet Search(string keyword, string beginDate, string endDate, string Catalogid, string Userid, int PageSize, int PageNum, ref int pageCount, string resourceType, string groupid, int validateStatus)
{
/** 使用索引搜索开始 *****************************/
if (ResourceIndex.IsUsingIndex)
{
if (Catalogid.Equals(new Guid().ToString()))
{
Catalogid = "";
}
else
{
Catalogid = " " + Catalogid;
}
if (!string.IsNullOrEmpty(groupid.Trim()))
{
groupid = " " + groupid;
}
else
{
groupid = "";
}
PageNum++;
return(ResourceIndex.Search(keyword + Catalogid + groupid, beginDate, endDate, Userid, PageSize, PageNum, ref pageCount, resourceType));
}
/** 使用索引搜索结束 *******************************/
QJVRMS.Business.ResourceWS.ResourceService rs = new ResourceService();
return(rs.SearchResource(keyword, beginDate, endDate, Catalogid, Userid, PageSize, PageNum, ref pageCount, resourceType, groupid, validateStatus));
}
/// <summary>
/// 平安时用的
/// </summary>
/// <param name="catalogId"></param>
/// <param name="userId"></param>
/// <param name="deptID"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public static DataSet SearchByDept(Guid catalogId, Guid userId, Guid deptID, int pageSize, int pageIndex)
{
/** 使用索引搜索开始 *****************************/
if (ResourceIndex.IsUsingIndex)
{
string Catalogid = catalogId.ToString();
string groupid = deptID.ToString();
string keyword = string.Empty;
string beginDate = string.Empty;
string endDate = string.Empty;
string Userid = userId.ToString();
int PageSize = pageSize;
int PageNum = pageIndex;
string resourceType = "video,image,document,other";
int pageCount = 0;
if (Catalogid.Equals(new Guid().ToString()))
{
Catalogid = "";
}
else
{
Catalogid = " " + Catalogid;
}
if (!string.IsNullOrEmpty(groupid.Trim()))
{
groupid = " " + groupid;
}
else
{
groupid = "";
}
PageNum++;
DataSet ds = ResourceIndex.Search(keyword + Catalogid + groupid, beginDate, endDate, Userid, PageSize, PageNum, ref pageCount, resourceType);
DataSet newDS = new DataSet();
newDS.Tables.Add(ds.Tables[1].DefaultView.ToTable());
newDS.Tables.Add(ds.Tables[0].DefaultView.ToTable());
return(newDS);
}
/** 使用索引搜索结束 *******************************/
QJVRMS.Business.SearchWS.SearchService ss = new QJVRMS.Business.SearchWS.SearchService();
return(ss.SearchByDept(catalogId, userId, deptID, pageSize, pageIndex));
}
