private void InitQueryFilter()
{
MultiValuesItem<ExtOrgObj> item = new MultiValuesItem<ExtOrgObj>();
SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ep = new Saas.Tools.PersonnelWS.T_HR_EMPLOYEE();
ep.EMPLOYEECNAME = DataCore.CurrentUser.Text;
ep.EMPLOYEEID = DataCore.CurrentUser.Value.ToString();
List<ExtOrgObj> list = new List<ExtOrgObj>() { new ExtOrgObj { ObjectInstance = ep } };
item.Values = list;
item.Text = ep.EMPLOYEECNAME;
lkObject.SelectItem = item;
lkObject.DataContext = item;
lkObject.DisplayMemberPath = "Text";
DateTime dtSystem = DataCore.SystemSetting.UPDATEDATE.Value;
dtSystem = dtSystem.AddDays(1 - dtSystem.Day);
// 开始日期
// DatePicker dpStart = this.expander.FindChildControl<DatePicker>("dpStart");
dpStart.SelectedDate = dtSystem;
// 结束日期
// DatePicker dpEnd = this.expander.FindChildControl<DatePicker>("dpEnd");
dpEnd.SelectedDate = dtSystem.AddMonths(1).AddSeconds(-1);
}
private void InitQueryFilter()
{
MultiValuesItem <ExtOrgObj> item = new MultiValuesItem <ExtOrgObj>();
SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ep = new Saas.Tools.PersonnelWS.T_HR_EMPLOYEE();
ep.EMPLOYEECNAME = DataCore.CurrentUser.Text;
ep.EMPLOYEEID = DataCore.CurrentUser.Value.ToString();
List <ExtOrgObj> list = new List <ExtOrgObj>()
{
new ExtOrgObj {
ObjectInstance = ep
}
};
item.Values = list;
item.Text = ep.EMPLOYEECNAME;
lkObject.SelectItem = item;
lkObject.DataContext = item;
lkObject.DisplayMemberPath = "Text";
DateTime dtSystem = DataCore.SystemSetting.UPDATEDATE.Value;
dtSystem = dtSystem.AddDays(1 - dtSystem.Day);
// 开始日期
// DatePicker dpStart = this.expander.FindChildControl<DatePicker>("dpStart");
dpStart.SelectedDate = dtSystem;
// 结束日期
// DatePicker dpEnd = this.expander.FindChildControl<DatePicker>("dpEnd");
dpEnd.SelectedDate = dtSystem.AddMonths(1).AddSeconds(-1);
}
private void InitQueryFilter()
{
Button btnFind = this.expander.FindChildControl<Button>("btnFind");
btnFind.IsEnabled = true;
// 预算类型
ComboBox cbbBudgetType = this.expander.FindChildControl<ComboBox>("cbbBudgetType");
CommonFunction.FillQueryComboBox<BudgetTypeData>(cbbBudgetType);
ITextValueItem allItem = DataCore.AllSelectdData;
cbbBudgetType.DisplayMemberPath = "Text";
cbbBudgetType.SelectedItem = allItem;
// 查询对象
LookUp lkObject = this.expander.FindChildControl<LookUp>("lkObject");
MultiValuesItem<ExtOrgObj> item = new MultiValuesItem<ExtOrgObj>();
SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ep = new Saas.Tools.PersonnelWS.T_HR_EMPLOYEE();
ep.EMPLOYEECNAME = DataCore.CurrentUser.Text;
ep.EMPLOYEEID = DataCore.CurrentUser.Value.ToString();
List<ExtOrgObj> list = new List<ExtOrgObj>() { new ExtOrgObj { ObjectInstance = ep } };
item.Values = list;
item.Text = ep.EMPLOYEECNAME;
lkObject.SelectItem = item;
lkObject.DataContext = item;
lkObject.DisplayMemberPath = "Text";
}
private void lkObject_FindClick(object sender, EventArgs e)
{
string userID = DataCore.CurrentUser.Value.ToString();
string perm = ((int)Permissions.Browse).ToString();
string entity = this.DefaultEntity.OrderType.Name;
OrganizationLookup ogzLookup = new OrganizationLookup(userID, perm, entity);
ogzLookup.MultiSelected = true;
ogzLookup.SelectedObjType = OrgTreeItemTypes.All;
FrameworkElement plRoot = CommonFunction.ParentLayoutRoot;
ogzLookup.SelectedClick += (o, ev) =>
{
if (ogzLookup.SelectedObj.Count > 0)
{
List <ExtOrgObj> list = new List <ExtOrgObj>();
string text = " ";
foreach (ExtOrgObj obj in ogzLookup.SelectedObj)
{
list.Add(obj);
text = text.Trim() + ";" + obj.ObjectName;
}
MultiValuesItem <ExtOrgObj> item = new MultiValuesItem <ExtOrgObj>();
item.Values = list;
item.Text = text.Substring(1);
lkObject.SelectItem = item;
lkObject.DataContext = item;
lkObject.DisplayMemberPath = "Text";
//lkObject.TxtLookUp.Text = text.Substring(1);
}
};
ogzLookup.Show <string>(DialogMode.ApplicationModal, plRoot, "", (result) => { });
}
private void lkObject_FindClick(object sender, EventArgs e)
{
string userID = DataCore.CurrentUser.Value.ToString();
string perm = ((int)Permissions.Browse).ToString();
string entity = this.DefaultEntity.OrderType.Name;
OrganizationLookup ogzLookup = new OrganizationLookup(userID, perm, entity);
ogzLookup.MultiSelected = true;
ogzLookup.SelectedObjType = OrgTreeItemTypes.All;
FrameworkElement plRoot = CommonFunction.ParentLayoutRoot;
ogzLookup.SelectedClick += (o, ev) =>
{
if (ogzLookup.SelectedObj.Count > 0)
{
List<ExtOrgObj> list = new List<ExtOrgObj>();
string text = " ";
foreach (ExtOrgObj obj in ogzLookup.SelectedObj)
{
list.Add(obj);
text = text.Trim() + ";" + obj.ObjectName;
}
MultiValuesItem<ExtOrgObj> item = new MultiValuesItem<ExtOrgObj>();
item.Values = list;
item.Text = text.Substring(1);
lkObject.SelectItem = item;
lkObject.DataContext = item;
lkObject.DisplayMemberPath = "Text";
//lkObject.TxtLookUp.Text = text.Substring(1);
}
};
ogzLookup.Show<string>(DialogMode.ApplicationModal, plRoot, "", (result) => { });
}
private void GetOrders()
{
ShowProcess();
ITextValueItem dataOrderStatus = cbbOrderStatus.SelectedItem as ITextValueItem;
QueryData dataQueryList = cbbQueryList.SelectedItem as QueryData;
QueryExpression qeTop = new QueryExpression();
qeTop.QueryType = this.DefaultEntity.OrderType.Name;
QueryExpression qe = qeTop;
qe.RelatedType = QueryExpression.RelationType.And;
QueryExpression qe1 = new QueryExpression();
qe1.QueryType = qe.QueryType;
qe1.PropertyName = FieldName.CheckStates;
qe1.PropertyValue = dataOrderStatus.Value.ToString();
qe1.Operation = QueryExpression.Operations.Equal;
qe1.RelatedType = QueryExpression.RelationType.And;
qe.RelatedExpression = qe1;
qe = qe.RelatedExpression;
string strCodeName = string.Empty;
CommonFunction.GetTableCode(this.DefaultEntity.OrderType, ref strCodeName);
//if (this.DefaultEntity.OrderType == typeof(T_FB_CHARGEAPPLYMASTER))
//{
// strCodeName = "CHARGEAPPLYMASTERCODE";
//}
//else if (this.DefaultEntity.OrderType == typeof(T_FB_TRAVELEXPAPPLYMASTER))
//{
// strCodeName = "TRAVELEXPAPPLYMASTERCODE";
//}
//else if (this.DefaultEntity.OrderType == typeof(T_FB_BORROWAPPLYMASTER))
//{
// strCodeName = "BORROWAPPLYMASTERCODE";
//}
//else if (this.DefaultEntity.OrderType == typeof(T_FB_REPAYAPPLYMASTER))
//{
// strCodeName = "REPAYAPPLYMASTERCODE";
//}
if (!string.IsNullOrWhiteSpace(txtCode.Text) && !string.IsNullOrWhiteSpace(strCodeName))
{
QueryExpression qeCode = new QueryExpression();
qeCode.QueryType = qe.QueryType;
qeCode.PropertyName = strCodeName;
qeCode.PropertyValue = txtCode.Text;
qeCode.Operation = QueryExpression.Operations.Like;
qeCode.RelatedType = QueryExpression.RelationType.And;
qe.RelatedExpression = qeCode;
qe = qe.RelatedExpression;
}
// 开始日期
if (dpStart.SelectedDate != null)
{
QueryExpression qeStartDate = new QueryExpression();
qeStartDate.QueryType = qe.QueryType;
qeStartDate.PropertyName = FieldName.UpdateDate;
qeStartDate.PropertyValue = dpStart.SelectedDate.Value.ToString();
qeStartDate.Operation = QueryExpression.Operations.GreaterThanOrEqual;
qeStartDate.RelatedType = QueryExpression.RelationType.And;
qe.RelatedExpression = qeStartDate;
qe = qe.RelatedExpression;
}
// 截止日期
if (dpEnd.SelectedDate != null)
{
QueryExpression qeEndDate = new QueryExpression();
qeEndDate.QueryType = qe.QueryType;
qeEndDate.PropertyName = FieldName.UpdateDate;
qeEndDate.PropertyValue = dpEnd.SelectedDate.Value.ToString();
qeEndDate.Operation = QueryExpression.Operations.LessThanOrEqual;
qeEndDate.RelatedType = QueryExpression.RelationType.And;
qe.RelatedExpression = qeEndDate;
qe = qe.RelatedExpression;
}
// 查询对象选择范围
QueryExpression qeTemp = null;
if (lkObject.DataContext != null)
{
MultiValuesItem <ExtOrgObj> mutilValues = lkObject.SelectItem as MultiValuesItem <ExtOrgObj>;
if (mutilValues != null)
{
Dictionary <OrgTreeItemTypes, string> dictTypes = new Dictionary <OrgTreeItemTypes, string>();
dictTypes.Add(OrgTreeItemTypes.Company, FieldName.OwnerCompanyID);
dictTypes.Add(OrgTreeItemTypes.Department, FieldName.OwnerDepartmentID);
dictTypes.Add(OrgTreeItemTypes.Personnel, FieldName.OwnerID);
dictTypes.Add(OrgTreeItemTypes.Post, FieldName.OwnerPostID);
mutilValues.Values.ForEach(item =>
{
string propertyName = dictTypes[item.ObjectType];
QueryExpression qeItem = QueryExpressionHelper.Equal(propertyName, item.ObjectID);
qeItem.RelatedType = QueryExpression.RelationType.Or;
qeItem.RelatedExpression = qeTemp;
qeTemp = qeItem;
});
}
}
if (qeTemp != null)
{
qe.RelatedExpression = qeTemp;
qe = qeTemp;
}
if (qeTop.RelatedExpression != null)
{
qeTop = qeTop.RelatedExpression;
}
qeTop.OrderByExpression = new OrderByExpression();
qeTop.OrderByExpression.PropertyName = FieldName.UpdateDate;
qeTop.OrderByExpression.PropertyType = typeof(DateTime).Name;
qeTop.OrderByExpression.OrderByType = OrderByType.Dsc;
this.ADtGrid.Queryer.QueryExpression = qeTop;
this.ADtGrid.Queryer.Query();
}
