void LoadPerFormace()
{
TextBox txtCname = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
TextBox txtCode = Utility.FindChildControl <TextBox>(expander, "txtEmpCode");
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
if (!string.IsNullOrEmpty(txtCname.Text))
{
filter = " EMPLOYEECNAME==@" + paras.Count();
paras.Add(txtCname.Text);
}
if (!string.IsNullOrEmpty(txtCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " EMPLOYEECODE==@" + paras.Count();
paras.Add(txtCode.Text);
}
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " T_HR_PERFORMANCERECORD.T_HR_SUMPERFORMANCERECORD.SUMID==@" + paras.Count();
paras.Add(SumPerformance.SUMID);
client.GetPerformanceEmployeeAllPagingAsync(dataPagerPerformance.PageIndex, dataPagerPerformance.PageSize, "EMPLOYEECNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
//TextBox txtOrgCode = Utility.FindChildControl<TextBox>(controlsToolkitTUV, "txtOrgCode");
//TextBox txtLicenseName = Utility.FindChildControl<TextBox>(controlsToolkitTUV, "txtLicenseName");
if (!string.IsNullOrEmpty(txtOrgCode.Text.Trim()))
{
filter += "T_OA_ORGANIZATION.ORGCODE ==@" + paras.Count().ToString();
paras.Add(txtOrgCode.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLicenseName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "LICENSENAME ==@" + paras.Count().ToString();
paras.Add(txtLicenseName.Text);
}
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "ISVALID==@" + paras.Count().ToString();
paras.Add("1");
loadbar.Start();
client.GetLicenseListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, 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");
TextBox txtBlackIdCard = Utility.FindChildControl <TextBox>(expander, "txtBlackIdCard");
if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim()))
{
// filter += "NAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(NAME)";
paras.Add(txtName.Text.Trim());
}
if (txtBlackIdCard != null && !string.IsNullOrEmpty(txtBlackIdCard.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "IDCARDNUMBER==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(IDCARDNUMBER)";
paras.Add(txtBlackIdCard.Text.Trim());
}
client.GetBlackListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "NAME", 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>(); //参数值
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()
{
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>(); //参数值
//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()
{
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
filter += "CHECKSTATE==@" + paras.Count().ToString();
// paras.Add(Checkstate);
paras.Add(Convert.ToInt32(CheckStates.Approved).ToString());
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "EMPLOYEENAME==@" + paras.Count().ToString();
paras.Add(txtEmpName.Text.Trim());
}
client.EmployeeEvectionReportPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECODE", filter, paras, pageCount);
loadbar.Start();
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
// filter += "T_HR_EMPLOYEE.EMPLOYEECNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
if (!string.IsNullOrEmpty(txtEmpCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)";
paras.Add(txtEmpCode.Text.Trim());
}
string sType = treeOrganization.sType, sValue = treeOrganization.sValue;
client.GetEmployeeViewsPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECNAME", filter,
paras, pageCount, sType, sValue, 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>(); //参数值
if (!string.IsNullOrEmpty(txtSYSTEMCODE.Text.Trim())) //系统类型
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SYSCODE ^@" + paras.Count().ToString();
paras.Add(txtSYSTEMCODE.Text.Trim());
}
if (!string.IsNullOrEmpty(txtAGENTMODULE.Text.Trim()))//代理模块
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MODELCODE ^@" + paras.Count().ToString();
paras.Add(txtAGENTMODULE.Text.Trim());
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
SoaChannel.GetAgentSetListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "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(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());
}
loadbar.Start();
client.GetReturnListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, Common.CurrentLoginUserInfo.EmployeeID);
}
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 LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
TextBox txtDepID = Utility.FindChildControl <TextBox>(expander, "txtDepCode");
if (txtDepID != null)
{
if (!string.IsNullOrEmpty(txtDepID.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "DEPARTMENTCODE==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(DEPARTMENTCODE)";
paras.Add(txtDepID.Text.Trim());
}
}
TextBox txtDepName = Utility.FindChildControl <TextBox>(expander, "txtDepName");
if (txtDepName != null)
{
if (!string.IsNullOrEmpty(txtDepName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
// filter += "DEPARTMENTNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(DEPARTMENTNAME)";
paras.Add(txtDepName.Text.Trim());
}
}
ComboBox txtDepType = Utility.FindChildControl <ComboBox>(expander, "cbxDepType");
if (txtDepType != null)
{
if (txtDepType.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty((txtDepType.SelectedItem as T_SYS_DICTIONARY).DICTIONARYID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "DEPARTMENTTYPE==@" + paras.Count().ToString();
// paras.Add(txtDepType.SelectedValue.Trim());
paras.Add((txtDepType.SelectedItem as T_SYS_DICTIONARY).DICTIONARYVALUE.ToString());
}
}
}
svc.DepartmentDictionaryPagingAsync(dataPager.PageIndex, dataPager.PageSize, "DEPARTMENTCODE", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, Checkstate);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
string strState = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
//根据部门过滤
ComboBox cbxDepName = Utility.FindChildControl <ComboBox>(expander, "cbxDepName");
if (cbxDepName != null)
{
if (cbxDepName.SelectedIndex > 0)
{
T_HR_DEPARTMENT temp = cbxDepName.SelectedItem as T_HR_DEPARTMENT;
filter += "T_HR_DEPARTMENT.DEPARTMENTID==@" + paras.Count().ToString();
paras.Add(temp.DEPARTMENTID);
}
}
//根据公司过滤
ComboBox cbxCpyName = Utility.FindChildControl <ComboBox>(expander, "cbxCpyName");
if (cbxCpyName != null)
{
if (cbxCpyName.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
T_HR_COMPANY temp = cbxCpyName.SelectedItem as T_HR_COMPANY;
filter += " T_HR_DEPARTMENT.T_HR_COMPANY.COMPANYID==@" + paras.Count().ToString();
paras.Add(temp.COMPANYID);
}
}
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "T_HR_POSTDICTIONARY.POSTNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(T_HR_POSTDICTIONARY.POSTNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
client.PostPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_DEPARTMENT.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME",
filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
TextBox txtPostCode = Utility.FindChildControl <TextBox>(expander, "txtPostCode");
if (txtPostCode != null)
{
if (!string.IsNullOrEmpty(txtPostCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "POSTCODE==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(POSTCODE)";
paras.Add(txtPostCode.Text.Trim());
}
}
TextBox txtPostName = Utility.FindChildControl <TextBox>(expander, "txtPostName");
if (txtPostName != null)
{
if (!string.IsNullOrEmpty(txtPostName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(POSTNAME)";
paras.Add(txtPostName.Text.Trim());
}
}
//ComboBox cbxDepName = Utility.FindChildControl<ComboBox>(expander, "cbxDepName");
AutoCompleteComboBox acbDepName = Utility.FindChildControl <AutoCompleteComboBox>(expander, "acbDepName");
if (acbDepName != null)
{
if (acbDepName.SelectedItem != null)
{
T_HR_DEPARTMENTDICTIONARY ent = acbDepName.SelectedItem as T_HR_DEPARTMENTDICTIONARY;
if (!string.IsNullOrEmpty(ent.DEPARTMENTDICTIONARYID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_HR_DEPARTMENTDICTIONARY.DEPARTMENTDICTIONARYID==@" + paras.Count().ToString();
paras.Add(ent.DEPARTMENTDICTIONARYID);
}
}
}
client.PostDictionaryPagingAsync(dataPager.PageIndex, dataPager.PageSize, "POSTCODE", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, Checkstate);
}
void LoadData()
{
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
if (StrCompanyIDsList.Count() > 0)
{
StrCompanyIDsList.ForEach(item =>
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
else
{
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
});
}
DateTime dtLandStart = new DateTime();
DateTime dtLandEnd = new DateTime();
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandStart);
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value + "-1", out dtLandEnd);
dtLandEnd = dtLandEnd.AddMonths(1);
loadbar.Start();
if (string.IsNullOrEmpty(ReportsType))
{
personClient.GetEmployeeBasicInfosByCompanyAsync(StrCompanyIDsList, "COMPANYNAME,DEPARTMENTNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, dtLandStart, dtLandEnd);
}
else
{
loadbar.Stop();
}
//switch (ReportsType)
//{
// case "1":
// break;
// case "2":
// //personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, System.DateTime.Now);
// personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
// break;
// case "3":
// personClient.ExportEmployeeCollectsReportsAsync("", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
// break;
// default:
// personClient.GetEmployeeBasicInfosByCompanyAsync(StrCompanyIDsList, "COMPANYNAME,DEPARTMENTNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, dtLandStart, dtLandEnd);
// //personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType);
// break;
//}
}
private void LoadData()
{
loadbar.Start(); //打开转动动画
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (!string.IsNullOrEmpty(txtNoClaims.Text.Trim())) //报销单号
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "NoClaims =@" + paras.Count().ToString();
paras.Add(txtNoClaims.Text.Trim());
}
if (!string.IsNullOrEmpty(SearchUserID))//出差人
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "Travelmanagement.OWNERID =@" + paras.Count().ToString();
paras.Add(SearchUserID);
}
//if (!string.IsNullOrEmpty(postId))//岗位ID
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "Travelmanagement.OWNERPOSTID =@" + paras.Count().ToString();
// paras.Add(postId);
//}
if (!string.IsNullOrEmpty(StartTime.Text.Trim()))//开始时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "Travelmanagement.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DateTime.Parse(StartTime.Text.Trim()));
}
if (!string.IsNullOrEmpty(EndTime.Text.Trim()))//结束时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "Travelmanagement.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DateTime.Parse(EndTime.Text.Trim()));
}
SMT.SaaS.OA.UI.SmtOAPersonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOAPersonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
Travelmanagement.GetTravelmanagementListByUserIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "Travelmanagement.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
TextBox txtEmpCode = Utility.FindChildControl <TextBox>(expander, "txtEmpCode");
if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim()))
{
//filter += "EMPLOYEECODE==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)";
paras.Add(txtEmpCode.Text.Trim());
}
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
string sType = "", sValue = "";
TreeViewItem selectedItem = treeOrganization.SelectedItem as TreeViewItem;
if (selectedItem != null)
{
string IsTag = selectedItem.Tag.ToString();
switch (IsTag)
{
case "Company":
OrganizationWS.T_HR_COMPANY company = selectedItem.DataContext as OrganizationWS.T_HR_COMPANY;
sType = "Company";
sValue = company.COMPANYID;
break;
case "Department":
OrganizationWS.T_HR_DEPARTMENT department = selectedItem.DataContext as OrganizationWS.T_HR_DEPARTMENT;
sType = "Department";
sValue = department.DEPARTMENTID;
break;
case "Post":
OrganizationWS.T_HR_POST post = selectedItem.DataContext as OrganizationWS.T_HR_POST;
sType = "Post";
sValue = post.POSTID;
break;
}
}
// client.GetEmployeeViewsActivedPagingAsync(dataPager.PageIndex, dataPager.PageSize,"EMPLOYEECNAME", filter, paras, pageCount, sType, sValue,SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
client.GetEmployeeViewsPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECNAME", filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadFristData()
{
loadbar.Start();
int pageCount = 0;
itemsAll.Clear();
string filter = "";
int sType = 0;
string sValue = "";
list = null;
DateTime?starttimes;
DateTime?endtimes = DateTime.Now.Date;
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
string strState = Convert.ToInt32(CheckStates.Approved).ToString();
int year, month;
year = DateTime.Now.Year;
month = DateTime.Now.Month - 1;
if (DateTime.Now.Month <= 1)
{
year = DateTime.Now.Year - 1;
month = 12;
}
starttimes = new DateTime(year, month, 1);
endtimes = new DateTime(year, month, DateTime.DaysInMonth(year, month));
sType = 0;
sValue = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
filter += " EMPLOYEENAME.Contains(@" + paras.Count().ToString() + ")";
paras.Add(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName);
if (!string.IsNullOrEmpty(userID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " PAYCONFIRM==@" + paras.Count().ToString();
paras.Add("2");
}
if (!string.IsNullOrEmpty(userID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "EMPLOYEEID==@" + paras.Count().ToString();
//paras.Add(userID);
//filter += " OR EMPLOYEEID==@" + paras.Count().ToString();
//paras.Add(userID);
//filter += " AND PAYCONFIRM==@" + paras.Count().ToString();
filter += " OWNERID==@" + paras.Count().ToString();
paras.Add(userID);
}
client.GetMenuSignAutoEmployeeSalaryRecordPagingsAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEESALARYRECORDID", filter, paras, pageCount, Convert.ToDateTime(starttimes), Convert.ToDateTime(endtimes), sType, sValue, strState, userID, "PAYSALARYHISTORY");
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
TextBox txtDepID = Utility.FindChildControl<TextBox>(expander, "txtDepCode");
if (txtDepID != null)
{
if (!string.IsNullOrEmpty(txtDepID.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "DEPARTMENTCODE==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(DEPARTMENTCODE)";
paras.Add(txtDepID.Text.Trim());
}
}
TextBox txtDepName = Utility.FindChildControl<TextBox>(expander, "txtDepName");
if (txtDepName != null)
{
if (!string.IsNullOrEmpty(txtDepName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
// filter += "DEPARTMENTNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(DEPARTMENTNAME)";
paras.Add(txtDepName.Text.Trim());
}
}
ComboBox txtDepType = Utility.FindChildControl<ComboBox>(expander, "cbxDepType");
if (txtDepType != null)
{
if (txtDepType.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty((txtDepType.SelectedItem as T_SYS_DICTIONARY).DICTIONARYID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "DEPARTMENTTYPE==@" + paras.Count().ToString();
// paras.Add(txtDepType.SelectedValue.Trim());
paras.Add((txtDepType.SelectedItem as T_SYS_DICTIONARY).DICTIONARYVALUE.ToString());
}
}
}
svc.DepartmentDictionaryPagingAsync(dataPager.PageIndex, dataPager.PageSize, "DEPARTMENTCODE", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, Checkstate);
}
public void Save()
{
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
filter += "MUSTSELECTED==@" + paras.Count().ToString();
paras.Add("1");
filter += " and CREATECOMPANYID==@" + paras.Count().ToString();
paras.Add(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
client.SalarySolutionItemsAddAsync(filter, paras, savesid, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
FormType = FormTypes.Edit;
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
// ispaging = false;
dialog.DefaultExt = ".xls";
dialog.Filter = "MS Excel 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 (StrCompanyIDsList.Count() > 0)
{
StrCompanyIDsList.ForEach(item =>
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
else
{
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
});
}
DateTime dtLandStart = new DateTime();
DateTime dtLandEnd = new DateTime();
//选定月的 1号
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandStart);
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandEnd);
//选定的月份加1个月的1号
dtLandEnd = dtLandEnd.AddMonths(1);
loadbar.Start();
if (ListInfos.Count() > 0)
{
personClient.ExportEmployeePostChangeNoqueryReportAsync(StrCompanyIDsList, ListInfos, dtLandStart);
}
else
{
personClient.EmployeePostReportInfosAsync(StrCompanyIDsList, "COMPANYNAME,DEPARTMENTNAME",
filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, dtLandStart, dtLandEnd);
}
}
}
void LoadMeetingTypeTemplateInfos()
{
string filter = ""; //查询过滤条件
int pageCount = 0;
string StrMeetingType = "";
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQueryBtn)
{
if (!string.IsNullOrEmpty(txtTemplateName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "TEMPLATENAME ^@" + paras.Count().ToString();
paras.Add(txtTemplateName.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 (cbMeetingType.SelectedItem != null && cbMeetingType.SelectedIndex != 0)
{
StrMeetingType = ((cbMeetingType.SelectedItem) as T_OA_MEETINGTYPE).MEETINGTYPE;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_OA_MEETINGTYPE.MEETINGTYPE ==@" + paras.Count().ToString();
paras.Add(StrMeetingType);
}
IsQueryBtn = false;
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetTypeTemplateInfosAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
string strState = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
//ComboBox cbxCompanyName = Utility.FindChildControl<ComboBox>(expander, "cbxCompanyName");
AutoCompleteComboBox acbCompanyName = Utility.FindChildControl <AutoCompleteComboBox>(expander, "acbCompanyName");
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (acbCompanyName != null)
{
if (acbCompanyName.SelectedItem != null)
{
T_HR_COMPANY ent = acbCompanyName.SelectedItem as T_HR_COMPANY;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_HR_COMPANY.CNAME==@" + paras.Count().ToString();
paras.Add(ent.CNAME);
}
}
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
// filter += "T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME.Contains(@" + paras.Count().ToString()+")";
filter += " @" + paras.Count().ToString() + ".Contains(T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
client.DepartmentPagingAsync(dataPager.PageIndex, dataPager.PageSize, "SORTINDEX", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState);
}
private void LoadData()
{
int pageCount = 0;
string filter = "";
loadbar.Start();
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
string strState = "";
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
TextBox txtName = Utility.FindChildControl <TextBox>(expander, "txtName");
if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim()))
{
//filter += "GUERDONNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(GUERDONNAME)";
paras.Add(txtName.Text.Trim());
}
//if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CHECKSTATE==@" + paras.Count().ToString();
// paras.Add(Checkstate);
//}
client.GetCustomGuerdonSetPagingAsync(dataPager.PageIndex, dataPager.PageSize, "GUERDONNAME", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
string sType = "", sValue = "";
sType = treeOrganization.sType;
sValue = treeOrganization.sValue;
client.GetContactsListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECNAME",
filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
// filter += "EMPLOYEENAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEENAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
client.EmployeeCheckPagingAsync(dataPager.PageIndex, dataPager.PageSize, "BEREGULARDATE", filter,
paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
string strState = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName");
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
// filter += "T_HR_EMPLOYEE.EMPLOYEECNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(T_HR_EMPLOYEE.EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
client.EmployeePostChangePagingAsync(dataPager.PageIndex, dataPager.PageSize, "CHANGEDATE", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState);
}
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);
}
void LoadKPIDetail()
{
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
V_PERFORMANCERECORD tmp = dtgPerformance.SelectedItems[0] as V_PERFORMANCERECORD;
//filter = " T_HR_KPIRECORD.APPRAISEEID ==@" + paras.Count();
//paras.Add(tmp.T_HR_PERFORMANCERECORD.APPRAISEEID);
//if (tmp.T_HR_PERFORMANCERECORD.T_HR_SUMPERFORMANCERECORD != null)
//{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " PERFORMANCEID==@" + paras.Count();
paras.Add(tmp.PERFORMANCEID);
client.GetPerformanceDetailEmployeeAllPagingAsync(dataPagerDetail.PageIndex, dataPagerDetail.PageSize, "T_HR_KPIRECORD.UPDATEDATE", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, "", "");
//}
//else
//{
// dtgPerformanceDetail.ItemsSource = null;
// dataPagerDetail.PageCount = 0;
//}
}
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 = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
// filter += "T_HR_EMPLOYEE.EMPLOYEECNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
if (!string.IsNullOrEmpty(txtEmpCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)";
paras.Add(txtEmpCode.Text.Trim());
}
string sType = treeOrganization.sType, sValue = treeOrganization.sValue;
client.GetEmployeeViewsPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECNAME", filter,
paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (!string.IsNullOrEmpty(txtTitle.Text.Trim()))
{
filter += "ISSUANCETITLE ^@" + paras.Count().ToString();
paras.Add(txtTitle.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.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
client.GetIssunaceListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
//加载数据
private void GetData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrStart = "";
string StrEnd = "";
StrStart = DateStart.Text.ToString();
StrEnd = DateEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "RequireMaster.CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "RequireMaster.CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
paras.Add(DateStart.Text);
paras.Add(DateEnd.Text);
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
RefreshUI(RefreshedTypes.ShowProgressBar);
_VM.Get_ESurveyCheckedAsync(dataPager.PageIndex, dataPager.PageSize, "RequireMaster.CREATEDATE", "", paras, pageCount, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID, Common.CurrentLoginUserInfo.EmployeeID, checkState);
}
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()
{
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
filter += "CHECKSTATE==@" + paras.Count().ToString();
// paras.Add(Checkstate);
paras.Add(Convert.ToInt32(CheckStates.Approved).ToString());
TextBox txtEmpName = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "EMPLOYEENAME==@" + paras.Count().ToString();
paras.Add(txtEmpName.Text.Trim());
}
client.EmployeeEvectionReportPagingAsync(dataPager.PageIndex, dataPager.PageSize, "EMPLOYEECODE", filter, paras, pageCount);
loadbar.Start();
}
//加载数据
private void GetData(string checkState)
{
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //查询过滤条件
RefreshUI(RefreshedTypes.ShowProgressBar);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OWNERID == @" + paras.Count().ToString();
paras.Add(strOwnerID);
decimal dCheckStates = 0, dIsRepaied = 1;
decimal.TryParse(checkState, out dCheckStates);
client.GetBorrowApplyMasterListForRepayAsync(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, dIsRepaied, dCheckStates, filter, paras);
}
private void LoadData()
{
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
filter += "T_HR_POST.POSTID==@" + paras.Count().ToString();
paras.Add(PostID);
//TextBox txtEmpName = Utility.FindChildControl<TextBox Style="{StaticResource TextBoxStyle}">(expander, "txtEmpName");
//if (!string.IsNullOrEmpty(txtEmpName.Text))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CNAME==@" + paras.Count().ToString();
// paras.Add(txtEmpName.Text.Trim());
//}
client.RelationPostPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_POST.POSTID", filter, paras, pageCount);
loadbar.Stop();
}
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 = ""; //查询过滤条件
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 = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();//参数值
if (!string.IsNullOrEmpty(txtSYSTEMCODE.Text.Trim())) //系统类型
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SYSCODE ^@" + paras.Count().ToString();
paras.Add(txtSYSTEMCODE.Text.Trim());
}
if (!string.IsNullOrEmpty(txtAGENTMODULE.Text.Trim()))//代理模块
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MODELCODE ^@" + paras.Count().ToString();
paras.Add(txtAGENTMODULE.Text.Trim());
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
SoaChannel.GetAgentSetListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
// 1e
/// <summary>
/// 读取列表信息
/// </summary>
void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "", sType = "", sValue = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
if (myDetail)
{
// 1s 冉龙军
//filter += "APPRAISEEID==@" + paras.Count().ToString();
filter += "T_HR_KPIRECORD.APPRAISEEID==@" + paras.Count().ToString();
// 1e
paras.Add(SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
else
{
TextBox txtEmpName = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
TextBox txtEmpCode = Utility.FindChildControl<TextBox>(expander, "txtEmpCode");
if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim()))
{
filter += "@" + paras.Count().ToString() + ".Contains(EMPLOYEECODE)"; ;
paras.Add(txtEmpCode.Text.Trim());
}
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "@" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)"; ;
paras.Add(txtEmpName.Text.Trim());
}
sType = treeOrganization.sType;
sValue = treeOrganization.sValue;
if (string.IsNullOrEmpty(sType))
{
loadbar.Stop();
return;
}
}
DatePicker dpStartDate = Utility.FindChildControl<DatePicker>(expander, "dpStartDate");
DatePicker dpEndDate = Utility.FindChildControl<DatePicker>(expander, "dpEndDate");
string StartDate = string.Empty;
string EndDate = string.Empty;
if (dpStartDate != null)
{
StartDate = dpStartDate.Text;
}
if (dpEndDate != null)
{
EndDate = dpEndDate.Text;
}
string strState = "";
//if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
//{
// strState = Checkstate;
//}
kpiClient.GetKPIRecordPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_KPIRECORD.UPDATEDATE", filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, StartDate, EndDate, strState);
}
void LoadDocTypeInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrName = "";
string StrRecord = "";
string StrStart = "";
string StrEnd = "";
string StrTypeFlag = ""; //文档类型
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrRecord = this.cbxIsSave.SelectedIndex.ToString();
StrName = this.txtDocType.Text.Trim().ToString();
switch (this.cbxIsSave.SelectedIndex)
{
case 0:
break;
case 1:
StrTypeFlag ="1";
break;
case 2:
StrTypeFlag ="0";
break;
}
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
//if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
//{
// DtStart = System.Convert.ToDateTime(StrStart);
// DtEnd = System.Convert.ToDateTime(StrEnd);
// if (DtStart > DtEnd)
// {
// //MessageBox.Show("开始时间不能大于结束时间");
// Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
// return;
// }
// else
// {
// }
//}
if (!string.IsNullOrEmpty(StrName))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTYPE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrName);
}
if(!string.IsNullOrEmpty(StrTypeFlag))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OPTFLAG ==@" + paras.Count().ToString();//类型名称
paras.Add(StrTypeFlag);
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
//client.GetLendingListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "archivesLending.CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
start = DateTime.Now;
BumfClient.GetDocTypeInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadPerFormace()
{
TextBox txtCname = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
TextBox txtCode = Utility.FindChildControl<TextBox>(expander, "txtEmpCode");
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
if (!string.IsNullOrEmpty(txtCname.Text))
{
filter = " EMPLOYEECNAME==@" + paras.Count();
paras.Add(txtCname.Text);
}
if (!string.IsNullOrEmpty(txtCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " EMPLOYEECODE==@" + paras.Count();
paras.Add(txtCode.Text);
}
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " T_HR_PERFORMANCERECORD.T_HR_SUMPERFORMANCERECORD.SUMID==@" + paras.Count();
paras.Add(SumPerformance.SUMID);
client.GetPerformanceEmployeeAllPagingAsync(dataPagerPerformance.PageIndex, dataPagerPerformance.PageSize, "EMPLOYEECNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
private void LoadData()
{
int pageCount = 0;
string filter = "";
string sValue = "";
loadbar.Start();
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
string strState = "";
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
TextBox txtName = Utility.FindChildControl<TextBox>(expander, "txtName");
if (txtName != null && !string.IsNullOrEmpty(txtName.Text.Trim()))
{
//filter += "SALARYITEMNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(SALARYITEMNAME)";
paras.Add(txtName.Text.Trim());
}
//TreeViewItem selectedItem = treeOrganization.SelectedItem as TreeViewItem;
//if (selectedItem != null)
//{
// OrganizationWS.T_HR_COMPANY company = selectedItem.DataContext as OrganizationWS.T_HR_COMPANY;
// sValue = company.COMPANYID;
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CREATECOMPANYID==@" + paras.Count().ToString();
// paras.Add(sValue);
//}
//else
//{
// loadbar.Stop();
// return;
//}
string selectedType = treeOrganization.sType;
if (!string.IsNullOrEmpty(selectedType) && selectedType == "Company")
{
sValue = treeOrganization.sValue;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATECOMPANYID==@" + paras.Count().ToString();
paras.Add(sValue);
}
else
{
loadbar.Stop();
return;
}
#region --
//if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CHECKSTATE==@" + paras.Count().ToString();
// paras.Add(Checkstate);
//}
#endregion
client.GetSalaryItemSetPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
/// <summary>
/// 绑定员工列表
/// </summary>
private void BindEmployeeList()
{
int pageSize = 0, pageIndex = 0, pageCount = 0;
string filter = string.Empty, strMsg = string.Empty;
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEECNAME)";
paras.Add(txtEmpName.Text.Trim());
}
string sType = "", sValue = "";
//2012-9-13
//不需要选择机构就可进行查询，于是注释
// GetOrgInfoByChecked(ref sType, ref sValue, ref strMsg);
if (!string.IsNullOrWhiteSpace(strMsg))
{
Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("CAUTION"), strMsg);
return;
}
//不分页
pageIndex = 1;
pageSize = 999999;
PersonnelWS.PersonnelServiceClient clientPers = new PersonnelWS.PersonnelServiceClient();
Employeestate statetmp = cbxEmployeeState.SelectedItem as Employeestate;
if (statetmp != null)
{
if (statetmp.Value == "1")
{
clientPers.GetLeaveEmployeeViewsPagingCompleted += new EventHandler<PersonnelWS.GetLeaveEmployeeViewsPagingCompletedEventArgs>(clientPers_GetLeaveEmployeeViewsPagingCompleted);
clientPers.GetLeaveEmployeeViewsPagingAsync(pageIndex, pageSize, "EMPLOYEECNAME",
filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
else
{
clientPers.GetEmployeeViewsPagingCompleted += new EventHandler<PersonnelWS.GetEmployeeViewsPagingCompletedEventArgs>(clientPers_GetEmployeeViewsPagingCompleted);
clientPers.GetEmployeeViewsPagingAsync(pageIndex, pageSize, "EMPLOYEECNAME",
filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
}
else
{
clientPers.GetEmployeeViewsPagingCompleted += new EventHandler<PersonnelWS.GetEmployeeViewsPagingCompletedEventArgs>(clientPers_GetEmployeeViewsPagingCompleted);
clientPers.GetEmployeeViewsPagingAsync(pageIndex, pageSize, "EMPLOYEECNAME",
filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
}
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 GetData()
{
loadbar.Start();
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQuery)
{
string StrContent = "";
string StrStart = "";
string StrEnd = "";
string StrConservateType = ((SMT.Saas.Tools.PermissionWS.T_SYS_DICTIONARY)cmbConserVationName.SelectedItem).DICTIONARYNAME.ToString();
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrContent = this.txtConserVationContent.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
//MessageBox.Show("结束时间不能为空");
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("STARTTIMENOTNULL"));
//MessageBox.Show("开始时间不能为空");
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "REPAIRDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "REPAIRDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (cmbConserVationName.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MAINTENANCETYPE ==@" + paras.Count().ToString();//类型
paras.Add(StrConservateType);
}
if (!string.IsNullOrEmpty(StrContent))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CONTENT ^@" + paras.Count().ToString();//类型名称
paras.Add(StrContent);
}
}
maWS.Get_VMRecordsAsync(dataPager.PageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID, Common.CurrentLoginUserInfo.EmployeeID, checkState);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
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());
}
loadbar.Start();
client.GetReturnListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, Common.CurrentLoginUserInfo.EmployeeID);
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
// ispaging = false;
dialog.DefaultExt = ".xls";
dialog.Filter = "MS Excel 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 (StrCompanyIDsList.Count() > 0)
{
StrCompanyIDsList.ForEach(item =>
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
else
{
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
});
}
DateTime dtLandStart = new DateTime();
DateTime dtLandEnd = new DateTime();
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandStart);
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandEnd);
dtLandEnd = dtLandEnd.AddMonths(1);
//if (string.IsNullOrEmpty(filter))
//{
// filter += " CREATEDATE >= @" + paras.Count().ToString();
// paras.Add(dtLandStart);
//}
//else
//{
// filter += " and CREATEDATE >= @" + paras.Count().ToString();
// paras.Add(dtLandStart);
//}
//filter += " and CREATEDATE < @" + paras.Count().ToString();
//paras.Add(dtLandEnd);
loadbar.Start();
switch (ReportsType)
{
case "1":
break;
case "2":
personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE",filter,paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue,dtLandStart,dtLandEnd);
break;
case "3":
personClient.ExportEmployeeCollectsReportsAsync("", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart,dtLandEnd);
break;
case "4":
sValue = StrCompanyIDsList.FirstOrDefault();
client.ExportEmployeePensionReportsAsync("COMPANYNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID,sValue, dtLandStart);
break;
default:
//personClient.GetEmployeeBasicInfosByCompanyAsync(dataPager.PageIndex, dataPager.PageSize, "POSTNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, sValue);
//personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(StrCompanyIDsList, "CREATEDATE",filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType);
if (ListInfos != null)
{
personClient.ExportEmployeeBasicInfosNoGetReportsAsync(ListInfos,dtLandStart,StrCompanyIDsList);
}
else
{
//personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(
}
break;
}
//personClient.ExportEmployeesIntimeAsync(dataPager.PageIndex, dataPager.PageSize, "DepartmentName",
// filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
}
void LoadData()
{
string filter = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
if (StrCompanyIDsList.Count() > 0)
{
StrCompanyIDsList.ForEach(item =>
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
else
{
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
});
}
DateTime dtLandStart = new DateTime();
DateTime dtLandEnd = new DateTime();
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandStart);
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value + "-1", out dtLandEnd);
dtLandEnd = dtLandEnd.AddMonths(1);
loadbar.Start();
if (string.IsNullOrEmpty(ReportsType))
{
personClient.GetEmployeeBasicInfosByCompanyAsync(StrCompanyIDsList, "COMPANYNAME,DEPARTMENTNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, dtLandStart, dtLandEnd);
}
else
{
loadbar.Stop();
}
//switch (ReportsType)
//{
// case "1":
// break;
// case "2":
// //personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, System.DateTime.Now);
// personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
// break;
// case "3":
// personClient.ExportEmployeeCollectsReportsAsync("", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
// break;
// default:
// personClient.GetEmployeeBasicInfosByCompanyAsync(StrCompanyIDsList, "COMPANYNAME,DEPARTMENTNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, dtLandStart, dtLandEnd);
// //personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType);
// break;
//}
}
/// <summary>
/// 获取数据 1
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="checkState"></param>
private void GetData(int pageIndex, string checkState)
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQuery)
{
string StrTitle = "";
string StrContent = "";
string StrStart = "";
string StrEnd = "";
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrTitle = this.txtSurveysTITLE.Text.ToString().Trim();
StrContent = this.txtSurveysContent.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
//MessageBox.Show("结束时间不能为空");
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
//MessageBox.Show("开始时间不能为空");
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OARequire.STARTDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "OARequire.STARTDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OARequire.SATISFACTIONTITLE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrContent))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OARequire.CONTENT ^@" + paras.Count().ToString();//类型名称
paras.Add(StrContent);
}
//if (!string.IsNullOrEmpty(filter))
//{
// filter += " and ";
//}
//filter += "OARequire.STARTDATE <=@" + paras.Count().ToString();//类型名称
//paras.Add(System.DateTime.Now);
}
loadbar.Start();
client.Get_StaticfactionSurveyAppCheckedAsync(dataPager.PageIndex, dataPager.PageSize, "OARequire.UPDATEDATE descending", filter, paras, pageCount, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID, Common.CurrentLoginUserInfo.EmployeeID, checkState, Common.CurrentLoginUserInfo.UserPosts[0].PostID, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID, Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
}
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);
}
void LoadKPIDetail()
{
int pageCount = 0;
string filter = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
V_PERFORMANCERECORD tmp = dtgPerformance.SelectedItems[0] as V_PERFORMANCERECORD;
//filter = " T_HR_KPIRECORD.APPRAISEEID ==@" + paras.Count();
//paras.Add(tmp.T_HR_PERFORMANCERECORD.APPRAISEEID);
//if (tmp.T_HR_PERFORMANCERECORD.T_HR_SUMPERFORMANCERECORD != null)
//{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " PERFORMANCEID==@" + paras.Count();
paras.Add(tmp.PERFORMANCEID);
client.GetPerformanceDetailEmployeeAllPagingAsync(dataPagerDetail.PageIndex, dataPagerDetail.PageSize, "T_HR_KPIRECORD.UPDATEDATE", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, "", "");
//}
//else
//{
// dtgPerformanceDetail.ItemsSource = null;
// dataPagerDetail.PageCount = 0;
//}
}
public void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
int sType = -1;
string sValue = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
string selectedType = treeOrganization.sType;
if (!string.IsNullOrEmpty(selectedType))
{
switch (selectedType)
{
case "Company":
sType = 0;
break;
case "Department":
sType = 1;
break;
case "Post":
sType = 2;
break;
}
sValue = treeOrganization.sValue;
}
else
{
loadbar.Stop();
//if (frist) frist = false; else Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), "PLEASESELECT");
return;
}
DatePicker dpStartDate = Utility.FindChildControl<DatePicker>(expander, "dpStartDate");
DatePicker dpEndDate = Utility.FindChildControl<DatePicker>(expander, "dpEndDate");
string StartDate = string.Empty;
string EndDate = string.Empty;
if (dpStartDate != null)
{
StartDate = dpStartDate.Text;
}
if (dpEndDate != null)
{
EndDate = dpEndDate.Text;
}
string strState = "";
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
TextBox txtEmpName = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
TextBox txtEmpCode = Utility.FindChildControl<TextBox>(expander, "txtEmpCode");
if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim()))
{
filter += "EMPLOYEECODE==@" + paras.Count().ToString();
paras.Add(txtEmpCode.Text.Trim());
}
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "EMPLOYEECNAME==@" + paras.Count().ToString();
paras.Add(txtEmpName.Text.Trim());
}
//client.GetCustomGuerdonSetPagingAsync(dataPager.PageIndex, dataPager.PageSize, "GUERDONNAME", filter, paras, pageCount, strState, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
client.GetComplainRecordPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_KPIRECORD.UPDATEDATE", filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, StartDate, EndDate, strState);
//loadbar.Stop();
}
private void PlayPlaylist()
{
var str = this.SelectedEntries.Select((t) => new Track
{
Id = t.TrackId
});
var selectedTracks = new System.Collections.ObjectModel.ObservableCollection<Track>(str);
if (selectedTracks != null && selectedTracks.Count() > 0)
{
this.m_playerManager.PlayTracks(selectedTracks, PlayerMode.Song);
}
else
{
var tr = this.Entries.Select((t) => new Track
{
Id = t.TrackId
});
var tracks = new System.Collections.ObjectModel.ObservableCollection<Track>(tr);
if (tracks != null && tracks.Count() > 0)
{
this.m_playerManager.PlayTracks(tracks, PlayerMode.Playlist);
}
}
}
void ServiceClent_GetUserByEmployeeIDCompleted(object sender, GetUserByEmployeeIDCompletedEventArgs e)
{
if (!e.Cancelled)
{
if (e.Result != null)
{
sysUser = e.Result as T_SYS_USER;
this.tblemployeename.Text = sysUser.EMPLOYEENAME;
this.txtUserName.Text = sysUser.USERNAME;
this.txtPassword.Password = SMT.SaaS.FrameworkUI.Common.Utility.Decrypt( sysUser.PASSWORD);
this.txtConfirmpwd.Password = SMT.SaaS.FrameworkUI.Common.Utility.Decrypt(sysUser.PASSWORD);
this.txtRemark.Text = sysUser.REMARK == null ? "" : sysUser.REMARK;
if (!string.IsNullOrEmpty(sysUser.OWNERCOMPANYID))
{
GetCompanyNameByCompanyID(sysUser.OWNERCOMPANYID);
}
if (sysUser.ISMANGER == 1)
{
this.rbtIsAutoyes.IsChecked = true;
}
else
{
this.rbtIsAutono.IsChecked = true;
}
if (sysUser.ISENGINEMANAGER == "1")
{
this.rbtengine.IsChecked = true;
}
else
{
this.rbtengineno.IsChecked = true;
}
if (sysUser.ISFLOWMANAGER == "1")
{
this.rbtflow.IsChecked = true;
}
else
{
this.rbtflowno.IsChecked = true;
}
if (sysUser.STATE == "0")
{
this.tblstate.Text = "禁用";
//this.tblstate.Foreground = SystemColors.
btnSet.Content = Utility.GetResourceStr("STARTUSING");
//FormToolBar1.btnOtherAction("/SMT.SaaS.FrameworkUI;Component/Images/ToolBar/ico_16_4424.png", Utility.GetResourceStr("STARTUSING")).Click += new RoutedEventHandler(SysUserSetIsActived_Click);
}
else
{
this.tblstate.Text = "正常";
btnSet.Content = Utility.GetResourceStr("FORBIDUSE");
//FormToolBar1.btnOtherAction("/SMT.SaaS.FrameworkUI;Component/Images/ToolBar/ico_16_4424.png", Utility.GetResourceStr("FORBIDUSE")).Click += new RoutedEventHandler(SysUserManagement_Click);
}
#region 获取用户薪资密码
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 OWNERID==@" + paras.Count().ToString();
paras.Add(sysUser.EMPLOYEEID);
salaryClient.GetSystemParamSetPagingAsync(1, 20, "PARAMETERNAME", filter, paras, pageCount, sysUser.EMPLOYEEID);
#endregion
}
}
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (!string.IsNullOrEmpty(txtTitle.Text.Trim()))
{
filter += "ISSUANCETITLE ^@" + paras.Count().ToString();
paras.Add(txtTitle.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.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
client.GetIssunaceListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
string strState = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
//根据部门过滤
ComboBox cbxDepName = Utility.FindChildControl<ComboBox>(expander, "cbxDepName");
if (cbxDepName != null)
{
if (cbxDepName.SelectedIndex > 0)
{
T_HR_DEPARTMENT temp = cbxDepName.SelectedItem as T_HR_DEPARTMENT;
filter += "T_HR_DEPARTMENT.DEPARTMENTID==@" + paras.Count().ToString();
paras.Add(temp.DEPARTMENTID);
}
}
//根据公司过滤
ComboBox cbxCpyName = Utility.FindChildControl<ComboBox>(expander, "cbxCpyName");
if (cbxCpyName != null)
{
if (cbxCpyName.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
T_HR_COMPANY temp = cbxCpyName.SelectedItem as T_HR_COMPANY;
filter += " T_HR_DEPARTMENT.T_HR_COMPANY.COMPANYID==@" + paras.Count().ToString();
paras.Add(temp.COMPANYID);
}
}
TextBox txtEmpName = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
//filter += "T_HR_POSTDICTIONARY.POSTNAME==@" + paras.Count().ToString();
filter += " @" + paras.Count().ToString() + ".Contains(T_HR_POSTDICTIONARY.POSTNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
client.PostPagingAsync(dataPager.PageIndex, dataPager.PageSize, "T_HR_DEPARTMENT.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME",
filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState);
}
private void LoadData()
{
loadbar.Start();
int pageCount = 0;
string filter = "";
string strState = "";
System.Collections.ObjectModel.ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();
if (Checkstate != Convert.ToInt32(CheckStates.All).ToString())
{
strState = Checkstate;
}
//ComboBox cbxCompanyName = Utility.FindChildControl<ComboBox>(expander, "cbxCompanyName");
AutoCompleteComboBox acbCompanyName = Utility.FindChildControl<AutoCompleteComboBox>(expander, "acbCompanyName");
TextBox txtEmpName = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
if (acbCompanyName != null)
{
if (acbCompanyName.SelectedItem != null)
{
T_HR_COMPANY ent = acbCompanyName.SelectedItem as T_HR_COMPANY;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_HR_COMPANY.CNAME==@" + paras.Count().ToString();
paras.Add(ent.CNAME);
}
}
if (txtEmpName != null)
{
if (!string.IsNullOrEmpty(txtEmpName.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
// filter += "T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME.Contains(@" + paras.Count().ToString()+")";
filter += " @" + paras.Count().ToString() + ".Contains(T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME)";
paras.Add(txtEmpName.Text.Trim());
}
}
client.DepartmentPagingAsync(dataPager.PageIndex, dataPager.PageSize, "SORTINDEX", filter,
paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strState);
}
// 1e
/// <summary>
/// 刷新绩效考核列表
/// </summary>
void LoadData()
{
int pageCount = 0;
string filter = "", sType = "", sValue = "";
System.Collections.ObjectModel.ObservableCollection<string> paras = new System.Collections.ObjectModel.ObservableCollection<string>();
sType = treeOrganization.sType;
sValue = treeOrganization.sValue;
// 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
DatePicker dpSumStartTime = Utility.FindChildControl<DatePicker>(expander, "dpSumStartDate");
DatePicker dpSumEndDate = Utility.FindChildControl<DatePicker>(expander, "dpSumEndDate");
string SumStartTime = string.Empty;
string SumEndDate = string.Empty;
if (dpSumStartTime != null)
{
SumStartTime = dpSumStartTime.Text;
}
if (dpSumEndDate != null)
{
SumEndDate = dpSumEndDate.Text;
}
TextBox txtCname = Utility.FindChildControl<TextBox>(expander, "txtEmpName");
TextBox txtCode = Utility.FindChildControl<TextBox>(expander, "txtEmpCode");
if (txtCname != null && !string.IsNullOrEmpty(txtCname.Text))
{
filter = " EMPLOYEECNAME==@" + paras.Count();
paras.Add(txtCname.Text);
}
if (txtCode != null && !string.IsNullOrEmpty(txtCode.Text))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " EMPLOYEECODE==@" + paras.Count();
paras.Add(txtCode.Text);
}
client.GetEmployeePerformancePagingByTimeAsync(dataPagerPerformance.PageIndex, dataPagerPerformance.PageSize, "EMPLOYEECNAME", filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, SumStartTime, SumEndDate);
loadbar.Start();
}
