///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_Keywords.UO_Keywords parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_Keywords.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.Id != 0 || (extTokens != null && extTokens.ContainsKey(DO_Keywords.Columns.Id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Keywords.Columns.Id, extTokens), DO_Keywords.Columns.Id, parameterObj.Id);
            }
            if (!string.IsNullOrEmpty(parameterObj.Find))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Keywords.Columns.Find, extTokens), DO_Keywords.Columns.Find, parameterObj.Find);
            }
            if (!string.IsNullOrEmpty(parameterObj.Replacement))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Keywords.Columns.Replacement, extTokens), DO_Keywords.Columns.Replacement, parameterObj.Replacement);
            }
            if (!string.IsNullOrEmpty(parameterObj.Editor))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Keywords.Columns.Editor, extTokens), DO_Keywords.Columns.Editor, parameterObj.Editor);
            }
            if (parameterObj.EditTime != DateTime.MinValue)
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Keywords.Columns.EditTime, extTokens), DO_Keywords.Columns.EditTime, parameterObj.EditTime);
            }
            return(objectConditions);
        }
Beispiel #2
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_APIS_Info.UO_APIS_Info parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_APIS_Info.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.Id != 0 || (extTokens != null && extTokens.ContainsKey(DO_APIS_Info.Columns.Id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_APIS_Info.Columns.Id, extTokens), DO_APIS_Info.Columns.Id, parameterObj.Id);
            }
            if (!string.IsNullOrEmpty(parameterObj.Country))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_APIS_Info.Columns.Country, extTokens), DO_APIS_Info.Columns.Country, parameterObj.Country);
            }
            if (!string.IsNullOrEmpty(parameterObj.Airlines))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_APIS_Info.Columns.Airlines, extTokens), DO_APIS_Info.Columns.Airlines, parameterObj.Airlines);
            }
            if (!string.IsNullOrEmpty(parameterObj.CreateBy))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_APIS_Info.Columns.CreateBy, extTokens), DO_APIS_Info.Columns.CreateBy, parameterObj.CreateBy);
            }
            if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_APIS_Info.Columns.UpdateBy, extTokens), DO_APIS_Info.Columns.UpdateBy, parameterObj.UpdateBy);
            }
            return(objectConditions);
        }
		///<summary>
		///Get conditions by object with Multi-TokenType.
		///</summary>
		public static ParameterCollection GetConditionsByObject(DO_Goods_lable.UO_Goods_lable parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Goods_lable.Columns, TokenTypes> extTokens)
		{
			ParameterCollection objectConditions = new ParameterCollection();
			TokenTypes tt = tokenTypes;
			ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
			if (parameterObj.lableid != 0 || (extTokens != null && extTokens.ContainsKey(DO_Goods_lable.Columns.lableid)))
			{
				objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lableid,extTokens), DO_Goods_lable.Columns.lableid,parameterObj.lableid);
			}
			if (parameterObj.merchantid != 0 || (extTokens != null && extTokens.ContainsKey(DO_Goods_lable.Columns.merchantid)))
			{
				objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.merchantid,extTokens), DO_Goods_lable.Columns.merchantid,parameterObj.merchantid);
			}
			if (!string.IsNullOrEmpty(parameterObj.lablename))
			{
				objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lablename,extTokens), DO_Goods_lable.Columns.lablename,parameterObj.lablename);
			}
			if (!string.IsNullOrEmpty(parameterObj.lablecolor))
			{
				objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lablecolor,extTokens), DO_Goods_lable.Columns.lablecolor,parameterObj.lablecolor);
			}
			if (!string.IsNullOrEmpty(parameterObj.addTime))
			{
				objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.addTime,extTokens), DO_Goods_lable.Columns.addTime,parameterObj.addTime);
			}
			return objectConditions;
		}
