public string UserInfo(string UserId, string SessionId)
{
if (!(UserId != "0") || !(SessionId != "0"))
{
return(this.GetJsonResult(0, "登陆已超时，请您重新登陆！"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT '1' as result,Id,Money,IsDel,IsEnable,sessionId\r\n ,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point\r\n ,'0' as email\r\n ,'0' as notice\r\n FROM [N_User] a where Id={0} and sessionId='{1}'", (object)UserId, (object)SessionId);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["IsDel"].Equals((object)"1") || dataTable.Rows[0]["IsEnable"].Equals((object)"1"))
{
return(this.GetJsonResult(0, "您的账户存在未知问题，请于客服联系！"));
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)UserId);
dbOperHandler.AddFieldItem("ontime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsOnline", (object)1);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
return(this.ConverTableToJSON(dataTable));
}
dbOperHandler.Dispose();
return(this.GetJsonResult(0, "登陆已超时，请您重新登陆"));
}
}
public string Login(string UserName, string UserPass)
{
UserName = UserName.ToLower().Replace("'", "");
UserPass = MD5.Last64(MD5.Lower32(UserPass));
string text = Guid.NewGuid().ToString().Replace("-", "");
string result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT TOP 1 '1' as result,a.Id,ParentId,UserGroup,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point,\r\n UserName,Money,'{0}' as SessionId,LastTime,OnTime,IP,a.IsEnable,IsGetCash,IsBet,IsTranAcc,EnableSeason,LoginId,\r\n case when b.Id is null then '0' else '1' end as IsBank,'0' as email,'0' as notice \r\n FROM N_User a left join N_UserBank b on a.Id=b.UserId\r\n where username='******' and password='******' and isDel=0", text, UserName, UserPass);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
result = base.GetJsonResult(0, "您的账户存在未知问题，请于客服联系！");
}
else if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
result = base.GetJsonResult(0, "对不起，您的网络不稳定，请重新登录！！");
}
else
{
this.ClearSession();
Cookie.SetObj("UserId", dataTable.Rows[0]["Id"].ToString());
Cookie.SetObj("UserName", UserName);
Cookie.SetObj("UserPoint", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj("SessionId", text);
string clientIP = IPHelp.ClientIP;
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("ontime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", clientIP);
dbOperHandler.AddFieldItem("sessionId", text);
dbOperHandler.AddFieldItem("IsOnline", 1);
dbOperHandler.AddFieldItem("Source", 0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
IPScaner iPScaner = new IPScaner();
iPScaner.DataPath = HttpContext.Current.Server.MapPath("Data/qqwry.dat");
iPScaner.IP = clientIP;
string address = iPScaner.IPLocation() + iPScaner.ErrMsg;
string browser = HttpContext.Current.Request.Browser.Browser + " " + HttpContext.Current.Request.Browser.Version;
string oSNameByUserAgent = this.GetOSNameByUserAgent(HttpContext.Current.Request.UserAgent);
new LogUserLoginDAL().Save(dataTable.Rows[0]["Id"].ToString(), address, browser, oSNameByUserAgent, clientIP);
result = base.ConverTableToJSON(dataTable);
}
}
else
{
dbOperHandler.Dispose();
result = base.GetJsonResult(0, "登录失败，用户名或密码错误！");
}
}
return(result);
}
