示例#1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     StringBuilder stringBuilder = new StringBuilder();
     HySearchArt hySearchArt = new HySearchArt();
     DataTable dt = hySearchArt.getData("", 10);
     string strArtType = "0";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             if (dt.Rows[i]["hy_url"].ToString() == "art_detail.aspx")
             {
                 strArtType = "1";
             }
             else if (dt.Rows[i]["hy_url"].ToString() == "photo_detail.aspx")
             {
                 strArtType = "2";
             }
             if (dt.Rows[i]["type"].ToString() == "1")
             {
                 stringBuilder.Append("<div><a onclick=\"locationDetail('" + dt.Rows[i]["hy_url"].ToString() + "','" + locationType + "','" + strArtType + "','0')\" ><img src=\"" + dt.Rows[i]["img"].ToString() + "\">" + dt.Rows[i]["hy_title"].ToString() + "</a></div>");
             }
             else if (dt.Rows[i]["type"].ToString() == "0")
             {
                 HyFileatt hyFileatt = new HyFileatt();
                 DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["img"].ToString());
                 if (dt_img.Rows.Count > 0)
                 {
                     stringBuilder.Append("<div><a onclick=\"locationDetail('" + dt.Rows[i]["hy_url"].ToString() + "','" + locationType + "','" + strArtType + "','0')\" ><img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\">" + dt.Rows[i]["hy_title"].ToString() + "</a></div>");
                 }
             }
         }
     }
     strShowData = stringBuilder.ToString();
 }
示例#2
0
    //删除图片
    protected void btndelinfo_Click(object sender, EventArgs e)
    {
        string ls_filepath1 = "", ls_filepath2 = "";
        TPortalClass.HyFileatt HyFileatt = new TPortalClass.HyFileatt();
        DataTable dt = HyFileatt.Getdocbyid(this.txtuids.Value);
        if (dt.Rows.Count > 0)
        {
            if (dt.Rows[0]["hy_fm"].ToString() == "1")
            {
                Response.Write("<script>alert('封面图片不能删除');window.location.href=window.location.href;</script>");
                return;
            }
            //删除文件夹里的图片
            ls_filepath1 = Server.MapPath("~/") + dt.Rows[0]["hy_filepath"].ToString();
            ls_filepath2 = Server.MapPath("~/") + dt.Rows[0]["hy_filepath"].ToString().Replace("thumbnail", "original");
            if (System.IO.File.Exists(ls_filepath1))
            {
                System.IO.File.Delete(ls_filepath1);
            }
            if (System.IO.File.Exists(ls_filepath2))
            {
                System.IO.File.Delete(ls_filepath2);
            }
        }

        //删除数据库记录
        HyFileatt.Delete(this.txtuids.Value);
        //操作日志
        TPortalClass.JpCommon HyCommon = new TPortalClass.JpCommon();
        //  HyCommon.WriteLog("删除图片", "删除图片ID:" + this.txtuids.Value, this.Session["hy_id"].ToString(), this.Session["hy_name"].ToString());
        // LoadingPictures();
        Response.Write("<script>location.replace(location);</script>");
    }
示例#3
0
    public string showNewGoods()
    {
        StringBuilder stringBuilder = new StringBuilder();
        JpGoods jpGoods = new JpGoods();
        DataTable dt = jpGoods.getNewsGood(10);
        string strTitle = "";
        for (int i = 0; i < dt.Rows.Count; i++)
        {

            strTitle = dt.Rows[i]["hy_goodsname"].ToString();
            if (strTitle.Length > 18)
            {
                strTitle = strTitle.Substring(0, 18);
            }
            stringBuilder.Append("<a onclick=\"locationDetail('" + dt.Rows[i]["hy_linkurl"].ToString() + "','" + locationType + "','0')\" > <li>");
            HyFileatt hyFileatt = new HyFileatt();
            DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
            if (dt_img.Rows.Count > 0)
            {
                stringBuilder.Append("<img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\">");
            }
            stringBuilder.Append("<p>" + strTitle + "</p>");
            stringBuilder.Append("<span>¥" + Convert.ToDecimal(dt.Rows[i]["hy_goodsprice"].ToString()).ToString("0.00") + "</span><i class=\"btn-dg\">订购</i></li></a>");
        }
        return stringBuilder.ToString();
    }
