public static int Delete(IEnumerable <long> ids) { if (ids?.Count() == 0) { return(0); } string sql = "Delete AdsStatisticsLabels Where ID In ({0})\n"; int num = 0; using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(WebInfo.Conn)) { num = conn.Execute(string.Format(sql, string.Join(", ", ids))); } ParagraphDAO.DeleteBySourceNo(ids); return(num); }
public static int Delete(long id) { string sql = "Delete Pages Where NO IN (SELECT PageNo From Zones Where No IN (SELECT ZoneNo From Cards WHERE No IN (Select CardNo From ArticleIntro WHERE ID={0})))\n" + "Delete Zones Where No IN (SELECT ZoneNo From Cards WHERE No IN (Select CardNo From ArticleIntro WHERE ID={0}))\n" + "Delete Cards WHERE No IN (Select CardNo From Article WHERE ID={0}) \n" + "Delete ArticleIntro Where ID={0} \n"; int num = 0; using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(WebInfo.Conn)) { num = conn.Execute(string.Format(sql, id.ToString())); } long[] ids = new long[1] { id }; ParagraphDAO.DeleteBySourceNo(ids.ToList()); return(num); }
public static int Delete(IEnumerable <long> ids) { if (ids?.Count() == 0) { return(0); } string sql = "Delete Pages Where NO IN (SELECT PageNo From Zones Where No IN (SELECT ZoneNo From Cards WHERE No IN (Select CardNo From Article WHERE ID IN ({0}))))\n" + "Delete Zones Where No IN (SELECT ZoneNo From Cards WHERE No IN (Select CardNo From Article WHERE ID IN ({0})))\n" + "Delete Cards WHERE No IN (Select CardNo From Article WHERE ID IN ({0}))\n" + "Delete Article Where ID In ({0})\n" + "Delete ArticleToPoster Where ArticleID In ({0})\n" + "Delete ArticleToType Where ArticleID In ({0})\n"; int num = 0; using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(WebInfo.Conn)) { num = conn.Execute(string.Format(sql, string.Join(", ", ids))); } ParagraphDAO.DeleteBySourceNo(ids); return(num); }