C# CAACommon.GetValueSetParameter方法代码示例

        /// <summary>
        /// CAA02報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable CAA20_1(ArrayList ParameterList)
        {
            #region 宣告變數

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_ReportService = new ArrayList();
            DataTable dt_Return = new DataTable();

            #endregion

            #region 傳入參數

            arl_ReportService.Clear();
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[收票日]起
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//[收票日]迄
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[託收日]起
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[託收日]迄
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[收款單號日期]起
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "date", false));//[收款單號日期]迄
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[營業所]起
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[營業所]迄
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[營業人員]
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//[帳務人員]

            #endregion

            #region 連結資料庫

            BCO.MaintainBondMain bco = new BCO.MaintainBondMain(ConntionDB);
            dt_Return = bco.BondReport(arl_ReportService);

            #endregion

            #region 檢查回傳資料

            if (dt_Return.Rows.Count == 0)
            { throw new Exception("查無資料"); }
            else
            { return dt_Return; }

            #endregion
        }

        /// <summary>
        /// CAA34報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable CAA34_1(ArrayList ParameterList)
        {
            #region 宣告變數

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_ReportService = new ArrayList();
            DataTable dt_Return = new DataTable();

            #endregion

            #region 傳入參數

            arl_ReportService.Clear();
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "date", false));//[結帳日期]起(1)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "date", false));//[結帳日期]迄(2)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[利潤中心](3)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[利潤中心](4)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "string", false));//[科目別]起(5)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//[開立別]迄(6)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[登入人員](7)

            #endregion

            #region 連結資料庫

            BCO.CAA34_BCO bco = new BCO.CAA34_BCO(ConntionDB);
            dt_Return = bco.QueryReport(arl_ReportService);

            #endregion

            #region 檢查回傳資料

            if (dt_Return.Rows.Count == 0)
            { throw new Exception("查無資料"); }
            else
            { return dt_Return; }

            #endregion
        }

    private bool Check_BOND_Monthly()
    {
        bool bResult = false;

        #region 傳入參數

        BCO.CAACommon CAAComm = new BCO.CAACommon();

        ParameterList.Clear();
        ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_ACCEPT_BOND_DATE.Text, "date", false));//20091223改為利用[收票日]來判斷

        #endregion

        #region 連結資料庫

        string str_Result = string.Empty;
        BCO.MaintainBondRecord BCO = new BCO.MaintainBondRecord(ConntionDB);
        str_Result = BCO.CheckBondRecord(ParameterList);

        #endregion

        #region 檢查回傳資料

        if (str_Result == "Y")
        { bResult = true; }

        #endregion

        return bResult;
    }

    private bool Check_StoreDate(string s_Store_Id, DateTime d_Date)
    {
        bool bResult = false;

        #region 傳入參數

        BCO.CAACommon CAAComm = new BCO.CAACommon();

        ParameterList.Clear();
        ParameterList.Add(CAAComm.GetValueSetParameter(s_Store_Id, "string", false));//店號
        ParameterList.Add(CAAComm.GetValueSetParameter(d_Date.ToString(), "datetime", false));//時間
        ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//登入人員

        #endregion

        #region 連結資料庫

        DataTable dt_Return = new DataTable();
        BCO.MaintainBondRecord bco = new BCO.MaintainBondRecord(ConntionDB);
        dt_Return = bco.GET_STORE_RELATE_DATA(ParameterList);

        #endregion

        #region 檢查回傳資料

        if (dt_Return.Rows.Count == 1)
        { bResult = true; }

        #endregion

        return bResult;
    }

    /// <summary>
    /// BUTTON [查詢]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_Query_Click(object sender, EventArgs e)
    {
        try
        {
            #region 設定變數

            DataTable dt_Return_UP = new DataTable();

            #endregion

            #region 檢查條件

            BCO_CAA.CAACommon CAAComm = new BCO_CAA.CAACommon();
            ArrayList arl_Check_Condition = Check_Condition("BUTTON [查詢]鈕");

            #region 如果檢查有誤，則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CGD261", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 取得欄位[條碼][二段條碼][品名][品號][期別]

            #region 傳入參數

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_FULL_BARCODE.Text, "string", false));//[商品條碼]

            #endregion

            #region 連接資料庫

            BCO_IVM.MaintainDataTrans bco_IVM = new BCO_IVM.MaintainDataTrans(ConntionDB);
            dt_Return_UP = bco_IVM.GetItemByBarCode(ParameterList);

            #endregion

            #region 檢查回傳資料

            if (dt_Return_UP.Rows.Count == 0)
            {
                this.ErrorMsgLabel.Text = "查無資料";

                dt_Result = null;

                this.Repeater1.DataSource = dt_Result;
                this.Repeater1.DataBind();

                this.txt_BARCODE.Text = string.Empty;//條碼
                this.txt_PERIOD_BARCODE.Text = string.Empty;//二段條碼
                this.txt_ITEM_NAME.Text = string.Empty;//品名
                this.txt_ITEM.Text = string.Empty;//品號
                this.txt_PERIOD.Text = string.Empty;//期別           

                return;
            }

            #endregion

            #region 將資料寫入欄位

            this.txt_BARCODE.Text = dt_Return_UP.Rows[0]["BARCODE"].ToString();
            this.txt_PERIOD_BARCODE.Text = dt_Return_UP.Rows[0]["PERIOD_BARCODE"].ToString();
            this.txt_ITEM_NAME.Text = dt_Return_UP.Rows[0]["ITEM_NAME"].ToString();
            this.txt_ITEM.Text = dt_Return_UP.Rows[0]["ITEM"].ToString();
            this.txt_PERIOD.Text = dt_Return_UP.Rows[0]["PERIOD"].ToString();

            #endregion

            #endregion

            #region 傳入參數

            ParameterList.Clear();
