架构B/S四 DBUtility 数据层基类放公共类(四) ControlBindHelper.cs 类

最新推荐文章于 2021-04-09 17:24:16 发布

tiaru

最新推荐文章于 2021-04-09 17:24:16 发布

阅读量314

点赞数

文章标签： parameters dataset string system class

本文链接：https://blog.csdn.net/tiaru/article/details/4672819

版权

放公共类

如:SQLHelper.cs数据访问抽象基础类 ControlBindHelper.cs 控件帮定抽象基础类 DataBase.cs 操作控件类 MessageBox.cs 显示消息提示对话框类。 PageValidate.cs 页面数据校验类

ControlBindHelper.cs 控件帮定抽象基础类代码

using System;
using System.Data.SqlClient;
using System.Data;
using System.Web;
using System.Collections;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;

namespace CoalTraffic.DBUtility
{
 /// <summary>
 /// 控件帮定抽象基础类
 /// </summary>
 public abstract class ControlBindHelper
 {
 public ControlBindHelper()
 {
 }

#region DropDownList帮定
 /// <summary>
 /// 帮定DropDownList
 /// </summary>
 /// <param name="ddlControl">DropDownList控件ID</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的文本字段</param>
 /// <param name="strValue">值字段</param>
 /// <param name="strInitializeText">初始化文本</param>
 /// <param name="strInitializeValue">初始化值</param>
 public static void DropDownListBind(System.Web.UI.WebControls.DropDownList ddlControl, string strTableName, string strText, string strValue, string strInitializeText,string strInitializeValue)
 {
 string strSql = "SELECT * FROM " + strTableName + "";
 DataSet dstTemp = new DataSet();

dstTemp = DbHelperSQL.Query(strSql);

            ddlControl.DataSource = dstTemp.Tables[0];
            ddlControl.DataTextField = strText;
            ddlControl.DataValueField = strValue;
            ddlControl.DataBind();

ddlControl.Items.Insert(0, "" + strInitializeText + "");
 ddlControl.Items[0].Value = strInitializeValue;
 }
 /// <summary>
 /// 帮定DropDownList
 /// </summary>
 /// <param name="ddlControl">DropDownList控件ID</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的文本字段</param>
 /// <param name="strValue">值字段</param>
 /// <param name="strWhere">查询条件，不包含Where</param>
 public static void DropDownListBind(System.Web.UI.WebControls.DropDownList ddlControl,string strTableName, string strText, string strValue, string strWhere)
 {

string strSql = "SELECT * FROM " + strTableName + " Where " + strWhere;
DataSet dstTemp = new DataSet();

dstTemp = DbHelperSQL.Query(strSql);
 ddlControl.DataSource = dstTemp.Tables[0];
 ddlControl.DataTextField = strText;
 ddlControl.DataValueField = strValue;
 ddlControl.DataBind();
 }
 /// <summary>
 /// 帮定DropDownList
 /// </summary>
 /// <param name="ddlControl">DropDownList控件ID</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的文本字段</param>
 /// <param name="strValue">值字段</param>
 /// <param name="strWhere">查询条件，不包含Where</param>
 /// <param name="strInitializeText">初始化文本</param>
 /// <param name="strInitializeValue">初始化值</param>
 public static void DropDownListBind(System.Web.UI.WebControls.DropDownList ddlControl, string strTableName, string strText, string strValue, string strWhere, string strInitializeText, string strInitializeValue)
 {
 string strSql = "SELECT * FROM " + strTableName + " Where " + strWhere;
 DataSet dstTemp = new DataSet();

dstTemp = DbHelperSQL.Query(strSql);
 ddlControl.DataSource = dstTemp.Tables[0];
 ddlControl.DataTextField = strText;
 ddlControl.DataValueField = strValue;
 ddlControl.DataBind();
 ddlControl.Items.Insert(0, "" + strInitializeText + "");
 ddlControl.Items[0].Value = strInitializeValue;
 }
 /// <summary>
 /// 帮定DropDownList
 /// </summary>
 /// <param name="ddlControl">DropDownList控件ID</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的文本字段</param>
 /// <param name="strValue">值字段</param>
 /// <param name="strWhere">查询条件，不包含Where</param>
 /// <param name="strOrder">排序字段</param>
 /// <param name="strInitializeText">初始化文本</param>
 /// <param name="strInitializeValue">初始化值</param>
 public static void DropDownListBind(System.Web.UI.WebControls.DropDownList ddlControl, string strTableName, string strText, string strValue, string strWhere, string strOrder, string strInitializeText, string strInitializeValue)
 {

string strSql = "SELECT * FROM " + strTableName + " Where " + strWhere + " Order By " + strOrder;
DataSet dstTemp = new DataSet();

#region Repeater控件分页帮定
 /// <summary>
 /// Repeater控件分页帮定
 /// </summary>
 /// <param name="anpager">AspNetPager分页控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strPrimaryKey">表的唯一主建名</param>
 /// <param name="strQuaryCondition">查询Where条件，不含Where</param>
 /// <param name="strOrderCondition">需要排序的字段名</param>
 /// <param name="rptControl">Repeater控件</param>
 public static void RepeaterPagerBind(Wuqi.Webdiyer.AspNetPager anpager, string strTableName,string strPrimaryKey,string strQuaryCondition,string strOrderCondition, System.Web.UI.WebControls.Repeater rptControl)
 {
 SqlParameter[] parameters = new SqlParameter[]
 {
 new SqlParameter("@pageindex",SqlDbType.Int),
 new SqlParameter("@pagesize",SqlDbType.Int),
 new SqlParameter("@docount",SqlDbType.Bit),
 new SqlParameter("@strwhere",SqlDbType.NVarChar,1000),
 new SqlParameter("@tablenm",SqlDbType.NVarChar,100),
 new SqlParameter("@tbmainid",SqlDbType.NVarChar,100),
 new SqlParameter("@strorder",SqlDbType.NVarChar,100),
 };

            parameters[0].Value = anpager.CurrentPageIndex;
            parameters[1].Value = anpager.PageSize;
            parameters[2].Value = false;
            parameters[3].Value = strQuaryCondition;
            parameters[4].Value = strTableName;
            parameters[5].Value = strPrimaryKey;
            parameters[6].Value = strOrderCondition;

            if (strQuaryCondition == "")
            {
                anpager.RecordCount = Convert.ToInt32(DbHelperSQL.GetSingle("Select Count(*) From " + strTableName));
            }
            else
            {
                anpager.RecordCount = Convert.ToInt32(DbHelperSQL.GetSingle("Select Count(*) From " + strTableName + " Where " + strQuaryCondition));
            }

DataSet dstTemp = DbHelperSQL.RunProcedure("P_ControlPager", parameters, "NewTableName");

rptControl.DataSource = dstTemp.Tables["NewTableName"];
rptControl.DataBind();

//动态设置用户自定义文本内容
 anpager.CustomInfoHTML = "共有" + anpager.RecordCount.ToString() + "条记录";
 anpager.CustomInfoHTML += " 总页数：" + anpager.PageCount.ToString() + "页";
 anpager.CustomInfoHTML += " 当前页：第" + anpager.CurrentPageIndex.ToString() + "页";
 }
 #endregion

#region GridView控件分页帮定
 /// <summary>
 /// GridView控件分页帮定
 /// </summary>
 /// <param name="anpager">AspNetPager分页控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strPrimaryKey">表的唯一主建名</param>
 /// <param name="strQuaryCondition">查询Where条件，不含Where</param>
 /// <param name="strOrderCondition">需要排序的字段名</param>
 /// <param name="rptControl">GridView控件</param>
 public static void GridViewPagerBind(Wuqi.Webdiyer.AspNetPager anpager, string strTableName, string strPrimaryKey, string strQuaryCondition, string strOrderCondition, System.Web.UI.WebControls.GridView grvControl)
 {
 SqlParameter[] parameters = new SqlParameter[]
 {
 new SqlParameter("@pageindex",SqlDbType.Int),
 new SqlParameter("@pagesize",SqlDbType.Int),
 new SqlParameter("@docount",SqlDbType.Bit),
 new SqlParameter("@strwhere",SqlDbType.NVarChar,1000),
 new SqlParameter("@tablenm",SqlDbType.NVarChar,100),
 new SqlParameter("@tbmainid",SqlDbType.NVarChar,100),
 new SqlParameter("@strorder",SqlDbType.NVarChar,100),
 };

            if (dstTemp.Tables[0].Rows.Count == 0)
            {
                DataRow dr = dstTemp.Tables[0].NewRow();
                dstTemp.Tables[0].Rows.Add(dr);
                grvControl.DataSource = dstTemp;
                grvControl.DataBind();

            }
            else
            {
                grvControl.DataSource = dstTemp.Tables["NewTableName"];
                grvControl.DataBind();
            }

}

#endregion

#region GridView控件分页帮定
 /// <summary>
 /// GridView控件分页帮定
 /// </summary>
 /// <param name="anpager">AspNetPager分页控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strPrimaryKey">表的唯一主建名</param>
 /// <param name="strQuaryCondition">查询Where条件，不含Where</param>
 /// <param name="strOrderCondition">需要排序的字段名</param>
 /// <param name="rptControl">GridView控件</param>
 public static void GridViewPagerBind(Wuqi.Webdiyer.AspNetPager anpager, string strTableName, string strPrimaryKey, string strQuaryCondition, string strOrderCondition, System.Web.UI.WebControls.GridView grvControl,string produceName)
 {
 SqlParameter[] parameters = new SqlParameter[]
 {
 new SqlParameter("@pageindex",SqlDbType.Int),
 new SqlParameter("@pagesize",SqlDbType.Int),
 new SqlParameter("@docount",SqlDbType.Bit),
 new SqlParameter("@strwhere",SqlDbType.NVarChar,1000),
 new SqlParameter("@tablenm",SqlDbType.NVarChar,100),
 new SqlParameter("@tbmainid",SqlDbType.NVarChar,100),
 new SqlParameter("@strorder",SqlDbType.NVarChar,100),
 };

DataSet dstTemp = DbHelperSQL.RunProcedure(produceName, parameters, "NewTableName");

grvControl.DataSource = dstTemp.Tables["NewTableName"];
grvControl.DataBind();

}

#endregion

#region DataList控件分页帮定
 /// <summary>
 /// DataList控件分页帮定
 /// </summary>
 /// <param name="anpager">AspNetPager分页控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strPrimaryKey">表的唯一主建名</param>
 /// <param name="strQuaryCondition">查询Where条件，不含Where</param>
 /// <param name="strOrderCondition">需要排序的字段名</param>
 /// <param name="rptControl">DataList控件</param>
 public static void DataListPagerBind(Wuqi.Webdiyer.AspNetPager anpager, string strTableName, string strPrimaryKey, string strQuaryCondition, string strOrderCondition, System.Web.UI.WebControls.DataList dlstControl)
 {
 SqlParameter[] parameters = new SqlParameter[]
 {
 new SqlParameter("@pageindex",SqlDbType.Int),
 new SqlParameter("@pagesize",SqlDbType.Int),
 new SqlParameter("@docount",SqlDbType.Bit),
 new SqlParameter("@strwhere",SqlDbType.NVarChar,1000),
 new SqlParameter("@tablenm",SqlDbType.NVarChar,100),
 new SqlParameter("@tbmainid",SqlDbType.NVarChar,100),
 new SqlParameter("@strorder",SqlDbType.NVarChar,100),
 };

DataSet dstTemp = DbHelperSQL.RunProcedure("P_ControlPager", parameters, "NewTableName");

dlstControl.DataSource = dstTemp.Tables["NewTableName"];
dlstControl.DataBind();

}
#endregion

#region CheckBoxListBind邦定
 /// <summary>
 /// CheckBoxListBind邦定
 /// </summary>
 /// <param name="chklControl">CheckBoxList控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的字段</param>
 /// <param name="strValue">值字段</param>
 public static void CheckBoxListBind(System.Web.UI.WebControls.CheckBoxList chklControl,string strTableName, string strText, string strValue)
 {
 string strSql = "SELECT * FROM " + strTableName + "";
 DataSet dstTemp = new DataSet();

dstTemp = DbHelperSQL.Query(strSql);

chklControl.DataSource = dstTemp.Tables[0];
 chklControl.DataTextField = strText;
 chklControl.DataValueField = strValue;
 chklControl.DataBind();
 }
 /// <summary>
 /// CheckBoxListBind邦定
 /// </summary>
 /// <param name="chklControl">CheckBoxList控件</param>
 /// <param name="strTableName">表名</param>
 /// <param name="strText">显示的字段</param>
 /// <param name="strValue">值字段</param>
 /// <param name="strWhere">查询条件</param>
 public static void CheckBoxListBind(System.Web.UI.WebControls.CheckBoxList chklControl, string strTableName, string strText, string strValue, string strWhere)
 {
 string strSql = "SELECT * FROM " + strTableName + " Where " + strWhere;
 DataSet dstTemp = new DataSet();

dstTemp = DbHelperSQL.Query(strSql);

            chklControl.DataSource = dstTemp.Tables[0];
            chklControl.DataTextField = strText;
            chklControl.DataValueField = strValue;
            chklControl.DataBind();
        }

#endregion