//判断是否已提交过或时间是否已过，已提交或时间已过则返回false，用在前台控制 字体不加粗
public bool surveyIsSubmit(string spiid)
{
bool result = true;
int _spiid;
if (int.TryParse(spiid, out _spiid))
{
//判断是否已提交过
Entities.QuerySurveyAnswer query = new Entities.QuerySurveyAnswer();
query.CreateUserID = userID;
query.SPIID = _spiid;
int count;
DataTable dt = BLL.SurveyAnswer.Instance.GetSurveyAnswer(query, "", 1, 10000, out count);
if (dt.Rows.Count > 0)
{
result = false;
}
else
{
//判断时间是否已过
Entities.SurveyProjectInfo query_projectInfo = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(_spiid);
if (query_projectInfo != null)
{
if (query_projectInfo.SurveyEndTime < DateTime.Now)
{
result = false;
}
}
}
}
return(result);
}
//显示按钮
public string showOperBtn(string spiid)
{
string result = string.Empty;
int _spiid;
if (int.TryParse(spiid, out _spiid))
{
Entities.SurveyProjectInfo model = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(_spiid);
if (model != null)
{
if (model.SurveyStartTime <= DateTime.Now && model.SurveyEndTime >= DateTime.Now)//时间没过，显示按钮
{
//判断是否已提交过，已提交则不显示按钮 返回false，且字体不需要加粗
Entities.QuerySurveyAnswer query = new Entities.QuerySurveyAnswer();
query.CreateUserID = userID;
query.SPIID = _spiid;
int count;
DataTable dt = BLL.SurveyAnswer.Instance.GetSurveyAnswer(query, "", 1, 10000, out count);
//没提交过，显示进入调查按钮
if (dt.Rows.Count == 0)
{
result = "<span class='right btnsearch'><input name='' type='button' value='进入调查' onclick='openpage(" + _spiid + ")'/></span>";
}
}
}
}
return(result);
}
//判断能否进入该页面或能否插入回答表；
private void judgeIsCorrect(out string msg)
{
msg = string.Empty;
int _spiid;
if (!int.TryParse(RequestSPIID, out _spiid))
{
msg = "调查项目ID有误";
return;
}
//1-判断该问卷在人员表是否有该登陆者
Entities.QuerySurveyPerson query_Person = new Entities.QuerySurveyPerson();
int count;
query_Person.SPIID = _spiid;
query_Person.ExamPersonID = userID;
DataTable dt_Person = BLL.SurveyPerson.Instance.GetSurveyPerson(query_Person, "", 1, 10000, out count);
if (dt_Person.Rows.Count == 0)
{
msg = "您不在该问卷调查参与人员表中，无法参与该问卷的调查";
return;
}
//2-判断问卷时间是否没到或已过
Entities.SurveyProjectInfo model_ProjectInfo = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(_spiid);
if (model_ProjectInfo == null)
{
msg = "没有找到该问卷调查项目，无法参与该问卷的调查";
return;
}
if (model_ProjectInfo.SurveyStartTime > DateTime.Now)
{
msg = "该问卷调查项目尚未开始，无法参与该问卷的调查";
return;
}
if (model_ProjectInfo.SurveyEndTime < DateTime.Now)
{
msg = "该问卷调查项目已经结束，无法参与该问卷的调查";
return;
}
//3-判断问卷是否被该登陆者提交过
Entities.QuerySurveyAnswer query_Answer = new Entities.QuerySurveyAnswer();
query_Answer.SPIID = _spiid;
query_Answer.CreateUserID = userID;
DataTable dt_Answer = BLL.SurveyAnswer.Instance.GetSurveyAnswer(query_Answer, "", 1, 10000, out count);
if (dt_Answer.Rows.Count > 0)
{
msg = "您已提交过该调查问卷，无法再次提交";
return;
}
//如果上述验证都没问题，msg返回success
msg = "success";
}
private void bindData()
{
Entities.QuerySurveyAnswer query = new Entities.QuerySurveyAnswer();
if (RequestSOID != "")
{
query.SOID = int.Parse(RequestSOID);
}
if (RequestSQID != "")
{
query.SQID = int.Parse(RequestSQID);
}
if (RequestSPIID != "")
{
query.SPIID = int.Parse(RequestSPIID);
}
if (RequestAnswerContent != "")
{
query.AnswerContent = RequestAnswerContent;
}
if (RequestFilterNull != "")
{
query.FilterNull = int.Parse(RequestFilterNull);
}
int page = 1;
if (int.TryParse(Requestpage, out page))
{
page = int.Parse(Requestpage);
}
else
{
page = 1;
}
DataTable dt = BLL.SurveyAnswer.Instance.GetSurveyAnswerByTextDetail(query, "", page, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, page, 1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bool flag = true;
//判断当前登录人是否有查看当前问卷的权限
flag = BLL.Util.CheckRight(BLL.Util.GetLoginUserID(), "SYS024BUT3301");
if (flag == false)
{
Response.Write(@"<script language='javascript'>javascript:alert('您没有查看该问卷的权限');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
else
{
if (!string.IsNullOrEmpty(RequestSPIID))
{
//取项目信息
Entities.SurveyProjectInfo Model = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(Convert.ToInt32(RequestSPIID));
if (Model != null)
{
//取试卷id
RequestSIID = Model.SIID.ToString();
UCSurveyInfoEditID.RequestSPIID = RequestSPIID;
UCSurveyInfoEditID.RequestSIID = RequestSIID;
UCSurveyInfoEditID.RequestUserID = RequestUserID;
SurveyName = Model.Name;
if (!string.IsNullOrEmpty(RequestUserID))
{
UserName = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(RequestUserID));
}
if (!string.IsNullOrEmpty(RequestSPIID) && !string.IsNullOrEmpty(RequestSIID) && !string.IsNullOrEmpty(RequestUserID))
{
Entities.QuerySurveyAnswer query = new Entities.QuerySurveyAnswer();
query.SPIID = Convert.ToInt32(RequestSPIID);
query.SIID = Convert.ToInt32(RequestSIID);
query.CreateUserID = Convert.ToInt32(RequestUserID);
int allcount = 0;
DataTable dt = BLL.SurveyAnswer.Instance.GetSurveyAnswer(query, "", 1, 100000, out allcount);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0]["CreateTime"] != DBNull.Value)
{
if (dt.Rows[0]["CreateTime"].ToString() != "")
{
SurveyTime = Convert.ToDateTime(dt.Rows[0]["CreateTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
}
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('调查问卷不存在！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('调查问卷不存在！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
}
}
}
