// 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; } }