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