/// <summary> /// 获取约束条件 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源类别</param> /// <param name="resourceId">资源主键</param> /// <param name="tableName">表名</param> /// <returns>约束条件</returns> public PiPermissionScopeEntity GetConstraintEntity(UserInfo userInfo, string resourceCategory, string resourceId, string tableName, string permissionCode = "Resource.AccessPermission") { PiPermissionScopeEntity returnValue = null; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).GetConstraintEntity(resourceCategory, resourceId, tableName, permissionCode); }); return(returnValue); }
/// <summary> /// 设置约束条件 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源类别</param> /// <param name="resourceId">资源主键</param> /// <param name="tableName">表名</param> /// <param name="constraint">约束</param> /// <param name="enabled">有效</param> /// <returns>主键</returns> public string SetConstraint(UserInfo userInfo, string resourceCategory, string resourceId, string tableName, string permissionCode, string constraint, bool enabled = true) { string returnValue = string.Empty; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_SetConstraint); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).SetConstraint(resourceCategory, resourceId, tableName, permissionCode, constraint, enabled); }); return(returnValue); }
/// <summary> /// 获取约束条件 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源类别</param> /// <param name="resourceId">资源主键</param> /// <param name="tableName">表名</param> /// <returns>约束条件</returns> public string GetConstraint(UserInfo userInfo, string resourceCategory, string resourceId, string tableName) { string returnValue = string.Empty; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).GetConstraint(resourceCategory, resourceId, tableName); }); return(returnValue); }
/// <summary> /// 获取当前用户的件约束表达式 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <returns>主键</returns> public string GetUserConstraint(UserInfo userInfo, string tableName) { string returnValue = string.Empty; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetUserConstraint); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).GetUserConstraint(tableName); }); return(returnValue); }
/// <summary> /// 批次設置刪除标志 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int SetDeleted(UserInfo userInfo, string[] ids) { var returnValue = 0; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_SetDeleted); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).SetDeleted(ids); }); return(returnValue); }
/// <summary> /// 批量保存数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="dataTable">数据表</param> /// <returns>影响行数</returns> public int BatchSave(UserInfo userInfo, DataTable dataTable) { var returnValue = 0; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_BatchSave); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).BatchSave(dataTable); }); return(returnValue); }
/// <summary> /// 得到所有数据表(用于表字段权限的控制,主要针对PiTablePermissionScope数据表的数据) /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetAllTableScope(UserInfo userInfo) { var dataTable = new DataTable(CiTableColumnsTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetAllTableScope); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new TableColumnsManager(dbProvider, userInfo).GetAllTableScope(); dataTable.TableName = CiTableColumnsTable.TableName; }); return(dataTable); }
/// <summary> /// 获取约束条件(所有的约束) /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源类别</param> /// <param name="resourceId">资源主键</param> /// <returns>数据表</returns> public DataTable GetConstraintDT(UserInfo userInfo, string resourceCategory, string resourceId) { var dataTable = new DataTable(CiTableColumnsTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetConstraintDT); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new TableColumnsManager(dbProvider, userInfo).GetConstraintDT(resourceCategory, resourceId); dataTable.TableName = CiTableColumnsTable.TableName; }); return(dataTable); }
/// <summary> /// 获取用户的列权限 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableCode">表名</param> /// <param name="permissionCode">操作权限</param> /// <returns>有权限的列数组</returns> public string[] GetColumns(UserInfo userInfo, string tableCode, string permissionCode = "Column.Access") { string[] returnValue = null; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetColumns); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { returnValue = new TableColumnsManager(dbProvider, userInfo).GetColumns(userInfo.Id, tableCode, permissionCode); }); return(returnValue); }
/// <summary> /// 按条件获取数据列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="names">字段</param> /// <param name="values">值</param> /// <returns>資料表</returns> public DataTable GetDTByValues(UserInfo userInfo, string[] names, object[] values) { var dataTable = new DataTable(CiTableColumnsTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetDTByValues); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new TableColumnsManager(dbProvider, userInfo).GetDT(names, values); dataTable.TableName = CiTableColumnsTable.TableName; }); return(dataTable); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public CiTableColumnsEntity GetEntity(UserInfo userInfo, string id) { CiTableColumnsEntity entity = null; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { entity = new TableColumnsManager(dbProvider, userInfo).GetEntity(id); }); return(entity); }
/// <summary> /// 得到查询项 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableCode">表名称</param> /// <returns></returns> public DataTable GetSearchFields(UserInfo userInfo, string tableCode) { var dataTable = new DataTable(PiUserTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetSearchFields); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { dataTable = new TableColumnsManager(dbProvider, userInfo).GetSearchFields(tableCode); dataTable.TableName = PiUserTable.TableName; }); return(dataTable); }
/// <summary> /// 按表名获取字段列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableCode">表名</param> /// <returns>数据表</returns> public DataTable GetDTByTable(UserInfo userInfo, string tableCode) { var dataTable = new DataTable(CiTableColumnsTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_GetDTByTable); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { string[] names = { CiTableColumnsTable.FieldTableCode, CiTableColumnsTable.FieldDeleteMark }; Object[] values = { tableCode, 0 }; dataTable = new TableColumnsManager(dbProvider, userInfo).GetDT(names, values, CiTableColumnsTable.FieldSortCode); dataTable.TableName = CiTableColumnsTable.TableName; }); return(dataTable); }
/// <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, CiTableColumnsEntity entity, out string statusCode, out string statusMessage) { string returnValue = string.Empty; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.TableColumnsService_Add); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var manager = new TableColumnsManager(dbProvider, userInfo); returnValue = manager.AddEntity(entity); returnMessage = manager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; 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, CiTableColumnsEntity entity, out string statusCode, out string statusMessage) { var returnValue = 0; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var manager = new TableColumnsManager(dbProvider, userInfo); returnValue = manager.UpdateEntity(entity); returnMessage = manager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; return(returnValue); }