public article_attach()
{
dal = new DAL.MySql.article_attach(sysConfig.sysdatabaseprefix);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string channel_name, int channel_id, int article_id)
{
//取得相册MODEL
List <Model.article_albums> albumsList = new DAL.MySql.article_albums(databaseprefix).GetList(channel_id, article_id);
//取得附件MODEL
List <Model.article_attach> attachList = new DAL.MySql.article_attach(databaseprefix).GetList(channel_id, article_id);
//删除图片相册
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "article_albums");
strSql2.Append(" where channel_id=@channel_id and article_id=@article_id");
SqlParameter[] parameters2 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters2[0].Value = channel_id;
parameters2[1].Value = article_id;
Hashtable sqllist = new Hashtable();
//List<CommandInfo> sqllist = new List<CommandInfo>();
//CommandInfo cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(strSql2.ToString(), parameters2);
//删除附件
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("delete from " + databaseprefix + "article_attach");
strSql3.Append(" where channel_id=@channel_id and article_id=@article_id");
SqlParameter[] parameters3 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters3[0].Value = channel_id;
parameters3[1].Value = article_id;
//cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(strSql3.ToString(), parameters3);
//删除用户组价格
StringBuilder strSql4 = new StringBuilder();
strSql4.Append("delete from " + databaseprefix + "user_group_price");
strSql4.Append(" where channel_id=@channel_id and article_id=@article_id");
SqlParameter[] parameters4 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters4[0].Value = channel_id;
parameters4[1].Value = article_id;
//cmd = new CommandInfo(strSql4.ToString(), parameters4);
sqllist.Add(strSql4.ToString(), parameters4);
//删除Tags标签关系
StringBuilder strSql7 = new StringBuilder();
strSql7.Append("delete from " + databaseprefix + "article_tags_relation");
strSql7.Append(" where channel_id=@channel_id and article_id=@article_id");
SqlParameter[] parameters7 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters7[0].Value = channel_id;
parameters7[1].Value = article_id;
//cmd = new CommandInfo(strSql7.ToString(), parameters7);
sqllist.Add(strSql7.ToString(), parameters7);
//删除评论
StringBuilder strSql8 = new StringBuilder();
strSql8.Append("delete from " + databaseprefix + "article_comment");
strSql8.Append(" where channel_id=@channel_id and article_id=@article_id ");
SqlParameter[] parameters8 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters8[0].Value = channel_id;
parameters8[1].Value = article_id;
//cmd = new CommandInfo(strSql8.ToString(), parameters8);
sqllist.Add(strSql8.ToString(), parameters8);
//删除主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + DTKeys.TABLE_CHANNEL_ARTICLE + channel_name);
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = article_id;
//cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(strSql.ToString(), parameters);
bool rowsAffected = DbHelperMySql.ExecuteSqlTran(sqllist);
if (rowsAffected)
{
new DAL.MySql.article_albums(databaseprefix).DeleteFile(albumsList); //删除图片
new DAL.MySql.article_attach(databaseprefix).DeleteFile(attachList); //删除附件
return(true);
}
else
{
return(false);
}
}
