protected void Page_Load(object sender, EventArgs e)
{
//if((Request.UrlReferrer!=null) && Request.UrlReferrer.ToString().ToLower().IndexOf("enroll.sse.ustc.edu.cn")!=-1 && Request.UrlReferrer.ToString().ToLower().IndexOf("sseweb")!=-1)
//{
string USID = string.Empty;
if (Request["USID"] == null)
{
Response.Redirect("http://enroll.sse.ustc.edu.cn/sseweb/", false);
return;
}
USID = Request["USID"].Trim();
DalOperationAboutUser DalOperationAboutUser = new DalOperationAboutUser();
UserCookiesInfo UserCookiesInfoTeacher = null;
UserCookiesInfo UserCookiesInfoStudent = null;
CheckUserLogin CheckUserLoginTeacher = BllOperationAboutUser.ReturnSqlJudgeByUserType(1, USID);
UserCookiesInfoTeacher = DalOperationAboutUser.CheckUserLogin(CheckUserLoginTeacher);
CheckUserLogin CheckUserLoginStudent = BllOperationAboutUser.ReturnSqlJudgeByUserType(3, USID);
UserCookiesInfoStudent = DalOperationAboutUser.CheckUserLogin(CheckUserLoginStudent);
//1:教师(isAssistant值为1表示有助教身份，isAdmin值为1表示为管理员);3:学生;
UserCookiesInfo UserCookiesInformation = null;//登陆的用户Cookie对象
if (UserCookiesInfoTeacher != null)
{
UserCookiesInformation = UserCookiesInfoTeacher;
}
else if (UserCookiesInfoStudent != null)
{
UserCookiesInformation = UserCookiesInfoStudent;
}
if (UserCookiesInformation != null)
{
//FormsAuthenticationTicket Ticket;
//Ticket = new FormsAuthenticationTicket(3, UserCookiesInformation.userType.ToString().Trim(), DateTime.Now, DateTime.Now.AddMinutes(1440), false, SerializeCookies.SerializeCookiesMethod<UserCookiesInfo>(UserCookiesInformation)); //建立身份验证票对象
Session[ConfigurationManager.AppSettings["sessionKey"]] = SerializeCookies.SerializeCookiesMethod<UserCookiesInfo>(UserCookiesInformation);
//string HashTicket = FormsAuthentication.Encrypt(Ticket); //加密序列化验证票为字符串
//HttpCookie UserCookie = new HttpCookie(FormsAuthentication.FormsCookieName, HashTicket);
//UserCookie.HttpOnly = true;
////生成Cookie
//Context.Response.Cookies.Add(UserCookie); //输出Cookie
// 定位到管理页面
Response.Redirect("/Common/NotifyList.aspx", false);
}
else
{
Javascript.AlertAndRedirect("用户名或密码错误！请重新填写再登陆！","http://enroll.sse.ustc.edu.cn/sseweb/", Page);
}
}
public int CheckLogin(string userName,string userPwd)
{
int isLoginSuccess = 0;
DalOperationAboutUser DalOperationAboutUser = new DalOperationAboutUser();
//0:管理员;1:教师;2:助教;3:学生;
CheckUserLogin CheckUserLoginAdmin = BllOperationAboutUser.ReturnSqlJudgeByUserType(0, userName, CommonUtility.EncodeUsingMD5(userPwd));
CheckUserLogin CheckUserLoginTeacher = BllOperationAboutUser.ReturnSqlJudgeByUserType(1, userName, CommonUtility.EncodeUsingMD5(userPwd));
CheckUserLogin CheckUserLoginAssistant = BllOperationAboutUser.ReturnSqlJudgeByUserType(2, userName, CommonUtility.EncodeUsingMD5(userPwd));
CheckUserLogin CheckUserLoginStudent = BllOperationAboutUser.ReturnSqlJudgeByUserType(3, userName, CommonUtility.EncodeUsingMD5(userPwd));
UserCookiesInfo UserCookiesInfoAdmin = DalOperationAboutUser.CheckUserLogin(CheckUserLoginAdmin);
UserCookiesInfo UserCookiesInfoTeacher = DalOperationAboutUser.CheckUserLogin(CheckUserLoginTeacher);
UserCookiesInfo UserCookiesInfoAssistant = DalOperationAboutUser.CheckUserLogin(CheckUserLoginAssistant);
UserCookiesInfo UserCookiesInfoStudent = DalOperationAboutUser.CheckUserLogin(CheckUserLoginStudent);
UserCookiesInfo UserCookiesInformation = null;//登陆的用户Cookie对象
if (UserCookiesInfoAdmin != null)
{
UserCookiesInformation = UserCookiesInfoAdmin;
}
else if (UserCookiesInfoTeacher != null)
{
UserCookiesInformation = UserCookiesInfoTeacher;
}
else if (UserCookiesInfoAssistant != null)
{
UserCookiesInformation = UserCookiesInfoAssistant;
}
else if (UserCookiesInfoStudent != null)
{
UserCookiesInformation = UserCookiesInfoStudent;
}
if (UserCookiesInformation != null)
{
FormsAuthenticationTicket Ticket = new FormsAuthenticationTicket(3, UserCookiesInformation.userType.ToString().Trim(), DateTime.Now, DateTime.Now.AddMinutes(1440), false, SerializeCookies.SerializeCookiesMethod<UserCookiesInfo>(UserCookiesInformation)); //建立身份验证票对象
string HashTicket = FormsAuthentication.Encrypt(Ticket); //加密序列化验证票为字符串
HttpCookie UserCookie = new HttpCookie(FormsAuthentication.FormsCookieName, HashTicket);
UserCookie.HttpOnly = true;
//生成Cookie
HttpContext.Current.Response.Cookies.Add(UserCookie); //输出Cookie
//// 定位到管理页面
//HttpContext.Current.Response.Redirect("/Common/NotifyList.aspx", false);
isLoginSuccess = 1;
}
return isLoginSuccess;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("/" + FileUpload1.FileName));
DalOperationAboutUser DalOperationAboutUser = new DalOperationAboutUser();
//按顺序设定每个工作薄的字段数目
int[] sheetFiledsCount = { 5, 5, 7, 1, 6, 2, 2, 2 };
//读取要导入的Excel文件的全部数据
ExcelData excelData = BllOperationAboutExcel.BllImportExcelData(Server.MapPath("/" + FileUpload1.FileName), sheetFiledsCount,FileUpload1);
//Response.Write(excelData.excelPasswordMapping.Count);
//Response.End();
//将获取的导入数据存入数据库
DalOperationAboutUser.ImportExcelData(excelData);
}
else
{
Javascript.GoHistory(-1, "请先选择Excel文件！", Page);
}
}