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); } }