public bool AddAnswer(M_Answer m_Answer)
{
string strSql = "PR_Answer_Add";
SqlParameter[] parameter = GetParameters(m_Answer);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
M_Survey info = surBll.GetSurveyBySid(Sid);
if (info.IsNull)
{
function.WriteErrMsg("该问卷不存在！可能已被删除");
}
DateTime SubmitDate = DateTime.Now;
string SIP = IPScaner.GetUserIP();
//----如该问卷是不用登录的，则以随机码作为用户名
int UserID = GetUserID(info);
if (info.IsCheck && !CheckVCode(SendVcode.Text.Trim()))
{
function.Script(this, "alert('验证码不正确');");
return;
}
IList <M_Question> list = B_Survey.GetQueList(Sid);
for (int i = 0; i < list.Count; i++)
{
M_Answer ans = new M_Answer();
string re = Request.Form["vote_" + i];
string[] OptionValue = list[i].QuestionContent.Split(new char[] { '|' });
if (list[i].TypeID == 2)
{
string[] ReArr = re.Split(new char[] { ',' });
for (int s = 0; s < ReArr.Length; s++)
{
ans.AnswerID = 0;
ans.AnswerContent = ReArr[s];
ans.QuestionID = list[i].QuestionID;
ans.SurveyID = Sid;
ans.SubmitIP = SIP;
ans.SubmitDate = SubmitDate;
ans.UserID = UserID;
B_Survey.AddAnswer(ans);
}
}
else
{
ans.AnswerID = 0;
ans.AnswerContent = re;
ans.QuestionID = list[i].QuestionID;
ans.SurveyID = Sid;
ans.SubmitIP = SIP;
ans.SubmitDate = SubmitDate;
ans.UserID = UserID;
B_Survey.AddAnswer(ans);
}
}
B_Survey.AddAnswerRecord(Sid, UserID, SIP, SubmitDate, 1);
string url = "VoteResult.aspx?SID=" + Sid;
function.WriteSuccessMsg("提交成功！感谢您的参与！", Page.ResolveClientUrl(url));
}
private M_Answer GetAnswerInfoFromReader(SqlDataReader reader)
{
M_Answer info = new M_Answer();
info.AnswerID = DataConverter.CLng(reader["AnswerID"].ToString());
info.SurveryID = DataConverter.CLng(reader["SurveryID"].ToString());
info.QuestionID = DataConverter.CLng(reader["QuestionID"].ToString());
info.OptionID = DataConverter.CLng(reader["OptionID"].ToString());
info.AnswerContent = reader["AnswerContent"].ToString();
info.UserID = DataConverter.CLng(reader["UserID"]);
return(info);
}
private SqlParameter[] GetParameters(M_Answer m_Answer)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@AnswerID", SqlDbType.BigInt),
new SqlParameter("@SurveryID", SqlDbType.Int, 4),
new SqlParameter("@QuestionID", SqlDbType.Int, 4),
new SqlParameter("@OptionID", SqlDbType.Int, 4),
new SqlParameter("@AnswerContent", SqlDbType.Text),
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameter[0].Value = m_Answer.AnswerID;
parameter[1].Value = m_Answer.SurveryID;
parameter[2].Value = m_Answer.QuestionID;
parameter[3].Value = m_Answer.OptionID;
parameter[4].Value = m_Answer.AnswerContent;
parameter[5].Value = m_Answer.UserID;
return(parameter);
}
public bool UpdateAnswer(M_Answer m_Answer)
{
return(dal.UpdateAnswer(m_Answer));
}
public bool AddAnswer(M_Answer m_Answer)
{
return(dal.AddAnswer(m_Answer));
}
public bool UpdateAnswer(M_Answer m_Answer)
{
SqlParameter[] cmdParams = GetParameters(m_Answer);;
return(SqlHelper.ExecuteProc("PR_Answer_Update", cmdParams));
}
protected void CheckInsert()
{
M_Survey info = surBll.GetSurveyBySid(Sid);
//判断是否登录
DateTime SubmitDate = DateTime.Now;
string SIP = Request.UserHostAddress;
int UserID = GetUserID(info);
//判断是否已参与了该问卷
if (B_Survey.HasAnswerBySID(Sid, UserID))
{
function.WriteErrMsg("您已提交过该问卷！");
}
if (info.IPRepeat > 0)
{
if (B_Survey.HasAnswerCountIP(Sid, SIP) >= info.IPRepeat)
{
function.WriteErrMsg("于IP：" + SIP + " 提交的问卷次数已达到限定次数：" + info.IPRepeat.ToString() + "次！");
}
}
IList <M_Question> list = new List <M_Question>();
list = B_Survey.GetQueList(Sid);
for (int i = 0; i < list.Count; i++)
{
M_Answer ans = new M_Answer();
string re = Request.Form["vote_" + i];
string[] OptionValue = list[i].QuestionContent.Split(new char[] { '|' });
if (string.IsNullOrEmpty(re))
{
re = "";
}
if (list[i].TypeID == 1)
{
if (list[i].IsNull && string.IsNullOrEmpty(Request.Form["vote_" + i]))
{
function.WriteErrMsg(list[i].QuestionTitle + ":为必填选项");
}
//ans.AnswerID = 0;
ans.AnswerContent = DataConvert.CStr(re);
ans.AnswerScore = surBll.GetScoreByContent(list[i].QuestionContent, re);
ans.QuestionID = list[i].QuestionID;
ans.SurveyID = Sid;
ans.SubmitIP = SIP;
ans.SubmitDate = SubmitDate;
ans.UserID = UserID;
B_Survey.AddAnswer(ans);
}
else
{
string[] ReArr = re.Split(new char[] { ',' });
for (int s = 0; s < ReArr.Length; s++)
{
//ans.AnswerID = 0;
ans.AnswerContent = DataConvert.CStr(ReArr[s]);
ans.QuestionID = list[i].QuestionID;
ans.SurveyID = Sid;
ans.SubmitIP = SIP;
ans.SubmitDate = SubmitDate;
ans.UserID = UserID;
B_Survey.AddAnswer(ans);
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
M_Survey info = surveyBll.GetSurveyBySid(Sid);
M_UserInfo mu = buser.GetLogin();
string SIP = EnviorHelper.GetUserIP();
if (info.NeedLogin && mu == null || mu.UserID < 1)
{
function.WriteErrMsg("该问卷需登录才能参与问卷,请先登录!");
}
if (B_Survey.HasAnswerBySID(Sid, mu.UserID))
{
function.WriteErrMsg("您已提交过该问卷！");
}
if (info.IPRepeat > 0 && B_Survey.HasAnswerCountIP(Sid, SIP) >= info.IPRepeat)
{
function.WriteErrMsg("于IP：" + SIP + " 提交的问卷次数已达到限定次数：" + info.IPRepeat.ToString() + "次!");
}
//--------------------------
IList <M_Question> list = B_Survey.GetQueList(Sid);
for (int i = 0; i < list.Count; i++)
{
M_Answer anMod = new M_Answer();
anMod.AnswerContent = Request.Form["result_" + list[i].QuestionID];
anMod.QuestionID = list[i].QuestionID;
anMod.SurveyID = Sid;
anMod.SubmitIP = SIP;
anMod.UserID = mu.UserID;
B_Survey.AddAnswer(anMod);
}
if (B_Survey.AddAnswerRecord(Sid, mu.UserID, SIP, DateTime.Now, 0))
{
function.WriteSuccessMsg("提交成功！感谢您的参与!");
}
//for (int i = 0; i < list.Count; i++)
//{
// M_Answer ans = new M_Answer();
// string re = Request.Form["txt_" + i];
// string[] OptionValue = list[i].QuestionContent.Split(new char[] { '|' });
// if (string.IsNullOrEmpty(re))
// {
// re = OptionValue[0];
// }
// if (list[i].TypeID == 1)
// {
// ans.AnswerID = 0;
// ans.AnswerContent = re;
// ans.QuestionID = list[i].QuestionID;
// ans.SurveyID = Sid;
// ans.SubmitIP = SIP;
// ans.UserID = mu.UserID;
// B_Survey.AddAnswer(ans);
// }
// else
// {
// string[] ReArr = re.Split(new char[] { ',' });
// for (int s = 0; s < ReArr.Length; s++)
// {
// ans.AnswerID = 0;
// ans.AnswerContent = ReArr[s];
// ans.QuestionID = list[i].QuestionID;
// ans.SurveyID = Sid;
// ans.SubmitIP = SIP;
// ans.UserID = mu.UserID;
// B_Survey.AddAnswer(ans);
// }
// }
//}
}
public int insert(M_Answer model)
{
return(DBCenter.Insert(model));
}
/// <summary>
/// 提交答案
/// </summary>
public static bool AddAnswer(M_Answer info)
{
return(Sql.insertID("ZL_Answer", info.GetParameters(), BLLCommon.GetParas(info), BLLCommon.GetFields(info)) > 0);
}
public bool UpdateByID(M_Answer model)
{
return(DBCenter.UpdateByID(model, model.AnswerID));
}
public int insert(M_Answer model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_Answer model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.AnswerID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
public bool UpdateAnswer(M_Answer model)
{
return(UpdateByID(model));
}
public bool AddAnswer(M_Answer model)
{
return(insert(model) > 0);
}
