///<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); }
///<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; }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
///<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); }
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); }
///<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); }
///<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); }
///<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; }
///<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; }
///<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; }
///<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); }
///<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); }
///<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); }
///<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; }
///<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); }
///<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; }
///<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; }
///<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; }
///<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; }
///<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; }
///<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; }
///<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; }