C# Connect类代码示例

 // Use this for initialization
 void Awake()
 {
     score = 0;
     scoreEditor = 0;
     scorePanel = GetComponent<Text>();
     server = GameObject.FindGameObjectWithTag("Server").GetComponent<Connect>();
 }

 /// <summary>
 /// This method fetches the list of branches from the database.
 /// </summary>
 /// <returns>It returns a data set containing the list of branches.</returns>
 public static DataSet GetAllBranches()
 {
     sql = "SELECT * FROM Branches";
     Connect.ConnectTT();
     c = new Connect(sql);
     return c.ds;
 }

    public override void erlReceive(Connect connect, ErlKVMessage message)
    {
        if (!MiniConnectManager.IsRobot )
        {
            try
            {

               // Log.debug("===============this is socketReceive! cmd=" + message.Cmd + " jsonString " + message.toJsonString(),true);
            }
            catch (Exception exception)
            {
                //Log.debug(" =================== : " + exception.ToString(),true);
            }
        }
        string cmd = message.Cmd;
        switch (cmd)
        {
            case "r_ok":
            case "r_err":
            {
                int port = message.getPort();
                ErlEntry entry = this.removeReciveFun(port);
                if ((entry == null) || (entry.receiveFun == null))
                {
                    return;
                }
                entry.receiveFun(connect, message);
                break;
            }
            default:
                message.addValue("cmd", new ErlString(cmd));
                this.defaultHandle(connect, message);
                break;
        }
    }

 public Form1()
 {
     InitializeComponent();
     pref = new prefs();
     pref.Owner = this;
     if (File.Exists("prefs"))
     {
         BinaryFormatter formatter = new BinaryFormatter();
         FileStream inputStream = File.OpenRead("prefs");
         try
         {
             Con = (Connect)formatter.Deserialize(inputStream);
         }
         catch (Exception ex)
         {
             System.Windows.Forms.MessageBox.Show("Ошибка:\n" + ex.Message, "",
                             MessageBoxButtons.OK,
                             MessageBoxIcon.Error);
         }
         inputStream.Close();
     }
     else
     {
         BinaryFormatter formatter = new BinaryFormatter();
         FileStream outputStream = File.OpenWrite("prefs");
         formatter.Serialize(outputStream, Con);
         outputStream.Close();
     }
 }

 public User()
 {
     _Updater = new Regulus.Utility.Updater<Regulus.Utility.IUpdatable>();
     _ConnectProvider = new Regulus.Remoting.Ghost.TProvider<TestNativeGameCore.IConnect>();
     _Connecter = new Connect();
     _Complex = new Regulus.Remoting.Ghost.Native.Agent();
 }

 /// <summary>
 /// This method returns all the societies from the database.
 /// </summary>
 /// <returns>It returns a datatable containing all the societies.</returns>
 public static DataTable GetAllSocieties()
 {
     sql = "SELECT * FROM Societies";
     Connect.ConnectEMS();
     c = new Connect(sql);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches all the events from the database.
 /// </summary>
 /// <returns>It returns a datatable containing all the events.</returns>
 public static DataTable GetAllEvents()
 {
     sql = "SELECT * FROM Events";
     Connect.ConnectEMS();
     c = new Connect(sql);
     return c.ds.Tables[0];
 }

    //init
    void Start() { 
        //get game objects from scene
        globalObj = GameObject.FindWithTag(TAG_GLOBAL); //global game object
        globalScript = globalObj.GetComponent<Global>(); //global script
        setupObj = GameObject.FindWithTag(TAG_SETUP); //setup game object
        connectScript = setupObj.GetComponent<Connect>(); //connect script
        activateScript = setupObj.GetComponent<Activate>(); //activate script

        //disable scripts to start
        //note: disable/uncheck scripts in the Unity interface
        connectScript.enabled = false;
        activateScript.enabled = false;

        //state manager
        //transition into scene
        //initialize since this is the first scene
        if (StateManager.Instance != null) {
            //set the transition effects for the state manager
            StateManager.Instance.gameObject.GetComponent<TransitionFade>().isFadingIn = true;
            StateManager.Instance.gameObject.GetComponent<TransitionFade>().isHoldFade = false;
        }

        //audio manager
        //initialize since this is the first scene
        if (AudioManager.Instance != null) {
            //set the transition effects for the audio manager
            //bgm
            AudioManager.Instance.switchBgmAfterDelay(AudioManager.Instance.bgmMenu, 0.0f);
            AudioManager.Instance.bgmIsFadingIn = true;
            AudioManager.Instance.bgmIsHoldFade = false;
        }

    } //end function

 public ExpressionHighlighterPlugin(Connect con, DTE2 appObject, AddIn addinInstance)
     : base(con, appObject, addinInstance)
 {
     workerToDos.WorkerReportsProgress = false;
     workerToDos.WorkerSupportsCancellation = true;
     workerToDos.DoWork += new System.ComponentModel.DoWorkEventHandler(workerToDos_DoWork);
 }

 protected void BtnStart_Click(object sender, EventArgs e)
 {
     sql = "SELECT SubjectType FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + "";
     c = new Connect(sql);
     if (c.ds.Tables[0].Rows[0]["SubjectType"].ToString().Equals("Theory"))
     {
         sql = "SELECT StudentNo,RollNo,Name FROM Student WHERE SectionID=" + int.Parse(DDLSectionGroup.SelectedValue.ToString()) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
         c = new Connect(sql);
         GridView1.DataSource = c.ds;
         GridView1.DataBind();
     }
     else
     {
         sql = "SELECT StudentNo,RollNo,Name FROM Student WHERE GroupID=" + int.Parse(DDLSectionGroup.SelectedValue.ToString()) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
         c = new Connect(sql);
         GridView1.DataSource = c.ds;
         GridView1.DataBind();
     }
     BtnSubmit.Visible = true;
     sql = "SELECT * FROM AttendanceType";
     c = new Connect(sql);
     foreach (GridViewRow row in GridView1.Rows)
     {
         DropDownList d = (DropDownList)row.FindControl("DDLAttendanceType");
         d.DataSource = c.ds;
         d.DataTextField = "AttendanceTypeName";
         d.DataValueField = "AttendanceTypeID";
         d.Width = 40;
         d.DataBind();
         d.Items[2].Attributes.CssStyle["Color"] = "red";
     }
 }

 void Test01()
 {
     var gd = new Connect();
     var sample = new Sample
                      {
                          Method = "GET",
                          Uri = "/test",
                          Timestamp = DateTime.Now.TimeOfDay.TotalMilliseconds,
                          ResponseTime = 100,
                          CpuTime = 20,
                          Context =
                              new[]
                                  {
                                      new Context {Name = "/", ResponseTime = 11},
                                      new Context {Name = "/one", ResponseTime = 12},
                                      new Context {Name = "/two", ResponseTime = 13}
                                  }
                      };
     gd.Init("26873", "testing", logger, null);
     for (int i = 0; i < 1000; i++)
     {
         gd.Store(sample, logger, null);
         Thread.Sleep(300);
     }
     gd.Term(logger, null);
     Console.Read();
 }

        public BIDSHelperPluginReference(Type t, DTE2 applicationObject, AddIn addInInstance, Connect addinCore)
        {
            pluginType = t;
            _applicationObject = applicationObject;
            _addInInstance = addInInstance;
            _core = addinCore;

        }

 /// <summary>
 /// This method fetches the details of a particular event.
 /// </summary>
 /// <param name="eventID">An integer parameter containing the ID of the event.</param>
 /// <returns>It returns a data table containing the details of the event.</returns>
 public static DataTable GetEventDetails(int eventID)
 {
     sql = "SELECT * FROM Events WHERE [email protected]";
     string[] s = { "@eventID" };
     Connect.ConnectEMS();
     c = new Connect(sql, s, eventID);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches the details of the student from the EMS database based on the student number.
 /// </summary>
 /// <param name="studentNumber">A string containing the student number of the student.</param>
 /// <returns>It returns a data table containing the details of the student.</returns>
 public static DataTable GetStudentDetails(string studentNumber)
 {
     sql = "SELECT * FROM Students WHERE [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@StudentNo" };
     c = new Connect(sql, s, studentNumber);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches the details of the organiser based on the username and password.
 /// </summary>
 /// <param name="username">A string containing the username of the organiser.</param>
 /// <param name="password">A string containing the password of the organiser.</param>
 /// <returns>It returns a data table containing the details of the organiser.</returns>
 public static DataTable GetOrganiserDetails(string username,string password)
 {
     sql = "SELECT * FROM Login WHERE [email protected] AND [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@username", "@password" };
     c = new Connect(sql, s, username, password);
     return c.ds.Tables[0];
 }