private void QueryPlugLineStructInfo()
{
RadGridViewProperties.ClearGridView(this.radGridView1, null);
var selectSQL = "order by ID desc";
if (this.rtbCableCondition.Text.Trim() != "")
{
selectSQL = $"where CableName like '%{this.rtbCableCondition.Text.Trim()}%' order by ID desc";
}
var data = lineStructLibraryDetailManager.GetDataSetByFieldsAndWhere("distinct CableName", selectSQL).Tables[0];
if (data.Rows.Count < 1)
{
return;
}
int iRow = 0;
foreach (DataRow dr in data.Rows)
{
var lineStructName = dr["CableName"].ToString();
if (IsExistLineStruct(lineStructName))
{
continue;
}
this.radGridView1.Rows.AddNew();
var resultString = GetInterfaceInfoByCableName(lineStructName);
this.radGridView1.Rows[iRow].Cells[0].Value = iRow + 1;
this.radGridView1.Rows[iRow].Cells[1].Value = lineStructName;
this.radGridView1.Rows[iRow].Cells[2].Value = resultString;
this.radGridView1.Rows[iRow].Cells[3].Value = lineStructLibraryDetailManager.GetRowCountByWhere($"where CableName='{lineStructName}'");
//this.radGridView1.Rows[iRow].Cells[4].Value = dr["Remark"].ToString();
iRow++;
}
}
private bool IsInterUsed(string interName)
{
TCableTestLibraryManager libraryManager = new TCableTestLibraryManager();
var data = libraryManager.GetDataSetByFieldsAndWhere("DISTINCT CableName", $"where StartInterface = '{interName}' OR EndInterface = '{interName}'").Tables[0];
if (data.Rows.Count > 0)
{
return(true);
}
return(false);
}
private void QueryCableLibInfo()
{
RadGridViewProperties.ClearGridView(this.radGridView1, null);
var where = "";
if (this.tool_queryFilter.Text != "")
{
where = $"where CableName like '%{this.tool_queryFilter.Text}%'";
}
var data = lineStructLibraryDetailManager.GetDataSetByFieldsAndWhere("distinct CableName,Remark,Operator", where).Tables[0];
if (data.Rows.Count < 1)
{
return;
}
int iRow = 0;
foreach (DataRow dr in data.Rows)
{
var lineStructName = dr[0].ToString();
if (IsExistLineStruct(lineStructName))
{
continue;
}
this.radGridView1.Rows.AddNew();
var resultString = GetInterfaceInfoByCableName(lineStructName);
this.radGridView1.Rows[iRow].Cells[0].Value = iRow + 1;
this.radGridView1.Rows[iRow].Cells[1].Value = lineStructName;
this.radGridView1.Rows[iRow].Cells[2].Value = resultString.Split(',').Length;
this.radGridView1.Rows[iRow].Cells[3].Value = resultString;
this.radGridView1.Rows[iRow].Cells[4].Value = lineStructLibraryDetailManager.GetRowCountByWhere($"where CableName='{lineStructName}'");
this.radGridView1.Rows[iRow].Cells[5].Value = dr[1].ToString();
this.radGridView1.Rows[iRow].Cells[6].Value = dr[2].ToString();
iRow++;
}
}
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++;
}
}));
}