Example #1
0
 ///<summary>
 ///Get conditions by object with Multi-TokenType.
 ///</summary>
 public static ParameterCollection GetConditionsByObject(DO_BigDateDetail.UO_BigDateDetail parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_BigDateDetail.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_BigDateDetail.Columns.BigDateCode, extTokens), DO_BigDateDetail.Columns.BigDateCode, parameterObj.BigDateCode);
     }
     if (!string.IsNullOrEmpty(parameterObj.Email))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateDetail.Columns.Email, extTokens), DO_BigDateDetail.Columns.Email, parameterObj.Email);
     }
     if (parameterObj.CreateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateDetail.Columns.CreateOn, extTokens), DO_BigDateDetail.Columns.CreateOn, parameterObj.CreateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.CreateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateDetail.Columns.CreateBy, extTokens), DO_BigDateDetail.Columns.CreateBy, parameterObj.CreateBy);
     }
     if (parameterObj.UpdateOn != DateTime.MinValue)
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateDetail.Columns.UpdateOn, extTokens), DO_BigDateDetail.Columns.UpdateOn, parameterObj.UpdateOn);
     }
     if (!string.IsNullOrEmpty(parameterObj.UpdateBy))
     {
         objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_BigDateDetail.Columns.UpdateBy, extTokens), DO_BigDateDetail.Columns.UpdateBy, parameterObj.UpdateBy);
     }
     return objectConditions;
 }
Example #2
0
 ///<summary>
 ///Get all records count.
 ///</summary>
 public static int GetAllRecordsCount()
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     return da.GetRecordsCount();
 }
Example #3
0
 ///<summary>
 ///Delete object by primary key(with transation).
 ///</summary>
 public static int Delete(string BigDateCode, string Email, IDbConnection connection, IDbTransaction transaction)
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     return da.Delete(connection, transaction, GetConditionsByPrimaryKey(BigDateCode, Email));
 }
Example #4
0
 ///<summary>
 ///Get all records.
 ///</summary>
 public static DO_BigDateDetail.UOList_BigDateDetail GetAllList()
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     return da.GetAllList();
 }
Example #5
0
 ///<summary>
 ///Get the tokenType of the column of condition query.
 ///</summary>
 private static TokenTypes GetColumnTokenType(TokenTypes defaultTokenType, DO_BigDateDetail.Columns column, Dictionary<DO_BigDateDetail.Columns, TokenTypes> extTokens)
 {
     if (extTokens != null && extTokens.ContainsKey(column))
         return extTokens[column];
     else
         return defaultTokenType;
 }
Example #6
0
 ///<summary>
 ///Delete object by primary key.
 ///</summary>
 public static int Delete(string BigDateCode, string Email)
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     return da.Delete(GetConditionsByPrimaryKey(BigDateCode, Email));
 }
Example #7
0
 ///<summary>
 ///Update object by primary key.
 ///</summary>
 public static bool UpdateObject(DO_BigDateDetail.UO_BigDateDetail obj, string BigDateCode, string Email)
 {
     return obj.Update(GetConditionsByPrimaryKey(BigDateCode, Email)) > 0;
 }
Example #8
0
 ///<summary>
 ///Update object by primary key(with transation).
 ///</summary>
 public static bool UpdateObject(DO_BigDateDetail.UO_BigDateDetail obj, string BigDateCode, string Email, IDbConnection connection, IDbTransaction transaction)
 {
     return obj.Update(connection, transaction, GetConditionsByPrimaryKey(BigDateCode, Email)) > 0;
 }
Example #9
0
 ///<summary>
 ///Get records count.
 ///</summary>
 public static int GetRecordsCount(DO_BigDateDetail.UO_BigDateDetail parameterObj)
 {
     return GetRecordsCount(parameterObj, true, TokenTypes.Equal, null);
 }
Example #10
0
 ///<summary>
 ///Get records count.
 ///</summary>
 public static int GetRecordsCount(DO_BigDateDetail.UO_BigDateDetail parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_BigDateDetail.Columns, TokenTypes> extTokens)
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     return da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));
 }
Example #11
0
 ///<summary>
 ///Get paging list.
 ///</summary>
 public static PagingResult<DO_BigDateDetail.UO_BigDateDetail, DO_BigDateDetail.UOList_BigDateDetail> GetPagingList(DO_BigDateDetail.UO_BigDateDetail parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc)
 {
     return parameterObj.GetPagingList(GetConditionsByObject(parameterObj, true, TokenTypes.Like, null), pageNumber, pageSize, sortBy, isAsc);
 }
Example #12
0
 ///<summary>
 ///Get paging list.
 ///</summary>
 public static PagingResult<DO_BigDateDetail.UO_BigDateDetail, DO_BigDateDetail.UOList_BigDateDetail> GetPagingList(DO_BigDateDetail.UO_BigDateDetail parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_BigDateDetail.Columns, TokenTypes> extTokens)
 {
     return parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens), pageNumber, pageSize, sortBy, isAsc);
 }
Example #13
0
 ///<summary>
 ///Get object by primary key.
 ///</summary>
 public static DO_BigDateDetail.UO_BigDateDetail GetObject(string BigDateCode, string Email)
 {
     DO_BigDateDetail da = new DO_BigDateDetail();
     DO_BigDateDetail.UOList_BigDateDetail l = da.GetList(GetConditionsByPrimaryKey(BigDateCode, Email));
     return l.Count > 0 ? l[0] : null;
 }
Example #14
0
 ///<summary>
 ///Get list by object.
 ///</summary>
 public static DO_BigDateDetail.UOList_BigDateDetail GetList(DO_BigDateDetail.UO_BigDateDetail parameterObj)
 {
     return GetList(parameterObj, true, TokenTypes.Equal, null);
 }
Example #15
0
 ///<summary>
 ///Get list by object.
 ///</summary>
 public static DO_BigDateDetail.UOList_BigDateDetail GetList(DO_BigDateDetail.UO_BigDateDetail parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_BigDateDetail.Columns, TokenTypes> extTokens)
 {
     return parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));
 }