示例#1
0
    /// <summary>
    /// 折讓項目,欄位[發票號碼]TextChanged事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void txt_Disc_INV_NO_TextChanged(object sender, EventArgs e)
    {
        try
        {
            #region 新增模式 & 檢視模式

            if (this.hid_PageStatus.Value == "insert" ||
                this.hid_PageStatus.Value == "edit")
            {
                #region 設定變數

                BCO.CAACommon CAAComm = new BCO.CAACommon();

                #endregion

                #region 檢查傳入欄位[發票號碼]的值

                if (this.txt_Disc_INV_NO.Text.Trim() == string.Empty)
                {
                    Set_Disc_NewItem_Default();
                    return;
                }

                #endregion

                #region 若輸入的發票號碼存在於按折讓開立查出的資料

                bool b_IsExist_GetDiscInv = Set_Disc_NewItem_Value(this.txt_Disc_INV_NO.Text, dt_NewItem);

                #endregion

                #region 若輸入的發票號碼不存在於按折讓開立查出的資料

                if (b_IsExist_GetDiscInv == false)
                {
                    #region 傳入參數

                    ParameterList.Clear();
                    ParameterList.Add(CAAComm.GetValueSetParameter("TEXT", "string", false));//[查詢型態]
                    if (this.hid_PageStatus.Value == "insert")
                    { ParameterList.Add(CAAComm.GetValueSetParameter(DateTime.Now.ToString(), "date", false)); }
                    else if (this.hid_PageStatus.Value == "edit")
                    { ParameterList.Add(CAAComm.GetValueSetParameter(this.hid_Record_Date.Value, "date", false)); }//[履歷時間]
                    ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID.Text, "string", false));//[店號]
                    ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_RFNO.Text, "string", false));//[統一編號]
                    ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_ROOT_NO.Text, "string", false));//[商品群分類]
                    ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TAX_TYPE.Text, "int", false));//[稅別]
                    ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_Disc_INV_NO.Text, "string", false));//[發票號碼]
                    ParameterList.Add(CAAComm.GetValueSetParameter("1", "int", false));//只取第1筆
                    ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UPDATEUID

                    #endregion

                    #region 連結資料庫

                    BCO.MaintainDiscRecord bco = new BCO.MaintainDiscRecord(ConntionDB);
                    DataTable dt_Return = bco.GetDetailRecord(ParameterList);

                    #endregion

                    #region 檢查回傳資料

                    #region 如果沒資料

                    if (dt_Return.Rows.Count == 0)
                    {
                        this.ErrorMsgLabel2.Text = "查無發票號碼:" + this.txt_Disc_INV_NO.Text + "的相關資料";
                        Set_Disc_NewItem_Default();
                    }

                    #endregion

                    #region 如果有資料

                    else
                    {
                        Set_Disc_NewItem_Value(this.txt_Disc_INV_NO.Text, dt_Return);

                        #region 使用XML,將資料放置到前端

                        xml_VDS_CAA_INV_MAIN_Data.InnerHtml = dt_Return.DataSet.GetXml();

                        #endregion

                        #region Focus欄位

                        string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(slp_Disc_DISC_UAMT.TextBox_Code.ClientID, true);
                        ScriptManager.RegisterStartupScript(this.up_DiscItem, typeof(UpdatePanel), "CAA182", s_ScriptManager_Script, true);

                        #endregion
                    }

                    #endregion

                    #endregion
                }
                else
                {
                    #region Focus欄位

                    string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(slp_Disc_DISC_UAMT.TextBox_Code.ClientID, true);
                    ScriptManager.RegisterStartupScript(this.up_DiscItem, typeof(UpdatePanel), "CAA182", s_ScriptManager_Script, true);

                    #endregion
                }

                #endregion
            }

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel2.Text = ex.Message;
        }
        finally { Finally_Function(); }
    }
