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