/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
protected IDbDataParameter[] ValueParas(Models.Course.MXQuestion Model)
{
SqlParameter[] par =
{
new SqlParameter("@QuestionId", SqlDbType.VarChar, 50),
new SqlParameter("@CateId", SqlDbType.VarChar, 50),
new SqlParameter("@Style", SqlDbType.VarChar, 50),
new SqlParameter("@Score", SqlDbType.VarChar, 50),
new SqlParameter("@Question", SqlDbType.VarChar, 50),
new SqlParameter("@A", SqlDbType.VarChar, 50),
new SqlParameter("@B", SqlDbType.VarChar, 50),
new SqlParameter("@C", SqlDbType.VarChar, 50),
new SqlParameter("@D", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.VarChar, 1000),
new SqlParameter("@Checked", SqlDbType.VarChar, 50)
};
par[0].Value = Model.QuestionId;
par[1].Value = Model.CateId;
par[2].Value = Model.Style;
par[3].Value = Model.Score;
par[4].Value = Model.Question;
par[5].Value = Model.A;
par[6].Value = Model.B;
par[7].Value = Model.C;
par[8].Value = Model.D;
par[9].Value = Model.Checked;
return(par);
}
public int UpdateInfor(Models.Course.MXQuestion Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update [MXQuestion] set CateId=@CateId,Style=@Style,Score=@Score,Question=@Question,A=@A,B=@B,C=@C,D=@D,Answer=@Answer,Remarks=@Remarks,Checked=@Checked where QuestionId=@QuestionId");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
public int InsertInfor(Models.Course.MXQuestion Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into [MXQuestion] ( CateId,Style,Score,Question,A,B,C,D,Answer,Remarks,Checked ) values(@CateId,@Style,@Score,@Question,@A,@B,@C,@D,@Answer,@Remarks,@Checked)");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(XueFuShop.Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//读取信息
public SqlDataReader GetInfor(Models.Course.MXQuestion Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from [MXQuestion] where QuestionId=@QuestionId");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
public int UpdateInfor(Models.Course.MXQuestion Model)
{
return(dal.UpdateInfor(Model));
}
public int InsertInfor(Models.Course.MXQuestion Model)
{
return(dal.InsertInfor(Model));
}
