protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
M_Design_Answer ansMod = ansBll.SelReturnModel(AnsID);
M_Design_Ask askMod = askBll.SelReturnModel(ansMod.AskID);
Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "Main.aspx'>工作台</a></li><li><a href='Default.aspx'>动力模块</a></li><li><a href='AnsList.aspx?AskID=" + ansMod.AskID + "'>回答列表</a></li><li class='active'>" + askMod.Title + "</li>");
MyBind();
}
}
//-------------
//检测问卷可否被提交
private bool CheckAsk(M_Design_Ask askMod, ref string err)
{
string ip = IPScaner.GetUserIP(HttpContext);
if (askMod == null)
{
err = "问卷不存在"; return(false);
}
if (askMod.IsNeedLogin == 1 && mu.IsNull)
{
err = "[" + askMod.Title + "]必须登录后才可访问"; return(false);
}
if (askMod.ZStatus != (int)ZLEnum.ConStatus.Audited)
{
err = "[" + askMod.Title + "]未开放"; return(false);
}
if (askMod.StartDate >= DateTime.Now)
{
err = "[" + askMod.Title + "]尚未到开放时间"; return(false);
}
if (askMod.EndDate <= DateTime.Now)
{
err = "[" + askMod.Title + "]已经结束"; return(false);
}
if (askMod.IsIPLimit > 0)
{
//if (ip.StartsWith("192.168") || ip.Equals("::1")) { }
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("ip", ip),
new SqlParameter("sdate", DateTime.Now.ToString("yyyy/MM/dd 00:00:00")),
new SqlParameter("edate", DateTime.Now.ToString("yyyy/MM/dd 23:59:59"))
};
int count = DBCenter.Count(ansBll.TbName, "IP=@ip AND AskID=" + askMod.ID + " AND (CDate>@sdate AND CDate<@edate)", sp);
if (count >= askMod.IsIPLimit)
{
err = "系统限定：一天只能提交" + askMod.IsIPLimit + "份,请明天再来"; return(false);
}
}
if (askMod.IPInterval > 0)
{
//取最近的一条记录
M_Design_Answer ansMod = ansBll.SelModelByIP(ip);
if (ansMod == null || (DateTime.Now - ansMod.CDate).TotalSeconds > askMod.IPInterval)
{
}
else
{
err = "系统限定:每隔" + DateHelper.ShowSeconds(askMod.IPInterval) + "才可再次提交";
return(false);
}
}
return(true);
}
public string ResultAdd_Submit()
{
if (!AdminCheck())
{
return("无权访问");
}
int ansnum = DataConvert.CLng(GetParam("ansnum"));
if (ansnum < 1)
{
return("投票人数不正确");
}
//[后期改为附加虚拟值的方式]
M_Design_Ask askMod = askBll.SelReturnModel(Mid);
if (askMod == null)
{
return("问卷不存在");
}
//--------------------------------
M_Design_Answer ansMod = new M_Design_Answer();
ansMod.AskID = askMod.ID;
//ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'}
ansMod.Answer = GetParam("answer");
ansMod.UserID = -1;
ansMod.IP = IPScaner.GetUserIP(HttpContext);
ansMod.Source = "管理员添加";
for (int i = 0; i < ansnum; i++)
{
ansMod.ID = 0;
ansMod.ID = ansBll.Insert(ansMod);
//-----------单独写入表中,便于后期分析(后期优化为批量插入)
List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(GetParam("answer"));
foreach (M_SubOption ans in ansList)
{
M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail();
ansdeMod.AskID = ansMod.AskID;
ansdeMod.AnsID = ansMod.ID;
ansdeMod.Qid = ans.qid;
ansdeMod.Answer = ans.answer;
ansdeMod.UserID = ansMod.UserID;
ansdeBll.Insert(ansdeMod);
}
}
return(Success.ToString());
}
public string Vote_Submit()
{
M_Design_Ask askMod = askBll.SelReturnModel(Mid);
if (askMod == null)
{
return("问卷不存在");
}
if (askMod.IsEnableVCode == 1)
{
if (!ZoomlaSecurityCenter.VCodeCheck(GetParam("vkey"), GetParam("vcode")))
{
return("验证码不正确");
}
}
if (!CheckAsk(askMod, ref err))
{
return(err);
}
M_Design_Answer ansMod = new M_Design_Answer();
ansMod.AskID = askMod.ID;
//ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'}
ansMod.Answer = GetParam("answer");
ansMod.UserID = mu.UserID;
ansMod.IP = IPScaner.GetUserIP(HttpContext);
//ansMod.Source = DeviceHelper.GetBrower().ToString();
ansMod.ID = ansBll.Insert(ansMod);
//-----------单独写入表中,便于后期分析(后期优化为批量插入)
List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(GetParam("answer"));
foreach (M_SubOption ans in ansList)
{
M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail();
ansdeMod.AskID = ansMod.AskID;
ansdeMod.AnsID = ansMod.ID;
ansdeMod.Qid = ans.qid;
ansdeMod.Answer = ans.answer;
ansdeMod.UserID = ansMod.UserID;
ansdeBll.Insert(ansdeMod);
}
return(Success.ToString());
}
//用户的回答
public IActionResult ShowAnswer()
{
if (!AdminCheck())
{
return(null);
}
M_Design_Ask askMod = askBll.SelReturnModel(Mid);
M_Design_Answer ansMod = ansBll.SelReturnModel(DataConvert.CLng(GetParam("ansid")));
DataTable questDT = questBll.Sel(askMod.ID, "qlist");
ViewBag.questDT = questDT;
ViewBag.Mode = "answer";
ViewBag.ansMod = ansMod;
if (ansMod == null)
{
return(WriteErr("传入的参数不正确"));
}
return(View("Index", askMod));
}
public int Insert(M_Design_Answer model)
{
return(DBCenter.Insert(model));
}
public bool UpdateByID(M_Design_Answer model)
{
return(DBCenter.UpdateByID(model, model.ID));
}
public void ProcessRequest(HttpContext context)
{
M_UserInfo mu = buser.GetLogin();
retMod.retcode = M_APIResult.Failed;
try
{
switch (Action)
{
case "submit":
{
M_Design_Answer ansMod = new M_Design_Answer();
ansMod.AskID = Convert.ToInt32(Req("askid"));
//ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'}
ansMod.Answer = Req("answer");
ansMod.UserID = mu.UserID;
ansMod.IP = IPScaner.GetUserIP();
ansMod.Source = DeviceHelper.GetBrower().ToString();
ansMod.ID = ansBll.Insert(ansMod);
//-----------单独写入表中,便于后期分析(后期优化为批量插入)
List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(Req("answer"));
foreach (M_SubOption ans in ansList)
{
M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail();
ansdeMod.AskID = ansMod.AskID;
ansdeMod.AnsID = ansMod.ID;
ansdeMod.Qid = ans.qid;
ansdeMod.Answer = ans.answer;
ansdeMod.UserID = ansMod.UserID;
ansdeBll.Insert(ansdeMod);
}
retMod.retcode = M_APIResult.Success;
retMod.result = ansMod.ID.ToString();
}
break;
case "list":
{
DataTable dt = ansBll.Sel(mu.UserID, -100);
retMod.retcode = M_APIResult.Success;
retMod.result = JsonConvert.SerializeObject(dt);
}
break;
case "listbyqid": //仅用于查看详情
{
int qid = Convert.ToInt32(Req("qid"));
DataTable dt = ansdeBll.Sel(qid.ToString());
retMod.retcode = M_APIResult.Success;
retMod.result = JsonConvert.SerializeObject(dt);
}
break;
default:
retMod.retmsg = "[" + Action + "]接口不存在";
break;
}
}
catch (Exception ex) { retMod.retmsg = ex.Message; }
RepToClient(retMod);
}
