本文整理汇总了C#中DBFunctions.getapplicant_count方法的典型用法代码示例。如果您正苦于以下问题:C# DBFunctions.getapplicant_count方法的具体用法?C# DBFunctions.getapplicant_count怎么用?C# DBFunctions.getapplicant_count使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions
的用法示例。
在下文中一共展示了DBFunctions.getapplicant_count方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GenerateList_Click
protected void GenerateList_Click(object sender, EventArgs e)
{
string pagname = Path.GetFileName(Request.PhysicalPath);
int pagesize = 15;
int page = 1;
int pagecount = 0;
DBFunctions db = new DBFunctions();
if (Request.QueryString["page"] != null)
{
page = int.Parse(Request.QueryString["page"]);
}
List<Candidate_tbl> applicants;
if (Dropdownprogramme.SelectedValue != "All")
{
Printmeritlist.Visible = true;
Applicantlist.Text = "";
Paging.Text = "";
applicants = db.generatemeritlist(int.Parse(Dropdownprogramme.SelectedValue));
}
else
{
ErrorMessagelbl.Text="Please Select A Programe First..!!";
return;
}
// applicants = applicants.OrderBy(x=>x.CuttoffPoints).Skip(page*pagesize).Take(pagesize).ToList();
pagecount = (db.getapplicant_count() + pagesize - 1) / pagesize;
foreach (var app in applicants)
{
//<tr class="blue-background"><th>Name</th><th>Address</th><th>Cut Off Points</th><th>Programme</th><th>Gender</th><th>Email</th><th>Phone</th><th>Status</th><th>Action</th></tr>
Applicantlist.Text += "<tr><td>" + app.Name + "</td><td>" + app.HomeAdress + "," + app.Areas_tbl.Area + "," + app.States_tbl.State + "</td><td>" + app.CuttoffPoints + "</td><td>" + app.Program_tbl.ProgramName + "</td><td>" + app.Gender + "</td><td>" + app.Email + "</td><td>" + app.Phone + "</td><td></td></tr>";
}
//if (pagecount > 1)
//{
// for (int i = 1; i <= pagecount; i++)
// {
// if (page != i)
// Paging.Text += "<li class=''><a style='background: #f0f0f0;' href='" + pagname + "?page=" + i + "'>" + i + "</a></li>";
// else
// Paging.Text += "<li><a>" + i + "</a></li>";
// }
//}
}
示例2: loadcandidates
public void loadcandidates(List<Candidate_tbl> applicants)
{
string pagname = Path.GetFileName(Request.PhysicalPath);
ErrorMessagelbl.Text = "";
DBFunctions db = new DBFunctions();
pagecount = (db.getapplicant_count() + pagesize - 1) / pagesize;
foreach (var app in applicants)
{
//<tr class="blue-background"><th>Name</th><th>Address</th><th>Cut Off Points</th><th>Programme</th><th>Gender</th><th>Email</th><th>Phone</th><th>Status</th><th>Action</th></tr>
Applicantlist.Text += "<tr><td>" + app.Name + "</td><td>" + app.HomeAdress + "," + app.Areas_tbl.Area + "," + app.States_tbl.State + "</td><td>" + app.CuttoffPoints + "</td><td>" + app.Program_tbl.ProgramName + "</td><td>" + app.Gender + "</td><td>" + app.Email + "</td><td>" + app.Phone + "</td><td></td></tr>";
}
if (pagecount > 1)
{
for (int i = 1; i <= pagecount; i++)
{
if (page != i)
Paging.Text += "<li class=''><a style='background: #f0f0f0;' href='" + pagname + "?page=" + i + "?meritlist=1'>" + i + "</a></li>";
else
Paging.Text += "<li><a>" + i + "</a></li>";
}
}
}