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 void Init()
{
this.StartPosition = FormStartPosition.CenterParent;
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, 7);
lineStructLibraryDetailManager = new TCableTestLibraryManager();
InitFuncState();
}
private void Init()
{
this.cableAddList = new List <CableConfig>();
this.cableDelList = new List <CableConfig>();
this.StartPosition = FormStartPosition.CenterParent;
this.rdb2Method.CheckState = CheckState.Checked;
InitDataTable();
lineStructManager = new TCableTestLibraryManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, 5);
this.cb_startInterface.EditorControl.Columns.Add("startInterfacePoint");
this.cb_startInterface.EditorControl.ShowColumnHeaders = false;
this.cb_startPin.EditorControl.Columns.Add("startPin");
this.cb_startPin.EditorControl.ShowColumnHeaders = false;
this.cb_endInterface.EditorControl.Columns.Add("endInterfacePoint");
this.cb_endInterface.EditorControl.ShowColumnHeaders = false;
this.cb_endPin.EditorControl.Columns.Add("endPin");
this.cb_endPin.EditorControl.ShowColumnHeaders = false;
this.checkCircuit.CheckState = CheckState.Checked;
this.checkConduction.CheckState = CheckState.Checked;
this.checkInsulate.CheckState = CheckState.Checked;
this.checkPressureProof.CheckState = CheckState.Checked;
GetLineStructDetailData(lineCableName);
CheckMeasureMethodValid();
}
private bool IsCableExist(string cableName)
{
TCableTestLibraryManager cableManage = new TCableTestLibraryManager();
var count = cableManage.GetRowCountByWhere($"where CableName = '{cableName}'");
if (count > 0)
{
return(true);
}
return(false);
}
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 bool IsExistLineStructRecord(string primaryID)
{
TCableTestLibraryManager lineStructManager = new TCableTestLibraryManager();
var lineStructRecord = lineStructManager.GetById(primaryID);
if (lineStructManager == null)
{
return(false);
}
return(true);
}
private void GroupTestStandardParams_Load(object sender, EventArgs e)
{
projectInfoManager = new TProjectBasicInfoManager();
lineStructLibraryDetailManager = new TCableTestLibraryManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, 12);
this.radGridView1.ReadOnly = true;
QueryLineCableInfo();
this.btn_apply.Click += Btn_apply_Click;
this.btn_cancel.Click += Btn_cancel_Click;
this.btn_batchModify.Click += Btn_batchModify_Click;
this.btn_export.Click += Btn_export_Click;
}
private void Init()
{
if (this.title != "")
{
this.Text = title;
}
projectInfo = new TProjectBasicInfo();
projectInfoManager = new TProjectBasicInfoManager();
lineStructLibraryDetailManager = new TCableTestLibraryManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, 5);
QueryPlugLineStructInfo();
UpdateProjectInfo();
}
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 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++;
}
}));
}
