private ActionResult GetPages(RtnStockSeacher condition, string where)
        {
            PageJsonModel <ScaleRtnStokeDetail> page = new PageJsonModel <ScaleRtnStokeDetail>();

            page.pageIndex = condition.pageIndex;
            page.pageSize  = condition.pageSize;
            page.strForm   = "ScaleRtnStoke s left join C_User as c on c.UserName=s.Consignee";
            page.strSelect = " s.ReturnTime,s.BigCode,s.MiddleCode,s.SmallCode,s.OrderNo,s.OutTime,s.OutOrderNo,c.Name ";
            page.strWhere  = where;
            if (string.IsNullOrWhiteSpace(condition.orderby) == false)
            {
                page.strOrder = Common.FilteSQLStr(condition.orderby);
            }
            else
            {
                page.strOrder = "ReturnTime desc";
            }

            page.LoadList();
            if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
            {
                return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
            }
            return(Json("", JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetRecordPageDetail(RtnStockSeacher condition)
        {
            string where = string.Empty;

            if (!string.IsNullOrWhiteSpace(condition.OrderNo))
            {
                where += string.Format(" and OrderNo='{0}'", Common.Filter(condition.OrderNo));
            }

            if (condition.RtnWay != 0)
            {
                where += string.Format(" and RtnWay={0}", condition.RtnWay);

                string codeStr = "SmallCode";
                if (condition.RtnWay == 2)
                {
                    codeStr = "MiddleCode";
                }
                if (condition.RtnWay == 3)
                {
                    codeStr = "BigCode";
                }

                if (!string.IsNullOrWhiteSpace(condition.BarCode))
                {
                    where += string.Format(" and {0}='{1}'", codeStr, Common.Filter(condition.BarCode));
                }
            }

            return(GetPages(condition, where));
        }
        public ActionResult GetSmallCodePage(RtnStockSeacher condition)
        {
            string where = string.Empty;

            if (condition.ReturnTime != 0)
            {
                where += string.Format(" and ReturnTime>={0} and ReturnTime<{1}", condition.ReturnTime, condition.ReturnTime + 86400);
            }
            if (!string.IsNullOrWhiteSpace(condition.OrderNo))
            {
                where += string.Format(" and OrderNo='{0}'", Common.Filter(condition.OrderNo));
            }
            if (!string.IsNullOrWhiteSpace(condition.BigCode))
            {
                where += string.Format(" and BigCode='{0}'", Common.Filter(condition.BigCode));
            }
            if (!string.IsNullOrWhiteSpace(condition.MiddleCode))
            {
                where += string.Format(" and MiddleCode='{0}'", Common.Filter(condition.MiddleCode));
            }
            if (!string.IsNullOrWhiteSpace(condition.ProductNo))
            {
                where += string.Format(" and ProducctNo='{0}'", Common.Filter(condition.ProductNo));
            }

            if (!string.IsNullOrWhiteSpace(condition.keyword))
            {
                where += string.Format(" and SmallCode like '%{0}%'", Common.Filter(condition.keyword));
            }

            return(GetPages(condition, where));
        }