/// <summary> /// 组装查询语句 /// </summary> /// <param name="type">枚举码</param> /// <param name="arg"></param> /// <returns></returns> private string GetSeleteSQL(SCCLottery type, HistoryLotteryArgEnyity arg) { StringBuilder builder = new StringBuilder(); string res = String.Empty; int total = type.GetEnumText().TryToInt32(); string tableName = type.GetSCCLotteryTableName(); for (int i = 1; i <= total; i++) { builder.Append("[OpenCode" + i + "],"); } if (arg.TotalRecord > 0) { res = string.Format(GetLotterySqlByTableNameWithTop, arg.TotalRecord, StringHelper.DelLastChar(builder.ToString(), ","), tableName); } else if (!string.IsNullOrEmpty(arg.StartTime)) { string time = arg.StartTime.CheckDateTime() ? arg.StartTime : DateTimeHelper.Now.AddDays(-7).ToString("yyyy-MM-dd"); res = string.Format(GetLotterySqlByTableNameWithStartTime, StringHelper.DelLastChar(builder.ToString(), ","), tableName, time); } else { res = string.Format(GetLotterySqlByTableNameWithTop, "20", StringHelper.DelLastChar(builder.ToString(), ","), tableName); } return(res); }
/// <summary> /// 新增彩种开奖数据 /// </summary> /// <param name="lottery">彩种名称</param> /// <param name="model">开奖数据模型</param> /// <returns></returns> public bool AddOpen21Code(SCCLottery lottery, OpenCode21Model model) { var TableName = lottery.GetSCCLotteryTableName(); var sqlString = string.Format(AddItemSql, TableName); DbParameter[] param = new DbParameter[] { new SqlParameter("@Term", model.Term), new SqlParameter("@OpenCode1", model.OpenCode1), new SqlParameter("@OpenCode2", model.OpenCode2), new SqlParameter("@OpenCode3", model.OpenCode3), new SqlParameter("@OpenCode4", model.OpenCode4), new SqlParameter("@OpenCode5", model.OpenCode5), new SqlParameter("@OpenCode6", model.OpenCode6), new SqlParameter("@OpenCode7", model.OpenCode7), new SqlParameter("@OpenCode8", model.OpenCode8), new SqlParameter("@OpenCode9", model.OpenCode9), new SqlParameter("@OpenCode10", model.OpenCode10), new SqlParameter("@OpenCode11", model.OpenCode11), new SqlParameter("@OpenCode12", model.OpenCode12), new SqlParameter("@OpenCode13", model.OpenCode13), new SqlParameter("@OpenCode14", model.OpenCode14), new SqlParameter("@OpenCode15", model.OpenCode15), new SqlParameter("@OpenCode16", model.OpenCode16), new SqlParameter("@OpenCode17", model.OpenCode17), new SqlParameter("@OpenCode18", model.OpenCode18), new SqlParameter("@OpenCode19", model.OpenCode19), new SqlParameter("@OpenCode20", model.OpenCode20), new SqlParameter("@OpenCode21", model.OpenCode21), new SqlParameter("@OpenTime", model.OpenTime), new SqlParameter("@ID", Guid.NewGuid().ToString().Replace("-", "")) }; var result = this.BaseRepository(DatabaseLinksEnum.LotteryNumber).ExecuteBySql(sqlString, param); return(result > 0); }
public ActionResult GetTodaysLottery() { Dictionary <string, SCCConfig> dict = GetTodayLotteryDict(); List <TodaysLotteryViewEntity> obj = new List <TodaysLotteryViewEntity>(); foreach (KeyValuePair <string, SCCConfig> pair in dict) { SCCConfig config = pair.Value; SCCLottery type = (SCCLottery)Enum.Parse(typeof(SCCLottery), config.EnumCode, true); //当前彩种今天真实开始开奖时间 DateTime todayRealStartOpentime = (DateTimeHelper.Now.ToString("yyyy-MM-dd") + " " + config.StartHour + ":" + config.StartMinute).TryToDateTime(); //如果当前时间大于当前彩种今天真实开始开奖时间,则忽略 if (DateTimeHelper.Now < todayRealStartOpentime) { string lastTerm = qgfc3Dbll.GetNewTermByTableName(type.GetSCCLotteryTableName()); obj.Add(new TodaysLotteryViewEntity { LotteryName = config.LotteryName, Term = lastTerm, OpenTime = todayRealStartOpentime, MainUrl = config.MainUrl, EnumCode = config.EnumCode }); } } obj = obj.OrderBy(o => o.OpenTime).ToList(); return(Success("操作成功", obj.ToJson())); }
/// <summary> /// 获取最新一条记录 /// </summary> /// <param name="lottery">彩种名称</param> /// <returns></returns> public OpenCode7Model GetLastItem(SCCLottery lottery) { var TableName = lottery.GetSCCLotteryTableName(); var sqlString = string.Format(LastItemSql, TableName); var ds = this.BaseRepository(DatabaseLinksEnum.LotteryNumber).FindTable(sqlString); if (ds != null && ds.DataSet.Tables.Count > 0 && ds.DataSet.Tables[0].Rows.Count > 0) { var result = BaseServices.LoadData <OpenCode7Model>(ds.DataSet.Tables[0].Rows[0]); return(result); } return(null); }
/// <summary> /// 新增彩种开奖数据 /// </summary> /// <param name="lottery">彩种名称</param> /// <param name="model">开奖数据模型</param> /// <returns></returns> public bool AddOpen3Code(SCCLottery lottery, OpenCode3Model model) { var TableName = lottery.GetSCCLotteryTableName(); var sqlString = string.Format(AddItemSql, TableName); DbParameter[] param = new DbParameter[] { new SqlParameter("@Term", model.Term), new SqlParameter("@OpenCode1", model.OpenCode1), new SqlParameter("@OpenCode2", model.OpenCode2), new SqlParameter("@OpenCode3", model.OpenCode3), new SqlParameter("@OpenTime", model.OpenTime), new SqlParameter("@ID", Guid.NewGuid().ToString().Replace("-", "")) }; var result = this.BaseRepository(DatabaseLinksEnum.LotteryNumber).ExecuteBySql(sqlString, param); return(result > 0); }