Beispiel #1
0
    /// <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 { }
    }