SHOW:
|
|
- or go back to the newest paste.
| 1 | - | var steps = _db.tblConversions.GroupBy(c => c.CvStep).OrderBy(c=>c.Key).Select(s => s.Key).ToList(); |
| 1 | + | var steps = _db.tblConversions.GroupBy(c => c.CvStep).OrderBy(c=>c.Key).Select(s => s.Key).ToList(); |
| 2 | - | foreach (var step in steps) |
| 2 | + | foreach (var step in steps) |
| 3 | - | {
|
| 3 | + | {
|
| 4 | - | var keywords = |
| 4 | + | var keywords = |
| 5 | - | _db.ExecuteQuery<string>( |
| 5 | + | _db.ExecuteQuery<string>( |
| 6 | - | "SELECT DISTINCT SkwKeyword FROM tblSearchKeywords WHERE SkwIpAddress in (" +
|
| 6 | + | "SELECT DISTINCT SkwKeyword FROM tblSearchKeywords WHERE SkwIpAddress in (" +
|
| 7 | - | " SELECT DISTINCT CvIP FROM tblConversions " + |
| 7 | + | " SELECT DISTINCT CvIP FROM tblConversions " + |
| 8 | - | " WHERE SkwIpAddress IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep = {0}) " +
|
| 8 | + | " WHERE SkwIpAddress IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep = {0}) " +
|
| 9 | - | " AND SkwIpAddress NOT IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep > {0}))",
|
| 9 | + | " AND SkwIpAddress NOT IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep > {0}))",
|
| 10 | - | step); |
| 10 | + | step); |
| 11 | ||
| 12 | - | sb.AppendFormat("<tr><td>Stap {0}</td><td style=\"text-align:left;\">{1}</td></tr>", step,
|
| 12 | + | sb.AppendFormat("<tr><td>Stap {0}</td><td style=\"text-align:left;\">{1}</td></tr>",
|
| 13 | - | String.Join(" | ",keywords));
|
| 13 | + | step, |
| 14 | - | } |
| 14 | + | String.Join(" | ",keywords));
|
| 15 | } |
