/// <summary>
/// 新增对象
/// </summary>
/// <param name="entity">实体</param>
/// <returns>true=成功;false=失败</returns>
public bool Insert(PatrolServerList entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
context.PatrolServerList.AddObject(entity);
trans.Complete();
success = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
try
{
if (success)
{
//提交保存
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
context.Dispose();
return(success);
}
/// <summary>
/// 记录需要更新的字段
/// </summary>
/// <param name="update"></param>
private static void SetUpdateValue(PatrolServerList current, Hashtable updateKeys)
{
foreach (DictionaryEntry item in updateKeys)
{
switch (item.Key.ToString().ToLower())
{
case "address":
current.Address = item.Value.ToString();
break;
case "name":
current.Name = item.Value.ToString();
break;
case "ismainserver":
current.IsMainServer = item.Value.ToString();
break;
case "sortcd":
current.SortCD = Convert.ToInt32(item.Value);
break;
default:
break;
}
}
}
/// <summary>
/// 根据用户名称查询唯一用户
/// </summary>
/// <param name="searchInfo">带有UserCD值的查询对象</param>
/// <returns>指定UserCD值的个人信息</returns>
public static PatrolServerList Select(PatrolServerList searchInfo)
{
if (searchInfo == null || searchInfo.Address == String.Empty)
{
return(null);
}
return(controller.Select(searchInfo));
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="entity">删除对象 主键必须设置</param>
/// <returns></returns>
public static bool Delete(PatrolServerList entity)
{
if (entity != null)
{
return(controller.Delete(entity));
}
return(false);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="entity">要更新对象</param>
/// <param name="updateKeys">更新列表</param>
/// <returns>true=成功,false=失败</returns>
public static bool Update(PatrolServerList entity, Hashtable updateKeys)
{
if (entity != null && updateKeys != null && updateKeys.Count > 0)
{
return(controller.Update(entity, updateKeys));
}
return(false);
}
/// <summary>
/// 新增记录
/// </summary>
/// <param name="entity">新增对象</param>
/// <returns>true=成功,false=失败</returns>
public static bool Insert(PatrolServerList entity)
{
if (entity != null)
{
return(controller.Insert(entity));
}
return(false);
}
/// <summary>
/// 复制对象
/// </summary>
/// <param name="source">源对象</param>
/// <returns></returns>
public PatrolServerList Copy(PatrolServerList source)
{
PatrolServerList target = new PatrolServerList();
target.Address = source.Address;
target.Name = source.Name;
target.IsMainServer = source.IsMainServer;
target.SortCD = source.SortCD;
return(target);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolServerList Select(PatrolServerList searchInfo)
{
PatrolServerList instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolServerList.Where("it.Address=@Address", new ObjectParameter("Address", searchInfo.Address)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <summary>
/// 根据主键删除实例
/// </summary>
/// <param name="oldEntity">设置了主键Id的对象</param>
/// <returns></returns>
public bool Delete(PatrolServerList entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
PatrolServerList instance = context.PatrolServerList.Where("it.Address=@Address", new ObjectParameter("Address", entity.Address)).First();
//标记删除
context.PatrolServerList.DeleteObject(instance);
trans.Complete();
success = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
try
{
if (success)
{
//提交保存
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
context.Dispose();
return(success);
}
