/// <summary>
/// Carga los datos del grid
/// </summary>
public void Refrescar()
{
string consulta = "";
FrmUsuarios ClseUser = new FrmUsuarios();
JobEnvioSobreMasivo Usuario = new JobEnvioSobreMasivo();
//Establecer consulta
if (Usuario.SuperUsuario())
{
consulta = "SELECT CASE WHEN (U_Tipo = '111' OR U_Tipo = '101' OR U_Tipo = '103' OR U_Tipo = '113') THEN " +
"(SELECT DocNum FROM OINV WHERE DocEntry = U_DocSap) WHEN (U_Tipo = '112' OR U_Tipo = '102') THEN " +
"(SELECT DocNum FROM ORIN WHERE DocEntry = U_DocSap) WHEN (U_Tipo = '181') THEN (SELECT DocNum FROM " +
"ODLN WHERE DocEntry = U_DocSap) ELSE U_DocSap END AS 'Número de Documento SAP', U_Tipo AS 'Tipo Documento', " +
"U_Serie AS 'Serie', U_Numero AS 'Número CFE', CreateDate AS 'Fecha Creación' FROM [@TFECONSOB]" +
"WHERE U_Estado = 'Pendiente' ";
}
else
{
consulta = "SELECT CASE WHEN (U_Tipo = '111' OR U_Tipo = '101' OR U_Tipo = '103' OR U_Tipo = '113') THEN " +
"(SELECT DocNum FROM OINV WHERE DocEntry = U_DocSap) WHEN (U_Tipo = '112' OR U_Tipo = '102') THEN " +
"(SELECT DocNum FROM ORIN WHERE DocEntry = U_DocSap) WHEN (U_Tipo = '181') THEN (SELECT DocNum FROM " +
"ODLN WHERE DocEntry = U_DocSap) ELSE U_DocSap END AS 'Número de Documento SAP', U_Tipo AS 'Tipo Documento', " +
"U_Serie AS 'Serie', U_Numero AS 'Número CFE', CreateDate AS 'Fecha Creación' FROM [@TFECONSOB]" +
"WHERE U_Estado = 'Pendiente' AND U_Usuario = '" + ProcConexion.Comp.UserName + "' AND CreateDate BETWEEN '" +
DateTime.Now.ToString("yyyy-MM-dd") +
"' AND '" + DateTime.Now.ToString("yyyy-MM-dd") + "'";
}
try
{
Formulario.Freeze(true);
Formulario.DataSources.DataTables.Item("dtGrdEnv").ExecuteQuery(consulta);
Formulario.Items.Item("btnEnv").Enabled = true;
((Grid)Formulario.Items.Item("grdEnv").Specific).Columns.Item(0).Editable = false;
((Grid)Formulario.Items.Item("grdEnv").Specific).Columns.Item(1).Editable = false;
((Grid)Formulario.Items.Item("grdEnv").Specific).Columns.Item(2).Editable = false;
((Grid)Formulario.Items.Item("grdEnv").Specific).Columns.Item(3).Editable = false;
((Grid)Formulario.Items.Item("grdEnv").Specific).Columns.Item(4).Editable = false;
Formulario.Freeze(false);
}
catch (Exception)
{
}
}
/// <summary>
/// Obtiene le docEntry de un sobre
/// </summary>
/// <param name="control"></param>
/// <returns></returns>
public ControlSobres ObtenerDocEntry(ControlSobres control)
{
Recordset recSet = null;
string consulta = "";
try
{
//Obtener objeto de recordset
recSet = ProcConexion.Comp.GetBusinessObject(BoObjectTypes.BoRecordset);
JobEnvioSobreMasivo Usuario = new JobEnvioSobreMasivo();
//Establecer consulta
if (Usuario.SuperUsuario())
{
consulta = "SELECT DocEntry FROM [@TFECONSOB] WHERE U_Tipo = '" + control.Tipo + "' AND U_Serie ='" +
control.Serie + "' AND U_Numero = '" + control.Numero + "'";
}
else
{
consulta = "SELECT DocEntry FROM [@TFECONSOB] WHERE U_Tipo = '" + control.Tipo + "' AND U_Serie ='" +
control.Serie + "' AND U_Numero = '" + control.Numero + "' AND U_Usuario = '" + control.UsuarioSap + "'";
}
//Ejectura consulta
recSet.DoQuery(consulta);
//Posicionar cursor al inicio
recSet.MoveFirst();
//Validar que existan valores
if (recSet.RecordCount > 0)
{
control.DocEntry = recSet.Fields.Item("DocEntry").Value + "";
}
}
catch (Exception)
{
}
finally
{
if (recSet != null)
{
//Se libera el objeto de memoria
System.Runtime.InteropServices.Marshal.ReleaseComObject(recSet);
System.GC.Collect();
}
}
return(control);
}
