/// <summary> /// 得到 tb_school_questioncls 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>tb_school_questioncls 数据实体</returns> public tb_School_QuestionClsEntity Populate_tb_School_QuestionClsEntity_FromDr(IDataReader dr) { tb_School_QuestionClsEntity Obj = new tb_School_QuestionClsEntity(); Obj.RelationId = ((dr["RelationId"]) == DBNull.Value)?0:Convert.ToInt32(dr["RelationId"]); Obj.SchoolId = ((dr["SchoolId"]) == DBNull.Value)?0:Convert.ToInt32(dr["SchoolId"]); Obj.QuestionClsId = ((dr["QuestionClsId"]) == DBNull.Value)?0:Convert.ToInt32(dr["QuestionClsId"]); Obj.Path = dr["Path"].ToString(); Obj.Score = ((dr["Score"]) == DBNull.Value)?0:Convert.ToInt32(dr["Score"]); Obj.IsMust = ((dr["IsMust"]) == DBNull.Value)?0:Convert.ToInt32(dr["IsMust"]); return(Obj); }
/// <summary> /// 得到 tb_school_questioncls 数据实体 /// </summary> /// <param name="row">row</param> /// <returns>tb_school_questioncls 数据实体</returns> public tb_School_QuestionClsEntity Populate_tb_School_QuestionClsEntity_FromDr(DataRow row) { tb_School_QuestionClsEntity Obj = new tb_School_QuestionClsEntity(); if (row != null) { Obj.RelationId = ((row["RelationId"]) == DBNull.Value)?0:Convert.ToInt32(row["RelationId"]); Obj.SchoolId = ((row["SchoolId"]) == DBNull.Value)?0:Convert.ToInt32(row["SchoolId"]); Obj.QuestionClsId = ((row["QuestionClsId"]) == DBNull.Value)?0:Convert.ToInt32(row["QuestionClsId"]); Obj.Path = row["Path"].ToString(); Obj.Score = ((row["Score"]) == DBNull.Value)?0:Convert.ToInt32(row["Score"]); Obj.IsMust = ((row["IsMust"]) == DBNull.Value)?0:Convert.ToInt32(row["IsMust"]); } else { return(null); } return(Obj); }
/// <summary> /// 根据ID,返回一个tb_School_QuestionCls对象 /// </summary> /// <param name="relationId">relationId</param> /// <returns>tb_School_QuestionCls对象</returns> public tb_School_QuestionClsEntity Get_tb_School_QuestionClsEntity(int relationId) { tb_School_QuestionClsEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@RelationId", SqlDbType.Int) }; _param[0].Value = relationId; string sqlStr = "select * from tb_School_QuestionCls with(nolock) where RelationId=@RelationId"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_School_QuestionClsEntity_FromDr(dr); } } return(_obj); }
/// <summary> /// 向数据库中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_tb_School_QuestionClsModel">tb_School_QuestionCls实体</param> /// <returns>新插入记录的编号</returns> public int Insert(SqlTransaction sp, tb_School_QuestionClsEntity _tb_School_QuestionClsModel) { string sqlStr = "insert into tb_School_QuestionCls([RelationId],[SchoolId],[QuestionClsId],[Path],[IsMust]) values(@RelationId,@SchoolId,@QuestionClsId,@Path,@IsMust) select @@identity"; int res; SqlParameter[] _param = { new SqlParameter("@RelationId", SqlDbType.Int), new SqlParameter("@SchoolId", SqlDbType.Int), new SqlParameter("@QuestionClsId", SqlDbType.Int), new SqlParameter("@Path", SqlDbType.VarChar), new SqlParameter("@IsMust", SqlDbType.Int) }; _param[0].Value = _tb_School_QuestionClsModel.RelationId; _param[1].Value = _tb_School_QuestionClsModel.SchoolId; _param[2].Value = _tb_School_QuestionClsModel.QuestionClsId; _param[3].Value = _tb_School_QuestionClsModel.Path; _param[4].Value = _tb_School_QuestionClsModel.IsMust; res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param)); return(res); }
/// <summary> /// 向数据表tb_School_QuestionCls更新一条记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_tb_School_QuestionClsModel">_tb_School_QuestionClsModel</param> /// <returns>影响的行数</returns> public int Update(SqlTransaction sp, tb_School_QuestionClsEntity _tb_School_QuestionClsModel) { string sqlStr = "update tb_School_QuestionCls set [SchoolId]=@SchoolId,[QuestionClsId]=@QuestionClsId,[Path]=@Path,[Score]=@Score,[IsMust]=@IsMust where RelationId=@RelationId"; SqlParameter[] _param = { new SqlParameter("@RelationId", SqlDbType.Int), new SqlParameter("@SchoolId", SqlDbType.Int), new SqlParameter("@QuestionClsId", SqlDbType.Int), new SqlParameter("@Path", SqlDbType.VarChar), new SqlParameter("@Score", SqlDbType.Int), new SqlParameter("@IsMust", SqlDbType.Int) }; _param[0].Value = _tb_School_QuestionClsModel.RelationId; _param[1].Value = _tb_School_QuestionClsModel.SchoolId; _param[2].Value = _tb_School_QuestionClsModel.QuestionClsId; _param[3].Value = _tb_School_QuestionClsModel.Path; _param[4].Value = _tb_School_QuestionClsModel.Score; _param[5].Value = _tb_School_QuestionClsModel.IsMust; return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param)); }
public tb_School_QuestionClsEntity GetSchoolQuestionClsEntityByQuestionIdSchoolId(int questionId, int schoolid) { tb_School_QuestionClsEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@QuestionId", SqlDbType.Int), new SqlParameter("@SchoolId", SqlDbType.Int) }; _param[0].Value = questionId; _param[1].Value = schoolid; string sqlStr = "select * from tb_School_QuestionCls with(nolock) where [QuestionClsId]=@QuestionId and schoolid = @SchoolId"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_School_QuestionClsEntity_FromDr(dr); } } return(_obj); }
public void Update(tb_School_QuestionClsEntity tb_School_QuestionClsEntity) { tb_School_QuestionClsdal.Update(tb_School_QuestionClsEntity); }
public int Insert(tb_School_QuestionClsEntity tb_School_QuestionClsEntity) { return(tb_School_QuestionClsdal.Insert(tb_School_QuestionClsEntity)); }