示例#4
0
    public string getExport()
    {
        StringBuilder stringBuilder = new StringBuilder();
        dt_expert dtExpert = new dt_expert();
        DataSet dt = dtExpert.GetListTop(10, "");
        DataTable dtImg = new DataTable();
        HyFileatt hyFileatt = new HyFileatt();

        if (dt.Tables[0].Rows.Count > 0)
        {

            for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
            {
                dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[i]["ID"].ToString());
                stringBuilder.Append("<li><a  target=\"_blank\"  href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[i]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">");
                if (dtImg.Rows.Count > 0)
                {
                    stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">");
                }
                else
                {
                    stringBuilder.Append("<img src=\"Images/Img.jpg\">");
                }
                dtImg.Clear();
                stringBuilder.Append("</a></li>");
            }
        }
        return stringBuilder.ToString();
    }
示例#5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Request.QueryString["aid"] != null)
        {
            aid = this.Request.QueryString["aid"].ToString();
        }
        this.txtcid.Value = cid;
        this.txtaid.Value = aid;
        this.lb_type.Text = "手摄一族";
        StringBuilder stringBuilder = new StringBuilder();
        JpPhotography jpPhotography = new JpPhotography();

        DataTable dt = jpPhotography.Getdocbyid(Convert.ToInt32(aid));
        if (dt.Rows.Count > 0)
        {
            this.lb_time.Text = Convert.ToDateTime(dt.Rows[0]["hy_addtime"].ToString()).ToString("yyyy年MM月dd日");
            this.lb_title.Text = dt.Rows[0]["hy_content"].ToString();
            HyFileatt hyFileatt = new HyFileatt();
            DataTable dt_img = hyFileatt.Getdocs(dt.Rows[0]["docid"].ToString(), 8);
            for (int i = 0; i < dt_img.Rows.Count; i++)
            {
                imgPath += "<img src=\"" + dt_img.Rows[i]["hy_filepath"].ToString() + "\" width=\"640\" height=\"340\">";
            }
            this.lb_article.Text = dt.Rows[0]["hy_content"].ToString();
        }
    }
示例#6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";

        string ls_update = "";
        string ls_filename = "";
        string ls_path = "";
        string ls_id = Request.Form["id"].ToString();
        if (Request.Files["file"].ContentLength > 0)
        {
            try
            {
                string updir = Server.MapPath("~/") + "upload\\original\\20159\\";
                TPortalClass.HyFileatt Hyoa_fileatt = new TPortalClass.HyFileatt();
                HttpPostedFile uploadFile = Request.Files["file"];

                //if (uploadFile.ContentLength > 0)
                //{
                    if (!Directory.Exists(updir))
                    {
                        Directory.CreateDirectory(updir);
                    }
                    //string extname = Path.GetExtension(uploadFile.FileName);

                    //string filename = uploadFile.FileName;
                    //lsfilename = filename;
                    //lsurl = "fileatt\\" + filename; //存放的文件夹
                    //uploadFile.SaveAs(string.Format("{0}\\{1}", updir, filename));
                    string ls_docid = System.Guid.NewGuid().ToString();
                    ls_filename = ls_docid + ".png";
                    uploadFile.SaveAs(updir + ls_filename);
                    ls_path = "/upload/original/20159/" + ls_filename;
                    Hyoa_fileatt.id = ls_docid;
                    Hyoa_fileatt.hy_filepath = ls_path;
                    Hyoa_fileatt.hy_fatherid = ls_id;
                    Hyoa_fileatt.hy_filesize = "";
                    Hyoa_fileatt.hy_userid = "";
                    Hyoa_fileatt.hy_addtime = System.DateTime.Now.ToString();
                    Hyoa_fileatt.hy_filename = ls_filename;
                    if (Hyoa_fileatt.IsExist(ls_id))
                    {
                        Hyoa_fileatt.hy_fm = 0;
                    }
                    else
                    {
                        Hyoa_fileatt.hy_fm = 1;
                    }
                    Hyoa_fileatt.Insert();

                //}
            }
            catch (Exception ex)
            {
                Response.Write("Message"+ ex.ToString());
            }
        }
    }
