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