示例#1
0
        public virtual QueryResultList QueryRMAProductInventory(RMAInventoryQueryFilter request)
        {
            QueryResultList resultList = new QueryResultList();
            int             totalCount;
            decimal         totalMisCost;
            var             dataTable = ObjectFactory <IReportQueryDA> .Instance.QueryRMAProductInventory(request, out totalCount, out totalMisCost);

            QueryResult resultTable = new QueryResult()
            {
                Data       = dataTable,
                TotalCount = totalCount
            };
            DataTable dt = new DataTable();

            dt.Columns.Add("TotleMisCost", typeof(decimal));
            dt.Rows.Add(totalMisCost);

            QueryResult MisCost = new QueryResult()
            {
                Data = dt
            };

            resultList.Add(resultTable);
            resultList.Add(MisCost);
            return(resultList);
        }
示例#2
0
        public virtual QueryResult QueryRMAProductInventoryForExport(RMAInventoryQueryFilter request)
        {
            int     totalCount;
            decimal totalMisCost;
            var     dataTable = ObjectFactory <IReportQueryDA> .Instance.QueryRMAProductInventory(request, out totalCount, out totalMisCost);

            return(new QueryResult()
            {
                Data = dataTable,
                TotalCount = totalCount
            });
        }
示例#3
0
        /// <summary>
        /// NoBizQuery RMA单件库存
        /// </summary>
        /// <param name="filter">查询条件</param>
        /// <param name="totalCount">out数据条数</param>
        /// <returns>DataTable</returns>
        public virtual DataTable QueryRMAItemInventory(RMAInventoryQueryFilter filter, out int totalCount)
        {
            PagingInfoEntity pagingEntity = new PagingInfoEntity();

            pagingEntity.SortField     = filter.PagingInfo.SortBy;
            pagingEntity.MaximumRows   = filter.PagingInfo.PageSize;
            pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
            var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryGetRMAItemsInventory");

            using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " A.SysNo "))
            {
                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status",
                                                             DbType.Int32, "@Status", QueryConditionOperatorType.Equal, RMARequestStatus.Handling);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.RecvTime",
                                                             DbType.DateTime, "@RecvTime", QueryConditionOperatorType.IsNotNull, DBNull.Value);


                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.SysNo",
                                                             DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.ProductSysNo);


                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.OwnBy",
                                                             DbType.Int32, "@OwnBy", QueryConditionOperatorType.Equal, filter.RMAOwnBy);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNo",
                                                             DbType.Int32, "@RMASysNo", QueryConditionOperatorType.Equal, filter.RMASysNo);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.LocationWarehouse",
                                                             DbType.AnsiStringFixedLength, "@LocationWarehouse", QueryConditionOperatorType.Equal, filter.LocationWarehouse);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.OwnByWarehouse",
                                                             DbType.AnsiStringFixedLength, "@OwnByWarehouse", QueryConditionOperatorType.Equal, filter.OwnByWarehouse);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CompanyCode",
                                                             DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);

                cmd.CommandText = sqlBuilder.BuildQuerySql();
                EnumColumnList enumList = new EnumColumnList();
                enumList.Add("OutBoundStatus", typeof(RMAOutBoundStatus));
                enumList.Add("RevertStatus", typeof(RMARevertStatus));
                enumList.Add("RefundStatus", typeof(RMARefundStatus));
                enumList.Add("NewProductStatus", typeof(RMANewProductStatus));
                enumList.Add("ReturnStatus", typeof(RMAReturnStatus));
                DataTable dt = cmd.ExecuteDataTable(enumList);
                totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
                return(dt);
            }
        }
示例#4
0
        public void ExportRMAItemExcelFile(RMAInventoryQueryVM queryVM, ColumnSet[] columns)
        {
            RMAInventoryQueryFilter queryFilter = new RMAInventoryQueryFilter();

            queryFilter            = queryVM.ConvertVM <RMAInventoryQueryVM, RMAInventoryQueryFilter>();
            queryFilter.PagingInfo = new PagingInfo
            {
                PageSize  = ConstValue.MaxRowCountLimit,
                PageIndex = 0,
                SortBy    = string.Empty
            };
            queryFilter.CompanyCode = CPApplication.Current.CompanyCode;

            string relativeUrl = "/RMAService/Report/RMAInventory/QueryRMAItem";

            restClient.ExportFile(relativeUrl, queryFilter, columns);
        }
