C# CAACommon.Check_Format_YearMonth方法代码示例

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    static ArrayList Check_Condition(string s_Type, string[] s_Array_ServerString)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 頁籤=銷貨折讓維護

        if (s_Type == "0")
        {
            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[13], "欄位[折讓日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[14], "欄位[折讓日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[16], "欄位[異動折讓日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[17], "欄位[異動折讓日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[19], "欄位[憑證已回日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[20], "欄位[憑證已回日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[25], "欄位[作廢日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[26], "欄位[作廢日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[28], "欄位[申報日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[29], "欄位[申報日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[31], "欄位[暫收日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[32], "欄位[暫收日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);

            #endregion

            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[36], "欄位[折讓金額(未稅)]數字格式錯誤", "32", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[38], "欄位[折讓稅額]數字格式錯誤", "32", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[40], "欄位[總金額]數字格式錯誤", "32", "1", string.Empty, arl_Return);

            //20110505 rika insert
            arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[48], "欄位[累積沖帳金額]數字格式錯誤", "32", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[50], "欄位[折讓餘額]數字格式錯誤", "32", "1", string.Empty, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[42], "欄位[結帳年月起]年月格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[43], "欄位[結帳年月迄]年月格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[44], "欄位[結帳年月-財會起]年月格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[45], "欄位[結帳年月-財會迄]年月格式錯誤", "1", string.Empty, arl_Return);

            //20110506 rika insert
            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[46], "欄位[申報期別起]年月格式錯誤", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[47], "欄位[申報期別迄]年月格式錯誤", "1", string.Empty, arl_Return);

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 檢查Between欄位

            #region 欄位[折讓日期]

            if (s_Array_ServerString[13] != string.Empty ||
                s_Array_ServerString[14] != string.Empty)
            {
                #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

                arl_Return = CAAComm.Check_Between_BeginEnd_Value
                    (s_Array_ServerString[13],
                     s_Array_ServerString[14],
                     "折讓日期",
                     "1",
                     string.Empty,
                     string.Empty,
                     arl_Return);

                #endregion

                #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

                arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                    (s_Array_ServerString[13],
                     s_Array_ServerString[14],
                     "date",
                     "欄位[折讓日期]結束欄位一定要大於或等於開始欄位",
                     "1",
                     string.Empty,
                     arl_Return);

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

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    private ArrayList Check_Condition()
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region SLP轉型

        TextBox txt_FUNC_NO_B = (TextBox)this.slp_FUNC_NO_B.FindControl("TextBoxCode");//[功能號]起
        TextBox txt_FUNC_NO_E = (TextBox)this.slp_FUNC_NO_E.FindControl("TextBoxCode");//[功能號]迄
        TextBox txt_UPDATEDATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_UPDATEDATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[維護日期]起
        TextBox txt_UPDATEDATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_UPDATEDATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[維護日期]迄
        TextBox txt_MONTH_CLOSE_B = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)this.slp_MONTH_CLOSE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");//[月結月份]起
        TextBox txt_MONTH_CLOSE_E = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)this.slp_MONTH_CLOSE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");//[月結月份]迄


        #endregion

        #region 檢查SLP年月格式

        arl_Return = CAAComm.Check_Format_YearMonth(this.slp_MONTH_CLOSE_B.Text, "欄位[月結月份]開始欄位格式錯誤", "1", txt_MONTH_CLOSE_B.ClientID, arl_Return);
        arl_Return = CAAComm.Check_Format_YearMonth(this.slp_MONTH_CLOSE_E.Text, "欄位[月結月份]結束欄位格式錯誤", "1", txt_MONTH_CLOSE_E.ClientID, arl_Return);

        #endregion

        #region 檢查日期格式

        arl_Return = CAAComm.Check_Format_Date(this.slp_UPDATEDATE.StartDate, "欄位[維護日期]開始欄位日期格式錯誤", "1", txt_UPDATEDATE_B.ClientID, arl_Return);
        arl_Return = CAAComm.Check_Format_Date(this.slp_UPDATEDATE.EndDate, "欄位[維護日期]結束欄位日期格式錯誤", "1", txt_UPDATEDATE_E.ClientID, arl_Return);

        #endregion

        #region 如果基本檢查有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查Between欄位[功能號]

        if (this.slp_FUNC_NO_B.Text != string.Empty ||
            this.slp_FUNC_NO_E.Text != string.Empty)
        {
            #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

            arl_Return = CAAComm.Check_Between_BeginEnd_Value
                (this.slp_FUNC_NO_B.Text,
                this.slp_FUNC_NO_E.Text,
                "功能號",
                "1",
                txt_FUNC_NO_B.ClientID,
                txt_FUNC_NO_E.ClientID,
                arl_Return);

            #endregion

            #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

            arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                (this.slp_FUNC_NO_B.Text,
                this.slp_FUNC_NO_E.Text,
                "string",
                "欄位[功能號]結束欄位一定要大於或等於開始欄位",
                "1",
                txt_FUNC_NO_E.ClientID,
                arl_Return);

            #endregion
        }

        #endregion

        #region 檢查Between欄位[月結月份]

        if (this.slp_MONTH_CLOSE_B.Text != string.Empty ||
            this.slp_MONTH_CLOSE_E.Text != string.Empty)
        {
            #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

            arl_Return = CAAComm.Check_Between_BeginEnd_Value
                (this.slp_MONTH_CLOSE_B.Text,
                this.slp_MONTH_CLOSE_E.Text,
                "月結月份",
                "1",
                txt_MONTH_CLOSE_B.ClientID,
                txt_MONTH_CLOSE_E.ClientID,
                arl_Return);

            #endregion

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

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region SLP轉型

        TextBox txt_CHG_DISC_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_CHG_DISC_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[異動折讓日期]起
        TextBox txt_CHG_DISC_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_CHG_DISC_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[異動折讓日期]迄

        #endregion

        #region BUTTON [查詢]鈕

        if (s_Type == "BUTTON [查詢]鈕")
        {
            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_PERIOD_MONTH_B.Text, "欄位[申報起迄年月]開始欄位年月格式錯誤", "1", this.slp_PERIOD_MONTH_B.TextBoxCode_Object.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_PERIOD_MONTH_E.Text, "欄位[申報起迄年月]結束欄位年月格式錯誤", "1", this.slp_PERIOD_MONTH_E.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(this.slp_CHG_DISC_DATE.StartDate, "欄位[異動折讓日期]開始欄位日期格式錯誤", "1", txt_CHG_DISC_DATE_B.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_CHG_DISC_DATE.EndDate, "欄位[異動折讓日期]結束欄位日期格式錯誤", "1", txt_CHG_DISC_DATE_E.ClientID, arl_Return);

            #endregion

            #region 檢查List欄位的選擇狀態

            if (this.rad_CHECK_FLG.SelectedIndex < 0)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[勾選狀態]請選擇一選項", "1", string.Empty); }

            if (this.rad_PERIOD_FLG.SelectedIndex < 0)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[申報狀態]請選擇一選項", "1", string.Empty); }

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 檢查Between欄位[發票年月]

            if (this.slp_PERIOD_MONTH_B.Text != string.Empty ||
                this.slp_PERIOD_MONTH_E.Text != string.Empty)
            {
                #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

                arl_Return = CAAComm.Check_Between_BeginEnd_Value
                    (this.slp_PERIOD_MONTH_B.Text,
                    this.slp_PERIOD_MONTH_E.Text,
                    "申報起迄年月",
                    "1",
                    this.slp_PERIOD_MONTH_B.TextBoxCode_Object.ClientID,
                    this.slp_PERIOD_MONTH_E.TextBoxCode_Object.ClientID,
                    arl_Return);

                #endregion

                #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

                arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                    (this.slp_PERIOD_MONTH_B.Text,
                    this.slp_PERIOD_MONTH_E.Text,
                    "string",
                    "欄位[申報起迄年月]結束欄位一定要大於或等於開始欄位",
                    "1",
                    this.slp_PERIOD_MONTH_E.TextBoxCode_Object.ClientID,
                    arl_Return);

                #endregion
            }

            #endregion

            #region 欄位[異動折讓日期]

            if (this.slp_CHG_DISC_DATE.StartDate != string.Empty ||
                this.slp_CHG_DISC_DATE.EndDate != string.Empty)
            {
                #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

                arl_Return = CAAComm.Check_Between_BeginEnd_Value
                    (this.slp_CHG_DISC_DATE.StartDate,
//.........这里部分代码省略.........

    /// <summary>
    /// 檢查文字檔條件
    /// </summary>
    /// <param name="s_FileLine"></param>
    /// <returns></returns>
    private ArrayList Check_Condition_FileLine(string s_FileLine, DataTable dt_Temp)
    {
        #region 規則

        /*
         *格式代號 VARCHAR2(2)  [INV_FORM] ：1~2
         *流水號   NUMBER(16)   [SEQ_NO]   ：12~18
         *年月     VARCHAR2(6)  [INV_YM]   ：19~23
         *客戶統編 VARCHAR2(10) [RFNO]     ：24~31
         *銷項發票 VARCHAR2(10) [INV_NO]   ：40~49
         *銷售額   NUMBER(12)   [INV_UAMT] ：50~61
         *課稅別   NUMBER(1)    [TAX_TYPE] ：62
         *稅額     NUMBER(12)   [INV_TAX]  ：63~72
         */

        #endregion

        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        BCO.ImportCOLLPO bco = new BCO.ImportCOLLPO(ConntionDB);
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 檢查字串長度

        //字串每一行都固定有81個字
        if (s_FileLine.Length < 81)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "字串長度不正確；", "1", string.Empty); }

        #endregion

        #region 如果檢查字串長度有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查數字格式

        arl_Return = CAAComm.Check_Format_Int(s_FileLine.Substring(11, 7), "[流水號]數字格式有誤；", "32", "1", string.Empty, arl_Return);//流水號
        arl_Return = CAAComm.Check_Format_Int(s_FileLine.Substring(49, 12), "[銷售額]數字格式有誤；", "64", "1", string.Empty, arl_Return);//銷售額
        arl_Return = CAAComm.Check_Format_Int(s_FileLine.Substring(62, 10), "[稅額]數字格式有誤；", "64", "1", string.Empty, arl_Return);//稅額

        #endregion

        #region 檢查必填欄位

        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(0, 2), "text", "[格式代號]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(11, 7), "text", "[流水號]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(18, 5), "text", "[年月]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(39, 10), "text", "[銷項發票]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(49, 12), "text", "[銷售額]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(61, 1), "text", "[課稅別]為必填欄位；", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_FileLine.Substring(62, 10), "text", "[稅額]為必填欄位；", "1", string.Empty, arl_Return);

        #endregion

        #region 如果檢查數字格式，必填欄位有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查年月格式

        try
        {
            string s_YearMonth = Convert.ToString(int.Parse(s_FileLine.Substring(18, 5)) + 191100);
            arl_Return = CAAComm.Check_Format_YearMonth(s_YearMonth, "[年月]年月格式有誤；", "1", string.Empty, arl_Return);//年月
        }
        catch
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[年月]年月格式有誤；", "1", string.Empty); }

        #endregion

        #region 檢查格式代號

        if (s_FileLine.Substring(0, 2) != "31" &&
            s_FileLine.Substring(0, 2) != "32" &&
            s_FileLine.Substring(0, 2) != "33" &&
            s_FileLine.Substring(0, 2) != "34")
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[格式代號]只有31,32,33,34四種格式；", "1", string.Empty); }

        #endregion

        #region 檢查發票字軌

        System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^[A-Z]+$");
        bool b_Inv_Track = reg1.IsMatch(s_FileLine.Substring(39, 2));
//.........这里部分代码省略.........

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    static ArrayList Check_Condition(string[] s_Array_ServerString)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 檢查必填欄位

        arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[1], "text", "欄位[發票年月]開始欄位為必填欄位", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[2], "text", "欄位[發票年月]結束欄位為必填欄位", "1", string.Empty, arl_Return);

        #endregion

        #region 檢查SLP年月格式

        arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[1], "欄位[發票年月]開始欄位年月格式錯誤", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[2], "欄位[發票年月]結束欄位年月格式錯誤", "1", string.Empty, arl_Return);

        #endregion

        #region 如果基本檢查有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查欄位[發票年月]

        #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

        arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
            (s_Array_ServerString[1],
             s_Array_ServerString[2],
             "string",
             "欄位[發票年月]結束欄位一定要大於或等於開始欄位",
             "1",
             string.Empty,
             arl_Return);

        #endregion

        #endregion

        return arl_Return;
    }

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 頁籤=整批兌現

        #region BUTTON [查詢]鈕

        if (s_Type == "頁籤=整批兌現 BUTTON [查詢]鈕")
        {
            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(this.slp_tab2_EX_DUE_DATE.StartDate, "欄位[票據預計兌現日]開始欄位日期格式錯誤", "1", this.slp_tab2_EX_DUE_DATE.RangeStartTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_tab2_EX_DUE_DATE.EndDate, "欄位[票據預計兌現日]結束欄位日期格式錯誤", "1", this.slp_tab2_EX_DUE_DATE.RangeEndTextBox.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_tab2_EX_DUE_DATE.StartDate, "text", "欄位[票據預計兌現日]開始欄位為必填欄位", "1", this.slp_tab2_EX_DUE_DATE.RangeStartTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_tab2_EX_DUE_DATE.EndDate, "text", "欄位[票據預計兌現日]結束欄位為必填欄位", "1", this.slp_tab2_EX_DUE_DATE.RangeEndTextBox.ClientID, arl_Return);

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 檢查Between欄位

            #region 欄位[票據預計兌現日]

            if (this.slp_tab2_EX_DUE_DATE.StartDate != string.Empty ||
                this.slp_tab2_EX_DUE_DATE.EndDate != string.Empty)
            {
                #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

                arl_Return = CAAComm.Check_Between_BeginEnd_Value
                    (this.slp_tab2_EX_DUE_DATE.StartDate,
                     this.slp_tab2_EX_DUE_DATE.EndDate,
                     "票據預計兌現日",
                     "1",
                     this.slp_tab2_EX_DUE_DATE.RangeStartTextBox.ClientID,
                     this.slp_tab2_EX_DUE_DATE.RangeEndTextBox.ClientID,
                     arl_Return);

                #endregion

                #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

                arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                    (this.slp_tab2_EX_DUE_DATE.StartDate,
                     this.slp_tab2_EX_DUE_DATE.EndDate,
                     "date",
                     "欄位[票據預計兌現日]結束欄位一定要大於或等於開始欄位",
                     "1",
                     this.slp_tab2_EX_DUE_DATE.RangeEndTextBox.ClientID,
                     arl_Return);

                #endregion
            }

            #endregion

            #endregion
        }

        #endregion

        #endregion

        #region 頁籤=月結處理

        else if (s_Type == "頁籤=月結處理")
        {
            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_YearMonth.Text, "欄位[月結年月]年月格式錯誤", "1", this.slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_YearMonth.Text, "text", "欄位[月結年月]為必填欄位", "1", this.slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);

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

    private ArrayList Check_Condition()
    {
        #region 宣告

        CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 檢查必填欄位

        arl_Return = CAAComm.Check_MustFillin_Column(this.slp_YearMonth.Text, "text", "欄位[所屬年月]為必填欄位", "1", this.slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(this.txt_INVOICE_TRACK.Text, "text", "欄位[字軌]為必填欄位", "1", this.txt_INVOICE_TRACK.ClientID, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_STAR_NO.Text, "text", "欄位[起始號碼]為必填欄位", "1", this.SLP_STAR_NO.TextBox_Code.ClientID, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_END_NO.Text, "text", "欄位[迄止號碼]為必填欄位", "1", this.SLP_END_NO.TextBox_Code.ClientID, arl_Return);

        #endregion

        #region 檢查SLP年月格式

        arl_Return = CAAComm.Check_Format_YearMonth(this.slp_YearMonth.Text, "欄位[所屬年月]開始欄位格式錯誤", "1", slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);

        #endregion

        #region 檢查SLP數字格式

        arl_Return = CAAComm.Check_Format_Int(this.SLP_STAR_NO.Text, "欄位[起始號碼]數字格式錯誤", "32", "1", this.SLP_STAR_NO.TextBox_Code.ClientID, arl_Return);
        arl_Return = CAAComm.Check_Format_Int(this.SLP_END_NO.Text, "欄位[迄止號碼]數字格式錯誤", "32", "1", this.SLP_END_NO.TextBox_Code.ClientID, arl_Return);

        #endregion

        #region 如果基本檢查有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查發票字軌格式

        System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z]{2}$");
        bool b_reg1 = reg1.IsMatch(this.txt_INVOICE_TRACK.Text);

        if (b_reg1 == false)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[發票字軌]格式有誤", "1", this.txt_INVOICE_TRACK.ClientID); }

        #endregion

        #region 檢查欄位[起始號碼]必須為8碼數目字

        System.Text.RegularExpressions.Regex reg2 = new System.Text.RegularExpressions.Regex(@"^[0-9]{8}$");
        bool b_reg2 = reg2.IsMatch(this.SLP_STAR_NO.Text);

        if (b_reg2 == false)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[起始號碼]必須為8碼數目字", "1", this.SLP_STAR_NO.TextBox_Code.ClientID); }

        #endregion

        #region 檢查欄位[迄止號碼]必須為8碼數目字

        System.Text.RegularExpressions.Regex reg3 = new System.Text.RegularExpressions.Regex(@"^[0-9]{8}$");
        bool b_reg3 = reg3.IsMatch(this.SLP_END_NO.Text);

        if (b_reg3 == false)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[迄止號碼]必須為8碼數目字", "1", this.SLP_END_NO.TextBox_Code.ClientID); }

        #endregion

        #region 檢查欄位[迄止號碼]一定要大於於欄位[起始號碼]

        if (int.Parse(this.SLP_STAR_NO.Text.Trim()) >= int.Parse(this.SLP_END_NO.Text.Trim()))
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[迄止號碼]一定要大於於欄位[起始號碼]", "1", this.SLP_END_NO.TextBox_Code.ClientID); }

        #endregion

        return arl_Return;
    }

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region SLP轉型

        TextBox txt_WASH_AMT = (TextBox)this.slp_WASH_AMT.FindControl("TextBoxCode");//累積沖帳金額
        TextBox txt_INV_REMAIN_AMT = (TextBox)this.slp_INV_REMAIN_AMT.FindControl("TextBoxCode");//應收餘額

        #endregion


        #region BUTTON [查詢]鈕

        if (s_Type == "BUTTON [查詢]鈕")
        {
            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_DATE.StartDate, "欄位[開立日期]開始欄位日期格式錯誤", "1", this.slp_INV_DATE.RangeStartTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_DATE.EndDate, "欄位[開立日期]結束欄位日期格式錯誤", "1", this.slp_INV_DATE.RangeEndTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_DUE_DATE.StartDate, "欄位[帳款到期日]開始欄位日期格式錯誤", "1", this.slp_INV_DUE_DATE.RangeStartTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_DUE_DATE.EndDate, "欄位[帳款到期日]結束欄位日期格式錯誤", "1", this.slp_INV_DUE_DATE.RangeEndTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_CANCEL_DATE.StartDate, "欄位[作廢日期]開始欄位日期格式錯誤", "1", this.slp_INV_CANCEL_DATE.RangeStartTextBox.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_INV_CANCEL_DATE.EndDate, "欄位[作廢日期]結束欄位日期格式錯誤", "1", this.slp_INV_CANCEL_DATE.RangeEndTextBox.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH_B.Text, "欄位[結帳年月]開始欄位年月格式錯誤", "1", this.slp_CLOSE_MONTH_B.TextBoxCode_Object.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH_E.Text, "欄位[結帳年月]結束欄位年月格式錯誤", "1", this.slp_CLOSE_MONTH_E.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.slp_WASH_AMT.Text, "欄位[累積沖帳金額]數字格式錯誤", "32", "1", txt_WASH_AMT.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(this.slp_INV_REMAIN_AMT.Text, "欄位[應收餘額]數字格式錯誤", "32", "1", txt_INV_REMAIN_AMT.ClientID, arl_Return);

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 檢查Between欄位

            #region 欄位[店群]

            if (this.slp_GROUP_NO_B.Text != string.Empty ||
                this.slp_GROUP_NO_E.Text != string.Empty)
            {
                #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

                arl_Return = CAAComm.Check_Between_BeginEnd_Value
                    (this.slp_GROUP_NO_B.Text,
                     this.slp_GROUP_NO_E.Text,
                     "店群",
                     "1",
                     this.slp_GROUP_NO_B.TextBox_Code.ClientID,
                     this.slp_GROUP_NO_E.TextBox_Code.ClientID,
                     arl_Return);

                #endregion

                #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

                arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                    (this.slp_GROUP_NO_B.Text,
                     this.slp_GROUP_NO_E.Text,
                     "string",
                     "欄位[店群]結束欄位一定要大於或等於開始欄位",
                     "1",
                     this.slp_GROUP_NO_E.TextBox_Code.ClientID,
                     arl_Return);

                #endregion
            }

            #endregion

            #region 欄位[利潤中心]

            if (this.slp_PROFIT_NO_B.Text != string.Empty ||
                this.slp_PROFIT_NO_E.Text != string.Empty)
//.........这里部分代码省略.........

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region BUTTON [確定匯入]

        if (s_Type == "BUTTON [確定匯入]")
        {
            #region 自訂檢查

            TextBox txt_UP11 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP11");//處理總筆數
            TextBox txt_UP12 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP12");//成功筆數
            TextBox txt_UP13 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP13");//異常筆數

            int i_Total_Count = int.Parse(txt_UP11.Text);
            int i_Success_Count = int.Parse(txt_UP12.Text);
            int i_Failure_Count = int.Parse(txt_UP13.Text);

            //20110211 Rika 因應沖正資料問題修改
            if (i_Failure_Count >0 ) 
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "上傳檔案有誤，不可匯入", "1", string.Empty); }

            #endregion
        }

        #endregion

        #region BUTTON [解除月結]

        else if (s_Type == "BUTTON [月結]" ||
                 s_Type == "BUTTON [解除月結]")
        {
            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_YearMonth.Text, "欄位[月結月份]年月格式錯誤", "1", this.slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_YearMonth.Text, "text", "欄位[月結月份]為必填欄位", "1", this.slp_YearMonth.TextBoxCode_Object.ClientID, arl_Return);

            #endregion
        }

        #endregion

        return arl_Return;
    }

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    private ArrayList Check_Condition()
    {
        #region 宣告

        CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 檢查必填欄位

        arl_Return = CAAComm.Check_MustFillin_Column(this.slp_YearMonth_S.Text, "text", "欄位[結帳年月]開始欄位為必填欄位", "1", this.slp_YearMonth_S.TextBoxCode_Object.ClientID, arl_Return);
        arl_Return = CAAComm.Check_MustFillin_Column(this.slp_YearMonth_E.Text, "text", "欄位[結帳年月]結束欄位為必填欄位", "1", this.slp_YearMonth_E.TextBoxCode_Object.ClientID, arl_Return);

        #endregion

        #region 檢查SLP年月格式

        arl_Return = CAAComm.Check_Format_YearMonth(this.slp_YearMonth_S.Text, "欄位[發票年月]開始欄位年月格式錯誤", "1", this.slp_YearMonth_S.TextBoxCode_Object.ClientID, arl_Return);
        arl_Return = CAAComm.Check_Format_YearMonth(this.slp_YearMonth_E.Text, "欄位[發票年月]結束欄位年月格式錯誤", "1", this.slp_YearMonth_E.TextBoxCode_Object.ClientID, arl_Return);

        #endregion

        #region 如果基本檢查有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查Between欄位

        #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

        arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
            (this.slp_YearMonth_S.Text,
             this.slp_YearMonth_E.Text,
             "string",
             "欄位[發票年月]結束欄位一定要大於或等於開始欄位",
             "1",
             this.slp_YearMonth_E.TextBoxCode_Object.ClientID,
             arl_Return);

        #endregion

        #endregion

        return arl_Return;
    }

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    static ArrayList Check_Condition(string[] s_Array_ServerString)
    {
        #region 宣告

        BCO_CAA.CAACommon CAAComm = new BCO_CAA.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 檢查必填欄位

        if (s_Array_ServerString[1] == string.Empty && s_Array_ServerString[2] == string.Empty &&
            s_Array_ServerString[3] == string.Empty && s_Array_ServerString[4] == string.Empty &&
            s_Array_ServerString[5] == string.Empty && s_Array_ServerString[6] == string.Empty)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[結帳年月][入帳日期][簽收日期]必須擇一輸入", "1", string.Empty); }

        if (s_Array_ServerString[21] == string.Empty)
        { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[狀態]必須擇一輸入", "1", string.Empty); }

        #endregion

        #region 檢查SLP年月格式

        arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[1], "欄位[結帳年月]開始欄位年月格式錯誤", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[2], "欄位[結帳年月]結束欄位年月格式錯誤", "1", string.Empty, arl_Return);

        #endregion

        #region 檢查SLP日期格式

        arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[3], "欄位[入帳日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[4], "欄位[入帳日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[5], "欄位[簽收日期 ]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
        arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[6], "欄位[簽收日期 ]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);

        #endregion

        #region 如果基本檢查有誤，則Return

        if (arl_Return[1].ToString() != string.Empty)
        { return arl_Return; }

        #endregion

        #region 檢查Between欄位

        #region 欄位[結帳年月]

        if (s_Array_ServerString[1] != string.Empty ||
            s_Array_ServerString[2] != string.Empty)
        {
            #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

            arl_Return = CAAComm.Check_Between_BeginEnd_Value
                (s_Array_ServerString[1],
                 s_Array_ServerString[2],
                 "結帳年月",
                 "1",
                 string.Empty,
                 string.Empty,
                 arl_Return);

            #endregion

            #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

            arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                (s_Array_ServerString[1],
                 s_Array_ServerString[2],
                 "string",
                 "欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
                 "1",
                 string.Empty,
                 arl_Return);

            #endregion
        }

        #endregion

        #region 欄位[入帳日期]

        if (s_Array_ServerString[3] != string.Empty ||
            s_Array_ServerString[4] != string.Empty)
        {
            #region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值

            arl_Return = CAAComm.Check_Between_BeginEnd_Value
                (s_Array_ServerString[3],
                 s_Array_ServerString[4],
                 "入帳日期",
                 "1",
                 string.Empty,
                 string.Empty,
//.........这里部分代码省略.........

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region SLP轉型

        TextBox txt_CHG_INCOME_DATE = (TextBox)this.SLP_CHG_INCOME_DATE.FindControl("TextBoxCode");//轉其他收入日期

        #endregion

        #region 新增模式

        if (s_Type == "Insert")
        {
            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.SLP_TEMPAMT.Text, "欄位[暫收金額]數字格式錯誤", "64", "1", this.SLP_TEMPAMT.TextBox_Code.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.txtCLOSE_MONTH.Text, "欄位[結帳年月]年月格式錯誤", "1", this.txtCLOSE_MONTH.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(this.SLP_CHG_INCOME_DATE.Text, "欄位[轉其他收入日期]日期格式錯誤", "1", txt_CHG_INCOME_DATE.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_STORE_ID.Text, "text", "欄位[店號]為必填欄位", "1", this.SLP_STORE_ID.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_ROOT_NO.Text, "text", "欄位[商品群分類]為必填欄位", "1", this.SLP_ROOT_NO.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.ddlTaxType.Text, "text", "欄位[稅別]為必填欄位", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_TEMPAMT.Text, "text", "欄位[暫收金額]為必填欄位", "1", this.SLP_TEMPAMT.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.txtCLOSE_MONTH.Text, "text", "欄位[結帳年月]為必填欄位", "1", this.txtCLOSE_MONTH.ClientID, arl_Return);

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 自訂檢查

            #region 檢查店號

            //新增模式下，店號必須以 sysdate 為基準來做查詢
            //編輯模式下，店號必須以該筆資料的 createdate 為基準來做查詢
            if (Check_Store_Id(this.SLP_STORE_ID.Text, DateTime.Now) == false)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[店號]必須是有效的店號", "1", this.SLP_STORE_ID.TextBox_Code.ClientID); }

            #endregion

            #region 檢查商品群分類代碼

            if (Check_RootNo(this.SLP_ROOT_NO.Text) == false)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[商品群分類]必須是有效的群分類代號", "1", this.SLP_ROOT_NO.TextBox_Code.ClientID); }

            #endregion

            #region 檢查欄位[暫收金額]不可為零

            if (Int64.Parse(this.SLP_TEMPAMT.Text) <= 0)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[暫收金額]必須大於零", "1", this.SLP_TEMPAMT.TextBox_Code.ClientID); }

            #endregion

            #endregion
        }

        #endregion

        #region 編輯模式

        else if (s_Type == "Edit")
        {
            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.SLP_TEMPAMT.Text, "欄位[暫收金額]數字格式錯誤", "64", "1", this.SLP_TEMPAMT.TextBox_Code.ClientID, arl_Return);

            #endregion

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

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region TAB1的檢查

        if (s_Type == "TAB1")
        {
            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_tab1_DATE_B.Text, "text", "欄位[起迄年月]開始欄位為必填欄位", "1", this.slp_tab1_DATE_B.TextBoxCode_Object.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_tab1_DATE_E.Text, "text", "欄位[起迄年月]結束欄位為必填欄位", "1", this.slp_tab1_DATE_E.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_tab1_DATE_B.Text, "欄位[起迄年月]開始欄位年月格式錯誤", "1", this.slp_tab1_DATE_B.TextBoxCode_Object.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_tab1_DATE_E.Text, "欄位[起迄年月]結束欄位年月格式錯誤", "1", this.slp_tab1_DATE_E.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查Between欄位

            #region 欄位[起迄年月]

            if (this.slp_tab1_DATE_B.Text != string.Empty &&
                this.slp_tab1_DATE_E.Text != string.Empty)
            {
                #region 檢查Between欄位結束欄位一定要大於或等於開始欄位

                arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
                    (this.slp_tab1_DATE_B.Text,
                    this.slp_tab1_DATE_E.Text,
                    "string",
                    "欄位[起迄年月]結束欄位一定要大於或等於開始欄位",
                    "1",
                    this.slp_tab1_DATE_E.TextBoxCode_Object.ClientID,
                    arl_Return);

                #endregion
            }

            #endregion

            #endregion
        }

        #endregion

        #region BUTTON [確定匯入]

        else if (s_Type == "BUTTON [確定匯入]")
        {
            #region 自訂檢查

            TextBox txt_UP11 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP11");//處理總筆數
            TextBox txt_UP12 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP12");//成功筆數
            TextBox txt_UP13 = (TextBox)this.UploadStatusPanel1.FindControl("txtUP13");//異常筆數

            int i_Total_Count = int.Parse(txt_UP11.Text);
            int i_Success_Count = int.Parse(txt_UP12.Text);
            int i_Failure_Count = int.Parse(txt_UP13.Text);

            if (((i_Total_Count == i_Success_Count) &&
               (i_Failure_Count == 0)) == false)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "上傳檔案有誤，不可匯入", "1", string.Empty); }

            #endregion
        }

        #endregion

        return arl_Return;
    }

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <param name="s_Type"></param>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        BCO.CAACommon CAAComm = new BCO.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region SLP轉型

        #region 銷或折讓維護區

        TextBox txt_STORE_ID = (TextBox)this.slp_STORE_ID.FindControl("TextBoxCode");//店號
        TextBox txt_ROOT_NO = (TextBox)this.slp_ROOT_NO.FindControl("TextBoxCode");//商品群分類
        TextBox txt_DISC_DATE = (TextBox)this.slp_DISC_DATE.FindControl("TextBoxCode");//折讓日期
        TextBox txt_CHG_DISC_DATE = (TextBox)this.slp_CHG_DISC_DATE.FindControl("TextBoxCode");//異動折讓日期
        TextBox txt_PROOF_DATE = (TextBox)this.slp_PROOF_DATE.FindControl("TextBoxCode");//憑證已回日期
        TextBox txt_CANCEL_DATE = (TextBox)this.slp_CANCEL_DATE.FindControl("TextBoxCode");//作廢日期
        TextBox txt_PERIOD_DATE = (TextBox)this.slp_PERIOD_DATE.FindControl("TextBoxCode");//申報日期
        TextBox txt_TEMPORAL_DATE = (TextBox)this.slp_TEMPORAL_DATE.FindControl("TextBoxCode");//暫收日期
        TextBox txt_DISC_UAMT = (TextBox)this.slp_DISC_UAMT.FindControl("TextBoxCode");//折讓金額(未稅)
        TextBox txt_DISC_TAX = (TextBox)this.slp_DISC_TAX.FindControl("TextBoxCode");//折讓稅額
        TextBox txt_DISC_AMT = (TextBox)this.slp_DISC_AMT.FindControl("TextBoxCode");//總金額
        TextBox txt_CLOSE_MONTH = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)this.slp_CLOSE_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");//結帳年月

        DropDownList drop_DISC_SOURCE = (DropDownList)this.slp_DISC_SOURCE.FindControl("D1");//來源
        DropDownList drop_DISC_TYPE = (DropDownList)this.slp_DISC_TYPE.FindControl("D1");//型式
        DropDownList drop_TAX_TYPE = (DropDownList)this.slp_TAX_TYPE.FindControl("D1");//稅別

        #endregion

        #region 折讓項目區

        TextBox txt_Disc_INV_DATE = (TextBox)this.slp_Disc_INV_DATE.FindControl("TextBoxCode");//發票日期
        TextBox txt_Disc_DISC_UAMT = (TextBox)this.slp_Disc_DISC_UAMT.FindControl("TextBoxCode");//折讓金額(未稅)
        TextBox txt_Disc_DISC_TAX = (TextBox)this.slp_Disc_DISC_TAX.FindControl("TextBoxCode");//折讓稅額
        TextBox txt_Disc_NON_INV_UAMT = (TextBox)this.slp_Disc_NON_INV_UAMT.FindControl("TextBoxCode");//發票餘額(未稅)
        TextBox txt_Disc_NON_INV_TAX = (TextBox)this.slp_Disc_NON_INV_TAX.FindControl("TextBoxCode");//發票稅額

        #endregion

        #endregion

        #region BUTTON [儲存]鈕

        #region 新增狀態

        if (s_Type == "BUTTON [儲存]鈕，新增狀態")
        {
            #region 檢查欄位的Byte長度

            if (CAAComm.Get_Byte_Length(this.txt_ACT_DISC_NO.Text) > 13)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[財會折讓單號]長度不可大於 13 Byte", "1", this.txt_ACT_DISC_NO.ClientID); }
            if (CAAComm.Get_Byte_Length(this.txt_REPROOF_NO.Text) > 12)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[發票號碼/收據]長度不可大於 12 Byte", "1", this.txt_REPROOF_NO.ClientID); }
            if (CAAComm.Get_Byte_Length(this.txt_RFNO.Text) > 10)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[統一編號]長度不可大於 10 Byte", "1", this.txt_RFNO.ClientID); }
            if (CAAComm.Get_Byte_Length(this.txt_MEMO.Text) > 200)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[備註]長度不可大於 200 Byte", "1", this.txt_MEMO.ClientID); }

            #endregion

            #region 檢查SLP日期格式

            arl_Return = CAAComm.Check_Format_Date(this.slp_DISC_DATE.Text, "欄位[折讓日期]日期格式錯誤", "1", txt_DISC_DATE.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_CHG_DISC_DATE.Text, "欄位[異動折讓日期]日期格式錯誤", "1", txt_DISC_DATE.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_PROOF_DATE.Text, "欄位[憑證已回日期]日期格式錯誤", "1", txt_PROOF_DATE.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_CANCEL_DATE.Text, "欄位[作廢日期]日期格式錯誤", "1", txt_CANCEL_DATE.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_PERIOD_DATE.Text, "欄位[申報日期]日期格式錯誤", "1", txt_PERIOD_DATE.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Date(this.slp_TEMPORAL_DATE.Text, "欄位[暫收日期]日期格式錯誤", "1", txt_TEMPORAL_DATE.ClientID, arl_Return);

            #endregion

            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.slp_DISC_UAMT.Text, "欄位[折讓金額(未稅)]數字格式錯誤", "32", "1", txt_DISC_UAMT.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(this.slp_DISC_TAX.Text, "欄位[折讓稅額]數字格式錯誤", "32", "1", txt_DISC_TAX.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_Int(Request[txt_DISC_AMT.UniqueID].ToString(), "欄位[總金額]數字格式錯誤", "32", "1", txt_DISC_AMT.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH.Text, "欄位[結帳年月]年月格式錯誤", "1", txt_CLOSE_MONTH.ClientID, arl_Return);
            arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH_ACCT.Text, "欄位[結帳年月-財會]年月格式錯誤", "1", this.slp_CLOSE_MONTH_ACCT.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(drop_DISC_SOURCE.SelectedIndex.ToString(), "drop", "欄位[來源]為必填欄位", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.slp_STORE_ID.Text, "text", "欄位[店號]為必填欄位", "1", txt_STORE_ID.ClientID, arl_Return);
//.........这里部分代码省略.........

    /// <summary>
    /// 檢查條件
    /// </summary>
    /// <returns></returns>
    private ArrayList Check_Condition(string s_Type)
    {
        #region 宣告

        CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
        ArrayList arl_Return = new ArrayList();
        arl_Return.Add(string.Empty);//該欄位放Focus欄位之ClientID
        arl_Return.Add(string.Empty);//該欄位放錯誤訊息

        #endregion

        #region 新增模式

        if (s_Type == "Insert")
        {
            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.SLP_DUE_AMT.Text, "欄位[調整金額]數字格式錯誤", "64", "1", this.SLP_DUE_AMT.TextBox_Code.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.txtCLOSE_MONTH.Text, "欄位[結帳年月]年月格式錯誤", "1", this.txtCLOSE_MONTH.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_STORE_ID.Text, "text", "欄位[店號]為必填欄位", "1", this.SLP_STORE_ID.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_ROOT_NO.Text, "text", "欄位[商品群分類]為必填欄位", "1", this.SLP_ROOT_NO.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.ddlTaxType.Text, "text", "欄位[稅別]為必填欄位", "1", string.Empty, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_DUE_AMT.Text, "text", "欄位[調整金額]為必填欄位", "1", this.SLP_DUE_AMT.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.txtCLOSE_MONTH.Text, "text", "欄位[結帳年月]為必填欄位", "1", this.txtCLOSE_MONTH.ClientID, arl_Return);

            #endregion

            #region 如果基本檢查有誤，則Return

            if (arl_Return[1].ToString() != string.Empty)
            { return arl_Return; }

            #endregion

            #region 自訂檢查

            #region 檢查店號

            //新增模式下，店號必須以 sysdate 為基準來做查詢
            //編輯模式下，店號必須以該筆資料的 createdate 為基準來做查詢
            if (Check_Store_Id(this.SLP_STORE_ID.Text, DateTime.Now) == false)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[店號]必須是有效的店號", "1", this.SLP_STORE_ID.TextBox_Code.ClientID); }

            #endregion

            #region 檢查商品群分類代碼

            if (Check_RootNo(this.SLP_ROOT_NO.Text) == false)
            { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[商品群分類]必須是有效的群分類代號", "1", this.SLP_ROOT_NO.TextBox_Code.ClientID); }

            #endregion

            #region 檢查欄位[調整金額]不可為零(如果型式選擇(帳款互沖)為列外狀態可以為零)
            if (SLP_SOURCE_TYPE.Text.Trim() != "3")
            {
                if (Int64.Parse(this.SLP_DUE_AMT.Text) <= 0)
                { arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[調整金額]必須大於零", "1", this.SLP_DUE_AMT.TextBox_Code.ClientID); }
            }
            #endregion

            #endregion
        }

        #endregion

        #region 編輯模式

        else if (s_Type == "Edit")
        {
            #region 檢查SLP數字格式

            arl_Return = CAAComm.Check_Format_Int(this.SLP_DUE_AMT.Text, "欄位[調整金額]數字格式錯誤", "64", "1", this.SLP_DUE_AMT.TextBox_Code.ClientID, arl_Return);

            #endregion

            #region 檢查SLP年月格式

            arl_Return = CAAComm.Check_Format_YearMonth(this.txtCLOSE_MONTH.Text, "欄位[結帳年月]年月格式錯誤", "1", this.txtCLOSE_MONTH.TextBoxCode_Object.ClientID, arl_Return);

            #endregion

            #region 檢查必填欄位

            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_STORE_ID.Text, "text", "欄位[店號]為必填欄位", "1", this.SLP_STORE_ID.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.SLP_ROOT_NO.Text, "text", "欄位[商品群分類]為必填欄位", "1", this.SLP_ROOT_NO.TextBox_Code.ClientID, arl_Return);
            arl_Return = CAAComm.Check_MustFillin_Column(this.ddlTaxType.Text, "text", "欄位[稅別]為必填欄位", "1", string.Empty, arl_Return);
//.........这里部分代码省略.........