JCK.Web/declaration/print/contract_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 (List_Mark == "E") //查成品表
        { 
        }
        else if (List_Mark == "I") //查料件表
        { 
        }


        //出口时，报关单中的买方=合同的买方，那企业用户所属企业就对应是合同的卖方
        

        if (type == "list")
        {
            
                ls_sql = @"
declare @total_total float
select @total_total=SUM(Dec_Total) from DEC_LIST_DETAIL where gl_id='" + gl_id + @"'
   
--(select (select top 1 dz from Offline_Customer where hgbm=TRADE_CODE) from dbo.pts_ems_head_audit where ems_no=a.Manual_No) cus_dz,
--(select top 1 dz from Offline_Customer where hgbm=a.TRADE_CO) cus_dz,
        
select 


ISNULL((select top 1 name from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
(select top 1 name from Online_Enterprise where hgbm=a.Business and bh=a.ParentNo)) Business_Name,
ISNULL((select top 1 dz from Offline_Customer where hgbm=a.Business and ParentNo=a.ParentNo),
(select top 1 dz from Online_Enterprise where hgbm=a.Business and Bh=a.ParentNo)) dz,
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)) Business_Name_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)) 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)) lxdh,
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)) fax,