Beispiel #4
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_AirfareLastView.UO_AirfareLastView parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareLastView.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.Id != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareLastView.Columns.Id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.Id, extTokens), DO_AirfareLastView.Columns.Id, parameterObj.Id);
            }
            if (!string.IsNullOrEmpty(parameterObj.CompanyCode))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.CompanyCode, extTokens), DO_AirfareLastView.Columns.CompanyCode, parameterObj.CompanyCode);
            }
            if (!string.IsNullOrEmpty(parameterObj.UserCode))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.UserCode, extTokens), DO_AirfareLastView.Columns.UserCode, parameterObj.UserCode);
            }
            if (!string.IsNullOrEmpty(parameterObj.Org))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.Org, extTokens), DO_AirfareLastView.Columns.Org, parameterObj.Org);
            }
            if (!string.IsNullOrEmpty(parameterObj.Dst))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.Dst, extTokens), DO_AirfareLastView.Columns.Dst, parameterObj.Dst);
            }
            if (parameterObj.OWRTOJ != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareLastView.Columns.OWRTOJ)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.OWRTOJ, extTokens), DO_AirfareLastView.Columns.OWRTOJ, parameterObj.OWRTOJ);
            }
            if (!string.IsNullOrEmpty(parameterObj.Airline))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.Airline, extTokens), DO_AirfareLastView.Columns.Airline, parameterObj.Airline);
            }
            if (!string.IsNullOrEmpty(parameterObj.FareCat))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.FareCat, extTokens), DO_AirfareLastView.Columns.FareCat, parameterObj.FareCat);
            }
            if (!string.IsNullOrEmpty(parameterObj.BkgClass))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.BkgClass, extTokens), DO_AirfareLastView.Columns.BkgClass, parameterObj.BkgClass);
            }
            if (!string.IsNullOrEmpty(parameterObj.FareClass))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareLastView.Columns.FareClass, extTokens), DO_AirfareLastView.Columns.FareClass, parameterObj.FareClass);
            }
            return(objectConditions);
        }
Beispiel #5
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareMarkupMode.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.ID != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.ID)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.ID, extTokens), DO_AirfareMarkupMode.Columns.ID, parameterObj.ID);
            }
            if (parameterObj.DetailId != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.DetailId)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.DetailId, extTokens), DO_AirfareMarkupMode.Columns.DetailId, parameterObj.DetailId);
            }
            if (parameterObj.Rank != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Rank)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Rank, extTokens), DO_AirfareMarkupMode.Columns.Rank, parameterObj.Rank);
            }
            if (parameterObj.MarkupBy != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.MarkupBy)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.MarkupBy, extTokens), DO_AirfareMarkupMode.Columns.MarkupBy, parameterObj.MarkupBy);
            }
            if (parameterObj.Amount != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Amount)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Amount, extTokens), DO_AirfareMarkupMode.Columns.Amount, parameterObj.Amount);
            }
            if (parameterObj.Rate != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Rate)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Rate, extTokens), DO_AirfareMarkupMode.Columns.Rate, parameterObj.Rate);
            }
            if (parameterObj.RoundUpBy != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.RoundUpBy)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.RoundUpBy, extTokens), DO_AirfareMarkupMode.Columns.RoundUpBy, parameterObj.RoundUpBy);
            }
            if (!string.IsNullOrEmpty(parameterObj.MarkupByValue))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.MarkupByValue, extTokens), DO_AirfareMarkupMode.Columns.MarkupByValue, parameterObj.MarkupByValue);
            }
            if (!string.IsNullOrEmpty(parameterObj.Description))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Description, extTokens), DO_AirfareMarkupMode.Columns.Description, parameterObj.Description);
            }
            if (parameterObj.AirfareMarkupModeType != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.AirfareMarkupModeType)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.AirfareMarkupModeType, extTokens), DO_AirfareMarkupMode.Columns.AirfareMarkupModeType, parameterObj.AirfareMarkupModeType);
            }
            return(objectConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.String Code)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_ErrorDescrption.Columns.Code, Code);
            return(primaryConditions);
        }
Beispiel #7
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 pay_id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_payment.Columns.pay_id, pay_id);
            return(primaryConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int32 lableid)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Goods_lable.Columns.lableid, lableid);
            return(autoIncrementConditions);
        }
Beispiel #9
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 Id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_APIS_Info.Columns.Id, Id);
            return(primaryConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int64 id)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_User_OrderUser_Log.Columns.id, id);
            return(autoIncrementConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int64 Id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_User_MoneyInOut.Columns.Id, Id);
            return(primaryConditions);
        }
Beispiel #12
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 ID)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_AirfareMarkupMode.Columns.ID, ID);
            return(primaryConditions);
        }
Beispiel #13
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int64 Id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_ArticleCate.Columns.Id, Id);
            return(primaryConditions);
        }
Beispiel #14
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 UId)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_Member.Columns.UId, UId);
            return(primaryConditions);
        }
Beispiel #15
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int32 UId)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_Member.Columns.UId, UId);
            return(autoIncrementConditions);
        }
Beispiel #16
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int32 id)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_profits_qyjl_log.Columns.id, id);
            return(autoIncrementConditions);
        }
Beispiel #17
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_SaleShop_profits_qyjl_log.Columns.id, id);
            return(primaryConditions);
        }
Beispiel #18
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int32 ID)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_AirfareMarkupMode.Columns.ID, ID);
            return(autoIncrementConditions);
        }
