asp.net 转成XML后在SQL操作XML的值

1.asp.net 转成XML 执行GetCheckedIDXml方法

        public static string ParseListToXML<T>(T list, string rootName, string elementName) where T : ICollection
        {
            StringBuilder sb = new StringBuilder();
            sb.AppendFormat("<{0}>", rootName);
            foreach (var str in list)
            {
                sb.AppendFormat("<{0}>{1}</{0}>", elementName, str.ToString());
            }
            sb.AppendFormat("</{0}>", rootName);
            return sb.ToString();
        }

        public static string ParseStringListToXML(List<string> list, string rootName, string elementName)
        {
            return ParseListToXML<List<string>>(list, rootName, elementName);
        }

        private string GetCheckedIDXml(List<string> list)
        {
            return ParseStringListToXML(list, "BaseStation", "StationID");
        }

 2.SQL存储过程写法

CREATE PROCEDURE [dbo].[SP_Delete_StationList]
	@StationID	XML

AS
BEGIN
	SET NOCOUNT OFF;
	
DELETE station
	Where station_id
	  IN(SELECT ParamValues.station_id.value('.','varchar(20)')
                     FROM @StationID.nodes('/BaseStation/StationID') AS ParamValues(station_id))
	
END

 

转载于:https://www.cnblogs.com/bulege/archive/2012/03/20/2407621.html