예제 #1
0
        private void btnContainees_Click(object sender, System.EventArgs e)
        {
            FolderNode folder;

            // Reset the data grid
            dgrdContainees.DataSource = null;
            dgrdContainees.Show();
            btnGetContent.Enabled = false;

            // Get the ID of the folder we are to search for containees
            if (treeFolders.SelectedNode == null)
            {
                MessageBox.Show("You must first select a folder node");
                return;
            }
            folder = (FolderNode)treeFolders.SelectedNode.Tag;
            string strFolderId = folder.Id;

            // Properties to exclude in the query results
            string[] strExclude = new string[2];
            strExclude[0] = "DateCreated";
            strExclude[1] = "DateLastModified";

            // Get the folder's Containees list object
            CEWSI.ObjectRequestType   objContaineesRequest = new CEWSI.ObjectRequestType();
            CEWSI.ObjectSpecification objContaineesSpec    = new CEWSI.ObjectSpecification();
            objContaineesSpec.classId                = "Folder";
            objContaineesSpec.objectId               = strFolderId;
            objContaineesSpec.objectStore            = MainForm.Library;
            objContaineesSpec.propertyId             = "Containees";
            objContaineesRequest.SourceSpecification = objContaineesSpec;
            objContaineesRequest.id = "1";

            // Make sure to ask for the Head property of the RCR
            objContaineesRequest.PropertyFilter = new CEWSI.PropertyFilterType();
            CEWSI.FilterElementType filterHead        = new CEWSI.FilterElementType();
            CEWSI.FilterElementType filterCName       = new CEWSI.FilterElementType();
            CEWSI.FilterElementType filterId          = new CEWSI.FilterElementType();
            CEWSI.FilterElementType filterCreator     = new CEWSI.FilterElementType();
            CEWSI.FilterElementType filterContentSize = new CEWSI.FilterElementType();
            CEWSI.FilterElementType filterTitle       = new CEWSI.FilterElementType();

            filterHead.Value        = "Head";
            filterCName.Value       = "ContainmentName";
            filterId.Value          = "Id";
            filterCreator.Value     = "Creator";
            filterContentSize.Value = "ContentSize";
            filterTitle.Value       = "DocumentTitle";

            objContaineesRequest.PropertyFilter.IncludeProperties     = new CEWSI.FilterElementType[6];
            objContaineesRequest.PropertyFilter.IncludeProperties[0]  = filterHead;
            objContaineesRequest.PropertyFilter.IncludeProperties[1]  = filterCName;
            objContaineesRequest.PropertyFilter.IncludeProperties[2]  = filterId;
            objContaineesRequest.PropertyFilter.IncludeProperties[3]  = filterCreator;
            objContaineesRequest.PropertyFilter.IncludeProperties[4]  = filterContentSize;
            objContaineesRequest.PropertyFilter.IncludeProperties[5]  = filterTitle;
            objContaineesRequest.PropertyFilter.ExcludeProperties     = strExclude;
            objContaineesRequest.PropertyFilter.maxRecursion          = 1;
            objContaineesRequest.PropertyFilter.maxRecursionSpecified = true;
            // Test continuation  objContaineesRequest.maxElements = 2;
            //                    objContaineesRequest.maxElementsSpecified = true;

            // Create the request array
            CEWSI.ObjectRequestType[] objRequestArray = new CEWSI.ObjectRequestType[1];
            objRequestArray[0] = objContaineesRequest;

            // Fill in the security headers...
            CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
                                                                               MainForm.Domain, MainForm.Password, MainForm.URL);

            // Send off the request
            CEWSI.ObjectResponseType[] objResponses = null;
            try
            {
                objResponses = objBinding.GetObjects(WSIUtil.GetLocalization(), objRequestArray);
            }
            catch (System.Net.WebException ex)
            {
                MessageBox.Show("An exception occurred while querying for containees: [" + ex.Message + "]");
                return;
            }
            catch (Exception allEx)
            {
                MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
                return;
            }


            // Get the containees
            if (objResponses.Length < 1)
            {
                MessageBox.Show("No containees found");
                return;
            }

            if (objResponses[0].GetType() == typeof(CEWSI.ErrorStackResponse))
            {
                CEWSI.ErrorStackResponse objErrResponse = (CEWSI.ErrorStackResponse)objResponses[0];
                CEWSI.ErrorStackType     objStack       = objErrResponse.ErrorStack;
                CEWSI.ErrorRecordType    objErr         = objStack.ErrorRecord[0];
                MessageBox.Show("Error [" + objErr.Description + "] occurred. " +
                                " Err source is [" + objErr.Source + "]");
                return;
            }

            CEWSI.ObjectSetResponse objSetResponse = (CEWSI.ObjectSetResponse)objResponses[0];
            CEWSI.ObjectSetType     objResults     = objSetResponse.ObjectSet;
            if (objResults.Object == null || objResults.Object.Length < 1)
            {
                MessageBox.Show("No containees found");
                return;
            }

            // Query was successful; display a list of result rows
            // First create a data table that has our columns in it
            System.Data.DataColumn dtCol;
            System.Data.DataRow    dtRow;

            System.Data.DataTable dtblResults = new System.Data.DataTable("Results");

            dtCol              = new System.Data.DataColumn("RCRId");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("ContainmentName");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("Id");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("ClassID");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("Title");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("Creator");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            dtCol              = new System.Data.DataColumn("ContentSize");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            // For each containee, make an entry in our data table
            CEWSI.ObjectValue objHead = null;
            foreach (CEWSI.ObjectValue objContainee in (CEWSI.ObjectValue[])objResults.Object)
            {
                dtRow = dtblResults.NewRow();
                foreach (CEWSI.PropertyType objProp in objContainee.Property)
                {
                    if (objProp.propertyId == "ContainmentName")
                    {
                        dtRow["ContainmentName"] = IdmObjectType.getPropertyValue(objProp);
                    }

                    if (objProp.propertyId == "Id")
                    {
                        dtRow["RCRId"] = IdmObjectType.getPropertyValue(objProp);
                    }

                    if (objProp.propertyId == "Head")
                    {
                        objHead = (CEWSI.ObjectValue)((CEWSI.SingletonObject)objProp).Value;

                        dtRow["ClassId"] = objHead.classId.ToString();

                        foreach (CEWSI.PropertyType objHeadProp in objHead.Property)
                        {
                            if (objHeadProp.propertyId == "Id")
                            {
                                dtRow["Id"] = IdmObjectType.getPropertyValue(objHeadProp);
                            }
                            if (objHeadProp.propertyId == "Creator")
                            {
                                dtRow["Creator"] = IdmObjectType.getPropertyValue(objHeadProp);
                            }
                            if (objHeadProp.propertyId == "ContentSize")
                            {
                                dtRow["ContentSize"] = IdmObjectType.getPropertyValue(objHeadProp);
                            }
                            if (objHeadProp.propertyId == "DocumentTitle")
                            {
                                dtRow["Title"] = IdmObjectType.getPropertyValue(objHeadProp);
                            }
                        }
                    }
                }
                dtblResults.Rows.Add(dtRow);
                btnGetContent.Enabled = true;
            }
            dgrdContainees.DataSource = dtblResults;
            dgrdContainees.Show();
            g_dtblResults = dtblResults;
        }
