/// <summary> /// 判断当前期在数据库是否已经存在 /// </summary> /// <param name="issueNo"></param> /// <returns></returns> private static bool Exists(long issueNo, string lotteryCode, string dataSource) { string sql = $"select * from open_result where issue_number = {issueNo} and lottery_code = '{lotteryCode}' and data_source = '{dataSource}'"; OpenResult o = MysqlHelper.GetOne <OpenResult>(sql); return(o != null && o.id > 0); }
private static bool Exist(string lotteryCode) { string sql = $"select * from lottery where code = '{lotteryCode}'"; return(MysqlHelper.GetOne <OpenResult>(sql) != null); }
/// <summary> /// 根据id获取日志信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static AppLog GetLogById(string id) { string sql = $"select log_message from app_log where id = {id}"; return(MysqlHelper.GetOne <AppLog>(sql)); }