/// <summary>
/// Gets the data for the selected jump option.
/// </summary>
/// <param name="selectedSummary">The selected summary.</param>
/// <returns>An enumerator.</returns>
protected override IEnumerator GetSelectedJumpOptionData(Summary selectedSummary)
{
return this.characterService.GetCharacter(selectedSummary.ResourceURI, this.GetCharacterCompleted);
}
/// <summary>
/// Gets the data for the selected jump option.
/// </summary>
/// <param name="selectedSummary">The selected summary.</param>
/// <returns>An enumerator.</returns>
protected override IEnumerator GetSelectedJumpOptionData(Summary selectedSummary)
{
throw new NotImplementedException();
}
public static bool SelectSummary(List<Summary> postSummarys, ref string e)
{
string strSql = "select tb_UserInfo.uiDepartment AS department, tb_PostResponseBook.prbPassed AS passed from tb_UserInfo left outer join tb_PostResponseBook on tb_UserInfo.uiID = tb_PostResponseBook.prbUserID order by passed desc";
DataTable table = new DataTable();
table = db.QueryDataTable(strSql, ref e);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Summary ps = new Summary();
ps.Department = (string)table.Rows[i]["department"];
if (!(table.Rows[i]["passed"] is DBNull))
{
ps.Passed = Convert.ToInt32(table.Rows[i]["passed"]);
}
else
ps.Passed = -1;
postSummarys.Add(ps);
}
return true;
}
else
{
return false;
}
}
/// <summary>
/// Gets the data for the selected jump option.
/// </summary>
/// <param name="selectedSummary">The selected summary.</param>
/// <returns>An enumerator.</returns>
protected override IEnumerator GetSelectedJumpOptionData(Summary selectedSummary)
{
return this.eventService.GetEvent(selectedSummary.ResourceURI, this.GetEventCompleted);
}
//统计汇总情况
public static bool SelectSummary(List<Summary> summarys, ref string e)
{
string strSql = "select distinct tb_UserInfo.uiID as ID, tb_UserInfo.uiDepartment as department, tb_AssessTable.atPass as passed " +
"from tb_UserInfo left outer join tb_AssessTable " +
"ON tb_UserInfo.uiID = tb_AssessTable.atUserID order by passed dest";
DataTable table = new DataTable();
table = db.QueryDataTable(strSql, ref e);
table.Columns.Remove("ID");
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Summary s = new Summary();
s.Department = (string)table.Rows[i]["department"];
if (!(table.Rows[i]["passed"] is DBNull))
{
s.Passed = Convert.ToInt32(table.Rows[i]["passed"]);
}
else
s.Passed = -1;
summarys.Add(s);
}
return true;
}
else
{
return false;
}
}