public static bool SetStudentCookies(LearnSite.Model.Students stumod, string logip)
{
bool isset = false;
if (stumod != null)
{
LearnSite.BLL.Signin gbll = new BLL.Signin();
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
if (rm.IsLoginLock(stumod.Sgrade.Value, stumod.Sclass.Value))
{
if (gbll.IsSameIp(stumod.Snum, logip))
{
//如果全班IP登录锁定，如果IP不变 写cookies
isset = SetStuCookie(stumod, logip);
}
}
else
{
//如果全班IP不锁定，写cookies
isset = SetStuCookie(stumod, logip);
}
}
return(isset);
}
/// <summary>
/// 设置学生的cookies值
/// </summary>
/// <param name="stmodel"></param>
///Snum,Syear,Sgrade,Sclass,Sname,Spwd,Sex,Saddress,Sphone,Sparents,Sheadtheacher,Sscore,Sattitude,Sape
public static bool SetStuCookie(LearnSite.Model.Students stmodel, string LoginIp)
{
if (stmodel != null)
{
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
string Rhid = rm.GetRoomRhid(stmodel.Sgrade.Value, stmodel.Sclass.Value);
DateTime LoginTime = DateTime.Now;
LearnSite.BLL.Webstudy wbll = new LearnSite.BLL.Webstudy();
string FtpPwd = wbll.FindWebFtpPwd(stmodel.Snum);
string ThisTerm = LearnSite.Common.XmlHelp.GetTerm();
HttpCookie StuCookie = new HttpCookie(stuCookieNname);
if (stmodel.Sex == null)
{
stmodel.Sex = "无";
}
if (stmodel.Sscore == null)
{
stmodel.Sscore = 0;
}
if (stmodel.Squiz == null)
{
stmodel.Squiz = 0;
}
if (stmodel.Sattitude == null)
{
stmodel.Sattitude = 0;
}
if (stmodel.Sape == null)
{
stmodel.Sape = "无";
}
if (stmodel.Sgroup == null)
{
stmodel.Sgroup = 0;
}
StuCookie.Values.Add("Sid", stmodel.Sid.ToString());
StuCookie.Values.Add("Snum", UrlEncode(stmodel.Snum));
StuCookie.Values.Add("Syear", stmodel.Syear.ToString());
StuCookie.Values.Add("Sgrade", stmodel.Sgrade.ToString());
StuCookie.Values.Add("Sclass", stmodel.Sclass.ToString());
StuCookie.Values.Add("Sname", UrlEncode(stmodel.Sname.Trim()));
StuCookie.Values.Add("Spwd", Common.WordProcess.GetMD5_8bit(stmodel.Spwd));
StuCookie.Values.Add("Sex", UrlEncode(stmodel.Sex));
StuCookie.Values.Add("Sscore", stmodel.Sscore.ToString());
StuCookie.Values.Add("Squiz", stmodel.Squiz.ToString());
StuCookie.Values.Add("Sattitude", stmodel.Sattitude.ToString());
StuCookie.Values.Add("Sape", UrlEncode(stmodel.Sape));
StuCookie.Values.Add("Sgroup", stmodel.Sgroup.ToString());
StuCookie.Values.Add("LoginTime", LoginTime.ToString());
StuCookie.Values.Add("LoginIp", LoginIp);
StuCookie.Values.Add("Ftppwd", FtpPwd);
StuCookie.Values.Add("ThisTerm", ThisTerm);
StuCookie.Values.Add("Rhid", Rhid);
StuCookie.Values.Add("RankImage", UrlEncode(LearnSite.Common.Rank.RankImage(stmodel.Sscore.Value + stmodel.Sattitude.Value, true)));
StuCookie.Values.Add("Ss", Common.WordProcess.GetMD5_8bit(stmodel.Snum));
string str = LearnSite.Common.XmlHelp.GetStudentCookiesPeriod();
StuCookie.Expires = StudentCookiesPeriod(str);
StuCookie.Path = "/";
StuCookie.HttpOnly = true;
HttpContext.Current.Response.AppendCookie(StuCookie);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 模拟该班级学生登录cookies设置
/// </summary>
/// <param name="Sgrade"></param>
/// <param name="Sclass"></param>
public static void SimulationStudentCookies(int Sgrade, int Sclass)
{
if (HttpContext.Current.Request.Cookies[teaCookieNname] != null)
{
string Rhid = HttpContext.Current.Request.Cookies[teaCookieNname].Values["Hid"].ToString();
LearnSite.BLL.Students stubll = new BLL.Students();
LearnSite.Model.Students sModel = new LearnSite.Model.Students();
string sss = Rhid + Sgrade.ToString() + Sclass.ToString();
sModel.Sid = 0 - Int32.Parse(sss);
string Syear = stubll.GetYear(Sgrade);
sModel.Syear = Int32.Parse(Syear);
sModel.Snum = "s" + Rhid + Syear.ToString() + Sgrade.ToString() + Sclass.ToString();
sModel.Sgrade = Sgrade;
sModel.Sclass = Sclass;
sModel.Sname = "学生" + Sgrade.ToString() + Sclass.ToString();
sModel.Spwd = "12345678";
sModel.Sex = "男";
sModel.Sscore = 100;
sModel.Squiz = 50;
sModel.Sattitude = 25;
sModel.Sape = "A";
sModel.Sgroup = 0;
DateTime LoginTime = DateTime.Now;
string LoginIp = LearnSite.Common.Computer.GetGuestIP();
string FtpPwd = LearnSite.Common.WordProcess.GetMD5_Nbit(Rhid, 18);
string ThisTerm = LearnSite.Common.XmlHelp.GetTerm();
HttpCookie StuCookie = new HttpCookie(stuCookieNname);
StuCookie.Values.Add("Sid", sModel.Sid.ToString());
StuCookie.Values.Add("Snum", UrlEncode(sModel.Snum));
StuCookie.Values.Add("Syear", sModel.Syear.ToString());
StuCookie.Values.Add("Sgrade", sModel.Sgrade.ToString());
StuCookie.Values.Add("Sclass", sModel.Sclass.ToString());
StuCookie.Values.Add("Sname", UrlEncode(sModel.Sname));
StuCookie.Values.Add("Spwd", sModel.Spwd.ToString());
StuCookie.Values.Add("Sex", UrlEncode(sModel.Sex));
StuCookie.Values.Add("Sscore", sModel.Sscore.ToString());
StuCookie.Values.Add("Squiz", sModel.Squiz.ToString());
StuCookie.Values.Add("Sattitude", sModel.Sattitude.ToString());
StuCookie.Values.Add("Sape", sModel.Sape.ToString());
StuCookie.Values.Add("Sgroup", sModel.Sgroup.ToString());
StuCookie.Values.Add("LoginTime", LoginTime.ToString());
StuCookie.Values.Add("LoginIp", LoginIp);
StuCookie.Values.Add("Ftppwd", FtpPwd);
StuCookie.Values.Add("ThisTerm", ThisTerm);
StuCookie.Values.Add("Rhid", Rhid);
StuCookie.Values.Add("RankImage", UrlEncode(LearnSite.Common.Rank.RankImage(sModel.Sscore.Value + sModel.Sattitude.Value, true)));
StuCookie.Values.Add("Ss", Common.WordProcess.GetMD5_8bit(sModel.Snum));
string str = LearnSite.Common.XmlHelp.GetStudentCookiesPeriod();
if (str != "0")
{
StuCookie.Expires = StudentCookiesPeriod(str);
StuCookie.Path = "/";
StuCookie.HttpOnly = true;
}
HttpContext.Current.Response.AppendCookie(StuCookie);
LearnSite.Common.App.AppUserAdd(sModel.Snum);
}
}
/// <summary>
/// ����ѧ�ţ��õ�һ������ʵ��
/// </summary>
public LearnSite.Model.Students SnumGetModel(string Snum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Sid,Snum,Syear,Sgrade,Sclass,Sname,Spwd,Sex,Saddress,Sphone,Sparents,Sheadtheacher,Sscore,Squiz,Sattitude,Sape from Students ");
strSql.Append(" where Snum=@Snum ");
SqlParameter[] parameters = {
new SqlParameter("@Snum", SqlDbType.NVarChar,50)};
parameters[0].Value = Snum;
LearnSite.Model.Students model = new LearnSite.Model.Students();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Sid"].ToString() != "")
{
model.Sid = int.Parse(ds.Tables[0].Rows[0]["Sid"].ToString());
}
model.Snum = ds.Tables[0].Rows[0]["Snum"].ToString();
if (ds.Tables[0].Rows[0]["Syear"].ToString() != "")
{
model.Syear = int.Parse(ds.Tables[0].Rows[0]["Syear"].ToString());
}
if (ds.Tables[0].Rows[0]["Sgrade"].ToString() != "")
{
model.Sgrade = int.Parse(ds.Tables[0].Rows[0]["Sgrade"].ToString());
}
if (ds.Tables[0].Rows[0]["Sclass"].ToString() != "")
{
model.Sclass = int.Parse(ds.Tables[0].Rows[0]["Sclass"].ToString());
}
model.Sname = ds.Tables[0].Rows[0]["Sname"].ToString();
model.Spwd = ds.Tables[0].Rows[0]["Spwd"].ToString();
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
model.Saddress = ds.Tables[0].Rows[0]["Saddress"].ToString();
model.Sphone = ds.Tables[0].Rows[0]["Sphone"].ToString();
model.Sparents = ds.Tables[0].Rows[0]["Sparents"].ToString();
model.Sheadtheacher = ds.Tables[0].Rows[0]["Sheadtheacher"].ToString();
if (ds.Tables[0].Rows[0]["Sscore"].ToString() != "")
{
model.Sscore = int.Parse(ds.Tables[0].Rows[0]["Sscore"].ToString());
}
if (ds.Tables[0].Rows[0]["Squiz"].ToString() != "")
{
model.Squiz = int.Parse(ds.Tables[0].Rows[0]["Squiz"].ToString());
}
if (ds.Tables[0].Rows[0]["Sattitude"].ToString() != "")
{
model.Sattitude = int.Parse(ds.Tables[0].Rows[0]["Sattitude"].ToString());
}
model.Sape = ds.Tables[0].Rows[0]["Sape"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 设置学生的cookies值
/// </summary>
/// <param name="stmodel"></param>
///Snum,Syear,Sgrade,Sclass,Sname,Spwd,Sex,Saddress,Sphone,Sparents,Sheadtheacher,Sscore,Sattitude,Sape
public static bool SetStuCookie(LearnSite.Model.Students stmodel, string LoginIp)
{
if (stmodel != null)
{
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
string Rhid = rm.GetRoomRhid(stmodel.Sgrade.Value, stmodel.Sclass.Value);
DateTime LoginTime = DateTime.Now;
string ThisTerm = LearnSite.Common.XmlHelp.GetTerm();
HttpCookie StuCookie = new HttpCookie(stuCookieNname);
if (stmodel.Sex == null)
{
stmodel.Sex = "无";
}
if (stmodel.Sscore == null)
{
stmodel.Sscore = 0;
}
if (stmodel.Squiz == null)
{
stmodel.Squiz = 0;
}
if (stmodel.Sattitude == null)
{
stmodel.Sattitude = 0;
}
if (stmodel.Sape == null)
{
stmodel.Sape = "无";
}
if (stmodel.Sgroup == null)
{
stmodel.Sgroup = 0;
}
if (String.IsNullOrEmpty(Rhid))
{
Rhid = "0";
}
Model.Cook Cook = new Model.Cook();
Cook.Sid = stmodel.Sid;
Cook.Snum = UrlEncode(stmodel.Snum);
Cook.Syear = stmodel.Syear.Value;
Cook.Sgrade = stmodel.Sgrade.Value;
Cook.Sclass = stmodel.Sclass.Value;
Cook.Sname = UrlEncode(stmodel.Sname.Trim());
Cook.Spwd = Common.WordProcess.GetMD5_8bit(stmodel.Spwd);
Cook.Sex = UrlEncode(stmodel.Sex);
Cook.Sscore = stmodel.Sscore.Value;
Cook.Squiz = stmodel.Squiz.Value;
Cook.Sattitude = stmodel.Sattitude.Value;
Cook.Sape = UrlEncode(stmodel.Sape);
Cook.Sgroup = stmodel.Sgroup.Value;
Cook.LoginTime = LoginTime.ToString();
Cook.LoginIp = LoginIp;
Cook.ThisTerm = Int32.Parse(ThisTerm);
Cook.Rhid = Int32.Parse(Rhid);
Cook.RankImage = UrlEncode(LearnSite.Common.Rank.RankImage(stmodel.Sscore.Value + stmodel.Sattitude.Value, true));
Cook.Ss = stuCookieNname;//cookie名称校验
Cook.SessionId = "";
StuCookie.Value = Cook.ToStr();
string str = LearnSite.Common.XmlHelp.GetStudentCookiesPeriod();
StuCookie.Expires = StudentCookiesPeriod(str);
StuCookie.Path = "/";
StuCookie.HttpOnly = true;
HttpContext.Current.Response.AppendCookie(StuCookie);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 模拟该班级学生登录cookies设置
/// </summary>
/// <param name="Sgrade"></param>
/// <param name="Sclass"></param>
public static void SimulationStudentCookies(int Sgrade, int Sclass)
{
if (HttpContext.Current.Request.Cookies[teaCookieNname] != null)
{
Model.TeaCook tcook = new Model.TeaCook();
string Rhid = tcook.Hid.ToString();
LearnSite.BLL.Students stubll = new BLL.Students();
LearnSite.Model.Students sModel = new LearnSite.Model.Students();
string sss = Rhid + Sgrade.ToString() + Sclass.ToString();
sModel.Sid = 0 - Int32.Parse(sss);
string Syear = stubll.GetYear(Sgrade);
sModel.Syear = Int32.Parse(Syear);
sModel.Snum = "s" + Rhid + Syear.ToString() + Sgrade.ToString() + Sclass.ToString();
sModel.Sgrade = Sgrade;
sModel.Sclass = Sclass;
sModel.Sname = "学生" + Sgrade.ToString() + Sclass.ToString();
sModel.Spwd = "12345678";
sModel.Sex = "男";
sModel.Sscore = 100;
sModel.Squiz = 50;
sModel.Sattitude = 25;
sModel.Sape = "A";
sModel.Sgroup = 0;
DateTime LoginTime = DateTime.Now;
string LoginIp = LearnSite.Common.Computer.GetGuestIP();
string ThisTerm = LearnSite.Common.XmlHelp.GetTerm();
HttpCookie StuCookie = new HttpCookie(stuCookieNname);
Model.Cook Cook = new Model.Cook();
Cook.Sid = sModel.Sid;
Cook.Snum = UrlEncode(sModel.Snum);
Cook.Syear = sModel.Syear.Value;
Cook.Sgrade = sModel.Sgrade.Value;
Cook.Sclass = sModel.Sclass.Value;
Cook.Sname = UrlEncode(sModel.Sname.Trim());
Cook.Spwd = Common.WordProcess.GetMD5_8bit(sModel.Spwd);
Cook.Sex = UrlEncode(sModel.Sex);
Cook.Sscore = sModel.Sscore.Value;
Cook.Squiz = sModel.Squiz.Value;
Cook.Sattitude = sModel.Sattitude.Value;
Cook.Sape = UrlEncode(sModel.Sape);
Cook.Sgroup = sModel.Sgroup.Value;
Cook.LoginTime = LoginTime.ToString();
Cook.LoginIp = LoginIp;
Cook.ThisTerm = Int32.Parse(ThisTerm);
Cook.Rhid = Int32.Parse(Rhid);
Cook.RankImage = UrlEncode(LearnSite.Common.Rank.RankImage(sModel.Sscore.Value + sModel.Sattitude.Value, true));
Cook.Ss = stuCookieNname;//cookie名称校验
Cook.SessionId = "";
StuCookie.Value = Cook.ToStr();
string str = LearnSite.Common.XmlHelp.GetStudentCookiesPeriod();
if (str != "0")
{
StuCookie.Expires = StudentCookiesPeriod(str);
StuCookie.Path = "/";
StuCookie.HttpOnly = true;
}
HttpContext.Current.Response.AppendCookie(StuCookie);
LearnSite.Common.App.AppUserAdd(sModel.Snum);
}
}
