if ((billingEngine.Journal == "1Comm") && (e.StockRecord.S_... == "..."))
{
    DataSet ds = Api.Zselect(MercatorUi.Globals.RepData, "select fou.f_id,fou.f_nom from ARTFOU inner join FOU on (artfou.id_fou=fou.f_id) where (id_art=@s_id) and (principal=1)", new MercatorSqlParam("@s_id", e.StockRecord.S_ID, SqlDbType.Char));
    if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
    {
        e.LignesVRecord.ID_FOU_LINKED = ds.Tables[0].Rows[0]["f_id"].ToString().TrimEnd();
        e.DataRowLignes["NOM_FOU_LINKED"] = ds.Tables[0].Rows[0]["f_nom"].ToString().TrimEnd();
    }
}