username@email.com
2025-01-17 8d51a0762a43eedada5eb15bd24180d7204e63b3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.Sys;
using CY.BLL.OA;
using CY.BLL.EC;
using CY.BLL.Inquiry;
using CY.Model.Inquiry;
namespace CY.WebForm.Pages.business
{
    public partial class DeliverPlanPrint : BasePage
    {
        OA_DeliverPlanBLL _OA_DeliverPlanBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;
        OA_CarManageBll _OA_CarManageBll = null;
 
        public string ssshtml = "";
 
        //初始化
        public DeliverPlanPrint()
        {
 
            _OA_DeliverPlanBLL = new OA_DeliverPlanBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            _OA_CarManageBll = new OA_CarManageBll();
 
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            
            if (!IsPostBack)
            {
 
 
 
 
                   
                        BindList();
                     
            }
        }
 
        //绑定列表
        private void BindList()
        {
 
            Pagination pa = new Pagination();
            pa.PageSize = 1000;
            pa.PageIndex = 1;
 
            string CarId = Request["CarId"].ToString2();
            string DriverId = Request["DriverId"].ToString2();
 
            string DeliverTime = Request["DeliverTime"].ToString2();
 
            IEnumerable<OA_DeliverPlan> oA_DeliverPlans = _OA_DeliverPlanBLL.SelectModelPage(pa,
                CurrentUser.MemberId,
                DeliverTime,
                 CarId,
                DriverId
              );
 
 
            int aaa = 1;
 
        List<OA_DeliverPlan>  oA_DeliverPlans1 =   oA_DeliverPlans.OrderBy(x=>x.DriverId).ThenBy(x=>x.Sort).ToList();
            ssshtml = "";
            ssshtml += "<div class=\"printtable printtable1\"> <table   border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border:0;\">";
            ssshtml += "<tr><th style=\"width:3%;\">顺序</th><th style=\"text-align:center;\"width=\"7%\">要求到达时间</th><th width=\"10%\">业务经理</th><th width=\"15%\">客户单位</th><th style=\"text-align:center;\"width=\"30%\">客户地址、联系人及联系电话</th><th width=\"5%\">货单数量</th><th width=\"7%\">车辆</th><th width=\"7%\">驾驶员</th><th width=\"30%\">注意事项</th></tr>";
            for (int i=0;i< oA_DeliverPlans1.Count; i++)
            {
                if (i != 0 && oA_DeliverPlans1[i].DriverId != oA_DeliverPlans1[i - 1].DriverId)
                {
                    ssshtml += "</table></div>";
                    ssshtml += "<br/><br/>";
                    ssshtml += "<div class=\"printtable printtable" + (aaa + 1) + "\"> <table   border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border:0;\">";
                    ssshtml += "<tr><th style=\"width:3%;\">顺序</th><th style=\"text-align:center;\"width=\"7%\">要求到达时间</th><th width=\"10%\">业务经理</th><th width=\"15%\">客户单位</th><th style=\"text-align:center;\"width=\"30%\">客户地址、联系人及联系电话</th><th width=\"5%\">货单数量</th><th width=\"7%\">车辆</th><th width=\"7%\">驾驶员</th><th width=\"30%\">注意事项</th></tr>";
                    aaa = aaa + 1;
                }
 
 
 
                ssshtml += "<tr><td>"+oA_DeliverPlans1[i].Sort+"</td><td>"+ oA_DeliverPlans1[i].DeliverTime.Value.ToString("yyyy-MM-dd")+"</td><td>"+ oA_DeliverPlans1[i].BusinessManager +"</td><td>"+ oA_DeliverPlans1[i].BuyerName +"</td><td>"+ oA_DeliverPlans1[i].DizhiLianxirenDianhua +"</td><td>"+ oA_DeliverPlans1[i].shuliang +"</td><td>"+ oA_DeliverPlans1[i].CarName+" </td><td>"+ oA_DeliverPlans1[i].DriverName +"</td><td>"+ oA_DeliverPlans1[i].Zhuyishixiang +"</td></tr>";
  
               
 
 
            }
            ssshtml += "</table></div>";
 
            // this.RepClientList.DataSource =
            //this.RepClientList.DataBind();
            //UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }
 
    }
}