/// <summary> /// 得到查询引擎定义实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public QueryEngineDefineEntity GetQueryEngineDefineEntity(UserInfo userInfo, string id) { QueryEngineDefineEntity entity = null; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_GetEntity); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { entity = new QueryEngineDefineManager(dbProvider, userInfo).GetEntity(id); }); return(entity); }
/// <summary> /// 批量删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDeleteQueryEngineDefine(UserInfo userInfo, string[] ids) { var returnValue = 0; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_BatchDelete); ServiceUtil.ProcessRDIWriteDbWithTran(userInfo, parameter, dbProvider => { returnValue = new QueryEngineDefineManager(dbProvider, userInfo).BatchDelete(ids); }); return(returnValue); }
/// <summary> /// 删除指定数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>数据表</returns> public int DeleteQueryEngineDefine(UserInfo userInfo, string id) { var returnValue = 0; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_Delete, "主键:" + id); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new QueryEngineDefineManager(dbProvider, userInfo).Delete(id); }); return(returnValue); }
/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parameters">参数</param> /// <returns>数据表</returns> public DataTable GetQueryEngineDefineDTByValues(UserInfo userInfo, List <KeyValuePair <string, object> > parameters) { var dataTable = new DataTable(QueryEngineDefineTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_GetDTByValues); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new QueryEngineDefineManager(dbProvider, userInfo).GetDT(parameters); dataTable.TableName = QueryEngineDefineTable.TableName; }); return(dataTable); }
/// <summary> /// 根据主键数组获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主鍵</param> /// <returns>数据表</returns> public DataTable GetQueryEngineDefineDTByIds(UserInfo userInfo, string[] ids) { var dataTable = new DataTable(QueryEngineDefineTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_GetDTByIds); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new QueryEngineDefineManager(dbProvider, userInfo).GetDT(QueryEngineDefineTable.FieldId, ids, QueryEngineDefineTable.FieldSortCode); dataTable.TableName = QueryEngineDefineTable.TableName; }); return(dataTable); }
/// <summary> /// 根据查询引擎主键获取查询引擎定义列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="queryEngineId">查询引擎主键</param> /// <returns>数据表</returns> public DataTable GetQueryEngineDefineDTByEngineId(UserInfo userInfo, string queryEngineId) { var dataTable = new DataTable(QueryEngineDefineTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_GetDT); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { List <KeyValuePair <string, object> > tempParameter = new List <KeyValuePair <string, object> >(); tempParameter.Add(new KeyValuePair <string, object>(QueryEngineDefineTable.FieldQueryEngineId, queryEngineId)); tempParameter.Add(new KeyValuePair <string, object>(QueryEngineDefineTable.FieldDeleteMark, 0)); dataTable = new QueryEngineDefineManager(dbProvider, userInfo).GetDT(tempParameter, QueryEngineDefineTable.FieldSortCode); dataTable.TableName = QueryEngineDefineTable.TableName; }); return(dataTable); }
/// <summary> /// 更新查询引擎定义 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">查询引擎定义实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int UpdateQueryEngineDefine(UserInfo userInfo, QueryEngineDefineEntity entity, out string statusCode, out string statusMessage) { int returnValue = 0; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.QueryEnginService_Update); ServiceUtil.ProcessRDIWriteDb(userInfo, parameter, dbProvider => { var manager = new QueryEngineDefineManager(dbProvider, userInfo); returnValue = manager.UpdateEntity(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; 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 GetQueryEngineDefineDTByPage(UserInfo userInfo, string searchValue, out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null) { var dataTable = new DataTable(QueryEngineDefineTable.TableName); var returnRecordCount = 0; var parameter = ParameterUtil.CreateWithOutMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var manager = new QueryEngineDefineManager(dbProvider, userInfo); if (string.IsNullOrEmpty(searchValue)) { searchValue = QueryEngineDefineTable.FieldDeleteMark + " = 0 "; } else { searchValue += " AND " + QueryEngineDefineTable.FieldDeleteMark + " = 0 "; } dataTable = manager.GetDTByPage(out returnRecordCount, pageIndex, pageSize, searchValue, sortExpression); dataTable.TableName = QueryEngineDefineTable.TableName; // 这里是获数据库连接名称中文显示 CiDbLinkDefineManager dbLinkManager = new CiDbLinkDefineManager(dbProvider, userInfo); if (!dataTable.Columns.Contains("LINKNAME_CHS")) { dataTable.Columns.Add("LINKNAME_CHS"); } foreach (DataRow dr in dataTable.Rows) { string dbLinkId = BusinessLogic.ConvertToString(dr[QueryEngineDefineTable.FieldDataBaseLinkName]); if (!string.IsNullOrEmpty(dbLinkId)) { dr["LINKNAME_CHS"] = dbLinkManager.GetEntity(dbLinkId).LinkName; } } dataTable.AcceptChanges(); }); recordCount = returnRecordCount; return(dataTable); }