|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" 零件号 ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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(" ");
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
}
|