//.........这里部分代码省略.........

    /// <summary>
    /// 按下BUTTON[儲存]鈕，將更改資料寫入TempTable
    /// </summary>
    /// <param name="dr_Detl"></param>
    /// <param name="dt_Update_Inv"></param>
    /// <param name="s_Now"></param>
    private void Set_NewItem_To_Temp_For_INV_MAIN(DataRow dr_Detl, DataTable dt_Update_Inv, string s_Now)
    {
        BCO.CAACommon CAAComm = new BCO.CAACommon();
        DataRow dr_Update_Inv = dt_Update_Inv.NewRow();

        //New Data
        dr_Update_Inv["NEW_UPDATEDATE"] = CAAComm.GetValueSetParameter(s_Now, "datetime", false);//更新日期
        dr_Update_Inv["NEW_UPDATEUID"] = CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false);//更新人員
        dr_Update_Inv["NEW_NON_INV_UAMT"] = dr_Detl["NON_INV_UAMT"];//畫面上發票餘額(未稅)
        dr_Update_Inv["NEW_NON_INV_TAX"] = dr_Detl["NON_INV_TAX"];//畫面上發票稅額

        //Old Data
        dr_Update_Inv["ID"] = dr_Detl["ID"];
        dr_Update_Inv["CODE"] = dr_Detl["CODE"];
        dr_Update_Inv["CLOSE_MONTH"] = dr_Detl["CLOSE_MONTH"];
        dr_Update_Inv["INV_DATE"] = dr_Detl["INV_DATE"];
        dr_Update_Inv["INV_NO"] = dr_Detl["INV_NO"];
        dr_Update_Inv["IS_SCHEDULE"] = dr_Detl["IS_SCHEDULE"];
        dr_Update_Inv["INV_CHKNO"] = dr_Detl["INV_CHKNO"];
        dr_Update_Inv["INVOICE_DATE_RANGE"] = dr_Detl["INVOICE_DATE_RANGE"];
        dr_Update_Inv["FORM_NO"] = dr_Detl["FORM_NO"];
        dr_Update_Inv["SOURCE_TYPE"] = dr_Detl["SOURCE_TYPE"];
        dr_Update_Inv["INV_KIND"] = dr_Detl["INV_KIND"];
        dr_Update_Inv["TAX_TYPE"] = dr_Detl["TAX_TYPE"];
        dr_Update_Inv["ITEM_NAME"] = dr_Detl["ITEM_NAME"];
        dr_Update_Inv["INV_UAMT"] = dr_Detl["INV_UAMT"];
        dr_Update_Inv["INV_TAX"] = dr_Detl["INV_TAX"];
        dr_Update_Inv["INV_AMT"] = dr_Detl["INV_AMT"];
        dr_Update_Inv["MEMO"] = dr_Detl["MEMO"];
        dr_Update_Inv["CANCEL_FLG"] = dr_Detl["CANCEL_FLG"];
        dr_Update_Inv["PRINT_FLG"] = dr_Detl["PRINT_FLG"];
        dr_Update_Inv["JUMP_FLG"] = dr_Detl["JUMP_FLG"];
        dr_Update_Inv["CANCEL_DATE"] = dr_Detl["CANCEL_DATE"];
        dr_Update_Inv["OLD_INV_NO"] = dr_Detl["OLD_INV_NO"];
        dr_Update_Inv["STORE_ID"] = dr_Detl["STORE_ID"];
        dr_Update_Inv["ROOT_NO"] = dr_Detl["ROOT_NO"];
        dr_Update_Inv["KEYIN_DATE"] = dr_Detl["KEYIN_DATE"];
        dr_Update_Inv["CHG_INV_TYPE"] = dr_Detl["CHG_INV_TYPE"];
        dr_Update_Inv["CREATEDATE"] = dr_Detl["CREATEDATE"];
        dr_Update_Inv["CREATEUID"] = dr_Detl["CREATEUID"];
        dr_Update_Inv["UPDATEDATE"] = dr_Detl["UPDATEDATE"];
        dr_Update_Inv["UPDATEUID"] = dr_Detl["UPDATEUID"];
        dr_Update_Inv["ENABLE"] = dr_Detl["ENABLE"];
        dr_Update_Inv["INV_FORM"] = dr_Detl["INV_FORM"];
        dr_Update_Inv["NON_INV_UAMT"] = dr_Detl["ORIGINAL_NON_INV_UAMT"]; //原始發票餘額(未稅)
        dr_Update_Inv["NON_INV_TAX"] = dr_Detl["ORIGINAL_NON_INV_TAX"]; //原始發票稅額
        dr_Update_Inv["INV_VERSION"] = dr_Detl["INV_VERSION"];
        dr_Update_Inv["INV_REMAIN_AMT"] = dr_Detl["INV_REMAIN_AMT"];
        dr_Update_Inv["DUE_DATE"] = dr_Detl["DUE_DATE"];
        dr_Update_Inv["INDEED_DATE"] = dr_Detl["INDEED_DATE"];
        dr_Update_Inv["WASH_STATUS"] = dr_Detl["WASH_STATUS"];
        dr_Update_Inv["VOUCH_DOC"] = dr_Detl["VOUCH_DOC"];
        dr_Update_Inv["VOUCH_RFNO"] = dr_Detl["VOUCH_RFNO"];

        dt_Update_Inv.Rows.Add(dr_Update_Inv);
    }

    /// <summary>
    /// 取得頁面上的資料
    /// </summary>
    /// <param name="s_DISC_NO">折讓單號</param>
    private void Get_PageDataMainAndDetl(string s_DISC_NO)
    {
        #region 傳入參數

        BCO.CAACommon CAAComm = new BCO.CAACommon();

        ParameterList.Clear();
        ParameterList.Add(CAAComm.GetValueSetParameter(s_DISC_NO, "string", false));//[折讓單號]
        ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UPDATEUID

        #endregion

        #region 連結資料庫

        BCO.MaintainDiscRecord bco = new BCO.MaintainDiscRecord(ConntionDB);
        DataSet ds_Return = bco.QueryDataByView(ParameterList);

        #endregion

        #region 將資料寫入相關欄位 MAIN

        string s_RequestString = Request.QueryString["CAA182_Type"];

        if (ds_Return.Tables["MAIN"].Rows.Count != 1 && s_RequestString != "ToolBar")
        { throw new Exception("查無折讓單號：" + s_DISC_NO + "的相關資料"); }
        else if (ds_Return.Tables["MAIN"].Rows.Count != 1 && s_RequestString == "ToolBar")
        { throw new Exception("查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); }

        DataRow dr_Return_Main = ds_Return.Tables["MAIN"].Rows[0];

        this.txt_DISC_NO.Text = dr_Return_Main["DISC_NO"].ToString();//折讓單號
        this.slp_DISC_FORM.Text = dr_Return_Main["DISC_FORM"].ToString();//格式代號
        this.slp_DISC_SOURCE.Text = dr_Return_Main["DISC_SOURCE"].ToString();//來源
        this.slp_GROUP_NO.Text = dr_Return_Main["GROUP_NO"].ToString();//店群
        this.slp_STORE_ID.Text = dr_Return_Main["STORE_ID"].ToString();//店號
        this.slp_Z_O.Text = dr_Return_Main["Z_O"].ToString();//營業所
        this.slp_DISC_TYPE.Text = dr_Return_Main["DISC_TYPE"].ToString();//型式
        this.slp_ROOT_NO.Text = dr_Return_Main["ROOT_NO"].ToString();//商品群分類
        this.slp_TAX_TYPE.Text = dr_Return_Main["TAX_TYPE"].ToString();//稅別
        this.slp_SAL_ID.Text = dr_Return_Main["SAL_ID"].ToString();//營業人員
        this.slp_AC_UID.Text = dr_Return_Main["AC_UID"].ToString();//帳務人員
        this.slp_DISC_DATE.Text = dr_Return_Main["DISC_DATE"].ToString();//折讓日期
        this.txt_ACT_DISC_NO.Text = dr_Return_Main["ACT_DISC_NO"].ToString();//財會折讓單號
        this.slp_CHG_DISC_DATE.Text = dr_Return_Main["CHG_DISC_DATE"].ToString();//異動折讓日期
        if (dr_Return_Main["PROOF_FLG"].ToString() != "0" && dr_Return_Main["PROOF_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[PROOF_FLG]資料錯誤"); }
        else
        { this.chb_PROOF_FLG.Checked = dr_Return_Main["PROOF_FLG"].ToString() == "0" ? false : true; }//憑證已回
        this.slp_PROOF_DATE.Text = dr_Return_Main["PROOF_DATE"].ToString();//憑證已回日期
        if (dr_Return_Main["REPROOF_FLG"].ToString() != "0" && dr_Return_Main["REPROOF_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[REPROOF_FLG]資料錯誤"); }
        else
        { this.chb_REPROOF_FLG.Checked = dr_Return_Main["REPROOF_FLG"].ToString() == "0" ? false : true; }//取具進項憑証
        this.txt_REPROOF_NO.Text = dr_Return_Main["REPROOF_NO"].ToString();//發票號碼/收據

        if (dr_Return_Main["RECEIPT_FLG"].ToString() != "0" && dr_Return_Main["RECEIPT_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[RECEIPT_FLG]資料錯誤"); }
        else
        { this.chb_RECEIPT_FLG.Checked = dr_Return_Main["RECEIPT_FLG"].ToString() == "0" ? false : true; }//憑證收據
        if (dr_Return_Main["CANCEL_FLG"].ToString() != "0" && dr_Return_Main["CANCEL_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[CANCEL_FLG]資料錯誤"); }
        else
        { this.chb_CANCEL_FLG.Checked = dr_Return_Main["CANCEL_FLG"].ToString() == "0" ? false : true; }//作廢
        this.slp_CANCEL_DATE.Text = dr_Return_Main["CANCEL_DATE"].ToString();//作廢日期
        if (dr_Return_Main["PERIOD_FLG"].ToString() != "0" && dr_Return_Main["PERIOD_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[PERIOD_FLG]資料錯誤"); }
        else
        { this.chb_PERIOD_FLG.Checked = dr_Return_Main["PERIOD_FLG"].ToString() == "0" ? false : true; }//申報
        this.slp_PERIOD_DATE.Text = dr_Return_Main["PERIOD_DATE"].ToString();//申報日期
        if (dr_Return_Main["TEMPORAL_FLG"].ToString() != "0" && dr_Return_Main["TEMPORAL_FLG"].ToString() != "1")
        { throw new Exception("折讓單號：" + dr_Return_Main["DISC_NO"].ToString() + "，資料庫欄位[TEMPORAL_FLG]資料錯誤"); }
        else
        { this.chb_TEMPORAL_FLG.Checked = dr_Return_Main["TEMPORAL_FLG"].ToString() == "0" ? false : true; }//轉暫收
        this.slp_TEMPORAL_DATE.Text = dr_Return_Main["TEMPORAL_DATE"].ToString();//暫收日期
        this.txt_PAY_RFNO.Text = dr_Return_Main["PAY_RFNO"].ToString();//結帳統編
        this.txt_RFNO.Text = dr_Return_Main["RFNO"].ToString();//統一編號
        this.txt_TITLE.Text = dr_Return_Main["TITLE"].ToString();//發票抬頭
        this.txt_INV_ADDR.Text = dr_Return_Main["INV_ADDR"].ToString();//地址
        this.slp_DISC_UAMT.Text = dr_Return_Main["DISC_UAMT"].ToString();//折讓金額(未稅)
        this.slp_DISC_TAX.Text = dr_Return_Main["DISC_TAX"].ToString();//折讓稅額
        this.slp_DISC_AMT.Text = dr_Return_Main["DISC_AMT"].ToString();//總金額
        this.slp_CLOSE_MONTH.Text = dr_Return_Main["CLOSE_MONTH"].ToString();//結帳年月
        this.txt_MEMO.Text = dr_Return_Main["MEMO"].ToString();//備註
        this.slp_CLOSE_MONTH_ACCT.Text = dr_Return_Main["CLOSE_MONTH_ACCT"].ToString();//結帳年月-財會
        this.hid_Record_Date.Value = dr_Return_Main["CREATEDATE"].ToString();//建立時間

        //20110512 rika insert
        this.slp_PERIOD_MONTH.Text = dr_Return_Main["PERIOD_MONTH"].ToString();//申報期別
        this.slp_DISC_REMAIN_AMT.Text = dr_Return_Main["DISC_REMAIN_AMT"].ToString();//折讓餘額
        this.slp_DISC_WASH_AMT.Text = (Convert.ToInt32(dr_Return_Main["DISC_AMT"])-Convert.ToInt32(dr_Return_Main["DISC_REMAIN_AMT"])).ToString();//累積沖帳金額

        #endregion

        #region 編輯狀態，紀錄CheckBox的勾選狀態

        if (this.hid_PageStatus.Value == "edit")
//.........这里部分代码省略.........

    /// <summary>
    /// 離開[店號]時，帶出相關資料
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    private void txt_STORE_ID_Onblur()
    {
        try
        {
            #region 新增模式

            BCO.CAACommon CAAComm = new BCO.CAACommon();

            if (this.hid_PageStatus.Value == "insert")
            {
                #region 檢查傳入欄位[店號]的值

                if (this.slp_STORE_ID.Text.Trim() == string.Empty)
                {
                    Set_STORE_ID_Default();

                    #region Focus欄位

                    DropDownList drop_DISC_TYPE = (DropDownList)this.slp_DISC_TYPE.FindControl("D1");
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(drop_DISC_TYPE.ClientID, false);
                    ScriptManager.RegisterStartupScript(this.up_Condition, typeof(UpdatePanel), "CAA182", s_ScriptManager_Script, true);

                    #endregion

                    return;
                }

                #endregion

                #region 傳入參數

                //新增狀態下，必須使用sysdate，去查店號資料
                //資料必須是當時有效的店號
                ParameterList.Clear();
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID.Text, "string", false));//[店號]
                ParameterList.Add(CAAComm.GetValueSetParameter(DateTime.Now.ToString(), "datetime", false));//時間
                ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UPDATEUID

                #endregion

                #region 連結資料庫

                BCO.MaintainDiscRecord bco = new BCO.MaintainDiscRecord(ConntionDB);
                IDataReader dr = bco.QUERY_CAA18_DATA_BY_STORE_ID(ParameterList);

                #endregion

                #region 將資料寫入相關欄位

                //重新將店號再寫入一次
                this.slp_STORE_ID.Text = this.slp_STORE_ID.Text;

                if (dr.Read())
                {
                    this.slp_GROUP_NO.Text = dr.IsDBNull(0) ? string.Empty : dr.GetString(0);//店群
                    this.slp_Z_O.Text = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);//營業所
                    this.slp_SAL_ID.Text = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);//營業人員
                    this.slp_AC_UID.Text = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);//帳務人員
                    this.txt_PAY_RFNO.Text = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);//結帳統編
                    this.txt_RFNO.Text = dr.IsDBNull(5) ? string.Empty : dr.GetString(5);//統一編號
                    this.txt_INV_ADDR.Text = dr.IsDBNull(6) ? string.Empty : dr.GetString(6);//地址
                    this.txt_TITLE.Text = dr.IsDBNull(7) ? string.Empty : dr.GetString(7);//發票抬頭

                    //Rika 20110413 修改 若統編開頭為A 則預設為2聯式折讓
                    if (this.txt_RFNO.Text.Substring(0, 1) == "A")
                    {
                        DropDownList drop_DISC_FORM = (DropDownList)this.slp_DISC_FORM.FindControl("D1");
                        drop_DISC_FORM.SelectedValue = "34";
                    }
                    else
                    {
                        DropDownList drop_DISC_FORM = (DropDownList)this.slp_DISC_FORM.FindControl("D1");
                        drop_DISC_FORM.SelectedValue = "33";
                    }

                    #region Focus欄位

                    DropDownList drop_DISC_TYPE = (DropDownList)this.slp_DISC_TYPE.FindControl("D1");
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(drop_DISC_TYPE.ClientID, false);
                    ScriptManager.RegisterStartupScript(this.up_Condition, typeof(UpdatePanel), "CAA182", s_ScriptManager_Script, true);

                    #endregion
                }

                #endregion

                #region 檢查回傳資料

                else
                {
                    Set_STORE_ID_Default();

                    #region 若發生錯誤則alert訊息(秀玲要alert訊息)

                    string s_ScriptManager_Script = "alert('無符合店號或己關店，請重新輸入')";
//.........这里部分代码省略.........

        /// <summary>
        /// CAA02報表
        /// </summary>
        /// <param name="ParameterList">變數清單</param>
        /// <returns>回傳查詢結果</returns>
        public DataTable CAA06_1(ArrayList ParameterList)
        {
            #region 宣告變數

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_ReportService = new ArrayList();
            DataTable dt_Return = new DataTable();

            #endregion

            #region 傳入參數

            arl_ReportService.Clear();
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[報表](0)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "date", false));//[兌換日期]起(1)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "date", false));//[兌換日期]迄(2)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "date", false));//[到期日]起(3)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[到期日]迄(4)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//[結帳統編](5)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[統一編號](6)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[營業所]起(3)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[營業所]迄(8)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//[帳務人員](9)
            arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//[登入人員](10)

            #endregion

            #region 連結資料庫

            BCO.MaintainBondMain bco = new BCO.MaintainBondMain(ConntionDB);
            dt_Return = bco.DUEYETORNOTYET(arl_ReportService);

            #endregion

            #region 檢查回傳資料

            if (dt_Return.Rows.Count == 0)
            { throw new Exception("查無資料"); }
            else
            { return dt_Return; }

            #endregion
        }

    protected void btn_Query_Click(object sender, EventArgs e)
    {
        try
        {
            #region 參數

            CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_WASH_NO.Text, "string", this.CheckBoxLikeSearch.Checked)); //V_WASH_NO
            ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_DUE_NO.Text, "string", this.CheckBoxLikeSearch.Checked)); //V_CUBE_NO
            ParameterList.Add(GetValueSetOP(this.slp_WASH_AMT.Operator)); //V_WASH_AMT_OP
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_WASH_AMT.Text, "int", false)); //N_WASH_AMT
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_WASH_DATE.StartDate, "string", false)); //V_WASH_DATE_S
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_WASH_DATE.EndDate, "string", false)); //V_WASH_DATE_E            
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CREATEUID.Text, "string", this.CheckBoxLikeSearch.Checked)); //V_CREATEUID           
            ParameterList.Add(CAAComm.GetValueSetParameter(this.TextBoxRowCountLimit.Text, "int", false)); //N_ROWNUM
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_LOG_UID

            #endregion

            DataTable dt = new DataTable();

            CAAModel.MaintainAccountRecord BCO = new CAAModel.MaintainAccountRecord(ConntionDB);
            dt = BCO.QueryAccountSetByLike(ParameterList);

            //抓取本頁初次登記的時間
            string SessionIDName = "CAA081_" + PageTimeStamp.Value;

            Session["SessionID"] = SessionIDName;
            Session[SessionIDName] = dt;
            gv_WASH.DataSource = dt;
            gv_WASH.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
            gv_WASH.PageIndex = 0;
            gv_WASH.DataBind();

            #region 將Key值存到Session中

            ArrayList arl_Key = new ArrayList();
            ArrayList arl_Key_C = new ArrayList();
            foreach (DataRow drRow in dt.Rows)
            {
                arl_Key.Add(drRow["WASH_NO"].ToString());
                arl_Key_C.Add(drRow["CUBE_NO"].ToString());
            }

            Session["CAA082_SortKey" + this.PageTimeStamp.Value] = arl_Key;
            Session["CAA082_SortKey_C" + this.PageTimeStamp.Value] = arl_Key_C;

            #endregion

            if (dt.Rows.Count == 0)
            { this.ErrorMsgLabel.Text = "查無資料"; }
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
    }

        /// <summary>
        /// CAA10
        /// </summary>
        /// <param name="ParameterList"></param>
        /// <param name="s_Type"></param>
        /// <returns></returns>
        public DataTable CAA10_1(ArrayList ParameterList, string s_Type)
        {
            #region 宣告變數

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_ReportService = new ArrayList();
            DataTable dt_Return = new DataTable();

            #endregion

            #region 取得資料

            switch (s_Type)
            {
                #region 頁籤=通路繳款-專案代收

                case "CAA10_1":

                    #region 傳入參數

                    arl_ReportService.Clear();
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[22].ToString(), "int", false));//[筆數]
                    arl_ReportService.Add(CAAComm.GetValueSetParameter((ParameterList[23].ToString() == "true") ? "1" : "0", "string", false));//[關鍵字查詢]，1=勾選關鍵字查詢，0=沒勾選關鍵字查詢
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//營業日期起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//營業日期迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//交易日期起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//交易日期迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "string", false));//交易序號起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//交易序號迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//交易金額Operator
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "int", false));//交易金額
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//客戶編號起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//客戶編號迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//繳款識別碼起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[11].ToString(), "string", false));//繳款識別碼迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[12].ToString(), "string", false));//店群起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[13].ToString(), "string", false));//店群迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[14].ToString(), "string", false));//收款單號起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[15].ToString(), "string", false));//收款單號迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[16].ToString(), "string", false));//建立日期起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[17].ToString(), "string", false));//建立日期迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[18].ToString(), "string", false));//建立人員
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[19].ToString(), "string", false));//維護日期起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[20].ToString(), "string", false));//維護日期迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[21].ToString(), "string", false));//維護人員
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[24].ToString(), "string", false));//交易金額Operator
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[25].ToString(), "int", false));//交易金額
                    #endregion

                    #region 連結資料庫

                    BCO.MaintainCollRecord bco_1 = new BCO.MaintainCollRecord(ConntionDB);
                    dt_Return = bco_1.QueryCollRecordByByLike(arl_ReportService);

                    #endregion

                    break;

                #endregion

                #region 頁籤=專案代收明細表

                case "CAA10_2":

                    #region 傳入參數

                    arl_ReportService.Clear();
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[營業日期]起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//[營業日期]迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[交易日期]起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[交易日期]迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[收款單號日期]起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "date", false));//[收款單號日期]迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[繳款型態]
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[帳務人員]起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[帳務人員]迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//利潤中心起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//利潤中心迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[11].ToString(), "string", false));//店號
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[12].ToString(), "string", false));//營業所起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[13].ToString(), "string", false));//營業所迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[14].ToString(), "string", false));//營業人員起
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[15].ToString(), "string", false));//營業人員迄
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[16].ToString(), "string", false));//沖帳餘額OP
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[17].ToString(), "string", false));//沖帳餘額
                    arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[18].ToString(), "string", false));//結案狀態
                    #endregion

                    #region 連結資料庫

                    BCO.ProcessCollReport bco_2 = new BCO.ProcessCollReport(ConntionDB);
                    dt_Return = bco_2.QueryCollReport(arl_ReportService);

                    #endregion
