/// <summary>
/// Test connection with user-input configure information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnTest_Click(object sender, EventArgs e)
{
RetrieveData();
int ret = MkaDBConnect.TryOpenConnection(strAddress, strDatabase, strUsername, strPassword);
this.imgResult.Visible = true;
if (ret == 1)
{
this.imgResult.ImageUrl = "~/images/connect_success.png";
this.lblTestResult.Text = MkaMessage.SuccessDBConnect;
this.lblTestResult.ForeColor = Color.Green;
}
else
{
this.imgResult.ImageUrl = "~/images/connect_error.png";
this.lblTestResult.ForeColor = Color.Red;
if (ret == 1045)
{
this.lblTestResult.Text = MkaMessage.ErrDBInvalidID;
}
else
{
this.lblTestResult.Text = MkaMessage.ErrDBConnect;
}
}
}
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();
}
protected void ViewData(String rBangou)
{
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_details", 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);
if (dt.Rows.Count == 0)
{
return;
}
lblChousaJisuu.Text = Convert.ToString(dt.Rows[0]["調査次数"]);
lblChikuBangou.Text = Convert.ToString(dt.Rows[0]["調査地区"]);
lblIkoumei.Text = Convert.ToString(dt.Rows[0]["遺構名"]);
lblDosoumei.Text = Convert.ToString(dt.Rows[0]["土層名"]);
lblGrid.Text = Convert.ToString(dt.Rows[0]["グリッド"]);
String strDate = Convert.ToString(dt.Rows[0]["出土日付"]);
lblDate.Text = strDate.Substring(0, 4) + "年" + strDate.Substring(4, 2) + "月" + strDate.Substring(6, 2) + "日";
lblBatBangou.Text = Convert.ToString(dt.Rows[0]["バット番号"]);
lblGlassItaBangou.Text = Convert.ToString(dt.Rows[0]["ガラス板番号"]);
lblRBangou.Text = Convert.ToString(dt.Rows[0]["R番号"]);
lblKariShakubun.Text = Convert.ToString(dt.Rows[0]["仮釈文"]);
lblGaihouShosuuJyouhou.Text = Convert.ToString(dt.Rows[0]["概報所収情報"]);
lblShasinBangouJyouhou.Text = Convert.ToString(dt.Rows[0]["写真番号情報"]);
lblBikou.Text = Convert.ToString(dt.Rows[0]["備考"]);
}
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();
}
