当前文件： KuangLongCommunicationV2/App_Code/DataBase.cs[5K，2009-6-12 11:46:37]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11
 12/**//// <summary>
 13/// DataBase 的摘要说明
 14/// </summary>
 15public class DataBase
 16...{
 17   
 18   
 19    public DataBase()
 20    ...{
 21        //
 22        // TODO: 在此处添加构造函数逻辑
 23        //
 24    }
 25
 26    public DataTable DataSelect(string Sqltext)
 27    ...{
 28        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
 29        con.Open();
 30       
 31        SqlDataAdapter datap = new SqlDataAdapter(Sqltext, con);
 32        DataTable dt = new DataTable();
 33        datap.Fill(dt);
 34       
 35        return dt;
 36    
 37    
 38    
 39    }
 40    public DataSet DataAll(string sqltxt)
 41    ...{
 42
 43        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
 44        con.Open();
 45        SqlDataAdapter datap = new SqlDataAdapter(sqltxt, con);
 46        DataSet ds = new DataSet();
 47        datap.Fill(ds);
 48        return ds;
 49    
 50    
 51    }
 52    private SqlConnection CreateConnection()
 53    ...{
 54        SqlConnection conn = new SqlConnection();
 55       
 56        conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 57        return conn;
 58
 59
 60    }
 61    private SqlParameter CreateReturnValuePar()
 62    ...{ 
 63    SqlParameter par=CreateParameter("RetrunValue",SqlDbType.Int,4,null);
 64        par.Direction=ParameterDirection.ReturnValue;
 65        return par;
 66    
 67    }
 68    private SqlCommand CreateCommand(string procName, params SqlParameter[] pars)
 69    ...{
 70        SqlCommand cmd = new SqlCommand(procName, CreateConnection());
 71        cmd.CommandType = CommandType.StoredProcedure;
 72        if (pars != null)
 73        ...{
 74            foreach (SqlParameter par in pars)
 75            ...{
 76                cmd.Parameters.Add(par);
 77            
 78            }
 79        
 80        
 81        
 82        }
 83        cmd.Parameters.Add(CreateReturnValuePar());
 84        return cmd;
 85    
 86    }
 87    public int ExecuteNonQuery(string ProcName, params SqlParameter[] Pars)
 88    ...{
 89        SqlCommand cmd = CreateCommand(ProcName, Pars);
 90        cmd.Connection.Open();
 91       
 92        cmd.ExecuteNonQuery();
 93        cmd.Connection.Close();
 94        
 95        return int.Parse(cmd.Parameters["RetrunValue"].Value.ToString());
 96    
 97    
 98    
 99    }
100    public SqlDataReader ExecuteDataReader(string ProcName, params SqlParameter[] Pars)
101    ...{
102        SqlCommand cmd = CreateCommand(ProcName, Pars);
103        cmd.Connection.Open();
104        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
105    
106    
107    
108    }
109
110    public SqlParameter CreateParameter(string ParName, SqlDbType DbType, int Size, object ParValue)
111    ...{
112        SqlParameter par = new SqlParameter();
113        par.Value = ParValue;
114        par.ParameterName = ParName;
115        par.SqlDbType = DbType;
116        par.Size = Size;
117        return par;
118    
119    }
120    public static string Getfield(string sql, string field)
121    ...{
122        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
123        
124            try
125            ...{
126                con.Open();
127                SqlCommand cmd = new SqlCommand(sql, con);
128                SqlDataReader sdr = cmd.ExecuteReader();
129                sdr.Read();
130                string str = sdr[field].ToString();
131                sdr.Close();
132                return str;
133            }
134            catch
135            ...{
136                return "获取信息失败！";
137            }
138            finally
139            ...{
140                con.Close();
141            }
142        
143        
144        
145        
146    
147    
148    }
149    public static bool DataTypes(int val, string sval, string procname)
150    ...{
151        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
152        
153            SqlCommand cmd = new SqlCommand(procname, con);
154            cmd.CommandType = CommandType.StoredProcedure;
155            SqlParameter s = new SqlParameter(sval, SqlDbType.Int, 4);
156            s.Value = val;
157            cmd.Parameters.Add(s);
158            con.Open();
159            try
160            ...{
161                cmd.ExecuteNonQuery();
162                return true;
163            }
164            catch
165            ...{
166                return false;
167            
168            }
169            finally
170            ...{
171                con.Close();            
172            
173            }
174        
175        
176        }
177    public DataRow GetDataRow(String SqlString)
178    ...{
179        DataSet dataset = DataAll(SqlString);
180        dataset.CaseSensitive = false;
181        if (dataset.Tables[0].Rows.Count > 0)
182        ...{
183            return dataset.Tables[0].Rows[0];
184
185
186        }
187        else
188        ...{
189            return null;
190        
191        
192        }
193    
194    }
195    
196    
197    }
198  
199