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