程序博客网 > js实现div旋转

sqllink.cs c#数据库操作类

来源：互联网 发布：js实现div旋转 编辑：程序博客网 时间：2024/05/17 08:28

sqllink.cs c#数据库操作类

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace Chenzhang
{

 /// <summary>
 /// SQL Server数据库操作组件
 /// </summary>
 public class SqlLink :IDisposable
 {
  private SqlDataAdapter dsCommand;
  private AppSettingsReader appsettingsreader;
  private String cn;

  /// <summary>
  /// Constructor
  /// </summary>
  public SqlLink()
  {
   dsCommand =new SqlDataAdapter() ;
   appsettingsreader = new AppSettingsReader();
   cn=(string)appsettingsreader.GetValue("SQLConnectionString", typeof(string));
  }

  /// <summary>
  /// Dispose
  /// </summary>
  public void Dispose()
  {
   Dispose(true);
   GC.SuppressFinalize(this);
  }

  protected virtual void Dispose(bool disposing)
  {
   if (!disposing)
    return;

   if (dsCommand != null)
   {
    //dispose dsCommand.SelectCommand
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }

    //dispose dsCommand.InsertCommand
    if (dsCommand.InsertCommand!=null)
    {
     if (dsCommand.InsertCommand.Connection!=null)
      dsCommand.InsertCommand.Connection.Dispose();
     dsCommand.InsertCommand.Dispose();
    }

    //dispose dsCommand.UpdateCommand
    if (dsCommand.UpdateCommand!=null)
    {
     if (dsCommand.UpdateCommand.Connection!=null)
      dsCommand.UpdateCommand.Connection.Dispose();
     dsCommand.UpdateCommand.Dispose();
    }

    dsCommand.Dispose();
    dsCommand=null;
   }

    
  }
  /// <summary>
  /// 获取select语句查询结果记录集
  /// </summary>
  /// <param name="sql">select语句</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql(String sql)
  {
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sql;
   dsCommand.SelectCommand.CommandType=CommandType.Text;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }
  /// <summary>
  /// 获取存储过程运行结果记录集，存储过程不带参数
  /// </summary>
  /// <param name="sp_name">存储过程名称</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql_sp(String sp_name)
  {
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sp_name;
   dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }
  /// <summary>
  /// 获取存储过程运行结果记录集，存储过程带1个参数
  /// </summary>
  /// <param name="sp_name">存储过程名称</param>
  /// <param name="par1_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par1_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par1_value">存储过程参数值，如"18","张三"</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql_sp_par1(String sp_name,String par1_name,String par1_type,String par1_value)
  {
   int par1_dbtype=0;
   if (par1_type.ToLower()=="varchar") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="string") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="integer") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par1_type.ToLower()=="int") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sp_name;
   dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;
   SqlParameter objPar;
   objPar=dsCommand.SelectCommand.Parameters.Add(par1_name,par1_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par1_value;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }
  /// <summary>
  /// 获取存储过程运行结果记录集，存储过程带2个参数
  /// </summary>
  /// <param name="sp_name">存储过程名称</param>
  /// <param name="par1_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par1_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par1_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par2_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par2_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par2_value">存储过程参数值，如"18","张三"</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql_sp_par2(String sp_name,String par1_name,String par1_type,String par1_value,String par2_name,String par2_type,String par2_value)
  {
   int par1_dbtype=0;
   int par2_dbtype=0;
   if (par1_type.ToLower()=="varchar") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="string") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="integer") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par1_type.ToLower()=="int") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par2_type.ToLower()=="varchar") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="string") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="integer") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par2_type.ToLower()=="int") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sp_name;
   dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;
   SqlParameter objPar;
   objPar=dsCommand.SelectCommand.Parameters.Add(par1_name,par1_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par1_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par2_name,par2_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par2_value;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }
  /// <summary>
  /// 获取存储过程运行结果记录集，存储过程带3个参数
  /// </summary>
  /// <param name="sp_name">存储过程名称</param>
  /// <param name="par1_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par1_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par1_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par2_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par2_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par2_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par3_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par3_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par3_value">存储过程参数值，如"18","张三"</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql_sp_par3(String sp_name,String par1_name,String par1_type,String par1_value,String par2_name,String par2_type,String par2_value,String par3_name,String par3_type,String par3_value)
  {
   int par1_dbtype=0;
   int par2_dbtype=0;
   int par3_dbtype=0;
   if (par1_type.ToLower()=="varchar") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="string") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="integer") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par1_type.ToLower()=="int") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par2_type.ToLower()=="varchar") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="string") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="integer") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par2_type.ToLower()=="int") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par3_type.ToLower()=="varchar") par3_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par3_type.ToLower()=="string") par3_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par3_type.ToLower()=="integer") par3_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par3_type.ToLower()=="int") par3_dbtype=Convert.ToInt16(SqlDbType.Int);
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sp_name;
   dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;
   SqlParameter objPar;
   objPar=dsCommand.SelectCommand.Parameters.Add(par1_name,par1_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par1_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par2_name,par2_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par2_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par3_name,par3_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par3_value;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }
  /// <summary>
  /// 获取存储过程运行结果记录集，存储过程带4个参数
  /// </summary>
  /// <param name="sp_name">存储过程名称</param>
  /// <param name="par1_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par1_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par1_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par2_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par2_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par2_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par3_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par3_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par3_value">存储过程参数值，如"18","张三"</param>
  /// <param name="par4_name">存储过程参数名称，如"@Age","@StudentName"</param>
  /// <param name="par4_type">存储过程参数类型，如"int","varchar"</param>
  /// <param name="par4_value">存储过程参数值，如"18","张三"</param>
  /// <returns>结果记录集</returns>
  public DataTable SelectSql_sp_par4(String sp_name,String par1_name,String par1_type,String par1_value,String par2_name,String par2_type,String par2_value,String par3_name,String par3_type,String par3_value,String par4_name,String par4_type,String par4_value)
  {
   int par1_dbtype=0;
   int par2_dbtype=0;
   int par3_dbtype=0;
   int par4_dbtype=0;
   if (par1_type.ToLower()=="varchar") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="string") par1_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par1_type.ToLower()=="integer") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par1_type.ToLower()=="int") par1_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par2_type.ToLower()=="varchar") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="string") par2_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par2_type.ToLower()=="integer") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par2_type.ToLower()=="int") par2_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par3_type.ToLower()=="varchar") par3_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par3_type.ToLower()=="string") par3_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par3_type.ToLower()=="integer") par3_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par3_type.ToLower()=="int") par3_dbtype=Convert.ToInt16(SqlDbType.Int);
   if (par4_type.ToLower()=="varchar") par4_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par4_type.ToLower()=="string") par4_dbtype=Convert.ToInt16(SqlDbType.VarChar);
   else if (par4_type.ToLower()=="integer") par4_dbtype=Convert.ToInt16(SqlDbType.Int);
   else if (par4_type.ToLower()=="int") par4_dbtype=Convert.ToInt16(SqlDbType.Int);
   dsCommand.SelectCommand=new SqlCommand();
   dsCommand.SelectCommand.Connection=new SqlConnection(cn);
   DataSet ds=new DataSet() ;
   dsCommand.SelectCommand.CommandText=sp_name;
   dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;
   SqlParameter objPar;
   objPar=dsCommand.SelectCommand.Parameters.Add(par1_name,par1_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par1_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par2_name,par2_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par2_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par3_name,par3_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par3_value;
   objPar=dsCommand.SelectCommand.Parameters.Add(par4_name,par4_dbtype);
   objPar.Direction=ParameterDirection.Input;
   objPar.Value=par4_value;
   dsCommand.SelectCommand.Connection.Open();
   try
   {
    dsCommand.Fill(ds,"result");
    return ds.Tables["result"];
   }
   catch
   {
    return null;
   }
   finally
   {
    if (dsCommand.SelectCommand!=null)
    {
     if (dsCommand.SelectCommand.Connection!=null)
      dsCommand.SelectCommand.Connection.Dispose();
     dsCommand.SelectCommand.Dispose();
    }
    dsCommand.Dispose();
    ds.Dispose();
   }
  }  /// <summary>
  /// 运行insert语句，并返回成功与否
  /// </summary>
  /// <param name="sql">insert语句</param>
  /// <returns>成功与否</returns>
  public bool InsertSql(String sql)
  {
   dsCommand.InsertCommand=new SqlCommand();
   dsCommand.InsertCommand.Connection=new SqlConnection(cn);
   dsCommand.InsertCommand.CommandText=sql;
   dsCommand.InsertCommand.CommandType=CommandType.Text;
   dsCommand.InsertCommand.Connection.Open();
   try
   {
    dsCommand.InsertCommand.ExecuteNonQuery();
    return true;
   }
   catch
   {
    return false;
   }
   finally
   {
    if(dsCommand.InsertCommand!=null)
    {
     if (dsCommand.InsertCommand.Connection!=null)
      dsCommand.InsertCommand.Connection.Dispose();
     dsCommand.InsertCommand.Dispose();
    }
    dsCommand.Dispose();
   }
  }
  /// <summary>
  /// 运行update语句，并返回成功与否
  /// </summary>
  /// <param name="sql">update语句</param>
  /// <returns>成功与否</returns>
  public bool UpdateSql(String sql)
  {
   dsCommand.UpdateCommand=new SqlCommand();
   dsCommand.UpdateCommand.Connection=new SqlConnection(cn);
   dsCommand.UpdateCommand.CommandText=sql;
   dsCommand.UpdateCommand.CommandType=CommandType.Text;
   dsCommand.UpdateCommand.Connection.Open();
   try
   {
    dsCommand.UpdateCommand.ExecuteNonQuery();
    return true;
   }
   catch
   {
    return false;
   }
   finally
   {
    if (dsCommand.UpdateCommand!=null)
    {
     if (dsCommand.UpdateCommand.Connection!=null)
      dsCommand.UpdateCommand.Connection.Dispose();
     dsCommand.UpdateCommand.Dispose();
    }
    dsCommand.Dispose();
   }
  }
  /// <summary>
  /// 运行delete语句，并返回成功与否
  /// </summary>
  /// <param name="sql">delete语句</param>
  /// <returns>成功与否</returns>
  public bool DeleteSql(String sql)
  {
   dsCommand.DeleteCommand=new SqlCommand();
   dsCommand.DeleteCommand.Connection=new SqlConnection(cn);
   dsCommand.DeleteCommand.CommandText=sql;
   dsCommand.DeleteCommand.CommandType=CommandType.Text;
   dsCommand.DeleteCommand.Connection.Open();
   try
   {
    dsCommand.DeleteCommand.ExecuteNonQuery();
    return true;
   }
   catch
   {
    return false;
   }
   finally
   {
    if (dsCommand.DeleteCommand!=null)
    {
     if (dsCommand.DeleteCommand.Connection!=null)
      dsCommand.DeleteCommand.Connection.Dispose();
     dsCommand.DeleteCommand.Dispose();
    }
    dsCommand.Dispose();
   }
  }

 }
}

 

