/// <summary>
/// Zyb_Sql_Helper 的摘要说明
/// </summary>
public class Zyb_Sql_Helper
{
public Zyb_Sql_Helper()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static string ExecuteQuery2String(string sql)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
try { str = com.ExecuteScalar().ToString(); }
catch { }
}
}
return str;
}
public static string ExecuteQuery2String(string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
try { str = com.ExecuteScalar().ToString(); }
catch { }
}
}
return str;
}
public static string ExecuteQuery2String(string connection_name, string sql)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
try { str = com.ExecuteScalar().ToString(); }
catch { }
}
}
return str;
}
public static string ExecuteQuery2String(string connection_name, string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
try { str = com.ExecuteScalar().ToString(); }
catch { }
}
}
return str;
}
public static string[] ExecuteQuery2Strings(string sql)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
while (dr.Read() == true)
{
str += "," + dr[0].ToString();
}
}
}
string[] result = str.Split(',');
return result;
}
public static string[] ExecuteQuery2Strings(string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
while (dr.Read() == true)
{
str += "," + dr[0].ToString();
}
}
}
string[] result = str.Split(',');
return result;
}
public static string[] ExecuteQuery2Strings(string connection_name, string sql)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
while (dr.Read() == true)
{
str += "," + dr[0].ToString();
}
}
}
string[] result = str.Split(',');
return result;
}
public static string[] ExecuteQuery2Strings(string connection_name, string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
string str = "";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
while (dr.Read() == true)
{
str += "," + dr[0].ToString();
}
}
}
string[] result = str.Split(',');
return result;
}
public static int ExecuteQuery(string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
int i = 0;
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
i = com.ExecuteNonQuery();
}
}
return i;
}
public static int ExecuteQuery(string sql)
{
int i = 0;
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local"].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
i = com.ExecuteNonQuery();
}
}
return i;
}
public static int ExecuteQuery(string connection_name, string sql)
{
int i = 0;
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
i = com.ExecuteNonQuery();
}
}
return i;
}
public static int ExecuteQuery(string connection_name, string sql, System.Data.SqlClient.SqlParameter[] sqlparams)
{
int i = 0;
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[connection_name].ToString()))
{
using (System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, con))
{
foreach (System.Data.SqlClient.SqlParameter para in sqlparams)
{
com.Parameters.Add(para);
}
con.Open();
i = com.ExecuteNonQuery();
}
}
return i;
}
}
/*
Use Example:
protected void Button1_Click(object sender, EventArgs e)
{
//使用默认连接名称
//string [] users= Zyb_Sql_Helper.ExecuteQuery2Strings("select user_name from csp_user");
//使用指定的连接名称
//string[] users = Zyb_Sql_Helper.ExecuteQuery2Strings("local","select user_name from csp_user");
//带参数
System.Data.SqlClient.SqlParameter[] param = {
new System.Data.SqlClient.SqlParameter("@enable", 1),
new System.Data.SqlClient.SqlParameter("@create_by", 29)
};
string[] users = Zyb_Sql_Helper.ExecuteQuery2Strings("local", "select user_name from csp_user where enable=@enable and create_by=@create_by", param);
foreach (string user in users) {
TextBox1.Text += user+"\r\n";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
//使用默认连接名称
//TextBox1.Text= Zyb_Sql_Helper.ExecuteQuery2String("select user_name from csp_user where id=29");
//使用指定的连接名称
//TextBox1.Text = Zyb_Sql_Helper.ExecuteQuery2String("local","select user_name from csp_user where id=29");
//带参数
System.Data.SqlClient.SqlParameter[] param = {
new System.Data.SqlClient.SqlParameter("@id", 30),
};
TextBox1.Text = Zyb_Sql_Helper.ExecuteQuery2String("local", "select user_name from csp_user where id=@id",param);
}
*/