private void SearchButton_Click(object sender, RoutedEventArgs e) { string filter = " 1=1 "; int pageCount = 0; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl <ComboBox>(expander, "cbxSystemType"); //T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; //string systype = dict == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); string parentid = ""; LookUp lkParentMenu = Utility.FindChildControl <LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if (!string.IsNullOrEmpty(StrSystemType)) { filter += " && SYSTEMTYPE ==@" + paras.Count().ToString(); paras.Add(StrSystemType); } if (menu != null) { parentid = menu.ENTITYMENUID; if (!string.IsNullOrEmpty(parentid)) { filter += " && T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //loadbar.Start(); RefreshUI(RefreshedTypes.ShowProgressBar); client.GetSysMenuByTypePagingAsync(0, 500, "ORDERNUMBER", filter, paras, pageCount, loginUserInfo); }
/// <summary> /// 加载菜单数据 /// </summary> private void LoadData() { string filter = " 1=1 "; int pageCount = 0; //from a in DataContext.T_SYS_ENTITYMENU.Include("T_SYS_ENTITYMENU2") // where (string.IsNullOrEmpty(sysType) || a.SYSTEMTYPE == sysType) // && (string.IsNullOrEmpty(parentID) || ( a.T_SYS_ENTITYMENU2!=null && a.T_SYS_ENTITYMENU2.ENTITYMENUID == parentID) ) // orderby a.ORDERNUMBER // select a; ComboBox cbxSystemType = Utility.FindChildControl <ComboBox>(expander, "cbxSystemType"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string systype = dict == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); string parentid = ""; //string StrName = "";//菜单名称 LookUp lkParentMenu = Utility.FindChildControl <LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if (!string.IsNullOrEmpty(systype)) { filter += " && SYSTEMTYPE ==@" + paras.Count().ToString(); paras.Add(systype); } if (menu != null) { parentid = menu.ENTITYMENUID; if (!string.IsNullOrEmpty(parentid)) { filter += " && T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; loadbar.Start(); client.GetSysMenuByTypePagingAsync(dataPager.PageIndex, dataPager.PageSize, "ORDERNUMBER", filter, paras, pageCount, loginUserInfo); //client.GetSysMenuByTypeAsync(systype, parentid); }
private void LoadData() { ShowPageStyle(); string filter = ""; //查询过滤条件 string StrName = ""; int pageCount = 0; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 TextBox Name = Utility.FindChildControl <TextBox>(expander, "txtName"); StrName = Name.Text.Trim().ToString(); if (!string.IsNullOrEmpty(StrName)) { filter += "PERMISSIONNAME ^@" + paras.Count().ToString();//类型名称 paras.Add(StrName); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; ServiceClient.GetSysPermissionAllPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo); }
/// <summary> /// 加载菜单数据 /// </summary> private void LoadData() { //ServiceClient.GetSysRoleByTypeAsync(this.txtSearchSystemType.Text.Trim()); string filter = ""; //查询过滤条件 int pageCount = 0; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl <ComboBox>(expander, "cbxSystemType"); TextBox RoleName = Utility.FindChildControl <TextBox>(expander, "TxtRoleName"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string StrRoleName = ""; StrRoleName = RoleName.Text; //if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim())) //{ // //filter += "EMPLOYEECODE==@" + paras.Count().ToString(); // filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)"; // paras.Add(txtEmpCode.Text.Trim()); //} string systype = ""; if (dict != null) { systype = dict.DICTIONARYVALUE == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); } if (!string.IsNullOrEmpty(systype)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "SYSTEMTYPE ==@" + paras.Count().ToString();//类型名称 paras.Add(systype); } string sValue = ""; TreeViewItem selectedItem = treeOrganization.SelectedItem as TreeViewItem; if (selectedItem != null) { string IsTag = selectedItem.Tag.ToString(); switch (IsTag) { case "Company": SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY company = selectedItem.DataContext as SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY; //sType = "Company"; sValue = company.COMPANYID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "OWNERCOMPANYID ==@" + paras.Count().ToString(); //类型名称 paras.Add(sValue); break; case "Department": SMT.Saas.Tools.OrganizationWS.T_HR_DEPARTMENT department = selectedItem.DataContext as SMT.Saas.Tools.OrganizationWS.T_HR_DEPARTMENT; //sType = "Department"; sValue = department.DEPARTMENTID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "OWNERDEPARTMENTID ==@" + paras.Count().ToString(); //类型名称 paras.Add(sValue); break; } } if (string.IsNullOrEmpty(filter)) { //默认为自己公司的角色 filter += "OWNERCOMPANYID ==@" + paras.Count().ToString();//类型名称 paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } if (!string.IsNullOrEmpty(StrRoleName)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } //filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)";//类型名称 //filter += "ROLENAME ^@" + paras.Count().ToString();//类型名称 filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)"; paras.Add(StrRoleName); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //只能查看自己所在公司的角色 //CompanyIDList.Clear(); //CompanyIDList.Add(Common.CurrentLoginUserInfo.UserPosts); //if (Common.CurrentLoginUserInfo.UserPosts.Count() > 0) //{ // foreach (var str in Common.CurrentLoginUserInfo.UserPosts) // { // CompanyIDList.Add(str.CompanyID); // } //} ServiceClient.GetSysRoleInfosPagingByCompanyIDsAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo, CompanyIDList); }
private void LoadData() { //ServiceClient.GetSysRoleByTypeAsync(this.txtSearchSystemType.Text.Trim()); string filter = ""; //查询过滤条件 int pageCount = 0; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl<ComboBox>(expander, "cbxSystemType"); TextBox RoleName = Utility.FindChildControl<TextBox>(expander, "TxtRoleName"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string StrRoleName = ""; StrRoleName = RoleName.Text; if (!string.IsNullOrEmpty(StrRoleName)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } //filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)";//类型名称 //filter += "ROLENAME ^@" + paras.Count().ToString();//类型名称 filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)"; paras.Add(StrRoleName); } //if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim())) //{ // //filter += "EMPLOYEECODE==@" + paras.Count().ToString(); // filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)"; // paras.Add(txtEmpCode.Text.Trim()); //} string systype = ""; if (dict != null) systype = dict.DICTIONARYVALUE == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); if (!string.IsNullOrEmpty(systype)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "SYSTEMTYPE ==@" + paras.Count().ToString();//类型名称 paras.Add(systype); } string sType = "", sValue = ""; if (string.IsNullOrEmpty(filter)) { //默认为自己公司的角色 filter += "OWNERCOMPANYID ==@" + paras.Count().ToString();//类型名称 paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //permClient.GetSysRoleInfosPagingByCompanyIDsAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo, null); permClient.GetRoleInfosByUserAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo); }
/// <summary> /// 加载菜单数据 /// </summary> private void LoadData() { //ServiceClient.GetSysRoleByTypeAsync(this.txtSearchSystemType.Text.Trim()); string filter = ""; //查询过滤条件 int pageCount = 0; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl<ComboBox>(expander, "cbxSystemType"); TextBox RoleName = Utility.FindChildControl<TextBox>(expander, "TxtRoleName"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string StrRoleName = ""; StrRoleName = RoleName.Text; //if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim())) //{ // //filter += "EMPLOYEECODE==@" + paras.Count().ToString(); // filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)"; // paras.Add(txtEmpCode.Text.Trim()); //} string systype = ""; if(dict != null) systype = dict.DICTIONARYVALUE == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); if (!string.IsNullOrEmpty(systype)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "SYSTEMTYPE ==@" + paras.Count().ToString();//类型名称 paras.Add(systype); } string sValue = ""; TreeViewItem selectedItem = treeOrganization.SelectedItem as TreeViewItem; if (selectedItem != null) { string IsTag = selectedItem.Tag.ToString(); switch (IsTag) { case "Company": SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY company = selectedItem.DataContext as SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY; //sType = "Company"; sValue = company.COMPANYID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "OWNERCOMPANYID ==@" + paras.Count().ToString();//类型名称 paras.Add(sValue); break; case "Department": SMT.Saas.Tools.OrganizationWS.T_HR_DEPARTMENT department = selectedItem.DataContext as SMT.Saas.Tools.OrganizationWS.T_HR_DEPARTMENT; //sType = "Department"; sValue = department.DEPARTMENTID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "OWNERDEPARTMENTID ==@" + paras.Count().ToString();//类型名称 paras.Add(sValue); break; } } if (string.IsNullOrEmpty(filter)) { //默认为自己公司的角色 filter += "OWNERCOMPANYID ==@" + paras.Count().ToString();//类型名称 paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } if (!string.IsNullOrEmpty(StrRoleName)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } //filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)";//类型名称 //filter += "ROLENAME ^@" + paras.Count().ToString();//类型名称 filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)"; paras.Add(StrRoleName); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //只能查看自己所在公司的角色 //CompanyIDList.Clear(); //CompanyIDList.Add(Common.CurrentLoginUserInfo.UserPosts); //if (Common.CurrentLoginUserInfo.UserPosts.Count() > 0) //{ // foreach (var str in Common.CurrentLoginUserInfo.UserPosts) // { // CompanyIDList.Add(str.CompanyID); // } //} ServiceClient.GetSysRoleInfosPagingByCompanyIDsAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo,CompanyIDList); }
private void LoadData() { string filter = ""; //查询过滤条件 int pageCount = 0; if (QueryBtn) { string StrState = ""; //状态 string StrStart = ""; //添加文档的起始时间 string StrEnd = ""; //添加文档的结束时间 ComboBox dpState = Utility.FindChildControl <ComboBox>(expander, "dpState"); switch (dpState.SelectedIndex) { case 0: StrState = ""; break; case 1: StrState = "1"; break; case 2: StrState = "0"; break; } DatePicker DtpStart = Utility.FindChildControl <DatePicker>(expander, "DtStart"); DatePicker DtpEnd = Utility.FindChildControl <DatePicker>(expander, "DtEnd"); StrStart = DtpStart.Text.Trim().ToString(); StrEnd = DtpEnd.Text.Trim().ToString(); if (StrState == "" && StrStart == "" && StrEnd == "") { //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("QUERYINFONOTNULL")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("QUERYINFONOTNULL"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL")); //ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); //return; DtStart = System.Convert.ToDateTime(StrStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE >@" + paras.Count().ToString(); paras.Add(DtStart); } if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL")); //ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); //return; DtEnd = System.Convert.ToDateTime(StrEnd); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE <@" + paras.Count().ToString(); paras.Add(DtEnd); } if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); //DtEnd = System.Convert.ToDateTime(StrEnd); DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59"); if (DtStart > DtEnd) { //Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE >@" + paras.Count().ToString(); paras.Add(DtStart); filter += " and "; filter += "userloginrecord.LOGINDATE <@" + paras.Count().ToString(); paras.Add(DtEnd); } } } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; SysLoginClient.GetSysUserLoginRecordInfosPagingAsync(dataPager.PageIndex, dataPager.PageSize, "userloginrecord.LOGINDATE", filter, paras, pageCount, loginUserInfo); //SysLoginClient.GetSysUserLoginRecordInfosAsync(); }
private void SearchButton_Click(object sender, RoutedEventArgs e) { string filter = " 1=1 "; int pageCount = 0; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl<ComboBox>(expander, "cbxSystemType"); //T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; //string systype = dict == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); string parentid = ""; LookUp lkParentMenu = Utility.FindChildControl<LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if (!string.IsNullOrEmpty(StrSystemType)) { filter += " && SYSTEMTYPE ==@" + paras.Count().ToString(); paras.Add(StrSystemType); } if (menu != null) { parentid = menu.ENTITYMENUID; if (!string.IsNullOrEmpty(parentid)) { filter += " && T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } string strName = string.Empty; TextBox menuName = Utility.FindChildControl<TextBox>(expander, "TxtMenuName"); strName = menuName.Text; if (!string.IsNullOrEmpty(strName)) { //filter += " && @" + paras.Count().ToString() + ".Contains(ENTITYNAME)"; filter += " && MENUNAME.Contains(@" + paras.Count().ToString() + ")"; paras.Add(strName); } SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //loadbar.Start(); RefreshUI(RefreshedTypes.ShowProgressBar); client.GetSysMenuByTypePagingAsync(0, 500, "ORDERNUMBER", filter, paras, pageCount, loginUserInfo); }
/// <summary> /// 加载菜单数据 /// </summary> private void LoadData() { string filter = " 1=1 "; int pageCount = 0; //from a in DataContext.T_SYS_ENTITYMENU.Include("T_SYS_ENTITYMENU2") // where (string.IsNullOrEmpty(sysType) || a.SYSTEMTYPE == sysType) // && (string.IsNullOrEmpty(parentID) || ( a.T_SYS_ENTITYMENU2!=null && a.T_SYS_ENTITYMENU2.ENTITYMENUID == parentID) ) // orderby a.ORDERNUMBER // select a; ComboBox cbxSystemType = Utility.FindChildControl<ComboBox>(expander, "cbxSystemType"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string systype = dict == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); string parentid = ""; string StrName = "";//菜单名称 TextBox menuName = Utility.FindChildControl<TextBox>(expander, "txtMenuName"); StrName = menuName.Text; LookUp lkParentMenu = Utility.FindChildControl<LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if(!string.IsNullOrEmpty(systype)) { filter += " && SYSTEMTYPE ==@" + paras.Count().ToString(); paras.Add(systype); } if (menu != null) { parentid = menu.ENTITYMENUID; if (!string.IsNullOrEmpty(filter)) { if (!string.IsNullOrEmpty(parentid)) { filter += " && T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } else { if (!string.IsNullOrEmpty(parentid)) { filter += " T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } } if (!string.IsNullOrEmpty(StrName)) { filter += " && MENUNAME.Contains(@" + paras.Count().ToString() + ")"; //filter += " && @" + paras.Count().ToString() + ".Contains(MENUNAME)"; paras.Add(StrName); } SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; loadbar.Start(); client.GetSysMenuByTypePagingAsync(dataPager.PageIndex, dataPager.PageSize, "ORDERNUMBER", filter, paras, pageCount, loginUserInfo); //client.GetSysMenuByTypeAsync(systype, parentid); }
private void LoadData() { //ServiceClient.GetSysRoleByTypeAsync(this.txtSearchSystemType.Text.Trim()); string filter = ""; //查询过滤条件 int pageCount = 0; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl <ComboBox>(expander, "cbxSystemType"); TextBox RoleName = Utility.FindChildControl <TextBox>(expander, "TxtRoleName"); T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; string StrRoleName = ""; StrRoleName = RoleName.Text; if (!string.IsNullOrEmpty(StrRoleName)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } //filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)";//类型名称 //filter += "ROLENAME ^@" + paras.Count().ToString();//类型名称 filter += " @" + paras.Count().ToString() + ".Contains(ROLENAME)"; paras.Add(StrRoleName); } //if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim())) //{ // //filter += "EMPLOYEECODE==@" + paras.Count().ToString(); // filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)"; // paras.Add(txtEmpCode.Text.Trim()); //} string systype = ""; if (dict != null) { systype = dict.DICTIONARYVALUE == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); } if (!string.IsNullOrEmpty(systype)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "SYSTEMTYPE ==@" + paras.Count().ToString();//类型名称 paras.Add(systype); } string sType = "", sValue = ""; if (string.IsNullOrEmpty(filter)) { //默认为自己公司的角色 filter += "OWNERCOMPANYID ==@" + paras.Count().ToString();//类型名称 paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //permClient.GetSysRoleInfosPagingByCompanyIDsAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo, null); permClient.GetRoleInfosByUserAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { string filter = ""; //查询过滤条件 int pageCount = 0; if (QueryBtn) { string StrState = ""; //状态 string StrStart = "";//添加文档的起始时间 string StrEnd = "";//添加文档的结束时间 ComboBox dpState = Utility.FindChildControl<ComboBox>(expander, "dpState"); switch (dpState.SelectedIndex) { case 0: StrState = ""; break; case 1: StrState = "1"; break; case 2: StrState = "0"; break; } DatePicker DtpStart = Utility.FindChildControl<DatePicker>(expander, "DtStart"); DatePicker DtpEnd = Utility.FindChildControl<DatePicker>(expander, "DtEnd"); StrStart = DtpStart.Text.Trim().ToString(); StrEnd = DtpEnd.Text.Trim().ToString(); if (StrState == "" && StrStart == "" && StrEnd == "") { Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("QUERYINFONOTNULL")); return; } DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL")); //return; DtStart = System.Convert.ToDateTime(StrStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE >@" + paras.Count().ToString(); paras.Add(DtStart); } if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL")); //return; DtEnd = System.Convert.ToDateTime(StrEnd); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE <@" + paras.Count().ToString(); paras.Add(DtEnd); } if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); //DtEnd = System.Convert.ToDateTime(StrEnd); DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59"); if (DtStart > DtEnd) { Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "userloginrecord.LOGINDATE >@" + paras.Count().ToString(); paras.Add(DtStart); filter += " and "; filter += "userloginrecord.LOGINDATE <@" + paras.Count().ToString(); paras.Add(DtEnd); } } } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; SysLoginHistoryClient.GetSysUserLoginHistoryRecordAllInfosPagingAsync(dataPager.PageIndex, dataPager.PageSize, "historyrecord.LOGINDATE", filter, paras, pageCount, loginUserInfo); }
private void LoadData() { ShowPageStyle(); string filter = ""; //查询过滤条件 string StrName = ""; int pageCount = 0; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 TextBox Name = Utility.FindChildControl<TextBox>(expander, "txtName"); StrName = Name.Text.Trim().ToString(); if (!string.IsNullOrEmpty(StrName)) { filter += "PERMISSIONNAME ^@" + paras.Count().ToString();//类型名称 paras.Add(StrName); } loadbar.Start(); SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; ServiceClient.GetSysPermissionAllPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo); }