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