/// <summary> /// 获取UUID列表 /// </summary> /// <param name="type">类型:class,dept,major</param> /// <param name="filename">文件名</param> public static bool GetUUID(string type, string filename) { var dt = new DataTable(); dt.Columns.Add("名称"); dt.Columns.Add("UUID"); switch (type) { case "class": //班级UUID var bll_class = new BLL.t_class(); var c_dt = bll_class.GetAllList().Tables[0]; if (c_dt == null) { break; } foreach (DataRow item in c_dt.Rows) { var dr = dt.NewRow(); dr["名称"] = item["class_name"]; dr["UUID"] = item["class_id"]; dt.Rows.Add(dr); } break; case "dept": //系别UUID var bll_dept = new BLL.t_dept(); var d_dt = bll_dept.GetAllList().Tables[0]; if (d_dt == null) { break; } foreach (DataRow item in d_dt.Rows) { var dr = dt.NewRow(); dr["名称"] = item["dept_name"]; dr["UUID"] = item["dept_id"]; dt.Rows.Add(dr); } break; case "major": //专业UUID var bll_major = new BLL.t_major(); var m_dt = bll_major.GetAllList().Tables[0]; if (m_dt == null) { break; } foreach (DataRow item in m_dt.Rows) { var dr = dt.NewRow(); dr["名称"] = item["major_name"]; dr["UUID"] = item["major_id"]; dt.Rows.Add(dr); } break; } //new Thread(() => { CsvHelper.dt2csv(filename, dt); }).Start(); return(CsvHelper.dt2csv(filename, dt)); }
/// <summary> /// 专业DDL /// </summary> /// <param name="dropDownList"></param> public static void MajorDLL(DropDownList dropDownList, string dept_id = null) { dropDownList.Items.Clear(); var bll = new BLL.t_major(); var model = dept_id == null?bll.GetModelList("major_stat=0") : bll.GetModelList("major_stat=0 AND major_dept_id='" + dept_id + "'"); foreach (var item in model) { dropDownList.Items.Add(new ListItem(item.major_name, item.major_id)); } }
protected void btnDelete_Click(object sender, EventArgs e) { string idlist = GetSelIDlist(); if (idlist.Trim().Length == 0) { return; } var bll2 = new BLL.t_major(); bll2.DeleteList(idlist); /// 写入日志 BLL.Utils.Log(this, "删除专业:" + idlist); BindData(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["login_name"] != null && Request["pwd"] != null && Request["type"] != null) { var msg = new BLL.Message(); /// 验证输入长度 if (Request["login_name"].Length < 3 || Request["pwd"].Length < 6 || Request["login_name"].Length > 32 || Request["pwd"].Length > 16) { msg.Msg = "数据输入有误!"; Response.Write(BLL.Utils.toJson(msg)); Response.End(); } /// 构建日志Model Model.t_log log = new Model.t_log { log_ip = Request.UserHostAddress, user_name = Request["login_name"], }; try { string url = null; var login_name = Request["login_name"]; var pwd = Request["pwd"]; var type = Request["type"]; /// 登录验证 if (BLL.Utils.Login(login_name, pwd, type)) { // 登录成功 Session["type"] = type; // 类型 Session["login_name"] = login_name; //登录,学号,工号 Session["user_name"] = null; // 显示名称(姓名) Session["role"] = 0; // 为了方便母版页判断权限和修改菜单,特设此变量,值越小权限越低:1学生,2导师,3教研室主任,4教务管理员 /// 获取附加信息 var bll_major = new BLL.t_major(); // 专业 switch (type) { #region 教务管理员登录 case "admin": Session["role"] = 4; var bll_admin = new BLL.t_admin(); var admin = bll_admin.GetModel(login_name); Session["user_name"] = admin.user_name; url = "/admin/"; break; #endregion 教务管理员登录 #region 教务室主任登录 case "mteacher": Session["role"] = 3; var bll_mteacher = new BLL.t_teacher(); var mteacher = bll_mteacher.GetModel(login_name); /// 获取专业信息 Session["major_id"] = mteacher.teacher_major_id; /// 获取系别信息 Session["dept_id"] = mteacher.teacher_dept_id; Session["user_name"] = mteacher.teacher_name; url = "/admin/"; break; #endregion 教务室主任登录 #region 导师登录 case "teacher": Session["role"] = 2; var bll_teacher = new BLL.t_teacher(); var teacher = bll_teacher.GetModel(login_name); /// 获取专业信息 Session["major_id"] = teacher.teacher_major_id; /// 获取系别信息 Session["dept_id"] = teacher.teacher_dept_id; Session["user_name"] = teacher.teacher_name; url = "/topic/"; break; #endregion 导师登录 #region 学生登录 case "student": //学生 Session["role"] = 1; var bll_student = new BLL.t_student(); var student = bll_student.GetModel(login_name); Session["user_name"] = student.student_name; Session["class_id"] = student.student_class_id; /// 获取班级信息 var bll_class = new BLL.t_class(); var myclass = bll_class.GetModel(student.student_class_id); /// 获取专业信息 var major = bll_major.GetModel(myclass.class_major_id); Session["major_id"] = major.major_id; /// 获取系别信息 Session["dept_id"] = major.major_dept_id; url = "/select/list.aspx"; break; #endregion 学生登录 } msg.Msg = log.log_info = "登录成功!"; } else { // 登录失败 log.log_info = msg.Msg = "用户名或密码错误!"; } if (url != null) { msg.Body = (url); } } catch { msg.Msg = "发生错误!"; } var bll_log = new BLL.t_log(); bll_log.Add(log); Response.Write(BLL.Utils.toJson(msg)); Response.End(); } else { BLL.Utils.ShowMessage(this, "输入有误!"); } }