Asp封装类的常用函数

 

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

namespace Call_Center
{
    class Method_1
    {
        public static readonly string cnnstring = ConfigurationManager.ConnectionStrings["cnnstring"].ConnectionString;

              /// <summary>
        /// 返回查寻内容
        /// </summary>
        /// <param name="sqlcmd"></param>
        /// <param name="commandtype"></param>
        /// <param name="para"></param>
        /// <returns></returns>
        public static DataTable Return_DataTable(string sqlcmd, CommandType commandtype, params SqlParameter[] para)
        {
            using (SqlConnection con = new SqlConnection(cnnstring))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcmd,con))
                {
                    using (SqlDataAdapter sda =  new SqlDataAdapter(cmd))
                    {
                        cmd.Parameters.AddRange(para);
                        DataTable dt = new DataTable();
                        sda.Fill(dt);
                        return dt;
                    }
                   

                }
            }
       
        }
        /// <summary>
        /// 执行数据删除修改插入操作
        /// </summary>
        /// <param name="sqlcdm"></param>
        /// <param name="commandtype"></param>
        /// <param name="para"></param>

        public static void ExecuteQuery(string sqlcdm,CommandType commandtype,params SqlParameter[] para)
        {
            using (SqlConnection con = new SqlConnection(cnnstring))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcdm,con))
                {
                    cmd.Parameters.AddRange(para);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
            }
       
       
        }

        public static void ExecuteQuery1(string sqlcdm, CommandType commandtype, params SqlParameter[] para)
        {
            using (SqlConnection con = new SqlConnection(cnnstring1))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcdm, con))
                {
                    cmd.Parameters.AddRange(para);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
            }

        }
    }

}