예제 #2
0
        private void button1_Click(object sender, System.EventArgs e)
        {
            // OK, what are we supposed to retrieve
            System.Data.DataRow dtRow;
            int i = dgrdContainees.CurrentRowIndex;

            dtRow = g_dtblResults.Rows[i];
            string strId          = (string)dtRow["Id"];
            string strContentSize = (string)dtRow["ContentSize"];

            MessageBox.Show("Retrieving content for document [" + strId + "]  size= " + strContentSize + " bytes.");

            // Retrieve the document
            CEWSI.ObjectRequestType   objContentRequest = new CEWSI.ObjectRequestType();
            CEWSI.ObjectSpecification objContentSpec    = new CEWSI.ObjectSpecification();
            objContentSpec.classId                = "Document";
            objContentSpec.objectId               = strId;
            objContentSpec.objectStore            = MainForm.Library;
            objContentRequest.SourceSpecification = objContentSpec;
            objContentRequest.id = "1";

            // Ask for the content properties...
            CEWSI.FilterElementType[] incContentProps;
            if (UseGetContent)
            {
                incContentProps = new CEWSI.FilterElementType[1];
            }
            else
            {
                incContentProps = new CEWSI.FilterElementType[2];
            }
            incContentProps[0]       = new CEWSI.FilterElementType();
            incContentProps[0].Value = "ContentElements";
            if (!UseGetContent)
            {
                incContentProps[1]                  = new CEWSI.FilterElementType();
                incContentProps[1].Value            = "Content";
                incContentProps[1].maxSize          = 1000000;
                incContentProps[1].maxSizeSpecified = true;
            }

            objContentRequest.PropertyFilter = new CEWSI.PropertyFilterType();
            objContentRequest.PropertyFilter.IncludeProperties     = incContentProps;
            objContentRequest.PropertyFilter.maxRecursion          = 1;
            objContentRequest.PropertyFilter.maxRecursionSpecified = true;

            // Create the request array
            CEWSI.ObjectRequestType[] objRequestArray = new CEWSI.ObjectRequestType[1];
            objRequestArray[0] = objContentRequest;

            // Fill in the security headers...
            CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
                                                                               MainForm.Domain, MainForm.Password, MainForm.URL);

            // Send off the request
            CEWSI.ObjectResponseType[] objResponses = null;
            try
            {
                objResponses = objBinding.GetObjects(WSIUtil.GetLocalization(), objRequestArray);
            }
            catch (System.Net.WebException ex)
            {
                MessageBox.Show("An exception occurred while querying for containees: [" + ex.Message + "]");
                return;
            }
            catch (Exception allEx)
            {
                MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
                return;
            }


            // Did we get some content?
            if (objResponses.Length < 1)
            {
                MessageBox.Show("No content found");
                return;
            }
            if (objResponses[0].GetType() == typeof(CEWSI.ErrorStackResponse))
            {
                CEWSI.ErrorStackResponse errStackResponse = (CEWSI.ErrorStackResponse)objResponses[0];
                CEWSI.ErrorStackType     objStack         = errStackResponse.ErrorStack;
                CEWSI.ErrorRecordType    objErr           = objStack.ErrorRecord[0];
                MessageBox.Show("Error [" + objErr.Description + "] occurred. " +
                                " Err source is [" + objErr.Source + "]");
                return;
            }

            // Extract the document object from the response
            CEWSI.ObjectValue objDoc = null;
            if (objResponses[0].GetType() == typeof(CEWSI.SingleObjectResponse))
            {
                CEWSI.SingleObjectResponse objResponse = (CEWSI.SingleObjectResponse)objResponses[0];
                objDoc = objResponse.Object;
            }
            else if (objResponses[0].GetType() == typeof(CEWSI.ObjectSetResponse))
            {
                CEWSI.ObjectSetResponse objSetResponse = (CEWSI.ObjectSetResponse)objResponses[0];
                CEWSI.ObjectSetType     objSet         = objSetResponse.ObjectSet;
                objDoc = objSet.Object[0];
            }
            else
            {
                MessageBox.Show("Unknown data type returned in ObjectReponse: [" + objResponses[0].GetType().ToString() + "]");
                return;
            }

            // OK, we got some content.  Get the bits from the response packet
            // First find the ContentElements property

            /*
             * if( objDoc.Property == null )
             * {
             *      MessageBox.Show("Received a document with no properties!");
             *      return;
             * }
             */

            // Extract the content for each content element
            foreach (CEWSI.PropertyType objProp in objDoc.Property)
            {
                if (objProp.propertyId.ToLower().CompareTo("contentelements") == 0)
                {
                    CEWSI.DependentObjectType[] contTrans = (CEWSI.DependentObjectType[])((CEWSI.ListOfObject)objProp).Value;
                    if (contTrans == null)
                    {
                        MessageBox.Show("The selected document has no content");
                        break;
                    }
                    for (int nItem = 0; nItem < contTrans.Length; nItem++)
                    {
                        Byte[] byteContent = null;

                        if (UseGetContent)
                        {
                            CEWSI.ContentRequestType crt = new CEWSI.ContentRequestType();
                            crt.cacheAllowed          = true;
                            crt.cacheAllowedSpecified = true;
                            crt.id                   = "1";
                            crt.maxBytes             = 100 * 1024;
                            crt.maxBytesSpecified    = true;
                            crt.startOffset          = 0;
                            crt.startOffsetSpecified = true;
                            crt.continueFrom         = null;

                            CEWSI.ElementSpecificationType est = new CEWSI.ElementSpecificationType();
                            est.itemIndex                      = nItem;
                            est.itemIndexSpecified             = true;
                            est.elementSequenceNumber          = 0;
                            est.elementSequenceNumberSpecified = false;

                            crt.ElementSpecification = est;

                            CEWSI.ObjectSpecification objSpec = new CEWSI.ObjectSpecification();
                            objSpec.classId     = "Document";
                            objSpec.objectId    = strId;
                            objSpec.objectStore = MainForm.Library;

                            crt.SourceSpecification = objSpec;

                            CEWSI.ContentRequestType[] contReqArray = new CEWSI.ContentRequestType[1];
                            contReqArray[0] = crt;

                            CEWSI.FNCEWS40PortTypeClient binding2 = WSIUtil.ConfigureBinding(MainForm.User,
                                                                                             MainForm.Domain, MainForm.Password, MainForm.URL);

                            // Send off the request
                            CEWSI.GetContentRequest gcr = new CEWSI.GetContentRequest();
                            gcr.ContentRequest        = contReqArray;
                            gcr.validateOnly          = false;
                            gcr.validateOnlySpecified = true;
                            CEWSI.ContentResponseType[] contResponses = null;
                            try
                            {
                                contResponses = binding2.GetContent(WSIUtil.GetLocalization(), gcr);
                            }
                            catch (System.Net.WebException ex)
                            {
                                MessageBox.Show("An exception occurred while fetching content for a content element: [" + ex.Message + "]");
                                return;
                            }
                            catch (Exception allEx)
                            {
                                MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
                                return;
                            }

                            CEWSI.ContentResponseType crt2 = contResponses[0];
                            if (crt2 is CEWSI.ContentErrorResponse)
                            {
                                CEWSI.ContentErrorResponse cer      = (CEWSI.ContentErrorResponse)crt2;
                                CEWSI.ErrorStackType       objStack = cer.ErrorStack;
                                CEWSI.ErrorRecordType      objErr   = objStack.ErrorRecord[0];
                                MessageBox.Show("Error [" + objErr.Description + "] occurred. " +
                                                " Err source is [" + objErr.Source + "]");
                                return;
                            }
                            else if (crt2 is CEWSI.ContentElementResponse)
                            {
                                CEWSI.ContentElementResponse elem = (CEWSI.ContentElementResponse)crt2;
                                CEWSI.InlineContent          ic   = (CEWSI.InlineContent)elem.Content;

                                byteContent = ic.Binary;
                            }
                            else
                            {
                                MessageBox.Show("Unknown data type returned in content response: [" + crt.GetType().ToString() + "]");
                                return;
                            }
                        }       // end if (UseGetContent)
                        else
                        {
                            CEWSI.DependentObjectType contTran = (CEWSI.DependentObjectType)contTrans[nItem];
                            CEWSI.PropertyType[]      props    = (CEWSI.PropertyType[])contTran.Property;
                            if (props != null)
                            {
                                CEWSI.ContentData   contData = (CEWSI.ContentData)props[0];
                                CEWSI.InlineContent ic       = (CEWSI.InlineContent)contData.Value;

                                byteContent = ic.Binary;
                            }
                        }

                        // Write the retrieved content out to a file
                        System.DateTime now         = System.DateTime.Now;
                        string          strFileName = "C:\\Temp\\ContentElement0";                // + nItem.ToString();
                        strFileName = strFileName + "_" + now.Month.ToString();
                        strFileName = strFileName + "_" + now.Day.ToString();
                        strFileName = strFileName + "_" + now.Year.ToString();
                        strFileName = strFileName + "_" + now.Hour.ToString();
                        strFileName = strFileName + "_" + now.Minute.ToString();
                        strFileName = strFileName + "_" + now.Millisecond.ToString();
                        MessageBox.Show("Saving content of size " + byteContent.Length.ToString() + " to file: " + strFileName);
                        saveContentToFile(strFileName, byteContent);
                    }
                }
            }
        }
