public int BetCancel(string betId) { using (SqlConnection sqlConnection = new SqlConnection(ComData.connectionString)) { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = sqlConnection; try { object[] objArray = new object[6]; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)betId); objArray = dbOperHandler.GetFields("N_UserBet", "UserId,IssueNum,LotteryId,PlayId,Total,Times,ssid,STime"); } Decimal Money = Convert.ToDecimal(Convert.ToDecimal(objArray[4]) * Convert.ToDecimal(objArray[5])); if (new UserTotalTran().MoneyOpers(objArray[6].ToString(), objArray[0].ToString(), Money, Convert.ToInt32(objArray[2].ToString()), Convert.ToInt32(objArray[3].ToString()), Convert.ToInt32(betId), 6, 99, string.Empty, string.Empty, "会员撤单", objArray[7].ToString()) <= 0) { return(0); } sqlCommand.CommandText = "update N_UserBet set State=1 where Id=" + betId; sqlCommand.ExecuteNonQuery(); return(1); } catch (Exception ex) { new LogExceptionDAL().Save("系统异常", ex.Message); return(0); } } }
public void GetActive7Money(string userId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Code=@Code"; dbOperHandler.AddConditionParameter("@Code", "Active7"); object[] fields = dbOperHandler.GetFields("Act_ActiveSet", "StartTime,EndTime,IsUse"); if (Convert.ToInt32(fields[2]) == 1) { if (new DateTimePubDAL().GetDateTime() >= Convert.ToDateTime(fields[0]) && new DateTimePubDAL().GetDateTime() <= Convert.ToDateTime(fields[1])) { Random random = new Random(); decimal num = random.Next(this.site.SignMinTotal, this.site.SignMaxTotal); SysActiveRecordDAL sysActiveRecordDAL = new SysActiveRecordDAL(); string clientIP = IPHelp.ClientIP; dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "ActiveType='Active7' and datediff(d,STime,getdate())=0"; int num2 = dbOperHandler.Count("Act_ActiveRecord"); if (num2 <= this.site.SignNum) { if (!sysActiveRecordDAL.Exists("UserId=" + userId + " and ActiveType='Active7' and datediff(d,STime,getdate())=0")) { if (!sysActiveRecordDAL.Exists("CheckIp='" + clientIP + "' and ActiveType='Active7' and datediff(d,STime,getdate())=0")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + userId; int num3 = dbOperHandler.Count("N_UserBank"); if (num3 > 0) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + userId + " and state=0"; int num4 = dbOperHandler.Count("N_UserBet"); if (num4 > 0) { _jsonstr = "您还有未开奖的订单,请开奖后再领取!"; } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select Bet,Cancellation from N_UserMoneyStatAll where UserId=" + userId + " and datediff(d,STime,getdate())=0"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (Convert.ToDecimal(dataTable.Rows[0]["Bet"]) - Convert.ToDecimal(dataTable.Rows[0]["Cancellation"]) < 50m) { _jsonstr = "签到领现失败,您的流水未得到50元!"; } else { sysActiveRecordDAL.SaveLog(userId, "Active7", "签到领现", num, "您签到领取了" + num + "元"); _jsonstr = "签到领现成功" + num + "元"; new LogSysDAL().Save("系统活动", string.Concat(new object[] { userId, "领取签到佣金", num, "元" })); } } else { _jsonstr = "签到领现失败,您的流水未得到50元!"; } } } else { _jsonstr = "签到领现失败,您未绑定银行!"; } } else { _jsonstr = "签到领现失败,您当前IP今天已领取!"; } } else { _jsonstr = "签到领现失败,您今天已领取!"; } } else { _jsonstr = "签到领现失败,今天领取已得到名额!"; } } else { _jsonstr = "领取失败,活动时间已过!"; } } else { _jsonstr = "领取失败,活动已关闭!"; } } }