/// <summary>
/// ��Ʈw�s�W��k
/// </summary>
/// <param name="insert"></param>
public void insert(ICommand insert)
{
string myCmd = insert.getCommand();
try
{
cmd = new OdbcCommand(myCmd, GetConn());
//cmd = new IBM.Data.DB2.DB2Command(myCmd, GetConn());
cmd.ExecuteNonQuery();
}
catch (OdbcException dobcEx)
{
if (dobcEx.ErrorCode == -2146232009)
{
return;
}
try
{
lock (typeof(OdbcConnection))
{
//cmd = new IBM.Data.DB2.DB2Command(myCmd, GetConn());
cmd = new OdbcCommand(myCmd, GetConn());
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
private void btStart_Click(object sender, EventArgs e)
{
lOutput.Text = "?";
FFMpegRunner runner = new FFMpegRunner();
runner.OutputDataReceived += (s) =>
{
this.Invoke(new Action(() =>
{
tbLog.AppendText("\r\n" + s);
}));
};
runner.Exited += () =>
{
this.Invoke(new Action(() =>
{
lOutput.Text = "Done: " + command.getOutFileName();
}));
};
string cmd = command.getCommand();
tbLog.AppendText("\r\nCommand to execute: " + cmd);
runner.Start(Path.Combine(Application.StartupPath, MainForm.C_WorkFolderName, MainForm.C_FFMpegBinName), cmd);
}
/// <summary>
/// ��Ʈw�s�W��k
/// </summary>
/// <param name="insert"></param>
public void insert(ICommand insert)
{
string myCmd = insert.getCommand();
try
{
cmd = new OdbcCommand(myCmd, conn);
cmd.ExecuteNonQuery();
}
catch
{
try
{
conn.Close();
conn.Open();
cmd = new OdbcCommand(myCmd, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
/// <summary>
/// ��Ʈw��s��k
/// </summary>
/// <param name="updata"></param>
public void update(ICommand updata)
{
string myCmd = updata.getCommand();
try
{
cmd = new OdbcCommand(myCmd, GetConn());
//cmd = new IBM.Data.DB2.DB2Command(myCmd, GetConn());
cmd.ExecuteNonQuery();
}
catch
{
try
{
lock (typeof(OdbcConnection))
{
GetConn().Close();
GetConn().Open();
cmd = new OdbcCommand(myCmd, GetConn());
//cmd = new IBM.Data.DB2.DB2Command(myCmd, GetConn());
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
/// <summary>
/// ��Ʈw�d�M��k
/// </summary>
/// <param name="type"></param>
/// <param name="selectcmd"></param>
/// <returns></returns>
public object select(DataType type, ICommand selectcmd)
{
System.Collections.Generic.List<object> list = new System.Collections.Generic.List<object>();
string selectCmd = selectcmd.getCommand();
OdbcDataReader dr;
//System.Data.Odbc.OdbcDataReader dr;
try
{
//cmd = new IBM.Data.DB2.DB2Command(selectCmd, GetConn());
cmd = new OdbcCommand(selectCmd, GetConn());
dr = cmd.ExecuteReader();
}
catch
{
try
{
lock (typeof(OdbcConnection))
{
GetConn().Close();
GetConn().Open();
cmd = new OdbcCommand(selectCmd, GetConn());
//cmd = new IBM.Data.DB2.DB2Command(selectCmd, GetConn());
dr = cmd.ExecuteReader();
}
}
catch (Exception ex)
{
throw ex;
}
}
//bool Found = false;
//try
//{
while (dr.Read())
{
//Found = true;
if (GetReaderData != null)
{
list.Add(GetReaderData(type, dr));
}
}
//}
//catch (Exception ex)
//{
// throw new Exception(ex.Message + "\r\n" + selectCmd);
//}
//if (!Found)
// throw new Exception("Not Found " + selectCmd);
return list;
}
/// <summary>
/// ��Ʈw�d�M��k
/// </summary>
/// <param name="selectcmd"></param>
/// <returns></returns>
public System.Data.DataTable select(ICommand selectcmd)
{
string selectCmd = selectcmd.getCommand();
try
{
cmd = new OdbcCommand(selectCmd, GetConn());
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
//cmd = new IBM.Data.DB2.DB2Command(selectCmd, GetConn());
//IBM.Data.DB2.DB2DataAdapter da = new IBM.Data.DB2.DB2DataAdapter(cmd);
System.Data.DataTable DT = new System.Data.DataTable();
da.Fill(DT);
da.Dispose();
return DT;
}
catch
{
try
{
lock (typeof(OdbcConnection))
{
GetConn().Close();
GetConn().Open();
cmd = new OdbcCommand(selectCmd, GetConn());
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
//cmd = new IBM.Data.DB2.DB2Command(selectCmd, GetConn());
//IBM.Data.DB2.DB2DataAdapter da = new IBM.Data.DB2.DB2DataAdapter(cmd);
System.Data.DataTable DT = new System.Data.DataTable();
da.Fill(DT);
da.Dispose();
return DT;
}
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// ��Ʈw�d�M��k
/// </summary>
/// <param name="selectcmd"></param>
/// <returns></returns>
public System.Data.DataTable select(ICommand selectcmd)
{
string selectCmd = selectcmd.getCommand();
try
{
cmd = new OdbcCommand(selectCmd, conn);
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
System.Data.DataTable DT = new System.Data.DataTable();
da.Fill(DT);
da.Dispose();
return DT;
}
catch
{
try
{
conn.Close();
conn.Open();
cmd = new OdbcCommand(selectCmd, conn);
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
System.Data.DataTable DT = new System.Data.DataTable();
da.Fill(DT);
da.Dispose();
return DT;
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// ��Ʈw�d�M��k
/// </summary>
/// <param name="type"></param>
/// <param name="selectcmd"></param>
/// <returns></returns>
public object select(DataType type, ICommand selectcmd)
{
System.Collections.Generic.List<object> list = new System.Collections.Generic.List<object>();
string selectCmd = selectcmd.getCommand();
OdbcDataReader dr;
try
{
cmd = new OdbcCommand(selectCmd, conn);
dr = cmd.ExecuteReader();
}
catch
{
try
{
conn.Close();
conn.Open();
cmd = new OdbcCommand(selectCmd, conn);
dr = cmd.ExecuteReader();
}
catch (Exception ex)
{
throw ex;
}
}
bool Found = false;
while (dr.Read())
{
Found = true;
if (GetReaderData != null)
{
list.Add(GetReaderData(type, dr));
}
}
if (!Found)
throw new Exception("Not Found " + selectCmd);
return list;
}
