private void QueryInterfaceInfo()
{
int i = 0;
ClearGridView();
var queryFilter = this.tb_queryFilter.Text.Trim();
var selectSQL = "";
if (queryFilter != "")
{
selectSQL = $"where InterfaceNo like '%{queryFilter}%'";
}
var dbSource = plugLibraryDetailManager.GetDataSetByWhere(selectSQL).Tables[0];
if (dbSource.Rows.Count < 1)
{
return;
}
foreach (DataRow dr in dbSource.Rows)
{
var plugNo = dr["InterfaceNo"].ToString();
if (IsExistPlugNo(plugNo))
{
continue;
}
this.radGridView1.Rows.AddNew();
var detailDB = plugLibraryDetailManager.GetDataSetByWhere($"where InterfaceNo='{plugNo}'").Tables[0];
this.radGridView1.Rows[i].Cells[0].Value = i + 1; //序号
this.radGridView1.Rows[i].Cells[1].Value = plugNo; //接口代号
this.radGridView1.Rows[i].Cells[2].Value = detailDB.Rows.Count; //接点个数
this.radGridView1.Rows[i].Cells[3].Value = GetStitchRange(detailDB); //针脚范围
if (dr["ConnectorName"].ToString() == "")
{
this.radGridView1.Rows[i].Cells[4].Value = "--";//连接器型号
}
else
{
this.radGridView1.Rows[i].Cells[4].Value = dr["ConnectorName"].ToString();
}
this.radGridView1.Rows[i].Cells[5].Value = dr["Remark"].ToString();//备注
this.radGridView1.Rows[i].Cells[6].Value = dr["Operator"].ToString();
i++;
}
//判断是否已经添加了两端的接口，限制只能添加两个接口
if (this.radGridView1.RowCount == 2)
{
this.tool_add.Enabled = false;
}
else
{
this.tool_add.Enabled = true;
}
}
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 int GetPlugPrimary(string plug, string pinName, string stitchNo)
{
int ID;
var dt = plugLibraryDetailManager.GetDataSetByWhere($"where InterfaceNo='{plug}' and ContactPointName='{pinName}' and SwitchStandStitchNo='{stitchNo}'").Tables[0];
if (dt.Rows.Count > 0)
{
int.TryParse(dt.Rows[0]["ID"].ToString(), out ID);
return(ID);
}
return(0);
}
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++;
}
}
}
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);
}
