//保存 protected void Button_Click(object sender, EventArgs e) { M_Question qinfo = new M_Question(); M_QuestOption option = new M_QuestOption(); option.FillByForm(Request); if (Qid > 0) { qinfo = B_Survey.GetQuestion(Qid); } qinfo.QuestionTitle = this.TxtQTitle.Text.Trim(); qinfo.TypeID = Convert.ToInt32(Request.Form["type_rad"]); qinfo.IsNull = Convert.ToBoolean(Convert.ToInt32(NotNull.SelectedValue)); qinfo.QuestionContent = Content_T.Text; qinfo.Qoption = JsonConvert.SerializeObject(option); if (Qid > 0) { B_Survey.UpdateQuestion(qinfo); } else { qinfo.SurveyID = Sid; qinfo.OrderID = B_Survey.GetMaxOrderID(Sid) + 1; int qid = B_Survey.AddQuestion(qinfo); } function.WriteSuccessMsg("操作成功", "SurveyItemList.aspx?SID=" + Sid); }
public string GetScore(string qid, string qtypeid) { string result = ""; if (Convert.ToInt32(qtypeid) != 1) { result = ""; } else { M_Question QueMod = new M_Question(); QueMod = B_Survey.GetQuestion(Convert.ToInt32(qid)); B_Survey surBll = new B_Survey(); if (!CheckScore(QueMod.QuestionContent)) { result = ""; } else { //result = "<td colspan='3'>"; //result += surBll.GetScore(Convert.ToInt32(qid), Convert.ToInt32(qtypeid)) + "<div><iframe width='400' height='350' id='TbLocation' src='/Plugins/Chart/pie-basic.aspx?Bases=400|400||"; //result += "%u4F4D&Datas=" + Server.UrlEncode(surBll.CreateIframe(Convert.ToInt32(qid))) + "' frameborder='0' scrolling='no'></iframe><div><td>"; } } return(result); }
public bool AddQuestiony(M_Question m_Question) { string strSql = "PR_Questiony_Add"; SqlParameter[] parameter = GetParameters(m_Question); return(SqlHelper.ExecuteProc(strSql, parameter)); }
// 获取验证文本的具体类型 public string GetVType(int qid) { string[] types = { "邮箱", "手机号码", "固定电话", "身份证号", "准考证号" }; M_Question info = B_Survey.GetQuestion(qid); string tpIndex = info.QuestionContent.Split('|')[1]; return(types[DataConverter.CLng(tpIndex)]); }
protected void rptResult_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem) { return; } M_Question rowv = (M_Question)e.Item.DataItem; if (rowv.TypeID >= 3) { ((HtmlGenericControl)e.Item.FindControl("divTable")).Style["display"] = "none"; (e.Item.FindControl("ltlTitle") as Literal).Text = rowv.QuestionTitle; return; } GridView gview = e.Item.FindControl("gviewOption") as GridView; string options = rowv.QuestionContent;//内容 List <string> lstopts = new List <string>(); for (int i = 0; i < options.Split('|').Length; i++) { lstopts.Add(options.Split('|')[i].Split(':')[0]); } int sum = 0; string ratios = ""; string names = ""; gview.RowDataBound += delegate(object s, GridViewRowEventArgs ex) { int total = 0; string rate = ""; int papers = B_Survey.GetUsersCnt(rowv.SurveyID); if (ex.Row.RowType == DataControlRowType.DataRow) { total = B_Survey.GetAnsOptionCount(rowv.QuestionID, ex.Row.DataItem.ToString()); (ex.Row.FindControl("ltlTotal") as Literal).Text = total.ToString(); sum += total; if (papers == 0) { rate = "未填写"; } else { rate = ((float)total / papers).ToString("P"); } (ex.Row.FindControl("ltlRate") as Literal).Text = rate; names += CutContent(ex.Row.DataItem.ToString(), 4) + ","; ratios += total + ","; } if (ex.Row.RowType == DataControlRowType.Footer) { (ex.Row.FindControl("ltlSum") as Literal).Text = papers.ToString(); } }; gview.DataSource = lstopts; gview.DataBind(); }
public ActionResult GetQuestion(int quesIndex) { List <M_Question> ql = QuestionHelper.Questions; M_Question q = ql.FirstOrDefault(a => a.Num == quesIndex); ViewBag.QuesIndex = quesIndex; ViewBag.QuesCount = ql.Count; return(View(q)); }
protected void Order_B_Click(object sender, EventArgs e) { DataTable dt = JsonConvert.DeserializeObject <DataTable>(Order_Hid.Value); foreach (DataRow dr in dt.Rows) { M_Question surmod = B_Survey.GetQuestion(DataConverter.CLng(dr["id"])); surmod.OrderID = DataConverter.CLng(dr["oid"]); B_Survey.UpdateQuestion(surmod); } MyBind(); }
protected void MyBind() { M_Question qinfo = B_Survey.GetQuestion(Qid); if (qinfo != null) { NotNull.SelectedValue = qinfo.IsNull ? "1" : "0"; TxtQTitle.Text = qinfo.QuestionTitle; Content_T.Text = qinfo.QuestionContent; Option_Hid.Value = qinfo.Qoption; function.Script(this, "SetRadVal('type_rad'," + qinfo.TypeID + ");"); } }
private M_Question GetQuestionInfoFromReader(SqlDataReader reader) { M_Question info = new M_Question(); info.QuestionID = DataConverter.CLng(reader["QuestionID"].ToString()); info.SurveryID = DataConverter.CLng(reader["SurveryID"].ToString()); info.TypeID = DataConverter.CLng(reader["TypeID"].ToString()); info.QuestionTitle = reader["QuestionTitle"].ToString(); info.QuestionContent = reader["QuestionContent"].ToString(); info.QuestionCreateTime = DataConverter.CDate(reader["QuestionCreateTime"]); info.ManagerID = DataConverter.CLng(reader["ManagerID"]); return(info); }
public static M_Question GetQuestion(int QID) { string sql = "SELECT * FROM ZL_Question WHERE QID=" + QID; using (SqlDataReader rdr = SqlHelper.ExecuteReader(CommandType.Text, sql)) { if (rdr.Read()) { M_Question info = new M_Question(); info = info.GetQuestionFromReader(rdr); return(info); } else { return(null); } } }
private SqlParameter[] GetParameters(M_Question m_Question) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@QuestionID", SqlDbType.Int, 4), new SqlParameter("@SurveryID", SqlDbType.Int, 4), new SqlParameter("@TypeID", SqlDbType.Int, 4), new SqlParameter("@QuestionTitle", SqlDbType.NVarChar, 255), new SqlParameter("@QuestionContent", SqlDbType.Text), new SqlParameter("@QuestionCreateTime", SqlDbType.DateTime, 8), new SqlParameter("@ManagerID", SqlDbType.Int, 4) }; parameter[0].Value = m_Question.QuestionID; parameter[1].Value = m_Question.SurveryID; parameter[2].Value = m_Question.TypeID; parameter[3].Value = m_Question.QuestionTitle; parameter[4].Value = m_Question.QuestionContent; parameter[5].Value = m_Question.QuestionCreateTime; parameter[6].Value = m_Question.ManagerID; return(parameter); }
/// <summary> /// 获取问题总分和平均分 /// </summary> /// <param name="qid">问题ID</param> /// <param name="qtypeid">问题类型ID</param> /// <returns></returns> public string GetScore(int qid, int qtypeid) { double score = 0; M_Question QMod = new M_Question(); QMod = B_Survey.GetQuestion(Convert.ToInt32(qid)); string[] qConte = QMod.QuestionContent.Split('|'); string str = "select * from ZL_Answer where qid=" + qid; DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, str); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < qConte.Length; j++) { if (!string.IsNullOrEmpty(qConte[j].Split(':').ToString()) && dt.Rows[i]["AnswerContent"].ToString() == qConte[j].Split(':')[0]) { score += Convert.ToDouble(qConte[j].Split(':')[1]); } } } return("总分:" + score.ToString() + " 平均分:" + score / dt.Rows.Count); }
public string CreateIframe(int qid) { M_Question QMod = new M_Question(); QMod = B_Survey.GetQuestion(Convert.ToInt32(qid)); string[] qConte = QMod.QuestionContent.Split('|'); string str = "select * from ZL_Answer where qid=" + qid; DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, str); string num = ""; string text = ""; for (int i = 0; i < qConte.Length; i++) { DataTable dt1; dt.DefaultView.RowFilter = "AnswerContent='" + qConte[i].Split(':')[0] + "'"; dt1 = dt.DefaultView.ToTable(); num += dt1.Rows.Count.ToString() + ","; text += qConte[i].Split(':')[0] + ","; } num = num.Trim(','); text = text.Trim(','); return(num + "|" + text); }
protected void Lnk_Click(object sender, GridViewCommandEventArgs e) { int Id = DataConverter.CLng(e.CommandArgument); if (e.CommandName == "Edit") { Response.Redirect("SurveyItem.aspx?SID=" + Sid + "&QID=" + Id); } if (e.CommandName == "MovePre") { M_Question info = B_Survey.GetQuestion(Id); if (info.OrderID != B_Survey.GetMinOrderID(info.SurveyID)) { M_Question Pre = B_Survey.GetQuestion(B_Survey.PreQusID(info.SurveyID, info.OrderID)); int CurrOrder = info.OrderID; info.OrderID = Pre.OrderID; Pre.OrderID = CurrOrder; B_Survey.UpdateQuestion(info); B_Survey.UpdateQuestion(Pre); } } if (e.CommandName == "MoveNext") { M_Question info = B_Survey.GetQuestion(Id); if (info.OrderID != B_Survey.GetMaxOrderID(info.SurveyID)) { M_Question Pre = B_Survey.GetQuestion(B_Survey.NexQusID(info.SurveyID, info.OrderID)); int CurrOrder = info.OrderID; info.OrderID = Pre.OrderID; Pre.OrderID = CurrOrder; B_Survey.UpdateQuestion(info); B_Survey.UpdateQuestion(Pre); } } MyBind(); }
private static void SetQuestionsByXML() { List <M_Question> ql = new List <M_Question>(); XDocument file = XDocument.Load(GetMapPath(QuestionXMLPath)); // 获取xml文件的根节点 XElement xmlRoot = file.Root; // 获取根节点下的第一级子节点 IEnumerable <XElement> nodeFirst = xmlRoot.Elements(); M_Question q = null; M_QuesOption qo = null; foreach (var item in nodeFirst) { q = new M_Question(); q.Num = int.Parse(item.Element("num").Value); q.Content = item.Element("content").Value; q.Pic = item.Element("pic").Value; q.Point = string.IsNullOrEmpty(item.Element("point").Value) ? 0 : int.Parse(item.Element("point").Value); q.Options = new List <M_QuesOption>(); foreach (var node in item.Element("options").Elements()) { qo = new M_QuesOption(); qo.Num = node.Element("num").Value; qo.Content = node.Element("content").Value; qo.Point = int.Parse(node.Element("point").Value); qo.Point = string.IsNullOrEmpty(node.Element("point").Value) ? 0 : int.Parse(node.Element("point").Value); q.Options.Add(qo); } ql.Add(q); } Questions = ql; }
protected void rptReuslt_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem) { return; } Repeater rep = e.Item.FindControl("rptOption") as Repeater; Label lbl = e.Item.FindControl("lblTip") as Label; M_Question rowv = (M_Question)e.Item.DataItem; if (rowv.TypeID > 2) { rep.Visible = false; lbl.Visible = true; return; } lbl.Visible = false; string options = rowv.QuestionContent; if (options.Length <= 0) { options = " 暂时没有添加选项内容。。。"; } List <string> lstopts = new List <string>(); lstopts.AddRange(options.Split('|')); int qid = rowv.QuestionID; int sid = rowv.SurveyID; rep.ItemDataBound += delegate(object obj, RepeaterItemEventArgs ex) { if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem) { return; } if (ex.Item.DataItem != null) { string item = ex.Item.DataItem.ToString().Split(':')[0]; int count = surBll.SelectNum(sid, qid, item); int papers = surBll.GetQuCount(qid); string strPcent = ""; if (papers == 0) { strPcent = "未填写"; } else { strPcent = ((float)count / papers).ToString("P"); } Image img = ex.Item.FindControl("imgBar") as Image; if (count == 0) { img.Style["Width"] = "0.2%"; (ex.Item.FindControl("lblPercent") as Label).Text = "0票/" + strPcent + "<span style='color:green;'>(0分)</span>"; } else { img.Style["width"] = strPcent; (ex.Item.FindControl("lblPercent") as Label).Text = count + "票/" + strPcent + "<span style='color:green;'>(分)</span>";//" + (count * score) + " } } }; rep.DataSource = lstopts; rep.DataBind(); }
/*-------------------------问答-------------------------------*/ public static int AddQuestion(M_Question info) { return(Sql.insertID(info.TbName, info.GetParameters(), BLLCommon.GetParas(info), BLLCommon.GetFields(info))); }
public bool UpdateQuestion(M_Question m_Question) { return(dal.UpdateQuestion(m_Question)); }
public bool AddQuestiony(M_Question m_Question) { return(dal.AddQuestiony(m_Question)); }
public bool UpdateQuestion(M_Question m_Question) { SqlParameter[] cmdParams = GetParameters(m_Question);; return(SqlHelper.ExecuteProc("PR_Questiony_Update", cmdParams)); }
public static bool UpdateQuestion(M_Question info) { return(Sql.UpdateByIDs(info.TbName, info.PK, info.QuestionID.ToString(), BLLCommon.GetFieldAndPara(info), info.GetParameters())); }