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 = "领取失败，活动已关闭！";
}
}
}
