/// <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); Hashtable sqllist = new Hashtable(); //删除文章模型数据 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_article_news "); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters[0].Value = id; sqllist.Add(strSql.ToString(), parameters); //删除下载模型数据 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_article_download "); strSql2.Append(" where id=@id "); OleDbParameter[] parameters2 = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters2[0].Value = id; sqllist.Add(strSql2.ToString(), parameters2); //删除商品模型数据 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from dt_article_goods "); strSql3.Append(" where id=@id "); OleDbParameter[] parameters3 = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters3[0].Value = id; sqllist.Add(strSql3.ToString(), parameters3); //删除内容模型数据 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from dt_article_content "); strSql4.Append(" where id=@id "); OleDbParameter[] parameters4 = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters4[0].Value = id; sqllist.Add(strSql4.ToString(), parameters4); //删除顶和踩 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from dt_article_diggs "); strSql5.Append(" where id=@id "); OleDbParameter[] parameters5 = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters5[0].Value = id; sqllist.Add(strSql5.ToString(), parameters5); //删除商品价格 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from dt_goods_group_price "); strSql6.Append(" where article_id=@article_id "); OleDbParameter[] parameters6 = { new OleDbParameter("@article_id", OleDbType.Integer,4)}; parameters6[0].Value = id; sqllist.Add(strSql6.ToString(), parameters6); //删除下载的附件 StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete from dt_download_attach "); strSql7.Append(" where article_id=@article_id "); OleDbParameter[] parameters7 = { new OleDbParameter("@article_id", OleDbType.Integer,4)}; parameters7[0].Value = id; sqllist.Add(strSql7.ToString(), parameters7); //删除图片相册 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from dt_article_albums "); strSql8.Append(" where article_id=@article_id "); OleDbParameter[] parameters8 = { new OleDbParameter("@article_id", OleDbType.Integer,4)}; parameters8[0].Value = id; sqllist.Add(strSql8.ToString(), parameters8); //删除扩展属性 StringBuilder strSql9 = new StringBuilder(); strSql9.Append("delete from dt_attribute_value "); strSql9.Append(" where article_id=@article_id "); OleDbParameter[] parameters9 = { new OleDbParameter("@article_id", OleDbType.Integer,4)}; parameters9[0].Value = id; sqllist.Add(strSql9.ToString(), parameters9); //删除评论 StringBuilder strSql10 = new StringBuilder(); strSql10.Append("delete from dt_article_comment "); strSql10.Append(" where article_id=@article_id "); OleDbParameter[] parameters10 = { new OleDbParameter("@article_id", OleDbType.Integer,4)}; parameters10[0].Value = id; sqllist.Add(strSql10.ToString(), parameters10); //删除主表信息 StringBuilder strSql11 = new StringBuilder(); strSql11.Append("delete from dt_article "); strSql11.Append(" where id=@id "); OleDbParameter[] parameters11 = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters11[0].Value = id; sqllist.Add(strSql11.ToString(), parameters11); bool result = DbHelperOleDb.ExecuteSqlTran(sqllist); if (result) { new article_albums().DeleteFile(albumsList); //删除图片 new download_attach().DeleteFile(attachList); //删除附件 } return result; }
/// <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 = DbHelperSQL2.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { new article_albums().DeleteFile(albumsList); //删除图片 //new download_attach().DeleteFile(attachList); //删除附件 return(true); } else { return(false); } }