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

 
using (IDbConnection conn = dp.GetConnection())
{
Common.DataAccess.ORMapping.IConvert ic = dp.GetIConvert();
Common.DataAccess.ORMapping.Mapping m = ic.GetNewMapping();
Common.Utilities.ListDic<string, object> ld = new Common.Utilities.ListDic<string, object>();
ld.Add("ServerName", _ServerName);
ld.Add("IP", _IP);
ld.Add("DomainName", _DomainName);
ld.Add("Dir", _Dir);
ld.Add("Url", _Url);
ld.Add("ServerGroupID", _ServerGroupID);
m.Update(ld, "ES_Server");
m.AddSql(" where ServerID=");
m.AddSql("ServerID", _ServerID);

return m.ExecuteNonQuery(conn) > 0;
}
}
#endregion

#region 删除服务器信息 bool Delete(int _ServerID)
/// <summary>
/// 删除服务器信息
/// </summary>
/// <param name="_ServerID">服务器的ServerID</param>
/// <returns>是否成功</returns>
public bool Delete(int _ServerID)
{
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.Delete("ES_Server");
m.AddSql(" where ServerID=");
m.AddSql("ServerID", _ServerID);

return m.ExecuteNonQuery(conn) > 0;
}
}
#endregion
#endregion

#region 得到其它
#region 得到此服务器所属服务器群信息 MServerGroup GetServerGroup(int _ServerID)
/// <summary>
/// 得到此服务器所属服务器群信息
/// </summary>
/// <param name="_ServerID">服务器ID</param>
/// <returns>得到此服务器所属服务器群信息</returns>
public MServerGroup GetServerGroup(int _ServerID)
{
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("select * from ES_ServerGroup where ServerGroupID = (select ServerGroupID from ES_Server where ServerID=");
m.AddSql("ServerID", _ServerID);
m.AddSql(")");
共12页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 11 [12] 下一页

评论加载中…