当前位置: 首页>>代码示例>>C#>>正文


C# ICommand.getCommand方法代码示例

本文整理汇总了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);
                }
            }
        }
开发者ID:ufjl0683,项目名称:Center,代码行数:35,代码来源:A_OdbcConnect.cs

示例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);
         }
     }
 }
开发者ID:ufjl0683,项目名称:Center,代码行数:27,代码来源:A_OdbcConnect.cs

示例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);
                }
            }
        }
开发者ID:ufjl0683,项目名称:Center,代码行数:33,代码来源:A_OdbcConnect.cs

示例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;
        }
开发者ID:ufjl0683,项目名称:Center,代码行数:59,代码来源:A_OdbcConnect.cs

示例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;
                }
            }
        }
开发者ID:ufjl0683,项目名称:Center,代码行数:38,代码来源:A_OdbcConnect.cs


注:本文中的ICommand.getCommand方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。