/// <summary>
/// 檢查店號
/// </summary>
/// <param name="s_Store_Id">店號</param>
/// <param name="d_Date">時間</param>
/// <returns></returns>
private bool Check_Store_Id(string s_Store_Id, DateTime d_Date)
{
bool bResult = false;
#region 傳入參數
CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
ParameterList.Clear();
ParameterList.Add(CAAComm.GetValueSetParameter(s_Store_Id, "string", false));//店號
ParameterList.Add(CAAComm.GetValueSetParameter(d_Date.ToString(), "datetime", false));//時間
ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//登入人員
#endregion
#region 連結資料庫
DataTable dt_Return = new DataTable();
CAAModel.MaintainTempRecord bco = new CAAModel.MaintainTempRecord(ConntionDB);
dt_Return = bco.GET_STORE_RELATE_DATA(ParameterList);
#endregion
#region 檢查回傳資料
if (dt_Return.Rows.Count == 1)
{ bResult = true; }
#endregion
return bResult;
}
/// <summary>
/// 檢查商品群分類代碼
/// </summary>
/// <param name="strCode"></param>
/// <returns></returns>
private bool Check_RootNo(string strCode)
{
bool bResult = false;
if (strCode != string.Empty)
{
ParameterList.Clear();
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
ParameterList.Add(strCode);
ParameterList.Add("");
DataTable Dt = BCO.GetRootData(ParameterList);
if (Dt.Rows.Count > 0)
{
bResult = true;
}
}
return bResult;
}
/// <summary>
/// 編輯模式下的[儲存]鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonModify_Click(object sender, EventArgs e)
{
try
{
#region 檢查條件
CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
ArrayList arl_Check_Condition = Check_Condition(ViewState["Mode"].ToString());
#region 如果檢查有誤，則Return
if (arl_Check_Condition[1].ToString() != string.Empty)
{
#region 錯誤訊息
this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();
#endregion
#region Focus欄位
if (arl_Check_Condition[0].ToString() != string.Empty)
{
string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "CAA142", s_ScriptManager_Script, true);
}
#endregion
return;
}
#endregion
#endregion
DataTable dt;
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
ParameterList.Clear();
ParameterList.Add(txtTEMP_NO.Text.Trim()); /// 0.TEMP_NO = @暫收單號
if ((ddlSOURCE_TYPE.SelectedValue == "4") && (this.SLP_SUM_TEMP.Text == "0"))
{
ParameterList.Add(SLP_STORE_ID.Text.Trim()); /// 1.STORE_ID = @客戶店號
ParameterList.Add(SLP_ROOT_NO.Text.Trim()); /// 2.ROOT_NO = @商品群分類
ParameterList.Add(ddlTaxType.SelectedValue); /// 3.TAX_TYPE = @稅別
ParameterList.Add(SLP_TEMPAMT.Text.Replace(",", "")); /// 4.TEMP_AMT = @暫收金額
SLP_REMAIN_AMT.Text = SLP_TEMPAMT.Text;
ParameterList.Add(SLP_REMAIN_AMT.Text.Replace(",", "")); /// 5.TEMP_REMAIN_AMT = @暫收餘額
}
else
{
ParameterList.Add(""); /// 1.STORE_ID = @客戶店號
ParameterList.Add(""); /// 2.ROOT_NO = @商品群分類
ParameterList.Add(""); /// 3.TAX_TYPE = @稅別
ParameterList.Add(""); /// 4.TEMP_AMT = @暫收金額
ParameterList.Add(""); /// 5.TEMP_REMAIN_AMT = @暫收餘額
}
ParameterList.Add(txtMEMO.Text.Trim()); /// 6.MEMO = @備註
if (rblCHG_INCOME_TYPE.Enabled == true)
{
//與秀玲確認過
//如果欄位[轉其他收入]選擇[是]，則欄位[轉其他收入日期]
//有輸入就依照輸入的日期，沒輸入就放系統日
//如果欄位[轉其他收入]選擇[否]，則欄位[轉其他收入日期]
//不管有沒有輸入，都當作null值
if (rblCHG_INCOME_TYPE.SelectedValue == "1")//是
{
ParameterList.Add(rblCHG_INCOME_TYPE.SelectedValue); /// 7.CHG_INCOME_TYPE = @轉其它收入選項
if (this.SLP_CHG_INCOME_DATE.Text == string.Empty)
{ ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd")); }
else
{ ParameterList.Add(this.SLP_CHG_INCOME_DATE.Text); }/// (12) 轉其它收入日期 = CHG_INCOME_DATE
}
else
{
ParameterList.Add(string.Empty); /// 7.CHG_INCOME_TYPE = @轉其它收入選項
ParameterList.Add(string.Empty); /// 8.CHG_INCOME_DATE = @轉其它收入日期
}
}
else
{
ParameterList.Add(""); /// 7.CHG_INCOME_TYPE = @轉其它收入選項
ParameterList.Add(""); /// 8.CHG_INCOME_DATE = @轉其它收入日期
}
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); /// 8.UPDATEDATE = (系統抓取目前AP機器之時間)
ParameterList.Add(Session["UID"].ToString()); ///9.UPDATEUID = 登入系統之使用者ID
ParameterList.Add(hdf_Old_UpdateDate.Value); ///10.原始抓資料時的UPDATEDATE
ParameterList.Add(hdf_Old_UpdateUID.Value); ///11.原始抓資料時的UPDATEUID
ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TEMP_DATE.Text, "date", false));//12.欄位[暫收日期]
string TEMP_NO = "";
string ID = "";
int iResult = BCO.UpdateTempRecord(ParameterList, DBT);
if (iResult == 0)
ErrorMsgLabel.Text = "資料更新失敗:可能是已不存在或資料已被異動過";
else
if (ViewState["TEMP_NO"] != null)
{
if (ViewState["SSID"] != null)
Response.Redirect("CAA142.aspx?Code=CAA14&Mode=View&TEMP_NO=" + txtTEMP_NO.Text.Trim() + "&SSID=" + ViewState["SSID"].ToString(), false);
else
Response.Redirect("CAA142.aspx?Code=CAA14&Mode=View&TEMP_NO=" + txtTEMP_NO.Text.Trim() + "&SSID=", false);
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// 離開[店號]時，帶出相關資料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_STORE_ID_Onblur()
{
#region 規則
/*
* 與秀玲確認過
* 抓取店號帶出相關資料的部份
* 在[新增]狀態下，要用 sysdate 作為查詢條件
* 在[編輯]狀態下，要用 createdate 作為查詢條件(編輯畫面load進來時，和使用者修改店號時都要以該筆資料的createdate為主)
* 來查出 [VDS_STM_STORE][VDS_STM_ACCOUNT_PROPERTY] 這兩個Table當時的資料
*/
#endregion
try
{
#region 新增 or 編輯 模式
CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
if (ViewState["Mode"].ToString() == "Insert" ||
ViewState["Mode"].ToString() == "Edit")
{
#region 重新將店號再寫入一次
this.SLP_STORE_ID.Text = this.SLP_STORE_ID.Text;
#endregion
if (this.SLP_STORE_ID.Text.Trim() == string.Empty)
{
#region 將欄位清空
this.txtGROUP_NO.Text = string.Empty;//店群
this.txtZ_O.Text = string.Empty;//營業所
this.txtRFNO.Text = string.Empty;//統一編號
this.txtSAL_ID.Text = string.Empty;//營業人員
this.txtAC_ID.Text = string.Empty;//帳務人員
#endregion
#region Focus欄位
string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(this.SLP_ROOT_NO.TextBox_Code.ClientID, true);
ScriptManager.RegisterStartupScript(this.up_Condition, typeof(UpdatePanel), "CAA142", s_ScriptManager_Script, true);
#endregion
}
else
{
#region 傳入參數
DateTime d_Date;
if (ViewState["Mode"].ToString() == "Insert")//新增狀態
{ d_Date = DateTime.Now; }
else//編輯狀態
{ d_Date = DateTime.Parse(this.hdf_Old_CreateDate.Value); }
ParameterList.Clear();
ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_STORE_ID.Text, "string", false));//店號
ParameterList.Add(CAAComm.GetValueSetParameter(d_Date.ToString(), "datetime", false));//時間
ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UPDATEUID
#endregion
#region 連結資料庫
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
DataTable dt_Return = BCO.GET_STORE_RELATE_DATA(ParameterList);
#endregion
#region 檢查回傳資料
if (dt_Return.Rows.Count != 1)
{
#region 將欄位清空
this.txtGROUP_NO.Text = string.Empty;//店群
this.txtZ_O.Text = string.Empty;//營業所
this.txtRFNO.Text = string.Empty;//統一編號
this.txtSAL_ID.Text = string.Empty;//營業人員
this.txtAC_ID.Text = string.Empty;//帳務人員
#endregion
#region 若發生錯誤則alert訊息(秀玲要alert訊息)
//若發生錯誤，則只要alert錯誤訊息，不要focus到[店號]欄位
string s_ScriptManager_Script = "alert('無符合店號或己關店，請重新輸入')";
ScriptManager.RegisterStartupScript(this.up_Condition, typeof(UpdatePanel), "CAA142", s_ScriptManager_Script, true);
#endregion
return;
}
#endregion
#region 將資料寫入頁面
else
{
this.txtGROUP_NO.Text = dt_Return.Rows[0]["GROUP_NO"].ToString();//店群
this.txtZ_O.Text = dt_Return.Rows[0]["Z_O"].ToString();//營業所
this.txtRFNO.Text = dt_Return.Rows[0]["RFNO"].ToString();//統一編號
this.txtSAL_ID.Text = dt_Return.Rows[0]["SAL_ID"].ToString();//營業人員
this.txtAC_ID.Text = dt_Return.Rows[0]["AC_UID"].ToString();//帳務人員
#region Focus欄位
string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(this.SLP_ROOT_NO.TextBox_Code.ClientID, true);
ScriptManager.RegisterStartupScript(this.up_Condition, typeof(UpdatePanel), "CAA142", s_ScriptManager_Script, true);
#endregion
}
#endregion
}
}
#endregion
#region 如果不符合以上條件，代表錯誤
else { throw new Exception("頁面資料錯誤，只有在[新增 or 編輯模式]下，才有欄位[店號]Onblur事件"); }
#endregion
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// 新增模式下的[儲存]鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonNew_Click(object sender, EventArgs e)
{
try
{
#region 檢查條件
CAAModel.CAACommon CAAComm = new CAAModel.CAACommon();
ArrayList arl_Check_Condition = Check_Condition(ViewState["Mode"].ToString());
#region 如果檢查有誤，則Return
if (arl_Check_Condition[1].ToString() != string.Empty)
{
#region 錯誤訊息
this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString();
#endregion
#region Focus欄位
if (arl_Check_Condition[0].ToString() != string.Empty)
{
string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "CAA142", s_ScriptManager_Script, true);
}
#endregion
return;
}
#endregion
#endregion
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
DataTable dt;
ParameterList.Clear();
ParameterList.Add(ddlSOURCE_TYPE.SelectedValue); /// (1) 來源 = SOURCE_TYPE
ParameterList.Add(txtSOURCE_NO.Text.Trim()); /// (2) 來源單號 = SOURCE_NO
ParameterList.Add(SLP_STORE_ID.Text.Trim()); /// (3) 客戶店號 = STORE_ID
ParameterList.Add(SLP_ROOT_NO.Text.Trim()); /// (4)商品群分類 = ROOT_NO
ParameterList.Add(ddlTaxType.SelectedValue); /// (5)稅別 = TAX_TYPE
ParameterList.Add(SLP_TEMPAMT.Text.Replace(",", "")); /// (6) 暫收金額 = TEMP_AMT
this.SLP_REMAIN_AMT.Text = SLP_TEMPAMT.Text;
ParameterList.Add(SLP_REMAIN_AMT.Text.Replace(",", "")); /// (8) 暫收餘額 = TEMP_REMAIN_AMT
ParameterList.Add(txtMEMO.Text.Trim()); /// (9) 備註說明 = MEMO
ParameterList.Add(txtCLOSE_MONTH.Text.Trim()); /// (10) 結帳年月 = CLOSE_MONTH
ParameterList.Add(rblCHG_INCOME_TYPE.SelectedValue); /// (11) 轉其它收入 = CHG_INCOME_TYPE
//與秀玲確認過
//如果欄位[轉其他收入]選擇[是]，則欄位[轉其他收入日期]
//有輸入就依照輸入的日期，沒輸入就放系統日
//如果欄位[轉其他收入]選擇[否]，則欄位[轉其他收入日期]
//不管有沒有輸入，都當作null值
if (this.rblCHG_INCOME_TYPE.SelectedValue == "1")//是
{
if (this.SLP_CHG_INCOME_DATE.Text == string.Empty)
{ ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd")); }
else
{ ParameterList.Add(this.SLP_CHG_INCOME_DATE.Text); }/// (12) 轉其它收入日期 = CHG_INCOME_DATE
}
else if (this.rblCHG_INCOME_TYPE.SelectedValue == "0")//否
{ ParameterList.Add(string.Empty); }
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); /// (13) 建立日期 = CREATEDATE (系統抓取目前AP機器之時間)
ParameterList.Add(Session["UID"].ToString()); /// (14) 建立人員 = CREATEUID (系統抓取登入之使用者ID)
ParameterList.Add(this.slp_TEMP_DATE.Text); /// (15) 暫收日期 = TEMP_DATE
string TEMP_NO = "";
string ID = "";
int iResult = BCO.CreateTempRecord(ParameterList, DBT, out TEMP_NO, out ID);
Response.Redirect("CAA142.aspx?Code=CAA14&Mode=View&TEMP_NO=" + TEMP_NO, false);
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
}
private void BindData()
{
ErrorMsgLabel.Text = "";
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
ParameterList.Clear();
ParameterList.Add("");//ID
ParameterList.Add(ViewState["TEMP_NO"].ToString()); //TEMP_NO
DataTable dt = BCO.QueryDetail(ParameterList);
if (dt.Rows.Count > 0)
{
txtTEMP_NO.Text = dt.Rows[0]["TEMP_NO"].ToString().Trim();
ddlSOURCE_TYPE.SelectedValue = dt.Rows[0]["SOURCE_TYPE"].ToString().Trim();
txtSOURCE_NO.Text = dt.Rows[0]["SOURCE_NO"].ToString().Trim();
txtGROUP_NO.Text = dt.Rows[0]["GROUP_NO"].ToString().Trim();
SLP_STORE_ID.Text = dt.Rows[0]["STORE_ID"].ToString().Trim();
txtZ_O.Text = dt.Rows[0]["Z_O"].ToString().Trim();
txtRFNO.Text = dt.Rows[0]["RFNO"].ToString().Trim();
txtSAL_ID.Text = dt.Rows[0]["SAL_ID"].ToString().Trim();
txtAC_ID.Text = dt.Rows[0]["AC_UID"].ToString().Trim();
SLP_ROOT_NO.Text = dt.Rows[0]["ROOT_NO"].ToString().Trim();
ddlTaxType.SelectedValue = dt.Rows[0]["TAX_TYPE"].ToString().Trim();
this.slp_TEMP_DATE.Text = dt.Rows[0]["TEMP_DATE"].ToString().Trim();
SLP_TEMPAMT.Text = dt.Rows[0]["TEMP_AMT"].ToString().Trim();
SLP_SUM_TEMP.Text = dt.Rows[0]["SUM_TEMP_AMT"].ToString().Trim();
SLP_REMAIN_AMT.Text = dt.Rows[0]["TEMP_REMAIN_AMT"].ToString().Trim();
txtMEMO.Text = dt.Rows[0]["MEMO"].ToString().Trim();
txtCLOSE_MONTH.Text = dt.Rows[0]["CLOSE_MONTH"].ToString().Trim();
rblCHG_INCOME_TYPE.SelectedValue = dt.Rows[0]["CHG_INCOME_TYPE"].ToString().Trim();
SLP_CHG_INCOME_DATE.Text = dt.Rows[0]["CHG_INCOME_DATE"].ToString().Trim();
SLP_CREATEDATE.Text = dt.Rows[0]["CREATEDATE"].ToString().Trim();
SLP_CREATEUID.Text = dt.Rows[0]["CREATEUID"].ToString().Trim();
SLP_UPDATEDATE.Text = dt.Rows[0]["UPDATEDATE"].ToString().Trim();
SLP_UPDATEUID.Text = dt.Rows[0]["UPDATEUID"].ToString().Trim();
hdf_Old_CreateDate.Value = dt.Rows[0]["CREATEDATE_S"].ToString().Trim();
hdf_Old_UpdateDate.Value = dt.Rows[0]["UPDATEDATE"].ToString().Trim();
hdf_Old_UpdateUID.Value = dt.Rows[0]["UPDATEUID"].ToString().Trim();
this.hid_WASH_STATUS.Value = dt.Rows[0]["WASH_STATUS"].ToString().Trim();
}
else
{
txtTEMP_NO.Text = string.Empty;
ddlSOURCE_TYPE.SelectedIndex = 0;
txtSOURCE_NO.Text = string.Empty;
txtGROUP_NO.Text = string.Empty;
SLP_STORE_ID.Text = string.Empty;
txtZ_O.Text = string.Empty;
txtRFNO.Text = string.Empty;
txtSAL_ID.Text = string.Empty;
txtAC_ID.Text = string.Empty;
SLP_ROOT_NO.Text = string.Empty;
ddlTaxType.SelectedIndex = 0;
this.slp_TEMP_DATE.Text = string.Empty;
SLP_TEMPAMT.Text = string.Empty;
SLP_SUM_TEMP.Text = string.Empty;
SLP_REMAIN_AMT.Text = string.Empty;
txtMEMO.Text = string.Empty;
txtCLOSE_MONTH.Text = string.Empty;
rblCHG_INCOME_TYPE.SelectedIndex = 0;
SLP_CHG_INCOME_DATE.Text = string.Empty;
SLP_CREATEDATE.Text = string.Empty;
SLP_CREATEUID.Text = string.Empty;
SLP_UPDATEDATE.Text = string.Empty;
SLP_UPDATEUID.Text = string.Empty;
hdf_Old_CreateDate.Value = string.Empty;
hdf_Old_UpdateDate.Value = string.Empty;
hdf_Old_UpdateUID.Value = string.Empty;
this.hid_WASH_STATUS.Value = string.Empty;
ErrorMsgLabel.Text = "查無資料";
if (ViewState["READMODE"] != null)
if (ViewState["READMODE"].ToString().Trim() == "TOOLBAR")
ErrorMsgLabel.Text = "查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!";
}
}
/// <summary>
/// LOAD 資料
/// </summary>
private void Init_Data()
{
hdf_ID_TEMP_AMT.Value = ((TextBox)this.SLP_TEMPAMT.FindControl("TextBoxCode")).ClientID;
hdf_ID_TEMP_REMAIN_AMT.Value = ((TextBox)this.SLP_REMAIN_AMT.FindControl("TextBoxCode")).ClientID;
//設定[來源]欄位
ddlSOURCE_TYPE.Items.Clear();
ddlSOURCE_TYPE.Items.Add(new ListItem("ALL", ""));
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
DataTable dt;
dt = BCO.GetSourceType();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlSOURCE_TYPE.Items.Add(new ListItem(dt.Rows[i]["ENUMTYPENAME"].ToString(), dt.Rows[i]["ENUMVALUE"].ToString()));
}
ddlSOURCE_TYPE.SelectedIndex = 0;
//設定[轉其他收入]欄位
rblCHG_INCOME_TYPE.Items.Clear();
rblCHG_INCOME_TYPE.Items.Add(new ListItem("是", "1"));
rblCHG_INCOME_TYPE.Items.Add(new ListItem("否", "0"));
rblCHG_INCOME_TYPE.SelectedIndex = 1;
//設定[稅別]欄位
CAAModel.RecordingInvoiceDetail BCO2 = new CAAModel.RecordingInvoiceDetail(ConntionDB);
DataTable dt2;
dt2 = BCO2.GetTaxType();
ddlTaxType.Items.Add(new ListItem("", ""));
for (int i = 0; i < dt2.Rows.Count; i++)
{
ddlTaxType.Items.Add(new ListItem(dt2.Rows[i]["ENUMTYPENAME"].ToString(), dt2.Rows[i]["ENUMVALUE"].ToString()));
}
ddlTaxType.SelectedIndex = 0;
ModeSetLoad();
}
private void QueryTemp()
{
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
ParameterList.Clear();
if (chkLike.Checked == true)
ParameterList.Add("%" + txtTEMP_NO.Text.Trim() + "%"); //V_TEMP_NO
else
ParameterList.Add(txtTEMP_NO.Text.Trim()); //V_TEMP_NO
ParameterList.Add(ddlSOURCE_TYPE.SelectedValue); //V_SOURCE_TYPE
if (chkLike.Checked == true)
ParameterList.Add("%" + txtSOURCE_NO.Text.Trim() + "%"); //V_SOURCE_NO
else
ParameterList.Add(txtSOURCE_NO.Text.Trim()); //V_SOURCE_NO
ParameterList.Add(SLP_GROUP_NO.Text.Trim()); //V_GROUP_NO
ParameterList.Add(SLP_STORE_ID.Text.Trim()); //V_STORE_ID
ParameterList.Add(SLP_Z_O.Text.Trim()); //V_Z_O
if (chkLike.Checked == true)
ParameterList.Add("%" + txtRFNO.Text.Trim() + "%"); //V_RFNO
else
ParameterList.Add(txtRFNO.Text.Trim()); //V_RFNO
ParameterList.Add(SLP_SAL_ID.Text.Trim()); //V_SAL_ID
ParameterList.Add(SLP_AC_ID.Text.Trim()); //V_AC_UID
string strMin, strMax, strEqual;
CompareSign(SLP_TEMPAMT.Operator, SLP_TEMPAMT.Text, out strMin, out strMax, out strEqual);
ParameterList.Add(strMin); //V_TEMP_AMT_S
ParameterList.Add(strMax); //V_TEMP_AMT_E
ParameterList.Add(strEqual); //V_TEMP_AMT_Equal
CompareSign(SLP_SUM_TEMP.Operator, SLP_SUM_TEMP.Text, out strMin, out strMax, out strEqual);
ParameterList.Add(strMin); //V_SUM_TEMP_AMT_S
ParameterList.Add(strMax); //V_SUM_TEMP_AMT_E
ParameterList.Add(strEqual); //V_SUM_TEMP_AMT_Equal
CompareSign(SLP_REMAIN_AMT.Operator, SLP_REMAIN_AMT.Text, out strMin, out strMax, out strEqual);
ParameterList.Add(strMin); //V_TEMP_REMAIN_AMT_S
ParameterList.Add(strMax); //V_TEMP_REMAIN_AMT_E
ParameterList.Add(strEqual); //V_TEMP_REMAIN_AMT_Equal
if (chkLike.Checked == true)
ParameterList.Add("%" + txtMEMO.Text.Trim() + "%"); //V_MEMO
else
ParameterList.Add(txtMEMO.Text.Trim()); //V_MEMO
ParameterList.Add(txtCLOSE_MONTH.Text.Trim()); //V_CLOSE_MONTH
ParameterList.Add(rblCHG_INCOME_TYPE.SelectedValue); //V_CHG_INCOME_TYPE
ParameterList.Add(GetDateS(SLP_CHG_INCOME_DATE.StartDate)); //V_CHG_INCOME_DATE_S
ParameterList.Add(GetDateE(SLP_CHG_INCOME_DATE.EndDate)); //V_CHG_INCOME_DATE_E
ParameterList.Add(GetDateS(SLP_CREATEDATE.StartDate)); //V_CREATEDATE_S
ParameterList.Add(GetDateE(SLP_CREATEDATE.EndDate)); //V_CREATEDATE_E
ParameterList.Add(SLP_CREATEUID.Text.Trim()); //V_CREATEUID
ParameterList.Add(GetDateS(SLP_UPDATEDATE.StartDate)); //V_UPDATEDATE_S
ParameterList.Add(GetDateE(SLP_UPDATEDATE.EndDate)); //V_UPDATEDATE_E
ParameterList.Add(SLP_UPDATEUID.Text.Trim()); //V_UPDATEUID
Int32 iTopRownum;
Int32.TryParse(TextBoxRowCountLimit.Text.Trim(), out iTopRownum);
ParameterList.Add(iTopRownum.ToString());
ParameterList.Add(this.SLP_TEMP_DATE.StartDate);
ParameterList.Add(this.SLP_TEMP_DATE.EndDate);
ParameterList.Add(txtCLOSE_MONTH_ACCT.Text.Trim()); //V_CLOSE_MONTH_ACCT 20130705 rika add
//Like部分直接在資料庫和前台做判斷,所以不再分別呼叫不同BCO
DataTable dt = BCO.QueryTempByFind(ParameterList);
Session[SessionName_DT] = dt;
LabelQueryRecordCount.Text = string.Format("共{0}筆", dt.Rows.Count.ToString());
if (dt.Rows.Count > 0)
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
BindData();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
ErrorMsgLabel.Text = "查無資料";
}
}
private void Set_Soure_Type(DropDownList ddlTemp)
{
ddlTemp.Items.Clear();
ddlTemp.Items.Add(new ListItem("ALL", ""));
CAAModel.MaintainTempRecord BCO = new CAAModel.MaintainTempRecord(ConntionDB);
DataTable dt;
dt = BCO.GetSourceType();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlTemp.Items.Add(new ListItem(dt.Rows[i]["ENUMTYPENAME"].ToString(), dt.Rows[i]["ENUMVALUE"].ToString()));
}
ddlTemp.SelectedIndex = 0;
}
