private int LoadLastIssue() { //判断刷新,返回0:没有刷新;1:全部重新加载;2:刷新一期新数据;-1:报错 try { if (mSystemConfig == null) { return(0); } DatabaseConfig dbConfig = mSystemConfig.Database; if (dbConfig == null) { return(0); } string strConn = dbConfig.GetConnectionString(); if (string.IsNullOrEmpty(strConn)) { return(0); } string strSql = string.Format("SELECT TOP 1 * FROM T_101_19 WHERE C099 = 1 ORDER BY C001 DESC"); OperationReturn optReturn = MssqlOperation.GetDataSet(strConn, strSql); if (!optReturn.Result) { WriteLog("LoadLastIssue", string.Format("Fail. [{0}]{1}", optReturn.Code, optReturn.Message)); return(-1); } DataSet objDataSet = optReturn.Data as DataSet; if (objDataSet == null) { return(0); } if (objDataSet.Tables[0].Rows.Count <= 0) { return(0); } DataRow dr = objDataSet.Tables[0].Rows[0]; string serial = dr["C001"].ToString(); int date = Convert.ToInt32(dr["C004"]); if (mNewestIssueItem == null) { return(0); } string lastSerial = mNewestIssueItem.Serial; int lastDate = mNewestIssueItem.Date; if (date > lastDate) { return(SscDefines.REFRESH_MODE_RELOAD); } if (date == lastDate && serial != lastSerial) { IssueItem item = new IssueItem(); item.Serial = serial; item.Number = Convert.ToInt32(dr["C005"]); item.Date = Convert.ToInt32(dr["C004"]); item.WeekDay = Convert.ToInt32(dr["C006"]); item.D1 = Convert.ToInt32(dr["C010"]); item.D2 = Convert.ToInt32(dr["C020"]); item.D3 = Convert.ToInt32(dr["C030"]); item.D4 = Convert.ToInt32(dr["C040"]); item.D5 = Convert.ToInt32(dr["C050"]); item.FullValue = dr["C002"].ToString(); item.LargeValue = dr["C007"].ToString() == "1"; item.SingleValue = dr["C008"].ToString() == "1"; item.SumValue = Convert.ToInt32(dr["C009"]); item.RepeatValue = dr["C100"].ToString() == "" ? 0 : Convert.ToInt32(dr["C100"]); item.IntervalValue = dr["C101"].ToString() == "" ? 0 : Convert.ToInt32(dr["C101"]); item.Larger20 = dr["C102"].ToString() == "" ? 0 : Convert.ToInt32(dr["C102"]); item.AllOne20 = dr["C103"].ToString() == "" ? 0 : Convert.ToInt32(dr["C103"]); item.PairsVaue = dr["C104"].ToString() == "" ? 0 : Convert.ToInt32(dr["C104"]); item.SameValue = dr["C105"].ToString() == "" ? 0 : Convert.ToInt32(dr["C105"]); item.S1 = Convert.ToInt32(dr["C011"]); item.S2 = Convert.ToInt32(dr["C021"]); item.S3 = Convert.ToInt32(dr["C031"]); item.S4 = Convert.ToInt32(dr["C041"]); item.S5 = Convert.ToInt32(dr["C051"]); mNewestIssueItem = item; return(SscDefines.REFRESH_MODE_LOTTERY); } return(-1); } catch (Exception ex) { WriteLog("LoadLastIssue", string.Format("Fail. {0}", ex.Message)); return(0); } }
private void LoadIssuesByDate(string date) { try { mListIssues.Clear(); if (mSystemConfig == null) { return; } DatabaseConfig dbConfig = mSystemConfig.Database; if (dbConfig == null) { return; } string strConn = dbConfig.GetConnectionString(); if (string.IsNullOrEmpty(strConn)) { return; } string strSql = string.Format("SELECT * FROM T_101_19 WHERE C099 = 1 AND C004 = {0} ORDER BY C001 DESC", date); OperationReturn optReturn = MssqlOperation.GetDataSet(strConn, strSql); if (!optReturn.Result) { ShowException(string.Format("Fail. [{0}]{1}", optReturn.Code, optReturn.Message)); return; } DataSet objDataSet = optReturn.Data as DataSet; if (objDataSet == null) { return; } for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { DataRow dr = objDataSet.Tables[0].Rows[i]; IssueItem item = new IssueItem(); item.Serial = dr["C001"].ToString(); item.Number = Convert.ToInt32(dr["C005"]); item.Date = Convert.ToInt32(dr["C004"]); item.WeekDay = Convert.ToInt32(dr["C006"]); item.D1 = Convert.ToInt32(dr["C010"]); item.D2 = Convert.ToInt32(dr["C020"]); item.D3 = Convert.ToInt32(dr["C030"]); item.D4 = Convert.ToInt32(dr["C040"]); item.D5 = Convert.ToInt32(dr["C050"]); item.FullValue = dr["C002"].ToString(); item.LargeValue = dr["C007"].ToString() == "2"; item.SingleValue = dr["C008"].ToString() == "2"; item.SumValue = Convert.ToInt32(dr["C009"]); item.RepeatValue = dr["C100"].ToString() == "" ? 0 : Convert.ToInt32(dr["C100"]); item.IntervalValue = dr["C101"].ToString() == "" ? 0 : Convert.ToInt32(dr["C101"]); item.Larger20 = dr["C102"].ToString() == "" ? 0 : Convert.ToInt32(dr["C102"]); item.AllOne20 = dr["C103"].ToString() == "" ? 0 : Convert.ToInt32(dr["C103"]); item.PairsVaue = dr["C104"].ToString() == "" ? 0 : Convert.ToInt32(dr["C104"]); item.SameValue = dr["C105"].ToString() == "" ? 0 : Convert.ToInt32(dr["C105"]); item.S1 = Convert.ToInt32(dr["C011"]); item.S2 = Convert.ToInt32(dr["C021"]); item.S3 = Convert.ToInt32(dr["C031"]); item.S4 = Convert.ToInt32(dr["C041"]); item.S5 = Convert.ToInt32(dr["C051"]); mListIssues.Add(item); } } catch (Exception ex) { ShowException(ex.Message); } }