public int Delete_Data(Select_Option select_Option)
{
int Result = -1;
connection.Open();
string commandQuery = AddQueryFile(select_Option);
command = new OleDbCommand(commandQuery, connection);
command.ExecuteNonQuery();
Result = 1;
connection.Close();
return(Result);
}
public DataTable Get_Data(Select_Option select_Option)
{
DataTable bufferTable = new DataTable();
connection.Open();
string commandQuery = AddQueryFile(select_Option);
DataAdapter = new OleDbDataAdapter(commandQuery, connection);
bufferTable.Clear();
DataAdapter.Fill(bufferTable);
connection.Close();
return(bufferTable);
}
private string AddQueryFile(Select_Option selectGr)
{
string Result = null;
try
{
string AppPath = Application.StartupPath;
string FileQuery_Path = null;
switch (selectGr)
{
case Select_Option.ColumsList:
FileQuery_Path = AppPath + @"\Queries\Columns.qrs";
break;
case Select_Option.Options:
FileQuery_Path = AppPath + @"\Queries\Options.qrs";
break;
case Select_Option.DeleteColumns:
FileQuery_Path = AppPath + @"\Queries\DeleteColumns.qrs";
break;
case Select_Option.Pogovorki:
FileQuery_Path = AppPath + @"\Queries\Sayings.qrs";
break;
case Select_Option.SystemInformation:
FileQuery_Path = AppPath + @"\Queries\SystemInformation.qrs";
break;
}
using (System.IO.StreamReader r = new System.IO.StreamReader(FileQuery_Path, System.Text.Encoding.GetEncoding(1251)))
{
string line = r.ReadToEnd();
Result = line;
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка при чтении настроек" + Environment.NewLine + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(Result);
}
//Y軸入力対応
void Input_Vertical()
{
//前のフレームで未入力なら
if (!stickDown)
{
//押されている
stickDown = true;
//入力があったら逆にする
switch (option)
{
case Select_Option.Player_Select:
option = Select_Option.Exit;
selected_exit = true;
break;
case Select_Option.Exit:
option = Select_Option.Player_Select;
selected_exit = false;
break;
}
}
}