示例#7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     StringBuilder stringBuilder = new StringBuilder();
     dt_expert dtExpert = new dt_expert();
     DataSet dt = dtExpert.GetList("");
     DataTable dtImg = new DataTable();
     HyFileatt hyFileatt = new HyFileatt();
     //控制数据条数
     int s = 0;
     if (dt.Tables[0].Rows.Count > 0)
     {
         //分行
         int n = 0;
         if ((dt.Tables[0].Rows.Count) % 4 == 0)
         {
             n = (dt.Tables[0].Rows.Count) / (4);
         }
         else
         {
             n = ((dt.Tables[0].Rows.Count) / (4)) + 1;
         }
         //构造列
         for (int i = 0; i < n; ++i)
         {
             stringBuilder.Append("<ul>");
             //控制循环条件
             int m = 0;
             if ((dt.Tables[0].Rows.Count - (i * 4)) > 4)
             {
                 m = 4;
             }
             else
             {
                 m = dt.Tables[0].Rows.Count - (i * 4);
             }
             for (int j = 0; j < m; j++)
             {
                 dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[s]["ID"].ToString());
                 stringBuilder.Append("<li><a href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[s]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">");
                 if (dtImg.Rows.Count > 0)
                 {
                     stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">");
                 }
                 else
                 {
                     stringBuilder.Append("<img src=\"Images/Img.jpg\">");
                 }
                 dtImg.Clear();
                 stringBuilder.Append("<dt align=\"center\" >" + dt.Tables[0].Rows[s]["dt_name"].ToString() + "</dt></a></li>");
                 s++;
             }
             stringBuilder.Append("</ul>");
         }
     }
     this.lb_show.Text = stringBuilder.ToString();
 }
示例#8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string ls_page = "1", ls_pagesize = "10";
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        //获取参数
        if (this.Request.QueryString["page"] != null)
        {
            ls_page = this.Request.QueryString["page"].ToString();
        }
        if (this.Request.QueryString["pagesize"] != null)
        {
            ls_pagesize = this.Request.QueryString["pagesize"].ToString();
        }

        string ls_where = " and hy_ifsh ='2' ";
        string ls_orderby = " order by hy_addtime desc ";
        JpPhotography jpPhotography = new JpPhotography();
        //获取数据
        string test = "";
        DataTable dt = jpPhotography.SearchdocsByKey(ls_where,ls_orderby, int.Parse(ls_page), int.Parse(ls_pagesize));
        Response.Write(test);
        //复制一个DataTalbe
        DataTable tempTable = dt.Clone();
        //在现有的DatatTable增加一列
        DataColumn col = new DataColumn("showTime", typeof(String));
        //将列添加到DataTable中去
        tempTable.Columns.Add(col);
        //在现有的DatatTable增加一列
        DataColumn co2 = new DataColumn("showImg", typeof(String));
        //将列添加到DataTable中去
        tempTable.Columns.Add(co2);
        //循环  对DataTable重新赋值
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = tempTable.NewRow();
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                dr[tempTable.Columns[j].ColumnName] = dt.Rows[i][j];
            }
            //获得间隔的时间
            dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["hy_addtime"].ToString()));
            HyFileatt hyFileatt = new HyFileatt();
            DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
            if (dt_img.Rows.Count > 0)
            {
                dr["showImg"] = dt_img.Rows[0]["hy_filepath"].ToString();
            }
            tempTable.Rows.Add(dr);
        }
        //转换成json格式
        string strJson = JsonConvert.SerializeObject(tempTable);
        //数据抛出
        Response.Write(strJson);
    }
示例#9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     string strFatherid = "";
     if (this.Request.QueryString["strFatherid"] != null)
     {
         strFatherid = this.Request.QueryString["strFatherid"].ToString();
     }
     HyFileatt hyFileatt = new HyFileatt();
     DataTable dt = hyFileatt.Getdocs(strFatherid,6);
     string json = JsonConvert.SerializeObject(dt);
     Response.Write(json);
 }
