WARNINGPT ObtenerWarningT(string spras_id, string warning_id, string tab_id)
{
WARNINGPT mensaje = db.WARNINGPTs.Where(x => x.WARNING_ID == warning_id && x.TAB_ID == tab_id && x.SPRAS_ID == spras_id).FirstOrDefault();
return(mensaje ?? new WARNINGPT {
SPRAS_ID = spras_id
});
}
public string listaW(string bukrs, string spras)//RSG 07.06.2018---------------------------------------------
{
using (TAT001Entities db = new TAT001Entities())
{
List <WARNINGP> lwp = db.WARNINGPs.Where(x => x.SOCIEDAD_ID.Equals(bukrs) | x.SOCIEDAD_ID == null).ToList();
List <WARNINGPT> lwpt = db.WARNINGPTs.Where(x => x.SPRAS_ID.Equals(spras)).ToList();
List <WARNING_COND> lwc = db.WARNING_COND.Where(x => x.ACTIVO.Equals(true)).ToList();
string val = "[";
int cont = 1;
foreach (WARNINGP wp in lwp)
{
if (cont != 1)
{
val += ", ";
}
val += "{ ID: '" + wp.CAMPOVAL_ID + "'";
val += ", BUKRS: '" + wp.SOCIEDAD_ID + "'";
val += ", TSOL: '" + wp.TSOL_ID + "'";
val += ", TAB: '" + wp.TAB_ID + "'";
val += ", ELEM: '" + wp.CAMPO_ID + "'";
WARNINGPT pt = lwpt.Where(x => x.TAB_ID == wp.TAB_ID & x.WARNING_ID == wp.ID).FirstOrDefault();
if (pt == null)
{
val += ", MSG: '" + wp.DESCR + "'";
}
else
{
val += ", MSG: '" + lwpt.Where(x => x.TAB_ID == wp.TAB_ID & x.WARNING_ID == wp.ID).FirstOrDefault().TXT100 + "'";
}
if (wp.TIPO == "E")
{
val += ", TIPO: 'error', COLOR: 'red'";
}
else
{
val += ", TIPO: 'info', COLOR: 'yellow'";
}
val += ", COND: [";
int cont2 = 0;
foreach (WARNING_COND wc in lwc.Where(x => x.TAB_ID == wp.TAB_ID & x.WARNING_ID == wp.ID).ToList())
{
if (cont2 != 0)
{
val += ", ";
}
val += "{ andor: '" + wc.ANDOR + "'";
val += ", comp: '" + wc.CONDICION.COND + "'";
val += ", val2: '" + wc.VALOR_COMP + "'";
val += ", orand: '" + wc.ORAND + "'";
val += "}";
cont2++;
}
val += "]";
val += ", ACTION: '" + wp.ACCION + "'";
val += ", NUM: " + cont + "}";
cont++;
}
val += "]";
return(val);
}
}