예제 #3
0
        private int ExpandNode(System.Windows.Forms.TreeNode objParent, FolderNode fNode)
        {
            int numSubfolders = 0;

            // Don't waste time expanding the same node twice...
            if (fNode.Expanded)
            {
                return(0);
            }

            // Properties to exclude in the query results
            string strFolderId = fNode.Id;

            string[] strExclude = new string[5];
            strExclude[0] = "DateCreated";
            strExclude[1] = "DateLastModified";

            // Comment out stuff that gets us in trouble when recursion is enabled
            strExclude[2] = "ObjectStore";
            strExclude[3] = "ClassDescription";
            strExclude[4] = "Parent";

            // Get the folder's Subfolders list object
            CEWSI.ObjectRequestType   objSubFoldersRequest = new CEWSI.ObjectRequestType();
            CEWSI.ObjectSpecification objSubFoldersSpec    = new CEWSI.ObjectSpecification();
            objSubFoldersSpec.classId                = "Folder";
            objSubFoldersSpec.objectId               = strFolderId;
            objSubFoldersSpec.objectStore            = MainForm.Library;
            objSubFoldersSpec.propertyId             = "SubFolders";
            objSubFoldersRequest.SourceSpecification = objSubFoldersSpec;
            objSubFoldersRequest.id             = "1";
            objSubFoldersRequest.PropertyFilter = new CEWSI.PropertyFilterType();
            objSubFoldersRequest.PropertyFilter.ExcludeProperties = strExclude;
            //objSubFoldersRequest.PropertyFilter.maxRecursion = 3;
            //objSubFoldersRequest.PropertyFilter.maxRecursionSpecified = true;
            //objSubFoldersRequest.maxElements = 2;
            //objSubFoldersRequest.maxElementsSpecified = true;

            // Get the folder itself
            //CEWSI.ObjectRequestType objFolderRequest = new CEWSI.ObjectRequestType();
            //CEWSI.ObjectSpecification objFolderSpec = new CEWSI.ObjectSpecification();
            //objFolderSpec.classId = "Folder";
            //objFolderSpec.objectId = strFolderId;
            //objFolderSpec.objectStore = MainForm.Library;
            //objFolderRequest.SourceSpecification = objFolderSpec;
            //objFolderRequest.id = "3";
            //objFolderRequest.PropertyFilter = new CEWSI.PropertyFilterType();
            //objFolderRequest.PropertyFilter.ExcludeProperties = strExclude;

            // Create the request array
            CEWSI.ObjectRequestType[] objRequestArray = new CEWSI.ObjectRequestType[1];
            objRequestArray[0] = objSubFoldersRequest;

            // Fill in the security headers...
            CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
                                                                               MainForm.Domain, MainForm.Password, MainForm.URL);

            // Send off the request
            CEWSI.ObjectResponseType[] objResponses = null;
            try
            {
                objResponses = objBinding.GetObjects(WSIUtil.GetLocalization(), objRequestArray);
            }
            catch (System.Net.WebException ex)
            {
                MessageBox.Show("An exception occurred while querying for a folder: [" + ex.Message + "]");
                return(0);
            }

            // Get the nodes below the parent
            if (objResponses.Length > 0 && objResponses[0].id == "1")
            {
                if (objResponses[0].GetType() == typeof(CEWSI.ErrorStackResponse))
                {
                    CEWSI.ErrorStackResponse objErrResponse = (CEWSI.ErrorStackResponse)objResponses[0];
                    CEWSI.ErrorStackType     objStack       = objErrResponse.ErrorStack;
                    CEWSI.ErrorRecordType    objErr         = objStack.ErrorRecord[0];
                    MessageBox.Show("Error [" + objErr.Description + "] occurred. " +
                                    " Err source is [" + objErr.Source + "]");
                    return(0);
                }

                CEWSI.ObjectSetResponse objSetResponse = (CEWSI.ObjectSetResponse)objResponses[0];
                CEWSI.ObjectSetType     objSet         = objSetResponse.ObjectSet;
                if (objSet.Object != null && objSet.Object.Length > 0)
                {
                    foreach (CEWSI.ObjectValue objValue in (CEWSI.ObjectValue[])objSet.Object)
                    {
                        numSubfolders += 1;
                        System.Windows.Forms.TreeNode objNode = new System.Windows.Forms.TreeNode();
                        FolderNode newNode = new FolderNode();
                        foreach (CEWSI.PropertyType objProp in objValue.Property)
                        {
                            if (objProp.propertyId == "FolderName")
                            {
                                string strName = ((CEWSI.SingletonString)objProp).Value;
                                objNode.Text = strName;
                                newNode.Name = strName;
                            }
                            if (objProp.propertyId == "Id")
                            {
                                string strId = ((CEWSI.SingletonId)objProp).Value;
                                newNode.Id = strId;
                            }
                        }
                        objNode.Tag = (object)newNode;
                        objParent.Nodes.Add(objNode);
                    }
                }
            }
            objParent.Expand();
            fNode.Expanded = true;
            return(numSubfolders);
        }
        private void btnQuery_Click(object sender, System.EventArgs e)
        {
            CEWSI.ObjectSetType objResponse = null;

            // Perform the requested query
            try
            {
                // Set up a connection to the web service.
                // Fill in the security headers...
                CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
                                                                                   MainForm.Domain, MainForm.Password, MainForm.URL);

                // Create a search object
                // Set up the scope for the query
                // Set up the SQL for the search
                CEWSI.RepositorySearch objSearch      = new CEWSI.RepositorySearch();
                CEWSI.ObjectStoreScope objSearchScope = new CEWSI.ObjectStoreScope();
                objSearchScope.objectStore = MainForm.Library;
                objSearch.SearchScope      = objSearchScope;
                objSearch.SearchSQL        = "SELECT SymbolicName, Id, IsHidden, IsSystemOwned, This FROM ClassDefinition ";
                objSearch.SearchSQL        = objSearch.SearchSQL + " WHERE AllowsSubclasses=TRUE";

                if (txtName.Text != "")
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + " AND SymbolicName LIKE '" + txtName.Text + "%'";
                }
                if (!chkIncludeSystem.Checked)
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + " AND IsSystemOwned=FALSE";
                }
                if (!chkIncludeHidden.Checked)
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + " AND IsHidden=FALSE";
                }

                // Execute the search
                objResponse = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objSearch);
            }
            catch (System.Net.WebException ex)
            {
                MessageBox.Show("An exception occurred while querying: [" + ex.Message + "]");
                return;
            }
            catch (Exception allEx)
            {
                MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
                return;
            }

            // Sanity check the results data
            long lColumnCount = 0;
            long lRowCount    = 0;
            long i;

            if (objResponse == null || objResponse.Object == null)
            {
                MessageBox.Show("The query completed successfully but the results were null!");
                return;
            }
            if (objResponse.Object.Length < 1)
            {
                MessageBox.Show("No results were found for this query.");
                return;
            }
            lColumnCount = objResponse.Object[0].Property.Length;
            if (lColumnCount < 5)
            {
                MessageBox.Show("The query succeeded, but the results are missing requested data");
                return;
            }

            // Query was successful; display a list of result rows
            // First create a data table that has one column for each property
            System.Data.DataColumn dtCol;
            System.Data.DataRow    dtRow;
            CEWSI.PropertyType     prop;

            g_Classes = objResponse.Object;
            lRowCount = g_Classes.Length;
            System.Data.DataTable dtblResults = new System.Data.DataTable("Results");

            // Name
            dtCol              = new System.Data.DataColumn("Name");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            // Class
            dtCol              = new System.Data.DataColumn("Class");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            // IsSystem
            dtCol              = new System.Data.DataColumn("IsSystem");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            // IsHidden
            dtCol              = new System.Data.DataColumn("IsHidden");
            dtCol.DataType     = System.Type.GetType("System.String");
            dtCol.DefaultValue = "";
            dtblResults.Columns.Add(dtCol);

            // Populate the rows
            CEWSI.ObjectReference objRef;
            for (i = 0; i < lRowCount; i++)
            {
                dtRow             = dtblResults.NewRow();
                prop              = g_Classes[i].Property[0];
                dtRow["Name"]     = IdmObjectType.getPropertyValue(prop);
                prop              = g_Classes[i].Property[4];
                objRef            = (CEWSI.ObjectReference)((CEWSI.SingletonObject)prop).Value;
                dtRow["Class"]    = objRef.classId;
                prop              = g_Classes[i].Property[3];
                dtRow["IsSystem"] = IdmObjectType.getPropertyValue(prop);
                prop              = g_Classes[i].Property[2];
                dtRow["IsHidden"] = IdmObjectType.getPropertyValue(prop);

                dtblResults.Rows.Add(dtRow);
            }
            dgrdResults.PreferredColumnWidth = 140;
            dgrdResults.DataSource           = dtblResults;
            dgrdResults.Show();
            btnCreateSubclass.Enabled = true;
            return;
        }
        private void btnQuery_Click(object sender, System.EventArgs e)
        {
            CEWSI.ObjectSetType objResponse = null;

            // Perform the requested query
            try
            {
                // Set up a connection to the web service.
                // Fill in the security headers...
                CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
                                                                                   MainForm.Domain, MainForm.Password, MainForm.URL);

                // Create a search object
                // Set up the scope for the query
                // Set up the SQL for the search
                CEWSI.RepositorySearch objSearch      = new CEWSI.RepositorySearch();
                CEWSI.ObjectStoreScope objSearchScope = new CEWSI.ObjectStoreScope();
                objSearchScope.objectStore = MainForm.Library;
                objSearch.SearchScope      = objSearchScope;
                objSearch.SearchSQL        = "SELECT ";
                if (txtSelect.Text == "")
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + "*";
                }
                else
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + txtSelect.Text;
                }
                objSearch.SearchSQL = objSearch.SearchSQL + " FROM " + txtFrom.Text;
                if (txtWhere.Text != "")
                {
                    objSearch.SearchSQL = objSearch.SearchSQL + " WHERE " + txtWhere.Text;
                }
                if (txtMaxRows.Text != "")
                {
                    Int32 iRows = System.Int32.Parse(txtMaxRows.Text);
                    objSearch.maxElements          = iRows;
                    objSearch.maxElementsSpecified = true;
                }

                // Execute the search
                objResponse = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objSearch);
            }
            catch (System.Net.WebException ex)
            {
                MessageBox.Show("An exception occurred while querying: [" + ex.Message + "]");
                return;
            }
            catch (Exception allEx)
            {
                MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
                return;
            }

            // Sanity check the results data
            long lColumnCount = 0;
            long lRowCount    = 0;
            long i;

            if (objResponse == null || objResponse.Object == null)
            {
                MessageBox.Show("The query completed successfully but the results were null!");
                return;
            }
            if (objResponse.Object.Length < 1)
            {
                MessageBox.Show("No results were found for this query - exiting.");
                return;
            }
            lColumnCount = objResponse.Object[0].Property.Length;
            if (lColumnCount < 1)
            {
                MessageBox.Show("The query succeeded, but the results contain no properties - exiting");
                return;
            }

            /*
             * if( lColumnCount > 12 )
             * {
             *      MessageBox.Show("The result set has more than 12 columns.  Only the first 12 columns will be displayed");
             *      lColumnCount = 12;
             * }
             */

            // Query was successful; display a list of result rows
            // First create a data table that has one column for each property in the
            //  returned data
            System.Data.DataColumn dtCol;
            System.Data.DataRow    dtRow;
            CEWSI.PropertyType     prop;

            CEWSI.ObjectValue[] objObjects = objResponse.Object;
            lRowCount = objObjects.Length;
            System.Data.DataTable dtblResults = new System.Data.DataTable("Results");
            for (i = 0; i < lColumnCount; i++)
            {
                dtCol              = new System.Data.DataColumn(objObjects[0].Property[i].propertyId);
                dtCol.DataType     = System.Type.GetType("System.String");
                dtCol.DefaultValue = "";
                dtblResults.Columns.Add(dtCol);
            }

            // Populate the rows
            for (i = 0; i < lRowCount; i++)
            {
                dtRow = dtblResults.NewRow();
                for (long iCol = 0; iCol < lColumnCount; iCol++)
                {
                    prop = objObjects[i].Property[iCol];
                    dtRow[prop.propertyId] = IdmObjectType.getPropertyValue(prop);
                }
                dtblResults.Rows.Add(dtRow);
            }
            dgrdResults.DataSource = dtblResults;
            dgrdResults.Show();
            return;
        }
