public ActionResult UpLoadImg() { HttpPostedFileBase head = Request.Files["head"]; string StuNum = Request["StuNum"]; string fileName = head.FileName; string ext = Path.GetExtension(fileName).ToLower(); if (!ext.Equals(".gif") && !ext.Equals(".jpg") && !ext.Equals(".png") && !ext.Equals(".bmp")) { return(Content("<script>alert('您上传的文件格式不正确!上传格式有(.gif、.jpg、.png、.bmp)')</script>")); } else if (head.ContentLength > 1048576 * 5) { return(Content("<script>alert('内容最大为5M')</script>")); } else { try { head.SaveAs(Server.MapPath("~/HeadImg/" + fileName)); string ImagePath = "../../HeadImg/" + fileName; MODEL.T_MemberInformation user = new MODEL.T_MemberInformation() { StuNum = StuNum, PhotoPath = ImagePath }; OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(user, new string[] { "PhotoPath" }); return(Content("<script>alert('修改成功')</script>")); } catch (Exception ex) { return(Content("<script>alert('修改失败')</script>")); } } }
//将成员信息新增到数据库中 public ActionResult AddStuData() { MODEL.T_MemberInformation member = new MODEL.T_MemberInformation(); member.StuName = Request.Form["StuName"]; member.StuNum= Request.Form["num"]; member.LoginPwd= Request.Form["pwd"]; member.Gender = Request.Form["gender"]; member.QQNum = "1"; member.Email = "*****@*****.**"; member.PhotoPath = "../../HeadImg/final.png"; member.JoinTime = DateTime.Now; member.Department = 10007; member.TechnicalLevel = 10003; member.IsAdmin = false; member.IsDelete = false; member.SecretShow = 7; int isOk = OperateContext.Current.BLLSession.IMemberInformationBLL.Add(member); if (isOk > 0) { return Content("<script>alert('新增成功');window.location='/PersonalManger/CheckMember/Index';</script>"); } else { return Content("<script>alert('新增失败');window.location='/PersonalManger/CheckMember/AddStu'</script>"); } }
public ActionResult Edit(MODEL.T_MemberInformation member) { int ShowFPhone = 2; int ShowAddress = 2; int ShowPhone = 2; int IsShow; ShowAddress = Convert.ToInt32(Request.Form["ShowAddress"]);//设置部分信息是否可以看到 ShowFPhone = Convert.ToInt32(Request.Form["ShowFPhone"]); ShowPhone = Convert.ToInt32(Request.Form["ShowPhone"]); IsShow = 4 * ShowFPhone + 2 * ShowAddress + ShowPhone;//得到信息公开数据 member.SecretShow = IsShow; try { if (ModelState.IsValid) { /*EF修改主键一定要加*/ string[] proNames = new string[] { "StuNum", "StuName", "Gender", "Email", "LoginPwd", "Class", "Major", "Counselor", "HeadTeacher", "UndergraduateTutor", "TelephoneNumber", "Birthday", "HomPhoneNumber", "FamilyAddress", "Sign", "OtheInfor", "SecretShow" }; OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(member, proNames); return(Content("<script>alert('修改成功');window.location='/PersonalManger/CheckMember/PersonPage?StuNum=" + member.StuNum + "'</script>")); } else { return(Content("<script>alert('修改成功');window.location='/PersonalManger/CheckMember/PageEdit?StuNum=" + member.StuNum + "'</script>")); } } catch (Exception ex) { return(Content("<script>alert('修改成功');window.location='/PersonalManger/CheckMember/PageEdit?StuNum=" + member.StuNum + "'</script>")); } }
//将成员信息新增到数据库中 public ActionResult AddStuData() { MODEL.T_MemberInformation member = new MODEL.T_MemberInformation(); member.StuName = Request.Form["StuName"]; member.StuNum = Request.Form["num"]; member.LoginPwd = Request.Form["pwd"]; member.Gender = Request.Form["gender"]; member.QQNum = "1"; member.Email = "*****@*****.**"; member.PhotoPath = "../../HeadImg/final.png"; member.JoinTime = DateTime.Now; member.Department = 10007; member.TechnicalLevel = 10003; member.IsAdmin = false; member.IsDelete = false; member.SecretShow = 7; int isOk = OperateContext.Current.BLLSession.IMemberInformationBLL.Add(member); if (isOk > 0) { return(Content("<script>alert('新增成功');window.location='/PersonalManger/CheckMember/Index';</script>")); } else { return(Content("<script>alert('新增失败');window.location='/PersonalManger/CheckMember/AddStu'</script>")); } }
public ActionResult SavePwd() { string pwd = Request.Form["pwd"]; MODEL.T_MemberInformation mem = new MODEL.T_MemberInformation(); mem = OperateContext.Current.Usr; mem.LoginPwd = pwd; OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(mem, "LoginPwd"); return(Content("<script>alert('修改成功!');window.location='/PersonalManger/CheckMember/EditPwd'</script>")); }
/// <summary> /// 查看收件箱消息的详情 /// </summary> /// <returns></returns> public ActionResult MessageContent() { MODEL.ViewModel.MessagaContentModel model = new MODEL.ViewModel.MessagaContentModel(); MODEL.T_MemberInformation user = OperateContext.Current.Usr;//Session["user"] as MODEL.T_MemberInformation; model.ReceiveName = user.StuName + "|" + user.StuNum + ";"; int userMessgeId = int.Parse(Request.QueryString["userMessgeId"]); int messageId = int.Parse(Request.QueryString["messageId"]); string sendId = Request.QueryString["sendId"]; List <MODEL.Tbl_User_Message> list = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetListBy(u => u.Id == userMessgeId); MODEL.Tbl_User_Message usermessage = new MODEL.Tbl_User_Message(); foreach (var um in list) { usermessage = um; } usermessage.IsRead = true; //设置消息为已读状态 OperateContext.Current.BLLSession.Il_User_MessageBLL.Modify(usermessage, "IsRead"); List <MODEL.Tbl_Message> message = OperateContext.Current.BLLSession.Il_MessageBLL.GetListBy(u => u.Id == messageId); List <MODEL.Tbl_User_Message> userMessage = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetListBy(u => u.Id == userMessgeId); string sendIdTemple = null; string sendNameTemple = null; foreach (MODEL.Tbl_User_Message um in userMessage) { sendIdTemple = um.SendId; } List <MODEL.T_MemberInformation> member = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == sendId); foreach (MODEL.T_MemberInformation mi in member) { sendNameTemple = mi.StuName; } model.SendName = sendNameTemple + "|" + sendIdTemple + ";"; foreach (MODEL.Tbl_Message mi in message) { model.Title = mi.Title; model.Content = mi.Content; model.Atachment = mi.Atachment; model.SendTime = mi.SendTime; } ViewData["messageInfo"] = model; return(View()); }
/// <summary> /// 管理员修改方法,可以修改所有信息 /// </summary> /// <param name="member"></param> /// <returns></returns> public ActionResult AdminEdit(MODEL.T_MemberInformation member) { int oldRoleId = 0; try { oldRoleId = Convert.ToInt32(Request.Form["oldRoleId"]); //查看角色属性 int roleId = 0; OperateContext.Current.BLLSession.IRoleActBLL.DelBy(u => u.RoleId == oldRoleId && u.RoleActor == member.StuNum); object o = Request.Form["role"]; if (Request.Form["role"] != null) { roleId = Convert.ToInt32(Request.Form["role"]); MODEL.T_RoleAct roleAct = new MODEL.T_RoleAct(); roleAct.RoleId = roleId; roleAct.RoleActor = member.StuNum; OperateContext.Current.BLLSession.IRoleActBLL.Add(roleAct); } } catch { } //得到修改SecretShow属性 int ShowFPhone = 2; int ShowAddress = 2; int ShowPhone = 2; int IsShow; ShowAddress = Convert.ToInt32(Request.Form["ShowAddress"]);//设置部分信息是否可以看到 ShowFPhone = Convert.ToInt32(Request.Form["ShowFPhone"]); ShowPhone = Convert.ToInt32(Request.Form["ShowPhone"]); IsShow = 4 * ShowFPhone + 2 * ShowAddress + ShowPhone;//得到信息公开数据 member.SecretShow = IsShow; if (ModelState.IsValid) { //EF修改主键一定要加 string[] proNames = new string[] { "StuNum", "StuName", "Gender", "QQNum", "Email", "Birthday", "Class", "Major", "Counselor", "HeadTeacher", "UndergraduateTutor", "TelephoneNumber", "HomPhoneNumber", "FamilyAddress", "Department", "TechnicalLevel", "StudyGuideNumber", "Sign", "OtheInfor", "SecretShow" }; int IsSuccess = OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(member, proNames); if (IsSuccess > 0) { return(Content("<script>alert('修改成功');window.location='/PersonalManger/CheckMember/PersonPage?StuNum=" + member.StuNum + "'</script>")); } else { return(Content("<script>alert('修改失败');window.location='/PersonalManger/CheckMember/PageEdit?StuNum=" + member.StuNum + "'</script>")); } } else { return(Content("<script>alert('修改失败');window.location='/PersonalManger/CheckMember/PageEdit?StuNum=" + member.StuNum + "'</script>")); } }
public ActionResult Index() { //这是判断是否免登入,即有用户的对象 if (Request.Cookies["Admin_InfoKey"] != null) { string strCookieValue = Request.Cookies["Admin_InfoKey"].Value; string User = Common.SecurityHelper.DecryptUserInfo(strCookieValue); MODEL.T_MemberInformation user = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == User).First(); ViewData["Name"] = user.StuNum; ViewData["Pwd"] = user.LoginPwd; } return(View()); }
/// <summary> /// 根据id删除成员 /// </summary> /// <param name="form"></param> /// <returns></returns> public ActionResult DeleteBy(FormCollection form) { string stuNum = form["stuNum"]; MODEL.T_MemberInformation model = new MODEL.T_MemberInformation(); model.IsDelete = true; int delCount = OperateContext.Current.BLLSession.IMemberInformationBLL.ModifyBy(model, u => u.StuNum == stuNum, "IsDelete"); if (delCount > 0) { return(OperateContext.Current.RedirectAjax("ok", "删除成功", null, null)); } else { return(OperateContext.Current.RedirectAjax("err", "删除失败", null, null)); } }
/// <summary> /// 保存草稿 /// </summary> /// <param name="form"></param> /// <returns></returns> public string SaveDraft(FormCollection form) { MODEL.Tbl_Message message = new MODEL.Tbl_Message(); MODEL.Tbl_User_Message userMessage = new MODEL.Tbl_User_Message(); MODEL.T_MemberInformation user = OperateContext.Current.Usr;//Session["user"] as MODEL.T_MemberInformation; string receiveName = form["receiveName"]; string topic = form["topic"]; string messageContent = form["messageContent"]; string hiddenFileAddress = form["hiddenFileAddress"]; message.Title = topic; message.Content = messageContent; message.SendTime = DateTime.Now; message.Atachment = hiddenFileAddress; string[] arr = receiveName.Split(';'); List <string> receiverId = new List <string>(); for (int i = 0; i < arr.Length - 1; i++) { string[] a = arr[i].Split('|'); receiverId.Add(a[a.Length - 1]); } //int result = OperateContext.Current.BLLSession.Il_MessageBLL.Add(message); MODEL.Tbl_Message messageList = OperateContext.Current.BLLSession.Il_MessageBLL.AddGetAutoId(message); userMessage.MessageId = messageList.Id; userMessage.IsDraft = true; //将信息草稿字段激活 userMessage.SendId = user.StuNum; foreach (string str in receiverId) { userMessage.ReceiveId = str; int result = OperateContext.Current.BLLSession.Il_User_MessageBLL.Add(userMessage); if (result <= 0) { return("no"); } } return("ok"); }
/// <summary> /// 给个别人发送系统消息(如用户注册提示修改密码等) /// </summary> /// <param name="receiveId">接收者的Id</param> /// <param name="title">系统消息的标题</param> /// <param name="sysContent">系统消息的内容</param> /// <returns>发送成功返回ok , 否则发送失败</returns> /* public string SendSysMsg(string receiveId, string title, string sysContent) * { * MODEL.T_MemberInformation user = Session["ainfo"] as MODEL.T_MemberInformation; * MODEL.SystemMessage model = new MODEL.SystemMessage(); * model.ReceiveId = receiveId; * model.SendId = user.StuNum; * model.Title = title; * model.Content = sysContent; * model.SendTime = DateTime.Now; * * int result = OperateContext.Current.BLLSession.IstemMessageBLL.Add(model); * if (result > 0) * { * return "ok"; * } * else * { * return "nook"; * } * * }*/ /// <summary> /// 给多人发送系统消息, /// </summary> /// <param name="receiveId">接收者的Id用“;”隔开,开头末尾不要加“;”</param> /// <param name="title">系统消息的标题</param> /// <param name="sysContent">系统消息的内容</param> /// <returns>发送成功返回ok , 否则发送失败</returns> public string SendSysMsg(string receiveId, string title, string sysContent) { MODEL.T_MemberInformation user = Session["ainfo"] as MODEL.T_MemberInformation; string[] arr = receiveId.Split(';'); foreach (var ri in arr) { MODEL.SystemMessage model = new MODEL.SystemMessage(); model.ReceiveId = ri; model.SendId = user.StuNum; model.Title = title; model.Content = sysContent; model.SendTime = DateTime.Now; if (OperateContext.Current.BLLSession.IstemMessageBLL.Add(model) <= 0) { return("nook"); } } return("ok"); }
/// <summary> /// 给整个实验室全体成员发送系统消息(如部门活动等) /// </summary> /// <param name="title">系统消息的标题</param> /// <param name="sysContent">系统消息的内容</param> /// <returns></returns> public string SendSysMsg(string title, string sysContent) { MODEL.T_MemberInformation user = Session["ainfo"] as MODEL.T_MemberInformation; List <MODEL.T_MemberInformation> list = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.IsDelete == false); foreach (var mi in list) { MODEL.SystemMessage model = new MODEL.SystemMessage(); model.SendId = user.StuNum; model.ReceiveId = mi.StuNum; model.Title = title; model.Content = sysContent; model.SendTime = DateTime.Now; if (OperateContext.Current.BLLSession.IstemMessageBLL.Add(model) <= 0) { return("nook"); } } return("ok"); }
/// <summary> /// 给各部门发送系统消息(如任务发布等) /// </summary> /// <param name="department">部门Id</param> /// <param name="title">系统消息标题</param> /// <param name="sysContent">系统消息的内容</param> /// <returns></returns> public string SendSysMsg(int department, string title, string sysContent) { MODEL.T_MemberInformation user = Session["ainfo"] as MODEL.T_MemberInformation; List <MODEL.T_MemberInformation> list = new List <MODEL.T_MemberInformation>(); list = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.Department == department); foreach (var mi in list) { int result = 0; MODEL.SystemMessage model = new MODEL.SystemMessage(); model.ReceiveId = mi.StuNum; model.SendId = user.StuNum; model.Title = title; model.Content = sysContent; model.SendTime = DateTime.Now; result = OperateContext.Current.BLLSession.IstemMessageBLL.Add(model); if (result <= 0) { return("nook"); } } return("ok"); }
/// <summary> /// 加载系统消息 /// </summary> /// <returns></returns> public ActionResult Index() { MODEL.T_MemberInformation user = OperateContext.Current.Usr; MODEL.ViewModel.PageModelInMsg pageModel = new MODEL.ViewModel.PageModelInMsg(); int pageIndex = 1; string flage = Request.QueryString["flage"] == null ? null : Request.QueryString["flage"].ToString(); if (flage == "next") { pageIndex = Request.QueryString["pageIndex"] == null ? 1 : int.Parse(Request.QueryString["pageIndex"]) + 1; } else if (flage == "front") { pageIndex = Request.QueryString["pageIndex"] == null ? 1 : int.Parse(Request.QueryString["pageIndex"]) - 1; } int pageSize = Request.QueryString["PageSize"] == null ? 8 : int.Parse(Request.QueryString["PageSize"]); pageModel.PageIndex = pageIndex; int count = OperateContext.Current.BLLSession.IstemMessageBLL.GetListBy(u => u.ReceiveId == user.StuNum).Count(); pageModel.MessageCount = count; pageModel.PageCount = (int)Math.Ceiling(count / (float)pageSize) == 0 ? 1 : (int)Math.Ceiling(count / (float)pageSize); if (pageModel.PageIndex > pageModel.PageCount) { pageModel.PageIndex = pageModel.PageCount; } List <MODEL.SystemMessage> list = OperateContext.Current.BLLSession.IstemMessageBLL.GetPagedList(pageIndex, pageSize, u => u.ReceiveId == user.StuNum, u => u.SendTime); ViewData["sysMsgList"] = list; ViewData["pageModel"] = pageModel; return(View()); }
/// <summary> /// 判断当前用户是否登陆 而且 /// </summary> /// <returns></returns>E:\Projects\FinalWeb\DALMSSQL\BaseDAL.cs public bool IsLogin() { //1.验证用户是否登陆(Session && Cookie) if (Session[Admin_InfoKey] == null)//如果关闭浏览器则session已经没有,但是cookie还在 { if (Request.Cookies[Admin_InfoKey] == null) { //重新登陆,内部已经调用了 Response.End(),后面的代码都不执行了! (注意:如果Ajax请求,此处不合适!) //filterContext.HttpContext.Response.Redirect("/admin/admin/login"); return(false); } else//如果有cookie则从cookie中获取用户id并查询相关数据存入 SessionS { string strUserInfo = Request.Cookies[Admin_InfoKey].Value; strUserInfo = Common.SecurityHelper.DecryptUserInfo(strUserInfo); //userId即为用户学号 string userId = strUserInfo; MODEL.T_MemberInformation usr = BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == userId).First(); Usr = usr; UsrPermission = OperateContext.Current.GetUserPermission(usr.StuNum); } } return(true); }
/// <summary> /// 判断用户登录 /// </summary> /// <param name="user"></param> public bool UserLogin(MODEL.ViewModel.LoginUser user) { //应该到业务层查询 MODEL.T_MemberInformation member = BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == user.LoginName).FirstOrDefault(); //如果登陆成功 if (user != null) { //Usr是当前用户对象 Usr = member; //存入学号 Session[Admin_Stunum] = member.StuNum; if (user.IsAlways) { string strCookieValue = Common.SecurityHelper.EncryptUserInfo(user.LoginName); HttpCookie cookie = new HttpCookie("Admin_InfoKey", strCookieValue); cookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookie); } //2.2 查询当前用户的 权限,并将权限 存入 Session 中 UsrPermission = GetUserPermission(user.LoginName); return(true); } return(false); }
public ActionResult SavePwd() { string pwd = Request.Form["pwd"]; MODEL.T_MemberInformation mem=new MODEL.T_MemberInformation(); mem=OperateContext.Current.Usr; mem.LoginPwd=pwd; OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(mem, "LoginPwd"); return Content("<script>alert('修改成功!');window.location='/PersonalManger/CheckMember/EditPwd'</script>"); }
/// <summary> /// 根据id删除成员 /// </summary> /// <param name="form"></param> /// <returns></returns> public ActionResult DeleteBy(FormCollection form) { string stuNum = form["stuNum"]; MODEL.T_MemberInformation model = new MODEL.T_MemberInformation(); model.IsDelete = true; int delCount = OperateContext.Current.BLLSession.IMemberInformationBLL.ModifyBy(model, u => u.StuNum == stuNum, "IsDelete"); if (delCount > 0) { return OperateContext.Current.RedirectAjax("ok", "删除成功", null, null); } else { return OperateContext.Current.RedirectAjax("err", "删除失败", null, null); } }
public ActionResult BatchAdd(HttpPostedFileBase filebase) { HttpPostedFileBase file = Request.Files["files"]; string FileName; string savePath; if (file == null || file.ContentLength <= 0) { ViewBag.error = "文件不能为空"; return Redirect("/PersonalManger/CheckMember/AddStu"); } else { string filename = Path.GetFileName(file.FileName); int filesize = file.ContentLength;//获取上传文件的大小单位为字节byte string fileEx = Path.GetExtension(filename);//获取上传文件的扩展名 string NoFileName = Path.GetFileNameWithoutExtension(filename);//获取无扩展文件名 int MaxSize = 8000 * 1024;//定义上传文件的最大空间大小为8M string FileType = ".xls,.xlsx";//定义上传文件的类型字符串 FileName = NoFileName+ fileEx; if (!FileType.Contains(fileEx)) { ViewBag.error = "文件类型不对,只能导入xls和xlsx格式的文件"; return Redirect("/PersonalManger/CheckMember/AddStu"); } if (filesize >= MaxSize) { ViewBag.error = "上传文件超过8M,请小于8M"; return Redirect("/PersonalManger/CheckMember/AddStu"); } string path = AppDomain.CurrentDomain.BaseDirectory + "Excel\\"; savePath = Path.Combine(path, FileName); file.SaveAs(savePath); } FileStream fs = new FileStream(savePath,FileMode.Open, FileAccess.ReadWrite, FileShare.None);//创建文件流 DataTable dt = new XlsStreamToDT(fs, 15).Xls2DT(); using (var scope = new TransactionScope()) { MODEL.T_MemberInformation member; for (int i = 1; i <dt.Rows.Count; i++) { member = new MODEL.T_MemberInformation(); member.StuNum = dt.Rows[i][0].ToString();//获取学号 member.StuName = dt.Rows[i][1].ToString();//获取姓名 member.LoginPwd = dt.Rows[i][2].ToString();//获取初始密码 member.QQNum = "1"; member.Email = "*****@*****.**"; member.PhotoPath = "../../HeadImg/final.png"; member.JoinTime = DateTime.Now; member.Department = 10007; member.TechnicalLevel = 10003; member.IsAdmin = false; member.IsDelete = false; member.SecretShow = 7; OperateContext.Current.BLLSession.IMemberInformationBLL.Add(member); MODEL.T_OgnizationAct OrganizationAct = new MODEL.T_OgnizationAct() { OrganizationId =10004 , RoleActor =member.StuNum,IsDel = false }; OperateContext.Current.BLLSession.IOgnizationActBLL.Add(OrganizationAct); //对每一个新成员赋予实习生的角色 MODEL.T_RoleAct ra = new MODEL.T_RoleAct(); ra.RoleId = 10009; ra.RoleActor = member.StuNum; ra.IsDel = false; OperateContext.Current.BLLSession.IRoleActBLL.Add(ra); } scope.Complete(); } //删除掉存储在网站目录下的文件 //事实上,调用File.Delete并没有删除文件,它只是让操作系统认为文件不存在, //文件在磁盘上的空间被标记成空的,以便用于再次使用。但是文件的数据没有被移除,您可以非常容易恢复。 //被删除的文件直到相应的空间被重写才会真消失,这也许要很长时间。 if (System.IO.File.Exists(savePath)) { System.IO.File.Delete(savePath); } return Content("<script>alert('批量新增成功!');window.location='/PersonalManger/CheckMember/Index';</script>"); }
public ActionResult RecycleBoxMenu() { MODEL.T_MemberInformation user = OperateContext.Current.Usr;//Session["user"] as MODEL.T_MemberInformation; MODEL.Tbl_User_Message sendUserMessage = new MODEL.Tbl_User_Message(); MODEL.Tbl_Message sendMessage = new MODEL.Tbl_Message(); List <MODEL.ViewModel.SendBox> sendBoxList = new List <MODEL.ViewModel.SendBox>(); List <MODEL.ViewModel.SendBox> receiveBoxList = new List <MODEL.ViewModel.SendBox>(); MODEL.ViewModel.PageModelInMsg sendPpageModel = new MODEL.ViewModel.PageModelInMsg(); MODEL.ViewModel.PageModelInMsg receivePageModel = new MODEL.ViewModel.PageModelInMsg(); string sendId = user.StuNum; string receiveId = user.StuNum; //分页查询处理 int sendPageIndex = 1; int receivePageIndex = 1; int sendCount = 1; int receiveCount = 1; string sendFlage = Request.QueryString["sendFlage"] == null ? null : Request.QueryString["sendFlage"].ToString(); string receiveFlage = Request.QueryString["receiveFlage"] == null ? null : Request.QueryString["receiveFlage"].ToString(); if (sendFlage == "next") { sendPageIndex = Request.QueryString["sendPageIndex"] == null ? 1 : int.Parse(Request.QueryString["sendPageIndex"]) + 1; } else if (sendFlage == "front") { sendPageIndex = Request.QueryString["sendPageIndex"] == null ? 1 : int.Parse(Request.QueryString["sendPageIndex"]) - 1; } if (receiveFlage == "next") { receivePageIndex = Request.QueryString["receivPageIndex"] == null ? 1 : int.Parse(Request.QueryString["receivPageIndex"]) + 1; } else if (receiveFlage == "front") { receivePageIndex = Request.QueryString["receivPageIndex"] == null ? 1 : int.Parse(Request.QueryString["receivPageIndex"]) - 1; } sendPpageModel.PageIndex = sendPageIndex; receivePageModel.PageIndex = receivePageIndex; sendCount = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetListBy(u => u.SendId == sendId && u.SendIsDelete == true && (u.SendTrueDel == false || u.SendTrueDel == null)).Count(); receiveCount = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetListBy(u => u.ReceiveId == receiveId && u.ReceiveIsDelete == true && (u.RecTrueDel == false || u.RecTrueDel == null)).Count(); sendPpageModel.MessageCount = sendCount; receivePageModel.MessageCount = receiveCount; int sendPageSize = Request.QueryString["sendPageSize"] == null ? 3 : int.Parse(Request.QueryString["sendPageSize"]); int receivePageSize = Request.QueryString["receivePageSize"] == null ? 3 : int.Parse(Request.QueryString["receivePageSize"]); sendPpageModel.PageCount = (int)Math.Ceiling(sendCount / (float)sendPageSize) == 0 ? 1 : (int)Math.Ceiling(sendCount / (float)sendPageSize); receivePageModel.PageCount = (int)Math.Ceiling(receiveCount / (float)receivePageSize) == 0 ? 1 : (int)Math.Ceiling(receiveCount / (float)receivePageSize); if (sendPpageModel.PageIndex > sendPpageModel.PageCount) { sendPpageModel.PageIndex = sendPpageModel.PageCount; } if (receivePageModel.PageIndex > receivePageModel.PageCount) { receivePageModel.PageIndex = receivePageModel.PageCount; } //开始分页查询 List <MODEL.Tbl_User_Message> sendList = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetPagedList(sendPpageModel.PageIndex, sendPageSize, u => u.SendId == sendId && u.SendIsDelete == true && (u.SendTrueDel == false || u.SendTrueDel == null), u => u.Id); List <MODEL.Tbl_User_Message> receiveList = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetPagedList(receivePageModel.PageIndex, receivePageSize, u => u.ReceiveId == receiveId && u.ReceiveIsDelete == true && (u.RecTrueDel == false || u.RecTrueDel == null), u => u.Id); foreach (MODEL.Tbl_User_Message userModel in sendList) { MODEL.ViewModel.SendBox sendBoxModel = new MODEL.ViewModel.SendBox(); List <MODEL.T_MemberInformation> menber = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == userModel.ReceiveId); foreach (MODEL.T_MemberInformation menberModel in menber) { sendBoxModel.ReceiveName = menberModel.StuName; List <MODEL.Tbl_Message> messageModel = OperateContext.Current.BLLSession.Il_MessageBLL.GetListBy(m => m.Id == userModel.MessageId); foreach (MODEL.Tbl_Message mes in messageModel) { sendBoxModel.MessageTitle = mes.Title; sendBoxModel.SendTime = mes.SendTime.ToString(); sendBoxModel.MessageId = mes.Id; } } sendBoxModel.ReceiveId = userModel.ReceiveId; sendBoxModel.UserMessageId = userModel.Id; sendBoxModel.IsRead = userModel.IsRead; sendBoxModel.IsDraft = userModel.IsDraft; sendBoxModel.ReceiveIsDelete = userModel.ReceiveIsDelete; sendBoxModel.SendIsDelete = userModel.SendIsDelete; sendBoxList.Add(sendBoxModel); } foreach (MODEL.Tbl_User_Message userModel in receiveList) { MODEL.ViewModel.SendBox sendBoxModel = new MODEL.ViewModel.SendBox(); List <MODEL.T_MemberInformation> menber = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == userModel.SendId); foreach (MODEL.T_MemberInformation menberModel in menber) { sendBoxModel.SendName = menberModel.StuName; List <MODEL.Tbl_Message> messageModel = OperateContext.Current.BLLSession.Il_MessageBLL.GetListBy(m => m.Id == userModel.MessageId); foreach (MODEL.Tbl_Message mes in messageModel) { sendBoxModel.MessageTitle = mes.Title; sendBoxModel.SendTime = mes.SendTime.ToString(); sendBoxModel.MessageId = mes.Id; } } sendBoxModel.SendId = userModel.SendId; sendBoxModel.UserMessageId = userModel.Id; sendBoxModel.IsRead = userModel.IsRead; sendBoxModel.IsDraft = userModel.IsDraft; sendBoxModel.ReceiveIsDelete = userModel.ReceiveIsDelete; sendBoxModel.SendIsDelete = userModel.SendIsDelete; receiveBoxList.Add(sendBoxModel); } ViewData["sendBoxList"] = sendBoxList; ViewData["receiveBoxList"] = receiveBoxList; ViewData["sendPpageModel"] = sendPpageModel; ViewData["receivePageModel"] = receivePageModel; return(View()); }
public ActionResult DraftBoxMenu() { MODEL.T_MemberInformation user = OperateContext.Current.Usr;//Session["user"] as MODEL.T_MemberInformation; MODEL.Tbl_User_Message userMessage = new MODEL.Tbl_User_Message(); MODEL.Tbl_Message message = new MODEL.Tbl_Message(); List <MODEL.ViewModel.SendBox> sendBoxList = new List <MODEL.ViewModel.SendBox>(); MODEL.ViewModel.PageModelInMsg pageModel = new MODEL.ViewModel.PageModelInMsg(); string sendId = user.StuNum; int pageIndex = 1; int count = 1; string flage = Request.QueryString["flage"] == null ? null : Request.QueryString["flage"].ToString(); if (flage == "next") { pageIndex = Request.QueryString["pageIndex"] == null ? 1 : int.Parse(Request.QueryString["pageIndex"]) + 1; } else if (flage == "front") { pageIndex = Request.QueryString["pageIndex"] == null ? 1 : int.Parse(Request.QueryString["pageIndex"]) - 1; } int pageSize = Request.QueryString["PageSize"] == null ? 5 : int.Parse(Request.QueryString["PageSize"]); pageModel.PageIndex = pageIndex; count = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetListBy(u => u.SendId == sendId && u.SendIsDelete == false && u.IsDraft == true && (u.SendTrueDel == false || u.SendTrueDel == null)).Count(); pageModel.MessageCount = count; pageModel.PageCount = (int)Math.Ceiling(count / (float)pageSize) == 0 ? 1 : (int)Math.Ceiling(count / (float)pageSize); if (pageModel.PageIndex > pageModel.PageCount) { pageModel.PageIndex = pageModel.PageCount; } List <MODEL.Tbl_User_Message> list = OperateContext.Current.BLLSession.Il_User_MessageBLL.GetPagedList(pageModel.PageIndex, pageSize, u => u.SendId == sendId && u.SendIsDelete == false && u.IsDraft == true && (u.SendTrueDel == false || u.SendTrueDel == null), u => u.Id); foreach (MODEL.Tbl_User_Message userModel in list) { MODEL.ViewModel.SendBox sendBoxModel = new MODEL.ViewModel.SendBox(); List <MODEL.T_MemberInformation> menber = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == userModel.ReceiveId); foreach (MODEL.T_MemberInformation menberModel in menber) { sendBoxModel.ReceiveName = menberModel.StuName; List <MODEL.Tbl_Message> messageModel = OperateContext.Current.BLLSession.Il_MessageBLL.GetListBy(m => m.Id == userModel.MessageId); foreach (MODEL.Tbl_Message mes in messageModel) { sendBoxModel.MessageTitle = mes.Title; sendBoxModel.SendTime = mes.SendTime.ToString(); sendBoxModel.MessageId = mes.Id; } } sendBoxModel.ReceiveId = userModel.ReceiveId; sendBoxModel.UserMessageId = userModel.Id; sendBoxModel.IsRead = userModel.IsRead; sendBoxModel.IsDraft = userModel.IsDraft; sendBoxModel.ReceiveIsDelete = userModel.ReceiveIsDelete; sendBoxModel.SendIsDelete = userModel.SendIsDelete; sendBoxList.Add(sendBoxModel); } ViewData["sendBoxList"] = sendBoxList; ViewData["pageModel"] = pageModel; return(View()); }
///// #region 4.1 进入新增页面 +ActionResult Add() /// <summary> /// 4.1 进入新增页面 /// </summary> public ActionResult Add() { MODEL.T_MemberInformation mem = Session["ainfo"] as MODEL.T_MemberInformation; ViewData["name"] = mem.StuName; return(View()); }
public ViewResult PageEdit() { //得到返回的页面 string backurl = Request.QueryString["backurl"]; if (!string.IsNullOrEmpty(backurl)) { if (backurl == "fromindex") { ViewBag.backurl = "/PersonalManger/CheckMember/Index"; } if (backurl == "fromrole") { ViewBag.backurl = "/Permission/Role/RoleIndex"; } if (backurl == "fromperson") { ViewBag.backurl = "/PersonalManger/CheckMember/PersonPage"; } } else { ViewBag.backurl = "/PersonalManger/CheckMember/PersonPage"; } string stunum = Request["StuNum"]; //得到要修改学生的学号 string user = OperateContext.Current.Usr.StuNum; //拿到登入用户的学号 if (user == "FinalAdmin") //注意:这里是直接用登入者账号是否等于数据库的系统维护人员的账号的。注意!!! { int UserRoleId; ViewBag.user = "******"; //这里是得到要修改成员的角色 UserRoleId = OperateContext.Current.BLLSession.IRoleActBLL.GetListBy(u => u.RoleActor == stunum).First().RoleId; List <MODEL.T_Role> listRole = OperateContext.Current.BLLSession.IRoleBLL.GetListBy(u => u.IsDelete == false).ToList(); ViewBag.listRole = listRole; ViewBag.UserRoleId = UserRoleId; } else { ViewBag.user = "******"; } //确定年级 string dtone; string dttwo; string dtthree; string dtfour; GetYear(out dtone, out dttwo, out dtthree, out dtfour); ViewBag.IsShow = 1; string datetime = stunum.Substring(0, 4).ToString(); //通过年级来设置学习顾问,组织等信息;大二和大三成员只能看到自己的学习顾问,管理员也无法修改 #region 1初始化下拉框的信息 List <MODEL.T_Department> dep = OperateContext.Current.BLLSession.IDepartmentBLL.GetListBy(u => u.DepartmentId > 0); List <MODEL.T_TechnicaLevel> techLeval = OperateContext.Current.BLLSession.ITechnicaLevelBLL.GetListBy(u => u.TechLevelId > 0); List <MODEL.T_MemberInformation> StudyGuide = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => (u.T_RoleAct.Select(p => p.RoleId).Contains(Position.StudyMember) || u.T_RoleAct.Select(p => p.RoleId).Contains(Position.StudyLeader))); List <MODEL.T_Organization> organization = OperateContext.Current.BLLSession.IOrganizationBLL.GetListBy(u => u.OrganizationId > 0); //选择信息赋值,初始化部门,组织,技术水平下拉框 ViewBag.dep = dep; ViewBag.techLeval = techLeval; ViewBag.StudyGuide = StudyGuide; ViewBag.organization = organization; #endregion #region 2个人信息赋初始值 //成员的基本信息 MODEL.T_MemberInformation member = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == stunum).FirstOrDefault(); if (OperateContext.Current.HasPemission("PersonalManger", "CheckMember", "AdminEdit", "3")) { ViewBag.HasPer = true; ViewBag.urlfix = "AdminEdit"; } else { ViewBag.urlfix = "Edit"; } ViewBag.member = member; int familyTel = 0; //设置私密信息 int address = 0; int phone = 0; GetSecret(member.SecretShow, ref familyTel, ref address, ref phone); ViewBag.familyTel = familyTel; ViewBag.address = address; ViewBag.phone = phone; string dtime = ""; //为生日赋初始值,生日在数据库是可为空类型,直接赋值报错 if (member.Birthday != null) { dtime = member.Birthday.ToString().Substring(0, 10); } ViewBag.dtime = dtime; ViewBag.IsOne = 0; //判断成员是不是大一成员 if (dtone == datetime) { ViewBag.IsOne = 1; } //为专业下拉框设值 string[] Professional = { "计算机科学技术", "网络工程", "通信工程", "软件工程", "设计艺术", "市场营销", "其他" }; ViewBag.Professional = Professional; int count = Professional.Count(); ViewBag.count = count; #endregion #region 3成员自己的实验室信息赋初始值 ViewBag.StuGuide = ""; ViewBag.org = ""; ViewBag.depName = ""; try { ViewBag.StuGuide = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == member.StudyGuideNumber).First().StuName; int orgId = OperateContext.Current.BLLSession.IOgnizationActBLL.GetListBy(o => o.RoleActor == member.StuNum).First().OrganizationId; string orgName = OperateContext.Current.BLLSession.IOrganizationBLL.GetListBy(u => u.OrganizationId == orgId).First().OrganizationName; ViewBag.orgName = orgName; ViewBag.orgId = orgId; ViewBag.depName = OperateContext.Current.BLLSession.IDepartmentBLL.GetListBy(u => u.DepartmentId == member.Department).First().DepartmentName; } catch (Exception ex) { } #endregion return(View()); }
//个人信息 模块 #region 1.1点击个人信息链接,个人信息展示页面 ViewResult PersonPage() public ViewResult PersonPage() { string stunum = Request.QueryString["StuNum"];//这个链接是从成员信息过来的 string backurl = Request.QueryString["backurl"]; if (string.IsNullOrEmpty(backurl)) { ViewBag.backurl = "fromperson"; } else { if (backurl == "fromindex") { ViewBag.backurl = "fromindex"; } if (backurl == "fromrole") { ViewBag.backurl = "fromrole"; } } if (string.IsNullOrEmpty(stunum)) { stunum = OperateContext.Current.Usr.StuNum; } /*判断每个人是否具有修改的权限*/ string IsEdit; //如果是管理员或者是自己本身则具有修改权限 if (OperateContext.Current.HasPemission("PersonalManger", "CheckMember", "AdminEdit", "post") || stunum.Equals(OperateContext.Current.Usr.StuNum)) { IsEdit = "True"; ViewBag.IsEdit = IsEdit; } else { IsEdit = "False"; ViewBag.IsEdit = IsEdit; } //拿到此用户信息的对象 MODEL.T_MemberInformation member = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == stunum).FirstOrDefault(); ViewBag.member = member; //设置私密信息 int familyTel = 0; int address = 0; int phone = 0; GetSecret(member.SecretShow, ref familyTel, ref address, ref phone); ViewBag.familyTel = familyTel; ViewBag.address = address; ViewBag.phone = phone; //获取该人担任的职务 string RoleString = ""; List <string> role = member.T_RoleAct.Select(u => u.T_Role.RoleName).ToList(); for (int i = 0; i < role.Count; i++) { if (i > 2) { RoleString = RoleString + "..."; break; } RoleString = RoleString + " " + role[i]; } ViewBag.RoleString = RoleString; return(View()); }
public ActionResult UpLoadImg() { HttpPostedFileBase head = Request.Files["head"]; string StuNum = Request["StuNum"]; string fileName = head.FileName; string ext = Path.GetExtension(fileName).ToLower(); if (!ext.Equals(".gif") && !ext.Equals(".jpg") && !ext.Equals(".png") && !ext.Equals(".bmp")) { return Content("<script>alert('您上传的文件格式不正确!上传格式有(.gif、.jpg、.png、.bmp)')</script>"); } else if (head.ContentLength > 1048576 * 5) { return Content("<script>alert('内容最大为5M')</script>"); } else { try { head.SaveAs(Server.MapPath("~/HeadImg/" + fileName)); string ImagePath = "../../HeadImg/" + fileName; MODEL.T_MemberInformation user = new MODEL.T_MemberInformation() { StuNum = StuNum, PhotoPath = ImagePath }; OperateContext.Current.BLLSession.IMemberInformationBLL.Modify(user, new string[] { "PhotoPath" }); return Content("<script>alert('修改成功')</script>"); } catch (Exception ex) { return Content("<script>alert('修改失败')</script>"); } } }
public ActionResult BatchAdd(HttpPostedFileBase filebase) { HttpPostedFileBase file = Request.Files["files"]; string FileName; string savePath; if (file == null || file.ContentLength <= 0) { return(Content("<script>alert('文件不能为空!');window.location='/PersonalManger/CheckMember/AddStu';</script>")); } else { string filename = Path.GetFileName(file.FileName); int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte string fileEx = Path.GetExtension(filename); //获取上传文件的扩展名 string NoFileName = Path.GetFileNameWithoutExtension(filename); //获取无扩展文件名 int MaxSize = 8000 * 1024; //定义上传文件的最大空间大小为8M string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串 FileName = NoFileName + fileEx; if (!FileType.Contains(fileEx)) { return(Content("<script>alert('文件类型不对,只能导入xls和xlsx格式的文件!');window.location='/PersonalManger/CheckMember/AddStu';</script>")); } if (filesize >= MaxSize) { return(Content("<script>alert('上传文件超过8M,请小于8M!');window.location='/PersonalManger/CheckMember/AddStu';</script>")); } string path = AppDomain.CurrentDomain.BaseDirectory + "Excel\\"; savePath = Path.Combine(path, FileName); file.SaveAs(savePath); } FileStream fs = new FileStream(savePath, FileMode.Open, FileAccess.ReadWrite, FileShare.None);//创建文件流 DataTable dt = new XlsStreamToDT(fs, 15).Xls2DT(); using (var scope = new TransactionScope()) { MODEL.T_MemberInformation member; for (int i = 1; i < dt.Rows.Count; i++) { member = new MODEL.T_MemberInformation(); member.StuNum = dt.Rows[i][0].ToString(); //获取学号 member.StuName = dt.Rows[i][1].ToString(); //获取姓名 member.LoginPwd = dt.Rows[i][2].ToString(); //获取初始密码 member.QQNum = "1"; member.Email = "*****@*****.**"; member.PhotoPath = "../../HeadImg/final.png"; member.JoinTime = DateTime.Now; member.Department = 10007; member.TechnicalLevel = 10003; member.IsAdmin = false; member.IsDelete = false; member.SecretShow = 7; OperateContext.Current.BLLSession.IMemberInformationBLL.Add(member); MODEL.T_OgnizationAct OrganizationAct = new MODEL.T_OgnizationAct() { OrganizationId = 10004, RoleActor = member.StuNum, IsDel = false }; OperateContext.Current.BLLSession.IOgnizationActBLL.Add(OrganizationAct); //对每一个新成员赋予实习生的角色 MODEL.T_RoleAct ra = new MODEL.T_RoleAct(); ra.RoleId = 10009; ra.RoleActor = member.StuNum; ra.IsDel = false; OperateContext.Current.BLLSession.IRoleActBLL.Add(ra); } scope.Complete(); } //删除掉存储在网站目录下的文件 //事实上,调用File.Delete并没有删除文件,它只是让操作系统认为文件不存在, //文件在磁盘上的空间被标记成空的,以便用于再次使用。但是文件的数据没有被移除,您可以非常容易恢复。 //被删除的文件直到相应的空间被重写才会真消失,这也许要很长时间。 if (System.IO.File.Exists(savePath)) { System.IO.File.Delete(savePath); } return(Content("<script>alert('批量新增成功!');window.location='/PersonalManger/CheckMember/Index';</script>")); }
public string SendMessage(FormCollection form) { MODEL.Tbl_Message message = new MODEL.Tbl_Message(); MODEL.Tbl_User_Message userMessage = new MODEL.Tbl_User_Message(); MODEL.T_MemberInformation user = OperateContext.Current.Usr;//Session["user"] as MODEL.T_MemberInformation; string receiveName = form["receiveName"]; string topic = form["topic"]; string messageContent = form["messageContent"]; string hiddenFileAddress = form["hiddenFileAddress"]; //string sendTime = form["sendTime"]; DateTime sendTime = DateTime.Parse(form["sendTime"]); //DateTime sendTime = DateTime.Now; message.Title = topic; message.Content = messageContent; message.SendTime = sendTime; message.Atachment = hiddenFileAddress; string[] arr = receiveName.Split(';'); List <string> receiverId = new List <string>(); //兼容联系人末尾是否有“;” if (arr[arr.Length - 1] == "") { for (int i = 0; i < arr.Length - 1; i++) { string[] a = arr[i].Split('|'); receiverId.Add(a[a.Length - 1]); } } else { for (int i = 0; i < arr.Length; i++) { string[] a = arr[i].Split('|'); receiverId.Add(a[a.Length - 1]); } } if (receiverId.Count() <= 0) { return("no"); } else { foreach (string id in receiverId) { List <MODEL.T_MemberInformation> model = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == id); if (model.Count() <= 0) { return("nook"); } } } //int result = OperateContext.Current.BLLSession.Il_MessageBLL.Add(message); MODEL.Tbl_Message messageList = OperateContext.Current.BLLSession.Il_MessageBLL.AddGetAutoId(message); userMessage.MessageId = messageList.Id; userMessage.SendId = user.StuNum; foreach (string str in receiverId) { List <MODEL.T_MemberInformation> list = OperateContext.Current.BLLSession.IMemberInformationBLL.GetListBy(u => u.StuNum == str); userMessage.ReceiveId = str; int result = OperateContext.Current.BLLSession.Il_User_MessageBLL.Add(userMessage); if (result <= 0) { return("no"); } } return("ok"); }