JCK.Web/declaration/print/pi_I_cs_prt.aspx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ Page Language="C#" %>

using System.Web.Security;

<script runat="server"> 
    protected void Page_Load(object sender, EventArgs e)
    {
        //★特别提示★：        //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlReportData，Oracle数据库用OracleReportData
        //OledbReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据



        string ls_sql = "", gl_id = "",List_Mark = "", type="";
        JCK.Web.UI.ManagePage mp = new JCK.Web.UI.ManagePage();
        JCK.Model.Online_User on_u = mp.GetUserInfo();
        
        gl_id = Request.QueryString["gl_id"];
        List_Mark = Request.QueryString["List_Mark"];
        type = Request.QueryString["type"];


        //出口时，报关单中的买方=合同的买方，那企业用户所属企业就对应是合同的卖方
        //“I”－进口 “E”－出口
        if (type == "list")
        {
             
                ls_sql = @"
                declare @total_qty int 
                declare @total_total float

                select @total_qty=SUM(qty) from DEC_LIST_DETAIL where gl_id='" + gl_id + @"'
                select @total_total=SUM(Dec_Total) from DEC_LIST_DETAIL where gl_id='" + gl_id + @"'
                            
                select 
 
(select TRADE_NAME from DEC_HEAD_Entrust where l_gl_id=a.gl_id) Buyer_EN,
--ISNULL((select top 1 ForeignName from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
--(select top 1 ForeignName from Online_Enterprise where hgbm=a.Business and Bh=a.ParentNo)) Buyer_EN,
ISNULL((select top 1 ForeignAddress from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
(select top 1 ForeignAddress from Online_Enterprise where hgbm=a.Business and Bh=a.ParentNo)) Buyer_dz_EN,
ISNULL((select top 1 lxdh from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
(select top 1 lxdh from Online_Enterprise where hgbm=a.Business and Bh=a.ParentNo)) Buyer_tel,
ISNULL((select top 1 fax from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
(select top 1 fax from Online_Enterprise where hgbm=a.Business and Bh=a.ParentNo)) Buyer_fax,

--ISNULL((select top 1 ForeignName from Offline_Customer where hgbm=a.Owener and ParentNo=a.ParentNo),
--(select top 1 ForeignName from Online_Enterprise where hgbm=a.Owener and Bh=a.ParentNo)) Business_Name_EN,
--ISNULL((select top 1 ForeignAddress from Offline_Customer where hgbm=a.Owener and ParentNo=a.ParentNo),
--(select top 1 ForeignAddress from Online_Enterprise where hgbm=a.Owener and Bh=a.ParentNo)) dz_EN,
--ISNULL((select top 1 lxdh from Offline_Customer where hgbm=a.Owener and ParentNo=a.ParentNo),
--(select top 1 lxdh from Online_Enterprise where hgbm=a.Owener and Bh=a.ParentNo)) lxdh,
--ISNULL((select top 1 fax from Offline_Customer where hgbm=a.Owener and ParentNo=a.ParentNo),
--(select top 1 fax from Online_Enterprise where hgbm=a.Owener and Bh=a.ParentNo)) fax,                

a.buyer Business_Name_EN,
a.buyer_dz  dz_EN,
null lxdh,
null fax,