/// <summary> /// 查询跟踪单责任人列表 /// </summary> /// <param name="query"></param> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="sortField"></param> /// <param name="callback"></param> public void QueryResponsibleUser(ResponsibleUserQueryVM query, int pageSize, int pageIndex, string sortField, Action <ResponsibleUserQueryResultVM> callback) { ResponsibleUserQueryFilter filter = query.ConvertVM <ResponsibleUserQueryVM, ResponsibleUserQueryFilter>(); filter.PagingInfo = new PagingInfo() { PageIndex = pageIndex, PageSize = pageSize, SortBy = sortField }; string relativeUrl = "/InvoiceService/ResponsibleUser/Query"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } ResponsibleUserQueryResultVM result = new ResponsibleUserQueryResultVM(); result.ResultList = DynamicConverter <ResponsibleUserVM> .ConvertToVMList(args.Result.Rows); result.TotalCount = args.Result.TotalCount; callback(result); }); }
public virtual QueryResult QueryResponsibleUser(ResponsibleUserQueryFilter request) { int totalCount; var table = ObjectFactory <ITrackingInfoQueryDA> .Instance.QueryResponsibleUser(request, out totalCount); return(new QueryResult() { Data = table, TotalCount = totalCount }); }
/// <summary> /// 导出跟踪单责任人 /// </summary> /// <param name="queryVM"></param> /// <param name="columnSet"></param> public void ExportResponsibleUserExcelFile(ResponsibleUserQueryVM queryVM, ColumnSet[] columnSet) { ResponsibleUserQueryFilter queryFilter = queryVM.ConvertVM <ResponsibleUserQueryVM, ResponsibleUserQueryFilter>(); queryFilter.PagingInfo = new PagingInfo { PageSize = ECCentral.Portal.Basic.ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = "sr.SysNo desc" }; queryFilter.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "/InvoiceService/ResponsibleUser/Query"; restClient.ExportFile(relativeUrl, queryFilter, columnSet); }
public DataTable QueryResponsibleUser(ResponsibleUserQueryFilter filter, out int totalCount) { DataTable result = null; PagingInfoEntity pagingInfo = CreatePagingInfo(filter.PagingInfo); CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryResponsibleUser"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "sr.SysNo desc")) { if (filter.IsSpecialMode == false) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.IsPayWhenRecv", DbType.Int32, "@IncomeStyle", QueryConditionOperatorType.Equal, filter.IncomeStyle); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.PayTypeSysNo", DbType.Int32, "@PayTypeSysNo", QueryConditionOperatorType.Equal, filter.PayTypeSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.ShipTypeSysNo", DbType.Int32, "@ShipTypeSysNo", QueryConditionOperatorType.Equal, filter.ShipTypeSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.CustomerSysNo", DbType.Int32, "@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.ResponsibleUserName", DbType.String, "@ResponsibleUserName", QueryConditionOperatorType.LeftLike, filter.ResponsibleUserName); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.EmailAddress", DbType.String, "@EmailAddress", QueryConditionOperatorType.Equal, filter.EmailAddress); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.SourceType", DbType.Int32, "@SrouceType", QueryConditionOperatorType.Equal, filter.SourceType); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); } else { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.IsPayWhenRecv", DbType.Int32, "@IsPayWhenRecv", QueryConditionOperatorType.Equal, filter.IncomeStyle); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sr.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); builder.ConditionConstructor.AddNullCheckCondition(QueryConditionRelationType.AND, "sr.PayTypeSysNo", QueryConditionOperatorType.IsNull); builder.ConditionConstructor.AddNullCheckCondition(QueryConditionRelationType.AND, "sr.ShipTypeSysNo", QueryConditionOperatorType.IsNull); builder.ConditionConstructor.AddNullCheckCondition(QueryConditionRelationType.AND, "sr.CustomerSysNo", QueryConditionOperatorType.IsNull); } dataCommand.CommandText = builder.BuildQuerySql(); EnumColumnList enumColumns = new EnumColumnList(); enumColumns.Add("IncomeStyle", typeof(ResponseUserOrderStyle)); enumColumns.Add("Status", typeof(ResponseUserStatus)); enumColumns.Add("SourceType", typeof(ResponsibleSource)); result = dataCommand.ExecuteDataTable(enumColumns); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); } return(result); }