/// <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); }