sql2005的xml字段类型在.net中的应用

 
/// <param name="_ShopID">店铺ID</param>
public void DeleteMServerShop(int _ServerID, int _ShopID)
{
/*
UPDATE ES_Server
SET ServerShops.modify('declare namespace mi="http://www.linkedu.com.cn/MServerShop.xsd";
delete /mi:Shops/mi:Shop[@ShopID=1]') where ServerID=1
*/
DataProvider dp = SqlTools.HelpWWW.DataProviderUse;
using (IDbConnection conn = dp.GetConnection())
{
Common.DataAccess.ORMapping.IConvert ic = dp.GetIConvert();
Common.DataAccess.ORMapping.Mapping m = ic.GetNewMapping();
m.AddSql("UPDATE ES_Server SET ServerShops.modify('declare namespace mi=\"http://www.linkedu.com.cn/MServerShop.xsd\";delete /mi:Shops/mi:Shop[@ShopID=" _ShopID "]') where ServerID=" _ServerID);
m.ExecuteNonQuery(conn);
}
}
#endregion

#region 修改服务器对应的店铺信息 void ModifyMServerShop(int _ServerID, MServerShop _ServerShop)
/// <summary>
/// 修改服务器对应的店铺信息
/// </summary>
/// <param name="_ServerID">服务器的ServerID</param>
/// <param name="_ServerShop">服务器对应的店铺信息,其中以_ServerShop的ShopID属性为主键</param>
public void ModifyMServerShop(int _ServerID, MServerShop _ServerShop)
{
//UPDATE ES_Server SET ServerShops.modify('declare namespace mi="http://www.linkedu.com.cn/MServerShop.xsd";replace value of (/mi:Shops/mi:Shop[@ShopID=128780281]/@ShopName)[1] with "ShopNamex"') where ServerID=1
DataProvider dp = SqlTools.HelpWWW.DataProviderUse;
using (IDbConnection conn = dp.GetConnection())
{
Common.DataAccess.ORMapping.IConvert ic = dp.GetIConvert();
Common.DataAccess.ORMapping.Mapping m = ic.GetNewMapping();
m.AddSql("UPDATE ES_Server SET ServerShops.modify('declare namespace mi=\"http://www.linkedu.com.cn/MServerShop.xsd\";replace value of (/mi:Shops/mi:Shop[@ShopID=" _ServerShop.ShopID "]/@ShopName)[1] with \"" _ServerShop.ShopName "\"') where ServerID=" _ServerID);
m.ExecuteNonQuery(conn);
}
}
#endregion

#endregion

#endregion

#region 增删改
#region 添加服务器信息 int Add(int _ServerID, string _ServerName, string _IP, string _DomainName, string _Dir, string _Url, int _ServerGroupID)
/// <summary>
/// 添加服务器信息
/// </summary>
/// <param name="_ServerID">服务器ID</param>
共12页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] 9 [10] [11] [12] 下一页

评论加载中…