Beispiel #1
0
    public void ReBindPageList()
    {
        DBLL.DBcommon         dbcom           = new DBLL.DBcommon();
        DBLL.clsTopicCategory TopicCategory   = new DBLL.clsTopicCategory();
        DataTable             TopicCategorydt = TopicCategory.sp_selectNormalTableOfAllByTopicCategoryAndnType(false, 2);

        ddlnTCategoryID.DataSource     = TopicCategorydt;
        ddlnTCategoryID.DataValueField = "nTCategoryID";
        ddlnTCategoryID.DataTextField  = "sTCategoryNameCN";
        ddlnTCategoryID.DataBind();
        AlbumList.Clear();
        DBLL.clsAlbum Album = new DBLL.clsAlbum();
        DataTable     dt    = new DataTable();

        dt = Album.sp_selectNormalTableOfAllByAlbum(false, int.Parse(ddlnTCategoryID.SelectedValue));
        if (dt != null)
        {
            AlbumList.Merge(dt);
            lvAlbumList.DataSource = AlbumList;
            lvAlbumList.DataBind();
        }
        else
        {
            lvAlbumList.DataSource = null;
            lvAlbumList.DataBind();
        }
    }
 public void SetTyp2Ablum(string sName, int nTCID)
 {
     MultiView1.ActiveViewIndex = 1;
     lblBigTitle.Text           = sName;
     DBLL.clsTopicCategory clstc = new DBLL.clsTopicCategory();
     DBLL.clsAlbum         clsa  = new DBLL.clsAlbum();
     dlAlbum.DataSource = clsa.Select_tb_AlbumBynTCategoryID(nTCID);
     dlAlbum.DataBind();
 }
Beispiel #3
0
    protected void ddlnTCategoryID_SelectedIndexChanged(object sender, EventArgs e)
    {
        AlbumList.Clear();
        DBLL.clsAlbum Album = new DBLL.clsAlbum();
        DataTable     dt    = new DataTable();

        dt = Album.sp_selectNormalTableOfAllByAlbum(false, int.Parse(ddlnTCategoryID.SelectedValue));
        if (dt != null)
        {
            AlbumList.Merge(dt);
            lvAlbumList.DataSource = AlbumList;
            lvAlbumList.DataBind();
        }
        else
        {
            lvAlbumList.DataSource = null;
            lvAlbumList.DataBind();
        }
    }
Beispiel #4
0
    //protected void lvTopicCategoryList_SelectedIndexChanging(object sender, ListViewSelectEventArgs e)
    //{
    //    Label lblnID = (Label)lvTopicCategoryList.Items[e.NewSelectedIndex].FindControl("lblnTCategoryID");
    //    int _nID = 0;
    //    DBLL.clsTopicCategory TopicCategory = new DBLL.clsTopicCategory();
    //    if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0)
    //    {
    //        MultiView1.ActiveViewIndex = 1;
    //        DBLL.DBcommon dbcom = new DBLL.DBcommon();
    //        DataTable Topicdt = dbcom.selectNormalTableofAll(false, "tb_Topic");
    //        ddlnTopicID.DataSource = Topicdt;
    //        ddlnTopicID.DataValueField = "nTopicID";
    //        ddlnTopicID.DataTextField = "sTopicNameCN";
    //        ddlnTopicID.DataBind();
    //        DataTable dt = TopicCategory.Select_tb_TopicCategoryBynTCategoryID(_nID);

    //        ddlnTopicID.SelectedValue = dt.Rows[0]["nTopicID"].ToString();
    //        txtsTCategoryNameCN.Text = dt.Rows[0]["sTCategoryNameCN"].ToString();
    //        txtsTCategoryNameEN.Text = dt.Rows[0]["sTCategoryNameEN"].ToString();
    //        rblnType.SelectedValue = dt.Rows[0]["nType"].ToString();
    //        if (rblnType.SelectedValue == "1")
    //        {
    //            CKEditorControl1.Enabled = true;
    //            CKEditorControl2.Enabled = true;
    //        }
    //        else
    //        {
    //            CKEditorControl1.Enabled = false;
    //            CKEditorControl2.Enabled = false;
    //        }
    //        CKEditorControl1.Text = dt.Rows[0]["sContentCN"].ToString();
    //        CKEditorControl2.Text = dt.Rows[0]["sContentEN"].ToString();
    //        ddlnSorting.SelectedValue = dt.Rows[0]["nSorting"].ToString();
    //        hfTopicCategoryUpdateID.Value = _nID.ToString();
    //    }
    //}
    protected void lvAlbumList_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {
        DBLL.clsAlbum Album  = new DBLL.clsAlbum();
        Label         lblnID = (Label)lvAlbumList.Items[e.ItemIndex].FindControl("lblnAlbumID");
        int           _nID   = 0;

        if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0)
        {
            bool Result = Album.sp_DeleteNormalTableByIDAlbum(int.Parse(_nID.ToString()), "tb_Album");
            if (Result)
            {
                //判断文件是不是存在
                Image  ImsImagePath        = (Image)lvAlbumList.Items[e.ItemIndex].FindControl("ImsImagePath");
                string sSaveFolderFullPath = Server.MapPath(ImsImagePath.ImageUrl);
                if (File.Exists(sSaveFolderFullPath))
                {
                    //如果存在则删除
                    File.Delete(sSaveFolderFullPath);
                }
            }
        }
        ReBindPageList();
    }
Beispiel #5
0
    protected void BtnAdd_Click(object sender, EventArgs e)
    {
        //判断session
        if (Session["User"] == null || Session["User"].ToString().Length < 1)
        {
            Response.Redirect(Request.RawUrl);
        }
        if (ValiAdd())
        {
            MutileUploaderUserControl21.SavePath(ddlnTCategoryID.SelectedItem.Text);

            for (int i = 0; i < MutileUploaderUserControl21.ImageDT.Rows.Count; i++)
            {
                Response.Write(MutileUploaderUserControl21.ImageDT.Rows[i]["sFilename"].ToString());
                DBLL.clsAlbum      Album  = new DBLL.clsAlbum();
                DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
                int _Result = 0;
                _Result = Album.insert_tb_Album(int.Parse(ddlnTCategoryID.SelectedValue), MutileUploaderUserControl21.ImageDT.Rows[i]["sImageNameCN"].ToString(), MutileUploaderUserControl21.ImageDT.Rows[i]["sImageNameEN"].ToString(), MutileUploaderUserControl21.filepathlist[i].ToString(), Session["User"].ToString(), DateTime.Now, Session["User"].ToString(), DateTime.Now, true, int.Parse(ddlnSorting.SelectedValue));

                if (_Result > 0)
                {
                    ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertSuccess");
                    ShowMsg1.Show();
                }
                else
                {
                    ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertFail");
                    ShowMsg1.Show();
                }
            }
            Response.Redirect("~/manage/Album/AddAlbum.aspx");
        }
        else
        {
            ShowMsg1.Show();
        }
    }