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())) //合同编号 { 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) //级别 { 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.GetInquiryContractPrintingRecordAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.contractApp.CREATEDATE", filter, paras, pageCount, loginUserInfo); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtOrgCode.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ORGCODE ^@" + paras.Count().ToString(); paras.Add(txtOrgCode.Text.Trim()); } if (!string.IsNullOrEmpty(txtOrgName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ORGNAME ^@" + paras.Count().ToString(); paras.Add(txtOrgName.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; loadbar.Start(); client.GetOrganListAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo); }
private void BindData() { string StrLicens = ""; StrLicens = this.txtLICENSENAME.Text.ToString().Trim(); int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 //filter += "licenseUser.CREATEUSERID==@" + paras.Count().ToString(); //paras.Add(Common.CurrentLoginUserInfo.EmployeeID); if (!string.IsNullOrEmpty(StrLicens)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "LICENSENAME ^@" + paras.Count().ToString(); paras.Add(StrLicens); } 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; client.GetLookupOjbectsAsync(EntityName, ColumnNames, dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo.userID); }
private void LoadData() { loadbar.Start(); //打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtProvisionName.Text.Trim())) //福利发放名 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.WELFAREDISTRIBUTETITLE ^@" + paras.Count().ToString(); paras.Add(txtProvisionName.Text.Trim()); } if (!string.IsNullOrEmpty(txtProvisionContent.Text.Trim()))//发放内容 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.CONTENT ^@" + paras.Count().ToString(); paras.Add(txtProvisionContent.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; BenefitsAdministration.GetWelfarePaymentWithdrawalAsync(dpGrid.PageIndex, dpGrid.PageSize, "beingWithdrawn.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 //filter += "licenseUser.CREATEUSERID==@" + paras.Count().ToString(); //paras.Add(Common.CurrentLoginUserInfo.EmployeeID); if (!string.IsNullOrEmpty(txtLicenseName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } 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()); } 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; loadbar.Start(); client.GetLicenseBorrowListAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 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; int pageCount = 0; BenefitsAdministration.GetWelfarePSelectRecordAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareProvision.CHECKSTATE", null, pageCount, checkState); }
private void LoadData() { loadbar.Start();//打开转动动画 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; int pageCount = 0; caswsc.GetInquiryContractPrintingRecordInfoAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.contractApp.CREATEDATE", "", null, pageCount, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 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; int pageCount = 0; //string filter = ""; //查询过滤条件 //ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 //filter += "contractApp.CONTRACTAPPID ^@" + paras.Count().ToString(); //paras.Add(ctapp.contractApp.CONTRACTAPPID); caswsc.GetApprovalListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.CHECKSTATE", "", null, 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() { 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() { 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();//打开转动动画 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; int pageCount = 0; BenefitsAdministration.GetWelfarePSelectRecordAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareProvision.CHECKSTATE",null, pageCount, checkState); }
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())) //合同编号 { 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) //级别 { 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.GetInquiryContractPrintingRecordAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.contractApp.CREATEDATE", filter, paras, pageCount, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 string StrStart = ""; string StrEnd = ""; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 if (!string.IsNullOrEmpty(txtProvisionName.Text.Trim()))//福利发放名 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.WELFAREDISTRIBUTETITLE ^@" + paras.Count().ToString(); paras.Add(txtProvisionName.Text.Trim()); } StrStart = ReleaseTime.Text.ToString(); StrEnd = ReleaseEndTime.Text.ToString(); DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); DtEnd = System.Convert.ToDateTime(StrEnd); if (DtStart > DtEnd) { Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE >=@" + paras.Count().ToString(); paras.Add(DtStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE <=@" + paras.Count().ToString(); paras.Add(DtEnd); } } else { //开始时间不为空 结束时间为空 if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE <=@" + paras.Count().ToString(); paras.Add(DtStart); } //结束时间不为空 if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE >=@" + paras.Count().ToString(); paras.Add(DtEnd); } } 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; BenefitsAdministration.GetWelfareProvisionListByUserIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareProvision.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 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; int pageCount = 0; //string filter = ""; //查询过滤条件 //ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 //filter += "contractApp.CONTRACTAPPID ^@" + paras.Count().ToString(); //paras.Add(ctapp.contractApp.CONTRACTAPPID); caswsc.GetApprovalListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.CHECKSTATE", "", null, pageCount, checkState, loginUserInfo); }
private void LoadData() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 //filter += "licenseUser.CREATEUSERID==@" + paras.Count().ToString(); //paras.Add(Common.CurrentLoginUserInfo.EmployeeID); if (!string.IsNullOrEmpty(txtLicenseName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } 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()); } 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; loadbar.Start(); client.GetLicenseBorrowListAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start(); //打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 string StrStart = ""; string StrEnd = ""; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 if (!string.IsNullOrEmpty(txtProvisionName.Text.Trim())) //福利发放名 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.WELFAREDISTRIBUTETITLE ^@" + paras.Count().ToString(); paras.Add(txtProvisionName.Text.Trim()); } StrStart = ReleaseTime.Text.ToString(); StrEnd = ReleaseEndTime.Text.ToString(); DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); DtEnd = System.Convert.ToDateTime(StrEnd); if (DtStart > DtEnd) { Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE >=@" + paras.Count().ToString(); paras.Add(DtStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE <=@" + paras.Count().ToString(); paras.Add(DtEnd); } } else { //开始时间不为空 结束时间为空 if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE <=@" + paras.Count().ToString(); paras.Add(DtStart); } //结束时间不为空 if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.DISTRIBUTEDATE >=@" + paras.Count().ToString(); paras.Add(DtEnd); } } 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; BenefitsAdministration.GetWelfareProvisionListByUserIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareProvision.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start(); //打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 string StrStart = ""; string StrEnd = ""; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 T_SYS_DICTIONARY StrWelfareId = cbWelfareID.SelectedItem as T_SYS_DICTIONARY; //从字典里查询福利名称 if (this.cbWelfareID.SelectedIndex >= 0) //福利名称 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.WELFAREPROID ^@" + paras.Count().ToString(); paras.Add(StrWelfareId.DICTIONARYVALUE.ToString()); } StrStart = ReleaseTime.Text.ToString(); StrEnd = ReleaseEndTime.Text.ToString(); DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); DtEnd = System.Convert.ToDateTime(StrEnd); if (DtStart > DtEnd) { Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE >=@" + paras.Count().ToString(); paras.Add(DtStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE <=@" + paras.Count().ToString(); paras.Add(DtEnd); } } else { //开始时间不为空 结束时间为空 if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE <=@" + paras.Count().ToString(); paras.Add(DtStart); } //结束时间不为空 if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE >=@" + paras.Count().ToString(); paras.Add(DtEnd); } } 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; wssc.GetWelfareListByUserIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareStandard.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 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; int pageCount = 0; caswsc.GetInquiryContractPrintingRecordInfoAsync(dpGrid.PageIndex, dpGrid.PageSize, "contractApp.contractApp.CREATEDATE", "", null, pageCount, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 string StrStart = ""; string StrEnd = ""; ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();//参数值 T_SYS_DICTIONARY StrWelfareId = cbWelfareID.SelectedItem as T_SYS_DICTIONARY;//从字典里查询福利名称 if (this.cbWelfareID.SelectedIndex >= 0) //福利名称 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.WELFAREPROID ^@" + paras.Count().ToString(); paras.Add(StrWelfareId.DICTIONARYVALUE.ToString()); } StrStart = ReleaseTime.Text.ToString(); StrEnd = ReleaseEndTime.Text.ToString(); DateTime DtStart = new DateTime(); DateTime DtEnd = new DateTime(); if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { DtStart = System.Convert.ToDateTime(StrStart); DtEnd = System.Convert.ToDateTime(StrEnd); if (DtStart > DtEnd) { Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME")); return; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE >=@" + paras.Count().ToString(); paras.Add(DtStart); if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE <=@" + paras.Count().ToString(); paras.Add(DtEnd); } } else { //开始时间不为空 结束时间为空 if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE <=@" + paras.Count().ToString(); paras.Add(DtStart); } //结束时间不为空 if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareStandard.STARTDATE >=@" + paras.Count().ToString(); paras.Add(DtEnd); } } 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; wssc.GetWelfareListByUserIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "welfareStandard.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void LoadData() { loadbar.Start();//打开转动动画 int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 if (!string.IsNullOrEmpty(txtProvisionName.Text.Trim()))//福利发放名 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.WELFAREDISTRIBUTETITLE ^@" + paras.Count().ToString(); paras.Add(txtProvisionName.Text.Trim()); } if (!string.IsNullOrEmpty(txtProvisionContent.Text.Trim()))//发放内容 { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "welfareProvision.CONTENT ^@" + paras.Count().ToString(); paras.Add(txtProvisionContent.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; BenefitsAdministration.GetWelfarePaymentWithdrawalAsync(dpGrid.PageIndex, dpGrid.PageSize, "beingWithdrawn.CHECKSTATE", filter, paras, pageCount, checkState, loginUserInfo); }
private void BindData() { string StrLicens = ""; StrLicens = this.txtLICENSENAME.Text.ToString().Trim(); int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 //filter += "licenseUser.CREATEUSERID==@" + paras.Count().ToString(); //paras.Add(Common.CurrentLoginUserInfo.EmployeeID); if (!string.IsNullOrEmpty(StrLicens)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "LICENSENAME ^@" + paras.Count().ToString(); paras.Add(StrLicens); } 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; client.GetLookupOjbectsAsync(EntityName, ColumnNames, dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo.userID); }
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() { int pageCount = 0; string filter = ""; //查询过滤条件 ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值 if (!string.IsNullOrEmpty(txtOrgCode.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ORGCODE ^@" + paras.Count().ToString(); paras.Add(txtOrgCode.Text.Trim()); } if (!string.IsNullOrEmpty(txtOrgName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ORGNAME ^@" + paras.Count().ToString(); paras.Add(txtOrgName.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; loadbar.Start(); client.GetOrganListAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo); }