public static void ComputeAvg() { Dictionary <string, List <int> > numberSpanDict = new Dictionary <string, List <int> >(110); DwNumberBiz biz = new DwNumberBiz("shand11x5"); DwSpanBiz spanBiz = new DwSpanBiz("shand11x5", "peroid"); List <DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, DwNumber.C_P, SortTypeEnum.ASC, null, DwNumber.C_P, DwNumber.C_P2); List <DwSpan> periodSpans = spanBiz.DataAccessor.SelectWithCondition(string.Empty, DwSpan.C_P, SortTypeEnum.ASC, null, DwSpan.C_P, DwSpan.C_P2Spans); var spanDict = periodSpans.ToDictionary(x => x.P, y => y.P2Spans); foreach (var number in numbers) { if (!numberSpanDict.ContainsKey(number.P2)) { numberSpanDict.Add(number.P2, new List <int>(10000)); } numberSpanDict[number.P2].Add(spanDict[number.P]); } StreamWriter sw = new StreamWriter(@"E:\avgSpan.txt", false, Encoding.UTF8); foreach (var kv in numberSpanDict) { int total = 0; for (var i = 0; i < kv.Value.Count; i++) { total += kv.Value[i]; sw.WriteLine("{0},{1},{2},{3}", kv.Key, i + 1, (total * 1.0) / ((i + 1) * 1.0), kv.Value[i]); } } sw.Close(); }
protected override void ExecuteCommand(Action<string> output, params string[] args) { WebClient wc = new WebClient(); wc.Encoding = Encoding.UTF8; string urlFormat = "http://www.pinble.com/Template/WebService1.asmx/Present3DList?pageindex={0}&lottory={1}&pl3={2}&name={3}&isgp={4}"; List<Category> categories = CategoryBiz.Instance.GetEnabledCategories(false); Dictionary<string, string> dict = new Dictionary<string, string>(categories.Count); string dataSourceName = ConfigHelper.GetAppSettings("dataSource"); DataSourceElement config = ConfigManager.DataSourceSection.DataSources[dataSourceName]; DwNumberBiz biz = new DwNumberBiz("shand11x5"); foreach (var category in categories) { if (category.ParentId == 0) continue; string url = string.Format(urlFormat, 1, category.Code, "", category.Name, category.IsGP); string htmlText = wc.DownloadString(url); int peroidCount = ConvertHelper.GetInt32(Regex.Match(htmlText, "共\\:(\\d+)条", RegexOptions.Singleline | RegexOptions.IgnoreCase).Groups[1].Value); int pageCount = ConvertHelper.GetInt32(Regex.Match(htmlText, "分页\\:1/(\\d+)页", RegexOptions.Singleline | RegexOptions.IgnoreCase).Groups[1].Value); Category entity = new Category() { Id = category.Id, PeroidCount = peroidCount, DownPageCount = pageCount }; CategoryBiz.Instance.Modify(entity, entity.Id, Category.C_DownPageCount, Category.C_PeroidCount); biz.DataAccessor.ConnectionString = config.Databases[category.DbName.Trim().ToLower()].ConnectionString; int maxSeq = biz.DataAccessor.SelectMaxWithCondition("Seq", 10, string.Empty); int downPeroids = biz.Count; string propmt = string.Format("{0}:{1}", category.Name, string.Format("{0}期,下载,{1}期,Max Seq,{2}", peroidCount, downPeroids, maxSeq)); output(propmt); if (category.Type.Equals("11X5")) this.CheckC5CX(output, category, biz.DataAccessor.ConnectionString); } }
public void C1StatMain(string dbName) { DwNumberBiz biz = new DwNumberBiz(dbName); List <DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); Span(numbers); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "F2", "P", "N", "Date"); for (int i = 0; i < allNumbers.Count; i++) { allNumbers[i].Seq = i + 1; } HashSet <string> allF2Numbers = this.GetAllF2Numbers(dbName.ToString()); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "F2_PeroidSpan"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (string numberId in allF2Numbers) { var numbers = allNumbers.Where(x => x.F2.Trim().Equals(numberId)).OrderBy(x => x.Seq).ToArray(); for (int j = 0; j < numbers.Length; j++) { int spans = -1; int lastN = 0; if (j > 0) { spans = numbers[j].Seq - numbers[j - 1].Seq - 1; lastN = numbers[j - 1].N; } string line = string.Format("{0},{1},{2},{3}", numbers[j].P, numberId, spans, lastN); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},F2PeroidSpan,Finished", dbName); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "D1", "P"); int numberCount = allNumbers.Count; HashSet <int> allD1Numbers = this.GetAllD1Numbers(); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "D1_PeroidNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); for (int i = 0; i < numberCount - 5; i++) { int count = 0; for (int n = 5; count < 11; n++) { if (i + n >= numberCount) { break; } var subSet = allNumbers.GetRange(i, n).Select(y => y.D1).Distinct(); count = this.GetCount <int>(subSet, allD1Numbers); string line = string.Format("{0},{1},{2}", allNumbers[i].P, n, count); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},D1PeroidNumbers,Finished", dbName); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.GetAll("F3", "Date"); List<DwNumber> allDates = biz.DataAccessor.SelectDistinctDate(); int end = allDates.Count; HashSet<string> allF3Numbers = this.GetAllF3Numbers(dbName.ToString()); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "F3_DayNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); for (int i = 0; i < end; i++) { int count = 0; for (int day = 0; count < 990; day++) { int next = i + day; if (next >= end) break; var subSet = allNumbers .Where(x => x.Date >= allDates[i].Date && x.Date <= allDates[next].Date) .Select(y => y.F3.Trim()) .Distinct(); count = this.GetCount<string>(subSet, allF3Numbers); string line = string.Format("{0},{1},{2}", allDates[i].Date, day + 1, count); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},F3DayNumbers,Finished", dbName); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.GetAll("F2", "Date"); List <DwNumber> allDates = biz.DataAccessor.SelectDistinctDate(); int end = allDates.Count; HashSet <string> allF2Numbers = this.GetAllF2Numbers(dbName.ToString()); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "F2_DayNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); for (int i = 0; i < end; i++) { int count = 0; for (int day = 0; count < 110; day++) { int next = i + day; if (next >= end) { break; } var subSet = allNumbers .Where(x => x.Date >= allDates[i].Date && x.Date <= allDates[next].Date) .Select(y => y.F2.Trim()) .Distinct(); count = this.GetCount <string>(subSet, allF2Numbers); string line = string.Format("{0},{1},{2}", allDates[i].Date, day + 1, count); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},F2DayNumbers,Finished", dbName); }
public static void ComputeAvg() { Dictionary<string, List<int>> numberSpanDict = new Dictionary<string, List<int>>(110); DwNumberBiz biz = new DwNumberBiz("shand11x5"); DwSpanBiz spanBiz = new DwSpanBiz("shand11x5", "peroid"); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, DwNumber.C_P, SortTypeEnum.ASC, null, DwNumber.C_P, DwNumber.C_P2); List<DwSpan> periodSpans = spanBiz.DataAccessor.SelectWithCondition(string.Empty, DwSpan.C_P, SortTypeEnum.ASC, null, DwSpan.C_P, DwSpan.C_P2Spans); var spanDict = periodSpans.ToDictionary(x => x.P, y => y.P2Spans); foreach (var number in numbers) { if (!numberSpanDict.ContainsKey(number.P2)) { numberSpanDict.Add(number.P2, new List<int>(10000)); } numberSpanDict[number.P2].Add(spanDict[number.P]); } StreamWriter sw = new StreamWriter(@"E:\avgSpan.txt", false, Encoding.UTF8); foreach (var kv in numberSpanDict) { int total = 0; for (var i = 0; i < kv.Value.Count; i++) { total += kv.Value[i]; sw.WriteLine("{0},{1},{2},{3}", kv.Key, i + 1, (total * 1.0) / ((i + 1) * 1.0), kv.Value[i]); } } sw.Close(); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "D1","P","N","Date"); for (int i = 0; i < allNumbers.Count; i++) allNumbers[i].Seq = i+1; HashSet<int> allD1Numbers = this.GetAllD1Numbers(); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "D1_PeroidSpan"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (int numberId in allD1Numbers) { var numbers = allNumbers.Where(x => x.D1.Equals(numberId)).OrderBy(x => x.Seq).ToArray(); for (int j = 0; j < numbers.Length; j++) { int spans = -1; int lastN = 0; if (j > 0) { spans = numbers[j].Seq - numbers[j - 1].Seq - 1; lastN = numbers[j - 1].N; } string line = string.Format("{0},{1},{2},{3}", numbers[j].P, numberId, spans, lastN); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},D1PeroidSpan,Finished", dbName); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "D1", "P"); int numberCount = allNumbers.Count; HashSet<int> allD1Numbers = this.GetAllD1Numbers(); string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "D1_PeroidNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); for (int i = 0; i < numberCount - 5; i++) { int count = 0; for (int n = 5; count < 11; n++) { if (i + n >= numberCount) break; var subSet = allNumbers.GetRange(i, n).Select(y => y.D1).Distinct(); count = this.GetCount<int>(subSet, allD1Numbers); string line = string.Format("{0},{1},{2}", allNumbers[i].P, n, count); writer.WriteLine(line); } } writer.Close(); Console.WriteLine("{0},D1PeroidNumbers,Finished", dbName); }
private static void ImportSSC(string line, string name,int index) { DwNumberBiz biz = null; if (name.Equals("江西时时彩")) biz = new DwNumberBiz("JiangXSSC"); if (name.Equals("重庆时时彩")) biz = new DwNumberBiz("ChongQSSC"); //biz.Add(dto); }
protected override void Stat(string dbName, bool isReset) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetEnabledDimensions("11X5"); DwNumberBiz biz = new DwNumberBiz(dbName); List <DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); this.StatC5CX(numbers, dbName, isReset); }
protected override void Stat(string dbName, bool isReset) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetEnabledDimensions("11X5"); DwNumberBiz biz = new DwNumberBiz(dbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); this.Stat(dbName, dmNames, numbers,isReset); }
public static void UpdateP(int categoryId, string p, string code) { Category category = CategoryBiz.Instance.GetById(categoryId); DwNumberBiz biz = new DwNumberBiz(category.DbName); DwNumber number = biz.GetById(p); DwNumber newNumber = biz.Create(number.P, number.N, code, number.Date, number.Created.ToString()); newNumber.Seq = number.Seq; biz.Modify(newNumber, newNumber.P.ToString()); }
private static void ImportD11X5(string line, string name) { DwNumberBiz biz = null; if (name.Equals("江西多乐彩")) biz = new DwNumberBiz("jiangx11x5"); if (name.Equals("广东11选5")) biz = new DwNumberBiz("guangd11x5"); if (name.Equals("山东十一运夺金")) biz = new DwNumberBiz("shand11x5"); //biz.Add(dto); //writer.WriteLine(dto.ToString()); }
public static void Update(int categoryId, string p, string code) { Category category = CategoryBiz.Instance.GetById(categoryId); DwNumberBiz biz = new DwNumberBiz(category.DbName); DwNumber number = biz.GetById(p); DwNumber newNumber = biz.Create(number.P, number.N, code, number.Date, number.Created.ToString()); newNumber.Seq = number.Seq; biz.Modify(newNumber, newNumber.P.ToString()); }
protected override void Stat(string dbName, OutputType outputType) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null); //List<DwNumber> allNumbers = biz.DataAccessor.SelectTopN(10, string.Empty, "P", SortTypeEnum.ASC, null); //string[] rules = new string[] { "D1", "F2", "C2", "F3", "C3", "A5"}; string[] rules = new string[] {"F2" }; foreach (string rule in rules) { this.Stat(allNumbers, rule, dbName.ToString()); Console.WriteLine("{0} {1} Finished", dbName, rule); } }
protected override void Stat(string dbName, bool isReset) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetEnabledDimensions("3D"); DwNumberBiz biz = new DwNumberBiz(dbName); List <DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); foreach (string dmName in dmNames) { string[] numberTypes = DimensionNumberTypeBiz.Instance.GetNumberTypes("3D", dmName); this.Stat(numbers, dbName, dmName, numberTypes, isReset); } Console.WriteLine("{0} {1} Finished", dbName, "ALL Span"); }
protected override void Stat(string dbName,bool isReset) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetEnabledDimensions("PL35"); DwNumberBiz biz = new DwNumberBiz(dbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); foreach (string dmName in dmNames) { string[] numberTypes = DimensionNumberTypeBiz.Instance.GetNumberTypes("PL35", dmName); this.Stat(numbers, dbName, dmName, numberTypes, isReset); } Console.WriteLine("{0} {1} Finished", dbName, "ALL Span"); }
protected override void Stat(string dbName, OutputType outputType) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null); //List<DwNumber> allNumbers = biz.DataAccessor.SelectTopN(10, string.Empty, "P", SortTypeEnum.ASC, null); //string[] rules = new string[] { "D1", "F2", "C2", "F3", "C3", "A5"}; string[] rules = new string[] { "F2" }; foreach (string rule in rules) { this.Stat(allNumbers, rule, dbName.ToString()); Console.WriteLine("{0} {1} Finished", dbName, rule); } }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "F3"); for (int i = 0; i < allNumbers.Count; i++) { allNumbers[i].Seq = i; } int numberCount = allNumbers.Count; Dictionary <string, int> nextDict = new Dictionary <string, int>(990 * 990); string[] f3Numbers = null; // biz.DataAccessor.SelectDistinctF3(); foreach (string f3 in f3Numbers) { foreach (string f31 in f3Numbers) { nextDict.Add(string.Format("{0},{1}", f3.Trim(), f31.Trim()), 0); } } foreach (string f3 in f3Numbers) { var numbers = allNumbers.Where(x => x.F3.Trim().Equals(f3.Trim())); foreach (var number in numbers) { int nextIndex = number.Seq + 1; if (nextIndex >= allNumbers.Count) { continue; } string key = string.Format("{0},{1}", f3.Trim(), allNumbers[nextIndex].F3.Trim()); nextDict[key]++; } } string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "F3_NextNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (var kp in nextDict) { string line = string.Format("{0},{1}", kp.Key, kp.Value); writer.WriteLine(line); } writer.Close(); Console.WriteLine("{0},F3NextNumbers,Finished", dbName); }
private static void ImportSSC(string line, string name, int index) { DwNumberBiz biz = null; if (name.Equals("江西时时彩")) { biz = new DwNumberBiz("JiangXSSC"); } if (name.Equals("重庆时时彩")) { biz = new DwNumberBiz("ChongQSSC"); } //biz.Add(dto); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List <DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "D1"); for (int i = 0; i < allNumbers.Count; i++) { allNumbers[i].Seq = i; } int numberCount = allNumbers.Count; Dictionary <string, int> nextNumberDict = new Dictionary <string, int>(11 * 11); for (int i = 1; i <= 11; i++) { var numbers = allNumbers.Where(x => x.D1.Equals(i)); foreach (var number in numbers) { int nextIndex = number.Seq + 1; if (nextIndex >= numberCount) { continue; } string key = string.Format("{0},{1}", i, allNumbers[nextIndex].D1); if (nextNumberDict.ContainsKey(key)) { nextNumberDict[key]++; } else { nextNumberDict.Add(key, 1); } } } string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "D1_NextNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (var kp in nextNumberDict) { string line = string.Format("{0},{1}", kp.Key, kp.Value); writer.WriteLine(line); } writer.Close(); Console.WriteLine("{0},D1NextNumbers,Finished", dbName); }
public static void UpdateC4() { List<Category> categories = CategoryBiz.Instance.GetEnabledCategories("11X5"); foreach (Category category in categories) { DwNumberBiz biz = new DwNumberBiz(category.DbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", Data.SortTypeEnum.ASC, null, "P", "P4"); foreach (var number in numbers) { string colValue = NumberCache.Instance.GetNumberId("C4",number.P4.ToString(2)); string sql = string.Format("update {0} set {1} = '{2}' where P = {3}", DwNumber.ENTITYNAME, "C4", colValue, number.P); Data.SqlHelper.ExecuteNonQuery(biz.DataAccessor.ConnectionString, System.Data.CommandType.Text, sql); } } }
protected override void ExecuteCommand(Action <string> output, params string[] args) { WebClient wc = new WebClient(); wc.Encoding = Encoding.UTF8; string urlFormat = "http://www.pinble.com/Template/WebService1.asmx/Present3DList?pageindex={0}&lottory={1}&pl3={2}&name={3}&isgp={4}"; List <Category> categories = CategoryBiz.Instance.GetEnabledCategories(false); Dictionary <string, string> dict = new Dictionary <string, string>(categories.Count); string dataSourceName = ConfigHelper.GetAppSettings("dataSource"); DataSourceElement config = ConfigManager.DataSourceSection.DataSources[dataSourceName]; DwNumberBiz biz = new DwNumberBiz("shand11x5"); foreach (var category in categories) { if (category.ParentId == 0) { continue; } string url = string.Format(urlFormat, 1, category.Code, "", category.Name, category.IsGP); string htmlText = wc.DownloadString(url); int peroidCount = ConvertHelper.GetInt32(Regex.Match(htmlText, "共\\:(\\d+)条", RegexOptions.Singleline | RegexOptions.IgnoreCase).Groups[1].Value); int pageCount = ConvertHelper.GetInt32(Regex.Match(htmlText, "分页\\:1/(\\d+)页", RegexOptions.Singleline | RegexOptions.IgnoreCase).Groups[1].Value); Category entity = new Category() { Id = category.Id, PeroidCount = peroidCount, DownPageCount = pageCount }; CategoryBiz.Instance.Modify(entity, entity.Id, Category.C_DownPageCount, Category.C_PeroidCount); biz.DataAccessor.ConnectionString = config.Databases[category.DbName.Trim().ToLower()].ConnectionString; int maxSeq = biz.DataAccessor.SelectMaxWithCondition("Seq", 10, string.Empty); int downPeroids = biz.Count; string propmt = string.Format("{0}:{1}", category.Name, string.Format("{0}期,下载,{1}期,Max Seq,{2}", peroidCount, downPeroids, maxSeq)); output(propmt); if (category.Type.Equals("11X5")) { this.CheckC5CX(output, category, biz.DataAccessor.ConnectionString); } } }
public static void Insert(int categoryId, string speroid, string code, string sdate) { string no = code.Replace(" ", ","); DateTime datetime = DateTime.Parse(sdate); int dateint = int.Parse(datetime.ToString("yyyyMMdd")); int p = 2000000000 + int.Parse(speroid); int n = int.Parse(speroid.Substring(speroid.Length - 2)); Category category = CategoryBiz.Instance.GetById(categoryId); DwNumberBiz biz = new DwNumberBiz(category.DbName); //select MAX(seq) seq from DwNumber where P < p; int seq = biz.DataAccessor.SelectMaxWithCondition(DwNumber.C_Seq, 10, "where P <" + p); DwNumber number = biz.Create(p, n, no, dateint, sdate); number.Seq = seq + 1; //UPDATE DwNumber set Seq=seq+ 1 where P > p; biz.Add(number); biz.DataAccessor.UpdateSeq(1, p); }
public static void UpdateC45() { List <Category> categories = CategoryBiz.Instance.GetEnabledCategories("SSC"); foreach (Category category in categories) { DwNumberBiz biz = new DwNumberBiz(category.DbName); List <DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", Data.SortTypeEnum.ASC, null, "P", "P4", "P5"); foreach (var number in numbers) { string c4 = NumberCache.Instance.GetNumberId("C4", number.P4); string c5 = NumberCache.Instance.GetNumberId("C5", number.P5); string sql = string.Format("update {0} set {1} = '{2}',{3} = '{4}' where P = {5}", DwNumber.ENTITYNAME, "C4", c4, "C5", c5, number.P); Data.SqlHelper.ExecuteNonQuery(biz.DataAccessor.ConnectionString, System.Data.CommandType.Text, sql); } } }
private static void ImportD11X5(string line, string name) { DwNumberBiz biz = null; if (name.Equals("江西多乐彩")) { biz = new DwNumberBiz("jiangx11x5"); } if (name.Equals("广东11选5")) { biz = new DwNumberBiz("guangd11x5"); } if (name.Equals("山东十一运夺金")) { biz = new DwNumberBiz("shand11x5"); } //biz.Add(dto); //writer.WriteLine(dto.ToString()); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "F3"); for (int i = 0; i < allNumbers.Count; i++) allNumbers[i].Seq = i; int numberCount = allNumbers.Count; Dictionary<string, int> nextDict = new Dictionary<string, int>(990*990); string[] f3Numbers = null; // biz.DataAccessor.SelectDistinctF3(); foreach (string f3 in f3Numbers) { foreach (string f31 in f3Numbers) { nextDict.Add(string.Format("{0},{1}", f3.Trim(), f31.Trim()), 0); } } foreach (string f3 in f3Numbers) { var numbers = allNumbers.Where(x => x.F3.Trim().Equals(f3.Trim())); foreach (var number in numbers) { int nextIndex = number.Seq + 1; if (nextIndex >= allNumbers.Count) continue; string key = string.Format("{0},{1}", f3.Trim(), allNumbers[nextIndex].F3.Trim()); nextDict[key]++; } } string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "F3_NextNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (var kp in nextDict) { string line = string.Format("{0},{1}", kp.Key, kp.Value); writer.WriteLine(line); } writer.Close(); Console.WriteLine("{0},F3NextNumbers,Finished", dbName); }
protected override void Stat(string dbName, OutputType outputType) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetEnabledDimensions("SSC"); DwNumberBiz biz = new DwNumberBiz(dbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); foreach (string dmName in dmNames) { string[] numberTypes = DimensionNumberTypeBiz.Instance.GetNumberTypes("SSC", dmName); if (outputType == OutputType.Database) this.Stat(numbers, dbName, dmName, numberTypes, null); else { string fileName = string.Format("{0}_{1}.txt", dbName, dmName); StreamWriter writer = new StreamWriter(this.GetOutputFileName(fileName), false, Encoding.UTF8); this.Stat(numbers, dbName, dmName, numberTypes, writer); writer.Close(); } } Console.WriteLine("{0} {1} Finished", dbName, "ALL Span"); }
protected override void Stat(string dbName, OutputType outputType) { string[] dmNames = DimensionNumberTypeBiz.Instance.GetDimensions("3D"); DwNumberBiz biz = new DwNumberBiz(dbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); foreach (string dmName in dmNames) { string[] numberTypes = DimensionNumberTypeBiz.Instance.GetNumberTypes("3D", dmName); if (outputType == OutputType.Database) this.Stat(numbers, dbName, dmName, numberTypes, null); else { string fileName = string.Format("{0}_{1}.txt", dbName, dmName); StreamWriter writer = new StreamWriter(this.GetOutputFileName(fileName), false, Encoding.UTF8); this.Stat(numbers, dbName, dmName, numberTypes, writer); writer.Close(); } } Console.WriteLine("{0} {1} Finished", dbName, "ALL Span"); }
private void Stat(object dbName) { DwNumberBiz biz = new DwNumberBiz(dbName.ToString()); List<DwNumber> allNumbers = biz.DataAccessor.SelectWithCondition(string.Empty, "P", SortTypeEnum.ASC, null, "D1"); for (int i = 0; i < allNumbers.Count; i++) allNumbers[i].Seq = i; int numberCount = allNumbers.Count; Dictionary<string, int> nextNumberDict = new Dictionary<string, int>(11*11); for (int i = 1; i <= 11; i++) { var numbers = allNumbers.Where(x => x.D1.Equals(i)); foreach (var number in numbers) { int nextIndex = number.Seq + 1; if (nextIndex >= numberCount) continue; string key = string.Format("{0},{1}", i, allNumbers[nextIndex].D1); if (nextNumberDict.ContainsKey(key)) { nextNumberDict[key]++; } else { nextNumberDict.Add(key, 1); } } } string fileName = string.Format("Dw{0}_{1}.txt", dbName.ToString(), "D1_NextNumbers"); string filePath = string.Format("{0}\\{1}", this._rootPath, fileName); StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8); foreach (var kp in nextNumberDict) { string line = string.Format("{0},{1}", kp.Key, kp.Value); writer.WriteLine(line); } writer.Close(); Console.WriteLine("{0},D1NextNumbers,Finished", dbName); }
public void C1StatMain(string dbName) { DwNumberBiz biz = new DwNumberBiz(dbName); List<DwNumber> numbers = biz.DataAccessor.SelectWithCondition(string.Empty, "Seq", SortTypeEnum.ASC, null); Span(numbers); }