/// <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(); }