public DataTable AccruedByVendor(AccruedQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_AccruedByVendor"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "accrued.AccruePeriod ASC")) { AddAccruedByVendorParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable LogQuery(VendorSystemQueryFilter filter, out int dataCount) { if (filter.PagingInfo.SortBy != null) { string sortCondition = filter.PagingInfo.SortBy.Trim(); Match match = Regex.Match(sortCondition, @"^(?<SortColumn>[\S]+)(?:\s+(?<SortType>ASC|DESC))?$", RegexOptions.IgnoreCase); if (match.Groups["SortColumn"].Success) { string sortColumn = match.Groups["SortColumn"].Value; string sortType = match.Groups["SortType"].Success ? match.Groups["SortType"].Value : "DESC"; switch (sortColumn) { case "Region": filter.PagingInfo.SortBy = String.Format("{0} {1}", "l.RegionSysNo", sortType); break; case "Category": filter.PagingInfo.SortBy = String.Format("{0} {1}", "l.CategorySysNo", sortType); break; case "Date": filter.PagingInfo.SortBy = String.Format("{0} {1}", "l.LogCreateDate", sortType); break; case "ReferenceKey": filter.PagingInfo.SortBy = String.Format("{0} {1}", "l.ReferenceKey", sortType); break; case "LogType": filter.PagingInfo.SortBy = String.Format("{0} {1}", "l.LogType", sortType); break; } } } CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_VendorLogs"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder( command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "l.SysNo DESC")) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "l.RegionSysNo", DbType.Int32, "@RegionSysNo", QueryConditionOperatorType.Equal, filter.RegionSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "l.CategorySysNo", DbType.Int32, "@CategorySysNo", QueryConditionOperatorType.Equal, filter.CategorySysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "l.LogCreateDate", DbType.DateTime, "@DateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.DateFrom); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "l.LogCreateDate", DbType.DateTime, "@DateTo", QueryConditionOperatorType.LessThanOrEqual, filter.DateTo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "l.LogType", DbType.AnsiStringFixedLength, "@LogType", QueryConditionOperatorType.Equal, filter.LogType); command.CommandText = builder.BuildQuerySql(); var dt = command.ExecuteDataTable(); dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }
/// <summary> /// 查询VendorProdcut /// </summary> /// <returns></returns> public DataTable VendorProductQuery(VendorProductQueryFilter filter, out int TotalCount) { CustomDataCommand command = DataCommandManager. CreateCustomDataCommandFromConfig("External_Query_VendorProduct"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "a.SysNo DESC")) { sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ProductType", DbType.Int32, "@ProductType", QueryConditionOperatorType.Equal, 0); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.Int32, "@Status", QueryConditionOperatorType.MoreThanOrEqual, 0); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ManufacturerSysNo", DbType.Int32, "@ManufacturerSysNo", QueryConditionOperatorType.Equal, filter.VendorManufacturerSysNo); command.AddInputParameter("@UserSysNo", DbType.Int32, filter.UserSysNo); if (filter.C3SysNo.HasValue) { sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.C3SysNo", DbType.Int32, "@C3SysNo", QueryConditionOperatorType.Equal, filter.C3SysNo); } else { if (filter.C2SysNo.HasValue) { ConditionConstructor subQueryBuilder = sb.ConditionConstructor.AddSubQueryCondition( QueryConditionRelationType.AND, "a.C3SysNo", QueryConditionOperatorType.In, @"SELECT [Category3Sysno] FROM [OverseaContentManagement].[dbo].[V_CM_CategoryInfo] WHERE [Category2Sysno]=@C2SysNo"); command.AddInputParameter("@C2SysNo", DbType.Int32, filter.C2SysNo); } } if (!filter.IsAuto) { QueryConditionOperatorType ot = QueryConditionOperatorType.Exist; if (!filter.IsMapping) { ot = QueryConditionOperatorType.NotExist; } sb.ConditionConstructor.AddSubQueryCondition( QueryConditionRelationType.AND, null, ot, @"SELECT TOP 1 1 FROM [IPP3].[dbo].VendorUser_ProductMapping WHERE ProductSysNo=a.sysno AND UserSysNo=@UserSysNo AND VendorExSysNo=@VendorExSysNo"); } sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "a.MerchantSysNo", DbType.Int32, "@MerchantSysNo", QueryConditionOperatorType.Equal, filter.VendorSysNo); command.AddInputParameter( "@VendorManufacturerSysNo", DbType.Int32, filter.ManufacturerSysNo); command.CommandText = sb.BuildQuerySql(); DataTable dt = command.ExecuteDataTable(); TotalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable AccruedByRule(AccruedQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_AccruedByRule"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "accrued.AccruePeriod ASC,accrued.AssignedCode ASC")) { AddAccruedByRuleParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); EnumColumnList enumColList = new EnumColumnList(); CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList(); codeNameColList.Add("EIMSType", "ExternalSYS", "EIMSType"); codeNameColList.Add("RuleStatus", "ExternalSYS", "RuleStatus"); cmd.ConvertColumn(dt, enumColList, codeNameColList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable RoleQuery(VendorRoleQueryFilter filter, out int dataCount) { if (filter.PagingInfo != null && filter.PagingInfo.SortBy != null) { string sortCondition = filter.PagingInfo.SortBy.Trim(); Match match = Regex.Match(sortCondition, @"^(?<SortColumn>[\S]+)(?:\s+(?<SortType>ASC|DESC))?$", RegexOptions.IgnoreCase); if (match.Groups["SortColumn"].Success) { string sortColumn = match.Groups["SortColumn"].Value; string sortType = match.Groups["SortType"].Success ? match.Groups["SortType"].Value : "DESC"; #region switch switch (sortColumn) { case "SysNo": filter.PagingInfo.SortBy = String.Format("{0} {1}", "SysNo", sortType); break; case "RoleName": filter.PagingInfo.SortBy = String.Format("{0} {1}", "RoleName", sortType); break; case "Status": filter.PagingInfo.SortBy = String.Format("{0} {1}", "Status", sortType); break; case "InUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "InUser", sortType); break; case "InDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "InDate", sortType); break; case "EditUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "EditUser", sortType); break; case "EditDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "EditDate", sortType); break; } #endregion } } CustomDataCommand command = DataCommandManager. CreateCustomDataCommandFromConfig("ExternalSYS_Query_VendorRole"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder( command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "SysNo DESC")) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.RoleSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RoleName", DbType.String, "@RoleName", QueryConditionOperatorType.LeftLike, filter.RoleName); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, filter.Status); if (!string.IsNullOrEmpty(filter.PrivilegeName)) { ConditionConstructor subQueryBuilder = builder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, null, QueryConditionOperatorType.Exist, @"SELECT 1 FROM ( SELECT [RoleSysNo] FROM [IPP3].[dbo].[VendorUser_Role_Privilege] WITH(NOLOCK) WHERE [PrivilegeSysNo] IN ( SELECT [SysNo] FROM [IPP3].[dbo].[VendorUser_Privilege] WITH(NOLOCK) WHERE [Memo] LIKE @PrivilegeName ) ) AS RESULT WHERE RESULT.[RoleSysNo]=[VendorUser_Role].[SysNo]"); command.AddInputParameter("@PrivilegeName", DbType.String, filter.PrivilegeName + "%"); } command.CommandText = builder.BuildQuerySql(); var dt = command.ExecuteDataTable("Status", typeof(ValidStatus)); dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable UserQuery(VendorUserQueryFilter filter, out int dataCount) { if (filter.PagingInfo.SortBy != null) { string sortCondition = filter.PagingInfo.SortBy.Trim(); Match match = Regex.Match(sortCondition, @"^(?<SortColumn>[\S]+)(?:\s+(?<SortType>ASC|DESC))?$", RegexOptions.IgnoreCase); if (match.Groups["SortColumn"].Success) { string sortColumn = match.Groups["SortColumn"].Value; string sortType = match.Groups["SortType"].Success ? match.Groups["SortType"].Value : "DESC"; #region switch switch (sortColumn) { case "SysNo": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.SysNo", sortType); break; case "RoleName": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.RoleName", sortType); break; case "Status": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.Status", sortType); break; case "InUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.InUser", sortType); break; case "InDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.InDate", sortType); break; case "EditUser": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.EditUser", sortType); break; case "EditDate": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.EditDate", sortType); break; case "VendorSysNo": filter.PagingInfo.SortBy = String.Format("{0} {1}", "a.VendorSysNo", sortType); break; case "VendorName": filter.PagingInfo.SortBy = String.Format("{0} {1}", "b.VendorName", sortType); break; case "VendorStatus": filter.PagingInfo.SortBy = String.Format("{0} {1}", "b.Status", sortType); break; case "Rank": filter.PagingInfo.SortBy = String.Format("{0} {1}", "b.Rank", sortType); break; case "IsConsign": filter.PagingInfo.SortBy = String.Format("{0} {1}", "b.IsConsign", sortType); break; } #endregion } } CustomDataCommand command = DataCommandManager. CreateCustomDataCommandFromConfig("External_Query_Vendor"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder( command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "a.SysNo DESC")) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); if (!string.IsNullOrEmpty(filter.SerialNum)) { string[] serialNum = filter.SerialNum.Split('-'); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.VendorSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, serialNum[0]); if (serialNum.Length > 1) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.UserNum", DbType.Int32, "@UserNum", QueryConditionOperatorType.Equal, Convert.ToInt32(serialNum[1]).ToString()); } } builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.UserName", DbType.String, "@UserName", QueryConditionOperatorType.LeftLike, filter.UserName); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.UserID", DbType.String, "@UserID", QueryConditionOperatorType.LeftLike, filter.UserID); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, LegacyEnumMapper.ConvertValidStatus(filter.UserStatus)); if (filter.RoleSysNo.HasValue) { builder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); ConditionConstructor subQueryBuilder = builder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, null, QueryConditionOperatorType.Exist, @"SELECT TOP 1 1 FROM (SELECT UserSysNo FROM [IPP3].[dbo].[VendorUser_User_Role] WITH(NOLOCK) WHERE RoleSysNo=@RoleSysNo ) AS RESULT WHERE RESULT.[UserSysNo]=a.[SysNo]"); builder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.OR, null, QueryConditionOperatorType.Exist, @"SELECT TOP 1 1 FROM (SELECT UserSysNo FROM [IPP3].[dbo].[VendorUser_RoleMapping] WITH(NOLOCK) WHERE RoleSysNo=@RoleSysNo ) AS RESULT WHERE RESULT.[UserSysNo]=a.[SysNo]"); command.AddInputParameter("@RoleSysNo", DbType.Int32, filter.RoleSysNo); builder.ConditionConstructor.EndGroupCondition(); } builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.VendorSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, filter.VendorSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.VendorName", DbType.String, "@VendorName", QueryConditionOperatorType.Like, filter.VendorName); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.ExpiredDate", DbType.DateTime, "@ExpiredDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.ExpiredDateFrom); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.ExpiredDate", DbType.DateTime, "@ExpiredDateTo", QueryConditionOperatorType.LessThanOrEqual, filter.ExpiredDateTo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.Contact", DbType.String, "@Contact", QueryConditionOperatorType.LeftLike, filter.Contact); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.Phone", DbType.String, "@Phone", QueryConditionOperatorType.LeftLike, filter.Phone); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.Address", DbType.String, "@Address", QueryConditionOperatorType.LeftLike, filter.Address); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.Status", DbType.Int32, "@VendorStatus", QueryConditionOperatorType.Equal, filter.VendorStatus); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.Rank", DbType.String, "@Rank", QueryConditionOperatorType.Equal, filter.Rank); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.IsConsign", DbType.Int32, "@IsConsign", QueryConditionOperatorType.Equal, filter.ConsignType); if (filter.ManufacturerSysNo.HasValue || (!string.IsNullOrEmpty(filter.AgentLevel) && filter.AgentLevel.Trim() != "") || filter.C1SysNo.HasValue) { string subCond = @"SELECT distinct [VendorSysNo] FROM dbo.Vendor_Manufacturer WITH(NOLOCK) "; string strWhere = string.Empty; //代理品牌 二级类 三级类 代理级别 if (filter.ManufacturerSysNo.HasValue) { strWhere += "ManufacturerSysNo=@ManufacturerSysNo"; command.AddInputParameter("@ManufacturerSysNo", DbType.Int32, filter.ManufacturerSysNo); } if (!string.IsNullOrEmpty(filter.AgentLevel) && filter.AgentLevel.Trim() != "") { if (strWhere != string.Empty) { strWhere += " AND "; } strWhere += "AgentLevel=@AgentLevel"; command.AddInputParameter("@AgentLevel", DbType.String, filter.AgentLevel); } if (filter.C3SysNo.HasValue) { if (strWhere != string.Empty) { strWhere += " AND "; } strWhere += "C3SysNo=@C3SysNo"; command.AddInputParameter("@C3SysNo", DbType.Int32, filter.C3SysNo); } else { if (filter.C2SysNo.HasValue) { if (strWhere != string.Empty) { strWhere += " AND "; } strWhere += "C2SysNo=@C2SysNo"; command.AddInputParameter("@C2SysNo", DbType.Int32, filter.C2SysNo); } else { if (filter.C1SysNo.HasValue) { if (strWhere != string.Empty) { strWhere += " AND "; } strWhere += @"C2SysNo in (SELECT [Category2Sysno] FROM [OverseaContentManagement].[dbo].[V_CM_CategoryInfo] WITH(NOLOCK) WHERE [Category1Sysno]=@C1SysNo)"; command.AddInputParameter("@C1SysNo", DbType.Int32, filter.C1SysNo); } } } if (!string.IsNullOrEmpty(strWhere)) { subCond += "WHERE status=0 and " + strWhere; } builder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "b.SysNo", QueryConditionOperatorType.In, subCond); } command.CommandText = builder.BuildQuerySql(); var dt = command.ExecuteDataTable(); EnumColumnList enumColList = new EnumColumnList(); enumColList.Add("IsConsign", typeof(ECCentral.BizEntity.PO.VendorConsignFlag)); enumColList.Add("Status", typeof(ECCentral.BizEntity.ExternalSYS.ValidStatus)); enumColList.Add("VendorStatus", typeof(VendorStatus)); command.ConvertEnumColumn(dt, enumColList); dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable InvoiceInfoListQuery(EIMSInvoiceEntryQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("EIMS_Query_InvoiceInfoList"); MapSortField(filter); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "ei.CreateDate DESC")) { AddInvoiceInfoListParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); EnumColumnList enumColList = new EnumColumnList(); enumColList.Add("Status", typeof(InvoiceStatus)); enumColList.Add("EIMSType", typeof(EIMSType)); enumColList.Add("ReceiveType", typeof(ReceiveType)); cmd.ConvertEnumColumn(dt, enumColList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public List <EIMSInvoiceEntryInfo> InvoiceInfoListQuery(EIMSInvoiceEntryQueryFilter filter) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("EIMS_Query_InvoiceInfoList"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "ei.CreateDate DESC")) { AddInvoiceInfoListParameters(filter, cmd, sb); return(cmd.ExecuteEntityList <EIMSInvoiceEntryInfo>()); } }
public DataTable EIMSEventMemoQuery(EIMSEventMemoQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("EIMSEventMemoQuery"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "EventDate DESC")) { AddEIMSEventMemoQueryParameters(filter, sb, cmd); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable ReceiveByVendorQuery(ReceivedReportQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_ReceiveByVendor"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "vendor.SysNo ASC")) { AddReceiveByVendorParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); EnumColumnList enumColList = new EnumColumnList(); CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList(); codeNameColList.Add("EIMSType", "ExternalSYS", "EIMSType"); cmd.ConvertColumn(dt, enumColList, codeNameColList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable ARReceiveDetialsQuery(ReceivedReportQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_InvoiceDetailByVendor"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "VendorNumber,InvoiceNumber")) { AddARReceiveDetialsParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable ReceiveByYearQuery(ReceivedReportQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_ReceiveByYear"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "vendor.SysNo ASC")) { AddReceiveByYearParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataTable ARReceiveQuery(ReceivedReportQueryFilter filter, out int totalCount) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_ReportByItem"); using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "VendorNumber")) { cmd.AddInputParameter("@PageSize", DbType.Int32, filter.PagingInfo.PageSize); cmd.AddInputParameter("@PageIndex", DbType.Int32, filter.PagingInfo.PageIndex); AddARReceiveParameters(filter, cmd, sb); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }