protected void bindData(CaseInfo sfi) { //设置文件描述和下载链接 try { hlFile.Text = sfi.StrDescription.Substring(0, 4); } catch { hlFile.Text = sfi.StrDescription; } hlFile.ToolTip = sfi.StrDescription; if (sfi.StrDescription.Length > 5) hlFile.Text += "..."; hlFile.NavigateUrl = "../" + sfi.StrUrl; //若无下载权限,链接置为空 isAbleToDownload = Convert.ToBoolean(HiddenFieldDownloadRight.Value); if (!isAbleToDownload) { hlFile.NavigateUrl = ""; } //获取文件扩展名 String format; int lastDotIndex = sfi.StrUrl.LastIndexOf('.'); if (-1 == lastDotIndex) { format = ""; } else { format = sfi.StrUrl.Substring(lastDotIndex); format = format.Remove(0, 1); format = format.ToUpper(); } lbFormat.Text = format; //获取文件大小 FileInfo fi = new FileInfo(Server.MapPath("../") + sfi.StrUrl); lbSize.Text = formatFileSize(fi.Length); }
/// <summary> /// ����PageID,�������½�,���һ��CaseInfo���� /// </summary> /// <param name="pageID">�ļ�����ҳ���pageID(д��web.config��appsettings����)</param> /// <returns>Case����</returns> public List<CaseInfo> getCaseFilesByPageID(int pageID, int sectionId) { List<CaseInfo> list = new List<CaseInfo>(); SqlParameter[] parms = { new SqlParameter("@pageID", pageID), new SqlParameter("@sectionId", sectionId) }; SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "[SP_GetCaseFilesByPageID]", parms); while (reader.Read()) { CaseInfo sfi = new CaseInfo(); sfi.ICaseId = Convert.ToInt32(reader["ID"]); sfi.StrDescription = Convert.ToString(reader["description"]); sfi.StrUrl = Convert.ToString(reader["url"]); sfi.DtAddTime = Convert.ToDateTime(reader["addDate"]); list.Add(sfi); } return list; }