public List <PartinBom> getSeqBillOfMaterial(string id_trace_order)
{
List <PartinBom> result = new List <PartinBom>();
string querytext = "select TT.trace_order_value, TR.refcmp_nom from t_trace_order TT join t_refcmp TR on TT.trace_order_value = TR.id_refcmp and TT.et_order_carord = '29' " +
" and TT.id_trace_order = '" + id_trace_order + "' order by TT.trace_order_value asc";
NpgsqlCommand getdata = new NpgsqlCommand(querytext, Connection);
NpgsqlDataReader readdata = getdata.ExecuteReader();
if (readdata.HasRows)
{
while (readdata.Read())
{
PartinBom tmp = new PartinBom();
tmp.PartNumber = readdata[0].ToString();
tmp.Name = readdata[1].ToString();
//MessageBox.Show(tmp.PartNumber + " " + tmp.Name);
result.Add(tmp);
}
readdata.Close();
}
return(result);
}
public List <PartinBom> getBillOfMaterial(string FamName)
{
List <PartinBom> result = new List <PartinBom>();
string querytext = "select TR.id_refcmp, TR.refcmp_nom from t_nomen TN join t_refcmp TR on TN.et_refakf_comp = TR.id_refcmp and TN.et_refakf_se = '" + FamName + "'"
+ " and TN.nomen_fin_validite is null order by TR.id_refcmp asc";
NpgsqlCommand getdata = new NpgsqlCommand(querytext, Connection);
NpgsqlDataReader readdata = getdata.ExecuteReader();
if (readdata.HasRows)
{
while (readdata.Read())
{
PartinBom tmp = new PartinBom();
tmp.PartNumber = readdata[0].ToString();
tmp.Name = readdata[1].ToString();
//MessageBox.Show(tmp.PartNumber + " " + tmp.Name);
result.Add(tmp);
}
readdata.Close();
}
return(result);
}
