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