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();
}
}
