// ----------------------------------------------------- // List Documents for a client // ----------------------------------------------------- public void ListClient(int clientUID) { this.documentList = new List <Model.ModelDocument.Document>(); using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + RepDocument.SQLDocumentConcat("DOC") + " FROM Document DOC " + " WHERE SourceCode = 'CLIENT' " + " AND FKClientUID = {0} " + " AND IsVoid <> 'Y' " + " ORDER BY PARENTUID ASC, SequenceNumber ASC ", clientUID); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Model.ModelDocument.Document _Document = new Model.ModelDocument.Document(); RepDocument.LoadDocumentFromReader(_Document, "DOC", reader); documentList.Add(_Document); } } } } }
// ----------------------------------------------------- // List Documents // ----------------------------------------------------- private void List(string Condition) { this.documentList = new List <Model.ModelDocument.Document>(); using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + RepDocument.SQLDocumentConcat("DOC") + " FROM Document DOC " + " WHERE DOC.SourceCode = 'FCM' " + " AND DOC.IsVoid = 'N' " + Condition + " ORDER BY PARENTUID ASC, SequenceNumber ASC " ); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Model.ModelDocument.Document _Document = new Model.ModelDocument.Document(); RepDocument.LoadDocumentFromReader(_Document, "DOC", reader); documentList.Add(_Document); } } } } }
// ----------------------------------------------------- // List Documents for a Document Set // ----------------------------------------------------- public void ListDocSet(int documentSetUID) { this.documentList = new List <Model.ModelDocument.Document>(); using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + RepDocument.SQLDocumentConcat("DOC") + " ,LNK.FKParentDocumentUID " + " ,LNK.FKParentDocumentSetUID " + " ,LNK.SequenceNumber " + " FROM Document DOC " + " ,DocumentSetDocument LNK" + " WHERE " + " LNK.FKDocumentUID = DOC.UID " + " AND DOC.SourceCode = 'FCM' " + " AND LNK.IsVoid = 'N' " + " AND DOC.IsVoid = 'N' " + " AND LNK.FKDocumentSetUID = {0} " + " ORDER BY LNK.FKParentDocumentUID ASC, LNK.SequenceNumber ", documentSetUID ); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Model.ModelDocument.Document _Document = new Model.ModelDocument.Document(); RepDocument.LoadDocumentFromReader(_Document, "DOC", reader); // This is necessary because when the list comes from DocumentSet, the parent may change // _Document.ParentUID = Convert.ToInt32(reader["FKParentDocumentUID"].ToString()); this.documentList.Add(_Document); } } } } }
public static DocumentSetDocumentLinkList ListRelatedDocuments(int documentSetUID, int documentUID, string type) { DocumentSetDocumentLinkList ret = new DocumentSetDocumentLinkList(); ret.documentSetDocumentLinkList = new List <DocumentSetDocumentLink>(); string linktype = ""; if (type == "ALL" || string.IsNullOrEmpty(type)) { // do nothing } else { linktype = " AND DSDL.LinkType = '" + type + "'"; } using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format ( "SELECT DSDL.UID DSDLUID " + " ,DSDL.FKParentDocumentUID DSDLFKParentDocumentUID " + " ,DSDL.FKChildDocumentUID DSDLFKChildDocumentUID " + " ,DSDL.LinkType DSDLLinkType " + " ,DSDL.IsVoid DSDLIsVoid " + " ," + RepDocument.SQLDocumentConcat("DOCUMENTCHILD") + " ," + RepDocument.SQLDocumentConcat("DOCUMENTPARENT") + " ," + RepDocumentSetDocument.SQLDocumentConcat("DSDCHILD") + " ," + RepDocumentSetDocument.SQLDocumentConcat("DSDPARENT") + " " + " FROM DocumentSetDocumentLink DSDL " + " ,DocumentSetDocument DSDCHILD " + " ,DocumentSetDocument DSDPARENT " + " ,Document DOCUMENTCHILD " + " ,Document DOCUMENTPARENT " + " WHERE " + " DSDL.IsVoid = 'N' " + " AND DSDL.FKParentDocumentUID = {0} " + linktype + " AND DSDL.FKDocumentSetUID = {1} " + " AND DSDL.FKChildDocumentUID = DSDCHILD.UID " + " AND DSDL.FKParentDocumentUID = DSDPARENT.UID " + " AND DSDCHILD.FKDocumentUID = DOCUMENTCHILD.UID " + " AND DSDPARENT.FKDocumentUID = DOCUMENTPARENT.UID " , documentUID , documentSetUID ); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DocumentSetDocumentLink _Document = new DocumentSetDocumentLink(); _Document.documentChild = new Model.ModelDocument.Document(); _Document.documentParent = new Model.ModelDocument.Document(); _Document.documentSetDocumentChild = new DocumentSetDocument(); _Document.documentSetDocumentParent = new DocumentSetDocument(); // Link information // _Document.FKChildDocumentUID = Convert.ToInt32(reader["DSDLFKChildDocumentUID"].ToString()); _Document.FKParentDocumentUID = Convert.ToInt32(reader["DSDLFKParentDocumentUID"].ToString()); _Document.LinkType = reader["DSDLLinkType"].ToString(); _Document.documentParent.UID = Convert.ToInt32(reader["DOCUMENTPARENTUID"].ToString()); _Document.documentParent.SimpleFileName = reader["DOCUMENTPARENTUID"].ToString(); _Document.documentParent.CUID = reader["DOCUMENTPARENTSimpleFileName"].ToString(); _Document.documentParent.Name = reader["DOCUMENTPARENTName"].ToString(); _Document.documentChild.UID = Convert.ToInt32(reader["DOCUMENTCHILDUID"].ToString()); _Document.documentChild.CUID = reader["DOCUMENTCHILDSimpleFileName"].ToString(); _Document.documentChild.Name = reader["DOCUMENTCHILDName"].ToString(); _Document.documentChild.SequenceNumber = Convert.ToInt32(reader["DOCUMENTCHILDSequenceNumber"].ToString()); _Document.documentChild.IssueNumber = Convert.ToInt32(reader["DOCUMENTCHILDIssueNumber"].ToString()); _Document.documentChild.Location = reader["DOCUMENTCHILDLocation"].ToString(); _Document.documentChild.Comments = reader["DOCUMENTCHILDComments"].ToString(); _Document.documentChild.SourceCode = reader["DOCUMENTCHILDSourceCode"].ToString(); _Document.documentChild.FileName = reader["DOCUMENTCHILDFileName"].ToString(); _Document.documentChild.SimpleFileName = reader["DOCUMENTCHILDSimpleFileName"].ToString(); _Document.documentChild.FKClientUID = Convert.ToInt32(reader["DOCUMENTCHILDFKClientUID"].ToString()); _Document.documentChild.ParentUID = Convert.ToInt32(reader["DOCUMENTCHILDParentUID"].ToString()); _Document.documentChild.RecordType = reader["DOCUMENTCHILDRecordType"].ToString(); _Document.documentChild.IsProjectPlan = reader["DOCUMENTCHILDIsProjectPlan"].ToString(); _Document.documentChild.DocumentType = reader["DOCUMENTCHILDDocumentType"].ToString(); _Document.documentSetDocumentChild.UID = Convert.ToInt32(reader["DSDCHILDUID"].ToString()); _Document.documentSetDocumentChild.FKDocumentUID = Convert.ToInt32(reader["DSDCHILDFKDocumentUID"].ToString()); _Document.documentSetDocumentChild.FKDocumentSetUID = Convert.ToInt32(reader["DSDCHILDFKDocumentSetUID"].ToString()); _Document.documentSetDocumentChild.Location = reader["DSDCHILDLocation"].ToString(); _Document.documentSetDocumentChild.StartDate = Convert.ToDateTime(reader["DSDCHILDStartDate"].ToString()); _Document.documentSetDocumentChild.EndDate = Convert.ToDateTime(reader["DSDCHILDEndDate"].ToString()); _Document.documentSetDocumentChild.FKParentDocumentUID = Convert.ToInt32(reader["DSDCHILDFKParentDocumentUID"].ToString()); _Document.documentSetDocumentChild.SequenceNumber = Convert.ToInt32(reader["DSDCHILDSequenceNumber"].ToString()); _Document.documentSetDocumentChild.FKParentDocumentSetUID = Convert.ToInt32(reader["DSDCHILDFKParentDocumentSetUID"].ToString()); ret.documentSetDocumentLinkList.Add(_Document); } } } } return(ret); }