/// <summary> /// 欄位值為 NULL /// </summary> /// <typeparam name="TSource"></typeparam> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <param name="exp"></param> /// <returns></returns> public static TSource IsNull <TSource, T>(this TSource model, Expression <Func <TSource, T> > exp) where TSource : IDBEntity { OperatingField field = new OperatingField() { COLUMN_NAME = ((MemberExpression)exp.Body).Member.Name, OPERATOR = "IS", VALUE = "NULL" }; model.GetOperating().WHERE_LIST.Add(field); return(model); }
//==================================================================== //條件式 //==================================================================== /// <summary> /// /// </summary> /// <typeparam name="TSource"></typeparam> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <param name="exp"></param> /// <param name="OPERATOR"></param> /// <param name="value"></param> /// <returns></returns> private static TSource AddWhereOperating <TSource, T>( this TSource model, Expression <Func <TSource, T> > exp, string OPERATOR, T value) where TSource : IDBEntity { OperatingField field = new OperatingField() { COLUMN_NAME = ((MemberExpression)exp.Body).Member.Name, OPERATOR = OPERATOR, VALUE = value }; model.GetOperating().WHERE_LIST.Add(field); return(model); }