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;
}
}
