StaticFunction.cs

      #region 得到IP地址
        /// <summary>
        /// 得到IP地址
        /// 创建者：袁纯林   时间：2008-1-19
        /// 修改者：         时间：
        /// </summary>
        /// <returns>IP地址</returns>
        public static string GetIP()
        {
            string reIp = "";
            if (System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null || System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString().IndexOf("unknown") > -1)
            {
                reIp = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
            }
            else if (System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString().IndexOf(",") > -1)
            {
                reIp = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].Substring(1, System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].IndexOf(",") - 1);
            }
            else if (System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString().IndexOf(";") > -1)
            {
                reIp = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].Substring(1, System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].IndexOf(":") - 1);
            }
            else
            {
                reIp = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            }
            if (reIp.Length > 30)
            {
                reIp = reIp.Trim().Substring(0, 29);
            }
            else
            {
                reIp = reIp.Trim();
            }
            return reIp;
        }
        #endregion

        #region IP地址转换长整型
        /// <summary>
        /// 得到IP地址

       /// </summary>
        /// <returns>IP地址</returns>
        public static long IPtoLong(string _strip)
        {
            long Ip = 0;
            string[] addressIP = _strip.Split('.');
            if (addressIP.Length == 4)
            {
                Ip = Convert.ToUInt32(addressIP[0]) * 256 * 256 * 256 + Convert.ToUInt32(addressIP[1]) * 256 * 256 + Convert.ToUInt32(addressIP[2]) * 256 + Convert.ToUInt32(addressIP[3]);
            }
            return Ip;
        }
        #endregion

        #region IP地址获取地理位置
        /// <summary>
        /// IP地址地理位置

        /// </summary>
        /// <param name="_strip">IP地址</param>
        /// <returns>地理位置</returns>
        public static string getIPArea(string _strip)
        {
            if ((_strip.Split('.')[0] == "192" && _strip.Split('.')[1] == "168") || _strip == "127.0.0.1")
                return "本地局域网";
            else
            {
                long Ip = IPtoLong(_strip);
                return getIPArea(Ip);
            }
        }
        /// <summary>
        /// IP地址地理位置
        /// </summary>
        /// <param name="_longip">IP地址长整型</param>
        /// <returns>地理位置</returns>
        ///
        public static string getIPArea(long _longip)
        {
            string tempstr = "";
            TOPRAND.BLL.Area bllArea = new TOPRAND.BLL.Area();
            TOPRAND.MODEL.SelectParams modSel = new TOPRAND.MODEL.SelectParams();
            //tempparam.S1 = "IPTOAREA";
            modSel.S2 = _longip.ToString();
            DataTable dt = bllArea.GetList("IPTOAREA", modSel);
            if (dt.Rows.Count>0)
            {
                tempstr = dt.Rows[0]["country"].ToString();
            }
            return tempstr;
        }
        #endregion

#region 将纯文本内容转换成HTML格式内容

/// <summary>
/// 将纯文本内容转换成HTML格式内容

        /// </summary>
        /// <param name="s">需要转换的文本</param>
        /// <returns>转换后的文本</returns>
        public static string TxtToHtml(string s)
        {
            if (s != null)
            {
                s = s.Replace(" ", "  ");
                s = s.Replace("\r\n", "<br>");
            }
            else
                s = "";
            return s;
        }

#endregion

#region 得到字符串的长度

        /// <summary>
        /// 得到字符串的长度
        /// </summary>
        /// <param name="strData"></param>
        /// <returns></returns>
        public static int GetStrLen(string strData)
        {
            System.Text.Encoding encoder5 = System.Text.Encoding.GetEncoding("GB2312");
            return encoder5.GetByteCount(strData);
        }
        #endregion

