예제 #1
0
        public void DeleteRes(int resId)
        {
            DataBaseAccess db  = this._dao.New();
            IWxRes         res = this.GetResById(resId);

            object[,] data = new object[, ]
            {
                { "@resId", resId }
            };

            if (res.Type() == 1)
            {
                db.ExecuteNonQuery(
                    new SqlQuery("DELETE FROM wx_res WHERE id=@resId", data),
                    new SqlQuery("DELETE FROM wx_text Where resid=@resId", data)
                    );
            }
            else
            {
                db.ExecuteNonQuery(
                    new SqlQuery("DELETE FROM wx_res WHERE id=@resId", data),
                    new SqlQuery("DELETE FROM wx_art_item Where resid=@resId", data)
                    );
            }
        }