public byte[] FileSearch(string where, string whereContact, string whereCaseStatus, bool includeXrefs) { DataSet ds = this.ExecuteDataset("FileSearchXref", where, whereContact, whereCaseStatus, includeXrefs); ds.RemotingFormat = SerializationFormat.Binary; ds.Tables[0].RemotingFormat = SerializationFormat.Binary; appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable(); dt.Merge(ds.Tables[0]); dt.RemotingFormat = this.RemotingFormat; return(CompressData(dt)); }
public byte[] FileSearch(string userName, DateTime dateStart, DateTime dateEnd) { DataSet ds = this.ExecuteDataset("FileSearchRecentFiles", userName, dateStart, dateEnd); ds.RemotingFormat = SerializationFormat.Binary; ds.Tables[0].RemotingFormat = SerializationFormat.Binary; appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable(); dt.Merge(ds.Tables[0]); dt.RemotingFormat = this.RemotingFormat; return(CompressData(dt)); }
public byte[] FileSearch(string search, string keyword, int officeId) { string spName; switch (search) { case "ICASE": spName = "FileSearchByICASENumber"; break; case "ParentFile": spName = "FileSearchFindParentFile"; break; case "FileId": spName = "FileSearchByFileId"; break; case "ParentFileId": spName = "FileSearchByParentFileId"; break; case "SIN": spName = "FileSearchBySIN"; break; case "OfficeFileNum": spName = "FileSearchByOfficeFileNum"; break; case "LastName": spName = "FileSearchByLastName"; break; case "LastNameExact": spName = "FileSearchByLastNameExact"; break; case "FileNumber": spName = "FileSearchByFileNumber"; break; case "FullFileNumber": spName = "FileSearchByFullFileNumber"; break; case "FullFileName": spName = "FileSearchByFullFileName"; break; default: spName = "FileSearchByKeyword"; break; } // DataSet ds=this.ExecuteDataset( spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId)); DataSet ds = this.ExecuteDataset(spName, keyword, officeId); ds.RemotingFormat = SerializationFormat.Binary; ds.Tables[0].RemotingFormat = SerializationFormat.Binary; // if(base.myTrans==null) // ds=SqlHelper.ExecuteDataset(this.SqlCon, CommandType.StoredProcedure, spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId)); // else // ds=SqlHelper.ExecuteDataset(this.myTrans, CommandType.StoredProcedure, spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId)); appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable(); dt.Constraints.Clear(); dt.Merge(ds.Tables[0]); dt.RemotingFormat = this.RemotingFormat; return(CompressData(dt)); }