Beispiel #19
0
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int32 Id)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_APIS_Info.Columns.Id, Id);
            return(autoIncrementConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int64 id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_User_OrderUser_Log.Columns.id, id);
            return(primaryConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int32 lableid)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Goods_lable.Columns.lableid, lableid);
            return(primaryConditions);
        }
Beispiel #22
0
    private void Delete()
    {
        try
        {
            if (string.IsNullOrEmpty(Request["keys"]))
            {
                JsonSuccess();
            }
            int[] ids = GetParameterArrayInt(Request["keys"], "SaleShop_Member_", ',');
            ParameterCollection conditions = new ParameterCollection();
            conditions.AddCondition(ParameterType.Initial, TokenTypes.In, DO_SaleShop_Member.Columns.UId, ids);

            if (new DO_SaleShop_Member().Delete(conditions) > 0)
            {
                JsonSuccess();
            }
            else
            {
                JsonError("Delete Failure");
            }
        }
        catch (Exception ex)
        {
            JsonError(ex.Message);
        }
    }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsByPrimaryKey(System.Int64 Id)
        {
            ParameterCollection primaryConditions = new ParameterCollection();

            primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Main_AdvertisementsType.Columns.Id, Id);
            return(primaryConditions);
        }
        ///<summary>
        ///Get conditions by primary key.
        ///</summary>
        public static ParameterCollection GetConditionsById(System.Int64 Id)
        {
            ParameterCollection autoIncrementConditions = new ParameterCollection();

            autoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Main_AdvertisementsType.Columns.Id, Id);
            return(autoIncrementConditions);
        }
Beispiel #25
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_DecorationCat.UO_DecorationCat parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_DecorationCat.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.DecorationCatName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_DecorationCat.Columns.DecorationCatName, extTokens), DO_DecorationCat.Columns.DecorationCatName, parameterObj.DecorationCatName);
     }
     if (!string.IsNullOrEmpty(parameterObj.DecorationCatCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_DecorationCat.Columns.DecorationCatCode, extTokens), DO_DecorationCat.Columns.DecorationCatCode, parameterObj.DecorationCatCode);
     }
     if (parameterObj.DecorationCatType != 0 || (extTokens != null && extTokens.ContainsKey(DO_DecorationCat.Columns.DecorationCatType)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_DecorationCat.Columns.DecorationCatType, extTokens), DO_DecorationCat.Columns.DecorationCatType, parameterObj.DecorationCatType);
     }
     return objectConditions;
 }
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_ErrorDescrption.UO_ErrorDescrption parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_ErrorDescrption.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (!string.IsNullOrEmpty(parameterObj.Code))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.Code, extTokens), DO_ErrorDescrption.Columns.Code, parameterObj.Code);
            }
            if (!string.IsNullOrEmpty(parameterObj.Description))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.Description, extTokens), DO_ErrorDescrption.Columns.Description, parameterObj.Description);
            }
            if (!string.IsNullOrEmpty(parameterObj.DescriptionKeywords))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.DescriptionKeywords, extTokens), DO_ErrorDescrption.Columns.DescriptionKeywords, parameterObj.DescriptionKeywords);
            }
            if (parameterObj.DescriptionType != 0 || (extTokens != null && extTokens.ContainsKey(DO_ErrorDescrption.Columns.DescriptionType)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.DescriptionType, extTokens), DO_ErrorDescrption.Columns.DescriptionType, parameterObj.DescriptionType);
            }
            if (!string.IsNullOrEmpty(parameterObj.CreateBy))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.CreateBy, extTokens), DO_ErrorDescrption.Columns.CreateBy, parameterObj.CreateBy);
            }
            if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_ErrorDescrption.Columns.UpdateBy, extTokens), DO_ErrorDescrption.Columns.UpdateBy, parameterObj.UpdateBy);
            }
            return(objectConditions);
        }
