/// <summary>
/// 补bip allpart data
/// </summary>
public void TEST()
{
OleExec APDB = new OleExec("HWD_APDB", false);
string strsql = @"select A.SN,B.PANEL from r_sn_station_detail A, R_PANEL_SN B where A.workorderno = '002510037542' and A.current_station = 'BIP'
AND A.SN = B.SN";
DataSet ds = SFCDB.ExecSelect(strsql);
try
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
strsql = $@"SELECT p_sn FROM (
SELECT DISTINCT(p_sn) FROM MES4.R_TR_PRODUCT_DETAIL WHERE WO = '002510037542' AND P_SN LIKE '{ds.Tables[0].Rows[i]["PANEL"]}%') WHERE ROWNUM =1";
string panel_sn = APDB.ExecSelectOneValue(strsql)?.ToString();
if (panel_sn == null)
{
continue;
}
strsql = $@"UPDATE MES4.R_TR_PRODUCT_DETAIL SET P_SN='{ds.Tables[0].Rows[i]["SN"]}' WHERE p_SN='{panel_sn}'";
APDB.ExecSQL(strsql);
}
catch (Exception E)
{
throw E;
}
finally { }
}
}
catch { }
finally {
APDB.CloseMe();
}
}
