数据库封装类支物业

由于自己工作需要 经常重复写数据库的操作代码.今天我把他们写成了dll, 拿来和大家分享.希望大家提出意见.支持事务,目前还不支持所有存储过程.

using System;

using neric;

using llections;

using xt;

using ta;

using lClient;

using nfiguration;

namespace DataOperation

{

/// summary

/// MsSql操作类

/// /summary

sealed public class DataMsSql

{

private SqlConnection dataConnection = null;

#region 构造函数

/// summary

/// 无参构造函数

/// /summary

public DataMsSql()

{

dataConnection = new SqlConnection();

}

/// summary

/// 有参构造函数

/// /summary

/// param name=\"connectionString\"数据库联接串/param

public DataMsSql(string connectionString)

{

dataConnection = new SqlConnection(connectionString);

}

#endregion

#region 属性

/// summary

/// 设置或获取SqlConnection类型数据库联接dataConnection的值

/// /summary

public SqlConnection DataConnection

{

get

{

if (dataConnection == null)

dataConnection = new SqlConnection();

return dataConnection;

}

set

{

dataConnection = value;

}

}

/// summary

/// 获取数据库联接的状态

/// /summary

public ConnectionState SqlState

{

get

{

return ate;

}

}

#endregion

#region 状态操作

/// summary

/// 打开数据库联接

/// /summary

public void Open()

{

if (ate != en)

en();

}

/// summary

/// 关闭数据库联接

/// /summary

public void Close()

{

if (ate != osed)

ose();

}

#endregion

#region 一般数据语句操作

/// summary

/// 获取检索出来首行首列的值

/// /summary

/// param name=\"sqlStr\"sql查询串/param

/// returns结果/returns

public object ExecuteScalar(string sqlStr)

{

if (SqlState == osed)

en();

SqlCommand cmd = new SqlCommand(sqlStr, dataConnection);

return ecuteScalar();

}

/// summary

///检索数据以SqlDataReader形式返检索结果

/// /summary

/// param name=\"sqlStr\"sql查询串/param

/// returnsSqlDataReader数据集/returns

public SqlDataReader GetDataReadr(string sqlStr)

{

if (SqlState == osed)

en();

SqlCommand cmd = new SqlCommand(sqlStr, dataConnection);

return ecuteReader();

}

/// summary

/// 检索数据以DataTable形式返检索结果

/// /summary

/// param name=\"sqlStr\"sql查询串/param

/// returnsDataTale数据集/returns

public DataTable GetDataTable(string sqlStr)

{

DataTable dt = new DataTable();

SqlDataAdapter adapter = new SqlDataAdapter(sqlStr, dataConnection);

ll(dt);

return dt;

}

/// summary

/// 执行出检索以外的其它数据操作返回影响条数

/// /summary

/// param name=\"sqlStr\"sql操作语句/param

2006年将是中国缝制设备需要更大力度开拓海外市场的一年。由于行业的特殊性--市场营销需要演示和操作 /// returns 操作影响条数/returns

public int ExecuteSql(String sqlStr)

{

if (SqlState == osed)

en();

SqlCommand cmd = new SqlCommand(sqlStr, DataConnection);

return ecuteNonQuery();

}

#endregion

#region 存储过程操作

/// summary

/// 执行存储过程获得DataTable数据

/// /summary

/// param name=\"sqlParameters\"存储过程参数ArrayList类型的SqlParameter集合/param

/// param name=\"storedProcedureName\"存储过程名/param

/// returns/returns

public DataTable ProGetDataTable(ArrayList sqlParameters, string storedProcedureName)

{

SqlCommand cmd = new SqlCommand();

nnection = dataConnection;

mandType = oredProcedure;

mandText = storedProcedureName;

if(sqlParameters != null unt != 0)

foreach(object parameter in sqlParameters)

{

d((SqlParameter)parameter);

}

SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

ll(dt);

return dt;

}

#endregion

#region 事务操作

/// summary

/// 开启事务

/// /summary

public void BeginTransaction()

{

ExecuteSql(\"begin transaction;\");

}

/// summary

/// 提交事务

/// /summary

public void Commit()

{

ExecuteSql(\"commit;\");

}

/// summary

/// 回滚事务

/// /summary

public void Rollback()

{

ExecuteSql(\"rollback;\");

}

#endregion

}

}

艾拉莫德片什么时候吃最好
汕头看癫痫去哪
上海男性功能障碍治疗费用多少钱