/// <summary>
 /// 添加获取到的数据到泛型变量
 /// </summary>
 /// <param name="tab">包含指定格式的数据表</param>
 /// <param name="l">将数据填写到的泛型变量</param>
 private void AddRemarkListItem(DataSetSampleOrderMgr.t_sample_orderDataTable tab, ref List<RemarkLiItem> l)
 {
     //li内容
     foreach (DataSetSampleOrderMgr.t_sample_orderRow row in tab.Rows)
     {
         //实例化li项目类
         var itm = new RemarkLiItem();
         //设置实例的值
         //备注
         itm.Remark = row.remark;
         //将实例加入泛型变量
         l.Add(itm);
     }
 }
 /// <summary>
 /// 添加获取到的数据到泛型变量
 /// </summary>
 /// <param name="tab">包含指定格式的数据表</param>
 /// <param name="l">将数据填写到的泛型变量</param>
 private void AddDeliveryOrderListItem(DataSetSampleOrderMgr.t_sample_orderDataTable tab, ref List<DeliverySampleOrderLiItem> l)
 {
     //li内容
     foreach (DataSetSampleOrderMgr.t_sample_orderRow row in tab.Rows)
     {
         //实例化li项目类
         var itm = new DeliverySampleOrderLiItem();
         //设置实例的值
         //订单序号
         itm.OrderId = row.order_id;
         //订单编号
         if (!row.Isorder_numNull())
         {
             itm.OrderNum = row.order_num;
         }
         //样板编号
         itm.ProductNum = row.product_num;
         //客户名称
         itm.CustName = row.cust_name;
         //客户料号
         itm.CustNum = row.cust_num;
         //订单结余pcs数
         itm.BalancePcsQty = row.balance_pcs_qty;
         //交货日期
         itm.NeedDate = row.need_date;
         //备注
         if (!row.IsremarkNull())
         {
             itm.Remark = row.remark;
         }
         //将实例加入泛型变量
         l.Add(itm);
     }
 }
 /// <summary>
 /// 添加获取到的数据到泛型变量
 /// </summary>
 /// <param name="tab">包含指定格式的数据表</param>
 /// <param name="l">将数据填写到的泛型变量</param>
 private void AddOrderListItem(DataSetSampleOrderMgr.t_sample_orderDataTable tab, ref List<SampleOrderLiItem> l)
 {
     //li内容
     foreach (DataSetSampleOrderMgr.t_sample_orderRow row in tab.Rows)
     {
         //实例化li项目类
         var itm = new SampleOrderLiItem();
         //设置实例的值
         //订单序号
         itm.OrderId = row.order_id;
         //状态
         if (!row.IsstateNull())
         {
             itm.State = row.state;
         }
         //良率
         itm.OkPercent = row.ok_percent;
         //样板编号
         itm.ProductNum = row.product_num;
         //pcs面积
         itm.PcsArea = row.pcs_area;
         //客户名称
         itm.CustName = row.cust_name;
         //客户料号
         itm.CustNum = row.cust_num;
         //订单编号
         if (!row.Isorder_numNull())
         {
             itm.OrderNum = row.order_num;
         }
         //订单pcs总数
         itm.OrderPcsQty = row.order_pcs_qty;
         //订单pcs面积
         itm.OrderPcsArea = row.order_pcs_area;
         //下单日期
         itm.OrderDate = row.order_date;
         //需求日期
         itm.NeedDate = row.need_date;
         //生产日期
         if (!row.Isproduct_dateNull())
         {
             itm.ProductDate = row.product_date;
         }
         //备注
         if (!row.IsremarkNull())
         {
             itm.Remark = row.remark;
         }
         //将实例加入泛型变量
         l.Add(itm);
     }
 }
        /// <summary>
        /// 创建订单信息表的html代码
        /// </summary>
        /// <param name="tab">订单信息表</param>
        /// <returns></returns>
        private string CreateOrderInfoTable(DataSetSampleOrderMgr.t_sample_orderDataTable tab)
        {
            //检测是否含有数据
            if (tab.Rows.Count == 0)
            {
                return string.Empty;
            }
            //首行
            var row = tab.Rows[0];
            //存储待返回的数据
            var sb = new StringBuilder();
            //写入数据
            sb.Append("<table id='tabOrderInfo' class='yd-add-tab'>");
            sb.Append("<tbody>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>订单序号:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["order_id"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>状况:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["state"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>良率:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["ok_percent"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>初始样板编号:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["product_num"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>pnl长:</span>");
            sb.Append("<span class='yd-1of6-span'>");
            sb.Append(HtmlEncode(row["pnl_length"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>pnl宽:</span>");
            sb.Append("<span class='yd-1of6-span'>");
            sb.Append(HtmlEncode(row["pnl_width"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>pnl面积:</span>");
            sb.Append("<span class='yd-1of6-span'>");
            sb.Append(HtmlEncode(row["pnl_area"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>客户名称:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["cust_name"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>客户料号:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["cust_num"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>订单编号:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["order_num"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>订单pcs数:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["order_pcs_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>订单pcs面积:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["order_pcs_area"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");

            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>事业部:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["market_dept"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>销售单号:</span>");
            sb.Append("<span class='yd-2of3-span'>");
            sb.Append(HtmlEncode(row["sale_num"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");

            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>特殊流程:</span>");
            sb.Append("<span class='yd-2of3-span'>");
            sb.Append(HtmlEncode(row["special_flow"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>SMT备注:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["smt_remark"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");

            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>FPC单价:</span>");
            sb.Append("<span class='yd-1of4-span'>");
            sb.Append(HtmlEncode(row["unit_price_fpc"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>SMT单价:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["unit_price_smt"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>批次号:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["batch_num"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");

            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>规格:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["specification"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>备品数量:</span>");
            sb.Append("<span class='yd-1of5-span'>");
            sb.Append(HtmlEncode(row["foc_pcs_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>覆盖膜:</span>");
            sb.Append("<span class='yd-1of5-span'>");
            sb.Append(HtmlEncode(row["cover_membrane"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>投料率:</span>");
            sb.Append("<span class='yd-1of5-span'>");
            sb.Append(HtmlEncode(row["feeding_rate"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");

            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>开料pnl数:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["total_pnl_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>开料pnl面积:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["total_pnl_area"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>pnl含pcs数:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["pnl_count_pcs"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>开料pcs数:</span>");
            sb.Append("<span class='yd-1of2-span'>");
            sb.Append(HtmlEncode(row["total_pcs_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>落单日期:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            var dt = row["order_date"] as DateTime?;
            if (dt.HasValue)
            {
                sb.Append(dt.Value.ToString("yyyy-MM-dd"));
            }
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>需求日期:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            dt = row["need_date"] as DateTime?;
            if (dt.HasValue)
            {
                sb.Append(dt.Value.ToString("yyyy-MM-dd"));
            }
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>生产日期:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            dt = row["product_date"] as DateTime?;
            if (dt.HasValue)
            {
                sb.Append(dt.Value.ToString("yyyy-MM-dd"));
            }
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>已交货pcs数:</span>");
            sb.Append("<span class='yd-1of6-span'>");
            sb.Append(HtmlEncode(row["out_pcs_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>已交货pcs面积:</span>");
            sb.Append("<span class='yd-1of4-span'>");
            sb.Append(HtmlEncode(row["out_pcs_area"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>欠出货pcs数:</span>");
            sb.Append("<span class='yd-1of6-span'>");
            sb.Append(HtmlEncode(row["balance_pcs_qty"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>欠出货pcs面积:</span>");
            sb.Append("<span class='yd-1of4-span'>");
            sb.Append(HtmlEncode(row["balance_pcs_area"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>备注:</span>");
            sb.Append("<span class='yd-span'>");
            sb.Append(HtmlEncode(row["remark"].ToString()));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append("<td>");
            sb.Append("<span class='yd-name-span'>录入员:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(HtmlEncode(row["add_person"].ToString()));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>录入时间:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(Convert.ToDateTime(row["add_time"]).ToString("yyyy-MM-dd HH:mm"));
            sb.Append("</span>");
            sb.Append("<span class='yd-name-span'>修改时间:</span>");
            sb.Append("<span class='yd-1of3-span'>");
            sb.Append(Convert.ToDateTime(row["last_change_time"]).ToString("yyyy-MM-dd HH:mm"));
            sb.Append("</span>");
            sb.Append("</td>");
            sb.Append("</tr>");
            sb.Append("</tbody>");
            sb.Append("</table>");
            //返回内容
            return sb.ToString();
        }
 /// <summary>
 /// 添加获取到的数据到泛型变量
 /// </summary>
 /// <param name="iBillType">送货单单据模版类型</param>
 /// <param name="tab">包含指定格式的数据表</param>
 /// <param name="l">将数据填写到的泛型变量</param>
 private void AddDeliveryOrderListItem(
     byte iBillType,
     DataSetSampleOrderMgr.t_sample_orderDataTable tab,
     ref List<DeliverySampleOrderLiItem> l
 )
 {
     //li内容
     foreach (DataSetSampleOrderMgr.t_sample_orderRow row in tab.Rows)
     {
         //实例化li项目类
         var itm = new DeliverySampleOrderLiItem();
         //设置实例的值
         //单据类型
         itm.BillType = iBillType;
         //订单序号
         itm.OrderId = row.order_id;
         //样板编号
         if (!row.Isproduct_numNull())
         {
             itm.ProductNum = row.product_num;
         }
         //客户名称
         if (!row.Iscust_nameNull())
         {
             itm.CustName = row.cust_name;
         }
         //客户料号
         if (!row.Iscust_numNull())
         {
             itm.CustNum = row.cust_num;
         }
         //订单编号
         if (!row.Isorder_numNull())
         {
             itm.OrderNum = row.order_num;
         }
         //事业部
         if (!row.Ismarket_deptNull())
         {
             itm.MarketDept = row.market_dept;
         }
         //规格
         if (!row.IsspecificationNull())
         {
             itm.Specification = row.specification;
         }
         //备品数量
         if (!row.Isfoc_pcs_qtyNull())
         {
             itm.FocPcsQty = row.foc_pcs_qty;
         }
         //订单结余pcs数
         itm.BalancePcsQty = row.balance_pcs_qty;
         //批次号
         if (!row.Isbatch_numNull())
         {
             itm.BatchNum = row.batch_num;
         }
         //生产日期
         if (!row.Isproduct_dateNull())
         {
             itm.ProductDate = row.product_date;
         }
         //交货日期
         if (!row.Isneed_dateNull())
         {
             itm.NeedDate = row.need_date;
         }
         //备注
         if (!row.IsremarkNull())
         {
             itm.Remark = row.remark;
         }
         //将实例加入泛型变量
         l.Add(itm);
     }
 }
 /// <summary>
 /// 添加获取到的数据到泛型变量
 /// </summary>
 /// <param name="tab">包含指定格式的数据表</param>
 /// <param name="l">将数据填写到的泛型变量</param>
 private void AddOrderListItem(DataSetSampleOrderMgr.t_sample_orderDataTable tab, ref List<SampleOrderLiItem> l)
 {
     //li内容
     foreach (DataSetSampleOrderMgr.t_sample_orderRow row in tab.Rows)
     {
         //实例化li项目类
         var itm = new SampleOrderLiItem();
         //设置实例的值
         //订单序号
         itm.OrderId = row.order_id;
         //状况
         if (!row.IsstateNull())
         {
             itm.State = row.state;
         }
         //良率
         if (!row.Isok_percentNull())
         {
             itm.OkPercent = row.ok_percent;
         }
         //样板编号
         if (!row.Isproduct_numNull())
         {
             itm.ProductNum = row.product_num;
         }
         //pnl长
         itm.PnlLength = row.pnl_length;
         //pnl宽
         itm.PnlWidth = row.pnl_width;
         //客户名称
         if (!row.Iscust_nameNull())
         {
             itm.CustName = row.cust_name;
         }
         //客户料号
         itm.CustNum = row.cust_num;
         //订单编号
         if (!row.Isorder_numNull())
         {
             itm.OrderNum = row.order_num;
         }
         //事业部
         itm.MarketDept = row.market_dept;
         //销售单号
         itm.SaleNum = row.sale_num;
         //特殊流程
         itm.SpecialFlow = row.special_flow;
         //SMT备注
         itm.SmtRemark = row.smt_remark;
         //FPC单价
         itm.UnitPriceFpc = row.unit_price_fpc;
         //SMT单价
         itm.UnitPriceSmt = row.unit_price_smt;
         //批次号
         itm.BatchNum = row.batch_num;
         //规格
         itm.Specification = row.specification;
         //备品数量
         itm.FocPcsQty = row.foc_pcs_qty;
         //覆盖膜
         itm.CoverMembrane = row.cover_membrane;
         //投料率
         itm.FeedingRate = row.feeding_rate;
         //订单pcs数
         itm.OrderPcsQty = row.order_pcs_qty;
         //开料pnl数
         itm.TotalPnlQty = row.total_pnl_qty;
         //pnl含pcs数
         itm.PnlCountPcs = row.pnl_count_pcs;
         //开料pcs数
         itm.TotalPcsQty = row.total_pcs_qty;
         //落单日期
         itm.OrderDate = row.order_date;
         //需求日期
         if (!row.Isneed_dateNull())
         {
             itm.NeedDate = row.need_date;
         }
         //生产日期
         if (!row.Isproduct_dateNull())
         {
             itm.ProductDate = row.product_date;
         }
         //备注
         if (!row.IsremarkNull())
         {
             itm.Remark = row.remark;
         }
         //将实例加入泛型变量
         l.Add(itm);
     }
 }
 /// <summary>
 /// 创建订单信息表的html代码
 /// </summary>
 /// <param name="tab">订单信息表</param>
 /// <returns></returns>
 private string CreateOrderInfoTable(DataSetSampleOrderMgr.t_sample_orderDataTable tab)
 {
     //检测是否含有数据
     if (tab.Rows.Count == 0)
     {
         return string.Empty;
     }
     //首行
     var row = tab.Rows[0];
     //存储待返回的数据
     var sb = new StringBuilder();
     //写入数据
     sb.Append("<table id='tabOrderInfo' class='yd-add-tab'>");
     sb.Append("<tbody>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>订单序号:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["order_id"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>状态:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["state"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>良率:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["ok_percent"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>初始样板编号:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["product_num"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>pnl长:</span>");
     sb.Append("<span class='yd-1of6-span'>");
     sb.Append(HtmlEncode(row["pnl_length"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>pnl宽:</span>");
     sb.Append("<span class='yd-1of6-span'>");
     sb.Append(HtmlEncode(row["pnl_width"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>pnl面积:</span>");
     sb.Append("<span class='yd-1of6-span'>");
     sb.Append(HtmlEncode(row["pnl_area"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>客户名称:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["cust_name"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>客户料号:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["cust_num"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>订单编号:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["order_num"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>订单pcs总数:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["order_pcs_qty"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>订单pcs面积:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["order_pcs_area"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>开料pnl数:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["total_pnl_qty"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>开料pnl面积:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["total_pnl_area"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>pnl含pcs数:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["pnl_count_pcs"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>开料pcs数:</span>");
     sb.Append("<span class='yd-1of2-span'>");
     sb.Append(HtmlEncode(row["total_pcs_qty"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>下单日期:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     var dt = row["order_date"] as DateTime?;
     if (dt.HasValue)
     {
         sb.Append(dt.Value.ToString("yyyy-MM-dd"));
     }
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>需求日期:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     dt = row["need_date"] as DateTime?;
     if (dt.HasValue)
     {
         sb.Append(dt.Value.ToString("yyyy-MM-dd"));
     }
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>生产日期:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     dt = row["product_date"] as DateTime?;
     if (dt.HasValue)
     {
         sb.Append(dt.Value.ToString("yyyy-MM-dd"));
     }
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>已交货pcs数:</span>");
     sb.Append("<span class='yd-1of6-span'>");
     sb.Append(HtmlEncode(row["out_pcs_qty"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>已交货pcs面积:</span>");
     sb.Append("<span class='yd-1of4-span'>");
     sb.Append(HtmlEncode(row["out_pcs_area"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>欠交货pcs数:</span>");
     sb.Append("<span class='yd-1of6-span'>");
     sb.Append(HtmlEncode(row["balance_pcs_qty"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>欠交货pcs面积:</span>");
     sb.Append("<span class='yd-1of4-span'>");
     sb.Append(HtmlEncode(row["balance_pcs_area"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>备注:</span>");
     sb.Append("<span class='yd-span'>");
     sb.Append(HtmlEncode(row["remark"].ToString()));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("<tr>");
     sb.Append("<td>");
     sb.Append("<span class='yd-name-span'>录入员:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(HtmlEncode(row["add_person"].ToString()));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>录入时间:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(Convert.ToDateTime(row["add_time"]).ToString("yyyy-MM-dd HH:mm"));
     sb.Append("</span>");
     sb.Append("<span class='yd-name-span'>修改时间:</span>");
     sb.Append("<span class='yd-1of3-span'>");
     sb.Append(Convert.ToDateTime(row["last_change_time"]).ToString("yyyy-MM-dd HH:mm"));
     sb.Append("</span>");
     sb.Append("</td>");
     sb.Append("</tr>");
     sb.Append("</tbody>");
     sb.Append("</table>");
     //返回内容
     return sb.ToString();
 }