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