Exemple #1
0
    //发布文章
    protected void btnPublish_Click(object sender, EventArgs e)
    {
        string   artTitle   = txtArtTitle.Text;                    //文章标题
        int      artType    = int.Parse(ddlArtType.SelectedValue); //文章类别
        DateTime artPubTime = DateTime.Now;                        //文章发布时间
        //string artContent = CKEditorControl1.Text; //文章内容
        string artContent = Request.Params["content"];             //文章内容

        int       maxOrder = 0;
        string    sqlQuery = string.Format("select max(ArtOrder) from T_ARTICLE where ArtType={0}", artType);
        DataTable dtQuery  = SqlServerHooker.GetDataTable(sqlQuery);

        if (dtQuery == null || dtQuery.Rows[0][0].ToString() == "")
        {
            maxOrder = 1;
        }
        else
        {
            maxOrder = (int)dtQuery.Rows[0][0] + 1;
        }

        bool isSuc = true;

        if (radioList.SelectedIndex == 0) //新增文章
        {
            string sqlInsert = string.Format("insert into T_ARTICLE(ID,ArtType,ArtTitle,ArtDate,ArtContent,ArtOrder) values('{0}',{1},'{2}','{3}','{4}',{5})", Guid.NewGuid(), artType,
                                             artTitle, artPubTime.ToString("yyyy-MM-dd HH:mm:ss"), artContent, maxOrder);
            isSuc = SqlServerHooker.InsertDataToTable(sqlInsert);
        }
        else //更新文章
        {
            string sqlUpdate = string.Format("update T_ARTICLE set ArtType={0},ArtTitle='{1}',ArtContent='{2}' where ID='{3}'", artType,
                                             artTitle, artContent, _selectArtID);
            isSuc = SqlServerHooker.InsertDataToTable(sqlUpdate);
        }

        //生成静态html网页
        string url  = string.Format("http://127.0.0.1:8080/article/detail?type={0}&order={1}", artType, maxOrder);
        string id   = OtherTool.GuidTo16String();
        string path = Server.MapPath(string.Format("~/article/{0}.html", id));

        CreateStaticHtml.ReturnStaticHtml(url, path);

        //上传html文件
        bool isUpdateSuc = _ftpManager.UploadFile(path, "article/");

        File.Delete(path);

        //上传图片
        string ftpPath  = "ueditor/net/upload/image/";
        string imageDir = Server.MapPath("~/artpublish/ueditor/net/upload/image/");

        string[] filePaths  = Directory.GetFiles(imageDir);
        string   imageNames = string.Empty;

        foreach (string filePath in filePaths)
        {
            //压缩图片
            string newFilePath = Path.GetDirectoryName(filePath) + "\\" + Path.GetFileNameWithoutExtension(filePath) + "new" + Path.GetExtension(filePath);
            ResizeImage.GetPicThumbnail(filePath, newFilePath, 222, 650, 100);
            FileInfo fileInfo = new FileInfo(newFilePath);
            fileInfo.MoveTo(filePath);

            imageNames += Path.GetFileName(filePath) + ";";
            _ftpManager.UploadFile(filePath, ftpPath);

            File.Delete(filePath);
        }
        if (imageNames.Length > 0)
        {
            imageNames = imageNames.Remove(imageNames.Length - 1, 1);
        }

        string sqlUpdateUrl = string.Format("update T_ARTICLE set ArtUrl='{0}',ArtContent='',ArtImages='{3}' where ArtType={1} and ArtOrder={2}", id, artType, maxOrder, imageNames);

        isSuc = SqlServerHooker.UpdateDataToTable(sqlUpdateUrl);

        if (isSuc)
        {
            div_text.InnerText = isUpdateSuc.ToString() + "发布成功!";
            gvArtManager.DataBind();
        }
        else
        {
            div_text.InnerText = "发布失败!";
        }
    }