示例#10
0
    //加载图片
    protected string LoadingPictures()
    {
        string ls_return = "";
        //预览图片
        TPortalClass.HyFileatt HyFileatt = new TPortalClass.HyFileatt();
        DataTable dt = HyFileatt.Getdocs(this.txtdocid.Value,8);
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string ls_id = dt.Rows[i]["id"].ToString();
                string ls_name = dt.Rows[i]["hy_filename"].ToString();
                string ls_url = dt.Rows[i]["hy_filepath"].ToString();
                //string ls_url2 = dt.Rows[i]["hy_filepath"].ToString().Replace("thumbnail", "original");

                ls_return += "<table width=\"130\" border=\"0\" cellpadding=\"0\" cellspacing=\"2\" bgcolor=\"#FFFFFF\"";
                ls_return += "style=\"float: left; margin: 2px 2px 2px 2px;font-size: 12px;\">";
                ls_return += "<tr><td align=\"left\" height=\"140\" valign=\"top\">";

                //ls_return += "<div class=\"pic01\"><a href='" + ls_url2 + "' onclick=\"szfm('" + ls_id + "');\" target='_blank'>";
                ls_return += "<div class=\"pic01\"><a href='#' onclick=\"szfm('" + ls_id + "');\" >";
                ls_return += "<img src=\"" + ls_url + "\" border=\"0\" width=\"126\" height=\"126\" alt=\"" + ls_name + "(点击设置封面)\" /></a></div>";
                ls_return += "<div class=\"photo_fm\">";
                if (HyFileatt.IsExistByID(ls_id))
                {
                    ls_return += "<img src=\"/images/fm.png\" alt='' />";
                }
                ls_return += "</div>";
                ls_return += "<div class=\"option01\"><span style='float:left;text-align:left;'>";
                if (ls_name.Length > 6)
                {
                    ls_return += "&nbsp;" + ls_name.Substring(0, 6) + "...";
                }
                else
                {
                    ls_return += "&nbsp;" + ls_name;
                }
                ls_return += "</span>";
                ls_return += "<span style='float:right;text-align:right;'><a href='#' onclick=\"DelInfo('" + ls_id + "');\">【删除】</a></span>";
                ls_return += "</div>";

                ls_return += "</td>";
                ls_return += "</tr>";
                ls_return += "</table>";
            }
        }
        return ls_return;
    }
示例#11
0
 public string RptBind()
 {
     //获取数据
     StringBuilder stringBuilder = new StringBuilder();
     JpGoods jpGoods = new JpGoods();
     string strWhere = "";
     if (strType == "0")
     {
         strWhere = " and hy_cid like '" + cid + "%' and hy_ifsh='2' ";
     }
     else if (strType == "1")
     {
         strWhere = " and hy_cid like '" + cid + "%' and hy_ifsh='2' ";
     }
     else if (strType == "2")
     {
         strWhere = " and hy_cid like '" + cid + "%' and hy_ifsh='2' ";
     }
     else if (strType == "3")
     {
         strWhere = " and hy_cid like '" + cid + "%' and hy_ifsh='2' ";
     }
     DataTable dt = jpGoods.getDataByCid(10, strWhere);
     string strTitle = "";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             strTitle = dt.Rows[i]["hy_goodsname"].ToString();
             if (strTitle.Length > 18)
             {
                 strTitle = strTitle.Substring(0, 18) + "...";
             }
             stringBuilder.Append("<li>");
             HyFileatt hyFileatt = new HyFileatt();
             DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
             if (dt_img.Rows.Count > 0)
             {
                 stringBuilder.Append("<a onclick=\"locationDetail('" + dt.Rows[i]["hy_linkurl"].ToString() + "','" + locationType + "')\"><img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\">");
             }
             stringBuilder.Append("<h1>");
             stringBuilder.Append("" + strTitle + "</h1><p class=\"fleft\">" + JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["hy_addtime"].ToString())) + "</p></a></li>");
         }
     }
     return stringBuilder.ToString();
 }
示例#12
0
    //设置封面
    protected void btnSzfm_Click(object sender, EventArgs e)
    {
        TPortalClass.HyFileatt HyFileatt = new TPortalClass.HyFileatt();
        DataTable dt = HyFileatt.Getdocsfm(this.txtdocid.Value);
        if (dt.Rows.Count > 0)
        {
            HyFileatt.id = dt.Rows[0]["id"].ToString();
            HyFileatt.hy_fm = 0;
            HyFileatt.UpdateFM();
        }

        HyFileatt.id = this.txtfmid.Value;
        HyFileatt.hy_fm = 1;
        HyFileatt.UpdateFM();

        //操作日志
        //  TPortalClass.HyCommon HyCommon = new TPortalClass.HyCommon();
        //  HyCommon.WriteLog("设置封面", "设置封面图片ID:" + this.txtdocid.Value, this.Session["hy_id"].ToString(), this.Session["hy_name"].ToString());
        Response.Write("<script>location.replace(location);</script>");
    }
示例#13
0
 protected void btnDel_Click(object sender, EventArgs e)
 {
     HyFileatt hyFileatt = new HyFileatt();
     DataTable dt = hyFileatt.Getdocbyid(this.delId.Value);
     //删除文件夹里的图片
     if (dt.Rows.Count > 0)
     {
         string ls_filepath1 = Server.MapPath("~/") + dt.Rows[0]["hy_filepath"].ToString();
         string ls_filepath2 = Server.MapPath("~/") + dt.Rows[0]["hy_filepath"].ToString().Replace("thumbnail", "original");
         if (System.IO.File.Exists(ls_filepath1))
         {
             System.IO.File.Delete(ls_filepath1);
         }
         if (System.IO.File.Exists(ls_filepath2))
         {
             System.IO.File.Delete(ls_filepath2);
         }
     }
     hyFileatt.DeleteImg(this.delId.Value);
     ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>hymainajax_img('" + this.txtDocid.Value + "');</script>");
 }
