public eco GetECOData(string ecoNumber) { eco e = new eco(); int en; if (int.TryParse(ecoNumber, out en)) { string SQL = string.Empty; if (en > GetLastLegacyECR()) { SQL = @"SELECT GEN_USERS.FIRST, GEN_USERS.LAST, ECR_MAIN.CHANGES, " + @"ECR_STATUS.STATUS, ECR_MAIN.ERR_DESC, ECR_MAIN.REVISION FROM " + @"(ECR_MAIN LEFT JOIN GEN_USERS ON ECR_MAIN.REQ_BY = GEN_USERS.UID) " + @"LEFT JOIN ECR_STATUS ON ECR_MAIN.STATUS = ECR_STATUS.STAT_ID WHERE " + @"(((ECR_MAIN.[ECR_NUM])=?))"; using (OdbcCommand comm = new OdbcCommand(SQL, conn)) { comm.Parameters.AddWithValue("@ecrNo", en); using (OdbcDataReader dr = comm.ExecuteReader()) { e.EcrNumber = int.Parse(ecoNumber); if (dr.Read()) { if (!dr.IsDBNull((int)ECODataColumns.CHANGES)) e.Changes = dr.GetString((int)ECODataColumns.CHANGES); if (!dr.IsDBNull((int)ECODataColumns.DESC)) e.ErrDescription = dr.GetString((int)ECODataColumns.DESC); if (!dr.IsDBNull((int)ECODataColumns.REVISION)) e.Revision = dr.GetString((int)ECODataColumns.REVISION); if (!dr.IsDBNull((int)ECODataColumns.STATUS)) e.Status = dr.GetString((int)ECODataColumns.STATUS); if (!dr.IsDBNull((int)ECODataColumns.USER_FIRST) && !dr.IsDBNull((int)ECODataColumns.USER_LAST)) e.RequestedBy = dr.GetString((int)ECODataColumns.USER_FIRST) + " " + dr.GetString((int)ECODataColumns.USER_LAST); dr.Close(); } } } } else { // ECR_LEGACY.ECRNum is a string field. SQL = @"SELECT * FROM ECR_LEGACY WHERE (((ECR_LEGACY.ECRNum)=?))"; using (OdbcCommand comm = new OdbcCommand(SQL, conn)) { comm.Parameters.AddWithValue("@ecrNo", ecoNumber); using (OdbcDataReader dr = comm.ExecuteReader()) { e.EcrNumber = int.Parse(ecoNumber); if (dr.Read()) { if (!dr.IsDBNull(6)) e.Changes = dr.GetString(6); if (!dr.IsDBNull(4)) e.Status = @"Finished on " + dr.GetDate(4).ToString().Split(' ')[0]; else if (!dr.IsDBNull(3)) e.Status = @"Requested on " + dr.GetDate(3).ToString().Split(' ')[0]; if (!dr.IsDBNull(5)) e.Revision = dr.GetString(5); if (!dr.IsDBNull(7)) e.RequestedBy = dr.GetString(7); } } } } return e; } return e; }
private void Init() { this.tvRevisions.Nodes.Clear(); foreach (DrawingRev r in revSet) { TreeNode tnList = new TreeNode(propertySet.CutlistData.GetAuthorFullName(r.List.Value)); TreeNode tnDate = new TreeNode(r.Date.Value); TreeNode tnECO = new TreeNode(r.Eco.Value); TreeNode tnC = new TreeNode(r.Revision.Value); int test = 0; eco e = new eco(); e = cd.GetECOData(r.Eco.Value); if (int.TryParse(r.Eco.Value, out test) && test > cd.GetLastLegacyECR()) { TreeNode tnD = new TreeNode("Error Description: " + e.ErrDescription, 0, 0); TreeNode tnRB = new TreeNode("Requested by: " + e.RequestedBy, 0, 0); TreeNode tnR = new TreeNode("Revision Description:" + e.Revision, 0, 0); TreeNode tnS = new TreeNode("Status: " + e.Status, 0, 0); if ((e.Changes != null) && e.Changes.Contains("\n")) { List<TreeNode> nodes = new List<TreeNode>(); string[] changeNodes = e.Changes.Split('\n'); foreach (string s in changeNodes) { nodes.Add(new TreeNode(s)); } tnC = new TreeNode("Changes ", nodes.ToArray()); } else { tnC = new TreeNode("Changes: " + e.Changes); } TreeNode[] ts = { tnC, tnD, tnRB, tnR, tnS }; TreeNode tnDesc = new TreeNode(r.Description.Value); tnECO = new TreeNode(r.Eco.Value, ts); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } else if (r.Eco.Value.Contains("NA") || r.Eco.Value.Trim().Equals(string.Empty)) { tnECO = new TreeNode(r.Eco.Value); TreeNode tnDesc = new TreeNode(r.Description.Value); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } else { if ((e.Changes != null) && e.Changes.Contains("\n")) { List<TreeNode> nodes = new List<TreeNode>(); string[] changeNodes = e.Changes.Split('\n'); foreach (string s in changeNodes) { nodes.Add(new TreeNode(s)); } tnC = new TreeNode("Changes ", nodes.ToArray()); } else { tnC = new TreeNode("Changes: " + e.Changes); TreeNode tnRB = new TreeNode("Finished by: " + e.RequestedBy, 0, 0); string[] affectedParts = e.Revision.Split(',', '&'); TreeNode tnT = new TreeNode(""); List<TreeNode> nodes = new List<TreeNode>(); foreach (string item in affectedParts) { nodes.Add(new TreeNode(item.Trim())); } TreeNode tnR = new TreeNode("Affected Parts:", nodes.ToArray()); TreeNode tnS = new TreeNode("Status: " + e.Status, 0, 0); TreeNode[] ts = { tnC, tnRB, tnR, tnS }; tnECO = new TreeNode(r.Eco.Value, ts); TreeNode tnDesc = new TreeNode(r.Description.Value); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } } } }
public eco GetLegacyECOData(string ecoNumber) { eco e = new eco(); // ECR_LEGACY.ECRNum is a string field. string SQL = @"SELECT * FROM ECR_LEGACY WHERE (((ECR_LEGACY.ECRNum)=?))"; using (OdbcCommand comm = new OdbcCommand(SQL, conn)) { comm.Parameters.AddWithValue("@ecoNumber", ecoNumber); using (OdbcDataReader dr = comm.ExecuteReader()) { if (dr.Read()) { e.EcrNumber = int.Parse(ecoNumber); e.Revision = dr.GetString(5); // AffectedParts e.Changes = dr.GetString(6); // Change string dString = dr.GetDate(4).ToString(); if (dString != string.Empty) { string[] dateString = dString.Split('/', ' '); // DateCompleted System.DateTime dt = new DateTime(int.Parse(dateString[2]), int.Parse(dateString[0]), int.Parse(dateString[1])); e.Status = @"Finished on " + dt.ToShortDateString(); } else { dString = dr.GetDate(3).ToString(); string[] dateString = dString.Split('/', ' '); // DateCompleted if (dateString.Length > 2) { System.DateTime dt = new DateTime(int.Parse(dateString[2]), int.Parse(dateString[0]), int.Parse(dateString[1])); e.Status = @"Requested on " + dt.ToShortDateString(); } else { e.Status = dString; } } e.RequestedBy = dr.GetString(7); // FinishedBy } } } return e; }
private void Init() { this.tvRevisions.Nodes.Clear(); foreach (DrawingRev r in revSet) { TreeNode tnList = new TreeNode(propertySet.CutlistData.GetAuthorFullName(r.List.Value)); TreeNode tnDate = new TreeNode(r.Date.Value); TreeNode tnECO = new TreeNode(r.Eco.Value); TreeNode tnC = new TreeNode(r.Revision.Value); int test = 0; eco e = new eco(); e = cd.GetECOData(r.Eco.Value); if (int.TryParse(r.Eco.Value, out test) && test > cd.GetLastLegacyECR()) { TreeNode tnD = new TreeNode("Error Description: " + e.ErrDescription, 0, 0); TreeNode tnRB = new TreeNode("Requested by: " + e.RequestedBy, 0, 0); TreeNode tnR = new TreeNode("Revision Description:" + e.Revision, 0, 0); TreeNode tnS = new TreeNode("Status: " + e.Status, 0, 0); if ((e.Changes != null) && e.Changes.Contains("\n")) { List <TreeNode> nodes = new List <TreeNode>(); string[] changeNodes = e.Changes.Split('\n'); foreach (string s in changeNodes) { nodes.Add(new TreeNode(s)); } tnC = new TreeNode("Changes ", nodes.ToArray()); } else { tnC = new TreeNode("Changes: " + e.Changes); } TreeNode[] ts = { tnC, tnD, tnRB, tnR, tnS }; TreeNode tnDesc = new TreeNode(r.Description.Value); tnECO = new TreeNode(r.Eco.Value, ts); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } else if (r.Eco.Value.Contains("NA") || r.Eco.Value.Trim().Equals(string.Empty)) { tnECO = new TreeNode(r.Eco.Value); TreeNode tnDesc = new TreeNode(r.Description.Value); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } else { if ((e.Changes != null) && e.Changes.Contains("\n")) { List <TreeNode> nodes = new List <TreeNode>(); string[] changeNodes = e.Changes.Split('\n'); foreach (string s in changeNodes) { nodes.Add(new TreeNode(s)); } tnC = new TreeNode("Changes ", nodes.ToArray()); } else { tnC = new TreeNode("Changes: " + e.Changes); TreeNode tnRB = new TreeNode("Finished by: " + e.RequestedBy, 0, 0); string[] affectedParts = e.Revision.Split(',', '&'); TreeNode tnT = new TreeNode(""); List <TreeNode> nodes = new List <TreeNode>(); foreach (string item in affectedParts) { nodes.Add(new TreeNode(item.Trim())); } TreeNode tnR = new TreeNode("Affected Parts:", nodes.ToArray()); TreeNode tnS = new TreeNode("Status: " + e.Status, 0, 0); TreeNode[] ts = { tnC, tnRB, tnR, tnS }; tnECO = new TreeNode(r.Eco.Value, ts); TreeNode tnDesc = new TreeNode(r.Description.Value); TreeNode[] tt = { tnECO, tnDesc, tnList, tnDate }; TreeNode tn = new TreeNode(r.Revision.Value, tt); this.tvRevisions.Nodes.Add(tn); } } } }