//停止往來計算(檢核) protected void STOP_COUNT_Check() { try { TextBox tb = (TextBox)slpSTOP_DATE.FindControl("TextBoxCode"); if (slpSTOP_DATE.Text.Trim().Length == 0) { string sc = "alert('請輸入停止往來日');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (DateTime.Parse(slpSTOP_DATE.Text) < DateTime.Parse(slpRESUME_DATE_B.Text) || DateTime.Parse(slpSTOP_DATE.Text) > DateTime.Parse(slpRESUME_DATE_E.Text)) { string sc = "alert('停止往來日必須介於履歷起始日與履歷結束日中間');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } //找出最大的結帳年月 BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB); string maxYM = bco.QueryMaxYM(); if (maxYM == "") { ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('無結帳年月,請重新輸入');", true); return; } if (DateTime.Parse(slpSTOP_DATE.Text) <= DateTime.Parse(maxYM.Substring(0, 4) + "/" + maxYM.Substring(4, 2) + "/26")) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('輸入的日期已結過帳,請重新輸入');", true); return; } if (DateTime.Parse(slpSTOP_DATE.Text) < DateTime.Today) { string sc = "if(confirm('您所輸入的停止往來日小於系統日期,是否仍確定更新?')){this.disabled=true;__doPostBack('STOP_COUNT','');} else {"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);}"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } STOP_COUNT(); UpdatePanel2.Update(); } catch (Exception ex) { lblErrMsg1.Text = "帳款往來計算不成功 !! " + ex.Message; UpdatePanel2.Update(); } }
//追溯計算(檢核) protected void RE_COUNT_Check() { try { if (slpTRACE_DATE_B.Text.Trim().Length < 6) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; if (slpTRACE_DATE_B.Text.Trim().Length == 0) sc = "alert('請輸入追溯年月(起)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (slpTRACE_DATE_E.Text.Trim().Length < 6) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; if (slpTRACE_DATE_E.Text.Trim().Length == 0) sc = "alert('請輸入追溯年月(迄)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } string trace1 = slpTRACE_DATE_B.Text.Substring(0, 4) + "/" + slpTRACE_DATE_B.Text.Substring(4, 2) + "/01"; string trace2 = slpTRACE_DATE_E.Text.Substring(0, 4) + "/" + slpTRACE_DATE_E.Text.Substring(4, 2) + "/01"; DateTime dt; if (!DateTime.TryParse(trace1, out dt)) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (!DateTime.TryParse(trace2, out dt)) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (DateTime.Parse(trace1) > DateTime.Parse(trace2)) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('追溯年月(起)不可大於追溯年月(迄)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (DateTime.Parse(trace2).Year > DateTime.Today.Year) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('追溯年月(迄)不可大於系統年月,請重新設定');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (DateTime.Parse(trace2).Year == DateTime.Today.Year && DateTime.Parse(trace2).Month > DateTime.Today.Month) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('追溯年月(迄)不可大於系統年月,請重新設定');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } if (txtYEAR_MONTH.Text.Trim().Length < 6) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; if (txtYEAR_MONTH.Text.Trim().Length == 0) sc = "alert('請輸入追溯掛帳年月');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } string trace3 = txtYEAR_MONTH.Text.Substring(0, 4) + "/" + txtYEAR_MONTH.Text.Substring(4, 2) + "/01"; if (!DateTime.TryParse(trace3, out dt)) { TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string sc = "alert('請輸入正確之日期格式(YYYY/MM)');"; sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true); return; } //找出最大的結帳年月 BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB); string maxYM = bco.QueryMaxYM(); if (!(string.Compare(txtYEAR_MONTH.Text, maxYM) > 0)) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('該合約已結帳至" + maxYM + "月,請重新輸入掛帳年月');", true); return; } TextBox Tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"); string Sc = @"if(confirm('避免供應商追溯金額為負值,請再度確認掛帳年月,以免產生負值的各項扣款報表,是否確定進行追溯?')){this.disabled=true;__doPostBack('RE_COUNT','');} else {"; Sc += @"window.setTimeout(function set_focus(){document.all['" + Tb.ClientID + "'].focus();document.all['" + Tb.ClientID + "'].select();}, 1800);}"; //string Sc = @"if(confirm('避免供應商追溯金額為負值,請再度確認掛帳年月,以免產生負值的各項扣款報表,是否確定進行追溯?')){this.disabled=true;__doPostBack('RE_COUNT','');}"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", Sc, true); UpdatePanel2.Update(); } catch (Exception ex) { lblErrMsg1.Text = "帳款追溯不成功 !! " + ex.Message; //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "btnSTOP_COUNT_fail", "alert('帳款追溯不成功 !! " + ex.Message + "');", true); UpdatePanel2.Update(); } }