baseclass.cs

后台管理模块有：小区管理、设备管理、楼盘管理、收费管理、停车管理、用户管理 小区基本信息 添加周边设施 编辑周边设施 添加公告 编辑公告 楼盘信息添加 编辑楼盘信息 房产信息添加 房产信息查

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;
using System.Security;
using System.Text;
using System.IO;
using System.Collections;
//该源码首发自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)

/// <summary>
/// BaseClass 的摘要说明
/// ==========================================================================================
/// 
/// ＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊类方法说明及参数＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
///  public BaseClass()构造函数：功能连接字符串
/// 
/// public bool ExecSql(string Sqlcom)；执行ＳＱＬ语句，返回是否执行成功，值：ＴＲＵＥ，ＦＡＬＳＥ
/// 
/// public DataSet ExecDS(string Sqlcom)；执行ＳＱＬ语句，返因DataSet类型数据
/// 
///  public DataSet ReturnDataSet(string sqlstr,string tablename):执行ＳＱＬ语句，其中tablename是执行ＳＱＬ语句的操作的表
/// public object ExecCscalar(string sqlcom):执行返回一个数据的ＳＱＬ语句,返回数据为任何类型
/// 
///   public SqlDataReader ExecRead(string Sqlcom)：:执行ＳＱＬ语句，返回操作的数据
/// 
/// public void ExecDropDownList(DropDownList DDL,string sqlstr,string dtf,string dvf)
/// 功能：绑定数据到Ｇridview
/// 参数：DDL是Gridview对象，
/// 　　　sqlstr是ＳＱＬ语句
/// 　　　dtf是绑定的选项
/// 　　　dvf  是选择下拉列表取到的值
/// 
///  public void ExecGridView(GridView gv,string sqlstr):：绑定数据集到gridview控件
/// 
/// public void ExecDatalist(DataList dl,string sqlstr): 绑定数据集到Datalist控件
/// 
/// 
/// 
/// 
/// 
/// 
/// 
/// ================================================================================================
/// </summary>
/// 

///










public class BaseClass
{　　　//定义三个数据库连接，操作，取数据的三个私有对象
	　　private SqlConnection sqlcon;
        private SqlCommand sqlcom;
        private SqlDataAdapter sqldata;
         
    
		
	
                     #region  构造函数

    /// <summary>
    /// 构造函数
    /// </summary>


    public BaseClass()
    {

    }
    
         #endregion



                    #region 执行ＳＱＬ语句

        ///<summary>
        ///执行ＳＱＬ语句
        ///</summary>
    public bool ExecSql(string Sqlcom)
    {

        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        sqlcon = new SqlConnection(settings);
        sqlcon.Open();



        sqlcom = new SqlCommand(Sqlcom, sqlcon);
        try
        {
            sqlcom.ExecuteNonQuery();
            return true;
        }

        catch
        {
            return false;
        }

        finally
        {
            
            sqlcon.Close();
        }



    }


               #endregion

                    #region 返回ＤＡＴＡＳＥＴ类型数据
    /// <summary>
    /// 返回一个ＤＡＴＡＳＥＴ数据
    /// </summary>
    /// <param name="Sqlcom"></param>
    /// <returns></returns>
    public DataSet ExecDS(string Sqlcom)
    {
        try
        {
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

            sqlcon = new SqlConnection(settings);
            sqlcon.Open();
            sqlcom = new SqlCommand(Sqlcom, sqlcon);
            sqldata = new SqlDataAdapter();
            sqldata.SelectCommand = sqlcom;
            DataSet ds = new DataSet();
            sqldata.Fill(ds);
            return ds;

        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }

        finally
        {
            sqlcon.Close();
        }
    }
             #endregion


                    #region 返回DataSet类型数据
    /// <summary>
    /// 返回DataSet类型数据
    /// sqlstr为执行的ＳＱＬ语句，
    /// tablename为执行查询的数据表名称
    /// </summary>
    /// <param name="sqlstr"></param>
    /// <param name="tablename"></param>
    /// <returns></returns>
     public DataSet ReturnDataSet(string sqlstr,string tablename)
    {
        SqlDataAdapter ada=new SqlDataAdapter(sqlstr,sqlcon);
        DataSet ds=new DataSet();
        ada.Fill(ds,tablename);
        return ds;
    }

                       #endregion



                   #region 返回DataRead类型数据
    /// <summary>
    /// 返回DataRead类型数据
    /// </summary>
    /// <param name="Sqlcom"></param>
    /// <returns></returns>

