public static DataTable studentList = new DataTable(); //定义一个Table表格，初始化为null.
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
if (!IsPostBack)
{
this.BjName.Items.Clear();
this.BjName.Items.Add("请选择...");
List <TbClass> TbClass = TbClassManager.GetAllClassList();
foreach (TbClass TbClassRow in TbClass)
{
string AddList = TbClassRow.Nj + TbClassRow.BjName;
this.BjName.Items.Add(AddList);
}
string yhid = Request["userid"];
if (yhid != null)
{
TbStudentManager.DeleteStuByYuID(int.Parse(yhid));
}
Load_Student();
}
}
static int FirstSxNum = 0;/*声明变量，初始化为0，用于判断筛选条件是否改变*/
/// <summary>
/// 加载科目列表信息
/// </summary>
/// <param name="apge">当前页面</param>
public void Load_Student()
{
string Bj_Name = txtClassName.Value.Trim() == "按姓名，学号，班级，用户名模糊查询" ? "" : txtClassName.Value.Trim();
if (Bj_Name != "按姓名，学号，班级，用户名模糊查询" && Bj_Name != "" && FirstSxNum == 0)
{
page = 1;
FirstSxNum = 1;
}
studentList = TbStudentManager.GetAllStuInfo(len, page, Bj_Name);
Count = TbStudentManager.GetAllStuInfo(Bj_Name).Rows.Count;
if (Count == 0)
{
Maxapge = 1;
}
else
{
if (Count % len == 0) //当数据库数据能整除10，最大页面数取Count/len的商
{
Maxapge = Count / len;
}
else
{
Maxapge = Count / len + 1;//当数据库数据不能整除10，最大页面数取Count/len的商+1.
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string name = "";
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "");
if (url != "")
{
Response.Redirect(url);
}
if (!IsPostBack)
{
string action = Request["action"];
if (action != null && action.ToString().Equals("Del"))
{
int kgtid = int.Parse(Request["kgtid"].ToString());
deleteGetTestPaperInfo(kgtid);
}
else if (action != null && action.ToString().Equals("vlaues"))
{
name = Request["sjName"].ToString();
}
spannowtime.InnerText = "服务器时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string user = usercookie.Value;
yhid = TbUserManager.GetStudentID(user);
testPaperScoreList = TbScoreManager.GetTestPaperScoreByYhid(yhid, name);
sjName.Value = name;
Hello = TbStudentManager.GetStudentByID(yhid).XsName;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sjName = "";
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "");
if (url != "")
{
Response.Redirect(url);
}
if (!IsPostBack)
{
string action = Request["action"];
if (action != null && action.ToString().Equals("Elspenvlaues"))
{
sjName = Request["sjName"].ToString();
}
spannowtime.InnerText = "服务器时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string user = usercookie.Value;
Tobj.YhID = TbUserManager.GetStudentID(user);
TbStudent tStudent = TbStudentManager.GetStudentByID(Tobj.YhID);
testPaperList = TbTestPaperManager.GetAllTestpaperByPages(len, page, sjName, 2);
Hello = tStudent.XsName;
Elspen.Value = sjName;
}
}
/// <summary>
/// 根据用户ID查询对应详细信息
/// </summary>
/// <param name="YhID"></param>
public void GetStudent(int YhID)
{
TbStudent student = TbStudentManager.GetStudentByID(YhID);
TbUser user = TbUserManager.GetAllUser(YhID);
string message = student.YhID + "," + student.XsName + "," + student.XsSex + "," + student.BjName + "," + student.Remark + "," + user.YhName + "," + user.Xh + "," + user.YhPwd;
Response.Write(message);
}
/// <summary>
/// 导入用户
/// </summary>
protected void BeginImport_Click(object sender, EventArgs e)
{
string path = "";
if (FileUpload1.PostedFile != null)
{
path = FileUpload1.PostedFile.FileName;
}
if (path == "")
{
lblImportResult.Text = "请选择导入文件！";
return;
}
if (!path.Contains(':') || !path.Contains('\\'))
{
lblImportResult.Text = "请设置您当前浏览器：工具-internet选项-安全-自定\n义级别-将文件上传到服务器是包含本地路径！";
return;
}
string hzm = path.Substring(path.LastIndexOf('.') + 1);
if (hzm != "xls" && hzm != "xlsx")
{
lblImportResult.Text = "本系统只支持excel文件格式导入，可以参考下面摸板！";
return;
}
TbUser user = null;
TbStudent stu = null;
DataSet ds = ExcelToDataSet(path);
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
user = new TbUser();
user.Xh = row[3].ToString();
user.YhName = row[4].ToString();
user.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(row[5].ToString(), "MD5");
user.Zt = 3;
int userIdentity = TbUserManager.AddUser(user);
if (userIdentity > 0)
{
stu = new TbStudent();
stu.XsName = row[0].ToString();
stu.XsSex = row[1].ToString();
stu.YhID = userIdentity;
stu.BjName = row[2].ToString();
stu.Remark = "";
int stuIdentity = TbStudentManager.AddStudent(stu);
}
}
}
lblImportResult.Text = "导入成功！";
}
/// <summary>
/// 导出学生信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnExport_Click(object sender, EventArgs e)
{
string path = Server.MapPath("file") + "\\studentinfo.xls";
if (File.Exists(path))
{
File.Delete(path);
}
DataTable dt = TbStudentManager.GetAllStuInfo();
PublicClass.SaveToFile(PublicClass.GetTable(dt, "学员信息"), Server.MapPath("file") + "\\studentinfo.xls");
Response.Redirect("file/studentinfo.xls");
}
protected void Page_Load(object sender, EventArgs e)
{
Ls = new List <string>();
if (!IsPostBack)
{
if (Request["sjid"] != null)
{
SjID = Request["sjid"].ToString();
}
}
DataTable dtPaper = TbTestPaperManager.getOnePaperInfo(SjID);
if (dtPaper != null)
{
drPaper = dtPaper.Rows[0];
DateTime Jstime = DateTime.Parse(drPaper["JsTime"].ToString()); //结束时间
DateTime Kstime = DateTime.Parse(drPaper["KsTime"].ToString()); //开始时间
int Min = PublicClass.GetMinutes(Kstime, Jstime); //间隔时间
Ls.Add(Min.ToString()); //Ls[0] = 剩余时间 分钟数
if (STimeMin == -1)
{
STimeMin = Min;
}
int Zfen = TbQuestionTypesManager.GetSumScoreBySjid(int.Parse(SjID));
Ls.Add(Zfen.ToString());
string KstrTime = drPaper["KsTime"].ToString();
KstrTime = KstrTime.Substring(KstrTime.LastIndexOf(' '));
Ls.Add(KstrTime);
}
HttpCookie ck = Request.Cookies["nowloginuser"];
string user = ck.Value;//获得当前登录用户用户名
int YhID = TbUserManager.GetStudentID(user);
string XsName = TbStudentManager.GetStudentByID(YhID).XsName;
Ls.Add(XsName);
ScoreZt = TbScoreManager.getScore(YhID.ToString(), SjID).Zt;
if (ScoreZt == 2)
{
//ScriptManager.RegisterStartupScript(Page, typeof(string), "3", "error()", true);
Response.Write("<script>alert('本次考试已结束，请勿重复提交');</script>");
Response.Write("<script>window.close();</script>");
return;
}
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
TbUser User = new TbUser();
TbStudent Student = new TbStudent();
User.YhName = this.TextYh.Text;
User.Xh = this.textStudentID.Text;
User.Zt = 3;
Student.XsName = this.TextName.Text;
Student.BjName = this.BjName.Text;
if (this.RadButNan.Checked)
{
Student.XsSex = this.RadButNan.Value;
}
else
{
Student.XsSex = this.RadButNv.Value;
}
Student.Remark = this.textBz.Text;
if (this.HiddenYhID.Value == "")
{
this.BjName.Text = "请选择...";
User.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.TextMm.Text, "MD5");
TbUserManager.SeeUser(User);
Student.YhID = TbUserManager.AddUser(User);
TbStudentManager.AddStudent(Student);
Load_Student();
}
else
{
User.YhPwd = this.TextMm.Text.Trim();
User.YhID = int.Parse(this.HiddenYhID.Value);
Student.YhID = int.Parse(this.HiddenYhID.Value);
TbUserManager.SetUser(User);
TbStudentManager.SetStudent(Student);
this.HiddenYhID.Value = "";
}
this.textStudentID.Text = "";
this.TextYh.Text = "";
this.TextName.Text = "";
this.textBz.Text = "";
this.BjName.Text = "请选择...";
this.RadButNan.Checked = true;
Load_Student();
}
/// <summary>
/// 清空学生信息j
/// </summary>
protected void ClearBtn_Click(object sender, EventArgs e)
{
TbStudentManager.DeleteAllStu();
TbUserManager.DeleteAllStuUser();
lblClear.Text = "学员以全部清空！";
}
