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 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); }
private List <int> ContactPointReSort(string plugno, int methodIndex) { List <int> list = new List <int>(); var selectSQL = $"where InterfaceNo='{plugno}' and MeasureMethod = '{methodIndex}'"; var dt = plugLibraryDetailManager.GetDataSetByFieldsAndWhere("SwitchStandStitchNo", selectSQL).Tables[0]; if (dt.Rows.Count < 1) { return(list); } foreach (DataRow dr in dt.Rows) { int value = 0; var v = dr[0].ToString(); if (methodIndex == 2) { if (int.TryParse(v, out value)) { if (!list.Contains(value)) { list.Add(value); } } } else if (methodIndex == 4) { if (v.Contains(",")) { var v1 = v.Substring(0, v.IndexOf(',')); if (int.TryParse(v1, out value)) { if (!list.Contains(value)) { list.Add(value); } } var v2 = v.Substring(v.IndexOf(',') + 1); if (int.TryParse(v2, out value)) { if (!list.Contains(value)) { list.Add(value); } } } } } list.Sort(); return(list); }
public static void InitMulCombox(RadMultiColumnComboBox comBox) { var data = libraryManager.GetDataSetByFieldsAndWhere("distinct InterfaceNo", "").Tables[0]; if (data.Rows.Count > 0) { foreach (DataRow dr in data.Rows) { comBox.EditorControl.Rows.Add(dr[0].ToString()); } comBox.EditorControl.ShowColumnHeaders = false; comBox.EditorControl.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; comBox.SelectedIndex = 0; } }
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); }