示例#14
0
    public void showData(string strOrder)
    {
        string ls_where = " and hy_ifsh ='2'  ";
        string ls_orderby = " ";
        if (strOrder == "1")
        {
            ls_orderby += " order by praiseCount desc  ";
        }
        else
        {
            ls_orderby += " order by hy_addtime desc  ";
        }
        JpPhotography JpPhotography = new JpPhotography();
        int colcous = 1;
        //获取数据
        StringBuilder stringBuilder = new StringBuilder();
        DataTable dt = JpPhotography.SearchdocsByKey(ls_where, ls_orderby, 1, 10);
        string strTitle = "";
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                strTitle = dt.Rows[i]["hy_content"].ToString();
                if (strTitle.Length > 10)
                {
                    strTitle = strTitle.Substring(0, 10) + "...";
                }
                stringBuilder.Append("<li><a onclick=\"locationDetail('photo_detail.aspx?aid=" + dt.Rows[i]["id"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "','" + locationType + "','2')\"><div class='pplist'><p class=\"ico-tx\"><img src=\"images/321tx.png\" style='width: 30px;height: 30px; display:block; float:left;'><span>" + dt.Rows[i]["hy_uid"].ToString() + "</span></p><p>" + strTitle + "</p>");
                HyFileatt hyFileatt = new HyFileatt();
                DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
                if (dt_img.Rows.Count > 0)
                {
                    stringBuilder.Append("<img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\">");
                }

                stringBuilder.Append("</div>点攒数:" + dt.Rows[i]["praiseCount"].ToString() + "</a></li>");
            }
        }
        this.lb_show.Text = stringBuilder.ToString();
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (this.Request.QueryString["docid"] != null)
     {
         strDocid = this.Request.QueryString["docid"].ToString();
     }
     StringBuilder stringBuilder = new StringBuilder();
     dt_expert dtExpert = new dt_expert();
     dtExpert.ID = strDocid;
     DataSet dt = dtExpert.GetListById();
     DataTable dtImg = new DataTable();
     HyFileatt hyFileatt = new HyFileatt();
     dtImg = hyFileatt.Getdocsfm(strDocid);
     stringBuilder.Append("<div class=\"exp_Bottom\">");
     if (dt.Tables[0].Rows.Count > 0 && dtImg.Rows.Count > 0)
     {
         stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">");
         stringBuilder.Append("<span>" + dt.Tables[0].Rows[0]["dt_name"].ToString() + "</span><p>");
         stringBuilder.Append(dt.Tables[0].Rows[0]["dt_summary"].ToString());
     }
     stringBuilder.Append("</p></div>");
     this.lb_show.Text = stringBuilder.ToString();
 }
示例#16
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (this.Request.QueryString["id"] != null)
     {
         try
         {
             id = Convert.ToInt32(this.Request.QueryString["id"].ToString());
         }
         catch
         {
             id = 1;
         }
     }
     this.lb_type.Text = "往期回顾";
     JpArticle jpArticle = new JpArticle();
     DataTable dt = jpArticle.GetArticleByaid(id);
     HyFileatt HyFileatt = new HyFileatt();
     if (dt.Rows.Count > 0)
     {
         this.lb_time.Text = Convert.ToDateTime(dt.Rows[0]["crtime"].ToString()).ToString("yyyy年MM月dd日");
         this.lb_title.Text = dt.Rows[0]["title"].ToString();
         this.lb_article.Text = dt.Rows[0]["ht_content"].ToString();
     }
 }
