/// <summary>
/// Submit renamed bat, glass name
/// </summary>
private void treeExplorer_AfterLabelEdit(object sender, NodeLabelEditEventArgs e)
{
if (e.Label == null)
{
return;
}
if (e.Label.Trim() == "") // empty string
{
MkaMessage.ShowError(MkaMessage.ErrEmptyName);
e.CancelEdit = true;
return;
}
else if (e.Label.IndexOfAny(new char[] { '\\', '/', ':', '*', '?', '"', '<', '>', '|' }) != -1) // invalid characters
{
MkaMessage.ShowError(MkaMessage.ErrInvalidName);
e.CancelEdit = true;
return;
}
String newName = e.Label;
// change name
if (newName != _oldName)
{
if (e.Node.Level == 0)
{
_owner.FileChangeBatName(newName);
}
else
{
_owner.FileChangeGlassName(_oldName, newName);
}
}
}
/// <summary>
/// Check input remain id
/// </summary>
/// <returns></returns>
private bool CheckId()
{
String curId = dgrMokkan[0, dgrMokkan.CurrentCell.RowIndex].EditedFormattedValue.ToString();
int rid;
String error = "";
// check valid input
if (!Int32.TryParse(curId, out rid))
{
error = String.Format(MkaMessage.ErrNumberRequest, dgrMokkan.Columns[0].HeaderText);
MkaMessage.ShowError(error);
return(false);
}
// check duplication
if (MokkanList.CheckDuplexRID(rid))
{
error = String.Format(MkaMessage.ErrDublication, dgrMokkan.Columns[0].HeaderText);
MkaMessage.ShowError(error);
return(false);
}
return(true);
}
/// <summary>
/// Reset database
/// </summary>
private void ResetDb()
{
MkaDBConnect dbCon = new MkaDBConnect();
// open connection
if (dbCon.OpenConnection() == false)
{
MkaMessage.ShowError(MkaMessage.ErrDBConnect);
return;
}
MySqlConnection con = dbCon.GetConnection();
// reset database
MySqlCommand cmd = new MySqlCommand("reset_db", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
// close connection
dbCon.CloseConnection();
}
/// <summary>
/// Submit changed data
/// </summary>
private void btnOK_Click(object sender, EventArgs e)
{
// information
if (!_multi)
{
// check remain id
int rid;
String error = "";
// check valid input
if (!Int32.TryParse(txtRBangou.Text, out rid))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblRBangou));
txtRBangou.Focus();
MkaMessage.ShowError(error);
return;
}
// check duplication
if (rid != MokkanProperty.RBangou && MokkanList.CheckDuplexRID(rid))
{
error = String.Format(MkaMessage.ErrDublication, GetLblText(lblRBangou));
txtRBangou.Focus();
MkaMessage.ShowError(error);
return;
}
MokkanProperty.RBangou = rid;
}
MokkanProperty.KariShakubun = txtKariShakubun.Text;
MokkanProperty.GaihouShoshuuJyouhou = txtGaihouShoshuuJyouhou.Text;
MokkanProperty.ShasinBangouJyouhou = txtShashinBangouJyouhou.Text;
MokkanProperty.Bikou = txtBikou.Text;
// graphics
Properties = mkaGraphicsProperties.Properties;
Properties.RShowPosition = (ShowPosition)cmbRShowPosition.SelectedItem;
DialogResult = DialogResult.OK;
}
/// <summary>
/// Check input data
/// </summary>
/// <returns>true if all input data were valid</returns>
private bool CheckValidInput()
{
String error = "";
// remains id
_rBangou = 0;
if (txtRBangou.Text.Trim() != "" && !Int32.TryParse(txtRBangou.Text.Trim(), out _rBangou))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblRBangou)) + "\n" + error;
txtRBangou.Focus();
}
// check grid
_grid = 0;
if (txtGrid.Text.Trim() != "" && !Int32.TryParse(txtGrid.Text.Trim(), out _grid))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblGrid)) + "\n" + error;
txtGrid.Focus();
}
// check dig order
_chousaJisuu = 0;
if (txtChousaJisuu.Text.Trim() != "" && !Int32.TryParse(txtChousaJisuu.Text.Trim(), out _chousaJisuu))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblChousaJisuu)) + "\n" + error;
txtChousaJisuu.Focus();
}
// show error message
if (error != "")
{
MkaMessage.ShowError(error);
return(false);
}
return(true);
}
/// <summary>
/// Check input data
/// </summary>
/// <returns>true if all input data were valid</returns>
private bool CheckValidInput()
{
int number;
String path;
String error = "";
// check image path
path = this.txtImagePath.Text;
if (path == String.Empty)
{
error = String.Format(MkaMessage.ErrEmptyPath, GetLblText(lblImagePath)) + "\n" + error;
this.btnBrowser.Focus();
}
else if (!File.Exists(path))
{
error = String.Format(MkaMessage.ErrInvalid, GetLblText(lblImagePath)) + "\n" + error;
this.btnBrowser.Focus();
}
// check start remain id
if (!Int32.TryParse(txtKaishiRBangou.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblKaishiRBangou)) + "\n" + error;
txtKaishiRBangou.Focus();
}
// check glass id
if (txtGlassBangou.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblGlassBangou)) + "\n" + error;
txtGlassBangou.Focus();
}
// check bat number
if (txtBatBangou.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblBatBangou)) + "\n" + error;
txtBatBangou.Focus();
}
//// check grid
//if (!Int32.TryParse(txtGrid.Text, out number))
//{
// error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblGrid)) + "\n" + error;
// txtGrid.Focus();
//}
//// check layer name
//if (txtDosoumei.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblDosoumei)) + "\n" + error;
// txtDosoumei.Focus();
//}
//// check remain name
//if (txtIkoumei.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblIkoumei)) + "\n" + error;
// txtIkoumei.Focus();
//}
//// check narrow area
//if (txtChuushouChiku.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblChuusouChiku)) + "\n" + error;
// txtChuushouChiku.Focus();
//}
//// check large area
//if (txtOoChiku.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblOoChiku)) + "\n" + error;
// txtOoChiku.Focus();
//}
// check dig order
if (!Int32.TryParse(txtChousaJisuu.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblChousaJisuu)) + "\n" + error;
txtChousaJisuu.Focus();
}
//// check match directory
//String glass = Path.GetFileNameWithoutExtension(path);
//DirectoryInfo dir = new DirectoryInfo(Path.GetDirectoryName(path));
//String bat = dir.Parent.ToString();
//String grid = dir.Parent.Parent.ToString();
//if (glass != this.txtGlassBangou.Text)
//{
// error = String.Format(MkaMessage.ErrIncorrectFilePath, GetLblText(lblGlassBangou)) + "\n" + error;
// txtGlassBangou.Focus();
//}
//if (bat != this.txtBatBangou.Text)
//{
// error = String.Format(MkaMessage.ErrIncorrectFilePath, GetLblText(lblBatBangou)) + "\n" + error;
// txtBatBangou.Focus();
//}
//if (grid != this.txtGrid.Text)
//{
// error = String.Format(MkaMessage.ErrIncorrectFilePath, GetLblText(lblGrid)) + "\n" + error;
// txtGrid.Focus();
//}
// show error message
if (error != "")
{
MkaMessage.ShowError(error);
return(false);
}
return(true);
}
/// <summary>
/// Check id is duplicated or not
/// </summary>
private void propertyGrid_PropertyValueChanged(object s, PropertyValueChangedEventArgs e)
{
GridItem changedItem = e.ChangedItem;
_sError = "";
_error = false;
if ((changedItem.PropertyDescriptor.Name == MkaDefine.BatOoChiku) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatChuushouChiku) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatIkoumei) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatDosoumei) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatDate) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatBangou) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.GlassItaBangou))
{
String value = changedItem.Value.ToString().Trim();
if (value == String.Empty)
{
_sError = String.Format(MkaMessage.ErrInputRequest, changedItem.PropertyDescriptor.DisplayName);
_error = true;
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
}
else if ((changedItem.PropertyDescriptor.Name == MkaDefine.BatChousaJisuu) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.BatGrid) ||
(changedItem.PropertyDescriptor.Name == MkaDefine.GlassKaishiRBangou))
{
int value = Convert.ToInt32(changedItem.Value);
if (value <= 0)
{
_sError = String.Format(MkaMessage.ErrNumberRequest, changedItem.PropertyDescriptor.DisplayName);
_error = true;
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
else
{
if (changedItem.PropertyDescriptor.Name == MkaDefine.GlassKaishiRBangou)
{
DocumentArea.Rearrange(value - (int)e.OldValue);
}
}
}
else if (changedItem.PropertyDescriptor.Name == MkaDefine.MokkanRBangou)
{
int rid = Convert.ToInt32(changedItem.Value);
if (rid < 0)
{
_sError = String.Format(MkaMessage.ErrNumberRequest, changedItem.PropertyDescriptor.DisplayName);
_error = true;
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
else if (MokkanList.CheckDoubleRID(rid))
{
_sError = String.Format(MkaMessage.ErrDublication, changedItem.Label);
_error = true;
if (propertyGrid.SelectedObjects.Length == 1)
{
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
else
{
int i;
for (i = 0; i < propertyGrid.SelectedObjects.Length; i++)
{
MkaMokkanInfo mk = (MkaMokkanInfo)propertyGrid.SelectedObjects[i];
mk.RBangou = Rids[i];
}
}
}
}
else if (changedItem.PropertyDescriptor.Name == MkaDefine.GraphicPenWidth)
{
float penWid = (float)Convert.ToDouble(changedItem.Value);
if (penWid < 0.25 || penWid > 6)
{
_sError = MkaMessage.ErrInvalidPenWidth;
_error = true;
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
}
else if (changedItem.PropertyDescriptor.Name == MkaDefine.GraphicColorAlpha)
{
int alpha = Convert.ToInt32(changedItem.Value);
if (alpha < 0 || alpha > 255)
{
_sError = MkaMessage.ErrInvalidAlpha;
_error = true;
changedItem.PropertyDescriptor.SetValue(propertyGrid.SelectedObject, e.OldValue);
}
}
if (_error)
{
MkaMessage.ShowError(_sError);
this.Focus();
changedItem.Select();
return;
}
if (SelectedType == SelectedObjectType.Mokkan)
{
command.NewState(MokkanList);
DocumentArea.AddCommandToHistory(command);
}
DocumentArea.SetDirty();
// raise data change event
_owner.PropertyDataChange();
}
/// <summary>
/// Check input data
/// </summary>
/// <returns>true if all input data were valid</returns>
private bool CheckValidInput()
{
String error = "";
int number;
// check username
if (txtUsername.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblUsername)) + "\n" + error;
tbSettings.SelectedIndex = 1;
txtUsername.Focus();
}
// check database
if (txtDatabase.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblDatabase)) + "\n" + error;
tbSettings.SelectedIndex = 1;
txtDatabase.Focus();
}
// check server
if (txtServer.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblServer)) + "\n" + error;
tbSettings.SelectedIndex = 1;
txtServer.Focus();
}
// check start remain id
if (!Int32.TryParse(txtKaishiRBangou.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblKaishiRBangou)) + "\n" + error;
txtKaishiRBangou.Focus();
}
// check bat number
if (txtBatBangou.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblBatBangou)) + "\n" + error;
txtBatBangou.Focus();
}
// check grid
if (!Int32.TryParse(txtGrid.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblGrid)) + "\n" + error;
txtGrid.Focus();
}
// check layer name
if (txtDosoumei.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblDosoumei)) + "\n" + error;
txtDosoumei.Focus();
}
// check remain name
if (txtIkoumei.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblIkoumei)) + "\n" + error;
txtIkoumei.Focus();
}
// check narrow area
if (txtChuushouChiku.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblChuusouChiku)) + "\n" + error;
txtChuushouChiku.Focus();
}
// check large area
if (txtOoChiku.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblOoChiku)) + "\n" + error;
txtOoChiku.Focus();
}
// check dig order
if (!Int32.TryParse(txtChousaJisuu.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblChousaJisuu)) + "\n" + error;
txtChousaJisuu.Focus();
}
// show error message
if (error != "")
{
MkaMessage.ShowError(error);
return(false);
}
return(true);
}
/// <summary>
/// Check input data
/// </summary>
/// <returns>true if all input data were valid</returns>
private bool CheckValidInput()
{
int number;
String error = "";
// check bat number
if (txtBatBangou.Text.Trim() == "")
{
error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblBatBangou)) + "\n" + error;
txtBatBangou.Focus();
}
//// check grid
//if (!Int32.TryParse(txtGrid.Text, out number))
//{
// error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblGrid)) + "\n" + error;
// txtGrid.Focus();
//}
//// check layer name
//if (txtDosoumei.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblDosoumei)) + "\n" + error;
// txtDosoumei.Focus();
//}
//// check remain name
//if (txtIkoumei.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblIkoumei)) + "\n" + error;
// txtIkoumei.Focus();
//}
//// check narrow area
//if (txtChuushouChiku.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblChuusouChiku)) + "\n" + error;
// txtChuushouChiku.Focus();
//}
//// check large area
//if (txtOoChiku.Text.Trim() == "")
//{
// error = String.Format(MkaMessage.ErrInputRequest, GetLblText(lblOoChiku)) + "\n" + error;
// txtOoChiku.Focus();
//}
// check dig order
if (!Int32.TryParse(txtChousaJisuu.Text, out number))
{
error = String.Format(MkaMessage.ErrNumberRequest, GetLblText(lblChousaJisuu)) + "\n" + error;
txtChousaJisuu.Focus();
}
// show error message
if (error != "")
{
MkaMessage.ShowError(error);
return(false);
}
return(true);
}
/// <summary>
/// Get retured result and display on datagrid
/// </summary>
private void LoadPage()
{
btnPrevious.Enabled = (_currentPage == 0) ? false : true;
btnNext.Enabled = (_currentPage == _pageCount - 1) ? false : true;
MkaDBConnect dbCon = new MkaDBConnect();
MySqlConnection con;
MySqlCommand cmd;
int intSkip = _currentPage * _pageSize;
// open connection
if (dbCon.OpenConnection() == false)
{
MkaMessage.ShowError(MkaMessage.ErrDBConnect);
return;
}
con = dbCon.GetConnection();
this.Cursor = Cursors.WaitCursor;
// get search records
cmd = new MySqlCommand("get_records", con);
cmd.CommandTimeout = 600; // 10 minutes
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));
cmd.Parameters.Add(new MySqlParameter("_pageSize", _pageSize));
cmd.Parameters.Add(new MySqlParameter("_skip", intSkip));
MySqlDataReader rdr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(rdr);
Size _resize = new Size(64, 64);
DateTime _dDate;
String path = "", _sDate;
Bitmap bmp = null;
dtgrResult.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
try
{
// get mokkan image
path = String.Format("{0}\\{1}\\{2}\\{3}\\{1}_{2}_{3}_{4:00000}.jpg", MkaDefine.MokkanPath, row[11], row[6], row[5], row[0]);
bmp = new Bitmap(path);
}
catch
{
MessageBox.Show("ダータベースの画像ファイルを開くことできません" + Environment.NewLine +
path + "を見付けません", "メッセージ", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
//_log.Error("Can not open image!: " + path +Environment.NewLine);
// delete mokkan of the glass if existed
//cmd = new MySqlCommand("delete_mokkan", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new MySqlParameter("_rBangou", row[0]));
//cmd.ExecuteNonQuery();
//_log.Info("Deleted registered but not existed item.");
continue;
}
bmp = ResizeImage(bmp, _resize);
_dDate = DateTime.ParseExact(row[12].ToString(), MkaDefine.DBDateFormat, null);
_sDate = _dDate.ToString(MkaDefine.DateFormat);
// add row
dtgrResult.Rows.Add(bmp, row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], _sDate);
}
// close connection
dbCon.CloseConnection();
lblPage.Visible = true;
lblPage.Text = String.Format("{0}/{1}", _currentPage + 1, _pageCount);
this.Cursor = Cursors.Default;
}
/// <summary>
/// Get number of returned records
/// </summary>
private void GetCount()
{
MkaDBConnect dbCon = new MkaDBConnect();
MySqlConnection con;
MySqlCommand cmd;
// open connection
if (dbCon.OpenConnection() == false)
{
MkaMessage.ShowError(MkaMessage.ErrDBConnect);
return;
}
con = dbCon.GetConnection();
this.Cursor = Cursors.WaitCursor;
// get search record count
cmd = new MySqlCommand("get_count", 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));
cmd.Parameters.Add(new MySqlParameter("_recCount", _totalRecords));
cmd.Parameters["_recCount"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
_totalRecords = (int)cmd.Parameters["_recCount"].Value;
// close connection
dbCon.CloseConnection();
this.Cursor = Cursors.Default;
}