#region 切割字符串

        /// <summary>
        /// 切割字符串
        /// </summary>
        /// <param name="s">需要切割的字符串</param>
        /// <param name="i">需要切割的字符串长度</param>
        /// <param name="smore">切割后字符串后面添加的字符串</param>
        /// <returns></returns>
        public static string SubStr(string s, int i, string smore)
        {
            int intResult = 0;
            int j = 0;
            string s1 = s;
            if (GetStrLen(s) > i)
            {
                foreach (char Char in s)
                {
                    if (intResult < i)
                    {
                        j++;
                        if ((int)Char > 127)
                            intResult = intResult + 2;
                        else
                            intResult++;
                    }
                    else
                        break;
                }
                s1 = s.Substring(0, j);
            }
            else
            {
                return s1;
            }
            return s1 + smore;
        }

#endregion

        #region 判断是否是数字，放回BOOL
        /// <summary>
       /// 判断是否是数字，放回BOOL
       /// </summary>
       /// <param name="str"></param>
       /// <returns></returns>
        public static bool isnumeric(string str)
        {
            char[] ch = new char[str.Length];
            ch = str.ToCharArray();
            for (int i = 0; i < ch.Length; i++)
            {
                if (ch[i] < 48 || ch[i] > 57)
                    return false;
            }
            return true;
        }
        #endregion

        #region 判断字符串是否数字组成，不是则返回0
        public static int Cint(string str)
        {
            if (str == null || str == "")
                return 0;
            string sChar = "";
            string sNum = "0123456789";
            for (int i = 0; i < str.Length; i++)
            {
                sChar = str.Substring(i, 1);
                if (sNum.IndexOf(sChar) == -1)
                {
                    return 0;
                }
            }
            return Convert.ToInt32(str);
        }
        #endregion

       /// <summary>
        /// 验证Email格式
       /// </summary>
       /// <param name="source">要验证的邮件号码</param>
       /// <returns>bool值（true/fals）</returns>

        #region 验证Email格式

        public static bool IsEmail(string source)
        {
            return Regex.IsMatch(source, @"^[A-Za-z0-9](([_\.\-]?[a-zA-Z0-9]+)*)@([A-Za-z0-9]+)(([\.\-]?[a-zA-Z0-9]+)*)\.([A-Za-z]{2,})$", RegexOptions.IgnoreCase);
        }

        #endregion

        /// <summary>
        ///验证手机号
        /// </summary>
        /// <param name="source">要验证的手机号 </param>
        /// <returns>bool值（true/fals）</returns>
        #region 验证手机号
        public static bool IsMobile(string source)
        {
            return Regex.IsMatch(source, @"^1[35]\d{9}$", RegexOptions.IgnoreCase);
        }

        #endregion

        #region 是不是中国电话，格式010-85849685
        /// <summary>
        /// 是不是中国电话，格式010-85849685
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        public static bool IsTel(string source)
        {
            return Regex.IsMatch(source, @"^\d{3,4}-?\d{6,8}$", RegexOptions.IgnoreCase);
        }
        #endregion

        #region 判断MENUID 返回BOOL
        /// <summary>
        /// 判断MENUID，返回BOOL
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public static string CheckMenuID(string str)
        {
            if (str == null || str == "")
                return "00";
            string sChar = "";
            string sNum = "0123456789";
            for (int i = 0; i < str.Length; i++)
            {
                sChar = str.Substring(i, 1);
                //int j = sNum.IndexOf(sChar);
                //if (!IsNumber(sChar))
                //{
                //    return "01";
                //}
                if (!IsNum(sChar))
                {
                    return "01";
                }
                //if (sNum.IndexOf(sChar) == -1)
                //{
                //    return "01";
                //}
            }
            return str;
        }

        #region 判断是否为数字
        private static bool IsNum(string str)
        {
            if (string.IsNullOrEmpty(str))
            {
                return false;
            }
            try
            {
                int.Parse(str);

            }
            catch
            {
                return false;
            }
            return true;
        }
        #endregion

