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

放公共类

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

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

///

        /// 无控件绑定
        ///

        /// 表名
        /// 主建
        /// 主键ID最大值
        public static string UnControlAutoIncreaseCodeNumber(string strTableName, string strPrimaryKeyName)
        {
            string strMaxCode = string.Empty;

            try
            {
                string strSql = "Select EnumValue From dbo.T_EnumValue Where EnumValueName='" + strTableName + "'";
                string strDefaultValue = DbHelperSQL.GetSingle(strSql).ToString();

                strSql = "Select Max(Convert(int," + strPrimaryKeyName + ")) From " + strTableName;// +" Order By " + strPrimaryKeyName + " desc";

                object objScalar = DbHelperSQL.GetSingle(strSql);

                if (objScalar != null && objScalar.ToString() != "")
                {
                    strMaxCode = objScalar.ToString();

                    //if (strMaxCode.Length > 2)
                    //{
                        //string strMaxCodeBefore = strMaxCode.Substring(0, 1);
                        string strMaxCodeAfter = strMaxCode;//.Substring(1);
                        //int iMaxCodeAfterLength = strMaxCodeAfter.Length;

                        strMaxCodeAfter = (Convert.ToInt32(strMaxCodeAfter) + 1).ToString();

                        //if (strMaxCodeAfter.Length != iMaxCodeAfterLength)
                        //{
                        //    strMaxCodeAfter = strMaxCodeAfter.PadLeft(iMaxCodeAfterLength, '0');
                        //}

                        strMaxCode = strMaxCodeAfter;//strMaxCodeBefore +
                    //}
                }
                else
                {
                    strMaxCode = strDefaultValue;
                }
            }
            catch (Exception ex)
            {
                string strErrorMessage = ex.Message.ToString();
            }

            return strMaxCode;
        }
        ///

        /// 无控件绑定
        ///

        /// 表名
        /// 主建
        /// 查询条件
        /// 主键ID最大值
        public static string UnControlAutoIncreaseCode(string strTableName, string strPrimaryKeyName,string strWhere)
        {
            string strMaxCode = string.Empty;
            try
            {
                string strSql = "Select EnumValue From dbo.T_EnumValue Where EnumValueName='" + strTableName + "'";
                string strDefaultValue = DbHelperSQL.GetSingle(strSql).ToString();

                strSql = "Select Top 1 " + strPrimaryKeyName + " From " + strTableName + " Where" + strWhere + " Order By " + strPrimaryKeyName + " desc";

                object objScalar = DbHelperSQL.GetSingle(strSql);

                if (objScalar != null && objScalar.ToString() != "")
                {
                    strMaxCode = objScalar.ToString();

                    if (strMaxCode.Length > 2)
                    {
                        string strMaxCodeBefore = strMaxCode.Substring(0, 1);
                        string strMaxCodeAfter = strMaxCode.Substring(1);
                        int iMaxCodeAfterLength = strMaxCodeAfter.Length;

                        strMaxCodeAfter = (Convert.ToInt32(strMaxCodeAfter) + 1).ToString();

                        if (strMaxCodeAfter.Length != iMaxCodeAfterLength)
                        {
                            strMaxCodeAfter = strMaxCodeAfter.PadLeft(iMaxCodeAfterLength, '0');
                        }

                        strMaxCode = strMaxCodeBefore + strMaxCodeAfter;
                    }
                }
                else
                {
                    strMaxCode = strDefaultValue;
                }
            }
            catch (Exception ex)
            {
                string strErrorMessage = ex.Message.ToString();
            }

            return strMaxCode;
        }
        #endregion

        #region 判断名称是否存在
        ///

        /// 判断某列是否存在
        ///

        /// 表名
        /// 要检测的列名
        /// 要检测的列值
        ///
        public static bool NameIsExict(string tableName, string nameColun, string nameColunValue)
        {
            string selectSql = "select count(1) from " + tableName + " where " + nameColun + " = '" + nameColunValue + "'";
            return DbHelperSQL.Exists(selectSql);
        }
        #endregion
    }
}

//**********************MessageBox.cs 显示消息提示对话框类 代码

using System;
using System.Text;

namespace CoalTraffic.Common
{
///

/// 显示消息提示对话框。
///

public class MessageBox
{  
   private MessageBox()
   {   
   }

   ///

   /// 显示消息提示对话框
   ///

   /// 当前页面指针，一般为this
   /// 提示信息
   public static void Show(System.Web.UI.Page page,string msg)
   {           
            page.ClientScript.RegisterStartupScript(page.GetType(),"message", "");
   }

   ///

   /// 控件点击 消息确认提示框
   ///

   /// 当前页面指针，一般为this
   /// 提示信息
   public static void ShowConfirm(System.Web.UI.WebControls.WebControl Control,string msg)
   {
    //Control.Attributes.Add("onClick","if (!window.confirm('"+msg+"')){return false;}");
    Control.Attributes.Add("onclick", "return confirm('" + msg + "');") ;
   }

   ///

   /// 显示消息提示对话框，并进行页面跳转
   ///

   /// 当前页面指针，一般为this
   /// 提示信息
   /// 跳转的目标URL
   public static void ShowAndRedirect(System.Web.UI.Page page,string msg,string url)
   {
    StringBuilder Builder=new StringBuilder();
    Builder.Append("");
            page.ClientScript.RegisterStartupScript(page.GetType(), "message", Builder.ToString());

   }
   ///

   /// 输出自定义脚本信息
   ///

   /// 当前页面指针，一般为this
   /// 输出脚本
   public static void ResponseScript(System.Web.UI.Page page,string script)
   {
            page.ClientScript.RegisterStartupScript(page.GetType(), "message", "");
   }

}
}