JCK.Web/declaration/print/GDFPTD_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 = "";

        gl_id = Request.QueryString["gl_id"];

        bool is_entrust = true;
        string sel_sql = "select * from DEC_HEAD where gl_id='" + gl_id + "'";
        System.Data.DataTable dt=JCK.DBUtility.DbHelperSQL.Query(sel_sql).Tables[0];
        if (dt.Rows.Count > 0)
        {
            if (dt.Rows[0]["status"].ToString() == "未委托")
            {
                is_entrust = false;
            }
        }

        if (is_entrust == false)
        {
            ls_sql = @"

select 
convert(varchar(10),a.I_E_DATE,23) I_E_DATE,
(select TD_NAME from TRADE where TRADE_MODE=a.TRADE_MODE) TRADE_MODE,
(select PAY_WAY_NAME from dbo.PAY_WAY where PAY_WAY_CODE=a.PAY_WAY) PAY_WAY,
(select PORT_NAME from  dbo.PORT where PORT_CODE=a.DESTINATION_PORT) DESTINATION_PORT,
(select TR_NAME from TRANSF where TRANSF=a.TRAF_MODE) TRAF_MODE,

b.G_NAME,b.G_MODEL,b.G_QTY,b.DECL_PRICE,b.DECL_TOTAL,
(select UT_NAME from unit where UNIT=b.G_UNIT) G_UNIT,
b.TRADE_CURR,(select CR_NAME from CURR where CURR=b.TRADE_CURR) TRADE_CURR_NAME,(select cr_ab from CURR where CURR=b.TRADE_CURR) TRADE_CURR_cr_ab,
(select top 1 agree_no from pts_ems_head_audit where ems_no=a.MANUAL_NO) agree_no
from dbo.DEC_HEAD a 
left join dbo.DEC_DETAIL b on b.GL_ID=a.GL_ID

where a.gl_id='" + gl_id + @"' 
  ";
        }
        else
        {
        ls_sql = @"

select 
convert(varchar(10),a.I_E_DATE,23) I_E_DATE,
(select TD_NAME from TRADE where TRADE_MODE=a.TRADE_MODE) TRADE_MODE,
(select PAY_WAY_NAME from dbo.PAY_WAY where PAY_WAY_CODE=a.PAY_WAY) PAY_WAY,
(select PORT_NAME from  dbo.PORT where PORT_CODE=a.DESTINATION_PORT) DESTINATION_PORT,