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);
}
