コード例 #1
0
 public void DeleteRecord(LotteryPeriod period)
 {
     string sql = string.Format(@"DELETE {0} WHERE {1}=@{1}", LotteryRecord.TABLENAME, LotteryRecord.PERIODID);
     base.ExecuteNonQuery(sql, new SqlParameter(LotteryRecord.PERIODID, period.PeriodId));
 }
コード例 #2
0
 public void InsertPeriod(LotteryPeriod period)
 {
     string sql = string.Format(@"INSERT INTO {0} ({1}) VALUES (@{1}) SELECT SCOPE_IDENTITY()", LotteryPeriod.TABLENAME, LotteryPeriod.COMPANYID);
     object id = base.ExecuteScalar(sql, new SqlParameter(LotteryPeriod.COMPANYID, period.Company.CompanyId));
     period.PeriodId = Convert.ToInt32(id);
 }
コード例 #3
0
 public void AddLotteryResult(int companyId, IEnumerable<LotteryRecord> records)
 {
     var company = TodayLotteryCompany.Instance.GetTodayCompany().Find(it => it.CompanyId == companyId);
     var lenSupport = DaNumLen.GetSupportNumLengthByType(company.CompanyType);
     foreach (var support in lenSupport)
     {
         var numLenCount = records.Where(it => it.Value.Length == support.NumLen.Length).Count();
         if (numLenCount != support.Count)
             throw new BusinessException("Please confirm the accuracy of the numbers!");
     }
     bool isNewData = true;
     var period = DaLotteryResult.GetPeriod(company, DateTime.Today);
     if (isNewData = (period == null))
     {
         period = new LotteryPeriod
         {
             Company = company
         };
         DaLotteryResult.InsertPeriod(period);
     }
     records = records.ForEach(it => { it.PeriodId = period.PeriodId; return it; });
     DaLotteryResult.ExecuteWithTransaction(() =>
     {
         if (!isNewData)
             DaLotteryResult.DeleteRecord(period);
         DaLotteryResult.InsertRecord(records);
     });
 }