/// <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; }