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