?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;

/// <summary>
/// dataOperate 的摘要說明
/// </summary>
public class dataOperate
{
	public dataOperate()
	{
		//
		// TODO: 在此處添加構(gòu)造函數(shù)邏輯
		//
	}

    /********************************************************************
     * 獲取數(shù)據(jù)集       
     * ******************************************************************/
    public string GetDataSet(string sql, ref DataSet ds, string dsName)
    {
        //獲取數(shù)據(jù)集DataSet
        string sRet = "";
        SqlConnection con = DB.CreateConnection();
        con.Open();
        try
        {
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = new SqlCommand(sql, con);
            sda.Fill(ds, dsName);
        }
        catch (Exception ex)
        {
            sRet = ex.Message.ToString();
        }
        con.Close();
        return sRet;
    }

    /********************************************************************
     * 執(zhí)行sql語句      
     * ******************************************************************/
    public string ExecuteNonQuery(string sql)
    {
        string sRet = "";
        int count = 0;
        SqlConnection con = DB.CreateConnection();
        con.Open();
        SqlCommand cmd = new SqlCommand(sql, con);

        try
        {
            count = cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            sRet = ex.Message.ToString();
        }

        con.Close();

        if (sRet == "" && count <= 0)
        {
            sRet = "記錄不存在！";
        }
        return sRet;
    }

    /********************************************************************
     * 執(zhí)行sql語句返回首行首列    
     * ******************************************************************/
    public string ExecuteScalar(string sql, ref string result)
    {
        string sRet = "";
        SqlConnection con = DB.CreateConnection();
        con.Open();
        SqlCommand cmd = new SqlCommand(sql, con);

        try
        {
            result = cmd.ExecuteScalar().ToString();
        }
        catch (Exception ex)
        {
            sRet = ex.Message.ToString();
        }
        
        con.Close();
        return sRet;
    }

    /********************************************************************
     * 獲取數(shù)據(jù)集       
     * ******************************************************************/

    /********************************************************************
     * 獲取數(shù)據(jù)集       
     * ******************************************************************/
}