Beispiel #27
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_Title.UO_Title parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Title.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.BigDateCode, extTokens), DO_Title.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.TitleCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.TitleCode, extTokens), DO_Title.Columns.TitleCode, parameterObj.TitleCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.TitleName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.TitleName, extTokens), DO_Title.Columns.TitleName, parameterObj.TitleName);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.CreateOn, extTokens), DO_Title.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.CreateBy, extTokens), DO_Title.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.UpdateOn, extTokens), DO_Title.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Title.Columns.UpdateBy, extTokens), DO_Title.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_User_OrderUser_Log.UO_User_OrderUser_Log parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_User_OrderUser_Log.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.id != 0 || (extTokens != null && extTokens.ContainsKey(DO_User_OrderUser_Log.Columns.id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.id, extTokens), DO_User_OrderUser_Log.Columns.id, parameterObj.id);
            }
            if (!string.IsNullOrEmpty(parameterObj.ordersid))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.ordersid, extTokens), DO_User_OrderUser_Log.Columns.ordersid, parameterObj.ordersid);
            }
            if (!string.IsNullOrEmpty(parameterObj.remark))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.remark, extTokens), DO_User_OrderUser_Log.Columns.remark, parameterObj.remark);
            }
            if (!string.IsNullOrEmpty(parameterObj.receivename))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.receivename, extTokens), DO_User_OrderUser_Log.Columns.receivename, parameterObj.receivename);
            }
            if (!string.IsNullOrEmpty(parameterObj.receivetel))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.receivetel, extTokens), DO_User_OrderUser_Log.Columns.receivetel, parameterObj.receivetel);
            }
            if (!string.IsNullOrEmpty(parameterObj.receivemobile))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.receivemobile, extTokens), DO_User_OrderUser_Log.Columns.receivemobile, parameterObj.receivemobile);
            }
            if (!string.IsNullOrEmpty(parameterObj.receivepostcode))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.receivepostcode, extTokens), DO_User_OrderUser_Log.Columns.receivepostcode, parameterObj.receivepostcode);
            }
            if (!string.IsNullOrEmpty(parameterObj.receiveaddress))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.receiveaddress, extTokens), DO_User_OrderUser_Log.Columns.receiveaddress, parameterObj.receiveaddress);
            }
            if (!string.IsNullOrEmpty(parameterObj.adminname))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_User_OrderUser_Log.Columns.adminname, extTokens), DO_User_OrderUser_Log.Columns.adminname, parameterObj.adminname);
            }
            return(objectConditions);
        }
Beispiel #29
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_BigDateJoin.UO_BigDateJoin parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_BigDateJoin.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.Email))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateJoin.Columns.Email, extTokens), DO_BigDateJoin.Columns.Email, parameterObj.Email);
     }
     if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateJoin.Columns.BigDateCode, extTokens), DO_BigDateJoin.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.BigDateName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateJoin.Columns.BigDateName, extTokens), DO_BigDateJoin.Columns.BigDateName, parameterObj.BigDateName);
     }
     if (parameterObj.BigDate != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateJoin.Columns.BigDate, extTokens), DO_BigDateJoin.Columns.BigDate, parameterObj.BigDate);
     }
     return objectConditions;
 }
Beispiel #30
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_MsgLog.UO_MsgLog parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_MsgLog.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.MsgCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.MsgCode, extTokens), DO_MsgLog.Columns.MsgCode, parameterObj.MsgCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.BigDateCode, extTokens), DO_MsgLog.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.MsgTemplateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.MsgTemplateCode, extTokens), DO_MsgLog.Columns.MsgTemplateCode, parameterObj.MsgTemplateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.ReplyMsgCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.ReplyMsgCode, extTokens), DO_MsgLog.Columns.ReplyMsgCode, parameterObj.ReplyMsgCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuesetCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.GuesetCode, extTokens), DO_MsgLog.Columns.GuesetCode, parameterObj.GuesetCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.MsgSubject))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.MsgSubject, extTokens), DO_MsgLog.Columns.MsgSubject, parameterObj.MsgSubject);
     }
     if (!string.IsNullOrEmpty(parameterObj.MsgContent))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.MsgContent, extTokens), DO_MsgLog.Columns.MsgContent, parameterObj.MsgContent);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.CreateOn, extTokens), DO_MsgLog.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.CreateBy, extTokens), DO_MsgLog.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.UpdateOn, extTokens), DO_MsgLog.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_MsgLog.Columns.UpdateBy, extTokens), DO_MsgLog.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
Beispiel #31
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_Decoration.UO_Decoration parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Decoration.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.DecorationCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationCode, extTokens), DO_Decoration.Columns.DecorationCode, parameterObj.DecorationCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.BigDateCode, extTokens), DO_Decoration.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.DecorationCatCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationCatCode, extTokens), DO_Decoration.Columns.DecorationCatCode, parameterObj.DecorationCatCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.DecorationName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationName, extTokens), DO_Decoration.Columns.DecorationName, parameterObj.DecorationName);
     }
     if (parameterObj.DecorationNum != 0 || (extTokens != null && extTokens.ContainsKey(DO_Decoration.Columns.DecorationNum)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationNum, extTokens), DO_Decoration.Columns.DecorationNum, parameterObj.DecorationNum);
     }
     if (parameterObj.DecorationLeft != 0 || (extTokens != null && extTokens.ContainsKey(DO_Decoration.Columns.DecorationLeft)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationLeft, extTokens), DO_Decoration.Columns.DecorationLeft, parameterObj.DecorationLeft);
     }
     if (parameterObj.DecorationTop != 0 || (extTokens != null && extTokens.ContainsKey(DO_Decoration.Columns.DecorationTop)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.DecorationTop, extTokens), DO_Decoration.Columns.DecorationTop, parameterObj.DecorationTop);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.CreateOn, extTokens), DO_Decoration.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.CreateBy, extTokens), DO_Decoration.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.UpdateOn, extTokens), DO_Decoration.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Decoration.Columns.UpdateBy, extTokens), DO_Decoration.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
