MyOAExx/OA.DAL/DBHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:20:34
//============================================================



using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


namespace OA.DAL
{
    public static class DBHelper
    {
        private static SqlConnection GetConnection()
        {

            //string connectionString = @"server=.\sql08;uid=sa;pwd=accp;database=myoffice";
            string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=MyOffice;Integrated Security=True";
            //string connectionString = @"Data Source=(local);Initial Catalog=MyOffice;Integrated Security=True";
            //connectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            return connection;
        }

        public static int ExecNonQuery(string sql, params SqlParameter[] values)
        {
            using (SqlConnection scon = GetConnection())
            {
                SqlCommand cmd = new SqlCommand(sql, scon);
                cmd.Parameters.AddRange(values);
                return cmd.ExecuteNonQuery();
            }
        }
        public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
        {
            SqlConnection scon = GetConnection();
            SqlCommand cmd = new SqlCommand(sql, scon);
            cmd.Parameters.AddRange(values);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return reader;
        }
        public static object getScalar(string safeSql, params SqlParameter[] values)
        {
            using (SqlConnection scon = GetConnection())
            {
                SqlCommand cmd = new SqlCommand(safeSql, scon);
                cmd.Parameters.AddRange(values);
                return cmd.ExecuteScalar();
            }
        }