Backup/comment/cdata.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.Data.SqlTypes;
using System.Data.SqlClient;

namespace GZGL.comment
{
	/// <summary>
	/// cdata 的摘要说明。
	/// </summary>
	public class cdata
	{
		private SqlConnection Conn;
		public cdata()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			this.Conn = new SqlConnection();
			Conn.ConnectionString= ConfigurationSettings.AppSettings["sqlConn"];
			//vs 2005 用ConfigurationManager.ConnectionStrings["sqlConn"].ConnectionString;IDbConnection DbConnection = null;
		}
		
		#region 取值
		/// <summary>
		///sslist，conQuery 取得SqlDataReader，操纵数据库（不返回值）
		/// </summary>
		/// <returns>Reader，count:特定区域文描述</returns>
		public SqlDataReader sslist(string sqlq,string bm,string id,int id1)
		{
			string sSQL = "SELECT " + sqlq + " FROM " + bm + " a WHERE " + id + "=@id";// + sWhere

			SqlCommand command = new SqlCommand(sSQL, Conn);
			command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int));
			command.Parameters["@id"].Value =id1;
			if (Conn.State == ConnectionState.Closed) { Conn.Open(); }
			SqlDataReader reader=command.ExecuteReader();
			
			return reader;
		}
		/// <summary>
		///sslist 取得SqlDataReader（返回值）
		/// </summary>
		/// <returns>Reader，count:特定区域文描述</returns>
		public SqlDataReader sslist(string sqlq)
		{
			SqlCommand command = new SqlCommand(sqlq, Conn);
			
			if (Conn.State == ConnectionState.Closed) { Conn.Open(); }
	
			SqlDataReader reader=command.ExecuteReader();
	
			return reader;
		}
		/// <summary>