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;
}
