Пример #1
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        #region --删除
        if (e.CommandName == "cmdDelete")
        {
            Tz888.BLL.TPVideo          bllobj = new Tz888.BLL.TPVideo();
            Tz888.SQLServerDAL.TPVideo tpobj  = new Tz888.SQLServerDAL.TPVideo();

            DataSet ds = tpobj.GetOneVideoMess(e.CommandArgument.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                try
                {
                    string strHtmlURL = ds.Tables[0].Rows[0]["HtmlURL"].ToString();
                    Tz888.Common.FileManage.FileDelete(strHtmlURL);
                }
                catch { }
            }
            bool isSuccess = false;
            isSuccess = bllobj.DeleteVideoMess(e.CommandArgument.ToString());
            if (isSuccess)
            {
                Response.Redirect(Request.RawUrl);
            }
            else
            {
                Response.Write("<script>alert('对编号为" + e.CommandArgument.ToString() + "的删除操作失败。'); </script>");
                return;
            }
        }
        #endregion
    }
Пример #2
0
    private void GetInfoVideo()
    {
        long   CurrentPage    = Convert.ToInt64(this.AspNetPager.CurrentPageIndex);
        long   PageNum        = Convert.ToInt64(this.AspNetPager.PageSize);
        long   TotalCount     = 0;
        long   PageCount      = 1;
        string MerchantDomain = (string)ConfigurationManager.AppSettings["MerchantDomain"];

        Tz888.BLL.TPVideo srvSI = new Tz888.BLL.TPVideo();

        DataSet   ds     = srvSI.dsGetVideoMess("*", ViewState["Criteria"].ToString(), "publishT desc", CurrentPage, PageNum, out TotalCount);
        DataTable dtdata = MakeTable();

        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            DataRow drs = dtdata.NewRow();
            drs["InfoID"]             = dr["InfoID"].ToString();
            drs["href"]               = MerchantDomain + "/videodetails.aspx?id=" + dr["InfoID"].ToString();
            drs["Title"]              = dr["Title"].ToString();
            drs["GradeID"]            = dr["GradeID"].ToString();
            drs["publishT"]           = dr["publishT"].ToString();
            drs["LoginName"]          = dr["LoginName"].ToString();
            drs["Origin"]             = dr["Origin"].ToString();
            drs["IsCore"]             = dr["IsCore"].ToString();
            drs["AuditingStatusDesc"] = dr["AuditingStatusDesc"].ToString();
            dtdata.Rows.Add(drs);
        }
        this.AspNetPager.RecordCount = Convert.ToInt32(TotalCount);
        GridView1.DataSource         = dtdata.DefaultView;

        this.GridView1.DataBind();
        if (TotalCount % PageNum > 0)
        {
            PageCount = TotalCount / PageNum + 1;
        }
        else
        {
            PageCount = TotalCount / PageNum;
        }

        this.pinfo.InnerText = "共" + PageCount + "页";
        this.LblCount.Text   = TotalCount.ToString();


        if (ds.Tables[0].Rows.Count <= 0)
        {
            this.NoMessage.Style.Value = "display:block";
            this.dvCheck.Style.Value   = "display:none";
            this.pinfo2.Style.Value    = "display:none";
        }
        else
        {
            this.NoMessage.Style.Value = "display:none";
            this.dvCheck.Style.Value   = "display:block";
            this.pinfo2.Style.Value    = "display:block";
        }
    }
Пример #3
0
    private void GetInfoVideo()
    {
        long CurrentPage = Convert.ToInt64(this.AspNetPager.CurrentPageIndex);
        long PageNum     = Convert.ToInt64(this.AspNetPager.PageSize);
        long TotalCount  = 0;
        long PageCount   = 1;

        Tz888.BLL.TPVideo srvSI = new Tz888.BLL.TPVideo();

        DataSet ds = srvSI.dsGetVideoMess("*", ViewState["Criteria"].ToString(), "publishT desc", CurrentPage, PageNum, out TotalCount);

        this.AspNetPager.RecordCount = Convert.ToInt32(TotalCount);
        GridView1.DataSource         = ds.Tables[0].DefaultView;

        this.GridView1.DataBind();
        if (TotalCount % PageNum > 0)
        {
            PageCount = TotalCount / PageNum + 1;
        }
        else
        {
            PageCount = TotalCount / PageNum;
        }

        this.pinfo.InnerText = "共" + PageCount + "页";
        this.LblCount.Text   = TotalCount.ToString();


        if (ds.Tables[0].Rows.Count <= 0)
        {
            this.NoMessage.Style.Value = "display:block";
            this.dvCheck.Style.Value   = "display:none";
            this.pinfo2.Style.Value    = "display:none";
        }
        else
        {
            this.NoMessage.Style.Value = "display:none";
            this.dvCheck.Style.Value   = "display:block";
            this.pinfo2.Style.Value    = "display:block";
        }
    }
Пример #4
0
    private void BathchDelete()
    {
        string idLst = Request.Form["chk"];

        if (idLst.Length > 0)
        {
            Tz888.BLL.TPVideo bllobj = new Tz888.BLL.TPVideo();
            string[]          lst    = idLst.Split(',');
            for (int i = 0; i < lst.Length; i++)
            {
                Tz888.SQLServerDAL.TPVideo tpobj = new Tz888.SQLServerDAL.TPVideo();
                DataSet ds = tpobj.GetOneVideoMess(lst[i].ToString());
                if (ds.Tables[0].Rows.Count > 0)
                {
                    try
                    {
                        string strHtmlURL = ds.Tables[0].Rows[0]["HtmlURL"].ToString();
                        Tz888.Common.FileManage.FileDelete(strHtmlURL);
                    }
                    catch { }
                }
            }

            bool isSuccess = false;
            isSuccess = bllobj.DeleteVideoMess(idLst);

            if (isSuccess)
            {
                Response.Redirect(Request.RawUrl.Substring(0, Request.RawUrl.IndexOf("?")));
            }
            else
            {
                Response.Write("<script>alert('部分删除操作失败。'); </script>");
            }
        }
    }