using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Estsh.Web.Util;
using System.Collections;
using Estsh.Web.Service;
using System.Data;
using System.Web.UI.WebControls;
using System.IO;
using System.Text;

/***************************************************************************************************
 * 
 * 作者：王勇
 * 
 * *************************************************************************************************/
namespace Estsh.Core.Web.Controllers
{
    /// <summary>
    /// 目视单打印模块的控制类
    /// </summary>
    public partial class StockOrderPrintController : Controller
    {
        private StockOrderPrintService service = new StockOrderPrintService();

        public ActionResult Index()
        {
            return View();
        }

        #region 发运单打印

        public ActionResult getStockOrderListByPage(Pager pager, String direction, String sort, string cbCustPDLine, string startOrder_id, string endOrder_id)
        {
            if (string.IsNullOrEmpty(cbCustPDLine) || cbCustPDLine == "null")
            {
                cbCustPDLine = "0";
            }

            Hashtable result = new Hashtable();
            result.Add("pager.pageNo", pager.pageNo);
            Hashtable dataHt = this.service.getStockOrderListByPage(pager, direction, sort, cbCustPDLine, startOrder_id, endOrder_id);
            result.Add("rows", dataHt["dataList"]);
            result.Add("pager.totalRows", dataHt["totalCount"]);
            result.Add("sort", sort);
            result.Add("direction", direction);
            return Json(result);
        }

        public ActionResult getStockOrderDetailByPage(Pager pager, String direction, int order_id)
        {
            Hashtable result = new Hashtable();
            result.Add("pager.pageNo", pager.pageNo);

            if (order_id == null)
            {
                order_id = 0;
            }

            Hashtable dataHt = this.service.getStockOrderDetailByPage(pager, direction, order_id);
            result.Add("rows", dataHt["dataList"]);
            result.Add("direction", direction);
            return Json(result);

        }

        public ActionResult updatePrintData(string order_id)
        {
            if (string.IsNullOrEmpty(order_id))
            {
                return Json("数据不正确，请联系管理员！");
            }

            order_id = order_id.Substring(0, order_id.Length - 1);

            Hashtable result = new Hashtable();
            result = this.service.updatePrintData(order_id);
            return Json(result, JsonRequestBehavior.AllowGet);
            //return Json(result);
        }

        /// <summary>
        /// 获取客户产线列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetCustPDLine()
        {
            Hashtable result = new Hashtable();
            ArrayList list = this.service.GetCustPDLine();
            result.Add("list", list);
            return Json(result, JsonRequestBehavior.AllowGet);
        }

        /// <summary>
        /// 获取打印车号
        /// </summary>
        /// <returns></returns>
        public ActionResult getShipNumber(string cbCustPDLine)
        {
            if (string.IsNullOrEmpty(cbCustPDLine) || cbCustPDLine == "null")
            {
                cbCustPDLine = "0";
            }

            Hashtable result = new Hashtable();
            string str = this.service.getShipNumber(cbCustPDLine);
            result.Add("data", str);
            return Json(result, JsonRequestBehavior.AllowGet);
        }

        public ActionResult uploadFile(String cbCustPDLine)
        {
            ViewData.Add("cbCustPDLine", cbCustPDLine);

            return View("~/Views/StockOrderPrint/uploadFile.aspx");
        }

        /// <summary>
        /// 导入
        /// </summary>
        /// <returns></returns>
        public ActionResult importStockOrderInfo()
        {
            String cbCustPDLine = Request["cbCustPDLine"].ToString();
            Hashtable result = new Hashtable();
            HttpPostedFileBase userDataFile = Request.Files[0];
            if (userDataFile == null)
            {
                return null;
            }

            result = service.ReadExcelFile(userDataFile.InputStream, cbCustPDLine);
            return Json(result);
        }

