public DiamondShoppingItem GetDiamondShoppingItem(int itemID)
        {
            DiamondShoppingItem[] items = null;
            MyDBHelper.Instance.ConnectionCommandSelect(mycmd =>
            {
                string sqlText = "select * from diamondshoppingitem where `ID`=@ID ";
                mycmd.Parameters.AddWithValue("@ID", itemID);
                mycmd.CommandText        = sqlText;
                DataTable table          = new DataTable();
                MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
                adapter.Fill(table);
                items = MetaDBAdapter <DiamondShoppingItem> .GetDiamondShoppingItemFromDataTable(table);
                table.Dispose();
                adapter.Dispose();
            });

            if (items == null || items.Length == 0)
            {
                return(null);
            }
            return(items[0]);
        }
        public DiamondShoppingItem[] GetDiamondShoppingItems(bool getAllSellState, SellState state, DiamondsShoppingItemType itemType)
        {
            DiamondShoppingItem[] items = null;
            MyDBHelper.Instance.ConnectionCommandSelect(mycmd =>
            {
                string sqlText = "select * from diamondshoppingitem where `Type`=@Type ";
                mycmd.Parameters.AddWithValue("@Type", (int)itemType);
                if (!getAllSellState)
                {
                    sqlText += " and SellState=@SellState ";
                    mycmd.Parameters.AddWithValue("@SellState", (int)state);
                }
                mycmd.CommandText        = sqlText;
                DataTable table          = new DataTable();
                MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
                adapter.Fill(table);
                items = MetaDBAdapter <DiamondShoppingItem> .GetDiamondShoppingItemFromDataTable(table);
                table.Dispose();
                adapter.Dispose();
            });

            return(items);
        }