/// <summary>
/// 获取彩票
/// </summary>
/// <param name="result"></param>
/// <returns></returns>
public List <Model.LotteryModel> GetLotteryModels(string result)
{
List <Model.LotteryModel> lt = new List <LotteryModel>();
Model.LotteryModel lm = null;
string[] arr1 = result.Split('\n');
for (int i = arr1.Length - 1; i >= 0; i--)
{
string[] arr2 = arr1[i].Split(',');
lm.Dtime = GetDateTime(DateTime.Now, int.Parse(arr2[0]));
lm = new LotteryModel();
lm.Ymd = DateTime.Now.ToString("yyyyMMdd");
lm.Sno = arr2[0];
lm.Num1 = int.Parse(arr2[1]);
lm.Num2 = int.Parse(arr2[2]);
lm.Num3 = int.Parse(arr2[3]);
if (arr2.Length > 4)
{
lm.Num4 = int.Parse(arr2[4]);
lm.Num5 = int.Parse(arr2[5]);
}
//lm.ID = ff.MaxId() + 1;
lt.Add(lm);
}
return(lt);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.LotteryModel model)
{
string sqlString = "insert into lottery" + DateTime.Now.ToString("yyyyMM") + " (ID,ymd,sno,num1,num2,num3,num4,num5,dtime) values (" +
model.ID + ",'"
+ model.Ymd + "','"
+ model.Sno + "',"
+ model.Num1 + ","
+ model.Num2 + ","
+ model.Num3 + ","
+ model.Num4 + ","
+ model.Num5 + ",'"
+ model.Dtime + "')";
try
{
return(DbHelperOleDb.ExecuteSql(sqlString));
}
catch (Exception er)
{
throw new Exception(er.ToString());
}
}
