test.cs

餐饮系统的各个功能

using System;
using System.Collections.Generic;
using System.Text;

public class Test
{
    /// <summary>
    /// SQL语句过滤
    /// </summary>
    /// <param name="str"></param>
    /// <returns></returns>
    public static string SqlEncode(string str)//SQL语句过滤
    {
        if (str != "" && str != null)
        {
            str = str.Trim();
            ///str = str.Replace(" ", "&nbsp;");
            str = str.Replace("\t", "<br />");
            str = str.Replace("\n", "<br />");
            str = str.Replace("-", "－");
            str = str.Replace("'", "＇");
            str = str.Replace("!", "！");
            str = str.Replace(".", "。");
            str = str.Replace(",", "，");
            str = str.Replace("(", "（");
            str = str.Replace(")", "）");
            str = str.Replace(":", "：");
            str = str.Replace("%", "％");
            str = str.Replace("=", "＝");
        }
        return str;
    }


    /// <summary>
    /// 过滤网址
    /// </summary>
    /// <param name="str"></param>
    /// <returns></returns>
    public static string UrlEncodes(string str)//SQL语句过滤
    {
        //if (str != "" && str != null)
        //{
        //    str = str.Trim();
        //    ///str = str.Replace(" ", "&nbsp;");
        //    //str = str.Replace("\t", "<br />");
        //    //str = str.Replace("\n", "<br />");
        //    //str = str.Replace("'", "＇");
        //    //str = str.Replace("!", "！");
        //    //str = str.Replace(",", "，");
        //    //str = str.Replace("(", "（");
        //    //str = str.Replace(")", "）");
        //    //str = str.Replace(":", "：");
        //    //str = str.Replace("%", "％");
        //    //str = str.Replace("=", "＝");
        //}
        return str;
    }



    public static string UrlNoEncode(string str)//SQL语句过滤
    {
        if (str != "" && str != null)
        {
            str = str.Trim();
            str = str.Replace("＇", "'");
            str = str.Replace("！", "!");
            str = str.Replace("。", ".");
            str = str.Replace("，", ",");
            str = str.Replace("（", "(");
            str = str.Replace("）", ")");
            str = str.Replace("：", ":");
            str = str.Replace("％", "%");
            str = str.Replace("＝", "=");
        }
        return str;
    }

    /// <summary>
    /// 读取信息转换回来
    /// </summary>
    /// <param name="str"></param>
    /// <returns></returns>
    public static string NoSqlEncode(string str)
    {
        if (str != "" && str != null)
        {
            str = str.Replace("&nbsp;", " ");
        }
        return str;
    }


    /// <summary>
    /// 处理标题长度
    /// </summary>
    /// <param name="title"></param>
    /// <param name="len"></param>
    /// <returns></returns>
    public static string Title(string title, int len)
    {
        if (title != "" && title != null)
        {
            if (title.Length >= len)
            {
                return title.Substring(0, len) + "...";
            }
            else
            {
                return title;
            }
        }
        return title;
    }


}