DAL/SqlUtil.cs

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

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

// ******************************************************************
// 文件名: SqlUtil.cs
// 主要内容： 常用Sql操作类。
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using Logistics.IDal;
using System.Reflection;
using System.Data;

namespace Logistics.DAL
{
    /// <summary>
    /// 常用Sql操作类。
    /// </summary>
    public class SqlUtil
    {
        /// <summary>
        /// 得到一个SqlConnection对象
        /// </summary>
        /// <returns>SqlConnection对象</returns>
        public static SqlConnection getConnection()
        {
            string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connstring"].Trim();// "server=172.16.36.24;DATABASE=Logistics;uid=lw;PWD=lw;";//
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            return conn;
        }


        /// <summary>
        /// 
        /// </summary>
        /// <param name="procname"></param>
        /// <param name="pars"></param>
        /// <param name="connection"></param>
        /// <returns></returns>
        public static DataTable executeProc(string procname, System.Data.SqlClient.SqlParameter[] pars, SqlConnection connection, SqlTransaction transaction)
        {
            SqlCommand comm = connection.CreateCommand();
            comm.CommandText = procname;
            comm.CommandType = CommandType.StoredProcedure;
            foreach (var v in pars)
            {
                comm.Parameters.Add(v);
            }
            comm.Transaction = transaction;
            DataTable ds = new DataTable();
            SqlDataAdapter sda = new SqlDataAdapter(comm);
            sda.Fill(ds);
            return ds;
        }


        public static int executeProcInt(string procname, System.Data.SqlClient.SqlParameter[] pars, SqlConnection connection, SqlTransaction transaction)
        {