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