示例#5
0
        /// <summary>
        /// NoBizQuery RMA商品库存
        /// </summary>
        /// <param name="filter">查询条件</param>
        /// <param name="totalCount">out 数据数量</param>
        /// <param name="totalMisCost">out 未税(增值税)成本</param>
        /// <returns>DataTable</returns>
        public virtual DataTable QueryRMAProductInventory(RMAInventoryQueryFilter filter, out int totalCount, out decimal totalMisCost)
        {
            PagingInfoEntity pagingEntity = new PagingInfoEntity();

            pagingEntity.SortField     = filter.PagingInfo.SortBy;
            pagingEntity.MaximumRows   = filter.PagingInfo.PageSize;
            pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
            var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryRMAProductsInventory");

            using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " p.SysNo "))
            {
                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "R.Status",
                                                             DbType.Int32, "@Status", QueryConditionOperatorType.Equal, RMARequestStatus.Handling);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RMA_Request.RecvTime",
                                                             DbType.DateTime, "@RecvTime", QueryConditionOperatorType.IsNotNull, DBNull.Value);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.SysNo",
                                                             DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, filter.ProductSysNo);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "OwnBy",
                                                             DbType.Int32, "@OWnBy", QueryConditionOperatorType.Equal, filter.RMAOwnBy);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "LocationWarehouse",
                                                             DbType.AnsiStringFixedLength, "@LocationWarehouse", QueryConditionOperatorType.Equal, filter.LocationWarehouse);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "OwnByWarehouse",
                                                             DbType.AnsiStringFixedLength, "@OwnByWarehouse", QueryConditionOperatorType.Equal, filter.OwnByWarehouse);

                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "R.CompanyCode",
                                                             DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);

                cmd.CommandText = sqlBuilder.BuildQuerySql();
                cmd.AddOutParameter("@TotleMisCost", DbType.String, 20);
                DataTable dt = cmd.ExecuteDataTable();
                totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
                object temp = cmd.GetParameterValue("@TotleMisCost");
                decimal.TryParse(temp != null ? temp.ToString() : string.Empty, out totalMisCost);
                return(dt);
            }
        }
示例#6
0
        public virtual QueryResult QueryRMAItemInventory(RMAInventoryQueryFilter request)
        {
            int       totalCount;
            DataTable dataTable = ObjectFactory <IReportQueryDA> .Instance.QueryRMAItemInventory(request, out totalCount);

            dataTable.Columns.Add("Inventory", typeof(int));
            if (dataTable.Rows.Count > 0)
            {
                foreach (DataRow dr in dataTable.Rows)
                {
                    RMAOutBoundStatus OutBoundStatus;
                    if (!Enum.TryParse(dr["OutBoundStatus"].ToString(), out OutBoundStatus))
                    {
                        //转换失败赋个条件判断不需要的值...
                        OutBoundStatus = RMAOutBoundStatus.Abandon;
                    }
                    RMARevertStatus RevertStatus;
                    if (!Enum.TryParse(dr["RevertStatus"].ToString(), out RevertStatus))
                    {
                        RevertStatus = RMARevertStatus.Abandon;
                    }
                    RMANewProductStatus NewProductStatus;
                    if (!Enum.TryParse(dr["NewProductStatus"].ToString(), out NewProductStatus))
                    {
                        NewProductStatus = RMANewProductStatus.OtherProduct;
                    }

                    dr["Inventory"] = (OutBoundStatus == RMAOutBoundStatus.SendAlready ||
                                       RevertStatus == RMARevertStatus.Reverted &&
                                       NewProductStatus == RMANewProductStatus.Origin) ? 0 : 1;
                }
            }

            return(new QueryResult()
            {
                Data = dataTable,
                TotalCount = totalCount
            });
        }
示例#7
0
        public void QueryRMAItemInventory(RMAInventoryQueryVM queryVM, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
        {
            RMAInventoryQueryFilter queryFilter = new RMAInventoryQueryFilter();

            queryFilter            = queryVM.ConvertVM <RMAInventoryQueryVM, RMAInventoryQueryFilter>();
            queryFilter.PagingInfo = new PagingInfo
            {
                PageSize  = PageSize,
                PageIndex = PageIndex,
                SortBy    = SortField
            };
            queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
            string relativeUrl = "/RMAService/Report/RMAInventory/QueryRMAItem";

            restClient.QueryDynamicData(relativeUrl, queryFilter, (obj, args) =>
            {
                if (args.FaultsHandle())
                {
                    return;
                }
                callback(obj, args);
            });
        }