コード例 #1
0
ファイル: Products.cs プロジェクト: x-plora/miakro911
        public CatalogData Get()
        {
            int imageSize;

            byte[]      image;
            CatalogData cd = new CatalogData();

            cd.ColNames = new String[] { "Название продукции", "Единицы измерения", CatalogData.IMAGE_MARKER + "Изображение" };
            MySqlCommand           cmd = new MySqlCommand("SELECT p_id,p_name,p_unit,p_image,p_image,p_imgsize FROM products ORDER BY p_id ASC;", sql);
            MySqlDataReader        rd  = cmd.ExecuteReader();
            List <CatalogData.Row> rws = new List <CatalogData.Row>();

            while (rd.Read())
            {
                CatalogData.Row rw = new CatalogData.Row();
                rw.key = rd.GetInt32(0);
                //rw.imageSize = rd.GetInt32("p_imgsize");
                imageSize = rd.GetInt32("p_imgsize");
                image     = new byte[imageSize];
                if (imageSize != 0)
                {
                    rd.GetBytes(rd.GetOrdinal("p_image"), 0, image, 0, imageSize);
                }

                rw.data = new String[] { rd.GetString("p_name"), rd.GetString("p_unit"), Convert.ToBase64String(image) };
                rws.Add(rw);
            }
            rd.Close();
            cd.Rows = rws.ToArray();
            return(cd);
        }
コード例 #2
0
ファイル: Breeds.cs プロジェクト: x-plora/miakro911
        public CatalogData Get()
        {
            CatalogData cd = new CatalogData();

            cd.ColNames = new String[] { "порода", "сокращение", CatalogData.COLOR_MARKER + "Цвет" };
            MySqlCommand           cmd = new MySqlCommand("SELECT b_id,b_name,b_short_name,b_color FROM breeds ORDER BY b_id;", sql);
            MySqlDataReader        rd  = cmd.ExecuteReader();
            List <CatalogData.Row> rws = new List <CatalogData.Row>();

            while (rd.Read())
            {
                CatalogData.Row rw = new CatalogData.Row();
                rw.key  = rd.GetInt32(0);
                rw.data = new String[] { rd.GetString(1), rd.GetString(2), rd.GetString(3) };
                rws.Add(rw);
            }
            rd.Close();
            cd.Rows = rws.ToArray();
            return(cd);
        }
コード例 #3
0
        public CatalogData Get()
        {
            CatalogData cd = new CatalogData();

            cd.ColNames = new String[] { "Причина" };
            MySqlCommand           cmd = new MySqlCommand("SELECT d_id,d_name FROM deadreasons WHERE d_id>2 ORDER BY d_id;", sql);
            MySqlDataReader        rd  = cmd.ExecuteReader();
            List <CatalogData.Row> rws = new List <CatalogData.Row>();

            while (rd.Read())
            {
                CatalogData.Row rw = new CatalogData.Row();
                rw.key  = rd.GetInt32(0);
                rw.data = new String[] { rd.GetString(1) };
                rws.Add(rw);
            }
            rd.Close();
            cd.Rows = rws.ToArray();
            return(cd);
        }
コード例 #4
0
        public CatalogData Get()
        {
            CatalogData cd = new CatalogData();

            cd.ColNames = new String[] { "ген", "зона", "сокращение" };
            MySqlCommand           cmd = new MySqlCommand("SELECT z_id,z_name,z_short_name FROM zones ORDER BY z_name;", sql);
            MySqlDataReader        rd  = cmd.ExecuteReader();
            List <CatalogData.Row> rws = new List <CatalogData.Row>();

            while (rd.Read())
            {
                CatalogData.Row rw = new CatalogData.Row();
                rw.key  = rd.GetInt32(0);
                rw.data = new String[] { rd.GetString(0), rd.GetString(1), rd.GetString(2) };
                rws.Add(rw);
            }
            rd.Close();
            cd.Rows = rws.ToArray();
            return(cd);
        }