private void RadProbMeasure_Load(object sender, EventArgs e)
{
this.conductionThresholdByPin.Minimum = 0;
this.conductionThresholdByPin.Maximum = 1000;
this.conductionThresholdByPin.Increment = 10;
this.conductionThresholdByPin.Value = 1000;
this.num_fthreshold.Minimum = 0;
this.num_fthreshold.Maximum = 1000;
this.num_fthreshold.Increment = 10;
this.num_fthreshold.Value = 1000;
this.num_fminPin.Minimum = 1;
this.num_fminPin.Maximum = 384;
this.num_fmaxPin.Minimum = 1;
this.num_fmaxPin.Maximum = 384;
this.cobInter.MultiColumnComboBoxElement.Columns.Add("A");
StudyProbCom.InitMulCombox(this.cobInter);
InterfaceInfoLibrary = new InterfaceInfoLibraryManager();
this.btn_InterStart.Click += Btn_InterStart_Click;
this.btn_InterCancel.Click += Btn_InterCancel_Click;
this.btn_fstartTest.Click += Btn_fstartTest_Click;
this.btn_fcancel.Click += Btn_fcancel_Click;
}
private SelfStudyParams GetOrderPointByDevPoint(string did, int stype, SelfStudyParams studyParams)//stype 0 - start,1-end
{
//SelfStudyParams studyParams = new SelfStudyParams();
InterfaceInfoLibraryManager infoLibraryManager = new InterfaceInfoLibraryManager();
var data = infoLibraryManager.GetDataSetByFieldsAndWhere("ContactPoint,InterfaceNo", $"where SwitchStandStitchNo='{did}'").Tables[0];
if (data.Rows.Count < 1)
{
studyParams.StartPointOrder = "";
studyParams.EndPointOrder = "";
return(studyParams);
}
var interName = data.Rows[0][1].ToString();
var pointOrder = data.Rows[0][0].ToString();
if (stype == 0)
{
studyParams.StartInterfaceName = interName;
studyParams.StartPointOrder = pointOrder;
}
else if (stype == 1)
{
studyParams.EndInterfaceName = interName;
studyParams.EndPointOrder = pointOrder;
}
return(studyParams);
}
private void Init()
{
this.StartPosition = FormStartPosition.CenterParent;
plugLibraryDetailManager = new InterfaceInfoLibraryManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, 7);
InitFuncState();
}
private bool IsExistStitchRepeat()
{
if (interLibraryDetailList.Count < 1)
{
return(false);
}
InterfaceInfoLibraryManager plugLibraryDetailManager = new InterfaceInfoLibraryManager();
foreach (var plugLibrary in interLibraryDetailList)
{
//查询针脚
var data = plugLibraryDetailManager.GetDataSetByWhere($"where InterfaceNo='{plugLibrary.InterfaceNo}'").Tables[0];
if (data.Rows.Count > 0)
{
foreach (DataRow dr in data.Rows)
{
var stitchValue = dr["SwitchStandStitchNo"].ToString();
foreach (var plugLibrary2 in interLibraryDetailList)
{
if (plugLibrary2.InterfaceNo == plugLibrary.InterfaceNo)
{
continue;
}
var resultList = plugLibraryDetailManager.GetListByWhere($"where InterfaceNo='{plugLibrary2.InterfaceNo}' and SwitchStandStitchNo='{stitchValue}'");
if (resultList.Count > 0)
{
MessageBox.Show($"接口{plugLibrary.InterfaceNo}与接口{plugLibrary2.InterfaceNo}存在相同的测试仪针脚{stitchValue}", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(true);
}
}
}
}
}
return(false);
}
private void LoadInterfaceList()
{
InterfaceInfoLibraryManager plugLibraryDetailManager = new InterfaceInfoLibraryManager();
var dt = plugLibraryDetailManager.GetAllDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
List <string> plugTemp = new List <string>();
int iRow = 0;
foreach (DataRow dr in dt.Rows)
{
var interNo = dr["InterfaceNo"].ToString();
var contactNum = plugLibraryDetailManager.GetRowCountByWhere($"where InterfaceNo='{interNo}'");
if (!plugTemp.Contains(interNo))
{
plugTemp.Add(interNo);
}
else
{
continue;
}
//add radgridview
this.radGridViewInter.Rows.AddNew();
this.radGridViewInter.Rows[iRow].Cells[0].Value = iRow + 1;
this.radGridViewInter.Rows[iRow].Cells[1].Value = interNo;
this.radGridViewInter.Rows[iRow].Cells[2].Value = contactNum;
iRow++;
}
}
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
//提交到线束库时，不同接口之间不能有相同的针脚
if (this.radGridViewCable.Rows.Count < 1)
{
return;
}
foreach (var rowInfo in this.radGridViewCable.Rows)
{
var interNo = rowInfo.Cells[1].Value.ToString();
InterfaceInfoLibrary plugLibraryDetail = new InterfaceInfoLibrary();
if (!interLibraryDetailList.Contains(plugLibraryDetail))
{
plugLibraryDetail.InterfaceNo = interNo;
InterfaceInfoLibraryManager libraryManager = new InterfaceInfoLibraryManager();
var libraryData = libraryManager.GetDataSetByFieldsAndWhere("DISTINCT MeasureMethod", $"where InterfaceNo='{interNo}'").Tables[0];
if (libraryData.Rows.Count > 0)
{
plugLibraryDetail.MeasureMethod = libraryData.Rows[0][0].ToString();
interLibraryDetailList.Add(plugLibraryDetail);
}
}
}
if (IsExistStitchRepeat())
{
return;
}
this.Close();
this.DialogResult = DialogResult.OK;
}
private int QueryMeasuringMethod(string PlugNo)
{
int method;
InterfaceInfoLibraryManager plugLibraryDetailManager = new InterfaceInfoLibraryManager();
var dt = plugLibraryDetailManager.GetDataSetByFieldsAndWhere("distinct MeasureMethod", $"where InterfaceNo='{PlugNo}'").Tables[0];
if (dt.Rows.Count < 1)
{
return(0);
}
int.TryParse(dt.Rows[0][0].ToString().Trim(), out method);
return(method);
}
public static long InsertInterfaceLibPID()
{
long id = -1;
InterfaceInfoLibraryManager objManager = new InterfaceInfoLibraryManager();
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 RefreshDataGrid()
{
RadGridViewProperties.ClearGridView(this.radGridView1, null);
InterfaceInfoLibraryManager plugLibraryDetailManager = new InterfaceInfoLibraryManager();
var dt = plugLibraryDetailManager.GetDataSetByWhere($"where InterfaceNo='{this.plugno}'").Tables[0];
if (dt.Rows.Count > 0)
{
int iRow = 0;
foreach (DataRow dr in dt.Rows)
{
var interName = dr["InterfaceNo"].ToString();
var pointName = dr["ContactPointName"].ToString();
var method = dr["MeasureMethod"].ToString();
var devPoint = dr["SwitchStandStitchNo"].ToString();
var connector = dr["ConnectorName"].ToString();
var remark = dr["remark"].ToString();
var keyID = dr["ID"].ToString();
this.radGridView1.Rows.AddNew();
this.radGridView1.Rows[iRow].Cells[0].Value = iRow + 1;
this.radGridView1.Rows[iRow].Cells[1].Value = interName;
this.radGridView1.Rows[iRow].Cells[2].Value = pointName;
if (method == "2")
{
this.radGridView1.Rows[iRow].Cells[3].Value = TWO_WIRE_METHOD;
UpdateSwitchPointValue(TWO_WIRE_METHOD);
}
else if (method == "4")
{
this.radGridView1.Rows[iRow].Cells[3].Value = FOUR_WIRE_METHOD;
UpdateSwitchPointValue(FOUR_WIRE_METHOD);
}
this.radGridView1.Rows[iRow].Cells[4].Value = devPoint;
this.radGridView1.Rows[iRow].Cells[5].Value = connector;
this.radGridView1.Rows[iRow].Cells[6].Value = remark;
this.radGridView1.Rows[iRow].Cells[8].Value = keyID;
iRow++;
}
}
}
private void Init()
{
this.conductionThresholdByPin.Maximum = 1000;
this.conductionThresholdByPin.Minimum = 0;
this.conductionThresholdByPin.Increment = 10;
this.conductionThresholdByPin.Value = 1000;
this.num_fthreshold.Maximum = 1000;
this.num_fthreshold.Minimum = 0;
this.num_fthreshold.Increment = 10;
this.num_fthreshold.Value = 1000;
this.num_fmin.Minimum = 1;
this.num_fmin.Maximum = 384;
this.num_fmax.Minimum = 1;
this.num_fmax.Maximum = 384;
this.InterfaceInfoLibrary = new InterfaceInfoLibraryManager();
this.studyTestParamsList = new List <SelfStudyTestParams>();
}
public static bool IsExistDevicePoint(string pointPin)
{
if (interLibManager == null)
{
interLibManager = new InterfaceInfoLibraryManager();
}
if (data == null)
{
data = interLibManager.GetDataSetByFieldsAndWhere($"distinct SwitchStandStitchNo", "").Tables[0];
}
if (data.Rows.Count <= 0)
{
return(false);
}
foreach (DataRow dr in data.Rows)
{
var point = dr[0].ToString();
if (pointPin.Contains(","))//four line method
{
if (point.Contains(","))
{
var pointArray = point.Split(',');
foreach (var val in pointArray)
{
if (pointPin.ToString() == val)
{
return(true);
}
}
}
}
else//for two line method
{
if (pointPin == point)
{
return(true);
}
}
}
return(false);
}
public static InterfaceInfoLibrary QueryInterfaceLibInfo(string priID)
{
InterfaceInfoLibrary interfaceInfo = new InterfaceInfoLibrary();
InterfaceInfoLibraryManager infoLibraryManager = new InterfaceInfoLibraryManager();
var data = infoLibraryManager.GetDataSetByWhere($"where ID='{priID}'").Tables[0];
if (data.Rows.Count > 0)
{
interfaceInfo.ID = int.Parse(data.Rows[0]["ID"].ToString());
interfaceInfo.InterfaceNo = data.Rows[0]["InterfaceNo"].ToString();
interfaceInfo.ContactPointName = data.Rows[0]["ContactPointName"].ToString();
interfaceInfo.SwitchStandStitchNo = data.Rows[0]["SwitchStandStitchNo"].ToString();
interfaceInfo.ContactPoint = data.Rows[0]["ContactPoint"].ToString();
interfaceInfo.MeasureMethod = data.Rows[0]["MeasureMethod"].ToString();
interfaceInfo.ConnectorName = data.Rows[0]["ConnectorName"].ToString();
interfaceInfo.Operator = data.Rows[0]["Operator"].ToString();
interfaceInfo.Remark = data.Rows[0]["Remark"].ToString();
interfaceInfo.UpdateDate = data.Rows[0]["UpdateDate"].ToString();
}
return(interfaceInfo);
}
private void Init(bool IsEdit)
{
this.StartPosition = FormStartPosition.CenterParent;
plugLibraryDetailManager = new InterfaceInfoLibraryManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, false, 8);
GridViewComboBoxColumn methodName = this.radGridView1.Columns["columnMethod"] as GridViewComboBoxColumn;
methodName.DataSource = new string[] { TWO_WIRE_METHOD, FOUR_WIRE_METHOD };
interfaceLibaryInfos = new List <InterfaceInfoLibrary>();
this.radGridView1.Columns[5].IsVisible = false;
this.radGridView1.Columns[7].IsVisible = false;
if (IsEdit)
{
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.Columns[1].ReadOnly = true;
this.tb_interfacelNo.Text = this.plugno;
}
else
{
this.radGridView1.ReadOnly = true;
}
}
