//获取合同附加订单(打印) public string GetPrintContractOrdersByContractsID(int Contract_ID) { string strHTML = ""; int i = 0; strHTML += "<table border=\"0\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"><tr><td>"; strHTML += "<table border=\"0\" width=\"608\" align=\"right\" class=\"list_tab\" style=\"border:1px solid #000000;\" cellpadding=\"0\" cellspacing=\"0\">"; strHTML += " <tr bgcolor=\"#ffffff\">"; strHTML += " <td align=\"center\" style=\"height:25px;\" width=\"50\">序号</td>"; strHTML += " <td align=\"center\">订单编号</td>"; strHTML += " <td align=\"center\">商品种类</td>"; strHTML += " <td align=\"center\">数量</td>"; strHTML += " <td align=\"center\">订单金额</td>"; strHTML += " <td align=\"center\">下单时间</td>"; strHTML += " </tr>"; int Goods_Amount = 0; double Goods_Sum = 0; IList <OrdersGoodsInfo> GoodsListAll = null; ContractInfo Contract = GetContractByID(Contract_ID); if (Contract != null) { IList <OrdersInfo> ordersinfos = MyOrders.GetOrderssByContractID(Contract_ID); if (ordersinfos != null) { foreach (OrdersInfo ordersinfo in ordersinfos) { Goods_Sum = 0; Goods_Amount = 0; i = i + 1; GoodsListAll = MyOrders.GetGoodsListByOrderID(ordersinfo.Orders_ID); if (GoodsListAll != null) { foreach (OrdersGoodsInfo good in GoodsListAll) { if ((good.Orders_Goods_ParentID == 0 && good.Orders_Goods_Type != 2) || good.Orders_Goods_ParentID > 0) { Goods_Amount = Goods_Amount + 1; Goods_Sum = Goods_Sum + good.Orders_Goods_Amount; } } } strHTML += " <tr bgcolor=\"#ffffff\">"; strHTML += " <td align=\"left\">" + i + "</td>"; strHTML += " <td align=\"left\">" + ordersinfo.Orders_SN + "</td>"; strHTML += " <td align=\"left\">" + Goods_Amount + "</td>"; strHTML += " <td align=\"left\">" + Goods_Sum + "</td>"; strHTML += " <td align=\"left\">" + Public_Class.DisplayCurrency(ordersinfo.Orders_Total_AllPrice) + "</td>"; strHTML += " <td align=\"left\">" + ordersinfo.Orders_Addtime + "</td>"; strHTML += " </tr>"; } } } strHTML += " </table></td></tr></table>"; return(strHTML); }
//合同订单所有产品(打印) public string Contract_Orders_Goods_Print(int Contract_ID) { string strHTML = ""; IList <OrdersGoodsInfo> GoodsListAll = null; int freighted_amount; int icount = 0; ContractInfo contractinfo = GetContractByID(Contract_ID); if (contractinfo != null) { strHTML += "<table width=\"635\" border=\"0\" align=\"center\" class=\"list_tab\" style=\"border:1px solid #000000;page-break-before:always;\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#000000\">"; strHTML += "<tr bgcolor=\"#ffffff\">"; strHTML += "<td align=\"center\" style=\"height:25px;\" width=\"50\">序号</td>"; strHTML += "<td align=\"center\">产品名称</td>"; //strHTML += "<td align=\"center\">订单号</td>"; strHTML += "<td align=\"center\">规格型号</td>"; strHTML += "<td align=\"center\">单位</td>"; strHTML += "<td align=\"center\">单价(元)</td>"; if (contractinfo.Contract_Status == 1) { strHTML += "<td align=\"center\">规格</td>"; strHTML += "<td align=\"center\">单价</td>"; strHTML += "<td align=\"center\">数量</td>"; strHTML += "<td align=\"center\">金额</td>"; } else { strHTML += "<td align=\"center\">数量</td>"; } //strHTML += "<td align=\"center\">总价(元)</td>"; strHTML += "</tr>"; IList <OrdersInfo> ordersinfos = MyOrders.GetOrderssByContractID(Contract_ID); if (ordersinfos != null) { foreach (OrdersInfo ordersinfo in ordersinfos) { GoodsListAll = MyOrders.GetGoodsListByOrderID(ordersinfo.Orders_ID); if (GoodsListAll != null) { foreach (OrdersGoodsInfo entity in GoodsListAll) { string Product_Spec = ""; string Product_Unit = ""; ProductInfo productEntity = new Product().GetProductByID(entity.Orders_Goods_Product_ID); if (productEntity != null) { Product_Spec = productEntity.Product_Spec; Product_Unit = productEntity.Product_Unit; if (Product_Unit == "0") { Product_Unit = ""; } } if (entity.Orders_Goods_Type == 2 && entity.Orders_Goods_ParentID == 0) { freighted_amount = 0; } else { icount = icount + 1; strHTML += "<tr bgcolor=\"#ffffff\">"; strHTML += "<td align=\"center\">" + icount + "</td>"; strHTML += "<td align=\"center\">" + entity.Orders_Goods_Product_Name + "</td>"; //strHTML += "<td align=\"center\">" + ordersinfo.Orders_SN + "</td>"; strHTML += "<td align=\"center\">" + Product_Spec + "</td>"; strHTML += "<td align=\"center\">" + Product_Unit + "</td>"; strHTML += "<td align=\"center\">" + entity.Orders_Goods_Product_Price + "</td>"; if (contractinfo.Contract_Status == 1) { strHTML += "<td align=\"center\">" + entity.Orders_Goods_Product_Spec + " </td>"; strHTML += "<td align=\"center\">" + Public_Class.DisplayCurrency(entity.Orders_Goods_Product_Price) + "</td>"; strHTML += "<td align=\"center\">" + (entity.Orders_Goods_Amount) + "</td>"; strHTML += "<td align=\"center\">" + (Public_Class.DisplayCurrency(entity.Orders_Goods_Product_Price * entity.Orders_Goods_Amount)) + "</td>"; } else { strHTML += "<td align=\"center\">" + (entity.Orders_Goods_Amount) + "</td>"; } //strHTML += "<td align=\"center\">" + (entity.Orders_Goods_Product_Price * entity.Orders_Goods_Amount) + "</td>"; strHTML += "</tr>"; } } } } } } strHTML += "</table>"; return(strHTML); }