Beispiel #1
0
        public static string SaveNewsPage(string mInfo, string loginUserInfo)
        {
            string returnStr = "";
            JObject objInfo = JObject.Parse(mInfo);
            JObject objUser = JObject.Parse(loginUserInfo);
            try
            {
                using (venuesEntities db = new venuesEntities())
                {
                    int curNewPageSeq = PageManager.GetMaxSequence();
                    tbl_page tbt = new tbl_page();
                    tbt.PageDescription = objInfo["PageDescription"].ToString();
                    tbt.PageCreateTime = DateTime.Now;
                    DateTime curDate = DateTime.Now;
                    tbt.PageModifyTime = DateTime.Now;
                    tbt.PageName = objInfo["PageName"].ToString();
                    tbt.PagePublish = KeyManager.PagePublish_Not;
                    //tbt.PageState = KeyManager.PageStatu_EditID;
                    tbt.PageState = KeyManager.PageStatu_SubmitID;
                    tbt.TemplateID = int.Parse(objInfo["TemplateID"].ToString());
                    int templateID = int.Parse(objInfo["TemplateID"].ToString());
                    tbt.VenueID = int.Parse(objUser["curUserID"].ToString());
                    tbt.Sequence = curNewPageSeq + 1;
                    tbt.PageTypeID = int.Parse(objInfo["PageTypeID"].ToString());

                    string pageContentInfo = objInfo["pageContentInfo"].ToString();
                    db.AddTotbl_page(tbt);

                    if (db.SaveChanges() != 0)
                    {
                        string strSql = "SELECT MAX(s.ID) as max FROM tbl_page AS s";
                        int newPageID = 0;
                        ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql);
                        foreach (var item in resultm)
                        {
                            newPageID = int.Parse(item["max"].ToString());
                        }
                        if (pageContentInfo != "[]")
                        {
                            returnStr = KeyManager.RetrunSucceed;

                            JArray arrPageContent = JArray.Parse(objInfo["pageContentInfo"].ToString());
                            foreach (JObject objPageContent in arrPageContent)
                            {
                                returnStr = PageContentManager.SavePageContent(newPageID, templateID, objPageContent.ToString(), loginUserInfo);
                            }

                        }
                        if (objInfo["pageModuleAttributeInfo"].ToString() != "[]")
                        {
                            returnStr = KeyManager.RetrunSucceed;

                            JArray arrModules = JArray.Parse(objInfo["pageModuleAttributeInfo"].ToString());
                            foreach (JObject objModule in arrModules)
                            {
                                returnStr = PageModuleAttributeManager.AddPageModuleAttribute(objModule.ToString(), loginUserInfo, newPageID, templateID);
                            }
                        }

                        int curNewSeq=GetMaxSequence();

                        tbl_news tn = new tbl_news();
                        tn.NewsAuthor = objInfo["NewsAuthor"].ToString();
                        tn.NewsCreateTime = curDate;
                        tn.NewsPage = newPageID;
                        tn.NewsTitle = objInfo["PageName"].ToString();
                        tn.SmallImage = objInfo["SmallImage"].ToString();
                        tn.UserID = int.Parse(objUser["curUserID"].ToString());
                        tn.NewsSequence = curNewSeq + 1;
                        db.AddTotbl_news(tn);
                        if (db.SaveChanges() != 0)
                        {
                            returnStr = KeyManager.RetrunSucceed;
                        }
                        else
                        {
                            returnStr = KeyManager.RetrunUnSucceed;
                        }
                    }
                    else
                    {
                        returnStr = KeyManager.RetrunUnSucceed;
                    }
                }
            }
            catch (Exception e)
            {
                returnStr = e.Message;
                LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_NewsManager, "新增新闻页面,mInfo=" + mInfo + ";错误信息:" + e.Message, loginUserInfo);
            }

            return returnStr;
        }