运行sql<1>

 

using System;
using System.Data.Odbc;
using System.Data;

 namespace glp_gong.bussiness
{
 /// <summary>
 /// core 的摘要说明。
 /// </summary>
 public class core
 {
  private string strConn;
  private OdbcConnection cn;

 

public core()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //

            strConn = System.Configuration.ConfigurationSettings.AppSettings["glp"];
            cn = new OdbcConnection(strConn);
        }
    

 

public DataSet createDs(string strSql)
        {
            DataSet ds = new DataSet();

            try
            {
    
                cn.Open();
                OdbcDataAdapter da = new OdbcDataAdapter();
                OdbcCommand cmd= new OdbcCommand(strSql,cn);
                da.SelectCommand = cmd;
                da.Fill(ds);
            }
            finally
            {
                cn.Close();
        
            }

            if(ds.Tables[0].Rows.Count<1)
            {
                ds = null;
            }

            return ds;

        }

 

public DataSet createDs(string strSql,string strFlag)
        {
            DataSet ds = new DataSet();

            try
            {
    
                cn.Open();
                OdbcDataAdapter da = new OdbcDataAdapter();
                OdbcCommand cmd= new OdbcCommand(strSql,cn);
                da.SelectCommand = cmd;
                da.Fill(ds);
            }
            finally
            {
                cn.Close();
        
            }

            return ds;

        }

 

public bool runSql(string strSql)
        {
            bool lbRet = true;
            try
            {
    
                cn.Open();
                OdbcCommand cmd= new OdbcCommand(strSql,cn);
                cmd.ExecuteNonQuery();
            }
            catch
            {
                lbRet = false;
            }
            finally
            {
                cn.Close();
            }
            return lbRet;
        }

 

public DataRow createRow(string strSql)
        {
            DataRow row;
            DataSet ds = new DataSet();

            try
            {
                cn.Open();

                OdbcDataAdapter da = new OdbcDataAdapter();
                OdbcCommand cmd= new OdbcCommand(strSql,cn);
                da.SelectCommand = cmd;
                da.Fill(ds);
            }
            finally
            {
                cn.Close();
            }
            

            if (ds.Tables[0].Rows.Count>0)
            {
                row = ds.Tables[0].Rows[0];
            }
            else
            {
                row = null;
            }
        
            return row;

        }