C# Connector.Lookup方法代码示例

本文整理汇总了C#中Connector.Lookup方法的典型用法代码示例。如果您正苦于以下问题：C# Connector.Lookup方法的具体用法？C# Connector.Lookup怎么用？C# Connector.Lookup使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Connector的用法示例。

在下文中一共展示了Connector.Lookup方法的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: getStudentID

    public string getStudentID()
    {
        string barcode = "";
         Connector conn = new Connector();

         string churchcode = String.Format("{0:00}",Convert.ToInt32(conn.Lookup("fldID", "tblChurch", "fldActive='1'")));
         string dt = DateTime.Now.ToString("yyMMddmmss");

         barcode = churchcode + dt;

         return barcode;
    }

开发者ID:meanprogrammer，项目名称:KidsCheckinSystem，代码行数:12，代码来源:Kids.cs

示例2: frmLogin_Load

        private void frmLogin_Load(object sender, EventArgs e)
        {
            js = new Connector(AccessRegistryTool.ReadValue("DBServer"),"Kids_Checkin","kidschurch","[email protected]");

            icon.Icon = new Icon(Application.StartupPath + @"\kids-icon.ico");
            icon.Visible = true;

            txtRoom.Text = this.Tag.ToString();

            lblConnected.Text = "Connected To: " + AccessRegistryTool.ReadValue("DBServer");

            fldRoomID = js.Lookup("fldID", "tblRoom", "fldRoom='" + txtRoom.Text + "'");

            string eID = js.Lookup("fldID", "tblCustomizedEvent", "fldEventCode='" + this.Text + "'");

            lblTotal.Text = js.Lookup("fldMaxCapacity", "tblCustomizedEventRooms", "fldRoomID='" + fldRoomID + "' AND fldCEventID='" + eID + "'");

            txtAge1.Text = js.Lookup("fldAgeFrom", "tblCustomizedEventRooms", "fldRoomID='" + fldRoomID + "' AND fldCEventID='" + eID + "'");
            txtAge2.Text = js.Lookup("fldAgeTo", "tblCustomizedEventRooms", "fldRoomID='" + fldRoomID + "' AND fldCEventID='" + eID + "'");

            fldGroupID = js.Lookup("fldID","tblGroup","fldAgeFrom='" + txtAge1.Text + "' AND fldAgeTo='" + txtAge2.Text + "'");

            if(Convert.ToInt32(txtAge1.Text)< 7)
            {
                btnAddPoints.Enabled = false;
            }

            string timetoday = DateTime.Now.ToString("hh:mm tt");

            string q = "SELECT * FROM tblEvent WHERE fldRegistrationTime <= convert(time,'" + timetoday + "') AND fldEndTime >=convert(time,'" + timetoday + "')";

            js.ExecuteQuery(q);

            js.RiD.Read();

            lblNotification.Text = "";

            if (js.RiD.HasRows)
            {
                fldEventID = "" + js.RiD["fldID"].ToString();

                txtService.Text = js.RiD["fldEventTitle"].ToString();

                LoadAttendance();
                LoadBirthdays();
                LoadNewComer();
                LoadVolunteer();
                dgvAttendance_CellContentClick(null,null);
            }
            else
            {
                js.showExclamation("Cannot open an event yet!, Please try again later");
                frmSystemOptions frm = new frmSystemOptions();
                frm.Show();
                Close();
                return;
            }

            js.CloseConnection();

            StartReader();

            string mode = AccessRegistryTool.ReadValue("RegMode");

            if(mode=="Barcode")
            {
                tmrReader.Enabled = false;
                //rbBarcode_CheckedChanged(null, null);

            }
            else
            {
                tmrReader.Enabled = true;
            }

            //this.BackgroundImage = Image.FromFile(Application.StartupPath + "/Pictures/kids back.jpg");
        }

开发者ID:meanprogrammer，项目名称:KidsCheckinSystem，代码行数:77，代码来源:frmLogin.cs