public void Query(CSQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/CustomerService/CS/Query";
request.CompanyCode = CPApplication.Current.CompanyCode;
restClient.QueryDynamicData(relativeUrl, request, callback);
}
public virtual DataTable Query(CSQueryFilter queryCriteria, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = queryCriteria.PagingInfo.SortBy;
pagingEntity.MaximumRows = queryCriteria.PagingInfo.PageSize;
pagingEntity.StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetCSListByQuery");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " a.UserName ASC "))
{
if (queryCriteria.IsGetUnderling)
{
if (queryCriteria.Role == CSRole.Leader)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"b.UserName",
DbType.String, "@UserName",
QueryConditionOperatorType.Like,
queryCriteria.Name);
}
else if (queryCriteria.Role == CSRole.Manager)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.UserName",
DbType.String, "@UserName",
QueryConditionOperatorType.Like,
queryCriteria.Name);
}
}
else
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.UserName",
DbType.String, "@UserName",
QueryConditionOperatorType.Like,
queryCriteria.Name);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.Role",
DbType.Int32, "@Role",
QueryConditionOperatorType.Equal,
queryCriteria.Role);
}
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode",
QueryConditionOperatorType.Equal,
queryCriteria.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = cmd.ExecuteDataTable(3, typeof(CSRole));
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public QueryResult QueryCS(CSQueryFilter request)
{
int totalCount;
return(new QueryResult()
{
Data = ObjectFactory <ICSQueryDA> .Instance.Query(request, out totalCount),
TotalCount = totalCount
});
}
public override void OnPageLoad(object sender, EventArgs e)
{
queryRequest = new CSQueryFilter();
vm = new CSSetVM();
this.DataContext = vm;
facade = new CSFacade(this);
queryRequest.PagingInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = CSGrid.PageSize,
PageIndex = 0,
SortBy = string.Empty
};
vm.RoleList = EnumConverter.GetKeyValuePairs <CSRole>(EnumConverter.EnumAppendItemType.All);
Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn role = this.CSGrid.Columns[1] as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn;
role.Binding.ConverterParameter = typeof(CSRole);
base.OnPageLoad(sender, e);
CheckRights();
}
private void InitVM()
{
//init CSList;
if (IsAdd)
{
new CSFacade().GetCSWithDepartmentId(csdeparmentId, (s, args) =>
{
if (args.Error == null && null != args.Result)
{
args.Result.ForEach(item => viewModel.CSList.Add(item.Convert <CSInfo, CSVM>()));
cmbUser.ItemsSource = viewModel.CSList;
}
});
}
else
{
viewModel.CSList.Add(new CSVM()
{
SysNo = viewModel.csvm.IPPUserSysNo, UserName = viewModel.csvm.UserName
});
cmbUser.ItemsSource = viewModel.CSList;
cmbUser.IsEnabled = false;
ckbAllDepartment.Visibility = System.Windows.Visibility.Collapsed;
}
//init AllCSList
new CSFacade().GetAllCS((s, args) =>
{
if (args.Error == null && null != args.Result)
{
args.Result.ForEach(item => viewModel.AllCSList.Add(item.Convert <CSInfo, CSVM>()));
}
});
//init RoleList
viewModel.RoleList = EnumConverter.GetKeyValuePairs <CSRole>();
//init leaderList
CSQueryFilter queryRequest = new CSQueryFilter();
queryRequest.Role = CSRole.Leader;
queryRequest.PagingInfo = new PagingInfo
{
PageSize = int.MaxValue,
PageIndex = 0
};
new CSFacade().Query(queryRequest, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
viewModel.LeaderList = DynamicConverter <CSVM> .ConvertToVMList(args.Result.Rows);;
});
//init managerList
queryRequest = new CSQueryFilter();
queryRequest.Role = CSRole.Manager;
queryRequest.PagingInfo = new PagingInfo
{
PageSize = int.MaxValue,
PageIndex = 0
};
new CSFacade().Query(queryRequest, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
viewModel.ManagerList = DynamicConverter <CSVM> .ConvertToVMList(args.Result.Rows);;
});
}
