//busqueda en sap de los datos proporcionados
public void get_routes()
{
DataSet ds = new DataSet();
string name_function = "Zmaestro_Rutas";
try
{
IRfcFunction rfcFunction_Company = rfcRepository.CreateFunction(name_function.ToUpper());
rfcFunction_Company.Invoke(rfcDestination);
ds.Tables.Add(convert.toDataTable(rfcFunction_Company.GetTable("R_RUTA")));
DataSet dsCet = new DataSet();
DataTable dtCet = new DataTable();
DataSet cetsPermitidos = new DataSet();
string sqlQuery = "SELECT d.detalle_op FROM usuario u inner join detalle_usuario d "
+ "ON u.codigo_usuario = d.codigo_usuario WHERE u.usuario = '" + Session["usuario"] + "' AND d.maestro=4";
dataAdapter = new SqlDataAdapter(sqlQuery, connection);
dataAdapter.Fill(dsCet);
DataTable table = new DataTable("Agencias");
table.Columns.Add("codigo", typeof(Int32));
table = dsCet.Tables[0];
DataRow[] foundRow;
DataRow[] foundRow1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
foundRow = table.Select("detalle_op = '" + dr[1].ToString() + "'");
foundRow1 = table.Select("detalle_op = 'ATOTAL'");
if (foundRow1.Length == 1)
{
DatosPermitidos dp = new DatosPermitidos();
dp.sala_venta = dr[1].ToString();
dp.cet = dr[2].ToString();
dp.ruta = dr[3].ToString();
datos.Add(dp);
}
else
{
for (int q = 0; q < foundRow.Length; q++)
{
DatosPermitidos dp = new DatosPermitidos();
dp.sala_venta = dr[1].ToString();
dp.cet = dr[2].ToString();
dp.ruta = dr[3].ToString();
datos.Add(dp);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("<-- get_routes Error: " + ex.Message + " -->");
}
}
//llena el combo de agencia
public void cargoAgencia()
{
DataSet ds = new DataSet();
string name_function = "Zconsulta_Maestro_Detalle";
DataTable dt = new DataTable();
string sql = "SELECT d.detalle_op FROM usuario u inner join detalle_usuario d "
+ "ON u.codigo_usuario = d.codigo_usuario WHERE u.usuario = '" + Session["usuario"] + "' AND d.maestro=4";
try
{
dataAdapter = new SqlDataAdapter(sql, connection);
commandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Fill(dt);//contar rows
IRfcFunction rfcFunction_Company = rfcRepository.CreateFunction(name_function.ToUpper());
rfcFunction_Company.SetValue("I_Parametro", "SVENT");
rfcFunction_Company.Invoke(rfcDestination);
ds.Tables.Add(convert.toDataTable(rfcFunction_Company.GetTable("It_Datos")));
DataRow[] foundRow;
DataRow[] foundRow1;
int cont = 0;
Session["sociedades"] = ds.Tables[0];
foreach (DataRow dr in ds.Tables[0].Rows)
{
foundRow = dt.Select("detalle_op = '" + dr[0].ToString() + "'");
foundRow1 = dt.Select("detalle_op = 'ATOTAL'");
if (foundRow1.Length == 1)
{
cmbAgency.Items.Insert(cont, new ListItem(dr[1].ToString(), dr[0].ToString()));
cont++;
}
else
{
for (int q = 0; q < foundRow.Length; q++)
{
cmbAgency.Items.Insert(cont, new ListItem(dr[1].ToString(), dr[0].ToString()));
cont++;
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error cargoAgencia() --> " + ex.Message);
}
}
//llena las agencias con SAP
public void fill_Agency()
{
DataSet ds = new DataSet();
string name_function = "Zconsulta_Maestro_Detalle";
DataTable dt = new DataTable();
string sql = "SELECT d.detalle_op FROM usuario u inner join detalle_usuario d "
+ "ON u.codigo_usuario = d.codigo_usuario WHERE u.usuario = '" + Session["usuario"] + "' AND d.maestro=4;";
try
{
//Acá recupero los códigos de las agencias por usuario
dataAdapter = new SqlDataAdapter(sql, connection);
commandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Fill(dt);//contar rows
//Acá recupero la tabla de sap que contiene codigo y descripcion de las agencias
IRfcFunction rfcFunction_Company = rfcRepository.CreateFunction(name_function.ToUpper());
rfcFunction_Company.SetValue("I_Parametro", "SVENT");
rfcFunction_Company.Invoke(rfcDestination);
ds.Tables.Add(convert.toDataTable(rfcFunction_Company.GetTable("It_Datos")));
//Acá hago match con codigo de sql y sap, seteo la descripcion al dropdown
int cont1 = 0;
DataRow[] foundRow1;
foreach (DataRow dr in dt.Rows)
{
string permiso = dr[0].ToString();
if (permiso == "ATOTAL")
{
foreach (DataRow dr12 in ds.Tables[0].Rows)
{
//System.Diagnostics.Debug.WriteLine(dr12[1].ToString());
//System.Diagnostics.Debug.WriteLine(cont1);
cmbAgency.Items.Insert(cont1, new ListItem(dr12[1].ToString(), dr12[0].ToString()));
cont1++;
}
}
break;
}
DataRow[] foundRow;
int cont = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
foundRow = dt.Select("detalle_op = '" + dr[0].ToString() + "'");
for (int q = 0; q < foundRow.Length; q++)
{
cmbAgency.Items.Insert(cont, new ListItem(dr[1].ToString(), dr[0].ToString()));
cont++;
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error fill_agency() --> " + ex.Message);
}
}
