//页面加载 void UCRoleCheck_Loaded(object sender, RoutedEventArgs e) { m_facade = new VendorFacade(); filter = new VendorRoleQueryFilter(); roleListVM = new VendorUserRoleListVM(); LoadAllActiveRoles(); LoadSettedRoles(AgentSysNo, UserSysNo); }
public UCVendorRoleQuery(int?roleSysNo) { InitializeComponent(); BindComboBoxData(); SeachBuilder.DataContext = m_query = new VendorRoleQueryFilter(); m_query.RoleSysNo = roleSysNo; if (m_query.RoleSysNo != null && m_query.RoleSysNo != 0) { this.txtRoleSysNo.Text = m_query.RoleSysNo.Value.ToString(); this.QueryResultGrid.Bind(); } }
public void QueryVendorRoleVM(VendorRoleQueryFilter query, Action <List <RoleMgmtSearchResultVM>, int> callback) { string relativeUrl = "/ExternalSYSService/ExternalSYS/QueryVendorRole"; restClient.QueryDynamicData(relativeUrl, query, (sender, e) => { if (!e.FaultsHandle()) { if (e.Result != null && callback != null) { List <RoleMgmtSearchResultVM> dataVMList = DynamicConverter <RoleMgmtSearchResultVM> .ConvertToVMList(e.Result.Rows); callback(dataVMList, e.Result.TotalCount); } } }); }
public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); SeachBuilder.DataContext = m_query = new VendorRoleQueryFilter(); m_facade = new VendorFacade(); vm = new RoleMgmtVM(); this.cmbStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.ExternalSYS.ValidStatus>(EnumConverter.EnumAppendItemType.All); this.cmbStatus.SelectedIndex = 0; this.ResultGrid.DataContext = vm; m_facade.GetPrivilegeList((o, rst) => { if (!rst.FaultsHandle() && rst.Result != null) { privilegeData = TransferToNodes(rst.Result); } }); }
public QueryResult QueryVendorRole(VendorRoleQueryFilter filter) { return(QueryList <VendorRoleQueryFilter>(filter, ObjectFactory <IVendorRoleDA> .Instance.RoleQuery)); }
/// <summary> /// 角色查询 /// </summary> /// <param name="query">过滤条件</param> /// <param name="callback">回调函数</param> public void QueryVendorRole(VendorRoleQueryFilter query, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/ExternalSYSService/ExternalSYS/QueryVendorRole"; restClient.QueryDynamicData(relativeUrl, query, callback); }
public DataTable RoleQuery(VendorRoleQueryFilter filter, out int dataCount) { if (filter.PagingInfo != null && filter.PagingInfo.SortBy != null) { string sortCondition = filter.PagingInfo.SortBy.Trim(); Match match = Regex.Match(sortCondition, @"^(?<SortColumn>[\S]+)(?:\s+(?<SortType>ASC|DESC))?$", RegexOptions.IgnoreCase); if (match.Groups["SortColumn"].Success) { string sortColumn = match.Groups["SortColumn"].Value; string sortType = match.Groups["SortType"].Success ? match.Groups["SortType"].Value : "DESC"; #region switch switch (sortColumn) { case "SysNo": filter.PagingInfo.SortBy = String.Format("{0} {1}", "SysNo", sortType); break; case "RoleName": filter.PagingInfo.SortBy = String.Format("{0} {1}", "RoleName", sortType); break; case "Status": filter.PagingInfo.SortBy = String.Format("{0} {1}", "Status", sortType); break; case "InUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "InUser", sortType); break; case "InDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "InDate", sortType); break; case "EditUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "EditUser", sortType); break; case "EditDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "EditDate", sortType); break; } #endregion } } CustomDataCommand command = DataCommandManager. CreateCustomDataCommandFromConfig("ExternalSYS_Query_VendorRole"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder( command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "SysNo DESC")) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.RoleSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RoleName", DbType.String, "@RoleName", QueryConditionOperatorType.LeftLike, filter.RoleName); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, filter.Status); if (!string.IsNullOrEmpty(filter.PrivilegeName)) { ConditionConstructor subQueryBuilder = builder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, null, QueryConditionOperatorType.Exist, @"SELECT 1 FROM ( SELECT [RoleSysNo] FROM [IPP3].[dbo].[VendorUser_Role_Privilege] WITH(NOLOCK) WHERE [PrivilegeSysNo] IN ( SELECT [SysNo] FROM [IPP3].[dbo].[VendorUser_Privilege] WITH(NOLOCK) WHERE [Memo] LIKE @PrivilegeName ) ) AS RESULT WHERE RESULT.[RoleSysNo]=[VendorUser_Role].[SysNo]"); command.AddInputParameter("@PrivilegeName", DbType.String, filter.PrivilegeName + "%"); } command.CommandText = builder.BuildQuerySql(); var dt = command.ExecuteDataTable("Status", typeof(ValidStatus)); dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }