Beispiel #1
0
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="appLog"></param>
        /// <returns></returns>
        public static int Insert(AppLog appLog)
        {
            string sql = "insert into app_log (create_time, create_timestamp, log_type, lottery_code, data_source, log_message)"
                         + "values(@create_time, @create_timestamp, @log_type, @lottery_code, @data_source, @log_message)";

            return(MysqlHelper.Execute(sql, appLog));
        }
Beispiel #2
0
        /// <summary>
        /// 清除指定时间之前的开奖结果
        /// </summary>
        /// <param name="timestamp"></param>
        /// <returns></returns>
        public static int Delete(long timestamp)
        {
            string sql = "detele from open_result where create_timestamp < {0}";

            sql = string.Format(sql, timestamp);
            return(MysqlHelper.Execute(sql));
        }
Beispiel #3
0
        /// <summary>
        /// 批量插入
        /// </summary>
        /// <param name="resultList"></param>
        /// <returns></returns>
        public static int Insert(List <OpenResult> resultList)
        {
            if (resultList.Count == 0)
            {
                return(1);
            }

            string sql = "insert into open_result (create_time, create_timestamp, open_time, open_timestamp, lottery_code, issue_number, open_data, data_source, is_legal) "
                         + "values (@create_time, @create_timestamp, @open_time, @open_timestamp, @lottery_code, @issue_number, @open_data, @data_source, @is_legal)";

            return(MysqlHelper.Execute(sql, resultList.Where(o => !Exists(o.issue_number, o.lottery_code, o.data_source)).OrderBy(o => o.issue_number)));
        }
Beispiel #4
0
        /// <summary>
        /// 修改状态
        /// </summary>
        /// <param name="id"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public static int UpdateStatus(string id, int status)
        {
            string sql = $"update lottery set status = {status}, update_time='{DateTime.Now}', update_timestamp={DateTime.Now.ToTimestamp()} where id in ({id})";

            return(MysqlHelper.Execute(sql));
        }
Beispiel #5
0
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public static int Insert(List <Lottery> list)
        {
            string sql = "insert into lottery (create_time, create_timestamp, name, code) values (@create_time, @create_timestamp, @name, @code)";

            return(MysqlHelper.Execute(sql, list.Where(l => !Exist(l.code))));
        }
        /// <summary>
        /// 修改状态
        /// </summary>
        /// <param name="id"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public static int UpdateStatus(int id, int status)
        {
            string sql = $"update data_source set status = {status}, update_time='{DateTime.Now}', update_timestamp={DateTime.Now.ToTimestamp()} where id = {id}";

            return(MysqlHelper.Execute(sql));
        }
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public static int Insert(List <DataSource> list)
        {
            string sql = "insert into data_source (create_time, create_timestamp, name, code) values (@create_time, @create_timestamp, @name, @code)";

            return(MysqlHelper.Execute(sql, list));
        }