public int Insert(LotteryLogInfo lotteryLogInfo) { var lotteryLogID = 0; IDataParameter[] parms = null; var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(lotteryLogInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, SQL_INSERT, parms); lotteryLogID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(lotteryLogID); }
public int Insert(LotteryLogInfo lotteryLogInfo) { var lotteryLogId = 0; IDataParameter[] parms = null; var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(lotteryLogInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { lotteryLogId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(lotteryLogId); }
public void AddCount(int publishmentSystemID, int lotteryID, string cookieSN, string wxOpenID, string userName, int maxCount, int maxDailyCount, out bool isMaxCount, out bool isMaxDailyCount) { isMaxCount = false; isMaxDailyCount = false; var logInfo = GetLogInfo(lotteryID, cookieSN, wxOpenID, userName); if (logInfo == null) { logInfo = new LotteryLogInfo { PublishmentSystemID = publishmentSystemID, LotteryID = lotteryID, CookieSN = cookieSN, WXOpenID = wxOpenID, UserName = userName, LotteryCount = 1, LotteryDailyCount = 1, LastLotteryDate = DateTime.Now }; IDataParameter[] parms = null; var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(logInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); ExecuteNonQuery(SQL_INSERT, parms); } else { if (maxCount > 0 && logInfo.LotteryCount >= maxCount) { isMaxCount = true; } else { var theSameDay = DateUtils.IsTheSameDay(DateTime.Now, logInfo.LastLotteryDate); if (theSameDay) { if (maxDailyCount > 0 && logInfo.LotteryDailyCount >= maxDailyCount) { isMaxDailyCount = true; } } if (!isMaxDailyCount) { string sqlString = $"UPDATE {TABLE_NAME} SET {LotteryLogAttribute.LotteryCount} = {LotteryLogAttribute.LotteryCount} + 1, {LotteryLogAttribute.LotteryDailyCount} = 1, {LotteryLogAttribute.LastLotteryDate} = getdate() WHERE ID = {logInfo.ID}"; if (theSameDay) { sqlString = $"UPDATE {TABLE_NAME} SET {LotteryLogAttribute.LotteryCount} = {LotteryLogAttribute.LotteryCount} + 1, {LotteryLogAttribute.LotteryDailyCount} = {LotteryLogAttribute.LotteryDailyCount} + 1, {LotteryLogAttribute.LastLotteryDate} = getdate() WHERE ID = {logInfo.ID}"; } ExecuteNonQuery(sqlString); } } } }
private LotteryLogInfo GetLogInfo(int lotteryID, string cookieSN, string wxOpenID, string userName) { LotteryLogInfo logInfo = null; string SQL_WHERE = $"WHERE {LotteryLogAttribute.LotteryID} = {lotteryID} AND {LotteryLogAttribute.CookieSN} = '{cookieSN}'"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { if (rdr.Read()) { logInfo = new LotteryLogInfo(rdr); } rdr.Close(); } return(logInfo); }
private LotteryLogInfo GetLogInfo(int lotteryId, string cookieSn, string wxOpenId, string userName) { LotteryLogInfo logInfo = null; string sqlWhere = $"WHERE {LotteryLogAttribute.LotteryId} = {lotteryId} AND {LotteryLogAttribute.CookieSn} = '{cookieSn}'"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { logInfo = new LotteryLogInfo(rdr); } rdr.Close(); } return(logInfo); }
public List <LotteryLogInfo> GetLotteryLogInfoList(int publishmentSystemID, int lotteryID) { var lotteryLogInfoList = new List <LotteryLogInfo>(); string SQL_WHERE = $"WHERE {LotteryLogAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryLogAttribute.LotteryID} = {lotteryID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { while (rdr.Read()) { var lotteryLogInfo = new LotteryLogInfo(rdr); lotteryLogInfoList.Add(lotteryLogInfo); } rdr.Close(); } return(lotteryLogInfoList); }
public List <LotteryLogInfo> GetLotteryLogInfoList(int publishmentSystemId, int lotteryId) { var lotteryLogInfoList = new List <LotteryLogInfo>(); string sqlWhere = $"WHERE {LotteryLogAttribute.PublishmentSystemId} = {publishmentSystemId} AND {LotteryLogAttribute.LotteryId} = {lotteryId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { while (rdr.Read()) { var lotteryLogInfo = new LotteryLogInfo(rdr); lotteryLogInfoList.Add(lotteryLogInfo); } rdr.Close(); } return(lotteryLogInfoList); }