示例#17
0
 public string showActive()
 {
     StringBuilder stringBuilder = new StringBuilder();
     JpActivity jpActivity = new JpActivity();
     DataTable dt = jpActivity.getActive(5);
     HyFileatt HyFileatt = new HyFileatt();
     string strTitle = "";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             strTitle = dt.Rows[i]["hy_bt"].ToString();
             if (strTitle.Length > 20)
             {
                 strTitle = strTitle.Substring(0, 20) + "...";
             }
             stringBuilder.Append("<div class=\"wszw\">" + Convert.ToDateTime(dt.Rows[i]["hy_addtime"].ToString()).ToString("mm:ss") + "</div>");
             stringBuilder.Append("<div class=\"jptx\"><a  onclick=\"locationDetail('active_detail.aspx?id=" + dt.Rows[i]["id"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "','" + locationType + "','0')\" href=\"javascript:void(0);\" >");
             stringBuilder.Append("<div class=\"jptxpp\">");
             DataTable dt_img = HyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
             if (dt_img.Rows.Count > 0)
             {
                 stringBuilder.Append("<span><img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\" alt=\"" + strTitle + "\" /></span>");
             }
             else
             {
                 stringBuilder.Append("<span><img src=\"nophoto.jpg\" alt=\"" + strTitle + "\" /></span>");
             }
             //nophoto
             stringBuilder.Append("<div class=\"jptxsub\"><span>" + strTitle + "</span></a><i class=\"ico-bm\" onclick=\"hdbm('" + dt.Rows[i]["id"].ToString() + "')\" >报名</i></div>");
             stringBuilder.Append("</div></a>");
             stringBuilder.Append("</div>");
         }
     }
     return stringBuilder.ToString();
 }
示例#18
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (this.txtUid.Value != "")
     {
         this.Session["hyuid"] = this.txtUid.Value;
     }
     if (this.Request.QueryString["id"] != null)
     {
         try
         {
             id = Convert.ToInt32(this.Request.QueryString["id"].ToString());
         }
         catch
         {
             id = 1;
         }
     }
     this.txtaid.Value = id.ToString();
     this.txtcid.Value = "008";
     this.lb_type.Text = "金点活动";
     StringBuilder stringBuilder = new StringBuilder();
     JpActivity jpActivity = new JpActivity();
     DataTable dt = jpActivity.Getdocbyid(id);
     HyFileatt HyFileatt = new HyFileatt();
     if (dt.Rows.Count > 0)
     {
         this.lb_time.Text = Convert.ToDateTime(dt.Rows[0]["hy_addtime"].ToString()).ToString("yyyy年MM月dd日");
         this.lb_title.Text = dt.Rows[0]["hy_bt"].ToString();
         DataTable dt_img = HyFileatt.Getdocs(dt.Rows[0]["docid"].ToString(), 1);
         if (dt_img.Rows.Count > 0)
         {
             imgPath = dt_img.Rows[0]["hy_filepath"].ToString();
         }
         this.lb_article.Text = dt.Rows[0]["hy_content"].ToString();
     }
 }
示例#19
0
 protected void Page_Load(object sender, EventArgs e)
 {
     string strCid = "";
     int ls_page = 1, ls_pagesize = 10;
     string strType = "";
     TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
     //获取参数
     if (this.Request.QueryString["cid"] != null)
     {
         strCid = this.Request.QueryString["cid"].ToString();
     }
     if (this.Request.QueryString["page"] != null)
     {
         ls_page = Convert.ToInt32(this.Request.QueryString["page"].ToString());
     }
     if (this.Request.QueryString["pagesize"] != null)
     {
         ls_pagesize = Convert.ToInt32(this.Request.QueryString["pagesize"].ToString());
     }
     if (this.Request.QueryString["type"] != null)
     {
         strType = this.Request.QueryString["type"].ToString();
     }
     JpGoods jpGoods = new JpGoods();
     string strWhere = " and  hy_cid like '" + strCid + "%' and hy_ifsh='2' ";
     if (strType == "0")
     {
         strWhere = " and hy_cid like '" + strCid + "%' and hy_ifsh='2' ";
     }
     else if (strType == "1")
     {
         strWhere = " and (hy_cid = '006001001' or hy_cid='006002001' or  hy_cid='006003001'  or  hy_cid='006004001') and hy_ifsh='2' ";
     }
     else if (strType == "2")
     {
         strWhere = " and (hy_cid = '006001002' or hy_cid='006002002' or  hy_cid='006003002'  or  hy_cid='006004002') and hy_ifsh='2' ";
     }
     else if (strType == "3")
     {
         strWhere = " and (hy_cid = '006001003' or hy_cid='006002003' or  hy_cid='006003003'  or  hy_cid='006004003') and hy_ifsh='2' ";
     }
     string orderby = " order by hy_addtime desc ";
     //获取数据
     DataTable dt = jpGoods.SearchdocsByKey(strWhere, orderby, ls_page, ls_pagesize);
     //复制一个DataTalbe
     DataTable tempTable = dt.Clone();
     //在现有的DatatTable增加一列
     DataColumn col = new DataColumn("showImg", typeof(String));
     //将列添加到DataTable中去
     tempTable.Columns.Add(col);
     DataColumn col2 = new DataColumn("showTime", typeof(String));
     //将列添加到DataTable中去
     tempTable.Columns.Add(col2);
     //循环  对DataTable重新赋值
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         DataRow dr = tempTable.NewRow();
         for (int j = 0; j < dt.Columns.Count; j++)
         {
             dr[tempTable.Columns[j].ColumnName] = dt.Rows[i][j];
         }
         //获得间隔的时间
         HyFileatt hyFileatt = new HyFileatt();
         DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
         if (dt_img.Rows.Count > 0)
         {
             dr["showImg"] = dt_img.Rows[0]["hy_filepath"].ToString();
         }
         dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["hy_addtime"].ToString()));
         tempTable.Rows.Add(dr);
     }
     //转换成json格式
     string strJson = JsonConvert.SerializeObject(tempTable);
     //数据抛出
     Response.Write(strJson);
 }
