/// <summary>
/// 檢查條件
/// </summary>
/// <returns></returns>
static ArrayList Check_Condition(string[] s_Array_ServerString)
{
#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日期格式
if (s_Array_ServerString[2] == "____/__/__")
{ s_Array_ServerString[2] = string.Empty; }
if (s_Array_ServerString[3] == "____/__/__")
{ s_Array_ServerString[3] = string.Empty; }
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[2], "欄位[沖帳日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[3], "欄位[沖帳日期]結束欄位日期格式錯誤", "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[8] != string.Empty ||
s_Array_ServerString[9] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[8],
s_Array_ServerString[9],
"利潤中心",
"1",
s_Array_ServerString[8],
s_Array_ServerString[9],
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[8],
s_Array_ServerString[9],
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
s_Array_ServerString[9],
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (s_Array_ServerString[10] != string.Empty ||
s_Array_ServerString[11] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[10],
s_Array_ServerString[11],
"營業所",
"1",
s_Array_ServerString[10],
s_Array_ServerString[11],
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[10],
s_Array_ServerString[11],
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
s_Array_ServerString[10],
arl_Return);
#endregion
}
#endregion
#region 檢查欄位[沖帳日期]
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[2],
s_Array_ServerString[3],
"string",
"欄位[沖帳日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
#endregion
#endregion
return arl_Return;
}
/// <summary>
/// 檢查條件
/// </summary>
/// <param name="s_Type"></param>
/// <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 BUTTON [查詢]鈕
if (s_Type == "BUTTON [查詢]鈕")
{
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(this.SLP_3_WASHDATE_RANGE.StartDate, "欄位[沖帳日期]開始欄位日期格式錯誤", "1", this.SLP_3_WASHDATE_RANGE.RangeStartTextBox.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.SLP_3_WASHDATE_RANGE.EndDate, "欄位[沖帳日期]結束欄位日期格式錯誤", "1", this.SLP_3_WASHDATE_RANGE.RangeEndTextBox.ClientID, arl_Return);
#endregion
#region 如果基本檢查有誤，則Return
if (arl_Return[1].ToString() != string.Empty)
{ return arl_Return; }
#endregion
#region 檢查Between欄位
#region 欄位[利潤中心]
if (this.slp_PROFIT_NO_B.Text != string.Empty ||
this.slp_PROFIT_NO_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_PROFIT_NO_B.Text,
this.slp_PROFIT_NO_E.Text,
"利潤中心",
"1",
this.slp_PROFIT_NO_B.TextBox_Code.ClientID,
this.slp_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_PROFIT_NO_B.Text,
this.slp_PROFIT_NO_E.Text,
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (this.slp_Z_O_B.Text != string.Empty ||
this.slp_Z_O_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_Z_O_B.Text,
this.slp_Z_O_E.Text,
"營業所",
"1",
this.slp_Z_O_B.TextBox_Code.ClientID,
this.slp_Z_O_E.TextBox_Code.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_Z_O_B.Text,
this.slp_Z_O_E.Text,
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_Z_O_E.TextBox_Code.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[沖帳日期]
if (this.SLP_3_WASHDATE_RANGE.StartDate != string.Empty ||
this.SLP_3_WASHDATE_RANGE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.SLP_3_WASHDATE_RANGE.StartDate,
this.SLP_3_WASHDATE_RANGE.EndDate,
"沖帳日期",
"1",
this.SLP_3_WASHDATE_RANGE.RangeStartTextBox.ClientID,
this.SLP_3_WASHDATE_RANGE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.SLP_3_WASHDATE_RANGE.StartDate,
this.SLP_3_WASHDATE_RANGE.EndDate,
"string",
"欄位[沖帳日期]結束欄位一定要大於或等於開始欄位",
"1",
this.SLP_3_WASHDATE_RANGE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
return arl_Return;
}
/// <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);
#endregion
}
#endregion
#region 欄位[異動折讓日期]
if (s_Array_ServerString[16] != string.Empty ||
s_Array_ServerString[17] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[16],
s_Array_ServerString[17],
"異動折讓日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[16],
s_Array_ServerString[17],
"date",
"欄位[異動折讓日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[憑證已回日期]
if (s_Array_ServerString[19] != string.Empty ||
s_Array_ServerString[20] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[19],
s_Array_ServerString[20],
"憑證已回日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[19],
s_Array_ServerString[20],
"date",
"欄位[憑證已回日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[作廢日期]
if (s_Array_ServerString[25] != string.Empty ||
s_Array_ServerString[26] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[25],
s_Array_ServerString[26],
"作廢日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[25],
s_Array_ServerString[26],
"date",
"欄位[作廢日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報日期]
if (s_Array_ServerString[28] != string.Empty ||
s_Array_ServerString[29] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[28],
s_Array_ServerString[29],
"申報日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[28],
s_Array_ServerString[29],
"date",
"欄位[申報日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[暫收日期]
if (s_Array_ServerString[31] != string.Empty ||
s_Array_ServerString[32] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[31],
s_Array_ServerString[32],
"暫收日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[31],
s_Array_ServerString[32],
"date",
"欄位[暫收日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報期別] 20110505 RIKA INSERT
if (s_Array_ServerString[46] != string.Empty ||
s_Array_ServerString[47] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[46],
s_Array_ServerString[47],
"申報期別",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[46],
s_Array_ServerString[47],
"string",
"欄位[申報期別]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月] 20110414 RIKA INSERT
if (s_Array_ServerString[42] != string.Empty ||
s_Array_ServerString[43] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[42],
s_Array_ServerString[43],
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[42],
s_Array_ServerString[43],
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月-財會] 20110414 RIKA INSERT
if (s_Array_ServerString[44] != string.Empty ||
s_Array_ServerString[45] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[44],
s_Array_ServerString[45],
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[44],
s_Array_ServerString[45],
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#region 頁籤=發票折抵明細查詢
else if (s_Type == "1")
{
#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);
#endregion
#region 檢查SLP數字格式
arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[8], "欄位[發票金額(未稅)]數字格式錯誤", "32", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[10], "欄位[發票稅額]數字格式錯誤", "32", "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[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,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[3],
s_Array_ServerString[4],
"date",
"欄位[發票日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#region 頁籤=報表
else if (s_Type == "2")
{
#region 檢查必填欄位
if (s_Array_ServerString[2] == string.Empty && s_Array_ServerString[3] == string.Empty && s_Array_ServerString[4] == string.Empty &&
s_Array_ServerString[5] == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[結帳年月][結帳年月-財會]必須擇一輸入", "1", string.Empty); }
#endregion
#region 檢查SLP日期格式
//20110512 rika insert
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);
#endregion
#region 檢查SLP年月格式
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[2], "欄位[結帳年月]起年月格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[3], "欄位[結帳年月]迄年月格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[4], "欄位[結帳年月-財會]起年月格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[5], "欄位[結帳年月-財會]迄年月格式錯誤", "1", string.Empty, arl_Return);
//20110512 rika insert
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[27], "欄位[申報期別起]年月格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[28], "欄位[申報期別迄]年月格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查輸入代號是否正確
if (s_Array_ServerString[19] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[利潤中心]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[20] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[利潤中心]結束欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[21] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業所]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[22] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業所]結束欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[23] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[帳務人員]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[24] == "查無資料")
{ 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欄位
#region 欄位[利潤中心]
if (s_Array_ServerString[6] != string.Empty ||
s_Array_ServerString[7] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[6],
s_Array_ServerString[7],
"利潤中心",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[6],
s_Array_ServerString[7],
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (s_Array_ServerString[8] != string.Empty ||
s_Array_ServerString[9] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[8],
s_Array_ServerString[9],
"營業所",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[8],
s_Array_ServerString[9],
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[帳務人員]
if (s_Array_ServerString[10] != string.Empty ||
s_Array_ServerString[11] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[10],
s_Array_ServerString[11],
"帳務人員",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[10],
s_Array_ServerString[11],
"string",
"欄位[帳務人員]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報日期] 20110512 rika insert
if (s_Array_ServerString[25] != string.Empty ||
s_Array_ServerString[26] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[25],
s_Array_ServerString[26],
"申報日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[25],
s_Array_ServerString[26],
"date",
"欄位[申報日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報期別] 20110512 RIKA INSERT
if (s_Array_ServerString[27] != string.Empty ||
s_Array_ServerString[28] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[27],
s_Array_ServerString[28],
"申報期別",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[27],
s_Array_ServerString[28],
"string",
"欄位[申報期別]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月] 20110520 RIKA INSERT
if (s_Array_ServerString[2] != string.Empty ||
s_Array_ServerString[3] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[2],
s_Array_ServerString[3],
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[2],
s_Array_ServerString[3],
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月-財會] 20110520 RIKA INSERT
if (s_Array_ServerString[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"結帳年月-財會",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"string",
"欄位[結帳年月-財會]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#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 TAB 銷貨折讓維護
TextBox txt_DISC_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_DISC_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[折讓日期]起
TextBox txt_DISC_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_DISC_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[折讓日期]迄
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");//[異動折讓日期]迄
TextBox txt_PROOF_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_PROOF_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[憑證已回日期]起
TextBox txt_PROOF_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_PROOF_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[憑證已回日期]迄
TextBox txt_CANCEL_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_CANCEL_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[作廢日期]起
TextBox txt_CANCEL_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_CANCEL_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[作廢日期]迄
TextBox txt_PERIOD_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_PERIOD_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[申報日期]起
TextBox txt_PERIOD_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_PERIOD_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[申報日期]迄
TextBox txt_TEMPORAL_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_TEMPORAL_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[暫收日期]起
TextBox txt_TEMPORAL_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_TEMPORAL_DATE.FindControl("SLP_SLPDate2")).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_DISC_WASH_AMT = (TextBox)this.slp_DISC_WASH_AMT.FindControl("TextBoxCode");//累積沖帳金額
TextBox txt_DISC_REMAIN_AMT = (TextBox)this.slp_DISC_REMAIN_AMT.FindControl("TextBoxCode");//折讓餘額
DropDownList drop_DISC_FORM = (DropDownList)this.slp_DISC_FORM.FindControl("D1");//格式代號
DropDownList drop_DISC_SOURCE = (DropDownList)this.slp_DISC_SOURCE.FindControl("D1");//來源
DropDownList drop_DISC_TYPE = (DropDownList)this.slp_DISC_TYPE.FindControl("D1");//型式
#endregion
#region TAB 發票折抵明細查詢
TextBox txt_2_INV_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_2_INV_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[發票日期]起
TextBox txt_2_INV_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_2_INV_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[發票日期]迄
TextBox txt_2_INV_UAMT = (TextBox)this.slp_2_INV_UAMT.FindControl("TextBoxCode");//發票金額(未稅)
TextBox txt_2_INV_TAX = (TextBox)this.slp_2_INV_TAX.FindControl("TextBoxCode");//發票稅額(未稅)
#endregion
#region TAB 報表
TextBox txt_3_PERIOD_DATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_3_PERIOD_DATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");//[申報日期]起
TextBox txt_3_PERIOD_DATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_3_PERIOD_DATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");//[申報日期]迄
#endregion
#endregion
#region BUTTON [查詢]鈕
#region TAB 銷貨折讓維護
if (s_Type == "BUTTON [查詢]鈕 TAB 銷貨折讓維護")
{
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(this.slp_DISC_DATE.StartDate, "欄位[折讓日期]開始欄位日期格式錯誤", "1", txt_DISC_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_DISC_DATE.EndDate, "欄位[折讓日期]結束欄位日期格式錯誤", "1", txt_DISC_DATE_E.ClientID, arl_Return);
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);
arl_Return = CAAComm.Check_Format_Date(this.slp_PROOF_DATE.StartDate, "欄位[憑證已回日期]開始欄位日期格式錯誤", "1", txt_PROOF_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_PROOF_DATE.EndDate, "欄位[憑證已回日期]結束欄位日期格式錯誤", "1", txt_PROOF_DATE_E.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_CANCEL_DATE.StartDate, "欄位[作廢日期]開始欄位日期格式錯誤", "1", txt_CANCEL_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_CANCEL_DATE.EndDate, "欄位[作廢日期]結束欄位日期格式錯誤", "1", txt_CANCEL_DATE_E.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_PERIOD_DATE.StartDate, "欄位[申報日期]開始欄位日期格式錯誤", "1", txt_PERIOD_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_PERIOD_DATE.EndDate, "欄位[申報日期]結束欄位日期格式錯誤", "1", txt_PERIOD_DATE_E.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_TEMPORAL_DATE.StartDate, "欄位[暫收日期]開始欄位日期格式錯誤", "1", txt_TEMPORAL_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_TEMPORAL_DATE.EndDate, "欄位[暫收日期]結束欄位日期格式錯誤", "1", txt_TEMPORAL_DATE_E.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(this.slp_DISC_AMT.Text, "欄位[總金額]數字格式錯誤", "32", "1", txt_DISC_AMT.ClientID, arl_Return);
//20110505 rika insert
arl_Return = CAAComm.Check_Format_Int(this.slp_DISC_WASH_AMT.Text, "欄位[累積沖帳金額]數字格式錯誤", "32", "1", txt_DISC_WASH_AMT.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Int(this.slp_DISC_REMAIN_AMT.Text, "欄位[折讓餘額]數字格式錯誤", "32", "1", txt_DISC_REMAIN_AMT.ClientID, arl_Return);
#endregion
#region 檢查SLP年月格式 20110505 rika insert
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);
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);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH_ACCT_B.Text, "欄位[結帳年月-財會]起年月格式錯誤", "1", this.slp_CLOSE_MONTH_ACCT_B.TextBoxCode_Object.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_CLOSE_MONTH_ACCT_E.Text, "欄位[結帳年月-財會]迄年月格式錯誤", "1", this.slp_CLOSE_MONTH_ACCT_E.TextBoxCode_Object.ClientID, arl_Return);
#endregion
#region 檢查List欄位的選擇狀態
if (drop_DISC_FORM.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[格式代號]請選擇一選項", "1", string.Empty); }
if (drop_DISC_SOURCE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[來源]請選擇一選項", "1", string.Empty); }
if (drop_DISC_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[型式]請選擇一選項", "1", string.Empty); }
if (this.slp_TAX_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[稅別]請選擇一選項", "1", string.Empty); }
if (this.radl_PROOF_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[憑證已回]請選擇一選項", "1", string.Empty); }
if (this.radl_REPROOF_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[取具進項憑証]請選擇一選項", "1", string.Empty); }
if (this.radl_CANCEL_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[作廢]請選擇一選項", "1", string.Empty); }
if (this.radl_PERIOD_TYPE.SelectedIndex < 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[申報]請選擇一選項", "1", string.Empty); }
if (this.radl_TEMPORAL_TYPE.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欄位
#region 欄位[折讓日期]
if (this.slp_DISC_DATE.StartDate != string.Empty ||
this.slp_DISC_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_DISC_DATE.StartDate,
this.slp_DISC_DATE.EndDate,
"折讓日期",
"1",
txt_DISC_DATE_B.ClientID,
txt_DISC_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_DISC_DATE.StartDate,
this.slp_DISC_DATE.EndDate,
"date",
"欄位[折讓日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_DISC_DATE_E.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,
this.slp_CHG_DISC_DATE.EndDate,
"異動折讓日期",
"1",
txt_CHG_DISC_DATE_B.ClientID,
txt_CHG_DISC_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CHG_DISC_DATE.StartDate,
this.slp_CHG_DISC_DATE.EndDate,
"date",
"欄位[異動折讓日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_CHG_DISC_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[憑證已回日期]
if (this.slp_PROOF_DATE.StartDate != string.Empty ||
this.slp_PROOF_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_PROOF_DATE.StartDate,
this.slp_PROOF_DATE.EndDate,
"憑證已回日期",
"1",
txt_PROOF_DATE_B.ClientID,
txt_PROOF_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_PROOF_DATE.StartDate,
this.slp_PROOF_DATE.EndDate,
"date",
"欄位[憑證已回日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_PROOF_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[作廢日期]
if (this.slp_CANCEL_DATE.StartDate != string.Empty ||
this.slp_CANCEL_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_CANCEL_DATE.StartDate,
this.slp_CANCEL_DATE.EndDate,
"作廢日期",
"1",
txt_CANCEL_DATE_B.ClientID,
txt_CANCEL_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CANCEL_DATE.StartDate,
this.slp_CANCEL_DATE.EndDate,
"date",
"欄位[作廢日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_CANCEL_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報日期]
if (this.slp_PERIOD_DATE.StartDate != string.Empty ||
this.slp_PERIOD_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_PERIOD_DATE.StartDate,
this.slp_PERIOD_DATE.EndDate,
"申報日期",
"1",
txt_PERIOD_DATE_B.ClientID,
txt_PERIOD_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_PERIOD_DATE.StartDate,
this.slp_PERIOD_DATE.EndDate,
"date",
"欄位[申報日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_PERIOD_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[暫收日期]
if (this.slp_TEMPORAL_DATE.StartDate != string.Empty ||
this.slp_TEMPORAL_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_TEMPORAL_DATE.StartDate,
this.slp_TEMPORAL_DATE.EndDate,
"暫收日期",
"1",
txt_TEMPORAL_DATE_B.ClientID,
txt_TEMPORAL_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_TEMPORAL_DATE.StartDate,
this.slp_TEMPORAL_DATE.EndDate,
"date",
"欄位[暫收日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_TEMPORAL_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報期別] 20110505 RIKA INSERT
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",
string.Empty,
string.Empty,
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",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月] 20110414 RIKA INSERT
if (this.slp_CLOSE_MONTH_B.Text != string.Empty ||
this.slp_CLOSE_MONTH_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_CLOSE_MONTH_B.Text,
this.slp_CLOSE_MONTH_E.Text,
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CLOSE_MONTH_B.Text,
this.slp_CLOSE_MONTH_E.Text,
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月-財會] 20110414 RIKA INSERT
if (this.slp_CLOSE_MONTH_ACCT_B.Text != string.Empty ||
this.slp_CLOSE_MONTH_ACCT_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_CLOSE_MONTH_ACCT_B.Text,
this.slp_CLOSE_MONTH_ACCT_E.Text,
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CLOSE_MONTH_ACCT_B.Text,
this.slp_CLOSE_MONTH_ACCT_E.Text,
"string",
"欄位[結帳年月-財會]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#region TAB 發票折抵明細查詢
else if (s_Type == "BUTTON [查詢]鈕 TAB 發票折抵明細查詢")
{
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(this.slp_2_INV_DATE.StartDate, "欄位[發票日期]開始欄位日期格式錯誤", "1", txt_2_INV_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_2_INV_DATE.EndDate, "欄位[發票日期]結束欄位日期格式錯誤", "1", txt_2_INV_DATE_E.ClientID, arl_Return);
#endregion
#region 檢查SLP數字格式
arl_Return = CAAComm.Check_Format_Int(this.slp_2_INV_UAMT.Text, "欄位[發票金額(未稅)]數字格式錯誤", "32", "1", txt_2_INV_UAMT.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Int(this.slp_2_INV_TAX.Text, "欄位[發票稅額]數字格式錯誤", "32", "1", txt_2_INV_TAX.ClientID, arl_Return);
#endregion
#region 檢查List欄位的選擇狀態
if (this.slp_2_TAX_TYPE.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欄位
#region 欄位[發票日期]
if (this.slp_2_INV_DATE.StartDate != string.Empty ||
this.slp_2_INV_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_2_INV_DATE.StartDate,
this.slp_2_INV_DATE.EndDate,
"發票日期",
"1",
txt_2_INV_DATE_B.ClientID,
txt_2_INV_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_2_INV_DATE.StartDate,
this.slp_2_INV_DATE.EndDate,
"date",
"欄位[發票日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_2_INV_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#endregion
#region TAB 報表
if (s_Type == "TAB 報表")
{
#region 檢查必填欄位
if (this.slp_3_CLOSE_MONTH_B.Text == string.Empty && this.slp_3_CLOSE_MONTH_E.Text == string.Empty &&
this.slp_3_CLOSE_MONTH_ACCT_B.Text == string.Empty && this.slp_3_CLOSE_MONTH_ACCT_E.Text == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[結帳年月][結帳年月-財會]必須擇一輸入", "1", this.slp_3_CLOSE_MONTH_B.TextBoxCode_Object.ClientID); }
#endregion
#region 檢查SLP日期格式 20110512 rika insert
arl_Return = CAAComm.Check_Format_Date(this.slp_3_PERIOD_DATE.StartDate, "欄位[申報日期]開始欄位日期格式錯誤", "1", txt_3_PERIOD_DATE_B.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_Date(this.slp_3_PERIOD_DATE.EndDate, "欄位[申報日期]結束欄位日期格式錯誤", "1", txt_3_PERIOD_DATE_E.ClientID, arl_Return);
#endregion
#region 檢查SLP年月格式
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_CLOSE_MONTH_B.Text, "欄位[結帳年月]起年月格式錯誤", "1", this.slp_3_CLOSE_MONTH_B.TextBoxCode_Object.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_CLOSE_MONTH_E.Text, "欄位[結帳年月]迄年月格式錯誤", "1", this.slp_3_CLOSE_MONTH_E.TextBoxCode_Object.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_CLOSE_MONTH_ACCT_B.Text, "欄位[結帳年月-財會]起年月格式錯誤", "1", this.slp_3_CLOSE_MONTH_ACCT_B.TextBoxCode_Object.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_CLOSE_MONTH_ACCT_E.Text, "欄位[結帳年月-財會]迄年月格式錯誤", "1", this.slp_3_CLOSE_MONTH_ACCT_E.TextBoxCode_Object.ClientID, arl_Return);
//20110505 rika insert
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_PERIOD_MONTH_B.Text, "欄位[申報期別]年月格式錯誤", "1", this.slp_3_PERIOD_MONTH_B.TextBoxCode_Object.ClientID, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(this.slp_3_PERIOD_MONTH_E.Text, "欄位[申報期別]年月格式錯誤", "1", this.slp_3_PERIOD_MONTH_E.TextBoxCode_Object.ClientID, arl_Return);
#endregion
#region 如果基本檢查有誤，則Return
if (arl_Return[1].ToString() != string.Empty)
{ return arl_Return; }
#endregion
#region 檢查Between欄位
#region 欄位[利潤中心]
if (this.slp_3_PROFIT_NO_B.Text != string.Empty ||
this.slp_3_PROFIT_NO_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_3_PROFIT_NO_B.Text,
this.slp_3_PROFIT_NO_E.Text,
"利潤中心",
"1",
this.slp_3_PROFIT_NO_B.TextBox_Code.ClientID,
this.slp_3_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_3_PROFIT_NO_B.Text,
this.slp_3_PROFIT_NO_E.Text,
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_3_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報日期] 20110512 rika insert
if (this.slp_3_PERIOD_DATE.StartDate != string.Empty ||
this.slp_3_PERIOD_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_3_PERIOD_DATE.StartDate,
this.slp_3_PERIOD_DATE.EndDate,
"申報日期",
"1",
txt_3_PERIOD_DATE_B.ClientID,
txt_3_PERIOD_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_3_PERIOD_DATE.StartDate,
this.slp_3_PERIOD_DATE.EndDate,
"date",
"欄位[申報日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_3_PERIOD_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[申報期別] 20110512 RIKA INSERT
if (this.slp_3_PERIOD_MONTH_B.Text != string.Empty ||
this.slp_3_PERIOD_MONTH_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_3_PERIOD_MONTH_B.Text,
this.slp_3_PERIOD_MONTH_E.Text,
"申報期別",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_3_PERIOD_MONTH_B.Text,
this.slp_3_PERIOD_MONTH_E.Text,
"string",
"欄位[申報期別]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月] 20110520 RIKA INSERT
if (this.slp_3_CLOSE_MONTH_B.Text != string.Empty ||
this.slp_3_CLOSE_MONTH_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_3_CLOSE_MONTH_B.Text,
this.slp_3_CLOSE_MONTH_E.Text,
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_3_CLOSE_MONTH_B.Text,
this.slp_3_CLOSE_MONTH_E.Text,
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月-財會] 20110520 RIKA INSERT
if (this.slp_3_CLOSE_MONTH_ACCT_B.Text != string.Empty ||
this.slp_3_CLOSE_MONTH_ACCT_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_3_CLOSE_MONTH_ACCT_B.Text,
this.slp_3_CLOSE_MONTH_ACCT_E.Text,
"結帳年月-財會",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_3_CLOSE_MONTH_ACCT_B.Text,
this.slp_3_CLOSE_MONTH_ACCT_E.Text,
"string",
"欄位[結帳年月-財會]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#region TAB 月結
if (s_Type == "TAB 月結")
{
#region 檢查必填欄位
arl_Return = CAAComm.Check_MustFillin_Column(this.slp_4_CLOSE_MONTH.Text, "text", "欄位[月結年月]為必填欄位", "1", this.slp_4_CLOSE_MONTH.TextBoxCode_Object.ClientID, arl_Return);
#endregion
}
#endregion
return 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_INV_DATE = (TextBox)this.slp_INV_DATE.FindControl("TextBoxCode");//[折讓日期]起
TextBox txt_ROUTE_B = (TextBox)this.slp_ROUTE_B.FindControl("TextBoxCode");//[折讓日期]起
TextBox txt_ROUTE_E = (TextBox)this.slp_ROUTE_E.FindControl("TextBoxCode");//[折讓日期]起
#endregion
#region 檢查必填欄位
arl_Return = CAAComm.Check_MustFillin_Column(this.slp_INV_DATE.Text, "text", "欄位[發票日期]為必填欄位", "1", txt_INV_DATE.ClientID, arl_Return);
#endregion
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(this.slp_INV_DATE.Text, "欄位[發票日期]日期格式錯誤", "1", txt_INV_DATE.ClientID, arl_Return);
#endregion
#region 如果基本檢查有誤，則Return
if (arl_Return[1].ToString() != string.Empty)
{ return arl_Return; }
#endregion
#region 自訂檢查
#region 欄位[路線]
if (this.slp_ROUTE_B.Text != string.Empty ||
this.slp_ROUTE_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_ROUTE_B.Text,
this.slp_ROUTE_E.Text,
"路線",
"1",
txt_ROUTE_B.ClientID,
txt_ROUTE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_ROUTE_B.Text,
this.slp_ROUTE_E.Text,
"string",
"欄位[路線]結束欄位一定要大於或等於開始欄位",
"1",
txt_ROUTE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[發票號碼]和[路線]只能擇一輸入
if (this.txt_INV_NO.Text.Trim() != string.Empty &&
this.slp_ROUTE_B.Text.Trim() != string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[發票號碼]和[路線]只能擇一輸入！", "1", string.Empty); }
#endregion
#region 欄位[發票對帳單送達]選擇[到店]時，欄位[路線]為必填欄位
if (this.slp_INVOICE_SEND.Text == "1")//到店
{ arl_Return = CAAComm.Check_MustFillin_Column(this.slp_ROUTE_B.Text, "text", "欄位[發票對帳單送達]選擇[到店]時，欄位[路線]為必填欄位", "1", this.slp_ROUTE_B.TextBox_Code.ClientID, arl_Return); }
#endregion
#endregion
return arl_Return;
}
/// <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,
this.slp_CHG_DISC_DATE.EndDate,
"異動折讓日期",
"1",
txt_CHG_DISC_DATE_B.ClientID,
txt_CHG_DISC_DATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CHG_DISC_DATE.StartDate,
this.slp_CHG_DISC_DATE.EndDate,
"date",
"欄位[異動折讓日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_CHG_DISC_DATE_E.ClientID,
arl_Return);
#endregion
}
#endregion
}
#endregion
#region 將GridView的資訊寫入TempTable
else if (s_Type == "將GridView的資訊寫入TempTable")
{
#region 檢查SLP年月格式 & [申報期別]
#region 取出最小期別
string s_Min_PERIOD_MONTH = Cet_Min_PERIOD_MONTH();
#endregion
foreach (GridViewRow gvRow in this.gv_Result.Rows)
{
#region 轉型
CheckBox chb_CHECK_FLG = (CheckBox)gvRow.FindControl("chb_Item_CHECK_FLG");
CheckBox chb_PERIOD_FLG = (CheckBox)gvRow.FindControl("chb_Item_PERIOD_FLG");
ASP.sys_slp_slp_yearmonth_ascx slp_Item_PERIOD_MONTH = (ASP.sys_slp_slp_yearmonth_ascx)gvRow.Cells[14].Controls[1];
HiddenField hid_SIGN_IS_DISABLED = (HiddenField)gvRow.FindControl("hid_SIGN_IS_DISABLED");
#endregion
bool b_IsRightFormat = false;
#region 檢查[申報期別]是否有值
if (chb_CHECK_FLG.Checked == true &&
chb_PERIOD_FLG.Checked == true &&
slp_Item_PERIOD_MONTH.Text.Trim() == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "折讓單號：" + gvRow.Cells[3].Text + "的[申報期別]不可為空值", "1", slp_Item_PERIOD_MONTH.TextBoxCode_Object.ClientID); }
#endregion
#region 檢查SLP年月格式
arl_Return = CAAComm.Check_Format_YearMonth(slp_Item_PERIOD_MONTH.Text, "折讓單號：" + gvRow.Cells[3].Text + "的[申報期別]欄位年月格式錯誤", "1", slp_Item_PERIOD_MONTH.TextBoxCode_Object.ClientID, arl_Return, out b_IsRightFormat);
#endregion
#region 檢查[申報期別]
if (b_IsRightFormat == true && //代表[申報期別]年月格式正確 or [申報期別]為空值
slp_Item_PERIOD_MONTH.Text.Trim() != string.Empty &&
hid_SIGN_IS_DISABLED.Value == "0")//hid_SIGN_IS_DISABLED=0，代表是從資料庫查詢出來時，[勾選][申報]不是兩個都有勾選
{
if (s_Min_PERIOD_MONTH.CompareTo(slp_Item_PERIOD_MONTH.Text.Trim()) > 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "折讓單號：" + gvRow.Cells[3].Text + "的[申報期別]不可小於" + s_Min_PERIOD_MONTH, "1", slp_Item_PERIOD_MONTH.TextBoxCode_Object.ClientID); }
if (int.Parse(slp_Item_PERIOD_MONTH.Text) % 2 > 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "折讓單號：" + gvRow.Cells[3].Text + "的[申報期別]必須為偶數月", "1", slp_Item_PERIOD_MONTH.TextBoxCode_Object.ClientID); }
}
#endregion
}
#endregion
}
#endregion
#region 將GridView的資訊寫入TempTable
else if (s_Type == "批次更新申報期別")
{
#region 檢查SLP年月格式 & [申報期別]
#region 取出最小期別
string s_Min_PERIOD_MONTH = Cet_Min_PERIOD_MONTH();
#endregion
bool b_IsRightFormat = false;
#region 檢查[申報期別]是否有值
if (slp_PERIOD_MONTH_BATCH.Text == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[自動代入申報期別]不可為空值", "1", slp_PERIOD_MONTH_BATCH.TextBoxCode_Object.ClientID); }
#endregion
#region 檢查SLP年月格式
arl_Return = CAAComm.Check_Format_YearMonth(slp_PERIOD_MONTH_BATCH.Text, "[自動代入申報期別]欄位年月格式錯誤", "1", slp_PERIOD_MONTH_BATCH.TextBoxCode_Object.ClientID, arl_Return, out b_IsRightFormat);
#endregion
#region 檢查[申報期別]
if (b_IsRightFormat == true && //代表[申報期別]年月格式正確 or [申報期別]為空值
slp_PERIOD_MONTH_BATCH.Text.Trim() != string.Empty)
{
if (s_Min_PERIOD_MONTH.CompareTo(slp_PERIOD_MONTH_BATCH.Text.Trim()) > 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[自動代入申報期別]不可小於" + s_Min_PERIOD_MONTH, "1", slp_PERIOD_MONTH_BATCH.TextBoxCode_Object.ClientID); }
if (int.Parse(slp_PERIOD_MONTH_BATCH.Text) % 2 > 0)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[自動代入申報期別]必須為偶數月", "1", slp_PERIOD_MONTH_BATCH.TextBoxCode_Object.ClientID); }
}
#endregion
#endregion
}
#endregion
return arl_Return;
}
/// <summary>
/// 檢查條件
/// </summary>
/// <param name="s_Type"></param>
/// <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_Date(s_Array_ServerString[1], "欄位[結帳日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[2], "欄位[結帳日期]結束欄位日期格式錯誤", "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],
"date",
"欄位[結帳日期]結束欄位一定要大於或等於開始欄位",
"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,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[3],
s_Array_ServerString[4],
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
#region 檢查欄位[利潤中心]輸入的代號是否正確
if (s_Array_ServerString[7] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[利潤中心]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[8] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[利潤中心]結束欄位輸入的代號不正確", "1", string.Empty); }
#endregion
return 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
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_MONTH_CLOSE_B.Text,
this.slp_MONTH_CLOSE_E.Text,
"string",
"欄位[月結月份]結束欄位一定要大於或等於開始欄位",
"1",
txt_MONTH_CLOSE_E.ClientID,
arl_Return);
#endregion
}
#endregion
#region 檢查Between欄位[維護日期]
if (this.slp_UPDATEDATE.StartDate != string.Empty ||
this.slp_UPDATEDATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_UPDATEDATE.StartDate,
this.slp_UPDATEDATE.EndDate,
"維護日期",
"1",
txt_UPDATEDATE_B.ClientID,
txt_UPDATEDATE_E.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_UPDATEDATE.StartDate,
this.slp_UPDATEDATE.EndDate,
"date",
"欄位[維護日期]結束欄位一定要大於或等於開始欄位",
"1",
txt_UPDATEDATE_E.ClientID,
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);
#endregion
}
#endregion
return arl_Return;
}
/// <summary>
/// 檢查條件
/// </summary>
/// <param name="s_Array_ServerString"></param>
/// <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 檢查必填欄位
if (s_Array_ServerString[1] == "DATE0")
{
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[2], "text", "欄位[收票日]開始欄位為必填欄位", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[3], "text", "欄位[收票日]結束欄位為必填欄位", "1", string.Empty, arl_Return);
}
else if (s_Array_ServerString[1] == "DATE1")
{
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[4], "text", "欄位[託收日]開始欄位為必填欄位", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[5], "text", "欄位[託收日]結束欄位為必填欄位", "1", string.Empty, arl_Return);
}
else if (s_Array_ServerString[1] == "DATE2")
{
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[6], "text", "欄位[收款單號日期]開始欄位為必填欄位", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[7], "text", "欄位[收款單號日期]結束欄位為必填欄位", "1", string.Empty, arl_Return);
}
if (s_Array_ServerString[8] == "TYPE0")
{
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[9], "text", "欄位[營業所]開始欄位為必填欄位", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[10], "text", "欄位[營業所]結束欄位為必填欄位", "1", string.Empty, arl_Return);
}
else if (s_Array_ServerString[8] == "TYPE1")
{ arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[11], "text", "欄位[營業人員]為必填欄位", "1", string.Empty, arl_Return); }
else if (s_Array_ServerString[8] == "TYPE2")
{ arl_Return = CAAComm.Check_MustFillin_Column(s_Array_ServerString[12], "text", "欄位[帳務人員]為必填欄位", "1", string.Empty, arl_Return); }
#endregion
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[2], "欄位[收票日]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
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);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[7], "欄位[收款單號日期]結束欄位為必填欄位", "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[2] != string.Empty ||
s_Array_ServerString[3] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[2],
s_Array_ServerString[3],
"收票日",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[2],
s_Array_ServerString[3],
"date",
"欄位[收票日]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[託收日]
if (s_Array_ServerString[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"託收日",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"date",
"欄位[託收日]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[收款單號日期]
if (s_Array_ServerString[6] != string.Empty ||
s_Array_ServerString[7] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[6],
s_Array_ServerString[7],
"收款單號日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[6],
s_Array_ServerString[7],
"date",
"欄位[收款單號日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (s_Array_ServerString[9] != string.Empty ||
s_Array_ServerString[10] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[9],
s_Array_ServerString[10],
"營業所",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[9],
s_Array_ServerString[10],
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
#region 檢查欄位[營業所]輸入的代號是否正確
if (s_Array_ServerString[13] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業所]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[14] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業所]結束欄位輸入的代號不正確", "1", string.Empty); }
#endregion
#region 檢查欄位[營業人員]輸入的代號是否正確
if (s_Array_ServerString[15] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業人員]輸入的代號不正確", "1", string.Empty); }
#endregion
#region 檢查欄位[帳務人員]輸入的代號是否正確
if (s_Array_ServerString[16] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[帳務人員]輸入的代號不正確", "1", string.Empty); }
#endregion
return arl_Return;
}
/// <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 BUTTON [查詢]鈕
if (s_Type == "BUTTON [查詢]鈕")
{
# region 檢查SLP日期格式
if (s_Array_ServerString[12] == "____/__/__")
{ s_Array_ServerString[12] = string.Empty; }
if (s_Array_ServerString[13] == "____/__/__")
{ s_Array_ServerString[13] = string.Empty; }
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[12], "欄位[開立日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
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[15], "欄位[帳款到期日]結束欄位日期格式錯誤", "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[18], "欄位[作廢日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查SLP年月格式
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[10], "欄位[結帳年月]開始欄位年月格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_YearMonth(s_Array_ServerString[11], "欄位[結帳年月]結束欄位年月格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查SLP數字格式
arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[27], "欄位[累積沖帳金額]數字格式錯誤", "32", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[29], "欄位[應收餘額]數字格式錯誤", "32", "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[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"利潤中心",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (s_Array_ServerString[6] != string.Empty ||
s_Array_ServerString[7] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[6],
s_Array_ServerString[7],
"營業所",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[6],
s_Array_ServerString[7],
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月]
if (s_Array_ServerString[10] != string.Empty ||
s_Array_ServerString[11] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[10],
s_Array_ServerString[11],
"結帳年月",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[10],
s_Array_ServerString[11],
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[開立日期]
if (s_Array_ServerString[12] != string.Empty ||
s_Array_ServerString[13] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[12],
s_Array_ServerString[13],
"開立日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[12],
s_Array_ServerString[13],
"date",
"欄位[開立日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[帳款到期日]
if (s_Array_ServerString[14] != string.Empty ||
s_Array_ServerString[15] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[14],
s_Array_ServerString[15],
"帳款到期日",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[14],
s_Array_ServerString[15],
"date",
"欄位[帳款到期日]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[作廢日期]
if (s_Array_ServerString[17] != string.Empty ||
s_Array_ServerString[18] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[17],
s_Array_ServerString[18],
"作廢日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[17],
s_Array_ServerString[18],
"date",
"欄位[作廢日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
/// <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)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_PROFIT_NO_B.Text,
this.slp_PROFIT_NO_E.Text,
"利潤中心",
"1",
this.slp_PROFIT_NO_B.TextBox_Code.ClientID,
this.slp_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_PROFIT_NO_B.Text,
this.slp_PROFIT_NO_E.Text,
"string",
"欄位[利潤中心]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_PROFIT_NO_E.TextBox_Code.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (this.slp_Z_O_B.Text != string.Empty ||
this.slp_Z_O_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_Z_O_B.Text,
this.slp_Z_O_E.Text,
"營業所",
"1",
this.slp_Z_O_B.TextBox_Code.ClientID,
this.slp_Z_O_E.TextBox_Code.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_Z_O_B.Text,
this.slp_Z_O_E.Text,
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_Z_O_E.TextBox_Code.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[結帳年月]
if (this.slp_CLOSE_MONTH_B.Text != string.Empty ||
this.slp_CLOSE_MONTH_E.Text != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_CLOSE_MONTH_B.Text,
this.slp_CLOSE_MONTH_E.Text,
"結帳年月",
"1",
this.slp_CLOSE_MONTH_B.TextBoxCode_Object.ClientID,
this.slp_CLOSE_MONTH_E.TextBoxCode_Object.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_CLOSE_MONTH_B.Text,
this.slp_CLOSE_MONTH_E.Text,
"string",
"欄位[結帳年月]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_CLOSE_MONTH_E.TextBoxCode_Object.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[開立日期]
if (this.slp_INV_DATE.StartDate != string.Empty ||
this.slp_INV_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_INV_DATE.StartDate,
this.slp_INV_DATE.EndDate,
"開立日期",
"1",
this.slp_INV_DATE.RangeStartTextBox.ClientID,
this.slp_INV_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_INV_DATE.StartDate,
this.slp_INV_DATE.EndDate,
"string",
"欄位[開立日期]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_INV_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[帳款到期日]
if (this.slp_INV_DUE_DATE.StartDate != string.Empty ||
this.slp_INV_DUE_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_INV_DUE_DATE.StartDate,
this.slp_INV_DUE_DATE.EndDate,
"帳款到期日",
"1",
this.slp_INV_DUE_DATE.RangeStartTextBox.ClientID,
this.slp_INV_DUE_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_INV_DUE_DATE.StartDate,
this.slp_INV_DUE_DATE.EndDate,
"string",
"欄位[帳款到期日]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_INV_DUE_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
}
#endregion
#region 欄位[作廢日期]
if (this.slp_INV_CANCEL_DATE.StartDate != string.Empty ||
this.slp_INV_CANCEL_DATE.EndDate != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(this.slp_INV_CANCEL_DATE.StartDate,
this.slp_INV_CANCEL_DATE.EndDate,
"作廢日期",
"1",
this.slp_INV_CANCEL_DATE.RangeStartTextBox.ClientID,
this.slp_INV_CANCEL_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(this.slp_INV_CANCEL_DATE.StartDate,
this.slp_INV_CANCEL_DATE.EndDate,
"string",
"欄位[作廢日期]結束欄位一定要大於或等於開始欄位",
"1",
this.slp_INV_CANCEL_DATE.RangeEndTextBox.ClientID,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
return arl_Return;
}
/// <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[2], "欄位[營業日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
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[18], "欄位[建立日期]開始欄位日期格式錯誤", "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[21], "欄位[維護日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[22], "欄位[維護日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查SLP數字格式
arl_Return = CAAComm.Check_Format_Int(s_Array_ServerString[9], "欄位[交易金額]數字格式錯誤", "32", "1", string.Empty, arl_Return);
#endregion
#region 檢查欄位輸入的代號是否正確
if (s_Array_ServerString[26] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[客戶編號]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[27] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[客戶編號]結束欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[28] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[店群]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[29] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[店群]結束欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[30] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[建立人員]輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[31] == "查無資料")
{ 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欄位
#region 欄位[營業日期]
if (s_Array_ServerString[2] != string.Empty ||
s_Array_ServerString[3] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[2],
s_Array_ServerString[3],
"營業日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[2],
s_Array_ServerString[3],
"date",
"欄位[營業日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[交易日期]
if (s_Array_ServerString[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"交易日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"date",
"欄位[交易日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[交易序號]
if (s_Array_ServerString[6] != string.Empty ||
s_Array_ServerString[7] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[6],
s_Array_ServerString[7],
"交易序號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[6],
s_Array_ServerString[7],
"string",
"欄位[交易序號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[客戶編號]
if (s_Array_ServerString[10] != string.Empty ||
s_Array_ServerString[11] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[10],
s_Array_ServerString[11],
"客戶編號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[10],
s_Array_ServerString[11],
"string",
"欄位[客戶編號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[繳款識別碼]
if (s_Array_ServerString[12] != string.Empty ||
s_Array_ServerString[13] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[12],
s_Array_ServerString[13],
"繳款識別碼",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[12],
s_Array_ServerString[13],
"string",
"欄位[繳款識別碼]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[店群]
if (s_Array_ServerString[14] != string.Empty ||
s_Array_ServerString[15] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[14],
s_Array_ServerString[15],
"店群",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[14],
s_Array_ServerString[15],
"string",
"欄位[店群]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[收款單號]
if (s_Array_ServerString[16] != string.Empty ||
s_Array_ServerString[17] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[16],
s_Array_ServerString[17],
"收款單號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[16],
s_Array_ServerString[17],
"string",
"欄位[收款單號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[建立日期]
if (s_Array_ServerString[18] != string.Empty ||
s_Array_ServerString[19] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[18],
s_Array_ServerString[19],
"建立日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[18],
s_Array_ServerString[19],
"date",
"欄位[建立日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[維護日期]
if (s_Array_ServerString[21] != string.Empty ||
s_Array_ServerString[22] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[21],
s_Array_ServerString[22],
"維護日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[21],
s_Array_ServerString[22],
"date",
"欄位[維護日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
}
#endregion
#region 頁籤=專案代收明細表
else if (s_Type == "2")
{
#region 檢查必填欄位
if (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 && s_Array_ServerString[7] == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[營業日期][交易日期][收款單號日期]必須擇一輸入", "1", string.Empty); }
#endregion
#region 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[2], "欄位[營業日期]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
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);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[7], "欄位[收款單號日期]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查欄位輸入的代號是否正確
if (s_Array_ServerString[11] == "查無資料")
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[帳務人員]開始欄位輸入的代號不正確", "1", string.Empty); }
if (s_Array_ServerString[12] == "查無資料")
{ 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欄位
#region 欄位[營業日期]
if (s_Array_ServerString[2] != string.Empty ||
s_Array_ServerString[3] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[2],
s_Array_ServerString[3],
"營業日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[2],
s_Array_ServerString[3],
"date",
"欄位[營業日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[交易日期]
if (s_Array_ServerString[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"交易日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"date",
"欄位[交易日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[收款單號日期]
if (s_Array_ServerString[6] != string.Empty ||
s_Array_ServerString[7] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[6],
s_Array_ServerString[7],
"收款單號日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[6],
s_Array_ServerString[7],
"date",
"欄位[收款單號日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[帳務人員]
if (s_Array_ServerString[9] != string.Empty ||
s_Array_ServerString[10] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[9],
s_Array_ServerString[10],
"帳務人員",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[9],
s_Array_ServerString[10],
"string",
"欄位[帳務人員]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#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,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[3],
s_Array_ServerString[4],
"date",
"欄位[入帳日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[簽收日期]
if (s_Array_ServerString[5] != string.Empty ||
s_Array_ServerString[6] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[5],
s_Array_ServerString[6],
"簽收日期",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[5],
s_Array_ServerString[6],
"date",
"欄位[簽收日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[店群]
if (s_Array_ServerString[7] != string.Empty ||
s_Array_ServerString[8] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[7],
s_Array_ServerString[8],
"店群",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[7],
s_Array_ServerString[8],
"string",
"欄位[店群]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[通路]
if (s_Array_ServerString[9] != string.Empty ||
s_Array_ServerString[10] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[9],
s_Array_ServerString[10],
"通路",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[9],
s_Array_ServerString[10],
"string",
"欄位[通路]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[店號]
if (s_Array_ServerString[11] != string.Empty ||
s_Array_ServerString[12] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[11],
s_Array_ServerString[12],
"店號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[11],
s_Array_ServerString[12],
"string",
"欄位[店號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#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],
"string",
"欄位[結帳統編]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[供應商代號]
if (s_Array_ServerString[15] != string.Empty ||
s_Array_ServerString[16] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[15],
s_Array_ServerString[16],
"供應商代號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[15],
s_Array_ServerString[16],
"string",
"欄位[供應商代號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[品號]
if (s_Array_ServerString[17] != string.Empty ||
s_Array_ServerString[18] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[17],
s_Array_ServerString[18],
"品號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[17],
s_Array_ServerString[18],
"string",
"欄位[品號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[期別]
if (s_Array_ServerString[19] != string.Empty ||
s_Array_ServerString[20] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[19],
s_Array_ServerString[20],
"期別",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[19],
s_Array_ServerString[20],
"string",
"欄位[期別]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[群分類]
if (s_Array_ServerString[22] != string.Empty ||
s_Array_ServerString[23] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[22],
s_Array_ServerString[23],
"群分類",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[22],
s_Array_ServerString[23],
"string",
"欄位[群分類]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[大分類]
if (s_Array_ServerString[24] != string.Empty ||
s_Array_ServerString[25] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[24],
s_Array_ServerString[25],
"大分類",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[24],
s_Array_ServerString[25],
"string",
"欄位[大分類]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[中分類]
if (s_Array_ServerString[26] != string.Empty ||
s_Array_ServerString[27] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[26],
s_Array_ServerString[27],
"中分類",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[26],
s_Array_ServerString[27],
"string",
"欄位[中分類]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#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 檢查SLP日期格式
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[1], "欄位[調撥日期 ]開始欄位日期格式錯誤", "1", string.Empty, arl_Return);
arl_Return = CAAComm.Check_Format_Date(s_Array_ServerString[2], "欄位[調撥日期 ]結束欄位日期格式錯誤", "1", string.Empty, arl_Return);
#endregion
#region 檢查必填欄位
if (s_Array_ServerString[4] == string.Empty && s_Array_ServerString[5] == string.Empty &&
s_Array_ServerString[6] == string.Empty && s_Array_ServerString[7] == string.Empty &&
s_Array_ServerString[8] == string.Empty && s_Array_ServerString[9] == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "欄位[店群][店號][營業所][帳務人員]必須擇一輸入", "1", string.Empty); }
if (s_Array_ServerString[16] == string.Empty)
{ arl_Return = CAAComm.ToMakeUp_Err_ArrayList(arl_Return, "[筆數]要輸入", "1", string.Empty); }
if (s_Array_ServerString[16] != string.Empty && int.Parse(s_Array_ServerString[16]) < 1)
{
arl_Return[0] = string.Empty;
arl_Return[1] = "[筆數]要大於零<br/>";
}
#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],
"date",
"欄位[調撥日期]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[店群]
if (s_Array_ServerString[4] != string.Empty ||
s_Array_ServerString[5] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[4],
s_Array_ServerString[5],
"店群",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[4],
s_Array_ServerString[5],
"string",
"欄位[店群]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[營業所]
if (s_Array_ServerString[7] != string.Empty ||
s_Array_ServerString[8] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[7],
s_Array_ServerString[8],
"營業所",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[7],
s_Array_ServerString[8],
"string",
"欄位[營業所]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[品號]
if (s_Array_ServerString[12] != string.Empty ||
s_Array_ServerString[13] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[12],
s_Array_ServerString[13],
"品號",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[12],
s_Array_ServerString[13],
"string",
"欄位[品號]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#region 欄位[期別]
if (s_Array_ServerString[14] != string.Empty ||
s_Array_ServerString[15] != string.Empty)
{
#region 檢查Between欄位如果輸入其中一個欄位則另一個欄位也必須填值
arl_Return = CAAComm.Check_Between_BeginEnd_Value
(s_Array_ServerString[14],
s_Array_ServerString[15],
"期別",
"1",
string.Empty,
string.Empty,
arl_Return);
#endregion
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
arl_Return = CAAComm.Check_Between_End_GreaterThan_Begin
(s_Array_ServerString[14],
s_Array_ServerString[15],
"string",
"欄位[期別]結束欄位一定要大於或等於開始欄位",
"1",
string.Empty,
arl_Return);
#endregion
}
#endregion
#endregion
return arl_Return;
}
