tabs.cs

专业的办公oa代码下载 c#语言编写 三层结构

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace qminoa.DA
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	public class Tabs
	{
		private SqlDataAdapter Command;
		public Tabs()
		{
			String strCon=ConfigurationSettings.AppSettings["ConnectionString"];
			Command = new SqlDataAdapter();
			Command.SelectCommand = new SqlCommand();
			Command.SelectCommand.Connection = new SqlConnection(strCon);
		}
		public DataTable GetTab(string tabid)
		{
			DataSet ds_Tabs = new DataSet();
			
			SqlCommand gettab = Command.SelectCommand;
			gettab.CommandText ="GetsysTab";
			gettab.CommandType = CommandType.StoredProcedure;

			SqlParameter para_tabid = new SqlParameter("@tabid",SqlDbType.VarChar,20);
			para_tabid.Value = tabid;
			gettab.Parameters.Add(para_tabid);

			Command.Fill(ds_Tabs,"thisTab");

			return ds_Tabs.Tables["thisTab"];
		}
	}
}