CY_ZZJY.EasyUI/StaticClass.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Globalization;
using Hxj.Data;
using System.Reflection;
using System.Text.RegularExpressions;

namespace CY_ZZJY.EasyUI
{
    /// <summary>
    /// 
    /// </summary>
    public static class StaticClass
    {
        /// <summary>
        /// 检查列名是否有与sql相同的关键字
        /// </summary>
        public static string CheckColumnName(string columnName)
        {
            string returnValue = columnName;
            #region sql关键字列表
            string str = "MONTH,OTHER,CONTENT,TYPE,NATIONAL,NUMBER,FROM,E-mail,KILL,PASSWORD,NO,YEAR,LEAVE,USE,ACCESS,ADD,ALL,ALTER,AND,ANY,AS,ASC,AUDIT,BETWEEN,BY,CHAR,CHECK,CLUSTER,COLUMN,COMMENT,COMPRESS,CONNECT,CREATE,CURRENT,DATE,DECIMAL,DEFAULT,DELETE,DESC,DISTINCT,DROP,ELSE,EXCLUSIVE,EXISTS,FILE,FLOAT,FOR,FROM,GRANT,GROUP,HAVING,IDENTIFIED,IMMEDIATE,IN,INCREMENT,INDEX,INITIAL,INSERT,INTEGER,INTERSECT,INTO,IS,LEVEL,LIKE,LOCK,LONG,MAXEXTENTS,MINUS,MLSLABEL,MODE,MODIFY,NOAUDIT,NOCOMPRESS,NOT,NOWAIT,NULL,NUMBER,OF,OFFLINE,ON,ONLINE,OPTION,OR,ORDER,P,CTFREE,PRIOR,PRIVILEGES,PUBLIC,RAW,RENAME,RESOURCE,REVOKE,ROW,ROWID,ROWNUM,ROWS,SELECT,SESSION,SET,SHARE,SIZE,SMALLINT,START,SUCCESSFUL,SYNONYM,SYSDATE,TABLE,THEN,TO,TRIGGER,UID,UNION,UNIQUE,UPDATE,USER,VALIDATE,VALUES,VARCHAR,VARCHAR2,VIEW,WHENEVER,WHERE,WITH";
            List<string> list = new List<string>();
            foreach (string item in str.Split(new char[] { ',' }))
            { list.Add(item); }
            #endregion
            foreach (string item in list)
            {
                if (item.Trim().ToUpper() == columnName.ToUpper().Trim())
                {
                    returnValue = string.Format("\"{0}\"", columnName.Trim().ToUpper());
                    break;
                }
            }
            return returnValue;
        }
        /// <summary>
        /// 获取指定日期，在为一年中为第几周
        /// </summary>
        /// <param name="dt">指定时间</param>
        /// <reutrn>返回第几周</reutrn>
        public static int GetWeekOfYear(DateTime dt)
        {
            GregorianCalendar gc = new GregorianCalendar();
            int weekOfYear = gc.GetWeekOfYear(dt, CalendarWeekRule.FirstDay, DayOfWeek.Monday);
            return weekOfYear;
        }
        /// <summary>
        /// 获取实体类的属性名和属性值的键值对
        /// </summary>
        /// <param name="model">实体类</param>
        /// <returns></returns>
        public static Dictionary<string, object> GetKeyValue(Entity model)
        {
            Dictionary<string, object> keyvalue = new Dictionary<string, object>();
            Type type = model.GetType();
            foreach (PropertyInfo pi in type.GetProperties())
            {