public article_attach() { dal = new DAL.contents.article_attach(siteConfig.sysdatabaseprefix); }
/// <summary> /// ɾ��һ������ /// </summary> public bool Delete(int id) { //ȡ�����MODEL List<Model.contents.article_albums> albumsList = new DAL.contents.article_albums(databaseprefix).GetList(id); //ȡ�ø���MODEL List<Model.contents.article_attach> attachList = new DAL.contents.article_attach(databaseprefix).GetList(id); //ɾ����չ�ֶα� StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "article_attribute_value "); strSql1.Append(" where article_id=@article_id "); SqlParameter[] parameters1 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters1[0].Value = id; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //ɾ��ͼƬ��� StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "article_albums "); strSql2.Append(" where article_id=@article_id "); SqlParameter[] parameters2 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //ɾ������ StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "article_attach "); strSql3.Append(" where article_id=@article_id "); SqlParameter[] parameters3 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //ɾ������ StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "article_comment "); strSql5.Append(" where article_id=@article_id "); SqlParameter[] parameters5 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //ɾ������ StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "article "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { new DAL.contents.article_albums(databaseprefix).DeleteFile(albumsList); //ɾ��ͼƬ new DAL.contents.article_attach(databaseprefix).DeleteFile(attachList); //ɾ������ return true; } else { return false; } }