示例#20
0
 public string showRollingActive()
 {
     StringBuilder stringBuilder = new StringBuilder();
     JpActivity jpActivity = new JpActivity();
     DataTable dt = jpActivity.getActive(5);
     HyFileatt HyFileatt = new HyFileatt();
     string strTitle = "";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             strTitle = dt.Rows[i]["hy_bt"].ToString();
             if (strTitle.Length > 20)
             {
                 strTitle = strTitle.Substring(0, 20) + "...";
             }
             stringBuilder.Append("<li>");
             stringBuilder.Append("<div class=\"slide\">");
             DataTable dt_img = HyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
             if (dt_img.Rows.Count > 0)
             {
                 stringBuilder.Append("<span><a onclick=\"locationDetail('active_detail.aspx?id=" + dt.Rows[i]["id"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "','" + locationType + "','0')\" href=\"javascript:void(0);\" ><img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\" alt=\"" + strTitle + "\"/></span>");
             }
             stringBuilder.Append("<div class=\"caption\">");
             stringBuilder.Append("<p class=\"title\" >" + strTitle + "</a></p>");
             stringBuilder.Append("</div>");
             stringBuilder.Append("</div>");
             stringBuilder.Append("</li>");
         }
     }
     return stringBuilder.ToString();
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Request.QueryString["page"] != null)
        {
            try
            {
                pageNo = Convert.ToInt32(this.Request.QueryString["page"].ToString());
            }
            catch
            {
                pageNo = 1;
            }

        }
        StringBuilder stringBuilder = new StringBuilder();
        dt_expert dtExpert = new dt_expert();
        DataSet dt = dtExpert.GetListPage(pageNo, pageSize, "");
        DataSet dtDataSet = dtExpert.GetList("");
        totalPage = dtDataSet.Tables[0].Rows.Count / pageSize;
        if (dtDataSet.Tables[0].Rows.Count % pageSize > 0)
        {
            totalPage++;
        }
        this.lb_page.Text = HyCommon.page("\"#Pagle\"", pageNo.ToString(), pageSize.ToString(), totalPage.ToString(), "");
        DataTable dtImg = new DataTable();
        HyFileatt hyFileatt = new HyFileatt();
        //控制数据条数
        int s = 0;
        if (dt.Tables[0].Rows.Count > 0)
        {
            //分行
            int n = 0;
            if ((dt.Tables[0].Rows.Count) % 4 == 0)
            {
                n = (dt.Tables[0].Rows.Count) / (4);
            }
            else
            {
                n = ((dt.Tables[0].Rows.Count) / (4)) + 1;
            }
            //构造列
            for (int i = 0; i < n; ++i)
            {
                stringBuilder.Append("<ul>");
                //控制循环条件
                int m = 0;
                if ((dt.Tables[0].Rows.Count - (i * 4)) > 4)
                {
                    m = 4;
                }
                else
                {
                    m = dt.Tables[0].Rows.Count - (i * 4);
                }
                for (int j = 0; j < m; j++)
                {
                    dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[s]["ID"].ToString());
                    stringBuilder.Append("<li><a href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[s]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">");
                    if (dtImg.Rows.Count > 0)
                    {
                        stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">");
                    }
                    else
                    {
                        stringBuilder.Append("<img src=\"Images/Img.jpg\">");
                    }
                    dtImg.Clear();
                    stringBuilder.Append("<dt align=\"center\" >" + dt.Tables[0].Rows[s]["dt_name"].ToString() + "</dt></a></li>");
                    s++;
                }
                stringBuilder.Append("</ul>");
            }
        }
        this.lb_show.Text = stringBuilder.ToString();
    }
