private void AddRecommend(Recommend rec) { if (!Recommends.Any((i) => i.Time2 == rec.Time2)) { Recommends.Add(rec); } }
public static Recommend RecommendFromReader(IDataRecord reader) { Recommend rec = new Recommend(); // 处理string类型 var ps = typeof(Recommend).Properties<string>(); try { foreach (var p in ps) { if (p.StartsWith("Time")) { continue; } rec.SetProperty(p, reader[p] as string); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("ex:" + ex.StackTrace); } // 处理时间类型 DateTime t1 = (DateTime)reader["Time1"]; DateTime t2 = (DateTime)reader["Time2"]; rec.Time1 = t1.ToString("yy-MM-dd HH:mm"); rec.Time2 = t2.ToString("yy-MM-dd HH:mm"); rec.PreferResult = (PreferResult)reader["PreferResult"]; rec.Odds = (float)((double)reader["Odds"]); return rec; }
private static float GainLose(Recommend r) { switch (r.PreferResult) { case PreferResult.Waiting: return .0f; case PreferResult.Lose: return -1.0f; case PreferResult.LoseHalf: return -.5f; case PreferResult.Useless: return .0f; case PreferResult.WinHalf: return 0.5f * r.Odds; case PreferResult.Win: return 1.0f * r.Odds; default: return .0f; } }
public void TestProperty() { B b1 = new B() { A = new A() { szA = "szA1" }, szB = "szB1" }; var x = b1.Property("szB"); var y = b1.Property("A"); var z = b1.Property("A.szA"); var m = b1.Property("A.iA"); Recommend r = new Recommend(); var properties = r.GetType().Properties<string>(); foreach (var p in properties) { System.Diagnostics.Debug.WriteLine(p); } b1.SetProperty("A.iA", 999); }
public void TestOutPutSql() { var rec = new Recommend() { Current = "第43期", League = "无联赛", Time1 = "05-01 02:45", Host = "車斯曼", OddStake = "半球", Guest = "赫默爾亨普斯特德城", Prefer = "赫默爾亨普斯特德城", Odds = 0.800f, Result = "-", PreferResult = PreferResult.Waiting, Time2 = "04-30 22:57", Person = "sos73" }; string sz = DBHelper.ReplaceCommand(rec); }
public static string ReplaceCommand(Recommend rec) { var pros = typeof(Recommend).GetProperties(); string prms = ""; string vals = ""; foreach (var p in pros) { if (p.Name.Contains("Time") || p.PropertyType.Name != "String") { continue; } prms = prms + "'" + p.Name + "',"; vals = vals + "'" + rec.Property(p.Name) + "',"; } // handle Time1 & Time2 var t1 = DateTimeToSqlTime(TimeFromString(rec.Time1)); var t2 = DateTimeToSqlTime(TimeFromString(rec.Time2)); var sz = "replace into Recommends(" + prms + "'Time1','Time2','Odds','PreferResult') values(" + vals + "'" + t1 + "','" + t2 + "'," + rec.Odds + "," + (int)rec.PreferResult + ");"; return sz; }
public YieldRoiRecommend(Recommend recommend) { this.Recommend = recommend; this.Person = YieldRoiProvider.Instance.GetPerson(recommend.Person); }
public RecommendModifyViewModel(Recommend rec) { Recommends.Add(rec); }
private bool Match(Recommend i, Recommend j) { return i.Time2 == j.Time2; }
private string RecommendToString(Recommend item) { string body = item.Person + " :" + item.Host + " " + item.OddStake + " " + item.Guest + " 推荐:" + item.Prefer + " " + item.Odds; return body; }
public void SaveRecommend(Recommend rec) { localHelper.SaveRecommend(rec); }
private void OnRecommend(Recommend rec) { AllRecommends.Add(new YieldRoiRecommend(rec)); }
private bool IsTopNewRecommend(Recommend item) { return IsTopPerson(item.Person) && item.PreferResult == PreferResult.Waiting; }
public string GetReplaceRecommendSql(Recommend rec) { return DBHelper.ReplaceCommand(rec); }
private static bool IsValidRecommend(Recommend rec) { return rec.Odds > 0 && !string.IsNullOrEmpty(rec.Host) && !string.IsNullOrEmpty(rec.Guest) && !string.IsNullOrEmpty(rec.OddStake); }
private void onRecommend(Recommend obj) { var sz = DBHelper.ReplaceCommand(obj); Write(sz); }
private static Recommend RecommendFromStrings(IList<string> results) { string r6 = results[6]; // 艾斯迪格拿/0.900 string szOdds = "0.0"; int lastSlash = r6.LastIndexOf("/"); string prefer = "推荐"; if (lastSlash >= 0) { szOdds = r6.Substring(r6.LastIndexOf("/") + 1); prefer = r6.Substring(0, r6.LastIndexOf("/")); } float odds = 0.0f; float.TryParse(szOdds, out odds); Recommend rec = new Recommend() { // 擂台期数:第45期 Current = results[0], // 所属赛事:挪威超 League = results[1], // 开赛时间:04-27 16:30 Time1 = results[2], // 主队:中央海岸學院 Host = results[3], // 盘口:2.5/3球 OddStake = results[4], // 客队:馬柯尼 Guest = results[5], // 推荐内容:大球 Prefer = prefer, // 赔率:0.86 Odds = odds, // 比赛最终结果:0-1 Result = results[7], // 推荐最终结果:输盘 PreferResult = PreferResultHelper.ConvertBack(results[8], typeof(PreferResult), null, null), // 推荐时间:04-27 16:00 Time2 = results[9], // 推荐人:地狱黑仔王 Person = results[10] }; return rec; }
public void SaveRecommend(Recommend rec) { using (var cmd = commandFactory.GetDbCommand()) { cmd.CommandText = commandFactory.GetReplaceRecommendSql(rec); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } }