/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_QUESTION model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OT_QUESTION("); strSql.Append("QS_ID,QS_TYPE,QS_EID,QS_CONTENT,QS_CHOICE_A,QS_CHOICE_B,QS_CHOICE_C,QS_CHOICE_D,QS_CHOICE_COR,QS_COR_EXPLAINATION,QS_DELFLAG,QS_HARD,QS_CTIME,QS_TID)"); strSql.Append(" values ("); strSql.Append("@QS_ID,@QS_TYPE,@QS_EID,@QS_CONTENT,@QS_CHOICE_A,@QS_CHOICE_B,@QS_CHOICE_C,@QS_CHOICE_D,@QS_CHOICE_COR,@QS_COR_EXPLAINATION,@QS_DELFLAG,@QS_HARD,@QS_CTIME,@QS_TID)"); SqlParameter[] parameters = { new SqlParameter("@QS_ID", SqlDbType.VarChar, 64), new SqlParameter("@QS_TYPE", SqlDbType.VarChar, 50), new SqlParameter("@QS_EID", SqlDbType.VarChar, 64), new SqlParameter("@QS_CONTENT", SqlDbType.Text), new SqlParameter("@QS_CHOICE_A", SqlDbType.Text), new SqlParameter("@QS_CHOICE_B", SqlDbType.Text), new SqlParameter("@QS_CHOICE_C", SqlDbType.Text), new SqlParameter("@QS_CHOICE_D", SqlDbType.Text), new SqlParameter("@QS_CHOICE_COR", SqlDbType.Int, 4), new SqlParameter("@QS_COR_EXPLAINATION", SqlDbType.NVarChar, 1000), new SqlParameter("@QS_DELFLAG", SqlDbType.Int, 4), new SqlParameter("@QS_HARD", SqlDbType.Int, 4), new SqlParameter("@QS_CTIME", SqlDbType.DateTime), new SqlParameter("@QS_TID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.QS_ID; parameters[1].Value = model.QS_TYPE; parameters[2].Value = model.QS_EID; parameters[3].Value = model.QS_CONTENT; parameters[4].Value = model.QS_CHOICE_A; parameters[5].Value = model.QS_CHOICE_B; parameters[6].Value = model.QS_CHOICE_C; parameters[7].Value = model.QS_CHOICE_D; parameters[8].Value = model.QS_CHOICE_COR; parameters[9].Value = model.QS_COR_EXPLAINATION; parameters[10].Value = model.QS_DELFLAG; parameters[11].Value = model.QS_HARD; parameters[12].Value = model.QS_CTIME; parameters[13].Value = model.QS_TID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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; }
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"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_QUESTION model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OT_QUESTION set "); strSql.Append("QS_TYPE=@QS_TYPE,"); strSql.Append("QS_EID=@QS_EID,"); strSql.Append("QS_CONTENT=@QS_CONTENT,"); strSql.Append("QS_CHOICE_A=@QS_CHOICE_A,"); strSql.Append("QS_CHOICE_B=@QS_CHOICE_B,"); strSql.Append("QS_CHOICE_C=@QS_CHOICE_C,"); strSql.Append("QS_CHOICE_D=@QS_CHOICE_D,"); strSql.Append("QS_CHOICE_COR=@QS_CHOICE_COR,"); strSql.Append("QS_COR_EXPLAINATION=@QS_COR_EXPLAINATION,"); strSql.Append("QS_DELFLAG=@QS_DELFLAG,"); strSql.Append("QS_HARD=@QS_HARD,"); strSql.Append("QS_CTIME=@QS_CTIME,"); strSql.Append("QS_TID=@QS_TID"); strSql.Append(" where QS_ID=@QS_ID "); SqlParameter[] parameters = { new SqlParameter("@QS_TYPE", SqlDbType.VarChar, 50), new SqlParameter("@QS_EID", SqlDbType.VarChar, 64), new SqlParameter("@QS_CONTENT", SqlDbType.Text), new SqlParameter("@QS_CHOICE_A", SqlDbType.Text), new SqlParameter("@QS_CHOICE_B", SqlDbType.Text), new SqlParameter("@QS_CHOICE_C", SqlDbType.Text), new SqlParameter("@QS_CHOICE_D", SqlDbType.Text), new SqlParameter("@QS_CHOICE_COR", SqlDbType.Int, 4), new SqlParameter("@QS_COR_EXPLAINATION", SqlDbType.NVarChar, 1000), new SqlParameter("@QS_DELFLAG", SqlDbType.Int, 4), new SqlParameter("@QS_HARD", SqlDbType.Int, 4), new SqlParameter("@QS_CTIME", SqlDbType.DateTime), new SqlParameter("@QS_TID", SqlDbType.VarChar, 50), new SqlParameter("@QS_ID", SqlDbType.VarChar, 64) }; parameters[0].Value = model.QS_TYPE; parameters[1].Value = model.QS_EID; parameters[2].Value = model.QS_CONTENT; parameters[3].Value = model.QS_CHOICE_A; parameters[4].Value = model.QS_CHOICE_B; parameters[5].Value = model.QS_CHOICE_C; parameters[6].Value = model.QS_CHOICE_D; parameters[7].Value = model.QS_CHOICE_COR; parameters[8].Value = model.QS_COR_EXPLAINATION; parameters[9].Value = model.QS_DELFLAG; parameters[10].Value = model.QS_HARD; parameters[11].Value = model.QS_CTIME; parameters[12].Value = model.QS_TID; parameters[13].Value = model.QS_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public cfs.Model.OT_QUESTION GetModel(string QS_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QS_ID,QS_TYPE,QS_EID,QS_CONTENT,QS_CHOICE_A,QS_CHOICE_B,QS_CHOICE_C,QS_CHOICE_D,QS_CHOICE_COR,QS_COR_EXPLAINATION,QS_DELFLAG,QS_HARD,QS_CTIME,QS_TID from OT_QUESTION "); strSql.Append(" where QS_ID=@QS_ID "); SqlParameter[] parameters = { new SqlParameter("@QS_ID", SqlDbType.VarChar, 64) }; parameters[0].Value = QS_ID; cfs.Model.OT_QUESTION model = new cfs.Model.OT_QUESTION(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["QS_ID"] != null && ds.Tables[0].Rows[0]["QS_ID"].ToString() != "") { model.QS_ID = ds.Tables[0].Rows[0]["QS_ID"].ToString(); } if (ds.Tables[0].Rows[0]["QS_TYPE"] != null && ds.Tables[0].Rows[0]["QS_TYPE"].ToString() != "") { model.QS_TYPE = ds.Tables[0].Rows[0]["QS_TYPE"].ToString(); } if (ds.Tables[0].Rows[0]["QS_EID"] != null && ds.Tables[0].Rows[0]["QS_EID"].ToString() != "") { model.QS_EID = ds.Tables[0].Rows[0]["QS_EID"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CONTENT"] != null && ds.Tables[0].Rows[0]["QS_CONTENT"].ToString() != "") { model.QS_CONTENT = ds.Tables[0].Rows[0]["QS_CONTENT"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CHOICE_A"] != null && ds.Tables[0].Rows[0]["QS_CHOICE_A"].ToString() != "") { model.QS_CHOICE_A = ds.Tables[0].Rows[0]["QS_CHOICE_A"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CHOICE_B"] != null && ds.Tables[0].Rows[0]["QS_CHOICE_B"].ToString() != "") { model.QS_CHOICE_B = ds.Tables[0].Rows[0]["QS_CHOICE_B"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CHOICE_C"] != null && ds.Tables[0].Rows[0]["QS_CHOICE_C"].ToString() != "") { model.QS_CHOICE_C = ds.Tables[0].Rows[0]["QS_CHOICE_C"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CHOICE_D"] != null && ds.Tables[0].Rows[0]["QS_CHOICE_D"].ToString() != "") { model.QS_CHOICE_D = ds.Tables[0].Rows[0]["QS_CHOICE_D"].ToString(); } if (ds.Tables[0].Rows[0]["QS_CHOICE_COR"] != null && ds.Tables[0].Rows[0]["QS_CHOICE_COR"].ToString() != "") { model.QS_CHOICE_COR = int.Parse(ds.Tables[0].Rows[0]["QS_CHOICE_COR"].ToString()); } if (ds.Tables[0].Rows[0]["QS_COR_EXPLAINATION"] != null && ds.Tables[0].Rows[0]["QS_COR_EXPLAINATION"].ToString() != "") { model.QS_COR_EXPLAINATION = ds.Tables[0].Rows[0]["QS_COR_EXPLAINATION"].ToString(); } if (ds.Tables[0].Rows[0]["QS_DELFLAG"] != null && ds.Tables[0].Rows[0]["QS_DELFLAG"].ToString() != "") { model.QS_DELFLAG = int.Parse(ds.Tables[0].Rows[0]["QS_DELFLAG"].ToString()); } if (ds.Tables[0].Rows[0]["QS_HARD"] != null && ds.Tables[0].Rows[0]["QS_HARD"].ToString() != "") { model.QS_HARD = int.Parse(ds.Tables[0].Rows[0]["QS_HARD"].ToString()); } if (ds.Tables[0].Rows[0]["QS_CTIME"] != null && ds.Tables[0].Rows[0]["QS_CTIME"].ToString() != "") { model.QS_CTIME = DateTime.Parse(ds.Tables[0].Rows[0]["QS_CTIME"].ToString()); } if (ds.Tables[0].Rows[0]["QS_TID"] != null && ds.Tables[0].Rows[0]["QS_TID"].ToString() != "") { model.QS_TID = ds.Tables[0].Rows[0]["QS_TID"].ToString(); } return(model); } else { return(null); } }
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"); }