public List <ZEBAN_BE> ZEBAN_GET(IDataReader reader) { List <ZEBAN_BE> zeban = new List <ZEBAN_BE>(); try { while (reader.Read()) { ZEBAN_BE z = new ZEBAN_BE(); z.BANFN = Int32.Parse(reader["BANFN"].ToString()); z.BNFPO = reader["BNFPO"].ToString(); z.MATNR = reader["MATNR"].ToString(); z.DESCR = reader["DESCR"].ToString(); z.MEINS = reader["MEINS"].ToString(); z.MENGE = Decimal.Parse(reader["MENGE"].ToString()); z.WERKS = reader["WERKS"].ToString(); z.PREIS = Decimal.Parse(reader["PREIS"].ToString()); z.WAERS = reader["WAERS"].ToString(); z.IMP = reader["IMP"].ToString(); z.TIPO = reader["TIPO"].ToString(); z.PUR_GR = reader["PUR_GR"].ToString(); z.MAT_GR = reader["MAT_GR"].ToString(); z.F_ENTREGA = DateTime.Parse(reader["F_ENTREGA"].ToString()); zeban.Add(z); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(zeban); }
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"); }
private static List <Object> creaServicios(string valores, string id, int cont) { string[] item = valores.Split('|'); ////ZEBAN_P_BE header = new ZEBAN_P_BE(); ZEBAN_BE items = new ZEBAN_BE(); Conexion con = new Conexion(); ////header.FK_USUARIO = user; ////header.STATUS = getStatus(user); ////header.F_APROBACION = DateTime.Now; ////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; ////items.BANFN = banfn; IRfcTable serv = con.check_servicio(id, "S"); items.BNFPO = "" + (cont * 10); items.DESCR = item[0]; items.DESCR = serv.GetString("DESCR"); items.F_ENTREGA = DateTime.Parse(item[4]); items.MAT_GR = item[2]; serv.CurrentIndex = 0; //items.MEINS = serv.GetString("UM"); items.MEINS = "SER"; //items.MENGE = Decimal.Parse(item[3]); items.MENGE = 1; //items.PREIS = Decimal.Parse(item[1]); items.PUR_GR = ConfigurationManager.AppSettings["purchaseGroup"]; items.TIPO = "F"; items.IMP = "K"; items.WERKS = ConfigurationManager.AppSettings["werks"]; items.WAERS = item[5]; ////List<ZEBAN_BE> Items = new List<ZEBAN_BE>(); ////Items.Add(items); ////conf += ZEBAN_BLL.INSERT(Items); //Insertar registro en SQL List <ZEBAN_S_BE> servs = new List <ZEBAN_S_BE>(); ZEBAN_S_BE temp = new ZEBAN_S_BE(); //temp.BANFN = banfn; temp.BNFPO = "" + (cont * 10); temp.SERIAL = 1; temp.MEINS = "SER"; temp.SERVICIO = serv.GetString("SERVICIO"); temp.TEXTO = con.check_servDesc(temp.SERVICIO); temp.MENGE = Decimal.Parse(item[3]); temp.PREIS = Decimal.Parse(item[1]); temp.WAERS = item[5]; servs.Add(temp); //conf += ZEBAN_S_BLL.INSERT(servs); //Insertar registro en SQL List <ZEBAN_I_BE> imps = new List <ZEBAN_I_BE>(); ZEBAN_I_BE tempi = new ZEBAN_I_BE(); //tempi.BANFN = banfn; tempi.BNFPO = "" + (cont * 10); tempi.SERIAL = 1; tempi.LINE = 1; tempi.GL_ACCOUNT = servs[0].GL_ACCOUNT; tempi.COSTCENTER = servs[0].COSTCENTER; imps.Add(tempi); //conf += ZEBAN_I_BLL.INSERT(imps); //Insertar registro en SQL //if (!comentario.Equals("")) //{ // ZEBAN_C_BE com = new ZEBAN_C_BE(); // com.BANFN = banfn; // com.FK_USUARIO = user; // com.TEXTO = comentario; // conf += ZEBAN_C_BLL.INSERT(com); //} //return "B"; List <Object> lista = new List <object>(); lista.Add(items); lista.Add(tempi); lista.Add(temp); return(lista); }
private static ZEBAN_BE creaMateriales(string valores, string id, int cont)//, string comentario) { string[] item = valores.Split('|'); //ZEBAN_P_BE header = new ZEBAN_P_BE(); ZEBAN_BE items = new ZEBAN_BE(); //Conexion con = new Conexion(); //header.FK_USUARIO = user; //header.STATUS = getStatus(user); //header.F_APROBACION = DateTime.Now; //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; //items.BANFN = banfn; items.BNFPO = "" + (cont * 10); items.DESCR = item[0]; items.F_ENTREGA = DateTime.Parse(item[4]); items.MAT_GR = item[2]; items.MATNR = id; items.MENGE = Decimal.Parse(item[3]); items.PREIS = Decimal.Parse(item[1]); items.PUR_GR = ConfigurationManager.AppSettings["purchaseGroup"]; //items.TIPO = "F"; //items.IMP = "A"; items.WERKS = ConfigurationManager.AppSettings["werks"]; items.WAERS = item[5]; ////List<ZEBAN_BE> Items = new List<ZEBAN_BE>(); ////Items.Add(items); ////conf += ZEBAN_BLL.INSERT(Items); //Insertar registro en SQL //List<ZEBAN_S_BE> servs = new List<ZEBAN_S_BE>(); //ZEBAN_S_BE temp = new ZEBAN_S_BE(); //temp.BANFN = banfn; //temp.BNFPO = "10"; //temp.SERIAL = 1; //temp.MEINS = act.GetString("UM"); //temp.SERVICIO = act.GetString("SERVICIO"); //temp.ASSET_NUM = act.GetString("ACTIVO"); //temp.TEXTO = item[0]; //temp.MENGE = Decimal.Parse(item[3]); //temp.PREIS = Decimal.Parse(item[1]); //servs.Add(temp); //conf += ZEBAN_S_BLL.INSERT(servs); //Insertar registro en SQL //List<ZEBAN_I_BE> imps = new List<ZEBAN_I_BE>(); //ZEBAN_I_BE tempi = new ZEBAN_I_BE(); //tempi.BANFN = banfn; //tempi.BNFPO = "10"; //tempi.SERIAL = servs[0].SERIAL; //tempi.MENGE = Decimal.Parse(item[3]); //tempi.LINE = 1; //tempi.GL_ACCOUNT = servs[0].GL_ACCOUNT; //tempi.COSTCENTER = servs[0].COSTCENTER; //imps.Add(tempi); //conf += ZEBAN_I_BLL.INSERT(imps); //Insertar registro en SQL ////if (!comentario.Equals("")) ////{ //// ZEBAN_C_BE com = new ZEBAN_C_BE(); //// com.BANFN = banfn; //// com.FK_USUARIO = user; //// com.TEXTO = comentario; //// conf += ZEBAN_C_BLL.INSERT(com); ////} ////return "B"; return(items); }