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); } }