Пример #1
0
        public void GetDataTableTestWithCondition()
        {
            DataConfiguration dataConfiguration = new DataConfiguration();

            dataConfiguration.ReadConfiguration();

            string query = @"SELECT a.nib FROM so_pos a
                                WHERE a.pos_d > {5/11/14}";

            string query2 = @"SELECT a.nib, a.pac_born, a.pacfam, a.pacname, a.pacsurname, a.pac_sex,
                         a.pos_kno, a.out_kno, a.citycount, a.m_kres,
                         a.pos_t, a.pos_d, a.out_d, a.out_t, a.withmother
                         FROM so_otd b, so_pos a
                            WHERE a.nib = b.nib AND a.pos_d >= {4/1/14} AND a.out_d <= {1/11/15}";

            var queryTable = sqlDataHelper.DoQuery(dataConfiguration.Path, query2);

            Assert.IsTrue(queryTable.Rows.Count > 0);
            Console.WriteLine("Count = {0}", queryTable.Rows.Count);

            /*    foreach (DataRow dataRow in queryTable.Rows)
             *  {
             *      foreach (var item in dataRow.ItemArray)
             *      {
             *          Console.WriteLine(item);
             *      }
             *  } */
        }