排球现场工作人员

  1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Configuration;
  5 using System.Data.OleDb;
  6 using System.Data;
  7 using MODEL;
  8 using System.Text;
  9 
 10 namespace COMMON
 11 {
 12     public static class AccessHelpera
 13     {
 14         private static readonly String constr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
 15 
 16         //执行增删改
 17         public static int ExecuteNonQuery(string sql, params OleDbParameter[] pms)
 18         {
 19             using (OleDbConnection con = new OleDbConnection(constr))
 20             {
 21                 using (OleDbCommand cmd = new OleDbCommand(sql, con))
 22                 {
 23 
 24                     if (pms != null)
 25                     {
 26                         cmd.Parameters.AddRange(pms);
 27 
 28                     }
 29                     con.Open();
 30                     return cmd.ExecuteNonQuery();
 31                 }
 32             }
 33         }
 34         //执行返回单个值得
 35         public static object ExecuteScalar(string sql, params OleDbParameter[] pms)
 36         {
 37             using (OleDbConnection con = new OleDbConnection(constr))
 38             {
 39                 using (OleDbCommand cmd = new OleDbCommand(sql, con))
 40                 {
 41                     if (pms != null)
 42                     {
 43                         cmd.Parameters.AddRange(pms);
 44                     }
 45                     con.Open();
 46                     return cmd.ExecuteScalar();
 47                 }
 48             }
 49         }
 50         //执行返回sqldatareader
 51         public static OleDbDataReader ExecuteReader(string sql, params OleDbParameter[] pms)
 52         {
 53             OleDbConnection con = new OleDbConnection(constr);
 54 
 55             using (OleDbCommand cmd = new OleDbCommand(sql, con))
 56             {
 57                 if (pms != null)
 58                 {
 59                     cmd.Parameters.AddRange(pms);
 60                 }
 61                 try
 62                 {
 63                     con.Open();
 64                     return cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
 65                 }
 66                 catch (Exception)
 67                 {
 68                     con.Close();
 69                     con.Dispose();
 70                     throw;
 71                 }
 72 
 73             }
 74 
 75         }
 76         //执行返回datatable
 77         public static DataTable ExecuteDataTable(string sql, params OleDbParameter[] pms)
 78         {
 79             DataTable dt = new DataTable();
 80             using (OleDbDataAdapter adapter = new OleDbDataAdapter(sql, constr))
 81             {
 82                 if (pms != null)
 83                 {
 84                     adapter.SelectCommand.Parameters.AddRange(pms);
 85 
 86                 }
 87                 adapter.Fill(dt);
 88                 return dt;
 89             }
 90 
 91         }
 92         //执行删除ren表中数据  
 93         public static int ClearBiaoRen()
 94         {
 95             using (OleDbConnection conn = new OleDbConnection(constr))
 96             {
 97                 int a = 0;
 98                 using (OleDbCommand comm = new OleDbCommand("delete from renA", conn))
 99                 {
100                      OleDbCommand com = new OleDbCommand("delete from renB", conn);
101                         conn.Open();
102                     a = comm.ExecuteNonQuery() + com.ExecuteNonQuery();
103                     ClearBiaoFen();
104                     return a;
105                 }
106                 
107             }
108         }
109         //删除的fen表中数据
110         public static int ClearBiaoFen()
111         {
112             using (OleDbConnection conn = new OleDbConnection(constr))
113             {
114                 int a = 0;
115                 using (OleDbCommand comm = new OleDbCommand("delete from fenA", conn))
116                 {
117                     OleDbCommand com = new OleDbCommand("delete from fenB", conn);
118                     conn.Open();
119                     a = comm.ExecuteNonQuery() + com.ExecuteNonQuery();
120                     return a;
121                 }
122 
123             }
124         }
125         
126     }
127 }