本文整理汇总了C#中DBFunctions.getBook_Count方法的典型用法代码示例。如果您正苦于以下问题:C# DBFunctions.getBook_Count方法的具体用法?C# DBFunctions.getBook_Count怎么用?C# DBFunctions.getBook_Count使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions
的用法示例。
在下文中一共展示了DBFunctions.getBook_Count方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
bool loggedStatus = false;
DBFunctions db = new DBFunctions();
string pagename = Path.GetFileName(Request.PhysicalPath);
if (System.Web.HttpContext.Current.User == null)
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
else
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
DatabaseFunctions d = new DatabaseFunctions();
UserID = Membership.GetUser().ProviderUserKey.ToString();
int stid = d.GetCandidateID(UserID);
if (stid != -1)
{
var chk = db.getLirarymember(stid);
backlink.Text = "<a href='#0' class='btn btn-primary' onclick='history.back()'>Back</a>";
if (chk == null)
{
searchcontrols.Visible = false;
pagingdiv.Visible = false;
tblbooks.Visible = false;
membermsg.Visible = true;
linkmemebrship.Visible = true;
membermsg.InnerText = "Your Do Not Have The Library Membership..!!";
//var stdent = db.getstdentinfo(stid);
//nametxt.Text = stdent.Candidate_tbl.Name;
//metricno.Text = stdent.Candidate_tbl.AddmissionList_tbl.FirstOrDefault().MetricNo;
//programme.Text = stdent.Program_tbl.ProgramName;
return;
}
else if (chk.Status == 0)
{
tblbooks.Visible = false;
searchcontrols.Visible = false;
pagingdiv.Visible = false;
membermsg.Visible = true;
//membershipform.Visible = false;
//membermsg.Visible = true;
membermsg.InnerText = "Your Request For Library Membership is Pending..!!";
return;
}
int pageStart = 1;
int pageEnd = 10;
if (Request.QueryString.ToString().Contains("page"))
{
page = Convert.ToInt32(Request.QueryString["page"].ToString());
pageEnd = pageSize * page;
pageStart = (pageEnd - pageSize) + 1;
}
// List<Book> ds = new List<Book>();
literalStart.Text = pageStart.ToString();
literalEnd.Text = pageEnd.ToString();
int tmpPageEnd = 0;
tmpPageEnd = pageEnd;
pageEnd = db.getBook_Count();
if (pageEnd > 10)
{
literalTotal.Text = pageEnd.ToString();
int pagett = 0;
pagett = Convert.ToInt16(literalEnd.Text);
if (pagett > pageEnd)
{
literalEnd.Text = pageEnd.ToString();
}
}
else
{
if (pageEnd == 0)
{
literalStart.Text = "";
}
literalTotal.Text = pageEnd.ToString();
literalEnd.Text = pageEnd.ToString();
}
//.........这里部分代码省略.........
示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
int pageStart = 1;
int pageEnd = 10;
if (Request.QueryString.ToString().Contains("page"))
{
page = Convert.ToInt32(Request.QueryString["page"].ToString());
pageEnd = pageSize * page;
pageStart = (pageEnd - pageSize) + 1;
}
List<Book> ds = new List<Book>();
ds = db.getbooklist(page-1, pageSize);
literalStart.Text = pageStart.ToString();
literalEnd.Text = pageEnd.ToString();
int tmpPageEnd = 0;
tmpPageEnd = pageEnd;
pageEnd = db.getBook_Count();
if (pageEnd > 10)
{
literalTotal.Text = pageEnd.ToString();
int pagett = 0;
pagett = Convert.ToInt16(literalEnd.Text);
if (pagett > pageEnd)
{
literalEnd.Text = pageEnd.ToString();
}
}
else
{
if (pageEnd == 0)
{
literalStart.Text = "";
}
literalTotal.Text = pageEnd.ToString();
literalEnd.Text = pageEnd.ToString();
}
string tmpUrl = string.Empty;
tmpUrl = "ManageCourses.aspx?" + Request.QueryString.ToString();
if (tmpUrl.Contains("?page"))
{
tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page"));
}
StringBuilder listingString = new StringBuilder();
if (ds != null)
{
loadBooks(ds);
}
if (pageEnd > 10)
{
StringBuilder paging = new StringBuilder();
int counterPage = 1;
int totalPages = 1;
totalPages = (pageEnd / 10) + 1;
string urlMain = string.Empty;
urlMain = Request.Url.ToString();
if (urlMain.Contains("?page"))
{
urlMain = urlMain.Remove(urlMain.IndexOf("?page"));
}
for (int i = 1; i <= totalPages; i++)
{
string newPageString = string.Empty;
if (i == 1)
{
newPageString = "<li><a aria-label=\"First\" href=\"" + urlMain + "\" ><<</a></li>";
if (page == i)
{
newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
else
{
newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
//.........这里部分代码省略.........