js实现div旋转 js实现div旋转
原创粉丝点击
热门IT博客
淘宝宝贝七天下架吗淘宝宝贝七天下架吗
区块链技术 知乎区块链技术 知乎
mac里面的照片怎么导出
蚁群优化算法的特点
linux 中文输入
电路板绘制软件
js获取file真实路径
药家鑫事件知乎
2017美国胃癌数据统计
一个软件网络连接异常
社交网络的利弊辩论
招商银行软件下载
java读取csv文件乱码
淘宝网招聘平台
大数据方向什么专业
淘宝一天访客多少正常
审判者极速踢腿宏编程
杀毒软件哪个好 知乎
蜀道难 知乎
php获取本机ip
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 cf显示网络异常怎么办 cf游戏数据异常怎么办 oppo图标消失了怎么办 服务器ip被攻击怎么办 cdn服务器连接异常怎么办 cf36-1网络异常怎么办 天气信息过满怎么办 cf语音连接失败怎么办 cf对讲机没了怎么办 醉酒过后胃难受怎么办 酒后呕吐胃难受怎么办 喝酒第二天难受怎么办 晚上醉酒后难受怎么办 醉酒后难受呕吐怎么办 太情绪化的人怎么办 容易情绪化怎么办 知乎 身上长潮湿疙瘩怎么办 一楼墙面潮湿怎么办 结痂里面有脓怎么办 狗狗外伤用错药怎么办 狗身上长跳蚤怎么办 手机网站被劫持怎么办 主页被毒霸篡改怎么办 网站被恶意篡改怎么办 电脑ip地址错误怎么办 旅游购物被骗了怎么办 没有3c认证怎么办 没3c认证怎么办 淘宝买家要发票怎么办 淘宝客户要发票怎么办 工程抢修车怎么办手续 马桶排水阀漏水怎么办 真人cs不会玩怎么办 pp助手安装失败怎么办 ipad屏幕一直闪怎么办 ipad丢失被抹掉怎么办 苹果ipad丢失了怎么办 苹果ipad丢了怎么办 空间相册没有了怎么办 51帐号被注销怎么办 邮箱密码忘记了怎么办

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里