public bool IsAuto(int lotteryId)
{
bool result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", lotteryId);
int num = Convert.ToInt32(dbOperHandler.GetField("Sys_Lottery", "IsAuto"));
result = (num == 0);
}
return(result);
}
public void Update(DataTable dt)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", dt.Rows[i]["Id"].ToString());
dbOperHandler.AddFieldItem("IsRead", "1");
dbOperHandler.Update("N_UserMessage");
}
}
}
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, string _userId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)_userId);
string str = string.Concat(dbOperHandler.GetField("N_User", "ParentId"));
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
int totalCount = dbOperHandler.Count("N_UserEmail");
string sql0 = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid," + str + " as parentid,dbo.f_GetUserName(SendId) as SendName,dbo.f_GetUserName(ReceiveId) as ReceiveName,*", "N_UserEmail", "STime", _pagesize, _thispage, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql0;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public bool SaveMobile(string _userid, string _name)
{
bool result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
dbOperHandler.AddFieldItem("Mobile", _name);
if (dbOperHandler.Update("N_User") > 0)
{
result = true;
}
else
{
result = false;
}
}
return(result);
}
public int BetCancel(string betId)
{
int result;
using (SqlConnection sqlConnection = new SqlConnection(ComData.connectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
try
{
object[] array = new object[6];
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", betId);
array = dbOperHandler.GetFields("N_UserBet", "UserId,IssueNum,LotteryId,PlayId,Total,Times,ssid,STime");
}
decimal money = Convert.ToDecimal(Convert.ToDecimal(array[4]) * Convert.ToDecimal(array[5]));
if (new UserTotalTran().MoneyOpers(array[6].ToString(), array[0].ToString(), money, Convert.ToInt32(array[2].ToString()), Convert.ToInt32(array[3].ToString()), Convert.ToInt32(betId), 6, 99, string.Empty, string.Empty, "会员撤单", array[7].ToString()) > 0)
{
sqlCommand.CommandText = "update N_UserBet set State=1 where Id=" + betId;
sqlCommand.ExecuteNonQuery();
result = 1;
}
else
{
result = 0;
}
}
catch (Exception ex)
{
new LogExceptionDAL().Save("系统异常", ex.Message);
result = 0;
}
}
return(result);
}
public string ChkAutoLoginWebApp(string _Id, string _sessionId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("select top 1 UserName,Point,sessionId from N_User with(nolock) where Id={0}", _Id);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(string.Concat(dataTable.Rows[0]["sessionId"])))
{
NameValueCollection nameValueCollection = new NameValueCollection();
nameValueCollection.Add("id", _Id);
nameValueCollection.Add("name", dataTable.Rows[0]["UserName"].ToString());
nameValueCollection.Add("cookiess", dataTable.Rows[0]["sessionId"].ToString());
nameValueCollection.Add("point", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection, this.site.CookieDomain, this.site.CookiePath);
}
else
{
string text = Guid.NewGuid().ToString().Replace("-", "");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", _Id);
dbOperHandler.AddFieldItem("sessionId", text);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
NameValueCollection nameValueCollection2 = new NameValueCollection();
nameValueCollection2.Add("id", _Id);
nameValueCollection2.Add("name", dataTable.Rows[0]["UserName"].ToString());
nameValueCollection2.Add("cookiess", text);
nameValueCollection2.Add("point", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection2, this.site.CookieDomain, this.site.CookiePath);
}
}
}
return(_Id);
}
public Decimal GetMaxMoney(int userId)
{
Decimal num = new Decimal(0);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 ISNULL(MoneyAfter,0) as MoneyAfter from N_UserMoneyLog with(nolock) where userId=" + (object)userId + " order by Id desc";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
num = Convert.ToDecimal(dataTable.Rows[0]["MoneyAfter"].ToString());
}
else
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)userId);
num = Convert.ToDecimal(dbOperHandler.GetField("N_User", "Money"));
}
}
return(num);
}
public string ChkAutoLoginWebApp(string _Id, string _sessionId, int iExpires)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("select top 1 UserName,Point,sessionId from N_User with(nolock) where Id={0}", (object)_Id);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(string.Concat(dataTable.Rows[0]["sessionId"])))
{
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection()
{
{
"id",
_Id
},
{
"name",
dataTable.Rows[0]["UserName"].ToString()
},
{
"cookiess",
dataTable.Rows[0]["sessionId"].ToString()
},
{
"point",
dataTable.Rows[0]["Point"].ToString()
}
}, "www.youle1288.com;youle1288.com;www.youle2888.com;youle2888.com,feifan1188.com,www.feifan1188.com", this.site.CookiePath);
}
else
{
string str = Guid.NewGuid().ToString().Replace("-", "");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)_Id);
dbOperHandler.AddFieldItem("sessionId", (object)str);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection()
{
{
"id",
_Id
},
{
"name",
dataTable.Rows[0]["UserName"].ToString()
},
{
"cookiess",
str
},
{
"point",
dataTable.Rows[0]["Point"].ToString()
}
}, "www.youle1288.com;youle1288.com;www.youle2888.com;youle2888.com,feifan1188.com,www.feifan1188.com", this.site.CookiePath);
}
}
return(_Id);
}
}
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 = "领取失败，活动已关闭！";
}
}
}