public static void InsertComment(long articleId, long article_id)
        {
            //int count = SelectComment(article_id);
            //if (count > 0)
            //{
            //    DelComment(article_id);
            //}
            try
            {
                DataTable      dt = new DataTable();
                DataConnection dc = new DataConnection();
                //获取Comment评论表的数据
                string sql = "select * from ra_pbComment where ParentID=" + articleId;
                dt = dc.FillDataTable(sql);
                foreach (DataRow dr in dt.Rows)
                {
                    int      parentID   = Convert.ToInt32(dr["ParentID"]);
                    string   body       = Convert.ToString(dr["Body"]);
                    string   authorName = Convert.ToString(dr["AuthorName"]);
                    DateTime addTime    = Convert.ToDateTime(dr["AddTime"]);
                    string   authorIP   = Convert.ToString(dr["AuthorIP"]);
                    DateTime updateTime = Convert.ToDateTime(dr["UpdateTime"]);

                    //将读取到的数据逐条插入postgresql数据库
                    Comment comment = new Comment();
                    comment.article_id     = article_id;
                    comment.comm_content   = body;
                    comment.comm_username  = authorName;
                    comment.comm_time      = addTime;
                    comment.ip             = authorIP;
                    comment.is_valid       = true;
                    comment.forum_topicid  = 0;
                    comment.forum_threadid = 0;
                    comment.modify_time    = updateTime;
                    Createcomment(comment);
                }
                //return result;
            }
            catch (Exception e)
            {
                Untils.WriteProgramLog("something wrong in A method: " + e.Message);
                throw;
            }
        }
        public static bool InsertUnit(int memberId, string loginName, string face)
        {
            //string msg = string.Empty;
            bool     result         = false;
            string   sql            = string.Empty;
            string   blogName       = string.Empty;
            int      blogId         = 0;
            string   blogTitle      = string.Empty;
            string   memberLogo     = string.Empty;
            DateTime blogAddTime    = DateTime.Now;
            DateTime blogUpdateTime = DateTime.Now;
            int      postCount      = 0;
            int      blogStatus     = 0;

            try
            {
                DataTable      dt = new DataTable();
                DataConnection dc = new DataConnection();
                //获取Blog博客表的数据
                sql = "select * from ra_bgBlog where MemberID=" + memberId;
                //dt = dc.FillDataTable(sql);
                DataRow dr = dc.FillDataRow(sql);
                //foreach (DataRow dr in dt.Rows)//?
                //{
                blogId         = Convert.ToInt32(dr["ID"]);
                blogStatus     = Convert.ToInt32(dr["status"]);
                blogName       = Convert.ToString(dr["Name"]);
                blogTitle      = Convert.ToString(dr["Title"]);
                blogAddTime    = Convert.ToDateTime(dr["AddTime"]);
                blogUpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
                postCount      = Convert.ToInt32(dr["PostCount"]);//文章数量
                //}
                //if (blogStatus == 0)
                //{
                //  sql = "update ra_bgBlog set status=1";
                //   dc.ExeSql(sql);

                //获取Member表的数据
                //sql = "select * from ra_pbMember where LoginName='" + loginName + "'"; //?
                //dt = dc.FillDataTable(sql);
                //foreach (DataRow dr in dt.Rows)
                //{
                // memberId = Convert.ToInt32(dr["ID"]);
                // memberLogo = "http://blog.cnool.net" + Convert.ToString(dr["Face"]);
                //}

                var unitInfo = getUnitByBlogName(loginName);
                if (unitInfo != null)
                {
                    ArticleManage.InsertArticle(blogId, Convert.ToInt32(unitInfo["id"]), blogName, loginName);
                    result = true;
                }
                else
                {
                    Unit unit = new Unit();
                    unit.username = loginName;
                    unitInfo      = getUnitByName(loginName);
                    if (unitInfo != null)
                    {
                        unit.asmanagers = Untils.ConvertToSearchkey(loginName);
                        unit.username   = null;
                    }
                    unit.id          = GetId();
                    unit.unit_name   = loginName + "@博客";
                    unit.create_time = blogAddTime;
                    unit.isvalid     = true;
                    unit.creater     = "system";
                    unit.unit_type   = 1;
                    //unit.modifier = "system";
                    //unit.update_time = blogUpdateTime;
                    if (string.IsNullOrEmpty(face))
                    {
                        unit.unit_logo = null;
                    }
                    else
                    {
                        unit.unit_logo = Untils.GetHtmlImageUrl(face);
                    }
                    //unit.unit_remark = blogTitle;
                    unit.forum_id      = 0;
                    unit.industry_id   = 10040;
                    unit.status        = 0;
                    unit.article_count = postCount;
                    unit.unit_domain   = blogName + ".blog2.cnool.net";
                    result             = CreateUnit(unit);
                    if (result)
                    {
                        //导入Article表
                        ArticleManage.InsertArticle(blogId, unit.id, blogName, loginName);
                    }
                    else
                    {
                        Untils.WriteProgramLog(loginName + "  导入Blog数据失败!");
                    }
                }
            }
            catch (Exception e)
            {
                Untils.WriteProgramLog("something wrong in A method: " + e.Message);
                throw;
            }
            return(result);
        }