Example #1
0
    //讀取資料
    private void LoadData(bool bNoShowMSG)
    {
        MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB);

        ParameterList.Clear();

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

        DataTable dt = BCO.QueryData(ParameterList);

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

        if (dt.Rows.Count > 0)
        {
            SLP_StoreChain1.Text = dt.Rows[0]["CHAN_NO"].ToString();
            SLP_SKU1.Text = dt.Rows[0]["ITEM"].ToString();
            SLP_ItemPeriod1.Text = dt.Rows[0]["PERIOD"].ToString();
            txtEAN_CODE.Text = dt.Rows[0]["EAN_CODE"].ToString();
            txtBARCODE.Text = dt.Rows[0]["BARCODE"].ToString();
            txtPERIOD_BARCODE.Text = dt.Rows[0]["PERIOD_BARCODE"].ToString();
            txtCHAN_CODE.Text = dt.Rows[0]["CHAN_CODE"].ToString();
            ddlDATASOURCE.SelectedIndex = int.Parse(dt.Rows[0]["DATASOURCE"].ToString()) - 1;
            txtMEMO.Text = dt.Rows[0]["MEMO"].ToString();
            hdfID.Value = dt.Rows[0]["ID"].ToString();
            hdfUPDATEDATE.Value = dt.Rows[0]["UPDATEDATE"].ToString();
            hdfUPDATEUID.Value = dt.Rows[0]["UPDATEUID"].ToString();
        }
        else
        {

            btnDel.Visible = false;
            btnEdit.Visible = false;
            ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢";
        }

    }