    public SqlDataReader ExecRead(string Sqlcom)
    {


        try
        {
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

            sqlcon = new SqlConnection(settings);
            sqlcon.Open();
            sqlcom = new SqlCommand(Sqlcom, sqlcon);
            SqlDataReader read = sqlcom.ExecuteReader();
            return read;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        finally
        {
            
        }
       

    }
   #endregion

    #region 执行返回一个数据的ＳＱＬ语句
    /// <summary>
    /// 执行返回一个数据的ＳＱＬ语句
    /// 返回数据为任何类型
    /// </summary>
    /// <param name="sqlcom"></param>
    /// <returns></returns>
    public object ExecCscalar(string Sqlcom)
    {
         try
        {
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

            sqlcon = new SqlConnection(settings);
            sqlcon.Open();
           SqlCommand mycmd = new SqlCommand(Sqlcom, sqlcon);
           object r = mycmd.ExecuteScalar();
             return r;
            
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        finally
        {
            sqlcon.Close();
        }
    }

#endregion

    #region 执行一组SQL语句，
    /// <summary>
    /// 执行一组SQl语句，全部执行成功刚返回TRUE,否则返回FALSE
    /// 事务类，要么全部执行，要么就不执行。
    /// </summary>
    /// <param name="sqlstrings"></param>
    /// <returns></returns>
    public bool ExecSQLTrans(ArrayList sqlstrings)
    {
        Boolean success = true;
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        sqlcon = new SqlConnection(settings);
        sqlcon.Open();
        SqlCommand cmd = new SqlCommand();
        SqlTransaction trans = sqlcon.BeginTransaction();
        cmd.Connection = sqlcon;
        cmd.Transaction = trans;
        try
        {
            foreach (string str in sqlstrings)  //循环执行SQL语句
            {
                cmd.CommandText = str;
                cmd.ExecuteNonQuery();

            }
            trans.Commit();//，所有SQL执行完毕，提交事务
        }
        catch
        {
            success = false;
            trans.Rollback();
            //回滚
        }
        finally
        {
            Closeconn();
        }
        return success;
    }



    #endregion











    //以下方法实现数据绑定


                 #region DropdownList 数据绑定
    /// <summary>
    /// 将ＳＱＬ语句中的字段绑定下拉列表控件
    /// </summary>
    /// <param name="DDL"></param>
    /// <param name="sqlstr"></param>
    /// <param name="dtf"></param>
    /// <param name="dvf"></param>
    public void ExecDropDownList(DropDownList DDL,string sqlstr,string dtf,string dvf)
    {


        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        sqlcon = new SqlConnection(settings);
        sqlcon.Open();
        SqlDataAdapter ada=new SqlDataAdapter(sqlstr,sqlcon);
        DataSet ds=new DataSet();
        ada.Fill(ds);
      
        DDL.DataSource=ds;
      
        DDL.DataTextField=dtf;
        DDL.DataValueField=dvf;
        DDL.DataBind();
        sqlcon.Close();
    }
#endregion

                 #region 绑定到Gridview控件
    /// <summary>
    /// 将ＳＱＬ语句中的字段绑定到Gridview控件
    
    /// </summary>
    /// <param name="gv"></param>
    /// <param name="sqlstr"></param>
    public void ExecGridView(GridView gv,string sqlstr)
    {
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        sqlcon = new SqlConnection(settings);
        sqlcon.Open();
        SqlDataAdapter ada=new SqlDataAdapter(sqlstr,sqlcon);
        DataSet ds=new DataSet();
        ada.Fill(ds);
        gv.DataSource=ds;
        gv.DataBind();
        sqlcon.Close();
    }
           #endregion

                 #region 绑定到DataLIist控件
    public void ExecDatalist(DataList dl, string Sqlstr)
    {
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        sqlcon = new SqlConnection(settings);
        sqlcon.Open();
        SqlDataAdapter ada = new SqlDataAdapter(Sqlstr,sqlcon);
        DataSet ds = new DataSet();
        ada.Fill(ds);
        dl.DataSource = ds;
        dl.DataBind();
        sqlcon.Close();

    }

    #endregion 

    //打开关闭数据库

                 #region 关闭数据库连接
    /// <summary>
    /// 判断数据库是否打开，如打开，就关闭
    /// </summary>

    public void Closeconn()
    {
        if (sqlcon != null)
        {
            sqlcon.Close();
        }
    }
#endregion 


                 #region 打开数据库连接
    /// <summary>
    /// 判断数据库是否关闭，如关闭就打开
    /// 
    /// </summary>
    public void openconn()
    {
        if (sqlcon.State == System.Data.ConnectionState.Closed)
        {
            sqlcon.Open();
        }

    }
    #endregion


}