using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
private static DataBase _instance;
public DataBase()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
//
// TODO: 在此处添加构造函数逻辑
//
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 获得一个DataBase实例
/// </summary>
/// <returns></returns>
public static DataBase getInstance()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (_instance == null)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
_instance = new DataBase();
}
return _instance;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回SqlConnection对象实例
/// </summary>
/// <returns></returns>
public static SqlConnection ReturnCon()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string connstr=ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection con = new SqlConnection(connstr);
if (con.State.Equals(ConnectionState.Closed))
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
con.Open();
}
return con;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回SqlCommand对象实例
/// </summary>
/// <param name="procName"></param>
/// <returns></returns>
public static SqlCommand CreateCmd(string procName)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlConnection con = ReturnCon();
SqlCommand cmd = new SqlCommand(procName,con);
cmd.CommandType = CommandType.StoredProcedure;
return cmd;
}
public static SqlCommand CreateCmd(string procName, SqlParameter[] prams)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlConnection con = ReturnCon();
SqlCommand cmd = new SqlCommand(procName,con);
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter parameter in prams)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
cmd.Parameters.Add(parameter);
}
return cmd;
}
public static SqlCommand CreateCmd(string procName, SqlConnection con)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlConnection sqlcon = con;
if (sqlcon.State.Equals(ConnectionState.Closed))
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
sqlcon.Open();
}
SqlCommand cmd = new SqlCommand(procName,sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
return cmd;
}
public static SqlCommand CreateCmd(string procName, SqlParameter[] prams, SqlConnection con)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlConnection sqlcon = con;
if (sqlcon.State.Equals(ConnectionState.Closed))
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
sqlcon.Open();
}
SqlCommand cmd = new SqlCommand(procName,sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter parameter in prams)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
cmd.Parameters.Add(parameter);
}
return cmd;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回SqlDataReader对象实例
/// </summary>
/// <param name="procName"></param>
/// <returns></returns>
public static SqlDataReader RunProcGetReader(string procName)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return sdr;
}
public static SqlDataReader RunProGetReader(string procName, SqlParameter[] prams)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName, prams);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return sdr;
}
public static SqlDataReader RunProGetReader(string procName, SqlConnection con)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName, con);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return sdr;
}
public static SqlDataReader RunProGetReader(string procName, SqlParameter[] prams, SqlConnection con)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName, prams, con);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return sdr;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回DataTable对象实例
/// </summary>
/// <param name="procName"></param>
/// <param name="prams"></param>
/// <param name="con"></param>
/// <returns></returns>
public static DataTable RunProTable(string procName, SqlParameter[] prams, SqlConnection con)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName, prams, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt=ds.Tables[0];
con.Close();
return dt;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回执行结果受影响的行数
/// </summary>
/// <param name="procName"></param>
/// <returns></returns>
public static int RunProExecute(string procName)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName);
int intResult = cmd.ExecuteNonQuery();
return intResult;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 返回首行首列
/// </summary>
/// <param name="procName"></param>
/// <returns></returns>
public static int RunProScalar(string procName)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName);
int intResult = Convert.ToInt32(cmd.ExecuteScalar());
return intResult;
}
public static int RunProScalar(string procName, SqlParameter[] prams)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlCommand cmd = CreateCmd(procName, prams);
int intResult = Convert.ToInt32(cmd.ExecuteScalar());
return intResult;
}
}
![](/Images/OutliningIndicators/None.gif)
posted on
2008-01-11 06:34
wangbin
阅读(
292)
评论()
编辑
收藏
举报