protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LabelResourceID.Text = Request.QueryString["ID"];
// RoleID=1,Administrator;RoleID=2,Editor;RoleID=3,Contributor;RoleID=4,Author;
//if (Session["RoleID"]!=null && !String.IsNullOrEmpty(Session["RoleID"].ToString()) && ( Session["RoleID"].ToString() == "1" || Session["RoleID"].ToString() == "2") )
//{
// //Role.Enabled = true;
// FolderDDL.Enabled = true;
// //PasswordPanel.Visible = true;
//}
//else
//{
// //Role.Enabled = false;
// FolderDDL.Enabled = false;
// //PasswordPanel.Visible = false;
//}
using (SqlConnection conn = new DB().GetConnection())
{
string sql = "Select * from ResourceFolders order by ID asc";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
FolderDDL.DataSource = rd;
FolderDDL.DataTextField = "FolderName";
FolderDDL.DataValueField = "ID";
FolderDDL.DataBind();
rd.Close();
cmd.CommandText = "Select * from [Resources] where ID = @ResourceID";
cmd.Parameters.AddWithValue("@ResourceID", LabelResourceID.Text);
rd = cmd.ExecuteReader();
if (rd.Read())
{
ResourceName.Text = rd["ResourceName"].ToString();
UserName.Text = rd["UserName"].ToString();
FileType.Text = rd["FileType"].ToString();
FileSizeInKB.Text = rd["FileSizeInKB"].ToString();
CreateDateTime.Text = rd["CDT"].ToString();
string resourcefolderID = rd["FolderID"].ToString();
if (FolderDDL.Items.FindByValue(resourcefolderID) != null)
{
FolderDDL.ClearSelection();
FolderDDL.Items.FindByValue(resourcefolderID).Selected = true;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["RoleID"] == null || Session["UserID"] == null)
{
Util.ShowMessage("用户登录超时，请重新登录！", "Login2.aspx");
}
else
{
if (Convert.ToInt16(Session["RoleID"]) > 4)
{
Util.ShowMessage("对不起，你无权访问该页面！", "User_Center.aspx");
}
else
{
LabelResourceID.Text = Request.QueryString["ID"];
// RoleID=1,Administrator;RoleID=2,Editor;RoleID=3,Contributor;RoleID=4,Author;
//if (Session["RoleID"]!=null && !String.IsNullOrEmpty(Session["RoleID"].ToString()) && ( Session["RoleID"].ToString() == "1" || Session["RoleID"].ToString() == "2") )
//{
// //Role.Enabled = true;
// FolderDDL.Enabled = true;
// //PasswordPanel.Visible = true;
//}
//else
//{
// //Role.Enabled = false;
// FolderDDL.Enabled = false;
// //PasswordPanel.Visible = false;
//}
using (SqlConnection conn = new DB().GetConnection())
{
string sql = "Select * from ResourceFolders order by ID asc";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
FolderDDL.DataSource = rd;
FolderDDL.DataTextField = "FolderName";
FolderDDL.DataValueField = "ID";
FolderDDL.DataBind();
rd.Close();
cmd.CommandText = "Select * from [Resources] where ID = @ResourceID";
cmd.Parameters.AddWithValue("@ResourceID", LabelResourceID.Text);
rd = cmd.ExecuteReader();
if (rd.Read())
{
ResourceName.Text = rd["ResourceName"].ToString();
UserName.Text = rd["UserName"].ToString();
UserID.Text = rd["UserID"].ToString();
FileType.Text = rd["FileType"].ToString();
FileSizeInKB.Text = rd["FileSizeInKB"].ToString();
CreateDateTime.Text = rd["CDT"].ToString();
string resourcefolderID = rd["FolderID"].ToString();
if (FolderDDL.Items.FindByValue(resourcefolderID) != null)
{
FolderDDL.ClearSelection();
FolderDDL.Items.FindByValue(resourcefolderID).Selected = true;
}
if (FileType.Text.Equals("图片"))
{
Image1.ImageUrl = rd["FilePath"].ToString();
}
if (FileType.Text.Equals("压缩"))
{
Image1.ImageUrl = "upload/Resource_Preview/ys.png";
}
if (FileType.Text.Equals("文档"))
{
Image1.ImageUrl = "upload/Resource_Preview/wd.png";
}
if (FileType.Text.Equals("视频"))
{
Image1.ImageUrl = "upload/Resource_Preview/sp.png";
}
if (FileType.Text.Equals("音频"))
{
Image1.ImageUrl = "upload/Resource_Preview/yp.png";
}
if (FileType.Text.Equals("Flash"))
{
Image1.ImageUrl = "upload/Resource_Preview/fl.png";
}
if (FileType.Text.Equals("附件"))
{
Image1.ImageUrl = "upload/Resource_Preview/wd.png";
}
}
}
int RoleID = Convert.ToInt16(Session["RoleID"].ToString());
string UserIDstr = Session["UserID"].ToString();
if ((RoleID > 2) && (UserIDstr != UserID.Text))
{
Button1.Visible = false;
Button2.Visible = false;
ErrorLabel.Text = "用户权限不够，不可编辑他人上传的资源！";
}
else
{
Button1.Visible = true;
Button2.Visible = true;
}
}
}
}
}