示例#2
0
    /// <summary>
    /// BUTTON [折讓開立]鈕
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void but_GetDiscInv_Click(object sender, EventArgs e)
    {
        try
        {
            #region 新增狀態

            if (this.hid_PageStatus.Value == "insert")
            {
                #region 檢查條件

                BCO.CAACommon CAAComm = new BCO.CAACommon();
                ArrayList arl_Check_Condition = Check_Condition("BUTTON [折讓開立]鈕");

                #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.up_Msg, typeof(UpdatePanel), "CAA182", s_ScriptManager_Script, true);
                    }

                    #endregion

                    return;
                }

                #endregion

                #endregion

                #region 清空變數

                if (dt_NewItem != null)
                { dt_NewItem.Clear(); }

                #endregion

                #region 清空新增項目

                #region 將新增項目的Panel關閉

                this.panel_Disc_NewItem.Visible = false;

                #endregion

                #region 設定新增項目的初始狀態

                Set_Disc_NewItem_Default();

                #endregion

                #endregion

                #region 傳入參數

                ParameterList.Clear();
                ParameterList.Add(CAAComm.GetValueSetParameter("BUTTON", "string", false));//[查詢型態]
                ParameterList.Add(CAAComm.GetValueSetParameter(DateTime.Now.ToString(), "date", false));//[履歷時間]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID.Text, "string", false));//[店號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_RFNO.Text, "string", false));//[統一編號]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_ROOT_NO.Text, "string", false));//[商品群分類]
                ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_TAX_TYPE.Text, "int", false));//[稅別]
                ParameterList.Add(CAAComm.GetValueSetParameter(string.Empty, "string", false));//[發票號碼]
                ParameterList.Add(CAAComm.GetValueSetParameter("100", "int", false));//只取前100筆
                ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//V_LOG_UPDATEUID

                #endregion

                #region 連結資料庫

                BCO.MaintainDiscRecord bco = new BCO.MaintainDiscRecord(ConntionDB);
                dt_NewItem = bco.GetDetailRecord(ParameterList);

                #endregion

                #region 資料與GridView繫結

                this.gv_DiscInv.DataSource = dt_NewItem;
                this.gv_DiscInv.PageSize = 10;//設定一頁10筆資料
                this.gv_DiscInv.PageIndex = 0;
                this.gv_DiscInv.DataBind();

                #endregion

                #region 檢查回傳資料

                #region 不管有沒有資料,[新增項目]鈕都要可以按

                this.but_Disc_NewItem.Enabled = true;

                #endregion

                #region 計算欄位[折讓金額(未稅)][折讓稅額][總金額]

                int i_txt_DISC_UAMT = 0;//折讓金額(未稅)
                int i_txt_DISC_TAX = 0;//折讓稅額
                int i_txt_DISC_AMT = 0;//含稅金額

                foreach (DataRow dr_Count in dt_NewItem.Rows)
                {
                    i_txt_DISC_UAMT += int.Parse(dr_Count["DISC_UAMT"].ToString());//折讓金額(未稅)
                    i_txt_DISC_TAX += int.Parse(dr_Count["DISC_TAX"].ToString());//折讓稅額
                    i_txt_DISC_AMT += int.Parse(dr_Count["DISC_AMT"].ToString());//含稅金額
                }

                this.slp_DISC_UAMT.Text = i_txt_DISC_UAMT.ToString();//折讓金額(未稅)
                this.slp_DISC_TAX.Text = i_txt_DISC_TAX.ToString();//折讓稅額
                this.slp_DISC_AMT.Text = i_txt_DISC_AMT.ToString();//總金額

                #endregion

                #region 將畫面鎖起來

                this.slp_DISC_FORM.ReadOnly = true;//格式代號
                this.slp_STORE_ID.ReadOnly = true;//店號
                this.slp_DISC_TYPE.ReadOnly = true;//型式
                this.slp_ROOT_NO.ReadOnly = true;//商品群分類
                this.slp_TAX_TYPE.ReadOnly = true;//稅別
                this.txt_ACT_DISC_NO.ReadOnly = true;//財會折讓單號
                this.txt_ACT_DISC_NO.CssClass = "readtxtbox";
                this.slp_CHG_DISC_DATE.ReadOnly = true;//異動折讓日期
                this.chb_PROOF_FLG.Enabled = false;//憑證已回
                this.slp_PROOF_DATE.ReadOnly = true;//憑證已回日期
                this.chb_REPROOF_FLG.Enabled = false;//取具進項憑証
                this.txt_REPROOF_NO.ReadOnly = true;//發票號碼/收據
                this.txt_REPROOF_NO.CssClass = "readtxtbox";
                this.chb_RECEIPT_FLG.Enabled = false;//取具收據
                this.slp_CLOSE_MONTH.ReadOnly = true;//結帳年月
                this.txt_MEMO.ReadOnly = true;//備註
                this.txt_MEMO.CssClass = "readtxtbox";

                #endregion

                #endregion
            }

            #endregion
        }
        catch (Exception ex)
        {
            WaringLogProcess(ex.Message);
            this.ErrorMsgLabel.Text = ex.Message;
        }
        finally
        { Finally_Function(); }
    }