/// <summary> /// 将IDataReader的当前记录读取到ConfigEverydayactivitylegendEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigEverydayactivitylegendEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigEverydayactivitylegendEntity(); obj.RefreshDate = (System.DateTime)reader["RefreshDate"]; obj.LegendCode = (System.Int32)reader["LegendCode"]; obj.LegendDebrisCode = (System.Int32)reader["LegendDebrisCode"]; return(obj); }
private Games.NBall.Entity.Enums.MessageCode RefreshLegendCode() { DateTime date = DateTime.Now.AddDays(1); var count = ConfigEverydayactivitylegendMgr.GetByTime(date.Date); if (count == 0) { int legendCode = 0; int legendDebrisCode = 0; int index = 50; var top5List = ConfigEverydayactivitylegendMgr.GetTop5(date.AddDays(-5), date); if (top5List != null && top5List.Count > 0) { do { var legendLottery = CacheFactory.AppsettingCache.GetAppSettingToInt( Games.NBall.Entity.Enums.EnumAppsetting.RandomLegendDebrisCode, 199); legendCode = CacheFactory.LotteryCache.LotteryByLib(legendLottery); if (legendCode > 0 && top5List.Find(r => r.LegendCode == legendCode) == null) { break; } index--; } while (index > 0); } if (legendCode > 0) { legendDebrisCode = CacheFactory.ItemsdicCache.LotteryTheContractId(legendCode % 100000); if (legendDebrisCode == 0) { return(Entity.Enums.MessageCode.NbParameterError); } } ConfigEverydayactivitylegendEntity entity = new ConfigEverydayactivitylegendEntity(date.Date, legendCode, legendDebrisCode); if (!ConfigEverydayactivitylegendMgr.Insert(entity)) { return(Entity.Enums.MessageCode.NbUpdateFail); } } return(Entity.Enums.MessageCode.Success); }
/// <summary> /// GetById /// </summary> /// <param name="refreshDate">refreshDate</param> /// <returns>ConfigEverydayactivitylegendEntity</returns> /// <remarks>2016/11/7 14:45:32</remarks> public ConfigEverydayactivitylegendEntity GetById(System.DateTime refreshDate) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigEverydayactivitylegend_GetById"); database.AddInParameter(commandWrapper, "@RefreshDate", DbType.Date, refreshDate); ConfigEverydayactivitylegendEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/11/7 14:45:33</remarks> public bool Update(ConfigEverydayactivitylegendEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigEverydayactivitylegend_Update"); database.AddInParameter(commandWrapper, "@RefreshDate", DbType.Date, entity.RefreshDate); database.AddInParameter(commandWrapper, "@LegendCode", DbType.Int32, entity.LegendCode); database.AddInParameter(commandWrapper, "@LegendDebrisCode", DbType.Int32, entity.LegendDebrisCode); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/11/7 14:45:33</remarks> public bool Update(ConfigEverydayactivitylegendEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/11/7 14:45:33</remarks> public bool Insert(ConfigEverydayactivitylegendEntity entity) { return(Insert(entity, null)); }
public static bool Update(ConfigEverydayactivitylegendEntity configEverydayactivitylegendEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigEverydayactivitylegendProvider(zoneId); return(provider.Update(configEverydayactivitylegendEntity, trans)); }