本文整理汇总了C#中DBFunctions.SubmittedAssignmentsCount方法的典型用法代码示例。如果您正苦于以下问题：C# DBFunctions.SubmittedAssignmentsCount方法的具体用法？C# DBFunctions.SubmittedAssignmentsCount怎么用？C# DBFunctions.SubmittedAssignmentsCount使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions的用法示例。
在下文中一共展示了DBFunctions.SubmittedAssignmentsCount方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Downloadzip_Click
protected void Downloadzip_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
int aid = int.Parse(Request.QueryString["Asid"]);
List<SubmittedAssignments_tbl> AssList = db.getsubmittedassignments(aid, 0, db.SubmittedAssignmentsCount(aid));
// string sPath = Server.MapPath("~") + "DownloadFolder";
string sPath = Server.MapPath("~/LMS/SubmittedAssignments/") + "";
string zipfile=DateTime.Now.Ticks +"_Assignment.zip";
string zipFullPath = Server.MapPath("~/LMS/DownloadedAssingments/") +zipfile;
ZipOutputStream zipOut = new ZipOutputStream(File.Create(zipFullPath));
foreach (var asg in AssList)
{
string fName = sPath + asg.AssginmentFile;
FileInfo fi = new FileInfo(fName);
ZipEntry entry = new ZipEntry(fi.Name);
FileStream sReader = File.OpenRead(fName);
byte[] buff = new byte[Convert.ToInt32(sReader.Length)];
sReader.Read(buff, 0, (int)sReader.Length);
entry.DateTime = fi.LastWriteTime;
entry.Size = sReader.Length;
sReader.Close();
zipOut.PutNextEntry(entry);
zipOut.Write(buff, 0, buff.Length);
}
zipOut.Finish();
zipOut.Close();
Response.Redirect("Download.ashx?file=" + zipfile + "&location=DownloadedAssingments", false);
}示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
if (Request.QueryString["Asid"] != null)
{
int aid = int.Parse(Request.QueryString["Asid"]);
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<SubmittedAssignments_tbl> AssList = db.getsubmittedassignments(aid, page - 1, pageSize);
// ds = db.getwardenlist(page-1, pageSize);
literalStart.Text = pageStart.ToString();
literalEnd.Text = pageEnd.ToString();
int tmpPageEnd = 0;
tmpPageEnd = pageEnd;
pageEnd = db.SubmittedAssignmentsCount(aid);
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 = "ViewSubmittedAssignment.aspx?" + Request.QueryString.ToString();
if (tmpUrl.Contains("&page"))
{
tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("&page"));
}
//*************************
//*********
StringBuilder listingString = new StringBuilder();
if (AssList != null)
{
if (AssList != null)
{
foreach (var subassgn in AssList)
{
submittedAsstbl.Text += "<tr><td>" + subassgn.Assignments_tbl.Courses_tbl.Course + "</td><td>" + subassgn.Assignments_tbl.Assignment_Title + "</td><td>" + subassgn.Assignments_tbl.marks + "</td><td>" + subassgn.Candidate_tbl.Name + "</td><td>";
submittedAsstbl.Text +="<a href='#'>" + subassgn.AssginmentFile + "</a></td>";
}
}
}
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"))
{
//.........这里部分代码省略.........