using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;


namespace LZJ_Common
{
    public class SqlHelper
    {
        private static readonly string ConStr = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;

        /// <summary>
        /// 增删改方法
        /// </summary>
        /// <param name="sqlstr"></param>
        /// <param name="psm"></param>
        public int ExeCuteNonQuery(string sqlstr, params SqlParameter[] psm)
        {
            using (SqlConnection mycon = new SqlConnection(ConStr))
            {
                using (SqlCommand mycom = new SqlCommand(sqlstr, mycon))
                {
                    if (psm != null)
                    {
                        mycom.Parameters.AddRange(psm);
                    }
                    mycon.Open();
                    return mycom.ExecuteNonQuery();
                }
            }
        }

        public object ExeCuteSclar(string sqlstr, params SqlParameter[] psm)
        {
            using (SqlConnection mycon = new SqlConnection(ConStr))
            {
                using (SqlCommand mycom = new SqlCommand(sqlstr, mycon))
                {
                    if (psm != null)
                    {
                        mycom.Parameters.AddRange(psm);
                    }
                    mycon.Open();
                    return mycom.ExecuteScalar();
                }
            }
        }

        public SqlDataReader ExeCuteReader(string sqlstr, params SqlParameter[] psm)
        {
            SqlConnection mycon = new SqlConnection(ConStr);
            using (SqlCommand mycom = new SqlCommand(sqlstr, mycon))
            {
                if (psm != null)
                {
                    mycom.Parameters.AddRange(psm);
                }

                try
                {
                    mycon.Open();
                    return mycom.ExecuteReader(CommandBehavior.CloseConnection);
                }
                catch (Exception ex)
                {
                    mycon.Dispose();
                    throw ex;
                }
            }
        }

        public DataTable ExeCuteDataTable(string sqlstr, params SqlParameter[] psm)
        {
            DataTable dt = new DataTable();
            using (SqlDataAdapter myda = new SqlDataAdapter(sqlstr, ConStr))
            {
                if (psm != null)
                {
                    myda.SelectCommand.Parameters.AddRange(psm);
                }
                myda.Fill(dt);
                return dt;
            }
        }



    }
}