/*
* 说明: 对MSSQL数据库的增删查改操作的封装类
*/
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
namespace Niunan.Tg029.Hr.Utility
{
public class MSSQLHelper
{
private SqlConnection conn = null;
private SqlCommand cmd = null;
private SqlDataReader sdr = null;
public MSSQLHelper()
{
string connStr = WebConfigurationManager.ConnectionStrings["connStr"].ToString();
conn = new SqlConnection(connStr);
}
/// <summary>创建Command对象
/// 默认是SQL语句
/// </summary>
/// <param name="sql">SQL语句</param>
public void CreateCommand(string sql)
{
conn.Open();
cmd &