C# (CSharp) PIC.VDS2G.BSM.MKT VDS_MKT22_BCO.QUERY_UN_TAG_PMA_BY_ID Examples

Example #1

File: MKT222.aspx.cs Project: ChiangHanLung/PIC_VDS

    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region
        try
        {
            SLP_RootNo1.Text = "";
            SLP_PMA1.Text = "";

            MKTModel.VDS_MKT22_BCO BCO = new MKTModel.VDS_MKT22_BCO(ConnectionDB);
            DataTable dt = null;
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(s_ID);
            dt = BCO.QUERY_UN_TAG_PMA_BY_ID(ParameterList);

            if (dt != null && dt.Rows.Count > 0)
            {
                SLP_RootNo1.Text = dt.Rows[0]["ROOT_NO"].ToString().Trim();
                SLP_PMA1.Text = dt.Rows[0]["PMA"].ToString().Trim();
            }
            else
            {
                ErrorMsgLabel.Text = "查無資料或原始資料已被刪除";
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }