/// <summary>
/// ɾ��һ�����ݣ����ӱ������������
/// </summary>
public bool Delete(int id)
{
//ȡ�����MODEL
List<Model.article_albums> albumsList = new article_albums().GetList(id);
//ȡ�ø���MODEL
List<Model.download_attach> attachList = new download_attach().GetList(id);
List<CommandInfo> sqllist = new List<CommandInfo>();
//ɾ������ģ������
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dt_article_news ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//ɾ������ģ������
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from dt_article_download ");
strSql2.Append(" where id=@id ");
SqlParameter[] parameters2 = {
new SqlParameter("@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 dt_article_goods ");
strSql3.Append(" where id=@id ");
SqlParameter[] parameters3 = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters3[0].Value = id;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
//ɾ������ģ������
StringBuilder strSql4 = new StringBuilder();
strSql4.Append("delete from dt_article_content ");
strSql4.Append(" where id=@id ");
SqlParameter[] parameters4 = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters4[0].Value = id;
cmd = new CommandInfo(strSql4.ToString(), parameters4);
sqllist.Add(cmd);
//ɾ�����Ͳ�
StringBuilder strSql5 = new StringBuilder();
strSql5.Append("delete from dt_article_diggs ");
strSql5.Append(" where id=@id ");
SqlParameter[] parameters5 = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters5[0].Value = id;
cmd = new CommandInfo(strSql5.ToString(), parameters5);
sqllist.Add(cmd);
//ɾ����Ʒ�۸�
StringBuilder strSql6 = new StringBuilder();
strSql6.Append("delete from dt_goods_group_price ");
strSql6.Append(" where article_id=@article_id ");
SqlParameter[] parameters6 = {
new SqlParameter("@article_id", SqlDbType.Int,4)};
parameters6[0].Value = id;
cmd = new CommandInfo(strSql6.ToString(), parameters6);
sqllist.Add(cmd);
//ɾ�����صĸ���
StringBuilder strSql7 = new StringBuilder();
strSql7.Append("delete from dt_download_attach ");
strSql7.Append(" where article_id=@article_id ");
SqlParameter[] parameters7 = {
new SqlParameter("@article_id", SqlDbType.Int,4)};
parameters7[0].Value = id;
cmd = new CommandInfo(strSql7.ToString(), parameters7);
sqllist.Add(cmd);
//ɾ��ͼƬ���
StringBuilder strSql8 = new StringBuilder();
strSql8.Append("delete from dt_article_albums ");
strSql8.Append(" where article_id=@article_id ");
SqlParameter[] parameters8 = {
new SqlParameter("@article_id", SqlDbType.Int,4)};
parameters8[0].Value = id;
cmd = new CommandInfo(strSql8.ToString(), parameters8);
sqllist.Add(cmd);
//ɾ����չ����
StringBuilder strSql9 = new StringBuilder();
strSql9.Append("delete from dt_attribute_value ");
strSql9.Append(" where article_id=@article_id ");
SqlParameter[] parameters9 = {
new SqlParameter("@article_id", SqlDbType.Int,4)};
parameters9[0].Value = id;
cmd = new CommandInfo(strSql9.ToString(), parameters9);
sqllist.Add(cmd);
//ɾ������
StringBuilder strSql10 = new StringBuilder();
strSql10.Append("delete from dt_article_comment ");
strSql10.Append(" where article_id=@article_id ");
SqlParameter[] parameters10 = {
new SqlParameter("@article_id", SqlDbType.Int,4)};
parameters10[0].Value = id;
cmd = new CommandInfo(strSql10.ToString(), parameters10);
sqllist.Add(cmd);
//ɾ��������Ϣ
StringBuilder strSql11 = new StringBuilder();
strSql11.Append("delete from dt_article ");
strSql11.Append(" where id=@id ");
SqlParameter[] parameters11 = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters11[0].Value = id;
cmd = new CommandInfo(strSql11.ToString(), parameters11);
sqllist.Add(cmd);
int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist);
if (rowsAffected > 0)
{
new article_albums().DeleteFile(albumsList); //ɾ��ͼƬ
new download_attach().DeleteFile(attachList); //ɾ������
return true;
}
else
{
return false;
}
}
/// <summary>
/// 删除一条数据，及子表所有相关数据
/// </summary>
public bool Delete(int id)
{
//取得相册MODEL
List <Model.article_albums> albumsList = new article_albums().GetList(id);
//取得附件MODEL
List <Model.download_attach> attachList = new download_attach().GetList(id);
List <CommandInfo> sqllist = new List <CommandInfo>();
//删除文章模型数据
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dt_article_news ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//删除下载模型数据
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from dt_article_download ");
strSql2.Append(" where id=@id ");
SqlParameter[] parameters2 =
{
new SqlParameter("@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 dt_article_goods ");
strSql3.Append(" where id=@id ");
SqlParameter[] parameters3 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters3[0].Value = id;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
//删除内容模型数据
StringBuilder strSql4 = new StringBuilder();
strSql4.Append("delete from dt_article_content ");
strSql4.Append(" where id=@id ");
SqlParameter[] parameters4 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters4[0].Value = id;
cmd = new CommandInfo(strSql4.ToString(), parameters4);
sqllist.Add(cmd);
//删除顶和踩
StringBuilder strSql5 = new StringBuilder();
strSql5.Append("delete from dt_article_diggs ");
strSql5.Append(" where id=@id ");
SqlParameter[] parameters5 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters5[0].Value = id;
cmd = new CommandInfo(strSql5.ToString(), parameters5);
sqllist.Add(cmd);
//删除商品价格
StringBuilder strSql6 = new StringBuilder();
strSql6.Append("delete from dt_goods_group_price ");
strSql6.Append(" where article_id=@article_id ");
SqlParameter[] parameters6 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters6[0].Value = id;
cmd = new CommandInfo(strSql6.ToString(), parameters6);
sqllist.Add(cmd);
//删除下载的附件
StringBuilder strSql7 = new StringBuilder();
strSql7.Append("delete from dt_download_attach ");
strSql7.Append(" where article_id=@article_id ");
SqlParameter[] parameters7 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters7[0].Value = id;
cmd = new CommandInfo(strSql7.ToString(), parameters7);
sqllist.Add(cmd);
//删除图片相册
StringBuilder strSql8 = new StringBuilder();
strSql8.Append("delete from dt_article_albums ");
strSql8.Append(" where article_id=@article_id ");
SqlParameter[] parameters8 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters8[0].Value = id;
cmd = new CommandInfo(strSql8.ToString(), parameters8);
sqllist.Add(cmd);
//删除扩展属性
StringBuilder strSql9 = new StringBuilder();
strSql9.Append("delete from dt_attribute_value ");
strSql9.Append(" where article_id=@article_id ");
SqlParameter[] parameters9 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters9[0].Value = id;
cmd = new CommandInfo(strSql9.ToString(), parameters9);
sqllist.Add(cmd);
//删除评论
StringBuilder strSql10 = new StringBuilder();
strSql10.Append("delete from dt_article_comment ");
strSql10.Append(" where article_id=@article_id ");
SqlParameter[] parameters10 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4)
};
parameters10[0].Value = id;
cmd = new CommandInfo(strSql10.ToString(), parameters10);
sqllist.Add(cmd);
//删除主表信息
StringBuilder strSql11 = new StringBuilder();
strSql11.Append("delete from dt_article ");
strSql11.Append(" where id=@id ");
SqlParameter[] parameters11 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters11[0].Value = id;
cmd = new CommandInfo(strSql11.ToString(), parameters11);
sqllist.Add(cmd);
int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist);
if (rowsAffected > 0)
{
new article_albums().DeleteFile(albumsList); //删除图片
new download_attach().DeleteFile(attachList); //删除附件
return(true);
}
else
{
return(false);
}
}