110,539
社区成员
发帖
与我相关
我的任务
分享
public static void InsertAnswerInfo_DAL(int questionnaireID, int userID,string ks, string marks, string text, string m1, string m2, string m3, string m4)
{
string cmdText = "insert into [test] (QuestionnaireID,UserID,科室,工作态度,劳动纪律,服务意识,协调配合,工作作风,执行力) values ('" +
questionnaireID + "','" + userID + "','" + ks + "','" + m1 + "','" + marks + "','" + text + "','" + m2 + "','" + m3 + "','" + m4 + "')";
DBHelper.SqlExecuteNonQuery(cmdText, null, CommandType.Text);
}
foreach (DataListItem item in this.DataListSingle.Items)
{
DropDownList rb1 = (DropDownList)item.FindControl("DropDownList2");
var ks = rb1.SelectedText;
//var m1 = ***
BLL.AnswerBLL.InsertAnswerInfo_BLL(questionnaireID, userID,ks,m1, marks, text, m2, m3, m4);
}
if (questionnaireID!=0&&userID!=0)
{
//求总分
// int marks = 0;
string marks=test();
string m2 = "manyi2";
string m3 = "manyi3";
string m4 = "manyi4";
string m1 = "manyi5";
// Single_Marks(ref marks);
// Multiple_marks(ref marks);
//主观题题目和内容
string text= "mm";
string ks = "aa";
// string OptionA = AAA();
// string OptionB = AAA();
// string OptionC = AAA();
//在T_Answer表中插入用户所做试卷信息
BLL.AnswerBLL.InsertAnswerInfo_BLL(questionnaireID, userID,ks,m1, marks, text, m2, m3, m4);
Response.Write("<script>window.alert('问卷结果提交成功!');location.href='UserQuestionnaireContents.aspx?UserID=" + userID + "'</script>");
//Response.Write("<script>window.alert('选择题:" + marks + "主观题:" + text + "');location.href='UserQuestionnaireContents.aspx?UserID=" + userID + "'</script>");
}
else
{
Response.Write("<script>window.alert('不存在用户或问卷!');location.href='UserQuestionnaireContents.aspx?UserID=" + userID + "'</script>");
}
}
}
test方法:
private string test()
{
StringBuilder marks = new StringBuilder();
int i = 1;
foreach (DataListItem item in this.DataListSingle.Items)
{
DropDownList rb1 = (DropDownList)item.FindControl("DropDownList2");
marks.AppendFormat(rb1.Text, i++, rb1.Text);
}
return marks.ToString();
}
for(var i=0;i<6;i++)
{
var ddl1 = this.FindControl("工作态度"+i.ToString());
string m1 = dd1.SelectedValue;
//其他代码
//最后调用InsertAnswerInfo_DAL
}
只是伪代码,用于提供思路