/// <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>
/// <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>
/// <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);
}
/// <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="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 string Add(UserInfo userInfo, LinkManEntity 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);
LinkManManager manager = new LinkManManager(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>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int SetDeleted(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);
LinkManManager manager = new LinkManManager(dbProvider, userInfo);
returnValue = manager.SetDeleted(ids);
}
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 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);
}