예제 #6
0
        public static EcmQueryResult QueryDocument(DocumentModel doc, string query, int maxRow = 100)
        {
            EcmQueryResult ret = new EcmQueryResult();

            CEWSI.ObjectSetType objResponse = null;

            // Perform the requested query
            try
            {
                if (doc.IsUseCert == 1)
                {
                    Addcert(doc.EcmUrl);
                }
                // Set up a connection to the web service.
                // Fill in the security headers...
                CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(doc.EcmUser, doc.EcmDomain, doc.EcmPassword, doc.EcmUrl);

                // Create a search object
                // Set up the scope for the query
                // Set up the SQL for the search
                CEWSI.RepositorySearch objSearch      = new CEWSI.RepositorySearch();
                CEWSI.ObjectStoreScope objSearchScope = new CEWSI.ObjectStoreScope();
                objSearchScope.objectStore     = doc.ObjectStore;
                objSearch.SearchScope          = objSearchScope;
                objSearch.SearchSQL            = query;
                objSearch.maxElements          = maxRow;
                objSearch.maxElementsSpecified = true;

                // Execute the search
                objResponse = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objSearch);
            }
            catch (System.Net.WebException ex)
            {
                ret.ErrorCode = -1;
                ret.ErrorMsg  = "An exception occurred while querying: [" + ex.Message + "]\n" + ex.ToString();
                return(ret);
            }
            catch (Exception allEx)
            {
                ret.ErrorCode = -1;
                ret.ErrorMsg  = "An exception occurred: [" + allEx.Message + "]\n" + allEx.ToString();
                return(ret);
            }

            // Sanity check the results data
            long lColumnCount = 0;
            long lRowCount    = 0;
            long i;

            if (objResponse == null || objResponse.Object == null)
            {
                ret.ErrorCode = 1;
                ret.ErrorMsg  = "The query completed successfully but the results were null";
                return(ret);
            }
            if (objResponse.Object.Length < 1)
            {
                ret.ErrorCode = 1;
                ret.ErrorMsg  = "No results were found for this query - exiting";
                return(ret);
            }
            lColumnCount = objResponse.Object[0].Property.Length;
            if (lColumnCount < 1)
            {
                ret.ErrorCode = 1;
                ret.ErrorMsg  = "The query succeeded, but the results contain no properties - exiting";
                return(ret);
            }

            /*
             *          if( lColumnCount > 12 )
             *          {
             *                  MessageBox.Show("The result set has more than 12 columns.  Only the first 12 columns will be displayed");
             *                  lColumnCount = 12;
             *          }
             */

            // Query was successful; display a list of result rows
            // First create a data table that has one column for each property in the
            //  returned data
            System.Data.DataColumn dtCol;
            System.Data.DataRow    dtRow;
            CEWSI.PropertyType     prop;

            CEWSI.ObjectValue[] objObjects = objResponse.Object;
            lRowCount = objObjects.Length;
            System.Data.DataTable dtblResults = new System.Data.DataTable("Results");
            for (i = 0; i < lColumnCount; i++)
            {
                dtCol              = new System.Data.DataColumn(objObjects[0].Property[i].propertyId);
                dtCol.DataType     = System.Type.GetType("System.String");
                dtCol.DefaultValue = "";
                dtblResults.Columns.Add(dtCol);
            }

            // Populate the rows
            for (i = 0; i < lRowCount; i++)
            {
                dtRow = dtblResults.NewRow();
                for (long iCol = 0; iCol < lColumnCount; iCol++)
                {
                    prop = objObjects[i].Property[iCol];
                    dtRow[prop.propertyId] = IdmObjectType.getPropertyValue(prop);
                }
                dtblResults.Rows.Add(dtRow);
            }
            ret.Result    = dtblResults;
            ret.ErrorCode = 1;
            ret.ErrorMsg  = "Success";
            return(ret);
        }
