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