/// <summary> /// 返回受影响行数 /// </summary> /// <param name="provider">数据提供加载驱动</param> /// <param name="sqlString">sql语句</param> /// <param name="isProcedure">是否为存储过程,true 为存储过程</param> /// <param name="param">sql语句对应参数</param> /// <returns></returns> public int ExecuteNonQuery(string sqlString, bool isProcedure, params IDataParameter[] param) { try { provider.Open(); provider.Command.CommandText = sqlString; if (isProcedure) { provider.Command.CommandType = CommandType.StoredProcedure; } else { provider.Command.CommandType = CommandType.Text; } provider.Command.Parameters.Clear(); if (param != null) { for (int i = 0; i < param.Length; i++) { provider.Command.Parameters.Add(param[i]); } } return((int)provider.Command.ExecuteNonQuery()); } finally { provider.Close(); } }
/// <summary> /// 执行查询返回受影响的行数 /// </summary> /// <param name="commandText">sql查询</param> /// <param name="dbParameters">参数集</param> /// <param name="commandType">命令分类</param> /// <returns>影响行数</returns> public static int ExecuteNonQuery(string commandText, IDbDataParameter[] dbParameters = null, CommandType commandType = CommandType.Text) { int returnValue = 0; dbProvider.Open(DbConnection); returnValue = dbProvider.ExecuteNonQuery(commandText, dbParameters, commandType); dbProvider.Close(); return(returnValue); }
public static int ExecuteNonQuery(string commandText, IDbDataParameter[] dbParameters = null, CommandType commandType = 1) { int num = 0; idbProvider_0.Open(DbConnection); num = idbProvider_0.ExecuteNonQuery(commandText, dbParameters, commandType); idbProvider_0.Close(); return(num); }
/// <summary> /// 得到客户-主联系人信息 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>数据表</returns> public DataTable GetCustomerContactInfo(UserInfo userInfo, string id) { DataTable dataTable = new DataTable(); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 CustomerManager manager = new CustomerManager(dbProvider, userInfo); dataTable = manager.GetCustomerContactInfo(id); dataTable.TableName = CustomerTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
public static void ProcessRDIWriteDbWithLock(UserInfo userInfo, ParameterUtil parameter, object locker, ProcessFunWithLockDelegate fun) { if (SystemInfo.IsAuthorized(userInfo)) { int milliStart = Begin(parameter.UserInfo, parameter.CurrentMethod); bool getOnLine = false; lock (locker) { using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(GetDbType(DbType.RDIDbWrite))) { try { dbProvider.Open(GetDbConnection(DbType.RDIDbWrite)); getOnLine = fun(dbProvider, getOnLine); AddLog(dbProvider, parameter); } catch (Exception ex) { CiExceptionManager.LogException(dbProvider, parameter.UserInfo, ex); throw; } finally { dbProvider.Close(); } } } End(milliStart, parameter.CurrentMethod, getOnLine); } }
/// <summary> /// 根据分类获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="category">分类</param> /// <returns>数据表</returns> public DataTable GetDTByCategory(UserInfo userInfo, string category = "") { DataTable dataTable = new DataTable(CustomerTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 CustomerManager manager = new CustomerManager(dbProvider, userInfo); dataTable = manager.GetDTByCategory(category); dataTable.TableName = CustomerTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parameters">参数</param> /// <returns>数据表</returns> public DataTable GetDataTableByValues(UserInfo userInfo, List <KeyValuePair <string, object> > parameters) { DataTable dataTable = new DataTable(LinkManTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 LinkManManager manager = new LinkManManager(dbProvider, userInfo); dataTable = manager.GetDT(parameters); dataTable.TableName = LinkManTable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(dbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 取得数据表(包括客户的简称) /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(UserInfo userInfo) { DataTable dataTable = new DataTable(LinkManTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 LinkManManager manager = new LinkManManager(dbProvider, userInfo); dataTable = manager.GetDataTable(); dataTable.TableName = LinkManTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 分页查询 /// </summary> /// <param name="userInfo">用户</param> /// <param name="userId">用户主键</param> /// <param name="searchValue">查询关键字</param> /// <param name="recordCount">记录数</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">每页显示记录条数</param> /// <param name="sortExpression">排序字段</param> /// <param name="sortDire">排序方向</param> /// <returns>数据表</returns> public DataTable GetDataTableByPage(UserInfo userInfo, string userId, string searchValue, out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null, string sortDire = null) { DataTable dataTable = new DataTable(LinkManTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 LinkManManager manager = new LinkManManager(dbProvider, userInfo); dataTable = manager.GetDataTableByPage(userId, searchValue, out recordCount, pageIndex, pageSize, sortExpression, sortDire); dataTable.TableName = LinkManTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
private static void ProcessDbProvider(ParameterUtil sup, ProcessFunDelegate fun, DbType dbType, bool inTransaction) { using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(GetDbType(dbType))) { try { dbProvider.Open(GetDbConnection(dbType)); if (inTransaction) { dbProvider.BeginTransaction(); } fun(dbProvider); AddLog(dbProvider, sup); if (inTransaction) { dbProvider.CommitTransaction(); } } catch (Exception ex) { if (inTransaction) { dbProvider.RollbackTransaction(); } CiExceptionManager.LogException(dbProvider, sup.UserInfo, ex); throw; } finally { dbProvider.Close(); } } }
/// <summary> /// 新增数据 /// </summary> /// <param name="userInfo">使用者</param> /// <param name="entity">实体</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>受影响的行数</returns> public int Add(UserInfo userInfo, CiItemDetailsEntity entity, out string statusMessage) { int returnValue = 0; statusMessage = string.Empty; if (this.GetDTByValues(userInfo, new string[] { CiItemDetailsTable.FieldItemId, CiItemDetailsTable.FieldItemName, CiItemDetailsTable.FieldDeleteMark }, new string[] { entity.ItemId.ToString(), entity.ItemName, "0" }).Rows.Count > 0) { returnValue = 0; statusMessage = "已存在相同的明细项!"; } else { using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { dbProvider.Open(RDIFrameworkDbConection); var manager = new CiItemDetailsManager(dbProvider, userInfo); returnValue = !string.IsNullOrEmpty(manager.AddEntity(entity)) ?1:0; statusMessage = "成功新增数据!"; } catch (Exception ex) { CiExceptionManager.LogException(dbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } return(returnValue); }
/// <summary> /// 根据主键数组获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主鍵</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(UserInfo userInfo, string[] ids) { DataTable dataTable = new DataTable(LinkManTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); LinkManManager manager = new LinkManManager(dbProvider, userInfo); dataTable = manager.GetDT(LinkManTable.FieldId, ids, LinkManTable.FieldSortCode); dataTable.TableName = LinkManTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 取得数据表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(UserInfo userInfo) { DataTable dataTable = new DataTable(IncomingCallTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); dataTable = manager.GetDT(new KeyValuePair <string, object>(IncomingCallTable.FieldDeleteMark, 0), IncomingCallTable.FieldSortCode); dataTable.TableName = IncomingCallTable.TableName; } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 批量删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(UserInfo userInfo, string[] ids) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "批量删除数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 开始事务 dbProvider.BeginTransaction(); LinkManManager manager = new LinkManManager(dbProvider, userInfo); returnValue = manager.Delete(ids); // 提交事务 dbProvider.CommitTransaction(); } catch (Exception ex) { // 回滚事务 dbProvider.RollbackTransaction(); CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.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="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态消息</param> /// <returns>主鍵</returns> public string Add(UserInfo userInfo, CustomerEntity entity, out string statusCode, out string statusMessage) { string returnValue = string.Empty; statusCode = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "新增实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CustomerManager manager = new CustomerManager(dbProvider, userInfo); returnValue = manager.Add(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <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="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> /// <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="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="whereParameters">条件键值对</param> /// <param name="parameters">键值对</param> /// <returns>受影响的行数</returns> public int UpdateByValues(UserInfo userInfo, List <KeyValuePair <string, object> > whereParameters, List <KeyValuePair <string, object> > parameters) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "根据条件更新数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 CustomerManager manager = new CustomerManager(dbProvider, userInfo); returnValue = manager.SetProperty(manager.GetIds(parameters), whereParameters); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>数据表</returns> public int Delete(UserInfo userInfo, string id) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "删除数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.Delete(id); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 新增实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <returns>主鍵</returns> public string Add(UserInfo userInfo, IncomingCallEntity entity) { string returnValue = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "新增实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.AddEntity(entity); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.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); }
/// <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); }
private DataTable ExecSql(string sql) { DataTable dt = new DataTable(); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); dt = dbProvider.Fill(sql); } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(dt); }
/// <summary> /// 服务器端检查在线状态 /// </summary> /// <returns>离线人数</returns> public int ServerCheckOnLine() { int returnValue = 0; using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { dbProvider.Open(RDIFrameworkDbConection); returnValue = userLogOnManager.CheckOnLine(); } catch (Exception ex) { LogHelper.WriteException(ex); throw ex; } finally { dbProvider.Close(); } } return(returnValue); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public LinkManEntity GetEntity(UserInfo userInfo, string id) { LinkManEntity entity = null; using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); LinkManManager manager = new LinkManManager(dbProvider, userInfo); entity = manager.GetEntity(id); } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(entity); }
//事务测试 private void toolStripButton2_Click(object sender, EventArgs e) { dbProvider.Open(); dbProvider.BeginTransaction(); try { string sql = "insert into test1(Id,Col1,Col2,Col3) values('" + BusinessLogic.NewGuid() + "','abcd',2,'kk')"; int value1 = dbProvider.ExecuteNonQuery(sql); //sql = "insert into test2(Id,Col1,Col2) values('" + BusinessLogic.NewGuid() + "','4','kk')"; sql = "insert into test2(Id,Col2) values('" + BusinessLogic.NewGuid() + "','kk')"; int value2 = dbProvider.ExecuteNonQuery(sql); //插入失败,则第一条语句也失败。 dbProvider.CommitTransaction(); } catch (Exception ex) { dbProvider.RollbackTransaction(); MessageBoxHelper.ShowErrorMsg(ex.Message); } finally { dbProvider.Close(); } }