/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool TiMuSuoYinEdit(Entity.TiMuSuoYin info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@gid", SqlDbType.VarChar, 50, info.gid), SqlDB.MakeInParam("@zh_knowledge", SqlDbType.NVarChar, 128, info.zh_knowledge), SqlDB.MakeInParam("@difficulty", SqlDbType.Int, 4, info.difficulty), SqlDB.MakeInParam("@score", SqlDbType.Int, 4, info.score), SqlDB.MakeInParam("@objective_flag", SqlDbType.Int, 4, info.objective_flag), SqlDB.MakeInParam("@option_count", SqlDbType.Int, 4, info.option_count), SqlDB.MakeInParam("@group_count", SqlDbType.Int, 4, info.group_count), SqlDB.MakeInParam("@question_type", SqlDbType.NVarChar, 50, info.question_type), SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@grade_id", SqlDbType.Int, 4, info.grade_id), SqlDB.MakeInParam("@section_id", SqlDbType.Int, 4, info.section_id), SqlDB.MakeInParam("@edu_question_type_Id", SqlDbType.Int, 4, info.edu_question_type_Id), SqlDB.MakeInParam("@zhishidian_id", SqlDbType.Int, 4, info.zhishidian_id), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "TiMuSuoYinEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int TiMuSuoYinAdd(Entity.TiMuSuoYin info) { SqlParameter[] prams = { SqlDB.MakeInParam("@gid", SqlDbType.VarChar, 50, info.gid), SqlDB.MakeInParam("@zh_knowledge", SqlDbType.NVarChar, 128, info.zh_knowledge), SqlDB.MakeInParam("@difficulty", SqlDbType.Int, 4, info.difficulty), SqlDB.MakeInParam("@score", SqlDbType.Int, 4, info.score), SqlDB.MakeInParam("@objective_flag", SqlDbType.Int, 4, info.objective_flag), SqlDB.MakeInParam("@option_count", SqlDbType.Int, 4, info.option_count), SqlDB.MakeInParam("@group_count", SqlDbType.Int, 4, info.group_count), SqlDB.MakeInParam("@question_type", SqlDbType.NVarChar, 50, info.question_type), SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@grade_id", SqlDbType.Int, 4, info.grade_id), SqlDB.MakeInParam("@section_id", SqlDbType.Int, 4, info.section_id), SqlDB.MakeInParam("@edu_question_type_Id", SqlDbType.Int, 4, info.edu_question_type_Id), SqlDB.MakeInParam("@zhishidian_id", SqlDbType.Int, 4, info.zhishidian_id), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "TiMuSuoYinAdd", prams).ToString(), -1)); }
/// <summary> /// 获取某一个实体 /// </summary> /// <param name="Id">标识</param> /// <returns>返回Entity</returns> public static Entity.TiMuSuoYin TiMuSuoYinEntityGet(int Id) { Entity.TiMuSuoYin info = new Entity.TiMuSuoYin(); DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [TiMuSuoYin] WHERE Id = " + Id + ";").Tables[0]; if (dt.Rows.Count > 0) { info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0); info.gid = dt.Rows[0]["gid"].ToString(); info.zh_knowledge = dt.Rows[0]["zh_knowledge"].ToString(); info.difficulty = Basic.Utils.StrToInt(dt.Rows[0]["difficulty"].ToString(), 0); info.score = Basic.Utils.StrToInt(dt.Rows[0]["score"].ToString(), 0); info.objective_flag = Basic.Utils.StrToInt(dt.Rows[0]["objective_flag"].ToString(), 0); info.option_count = Basic.Utils.StrToInt(dt.Rows[0]["option_count"].ToString(), 0); info.group_count = Basic.Utils.StrToInt(dt.Rows[0]["group_count"].ToString(), 0); info.question_type = dt.Rows[0]["question_type"].ToString(); info.subject_id = Basic.Utils.StrToInt(dt.Rows[0]["subject_id"].ToString(), 0); info.grade_id = Basic.Utils.StrToInt(dt.Rows[0]["grade_id"].ToString(), 0); info.section_id = Basic.Utils.StrToInt(dt.Rows[0]["section_id"].ToString(), 0); info.edu_question_type_Id = Basic.Utils.StrToInt(dt.Rows[0]["edu_question_type_Id"].ToString(), 0); info.zhishidian_id = Basic.Utils.StrToInt(dt.Rows[0]["zhishidian_id"].ToString(), 0); } return(info); }