private void ShowInfo(string QS_ID)
{
cfs.BLL.OT_QUESTION bll=new cfs.BLL.OT_QUESTION();
cfs.Model.OT_QUESTION model=bll.GetModel(QS_ID);
this.lblQS_ID.Text=model.QS_ID;
this.lblQS_TYPE.Text=model.QS_TYPE;
this.lblQS_EID.Text=model.QS_EID;
this.lblQS_CONTENT.Text=model.QS_CONTENT;
this.lblQS_CHOICE_A.Text=model.QS_CHOICE_A;
this.lblQS_CHOICE_B.Text=model.QS_CHOICE_B;
this.lblQS_CHOICE_C.Text=model.QS_CHOICE_C;
this.lblQS_CHOICE_D.Text=model.QS_CHOICE_D;
this.lblQS_CHOICE_COR.Text=model.QS_CHOICE_COR;
this.lblQS_COR_EXPLAINATION.Text=model.QS_COR_EXPLAINATION;
this.lblQS_DELFLAG.Text=model.QS_DELFLAG.ToString();
this.lblQS_HARD.Text=model.QS_HARD.ToString();
this.lblQS_CTIME.Text=model.QS_CTIME.ToString();
this.lblQS_TID.Text=model.QS_TID;
}
private void ShowInfo(string QS_ID)
{
cfs.BLL.OT_QUESTION bll = new cfs.BLL.OT_QUESTION();
cfs.Model.OT_QUESTION model = bll.GetModel(QS_ID);
this.lblQS_ID.Text = model.QS_ID;
this.txtQS_TYPE.Text = model.QS_TYPE;
this.txtQS_EID.Text = model.QS_EID;
this.txtQS_CONTENT.Text = model.QS_CONTENT;
this.txtQS_CHOICE_A.Text = model.QS_CHOICE_A;
this.txtQS_CHOICE_B.Text = model.QS_CHOICE_B;
this.txtQS_CHOICE_C.Text = model.QS_CHOICE_C;
this.txtQS_CHOICE_D.Text = model.QS_CHOICE_D;
this.txtQS_CHOICE_COR.Text = model.QS_CHOICE_COR;
this.txtQS_COR_EXPLAINATION.Text = model.QS_COR_EXPLAINATION;
this.txtQS_DELFLAG.Text = model.QS_DELFLAG.ToString();
this.txtQS_HARD.Text = model.QS_HARD.ToString();
this.txtQS_CTIME.Text = model.QS_CTIME.ToString();
this.txtQS_TID.Text = model.QS_TID;
}
private void BindData(int numPerPage, int pageNum)
{
cfs.BLL.OT_QUESTION bll = new cfs.BLL.OT_QUESTION();
StringBuilder sb = new StringBuilder();
DataSet ds = new DataSet();
//根据Session值查表
string sqlwhere = "";
TotalCount = bll.GetRecordCount(sqlwhere);
ds = bll.GetListByPage(sqlwhere, "QS_ID DESC", (pageNum - 1) * numPerPage + 1, pageNum * numPerPage);
sb.Append("<table class=\"table\" width=\"80%\" layouth=\"74\"><thead><tr align='center'><th>题目编号</th><th width=\"70%\">题干</th><th width='5%'>难易度</th><th width='10%'>创建教师</th></tr></thead>");
sb.Append("<tbody>");
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.Append("<tr target='qsid' rel='" + ds.Tables[0].Rows[i]["QS_ID"] + "' align='center'>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_ID"]);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_CONTENT"]);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_HARD"]);
sb.Append("</td>");
//显示用户分组，根据Session的值更改
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_TID"]);
sb.Append("</td>");
sb.Append("</tr>");
}
}
sb.Append("</tbody></table>");
MainTable.InnerHtml = sb.ToString();
}
private void BindData(int numPerPage, int pageNum)
{
cfs.BLL.OT_QUESTION bll = new cfs.BLL.OT_QUESTION();
StringBuilder sb = new StringBuilder();
DataSet ds = new DataSet();
//根据Session值查表
string sqlwhere = "";
TotalCount = bll.GetRecordCount(sqlwhere);
ds = bll.GetListByPage(sqlwhere, "QS_ID DESC", (pageNum - 1) * numPerPage + 1, pageNum * numPerPage);
sb.Append("<table class=\"table\" width=\"80%\" layouth=\"74\"><thead><tr align='center'><th>题目编号</th><th width=\"70%\">题干</th><th width='5%'>难易度</th><th width='10%'>创建教师</th></tr></thead>");
sb.Append("<tbody>");
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.Append("<tr target='qsid' rel='" + ds.Tables[0].Rows[i]["QS_ID"] + "' align='center'>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_ID"]);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_CONTENT"]);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_HARD"]);
sb.Append("</td>");
//显示用户分组，根据Session的值更改
sb.Append("<td>");
sb.Append(ds.Tables[0].Rows[i]["QS_TID"]);
sb.Append("</td>");
sb.Append("</tr>");
}
}
sb.Append("</tbody></table>");
MainTable.InnerHtml = sb.ToString();
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(this.txtQS_TYPE.Text.Trim().Length==0)
{
strErr+="QS_TYPE不能为空！\\n";
}
if(this.txtQS_EID.Text.Trim().Length==0)
{
strErr+="QS_EID不能为空！\\n";
}
if(this.txtQS_CONTENT.Text.Trim().Length==0)
{
strErr+="QS_CONTENT不能为空！\\n";
}
if(this.txtQS_CHOICE_A.Text.Trim().Length==0)
{
strErr+="QS_CHOICE_A不能为空！\\n";
}
if(this.txtQS_CHOICE_B.Text.Trim().Length==0)
{
strErr+="QS_CHOICE_B不能为空！\\n";
}
if(this.txtQS_CHOICE_C.Text.Trim().Length==0)
{
strErr+="QS_CHOICE_C不能为空！\\n";
}
if(this.txtQS_CHOICE_D.Text.Trim().Length==0)
{
strErr+="QS_CHOICE_D不能为空！\\n";
}
if(this.txtQS_CHOICE_COR.Text.Trim().Length==0)
{
strErr+="QS_CHOICE_COR不能为空！\\n";
}
if(this.txtQS_COR_EXPLAINATION.Text.Trim().Length==0)
{
strErr+="QS_COR_EXPLAINATION不能为空！\\n";
}
if(!PageValidate.IsNumber(txtQS_DELFLAG.Text))
{
strErr+="QS_DELFLAG格式错误！\\n";
}
if(!PageValidate.IsNumber(txtQS_HARD.Text))
{
strErr+="QS_HARD格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtQS_CTIME.Text))
{
strErr+="QS_CTIME格式错误！\\n";
}
if(this.txtQS_TID.Text.Trim().Length==0)
{
strErr+="QS_TID不能为空！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
string QS_ID=this.lblQS_ID.Text;
string QS_TYPE=this.txtQS_TYPE.Text;
string QS_EID=this.txtQS_EID.Text;
string QS_CONTENT=this.txtQS_CONTENT.Text;
string QS_CHOICE_A=this.txtQS_CHOICE_A.Text;
string QS_CHOICE_B=this.txtQS_CHOICE_B.Text;
string QS_CHOICE_C=this.txtQS_CHOICE_C.Text;
string QS_CHOICE_D=this.txtQS_CHOICE_D.Text;
string QS_CHOICE_COR=this.txtQS_CHOICE_COR.Text;
string QS_COR_EXPLAINATION=this.txtQS_COR_EXPLAINATION.Text;
int QS_DELFLAG=int.Parse(this.txtQS_DELFLAG.Text);
int QS_HARD=int.Parse(this.txtQS_HARD.Text);
DateTime QS_CTIME=DateTime.Parse(this.txtQS_CTIME.Text);
string QS_TID=this.txtQS_TID.Text;
cfs.Model.OT_QUESTION model=new cfs.Model.OT_QUESTION();
model.QS_ID=QS_ID;
model.QS_TYPE=QS_TYPE;
model.QS_EID=QS_EID;
model.QS_CONTENT=QS_CONTENT;
model.QS_CHOICE_A=QS_CHOICE_A;
model.QS_CHOICE_B=QS_CHOICE_B;
model.QS_CHOICE_C=QS_CHOICE_C;
model.QS_CHOICE_D=QS_CHOICE_D;
model.QS_CHOICE_COR=QS_CHOICE_COR;
model.QS_COR_EXPLAINATION=QS_COR_EXPLAINATION;
model.QS_DELFLAG=QS_DELFLAG;
model.QS_HARD=QS_HARD;
model.QS_CTIME=QS_CTIME;
model.QS_TID=QS_TID;
cfs.BLL.OT_QUESTION bll=new cfs.BLL.OT_QUESTION();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","list.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtQS_ID.Text.Trim().Length == 0)
{
strErr += "QS_ID不能为空！\\n";
}
if (this.txtQS_TYPE.Text.Trim().Length == 0)
{
strErr += "QS_TYPE不能为空！\\n";
}
if (this.txtQS_EID.Text.Trim().Length == 0)
{
strErr += "QS_EID不能为空！\\n";
}
if (this.txtQS_CONTENT.Text.Trim().Length == 0)
{
strErr += "QS_CONTENT不能为空！\\n";
}
if (this.txtQS_CHOICE_A.Text.Trim().Length == 0)
{
strErr += "QS_CHOICE_A不能为空！\\n";
}
if (this.txtQS_CHOICE_B.Text.Trim().Length == 0)
{
strErr += "QS_CHOICE_B不能为空！\\n";
}
if (this.txtQS_CHOICE_C.Text.Trim().Length == 0)
{
strErr += "QS_CHOICE_C不能为空！\\n";
}
if (this.txtQS_CHOICE_D.Text.Trim().Length == 0)
{
strErr += "QS_CHOICE_D不能为空！\\n";
}
if (this.txtQS_CHOICE_COR.Text.Trim().Length == 0)
{
strErr += "QS_CHOICE_COR不能为空！\\n";
}
if (this.txtQS_COR_EXPLAINATION.Text.Trim().Length == 0)
{
strErr += "QS_COR_EXPLAINATION不能为空！\\n";
}
if (!PageValidate.IsNumber(txtQS_DELFLAG.Text))
{
strErr += "QS_DELFLAG格式错误！\\n";
}
if (!PageValidate.IsNumber(txtQS_HARD.Text))
{
strErr += "QS_HARD格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtQS_CTIME.Text))
{
strErr += "QS_CTIME格式错误！\\n";
}
if (this.txtQS_TID.Text.Trim().Length == 0)
{
strErr += "QS_TID不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string QS_ID = this.txtQS_ID.Text;
string QS_TYPE = this.txtQS_TYPE.Text;
string QS_EID = this.txtQS_EID.Text;
string QS_CONTENT = this.txtQS_CONTENT.Text;
string QS_CHOICE_A = this.txtQS_CHOICE_A.Text;
string QS_CHOICE_B = this.txtQS_CHOICE_B.Text;
string QS_CHOICE_C = this.txtQS_CHOICE_C.Text;
string QS_CHOICE_D = this.txtQS_CHOICE_D.Text;
string QS_CHOICE_COR = this.txtQS_CHOICE_COR.Text;
string QS_COR_EXPLAINATION = this.txtQS_COR_EXPLAINATION.Text;
int QS_DELFLAG = int.Parse(this.txtQS_DELFLAG.Text);
int QS_HARD = int.Parse(this.txtQS_HARD.Text);
DateTime QS_CTIME = DateTime.Parse(this.txtQS_CTIME.Text);
string QS_TID = this.txtQS_TID.Text;
cfs.Model.OT_QUESTION model = new cfs.Model.OT_QUESTION();
model.QS_ID = QS_ID;
model.QS_TYPE = QS_TYPE;
model.QS_EID = QS_EID;
model.QS_CONTENT = QS_CONTENT;
model.QS_CHOICE_A = QS_CHOICE_A;
model.QS_CHOICE_B = QS_CHOICE_B;
model.QS_CHOICE_C = QS_CHOICE_C;
model.QS_CHOICE_D = QS_CHOICE_D;
model.QS_CHOICE_COR = QS_CHOICE_COR;
model.QS_COR_EXPLAINATION = QS_COR_EXPLAINATION;
model.QS_DELFLAG = QS_DELFLAG;
model.QS_HARD = QS_HARD;
model.QS_CTIME = QS_CTIME;
model.QS_TID = QS_TID;
cfs.BLL.OT_QUESTION bll = new cfs.BLL.OT_QUESTION();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
