protected void btnPhoto_Click(object sender, EventArgs e)
{
marykay_Set s = (from a in _db.marykay_Set
where a.sId == 4
select a).FirstOrDefault();
if (btnPhoto.Text == "开启照片")
{
s.sIsOpen = true;
_db.SaveChanges();
btnPhoto.Text = "关闭照片";
}
else
{
s.sIsOpen = false;
_db.SaveChanges();
btnPhoto.Text = "开启照片";
}
}
public void LoadFirstQData()
{
marykay_Set s = (from a in _db.marykay_Set
where a.sId == 3
select a).FirstOrDefault();
if (s.sIsOpen == true)
{
btnQuestion.Text = "关闭问卷";
}
else
{
btnQuestion.Text = "开启问卷";
}
marykay_Set s2 = (from a in _db.marykay_Set
where a.sId == 4
select a).FirstOrDefault();
if (s2.sIsOpen == true)
{
btnPhoto.Text = "关闭照片";
}
else
{
btnPhoto.Text = "开启照片";
}
PageIndex = 1;
list = (from r in _db.korea_record
join emp in _db.korea_employeeMK on new { EId = r.eId.Value } equals new { EId = emp.eId }
join ans in
(
(from a in _db.korea_answer
group a by new
{
a.rId
} into g
select new
{
arid = g.Key.rId.Value,
answer1 = g.Max(p => (p.qId == 1 ? p.aContent : null)),
answer2 = g.Max(p => (p.qId == 2 ? p.aContent : null)),
answer3 = g.Max(p => (p.qId == 3 ? p.aContent : null)),
answer4 = g.Max(p => (p.qId == 4 ? p.aContent : null)),
answer5 = g.Max(p => (p.qId == 5 ? p.aContent : null)),
answer6 = g.Max(p => (p.qId == 6 ? p.aContent : null)),
answer7 = g.Max(p => (p.qId == 7 ? p.aContent : null)),
answer8 = g.Max(p => (p.qId == 8 ? p.aContent : null)),
answer9 = g.Max(p => (p.qId == 9 ? p.aContent : null)),
answer10 = g.Max(p => (p.qId == 10 ? p.aContent : null)),
answer11 = g.Max(p => (p.qId == 11 ? p.aContent : null)),
answer12 = g.Max(p => (p.qId == 12 ? p.aContent : null))
}))on new { RId = r.rId } equals new { RId = ans.arid }
orderby
r.rId
select new RecordModel
{
AnswerId = r.rId,
AnswerName = emp.eName,
AnswerNumber = emp.eNumber,
AnswerPhone = emp.ePhone,
AnswerDuration = r.rDuration.Value,
AnswerTime = r.rEndtime.Value,
AnswerAnswer1 = ans.answer1,
AnswerAnswer2 = ans.answer2,
AnswerAnswer3 = ans.answer3,
AnswerAnswer4 = ans.answer4,
AnswerAnswer5 = ans.answer5,
AnswerAnswer6 = ans.answer6,
AnswerAnswer7 = ans.answer7,
AnswerAnswer8 = ans.answer8,
AnswerAnswer9 = ans.answer9,
AnswerAnswer10 = ans.answer10,
AnswerAnswer11 = ans.answer11,
AnswerAnswer12 = ans.answer12,
}).Skip(PageCount * (PageIndex - 1)).Take(PageCount).ToList();
lblIndex.InnerText = (PageIndex).ToString();
lblCount.InnerText = (nuCount()).ToString();
repTaskInfo.DataSource = list;
repTaskInfo.DataBind();
var sumEmp = (from b in _db.korea_employeeMK select b).ToList().Count();
lblSumCount.Text = "当前总人数为:" + sumEmp + "，已答题人数<span style='color:red; margin:0 8px;'>" + list.Count + "</span>位。";
btnFrist.Enabled = true;
btnPrv.Enabled = true;
btnLast.Enabled = true;
btnNext.Enabled = true;
if (PageIndex == 1)
{
btnPrv.Enabled = false;
btnFrist.Enabled = false;
}
if (PageIndex == nuCount())
{
btnNext.Enabled = false;
btnLast.Enabled = false;
}
}
