private void GetLineStructDetailData(string plugCableName) { if (plugCableName == "") { return; } TCableTestLibraryManager lineStructManager = new TCableTestLibraryManager(); var data = lineStructManager.GetDataSetByWhere($"where CableName = '{plugCableName}'").Tables[0]; if (data.Rows.Count < 1) { return; } this.Invoke(new Action(() => { int iRow = 0; foreach (DataRow dr in data.Rows) { this.radGridView1.Rows.AddNew(); this.radGridView1.Rows[iRow].Cells[0].Value = iRow + 1; this.radGridView1.Rows[iRow].Cells[1].Value = dr["StartInterface"].ToString(); this.radGridView1.Rows[iRow].Cells[2].Value = dr["StartContactPoint"].ToString(); this.radGridView1.Rows[iRow].Cells[3].Value = dr["EndInterface"].ToString(); this.radGridView1.Rows[iRow].Cells[4].Value = dr["EndContactPoint"].ToString(); iRow++; } })); }
private int GetCablePrimary(string LineStructName, string StartInterface, string StartContactPoint, string EndInterface, string EndContactPoint) { int ID; var dt = lineStructManager.GetDataSetByWhere($"where CableName='{LineStructName}' and StartInterface='{StartInterface}' " + $"and StartContactPoint='{StartContactPoint}' and EndInterface = '{EndInterface}' and EndContactPoint= '{EndContactPoint}'").Tables[0]; if (dt.Rows.Count > 0) { int.TryParse(dt.Rows[0]["ID"].ToString(), out ID); return(ID); } return(0); }
public static long InsertCableLibPID() { long id = -1; TCableTestLibraryManager objManager = new TCableTestLibraryManager(); var dt = objManager.GetDataSetByWhere("order by ID DESC limit 1").Tables[0]; if (dt.Rows.Count < 1) { return(0); } if (long.TryParse(dt.Rows[0]["ID"].ToString(), out id)) { return(id + 1); } return(id); }
private void QueryLineCableInfo() { var dt = lineStructLibraryDetailManager.GetDataSetByWhere($"where CableName='{this.testLineCable}'").Tables[0]; if (dt.Rows.Count < 1) { return; } ClearGridView(); foreach (DataRow dr in dt.Rows) { var startInterface = dr["StartInterface"].ToString(); var endInterface = dr["EndInterface"].ToString(); var startContactPoint = dr["StartContactPoint"].ToString(); var endContactPoint = dr["EndContactPoint"].ToString(); if (IsExistCableInfo(startInterface, endInterface, startContactPoint, endContactPoint)) { continue; } this.radGridView1.Rows.AddNew(); var rCount = this.radGridView1.RowCount; this.radGridView1.Rows[rCount - 1].Cells[0].Value = rCount; this.radGridView1.Rows[rCount - 1].Cells[1].Value = startInterface; this.radGridView1.Rows[rCount - 1].Cells[2].Value = startContactPoint; this.radGridView1.Rows[rCount - 1].Cells[3].Value = endInterface; this.radGridView1.Rows[rCount - 1].Cells[4].Value = endContactPoint; this.radGridView1.Rows[rCount - 1].Cells[5].Value = this.devConfig.ConductThreshold; this.radGridView1.Rows[rCount - 1].Cells[6].Value = this.devConfig.InsulateThreshold; this.radGridView1.Rows[rCount - 1].Cells[7].Value = this.devConfig.InsulateHoldTime; this.radGridView1.Rows[rCount - 1].Cells[8].Value = this.devConfig.InsulateVoltage; this.radGridView1.Rows[rCount - 1].Cells[9].Value = this.devConfig.PressureWithVoltageThreshold; //this.radGridView1.Rows[rCount - 1].Cells[10].Value = this.devConfig.PressureProofHoldTime; //this.radGridView1.Rows[rCount - 1].Cells[11].Value = this.devConfig.PressureProofVoltage; } }
private void GetLineStructDetailData(string plugCableName) { if (plugCableName == "") { return; } TCableTestLibraryManager lineStructManager = new TCableTestLibraryManager(); var data = lineStructManager.GetDataSetByWhere($"where CableName = '{plugCableName}'").Tables[0]; if (data.Rows.Count < 1) { return; } List <string> interfaceList = new List <string>(); List <int> interfacePointList = new List <int>(); this.Invoke(new Action(() => { this.rtbCableName.Text = this.lineCableName; this.rtb_remark.Text = data.Rows[0]["Remark"].ToString(); var dt = lineStructManager.GetDataSetByFieldsAndWhere("DISTINCT StartInterface,EndInterface,StartContactPoint,EndContactPoint", $"where CableName = '{this.lineCableName}'").Tables[0]; if (dt.Rows.Count > 0) { this.cb_startInterface.EditorControl.Rows.Clear(); this.cb_endInterface.EditorControl.Rows.Clear(); this.cb_startPin.EditorControl.Rows.Clear(); this.cb_endPin.EditorControl.Rows.Clear(); foreach (DataRow dr in dt.Rows) { var startInterface = dr["StartInterface"].ToString(); var endInterface = dr["EndInterface"].ToString(); var startContactPoint = int.Parse(dr["StartContactPoint"].ToString()); var endContactPoint = int.Parse(dr["EndContactPoint"].ToString()); if (!interfaceList.Contains(startInterface)) { interfaceList.Add(startInterface); } if (!interfaceList.Contains(endInterface)) { interfaceList.Add(endInterface); } if (!interfacePointList.Contains(startContactPoint)) { interfacePointList.Add(startContactPoint); } if (!interfacePointList.Contains(endContactPoint)) { interfacePointList.Add(endContactPoint); } } interfacePointList.Sort(); int iStart = 1; foreach (var pointString in interfacePointList) { if (!IsExistCombox(this.cb_startPin, iStart.ToString())) { this.cb_startPin.EditorControl.Rows.Add(iStart); } if (!IsExistCombox(this.cb_endPin, iStart.ToString())) { this.cb_endPin.EditorControl.Rows.Add(iStart); } iStart++; } this.cb_startPin.EditorControl.ShowColumnHeaders = false; this.cb_startPin.EditorControl.AllowAutoSizeColumns = true; this.cb_endPin.EditorControl.ShowColumnHeaders = false; this.cb_endPin.EditorControl.AllowAutoSizeColumns = true; foreach (var interString in interfaceList) { if (!IsExistInterfaceCombox(interString)) { this.cb_startInterface.EditorControl.Rows.Add(interString); } if (!IsExistEndInterfaceCombox(interString)) { this.cb_endInterface.EditorControl.Rows.Add(interString); } InitCableParams(interString); } this.cb_startInterface.EditorControl.ShowColumnHeaders = false; this.cb_startInterface.EditorControl.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; this.cb_endInterface.EditorControl.ShowColumnHeaders = false; this.cb_endInterface.EditorControl.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; } int iRow = 0; foreach (DataRow dr in data.Rows) { this.radGridView1.Rows.AddNew(); this.radGridView1.Rows[iRow].Cells[0].Value = iRow + 1; this.radGridView1.Rows[iRow].Cells[1].Value = dr["StartInterface"].ToString(); this.radGridView1.Rows[iRow].Cells[2].Value = dr["StartContactPoint"].ToString(); this.radGridView1.Rows[iRow].Cells[3].Value = dr["EndInterface"].ToString(); this.radGridView1.Rows[iRow].Cells[4].Value = dr["EndContactPoint"].ToString(); iRow++; } })); }