public Starter(DbReader dbr) { RaceId = dbr.GetValue<int>("RACE_ID"); TrackCode = dbr.GetValue<string>("TRACK_CODE").Trim(); Date = dbr.GetValue<string>("RACING_DATE"); HorseName = dbr.GetValue<string>("HORSE_NAME").Trim(); WasTheFavorite = (1 == dbr.GetValue<int>("WAS_THE_FAVORITE")); Odds = dbr.GetValue<double>("ODDS"); Distance = dbr.GetValue<double>("DISTANCE"); Surface = dbr.GetValue<string>("SURFACE").Trim(); Jockey = dbr.GetValue<string>("ABBR_JOCKEY_NAME").Trim(); FinishPosition = dbr.GetValue<int>("FINISH_POSITION"); AbbrRaceClass = dbr.GetValue<string>("ABBR_RACE_CLASS").Trim(); AgeSexRestrictions = dbr.GetValue<string>("AGE_SEX_RESTRICTIONS").Trim(); StateBredFlag = dbr.GetValue<string>("STATE_BRED_FLAG").Trim(); RaceGrade = dbr.GetValue<int>("RACE_GRADE"); RaceName = dbr.GetValue<string>("RACE_NAME").Trim(); RaceNumber = dbr.GetValue<int>("RACE_NUMBER"); ProgramNumber = dbr.GetValue<string>("PROGRAM_NUMBER").Trim(); BrisRaceTypeDescription = dbr.GetValue<string>("BRIS_RACE_TYPE").Trim(); FactorsFlag = dbr.GetValue<long>("FACTORS_FLAG"); FieldSize = dbr.GetValue<int>("FIELD_SIZE"); if(AbbrRaceClass.Length > 20) { AbbrRaceClass = AbbrRaceClass.Substring(0, 19); } }
private void LoadSurfaceComboBox() { _cbSurface.Items.Clear(); string trackCode = CurrentTrackCode.Trim(); if (trackCode.Length <= 0) return; using (var dbr = new DbReader()) { if (dbr.Open(string.Format(@"select distinct(surface COLLATE SQL_Latin1_General_CP1_CS_AS) 'surface' from race_description where track_code='{0}'", trackCode))) { while (dbr.MoveToNextRow()) { _cbSurface.Items.Add(dbr.GetValue<string>("surface")); } } } if (_cbSurface.Items.Count > 0) { _cbSurface.SelectedIndex = 0; } }
private void LoadCurrentRaceInfo(DateTime date, string trackCode, int raceNumber) { _currentRaceInfo = null; string sql = string.Format( @"SELECT RACE_ID, DISTANCE, ABOUT_DISTANCE_FLAG, SURFACE, TRACK_CODE, TRACK_CONDITION FROM RACE_DESCRIPTION WHERE DATE_OF_THE_RACE = '{0}' AND TRACK_CODE = '{1}' AND RACE_NUMBER = {2}", Utilities.GetDateInYYYYMMDD(date), trackCode, raceNumber); using (var dbr = new DbReader()) { if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { _currentRaceInfo = new RaceInfo(); _currentRaceInfo.AboutFlag = dbr.GetValue<string>("ABOUT_DISTANCE_FLAG"); _currentRaceInfo.Distance = dbr.GetValue<double>("DISTANCE"); _currentRaceInfo.RaceId = dbr.GetValue<int>("RACE_ID"); _currentRaceInfo.Surface = dbr.GetValue<string>("SURFACE"); _currentRaceInfo.TrackCondition = dbr.GetValue<string>("TRACK_CONDITION"); _currentRaceInfo.TrackCode = trackCode; } } } }
public void Populate(DbReader dbr) { BitMask = dbr.GetValue<long>("BIT_MASK"); Name = dbr.GetValue<string>("FACTOR_NAME"); Starters = Winners = TotalFieldSize = 0; TotalWinPayoff = 0.0; }
public void Populate(DbReader dbr) { TrackDesc = dbr.GetValue<string>("track_desc"); Surface = dbr.GetValue<string>("surface"); HorseName = dbr.GetValue<string>("horse_name"); TrackCode = dbr.GetValue<string>("track_code"); ProjectedTime = dbr.GetValue<double>("ThisHorseProjectedTime"); }
public void Populate(DbReader dbr) { FactorsFlag = dbr.GetValue<long>("FACTORS_FLAG"); WinPayoff = dbr.GetValue<double>("WIN_PAYOFF"); FieldSize = dbr.GetValue<int>("FIELD_SIZE"); Trainer = dbr.GetValue<string>("ABBR_TRAINER_NAME"); Jockey = dbr.GetValue<string>("ABBR_JOCKEY_NAME"); }
public void Populate(DbReader dbr) { BitMask = dbr.GetValue<long>("BIT_MASK"); Name = dbr.GetValue<string>("FACTOR_NAME").Trim(); Starters = dbr.GetValue<int>("NUMBER_OF_STARTERS"); Winners = dbr.GetValue<int>("NUMBER_OF_WINNERS"); Roi = dbr.GetValue<double>("ROI"); IV = dbr.GetValue<double>("IV"); }
public void Populate(DbReader dbr) { FinalRaceId = dbr.GetValue<int>("ID"); TrackCode = dbr.GetValue<string>("TRACK_CODE"); RacingDate = dbr.GetValue<string>("RACING_DATE"); RaceNumber = dbr.GetValue<int>("RACE_NUMBER"); Bet = dbr.GetValue<double>("BET_AMOUNT"); Payoff = dbr.GetValue<double>("PAYOFF_AMOUNT"); Pool = dbr.GetValue<double>("WAGER_POOL"); }
public void Populate(DbReader dbr) { PostPosition = dbr.GetValue<int>("PostPosition"); Starters = dbr.GetValue<int>("StartersForPP"); WinPercent = dbr.GetValue<double>("WinPercent"); IV = dbr.GetValue<double>("WinnersIV"); W2WWinPercent = dbr.GetValue<double>("W2WWinPercent"); W2WWinners = dbr.GetValue<int>("TotalW2WWinners"); NumberOfRaces = dbr.GetValue<int>("numberOfRaces"); }
public PaceFigure(DbReader dbr) { RaceId = dbr.GetValue<int>("raceid"); RaceClassification = dbr.GetValue<string>("raceClassification"); DateOfTheRace = dbr.GetValue<string>("dateOfTheRace"); TrackCondition = dbr.GetValue<string>("trackCondition"); RaceNumber = dbr.GetValue<int>("raceNumber"); Call1 = dbr.GetValue<int>("figure1"); Call2 = dbr.GetValue<int>("figure2"); FinalCall = dbr.GetValue<int>("finalTime"); }
public void Populate(DbReader dbr) { HorseName = dbr.GetValue<string>("horse_name"); RaceId = dbr.GetValue<int>("race_id"); Date = dbr.GetValue<string>("RACING_DATE"); FinishPosition = dbr.GetValue<int>("finish_position"); Distance = dbr.GetValue<double>("DISTANCE"); Surface = dbr.GetValue<string>("surface"); TrackCondition = dbr.GetValue<string>("track_condition"); WinnersFinalTime = dbr.GetValue<double>("final_time"); ThisHorseTime = dbr.GetValue<double>("thisHorseTime"); WinnersAdjustedTime = dbr.GetValue<double>("projectedTime"); ThisHorseProjectedTime = dbr.GetValue<double>("thisHorseProjectedTime"); }
private Sire(DbReader dbr) { _name = dbr.GetValue<string>("NAME"); _country = dbr.GetValue<string>("COUNTRY"); _yearOfBirth = dbr.GetValue<int>("YEAR_OF_BIRTH"); _spi = dbr.GetValue<double>("SPI"); _firstTimeStarters = dbr.GetValue<string>("FIRST_TIME_STARTERS"); _mudStarters = dbr.GetValue<string>("MUD_STARTERS"); _turfStarters = dbr.GetValue<string>("TURF_STARTERS"); _allweatherStarters = dbr.GetValue<string>("ALL_WEATHER_STARTERS"); _averageWinningDistance = dbr.GetValue<string>("AVG_WINNING_DISTANCE"); _distance = dbr.GetValue<string>("DISTANCE"); _state = dbr.GetValue<string>("STATE"); }
static void ReadTable <T>(SQLiteHelper dbHelper) where T : class, new() { var datas = DbReader.Read <T>(dbHelper); if (datas == null) { return; } foreach (var d in datas) { Debug.Log(JsonUtility.ToJson(d)); } }
public IDictionary <TKey, int> GroupbyCount <TKey>(Expression <Func <T, object> > field) { var parameters = CreateParamterCollection(); string sql = new Queryable <T>(DbReader) .Select(field) .Count(field) .GroupBy(field) .OutputSqlString(parameters); using (var reader = DbReader.ExecuteReader(sql, parameters)) { return(reader.ToDictionary <TKey, int>()); } }
public RaceInfo(DbReader dbr) { _raceID = dbr.GetValue<int>("RACE_ID"); _raceNumber = dbr.GetValue<int>("race_number"); _distance = dbr.GetValue<double>("DISTANCE"); _surface = dbr.GetValue<string>("surface"); _surface = dbr.GetValue<string>("surface"); _age_sex_restrictions = dbr.GetValue<string>("age_sex_restrictions"); _state_bred_flag = dbr.GetValue<string>("state_bred_flag"); _abbr_race_class = dbr.GetValue<string>("abbr_race_class"); _race_conditions = dbr.GetValue<string>("race_conditions"); _raceGrade = dbr.GetValue<int>("race_grade"); _raceName = dbr.GetValue<string>("race_name"); }
public void SaveModified(DbReader db) { //log.InfoFormat("SaveModified() called"); lock (syncObject) { foreach (var wrapper in this) { if (wrapper.Value.Changed && wrapper.Value.Data != null) { db.Save(wrapper.Value.Data); wrapper.Value.Changed = false; } } } }
public IDictionary <TKey, TValue> GroupbyAvg <TKey, TValue>(Expression <Func <T, object> > keyField, Expression <Func <T, object> > valueField) { var parameters = CreateParamterCollection(); string sql = new Queryable <T>(DbReader) .Select(keyField) .Avg(valueField) .GroupBy(keyField) .OutputSqlString(parameters); using (var reader = DbReader.ExecuteReader(sql, parameters)) { return(reader.ToDictionary <TKey, TValue>()); } }
public async Task <IEnumerable <ImportMetadata> > GetAllImportMetadataAsync() { using (var cn = new SqlConnection(dbOptions.ConnectionString)) { var grid = await cn.QueryMultipleAsync( Sql.GetAllMetadata, new { user = user.UUID, groups = GroupMembership.From(user), admin = user.IsAdmin }, commandType : CommandType.StoredProcedure, commandTimeout : dbOptions.DefaultTimeout ); var metas = DbReader.ReadMany(grid); return(metas); } }
public void Populate(DbReader dbr) { TrackCode = dbr.GetValue<string>("track_code"); Surface = dbr.GetValue<string>("surface"); FinalTime = dbr.GetValue<double>("FINAL_TIME"); Distance = dbr.GetValue<double>("DISTANCE"); Speed = dbr.GetValue<double>("SPEED"); NumberOfRaces = dbr.GetValue<int>("COUNTER"); string s = Surface; if (s == "t" || s == "d") { s = "i" + s; } TrackDesc = string.Format("{0}_{1}", TrackCode.Trim(), s); }
public async Task <AdminDatasetQuery> GetDatasetQueryByIdAsync(Guid id) { using (var cn = new SqlConnection(opts.ConnectionString)) { await cn.OpenAsync(); var grid = await cn.QueryMultipleAsync( Sql.GetById, new { id }, commandType : CommandType.StoredProcedure, commandTimeout : opts.DefaultTimeout); return(DbReader.Read(grid)); } }
public static bool RaceExistsInDb(string trackCode, DateTime date, int raceNumber) { int count = 0; using (var dbr = new DbReader()) { string sql = string.Format("SELECT COUNT(*) 'COUNTER' FROM RACE_DESCRIPTION WHERE TRACK_CODE = '{0}' AND DATE_OF_THE_RACE = '{1}' AND RACE_NUMBER = {2} ", trackCode, Utilities.GetDateInYYYYMMDD(date), raceNumber); if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { count = dbr.GetValue<int>("COUNTER"); } } } return count > 0; }
private HorseInfo(DbReader dbr) { _raceid = dbr.GetValue<int>("RACE_ID"); _trackCode= dbr.GetValue<string>("TRACK_CODE").Trim().ToUpper(); _date = Utilities.MakeDateTime(dbr.GetValue<string>("DATE")); _raceNumber = dbr.GetValue<int>("RACE"); _horseName= dbr.GetValue<string>("NAME"); _finishPosition = dbr.GetValue<int>("POS"); _distance = dbr.GetValue<double>("DIST"); _odds = dbr.GetValue<double>("ODDS"); _surface= dbr.GetValue<string>("SUR"); _raceClassification = dbr.GetValue<string>("CLASS"); _offTurfIndicator = dbr.GetValue<string>("OFF"); _trainer = dbr.GetValue<string>("TRAINER"); _raceClassificationAbrv = MakeClassAbr(_raceClassification); }
private void Load() { string sql = string.Format("exec GetSummarizedStatsForTrainer '{0}'", Name); using (var dbr = new DbReader()) { if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { StartersCount = dbr.GetValue<int>("STARTERS"); WinPercent = dbr.GetValue<double>("WIN_PERCENT"); ROI = dbr.GetValue<double>("ROI"); IV = dbr.GetValue<double>("IV"); } } } }
private bool _isDisposed = false; // To detect redundant calls protected virtual void Dispose(bool disposing) { if (_isDisposed) { return; } if (disposing) { // TODO: dispose managed state (managed objects). DbReader?.Dispose(); } // TODO: free unmanaged resources (unmanaged objects) and override a finalizer below. // TODO: set large fields to null. _isDisposed = true; }
public static string Getcheckpoint() { DbReader objReader = null; sSql = new StringBuilder(); sSql.Append("SELECT MAX(CHECK_POINT) FROM VP_CHECKPOINT"); objReader = DbFactory.GetDbReader(ConnectionString, sSql.ToString()); if (objReader != null) { while (objReader.Read()) { CHECK_POINT = Conversion.ConvertObjToStr(objReader.GetValue(0)); } } return(CHECK_POINT); }
/// <summary> /// 根据唯一ID获取对象,返回实体 /// </summary> /// <param name="where">条件</param> /// <param name="param">参数化</param> /// <returns>返回实体类</returns> public T GetModelById <T>(StringBuilder where, SqlParam[] param) { this.GetInstance(); T model = Activator.CreateInstance <T>(); Type type = model.GetType(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM " + type.Name + " WHERE 1=1"); strSql.Append(where); DataTable dt = db.GetDataTableBySQL(strSql, param); if (dt.Rows.Count > 0) { return(DbReader.ReaderToModel <T>(dt.Rows[0])); } return(model); }
public List <Tuple <object, string> > SelectProcess(DbReader <SqlDataReader> reader) { var fields = new List <Tuple <object, string> >(); for (int i = 0; i < reader.CountFields(); i++) { var name = reader.Reader.GetName(i).Split('.').ToList().Last(); var v = reader.GetValue(i); if (v is DBNull) { v = null; } fields.Add(new Tuple <object, string>(v, name)); } return(fields); }
private WinnerInfo(DbReader dbr) { _date = Utilities.MakeDateTime(dbr.GetValue<string>("DATE_OF_THE_RACE")); _raceNumber = dbr.GetValue<int>("RACE_NUMBER"); _surface = dbr.GetValue<string>("SURFACE"); _aboutDistanceFlag = dbr.GetValue<string>("ABOUT_DISTANCE_FLAG"); _trackCondition = dbr.GetValue<string>("TRACK_CONDITION"); _abbrRaceClass = dbr.GetValue<string>("ABBR_RACE_CLASS"); _horseName = dbr.GetValue<string>("HORSE_NAME"); _fraction1 = dbr.GetValue<double>("TIME_FOR_FRACTION_1"); _fraction2 = dbr.GetValue<double>("TIME_FOR_FRACTION_2"); _fraction3 = dbr.GetValue<double>("TIME_FOR_FRACTION_3"); _finalTime = dbr.GetValue<double>("FINAL_TIME"); _raceId = dbr.GetValue<int>("RACE_ID"); _stateBredFlag = dbr.GetValue<string>("STATE_BRED_FLAG"); _ageSexRestrictions = dbr.GetValue<string>("AGE_SEX_RESTRICTIONS"); _raceGrade = dbr.GetValue<int>("RACE_GRADE"); }
private static void Load(UnityModManager.ModEntry modEntry) { settings = Settings.Load <Settings>(modEntry); SqliteDataReader reader = LocalDb.cur.ReadFullTable("Synthesis_table "); var sourceData = DbReader.Read <CompoundItemData>(reader, 20); templateData = sourceData.Find((CompoundItemData c) => c.ItemID == 2000046); modEntry.OnToggle = OnToggle; modEntry.OnGUI = OnGUI; modEntry.OnSaveGUI = OnSaveGUI; modEntry.OnUpdate = OnUpdate; var harmony = HarmonyInstance.Create(modEntry.Info.Id); harmony.PatchAll(Assembly.GetExecutingAssembly()); }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="KeyValue">主键</param> /// <returns></returns> public BPMS_DataPermission GetEntity(StringBuilder where, SqlParam[] param) { BPMS_DataPermission entity = new BPMS_DataPermission(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM BPMS_DataPermission WHERE 1=1"); strSql.Append(where); DataTable dt = DataFactory.SqlHelper().GetDataTableBySQL(strSql, param); if (dt.Rows.Count > 0) { return(DbReader.ReaderToModel <BPMS_DataPermission>(dt.Rows[0])); } else { return(entity); } }
static void LoadTrainers() { _trainerIds = new Dictionary<string, int>(); using (var dbr = new DbReader()) { if (dbr.Open("select TRAINER_ID, ABBR_TRAINER_NAME FROM TRAINERS")) { while (dbr.MoveToNextRow()) { int id = dbr.GetValue<int>("TRAINER_ID"); string name = dbr.GetValue<string>("ABBR_TRAINER_NAME"); _trainerIds.Add(name.ToUpper().Trim(),id); } } } }
/// <summary> /// 获取aspx页面 服务器控件值,返回实体类 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="page"></param> /// <returns></returns> public static T GetWebControls <T>(Control page) { Hashtable ht = GetWebControls(page); T model = Activator.CreateInstance <T>(); Type type = model.GetType(); //遍历每一个属性 foreach (PropertyInfo prop in type.GetProperties()) { object value = ht[prop.Name]; if (prop.PropertyType.ToString() == "System.Nullable`1[System.DateTime]") { value = CommonHelper.ToDateTime(value); } prop.SetValue(model, DbReader.HackType(value, prop.PropertyType), null); } return(model); }
public StarterInfo(int raceid, string horseName) { _existsInTheDb = false; using (var dbr = new DbReader()) { string sql = string.Format(@"EXEC GetHorseFractions {0}, '{1}' ", raceid, horseName); if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { _fraction1 = dbr.GetValue<double>("CALL_1"); _fraction2 = dbr.GetValue<double>("CALL_2"); _fraction3 = dbr.GetValue<double>("CALL_3"); _finalTime = dbr.GetValue<double>("FINAL_CALL"); _existsInTheDb = true; } } } }
public void GetElements() { Console.Write("Begin Get Elemtents Test..."); DbReader his = new DbReader(); IArgument[] arguments = new IArgument[1]; arguments[0] = new Argument("DbPath", @"..\data\cuahsi-his\demo.db", true, "Database"); his.Initialize(arguments); for (int i = 0; i < his.OutputExchangeItemCount; ++i) { IElementSet es = his.GetOutputExchangeItem(i).ElementSet; for (int j = 0; j < es.ElementCount; ++j) { Console.WriteLine(es.GetXCoordinate(j, 0).ToString() + ", " + es.GetYCoordinate(j, 0).ToString()); } } Console.WriteLine("model description: " + his.ModelDescription); }
public JockeyStarter(DbReader dbr) { _raceID = dbr.GetValue<int>("RACE_ID"); _trackCode = dbr.GetValue<string>("TRACK_CODE"); _date = Utilities.MakeDateTime(dbr.GetValue<string>("RACING_DATE")); _horseName = dbr.GetValue<string>("HORSE_NAME"); _trainer = dbr.GetValue<string>("ABBR_TRAINER_NAME"); _owner = dbr.GetValue<string>("OWNER_NAME"); _wasTheFavorite = (1 == dbr.GetValue<int>("FAVORITE_FLAG")); _odds = dbr.GetValue<double>("ODDS"); _winPayoff = dbr.GetValue<double>("WIN_PAYOFF"); _surface = dbr.GetValue<string>("SURFACE"); _distanceInYards = dbr.GetValue<double>("DISTANCE"); _postPosition = dbr.GetValue<int>("POST_POSITION"); _trackCondition = dbr.GetValue<string>("TRACK_CONDITION"); _firstCall = dbr.GetValue<int>("CALL_1_POSITION"); _secondCall = dbr.GetValue<int>("CALL_2_POSITION"); _finalCall = dbr.GetValue<int>("FINISH_POSITION"); }
/// <summary> /// 执行一存储过程返回数据表 返回多个值 /// <param name="procName">存储过程名称</param> /// <param name="ht">Hashtable</param> /// <param name="rs">Hashtable</param> public DataTable GetDataTableProcReturn(string procName, Hashtable ht, ref Hashtable rs) { try { using (MySqlConnection conn = this.GetInstance()) { dbCommand = new MySqlCommand(procName, conn); try { dbCommand.CommandTimeout = CommandTimeOut; dbCommand.CommandType = CommandType.StoredProcedure; DbCommon.MySqlAddInParameter(dbCommand, ht); DataTable dt = DbReader.ReaderToDataTable(dbCommand.ExecuteReader(CommandBehavior.CloseConnection)); rs = new Hashtable(); foreach (string str in ht.Keys) { if (str.StartsWith("OUT_")) { object parameterValue = dbCommand.Parameters["@" + str.Remove(0, 4)].Direction = ParameterDirection.ReturnValue; rs[str] = parameterValue; } } return(dt); } catch { return(null); } finally { dbCommand.Dispose(); conn.Close(); conn.Dispose(); } } } catch (Exception e) { DbLog.WriteException(e); return(null); } }
/// <summary> /// 根据唯一ID获取对象,返回实体 /// </summary> /// <param name="pkName">字段主键</param> /// <param name="pkVal">字段值</param> /// <returns>返回实体类</returns> public T GetModelById <T>(string pkName, string pkVal) { if (string.IsNullOrEmpty(pkVal)) { return(default(T)); } this.GetInstance(); T model = Activator.CreateInstance <T>(); Type type = model.GetType(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT * FROM ").Append(type.Name).Append(" Where ").Append(pkName).Append("=" + DbCommon.ParamKey + "ID"); DataTable dt = db.GetDataTableBySQL(sb, new SqlParam[] { new SqlParam("" + DbCommon.ParamKey + "ID", pkVal) }); if (dt.Rows.Count > 0) { return(DbReader.ReaderToModel <T>(dt.Rows[0])); } return(model); }
/// <summary> /// 根据唯一ID获取对象,返回实体 /// </summary> /// <param name="ht">参数</param> /// <returns>返回实体类</returns> public T GetModelById <T>(Hashtable ht) { this.GetInstance(); T model = Activator.CreateInstance <T>(); Type type = model.GetType(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM " + type.Name + " WHERE 1=1"); foreach (string key in ht.Keys) { strSql.Append(" AND " + key + " = " + DbCommon.ParamKey + "" + key + ""); } DataTable dt = db.GetDataTableBySQL(strSql, DbCommon.GetParameter(ht)); if (dt.Rows.Count > 0) { return(DbReader.ReaderToModel <T>(dt.Rows[0])); } return(model); }
public void Dispose() { if (DbReader != null) { DbReader.Dispose(); DbReader = null; } if (_command != null) { _command.Dispose(); _command = null; } if (_connection != null) { _connection.Dispose(); _connection = null; } }
///// <summary> ///// ///// </summary> ///// <param name="db"></param> ///// <param name="format"></param> ///// <param name="parameters"></param> ///// <returns></returns> //internal static Task<JArray> FromSqlToJsonAsync( // this ObjectContext db, // string format, // params object[] parameters) //{ // return FromSqlToJsonAsync(db, TemplateQuery.FromString(format, parameters)); //} /// <summary> /// /// </summary> /// <param name="db"></param> /// <param name="query"></param> /// <returns></returns> public static async Task <JArray> FromSqlToJsonAsync( this ObjectContext db, TemplateQuery query) { JArray list = new JArray(); var props = new List <(int index, string name)>(); using (var dbReader = await DbReader.CreateAsync(db, query)) { var reader = dbReader.Reader; while (await reader.ReadAsync()) { if (props.Count == 0) { if (reader.FieldCount == 0) { return(list); } for (int i = 0; i < reader.FieldCount; i++) { var n = reader.GetName(i); props.Add((i, n)); } } var item = new JObject(); foreach (var(index, n) in props) { var value = reader.GetValue(index); if (value == null || value == DBNull.Value) { continue; } item.Add(n, JToken.FromObject(value)); } list.Add(item); } return(list); } }
private void LoadListBox() { try { _listBox.Items.Clear(); using (var dbr = new DbReader()) { if (dbr.Open(@"SELECT DISTINCT(ABBR_JOCKEY_NAME) 'JOCKEY' FROM RACE_STARTERS WHERE ABBR_JOCKEY_NAME != '' ORDER BY 'JOCKEY'")) { while (dbr.MoveToNextRow()) { _listBox.Items.Add(dbr.GetValue<string>("JOCKEY")); } } } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void RunComposerScan_Inner(IEnumLog log) { DTE2 applicationObject = (DTE2)Package.GetGlobalService(typeof(EnvDTE.DTE)); TextDocument document = ObtainActiveDocument(applicationObject); if (document == null) { log.WriteLine("not a C# file."); return; } DbReader dbReader = new DbReader(null, null, log); IEnumConfigReader configReaderVsp = new ConfigReaderVsp(applicationObject.ActiveDocument.ProjectItem.ContainingProject); dbReader._configReader = configReaderVsp; ComposerStrings composer = new ComposerStrings(dbReader, log); ApplyComposer(document, composer); }
override public void Run() { var(channelId, uploadsListId) = ApiDataFetcher.FetchChannelInfo(DataService); var comparison = DbReader.CompareVideoLifetimeDailyTotal(); long comparisonMinLimit = 500; double comparisonThreshold = 0.05; foreach (var item in comparison) { if (item.Lifetime > 0) { var ratio = Math.Abs((double)item.Lifetime - item.Total) / ((double)item.Lifetime); if (Math.Abs(ratio) > comparisonThreshold && item.Lifetime > comparisonMinLimit) { Logger.Information("Reprocessing video {0}: daily views {1} from {4} to {5}, lifetime views {2} at {6} and ratio {3}" , item.Id.VideoId, item.Total, item.Lifetime, ratio, item.DailyStart, item.DailyEnd, item.LifetimeDate); DbWriter.Write(ApiDataFetcher.FetchDailyMetrics(AnalyticsService, channelId, item.Id, Logger, true)); } } } }
public void PullOutRelations() { OutRelations = new List <Relation>(); var outRelationBlock = DbReader.ReadRelationBlock(nodeBlock.FirstOutRelationId); while (outRelationBlock.RelationId != 0) { if (!outRelationBlock.Used) { outRelationBlock = DbReader.ReadRelationBlock(outRelationBlock.FirstNodeNextRelation); continue; } var relation = new Relation(this, null, outRelationBlock); OutRelations.Add(relation); outRelationBlock = DbReader.ReadRelationBlock(outRelationBlock.FirstNodeNextRelation); } }
void Initialize() { _variantMap.Clear(); using (var dbr = new DbReader()) { string sql = @"SELECT TRACK_CODE, RACING_DATE, TRACK_VARIANT_ESTIMATE, TRACK_VARIANT , NUMBER_OF_STARTERS_FOR_TV FROM TV_TRACK_VARIANT "; if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { string trackCode = dbr.GetValue<string>("TRACK_CODE"); string date = dbr.GetValue<string>("RACING_DATE"); double tv1 = dbr.GetValue<double>("TRACK_VARIANT_ESTIMATE"); double tv2 = dbr.GetValue<double>("TRACK_VARIANT"); int count = dbr.GetValue<int>("NUMBER_OF_STARTERS_FOR_TV"); _variantMap.Add(MakeKey(trackCode,date),count > 0 ? tv2 : tv1); } } } }
public async Task <ImportMetadata> GetImportMetadataAsync(Guid id) { using (var cn = new SqlConnection(dbOptions.ConnectionString)) { var grid = await cn.QueryMultipleAsync( Sql.GetMetadataById, new { id, user = user.UUID, groups = GroupMembership.From(user), admin = user.IsAdmin }, commandType : CommandType.StoredProcedure, commandTimeout : dbOptions.DefaultTimeout ); var metadata = DbReader.Read(grid); return(metadata); } }
public void PullInRelations() { InRelations = new List <Relation>(); var inRelationBlock = DbReader.ReadRelationBlock(nodeBlock.FirstInRelationId); while (inRelationBlock.RelationId != 0) { if (!inRelationBlock.Used) { inRelationBlock = DbReader.ReadRelationBlock(inRelationBlock.SecondNodeNextRelation); continue; } var relation = new Relation(null, this, inRelationBlock); InRelations.Add(relation); inRelationBlock = DbReader.ReadRelationBlock(inRelationBlock.SecondNodeNextRelation); } }
private PaceFigure(string trackCode, string date, int raceNumber, string horseNumber) { var sql = string.Format("exec GetPaceFigureForSpecificRace '{0}', '{1}', {2}, '{3}'", trackCode, date, raceNumber, horseNumber); using (var dbr = new DbReader()) { if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { _figure1ForTheRace = dbr.GetValue<int>("figure1"); _figure2ForTheRace = dbr.GetValue<int>("figure2"); _finalCallForTheRace = dbr.GetValue<int>("finalFigure"); _figure1ForTheHorse = dbr.GetValue<int>("figure1ForTheHorse"); _figure2ForTheHorse = dbr.GetValue<int>("figure2ForTheHorse"); _finalCallForTheHorse = dbr.GetValue<int>("finalFigureForTheHorse"); } } } }
static void Prefix(List <AnimalData> ___datas) { if (!enabled) { return; } if (___datas == null) { SqliteDataReader sqliteDataReader = LocalDb.cur.ReadFullTable("AnimalFarm_Animal"); if (sqliteDataReader == null) { return; } ___datas = DbReader.Read <AnimalData>(sqliteDataReader, 20); } for (int i = 0; i < ___datas.Count; i++) { typeof(AnimalData).GetProperty("TotalPoint").SetValue(___datas[i], (int)Math.Round(___datas[i].StandardPoint * settings.MaxAnimalGrowthPercent / 100f), null); string name = TextMgr.GetStr(___datas[i].NameId, -1); Dbgl($"{name} max points set to {___datas[i].TotalPoint}"); } }
public async Task <ImportMetadata> CreateImportMetadataAsync(ImportMetadata metadata) { using (var cn = new SqlConnection(dbOptions.ConnectionString)) { var grid = await cn.QueryMultipleAsync( Sql.CreateImportMetadata, new { sourceId = metadata.SourceId, type = metadata.Type, structure = metadata.StructureJson, constraints = ResourceConstraintTable.From(metadata), user = user.UUID }, commandType : CommandType.StoredProcedure, commandTimeout : dbOptions.DefaultTimeout ); var created = DbReader.Read(grid); return(created); } }
public async void checkforwork(object source, ElapsedEventArgs e) { var items = new DbReader("", "", "").GetScheduledTasks().ConvertToScheduleItem(); var users = await Context.Guild.GetUsersAsync(); for (int i = 0; i < items.Count; i++) { foreach (var itm in users) { if (itm.Username == items[i].user) { IUser user = itm; switch (items[i].task.ToLower()) { } IDMChannel dMChannel = await user.GetOrCreateDMChannelAsync(); await user.SendMessageAsync(items[i].variables); } } } }
public static List<DateTime> GetDates(string trackCode) { if (_racesPool.ContainsKey(trackCode)) { return _racesPool[trackCode]; } else { using (var dbr = new DbReader()) { var dates = new List<DateTime>(); if (dbr.Open(string.Format(@"Select DATE_OF_THE_RACE FROM RACE_DESCRIPTION WHERE TRACK_CODE = '{0}'", trackCode))) { while (dbr.MoveToNextRow()) { dates.Add(Utilities.MakeDateTime(dbr.GetValue<string>("DATE_OF_THE_RACE"))); } } _racesPool.Add(trackCode, dates); return dates; } } }
private static void GetRewardsList() { basicRewardList = DbReader.Read <BoxInfo>(LocalDb.cur.ReadFullTable("The_Chest"), 20); medRewardList = DbReader.Read <DungeonChestConfInfo>(LocalDb.cur.ReadFullTable("Dungeon_Chest"), 20); eliteRewardList = new List <Reward>(); SqliteDataReader sqliteDataReader = LocalDb.cur.ReadFullTable("Unlimited_DungeonN"); while (sqliteDataReader.Read()) { IntR range = new IntR(sqliteDataReader.GetString(sqliteDataReader.GetOrdinal("levelRange")), '~'); string rawString = sqliteDataReader.GetString(sqliteDataReader.GetOrdinal("reward")); string[] rawRewards = rawString.Split(new char[] { '|' }); if (rawRewards.Length < 4) { Debug.LogError("rewards length error! " + rawString); } else { DoubleValue <int, FloatR>[] rewardsArray = new DoubleValue <int, FloatR> [4]; for (int j = 0; j < 4; j++) { string[] array5 = rawRewards[j].Split(new char[] { '_' }); rewardsArray[j] = new DoubleValue <int, FloatR>(int.Parse(array5[0]), new FloatR(array5[1], '~')); } eliteRewardList.Add(new Reward(rewardsArray, range)); } } }
public void Populate(DbReader dbr) { if (0 == ++_counter % 100) { Console.WriteLine("Populated so far: {0}", _counter); } try { RaceId = dbr.GetValue<int>("race_id"); HorseName = dbr.GetValue<string>("horse_name").Trim(); RacingDate = dbr.GetValue<string>("racing_date"); TrackCode = dbr.GetValue<string>("track_code"); FinishPosition = dbr.GetValue<int>("finish_position"); Odds = dbr.GetValue<double>("odds"); GoldenFigure = (int)dbr.GetValue<double>("goldenFigure"); WinnersGoldenFigure = (int)dbr.GetValue<double>("WinnersGoldenFigure"); TrackCondition = dbr.GetValue<string>("track_condition"); Distance = (int)dbr.GetValue<double>("distance"); SecondCallPosition = dbr.GetValue<int>("call_2_position"); RaceType = MakeRaceType(dbr.GetValue<string>("bris_race_type").Trim().ToUpper()); RestrictedToFemalesOnly = GetRestrictedToFemalesOnly(dbr.GetValue<string>("age_sex_restrictions").Trim().ToUpper()); RestrictedToTwoYearsOnly = GetIfRestrictedToTwoYearsOnly(dbr.GetValue<string>("age_sex_restrictions").Trim().ToUpper()); RestrictedToThreeYearsOnly = GetIfRestrictedToThreeYearsOnly(dbr.GetValue<string>("age_sex_restrictions").Trim().ToUpper()); RestrictedToStateBredsOnly = GetIfRestrictedToStateBredsOnly(dbr.GetValue<string>("state_bred_flag").Trim().ToUpper()); PostPosition = dbr.GetValue<int>("post_position"); WasClaimed = GetWasClaimed(dbr.GetValue<string>("claimed_indicator").Trim().ToUpper()); BlinkersOff = GetBlinkersOff(dbr.GetValue<string>("equipment_codes").Trim().ToUpper()); FirstTimeLasix = GetFirstTimeLasix(dbr.GetValue<string>("medication_codes").Trim().ToUpper()); FieldSize = dbr.GetValue<int>("field_size"); WasTheFavorite = dbr.GetValue<int>("favorite_flag") == 1; Previous = null; Next = null; } catch (Exception e) { GoldenFigure = -999; } }
Tuple <MetaData, bool> IMetaDataCommandCreator <TestCommand, TestDbReader> .ReadMetaDataFromReader(DbReader <TestDbReader> reader, bool readuserId = true) { var comman = (TestCommand)reader.GetValue(1); return(new Tuple <MetaData, bool>(new MetaData(comman.Local, comman.DeleteTime, comman.IsDeleted), false)); }
public static List<WinnerInfo> LoadFromDb(string trackCode, double distance, string surface, string aboutFlag) { var list = new List<WinnerInfo>(); using (var dbr = new DbReader()) { string sql = GetSqlLoader(trackCode, distance, surface, aboutFlag); if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { list.Add(new WinnerInfo(dbr)); } } } list = RemoveZeroValues(list, (WinnerInfo wik) => wik.FirstFraction()); list = RemoveZeroValues(list, (WinnerInfo wik) => wik.SecondFraction()); list = RemoveZeroValues(list, (WinnerInfo wik) => wik.ThirdFraction()); return list; }
/// <summary> /// 根据 SQL 返回 IList,带参数 (比DataSet效率高) /// </summary> /// <typeparam name="T">实体类</typeparam> /// <param name="sql">Sql语句</param> /// <param name="param">参数化</param> /// <returns></returns> public IList GetDataListBySQL <T>(StringBuilder sql, SqlParam[] param) { dbCommand = this.GetInstance().GetSqlStringCommand(Replace(sql.ToString())); DbCommon.AddInParameter(db, dbCommand, param); return(DbReader.ReaderToList <T>(db.ExecuteReader(dbCommand))); }
/// <summary> /// Adds the next rows to the database tables. /// </summary> /// <param name="reader">The database reader.</param> private void AddNextRow(DbReader reader) { // Add a new row to the data. object[] row = new object[reader.ColumnCount]; for (int index = 0; index < this.columnCount; index++) { row[index] = reader[index]; } this.rows.Add(row); }
private static int GetRaceIdFromDb(string trackCode, int year, int month, int day, int raceNumber) { int raceid = -1; using (var dbr = new DbReader()) { string date = string.Format("{0:0000}{1:00}{2:00}", year, month, day); string sql = string.Format(@"SELECT RACE_ID FROM RACE_DESCRIPTION WHERE TRACK_CODE = '{0}' AND DATE_OF_THE_RACE = '{1}' AND RACE_NUMBER= {2}", trackCode, date, raceNumber); if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { raceid = dbr.GetValue<int>("RACE_ID"); } } } return raceid; }
public RaceStarter(DbReader dbr) { _officalPosition = dbr.GetValue<int>("official_position"); _name = dbr.GetValue<string>("horse_name"); _programNumber = dbr.GetValue<string>("program_number"); }