        public ActionResult printTest(string cbCustPDLine, string step, string printType, string forPrintNumber, string printDate, string printNumber)
        {
            Hashtable result = new Hashtable();
            String message = "";
            String flag = "";

            if (!(cbCustPDLine.Contains("1002") || cbCustPDLine.Contains("1007")))
            {
                result.Add("message", "不支持该产线发运单打印！");
                result.Add("flag", "FAIL");
                return Json(result);
            }

            if (string.IsNullOrEmpty(printDate))
            {
                result.Add("message", "打印时间不能为空！");
                result.Add("flag", "FAIL");
                return Json(result);
            }

            if (string.IsNullOrEmpty(printNumber))
            {
                result.Add("message", "当前打印车号不能为空！");
                result.Add("flag", "FAIL");
                return Json(result);
            }

            DataTable dtOrderId = new DataTable();
            string orderId = "";

            if (printType == "1")
            {
                dtOrderId = this.service.getTopOrderBy(step, cbCustPDLine);
            }
            else if (printType == "2")
            {
                dtOrderId = this.service.getOrderByTraySeq(forPrintNumber, cbCustPDLine);
            }


            if (dtOrderId.Rows.Count < Convert.ToInt32(step))
            {
                result.Add("message", "待打印数据不满足" + step + "条！");
                result.Add("flag", "FAIL");
                return Json(result);
            }

            for (int w = 0; w < dtOrderId.Rows.Count; w++)
            {
                orderId += dtOrderId.Rows[w]["order_id"].ToString() + ",";
            }

            orderId = orderId.Substring(0, orderId.Length - 1);

            DataTable dt = new DataTable();



            string[] str = orderId.Split(',');

            #region 定义变量

            #region 正驾驶打印页面数值变量

            //正驾驶数据
            string ZhengJiaShi_1_1 = "";
            string ZhengJiaShi_1_2 = "";
            string ZhengJiaShi_1_3 = "";

            string ZhengJiaShi_2_1 = "";
            string ZhengJiaShi_2_2 = "";
            string ZhengJiaShi_2_3 = "";

            string ZhengJiaShi_3_1_1 = "";
            string ZhengJiaShi_3_1_2 = "";
            string ZhengJiaShi_3_1_3 = "";
            string ZhengJiaShi_3_1_4 = "";
            string ZhengJiaShi_3_1_5 = "";

            string ZhengJiaShi_3_2_1 = "";
            string ZhengJiaShi_3_2_2 = "";
            string ZhengJiaShi_3_2_3 = "";
            string ZhengJiaShi_3_2_4 = "";
            string ZhengJiaShi_3_2_5 = "";

            string ZhengJiaShi_3_3_1 = "";
            string ZhengJiaShi_3_3_2 = "";
            string ZhengJiaShi_3_3_3 = "";
            string ZhengJiaShi_3_3_4 = "";
            string ZhengJiaShi_3_3_5 = "";

            string ZhengJiaShi_3_4_1 = "";
            string ZhengJiaShi_3_4_2 = "";
            string ZhengJiaShi_3_4_3 = "";
            string ZhengJiaShi_3_4_4 = "";
            string ZhengJiaShi_3_4_5 = "";

            string ZhengJiaShi_3_5_1 = "";
            string ZhengJiaShi_3_5_2 = "";
            string ZhengJiaShi_3_5_3 = "";
            string ZhengJiaShi_3_5_4 = "";
            string ZhengJiaShi_3_5_5 = "";

            string ZhengJiaShi_3_6_1 = "";
            string ZhengJiaShi_3_6_2 = "";
            string ZhengJiaShi_3_6_3 = "";
            string ZhengJiaShi_3_6_4 = "";
            string ZhengJiaShi_3_6_5 = "";

            #endregion

            #region 副驾驶打印页面数值变量

            //副驾驶
            string FuJiaShi_1_1 = "";
            string FuJiaShi_1_2 = "";
            string FuJiaShi_1_3 = "";

            string FuJiaShi_2_1 = "";
            string FuJiaShi_2_2 = "";
            string FuJiaShi_2_3 = "";

            string FuJiaShi_3_1_1 = "";
            string FuJiaShi_3_1_2 = "";
            string FuJiaShi_3_1_3 = "";
            string FuJiaShi_3_1_4 = "";
            string FuJiaShi_3_1_5 = "";

            string FuJiaShi_3_2_1 = "";
            string FuJiaShi_3_2_2 = "";
            string FuJiaShi_3_2_3 = "";
            string FuJiaShi_3_2_4 = "";
            string FuJiaShi_3_2_5 = "";

            string FuJiaShi_3_3_1 = "";
            string FuJiaShi_3_3_2 = "";
            string FuJiaShi_3_3_3 = "";
            string FuJiaShi_3_3_4 = "";
            string FuJiaShi_3_3_5 = "";

            string FuJiaShi_3_4_1 = "";
            string FuJiaShi_3_4_2 = "";
            string FuJiaShi_3_4_3 = "";
            string FuJiaShi_3_4_4 = "";
            string FuJiaShi_3_4_5 = "";

            string FuJiaShi_3_5_1 = "";
            string FuJiaShi_3_5_2 = "";
            string FuJiaShi_3_5_3 = "";
            string FuJiaShi_3_5_4 = "";
            string FuJiaShi_3_5_5 = "";

            string FuJiaShi_3_6_1 = "";
            string FuJiaShi_3_6_2 = "";
            string FuJiaShi_3_6_3 = "";
            string FuJiaShi_3_6_4 = "";
            string FuJiaShi_3_6_5 = "";

            #endregion

            #region 后排整椅打印页面数值变量

            //后排整椅
            string HouPaiZhengYi_1_1 = "";
            string HouPaiZhengYi_1_2 = "";
            string HouPaiZhengYi_1_3 = "";

            string HouPaiZhengYi_2_1 = "";
            string HouPaiZhengYi_2_2 = "";
            string HouPaiZhengYi_2_3 = "";

            string HouPaiZhengYi_3_1_1 = "";
            string HouPaiZhengYi_3_1_2 = "";
            string HouPaiZhengYi_3_1_3 = "";
            string HouPaiZhengYi_3_1_4 = "";
            string HouPaiZhengYi_3_1_5 = "";

            string HouPaiZhengYi_3_2_1 = "";
            string HouPaiZhengYi_3_2_2 = "";
            string HouPaiZhengYi_3_2_3 = "";
            string HouPaiZhengYi_3_2_4 = "";
            string HouPaiZhengYi_3_2_5 = "";

            string HouPaiZhengYi_3_3_1 = "";
            string HouPaiZhengYi_3_3_2 = "";
            string HouPaiZhengYi_3_3_3 = "";
            string HouPaiZhengYi_3_3_4 = "";
            string HouPaiZhengYi_3_3_5 = "";

            string HouPaiZhengYi_3_4_1 = "";
            string HouPaiZhengYi_3_4_2 = "";
            string HouPaiZhengYi_3_4_3 = "";
            string HouPaiZhengYi_3_4_4 = "";
            string HouPaiZhengYi_3_4_5 = "";

            string HouPaiZhengYi_3_5_1 = "";
            string HouPaiZhengYi_3_5_2 = "";
            string HouPaiZhengYi_3_5_3 = "";
            string HouPaiZhengYi_3_5_4 = "";
            string HouPaiZhengYi_3_5_5 = "";

            string HouPaiZhengYi_3_6_1 = "";
            string HouPaiZhengYi_3_6_2 = "";
            string HouPaiZhengYi_3_6_3 = "";
            string HouPaiZhengYi_3_6_4 = "";
            string HouPaiZhengYi_3_6_5 = "";

            #endregion

            #region 后排整椅打印页面数值变量

            //后排整椅
            string CunLiu_1_1 = "";
            string CunLiu_1_2 = "";
            string CunLiu_1_3 = "";

            string CunLiu_2_1 = "";
            string CunLiu_2_2 = "";
            string CunLiu_2_3 = "";

            string CunLiu_3_1_1 = "";
            string CunLiu_3_1_2 = "";
            string CunLiu_3_1_3 = "";
            string CunLiu_3_1_4 = "";
            string CunLiu_3_1_5 = "";

            string CunLiu_3_2_1 = "";
            string CunLiu_3_2_2 = "";
            string CunLiu_3_2_3 = "";
            string CunLiu_3_2_4 = "";
            string CunLiu_3_2_5 = "";

            string CunLiu_3_3_1 = "";
            string CunLiu_3_3_2 = "";
            string CunLiu_3_3_3 = "";
            string CunLiu_3_3_4 = "";
            string CunLiu_3_3_5 = "";

            string CunLiu_3_4_1 = "";
            string CunLiu_3_4_2 = "";
            string CunLiu_3_4_3 = "";
            string CunLiu_3_4_4 = "";
            string CunLiu_3_4_5 = "";

            string CunLiu_3_5_1 = "";
            string CunLiu_3_5_2 = "";
            string CunLiu_3_5_3 = "";
            string CunLiu_3_5_4 = "";
            string CunLiu_3_5_5 = "";

            string CunLiu_3_6_1 = "";
            string CunLiu_3_6_2 = "";
            string CunLiu_3_6_3 = "";
            string CunLiu_3_6_4 = "";
            string CunLiu_3_6_5 = "";

            #endregion

            #endregion

            int z = 1;// 记录正驾驶上一个座椅的索引
            int x = 1;// 记录副驾驶上一个座椅的索引
            int c = 1;// 记录后排整椅上一个座椅的索引
            int v = 1;// 记录存留上一个座椅的索引

            StringBuilder SqlStringBuilder = new StringBuilder(1024);
            SqlStringBuilder.Append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"> ");
            SqlStringBuilder.Append("<html> ");
            SqlStringBuilder.Append("<head> ");
            SqlStringBuilder.Append("    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /> ");
            //SqlStringBuilder.Append("    <meta http-equiv=\"pragma\" content=\"no-cache\" /> ");
            //SqlStringBuilder.Append("    <meta http-equiv=\"Cache-Control\" content=\"no-cache\" /> ");
            //SqlStringBuilder.Append("    <meta http-equiv=\"Cache-Control\" content=\"no-store\" /> ");
            //SqlStringBuilder.Append("    <meta http-equiv=\"Expires\" content=\"0\" /> ");
            SqlStringBuilder.Append("	<title></title> ");
            SqlStringBuilder.Append("    <script type=\"text/javascript\" src=\"..\\..\\libs\\js\\lodop\\LodopFuncs.js\"></script> ");
            SqlStringBuilder.Append("	<style type=\"text/css\"> ");
            SqlStringBuilder.Append("		body ");
            SqlStringBuilder.Append("		{ ");
            SqlStringBuilder.Append("			font-family: Arial; ");
            SqlStringBuilder.Append("			width: 180mm; ");
            SqlStringBuilder.Append("		} ");
            SqlStringBuilder.Append("		table ");
            SqlStringBuilder.Append("		{ ");
            SqlStringBuilder.Append("			text-align:center; ");
            //SqlStringBuilder.Append("			border:0; ");
            //SqlStringBuilder.Append("			margin:0; ");
            //SqlStringBuilder.Append("			border-collapse:collapse; ");
            //SqlStringBuilder.Append("			border-spacing:0; ");
            SqlStringBuilder.Append("			width: 180mm; ");
            SqlStringBuilder.Append("		} ");
            SqlStringBuilder.Append("		td,th,tr ");
            SqlStringBuilder.Append("		{ ");
            SqlStringBuilder.Append("			text-align:center; ");
            SqlStringBuilder.Append("		     font-size:10pt; ");
            SqlStringBuilder.Append("		     height:25px; ");
            SqlStringBuilder.Append("		     font-weight:normal; ");
            SqlStringBuilder.Append("		} ");
            SqlStringBuilder.Append("		.PageNext ");
            SqlStringBuilder.Append("        { ");
            SqlStringBuilder.Append("            page-break-after: always; ");
            SqlStringBuilder.Append("        } ");
            SqlStringBuilder.Append("         .Noprint         ");
            SqlStringBuilder.Append("         {             ");
            SqlStringBuilder.Append("         	display: none;         ");
            SqlStringBuilder.Append("         } ");
            SqlStringBuilder.Append("	</style> ");
            SqlStringBuilder.Append("</head> ");
            SqlStringBuilder.Append("<body> ");

