// This queries the db for the states.
public void queryState()
{
// Clears the grid data and the other boxes.
cityList.Items.Clear();
zipList.Items.Clear();
catList.Items.Clear();
selectedCats.Items.Clear();
data.Clear();
// Query for the business box
string cmd = @"SELECT distinct businessstate FROM businessaddress
ORDER BY businessstate";
s.executeQuery(cmd, queryStateHelper, true);
}
private void AddDirsInListViewFile(IEnumerable <OsFile> dirs, IEnumerable <OsFile> files, string parentPath)
{
_dataStore.Clear();
var item = new DataStoreCollection <FileInfoView>();
//显示dirs
foreach (OsFile dir in dirs)
{
//移除最后的'/'符号
string dirName = dir.FileName.Remove(dir.FileName.Length - 1, 1);
//添加fileInfo
string fullName = Path.Combine(new string[] { parentPath, dirName }) + (_isWin ? "\\" : "/");
item.Add(new FileInfoView(dirName, fullName, true, dir.FileMTime, dir.FileSize, dir.FilePerms));
}
//显示files
foreach (OsFile file in files)
{
//添加fileInfo
string dirName = file.FileName;
string fullName = Path.Combine(new string[] { parentPath, dirName });
item.Add(new FileInfoView(dirName, fullName, false, file.FileMTime, file.FileSize, file.FilePerms));
}
_dataStore.AddRange(item);
}
public void queryFriends()
{
friendData.Clear();
string cmd = @"SELECT friendid, username, totalLikes, averageStars, yelpingSince
FROM FriendsWith, Users WHERE FriendsWith.friendid = Users.UserID AND FriendsWith.UserId = '" + currentUser.UserID + "' ;";
s.executeQuery(cmd, queryFriendInfoHelper, true);
friendsGrid.DataStore = friendData;
}
public void queryTips()
{
latestTipsData.Clear();
string cmd = @"SELECT friendid, recentDate, username, textwritten, businessname, businesscity
FROM FriendsWith, Users, BusinessAddress, Business, Tip, (SELECT userid, MAX(datewritten) as recentDate FROM Tip GROUP BY userid) as Recent
WHERE FriendsWith.friendid = Users.UserID AND FriendsWith.UserId = '" + currentUser.UserID + @"'
AND BusinessAddress.businessid = Business.businessid AND Tip.businessid = business.businessid AND Tip.datewritten = Recent.recentDate
AND Tip.userid = Recent.userid AND Recent.userid = Friendswith.friendid ORDER BY recentDate DESC;";
s.executeQuery(cmd, queryLatestTipsHelper, true);
latestTips.DataStore = latestTipsData;
}
// Loads the tips into the grid
private void loadBusinessTipsHelper()
{
general_data.Clear();
friend_data.Clear();
// Query for the tips
string sqlStr1 = @"SELECT Tip.userid, dateWritten, userName, likes, textWritten FROM Tip, Users
WHERE Users.userID = Tip.userID AND businessID = '" + bus.bid + "' ORDER BY dateWritten;";
s.executeQuery(sqlStr1, loadBusinessTipsHelper, true);
general_grid.DataStore = general_data;
if (user.UserID != "/0")
{
// Query friend tips for the business
string sqlStr2 = @"SELECT Tip.userid, dateWritten, userName, likes, textWritten
FROM Tip, Users, FriendsWith WHERE Users.userID = Tip.userID AND FriendsWith.UserID = '" + user.UserID + @"'
AND FriendsWith.FriendID = Tip.UserID AND businessID = '" + bus.bid + "' ORDER BY dateWritten;";
s.executeQuery(sqlStr2, loadBusinessFriendTipsHelper, true);
friend_grid.DataStore = friend_data;
}
}