private void LoadData() { loadbar.Start(); int pageCount = 0; string filter = ""; string strState = ""; if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) { strState = Checkstate; } System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) //{ // filter += "CHECKSTATE==@" + paras.Count().ToString(); // paras.Add(Convert.ToInt32(Checkstate).ToString()); //} TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName"); if (txtEmpName != null) { if (!string.IsNullOrEmpty(txtEmpName.Text)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } //filter += "T_HR_EMPLOYEE.EMPLOYEENAME==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(T_HR_EMPLOYEE.EMPLOYEECNAME)"; paras.Add(txtEmpName.Text.Trim()); } } //if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) // { // if (!string.IsNullOrEmpty(filter)) // { // filter += " and "; // } // filter += "CHECKSTATE==@" + paras.Count().ToString(); // paras.Add(Checkstate); // } client.EmployeeContractPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_EMPLOYEE.EMPLOYEECODE", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
private void LoadData() { loadbar.Start(); int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); TextBox txtName = Utility.FindChildControl <TextBox>(expander, "txtName"); if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim())) { filter += " @" + paras.Count().ToString() + ".Contains(SALARYSOLUTIONNAME)"; paras.Add(txtName.Text.Trim()); } client.GetSalarySolutionAssignPagingAsync(dataPager.PageIndex, dataPager.PageSize, "SALARYSOLUTIONASSIGNID", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
/// <summary> /// 触发绑定DataGrid事件 /// </summary> private void LoadData() { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); if (lkEmpName.DataContext != null) { SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ent = lkEmpName.DataContext as SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE; if (!string.IsNullOrEmpty(ent.EMPLOYEEID)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "EMPLOYEEID==@" + paras.Count().ToString(); paras.Add(ent.EMPLOYEEID); } } if (this.dpClockInRdStartDate.Text != null && this.dpClockInRdEndDate.Text != null) { //开始时间 DateTime startDate = DateTime.Parse(this.dpClockInRdStartDate.Text); //结束时间 DateTime endDate = DateTime.Parse(this.dpClockInRdEndDate.Text); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "STARTDATE >=@" + paras.Count().ToString(); paras.Add(startDate); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ENDDATE <=@" + paras.Count().ToString(); paras.Add(endDate); } clientAtt.EmployeeOverTimeRecordPagingAsync(dataPager.PageIndex, dataPager.PageSize, "STARTDATE", filter, paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); loadbar.Start(); }
private void InitControlEvent() { PARENT.Children.Add(loadbar); loadbar.Start(); ToolBar.btnNew.Click += new RoutedEventHandler(btnNew_Click); ToolBar.btnEdit.Click += new RoutedEventHandler(btnEdit_Click); ToolBar.btnDelete.Click += new RoutedEventHandler(btnDelete_Click); ToolBar.BtnView.Click += new RoutedEventHandler(BtnView_Click); ToolBar.cbxCheckState.Visibility = Visibility.Collapsed; ToolBar.txtCheckStateName.Visibility = Visibility.Collapsed; ToolBar.btnAudit.Visibility = Visibility.Collapsed; ToolBar.ShowRect(); client = new PersonnelServiceClient(); client.GetResumePagingCompleted += new EventHandler <GetResumePagingCompletedEventArgs>(client_GetResumePagingCompleted); client.ResumeDeleteCompleted += new EventHandler <ResumeDeleteCompletedEventArgs>(client_ResumeDeleteCompleted); }
/// <summary> /// 初始化事件 /// </summary> private void InitEvent() { client = new SmtOAPersonOfficeClient(); PARENT.Children.Add(loadbar); this.textTitle.IsEnabled = false; this.textContent.IsEnabled = false; if (actionType == FormTypes.New) // 新增 { this.SetToolBar(); } loadbar.Start(); client.GetDataByRequireIDAsync(requireID); client.GetDataByRequireIDCompleted += new EventHandler <GetDataByRequireIDCompletedEventArgs>(client_GetDataByRequireIDCompleted); client.GetAnswerCompleted += new EventHandler <GetAnswerCompletedEventArgs>(client_GetAnswerCompleted); client.EditRequireresultCompleted += new EventHandler <EditRequireresultCompletedEventArgs>(client_EditRequireresultCompleted); }
private void QueryData() { DateTime dtStart = new DateTime(); DateTime dtEnd = new DateTime(); int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new ObservableCollection <object>(); //参数值 // 开始时间 if (!string.IsNullOrEmpty(this.dateStart.Text.Trim())) { dtStart = Convert.ToDateTime(this.dateStart.Text); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CREATEDATE >= @" + paras.Count(); paras.Add(dtStart); } // 结束时间 if (!string.IsNullOrEmpty(this.dateEnd.Text.Trim())) { dtEnd = Convert.ToDateTime(this.dateEnd.Text); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CREATEDATE <= @" + paras.Count(); paras.Add(dtEnd); } if (!string.IsNullOrEmpty(this.dateStart.Text.Trim()) && !string.IsNullOrEmpty(this.dateEnd.Text.Trim())) { if (dtStart > dtEnd) { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("WARING"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Information); return; } } loadbar.Start(); client.GetEmployeeSurveysAsync(dataPager.PageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, Common.CurrentLoginUserInfo.EmployeeID, "2"); }
/// <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() { int pageCount = 0; string filter = ""; loadbar.Start(); System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); string strState = ""; TextBox txtName = Utility.FindChildControl <TextBox>(expander, "txtName"); if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim())) { filter += "ATTENDMACHINENAME==@" + paras.Count().ToString(); paras.Add(txtName.Text.Trim()); } client.GetAttendMachineSetPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
public void LoadData(string modeltype) { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); loadbar.Start(); if (tbmodetypevalue != null && !string.IsNullOrEmpty(tbmodetypevalue.Text.Trim())) { filter += "PARAMETERNAME==@" + paras.Count().ToString(); paras.Add(tbmodetypevalue.Text.Trim()); } if (filter != "") { filter += " and "; } filter += "MODELTYPE==@" + paras.Count().ToString(); paras.Add(modeltype); client.GetSystemParamSetPagingAsync(dataPager.PageIndex, dataPager.PageSize, "PARAMETERNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
public void EditData() { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); filter += "MODELTYPE==@" + paras.Count().ToString(); paras.Add("4"); filter += " and PARAMETERVALUE==@" + paras.Count().ToString(); paras.Add(SMT.SaaS.FrameworkUI.Common.Utility.Encrypt(oldpwd.Password)); filter += " and OWNERID==@" + paras.Count().ToString(); paras.Add(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); loadbar.Start(); client.GetSystemParamSetPagingAsync(1, 20, "PARAMETERNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
private void LoadData() { loadbar.Start(); //打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 T_SYS_DICTIONARY StrContractLevel = cbContractLevel.SelectedItem as T_SYS_DICTIONARY; //合同级别 if (!string.IsNullOrEmpty(txtSearchID.Text.Trim())) //合同编号 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "contractApp.contractApp.CONTRACTCODE ^@" + paras.Count().ToString(); paras.Add(txtSearchID.Text.Trim()); } if (!string.IsNullOrEmpty(txtSearchType.Text.Trim()))//标题 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "contractApp.contractApp.CONTRACTTITLE ^@" + paras.Count().ToString(); paras.Add(txtSearchType.Text.Trim()); } if (this.cbContractLevel.SelectedIndex > 0) //级别 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "contractApp.contractApp.CONTRACTLEVEL ^@" + paras.Count().ToString(); paras.Add(StrContractLevel.DICTIONARYVALUE.ToString()); } SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; caswsc.GetInquiryViewContractApplicationAsync(dpGrid.PageIndex, dpGrid.PageSize, "viewContract.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
/// <summary> /// 根据查询条件,调用WCF服务获取数据,以便加载数据列表 /// </summary> private void BindGrid() { string strAttendanceSolutionID = string.Empty, strAssignedObjectType = string.Empty, strSortKey = string.Empty, strOwnerID = string.Empty, strCheckState = string.Empty; int pageIndex = 0, pageSize = 0, pageCount = 0; strOwnerID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; strSortKey = " CREATEDATE "; CheckInputFilter(ref strAttendanceSolutionID, ref strAssignedObjectType, ref strCheckState); pageIndex = dataPager.PageIndex; pageSize = dataPager.PageSize; if (strCheckState == Convert.ToInt32(CheckStates.All).ToString()) { strCheckState = ""; } DateTime dtStart = dpStartDate.SelectedDate.HasValue ? dpStartDate.SelectedDate.Value : DateTime.MinValue; DateTime dtEnd = dpEndDate.SelectedDate.HasValue ? dpEndDate.SelectedDate.Value : DateTime.MinValue; clientAtt.GetAttendanceSolutionAsignRdListByMultSearchAsync(strOwnerID, strCheckState, strAttendanceSolutionID, strAssignedObjectType, strSortKey, dtStart, dtEnd, pageIndex, pageSize, pageCount); loadbar.Start(); }
/// <summary> /// 刷新抽查组列表 /// </summary> void LoadData() { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); TextBox txtRandomGroupName = Utility.FindChildControl <TextBox>(expander, "txtRandomGroupName"); if (!string.IsNullOrEmpty(txtRandomGroupName.Text.Trim())) { // filter += "RANDOMGROUPNAME==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(RANDOMGROUPNAME)"; paras.Add(txtRandomGroupName.Text.Trim()); } client.GetRandomGroupPagingAsync(dataPager.PageIndex, dataPager.PageSize, "RANDOMGROUPID", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); // 1s 冉龙军 loadbar.Start(); // 1e }
void organClient_GetAllPostViewCompleted(object sender, GetAllPostViewCompletedEventArgs e) { if (e.Error == null) { if (e.Result != null) { List <V_POST> vpostList = e.Result.ToList(); entlist = new List <T_HR_POST>(); foreach (var ent in vpostList) { T_HR_POST pt = new T_HR_POST(); pt.POSTID = ent.POSTID; pt.FATHERPOSTID = ent.FATHERPOSTID; pt.CHECKSTATE = ent.CHECKSTATE; pt.EDITSTATE = ent.EDITSTATE; pt.T_HR_POSTDICTIONARY = new T_HR_POSTDICTIONARY(); pt.T_HR_POSTDICTIONARY.POSTDICTIONARYID = Guid.NewGuid().ToString(); pt.T_HR_POSTDICTIONARY.POSTNAME = ent.POSTNAME; pt.T_HR_DEPARTMENT = new T_HR_DEPARTMENT(); pt.T_HR_DEPARTMENT = allDepartments.Where(s => s.DEPARTMENTID == ent.DEPARTMENTID).FirstOrDefault(); entlist.Add(pt); } if (App.Current.Resources["SYS_PostInfo"] != null) { App.Current.Resources.Remove("SYS_PostInfo"); App.Current.Resources.Add("SYS_PostInfo", entlist); } else { App.Current.Resources.Add("SYS_PostInfo", entlist); } } } //this.Loaded += new RoutedEventHandler(BusinessApplicationsForm_Loaded); loadbar.Start(); DetailSendClient.GetSendDocSingleInfoByIdAsync(TmpSendoc); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 //if (checkState != ((int)CheckStates.Approving).ToString()) //{ // filter += "archivesLending.OWNERID==@" + paras.Count().ToString(); //} //paras.Add(Common.CurrentLoginUserInfo.EmployeeID); if (!string.IsNullOrEmpty(txtSearchType.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "T_OA_ARCHIVES.RECORDTYPE ^@" + paras.Count().ToString(); paras.Add(txtSearchType.Text.Trim()); } if (!string.IsNullOrEmpty(txtSearchTitle.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "T_OA_ARCHIVES.ARCHIVESTITLE ^@" + paras.Count().ToString(); paras.Add(txtSearchTitle.Text.Trim()); } SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; if (string.IsNullOrEmpty(loginUserInfo.companyID)) { Utility.GetLoginUserInfo(loginUserInfo); } //GetLoginUserInfo(loginUserInfo); loadbar.Start(); client.GetLendingListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start(); //打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 T_SYS_DICTIONARY StrContractLevel = cbContractLevel.SelectedItem as T_SYS_DICTIONARY; //合同级别 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtContractTypeRoom.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CONTRACTTYPE ^@" + paras.Count().ToString();//类型名称 paras.Add(txtContractTypeRoom.Text.Trim()); } if (!string.IsNullOrEmpty(txtContractTypeMemo.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CONTENT ^@" + paras.Count().ToString(); paras.Add(txtContractTypeMemo.Text.Trim()); } if (this.cbContractLevel.SelectedIndex > 0) //级别 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CONTRACTLEVEL ^@" + paras.Count().ToString(); paras.Add(StrContractLevel.DICTIONARYVALUE.ToString()); } SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; ContractManagements.GetContractTypeInfoAsync(dpGrid.PageIndex, dpGrid.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo); }
private void LoadData() { loadbar.Start(); int pageCount = 0; string filter = ""; string strState = ""; ObservableCollection <object> paras = new ObservableCollection <object>(); if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) { strState = Checkstate; } TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName"); TextBox txtInsuranceName = Utility.FindChildControl <TextBox>(expander, "txtInsuranceName"); if (txtEmpName != null) { if (!string.IsNullOrEmpty(txtEmpName.Text.Trim())) { // filter += "EMPLOYEENAME==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(T_HR_EMPLOYEE.EMPLOYEECNAME)"; paras.Add(txtEmpName.Text.Trim()); } } if (txtInsuranceName != null) { if (!string.IsNullOrEmpty(txtInsuranceName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } // filter += "INSURANCENAME==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(INSURANCENAME)"; paras.Add(txtInsuranceName.Text.Trim()); } } client.EmployeeInsurancePagingAsync(dataPager.PageIndex, dataPager.PageSize, "INSURANCENAME", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
private void LoadData() { loadbar.Start(); int pageCount = 0; string filter = ""; string strState = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); //TextBox txtName = Utility.FindChildControl<TextBox>(expander, "txtName"); //if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim())) //{ // filter += " PERFORMANCECATEGORY==@" + paras.Count().ToString(); // paras.Add(txtName.Text.Trim()); //} if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) { strState = Checkstate; } client.GetPerformanceRewardSetWithPagingAsync(dataPager.PageIndex, dataPager.PageSize, "PERFORMANCEREWARDSETID", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState); }
private void btnExport_Click(object sender, RoutedEventArgs e) { // ispaging = false; dialog.Filter = "MS csv Files|*.xls"; dialog.FilterIndex = 1; result = dialog.ShowDialog(); if (result.Value == true) { string filter = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); if (sType == "Company") { filter += " OWNERCOMPANYID==@" + paras.Count().ToString(); paras.Add(sValue); } if (sType == "Department") { filter += " OWNERDEPARTMENTID==@" + paras.Count().ToString(); paras.Add(sValue); } if (sType == "Post") { filter += " OWNERPOSTID==@" + paras.Count().ToString(); paras.Add(sValue); } if (string.IsNullOrEmpty(sType)) { sType = "Company"; sValue = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; filter += " OWNERCOMPANYID==@" + paras.Count().ToString(); paras.Add(sValue); } loadbar.Start(); } }
/// <summary> /// 根据查询条件,调用WCF服务获取数据,以便加载数据列表 /// </summary> private void BindGrid() { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); string recorderDate = string.Empty; if (lkEmpName.DataContext != null) { SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ent = lkEmpName.DataContext as SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE; if (!string.IsNullOrEmpty(ent.EMPLOYEEID)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "EMPLOYEEID==@" + paras.Count().ToString(); paras.Add(ent.EMPLOYEEID); } } recorderDate = nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1"; if (DateTime.Parse(recorderDate) <= DateTime.Parse("1900-1-1")) { recorderDate = string.Empty; } if (toolbar1.cbxCheckState.SelectedItem != null) { T_SYS_DICTIONARY entDic = toolbar1.cbxCheckState.SelectedItem as T_SYS_DICTIONARY; Checkstate = entDic.DICTIONARYVALUE.ToString(); } clientAtt.EmployeeSignInRecordPagingAsync(dataPager.PageIndex, dataPager.PageSize, "SIGNINTIME", filter, paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, recorderDate); loadbar.Start(); }
private void LoadData() { string filter = ""; //查询过滤条件 string State = "1"; int pageCount = 0; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } // filter += filter += "STATE =@" + paras.Count().ToString(); paras.Add(State); if (QueryBtn) { string StrName = ""; //姓名 TextBox UserName = Utility.FindChildControl <TextBox>(expander, "txtSelect"); StrName = UserName.Text.Trim().ToString(); if (!string.IsNullOrEmpty(StrName)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CLIENTHOSTADDRESS =@" + paras.Count().ToString(); paras.Add(StrName); } } loadbar.Start(); SMT.Saas.Tools.UseractWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.UseractWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; SysUseract.GetSysUseractLogWithPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo); //SysUseract.GetSysUseractLogListAsync(); //SysUseract.CloseAsync(); //SysUseract.Abort(); // SysUserClient.GetSysUserAllInfosAsync(); }
private void LoadData() { loadbar.Start(); int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //LookUp txtEmpName = Utility.FindChildControl<LookUp>(expander, "lkEmployeeName"); TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmployeeName"); TextBox txtCardID = Utility.FindChildControl <TextBox>(expander, "txtCardID"); // T_HR_EMPLOYEE employee = txtEmpName.DataContext as T_HR_EMPLOYEE; if (txtEmpName != null) { if (!string.IsNullOrEmpty(txtEmpName.Text.Trim())) { // filter += "T_HR_EMPLOYEE.EMPLOYEECNAME==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(T_HR_EMPLOYEE.EMPLOYEECNAME)"; paras.Add(txtEmpName.Text.Trim()); } } if (txtCardID != null) { if (!string.IsNullOrEmpty(txtCardID.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } // filter += "CARDID==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(CARDID)"; paras.Add(txtCardID.Text.Trim()); } } client.PensionMasterPagingAsync(dataPager.PageIndex, dataPager.PageSize, "COMPUTERNO", filter, paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }
// 1e /// <summary> /// 刷新绩效考核列表 /// </summary> void LoadData() { int pageCount = 0; string filter = "", sType = "", sValue = ""; bool isSelf = false; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); // 1s 冉龙军 string strState = ""; if (Checkstate != Convert.ToInt32(CheckStates.All).ToString()) { strState = Checkstate; } //if (!string.IsNullOrEmpty(strState)) //{ // if (!string.IsNullOrEmpty(filter)) // { // filter += " AND"; // } // filter += " CHECKSTATE == @" + paras.Count(); // paras.Add(strState); //} // 1e if (myDetail) { isSelf = true; } sType = treeOrganization.sType; sValue = treeOrganization.sValue; SumPerformanceList.Clear(); client.GetSumPerformancePagingAsync(dataPager.PageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, isSelf, strState); loadbar.Start(); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtLicenseName.Text.Trim())) { filter += "T_OA_LICENSEMASTER.LICENSENAME ^@" + paras.Count().ToString(); paras.Add(txtLicenseName.Text.Trim()); } if (!string.IsNullOrEmpty(txtContent.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "CONTENT ^@" + paras.Count().ToString(); paras.Add(txtContent.Text.Trim()); } //if (CBLendState.SelectedIndex > 0) //{ // if (CBLendState.SelectedIndex == 1) // { // lendFlag = "0"; // } // if (CBLendState.SelectedIndex == 2) // { // lendFlag = "1"; // } //} SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOADocumentAdminService.LoginUserInfo(); loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loadbar.Start(); client.GetBorrowAppListAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, lendFlag, loginUserInfo); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtSearchType.Text.Trim())) { filter += "RECORDTYPE ^@" + paras.Count().ToString(); paras.Add(txtSearchType.Text.Trim()); } if (!string.IsNullOrEmpty(txtSearchTitle.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ARCHIVESTITLE ^@" + paras.Count().ToString(); paras.Add(txtSearchTitle.Text.Trim()); } loadbar.Start(); client.GetArchivesAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, Common.CurrentLoginUserInfo.EmployeeID); }
/// <summary> /// 刷新抽查组列表 /// </summary> void LoadData() { int pageCount = 0; string filter = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); filter = " COMPANYID =@" + paras.Count().ToString(); paras.Add(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtMoudleName"); if (!string.IsNullOrEmpty(txtEmpName.Text)) { filter += " and "; filter += " FLOW_MODELDEFINE_T.DESCRIPTION==@" + paras.Count().ToString(); paras.Add(txtEmpName.Text); } // fClient.GetModelFlowRelationInfosListBySearchAsync(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID, "");//(dataPager.PageIndex, dataPager.PageSize, "RANDOMGROUPID", filter, paras, pageCount); fClient.GetModelFlowRelationInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount); // 1s 冉龙军 loadbar.Start(); // 1e }
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); }
private void InitData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (Common.CurrentLoginUserInfo != null) { if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID)) { filter += "(distrbuteObj.VIEWER =@" + paras.Count().ToString(); paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID)) { if (!string.IsNullOrEmpty(filter)) { filter += " or "; } filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString(); paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID); } if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].PostID)) { if (!string.IsNullOrEmpty(filter)) { filter += " or "; } filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString(); paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].PostID); } if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.EmployeeID)) { if (!string.IsNullOrEmpty(filter)) { filter += " or "; } filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString() + ")"; paras.Add(Common.CurrentLoginUserInfo.EmployeeID); } } if (!string.IsNullOrEmpty(txtUptown.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "houseInfoObj.COMMUNITY ^@" + paras.Count().ToString(); paras.Add(txtUptown.Text.Trim()); } if (!string.IsNullOrEmpty(txtHouseName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "houseInfoObj.HOUSENAME ^@" + paras.Count().ToString(); paras.Add(txtHouseName.Text.Trim()); } loadbar.Start(); SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID; //if (string.IsNullOrEmpty(loginUserInfo.companyID)) //{ // Utility.GetLoginUserInfo(loginUserInfo); //} client.GetMemberHireHouseAppListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "houselistObj.CREATEDATE", filter, paras, pageCount, loginUserInfo); }
public void Save() { loadbar.Start(); if (!SMT.SaaS.FrameworkUI.Common.Utility.CheckDataIsValid(Group1)) { loadbar.Stop(); return; } if (string.IsNullOrEmpty(lkPost.TxtLookUp.Text)) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "POST")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "POST"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); loadbar.Stop(); return; } if (cbxPostLevel.SelectedItem == null) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "POST")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "POSTLEVEL"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); loadbar.Stop(); return; } if (string.IsNullOrEmpty(dpEntryDate.Text)) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "ENTRYDATE")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "ENTRYDATE"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); loadbar.Stop(); return; } if (string.IsNullOrEmpty(dpOnPostDate.Text)) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "ONPOSTDATE")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "ONPOSTDATE"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); loadbar.Stop(); return; } if (txtUser.Text == "") { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "USERNAME")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "USERNAME"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); loadbar.Stop(); return; } if (!string.IsNullOrEmpty(txtRemarks.Text)) { if (!string.IsNullOrEmpty(EmployeeEntry.REMARK)) { EmployeeEntry.REMARK += "Ё" + txtRemarks.Text; } else { EmployeeEntry.REMARK = txtRemarks.Text; } } SysUser.USERNAME = txtUser.Text.Trim(); //SysUser.PASSWORD = SMT.SaaS.FrameworkUI.Common.Utility.Encrypt(txtPwd.Password.Trim()); //改密码的时候作判断 // SysUser.PASSWORD = txtPwd.Password.Trim(); SysUser.REMARK = txtMark.Text; SysUser.EMPLOYEEID = Employee.EMPLOYEEID; SysUser.EMPLOYEECODE = Employee.EMPLOYEECODE; SysUser.EMPLOYEENAME = Employee.EMPLOYEECNAME; SysUser.OWNERID = Employee.EMPLOYEEID; SysUser.ISMANGER = 0; SysUser.OWNERPOSTID = Employee.OWNERPOSTID; SysUser.OWNERDEPARTMENTID = Employee.OWNERDEPARTMENTID; SysUser.OWNERCOMPANYID = Employee.OWNERCOMPANYID; EmployeePost.POSTLEVEL = (cbxPostLevel.SelectedItem as T_SYS_DICTIONARY).DICTIONARYVALUE; #region // Employee.EMPLOYEECODE = CreateCode(); //检查系统用户名是否重复 //if (employeeType == 0) //{ // perclient.IsExistSysUserInfoAsync(SysUser.USERNAME); //} //else //{ // string strMsg = ""; // EmployeeEntry.REMARK = "离职未满6个月"; // perclient.SysUserInfoAddORUpdateAsync(SysUser, strMsg); //} #endregion //添加系统用户名 string strMsg = ""; if (txtPwd.Password != null && CheckPwd(txtPwd.Password.Trim())) { SysUser.PASSWORD = SMT.SaaS.FrameworkUI.Common.Utility.Encrypt(txtPwd.Password.Trim()); perclient.SysUserInfoAddORUpdateAsync(SysUser, strMsg); canSave = true; } else { canSave = false; loadbar.Stop(); } }
/// <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); }