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