/// <summary>
/// 根据主键删除实例
/// </summary>
/// <param name="oldEntity">设置了主键Id的对象</param>
/// <returns></returns>
public bool Delete(SUBCOMPANYMST entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
//删除操作
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="entity">实体</param>
/// <returns>true=成功;false=失败</returns>
public bool Insert(PatrolReportDetail entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
context.PatrolReportDetail.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="entity">实体</param>
/// <param name="updateKeys">更新字段列表 键值对</param>
/// <returns>true=成功,false=失败</returns>
public bool Update(CUSTMST entity, Hashtable updateKeys)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
//更新操作
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);
}
public static bool InsertPatrol(PatrolReportHeader header, List <PatrolReportDetail> detailList)
{
SQLEntities context = new SQLEntities();
bool success = false;
if (header != null && detailList != null && detailList.Count > 0)
{
using (TransactionScope trans = new TransactionScope())
{
try
{
context.PatrolReportHeader.AddObject(header);
foreach (PatrolReportDetail item in detailList)
{
context.PatrolReportDetail.AddObject(item);
}
trans.Complete();
success = true;
}
catch (Exception ex)
{
MyLog.Error("{{" + header.Reporter + "}}新建特巡报告错误" + ex.Message);
Console.WriteLine(ex.Message);
}
}
}
try
{
if (success)
{
//提交保存
context.SaveChanges();
MyLog.Log("{{" + header.Reporter + "}}保存特巡报告成功");
Console.WriteLine("保存特巡报告成功");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine("保存特巡报告异常");
MyLog.Error("{{" + header.Reporter + "}}保存特巡报告错误" + ex.Message);
success = false;
}
context.Dispose();
return(success);
}
/// <summary>
/// 返回所有整个表数据
/// </summary>
/// <returns></returns>
public List <SUBCOMPANYMST> SelectAll()
{
List <SUBCOMPANYMST> list = new List <SUBCOMPANYMST>();
try
{
SQLEntities context = new SQLEntities();
//添加所有记录
list.AddRange(context.SUBCOMPANYMST.ToList());
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(list);
}
/// <summary>
/// 返回所有整个表数据
/// </summary>
/// <returns></returns>
public List <PatrolReportDetail> SelectAll()
{
List <PatrolReportDetail> list = new List <PatrolReportDetail>();
try
{
SQLEntities context = new SQLEntities();
//添加所有记录
list.AddRange(context.PatrolReportDetail.ToList());
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(list);
}
/// <summary>
/// 根据查询条件查询数据集合
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public List <PatrolReportDetail> SearchByCondition(SearchInfo searchInfo)
{
List <PatrolReportDetail> list = new List <PatrolReportDetail>();
try
{
SQLEntities context = new SQLEntities();
list.AddRange(context.PatrolReportDetail.Where(searchInfo.WhereExpress, searchInfo.Parameters.ToArray()).ToList());
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(list);
}
/// <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="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolSpotParts Select(PatrolSpotParts searchInfo)
{
PatrolSpotParts instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolSpotParts.Where("it.ID=@ID", new ObjectParameter("ID", searchInfo.ID)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <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>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolReportHeader Select(PatrolReportHeader searchInfo)
{
PatrolReportHeader instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolReportHeader.Where("it.PatrolNO=@PatrolNO", new ObjectParameter("PatrolNO", searchInfo.PatrolNO)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(" 查询特巡异常：" + ex.Message);
}
return(instance);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public SUBCOMPANYMST Select(SUBCOMPANYMST searchInfo)
{
SUBCOMPANYMST instance = null;
try
{
SQLEntities context = new SQLEntities();
//查询单个用户
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolGenerateNO Select(PatrolGenerateNO searchInfo)
{
PatrolGenerateNO instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolGenerateNO.Where("it.PrefixCode=@PrefixCode", new ObjectParameter("PrefixCode", searchInfo.PrefixCode)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolReportDetail Select(PatrolReportDetail searchInfo)
{
PatrolReportDetail instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolReportDetail.Where("it.PatrolNO=@PatrolNO and it.SubNO =@SubNO", new ObjectParameter("PatrolNO", searchInfo.PatrolNO), new ObjectParameter("SubNO", searchInfo.SubNO)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
/// <summary>
/// 根据查询条件查询单条记录
/// </summary>
/// <param name="searchInfo">查询条件,主键查询</param>
/// <returns></returns>
public PatrolUserInfo Select(PatrolUserInfo searchInfo)
{
PatrolUserInfo instance = null;
try
{
SQLEntities context = new SQLEntities();
instance = context.PatrolUserInfo.Where("it.UserCD=@UserCD", new ObjectParameter("UserCD", searchInfo.UserCD)).First();
context.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(instance);
}
public static bool InsertUser(PatrolUserInfo newuser)
{
SQLEntities context = new SQLEntities();
bool success = false;
if (newuser != null)
{
using (TransactionScope trans = new TransactionScope())
{
try
{
context.PatrolUserInfo.AddObject(newuser);
Console.WriteLine("新增对象完毕");
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);
}
public static DataTable getUserInfo(string usercd)
{
SQLEntities context = new SQLEntities();
DataTable dt = new DataTable();
if (usercd != null && usercd != String.Empty)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (SqlConnection conn = new SqlConnection(connectString))
{
conn.Open();
Console.WriteLine("连接成功...");
String sqlString = getUserSqlString(usercd);
Console.WriteLine(sqlString);
SqlDataAdapter adapter = new SqlDataAdapter(sqlString, conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
scope.Complete();
dt = ds.Tables[0];
conn.Close();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
context.Dispose();
return(dt);
}
/// <summary>
/// 根据更新列表更新实体
/// </summary>
/// <param name="entity">实体</param>
/// <param name="updateKeys">更新字段列表 键值对</param>
/// <returns>true=成功,false=失败</returns>
public bool Update(PatrolReportHeader entity, Hashtable updateKeys)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
Console.WriteLine(entity.PatrolNO);
PatrolReportHeader instance = context.PatrolReportHeader.Where("it.PatrolNO=@PatrolNO", new ObjectParameter("PatrolNO", entity.PatrolNO)).First();
//更新数据操作
SetUpdateValue(instance, updateKeys);
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="oldEntity">设置了主键Id的对象</param>
/// <returns></returns>
public bool Delete(PatrolReportDetail entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
PatrolReportDetail instance = context.PatrolReportDetail.Where("it.PatrolNO=@PatrolNO and it.SubNO =@SubNO", new ObjectParameter("PatrolNO", entity.PatrolNO), new ObjectParameter("SubNO", entity.SubNO)).First();
//标记删除
context.PatrolReportDetail.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);
}
/// <summary>
/// 根据主键删除实例
/// </summary>
/// <param name="oldEntity">设置了主键Id的对象</param>
/// <returns></returns>
public bool Delete(PatrolUserInfo entity)
{
SQLEntities context = new SQLEntities();
bool success = false;
using (TransactionScope trans = new TransactionScope())
{
try
{
PatrolUserInfo instance = context.PatrolUserInfo.Where("it.UserCD=@UserCD", new ObjectParameter("UserCD", entity.UserCD)).First();
//标记删除
context.PatrolUserInfo.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);
}
public static bool updatePatrol(string headerSql, string detailSql)
{
SQLEntities context = new SQLEntities();
bool success = false;
if (headerSql != null && headerSql != String.Empty && detailSql != null && detailSql != String.Empty)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (SqlConnection conn = new SqlConnection(connectString))
{
Console.WriteLine("连接成功...");
String sqlString = headerSql + detailSql;
Console.WriteLine(sqlString);
SqlCommand command = new SqlCommand(sqlString, conn);
conn.Open();
success = command.ExecuteNonQuery() > 0;
scope.Complete();
conn.Close();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
context.Dispose();
return(success);
}