Beispiel #1
0
        public static int UpdateUserCategory(string tableName, int id, int pid, int uid, string name, string pinyin = null, string pinyinabbr = null, string ename = null)
        {
            if (pinyin == null)
            {
                pinyin = HZ.ToPinYin(name, true);
            }
            if (pinyinabbr == null)
            {
                pinyinabbr = PinYin.GetInitial(name);
            }
            if (ename == null)
            {
                ename = pinyin;
            }

            //check pid & uid
            if (pid != 0 && !DBH.GetBoolean(QA.DBCS_CMS, CommandType.Text, "SELECT COUNT(id) FROM " + tableName + " WHERE pid=@pid AND uid=@uid", new SqlParameter("@pid", pid), new SqlParameter("@uid", uid)))
            {
                return(-1);
            }

            return(EB <UserCategoryEntity> .Update(QA.DBCS_CMS, new UserCategoryEntity()
            {
                id = id,
                uid = uid,
                pid = pid,
                name = name,
                pinyin = pinyin,
                pinyinabbr = pinyinabbr,
                ename = ename
            }, tableName));
        }
Beispiel #2
0
 public static int Update(ContentEntity entity, string tableName)
 {
     return(EB <ContentEntity> .Update(QA.DBCS_CMS, entity, tableName));
 }
Beispiel #3
0
 public static int UpdatePost(PostEntity postEntity)
 {
     return(EB <PostEntity> .Update(QA.DBCS_MAIN, postEntity));
 }
Beispiel #4
0
 public static int UpdateThread(ThreadEntity threadEntity)
 {
     return(EB <ThreadEntity> .Update(QA.DBCS_MAIN, threadEntity));
 }
Beispiel #5
0
 public static int Update(QuestionEntity entity)
 {
     return(EB <QuestionEntity> .Update(QA.DBCS_MAIN, entity));
 }