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++;
}
}));
}
