dbmanagerlogininfo.cs

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

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


namespace qminoa.DA
{
	public class DbManagerLogininfo
	{
		string STRCON =ConfigurationSettings.AppSettings["ConnectionString"];
		SqlCommand mycm;
		DataSet myds;
		SqlDataAdapter myda;

		public DbManagerLogininfo()
		{
			mycm=new SqlCommand ();
			mycm.Connection =new SqlConnection (STRCON);
			mycm.CommandType =CommandType.StoredProcedure ;
			mycm.Connection .Open ();
			myds=new DataSet ();
			myda =new SqlDataAdapter ();
			myda.SelectCommand =mycm;
		}

		public DataTable Getalllogininfo()
		{
			mycm.CommandText ="GetLogInfo";
			myda.Fill (myds,"GetLogInfo");
			return myds.Tables ["GetLogInfo"];
		}

		public void insertLoginUser(string []Newlogin)
		{
			mycm.CommandText ="insert_LogInfo";
			mycm.Parameters .Add (new SqlParameter ("@UserID_1",SqlDbType.VarChar ,50));
			mycm.Parameters .Add (new SqlParameter ("@Logintime_2",SqlDbType.VarChar ,50));
			mycm.Parameters .Add (new SqlParameter ("@Valid_3",SqlDbType.VarChar ,50));
			mycm.Parameters .Add (new SqlParameter ("@Logofftime_4",SqlDbType.VarChar ,50));
			mycm.Parameters .Add (new SqlParameter ("@IP_5",SqlDbType.VarChar ,50));
			mycm.Parameters .Add (new SqlParameter ("@Reason_6",SqlDbType.VarChar ,50));
			
			for(int i=0;i<Newlogin.Length;i++)
			{
				mycm.Parameters [i].Value =Newlogin[i];
			}
			int j=mycm.ExecuteNonQuery ();

		}

		public void dellogininfo(string LoginID)
		{
			mycm.CommandText ="delete_LogInfo";
			mycm.Parameters .Add (new SqlParameter ("@LoginID_1",SqlDbType.VarChar ,50));
			mycm.Parameters [0].Value =LoginID;
			int j=mycm.ExecuteNonQuery ();
		}
	}
}