Beispiel #1
0
    //讀取在途單資料
    private void LoadOnWayData(bool bNoShowMSG)
    {
        MaintainGoodsInTransit BCO = new MaintainGoodsInTransit(ConntionDB);

        ParameterList.Clear();

        ParameterList.Add(ViewState["ONWAY_NO"].ToString().Trim());

        DataTable dt = BCO.QueryMain(ParameterList);

        ErrorMsgLabel.Text = "";
        if (bNoShowMSG == false)
        {
            if (!string.IsNullOrEmpty(Request.QueryString["MSG"]))
            {
                if (Request.QueryString["MSG"].ToString() == "SAVE")
                {
                    ErrorMsgLabel.Text = "儲存完成<BR />";
                }
                if (Request.QueryString["MSG"].ToString() == "CLOSE")
                {
                    ErrorMsgLabel.Text = "結案完成<BR />";
                }
            }
        }

        if (dt.Rows.Count > 0)
        {
            txtONWAY_NO.Text = dt.Rows[0]["ONWAY_NO"].ToString().Trim();
            txtONWAY_DATE.Text = dt.Rows[0]["ONWAY_DATE"].ToString().Trim();
            txtUPDATEDATE.Text = dt.Rows[0]["UPDATEDATE"].ToString().Trim().Substring(0, 10);
            hdfOLD_UPDATEDATE.Value = dt.Rows[0]["UPDATEDATE"].ToString().Trim();
            txtPURCHASE_NO.Text = dt.Rows[0]["PURCHASE_NO"].ToString().Trim();
            SLP_VendorBase1.Text = dt.Rows[0]["Vendor"].ToString().Trim();
            SLP_UPDATEUID.Text = dt.Rows[0]["UPDATEUID"].ToString().Trim();

            if (dt.Rows[0]["STATUS"].ToString().Trim() == "75")
                txtStatus.Text = "已結案";
            else
                txtStatus.Text = "未結案";

            int iItems = QueryOnWayDetail(ViewState["ONWAY_NO"].ToString().Trim());
            int iGifts = QueryOnWayGift(ViewState["ONWAY_NO"].ToString().Trim());

            //檢查日結           
            //CheckVendorAccountClose BCO_CHECK = new CheckVendorAccountClose(ConntionDB);
            //if (BCO_CHECK.CheckVendorCloseStaus(DateTime.Now.ToString("yyyyMMdd")) == "1")
            //{
            //    btnDel.Visible = false;
            //    btnEdit.Visible = false;
            //    btnClose.Visible = false;
            //    ErrorMsgLabel.Text += "在途日 " + DateTime.Now.ToString("yyyyMMdd") + " 已日結,不可新增在途單。<BR>";

            //}
            if ((iItems == 1) || (iGifts == 1))
            {
                btnDel.Visible = false;
                //btnEdit.Visible = false;
                //btnClose.Visible = false;             
                if (ViewState["Mode"].ToString() == "View")
                    ErrorMsgLabel.Text += "”明細已有結案”不可刪除。<BR>";
            }
            if (txtStatus.Text == "已結案")
            {
                btnDel.Visible = false;
                btnEdit.Visible = false;
                btnClose.Visible = false;
                ErrorMsgLabel.Text = "在途單已結案不能再修改及刪除。<BR>";
            }
            GV_Visible(true);
        }
        else
        {
            txtONWAY_NO.Text = ViewState["ONWAY_NO"].ToString().Trim();
            txtONWAY_DATE.Text = "";
            txtUPDATEDATE.Text = "";
            txtPURCHASE_NO.Text = "";
            SLP_VendorBase1.Text = "";
            SLP_UPDATEUID.Text = "";
            txtStatus.Text = "";
            btnDel.Visible = false;
            btnEdit.Visible = false;
            btnClose.Visible = false;
            btnPrint.Visible = false;
            GV_Visible(false);
            ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢";
        }

    }