///<summary>
///Get all records count.
///</summary>
public static int GetAllRecordsCount()
{
DO_GuestJoin da = new DO_GuestJoin();
return da.GetRecordsCount();
}
///<summary>
///Get conditions by object with Multi-TokenType.
///</summary>
public static ParameterCollection GetConditionsByObject(DO_GuestJoin.UO_GuestJoin parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_GuestJoin.Columns, TokenTypes> extTokens)
{
ParameterCollection objectConditions = new ParameterCollection();
TokenTypes tt = tokenTypes;
ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
if (!string.IsNullOrEmpty(parameterObj.TitleName))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.TitleName, extTokens), DO_GuestJoin.Columns.TitleName, parameterObj.TitleName);
}
if (!string.IsNullOrEmpty(parameterObj.CategoryName))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.CategoryName, extTokens), DO_GuestJoin.Columns.CategoryName, parameterObj.CategoryName);
}
if (!string.IsNullOrEmpty(parameterObj.BigDateCode))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.BigDateCode, extTokens), DO_GuestJoin.Columns.BigDateCode, parameterObj.BigDateCode);
}
if (!string.IsNullOrEmpty(parameterObj.GuestCode))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestCode, extTokens), DO_GuestJoin.Columns.GuestCode, parameterObj.GuestCode);
}
if (!string.IsNullOrEmpty(parameterObj.TitleCode))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.TitleCode, extTokens), DO_GuestJoin.Columns.TitleCode, parameterObj.TitleCode);
}
if (!string.IsNullOrEmpty(parameterObj.CategoryCode))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.CategoryCode, extTokens), DO_GuestJoin.Columns.CategoryCode, parameterObj.CategoryCode);
}
if (!string.IsNullOrEmpty(parameterObj.GuestQueryWords))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestQueryWords, extTokens), DO_GuestJoin.Columns.GuestQueryWords, parameterObj.GuestQueryWords);
}
if (!string.IsNullOrEmpty(parameterObj.GuestName_en_us))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestName_en_us, extTokens), DO_GuestJoin.Columns.GuestName_en_us, parameterObj.GuestName_en_us);
}
if (!string.IsNullOrEmpty(parameterObj.GuestName_zh_tw))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestName_zh_tw, extTokens), DO_GuestJoin.Columns.GuestName_zh_tw, parameterObj.GuestName_zh_tw);
}
if (parameterObj.GuestNameFormat != 0 || (extTokens != null && extTokens.ContainsKey(DO_GuestJoin.Columns.GuestNameFormat)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestNameFormat, extTokens), DO_GuestJoin.Columns.GuestNameFormat, parameterObj.GuestNameFormat);
}
if (!string.IsNullOrEmpty(parameterObj.GuestMobile))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestMobile, extTokens), DO_GuestJoin.Columns.GuestMobile, parameterObj.GuestMobile);
}
if (!string.IsNullOrEmpty(parameterObj.GuestEmail))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestEmail, extTokens), DO_GuestJoin.Columns.GuestEmail, parameterObj.GuestEmail);
}
if (parameterObj.GuestQuantity != 0 || (extTokens != null && extTokens.ContainsKey(DO_GuestJoin.Columns.GuestQuantity)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestQuantity, extTokens), DO_GuestJoin.Columns.GuestQuantity, parameterObj.GuestQuantity);
}
if (parameterObj.GuestAttended != 0 || (extTokens != null && extTokens.ContainsKey(DO_GuestJoin.Columns.GuestAttended)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.GuestAttended, extTokens), DO_GuestJoin.Columns.GuestAttended, parameterObj.GuestAttended);
}
if (parameterObj.CreateOn != DateTime.MinValue)
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.CreateOn, extTokens), DO_GuestJoin.Columns.CreateOn, parameterObj.CreateOn);
}
if (!string.IsNullOrEmpty(parameterObj.CreateBy))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.CreateBy, extTokens), DO_GuestJoin.Columns.CreateBy, parameterObj.CreateBy);
}
if (parameterObj.UpdateOn != DateTime.MinValue)
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.UpdateOn, extTokens), DO_GuestJoin.Columns.UpdateOn, parameterObj.UpdateOn);
}
if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_GuestJoin.Columns.UpdateBy, extTokens), DO_GuestJoin.Columns.UpdateBy, parameterObj.UpdateBy);
}
return objectConditions;
}
///<summary>
///Get the tokenType of the column of condition query.
///</summary>
private static TokenTypes GetColumnTokenType(TokenTypes defaultTokenType, DO_GuestJoin.Columns column, Dictionary<DO_GuestJoin.Columns, TokenTypes> extTokens)
{
if (extTokens != null && extTokens.ContainsKey(column))
return extTokens[column];
else
return defaultTokenType;
}
///<summary>
///Get all records.
///</summary>
public static DO_GuestJoin.UOList_GuestJoin GetAllList()
{
DO_GuestJoin da = new DO_GuestJoin();
return da.GetAllList();
}
///<summary>
///Get records count.
///</summary>
public static int GetRecordsCount(DO_GuestJoin.UO_GuestJoin parameterObj)
{
return GetRecordsCount(parameterObj, true, TokenTypes.Equal, null);
}
///<summary>
///Get records count.
///</summary>
public static int GetRecordsCount(DO_GuestJoin.UO_GuestJoin parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_GuestJoin.Columns, TokenTypes> extTokens)
{
DO_GuestJoin da = new DO_GuestJoin();
return da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));
}
///<summary>
///Get paging list.
///</summary>
public static PagingResult<DO_GuestJoin.UO_GuestJoin, DO_GuestJoin.UOList_GuestJoin> GetPagingList(DO_GuestJoin.UO_GuestJoin parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc)
{
return parameterObj.GetPagingList(GetConditionsByObject(parameterObj, true, TokenTypes.Like, null), pageNumber, pageSize, sortBy, isAsc);
}
///<summary>
///Get paging list.
///</summary>
public static PagingResult<DO_GuestJoin.UO_GuestJoin, DO_GuestJoin.UOList_GuestJoin> GetPagingList(DO_GuestJoin.UO_GuestJoin parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_GuestJoin.Columns, TokenTypes> extTokens)
{
return parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens), pageNumber, pageSize, sortBy, isAsc);
}
///<summary>
///Get object by primary key.
///</summary>
public static DO_GuestJoin.UO_GuestJoin GetObject(System.String BigDateCode, System.String GuestCode)
{
DO_GuestJoin da = new DO_GuestJoin();
DO_GuestJoin.UOList_GuestJoin l = da.GetList(GetConditionsByPrimaryKey(BigDateCode, GuestCode));
return l.Count > 0 ? l[0] : null;
}
///<summary>
///Get list by object.
///</summary>
public static DO_GuestJoin.UOList_GuestJoin GetList(DO_GuestJoin.UO_GuestJoin parameterObj)
{
return GetList(parameterObj, true, TokenTypes.Equal, null);
}
///<summary>
///Get list by object.
///</summary>
public static DO_GuestJoin.UOList_GuestJoin GetList(DO_GuestJoin.UO_GuestJoin parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_GuestJoin.Columns, TokenTypes> extTokens)
{
return parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));
}
