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;            }        }    }}