Example #1
0
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public Response <GetASNDetailByConditionResponse> GetExportAsnandDetailByCondition(GetASNByConditionRequest request)
        {
            Response <GetASNDetailByConditionResponse> response = new Response <GetASNDetailByConditionResponse>()
            {
                Result = new GetASNDetailByConditionResponse()
            };

            if (request == null || request.SearchCondition == null)
            {
                ArgumentNullException ex = new ArgumentNullException("GetExportAsnandDetailByCondition request");
                LogError(ex);
                response.ErrorCode = ErrorCode.Argument;
                response.Exception = ex;
                return(response);
            }

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                response.Result    = accessor.GetExportAsnandDetailByCondition(request.SearchCondition);
                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #2
0
        //明细单条的查看或者编辑
        public Response <ASNAndASNDetail> GetASNInfosSF(GetASNByConditionRequest request)
        {
            Response <ASNAndASNDetail> response = new Response <ASNAndASNDetail>();

            if (request == null)
            {
                ArgumentNullException ex = new ArgumentNullException("GetASNByConditionRequest request");
                LogError(ex);
                response.ErrorCode = ErrorCode.Argument;
                response.Exception = ex;
                return(response);
            }

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                response.Result    = accessor.GetASNInfosSF(request.ID);
                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #3
0
        /// <summary>
        /// 根据单号查扫描情况
        /// </summary>
        /// <param name="AsnNumber"></param>
        /// <returns></returns>
        public Response <GetASNByConditionResponse> GetASNScanByAsnNumber(string AsnNumber)
        {
            Response <GetASNByConditionResponse> response = new Response <GetASNByConditionResponse>()
            {
                Result = new GetASNByConditionResponse()
            };

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();

                response.Result = accessor.GetASNScanByAsnNumber(AsnNumber);

                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #4
0
        public Response <GetASNDetailByConditionResponse> GetASNDetailByConditionResponseSF(GetASNByConditionRequest request)
        {
            Response <GetASNDetailByConditionResponse> response = new Response <GetASNDetailByConditionResponse>()
            {
                Result = new GetASNDetailByConditionResponse()
            };

            if (request == null || request.SearchCondition == null)
            {
                ArgumentNullException ex = new ArgumentNullException("GetASNDetailByConditionResponse request");
                LogError(ex);
                response.ErrorCode = ErrorCode.Argument;
                response.Exception = ex;
                return(response);
            }
            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                int RowCount;
                response.Result           = accessor.GetASNandasndetailByConditionSF(request.SearchCondition, request.PageIndex, request.PageSize, out RowCount);
                response.Result.PageCount = RowCount % request.PageSize == 0 ? RowCount / request.PageSize : RowCount / request.PageSize + 1;
                response.Result.PageIndex = request.PageIndex;

                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #5
0
        /// <summary>
        /// 根据状态查询明细
        /// </summary>
        /// <param name="search"></param>
        /// <param name="type"></param>
        /// <returns></returns>
        public Response <GetASNByConditionResponse> SearchReceiptOrderTotal(ASNSearchCondition search, int type)
        {
            Response <GetASNByConditionResponse> response = new Response <GetASNByConditionResponse>()
            {
                Result = new GetASNByConditionResponse()
            };

            if (search == null)
            {
                ArgumentNullException ex = new ArgumentNullException("GetASNStatusByConditionRequest request");
                LogError(ex);
                response.ErrorCode = ErrorCode.Argument;
                response.Exception = ex;
                return(response);
            }

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                response.Result.ASNCollection = accessor.SearchReceiptOrderTotal(search, type);
                response.IsSuccess            = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #6
0
        ///查询取消入库单数据
        public Response <GetASNDetailByConditionResponse> GetCancelAsnAndAsnDetail(string strwhere)
        {
            Response <GetASNDetailByConditionResponse> response = new Response <GetASNDetailByConditionResponse>()
            {
                Result = new GetASNDetailByConditionResponse()
            };


            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();

                response.Result = accessor.GetCancelAsnAndAsnDetail(strwhere);


                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #7
0
        /// <summary>
        /// 导入包装信息
        /// </summary>
        /// <param name="packageinfo"></param>
        ///  <param name="Proc">调用不同存储过程</param>
        /// <returns></returns>
        public Response <string> ImportPackageInfo(AddPackageAndDetailRequest Requset, string Proc)
        {
            Response <string> response = new Response <string>();
            string            error    = string.Empty;

            try
            {
                error = new ASNManagementAccessor().ImportPackageInfo(Requset, Proc);
                if (error == "1")
                {
                    response.IsSuccess = true;
                }
                else
                {
                    response.IsSuccess      = false;
                    response.SuccessMessage = error;
                }
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.IsSuccess      = false;
                response.SuccessMessage = ex.Message;
                response.ErrorCode      = ErrorCode.Technical;
            }
            return(response);
        }
Example #8
0
        //批量完成操作
        public bool CompletALLSelect(string asnid)
        {
            bool ve = true;

            try
            {
                ve = new ASNManagementAccessor().CompletALLSelect(asnid);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(ve);
        }
Example #9
0
        //NIKE退货仓-
        public int UDnewboxPrintedTimes(string customerid, string warehouseid, string boxids)
        {
            int s = 0;

            try
            {
                s = new ASNManagementAccessor().UDnewboxPrintedTimes(customerid, warehouseid, boxids);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(s);
        }
Example #10
0
        public int ExternKeyCheck_TH(string pon, string ern, string plno, string flag, long CustomerID)
        {
            int i = 0;

            try
            {
                i = new ASNManagementAccessor().ExternKeyCheck_TH(pon, ern, plno, flag, CustomerID);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(i);
        }
Example #11
0
        //NIKE退货仓-
        public int Insertnewbox(string customerid, string ExternReceiptNumber, int total, string warehouseid, string GoodsType)
        {
            int s = 0;

            try
            {
                s = new ASNManagementAccessor().Insertnewbox(customerid, ExternReceiptNumber, total, warehouseid, GoodsType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(s);
        }
Example #12
0
        public string AsnScanQtyUpdate(string AsnNumber, string str2, string SKU, string Creator)
        {
            string message = "";

            try
            {
                message = new ASNManagementAccessor().AsnScanQtyUpdate(AsnNumber, str2, SKU, Creator);
            }
            catch (Exception ex)
            {
                message = ex.Message;
            }
            return(message);
        }
Example #13
0
        public int CountAsn(string ExternNumber, long customerID)
        {
            int s = 0;

            try
            {
                s = new ASNManagementAccessor().CountAsn(ExternNumber, customerID);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(s);
        }
Example #14
0
        public IEnumerable <Receipt> CountReceipt(int ID)
        {
            IEnumerable <Receipt> s = new List <Receipt>();

            try
            {
                s = new ASNManagementAccessor().CountReceipt(ID);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(s);
        }
Example #15
0
        //完成操作
        public bool Complet(int ID)
        {
            bool ve = true;

            try
            {
                ve = new ASNManagementAccessor().Complet(ID);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(ve);
        }
Example #16
0
        //批量取消操作
        public bool StatusBacks(string asnid)
        {
            bool ve = true;

            try
            {
                ve = new ASNManagementAccessor().StatusBacks(asnid);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(ve);
        }
Example #17
0
        public int ExternKeyCheckSF(string keys, string flag, long CustomerID)
        {
            int i = 0;

            try
            {
                i = new ASNManagementAccessor().ExternKeyCheckSF(keys, flag, CustomerID);
            }
            catch (Exception ex)
            {
                LogError(ex);
            }
            return(i);
        }
Example #18
0
        public List <ASNDetail> CheckDiffReturn(string AsnNumber, string ScanBoxNumber)
        {
            List <ASNDetail> lists = new List <ASNDetail>();

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();

                lists = accessor.CheckDiffReturn(AsnNumber, ScanBoxNumber);
            }
            catch (Exception ex)
            {
            }

            return(lists);
        }
Example #19
0
        public string ClearAsnBoxNumber(string AsnNumber, string ScanBoxNumber)
        {
            string response = "";

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();

                response = accessor.ClearAsnBoxNumber(AsnNumber, ScanBoxNumber);
            }
            catch (Exception ex)
            {
                response = ex.Message;
            }

            return(response);
        }
Example #20
0
        /// <summary>
        /// 根据状态查询明细
        /// </summary>
        /// <param name="search"></param>
        /// <param name="type"></param>
        /// <returns></returns>
        public Response <int> TurnASN(int Id, int CustomerId)
        {
            Response <int> response = new Response <int>()
            {
                Result = 0
            };

            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                response.Result    = accessor.TurnASN(Id, CustomerId);
                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #21
0
        //导出选中
        public Response <GetASNDetailByConditionResponse> GetReceiptByIDs(string IDs)
        {
            Response <GetASNDetailByConditionResponse> response = new Response <GetASNDetailByConditionResponse>()
            {
                Result = new GetASNDetailByConditionResponse()
            };



            try
            {
                ASNManagementAccessor accessor = new ASNManagementAccessor();
                //int RowCount;
                //if (request.PageSize > 0)
                //{
                response.Result = accessor.GetReceiptByIDs(IDs);

                //}
                //else
                //{
                //    response.Result.PageIndex = 0;
                //    response.Result.PageCount = 0;
                //    response.Result.ReceiptCollection = accessor.GetWarehouseByConditionNoPaging(request.SearchCondition);
                //}
                response.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.Exception = ex;
                response.IsSuccess = false;
                response.ErrorCode = ErrorCode.Technical;
            }

            return(response);
        }
Example #22
0
        /// <summary>
        /// 添加操作
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public Response <string> AddasnAndasnDetailSF(AddASNandASNDetailRequest request)
        {
            Response <string> response = new Response <string>();

            string message = "";

            if (request == null || request.asn == null || !request.asn.Any())
            {
                ArgumentNullException ex = new ArgumentNullException("AddasnAndasnDetail request");
                LogError(ex);
                response.ErrorCode = ErrorCode.Argument;
                response.Exception = ex;
                response.Result    = ex.ToString();
                response.IsSuccess = false;
                return(response);
            }
            try
            {
                //判断明细中同一外部单号中是否存在相同的sku   如果存在就提示
                DataTable dt = request.asnDetails.ToDataTable();
                if (request.asn.Select(c => c.CustomerID).ToArray().FirstOrDefault() != 71)
                {//永兴判断
                    var dt1 = from t in dt.AsEnumerable()
                              group t by new { t1 = t.Field <string>("ExternReceiptNumber"), t2 = t.Field <string>("SKU"), UPC = t.Field <string>("UPC"), t3 = t.Field <string>("BoxNumber"), t4 = t.Field <string>("BatchNumber"), t5 = t.Field <string>("Unit"), t6 = t.Field <string>("Specifications") } into m
                        select new
                    {
                        SKU = m.Select(p => p.Field <string>("SKU")).First(),
                        UPC = m.Select(p => p.Field <string>("UPC")).First(),
                        ExternReceiptNumber = m.Select(p => p.Field <string>("ExternReceiptNumber")).First(),
                        BoxNumber           = m.Select(p => p.Field <string>("BoxNumber")).First(),
                        BatchNumber         = m.Select(p => p.Field <string>("BatchNumber")).First(),
                        Unit           = m.Select(p => p.Field <string>("Unit")).First(),
                        Specifications = m.Select(p => p.Field <string>("Specifications")).First(),
                        count          = m.Count(),
                    };

                    var dr1     = dt1.Where(c => c.count > 1);
                    var results = "";
                    if (request.asn.Select(c => c.CustomerID).ToArray().FirstOrDefault() != 74 && request.asn.Select(c => c.CustomerID).ToArray().FirstOrDefault() != 75)
                    {
                        //if (dr1.Count() > 0)
                        //{
                        //    foreach (var item in dr1)
                        //    {
                        //        results += "<p><font color='#FF0000'>外部单号" + item.ExternReceiptNumber + "中的SKU" + item.SKU + "存在重复值!" + "</font></p>";
                        //    }
                        //    response.Result = results;
                        //    response.IsSuccess = false;
                        //    return response;
                        //}
                    }
                }//永兴判断
                message = new ASNManagementAccessor().AddasnAndasnDetailSF(request);

                if (message.Contains("添加成功") || message == "")
                {
                    response.Result    = message;
                    response.IsSuccess = true;
                }
                else
                {
                    response.Result    = message;
                    response.IsSuccess = false;
                }
            }
            catch (Exception ex)
            {
                LogError(ex);
                response.IsSuccess = false;
                response.Result    = ex.ToString();
                response.ErrorCode = ErrorCode.Technical;
            }
            return(response);
        }