public string ChkLoginWebApp(string _adminname, string _adminpass, int iExpires)
{
_adminname = _adminname.Replace("'", "");
string str1 = MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
//str1 = "4f5d4bb4a98a1b7b589833d832ff21664e22c970afb770375bf750cd3b88658c"; //admin
dbOperHandler.SqlCmd = string.Format("select top 1 Id,Point,IsEnable from N_User with(nolock) where username='******' and password='******' and isDel=0", (object)_adminname, (object)str1);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
return(this.JsonResult(0, "您的账户存在未知问题，请于客服联系！"));
}
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
return(this.JsonResult(0, "对不起，您的网络不稳定，请重新登录！"));
}
string str2 = Guid.NewGuid().ToString().Replace("-", "");
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection()
{
{
"id",
dataTable.Rows[0]["Id"].ToString()
},
{
"name",
_adminname
},
{
"cookiess",
str2
},
{
"point",
dataTable.Rows[0]["Point"].ToString()
}
}, this.site.CookieDomain, this.site.CookiePath);
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id and IsEnable=0";
dbOperHandler.AddConditionParameter("@Id", (object)dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", (object)IPHelp.ClientIP);
dbOperHandler.AddFieldItem("sessionId", (object)str2);
dbOperHandler.AddFieldItem("IsOnline", (object)1);
dbOperHandler.AddFieldItem("Source", (object)0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
return(dataTable.Rows[0]["Id"].ToString());
}
dbOperHandler.Dispose();
return(this.JsonResult(0, "会员账号或密码错误！"));
}
}
public string ChkLoginWebApp(string _adminname, string _adminpass, int iExpires)
{
_adminname = _adminname.Replace("'", "");
string arg = MD5.Last64(_adminpass);
string result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("select top 1 Id,Point,IsEnable from N_User with(nolock) where username='******' and password='******' and isDel=0", _adminname, arg);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
result = base.JsonResult(0, "您的账户存在未知问题，请于客服联系！");
}
else if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
result = base.JsonResult(0, "对不起，您的网络不稳定，请重新登录！");
}
else
{
string text = Guid.NewGuid().ToString().Replace("-", "");
NameValueCollection nameValueCollection = new NameValueCollection();
nameValueCollection.Add("id", dataTable.Rows[0]["Id"].ToString());
nameValueCollection.Add("name", _adminname);
nameValueCollection.Add("cookiess", text);
nameValueCollection.Add("point", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection, this.site.CookieDomain, this.site.CookiePath);
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id and IsEnable=0";
dbOperHandler.AddConditionParameter("@Id", dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", IPHelp.ClientIP);
dbOperHandler.AddFieldItem("sessionId", text);
dbOperHandler.AddFieldItem("IsOnline", 1);
dbOperHandler.AddFieldItem("Source", 0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
result = dataTable.Rows[0]["Id"].ToString();
}
}
else
{
dbOperHandler.Dispose();
result = base.JsonResult(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 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);
}
}
