JCK.Web/declaration/dec_entrust_status_list.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using JCK.Common;
using System.Data;

namespace JCK.Web.declaration
{
    public partial class dec_entrust_status_list : Web.UI.ManagePage
    {
        protected Model.Info info;
        protected Model.Online_User on_u;
        protected string keywords;
        int pageSize = 10;
 

        protected void Page_Load(object sender, EventArgs e)
        {
         
            info = GetInfo();
            on_u = GetUserInfo();

            if (!IsPostBack)
            {

                ChkAdminLevel("entrust_bg", CEnums.ActionEnum.View.ToString()); //检查权限

                full();
                rptBind();
            }
        }

        #region 数据绑定=================================
        private void rptBind()
        {
            this.keywords = txtKeywords.Text;

            string strSql = @"
                select a.D_ID,a.GL_ID,a.ParentNo,a.ENTRY_ID,a.ENTRY_TYPE,a.I_E_FLAG,a.DECL_PORT,a.
                I_E_PORT,a.I_E_DATE,a.D_DATE,a.DESTINATION_PORT,a.TRAF_MODE,a.TRAF_NAME,a.VOYAGE_NO,a.
                BILL_NO,a.TRADE_CO,a.TRADE_NAME,a.CO_OWNER,a.OWNER_CODE,a.OWNER_NAME,a.DISTRICT_CODE,a.
                AGENT_CODE,a.AGENT_NAME,a.CONTR_NO,a.IN_RATIO,a.TRADE_COUNTRY,a.TRADE_MODE,a.CUT_MODE,a.
                TRANS_MODE,a.CONTAINER_NO,a.PAY_WAY,a.FEE_MARK,a.FEE_CURR,a.FEE_RATE,a.INSUR_MARK,a.INSUR_CURR,a.
                INSUR_RATE,a.OTHER_MARK,a.OTHER_CURR,a.OTHER_RATE,a.PACK_NO,a.GROSS_WT,a.NET_WT,a.WRAP_TYPE,a.
                LICENSE_NO,a.APPR_NO,a.MANUAL_NO,a.RELATIVE_ID,a.RELATIVE_MANUAL_NO,a.BONDED_NO,a.CUSTOMS_FIELD,a.
                EDI_ID,a.EDI_REMARK,a.PARTENER_ID,a.P_DATE,a.TYPIST_NO,a.DECLARE_NO,a.BP_NO,a.NOTE_S,a.Entrust,a.status

                from DEC_HEAD_Entrust a
                where isnull(a.Entrust,'')<>''  
            ";

 
            if (ddlStatus.SelectedValue != "0")
            {
                strSql += " and (select [Status] from DEC_HEAD where GL_ID=a.GL_ID)='" + ddlStatus.SelectedValue + @"'";
            }