private void GetData() { // 検索モード SearchType _searchType; if (this.rblSearch.SelectedIndex == 0) { _searchType = SearchType.Ambiguous; } else if (this.rblSearch.SelectedIndex == 1) { _searchType = SearchType.Part; } else { _searchType = SearchType.Complete; } String _keyword = MkaCommon.GetCondition(txtKeyword.Text.Trim(), _searchType); MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; // open connection if (dbCon.OpenConnection() != 1) { return; } con = dbCon.GetConnection(); // get search records cmd = new MySqlCommand("simple_get_records", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("_keyword", _keyword)); MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); lblResult.Visible = true; if (dt.Rows.Count == 0) { lblResult.Text = "見つかりませんでした."; } else { lblResult.Text = dt.Rows.Count.ToString() + "点が見つけました."; } gvResults.DataSource = dt; gvResults.DataBind(); // close connection dbCon.CloseConnection(); }
private void GetData() { TreeNode node = treeBatGlass.SelectedNode; String _batBangou, _glassBangou; if (node.Depth == 0) { _batBangou = node.Text; _glassBangou = ""; node.Expand(); } else { _batBangou = node.Parent.Text; _glassBangou = node.Text; } MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; // open connection if (dbCon.OpenConnection() != 1) { return; } con = dbCon.GetConnection(); // get search records cmd = new MySqlCommand("get_mokkan_from_batglass", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("_batBangou", _batBangou)); cmd.Parameters.Add(new MySqlParameter("_glassBangou", _glassBangou)); MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); gvResults.DataSource = dt; gvResults.DataBind(); // close connection dbCon.CloseConnection(); }
private Image GetImage(int RBangou) { MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; // open connection if (dbCon.OpenConnection() != 1) { return(null); } con = dbCon.GetConnection(); cmd = new MySqlCommand("get_mokkan_simple", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("_rBangou", RBangou)); MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); // close connection dbCon.CloseConnection(); if (dt.Rows.Count == 0) { return(new Bitmap(50, 50)); } String path = String.Format("{0}\\{1}\\{2}\\{3}\\{1}_{2}_{3}_{4}.jpg", ConfigurationSettings.AppSettings["MokkanPath"], dt.Rows[0][0], dt.Rows[0][1], dt.Rows[0][2], RBangou); Bitmap bmp = new Bitmap(path); int maxsize = Math.Max(bmp.Width, bmp.Height); float percentage = 1.0f; if (maxsize > MAX_SIZE) { percentage = (float)MAX_SIZE / maxsize; } Image ret = Resize(bmp, percentage); bmp.Dispose(); return(ret); }
private void LoadBatGlass() { MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; // open connection if (dbCon.OpenConnection() != 1) { return; } con = dbCon.GetConnection(); // get search records cmd = new MySqlCommand("get_bat_glass", con); cmd.CommandType = CommandType.StoredProcedure; MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); String _lastBat = ""; TreeNode _batNode, _glassNode; _batNode = new TreeNode(); foreach (DataRow row in dt.Rows) { if (row[0].ToString() != _lastBat) { _lastBat = row[0].ToString(); _batNode = new TreeNode(_lastBat, _lastBat, "~/images/bat.png"); treeBatGlass.Nodes.Add(_batNode); } _glassNode = new TreeNode(row[1].ToString(), row[1].ToString(), "~/images/glass.png"); _batNode.ChildNodes.Add(_glassNode); } // close connection dbCon.CloseConnection(); }
private Image GetImage(int RBangou) { MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; // open connection if (dbCon.OpenConnection() != 1) { return(null); } con = dbCon.GetConnection(); // get search records cmd = new MySqlCommand("get_mokkan_simple", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("_rBangou", RBangou)); MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); // close connection dbCon.CloseConnection(); if (dt.Rows.Count == 0) { return(new Bitmap(_resize.Width, _resize.Height)); } String path = String.Format("{0}\\{1}\\{2}\\{3}\\{1}_{2}_{3}_{4}.jpg", ConfigurationSettings.AppSettings["MokkanPath"], dt.Rows[0][0], dt.Rows[0][1], dt.Rows[0][2], RBangou); Bitmap bmp = new Bitmap(path); bmp = MkaCommon.ResizeImage(bmp, _resize); return(bmp); }
private void GetData() { MkaDBConnect dbCon = new MkaDBConnect(); MySqlConnection con; MySqlCommand cmd; GetKeywords(); // open connection if (dbCon.OpenConnection() != 1) { return; } con = dbCon.GetConnection(); // get search records cmd = new MySqlCommand("detail_get_records", con); cmd.CommandType = CommandType.StoredProcedure; if (_chousaJisuu == 0) { cmd.Parameters.Add(new MySqlParameter("_chousaJisuu", null)); } else { cmd.Parameters.Add(new MySqlParameter("_chousaJisuu", _chousaJisuu)); } cmd.Parameters.Add(new MySqlParameter("_ooChikuBangou", _ooChiku)); cmd.Parameters.Add(new MySqlParameter("_chuushouChikuBangou", _chuushouChiku)); cmd.Parameters.Add(new MySqlParameter("_ikouBangou", _ikoumei)); cmd.Parameters.Add(new MySqlParameter("_dosouMei", _dosoumei)); if (_grid == 0) { cmd.Parameters.Add(new MySqlParameter("_grid", null)); } else { cmd.Parameters.Add(new MySqlParameter("_grid", _grid)); } cmd.Parameters.Add(new MySqlParameter("_date", _date)); cmd.Parameters.Add(new MySqlParameter("_batBangou", _batBangou)); cmd.Parameters.Add(new MySqlParameter("_glassBangou", _glassItaBangou)); if (_rBangou == 0) { cmd.Parameters.Add(new MySqlParameter("_rBangou", null)); } else { cmd.Parameters.Add(new MySqlParameter("_rBangou", _rBangou)); } cmd.Parameters.Add(new MySqlParameter("_kariShakubun", _kariShakubun)); cmd.Parameters.Add(new MySqlParameter("_gaihouShoshuuJyouhou", _gaihouShoshuuJyouhou)); cmd.Parameters.Add(new MySqlParameter("_shasinBangouJyouhou", _shashinBangouJyouhou)); cmd.Parameters.Add(new MySqlParameter("_bikou", _bikou)); MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(rdr); lblResult.Visible = true; if (dt.Rows.Count == 0) { lblResult.Text = "見つかりませんでした."; } else { lblResult.Text = dt.Rows.Count.ToString() + "点が見つけました."; } gvResults.DataSource = dt; gvResults.DataBind(); // close connection dbCon.CloseConnection(); }