public void ClearUser()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5";
if (dbOperHandler.Exist("N_User"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5";
dbOperHandler.AddFieldItem("IsOnline", "0");
dbOperHandler.AddFieldItem("SessionId", Guid.NewGuid().ToString().Replace("-", ""));
dbOperHandler.Update("N_User");
}
}
}
public void SaveUserRegLink(string UserId, decimal Point, string YxTime, string Times, string Url)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new object[]
{
"UserId=",
UserId,
" and Point=",
Point
});
if (dbOperHandler.Exist("N_UserRegLink"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new object[]
{
"UserId=",
UserId,
" and Point=",
Point
});
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("Point", Point);
dbOperHandler.AddFieldItem("YxTime", YxTime);
dbOperHandler.AddFieldItem("Times", Times);
dbOperHandler.AddFieldItem("Url", Url);
dbOperHandler.Update("N_UserRegLink");
}
else
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("Point", Point);
dbOperHandler.AddFieldItem("YxTime", YxTime);
dbOperHandler.AddFieldItem("Times", Times);
dbOperHandler.AddFieldItem("Url", Url);
dbOperHandler.Insert("N_UserRegLink");
}
}
}
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 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 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);
}
}
