DbManagerLogininfo.cs
上传用户:autodoor
上传日期:2022-08-04
资源大小:9973k
文件大小:2k
- 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 ();
- }
- }
- }