public QueryResult QuerySAPDOCHeaderDetail(HeaderDataQueryFilter filter) { int totalCount = 0; return(new QueryResult() { Data = ObjectFactory <IHeaderDataQueryDA> .Instance.QuerySAPDOCHeaderDetail(filter, out totalCount), TotalCount = totalCount }); }
/// <summary> /// 查询上传SAP数据明细 /// </summary> /// <param name="filter"></param> /// <param name="TotalCount"></param> /// <returns></returns> public DataTable QuerySAPDOCHeaderDetail(HeaderDataQueryFilter filter, out int TotalCount) { DataCommand command = DataCommandManager.GetDataCommand("GetSAPHeaderDetail"); command.SetParameterValue("@DOC_TYPE", filter.DocType); command.SetParameterValue("@COMP_CODE", filter.SapCoCode); command.SetParameterValue("@PSTNG_DATE", filter.UploadDate); TotalCount = Convert.ToInt32(command.GetParameterValue("TotalCount")); return(command.ExecuteDataTable()); }
/// <summary> /// 查询上传SAP数据 /// </summary> /// <param name="filter"></param> /// <param name="TotalCount"></param> /// <returns></returns> public DataTable QuerySAPDOCHeader(HeaderDataQueryFilter filter, out int TotalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetHeaderData"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "[InDate] DESC")) { AddSAPDOCHeaderParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList(); codeNameColList.Add("DOC_TYPE", "Invoice", "DocumentType"); cmd.ConvertCodeNamePairColumn(dt, codeNameColList); TotalCount = Convert.ToInt32(cmd.GetParameterValue("TotalCount")); return(dt); } }
private void AddSAPDOCHeaderParameters(HeaderDataQueryFilter filter, CustomDataCommand cmd, DynamicQuerySqlBuilder sb) { if (filter.UploadDateFrom.HasValue) { sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "[PSTNG_DATE]", DbType.DateTime, "@UploadDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.UploadDateFrom); } if (filter.UploadDateTo.HasValue) { sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "[PSTNG_DATE]", DbType.DateTime, "@UploadDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.UploadDateTo); } if (!string.IsNullOrEmpty(filter.DocType)) { sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "[DOC_TYPE]", DbType.String, "@DOC_TYPE", QueryConditionOperatorType.Equal, filter.DocType); } if (filter.SapCoCode != ResCommonEnum.Enum_All) { sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "[COMP_CODE]", DbType.String, "@COMP_CODE", QueryConditionOperatorType.Equal, filter.SapCoCode); } cmd.CommandText = sb.BuildQuerySql(); }
/// <summary> /// 查询SAP明细数据 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void HeaderDataDetailsQuery(HeaderDataQueryFilter filter, EventHandler<RestClientEventArgs<dynamic>> callback) { string relativeUrl = "/InvoiceService/HeaderData/QuerySAPDOCHeaderDetails"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
public UCHeaderDataDetails(HeaderDataQueryFilter filter) { this.Filter = filter; InitializeComponent(); Loaded += new RoutedEventHandler(UCHeaderDataDetails_Loaded); }