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;
using Estsh.Web.Models;

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

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

        public ActionResult getStockVendorOrderListByPage(Pager pager, string direction, string type, string Part, string StartDeliverTime, string EndDeliverTime)
        {
            Hashtable result = new Hashtable();
            result.Add("pager.pageNo", pager.pageNo);

            UserInfo user = Session["loginedUser"] as UserInfo;

            int empType = user.empType;
            string company = user.company;

            if (string.IsNullOrEmpty(type))
            {
                return null;
            }

            string str = " 1=1";

            if ((string.IsNullOrEmpty(company)) || type == "null")
            {
                return Json("用户未维护对应供应商！");
            }

            str += " and a.LIFNR='" + company + "' ";

            if (type.Length >= 7)
            {
                type = "1,2,3,4,''";
            }

            if (!(string.IsNullOrEmpty(type)) && type != "null")
            {
                str += " and a.STAFLG in (" + type + ") ";
            }

            if (!(string.IsNullOrEmpty(Part)) && Part != "null")
            {
                str += " and b.part_no LIKE '%" + Part + "%' ";
            }

            if (!(string.IsNullOrEmpty(StartDeliverTime) && string.IsNullOrEmpty(EndDeliverTime)) && StartDeliverTime != "null" && EndDeliverTime != "null")
            {
                str += " and (SELECT  [dbo].[sap2wms_ymd](zdate))+' '+(SELECT  [dbo].[sap2wms_hms](zcjsj)) BETWEEN '" + StartDeliverTime + "' and '" + EndDeliverTime + "' ";
            }

            Hashtable dataHt = this.service.getStockVendorOrderListByPage(pager, direction, str);
            result.Add("rows", dataHt["dataList"]);
            result.Add("pager.totalRows", dataHt["totalCount"]);
            return Json(result);
        }

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

            string str = " 1=1 ";

            if (string.IsNullOrEmpty(EBELN) && string.IsNullOrEmpty(TIME))
            {
                EBELN = "-1";
                TIME = " ";
            }

            str += " AND a.ebeln='" + EBELN + "' ";
            str += " AND (SELECT  [dbo].[sap2wms_ymd](zdate))+' '+(SELECT  [dbo].[sap2wms_hms](zcjsj))='" + TIME + "' ";

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

        }

        /// <summary>
        /// 获取工厂
        /// </summary>
        /// <returns></returns>
        public ActionResult GetFactory()
        {
            Hashtable result = new Hashtable();
            ArrayList list = this.service.GetFactory();
            result.Add("list", list);
            return Json(result, JsonRequestBehavior.AllowGet);
        }

        /// <summary>
        /// 获取供应商
        /// </summary>
        /// <returns></returns>
        public ActionResult GetVendor()
        {
            Hashtable result = new Hashtable();
            ArrayList list = this.service.GetVendor();
            result.Add("list", list);
            return Json(result, JsonRequestBehavior.AllowGet);

        }

        /// <summary>
        /// 订单确认
        /// </summary>
        /// <returns></returns>
        public ActionResult dingDanQueRen(string EBELN)
        {
            Hashtable result = new Hashtable();
            string str = "";

            if (string.IsNullOrEmpty(EBELN) )
            {
                str = "数据异常，请联系管理员。";
                result.Add("list", str);
                return Json(result, JsonRequestBehavior.AllowGet);
            }

            EBELN = EBELN.Substring(0, EBELN.Length - 1);
            //MATNR = MATNR.Substring(0, MATNR.Length - 1);
            //TIME = TIME.Substring(0, TIME.Length - 1);
            //TIME = Convert.ToDateTime(TIME).ToString("yyyyMMdd");

            bool bool_1 = this.service.dingDanQueRen(EBELN);

            if (bool_1 == true)
            {
                str = "订单确认成功！";
            }
            else
            { str = "订单确认失败！"; }

            result.Add("list", str);
            return Json(result, JsonRequestBehavior.AllowGet);

        }

        /// <summary>
        /// 发运确认
        /// </summary>
        /// <returns></returns>
        public ActionResult shipQueRen(string EBELN)
        {
            Hashtable result = new Hashtable();
            string str = "";

            if (string.IsNullOrEmpty(EBELN))
            {
                str = "数据异常，请联系管理员。";
                result.Add("list", str);
                return Json(result, JsonRequestBehavior.AllowGet);
            }

            EBELN = EBELN.Substring(0, EBELN.Length - 1);
            //MATNR = MATNR.Substring(0, MATNR.Length - 1);
            //TIME = TIME.Substring(0, TIME.Length - 1);
            //TIME = Convert.ToDateTime(TIME).ToString("yyyyMMdd");


            bool bool_1 = this.service.shipQueRen(EBELN);

            if (bool_1 == true)
            {
                str = "发运确认成功！";
            }
            else
            { str = "发运确认失败！"; }

            result.Add("list", str);
            return Json(result, JsonRequestBehavior.AllowGet);

        }

        #region
        public ActionResult printTest(string ebeln)
        {
            if (string.IsNullOrEmpty(ebeln))
            {
                return Json("请选择打印数据！");
            }

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

            DataTable dt = new DataTable();

            dt = service.GetOrderByEBELN(ebeln);

            if (dt.Rows.Count <= 0)
            {
                return Json("获取打印数据失败！");
            }
            //string[] str = order_id.Split(',');



            #region 打印页面数值变量

            //页头数据
            string YeMa = "";//页码
            string SongHuoDanHao = dt.Rows[0]["EBELN"].ToString();//送货单号
            string GongYingShangBianHao = dt.Rows[0]["LIFNR"].ToString();//供应商编号
            string SongHuoRiQi = DateTime.Now.ToString("yyyy-MM-dd HH:mm");//送货日期

            string GongYingShangJiFaHuoRen = dt.Rows[0]["vendor_name"].ToString();//供应商及发货人
            string DingDanHao = dt.Rows[0]["EBELN"].ToString(); ;//订单号
            string ChengYunDanWei = "";//承运单位

            string ZhuangHuoDiDan = dt.Rows[0]["vendor_addr"].ToString(); //装货地点
            string XieHuoDiDian = dt.Rows[0]["DOCK"].ToString();//卸货地点
            string BeiZhu = "";//备注
            string DaYingShiJian = DateTime.Now.ToString("yyyy-MM-dd HH:mm");//打印时间

            //明细数据
            string XuHao = "";//序号
            string LingJianHao = "";//零件号
            string LiuShuiHao = "";//流水号
            string LingJianMingCheng = "";//零件名称
            string ShuLiang = "";//数量
            string BeiZhu_2 = "";//备注

            #endregion



            StringBuilder querySen = new StringBuilder(1024);
            querySen.Append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"> ");
            querySen.Append("<html> ");
            querySen.Append("<head> ");
            querySen.Append("   <meta content=\"text/html;charset=gb2312\" http-equiv=\"Content-Type\" /> ");
            querySen.AppendLine("    <title></title>  ");
            querySen.AppendLine("    <!--media=print 这个属性可以在打印时有效-->  ");
            querySen.AppendLine("    <style media=\"print\">  ");
            querySen.AppendLine("        .Noprint  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            display: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        .PageNext  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            page-break-after: always;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("    </style>  ");
            querySen.AppendLine("    <style type=\"text/css\">  ");
            querySen.AppendLine("        body  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            font-family: Arial;  ");
            querySen.AppendLine("            width: 190mm;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        table  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-collapse: collapse;  ");
            querySen.AppendLine("            border: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.border1px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border: 1px dotted #000000;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.border0px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.leftborder0px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-left: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.leftborder1px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-left: 1px dotted #000000;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.rightborder0px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-right: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.rightborder1px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-right: 1px dotted #000000;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        td.bottomborder0px  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            border-bottom: none;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("        .NOPRINT  ");
            querySen.AppendLine("        {  ");
            querySen.AppendLine("            font-family: \"宋体\";  ");
            querySen.AppendLine("            font-size: 9pt;  ");
            querySen.AppendLine("        }  ");
            querySen.AppendLine("    </style>  ");
            querySen.AppendLine("</head>  ");
            querySen.AppendLine("<body style=\"background-color: White;\">  ");
            querySen.AppendLine("    <!--<object id='WebBrowser' width=\"0\" height=\"0\" classid='CLSID:8856F961-340A-11D0-A96B-00C04FD705A2'>  ");
            querySen.AppendLine("    </object>-->  ");
            querySen.AppendLine("    <table align=\"center\" id=\"Table1\" style=\"width: 190mm; font-size: 9pt; margin-top: 2px;\"  ");
            querySen.AppendLine("        cellpadding=\"0\" cellspacing=\"0\">  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 38pt; font-family: C39P36DmTt;  ");
            querySen.AppendLine("                height: 35px; width: 50%;\">  ");
            querySen.AppendLine("                <img width='200'  height='120'   ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"center\" style=\"height: 35px;\">  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"right\" style=\"height: 35px; width: 50%;\" valign=\"top\">  ");
            querySen.AppendLine("                <span style=\"text-align: center; margin-left: 180px;\">页码：1/1</span>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 9pt; font-family: Arial;  ");
            querySen.AppendLine("                height: 25px; padding-top: -10px; padding-left: 10px; vertical-align: top;\">  ");
            querySen.AppendLine("                <font style=\"margin-left: 10px;\">ASN 编号：ASNO0</font>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 11pt; font-family: Arial;  ");
            querySen.AppendLine("                height: 25px; padding-left: 5px;\" rowspan=\"2\">  ");
            querySen.AppendLine("                &nbsp;  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"right\" style=\"font-weight: normal; font-size: 38pt;  ");
            querySen.AppendLine("                font-family: C39P36DmTt; height: 35px; vertical-align: bottom\" rowspan=\"2\">  ");
            querySen.AppendLine("                &nbsp;  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 11pt; font-family: Arial;  ");
            querySen.AppendLine("                height: 25px; padding-left: 5px;\">  ");
            querySen.AppendLine("                <p style=\"font-family: Arial; font-weight: bold; font-size: 18pt; width: 100%; text-align: left;\">  ");
            querySen.AppendLine("                    送货单 Lieferschein</p>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 11pt; font-family: Arial;  ");
            querySen.AppendLine("                height: 25px; padding-left: 5px;\">  ");
            querySen.AppendLine("                &nbsp;  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" align=\"left\" style=\"font-weight: normal; font-size: 11pt; font-family: Arial;  ");
            querySen.AppendLine("                height: 25px; padding-left: 5px;\">  ");
            querySen.AppendLine("                &nbsp;  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td class=\"border0px\" style=\"text-align: right; font-weight: normal; font-size: 9pt;  ");
            querySen.AppendLine("                font-family: Arial; height: 25px;\">  ");
            querySen.AppendLine("                <font style=\"margin-right: 32px;\">送货单编号：PlanNo0</font>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("    </table>  ");
            querySen.AppendLine("    <table align=\"center\" id=\"tbSupplyInfoBorder\" cellpadding=\"0\" cellspacing=\"0\" style=\"width: 190mm;  ");
            querySen.AppendLine("        font-size: 10pt; border: dotted 2px black; border-collapse: collapse; empty-cells: show;\">  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td>  ");
            querySen.AppendLine("                <table id=\"tbSupplyInfo\" style=\"width: 190mm\" cellpadding=\"0\" cellspacing=\"0\">  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td valign=\"top\" style=\"font-size: 9pt; height: 140px; padding-left: 5px; font-family: Arial;\">  ");
            querySen.AppendLine("                            <p style=\"margin-bottom: 0px; padding-bottom: 0px; margin-top: 2px; padding-top: 0px;  ");
            querySen.AppendLine("                                font-family: 黑体;\">  ");
            querySen.AppendLine("                                供应商编号：" + GongYingShangBianHao + "</p>  ");
            querySen.AppendLine("                            <p style=\"margin-top: 5px; padding-top: 0px; font-size: 8pt;\">  ");
            querySen.AppendLine("                                Lieferant Nr</p>  ");
            querySen.AppendLine("                            <p style=\"margin-bottom: 0px; padding-bottom: 0px; margin-top: 35px; font-family: 黑体;\">  ");
            querySen.AppendLine("                                供应商及发货人：" + GongYingShangJiFaHuoRen + "</p>  ");
            querySen.AppendLine("                            <p style=\"margin-top: 5px; padding-top: 0px; font-size: 8pt;\">  ");
            querySen.AppendLine("                                Lieferant</p>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td valign=\"top\" class=\"leftborder1px\" style=\"font-size: 9pt; height: 140px; padding-left: 5px;  ");
            querySen.AppendLine("                            font-family: Arial;\">  ");
            querySen.AppendLine("                            <p style=\"margin-bottom: 0px; padding-bottom: 0px; margin-top: 2px; padding-top: 0px;  ");
            querySen.AppendLine("                                font-family: 黑体;\">  ");
            querySen.AppendLine("                                送货日期：" + SongHuoRiQi + "</p>  ");
            querySen.AppendLine("                            <p style=\"margin-top: 5px; padding-top: 0px; font-size: 8pt; margin-bottom: 0px;  ");
            querySen.AppendLine("                                padding-bottom: 0px;\">  ");
            querySen.AppendLine("                                Datum</p>  ");
            querySen.AppendLine("                            <p style=\"margin-bottom: 0px; padding-bottom: 0px; margin-top: 35px;  ");
            querySen.AppendLine("                                font-family: 黑体;\">  ");
            querySen.AppendLine("                                订单号：" + DingDanHao + "</p>  ");
            querySen.AppendLine("                            <p style=\"margin-top: 5px; padding-top: 0px; font-size: 8pt;\">  ");
            querySen.AppendLine("                                Bestellung Nr</p>  ");
            querySen.AppendLine("                            <p style=\"margin-bottom: 0px; padding-bottom: 0px; margin-top: 30px; font-family: 黑体;\">  ");
            querySen.AppendLine("                                承运单位：" + ChengYunDanWei + "</p>  ");
            querySen.AppendLine("                            <p style=\"margin-top: 5px; padding-top: 0px; font-size: 8pt; margin-bottom: 2px;  ");
            querySen.AppendLine("                                padding-bottom: 0px;\">  ");
            querySen.AppendLine("                                Dienstleister</p>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" style=\"font-size: 9pt; height: 30px;  ");
            querySen.AppendLine("                            text-align: left; padding-left: 5px; font-family: 黑体;\">  ");
            querySen.AppendLine("                            装货地点 <span style=\"font-family: 黑体; font-size: 8pt;\">Laden Stelle：</span> " + ZhuangHuoDiDan + "</td>  ");
            querySen.AppendLine("                        <td class=\"border1px rightborder0px bottomborder0px\" style=\"font-size: 9pt; height: 30px;  ");
            querySen.AppendLine("                            text-align: left; padding-left: 5px; font-family: 黑体;\">  ");
            querySen.AppendLine("                            卸货地点（仓库）<span style=\"font-family: Arial; font-size: 8pt;\">Lager des Wareneingangs：</span>   ");
            querySen.AppendLine("                            " + XieHuoDiDian + "</td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                </table>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td>  ");
            querySen.AppendLine("                <table id=\"tbGwqjInfo\" style=\"width: 190mm\" cellpadding=\"0\" cellspacing=\"0\">  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td class=\"border1px leftborder0px rightborder0px bottomborder0px\" align=\"center\"  ");
            querySen.AppendLine("                            colspan=\"12\" style=\"font-size: 10pt; height: 30px; font-weight: bold;\">  ");
            querySen.AppendLine("                            发送单明细  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            序号  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td width=\"14%\" class=\"border1px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            零件号&nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td width=\"14%\" class=\"border1px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            流水号  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td width=\"14%\" class=\"border1px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            零件名称  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td width=\"14%\" class=\"border1px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            数量  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px rightborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;  ");
            querySen.AppendLine("                            height: 25px; font-weight: normal; font-family: 黑体;\">  ");
            querySen.AppendLine("                            备注  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            //querySen.AppendLine("                    <tr>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            IM2100  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            PartNo0  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            0  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            PartCN0  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            12  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            COMMON0  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                    </tr>  ");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                querySen.AppendLine("                    <tr>  ");
                querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                            " + dt.Rows[i]["EVRTP"].ToString() + "  ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                            " + dt.Rows[i]["MATNR"].ToString() + "  ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                               ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                            " + dt.Rows[i]["part_spec"].ToString() + "  ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                            " + dt.Rows[i]["ZDEV_NUM"].ToString() + "  ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
                querySen.AppendLine("                              ");
                querySen.AppendLine("                        </td>  ");
                querySen.AppendLine("                    </tr>  ");
            }
            //querySen.AppendLine("                    <tr>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            IM2102  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            PartNo2  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            0  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            PartCN2  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td width=\"7%\" class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            14  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" align=\"center\" style=\"font-size: 8pt;\">  ");
            //querySen.AppendLine("                            COMMON2  ");
            //querySen.AppendLine("                        </td>  ");
            //querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                </table>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td>  ");
            querySen.AppendLine("                <table id=\"tbLlqxInfo\" style=\"width: 190mm;\" cellpadding=\"0\" cellspacing=\"0\">  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td class=\"border1px leftborder0px rightborder0px\" align=\"left\" colspan=\"12\" style=\"font-size: 9pt; ");
            querySen.AppendLine("                            height: 80px; font-weight: normal; width: 10%; font-family: 黑体; vertical-align: top;  ");
            querySen.AppendLine("                            white-space: normal; word-break: break-all\">  ");
            querySen.AppendLine("                            备注 Bemerkung：<br />  ");
            querySen.AppendLine("                            拉动单号：0  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 22%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            发货人签字及电话  ");
            querySen.AppendLine("                            <br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Ablieferer Unterschrift & Tel.Nr</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 10%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            日期/时间<br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Datum/Zeit</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 26%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            承运人签字及电话  ");
            querySen.AppendLine("                            <br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Dienstleister Unterschrift & Tel.Nr</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 10%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            日期/时间<br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Datum/Zeit</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 22%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            收货人签字及电话<br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Empfaenger Unterschrift & Tel.Nr</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px rightborder0px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 40px; font-weight: normal; width: 10%; font-family: 黑体;\">  ");
            querySen.AppendLine("                            日期/时间<br />  ");
            querySen.AppendLine("                            <span style=\"font-size: 7.5pt;\">Datum/Zeit</span>  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                    <tr>  ");
            querySen.AppendLine("                        <td class=\"border1px leftborder0px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                        <td class=\"border1px rightborder0px bottomborder0px\" colspan=\"2\" align=\"center\" style=\"font-size: 9pt;  ");
            querySen.AppendLine("                            height: 50px; font-weight: normal;\">  ");
            querySen.AppendLine("                            &nbsp;  ");
            querySen.AppendLine("                        </td>  ");
            querySen.AppendLine("                    </tr>  ");
            querySen.AppendLine("                </table>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("    </table>  ");
            querySen.AppendLine("    <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width: 190mm;  ");
            querySen.AppendLine("        font-size: 8pt; margin-top: 5px;\">  ");
            querySen.AppendLine("        <tr>  ");
            querySen.AppendLine("            <td style=\"font-size: 12pt; font-weight: bold; padding-top: 10px; font-family: 微软雅黑;\">  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("            <td style=\"font-size: 11pt; font-family: Arial; text-align: right;\">  ");
            querySen.AppendLine("                <p style=\"padding-right: 20px; padding-top: 10px;\">  ");
            querySen.AppendLine("                    打印时间：<b>" + DaYingShiJian + "</b></p>  ");
            querySen.AppendLine("            </td>  ");
            querySen.AppendLine("        </tr>  ");
            querySen.AppendLine("    </table>  ");
            querySen.AppendLine("    <hr align=\"center\" width=\"90%\" size=\"1\" noshade class=\"NOPRINT\">  ");
            querySen.AppendLine("    <div class=\"PageNext\">  ");
            querySen.AppendLine("    </div>  ");
            querySen.AppendLine("    <script language='javascript'>        WebBrowser.ExecWB(6, 1); window.opener = null; window.close();</script>  ");
            querySen.AppendLine("</body>  ");
            querySen.AppendLine("</html>  ");

            //int count = this.service.UpdateCount(order_id);

            Hashtable result = new Hashtable();
            result.Add("data", querySen.ToString());
            return Json(result);
        }

        #endregion



    }
}