예제 #7
0
        public static bool Deletedoc(DocumentModel doc, string docId, int taskId, string userName)
        {
            EcmResult ret = new EcmResult();

            //string mimeType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
            //bool isCheckin = false;
            if (doc.IsUseCert == 1)
            {
                Addcert(doc.EcmUrl);
            }

            CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(doc.EcmUser, doc.EcmDomain, doc.EcmPassword, doc.EcmUrl);

            CEWSI.ObjectStoreScope objObjectStoreScope = new CEWSI.ObjectStoreScope();
            objObjectStoreScope.objectStore = doc.ObjectStore;

            // Create RepositorySearch
            CEWSI.RepositorySearch objRepositorySearch = new CEWSI.RepositorySearch();
            objRepositorySearch.repositorySearchMode          = CEWSI.RepositorySearchModeType.Rows;
            objRepositorySearch.repositorySearchModeSpecified = true;
            objRepositorySearch.SearchScope = objObjectStoreScope;

            objRepositorySearch.SearchSQL = "SELECT [DocumentTitle],[Id],[DateLastModified],bpmCodeLarge FROM " + doc.DocumentClass + " WHERE Id='" + docId + "' AND bpmCode='" + taskId.ToString() + "' AND NguoiTao='" + userName + "' ORDER BY [DateLastModified]";


            // Invoke the ExecuteSearch operation
            CEWSI.ObjectSetType objObjectSet = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objRepositorySearch);

            // Display the Document Titles
            int hitCount = (objObjectSet.Object == null) ? 0 : objObjectSet.Object.Length;

            if (hitCount == 0)
            {
                return(true);
            }

            CEWSI.DeleteAction docUnfile = new CEWSI.DeleteAction();

            // Assign the action to the ChangeRequestType element
            CEWSI.ChangeRequestType[] objChangeRequestTypeArray = new CEWSI.ChangeRequestType[1];
            CEWSI.ChangeRequestType   objChangeRequestType      = new CEWSI.ChangeRequestType();
            objChangeRequestTypeArray[0] = objChangeRequestType;

            // Create ChangeResponseType element array
            CEWSI.ChangeResponseType[] objChangeResponseTypeArray;

            // Build ExecuteChangesRequest element and assign ChangeRequestType element array to it
            CEWSI.ExecuteChangesRequest objExecuteChangesRequest = new CEWSI.ExecuteChangesRequest();
            objExecuteChangesRequest.ChangeRequest    = objChangeRequestTypeArray;
            objExecuteChangesRequest.refresh          = true; // return a refreshed object
            objExecuteChangesRequest.refreshSpecified = true;

            objChangeRequestType.Action    = new CEWSI.ActionType[1];
            objChangeRequestType.Action[0] = (CEWSI.ActionType)docUnfile;

            // Specify the target object (Reservation object) for the actions
            objChangeRequestType.TargetSpecification             = new CEWSI.ObjectReference();
            objChangeRequestType.TargetSpecification.classId     = doc.DocumentClass;
            objChangeRequestType.TargetSpecification.objectId    = docId;
            objChangeRequestType.TargetSpecification.objectStore = doc.ObjectStore;
            objChangeRequestType.id = "1";

            // Assign ChangeRequestType element
            objChangeRequestTypeArray[0] = objChangeRequestType;

            // Build ExecuteChangesRequest element and assign ChangeRequestType element array to it
            objExecuteChangesRequest.ChangeRequest    = objChangeRequestTypeArray;
            objExecuteChangesRequest.refresh          = true; // return a refreshed object
            objExecuteChangesRequest.refreshSpecified = true;

            try
            {
                // Call ExecuteChanges operation to implement the Delete object
                objChangeResponseTypeArray = objBinding.ExecuteChanges(WSIUtil.GetLocalization(), objExecuteChangesRequest);
            }
            catch (System.Net.WebException ex)
            {
                Console.WriteLine("An exception occurred while checking out a document: [" + ex.Message + "]");
                return(false);
            }
            catch (Exception ex)
            {
                Console.WriteLine("An exception : [" + ex.Message + "]");
                return(false);
            }

            // The new document object will be returned, unless there is an error
            if (objChangeResponseTypeArray == null || objChangeResponseTypeArray.Length < 1)
            {
                Console.WriteLine("A valid object was not returned from the ExecuteChanges operation");
                return(false);
            }

            return(true);
        }