예제 #1
0
        /// <summary>
        /// 构造Json
        /// </summary>
        /// <returns></returns>
        private JsonDetail CreateStockinfo(DataTable dt)
        {
            JsonDetail            JsInfo = new JsonDetail();
            List <JsonDetailRows> body   = new List <JsonDetailRows>();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                JsonDetailRows StockBodyRow = new JsonDetailRows();
                StockBodyRow.GOODSID        = dt.Rows[i]["GOODSID"].ToString();
                StockBodyRow.NAME           = dt.Rows[i]["NAME"].ToString();
                StockBodyRow.MODEL          = dt.Rows[i]["MODEL"].ToString();
                StockBodyRow.TRADEMARK      = dt.Rows[i]["TRADEMARK"].ToString();
                StockBodyRow.MID1           = dt.Rows[i]["MID1"].ToString();
                StockBodyRow.Goodsbatch     = dt.Rows[i]["Goodsbatch"].ToString();
                StockBodyRow.QUALITYFLG     = dt.Rows[i]["QUALITYFLG"].ToString();
                StockBodyRow.SHIPPEDNUM     = dt.Rows[i]["SHIPPEDNUM"].ToString();
                StockBodyRow.ARRIVENUM      = dt.Rows[i]["ARRIVENUM"].ToString();
                StockBodyRow.BACKNUM        = dt.Rows[i]["BACKNUM"].ToString();
                StockBodyRow.BACKREASON     = dt.Rows[i]["BACKREASON"].ToString();
                StockBodyRow.LOADINGDOCID   = dt.Rows[i]["LOADINGDOCID"].ToString();
                StockBodyRow.LOADINGDOCDTID = dt.Rows[i]["LOADINGDOCDTID"].ToString();
                StockBodyRow.INNERCODE1     = dt.Rows[i]["INNERCODE1"].ToString();
                StockBodyRow.INNERCODE2     = dt.Rows[i]["INNERCODE2"].ToString();
                StockBodyRow.SNAME          = dt.Rows[i]["SNAME"].ToString();
                body.Add(StockBodyRow);
            }
            JsInfo.body = body;

            return(JsInfo);
        }
예제 #2
0
        /// <summary>
        /// 构造Json
        /// </summary>
        /// <returns></returns>
        private JsonDetail CreateStockinfo(DataTable dt)
        {
            int Perpage;

            if (SearchPar.numPerPage == "")
            {
                Perpage = 5;
            }
            else
            {
                Perpage = int.Parse(SearchPar.numPerPage);
            }

            int pageno;

            if (SearchPar.pageNum == "")
            {
                pageno = 1;
            }
            else
            {
                pageno = int.Parse(SearchPar.pageNum) <= 0 ? 1 : int.Parse(SearchPar.pageNum);
            }

            JsonDetail            JsInfo = new JsonDetail();
            List <JsonDetailRows> body   = new List <JsonDetailRows>();

            int endno = pageno * Perpage < dt.Rows.Count?pageno * Perpage:dt.Rows.Count;

            for (int i = (pageno * Perpage - Perpage); i < endno; i++)
            {
                JsonDetailRows StockBodyRow = new JsonDetailRows();
                StockBodyRow.GOODSID        = dt.Rows[i]["GOODSID"].ToString();
                StockBodyRow.NAME           = dt.Rows[i]["NAME"].ToString();
                StockBodyRow.MODEL          = dt.Rows[i]["MODEL"].ToString();
                StockBodyRow.TRADEMARK      = dt.Rows[i]["TRADEMARK"].ToString();
                StockBodyRow.MID1           = dt.Rows[i]["MID1"].ToString();
                StockBodyRow.Goodsbatch     = dt.Rows[i]["Goodsbatch"].ToString();
                StockBodyRow.QUALITYFLG     = dt.Rows[i]["QUALITYFLG"].ToString();
                StockBodyRow.SHIPPEDNUM     = dt.Rows[i]["SHIPPEDNUM"].ToString();
                StockBodyRow.ARRIVENUM      = dt.Rows[i]["ARRIVENUM"].ToString();
                StockBodyRow.BACKNUM        = dt.Rows[i]["BACKNUM"].ToString();
                StockBodyRow.BACKREASON     = dt.Rows[i]["BACKREASON"].ToString();
                StockBodyRow.LOADINGDOCID   = dt.Rows[i]["LOADINGDOCID"].ToString();
                StockBodyRow.LOADINGDOCDTID = dt.Rows[i]["LOADINGDOCDTID"].ToString();
                StockBodyRow.INNERCODE1     = dt.Rows[i]["INNERCODE1"].ToString();
                StockBodyRow.INNERCODE2     = dt.Rows[i]["INNERCODE2"].ToString();
                StockBodyRow.SNAME          = dt.Rows[i]["SNAME"].ToString();
                body.Add(StockBodyRow);
            }
            JsInfo.body = body;

            return(JsInfo);
        }