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(); }
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"); }