public DataTable ListarResponsable(in23responsable oin23responsable)
        {
            DataTable dtData = null;
            _command = _database.GetStoredProcCommand("usp_ControlPedido_listarResponsable");
            try
            {

                _database.AddInParameter(_command, "@in23codemp", System.Data.DbType.String, oin23responsable.in23codemp );
                _database.AddInParameter(_command, "@in23SistemaUsuario", System.Data.DbType.String, oin23responsable.in23SistemaUsuario);

                dtData = _database.ExecuteDataSet(_command).Tables[0];
                return dtData;
            }
            catch (Exception)
            {

                throw;
            }
        }
 public DataTable ListarResponsable(in23responsable oin23responsable)
 {
     return new ResponsableDAL().ListarResponsable(oin23responsable);
 }
    private void ListarJefeArea()
    {
        try
        {
            in23responsable oin23responsable = new in23responsable();
            oin23responsable.in23codemp = _auditoria.CodigoEmpresa;

            if (this.hidFlujoProceso.Value.CompareTo(UIConstante.FlujoProceso.JefeArea.ToString()) == 0)
            {
                oin23responsable.in23SistemaUsuario = _auditoria.usuario.Nombre;
            }
            else
            {
                oin23responsable.in23SistemaUsuario = string.Empty;
            }

            Bind(this.ddlJefeArea, oResponsableBLL.ListarResponsable(oin23responsable), "in23Codigo", "In23Descri");
            if (this.hidFlujoProceso.Value.CompareTo(UIConstante.FlujoProceso.JefeArea.ToString()) != 0)
            {
                this.ddlJefeArea.Items.Insert(0, new ListItem("--Todos--", "0"));
            }
        }
        catch (Exception ex)
        {

            throw;
        }
    }
    private void ListarJefeArea()
    {
        try
        {
            in23responsable oin23responsable = new in23responsable();
            oin23responsable.in23codemp = _auditoria.CodigoEmpresa;
            oin23responsable.in23SistemaUsuario = _auditoria.usuario.Nombre;

            Bind(this.ddlJefeArea, oResponsableBLL.ListarResponsable(oin23responsable), "in23Codigo", "In23Descri");
            //this.ddlJefeArea.Items.Insert(0, new ListItem("--Todos--", "0"));
        }
        catch (Exception ex)
        {

            throw;
        }
    }