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