/// <summary> /// Metodo com nome errado (repetido se renomear) /// </summary> /// <typeparam name="T"></typeparam> /// <param name="context"></param> /// <param name="columnsView"></param> /// <param name="tipo"></param> /// <param name="title"></param> /// <returns></returns> public static dynamic ShowDiaglogFindEntity <T>(DbContextIts context, string[] columnsView, T tipo, string title = "Localizar:") where T : class { XFrmFindEntity xFrmFindEntity = initListaDinamica <T>(context, columnsView, title, tipo); xFrmFindEntity.ShowDialog(); return(xFrmFindEntity.TEntity); }
/// <summary> /// Recebe o contexto que recebe a string de conexão do banco a ser manipulado /// </summary> public Dao(DbContextIts contexto) { this.update = false; this.save = false; this.delete = false; this.dispose = false; this.contexto = contexto; //Set eh o DbSet que todo contexto tem this.DbSet = this.contexto.Set <T>(); this.Entry = new EntryIts <T>(this.contexto); }
public static dynamic ShowDiaglogFindEntity <T>(DbContextIts context, string[] columnsView, T tipo, string xmlFile, string title = "Localizar:") where T : class { XFrmFindEntity xFrmFindEntity = initListaDinamica <T>(context, columnsView, title, tipo); if (xmlFile != null) { xFrmFindEntity.gridViewResults.RestoreLayoutFromXml(xmlFile, OptionsLayoutBase.FullLayout); } xFrmFindEntity.ShowDialog(); return(xFrmFindEntity.TEntity); }
public XFrmClientUpdate(DbContextIts ctx) : this() { this._ctx = ctx; this._connectionString = ctx.NameOrConnectionString; cbDatabase.Properties.Items.Add(ctx.DatabaseName); pnlSql.Visible = true; cbDatabase.Properties.Items.Add(ctx.DatabaseName); var app = AppConfigManager.Configuration.AppConfig; txtServerName.Text = app.ServerName; cbDatabase.SelectedIndex = 0; this.pnlSql.Enabled = false; rChListTask.SetItemChecked(0, true); }
public static List <dynamic> ShowDialogFindListEntity <T>(DbContextIts context, string[] columnsView, T tipo, Stream layoutStream, string title = "Localizar:") where T : class { XFrmFindEntity xFrmFindEntity = initListaDinamica <T>(context, columnsView, title, tipo); xFrmFindEntity.gridViewResults.OptionsSelection.MultiSelect = true; if (layoutStream != null) { xFrmFindEntity.gridViewResults.RestoreLayoutFromStream(layoutStream, OptionsLayoutBase.FullLayout); } xFrmFindEntity.ShowDialog(); return(xFrmFindEntity.gridViewResults.GetSelectedItens <dynamic>()); }
/// <summary> /// Passar uma array de string com as colunas que deseja exibir /// </summary> /// <typeparam name="T">Entidade</typeparam> /// <param name="context">Contexto</param> /// <param name="columnsView">Array de colunas</param> /// <param name="title">Titulo da janela</param> /// <returns></returns> public static dynamic ShowDiaglogFindEntity <T>(DbContextIts context, string[] columnsView, T tipo, Stream layoutStream, string title = "Localizar:", Delegate action = null) where T : class { XFrmFindEntity xFrmFindEntity = initListaDinamica <T>(context, columnsView, title, tipo); if (layoutStream != null) { xFrmFindEntity.gridViewResults.RestoreLayoutFromStream(layoutStream, OptionsLayoutBase.FullLayout); } xFrmFindEntity.ShowDialog(); xFrmFindEntity.setDelegateActionPerfomed(action); return(xFrmFindEntity.TEntity); }
public static T ShowDialogFindTEntity <T>(DbContextIts ctx, Stream layoutStream) where T : class { XFrmFindEntity xFrmFindEntity = new XFrmFindEntity(); var x = new GenericContextIts <T>(ctx.NameOrConnectionString); xFrmFindEntity.gridControlResults.DataSource = x.Dao.FindAll(); xFrmFindEntity.TEntity = xFrmFindEntity.gridViewResults.GetFocusedRow() as T; if (layoutStream != null) { xFrmFindEntity.gridViewResults.RestoreLayoutFromStream(layoutStream, OptionsLayoutBase.FullLayout); } xFrmFindEntity.ShowDialog(); return(xFrmFindEntity.gridViewResults.GetFocusedRow <T>()); }
/// <summary> /// Faz a chamada da lista dinamica, este metodo requer uma string com as condicoes (WHERE) /// </summary> /// <typeparam name="T"></typeparam> /// <param name="context"></param> /// <param name="columnsView"></param> /// <param name="orderBy"></param> /// <param name="whereConditions"></param> /// <param name="title"></param> /// <param name="tipo"></param> /// <returns></returns> private static XFrmFindEntity initListaDinamica <T>(DbContextIts context, string[] columnsView, string orderBy, string whereConditions, string title, T tipo) where T : class { XFrmFindEntity xFrmFindEntity = new XFrmFindEntity(); IQueryable query; //Colunas que serão exibidas no grid var filter = "new ({0})"; var cols = ""; foreach (var c in columnsView) { if (columnsView.Count() > 1) { if (c != columnsView.Last()) { cols += "TEntity." + c + ","; } else { cols += "TEntity." + c; } } else { cols += "TEntity." + c; } } filter = String.Format(filter, cols); //se recebeu as condicoes, aplique-as if (!whereConditions.IsNullOrEmpty()) { query = (from TEntity in context.Set <T>().Where(whereConditions) select new { TEntity }).AsQueryable(); } else { query = (from TEntity in context.Set <T>() select new { TEntity }).AsQueryable(); } //Selecionando somente as colunas que quero exibir IQueryable iq = query.Select(filter); //ordenacao da lista - task 122 - gercy 10/10/2017 if (!orderBy.IsNullOrEmpty()) { iq = iq.OrderBy(orderBy); } //Lista tipada dinamica List <dynamic> list = new List <dynamic>(); //Fill List foreach (var item in iq) { list.Add(item); //guarda a referencia da lista carregada xFrmFindEntity.TList.Add(item); } //Cria uma linha tipada pro grid //guarda a referencia da lista carrega em uma lista tipada if (tipo != null) { var lista = new List <T>(); //adiciona o tipo informado lista.Add(tipo); //novo query query = (from TEntity in lista select new { TEntity }).AsQueryable(); //atualizando dados iq = query.Select(filter); //atualizando a lista list.Clear(); //reindexando foreach (var item in iq) { list.Add(item); } } //seta o elemento xFrmFindEntity.Text = title; xFrmFindEntity.gridControlResults.DataSource = list; xFrmFindEntity.gridViewResults.BestFitColumns(); xFrmFindEntity.TEntity = xFrmFindEntity.gridViewResults.GetFocusedRow(); return(xFrmFindEntity); }
public static List <dynamic> ShowDialogFindListEntity <T>(DbContextIts context, string[] columnsView, Stream layoutStream, string title = "Localizar:") where T : class { //sobre carga do metodo acima return(XFrmFindEntity.ShowDialogFindListEntity <T>(context, columnsView, null, layoutStream, title)); }