示例#22
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Session["uploadmessage"] = "";

        Response.CacheControl = "no-cache";

        string lspath = "";
        string ls_fatherid = Request.Params["docid"].ToString();
        string ls_userid = Request.Params["userid"].ToString();

        TPortalClass.HyCommon HyCommon = new TPortalClass.HyCommon();

        if (this.Page.Request.Files.Count > 0)
        {
            int k = 0;
            if (this.Page.Request.Files.Count > 8)
            {
                k = 8;
            }
            else
            {
                k = this.Page.Request.Files.Count;
            }
            try
            {
                for (int j = 0; j < k; j++)
                {
                    HttpPostedFile uploadFile = this.Page.Request.Files[j];

                    if (uploadFile.ContentLength > 0)
                    {
                        string ls_ny = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString();
                        string ls_name = uploadFile.FileName;
                        string filename = DateTime.Now.ToString("mmddhhMMss_") + uploadFile.FileName;

                        //将附件上传到服务器目录下
                        lspath = Server.MapPath("~/");  //虚拟目录的位置
                        string lsurl1 = "/upload/original/" + ls_ny;  //原图存放的文件夹
                        string lsurl2 = "/upload/thumbnail/" + ls_ny;    //缩略图存放的文件夹
                        Directory.CreateDirectory(lspath + "/" + lsurl1);
                        Directory.CreateDirectory(lspath + "/" + lsurl2);
                        string str_path1 = lspath + "/" + lsurl1 + "/" + filename;
                        string str_path2 = lspath + "/" + lsurl2 + "/" + filename;
                        uploadFile.SaveAs(str_path1);
                        //压缩图片处理
                        HyCommon.MakeThumbnail(str_path1, str_path2, 290, 290, "WH");

                        //保存数据
                        TPortalClass.HyFileatt HyFileatt = new TPortalClass.HyFileatt();
                        HyFileatt.id = System.Guid.NewGuid().ToString();
                        HyFileatt.hy_addtime = System.DateTime.Now.ToString("yyyy-MM-dd");
                        HyFileatt.hy_fatherid = ls_fatherid;
                        HyFileatt.hy_userid = ls_userid;
                        HyFileatt.hy_filepath = lsurl2 + "/" + filename;
                        HyFileatt.hy_filesize = "";
                        if (HyFileatt.IsExist(ls_fatherid))
                        {
                            HyFileatt.hy_fm = 0;
                        }
                        else
                        {
                            HyFileatt.hy_fm = 1;
                        }
                        if (ls_name.IndexOf(".") >= 0)
                        {
                            HyFileatt.hy_filename = ls_name.Substring(0, ls_name.LastIndexOf("."));
                        }
                        else
                        {
                            HyFileatt.hy_filename = "";
                        }
                        HyFileatt.Insert();
                        //操作日志

                        HyCommon.WriteLog("上传图片", "上传图片", ls_userid, ls_userid);
                    }
                }
            }
            catch (Exception ex)
            {
                Response.Write("Message" + ex.ToString());
            }
            finally
            {
            }
        }
    }
示例#23
0
 public string showScroll()
 {
     StringBuilder stringBuilder = new StringBuilder();
     JpGoods jpGoods = new JpGoods();
     DataTable dt = jpGoods.getNewsGood(5);
     string strTitle = "";
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         strTitle = dt.Rows[i]["hy_goodsname"].ToString();
         if (strTitle.Length > 18)
         {
             strTitle = strTitle.Substring(0, 18);
         }
         stringBuilder.Append("<li>");
         stringBuilder.Append("<div class=\"slide\">");
         HyFileatt hyFileatt = new HyFileatt();
         DataTable dt_img = hyFileatt.Getdocsfm(dt.Rows[i]["docid"].ToString());
         if (dt_img.Rows.Count > 0)
         {
             stringBuilder.Append("<a onclick=\"locationDetail('" + dt.Rows[i]["hy_linkurl"].ToString() + "','" + locationType + "','0')\" ><img src=\"" + dt_img.Rows[0]["hy_filepath"].ToString() + "\" alt=\"" + strTitle + "\" >");
         }
         stringBuilder.Append("<div class=\"caption\">");
         stringBuilder.Append("<p class=\"title\">" + strTitle + "</p>");
         stringBuilder.Append("</div></a>");
         stringBuilder.Append("</div>");
         stringBuilder.Append("</li>");
     }
     return stringBuilder.ToString();
 }