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