//.........这里部分代码省略.........

//.........这里部分代码省略.........
                    #endregion

                    #region 匯兌損益

                    if (s_REMIT_DIFF == string.Empty)
                    {
                        strErrMsg += "匯兌損益欄位為必填,";
                        s_REMIT_DIFF = "0";
                    }
                    else if (CheckLength(s_REMIT_DIFF, 8, "匯兌損益", strErrMsg, iErrCount, out  strErrMsg, out  iErrCount) == false)
                    {
                        //超過DB欄位
                        s_REMIT_DIFF = SubStr(s_REMIT_DIFF, 0, 12);
                    }
                    else if (double.TryParse(s_REMIT_DIFF, out doubleVal) == false)
                    {
                        strErrMsg += "匯兌損益必須為數值型態,";
                        s_REMIT_DIFF = "0";
                    }

                    #endregion

                    #endregion

                    #region 20100722秀玲新增規則

                    if (V_SOURCE_TYPE == "4")
                    {
                        int i_Check_Flg = 0;

                        CAACommon CAAComm = new CAACommon();

                        ParameterList.Clear();
                        ParameterList.Add(CAAComm.GetValueSetParameter(V_SECOND_NO, "string", false));//[折讓單號]
                        ParameterList.Add(CAAComm.GetValueSetParameter(s_LoginUser, "string", false));//[登入人員]

                        i_Check_Flg = DBO.CHECK_DISC_MAIN_FLG(ParameterList);

                        if (i_Check_Flg != 1)
                        { strErrMsg += "此筆尚未憑證已回，故不允許匯入,"; }
                    }

                    #endregion


                    if ((int.Parse(V_WASH_CHAGE) + int.Parse(V_WASH_AMT) + int.Parse(s_DIFF_AMT) + int.Parse(s_OTHER_DIFF) + int.Parse(s_REMIT_DIFF)) != int.Parse(V_WASH_AMT_TO))
                    {
                        strErrMsg += "繳款金額+手續費/郵資+尾差+其他差異+匯兌損益與沖帳總額不合,";
                    }

                    if (strErrMsg == "")
                    {
                        int iCheckREMAIN_AMT = CheckREMAIN_AMT(V_SECOND_NO, V_SOURCE_TYPE, V_WASH_AMT_TO);
                        if (iCheckREMAIN_AMT == 0)
                            strErrMsg += "找不到符合的單據資料,";
                        else if (iCheckREMAIN_AMT == 1)
                            strErrMsg += "沖帳總額不足,";

                        #region 20110217 RIKA 新增規則

                        if (V_SOURCE_TYPE == "3" || V_SOURCE_TYPE == "4" || V_SOURCE_TYPE == "5")
                        {
                            if (int.Parse(V_WASH_CHAGE) != 0 || int.Parse(s_DIFF_AMT) != 0 || int.Parse(s_OTHER_DIFF) != 0 || int.Parse(s_REMIT_DIFF) != 0)
                                strErrMsg += "手續費/郵資/尾差/差異/匯兌損益沖帳餘額不足,";
                        }
                        else

    /// <summary>
    /// 頁籤=月結 BUTTON [人工折讓月結解除]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_TAB4_Open_Click(object sender, EventArgs e)
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();
            ArrayList arl_Check_Condition = Check_Condition("TAB 月結");

            #region 如果檢查有誤，則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA181", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            string s_Now = DateTime.Now.ToString();

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter("CAA18", "string", false));//月結功能代碼
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_4_CLOSE_MONTH.Text, "string", false));//月結年月
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//更新人員
            ParameterList.Add(CAAComm.GetValueSetParameter(s_Now, "datetime", false));//更新日期

            #endregion

            #region 連結資料庫

            BCO.RecordingCloseLockInfo bco = new BCO.RecordingCloseLockInfo(ConntionDB);
            ArrayList ary_Result = bco.RecordingByOpen(ParameterList, null, ConntionDB);

            #endregion

            #region 檢查回傳資料

            this.ErrorMsgLabel.Text = ary_Result[1].ToString();

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
        finally { Finally_Function(); }
    }

    /// <summary>
    /// BUTTON [查詢]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_Query_Click(object sender, EventArgs e)
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();

            string s_Type = string.Empty;
            if (this.TabContainer1.ActiveTabIndex == 0)
            { s_Type = "BUTTON [查詢]鈕 TAB 銷貨折讓維護"; }
            else if (this.TabContainer1.ActiveTabIndex == 1)
            { s_Type = "BUTTON [查詢]鈕 TAB 發票折抵明細查詢"; }
            else
            { throw new Exception("頁面資訊錯誤，[查詢]鈕，只有在頁籤為[銷貨折讓維護][發票折抵明細查詢]時才可以使用"); }

            ArrayList arl_Check_Condition = Check_Condition(s_Type);

            #region 如果檢查有誤，則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA181", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            #region TabContainer 銷貨折讓維護

            if (this.TabContainer1.ActiveTabIndex == 0)
            {
                ParameterList.Clear();
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_DISC_NO.Text, "string", this.chb_LikeSearch.Checked));//[折讓單號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_FORM.Text, "int", false));//[格式代號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_SOURCE.Text, "int", false));//[來源]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_GROUP_NO.Text, "string", this.chb_LikeSearch.Checked));//[店群]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID.Text, "string", this.chb_LikeSearch.Checked));//[店號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_Z_O.Text, "string", false));//[營業所]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_TYPE.Text, "string", false));//[型式]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_ROOT_NO.Text, "string", this.chb_LikeSearch.Checked));//[商品群分類]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TAX_TYPE.Text, "string", false));//[稅別]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_SAL_ID.Text, "string", this.chb_LikeSearch.Checked));//[營業人員]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_AC_UID.Text, "string", this.chb_LikeSearch.Checked));//[帳務人員]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_DATE.StartDate, "date", false));//[折讓日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_DATE.EndDate, "date", false));//[折讓日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_ACT_DISC_NO.Text, "string", this.chb_LikeSearch.Checked));//[財會折讓單號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CHG_DISC_DATE.StartDate, "date", false));//[異動折讓日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CHG_DISC_DATE.EndDate, "date", false));//[異動折讓日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_PROOF_TYPE.Text == "2") ? string.Empty : this.radl_PROOF_TYPE.Text, "int", false));//[憑證已回]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_PROOF_DATE.StartDate, "date", false));//[憑換已回日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_PROOF_DATE.EndDate, "date", false));//[憑換已回日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_REPROOF_TYPE.Text == "2") ? string.Empty : this.radl_REPROOF_TYPE.Text, "int", false));//[取具進項憑証]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_REPROOF_NO.Text, "string", this.chb_LikeSearch.Checked));//[發票號碼/收據]
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_RECEIPT_TYPE.Text == "2") ? string.Empty : this.radl_RECEIPT_TYPE.Text, "int", false));//[取具收據]
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_CANCEL_TYPE.Text == "2") ? string.Empty : this.radl_CANCEL_TYPE.Text, "int", false));//[作廢]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CANCEL_DATE.StartDate, "date", false));//[作廢日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CANCEL_DATE.EndDate, "date", false));//[作廢日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_PERIOD_TYPE.Text == "2") ? string.Empty : this.radl_PERIOD_TYPE.Text, "int", false));//[申報]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_PERIOD_DATE.StartDate, "date", false));//[申報日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_PERIOD_DATE.EndDate, "date", false));//[申報日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter((this.radl_TEMPORAL_TYPE.Text == "2") ? string.Empty : this.radl_TEMPORAL_TYPE.Text, "int", false));//[轉暫收]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TEMPORAL_DATE.StartDate, "date", false));//[暫收日期]起
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TEMPORAL_DATE.EndDate, "date", false));//[暫收日期]迄
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PAY_RFNO.Text, "string", this.chb_LikeSearch.Checked));//[結帳統編]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_RFNO.Text, "string", this.chb_LikeSearch.Checked));//[統一編號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_INV_NO.Text, "string", this.chb_LikeSearch.Checked));//[地址]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_UAMT.Text, "int", false));//[折讓金額(未稅)]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_UAMT.Operator, "int", false));//[折讓金額(未稅)]Operator
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_TAX.Text, "int", false));//[折讓稅額]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_TAX.Operator, "int", false));//[折讓稅額]Operator
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_AMT.Text, "int", false));//[總金額]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_DISC_AMT.Operator, "int", false));//[總金額]Operator
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CLOSE_MONTH_B.Text, "string", false));//[結帳年月]起
                
                //20110505 rika insert
