本文整理汇总了C#中Connector.GetPath方法的典型用法代码示例。如果您正苦于以下问题：C# Connector.GetPath方法的具体用法？C# Connector.GetPath怎么用？C# Connector.GetPath使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Connector的用法示例。
在下文中一共展示了Connector.GetPath方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: pbOverride_Click
private void pbOverride_Click(object sender, EventArgs e)
{
js = new Connector(AccessRegistryTool.ReadValue("DBServer"), "Kids_Checkin", "kidschurch", "[email protected]");
tmrReader.Enabled = false;
DataGridViewImageColumn img = new DataGridViewImageColumn();
int age = 0;
int group = 0;
string pathfile = js.GetPath() + "/Kids/" + js.Lookup("fldPicture", "tblKids", "fldID='" + pbOverride.Tag + "'");
string roomid = js.Lookup("fldID", "tblRoom", "fldRoom='" + txtRoom.Text + "'");
string firstname = js.Lookup("fldNickName", "tblKids", "fldID='" + pbOverride.Tag + "'");
string Lastname = js.Lookup("fldLastName", "tblKids", "fldID='" + pbOverride.Tag + "'");
bool correct = false;
string room = "";
string thistext = "";
string id = js.Lookup("fldID", "tblCustomizedEvent", "fldEventCode='" + this.Text + "'");
if(lblCount.Text==lblTotal.Text)
{
string qry = "SELECT er.fldRoomID,r.fldRoom FROM tblCustomizedEventRooms er " +
" LEFT OUTER JOIN tblRoom r on r.fldID=er.fldRoomID" +
" WHERE er.fldMaxCapacity>(SELECT Count(*) FROM tblAttendance WHERE fldRoomID=er.fldRoomID AND fldLoginDateTime BETWEEN '" + DateTime.Now.ToShortDateString() + " 00:00:00' AND '" + DateTime.Now.ToShortDateString() + " 23:59:59' AND fldEventID='" + fldEventID + "')" +
" AND fldCEventID='" + id + "'";
js.ExecuteQuery(qry);
js.RiD.Read();
if (js.RiD.HasRows)
{
room = "" + js.RiD["fldRoom"].ToString();
roomid = js.RiD["fldRoomID"].ToString();
}
if(room!="")
{
js.showExclamation("Room: " + txtRoom.Text + " is already maxed out the kid will be transferred to Room: " + room);
}
else
{
room = txtRoom.Text;
roomid = js.Lookup("fldID", "tblRoom", "fldRoom='" + txtRoom.Text + "'");
js.showExclamation("Room: " + txtRoom.Text + " is already maxed out, the kid will be added to Room: " + room);
}
}
id = js.Lookup("fldID", "tblCustomizedEvent", "fldEventCode='" + this.Text + "'");
string qq = "SELECT er.fldRoomID,r.fldRoom,er.fldAgeFrom,er.fldAgeTo FROM tblCustomizedEventRooms er " +
" LEFT OUTER JOIN tblRoom r on r.fldID=er.fldRoomID" +
" WHERE er.fldMaxCapacity>(SELECT Count(*) FROM tblAttendance WHERE fldRoomID=er.fldRoomID AND fldLoginDateTime BETWEEN '" + DateTime.Now.ToShortDateString() + " 00:00:00' AND '" + DateTime.Now.ToShortDateString() + " 23:59:59' AND fldEventID='" + fldEventID + "')" +
" AND fldCEventID='" + id + "'";
while (correct == false)
{
//string value = "";
frmOverride frm = new frmOverride();
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
{
}
else
{
checkin.frmOverFlowRoom form = new checkin.frmOverFlowRoom();
form.Tag = qq;
if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string[] tag = form.Tag.ToString().Split(char.Parse("|"));
room = tag[1];
roomid = tag[0];
}
correct = true;
//return;
}
}
if (System.IO.File.Exists(pathfile))
{
img.Image = Image.FromFile(pathfile);
img.Image = (Image)(new Bitmap(img.Image, new Size(150, 150)));
}
else
{
img.Image = Image.FromFile(Application.StartupPath + "/Pictures/download.jpg");
img.Image = (Image)(new Bitmap(img.Image, new Size(150, 150)));
}
pbImageKid.Image = img.Image;
txtName.Text = firstname + " " + Lastname;
txtBirthday.Text = Convert.ToDateTime(js.Lookup("fldBirthday", "tblKids", "fldID='" + pbOverride.Tag + "'")).ToShortDateString();
DateTime sdate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd"));
//.........这里部分代码省略.........
示例2: SaveCheckin
private void SaveCheckin(string kidid,string fldRoomID = "")
{
js = new Connector(AccessRegistryTool.ReadValue("DBServer"),"Kids_Checkin","kidschurch","[email protected]");
if (kidid == "")
{
return;
}
DataGridViewImageColumn img = new DataGridViewImageColumn();
int age = 0;
int group = 0;
bool passed = false;
string pathfile = js.GetPath() + "/Kids/" + js.Lookup("fldPicture", "tblKids", "fldID='" + kidid + "'");
string roomid;
string room = "";
string firstname = js.Lookup("fldNickName", "tblKids", "fldID='" + kidid + "'");
string Lastname = js.Lookup("fldLastName", "tblKids", "fldID='" + kidid + "'");
age = js.GetAge(Convert.ToDateTime(js.Lookup("fldBirthday", "tblKids", "fldID='" + kidid + "'")));
if (fldRoomID == "")
{
roomid = js.Lookup("fldID", "tblRoom", "fldRoom='" + txtRoom.Text + "'");
room = js.Lookup("fldRoom", "tblRoom", "fldID=" + roomid);
}
else
{
roomid = fldRoomID;
room = js.Lookup("fldRoom", "tblRoom", "fldID=" + roomid);
passed = true;
}
if (age <= Convert.ToInt32(txtAge1.Text) && age >= Convert.ToInt32(txtAge2.Text))
{
int rooms = 0;
string id = js.Lookup("fldID", "tblCustomizedEvent", "fldEventCode='" + this.Text + "'");
rooms = int.Parse(js.Lookup("Count(*)","tblCustomizedEventRooms","fldCEventID='" + id + "'"));
if(rooms>1)
{
string qry = "SELECT er.fldRoomID,r.fldRoom FROM tblCustomizedEventRooms er " +
" LEFT OUTER JOIN tblRoom r on r.fldID=er.fldRoomID" +
" WHERE er.fldMaxCapacity>(SELECT Count(*) FROM tblAttendance WHERE fldRoomID=er.fldRoomID AND fldLoginDateTime BETWEEN '" + DateTime.Now.ToShortDateString() + " 00:00:00' AND '" + DateTime.Now.ToShortDateString() + " 23:59:59' AND fldEventID='" + fldEventID + "')" +
" AND fldCEventID='" + id + "' AND er.fldAgeFrom<=" + age + " AND er.fldAgeTo>=" + age;
js.RiD.Read();
//string roomid = "";
if (js.RiD.HasRows)
{
room = "" + js.RiD["fldRoom"].ToString();
roomid = js.RiD["fldRoomID"].ToString();
passed = true;
}
else
{
roomid = js.Lookup("fldID", "tblCustomizedEventRooms", "fldAgeFrom<=" + age + " AND fldAgeTo>=" + age + " AND fldCEventID='" + id + "'");
room = js.Lookup("fldRoom", "tblRoom", "fldID='" +roomid + "'");
}
}
else
{
lblNotification.ForeColor = System.Drawing.Color.Red;
lblNotification.Text = firstname + " " + Lastname + " does not belong to this Group";
pbOverride.Tag = null;
pbOverride.Visible = false;
return;
}
}
else if(age > Convert.ToInt32(txtAge2.Text))
{
int rooms = 0;
string id = js.Lookup("fldID", "tblCustomizedEvent", "fldEventCode='" + this.Text + "'");
rooms = int.Parse(js.Lookup("Count(*)", "tblCustomizedEventRooms", "fldCEventID='" + id + "'"));
if (rooms>1)
{
string qry = "SELECT er.fldRoomID,r.fldRoom FROM tblCustomizedEventRooms er " +
" LEFT OUTER JOIN tblRoom r on r.fldID=er.fldRoomID" +
" WHERE er.fldMaxCapacity>(SELECT Count(*) FROM tblAttendance WHERE fldRoomID=er.fldRoomID AND fldLoginDateTime BETWEEN '" + DateTime.Now.ToShortDateString() + " 00:00:00' AND '" + DateTime.Now.ToShortDateString() + " 23:59:59' AND fldEventID='" + fldEventID + "')" +
" AND fldCEventID='" + id + "' AND er.fldAgeFrom<=" + age + " AND er.fldAgeTo>=" + age;
js.ExecuteQuery(qry);
js.RiD.Read();
//string roomid = "";
if (js.RiD.HasRows)
{
//.........这里部分代码省略.........
示例3: btnScan_Click
private void btnScan_Click(object sender, EventArgs e)
{
js = new Connector(AccessRegistryTool.ReadValue("DBServer"), "Kids_Checkin", "kidschurch", "[email protected]");
string value = "";
bool passed = false;
if (js.InputBox("Check Out", "Please Scan Barcode", ref value) == System.Windows.Forms.DialogResult.OK)
{
string q = "SELECT * FROM tblKids WHERE fldStudentID = '" + value + "'";
js.ExecuteQuery(q);
js.RiD.Read();
if(!js.RiD.HasRows)
{
return;
}
string kidsid = js.RiD["fldID"].ToString();
for (int i=0;i<kID.Length;i++)
{
if(kidsid==kID[i])
{
passed = true;
break;
}
}
if(passed==true)
{
string p = js.GetPath() + "/Kids/" + js.RiD["fldPicture"];
string aID = js.Lookup("fldID", "tblAttendance", "fldKidsID='" + value + "' AND fldLoginDateTime BETWEEN '" + DateTime.Now.ToShortDateString() + " 00:00:00' AND '" + DateTime.Now.ToShortDateString() + " 23:59:59' AND (fldLogoutDateTime IS NULL)");
if (System.IO.File.Exists(p))
{
pbK1.Image = Image.FromFile(p);
}
lblKName.Text = "" + js.RiD["fldNickName"] + " " + js.RiD["fldLastName"];
lblBarcode.Text = value;
lblBirthday.Text = Convert.ToDateTime(js.RiD["fldBirthday"].ToString()).ToString("MM/dd/yyyy");
btnConfirm.Tag = aID;
btnConfirm.Enabled = true;
fromNFC = false;
}
else
{
lblNotification.ForeColor = Color.Red;
lblNotification.Text = "Fetcher and Kid Do Not Match";
}
}
}