批量查询 xml的方式还一种是表变量

最新推荐文章于 2023-08-18 09:22:31 发布

weixin_34128237

最新推荐文章于 2023-08-18 09:22:31 发布

阅读量94

点赞数

原文链接：http://www.cnblogs.com/muxueyuan/p/7991370.html

版权

var adds1 = getoneCityList.Select(l => { return new { YDCode = l.YDCode, SJQH = l.SJQH }; });
var jStr1 = JsonConvert.SerializeObject(new { root = new { li = adds1 } });
var xml1 = JsonConvert.DeserializeXmlNode(jStr1);

var dtOut3 = new TB_DomainAreaDAL().GetRegionalismList(xml1);

public DataTable GetRegionalismList(System.Xml.XmlDocument list)
{
string xml;//SJQH YDCode
using (System.IO.StringWriter sw = new System.IO.StringWriter())
{
System.Xml.Serialization.XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(list.GetType());
xs.Serialize(sw, list);
xml = sw.ToString();
}

StringBuilder strb = new StringBuilder();

strb.AppendLine("DECLARE @xml XML = @xmlData;");

strb.AppendLine(@"select distinct T.c.value('SJQH[1]','nvarchar(50)') SJQH, T.c.value('YDCode[1]','nvarchar(50)') YDCode,a.Regionalism
FROM TB_DomainArea AS a 
INNER JOIN @xml.nodes('/root/li') T(c) ON a.AreaCode=T.c.value('SJQH[1]','nvarchar(300)')");

var dt = DbHelperSQL.Query(SqlHelper.ConnectionStringLocalTransaction2Read, strb.ToString(), new SqlParameter("@xmlData", SqlDbType.Xml) { Value = xml }).Tables[0];

return dt;
}

转载于:https://www.cnblogs.com/muxueyuan/p/7991370.html