//.........这里部分代码省略.........

    /// <summary>
    /// 頁籤=[報表] 欄位[報表類型]=彙總，按下Button[匯出]鈕
    /// </summary>
    private void but_TAB3_Print_Total()
    {
        try
        {
            #region 檢查條件

            BCO.CAACommon CAAComm = new BCO.CAACommon();

            ArrayList arl_Check_Condition = Check_Condition("TAB 報表");

            #region 如果檢查有誤，則Return

            if (arl_Check_Condition[1].ToString() != string.Empty)
            {
                #region 錯誤訊息

                this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();

                #endregion

                #region Focus欄位

                if (arl_Check_Condition[0].ToString() != string.Empty)
                {
                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
                    ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CAA181", s_ScriptManager_Script, true);
                }

                #endregion

                return;
            }

            #endregion

            #endregion

            #region 傳入參數

            ParameterList.Clear();
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_CLOSE_MONTH_B.Text, "string", false));//[結帳年月]起 20110520修改為起迄
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_CLOSE_MONTH_E.Text, "string", false));//[結帳年月]迄
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_CLOSE_MONTH_ACCT_B.Text, "string", false));//[結帳年月-財會]起 20110520修改為起迄
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_CLOSE_MONTH_ACCT_E.Text, "string", false));//[結帳年月-財會]迄           
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_PROFIT_NO_B.Text, "string", false));//[利潤中心]起
            ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_3_PROFIT_NO_E.Text, "string", false));//[利潤中心]迄
            ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UID

            #endregion

            #region 連接資料庫

            DataSet ds_Return = new DataSet();
            BCO.MaintainDiscRecord bco = new BCO.MaintainDiscRecord(ConntionDB);
            ds_Return = bco.QUERY_CAA18_REPORT_SUMMARY(ParameterList);

            #endregion

            #region 檢查回傳資料

            if (ds_Return.Tables["SUMMARY"].Rows.Count == 0)
            {
                this.ErrorMsgLabel.Text = "查無資料";
                return;
            }

            #endregion

            #region 組合匯出的Excel

            #region 設定變數

            ExcelXmlWorkbook exl_WorkSheet = new ExcelXmlWorkbook();
            Worksheet sheet = exl_WorkSheet[0];
            sheet.Name = "折讓入帳彙總表";

            #region 設定長和寬

            int i_Vertical = 0;//直的有幾個欄位(依據資料庫[利潤中心])
            int i_Horizontal = 0;//橫的有幾個欄位(依據資料庫[型式])

            int i_Vertical_Fix = 3;//直的固定欄位[型式、稅別、合計]
            int i_Horizontal_Fix = 4;//橫的固定欄位[標題抬頭、利潤中心抬頭、合計上方要空一行、合計]

            i_Vertical = ds_Return.Tables["PROFIT"].Rows.Count + i_Vertical_Fix;
            i_Horizontal = (ds_Return.Tables["DISC_TYPE"].Rows.Count * 3) + i_Horizontal_Fix;

            #endregion

            #endregion

            #region 設定格式

            #region 設定欄位寬度

            for (int i_Style = 0; i_Style < i_Vertical; i_Style++)
            { sheet.Columns(i_Style).Width = 100; }
//.........这里部分代码省略.........