private void QueryDUE() { CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB); ParameterList.Clear(); if (chkLike.Checked == true) ParameterList.Add("%" + txtDUE_NO.Text.Trim() + "%"); //V_DUE_NO else ParameterList.Add(txtDUE_NO.Text.Trim()); //V_DUE_NO ParameterList.Add(this.SLP_DUE_SOURCE_TYPE.Text); //V_SOURCE_TYPE ParameterList.Add(SLP_DUE_GROUP_NO.Text.Trim()); //V_GROUP_NO ParameterList.Add(SLP_DUE_STORE_ID.Text.Trim()); //V_STORE_ID ParameterList.Add(SLP_DUE_Z_O.Text.Trim()); //V_Z_O if (chkLike.Checked == true) ParameterList.Add("%" + txtDUE_RFNO.Text.Trim() + "%"); //V_RFNO else ParameterList.Add(txtDUE_RFNO.Text.Trim()); //V_RFNO ParameterList.Add(SLP_DUE_SAL_ID.Text.Trim()); //V_SAL_ID ParameterList.Add(SLP_DUE_AC_ID.Text.Trim()); //V_AC_UID ParameterList.Add(this.SLP_DUE_ROOT_NO.Text.Trim()); //V_ROOT_NO ParameterList.Add(this.ddlDUE_TAX_TYPE.SelectedValue.Trim()); //V_TAX_TYPE string strMin, strMax, strEqual; CompareSign(this.SLP_DUE_AMT.Operator, SLP_DUE_AMT.Text, out strMin, out strMax, out strEqual); ParameterList.Add(strMin); //V_DUE_AMT_S ParameterList.Add(strMax); //V_DUE_AMT_E ParameterList.Add(strEqual); //V_DUE_AMT_Equal CompareSign(this.SLP_SUM_DUE_AMT.Operator, SLP_SUM_DUE_AMT.Text, out strMin, out strMax, out strEqual); ParameterList.Add(strMin); //V_SUM_DUE_AMT_S ParameterList.Add(strMax); //V_SUM_DUE_AMT_E ParameterList.Add(strEqual); //V_SUM_DUE_AMT_Equal CompareSign(this.SLP_DUE_REMAIN_AMT.Operator, SLP_DUE_REMAIN_AMT.Text, out strMin, out strMax, out strEqual); ParameterList.Add(strMin); //V_DUE_REMAIN_AMT_S ParameterList.Add(strMax); //V_DUE_REMAIN_AMT_E ParameterList.Add(strEqual); //V_DUE_REMAIN_AMT_Equal if (chkLike.Checked == true) ParameterList.Add("%" + txtDUE_MEMO.Text.Trim() + "%"); //V_MEMO else ParameterList.Add(txtDUE_MEMO.Text.Trim()); //V_MEMO ParameterList.Add(txtDUE_CLOSE_MONTH.Text.Trim()); //V_CLOSE_MONTH ParameterList.Add(GetDateS(SLP_DUE_CREATEDATE.StartDate)); //V_CREATEDATE_S ParameterList.Add(GetDateE(SLP_DUE_CREATEDATE.EndDate)); //V_CREATEDATE_E ParameterList.Add(SLP_DUE_CREATEUID.Text.Trim()); //V_CREATEUID ParameterList.Add(GetDateS(SLP_DUE_UPDATEDATE.StartDate)); //V_UPDATEDATE_S ParameterList.Add(GetDateE(SLP_DUE_UPDATEDATE.EndDate)); //V_UPDATEDATE_E ParameterList.Add(SLP_DUE_UPDATEUID.Text.Trim()); //V_UPDATEUID Int32 iTopRownum; Int32.TryParse(TextBoxRowCountLimit.Text.Trim(), out iTopRownum); ParameterList.Add(iTopRownum.ToString()); //Like部分直接在資料庫和前台做判斷,所以不再分別呼叫不同BCO DataTable dt = BCO.QueryDueByFind(ParameterList); Session[SessionName_DT] = dt; LabelQueryRecordCount.Text = string.Format("共{0}筆", dt.Rows.Count.ToString()); if (dt.Rows.Count > 0) { GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView2.PageIndex = 0; BindData(); } else { GridView2.DataSource = null; GridView2.DataBind(); ErrorMsgLabel.Text = "查無資料"; } }
/// <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), "CAA143", s_ScriptManager_Script, true); } #endregion return; } #endregion #endregion DataTable dt; CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB); #region 傳入參數 ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.txtDUE_NO.Text, "string", false));//暫收單號 //累計調整金額等於零時 if (this.SLP_SUM_DUE_AMT.Text == "0") { //[調整餘額]是使用javascript帶入[調整金額]的數值,回server端時,再重新寫入一次 this.SLP_DUE_REMAIN_AMT.Text = this.SLP_DUE_AMT.Text; ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_SOURCE_TYPE.Text, "int", false));//型式 ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_STORE_ID.Text, "string", false));//客戶店號 ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_ROOT_NO.Text, "string", false));//商品群分類 ParameterList.Add(CAAComm.GetValueSetParameter(this.ddlTaxType.SelectedValue, "string", false));//稅別 ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_DUE_AMT.Text, "int64", false));//調整金額 ParameterList.Add(CAAComm.GetValueSetParameter(this.SLP_DUE_REMAIN_AMT.Text, "int64", false));//調整餘額 ParameterList.Add(CAAComm.GetValueSetParameter(this.txtCLOSE_MONTH.Text, "string", false));//結帳年月 } else { ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "int", false));//型式 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "string", false));//客戶店號 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "string", false));//商品群分類 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "string", false));//稅別 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "int64", false));//調整金額 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "int64", false));//調整餘額 ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "string", false));//結帳年月 } ParameterList.Add(CAAComm.GetValueSetParameter(this.txtMEMO.Text, "string", false));//備註 ParameterList.Add(CAAComm.GetValueSetParameter(DateTime.Now.ToString(), "datetime", false));//更新時間 ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//更新人員 ParameterList.Add(CAAComm.GetValueSetParameter(this.hdf_Old_UpdateDate.Value, "datetime", false));//原始更新時間 ParameterList.Add(CAAComm.GetValueSetParameter(this.hdf_Old_UpdateUID.Value, "string", false));//原始更新人員 #endregion #region 連結資料庫 int iResult = BCO.UpdateDueRecord(ParameterList, DBT); if (iResult == 0) { ErrorMsgLabel.Text = "資料更新失敗:可能是已不存在或資料已被異動過"; } else { if (ViewState["DUE_NO"] != null) { if (ViewState["SSID"] != null) Response.Redirect("CAA143.aspx?Code=CAA14&Mode=View&DUE_NO=" + txtDUE_NO.Text.Trim() + "&SSID=" + ViewState["SSID"].ToString(), false); else Response.Redirect("CAA143.aspx?Code=CAA14&Mode=View&DUE_NO=" + txtDUE_NO.Text.Trim() + "&SSID=", false); } } #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } finally { } }
private void BindData() { ErrorMsgLabel.Text = ""; CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB); ParameterList.Clear(); ParameterList.Add("");//ID ParameterList.Add(ViewState["DUE_NO"].ToString());//DUE_NO DataTable dt = BCO.QueryDetail(ParameterList); if (dt.Rows.Count > 0) { txtDUE_NO.Text = dt.Rows[0]["DUE_NO"].ToString().Trim(); SLP_SOURCE_TYPE.Text = dt.Rows[0]["SOURCE_TYPE"].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.Text = dt.Rows[0]["TAX_TYPE"].ToString().Trim(); SLP_DUE_AMT.Text = dt.Rows[0]["DUE_AMT"].ToString().Trim(); SLP_SUM_DUE_AMT.Text = dt.Rows[0]["SUM_DUE_AMT"].ToString().Trim(); SLP_DUE_REMAIN_AMT.Text = dt.Rows[0]["DUE_REMAIN_AMT"].ToString().Trim(); txtMEMO.Text = dt.Rows[0]["MEMO"].ToString().Trim(); txtCLOSE_MONTH.Text = dt.Rows[0]["CLOSE_MONTH"].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"].ToString().Trim(); hdf_Old_UpdateDate.Value = dt.Rows[0]["UPDATEDATE"].ToString().Trim(); hdf_Old_UpdateUID.Value = dt.Rows[0]["UPDATEUID"].ToString().Trim(); } else { txtDUE_NO.Text = string.Empty; SLP_SOURCE_TYPE.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.Text = string.Empty; SLP_DUE_AMT.Text = string.Empty; SLP_SUM_DUE_AMT.Text = string.Empty; SLP_DUE_REMAIN_AMT.Text = string.Empty; txtMEMO.Text = string.Empty; txtCLOSE_MONTH.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; ErrorMsgLabel.Text = "查無資料"; if (ViewState["READMODE"] != null) if (ViewState["READMODE"].ToString().Trim() == "TOOLBAR") ErrorMsgLabel.Text = "查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"; } }
/// <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), "CAA143", s_ScriptManager_Script, true); } #endregion return; } #endregion #endregion CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB); DataTable dt; ParameterList.Clear(); ParameterList.Add(SLP_SOURCE_TYPE.Text); /// (1) 來源 = SOURCE_TYPE ParameterList.Add(SLP_STORE_ID.Text.Trim()); /// (2) 客戶店號 = STORE_ID ParameterList.Add(SLP_ROOT_NO.Text.Trim()); /// (3) 商品群分類 = ROOT_NO ParameterList.Add(ddlTaxType.SelectedValue); /// (4) 稅別 = TAX_TYPE ParameterList.Add(SLP_DUE_AMT.Text); /// (5) 調整金額 = DUE_AMT ParameterList.Add(SLP_SUM_DUE_AMT.Text.Replace(",", "")); /// (6) 累計沖帳金額 = SUM_DUE_AMT this.SLP_DUE_REMAIN_AMT.Text = SLP_DUE_AMT.Text; ParameterList.Add(SLP_DUE_REMAIN_AMT.Text.Replace(",", "")); /// (7) 調整餘額 = DUE_REMAIN_AMT ParameterList.Add(txtMEMO.Text.Trim()); /// (8) 備註說明 = MEMO ParameterList.Add(txtCLOSE_MONTH.Text.Trim()); /// (9) 結帳年月 = CLOSE_MONTH ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); /// (10) 建立日期 = CREATEDATE (系統抓取目前AP機器之時間) ParameterList.Add(Session["UID"].ToString()); /// (11) 建立人員 = CREATEUID (系統抓取登入之使用者ID) string DUE_NO = ""; string ID = ""; int iResult = BCO.CreateDueRecord(ParameterList, DBT, out DUE_NO, out ID); Response.Redirect("CAA143.aspx?Code=CAA14&Mode=View&DUE_NO=" + DUE_NO, false); } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 設定編輯狀態下的各個控制項狀態 /// </summary> private void ModeSetEdit() { CAAModel.CAACommon CAAComm = new CAAModel.CAACommon(); CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB); this.ButtonModify.Visible = true; if (ViewState["DUE_NO"] != null) { BindData(); } else { ErrorMsgLabel.Text = "查無資料"; } txtDUE_NO.ReadOnly = true; txtDUE_NO.CssClass = "readtxtbox"; ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.txtDUE_NO.Text, "string", false));//應收應付單號 int wash_amt; BCO.QueryWashData(ParameterList,out wash_amt); if (wash_amt==0) { this.SLP_SOURCE_TYPE.ReadOnly = false; SLP_STORE_ID.ReadOnly = false; SLP_ROOT_NO.ReadOnly = false; ddlTaxType.Enabled = true; ddlTaxType.CssClass = ""; SLP_DUE_AMT.ReadOnly = false; SourceType_Change(); this.txtCLOSE_MONTH.ReadOnly = false; } else { this.SLP_SOURCE_TYPE.ReadOnly = true; SLP_STORE_ID.ReadOnly = true; SLP_ROOT_NO.ReadOnly = true; ddlTaxType.Enabled = false; ddlTaxType.CssClass = "readtxtbox"; SLP_DUE_AMT.ReadOnly = true; this.txtCLOSE_MONTH.ReadOnly = true; } txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; SLP_SUM_DUE_AMT.ReadOnly = true; SLP_DUE_REMAIN_AMT.ReadOnly = true; SLP_CREATEDATE.ReadOnly = true; SLP_CREATEUID.ReadOnly = true; SLP_UPDATEDATE.ReadOnly = true; SLP_UPDATEUID.ReadOnly = true; txtGROUP_NO.ReadOnly = true; txtGROUP_NO.CssClass = "readtxtbox"; txtAC_ID.ReadOnly = true; txtAC_ID.CssClass = "readtxtbox"; txtSAL_ID.ReadOnly = true; txtSAL_ID.CssClass = "readtxtbox"; txtZ_O.ReadOnly = true; txtZ_O.CssClass = "readtxtbox"; #region 設定需要驗證的控制項 this.SLP_STORE_ID.ValidationGroup = "validate_Modify";//店號 this.SLP_ROOT_NO.ValidationGroup = "validate_Modify";//商品群分類 this.cuv_TaxType.ValidationGroup = "validate_Modify";//稅別 this.SLP_DUE_AMT.ValidationGroup = "validate_Modify";//調整金額 this.txtCLOSE_MONTH.ValidationGroup = "validate_Modify";//結帳年月 #endregion }