本文整理汇总了C#中DBFunctions.generatemeritlist方法的典型用法代码示例。如果您正苦于以下问题：C# DBFunctions.generatemeritlist方法的具体用法？C# DBFunctions.generatemeritlist怎么用？C# DBFunctions.generatemeritlist使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions的用法示例。
在下文中一共展示了DBFunctions.generatemeritlist方法的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: Printmeritlist_Click
protected void Printmeritlist_Click(object sender, EventArgs e)
{
string html = System.IO.File.ReadAllText(Server.MapPath("MeritList.html"));
DBFunctions db = new DBFunctions();
string candidtes = "";
var applicants = db.generatemeritlist(int.Parse(Dropdownprogramme.SelectedValue));
CollegeERPDBEntities db1 = new CollegeERPDBEntities();
var result1 = db1.Candidate_tbl.Join(db1.Batches_table,
c => c.ID,
a => a.ID,
(c, a) => new { a.ID }).ToList();
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>
int Year = Convert.ToInt16(app.AdmissionYear);
candidtes += "<tr><td>" + app.Name + "</td><td>" + app.CuttoffPoints + "</td><td>" + app.Gender + "</td><td>" + app.Email + "</td><td>" + app.Phone + "</td></tr>";
}
db.addadmssion(applicants);
Byte[] bytes;
html = html.Replace("{Programme}", applicants.FirstOrDefault().Program_tbl.ProgramName);
html = html.Replace("{year}", DateTime.Now.Year.ToString());
html= html.Replace("{CandidateList}", candidtes);
using (var ms = new MemoryStream())
{
var doc = new Document();
doc = new Document(PageSize.A4, 30, 30, 30, 30);
var writer = PdfWriter.GetInstance(doc, ms);
doc.Open();
doc.NewPage();
var example_html = html;
using (var htmlWorker = new iTextSharp.text.html.simpleparser.HTMLWorker(doc))
{
using (var sr = new StringReader(example_html))
{
htmlWorker.Parse(sr);
}
}
doc.Close();
bytes = ms.ToArray();
}
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + milliseconds +"MeritList.pdf");
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.BinaryWrite(bytes);
HttpContext.Current.Response.End();
HttpContext.Current.Response.Close();
}