예제 #1
0
        /// <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);
        }
예제 #2
0
 /// <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));
 }
예제 #3
0
        /// <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);
        }