public ActionResult CheckReportData(string ReportID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { try { Int64 RID = Convert.ToInt64(ReportID); Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == RID).FirstOrDefault(); var countInfo = db.countInfo.Where(e => e.questionnaireID == RID); ViewBag.allPerson = countInfo.Count(); if (questionnaireInfo != null) { int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); ViewData["show"] = "{value: 330,color:\"#F38630\"},{value: 100,color:\"red\"},{value: 50,color:\"yello\"}"; return View(outInfo); } else { return View(); } } catch { return View(); } } }
public ActionResult CheckReportList(string questionnaireYear) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var outInfo = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否"); var ww = outInfo.Distinct().Select(a => a.questionnaireYear); ViewData["years"] = ww.Distinct().ToArray(); if (questionnaireYear != null) { if (questionnaireYear == "allYears") { var outInfo1 = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否"); return View(outInfo1); } else { var outInfo1 = db.questionnaireInfo.Where(a => a.questionnaireYear.Contains(questionnaireYear)).OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否"); return View(outInfo1); } } else { var outInfo1 = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否"); return View(outInfo1); } } }
public ActionResult ProcessCompanyPwd(string userLoginName,string userMail) { string timeString = DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒"); Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var info= db.companyInfo.Where(a => a.loginName == userLoginName && a.userMail == userMail && a.is_Del == "否").FirstOrDefault(); if (info != null) { string before=info.userID+info.userMail+info.loginName+DateTime.Now.ToString(); MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider(); byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(before)); StringBuilder sBuilder = new StringBuilder(); for (int i = 0; i < data.Length; i++) { sBuilder.Append(data[i].ToString("x2")); } string authIn = sBuilder.ToString(); App_Class.Mail sm = new App_Class.Mail(); Models.ResetUserPasswordInfo rup = new Models.ResetUserPasswordInfo() { userID=info.userID, authInfo=authIn, EXP=DateTime.Now.AddMinutes(30), is_Use="否" }; db.ResetUserPasswordInfo.Add(rup); db.SaveChanges(); string mailContent = " <div style =\"width: 1003px;font-size:16px; margin: 0 auto;font-family:'Microsoft YaHei UI'\">" + "<div style=\"text-align:center\"><img src=\"http://139.129.23.13:81/Static/img/sziitselogo.jpg\"></div>" + "<p style=\"margin-left:23px;\">尊敬的" + info.userName + "专家:</p><p style=\"margin: 0 23px; text-indent:2em;\"><span style=\"color:red\">"+ "您在"+timeString+"提交找回密码请求,请点击下面的链接修改用户"+info.loginName+"的密码</span></p>"+ "<p style=\"margin: 0 23px; text-indent:2em;\"><a href=\"http://139.129.23.13:81/Home/ResetUserPassword?authenticationInfo=" + authIn + "\" target=\"_blank\">重置密码</a></p>" + "<p style=\"margin: 0 23px; text-indent:2em;\">http://139.129.23.13:81/Home/ResetUserPassword?authenticationInfo=" + authIn + "</p>" + "<p style=\"margin: 0 23px; text-indent:2em;\">(如果您无法点击这个链接,请将此链接复制到浏览器地址栏后访问)</p>"+ "<p style=\"margin: 0 23px; text-indent:2em;\">为了保证您帐号的安全性,该链接有效期为30分钟,并且点击一次后将失效! </p>"+ "<p style=\"margin: 0 23px; text-indent:2em;\">如果您误收到此电子邮件,则可能是其他用户在尝试帐号设置时的误操作,如果您并未发起该请求,则无需再进行任何操作,并可以放心地忽略此电子邮件。 </p>"+ "<p style=\"margin: 0 23px; text-indent:2em;\">若您担心帐号安全,建议您立即登录,修改登陆密码。</p>"+ " <p style=\"float:right\">深圳信息职业技术学院软件学院调研系统 <br/>邮件发送时间:" + DateTime.Now.ToString() + "</p><br/>" + "<p><a href=\"http://139.129.23.13:81 \" target=\"_blank\"style=\"-moz-box-shadow: inset 0px 1px 0px 0px #54a3f7; -webkit-box-shadow: inset 0px 1px 0px 0px #54a3f7; box-shadow: inset 0px 1px 0px 0px #54a3f7; background: -webkit-gradient(linear, left top, left bottom, color-stop(0.05, #007dc1), color-stop(1, #0061a7)); background: -moz-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -webkit-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -o-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -ms-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: linear-gradient(to bottom, #007dc1 5%, #0061a7 100%); filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#007dc1', endColorstr='#0061a7',GradientType=0); background-color: #007dc1; -moz-border-radius: 3px; -webkit-border-radius: 3px; border-radius: 3px; border: 1px solid #124d77; display: inline-block; cursor: pointer; color: #ffffff; font-family: Arial; font-size: 13px; padding: 6px 24px; text-decoration: none; text-shadow: 0px 1px 0px #154682;\">了解更多</a></p>" + "</div>" + "<div style=\"text-align: center;padding:23px 0 0 0;font-size:12px;color:#909090;\">本邮件由软件学院调研系统自动发出,无需回复。感谢您的支持与合作</div>"; if (sm.sendMail(info.userMail, info.userName, "软件学院调研系统-用户密码找回", mailContent)) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('资料核对成功,请到邮箱点击链接重置密码,该链接30分钟内有效',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); } else { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('资料核对成功,但由于系统故障,暂未能发送重置密码邮件,请重试或者联系管理员',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); } } else { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('很抱歉,没有找到相关资料,无法为您重置密码,请联系管理员',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); } return View(); }
public ActionResult CompleteReport(float ReportID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Session["ReportID"] = ReportID; Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == ReportID).FirstOrDefault(); Int64 uid = Convert.ToInt64(Session["userID"]); var checkComplete = db.countInfo.Where(e => e.questionnaireID == ReportID&&e.userID==uid).FirstOrDefault(); if (questionnaireInfo != null) { if (checkComplete != null) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该问卷您已经填写过了,无法重复填写,谢谢您的配合',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } else if (questionnaireInfo.questionnaireState == "禁用") { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该问卷状态为禁用,无法填写,谢谢您的配合',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } else if (questionnaireInfo.is_Del == "是") { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('系统找不到该问卷,请重新尝试',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } else if (questionnaireInfo.questionnaireEXP < DateTime.Now) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该问卷已过期,无法填写,谢谢您的配合',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } if (Session["cuowu"] != null) { ViewData["error"] = 1; } int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); return View(outInfo); } else { return RedirectToAction("Index", "Company"); } } }
public bool checkUpdateInfo() { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 uid= Convert.ToInt64(Session["userID"]); var u = db.companyInfo.Where(a => a.userID == uid).FirstOrDefault(); if (u != null) { if (u.is_edit == "否") { return false; } else { return true; } } else { return false; } }
public ActionResult CheckReport(string ReportID) { Int64 RID = Convert.ToInt64(ReportID); if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == RID).FirstOrDefault(); var checkComplete = db.countInfo.Where(e => e.questionnaireID == RID).FirstOrDefault(); if (questionnaireInfo != null) { if (questionnaireInfo.questionnaireState == "禁用") { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该问卷状态为禁用,无法查阅,谢谢您的配合',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } else if (questionnaireInfo.is_Del == "是") { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('系统找不到该问卷,请重新尝试',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); return View(outInfo); } else { return RedirectToAction("Index", "Company"); } } }
//AddReportTopics 为调研表添加题目 public ActionResult AddReportTopics(string ReportID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 qid = Convert.ToInt64(ReportID); var s = db.questionnaireInfo.Where(a => a.questionnaireID == qid && a.is_Del == "否").FirstOrDefault(); if (s != null) { Session["AddReportTopics"] = qid; return View(); } else { return View(); } } }
public JsonResult GetReportList(string year) { if (!is_Login()) { return Json("error", JsonRequestBehavior.AllowGet); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var info = from f in db.questionnaireInfo where f.questionnaireYear == year &&f.is_Del=="否" select new { qid = f.questionnaireID, qname = f.questionnaireName }; return Json(info, JsonRequestBehavior.AllowGet); } }
public ActionResult ReportList(string questionnaireYear) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { if (checkUpdateInfo()) { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var outInfo = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否" && s.questionnaireState != "禁用"); var yea=outInfo.Distinct().Select(a => a.questionnaireYear); ViewData["years"] =yea.Distinct().ToArray(); if (questionnaireYear != null) { if (questionnaireYear == "allYears") { var outInfo1 = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否"&&s.questionnaireState!="禁用"); return View(outInfo1); } else { var outInfo1 = db.questionnaireInfo.Where(a => a.questionnaireYear.Contains(questionnaireYear)).OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否" && s.questionnaireState != "禁用"); return View(outInfo1); } } else { var outInfo1 = db.questionnaireInfo.OrderByDescending(e => e.questionnaireID).Where(s => s.is_Del == "否" && s.questionnaireState != "禁用"); return View(outInfo1); } } else { return RedirectToAction("UpdateCompanyInformation", "Company"); } } }
public ContentResult SetUserAudit(string UID,string OperatingValue) { if (!is_Login()) { return Content("ERROR"); } else { try { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 ui = Convert.ToInt64(UID); var ua = db.companyInfo.Where(e => e.userID == ui).FirstOrDefault(); App_Class.Mail sm = new App_Class.Mail(); if (OperatingValue == "pass") { ua.is_Audit = "是"; string mailContent = " <div style =\"width: 1003px;font-size:16px; margin: 0 auto;font-family:'Microsoft YaHei UI'\">" + "<div style=\"text-align:center\"><img src=\"http://139.129.23.13:81//Static/img/sziitselogo.jpg\"></div>" + "<p style=\"margin-left:23px;\">尊敬的" + ua.userName + "专家:</p><p style=\"margin: 0 23px; text-indent:2em;\">恭喜!您已成功通过系统审核,现在您已经可以登录系统,欢迎您使用,您的登陆账号为:" + ua.loginName + "</p>" + " <p style=\"margin: 0 23px; text-indent:2em;\">感谢您的支持与合作</p><br />" + " <p style=\"float:right\">深圳信息职业技术学院软件学院调研系统 <br/>邮件发送时间:" + DateTime.Now.ToString() + "</p><br/>" + "<p><a href=\"http://139.129.23.13:81/\" target=\"_blank\"style=\"-moz-box-shadow: inset 0px 1px 0px 0px #54a3f7; -webkit-box-shadow: inset 0px 1px 0px 0px #54a3f7; box-shadow: inset 0px 1px 0px 0px #54a3f7; background: -webkit-gradient(linear, left top, left bottom, color-stop(0.05, #007dc1), color-stop(1, #0061a7)); background: -moz-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -webkit-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -o-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -ms-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: linear-gradient(to bottom, #007dc1 5%, #0061a7 100%); filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#007dc1', endColorstr='#0061a7',GradientType=0); background-color: #007dc1; -moz-border-radius: 3px; -webkit-border-radius: 3px; border-radius: 3px; border: 1px solid #124d77; display: inline-block; cursor: pointer; color: #ffffff; font-family: Arial; font-size: 13px; padding: 6px 24px; text-decoration: none; text-shadow: 0px 1px 0px #154682;\">了解更多</a></p>" + "</div>" + "<div style=\"text-align: center;padding:23px 0 0 0;font-size:12px;color:#909090;\">本邮件由软件学院调研系统自动发出,无需回复。感谢您的支持与合作</div>"; sm.sendMail(ua.userMail, ua.userName, "恭喜,您已成功通过系统审核!", mailContent); } else { string mailContent1 = " <div style =\"width: 1003px;font-size:16px; margin: 0 auto;font-family:'Microsoft YaHei UI'\">" + "<div style=\"text-align:center\"><img src=\"http://139.129.23.13:81//Static/img/sziitselogo.jpg\"></div>" + "<p style=\"margin-left:23px;\">尊敬的" + ua.userName + "专家:</p><p style=\"margin: 0 23px; text-indent:2em;\">很抱歉的通知您,您的申请尚未通过,请您提供真实信息或者联系管理员,欢迎您再次注册</p>" + " <p style=\"margin: 0 23px; text-indent:2em;\">感谢您的支持与合作</p><br />" + " <p style=\"float:right\">深圳信息职业技术学院软件学院调研系统 <br/>邮件发送时间:" + DateTime.Now.ToString() + "</p><br/>" + "<p><a href=\"http://139.129.23.13:81/\" target=\"_blank\"style=\"-moz-box-shadow: inset 0px 1px 0px 0px #54a3f7; -webkit-box-shadow: inset 0px 1px 0px 0px #54a3f7; box-shadow: inset 0px 1px 0px 0px #54a3f7; background: -webkit-gradient(linear, left top, left bottom, color-stop(0.05, #007dc1), color-stop(1, #0061a7)); background: -moz-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -webkit-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -o-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: -ms-linear-gradient(top, #007dc1 5%, #0061a7 100%); background: linear-gradient(to bottom, #007dc1 5%, #0061a7 100%); filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#007dc1', endColorstr='#0061a7',GradientType=0); background-color: #007dc1; -moz-border-radius: 3px; -webkit-border-radius: 3px; border-radius: 3px; border: 1px solid #124d77; display: inline-block; cursor: pointer; color: #ffffff; font-family: Arial; font-size: 13px; padding: 6px 24px; text-decoration: none; text-shadow: 0px 1px 0px #154682;\">了解更多</a></p>" + "</div>" + "<div style=\"text-align: center;padding:23px 0 0 0;font-size:12px;color:#909090;\">本邮件由软件学院调研系统自动发出,无需回复。感谢您的支持与合作</div>"; sm.sendMail(ua.userMail, ua.userName, "很抱歉,您未能通过系统审核!", mailContent1); ua.is_Del = "是"; } db.SaveChanges(); return Content("OK,设置成功"); } catch { return Content("ERROR,设置失败"); } } }
public ActionResult ProcessUpdateReport(FormCollection form) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Int64 rid = Convert.ToInt64(Session["updateReportID"]); Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var info = db.questionnaireInfo.Where(a => a.questionnaireID == rid).FirstOrDefault(); info.questionnaireName = form["questionnaireName"]; DateTime dt = Convert.ToDateTime(form["questionnaireEXP"]); info.questionnaireEXP = dt; info.questionnaireYear = form["userYear"]; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('修改成功',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } }
public ActionResult ProcessAddNewReport(FormCollection form) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); DateTime dt = Convert.ToDateTime(form["questionnaireEXP"]); Models.questionnaireInfo qi = new Models.questionnaireInfo() { questionnaireName = form["questionnaireName"], questionnaireEXP = dt, questionnaireState = form["questionnaireState"], is_Del = "否", questionnaireYear = DateTime.Now.Year.ToString() }; db.questionnaireInfo.Add(qi); db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增成功',function (){window.parent.location = window.parent.location ;});}</script>"); return View(); } }
public ActionResult AllUserList(string userType) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); if (userType == "admin") { var info = db.adminInfo.Where(a => a.is_Del == "否"); string outstring = "<table class=\"table table-hover\" style=\"text-align:center\">"; outstring += "<tr class=\"warning\" style=\"font-weight:bold\"><td>管理员ID</td>"; outstring += "<td>登陆账号</td>"; outstring += "<td>管理员姓名</td><td>可用操作</td></tr>"; foreach (var item in info) { outstring += "<tr><td>" + item.adminID + "</td><td>" + item.loginName + "</td><td>" + item.adminName + "</td><td>" + "<div class=\"dropdown\"><button class=\"btn btn-default btn-xs dropdown-toggle\" type=\"button\" id=\"dropdownMenu1\"" + " data-toggle=\"dropdown\" aria-expanded=\"true\">选择操作<span class=\"caret\"></span></button><ul class=\"dropdown-menu\" " + "role=\"menu\" aria-labelledby=\"dropdownMenu1\"><li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"UpdateUserInfo('admin','" + item.adminID + "')\">修改资料</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('admin','" + item.adminID + "','delete')\">删除账号</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('admin','" + item.adminID + "','resetPassword')\">重置密码</a></li>" + "</ul></div></td></tr>"; } outstring += "</table>"; ViewData["maininfo"] = outstring; return View(); } else if (userType == "company") { ViewBag.userType = "company"; var info = db.companyInfo.Where(D => D.is_Audit == "是" && D.is_Del != "是"); string outstring = "<table class=\"table table-hover\" style=\"text-align:center\">"; outstring += "<tr class=\"warning\" style=\"font-weight:bold\"><td>用户ID</td><td>专家姓名</td><td>手机号码</td><td>单位名称</td><td>账号状态</td><td>操作</td></tr>"; foreach (var item in info) { string pp = ""; if (item.is_Del == "冻结") { pp = "账号被冻结"; } else if (item.is_Del == "否") { pp = "状态正常"; } outstring += "<tr class=\"active\"><td>" + item.userID + "</td><td>" + item.userName + "</td><td>" + item.userPhone + "</td><td>" + item.companyName + "</td><td>" + pp + "</td><td>" + "<div class=\"dropdown\"><button class=\"btn btn-default btn-xs dropdown-toggle\" type=\"button\" id=\"dropdownMenu1\"" + " data-toggle=\"dropdown\" aria-expanded=\"true\">选择操作<span class=\"caret\"></span></button><ul class=\"dropdown-menu\" " + "role=\"menu\" aria-labelledby=\"dropdownMenu1\">" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"UpdateUserInfo('company','" + item.userID + "')\">修改资料</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('company','" + item.userID + "','lockOrUnlock')\">冻结/解冻</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('company','" + item.userID + "','delete')\">删除账号</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('company','" + item.userID + "','resrtPassword')\">重置密码</a></li>" + "</ul></div></td></tr>"; } outstring += "</table>"; ViewData["maininfo"] = outstring; return View(); } else if (userType == "teacher") { var info = db.teacherInfo.Where(a => a.is_del == "否"); string outstring = "<table class=\"table table-hover\" style=\"text-align:center\">"; outstring += "<tr class=\"warning\" style=\"font-weight:bold\"><td>教师ID</td>"; outstring += "<td>登陆账号</td>"; outstring += "<td>教师姓名</td><td>可用操作</td></tr>"; foreach (var item in info) { outstring += "<tr><td>" + item.teacherID + "</td><td>" + item.loginName + "</td><td>" + item.teacherName + "</td><td>" + "<div class=\"dropdown\"><button class=\"btn btn-default btn-xs dropdown-toggle\" type=\"button\" id=\"dropdownMenu1\"" + " data-toggle=\"dropdown\" aria-expanded=\"true\">选择操作<span class=\"caret\"></span></button><ul class=\"dropdown-menu\" " + "role=\"menu\" aria-labelledby=\"dropdownMenu1\"><li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"UpdateUserInfo('teacher','" + item.teacherID + "')\">修改资料</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('teacher','" + item.teacherID + "','delete')\">删除账号</a></li>" + "<li role=\"presentation\"><a role=\"menuitem\" tabindex=\"-1\" href=\"javascript:void(0);\" onclick=\"AccountOperation('teacher','" + item.teacherID + "','resetPassword')\">重置密码</a></li>" + "</ul></div></td></tr>"; } outstring += "</table>"; ViewData["maininfo"] = outstring; return View(); } else { return View(); } } }
public ActionResult UpdatePwd(string oldPwd, string newPwd) { if (Session["userType"] == null) { return RedirectToAction("Index", "Home"); } else { if (oldPwd != null && newPwd != null) { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); if (Session["userType"].ToString() == "teacher") { Int64 uid = Convert.ToInt64(Session["userID"]); var ci = db.companyInfo.Where(e => e.userID == uid && e.loginPwd == oldPwd).FirstOrDefault(); if (ci != null) { ci.loginPwd = newPwd; db.SaveChanges(); ViewBag.msgInfo = "修改成功,下次登录时生效"; } else { ViewBag.msgInfo = "修改失败,原始密码不正确"; } return View(); } else if (Session["userType"].ToString() == "company") { Int64 uid = Convert.ToInt64(Session["userID"]); var ci = db.companyInfo.Where(e => e.userID == uid && e.loginPwd == oldPwd).FirstOrDefault(); if (ci != null) { ci.loginPwd = newPwd; db.SaveChanges(); ViewBag.msgInfo = "修改成功,下次登录时生效"; } else { ViewBag.msgInfo = "修改失败,原始密码不正确"; } return View(); } else { int uid = Convert.ToInt32(Session["adminID"]); var ci = db.adminInfo.Where(f => f.adminID == uid).FirstOrDefault(); if (ci != null) { ci.adminPwd = newPwd; db.SaveChanges(); ViewBag.msgInfo = "修改成功,下次登录时生效"; } else { ViewBag.msgInfo = "修改失败,原始密码不正确"; } return View(); } } else { ViewBag.msgInfo = null; return View(); } } }
public ActionResult ProcessUpdateUserInfo(FormCollection form) { if (Session["userType"] == null) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); try { if (Session["updateUserType"].ToString() == "admin") { int uid = Convert.ToInt32(Session["updateuinfoID"]); var info = db.adminInfo.Where(r => r.adminID == uid).FirstOrDefault(); info.loginName = form["adminLoginName"]; info.adminName = form["adminUserName"]; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('修改成功',function (){window.parent.location=window.parent.location;});}</script>"); return View(); } else if (Session["updateUserType"].ToString() == "teacher") { int uid = Convert.ToInt32(Session["updateuinfoID"]); var info = db.teacherInfo.Where(t => t.teacherID == uid).FirstOrDefault(); info.loginName = form["teacherLoginName"]; info.teacherName = form["teacherName"]; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('修改成功',function (){window.parent.location=window.parent.location;});}</script>"); return View(); } else if (Session["updateUserType"].ToString() == "company") { Int64 uid = Convert.ToInt64(Session["updateuinfoID"]); var info = db.companyInfo.Where(a => a.userID == uid).FirstOrDefault(); info.companyName = form["companyName"]; info.companyAddress = form["companyAddress"]; info.companyWebsite = form["companyWebsite"]; info.userPhone = form["userPhone"]; info.companyPhone = form["companyPhone"]; info.userName = form["userName"]; info.loginName = form["userLoginName"]; info.userMail = form["userMail"]; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('修改成功',function (){window.parent.location=window.parent.location;});}</script>"); return View(); } else { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('修改成功',function (){window.parent.location=window.parent.location;});}</script>"); return View(); } } catch { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('出错了,可能原因为:登陆账号重复了',function (){window.parent.location=window.parent.location;});}</script>"); return View(); } } }
public ActionResult UpdateUserInfo(string userType,string userID) { if (Session["userType"] == null) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); ViewBag.userType = userType; Session["updateUserType"] = userType; if (userType == "admin") { int uid = Convert.ToInt32(userID); var ad = db.adminInfo.Where(e => e.adminID == uid).FirstOrDefault(); Session["updateuinfoID"] = ad.adminID; ViewBag.userName = ad.adminName; ViewBag.loginName = ad.loginName; return View(); } else if (userType == "teacher") { int uid = Convert.ToInt32(userID); var te = db.teacherInfo.Where(e => e.teacherID == uid).FirstOrDefault(); Session["updateuinfoID"] = te.teacherID; ViewBag.userName = te.teacherName; ViewBag.loginName = te.loginName; return View(); } else { Int64 uid = Convert.ToInt64(userID); var info = db.companyInfo.Where(a => a.userID == uid).FirstOrDefault(); Session["updateuinfoID"] = info.userID; ViewBag.userName = info.userName; ViewBag.companyName = info.companyName; ViewBag.companyAddress = info.companyAddress; ViewBag.companyWebsite = info.companyWebsite; ViewBag.userPhone = info.userPhone; ViewBag.userLoginName = info.loginName; ViewBag.companyPhone = info.companyPhone; ViewBag.companyType = info.companyType; return View(); } } }
public ActionResult UpdateCompanyInformation() { if (is_Login()) { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 uid = Convert.ToInt64(Session["userID"]); var info = db.companyInfo.Where(a => a.userID == uid).FirstOrDefault(); ViewBag.userName = info.userName; if (info.is_edit == "是") { return RedirectToAction("Index", "Company"); } else { return View(); } } else { return RedirectToAction("Index", "Home"); } }
public ContentResult AccountOperation(string userType, string userID, string operationType) { if (!is_Login()) { return Content("ERROR"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); if (userType == "company") { Int64 uid = Convert.ToInt64(userID); var ee = db.companyInfo.Where(e => e.userID == uid).FirstOrDefault(); if (operationType == "lockOrUnlock") { if (ee.is_Del == "冻结") { ee.is_Del = "否"; } else { ee.is_Del = "冻结"; } } if (operationType == "delete") { ee.is_Del = "是"; } if (operationType == "resetPassword") { ee.loginPwd = "sziit*123"; } db.SaveChanges(); return Content("操作成功"); } else if (userType == "teacher") { int uid = Convert.ToInt32(userID); var ee = db.teacherInfo.Where(e => e.teacherID == uid).FirstOrDefault(); if (operationType == "delete") { ee.is_del = "是"; } if (operationType == "resetPassword") { ee.loginPWD = "sziit*123"; } db.SaveChanges(); return Content("操作成功"); } else if (userType == "admin") { string outs = ""; int uid = Convert.ToInt32(userID); var ee = db.adminInfo.Where(e => e.adminID == uid).FirstOrDefault(); if (operationType == "delete") { if (db.adminInfo.Count() < 2) { outs = "最少保留一个管理员账号"; } else { ee.is_Del = "是"; outs = "操作成功"; } } if (operationType == "resetPassword") { ee.adminPwd = "sziit*123"; outs = "操作成功"; } db.SaveChanges(); return Content(outs); } else { return Content("ERROR"); } } }
public ContentResult AddUser(string userType,string userLoginName,string userName) { if (!is_Login()) { return Content("ERROR"); } else { try { if (userLoginName == "" || userName == "") { return Content("Error,相关信息不能为空"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); if (userType == "teacher") { Models.teacherInfo ti = new Models.teacherInfo() { loginName = userLoginName, loginPWD = "sziit*123", teacherName = userName, is_del = "否" }; db.teacherInfo.Add(ti); db.SaveChanges(); return Content("OK,新增成功"); } else if (userType == "admin") { Models.adminInfo ai = new Models.adminInfo() { adminName = userName, adminPwd = "sziit*123", loginName = userLoginName, is_Del = "否" }; db.adminInfo.Add(ai); db.SaveChanges(); return Content("OK,新增成功"); } else if (userType == "company") { Models.companyInfo cp = new Models.companyInfo() { userName = userName, loginName = userLoginName, loginPwd = "sziit*123", is_Audit = "是", is_edit = "否", is_Del = "否" }; db.companyInfo.Add(cp); db.SaveChanges(); return Content("OK,新增成功"); } else { return null; } } } catch { return Content("Error,新增失败!登录账号重复了"); } } }
public ActionResult GetUserReportData(int ReportID,Int64 UserID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var uinfo = db.companyInfo.Where(e => e.userID == UserID).FirstOrDefault(); ViewBag.companyAddress = uinfo.companyAddress; ViewBag.companyName = uinfo.companyName; ViewBag.companyPhone = uinfo.companyPhone; ViewBag.companyType = uinfo.companyType; ViewBag.companyWebsite = uinfo.companyWebsite; ViewBag.userName = uinfo.userName; ViewBag.userPhone = uinfo.userPhone; ViewBag.userID = uinfo.userID; var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == ReportID).FirstOrDefault(); var checkComplete = db.countInfo.Where(e => e.questionnaireID == ReportID).FirstOrDefault(); if (questionnaireInfo != null) { if (questionnaireInfo.is_Del == "是") { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('系统找不到该问卷,请重新尝试',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } ViewBag.qname = questionnaireInfo.questionnaireName; int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); return View(outInfo); } else { return View(); } } }
//DeleteTopics删除题目 public ContentResult DeleteTopics(string TopicsID) { try { if (!is_Login()) { return Content("系统错误,请重新登录"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 rid = Convert.ToInt64(TopicsID); var d = db.problemOptionInfo.Where(a => a.problemID == rid); db.problemOptionInfo.RemoveRange(d); var f = db.problemKeyInfo.Where(a => a.problemID == rid); db.problemKeyInfo.RemoveRange(f); var g = db.problemTitleInfo.Where(h => h.problemID == rid); db.problemTitleInfo.RemoveRange(g); db.SaveChanges(); return Content("删除成功"); } } catch { return Content("删除失败,系统错误"); } }
public ActionResult ProcessCompleteReport(FormCollection form) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { try { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); int ReportID = Convert.ToInt32(Session["ReportID"]); var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == ReportID).FirstOrDefault(); if (questionnaireInfo != null) { int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); Models.sziit_researchEntities db2 = new Models.sziit_researchEntities(); Int64 uid = Convert.ToInt64(Session["userID"]); foreach (var item in outInfo) { Int64 pid = item.problemID; if (item.problemType == "单选") { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = form[item.problemID.ToString()].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } else if (item.problemType == "多选") { var getInfo = form[pid.ToString()].Split(','); foreach (var gi in getInfo) { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = gi.ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } } else if (item.problemType == "单选加其他") { if (form[item.problemID.ToString()].ToString() != "otherInfo") { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = form[item.problemID.ToString()].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } else { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = ":" + form[item.problemID.ToString() + "other"].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } } else if (item.problemType == "多选加其他") { var getInfo = form[pid.ToString()].Split(','); foreach (var gi in getInfo) { if (gi.ToString() != "otherInfo") { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = gi.ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } else { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = ":" + form[item.problemID.ToString() + "other"].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } } } else if (item.problemType == "优先顺序题") { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = ":" + form[item.problemID.ToString()].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } else if (item.problemType == "问答题") { Models.problemOptionInfo poi = new Models.problemOptionInfo() { problemID = item.problemID, optionContent = ":"+form[item.problemID.ToString()].ToString(), userID = uid }; db2.problemOptionInfo.Add(poi); } } Models.countInfo ci = new Models.countInfo() { questionnaireID = ReportID, userID = uid, actualFinishTime=DateTime.Now }; db2.countInfo.Add(ci); db2.SaveChanges(); db.Dispose(); } Session["cuowu"] = null; Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('填写完毕,感谢您的配合',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } catch { Session["cuowu"] = 1; return RedirectToAction("CompleteReport", "Company", new { ReportID = Session["ReportID"].ToString() }); } } }
public ActionResult ProcessAddReportTopics(FormCollection form) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { try { int qid = Convert.ToInt32(Session["AddReportTopics"]); Models.sziit_researchEntities db = new Models.sziit_researchEntities(); if (form["TopicsType"].ToString() == "单选题") { Models.problemTitleInfo pti = new Models.problemTitleInfo() { questionnaireID = qid, problemType = "单选", problemTitle = form["problemTitle"] }; db.problemTitleInfo.Add(pti); Int64 problemID = pti.problemID; int count = Convert.ToInt32(form["optionNum"].ToString()); for (int i = 1; i <= count; i++) { string formName = "option" + i.ToString(); Models.problemKeyInfo pki = new Models.problemKeyInfo() { problemID = problemID, keyContent = form[formName] }; db.problemKeyInfo.Add(pki); } db.SaveChanges(); } else if (form["TopicsType"].ToString() == "多选题") { Models.problemTitleInfo pti = new Models.problemTitleInfo() { questionnaireID = qid, problemType = "多选", problemTitle = form["problemTitle"] }; db.problemTitleInfo.Add(pti); Int64 problemID = pti.problemID; int count = Convert.ToInt32(form["optionNum"].ToString()); for (int i = 1; i <= count; i++) { string formName = "option" + i.ToString(); Models.problemKeyInfo pki = new Models.problemKeyInfo() { problemID = problemID, keyContent = form[formName] }; db.problemKeyInfo.Add(pki); } db.SaveChanges(); } else if (form["TopicsType"].ToString() == "单选加其他") { Models.problemTitleInfo pti = new Models.problemTitleInfo() { questionnaireID = qid, problemType = "单选加其他", problemTitle = form["problemTitle"] }; db.problemTitleInfo.Add(pti); Int64 problemID = pti.problemID; int count = Convert.ToInt32(form["optionNum"].ToString()); for (int i = 1; i <= count; i++) { string formName = "option" + i.ToString(); Models.problemKeyInfo pki = new Models.problemKeyInfo() { problemID = problemID, keyContent = form[formName] }; db.problemKeyInfo.Add(pki); } db.SaveChanges(); } else if (form["TopicsType"].ToString() == "多选加其他") { Models.problemTitleInfo pti = new Models.problemTitleInfo() { questionnaireID = qid, problemType = "多选加其他", problemTitle = form["problemTitle"] }; db.problemTitleInfo.Add(pti); Int64 problemID = pti.problemID; int count = Convert.ToInt32(form["optionNum"].ToString()); for (int i = 1; i <= count; i++) { string formName = "option" + i.ToString(); Models.problemKeyInfo pki = new Models.problemKeyInfo() { problemID = problemID, keyContent = form[formName] }; db.problemKeyInfo.Add(pki); } db.SaveChanges(); } else { Models.problemTitleInfo pti = new Models.problemTitleInfo() { questionnaireID = qid, problemType = form["TopicsType"].ToString(), problemTitle = form["problemTitle"] }; db.problemTitleInfo.Add(pti); db.SaveChanges(); } Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增成功',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } catch { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('系统错误!!!',function (){var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index);});}</script>"); return View(); } } }
public ContentResult ShowUserList(string ReportID) { if (!is_Login()) { return Content("error"); } else { Int64 rid = Convert.ToInt64(ReportID); Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var qinfo = db.questionnaireInfo.Where(e => e.questionnaireID == rid).FirstOrDefault(); string outstring = "<table class=\"table table-hover\" style=\"text-align:center\">"; if (qinfo != null) { outstring += "<tr class=\"warning\" style=\"font-weight:bold\"><td colspan=\"3\">调研主题:" + qinfo.questionnaireName + "</td>"; outstring += "<td>状态:" + qinfo.questionnaireState + "</td>"; outstring += "<td >过期时间:" + qinfo.questionnaireEXP + "</td></tr>"; } outstring += "<tr class=\"info\"><td>用户ID</td><td>用户姓名</td><td>所在公司</td><td>完成时间</td><td>可用操作</td></tr>"; var ee = db.countInfo.Where(a => a.questionnaireID == rid).OrderByDescending(r => r.actualFinishTime); foreach (var item in ee) { var uinfo = db.companyInfo.Where(t => t.userID == item.userID).FirstOrDefault(); outstring += "<tr><td>" + item.userID + "</td><td>" + uinfo.userName + "</td><td>" + uinfo.companyName + "</td><td>" + item.actualFinishTime + "</td><td><button type=\"button\" class=\"btn btn-primary btn-sm\" onclick=\"GetUserReportData('" + item.questionnaireID + "','" + item.userID + "')\">查阅用户问卷详情</button></td></tr>"; } outstring += "</table>"; string newString = Microsoft.JScript.GlobalObject.escape(outstring);//escape return Content(newString); } }
//设置调研表状态【启用】【禁用】 public ContentResult SetReportStatus(string ReportID, string operationType) { if (!is_Login()) { return Content("Error"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 rid = Convert.ToInt64(ReportID); var d = db.questionnaireInfo.Where(e => e.questionnaireID == rid).FirstOrDefault(); if (operationType == "delete") { d.is_Del = "是"; db.SaveChanges(); return Content("删除成功"); } else if (operationType == "lockOrUnlock") { if (d.questionnaireState == "启用") { d.questionnaireState = "禁用"; } else { d.questionnaireState = "启用"; } db.SaveChanges(); return Content("状态更改成功"); } else { return Content("Error"); } } }
//更新调研表信息 public ActionResult UpdateReport(string ReportID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Int64 rid = Convert.ToInt64(ReportID); Session["updateReportID"] = rid; Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var info = db.questionnaireInfo.Where(a => a.questionnaireID == rid).FirstOrDefault(); ViewBag.qtitle = info.questionnaireName; ViewBag.exp = info.questionnaireEXP; ViewBag.years = info.questionnaireYear; return View(); } }
// public ActionResult ShowReport(string ReportID) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 rid = Convert.ToInt64(ReportID); var questionnaireInfo = db.questionnaireInfo.Where(a => a.questionnaireID == rid).FirstOrDefault(); if (questionnaireInfo != null) { int QID = Convert.ToInt32(questionnaireInfo.questionnaireID); var outInfo = db.problemTitleInfo.Where(b => b.questionnaireID == QID); return View(outInfo); } else { return View(); } } }
public ActionResult ProcessMaintenanceCompanyInformation(FormCollection form) { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); Int64 uid = Convert.ToInt64(Session["userID"]); var info = db.companyInfo.Where(a => a.userID == uid).FirstOrDefault(); info.companyName = form["companyName"]; info.companyAddress = form["companyAddress"]; info.companyWebsite = form["companyWebsite"]; info.userPhone = form["userPhone"]; info.companyPhone = form["companyPhone"]; db.SaveChanges(); return RedirectToAction("Index", "Company"); } }
public ActionResult UserAudit() { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var ua = db.companyInfo.Where(e => e.is_Audit == "否"&&e.is_Del!="是"); return View(ua.ToList()); } }
public ActionResult CheckUserReportList() { if (!is_Login()) { return RedirectToAction("Index", "Home"); } else { Models.sziit_researchEntities db = new Models.sziit_researchEntities(); var itd = db.questionnaireInfo.Distinct().Select(e => e.questionnaireYear); ViewData["years"] = itd.Distinct(); return View(); } }