Beispiel #32
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_Login.UO_Login parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Login.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.LoginEmail))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.LoginEmail, extTokens), DO_Login.Columns.LoginEmail, parameterObj.LoginEmail);
     }
     if (parameterObj.LoginType != 0 || (extTokens != null && extTokens.ContainsKey(DO_Login.Columns.LoginType)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.LoginType, extTokens), DO_Login.Columns.LoginType, parameterObj.LoginType);
     }
     if (!string.IsNullOrEmpty(parameterObj.LoginPassword))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.LoginPassword, extTokens), DO_Login.Columns.LoginPassword, parameterObj.LoginPassword);
     }
     if (!string.IsNullOrEmpty(parameterObj.LoginFirstname))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.LoginFirstname, extTokens), DO_Login.Columns.LoginFirstname, parameterObj.LoginFirstname);
     }
     if (!string.IsNullOrEmpty(parameterObj.LoginLastname))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.LoginLastname, extTokens), DO_Login.Columns.LoginLastname, parameterObj.LoginLastname);
     }
     if (!string.IsNullOrEmpty(parameterObj.CroomName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.CroomName, extTokens), DO_Login.Columns.CroomName, parameterObj.CroomName);
     }
     if (!string.IsNullOrEmpty(parameterObj.BrideName))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.BrideName, extTokens), DO_Login.Columns.BrideName, parameterObj.BrideName);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.CreateOn, extTokens), DO_Login.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.CreateBy, extTokens), DO_Login.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.UpdateOn, extTokens), DO_Login.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Login.Columns.UpdateBy, extTokens), DO_Login.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_Main_AdvertisementsType.UO_Main_AdvertisementsType parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_Main_AdvertisementsType.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.Id != 0 || (extTokens != null && extTokens.ContainsKey(DO_Main_AdvertisementsType.Columns.Id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.Id, extTokens), DO_Main_AdvertisementsType.Columns.Id, parameterObj.Id);
            }
            if (!string.IsNullOrEmpty(parameterObj.Name))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.Name, extTokens), DO_Main_AdvertisementsType.Columns.Name, parameterObj.Name);
            }
            if (parameterObj.Price != 0 || (extTokens != null && extTokens.ContainsKey(DO_Main_AdvertisementsType.Columns.Price)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.Price, extTokens), DO_Main_AdvertisementsType.Columns.Price, parameterObj.Price);
            }
            if (!string.IsNullOrEmpty(parameterObj.ImgUrl))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.ImgUrl, extTokens), DO_Main_AdvertisementsType.Columns.ImgUrl, parameterObj.ImgUrl);
            }
            if (!string.IsNullOrEmpty(parameterObj.Adway))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.Adway, extTokens), DO_Main_AdvertisementsType.Columns.Adway, parameterObj.Adway);
            }
            if (!string.IsNullOrEmpty(parameterObj.DefaultHtmlCode))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.DefaultHtmlCode, extTokens), DO_Main_AdvertisementsType.Columns.DefaultHtmlCode, parameterObj.DefaultHtmlCode);
            }
            if (!string.IsNullOrEmpty(parameterObj.DefaultParameter))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.DefaultParameter, extTokens), DO_Main_AdvertisementsType.Columns.DefaultParameter, parameterObj.DefaultParameter);
            }
            if (parameterObj.EditTime != DateTime.MinValue)
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Main_AdvertisementsType.Columns.EditTime, extTokens), DO_Main_AdvertisementsType.Columns.EditTime, parameterObj.EditTime);
            }
            return(objectConditions);
        }
