public static SqlDataReader  readPlanilha(string data1, string data2)
        {
            string        _sqlcommand = "Select * from tbDadosPlan where Data between @Data1 and @Data2 order by Data";
            SqlDataReader dr          = BDConnection.ReadDatabase(_sqlcommand, new SqlParameter("@Data1", data1), new SqlParameter("@Data2", data2));

            return(dr);
            //MessageBox.Show("nivel DAO" + dr.HasRows.ToString()); Teste para saber se o datareader chegou
        }
Beispiel #2
0
 //HELPERS
 private void exibeDatagrid()
 {
     #region converte data e salva data1 = datainicio ; data2 = dataFim
     //converte dd/mm/aaaa para aaaa-mm-dd
     string data1 = dataInicio.Value.Year.ToString() + "-" + dataInicio.Value.Month.ToString() + "-" + dataInicio.Value.Day.ToString();
     string data2 = dataFim.Value.Year.ToString() + "-" + dataFim.Value.Month.ToString() + "-" + dataFim.Value.Day.ToString();
     #endregion
     #region EXIBE DATAGRID
     dataT.Rows.Clear();                                                           //limpo o objeto
     dataT.Load(PlanilhaDAO.readPlanilha(data1, data2));                           //carrega dataread
     dgPlanilha.DataSource         = dataT;                                        //joga DataTable(backend) no Datagrid(UI)
     dgPlanilha.Columns[0].Visible = false; dgPlanilha.Columns[6].Visible = false; //Escondendo colunas
     BDConnection.fecharConexao();                                                 //Posso fechar a conexão, o dataread foi descarreado
     //MessageBox.Show(dataT.Rows.Count.ToString()); Teste verificar dataTable
     #endregion
 }
        public static void Insert(Planilha planilha)
        {
            string _sqlcommand = "INSERT INTO tbDadosPlan (Data, Filial, Ano, Caixa, Cte) values (@Data, @Filial, @Ano, @Caixa, @Cte)";

            BDConnection.ExecuteQueries(_sqlcommand, new SqlParameter("@Data", planilha.Data), new SqlParameter("@Filial", planilha.Filial), new SqlParameter("@Ano", planilha.Ano), new SqlParameter("@Caixa", planilha.Caixa), new SqlParameter("@Cte", planilha.Protocolo));
        }