user.cs

企业网站前台后台源程序,用于大中小型企业网站后台程序开发

using System;
using System.Data;
using Socut.Data;
namespace BLL
{
	/// <summary>
	/// user 的摘要说明。
	/// </summary>
	public class user
	{
		protected CData myData = new CData();
		protected DataSet ds = new DataSet();

		#region 单数据查找操作
		/// <summary>
		/// 单数据查找操作,table_name：查找数据表；set_field_name：查找数据字段；
		/// set_field_data：查找字段提供数据； get_field_name：需要返回的字段
		/// </summary>

		public string search_data(string table_name, string set_field_name, string set_field_data, string get_field_name)
		{
			string sql = "select top 1 " + get_field_name + " from " + table_name + " where  " + set_field_name + " ='" + set_field_data + "'";
			
			ds = myData.GetDataSet(sql, 0, 0, "search_data");

			return ds.Tables[0].Rows[0][0].ToString();
		}
		public string search_data(string table_name, string set_field_name, int set_field_data, string get_field_name)
		{
			string sql = "select top 1 " + get_field_name + " from " + table_name + " where  " + set_field_name + " =" + set_field_data + "";
			ds = myData.GetDataSet(sql, 0, 0, "search_data");

			return ds.Tables[0].Rows[0][0].ToString();
		}

		#endregion
	}
}