/// <summary> /// 批量删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(UserInfo userInfo, string[] ids) { int returnValue = 0; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "批量删除数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 开始事务 dbProvider.BeginTransaction(); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.Delete(ids); // 提交事务 dbProvider.CommitTransaction(); } catch (Exception ex) { // 回滚事务 dbProvider.RollbackTransaction(); CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 更新实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int Update(UserInfo userInfo, CUSTOMERCHANCEEntity entity, out string statusCode, out string statusMessage) { int returnValue = 0; statusCode = string.Empty; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "更新实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.UpdateEntity(entity); // returnValue = manager.Update(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 批量存储实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entites">实体列表</param> /// <returns>影响行数</returns> public int BatchSave(UserInfo userInfo, List <CUSTOMERCHANCEEntity> entites) { int returnValue = 0; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "批量存储实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); // returnValue = manager.BatchSave(entites); foreach (var entity in entites) { returnValue += manager.Update(entity); } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 分页查询 /// </summary> /// <param name="userInfo">用户</param> /// <param name="searchValue">查询关键字</param> /// <param name="recordCount">记录数</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">每页显示记录条数</param> /// <param name="sortExpression">排序字段</param> /// <returns>数据表</returns> public DataTable GetDTByPage(UserInfo userInfo, string searchValue, out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得列表", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDTByPage(out recordCount, pageIndex, pageSize, searchValue, sortExpression); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 得到数据表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(UserInfo userInfo) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得列表", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(new KeyValuePair <string, object>(CUSTOMERCHANCETable.FieldDELETEMARK, 0), CUSTOMERCHANCETable.FieldSORTCODE); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="names">字段</param> /// <param name="values">值</param> /// <returns>数据表</returns> public DataTable GetDataTableByValues(UserInfo userInfo, List <KeyValuePair <string, object> > parameters) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "根据条件获取数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(parameters); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 根据主键数组获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主鍵</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(UserInfo userInfo, string[] ids) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "根据主键数组获取数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(CUSTOMERCHANCETable.FieldId, ids, CUSTOMERCHANCETable.FieldSORTCODE); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 批量设置删除标志 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int SetDeleted(UserInfo userInfo, string[] ids) { int returnValue = 0; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "批量设置删除标志", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.SetDeleted(ids); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public CUSTOMERCHANCEEntity GetEntity(UserInfo userInfo, string id) { CUSTOMERCHANCEEntity entity = null; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); entity = manager.GetEntity(id); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(entity); }