/// <summary>
/// 记录需要更新的字段
/// </summary>
/// <param name="update"></param>
private static void SetUpdateValue(PatrolCodeMst current, Hashtable updateKeys)
{
foreach (DictionaryEntry item in updateKeys)
{
switch (item.Key.ToString().ToLower())
{
case "codecd":
current.CodeCD = item.Value.ToString();
break;
case "codetypecd":
current.CodeTypeCD = item.Value.ToString();
break;
case "codetypename":
current.CodeTypeName = item.Value.ToString();
break;
case "codename":
current.CodeName = item.Value.ToString();
break;
case "codevalue":
current.CodeValue = item.Value.ToString();
break;
case "sortcd":
current.SortCD = Convert.ToInt32(item.Value);
break;
default:
break;
}
}
}
/// <summary>
/// 新增对象
/// </summary>
/// <param name="entity">实体</param>
/// <returns>true=成功;false=失败</returns>
public bool Insert(PatrolCodeMst entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
context.PatrolCodeMst.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="searchInfo">带有PatrolNo的查询对象</param>
/// <returns>指定UserCD值的个人信息</returns>
public static PatrolCodeMst Select(PatrolCodeMst searchInfo)
{
if (searchInfo == null || searchInfo.CodeCD == String.Empty || searchInfo.CodeTypeCD == String.Empty)
{
return(null);
}
return(controller.Select(searchInfo));
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="entity">删除对象 主键必须设置</param>
/// <returns></returns>
public static bool Delete(PatrolCodeMst 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(PatrolCodeMst 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(PatrolCodeMst entity)
{
if (entity != null)
{
return(controller.Insert(entity));
}
return(false);
}
/// <summary>
/// 复制对象
/// </summary>
/// <param name="source">源对象</param>
/// <returns></returns>
public PatrolCodeMst Copy(PatrolCodeMst source)
{
PatrolCodeMst target = new PatrolCodeMst();
target.CodeCD = source.CodeCD;
target.CodeTypeCD = source.CodeTypeCD;
target.CodeTypeName = source.CodeTypeName;
target.CodeName = source.CodeName;
target.CodeValue = source.CodeValue;
target.SortCD = source.SortCD;
return(target);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolCodeMst Select(PatrolCodeMst searchInfo)
{
PatrolCodeMst instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolCodeMst.Where("it.CodeTypeCD=@CodeTypeCD and it.CodeCD =@CodeCD", new ObjectParameter("CodeTypeCD", searchInfo.CodeTypeCD), new ObjectParameter("CodeCD", searchInfo.CodeCD)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <summary>
/// 测试数据字典信息
/// </summary>
public static void TestPatrolCodeMst()
{
PatrolCodeMstHelper ph = new PatrolCodeMstHelper();
PatrolCodeMst target = new PatrolCodeMst();
target.CodeCD = "PN00001";
target.CodeTypeCD = "CTD0001";
target.CodeTypeName = "LC00001";
target.CodeName = "LC00001";
target.CodeValue = "1";
target.SortCD = 1;
ph.Insert(target);
List <PatrolCodeMst> list = ph.SelectAll();
foreach (PatrolCodeMst item in list)
{
Console.WriteLine(item.CodeName);
}
ph.Delete(target);
}
/// <summary>
/// 根据主键删除实例
/// </summary>
/// <param name="oldEntity">设置了主键Id的对象</param>
/// <returns></returns>
public bool Delete(PatrolCodeMst entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
PatrolCodeMst instance = context.PatrolCodeMst.Where("it.CodeTypeCD=@CodeTypeCD and it.CodeCD =@CodeCD", new ObjectParameter("CodeTypeCD", entity.CodeTypeCD), new ObjectParameter("CodeCD", entity.CodeCD)).First();
//标记删除
context.PatrolCodeMst.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);
}
