/// <summary> /// Obtiene una lista de usuarios /// </summary> /// <param name="reader"></param> /// <returns></returns> /// public List <ZEBAN_P_BE> ZEBAN_P_GET(IDataReader reader) { List <ZEBAN_P_BE> zeban_p = new List <ZEBAN_P_BE>(); try { while (reader.Read()) { ZEBAN_P_BE z = new ZEBAN_P_BE(); z.APROBO = reader["APROBO"].ToString(); z.BANFN = Int32.Parse(reader["BANFN"].ToString()); z.F_APROBACION = DateTime.Parse(reader["F_APROBACION"].ToString()); z.FK_USUARIO = reader["FK_USUARIO"].ToString(); z.SAP_BANFN = reader["SAP_BANFN"].ToString(); z.SAP_EBELN = reader["SAP_EBELN"].ToString(); z.STATUS = reader["STATUS"].ToString(); z.REFERENCIA = reader["REFERENCIA"].ToString(); z.COMPRADOR = reader["COMPRADOR"].ToString(); zeban_p.Add(z); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(zeban_p); }
public static string crear2(string url, string valores, string comentario, string r, string us)// Crea requisición { string tipo = ""; string id = ""; ZEBAN_P_BE header = new ZEBAN_P_BE(); header.FK_USUARIO = us; header.STATUS = "0";//getStatus(user) + ""; header.F_APROBACION = DateTime.Now; header.REFERENCIA = r; List <ZEBAN_BE> items = new List <ZEBAN_BE>(); List <ZEBAN_I_BE> imps = new List <ZEBAN_I_BE>(); List <ZEBAN_S_BE> serv = new List <ZEBAN_S_BE>(); string[] tabla = valores.Split('|'); string valores_temp = ""; int cont = 0; for (int i = 0; i < tabla.Length - 1; i += 9) { if (cont > 0) { cont = (i / 9) + 1;//27.01.2017 i/8 } else { cont = i + 1; } valores_temp = tabla[i + 2] + "|" + tabla[i + 3] + "|" + tabla[i + 4] + "|" + tabla[i + 5] + "|" + tabla[i + 6] + "|" + tabla[i + 7] + "|" + tabla[i + 8] + "|"; tipo = tabla[i]; id = tabla[i + 1]; if (tipo == "s") { //res = creaServicios(valores, id, comentario); List <Object> list = new List <object>(); list = creaServicios(valores_temp, id, cont); ZEBAN_BE item_s = new ZEBAN_BE(); ZEBAN_I_BE imp_s = new ZEBAN_I_BE(); ZEBAN_S_BE serv_s = new ZEBAN_S_BE(); item_s = (ZEBAN_BE)list[0]; items.Add(item_s); imp_s = (ZEBAN_I_BE)list[1]; imps.Add(imp_s); serv_s = (ZEBAN_S_BE)list[2]; serv.Add(serv_s); } else if (tipo == "a") { //res = creaActivos(valores, id, comentario); List <Object> list = new List <object>(); list = creaActivos(valores_temp, id, cont); ZEBAN_BE item_i = new ZEBAN_BE(); ZEBAN_I_BE imp_i = new ZEBAN_I_BE(); ZEBAN_S_BE serv_i = new ZEBAN_S_BE(); item_i = (ZEBAN_BE)list[0]; items.Add(item_i); imp_i = (ZEBAN_I_BE)list[1]; imps.Add(imp_i); serv_i = (ZEBAN_S_BE)list[2]; serv.Add(serv_i); } else if (tipo == "m") { ZEBAN_BE item = new ZEBAN_BE(); item = creaMateriales(valores_temp, id, cont); items.Add(item); } else { //res = creaServicios(valores, id, comentario); List <Object> list = new List <object>(); list = creaImputa(valores_temp, id, cont); ZEBAN_BE item_s = new ZEBAN_BE(); ZEBAN_I_BE imp_s = new ZEBAN_I_BE(); ZEBAN_S_BE serv_s = new ZEBAN_S_BE(); item_s = (ZEBAN_BE)list[0]; items.Add(item_s); imp_s = (ZEBAN_I_BE)list[1]; imps.Add(imp_s); } } int conf = ZEBAN_P_BLL.INSERT(header); //Insertar registro en SQL List <ZEBAN_P_BE> zeban_p = ZEBAN_P_BLL.GET(); int b = zeban_p[(zeban_p.Count - 1)].BANFN; int banfn = b; for (int i = 0; i < items.Count; i++) { items[i].BANFN = b; } for (int i = 0; i < imps.Count; i++) { imps[i].BANFN = b; } for (int i = 0; i < serv.Count; i++) { serv[i].BANFN = b; } conf += ZEBAN_BLL.INSERT(items); if (imps.Count > 0) { conf += ZEBAN_I_BLL.INSERT(imps); } if (serv.Count > 0) { conf += ZEBAN_S_BLL.INSERT(serv); } if (!comentario.Equals("")) { ZEBAN_C_BE com = new ZEBAN_C_BE(); com.BANFN = banfn; com.FK_USUARIO = us; com.TEXTO = comentario; conf += ZEBAN_C_BLL.INSERT(com); } //USUARIO_BE u = USUARIO_BLL.GET(us)[0]; //enviar(us, banfn, url); USUARIO_BE usuarioBe = USUARIO_BLL.GET(us)[0]; using (List <USUARIO_BE> .Enumerator enumerator = USUARIO_BLL.GET(USUARIO_BLL.GET(us)[0].AREA).GetEnumerator()) { while (enumerator.MoveNext()) { USUARIO_BE current = enumerator.Current; if (current.GEREN | current.DIREC) { header.BANFN = (b); header.STATUS = ("2"); conf += ZEBAN_P_BLL.UPDATE(header); enviarA(usuarioBe.NipLogin, b, url); } else { enviar(us, b, url); } } } return("B"); }
public abstract int ZEBAN_P_UPDATE(ZEBAN_P_BE requisiciones);
public abstract int ZEBAN_P_INSERT(ZEBAN_P_BE requisiciones);
public static int UPDATE(ZEBAN_P_BE requisiciones) { return(AbstractDataAccesLayerHelper.GetDataAccessLayer().ZEBAN_P_UPDATE(requisiciones)); }
public static int INSERT(ZEBAN_P_BE requisicion) { return(AbstractDataAccesLayerHelper.GetDataAccessLayer().ZEBAN_P_INSERT(requisicion)); }