|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/8346f1f3/9c1cfaad/ |
?#pragma checksum "D:\wwwroot\bujuan\wwwroot\RubricManag\NewTest.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "DD188A449975F0C9EAE090D2DB116623ADEE5250"
#line 1 "D:\wwwroot\bujuan\wwwroot\RubricManag\NewTest.aspx.cs"
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.IO;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Text;
using System.Text.RegularExpressions;
namespace EasyExam.RubricManag
{
/// <summary>
/// NewTest 的提要注明。
/// </summary>
public partial class NewTest : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlTable JudgeTable;
protected System.Web.UI.HtmlControls.HtmlTable OtherTable;
protected string strActive;
protected string strRubricID;
string myUserID="";
string myLoginID="";
PublicFunction ObjFun=new PublicFunction();
#region//************初始化信息*********
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
myUserID=Session["UserID"].ToString();
myLoginID=Session["LoginID"].ToString();
}
catch
{
}
if (myLoginID=="")
{
Response.Redirect("../Login.aspx");
}
strActive="Add";
strRubricID="0";
if (!IsPostBack)
{
if (ObjFun.GetValues("select UserType from UserInfo where LoginID='"+myLoginID+"' and UserType=1 and (RoleMenu=1 or (RoleMenu=2 and Exists(select OptionID from UserPower where UserID=UserInfo.UserID and PowerID=3 and OptionID=3)))","UserType")!="1")
{
Response.Write("<script>alert('对不起，您没有此操作权限！')</script>");
Response.End();
}
else
{
ShowSubjectInfo();//显示科目信息
DDLSubjectName.Items.FindByText("--请选择--").Selected=true;
ShowTestTypeInfo();//显示题型名称
DDLTestTypeName.Items.FindByText("--请选择--").Selected=true;
System.DateTime currentTime=new System.DateTime();
currentTime=System.DateTime.Now;
txtCreateDate.Text=Convert.ToString(currentTime.ToString("d"));
}
}
}
#endregion
#region//*********显示科目信息**********
private void ShowSubjectInfo()
{
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn=new SqlConnection(strConn);
SqlDataAdapter SqlCmd=new SqlDataAdapter("select * from SubjectInfo order by SubjectID",SqlConn);
DataSet SqlDS=new DataSet();
SqlCmd.Fill(SqlDS,"SubjectInfo");
DDLSubjectName.Items.Clear();
DDLSubjectName.DataSource=SqlDS.Tables["SubjectInfo"].DefaultView;
DDLSubjectName.DataTextField="SubjectName";
DDLSubjectName.DataValueField="SubjectID";
DDLSubjectName.DataBind();
SqlConn.Dispose();
ListItem strTmp=new ListItem("--请选择--","0");
DDLSubjectName.Items.Add(strTmp);
}
#endregion
#region//*********显示知识点信息**********
private void ShowLoreInfo(int SubjectID)
{
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn=new SqlConnection(strConn);
SqlDataAdapter SqlCmd=new SqlDataAdapter("select * from LoreInfo where SubjectID="+SubjectID+" order by LoreID",SqlConn);
DataSet SqlDS=new DataSet();
SqlCmd.Fill(SqlDS,"LoreInfo");
DDLLoreName.Items.Clear();
DDLLoreName.DataSource=SqlDS.Tables["LoreInfo"].DefaultView;
DDLLoreName.DataTextField="LoreName";
DDLLoreName.DataValueField="LoreID";
DDLLoreName.DataBind();
SqlConn.Dispose();
ListItem strTmp=new ListItem("--请选择--","0");
DDLLoreName.Items.Add(strTmp);
}
#endregion
#region//*********显示题型名称**********
private void ShowTestTypeInfo()
{
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn=new SqlConnection(strConn);
SqlDataAdapter SqlCmd=new SqlDataAdapter("select * from TestTypeInfo order by TestTypeID",SqlConn);
DataSet SqlDS=new DataSet();
SqlCmd.Fill(SqlDS,"TestTypeInfo");
DDLTestTypeName.Items.Clear();
for(int i=0;i<SqlDS.Tables["TestTypeInfo"].Rows.Count;i++)
{
DDLTestTypeName.Items.Add(new ListItem(SqlDS.Tables["TestTypeInfo"].Rows[i][1].ToString(),SqlDS.Tables["TestTypeInfo"].Rows[i][0].ToString()+","+SqlDS.Tables["TestTypeInfo"].Rows[i][2].ToString()));
}
SqlConn.Dispose();
ListItem strTmp=new ListItem("--请选择--","0");
DDLTestTypeName.Items.Add(strTmp);
}
#endregion
#region Web 窗体设计器天生的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该挪用是 ASP.NET Web 窗体设计器所必须的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的步骤 - 不要使用代码编纂器批改
/// 此步骤的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
#region//*******选择产生扭转*******
protected void DDLSubjectName_SelectedIndexChanged(object sender, System.EventArgs e)
{
ShowLoreInfo(Convert.ToInt32(DDLSubjectName.SelectedValue));
DDLLoreName.Items.FindByText("--请选择--").Selected=true;
}
#endregion
#region//*********新建试题信息***********
protected void ButInput_Click(object sender, System.EventArgs e)
{
int intSubjectID,intLoreID,intTestTypeID,intOptionNum,intTypeTime,intStandardSpeed,intCreateUserID;
string strTestDiff,strTestContent,strTestFileName,strOptionContent,strStandardAnswer,strTestParse;
double dblTestMark;
DateTime dtmCreateDate;
if (DDLSubjectName.SelectedItem.Value=="0")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择科目名称！')</script>");
return;
}
if (DDLLoreName.SelectedItem.Value=="0")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择知识点！')</script>");
return;
}
if (DDLTestTypeName.SelectedItem.Value=="0")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择题型名称！')</script>");
return;
}
if (DDLTestDiff.SelectedItem.Text.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择试题难度！')</script>");
return;
}
if (txtTestMark.Text.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入试题分数！')</script>");
return;
}
try
{
dblTestMark=Convert.ToDouble(txtTestMark.Text.Trim());
}
catch
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入正确的试题分数！')</script>");
return;
}
if (dblTestMark<=0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('试题分数应大于0！')</script>");
return;
}
strTestContent=ObjFun.getStr(ObjFun.CheckTestStr(txtTestContent0.Text.Trim()),4000);
if (strTestContent.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入试题内容！')</script>");
return;
}
string strTmp=ObjFun.GetValues("select RubricID from RubricInfo where SubjectID='"+DDLSubjectName.SelectedItem.Value+"' and LoreID='"+DDLLoreName.SelectedItem.Value+"' and TestContent='"+strTestContent+"'","RubricID");
if (strTmp.Trim()!="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('当前科目知识点中已经存在此试题，请沉新输入！')</script>");
return;
}
bool bSelected=false;
int i=0;
intOptionNum=4;
strOptionContent="";
strStandardAnswer="";
if (DDLTestTypeName.SelectedItem.Value.IndexOf("单选类")>=0)
{
intOptionNum=Convert.ToInt32(DDLOptionNum.SelectedItem.Value);
for (i=1;i<=intOptionNum;i++)
{
if (Request["txtTestContent"+i.ToString()]=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入试题选项内容！')</script>");
return;
}
}
RadioButton rbStr=null;
for (i=1;i<=intOptionNum;i++)
{
rbStr=(RadioButton)Page.FindControl("rbOneSelect"+i.ToString());
if (rbStr.Checked==true)
{
bSelected=true;
strStandardAnswer=strStandardAnswer+rbStr.Text;
}
if (strOptionContent=="")
{
strOptionContent=ObjFun.getStr(Request["txtTestContent"+i.ToString()],300);
}
else
{
strOptionContent=strOptionContent+"|"+ObjFun.getStr(Request["txtTestContent"+i.ToString()],300);
}
}
if (bSelected==false)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择试题答案！')</script>");
return;
}
}
if (DDLTestTypeName.SelectedItem.Value.IndexOf("多选类")>=0)
{
intOptionNum=Convert.ToInt32(DDLOptionNum.SelectedItem.Value);
for (i=1;i<=intOptionNum;i++)
{
if (Request["txtTestContent"+i.ToString()]=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入试题选项内容！')</script>");
return;
}
}
CheckBox chkStr=null;
for (i=1;i<=intOptionNum;i++)
{
chkStr=(CheckBox)Page.FindControl("chkMultiSelect"+i.ToString());
if (chkStr.Checked==true)
{
bSelected=true;
strStandardAnswer=strStandardAnswer+chkStr.Text;
}
if (strOptionContent=="")
{
strOptionContent=ObjFun.getStr(Request["txtTestContent"+i.ToString()],300);
}
else
{
strOptionContent=strOptionContent+"|"+ObjFun.getStr(Request["txtTestContent"+i.ToString()],300);
}
}
if (bSelected==false)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择试题答案！')</script>");
return;
}
}
if (DDLTestTypeName.SelectedItem.Value.IndexOf("判断类")>=0)
{
if ((rbJudgeRight.Checked==false)&&(rbJudgeWrong.Checked==false))
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择试题答案！')</script>");
return;
}
if (rbJudgeRight.Checked==true)
{
strStandardAnswer=rbJudgeRight.Text.Trim();
}
if (rbJudgeWrong.Checked==true)
{
strStandardAnswer=rbJudgeWrong.Text.Trim();
}
}
if ((DDLTestTypeName.SelectedItem.Value.IndexOf("填空类")>=0)||(DDLTestTypeName.SelectedItem.Value.IndexOf("问答类")>=0)||(DDLTestTypeName.SelectedItem.Value.IndexOf("作文类")>=0))
{
strStandardAnswer=txtTestContent7.Text.Trim();
if (DDLTestTypeName.SelectedItem.Value.IndexOf("填空类")>=0)
{
if (strTestContent.IndexOf("___")<0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('填空类试题内容中用3个下划线“_”暗示填空地位！')</script>");
return;
}
Regex regex1=new Regex("___");
Regex regex2=new Regex(",");
if (regex1.Matches(strTestContent,0).Count!=(regex2.Matches(strStandardAnswer,0).Count+1))
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('填空地位与答案数量不一致，各空答案间用半角逗号“,”隔开！')</script>");
return;
}
}
}
if (DDLTestTypeName.SelectedItem.Value.IndexOf("打字类")>=0)
{
try
{
intTypeTime=Convert.ToInt32(txtTypeTime.Text.Trim());
}
catch
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入正确的打字功夫！')</script>");
return;
}
try
{
intStandardSpeed=Convert.ToInt32(txtStandardSpeed.Text.Trim());
}
catch
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请输入正确的尺度快率！')</script>");
return;
}
strStandardAnswer=txtTypeTime.Text.Trim()+","+txtStandardSpeed.Text.Trim();
}
strTestFileName="";
byte[] fileBinaryData;
fileBinaryData=new byte[0];
if (DDLTestTypeName.SelectedItem.Value.IndexOf("操作类")>=0)
{
strTestFileName=TestFile.PostedFile.FileName.Substring(TestFile.PostedFile.FileName.LastIndexOf("\\")+1);
if (strTestFileName.Trim()!="")
{
Stream fileStream;
int fileLen;
fileStream=TestFile.PostedFile.InputStream;
fileLen=TestFile.PostedFile.ContentLength;
fileBinaryData=new byte[fileLen];
int n=fileStream.Read(fileBinaryData,0,fileLen);
}
else
{
fileBinaryData=new byte[0];
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择下载文件！')</script>");
return;
}
strStandardAnswer="";
}
string[] strArrTestType=DDLTestTypeName.SelectedItem.Value.Split(',');
intSubjectID=Convert.ToInt32(DDLSubjectName.SelectedItem.Value);
intLoreID=Convert.ToInt32(DDLLoreName.SelectedItem.Value);
intTestTypeID=Convert.ToInt32(strArrTestType[0]);
strTestDiff=DDLTestDiff.SelectedItem.Value;
intOptionNum=Convert.ToInt32(DDLOptionNum.SelectedItem.Value);
dblTestMark=System.Math.Round(Convert.ToDouble(txtTestMark.Text.Trim()),1);
strOptionContent=ObjFun.getStr(ObjFun.CheckTestStr(strOptionContent),1800);
strStandardAnswer=ObjFun.getStr(ObjFun.CheckTestStr(strStandardAnswer),2000);
strTestParse=ObjFun.getStr(ObjFun.CheckTestStr(txtTestContent8.Text.Trim()),500);
intCreateUserID=Convert.ToInt32(myUserID);
dtmCreateDate=Convert.ToDateTime(txtCreateDate.Text);
int NumRowsAffected=MyDatabaseMethod(intSubjectID,intLoreID,intTestTypeID,strTestDiff,intOptionNum,dblTestMark,strTestContent,fileBinaryData,strTestFileName,strOptionContent,strStandardAnswer,strTestParse,intCreateUserID,dtmCreateDate);
if (NumRowsAffected>0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('新建试题成功！');try{ window.opener.RefreshForm() }catch(e){};</script>");
}
else
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('新建试题失败！')</script>");
}
txtTestContent0.Text="";
txtTestContent1.Text="";
txtTestContent2.Text="";
txtTestContent3.Text="";
txtTestContent4.Text="";
txtTestContent5.Text="";
txtTestContent6.Text="";
txtTestContent7.Text="";
txtTestContent8.Text="";
rbOneSelect1.Checked=false;
rbOneSelect2.Checked=false;
rbOneSelect3.Checked=false;
rbOneSelect4.Checked=false;
rbOneSelect5.Checked=false;
rbOneSelect6.Checked=false;
chkMultiSelect1.Checked=false;
chkMultiSelect2.Checked=false;
chkMultiSelect3.Checked=false;
chkMultiSelect4.Checked=false;
chkMultiSelect5.Checked=false;
chkMultiSelect6.Checked=false;
rbJudgeRight.Checked=false;
rbJudgeWrong.Checked=false;
txtTypeTime.Text="5";
txtStandardSpeed.Text="30";
}
#endregion
#region//*********将数据更到数据库中*********
public int MyDatabaseMethod(int intSubjectID,int intLoreID,int intTestTypeID,string strTestDiff,int intOptionNum,double dblTestMark,string strTestContent,byte[] fileBinaryData,string strTestFileName,string strOptionContent,string strStandardAnswer,string strTestParse,int intCreateUserID,DateTime dtmCreateDate)
{
string strConn="";
string strSql="";
strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection ObjConn = new SqlConnection(strConn);
strSql="Insert into RubricInfo(SubjectID,LoreID,TestTypeID,TestDiff,OptionNum,TestMark,TestContent,TestFile,TestFileName,OptionContent,StandardAnswer,TestParse,CreateUserID,CreateDate) Values (@TmpSubjectID,@TmpLoreID,@TmpTestTypeID,@TmpTestDiff,@TmpOptionNum,@TmpTestMark,@TmpTestContent,@TmpTestFile,@TmpTestFileName,@TmpOptionContent,@TmpStandardAnswer,@TmpTestParse,@TmpCreateUserID,@TmpCreateDate)";
SqlCommand ObjCmd=new SqlCommand(strSql,ObjConn);
SqlParameter ParamSubjectID=new SqlParameter("@TmpSubjectID",SqlDbType.Int);
ParamSubjectID.Value = intSubjectID;
ObjCmd.Parameters.Add(ParamSubjectID);
SqlParameter ParamLoreID=new SqlParameter("@TmpLoreID",SqlDbType.Int);
ParamLoreID.Value = intLoreID;
ObjCmd.Parameters.Add(ParamLoreID);
SqlParameter ParamTestTypeID=new SqlParameter("@TmpTestTypeID",SqlDbType.Int);
ParamTestTypeID.Value = intTestTypeID;
ObjCmd.Parameters.Add(ParamTestTypeID);
SqlParameter ParamTestDiff=new SqlParameter("@TmpTestDiff",SqlDbType.VarChar,6);
ParamTestDiff.Value = strTestDiff;
ObjCmd.Parameters.Add(ParamTestDiff);
SqlParameter ParamOptionNum=new SqlParameter("@TmpOptionNum",SqlDbType.Int);
ParamOptionNum.Value = intOptionNum;
ObjCmd.Parameters.Add(ParamOptionNum);
SqlParameter ParamTestMark=new SqlParameter("@TmpTestMark",SqlDbType.Float);
ParamTestMark.Value = dblTestMark;
ObjCmd.Parameters.Add(ParamTestMark);
SqlParameter ParamTestContent=new SqlParameter("@TmpTestContent",SqlDbType.VarChar,4000);
ParamTestContent.Value = strTestContent;
ObjCmd.Parameters.Add(ParamTestContent);
if (fileBinaryData.Length>0)
{
SqlParameter ParamTestFile=new SqlParameter("@TmpTestFile",SqlDbType.Image);
ParamTestFile.Value = fileBinaryData;
ObjCmd.Parameters.Add(ParamTestFile);
SqlParameter ParamTestFileName=new SqlParameter("@TmpTestFileName",SqlDbType.VarChar,255);
ParamTestFileName.Value = strTestFileName.Trim();
ObjCmd.Parameters.Add(ParamTestFileName);
}
else
{
SqlParameter ParamTestFile=new SqlParameter("@TmpTestFile",SqlDbType.Image);
ParamTestFile.Value = System.DBNull.Value;
ObjCmd.Parameters.Add(ParamTestFile);
SqlParameter ParamTestFileName=new SqlParameter("@TmpTestFileName",SqlDbType.VarChar,255);
ParamTestFileName.Value = strTestFileName.Trim();
ObjCmd.Parameters.Add(ParamTestFileName);
}
SqlParameter ParamOptionContent=new SqlParameter("@TmpOptionContent",SqlDbType.VarChar,1800);
ParamOptionContent.Value = strOptionContent;
ObjCmd.Parameters.Add(ParamOptionContent);
SqlParameter ParamStandardAnswer=new SqlParameter("@TmpStandardAnswer",SqlDbType.VarChar,2000);
ParamStandardAnswer.Value = strStandardAnswer;
ObjCmd.Parameters.Add(ParamStandardAnswer);
SqlParameter ParamTestParse=new SqlParameter("@TmpTestParse",SqlDbType.VarChar,500);
ParamTestParse.Value = strTestParse;
ObjCmd.Parameters.Add(ParamTestParse);
SqlParameter ParamCreateUserID=new SqlParameter("@TmpCreateUserID",SqlDbType.Int);
ParamCreateUserID.Value = intCreateUserID;
ObjCmd.Parameters.Add(ParamCreateUserID);
SqlParameter ParamCreateDate=new SqlParameter("@TmpCreateDate",SqlDbType.DateTime);
ParamCreateDate.Value = dtmCreateDate;
ObjCmd.Parameters.Add(ParamCreateDate);
ObjConn.Open();
int numRowsAffected=ObjCmd.ExecuteNonQuery();
ObjConn.Close();
ObjConn.Dispose();
return numRowsAffected;
}
#endregion
}
}
#line default
#line hidden