本文整理汇总了C#中ICommand.getCommand方法的典型用法代码示例。如果您正苦于以下问题:C# ICommand.getCommand方法的具体用法?C# ICommand.getCommand怎么用?C# ICommand.getCommand使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ICommand
的用法示例。
在下文中一共展示了ICommand.getCommand方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: insert
/// <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);
}
}
}
示例2: insert
/// <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);
}
}
}
示例3: update
/// <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);
}
}
}
示例4: select
/// <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;
}
示例5: select
/// <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;
}
}
}