            int yeShu = 0;
            //int b = 0;
            string order_id_2 = "";

            double dou = Convert.ToDouble(str.Length) / Convert.ToDouble(6);

            //存储条码信息
            DataTable _barcode = new DataTable();
            _barcode.Columns.Add("name_1", Type.GetType("System.String"));
            _barcode.Columns.Add("name_2", Type.GetType("System.String"));
            _barcode.Columns.Add("name_3", Type.GetType("System.String"));
            //dt.Rows.Add("name_1", "name_2", "name_3");

            for (int j = 0; j < Math.Ceiling(dou); j++)
            {
                if (str.Length < 7)
                {
                    yeShu = dt.Rows.Count;
                }
                else
                {
                    z = 1;// 记录正驾驶上一个座椅的索引
                    x = 1;// 记录副驾驶上一个座椅的索引
                    c = 1;// 记录后排整椅上一个座椅的索引
                    v = 1;// 记录存留上一个座椅的索引


                    #region 变量初始化

                    #region 正驾驶打印页面数值变量

                    //正驾驶数据
                    ZhengJiaShi_1_1 = "";
                    ZhengJiaShi_1_2 = "";
                    ZhengJiaShi_1_3 = "";

                    ZhengJiaShi_2_1 = "";
                    ZhengJiaShi_2_2 = "";
                    ZhengJiaShi_2_3 = "";

                    ZhengJiaShi_3_1_1 = "";
                    ZhengJiaShi_3_1_2 = "";
                    ZhengJiaShi_3_1_3 = "";
                    ZhengJiaShi_3_1_4 = "";
                    ZhengJiaShi_3_1_5 = "";

                    ZhengJiaShi_3_2_1 = "";
                    ZhengJiaShi_3_2_2 = "";
                    ZhengJiaShi_3_2_3 = "";
                    ZhengJiaShi_3_2_4 = "";
                    ZhengJiaShi_3_2_5 = "";

                    ZhengJiaShi_3_3_1 = "";
                    ZhengJiaShi_3_3_2 = "";
                    ZhengJiaShi_3_3_3 = "";
                    ZhengJiaShi_3_3_4 = "";
                    ZhengJiaShi_3_3_5 = "";

                    ZhengJiaShi_3_4_1 = "";
                    ZhengJiaShi_3_4_2 = "";
                    ZhengJiaShi_3_4_3 = "";
                    ZhengJiaShi_3_4_4 = "";
                    ZhengJiaShi_3_4_5 = "";

                    ZhengJiaShi_3_5_1 = "";
                    ZhengJiaShi_3_5_2 = "";
                    ZhengJiaShi_3_5_3 = "";
                    ZhengJiaShi_3_5_4 = "";
                    ZhengJiaShi_3_5_5 = "";

                    ZhengJiaShi_3_6_1 = "";
                    ZhengJiaShi_3_6_2 = "";
                    ZhengJiaShi_3_6_3 = "";
                    ZhengJiaShi_3_6_4 = "";
                    ZhengJiaShi_3_6_5 = "";

                    #endregion

                    #region 副驾驶打印页面数值变量

                    //副驾驶
                    FuJiaShi_1_1 = "";
                    FuJiaShi_1_2 = "";
                    FuJiaShi_1_3 = "";

                    FuJiaShi_2_1 = "";
                    FuJiaShi_2_2 = "";
                    FuJiaShi_2_3 = "";

                    FuJiaShi_3_1_1 = "";
                    FuJiaShi_3_1_2 = "";
                    FuJiaShi_3_1_3 = "";
                    FuJiaShi_3_1_4 = "";
                    FuJiaShi_3_1_5 = "";

                    FuJiaShi_3_2_1 = "";
                    FuJiaShi_3_2_2 = "";
                    FuJiaShi_3_2_3 = "";
                    FuJiaShi_3_2_4 = "";
                    FuJiaShi_3_2_5 = "";

                    FuJiaShi_3_3_1 = "";
                    FuJiaShi_3_3_2 = "";
                    FuJiaShi_3_3_3 = "";
                    FuJiaShi_3_3_4 = "";
                    FuJiaShi_3_3_5 = "";

                    FuJiaShi_3_4_1 = "";
                    FuJiaShi_3_4_2 = "";
                    FuJiaShi_3_4_3 = "";
                    FuJiaShi_3_4_4 = "";
                    FuJiaShi_3_4_5 = "";

                    FuJiaShi_3_5_1 = "";
                    FuJiaShi_3_5_2 = "";
                    FuJiaShi_3_5_3 = "";
                    FuJiaShi_3_5_4 = "";
                    FuJiaShi_3_5_5 = "";

                    FuJiaShi_3_6_1 = "";
                    FuJiaShi_3_6_2 = "";
                    FuJiaShi_3_6_3 = "";
                    FuJiaShi_3_6_4 = "";
                    FuJiaShi_3_6_5 = "";

                    #endregion

                    #region 后排整椅打印页面数值变量

                    //后排整椅
                    HouPaiZhengYi_1_1 = "";
                    HouPaiZhengYi_1_2 = "";
                    HouPaiZhengYi_1_3 = "";

                    HouPaiZhengYi_2_1 = "";
                    HouPaiZhengYi_2_2 = "";
                    HouPaiZhengYi_2_3 = "";

                    HouPaiZhengYi_3_1_1 = "";
                    HouPaiZhengYi_3_1_2 = "";
                    HouPaiZhengYi_3_1_3 = "";
                    HouPaiZhengYi_3_1_4 = "";
                    HouPaiZhengYi_3_1_5 = "";

                    HouPaiZhengYi_3_2_1 = "";
                    HouPaiZhengYi_3_2_2 = "";
                    HouPaiZhengYi_3_2_3 = "";
                    HouPaiZhengYi_3_2_4 = "";
                    HouPaiZhengYi_3_2_5 = "";

                    HouPaiZhengYi_3_3_1 = "";
                    HouPaiZhengYi_3_3_2 = "";
                    HouPaiZhengYi_3_3_3 = "";
                    HouPaiZhengYi_3_3_4 = "";
                    HouPaiZhengYi_3_3_5 = "";

                    HouPaiZhengYi_3_4_1 = "";
                    HouPaiZhengYi_3_4_2 = "";
                    HouPaiZhengYi_3_4_3 = "";
                    HouPaiZhengYi_3_4_4 = "";
                    HouPaiZhengYi_3_4_5 = "";

                    HouPaiZhengYi_3_5_1 = "";
                    HouPaiZhengYi_3_5_2 = "";
                    HouPaiZhengYi_3_5_3 = "";
                    HouPaiZhengYi_3_5_4 = "";
                    HouPaiZhengYi_3_5_5 = "";

                    HouPaiZhengYi_3_6_1 = "";
                    HouPaiZhengYi_3_6_2 = "";
                    HouPaiZhengYi_3_6_3 = "";
                    HouPaiZhengYi_3_6_4 = "";
                    HouPaiZhengYi_3_6_5 = "";

                    #endregion

                    #region 后排整椅打印页面数值变量

                    //后排整椅
                    CunLiu_1_1 = "";
                    CunLiu_1_2 = "";
                    CunLiu_1_3 = "";

                    CunLiu_2_1 = "";
                    CunLiu_2_2 = "";
                    CunLiu_2_3 = "";

                    CunLiu_3_1_1 = "";
                    CunLiu_3_1_2 = "";
                    CunLiu_3_1_3 = "";
                    CunLiu_3_1_4 = "";
                    CunLiu_3_1_5 = "";

                    CunLiu_3_2_1 = "";
                    CunLiu_3_2_2 = "";
                    CunLiu_3_2_3 = "";
                    CunLiu_3_2_4 = "";
                    CunLiu_3_2_5 = "";

                    CunLiu_3_3_1 = "";
                    CunLiu_3_3_2 = "";
                    CunLiu_3_3_3 = "";
                    CunLiu_3_3_4 = "";
                    CunLiu_3_3_5 = "";

                    CunLiu_3_4_1 = "";
                    CunLiu_3_4_2 = "";
                    CunLiu_3_4_3 = "";
                    CunLiu_3_4_4 = "";
                    CunLiu_3_4_5 = "";

                    CunLiu_3_5_1 = "";
                    CunLiu_3_5_2 = "";
                    CunLiu_3_5_3 = "";
                    CunLiu_3_5_4 = "";
                    CunLiu_3_5_5 = "";

                    CunLiu_3_6_1 = "";
                    CunLiu_3_6_2 = "";
                    CunLiu_3_6_3 = "";
                    CunLiu_3_6_4 = "";
                    CunLiu_3_6_5 = "";

                    #endregion

                    #endregion

                    //_barcode = new DataTable();
                    //_barcode.Columns.Add("name_1", Type.GetType("System.String"));
                    //_barcode.Columns.Add("name_2", Type.GetType("System.String"));
                    //_barcode.Columns.Add("name_3", Type.GetType("System.String"));
                    order_id_2 = "";
                    yeShu = j * 6;
                }

                for (int s = 0; s < 6; s++)
                {
                    if (s + yeShu < str.Length)
                    {
                        order_id_2 += str[s + yeShu] + ",";
                    }
                }

                order_id_2 = order_id_2.Substring(0, order_id_2.Length - 1);
                dt = new DataTable();
                if (printType == "1")
                {
                    dt = this.service.updatePrintData_2(order_id_2, cbCustPDLine);
                }
                else if (printType == "2")
                {
                    dt = this.service.getForPintData(order_id_2, cbCustPDLine);
                }

                string sum = "";

                if (printType == "1")
                {
                    //sum = this.service.getShipNo("ShipNumber");

                    sum = printNumber;

                    if (sum.ToString().Length == 1)
                    {
                        sum = "00" + sum;
                    }
                    else if (sum.ToString().Length == 2)
                    {
                        sum = "0" + sum;
                    }
                }
                else if (printType == "2")
                {
                    sum = forPrintNumber.Substring(forPrintNumber.Length - 4, 3);
                }

                for (int i = 0; i < dt.Rows.Count; i++)
                {

                    //if (dt.Rows[i]["part_location"].ToString() == "01")
                    //{
                    if (z == 1)
                    {
                        ZhengJiaShi_1_1 = "驾驶座";
                        //ZhengJiaShi_1_2 = "A"+dt.Rows[i]["order_number_1"].ToString() + sum ;
                        //区分座椅位置

                        if (cbCustPDLine == "1007")
                        {
                            ZhengJiaShi_1_2 = "L" + printDate.Replace("-", "") + sum + "A";
                        }
                        else
                        {
                            ZhengJiaShi_1_2 = printDate.Replace("-", "") + sum + "A";
                        }


                        //string tray_no = this.service.getNumber(ZhengJiaShi_1_2);
                        //if (!string.IsNullOrEmpty(tray_no))
                        //{
                        //    result.Add("message", "包装单元号重复！");
                        //    result.Add("flag", "FAIL");
                        //    return Json(result);
                        //}

                        ZhengJiaShi_1_3 = printDate;

                        ZhengJiaShi_2_1 = printDate.Replace("-", "");
                        DataRow newRow = _barcode.NewRow();
                        newRow["name_1"] = "LODOP" + (1 + yeShu).ToString();
                        newRow["name_2"] = "LODOP_EM" + (1 + yeShu).ToString();
                        newRow["name_3"] = ZhengJiaShi_1_2;
                        _barcode.Rows.Add(newRow);

                        ZhengJiaShi_2_2 = sum;
                        ZhengJiaShi_2_3 = "车";

                    }

                    switch (z)
                    {
                        case 1:
                            ZhengJiaShi_3_1_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_1_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_1_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_1_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_1_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                        case 2:
                            ZhengJiaShi_3_2_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_2_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_2_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_2_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_2_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                        case 3:
                            ZhengJiaShi_3_3_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_3_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_3_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_3_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_3_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                        case 4:
                            ZhengJiaShi_3_4_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_4_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_4_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_4_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_4_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                        case 5:
                            ZhengJiaShi_3_5_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_5_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_5_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_5_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_5_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                        case 6:
                            ZhengJiaShi_3_6_1 = dt.Rows[i]["order_seq"].ToString();
                            ZhengJiaShi_3_6_2 = dt.Rows[i]["vin"].ToString();
                            ZhengJiaShi_3_6_3 = dt.Rows[i]["part_spec2"].ToString();
                            ZhengJiaShi_3_6_4 = dt.Rows[i]["part_class"].ToString();
                            ZhengJiaShi_3_6_5 = dt.Rows[i]["FALSE"].ToString();
                            z++;
                            break;
                    }
                    //}


                    //if (dt.Rows[i]["part_location"].ToString() == "02")
                    //{

                    if (x == 1)
                    {
                        FuJiaShi_1_1 = "乘客座";
                        //FuJiaShi_1_2 = "A" + dt.Rows[i]["order_number_1"].ToString() + sum;

                        if (cbCustPDLine == "1007")
                        {
                            FuJiaShi_1_2 = "L" + printDate.Replace("-", "") + sum + "B";
                        }
                        else
                        {
                            FuJiaShi_1_2 = printDate.Replace("-", "") + sum + "B";
                        }
                        FuJiaShi_1_3 = printDate;

                        FuJiaShi_2_1 = printDate.Replace("-", "");
                        DataRow newRow = _barcode.NewRow();
                        newRow["name_1"] = "LODOP" + (2 + yeShu).ToString();
                        newRow["name_2"] = "LODOP_EM" + (2 + yeShu).ToString();
                        newRow["name_3"] = FuJiaShi_1_2;
                        _barcode.Rows.Add(newRow);

                        FuJiaShi_2_2 = sum;
                        FuJiaShi_2_3 = "车";
                    }

                    switch (x)
                    {
                        case 1:
                            FuJiaShi_3_1_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_1_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_1_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_1_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_1_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                        case 2:
                            FuJiaShi_3_2_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_2_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_2_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_2_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_2_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                        case 3:
                            FuJiaShi_3_3_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_3_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_3_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_3_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_3_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                        case 4:
                            FuJiaShi_3_4_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_4_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_4_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_4_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_4_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                        case 5:
                            FuJiaShi_3_5_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_5_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_5_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_5_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_5_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                        case 6:
                            FuJiaShi_3_6_1 = dt.Rows[i]["order_seq"].ToString();
                            FuJiaShi_3_6_2 = dt.Rows[i]["vin"].ToString();
                            FuJiaShi_3_6_3 = dt.Rows[i]["part_spec2"].ToString();
                            FuJiaShi_3_6_4 = dt.Rows[i]["part_class"].ToString();
                            FuJiaShi_3_6_5 = dt.Rows[i]["FALSE"].ToString();
                            x++;
                            break;
                    }
                    //}

                    //if (dt.Rows[i]["part_location"].ToString() == "03" || dt.Rows[i]["part_location"].ToString() == "05")
                    //{
                    if (c == 1)
                    {
                        //HouPaiZhengYi_1_1 = dt.Rows[i]["enum_desc"].ToString();
                        HouPaiZhengYi_1_1 = "后椅座椅";
                        //HouPaiZhengYi_1_2 = "A" + dt.Rows[i]["order_number_1"].ToString() + sum;
                        if (cbCustPDLine == "1007")
                        { HouPaiZhengYi_1_2 = "L" + printDate.Replace("-", "") + sum + "C"; }
                        else
                        {
                            HouPaiZhengYi_1_2 = printDate.Replace("-", "") + sum + "C";
                        }
                        HouPaiZhengYi_1_3 = printDate;

                        HouPaiZhengYi_2_1 = printDate.Replace("-", "");
                        DataRow newRow = _barcode.NewRow();
                        newRow["name_1"] = "LODOP" + (3 + yeShu).ToString();
                        newRow["name_2"] = "LODOP_EM" + (3 + yeShu).ToString();
                        newRow["name_3"] = HouPaiZhengYi_1_2;
                        _barcode.Rows.Add(newRow);

                        HouPaiZhengYi_2_2 = sum;
                        HouPaiZhengYi_2_3 = "车";
                    }

                    switch (c)
                    {
                        case 1:
                            HouPaiZhengYi_3_1_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_1_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_1_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_1_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_1_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                        case 2:
                            HouPaiZhengYi_3_2_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_2_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_2_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_2_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_2_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                        case 3:
                            HouPaiZhengYi_3_3_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_3_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_3_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_3_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_3_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                        case 4:
                            HouPaiZhengYi_3_4_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_4_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_4_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_4_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_4_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                        case 5:
                            HouPaiZhengYi_3_5_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_5_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_5_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_5_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_5_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                        case 6:
                            HouPaiZhengYi_3_6_1 = dt.Rows[i]["order_seq"].ToString();
                            HouPaiZhengYi_3_6_2 = dt.Rows[i]["vin"].ToString();
                            HouPaiZhengYi_3_6_3 = dt.Rows[i]["part_spec2"].ToString();
                            HouPaiZhengYi_3_6_4 = dt.Rows[i]["part_class"].ToString();
                            HouPaiZhengYi_3_6_5 = dt.Rows[i]["FALSE"].ToString();
                            c++;
                            break;
                    }
                    //}

                    //if (dt.Rows[i]["part_location"].ToString() == "04" || dt.Rows[i]["part_location"].ToString() == "06")
                    //{

                    if (v == 1)
                    {
                        //CunLiu_1_1 = dt.Rows[i]["enum_desc"].ToString();
                        CunLiu_1_1 = "存留";
                        //CunLiu_1_2 = "A" + dt.Rows[i]["order_number_1"].ToString() + sum;
                        if (cbCustPDLine == "1007")
                        { CunLiu_1_2 = "L" + printDate.Replace("-", "") + sum; }
                        else
                        {
                            CunLiu_1_2 = printDate.Replace("-", "") + sum;
                        }
                        CunLiu_1_3 = printDate;

                        CunLiu_2_1 = printDate.Replace("-", "");
                        DataRow newRow = _barcode.NewRow();
                        newRow["name_1"] = "LODOP" + (4 + yeShu).ToString();
                        newRow["name_2"] = "LODOP_EM" + (4 + yeShu).ToString();
                        newRow["name_3"] = CunLiu_1_2;
                        _barcode.Rows.Add(newRow);

                        CunLiu_2_2 = sum;
                        CunLiu_2_3 = "车";
                    }

                    switch (v)
                    {
                        case 1:
                            CunLiu_3_1_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_1_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_1_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_1_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_1_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                        case 2:
                            CunLiu_3_2_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_2_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_2_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_2_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_2_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                        case 3:
                            CunLiu_3_3_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_3_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_3_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_3_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_3_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                        case 4:
                            CunLiu_3_4_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_4_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_4_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_4_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_4_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                        case 5:
                            CunLiu_3_5_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_5_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_5_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_5_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_5_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                        case 6:
                            CunLiu_3_6_1 = dt.Rows[i]["order_seq"].ToString();
                            CunLiu_3_6_2 = dt.Rows[i]["vin"].ToString();
                            CunLiu_3_6_3 = dt.Rows[i]["part_spec2"].ToString();
                            CunLiu_3_6_4 = dt.Rows[i]["part_class"].ToString();
                            CunLiu_3_6_5 = dt.Rows[i]["FALSE"].ToString();
                            v++;
                            break;
                    }
                    //}

                    if (printType == "1")
                    {
                        this.service.updateTrayNo(HouPaiZhengYi_1_2, FuJiaShi_1_2, ZhengJiaShi_1_2, dt.Rows[i]["order_id"].ToString(), sum);
                    }
                }

                if (cbCustPDLine == "1002")
                {
                    SqlStringBuilder.Append("    <table style=\"height:285mm; border-collapse:collapse;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" > ");
                    SqlStringBuilder.Append("    <tr> ");
                    SqlStringBuilder.Append("        <td valign=\"top\"  style=\"height:50%; margin:25px 10px 10px 10px\"> ");
                    SqlStringBuilder.Append("            <table id=\"Table" + j + 1 + "\"> ");
                    SqlStringBuilder.Append("		        <tr> ");
                    SqlStringBuilder.Append("			        <td style=\" font-size: 30pt;\"> ");
                    SqlStringBuilder.Append("				        " + ZhengJiaShi_1_1 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 18pt;\"> ");
                    SqlStringBuilder.Append("                    " + ZhengJiaShi_1_2 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 30pt; \" colspan=\"2\"> ");
                    SqlStringBuilder.Append("				        " + ZhengJiaShi_1_3 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("		        </tr> ");
                    SqlStringBuilder.Append("		        <tr> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\" colspan=\"2\"> ");
                    SqlStringBuilder.Append("				        <object id=\"LODOP" + (1 + yeShu).ToString() + "\" classid=\"clsid:2105C259-1E0C-4534-8141-A753534CB4CA\" width=\"200px\" height=\"50px\">  ");
                    SqlStringBuilder.Append("                          <param name=\"Caption\" value=\"" + ZhengJiaShi_2_1 + "\"> ");
                    SqlStringBuilder.Append("                          <param name=\"Color\" value=\"white\">  ");
                    SqlStringBuilder.Append("                          <embed id=\"LODOP_EM" + (1 + yeShu).ToString() + "\" TYPE=\"application/x-print-lodop\" border=0 Color=\"white\" PLUGINSPAGE=\"install_lodop.exe\"> ");
                    SqlStringBuilder.Append("                        </object>  ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 28pt;\"> ");
                    SqlStringBuilder.Append("				        " + ZhengJiaShi_2_2 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\"> ");
                    SqlStringBuilder.Append("				        车 ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("		        </tr> ");
                    SqlStringBuilder.Append("	        </table> ");
                    //border=\"2\"
                    SqlStringBuilder.Append("            <table id=\"" + j + 2 + "\" border=\"2\" cellpadding=\"0\" cellspacing=\"0\"> ");
                    SqlStringBuilder.Append("                <tr> ");
                    SqlStringBuilder.Append("                    <th width=\"8%\">序号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"25%\">流水号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"25%\">VIN号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"32%\">座椅描述</th> ");
                    SqlStringBuilder.Append("                    <th width=\"10%\">颜色</th> ");
                    //SqlStringBuilder.Append("                    <th width=\"16%\">装饰等级</th> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>1</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_1_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_1_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_1_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_1_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_1_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>2</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_2_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_2_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_2_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_2_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_2_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>3</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_3_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_3_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_3_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_3_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_3_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>4</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_4_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_4_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_4_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_4_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_4_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>5</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_5_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_5_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_5_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_5_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_5_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>6</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_6_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_6_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_6_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_6_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + ZhengJiaShi_3_6_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr>              ");
                    SqlStringBuilder.Append("            </table> ");
                    SqlStringBuilder.Append("        </td> ");
                    SqlStringBuilder.Append("    </tr> ");

                    SqlStringBuilder.Append("    <tr> ");
                    SqlStringBuilder.Append("        <td valign=\"top\" style=\"margin:25px 10px 10px 10px\"> ");
                    SqlStringBuilder.Append("            <table id=\"" + j + 3 + "\" > ");
                    SqlStringBuilder.Append("		        <tr> ");
                    SqlStringBuilder.Append("			        <td style=\" font-size: 30pt;\"> ");
                    SqlStringBuilder.Append("				        " + FuJiaShi_1_1 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 18pt;\"> ");
                    SqlStringBuilder.Append("                    " + FuJiaShi_1_2 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 30pt; \" colspan=\"2\"> ");
                    SqlStringBuilder.Append("				        " + FuJiaShi_1_3 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("		        </tr> ");
                    SqlStringBuilder.Append("		        <tr> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\" colspan=\"2\"> ");
                    SqlStringBuilder.Append("				        <object id=\"LODOP" + (2 + yeShu).ToString() + "\" classid=\"clsid:2105C259-1E0C-4534-8141-A753534CB4CA\" width=\"200px\" height=\"50px\">  ");
                    SqlStringBuilder.Append("                          <param name=\"Caption\" value=\"显示区\"> ");
                    SqlStringBuilder.Append("                          <param name=\"Color\" value=\"white\">  ");
                    SqlStringBuilder.Append("                          <embed id=\"LODOP_EM" + (2 + yeShu).ToString() + "\" TYPE=\"application/x-print-lodop\" border=0 Color=\"white\" PLUGINSPAGE=\"install_lodop.exe\"> ");
                    SqlStringBuilder.Append("                        </object> ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 28pt;\"> ");
                    SqlStringBuilder.Append("				        " + FuJiaShi_2_2 + " ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\"> ");
                    SqlStringBuilder.Append("				        车 ");
                    SqlStringBuilder.Append("			        </td> ");
                    SqlStringBuilder.Append("		        </tr> ");
                    SqlStringBuilder.Append("	        </table> ");
                    SqlStringBuilder.Append("            <table id=\"" + j + 4 + "\" border=\"2\" cellpadding=\"0\" cellspacing=\"0\"> ");
                    SqlStringBuilder.Append("                <tr> ");
                    SqlStringBuilder.Append("                    <th width=\"8%\">序号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"25%\">流水号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"25%\">VIN号</th> ");
                    SqlStringBuilder.Append("                    <th width=\"32%\">座椅描述</th> ");
                    SqlStringBuilder.Append("                    <th width=\"10%\">颜色</th> ");
                    //SqlStringBuilder.Append("                    <th width=\"16%\">装饰等级</th> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>1</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_1_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_1_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_1_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_1_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_1_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>2</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_2_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_2_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_2_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_2_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_2_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>3</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_3_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_3_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_3_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_3_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_3_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>4</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_4_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_4_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_4_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_4_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_4_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>5</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_5_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_5_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_5_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_5_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_5_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr> ");
                    SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                    SqlStringBuilder.Append("                    <td>6</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_6_1 + "</td>                 ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_6_2 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_6_3 + "</td> ");
                    SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_6_4 + "</td> ");
                    //SqlStringBuilder.Append("                    <td>" + FuJiaShi_3_6_5 + "</td> ");
                    SqlStringBuilder.Append("                </tr>              ");
                    SqlStringBuilder.Append("            </table> ");
                    SqlStringBuilder.Append("        </td> ");
                    SqlStringBuilder.Append("    </tr> ");
                    SqlStringBuilder.Append("    </table> ");
                }

                SqlStringBuilder.Append("    <table style=\"height:285mm;\"> ");
                SqlStringBuilder.Append("    <tr> ");
                SqlStringBuilder.Append("        <td valign=\"top\"  style=\"height:50%; margin:25px 10px 10px 10px\"> ");
                SqlStringBuilder.Append("            <table id=\"" + j + 5 + "\"> ");
                SqlStringBuilder.Append("		        <tr> ");
                SqlStringBuilder.Append("			        <td style=\" font-size: 30pt;\"> ");
                SqlStringBuilder.Append("				        " + HouPaiZhengYi_1_1 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 18pt;\"> ");
                SqlStringBuilder.Append("                    " + HouPaiZhengYi_1_2 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 30pt; \" colspan=\"2\"> ");
                SqlStringBuilder.Append("				        " + HouPaiZhengYi_1_3 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("		        </tr> ");
                SqlStringBuilder.Append("		        <tr> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\" colspan=\"2\"> ");
                SqlStringBuilder.Append("				        <object id=\"LODOP" + (3 + yeShu).ToString() + "\" classid=\"clsid:2105C259-1E0C-4534-8141-A753534CB4CA\" width=\"200px\" height=\"50px\">  ");
                SqlStringBuilder.Append("                          <param name=\"Caption\" value=\"显示区\"> ");
                SqlStringBuilder.Append("                          <param name=\"Color\" value=\"white\">  ");
                SqlStringBuilder.Append("                          <embed id=\"LODOP_EM" + (3 + yeShu).ToString() + "\" TYPE=\"application/x-print-lodop\" border=0 Color=\"white\" PLUGINSPAGE=\"install_lodop.exe\"> ");
                SqlStringBuilder.Append("                        </object>  ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 28pt;\"> ");
                SqlStringBuilder.Append("				        " + HouPaiZhengYi_2_2 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\"> ");
                SqlStringBuilder.Append("				        车 ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("		        </tr> ");
                SqlStringBuilder.Append("	        </table> ");
                SqlStringBuilder.Append("            <table id=\"" + j + 6 + "\"  border=\"2\" cellpadding=\"0\" cellspacing=\"0\"> ");
                SqlStringBuilder.Append("                <tr> ");
                SqlStringBuilder.Append("                    <th width=\"8%\">序号</th> ");
                SqlStringBuilder.Append("                    <th width=\"25%\">流水号</th> ");
                SqlStringBuilder.Append("                    <th width=\"25%\">VIN号</th> ");
                SqlStringBuilder.Append("                    <th width=\"32%\">座椅描述</th> ");
                SqlStringBuilder.Append("                    <th width=\"10%\">颜色</th> ");
                //SqlStringBuilder.Append("                    <th width=\"16%\">装饰等级</th> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>1</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_1_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_1_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_1_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_1_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_1_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>2</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_2_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_2_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_2_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_2_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_2_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>3</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_3_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_3_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_3_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_3_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_3_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>4</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_4_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_4_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_4_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_4_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_4_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>5</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_5_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_5_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_5_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_5_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_5_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>6</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_6_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_6_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_6_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_6_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + HouPaiZhengYi_3_6_5 + "</td> ");
                SqlStringBuilder.Append("                </tr>              ");
                SqlStringBuilder.Append("            </table> ");
                SqlStringBuilder.Append("        </td> ");
                SqlStringBuilder.Append("    </tr> ");
                SqlStringBuilder.Append("    <tr> ");
                SqlStringBuilder.Append("        <td valign=\"top\" style=\"margin:25px 10px 10px 10px\"> ");
                SqlStringBuilder.Append("            <table id=\"Table" + j + 7 + "\"> ");
                SqlStringBuilder.Append("		        <tr> ");
                SqlStringBuilder.Append("			        <td style=\" font-size: 30pt;\"> ");
                SqlStringBuilder.Append("				        " + CunLiu_1_1 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 18pt;\"> ");
                SqlStringBuilder.Append("                    " + CunLiu_1_2 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 30pt; \" colspan=\"2\"> ");
                SqlStringBuilder.Append("				       " + CunLiu_1_3 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("		        </tr> ");
                SqlStringBuilder.Append("		        <tr> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\" colspan=\"2\"> ");
                SqlStringBuilder.Append("				        <object id=\"LODOP" + (4 + yeShu).ToString() + "\" classid=\"clsid:2105C259-1E0C-4534-8141-A753534CB4CA\" width=\"200px\" height=\"50px\">  ");
                SqlStringBuilder.Append("                          <param name=\"Caption\" value=\"显示区\"> ");
                SqlStringBuilder.Append("                          <param name=\"Color\" value=\"white\">  ");
                SqlStringBuilder.Append("                          <embed id=\"LODOP_EM" + (4 + yeShu).ToString() + "\" TYPE=\"application/x-print-lodop\" border=0 Color=\"white\" PLUGINSPAGE=\"install_lodop.exe\"> ");
                SqlStringBuilder.Append("                        </object> ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 28pt;\"> ");
                SqlStringBuilder.Append("				        " + CunLiu_2_2 + " ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("			        <td style=\"font-size: 38pt;\"> ");
                SqlStringBuilder.Append("				        车 ");
                SqlStringBuilder.Append("			        </td> ");
                SqlStringBuilder.Append("		        </tr> ");
                SqlStringBuilder.Append("	        </table> ");
                SqlStringBuilder.Append("            <table id=\"Table" + j + 8 + "\" border=\"2\" cellpadding=\"0\" cellspacing=\"0\"> ");
                SqlStringBuilder.Append("                <tr> ");
                SqlStringBuilder.Append("                    <th width=\"8%\">序号</th> ");
                SqlStringBuilder.Append("                    <th width=\"25%\">流水号</th> ");
                SqlStringBuilder.Append("                    <th width=\"25%\">VIN号</th> ");
                SqlStringBuilder.Append("                    <th width=\"32%\">座椅描述</th> ");
                SqlStringBuilder.Append("                    <th width=\"10%\">颜色</th> ");
                //SqlStringBuilder.Append("                    <th width=\"16%\">装饰等级</th> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>1</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_1_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_1_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_1_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_1_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_1_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>2</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_2_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_2_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_2_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_2_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_2_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>3</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_3_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_3_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_3_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_3_4 + "</td> ");

                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_3_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>4</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_4_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_4_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_4_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_4_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_4_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>5</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_5_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_5_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_5_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_5_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_5_5 + "</td> ");
                SqlStringBuilder.Append("                </tr> ");
                SqlStringBuilder.Append("                <tr title=\"TWDReapter\"> ");
                SqlStringBuilder.Append("                    <td>6</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_6_1 + "</td>                 ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_6_2 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_6_3 + "</td> ");
                SqlStringBuilder.Append("                    <td>" + CunLiu_3_6_4 + "</td> ");
                //SqlStringBuilder.Append("                    <td>" + CunLiu_3_6_5 + "</td> ");
                SqlStringBuilder.Append("                </tr>              ");
                SqlStringBuilder.Append("            </table> ");
                SqlStringBuilder.Append("        </td> ");
                SqlStringBuilder.Append("    </tr> ");
                SqlStringBuilder.Append("    </table> ");

            }

            SqlStringBuilder.Append("</body> ");
            SqlStringBuilder.Append("<script type=\"text/javascript\"> ");
            SqlStringBuilder.Append("    var LODOP; ");
            SqlStringBuilder.Append("    var pLODOP; ");
            SqlStringBuilder.Append("    function myShow1() { ");

            for (int k = 0; k < _barcode.Rows.Count; k++)
            {
                SqlStringBuilder.Append("        LODOP = getLodop(document.getElementById('" + _barcode.Rows[k]["name_1"].ToString() + "'), document.getElementById('" + _barcode.Rows[k]["name_2"].ToString() + "')); ");
                SqlStringBuilder.Append("        LODOP.PRINT_INIT(\"打印控件功能演示_Lodop功能_内嵌显示演示11\"); ");
                SqlStringBuilder.Append("        LODOP.ADD_PRINT_BARCODE(0, 0, 190, 50, \"128A\", \"" + _barcode.Rows[k]["name_3"].ToString() + "\"); ");
                SqlStringBuilder.Append("        LODOP.SHOW_CHART(); ");
            }

            SqlStringBuilder.Append("    }; ");
            SqlStringBuilder.Append("    window.onload = myShow1; ");
            SqlStringBuilder.Append("</script> ");
            SqlStringBuilder.Append("</html> ");

            int count = this.service.UpdateCount(orderId);

            int pn = Convert.ToInt32(printNumber) + 1;

            if (printType == "1")
            {
                this.service.UpdatePrintNumber(pn.ToString(), cbCustPDLine);
            }

            result.Add("message", "打印成功！");
            result.Add("flag", "OK");
            result.Add("DATA", SqlStringBuilder.ToString());
            return Json(result);
        }

        #endregion
    }
}