Beispiel #34
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_SaleShop_profits_qyjl_log.UO_SaleShop_profits_qyjl_log parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_profits_qyjl_log.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.id != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.id, extTokens), DO_SaleShop_profits_qyjl_log.Columns.id, parameterObj.id);
            }
            if (parameterObj.uid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.uid)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.uid, extTokens), DO_SaleShop_profits_qyjl_log.Columns.uid, parameterObj.uid);
            }
            if (!string.IsNullOrEmpty(parameterObj.orderid))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.orderid, extTokens), DO_SaleShop_profits_qyjl_log.Columns.orderid, parameterObj.orderid);
            }
            if (parameterObj.mshopid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.mshopid)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.mshopid, extTokens), DO_SaleShop_profits_qyjl_log.Columns.mshopid, parameterObj.mshopid);
            }
            if (parameterObj.original_price != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.original_price)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.original_price, extTokens), DO_SaleShop_profits_qyjl_log.Columns.original_price, parameterObj.original_price);
            }
            if (parameterObj.profits_price != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.profits_price)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.profits_price, extTokens), DO_SaleShop_profits_qyjl_log.Columns.profits_price, parameterObj.profits_price);
            }
            if (parameterObj.status != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_profits_qyjl_log.Columns.status)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_profits_qyjl_log.Columns.status, extTokens), DO_SaleShop_profits_qyjl_log.Columns.status, parameterObj.status);
            }
            return(objectConditions);
        }
Beispiel #35
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_SaleShop_payment.UO_SaleShop_payment parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_payment.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.pay_id != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_payment.Columns.pay_id)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_id, extTokens), DO_SaleShop_payment.Columns.pay_id, parameterObj.pay_id);
            }
            if (!string.IsNullOrEmpty(parameterObj.pay_name))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_name, extTokens), DO_SaleShop_payment.Columns.pay_name, parameterObj.pay_name);
            }
            if (!string.IsNullOrEmpty(parameterObj.pay_code))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_code, extTokens), DO_SaleShop_payment.Columns.pay_code, parameterObj.pay_code);
            }
            if (!string.IsNullOrEmpty(parameterObj.pay_fee))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_fee, extTokens), DO_SaleShop_payment.Columns.pay_fee, parameterObj.pay_fee);
            }
            if (!string.IsNullOrEmpty(parameterObj.pay_desc))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_desc, extTokens), DO_SaleShop_payment.Columns.pay_desc, parameterObj.pay_desc);
            }
            if (parameterObj.Orderdisplay != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_payment.Columns.Orderdisplay)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.Orderdisplay, extTokens), DO_SaleShop_payment.Columns.Orderdisplay, parameterObj.Orderdisplay);
            }
            if (!string.IsNullOrEmpty(parameterObj.pay_config))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_payment.Columns.pay_config, extTokens), DO_SaleShop_payment.Columns.pay_config, parameterObj.pay_config);
            }
            return(objectConditions);
        }
Beispiel #36
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(string BigDateCode, string Email)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_BigDateDetail.Columns.BigDateCode, BigDateCode);
     primaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, DO_BigDateDetail.Columns.Email, Email);
     return primaryConditions;
 }