#endregion

        #region 清除查询字符串的危险字符
        /// <summary>
        /// 清除查询字符串的危险字符
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static string CheckSql(string sql)
        {
            string reSql = "";
            if (sql == null)
            {
                return reSql;
            }
            else
            {
                reSql = sql;
                reSql = reSql.ToLower().Replace("\"", """);
                reSql = reSql.ToLower().Replace("<", "<");
                reSql = reSql.ToLower().Replace(">", ">");
                reSql = reSql.Replace("script", "script");
                reSql = reSql.Replace("SCRIPT", "SCRIPT");
                reSql = reSql.Replace("Script", "Script");
                reSql = reSql.Replace("script", "Script");
                reSql = reSql.Replace("object", "object");
                reSql = reSql.Replace("OBJECT", "OBJECT");
                reSql = reSql.Replace("Object", "Object");
                reSql = reSql.Replace("object", "Object");
                reSql = reSql.Replace("applet", "applet");
                reSql = reSql.Replace("APPLET", "APPLET");
                reSql = reSql.Replace("Applet", "Applet");
                reSql = reSql.Replace("applet", "Applet");
                reSql = reSql.ToLower().Replace("[", "[");
                reSql = reSql.ToLower().Replace("]", "]");
                reSql = reSql.ToLower().Replace("=", "=");
                reSql = reSql.ToLower().Replace("'", "''");
                reSql = reSql.ToLower().Replace("select", "select");
                reSql = reSql.ToLower().Replace("execute", "&#101xecute");
                reSql = reSql.ToLower().Replace("exec", "&#101xec");
                reSql = reSql.ToLower().Replace("join", "join");
                reSql = reSql.ToLower().Replace("union", "union");
                reSql = reSql.ToLower().Replace("where", "where");
                reSql = reSql.ToLower().Replace("insert", "insert");
                reSql = reSql.ToLower().Replace("delete", "delete");
                reSql = reSql.ToLower().Replace("update", "update");
                reSql = reSql.ToLower().Replace("like", "like");
                reSql = reSql.ToLower().Replace("drop", "drop");
                reSql = reSql.ToLower().Replace("create", "create");
                reSql = reSql.ToLower().Replace("rename", "rename");
                reSql = reSql.ToLower().Replace("count", "count");
                reSql = reSql.ToLower().Replace("chr", "chr");
                reSql = reSql.ToLower().Replace("mid", "mid");
                reSql = reSql.ToLower().Replace("truncate", "truncate");
                reSql = reSql.ToLower().Replace("nchar", "nchar");
                reSql = reSql.ToLower().Replace("char", "char");
                reSql = reSql.ToLower().Replace("alter", "alter");
                reSql = reSql.ToLower().Replace("cast", "cast");
                reSql = reSql.ToLower().Replace("exists", "exists");
                reSql = reSql.ToLower().Replace("\n", "<br>");
                return reSql;
            }
        }
        #endregion

        #region 权限判断
        /// <summary>
        /// 判断用户角色是否具有某个模块，某个功能的权限
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool HasFunctionRight(string AdminRoleNo, string MenuID, string Functions)
        {
            TOPRAND.IDAL.IMenu dal = DataAccess.CreateMenu();
            return dal.HasFunctionRight(AdminRoleNo, MenuID, Functions);
        }

        /// <summary>
        /// 判断哪些按扭可用
        /// </summary>
        /// <param name="AdminRoleNo"></param>
        /// <param name="MenuID"></param>
        /// <returns></returns>
        public static DataSet HasFunctionRight(string AdminRoleNo, string MenuID)
        {
            TOPRAND.IDAL.IMenu dal = DataAccess.CreateMenu();
            return dal.HasFunctionRight(AdminRoleNo, MenuID);
        }

        /// <summary>
        /// 判断用户角色是否具有某个模块的权限
        /// </summary>
        /// <param name="AdminRoleNo"></param>
        /// <param name="MenuID"></param>
        /// <returns></returns>
        public static bool HasModuleRight(string AdminRoleNo, string MenuID)
        {
            TOPRAND.IDAL.IMenu dal = DataAccess.CreateMenu();
            return dal.HasModuleRight(AdminRoleNo, MenuID);
        }

        /// <summary>
        /// 判断用户角色是否具有某个站点的权限
        /// </summary>
        /// <param name="AdminRoleNo"></param>
        /// <param name="MenuID"></param>
        /// <returns></returns>
        public static string HasSiteRight(string AdminRoleNo, string siteID)
        {
            TOPRAND.IDAL.IMenu dal = DataAccess.CreateMenu();
            return dal.HasSiteRight(AdminRoleNo, siteID);
        }
        #endregion

//2012-11-29 15:49:07

#region 去除HTML标记
/// <summary>

/// 去除HTML标记
/// </summary>

/// <param name="NoHTML">包括HTML的源码</param>

/// <returns>已经去除后的文字</returns>

        public static string NoHTML(string Htmlstring)
        {
            //删除脚本

Htmlstring = Regex.Replace(Htmlstring, @"<script[^>]*?>.*?</script>", "", RegexOptions.IgnoreCase);

//删除HTML

Htmlstring = Regex.Replace(Htmlstring, @"<(.[^>]*)>", "", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"([\r\n])[\s]+", "", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"-->", "", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"<!--.*", "", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(quot|#34);", "\"", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(amp|#38);", "&", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(lt|#60);", "<", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(gt|#62);", ">", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(nbsp|#160);", " ", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(iexcl|#161);", "\xa1", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(cent|#162);", "\xa2", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(pound|#163);", "\xa3", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&(copy|#169);", "\xa9", RegexOptions.IgnoreCase);

Htmlstring = Regex.Replace(Htmlstring, @"&#(\d+);", "", RegexOptions.IgnoreCase);

Htmlstring.Replace("<", "");

Htmlstring.Replace(">", "");

Htmlstring.Replace("\r\n", "");

Htmlstring = HttpContext.Current.Server.HtmlEncode(Htmlstring).Trim();

            return Htmlstring;
        }
        #endregion

        #region 获取二级栏目
        /// <summary>
        /// 获取二级栏目
        /// 默认是有 li 装 a 的列表，就 ReturnChildsMenu("0202",PageMenuID," li>, /li>")
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static string ReturnChildsMenu(string MenuID, string PageMenuID, string AddStrig1)
        {
            string[] AddStrigList = null;
            if (!string.IsNullOrEmpty(AddStrig1))
            {
                AddStrigList = AddStrig1.Split(',');
            }
            string ReturnString = "";
            TOPRAND.BLL.Menu bllMenuID = new TOPRAND.BLL.Menu();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            DataTable dt = bllMenuID.GetList("GetSiteMap", param);
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (!string.IsNullOrEmpty(AddStrig1))
                    {
                        ReturnString += AddStrigList[0];
                    }
                    ReturnString += "<a href= \"" + (Convert.ToString(dt.Rows[i]["LinkURL"]) == "" ? "#" : dt.Rows[i]["LinkURL"]) + "\">" + TOPRAND.COMMON.StaticFunction.SubStr(Convert.ToString(dt.Rows[i]["Name"]), 20, "...") + "</a>";
                    DataTable dtChilds = bllMenuID.GetList("TYPEBLL", param);
                    if (dtChilds.Rows.Count > 0)
                    {
                        ReturnString += "<div class=" + (TOPRAND.COMMON.StaticFunction.SubStr(PageMenuID, MenuID.Length, "") == MenuID ? "" : "hidden") + ">";
                        ReturnString += "<ul class=\"" + (Convert.ToString(dtChilds.Rows[0]["MenuID"]).Length == 14 ? "ul3" : "ul2") + "\">";
                        for (int c = 0; c < dtChilds.Rows.Count; c++)
                        {
                            ReturnString += TOPRAND.COMMON.StaticFunction.ReturnChildsMenu(Convert.ToString(dtChilds.Rows[c]["MenuID"]), PageMenuID, null);
                        }
                        ReturnString += "</ul>";
                    }
                    if (!string.IsNullOrEmpty(AddStrig1))
                    {
                        ReturnString += AddStrigList[1];
                    }
                }
            }
            return ReturnString;
        }
        #endregion

        #region 根据Menuid获取栏目名称
        /// <summary>
        /// 根据Menuid获取栏目名称
        /// </summary>
        /// <param name="MenuID">Menuid</param>
        /// <returns>0表示无法找到栏目名称，否则返回栏目名称</returns>
        public static string ReturnMenuName(string MenuID)
        {
            TOPRAND.BLL.Menu bllMenuID = new TOPRAND.BLL.Menu();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            DataTable dtmenu = bllMenuID.GetList("ONE", param);
            if (dtmenu.Rows.Count > 0)
            {
                return dtmenu.Rows[0]["name"].ToString();
            }
            else
            {
                return "0";
            }
        }
        #endregion

        #region 根据Menuid返回内容管理模块内容
        /// <summary>
        /// 根据Menuid返回内容管理模块内容
        /// </summary>
        /// <param name="MenuID">Menuid</param>
        /// <returns>内容</returns>
        public static string ReturnContent(string MenuID)
        {
            TOPRAND.BLL.Content bllContent = new TOPRAND.BLL.Content();
            TOPRAND.MODEL.SelectParams paras = new TOPRAND.MODEL.SelectParams();
            paras.S1 = MenuID;
            DataTable dt = bllContent.GetList("MENUID", paras);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["remark"].ToString();
            }
            else
            {
                return "";
            }
        }
        #endregion

        #region 根据Menuid返回 Menu 的 DataTable
        /// <summary>
        /// 根据Menuid返回指定 Menu 的 DataTable
        /// </summary>
        /// <param name="MenuID">Menuid</param>
        /// <returns>DataTable</returns>
        public static DataTable GetMenuDateByMenuID(string MenuID)
        {
            TOPRAND.BLL.Menu bllMenuID = new TOPRAND.BLL.Menu();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            return bllMenuID.GetList("ONE", param);
        }

#endregion

        #region 判断指定MenuID是否有子栏目，有就返回 true,没有就返回false
        /// <summary>
        /// 判断指定MenuID是否有子栏目，有就返回 true,没有就返回false
        /// </summary>
        /// <param name="MenuID">Menuid</param>
        /// <returns>ReturnName</returns>

        public static bool ChickMenu(string MenuID)
        {
            DataTable dt = TOPRAND.COMMON.StaticFunction.ReturnMenuDataTable(MenuID, "TYPEBLL", null, null);
            if (dt.Rows.Count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion

        #region 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_NewsSel_sp 的新闻信息，String2是新增的参数
        /// <summary>
        /// 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_NewsSel_sp 的新闻信息，String2是新增的参数
        /// </summary>
        /// <param name="MenuID">MenuID</param>
        /// <returns>DataTable</returns>
        public static DataTable ReturnNewDataTable(string MenuID, string CType, string String2, string Int1)
        {
            TOPRAND.BLL.News bllNews = new TOPRAND.BLL.News();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();

            param.S1 = MenuID;
            if (!string.IsNullOrEmpty(String2))
            {
                param.S2 = String2;
            }
            if (!string.IsNullOrEmpty(Int1))
            {
                param.I1 = Convert.ToInt32(Int1);
            }

return bllNews.GetList(CType, param);
}

#endregion

        #region 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_MenuSel_sp 的信息，String2是新增的参数
        /// <summary>
        /// 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_NewsSel_sp 的信息，String2是新增的参数
        /// </summary>
        /// <param name="MenuID">MenuID</param>
        /// <returns>DataTable</returns>
        public static DataTable ReturnMenuDataTable(string MenuID, string CType, string String2, string Int1)
        {
            TOPRAND.BLL.Menu bllMenu = new TOPRAND.BLL.Menu();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            if (!string.IsNullOrEmpty(String2))
            {
                param.S2 = String2;
            }
            if (!string.IsNullOrEmpty(Int1))
            {
                param.I1 = Convert.ToInt32(Int1);
            }
            return bllMenu.GetList(CType, param);
        }

#endregion

        #region 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_ProductSel_sp 的新闻信息，String2是新增的参数
        /// <summary>
        /// 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_NewsSel_sp 的新闻信息，String2是新增的参数
        /// </summary>
        /// <param name="MenuID">MenuID</param>
        /// <returns>DataTable</returns>
        public static DataTable ReturnProductDataTable(string MenuID, string CType, string String2, string Int1)
        {
            TOPRAND.BLL.Product bllProduct = new TOPRAND.BLL.Product();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();

return bllProduct.GetList(CType, param);
}

#endregion

        #region 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_JobSel_sp 的新闻信息，String2是新增的参数
        /// <summary>
        /// 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_NewsSel_sp 的新闻信息，String2是新增的参数
        /// </summary>
        /// <param name="MenuID">MenuID</param>
        /// <returns>DataTable</returns>
        public static DataTable ReturnJobDataTable(string MenuID, string CType, string String2, string Int1)
        {
            TOPRAND.BLL.Job bllJob = new TOPRAND.BLL.Job();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            if (!string.IsNullOrEmpty(String2))
            {
                param.S2 = String2;
            }
            if (!string.IsNullOrEmpty(Int1))
            {
                param.I1 = Convert.ToInt32(Int1);
            }
            return bllJob.GetJobList(CType, param);
        }
        #endregion

        #region 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_FeekBack_sp 的新闻信息，String2是新增的参数
        /// <summary>
        /// 根据指定的 MenuID ， CType 存储过程名称，查询指定的 K_FeekBack_sp 的新闻信息，String2是新增的参数
        /// </summary>
        /// <param name="MenuID">MenuID</param>
        /// <returns>DataTable</returns>
        public static DataTable ReturnFeekBackDataTable(string MenuID, string CType, string String2, string Int1)
        {
            TOPRAND.BLL.FeekBack bllFeekBack = new TOPRAND.BLL.FeekBack();
            TOPRAND.MODEL.SelectParams param = new TOPRAND.MODEL.SelectParams();
            param.S1 = MenuID;
            if (!string.IsNullOrEmpty(String2))
            {
                param.S2 = String2;
            }
            if (!string.IsNullOrEmpty(Int1))
            {
                param.I1 = Convert.ToInt32(Int1);
            }
            return bllFeekBack.GetList(CType, param);
        }
        #endregion

        #region 判断DataTable是否为空
        /// <summary>
        /// 判断DataTable是否为空
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static bool CheckedDatatable(DataTable dt)
        {
            if (dt != null && dt.Rows.Count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion

        /// <summary>
        /// 得到Appkey
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public static string GetAppSetting(string key)
        {
            return ConfigurationManager.AppSettings.Get(key);
        }

        /// <summary>
        /// 获取缓存中的广告
        /// </summary>
        /// <returns></returns>
        public static DataTable AdvertisementCache()
        {
            DataTable datatable = new DataTable();
            if (HttpContext.Current.Cache["Advertisement"] != null)
            {
                datatable = (DataTable)HttpContext.Current.Cache["Advertisement"];
            }
            else
            {
                datatable = TOPRAND.COMMON.StaticFunction.ReturnNewDataTable("", "LISTIMAGE", "", "");
                HttpContext.Current.Cache.Insert("Advertisement", datatable, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
            }
            return datatable;
        }

}
}

posted @ 2013-03-05 20:21 战阅读(238) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

战

StaticFunction.cs

公告