Пример #1
0
    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region
        try
        {
            txt_CODE.Text = "";
            txt_NAME.Text = "";
            txt_EXPLAIN.Text = "";

            TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB);
            DataTable dt = null;
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(s_ID);
            dt = BCO.QUERY_TRN_CODE_MAIN_BY_ID(ParameterList);

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