Beispiel #37
0
        ///<summary>
        ///Get conditions by object with Multi-TokenType.
        ///</summary>
        public static ParameterCollection GetConditionsByObject(DO_SaleShop_Member.UO_SaleShop_Member parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_Member.Columns, TokenTypes> extTokens)
        {
            ParameterCollection objectConditions = new ParameterCollection();
            TokenTypes          tt = tokenTypes;
            ParameterType       pt = isAnd ? ParameterType.And : ParameterType.Or;

            if (parameterObj.UId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.UId)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.UId, extTokens), DO_SaleShop_Member.Columns.UId, parameterObj.UId);
            }
            if (!string.IsNullOrEmpty(parameterObj.UserName))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.UserName, extTokens), DO_SaleShop_Member.Columns.UserName, parameterObj.UserName);
            }
            if (!string.IsNullOrEmpty(parameterObj.RealName))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.RealName, extTokens), DO_SaleShop_Member.Columns.RealName, parameterObj.RealName);
            }
            if (!string.IsNullOrEmpty(parameterObj.ICON))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.ICON, extTokens), DO_SaleShop_Member.Columns.ICON, parameterObj.ICON);
            }
            if (!string.IsNullOrEmpty(parameterObj.Password))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Password, extTokens), DO_SaleShop_Member.Columns.Password, parameterObj.Password);
            }
            if (parameterObj.Gender != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Gender)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Gender, extTokens), DO_SaleShop_Member.Columns.Gender, parameterObj.Gender);
            }
            if (parameterObj.GroupId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.GroupId)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.GroupId, extTokens), DO_SaleShop_Member.Columns.GroupId, parameterObj.GroupId);
            }
            if (!string.IsNullOrEmpty(parameterObj.Email))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Email, extTokens), DO_SaleShop_Member.Columns.Email, parameterObj.Email);
            }
            if (!string.IsNullOrEmpty(parameterObj.Mobile))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Mobile, extTokens), DO_SaleShop_Member.Columns.Mobile, parameterObj.Mobile);
            }
            if (parameterObj.District != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.District)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.District, extTokens), DO_SaleShop_Member.Columns.District, parameterObj.District);
            }
            if (!string.IsNullOrEmpty(parameterObj.OtherContact))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.OtherContact, extTokens), DO_SaleShop_Member.Columns.OtherContact, parameterObj.OtherContact);
            }
            if (parameterObj.Funds != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Funds)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Funds, extTokens), DO_SaleShop_Member.Columns.Funds, parameterObj.Funds);
            }
            if (parameterObj.frostFunds != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.frostFunds)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.frostFunds, extTokens), DO_SaleShop_Member.Columns.frostFunds, parameterObj.frostFunds);
            }
            if (parameterObj.Referee != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Referee)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Referee, extTokens), DO_SaleShop_Member.Columns.Referee, parameterObj.Referee);
            }
            if (!string.IsNullOrEmpty(parameterObj.LastIP))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.LastIP, extTokens), DO_SaleShop_Member.Columns.LastIP, parameterObj.LastIP);
            }
            if (!string.IsNullOrEmpty(parameterObj.PrevIP))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.PrevIP, extTokens), DO_SaleShop_Member.Columns.PrevIP, parameterObj.PrevIP);
            }
            if (!string.IsNullOrEmpty(parameterObj.RegIP))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.RegIP, extTokens), DO_SaleShop_Member.Columns.RegIP, parameterObj.RegIP);
            }
            if (parameterObj.State != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.State)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.State, extTokens), DO_SaleShop_Member.Columns.State, parameterObj.State);
            }
            if (parameterObj.IsReceiveSms != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.IsReceiveSms)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.IsReceiveSms, extTokens), DO_SaleShop_Member.Columns.IsReceiveSms, parameterObj.IsReceiveSms);
            }
            if (!string.IsNullOrEmpty(parameterObj.Friends))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Friends, extTokens), DO_SaleShop_Member.Columns.Friends, parameterObj.Friends);
            }
            if (!string.IsNullOrEmpty(parameterObj.loginappid))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.loginappid, extTokens), DO_SaleShop_Member.Columns.loginappid, parameterObj.loginappid);
            }
            if (!string.IsNullOrEmpty(parameterObj.idcard))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.idcard, extTokens), DO_SaleShop_Member.Columns.idcard, parameterObj.idcard);
            }
            if (!string.IsNullOrEmpty(parameterObj.linkaddress))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.linkaddress, extTokens), DO_SaleShop_Member.Columns.linkaddress, parameterObj.linkaddress);
            }
            if (!string.IsNullOrEmpty(parameterObj.industry))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.industry, extTokens), DO_SaleShop_Member.Columns.industry, parameterObj.industry);
            }
            if (parameterObj.mshopid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.mshopid)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.mshopid, extTokens), DO_SaleShop_Member.Columns.mshopid, parameterObj.mshopid);
            }
            if (parameterObj.headuid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.headuid)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.headuid, extTokens), DO_SaleShop_Member.Columns.headuid, parameterObj.headuid);
            }
            if (parameterObj.areaid1 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid1)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid1, extTokens), DO_SaleShop_Member.Columns.areaid1, parameterObj.areaid1);
            }
            if (parameterObj.areaid2 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid2)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid2, extTokens), DO_SaleShop_Member.Columns.areaid2, parameterObj.areaid2);
            }
            if (parameterObj.areaid3 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid3)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid3, extTokens), DO_SaleShop_Member.Columns.areaid3, parameterObj.areaid3);
            }
            if (!string.IsNullOrEmpty(parameterObj.paypwd))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.paypwd, extTokens), DO_SaleShop_Member.Columns.paypwd, parameterObj.paypwd);
            }
            if (!string.IsNullOrEmpty(parameterObj.icon_old))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.icon_old, extTokens), DO_SaleShop_Member.Columns.icon_old, parameterObj.icon_old);
            }
            if (parameterObj.experience != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.experience)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.experience, extTokens), DO_SaleShop_Member.Columns.experience, parameterObj.experience);
            }
            if (!string.IsNullOrEmpty(parameterObj.question))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.question, extTokens), DO_SaleShop_Member.Columns.question, parameterObj.question);
            }
            if (!string.IsNullOrEmpty(parameterObj.answer))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.answer, extTokens), DO_SaleShop_Member.Columns.answer, parameterObj.answer);
            }
            if (!string.IsNullOrEmpty(parameterObj.bankNum))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.bankNum, extTokens), DO_SaleShop_Member.Columns.bankNum, parameterObj.bankNum);
            }
            if (!string.IsNullOrEmpty(parameterObj.honourId))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.honourId, extTokens), DO_SaleShop_Member.Columns.honourId, parameterObj.honourId);
            }
            if (parameterObj.gradeId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.gradeId)))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.gradeId, extTokens), DO_SaleShop_Member.Columns.gradeId, parameterObj.gradeId);
            }
            if (!string.IsNullOrEmpty(parameterObj.weixin_openid))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.weixin_openid, extTokens), DO_SaleShop_Member.Columns.weixin_openid, parameterObj.weixin_openid);
            }
            if (!string.IsNullOrEmpty(parameterObj.qq_openid))
            {
                objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.qq_openid, extTokens), DO_SaleShop_Member.Columns.qq_openid, parameterObj.qq_openid);
            }
            return(objectConditions);
        }
Beispiel #38
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(string DecorationCode)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Decoration.Columns.DecorationCode, DecorationCode);
     return primaryConditions;
 }
Beispiel #39
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(string LoginEmail)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Login.Columns.LoginEmail, LoginEmail);
     return primaryConditions;
 }
Beispiel #40
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(string BigDateCode, string MsgTemplateCode)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_MsgTemplate.Columns.BigDateCode, BigDateCode);
     primaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, DO_MsgTemplate.Columns.MsgTemplateCode, MsgTemplateCode);
     return primaryConditions;
 }
Beispiel #41
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_Guest.UO_Guest parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Guest.Columns, TokenTypes> extTokens)
 {
     ParameterCollection objectConditions = new ParameterCollection();
     TokenTypes tt = tokenTypes;
     ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
     if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.BigDateCode, extTokens), DO_Guest.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestCode, extTokens), DO_Guest.Columns.GuestCode, parameterObj.GuestCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.TitleCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.TitleCode, extTokens), DO_Guest.Columns.TitleCode, parameterObj.TitleCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.CategoryCode))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.CategoryCode, extTokens), DO_Guest.Columns.CategoryCode, parameterObj.CategoryCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestQueryWords))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestQueryWords, extTokens), DO_Guest.Columns.GuestQueryWords, parameterObj.GuestQueryWords);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestName_en_us))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestName_en_us, extTokens), DO_Guest.Columns.GuestName_en_us, parameterObj.GuestName_en_us);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestName_zh_tw))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestName_zh_tw, extTokens), DO_Guest.Columns.GuestName_zh_tw, parameterObj.GuestName_zh_tw);
     }
     if (parameterObj.GuestNameFormat != 0 || (extTokens != null && extTokens.ContainsKey(DO_Guest.Columns.GuestNameFormat)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestNameFormat, extTokens), DO_Guest.Columns.GuestNameFormat, parameterObj.GuestNameFormat);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestMobile))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestMobile, extTokens), DO_Guest.Columns.GuestMobile, parameterObj.GuestMobile);
     }
     if (!string.IsNullOrEmpty(parameterObj.GuestEmail))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestEmail, extTokens), DO_Guest.Columns.GuestEmail, parameterObj.GuestEmail);
     }
     if (parameterObj.GuestQuantity != 0 || (extTokens != null && extTokens.ContainsKey(DO_Guest.Columns.GuestQuantity)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestQuantity, extTokens), DO_Guest.Columns.GuestQuantity, parameterObj.GuestQuantity);
     }
     if (parameterObj.IsDeleted != 0 || (extTokens != null && extTokens.ContainsKey(DO_Guest.Columns.IsDeleted)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.IsDeleted, extTokens), DO_Guest.Columns.IsDeleted, parameterObj.IsDeleted);
     }
     if (parameterObj.GuestAttended != 0 || (extTokens != null && extTokens.ContainsKey(DO_Guest.Columns.GuestAttended)))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.GuestAttended, extTokens), DO_Guest.Columns.GuestAttended, parameterObj.GuestAttended);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.CreateOn, extTokens), DO_Guest.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.CreateBy, extTokens), DO_Guest.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.UpdateOn, extTokens), DO_Guest.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_Guest.Columns.UpdateBy, extTokens), DO_Guest.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
Beispiel #42
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(System.String Email)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_BigDateJoin.Columns.Email, Email);
     return primaryConditions;
 }
Beispiel #43
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(System.String BigDateCode, System.String GuestCode)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_GuestJoin.Columns.BigDateCode, BigDateCode);
     primaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, DO_GuestJoin.Columns.GuestCode, GuestCode);
     return primaryConditions;
 }
Beispiel #44
0
 ///<summary>
 ///Get conditions by primary key.
 ///</summary>
 public static ParameterCollection GetConditionsByPrimaryKey(string BigDateCode, string DecorationCode, string GuestCode)
 {
     ParameterCollection primaryConditions = new ParameterCollection();
     primaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, DO_Chair.Columns.BigDateCode, BigDateCode);
     primaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, DO_Chair.Columns.DecorationCode, DecorationCode);
     primaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, DO_Chair.Columns.GuestCode, GuestCode);
     return primaryConditions;
 }