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="r">资源实体类型</param>
/// <returns></returns>
public void Add(ResourceEntity r)
{
ResourceService rs = new ResourceService();
rs.Add(r.ItemId, r.ItemSerialNum, r.FileName,
r.FolderName,
r.FileSize,
r.ServerFileName,
r.Caption,
r.StartDate,
r.EndDate,
r.uploadDate,
r.shotDate,
r.Keyword,
r.Description,
r.updateDate,
r.userId,
r.Status,
r.ResourceType,
r.Author,
r.HasCopyright
);
//同时更新索引
string[] SNs = new string[] { r.ItemSerialNum };
ResourceIndex.updateIndex(SNs);
}
/// <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));
}
/// <summary>
/// 删除一个资源
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public static bool DeleteResource(Guid itemId)
{
ResourceService rs = new ResourceService();
//同时更新索引
DataSet ds = rs.GetResourceInfoByItemId(itemId.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
string[] SNs = new string[] { ds.Tables[0].Rows[0]["ItemSerialNumber"].ToString() };
ResourceIndex.deleteIndex(SNs);
}
return(rs.DeleteResource(itemId));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ResourceEntity r)
{
ResourceService rs = new ResourceService();
rs.Update(r.ItemId.ToString(),
r.Caption,
r.Keyword,
r.Description,
r.shotDate,
r.StartDate,
r.EndDate
);
//同时更新索引
string[] SNs = new string[] { r.ItemSerialNum };
ResourceIndex.updateIndex(SNs);
}
/// <summary>
/// 资源批量审核，同时也要更新索引
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="validateStatus"></param>
public void ValidateResourceByUserDate(Guid userId, DateTime startDate, DateTime endDate, int validateStatus)
{
ResourceService rs = new ResourceService();
rs.ValidateResourceByUserDate(userId, startDate, endDate, validateStatus);
//更新索引
DataSet ds = rs.GetResourceSNByUserDate(userId, startDate, endDate);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
string[] _sns = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
_sns[i] = dt.Rows[i][0].ToString();
}
ResourceIndex.updateIndex(_sns);
}
}
/// <summary>
/// 资源审核
/// </summary>
/// <param name="ids">itemid字符串数组</param>
/// <param name="validateStatus">要转到的审核状态</param>
/// <param name="reason">不通过时的原因</param>
public void ValidateResourceByIDs(string[] ids, int validateStatus, string reason)
{
ResourceService rs = new ResourceService();
rs.ValidateResourceByIDs(ids, validateStatus, reason);
//更新索引
DataSet ds = rs.GetResourceSNByIDs(ids);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
string[] _sns = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
_sns[i] = dt.Rows[i][0].ToString();
}
ResourceIndex.updateIndex(_sns);
}
}
