public static void DeleteMarker(int FType, string idList) { string delSql = @"update a set a.FIsDelete=1 from Map_Marker a,Map_MarkerProperty b where a.ID=b.FMarkerID and a.FIsDelete=0 and FType=" + FType + " and b.FMID in (" + idList + ")"; DBUtil.Execute(delSql); }
public static void DeleteAreaOverlay(string FMapOverlayID, string FMapTempID) { string sql = string.Format("delete Map_Area_Overlay where FMapOverlayID='{0}' AND FMapTempID='{1}'", FMapOverlayID, FMapTempID); DBUtil.Execute(sql); }