public static string GetHandBook() { JObject ja = new JObject(); try { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT tbo.BookBackgroundImg,tbo.BookCreateTIme,tbo.BookFacebookLink,tbo.BookTwitterLink,tbo.BookWeiboLink,tbo.BookWeixinLink,tbo.ID FROM tbl_book AS tbo"; ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { string adsInfo = ADManager.GetAllAd(null); JArray objAdsInfo = JArray.Parse(adsInfo); ja = new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("BookBackgroundImg", ks["BookBackgroundImg"].ToString()), new JProperty("BookCreateTIme", ks["BookCreateTIme"].ToString()), new JProperty("BookFacebookLink", ks["BookFacebookLink"].ToString()), new JProperty("BookTwitterLink", ks["BookTwitterLink"].ToString()), new JProperty("BookWeiboLink", ks["BookWeiboLink"].ToString()), new JProperty("BookWeixinLink", ks["BookWeixinLink"].ToString()), new JProperty("AdInfo", objAdsInfo) ); }; } } catch (Exception e) { // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "查询手册信息,error=" + e.Message, loginUserInfo); } return ja.ToString(); }
/// <summary> /// 根据用户id,删除用户权限表中所有关联关系 /// </summary> /// <param name="userID"></param> public static string deleteAllAuthoriyByUserID(int userID, int userTypeParentId, string loginUserInfo) { using (venuesEntities db = new venuesEntities()) { try { //ObjectQuery<tbl_sys_authority> tsus = db.tbl_sys_authority.Where("it.AT_UserId==@v AND it.AT_UserTypeId==@u", new ObjectParameter("v", userID), new ObjectParameter("u", userTypeParentId)); string strSql = string.Format("SELECT aa.AT_Id FROM tbl_sys_authority AS aa WHERE aa.AT_UserId={0} AND aa.AT_UserTypeId={1}", userID, userTypeParentId); ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in results) { int deleteAT_Id = int.Parse(item["AT_Id"].ToString()); deleteAuthoriyByID(deleteAT_Id, loginUserInfo); //tbl_sys_authority su = db.tbl_sys_authority.First<tbl_sys_authority>(a => a.AT_Id.Equals(deleteAT_Id)); //db.DeleteObject(su); }; //if (db.SaveChanges() != 0) // return "成功!"; //else // return "不成功!"; return "成功!"; } catch (Exception e) { return e.Message; } } }
public static string AddVenue(string loginUserInfo) { string returnStr = ""; int newVenueID = 0; JObject objUser = JObject.Parse(loginUserInfo); try { using (venuesEntities db = new venuesEntities()) { tbl_venue tbv = new tbl_venue(); tbv.VenueTypeID = KeyManager.VenueTypeId_Meeting; tbv.VenuePayType = "免费"; tbv.VenuePassword = GeneralFuction.MD5Encrypt(KeyManager.Default_Pwd); tbv.VenueName = ""; tbv.VenueManager = ""; tbv.VenueLng = float.Parse("0"); tbv.VenueLat = float.Parse("0"); tbv.VenueCreateTime = DateTime.Now; tbv.VenueContact = ""; tbv.VenueAddress = ""; tbv.VenueDescript = ""; tbv.VenueImage = ""; tbv.VenueStar = ""; tbv.Video = ""; tbv.LogoImg = ""; tbv.HomeImg =""; tbv.Phone = ""; tbv.PostCode = ""; tbv.Fax = ""; tbv.WebSite = "" ; tbv.Email = ""; db.AddTotbl_venue(tbv); if (db.SaveChanges() != 0) { string strSql = "SELECT MAX(s.ID) as max FROM tbl_venue AS s"; ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in resultm) { newVenueID = int.Parse(item["max"].ToString()); returnStr = item["max"].ToString(); } } else { returnStr = KeyManager.RetrunUnSucceed; } } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所失败,错误信息:" + e.Message, loginUserInfo); } return returnStr; }
public static int GetMaxSequence() { string returnStr = ""; int maxBookVenueSequence = 0; try { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT MAX(s.BookVenueSequence) as max FROM tbl_book_venue AS s"; ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in resultm) { maxBookVenueSequence = int.Parse(item["max"].ToString()); } } } catch (Exception e) { returnStr = e.Message; // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "获取当前tbl_book_venue中最大的排列数,错误信息:" + e.Message, loginUserInfo); } return maxBookVenueSequence; }
public static string GetPageContentByPageId(int pageId, string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tpc.ContentSequence,tpc.ContentValue,tpc.ID,tpc.ModuleID,tpc.PageID,tpc.TemplateID ,tm.ModuleType FROM tbl_page_content AS tpc LEFT JOIN tbl_module AS tm ON tm.ID=tpc.ModuleID WHERE tpc.PageID= {0}", pageId); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); string path = System.Configuration.ConfigurationManager.AppSettings["FilePath"].ToString(); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("ContentSequence", ks["ContentSequence"].ToString()), new JProperty("ContentValue", ks["ContentValue"].ToString()), new JProperty("FileNameServer", ks["ContentValue"].ToString()), new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("ModuleTypeID", ks["ModuleType"].ToString()), new JProperty("PageID", ks["PageID"].ToString()), new JProperty("TemplateID", ks["TemplateID"].ToString()) // new JProperty("FilePathAddress", path) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据pageId获取该页面内容信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string GetModuleType() { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT d.DA_Name,d.DA_Id,d.DA_Code FROM tbl_sys_dictionary as d WHERE d.DA_ParentId={0}", KeyManager.ModuleTypeID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("DA_Id", ks["DA_Id"].ToString()), new JProperty("DA_Name", ks["DA_Name"].ToString()), new JProperty("DA_Code", ks["DA_Code"].ToString()) ) ); }; } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "获取模块类型,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string GetNewsPageByNewsID(int NewsID, string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tn.ID,tn.NewsAuthor,tn.NewsCreateTime,tn.NewsPage,tn.NewsSequence,tn.NewsTitle,tn.UserID,tn.SmallImage FROM tbl_news AS tn WHERE tn.ID={0}", NewsID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { int pageId = int.Parse(ks["NewsPage"].ToString()); ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("NewsAuthor", ks["NewsAuthor"].ToString()), new JProperty("NewsCreateTime", ks["NewsCreateTime"].ToString()), new JProperty("NewsPage", ks["NewsPage"].ToString()), new JProperty("NewsTitle", ks["NewsTitle"].ToString()), new JProperty("SmallImage", ks["SmallImage"].ToString()), new JProperty("UserID", ks["UserID"].ToString()) ) ); } } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_NewsManager, "根据NewsID获取该新闻页面信息,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string GetAllTheme() { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT tt.ID,tt.ThemeImage,tt.ThemeName,tt.Sequence FROM tbl_theme AS tt ORDER BY tt.Sequence"; ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("ThemeImage", ks["ThemeImage"].ToString()), new JProperty("Sequence", ks["Sequence"].ToString()), new JProperty("ThemeName", ks["ThemeName"].ToString()) ) ); }; } } catch (Exception e) { // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "查询所有主题,error=" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string CopyTemplate(string mInfo, string loginUserInfo) { string returnStr = ""; JObject objVenue = JObject.Parse(mInfo); try { using (venuesEntities db = new venuesEntities()) { tbl_template tbt = new tbl_template(); tbt.TemplateColor = int.Parse(objVenue["templateColor"].ToString()); tbt.TemplateCreateTime = DateTime.Now; tbt.TemplateDescription = objVenue["templateDescription"].ToString(); tbt.TemplateHeight = int.Parse(objVenue["templateHeight"].ToString()); tbt.TemplateImage = objVenue["templateImage"].ToString(); tbt.TemplateName = objVenue["templateName"].ToString()+"(复制)"; tbt.TemplateType = int.Parse(objVenue["templateTypeID"].ToString()); tbt.TemplateWidth = int.Parse(objVenue["templateWidth"].ToString()); tbt.smallImage = objVenue["smallImage"].ToString(); string moduleInfo = objVenue["moduleInfo"].ToString(); db.AddTotbl_template(tbt); if (db.SaveChanges() != 0) { string strSql = "SELECT MAX(s.ID) as max FROM tbl_template AS s"; int newTemplateID = 0; ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in resultm) { newTemplateID = int.Parse(item["max"].ToString()); } if (moduleInfo != "[]") { returnStr = KeyManager.RetrunSucceed; JArray arrModules = JArray.Parse(objVenue["moduleInfo"].ToString()); foreach (JObject objModule in arrModules) { returnStr = ModuleManager.SaveModule(newTemplateID, objModule.ToString(), loginUserInfo); } } returnStr = KeyManager.RetrunSucceed; } else { returnStr = KeyManager.RetrunUnSucceed; } } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "复制模板,mInfo=" + mInfo + ";错误信息:" + e.Message, loginUserInfo); } return returnStr; }
public static string PublishCurrentBook( string loginUserInfo) { string returnStr = ""; string strSql = ""; try { using (venuesEntities db = new venuesEntities()) { //先将已发布过的手册的页面恢复为未发布的状态 strSql = string.Format("SELECT tp.ID AS PageID FROM tbl_page AS tp LEFT JOIN tbl_book_venue AS tbv ON tbv.VenueID=tp.VenueID WHERE tp.PagePublish={0}", KeyManager.PagePublish_Yes); ObjectQuery<DbDataRecord> list = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in list) { int pageId = int.Parse(item["PageID"].ToString()); returnStr = PageManager.SetPagePublish(pageId, KeyManager.PagePublish_Not, loginUserInfo); } db.SaveChanges(); //将审核通过的页面置为发布状态 strSql = string.Format("SELECT tp.ID AS PageID FROM tbl_page AS tp LEFT JOIN tbl_book_venue AS tbv ON tbv.VenueID=tp.VenueID WHERE tp.PageState={0}", KeyManager.PageStatu_AuditPassID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { int pageId = int.Parse(ks["PageID"].ToString()); returnStr = PageManager.SetPagePublish(pageId, KeyManager.PagePublish_Yes, loginUserInfo); } db.SaveChanges(); //将所有审核通过状态置为编辑状态 //strSql = string.Format("SELECT tp.ID AS PageID FROM tbl_page AS tp LEFT JOIN tbl_book_venue AS tbv ON tbv.VenueID=tp.VenueID WHERE tp.PageState={0}", KeyManager.PageStatu_AuditPassID); //ObjectQuery<DbDataRecord> keds = db.CreateQuery<DbDataRecord>(strSql); //foreach (var ks in keds) //{ // int pageId = int.Parse(ks["PageID"].ToString()); // returnStr = PageManager.SetPageState(pageId, KeyManager.PageStatu_EditID, loginUserInfo); //} //if (returnStr == KeyManager.RetrunSucceed) //{ // //DeleteALLBookVenues();//如果手册发布成功,将手册用户关联表中的数据全部删除 //} } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "发布当前手册,错误信息:" + e.Message, loginUserInfo); } return returnStr; }
/// <summary> /// 获取Menu /// </summary> /// <returns></returns> public static string GetMenu(int curUserID, int userTypeParentId, string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = ""; ObjectQuery<DbDataRecord> results = null; if (userTypeParentId == KeyManager.UserTypeId_BuissiensUser) { strSql = string.Format("SELECT tsm.Menu_Id,tsm.Menu_Name,tsm.Menu_Url FROM tbl_sys_menu AS tsm WHERE tsm.Menu_Id=6 OR tsm.Menu_Id=7 OR tsm.Menu_Id=8 OR tsm.Menu_Id=10"); results = db.CreateQuery<DbDataRecord>(strSql); } else { strSql = string.Format("SELECT m.Menu_Id,m.Menu_Name,m.Menu_IsMenu,m.Menu_Url FROM tbl_sys_menu as m join tbl_sys_authority as a on m.Menu_Id=a.AT_MenuId WHERE m.Menu_ParentId is NULL and a.AT_UserId={0} AND a.AT_UserTypeId={1} ORDER BY m.Menu_Id ASC", curUserID, userTypeParentId); results = db.CreateQuery<DbDataRecord>(strSql); } foreach (var item in results) { ja.Add( new JObject( new JProperty("Menu_Id", item["Menu_Id"].ToString()), new JProperty("Menu_Name", item["Menu_Name"].ToString()), new JProperty("Menu_Url", item["Menu_Url"].ToString()) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SystemManager, "获取用户对应的权限菜单,userID =" + curUserID + ";错误信息:" + e.Message, loginUserInfo); } //LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_SystemManager, "获取用户对应的权限菜单,userID =" + KeyManager.CUR_USERID); return ja.ToString(); }
/// <summary> /// 获取最新用户id /// </summary> /// <returns></returns> public static int GetNewUserID() { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT MAX(u.User_Id) as newUserId FROM tbl_sys_user as u"; ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); int newUserId = 0; foreach (var ks in kss) { newUserId = int.Parse(ks["newUserId"].ToString()); }; return newUserId; } }
public static string GetMeetingRoomByMrId(int mrID, string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT vmr.ID,vmr.MeetingImage,vmr.MRSequence,vmr.VenueID,vmr.Banquet,vmr.Boardroom,vmr.Classroom,vmr.Dimensions,vmr.FunctionRoom,vmr.Height,vmr.HollowSquare,vmr.Reception,vmr.Size,vmr.Theatre,vmr.UShape FROM tbl_venue_meetingroom AS vmr WHERE vmr.ID= {0}", mrID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("MRSequence", ks["MRSequence"].ToString()), new JProperty("Dimensions", ks["Dimensions"].ToString()), new JProperty("FunctionRoom", ks["FunctionRoom"].ToString()), new JProperty("Size", ks["Size"].ToString()), new JProperty("Height", ks["Height"].ToString()), new JProperty("Reception", ks["Reception"].ToString()), new JProperty("Banquet", ks["Banquet"].ToString()), new JProperty("Theatre", ks["Theatre"].ToString()), new JProperty("Classroom", ks["Classroom"].ToString()), new JProperty("UShape", ks["UShape"].ToString()), new JProperty("Boardroom", ks["Boardroom"].ToString()), new JProperty("HollowSquare", ks["HollowSquare"].ToString()), new JProperty("MeetingImage", ks["MeetingImage"].ToString()), new JProperty("VenueID", ks["VenueID"].ToString()) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据条件查询会议室信息,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static int GetBookVenueInfoByVenueID(int venueId, string loginUserInfo) { int bookVenueID = 0; try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tbv.ID FROM tbl_book_venue AS tbv WHERE tbv.VenueID={0}", venueId); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { bookVenueID=int.Parse(ks["ID"].ToString()); } } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "根据场所id获取该场所与手册是否有关联关系,venueId=" + venueId + ";错误信息:" + e.Message, loginUserInfo); } return bookVenueID; }
public static string GetCurHandBookInfo() { JObject ja = new JObject(); string bookInfo = ""; try { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT tb.AllCurBookInfo FROM tbl_book as tb"; ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in resultm) { bookInfo = (item["AllCurBookInfo"].ToString()); } } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "查询手册信息,error=" + e.Message); } return bookInfo; }
public static string GetVenuesByVenueId(int venueID, string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tv.ContactEmial,tv.ContactPhone,tv.ContactPosition,tv.ID,tv.VenueAddress,tv.VenueContact,tv.VenuePassword,tv.VenueCreateTime,tv.VenueLat,tv.VenueLng,tv.VenueManager,tv.VenueName,tv.VenuePayType,tv.VenueTypeID,tv.VenueDescript,tv.VenueImage,tv.VenueStar,tv.HomeImg,tv.LogoImg,tv.Video,tv.Phone,tv.PostCode,tv.Fax,tv.Email,tv.WebSite FROM tbl_venue AS tv WHERE tv.ID= {0}", venueID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { string otherAtt = VenueAttributeManager.GetVenueAttributeByVenueId(venueID, loginUserInfo); string venuePageRelation = VenuePageRelationsManager.GetVenuePagesByVenueId(venueID, loginUserInfo); ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("VenueName", ks["VenueName"].ToString()), new JProperty("VenueAddress", ks["VenueAddress"].ToString()), new JProperty("VenueContact", ks["VenueContact"].ToString()), new JProperty("VenueManager", ks["VenueManager"].ToString()), new JProperty("VenuePassword", ks["VenuePassword"].ToString()), new JProperty("VenueTypeID", ks["VenueTypeID"].ToString()), new JProperty("VenueCreateTime", ks["VenueCreateTime"].ToString()), new JProperty("VenueLng", ks["VenueLng"]), new JProperty("VenueLat", ks["VenueLat"]), new JProperty("VenuePayType", ks["VenuePayType"].ToString()), new JProperty("VenueDescript", ks["VenueDescript"].ToString()), new JProperty("VenueImage", ks["VenueImage"].ToString()), new JProperty("VenueStar", ks["VenueStar"].ToString()), //new JProperty("AverageConsumption", ks["AverageConsumption"].ToString()), //new JProperty("District", ks["District"].ToString()), //new JProperty("Country", ks["Country"].ToString()), //new JProperty("MeetRoomCapacity", ks["MeetRoomCapacity"].ToString()), new JProperty("WebSite", ks["WebSite"].ToString()), new JProperty("Email", ks["Email"].ToString()), new JProperty("HomeImg", ks["HomeImg"].ToString()), new JProperty("LogoImg", ks["LogoImg"].ToString()), new JProperty("Video", ks["Video"].ToString()), new JProperty("Phone", ks["Phone"].ToString()), new JProperty("PostCode", ks["PostCode"].ToString()), new JProperty("Fax", ks["Fax"].ToString()), new JProperty("ContactEmial", ks["ContactEmial"].ToString()), new JProperty("ContactPhone", ks["ContactPhone"].ToString()), new JProperty("ContactPosition", ks["ContactPosition"].ToString()), new JProperty("OtherAttibute",otherAtt), new JProperty("venuePageRelation", venuePageRelation) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据条件查询场所信息,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string GetVenues(string loginUserInfo, string venuesName, int venuesTypeID) { JArray ja = new JArray(); JObject objUser = JObject.Parse(loginUserInfo); try { using (venuesEntities db = new venuesEntities()) { //判断当前用户是系统用户还是场所用户,若为系统用户显示所有场所信息,若为场所用户只显示该场所的信息 string strSql = ""; if (int.Parse(objUser["UserTypeParentId"].ToString()) == KeyManager.UserTypeId_SystemUser) { strSql = "SELECT vv.ID,vv.ContactEmial,vv.ContactPhone,vv.ContactPosition,vv.VenueName,vv.VenueAddress,vv.VenueContact,vv.VenueManager,vv.VenuePassword, vv.VenueTypeID,dd.DA_Name,vv.VenueCreateTime,vv.VenueLng,vv.VenueLat,vv.VenuePayType,vv.VenueDescript,vv.VenueImage,vv.VenueStar,vv.HomeImg,vv.LogoImg,vv.Video,vv.Phone,vv.PostCode,vv.Fax,vv.WebSite,vv.Email FROM tbl_venue as vv LEFT JOIN tbl_sys_dictionary AS dd ON vv.VenueTypeID=dd.DA_Id WHERE 1=1 "; if (venuesName != "") { strSql += " AND vv.VenueName LIKE '%" + venuesName + "%'"; } if (venuesTypeID != 0) { strSql += " AND vv.VenueTypeID =" + venuesTypeID; } } else if (int.Parse(objUser["UserTypeParentId"].ToString()) == KeyManager.UserTypeId_BuissiensUser) { strSql = "SELECT vv.ID,vv.ContactEmial,vv.ContactPhone,vv.ContactPosition,vv.VenueName,vv.VenueAddress,vv.VenueContact,vv.VenueManager,vv.VenuePassword, vv.VenueTypeID,dd.DA_Name,vv.VenueCreateTime,vv.VenueLng,vv.VenueLat,vv.VenuePayType,vv.VenueDescript,vv.VenueImage,vv.VenueStar,vv.HomeImg,vv.LogoImg,vv.Video,vv.Phone,vv.PostCode,vv.Fax,vv.WebSite,vv.Email FROM tbl_venue as vv LEFT JOIN tbl_sys_dictionary AS dd ON vv.VenueTypeID=dd.DA_Id WHERE vv.ID =" + int.Parse(objUser["curUserID"].ToString()); } ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("VenueName", ks["VenueName"].ToString()), new JProperty("VenueAddress", ks["VenueAddress"].ToString()), new JProperty("VenueContact", ks["VenueContact"].ToString()), new JProperty("VenueManager", ks["VenueManager"].ToString()), new JProperty("VenuePassword", ks["VenuePassword"].ToString()), new JProperty("VenueType", ks["DA_Name"].ToString()), new JProperty("VenueTypeID", ks["VenueTypeID"].ToString()), new JProperty("VenueCreateTime", ks["VenueCreateTime"].ToString()), new JProperty("VenueLng", ks["VenueLng"]), new JProperty("VenueLat", ks["VenueLat"]), new JProperty("VenuePayType", ks["VenuePayType"].ToString()), new JProperty("VenueDescript", ks["VenueDescript"].ToString()), new JProperty("VenueImage", ks["VenueImage"].ToString()), new JProperty("VenueStar", ks["VenueStar"].ToString()), //new JProperty("AverageConsumption", ks["AverageConsumption"].ToString()), //new JProperty("District", ks["District"].ToString()), //new JProperty("Country", ks["Country"].ToString()), //new JProperty("MeetRoomCapacity", ks["MeetRoomCapacity"].ToString()), new JProperty("HomeImg", ks["HomeImg"].ToString()), new JProperty("LogoImg", ks["LogoImg"].ToString()), new JProperty("Video", ks["Video"].ToString()), new JProperty("Phone", ks["Phone"].ToString()), new JProperty("PostCode", ks["PostCode"].ToString()), new JProperty("Fax", ks["Fax"].ToString()), new JProperty("WebSite", ks["WebSite"].ToString()), new JProperty("Email", ks["Email"].ToString()), new JProperty("ContactEmial", ks["ContactEmial"].ToString()), new JProperty("ContactPhone", ks["ContactPhone"].ToString()), new JProperty("ContactPosition", ks["ContactPosition"].ToString()) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据条件查询场所信息,错误信息:userId=" + int.Parse(objUser["curUserID"].ToString()) + ",venuesName=" + venuesName + ",venuesTypeID=" + venuesTypeID + ",error:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string SetNewsInfo() { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql2 = string.Format("SELECT tn.NewsAuthor,tn.NewsPage,tn.NewsSequence,tn.NewsTitle,tn.SmallImage,tn.UserID,tp.PageCreateTime,tp.PageDescription,tp.PageModifyTime,tp.PageName,tp.PageTypeID,tsd.DA_Name AS PageTypeName,tsd.DA_Code AS PageTypeNameCode,tp.TemplateID,tp.VenueID,tt.TemplateColor,tt.TemplateCreateTime,tt.TemplateDescription,tt.TemplateHeight,tt.TemplateImage,tt.TemplateName,tt.TemplateType,tsd2.DA_Name AS TemplateTypeName,tsd2.DA_Code AS TemplateTypeNameCode,tt.TemplateWidth FROM tbl_page AS tp LEFT JOIN tbl_news AS tn ON tp.ID=tn.NewsPage LEFT JOIN tbl_template AS tt ON tp.TemplateID=tt.ID LEFT JOIN tbl_sys_dictionary AS tsd ON tp.PageTypeID=tsd.DA_Id LEFT JOIN tbl_sys_dictionary AS tsd2 ON tp.TemplateID=tsd2.DA_Id WHERE tsd.DA_Code='NewsPage' AND tp.PagePublish=1 ORDER BY tn.NewsSequence"); ObjectQuery<DbDataRecord> vekss = db.CreateQuery<DbDataRecord>(strSql2); foreach (var vks in vekss) { int pageID = int.Parse(vks["NewsPage"].ToString()); string pageModuleStr = GetPageModulesInfo(pageID); JArray objPagesMdule = JArray.Parse(pageModuleStr); ja.Add( new JObject( new JProperty("NewsAuthor", vks["NewsAuthor"].ToString()), new JProperty("PageID", vks["NewsPage"].ToString()), new JProperty("NewsSequence", vks["NewsSequence"].ToString()), new JProperty("NewsTitle", vks["NewsTitle"].ToString()), new JProperty("SmallImage", vks["SmallImage"].ToString()), new JProperty("PageCreateTime", vks["PageCreateTime"].ToString()), new JProperty("PageModifyTime", vks["PageModifyTime"].ToString()), new JProperty("PageTypeID", vks["PageTypeID"].ToString()), new JProperty("PageTypeName", vks["PageTypeName"].ToString()), new JProperty("PageTypeNameCode", vks["PageTypeNameCode"].ToString()), new JProperty("PageDescription", vks["PageDescription"].ToString()), new JProperty("PageName", vks["PageName"].ToString()), new JProperty("TemplateColor", vks["TemplateColor"].ToString()), new JProperty("TemplateDescription", vks["TemplateDescription"].ToString()), new JProperty("TemplateHeight", vks["TemplateHeight"].ToString()), new JProperty("TemplateImage", vks["TemplateImage"].ToString()), new JProperty("TemplateName", vks["TemplateName"].ToString()), new JProperty("TemplateType", vks["TemplateType"].ToString()), new JProperty("TemplateTypeName", vks["TemplateTypeName"].ToString()), new JProperty("TemplateTypeNameCode", vks["TemplateTypeNameCode"].ToString()), new JProperty("TemplateWidth", vks["TemplateWidth"].ToString()), new JProperty("Modules", objPagesMdule) ) ); } } } catch (Exception e) { // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "查询手册场所列表,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
/// <summary> /// 根据用户id获取登录用户信息 /// </summary> /// <param name="query_loginName"></param> /// <param name="query_username"></param> /// <returns></returns> public static string GetVenueByLoginUserID(string userID) { JArray ja = new JArray(); JObject loginUserInfo = new JObject(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT vv.ID,vv.VenueManager,vv.VenueName,vv.VenuePassword,vv.VenueTypeID,vv.ONLINE_CODE FROM tbl_venue as vv WHERE vv.ID={0}", userID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("User_Id", ks["ID"].ToString()), new JProperty("User_LoginName", ks["VenueManager"].ToString()), new JProperty("User_Name", ks["VenueName"].ToString()), new JProperty("User_Password", ks["VenuePassword"].ToString()), new JProperty("User_TypeParentId", KeyManager.UserTypeId_BuissiensUser), new JProperty("User_TypeId", ks["VenueTypeID"].ToString()), new JProperty("ONLINE_CODE", ks["ONLINE_CODE"].ToString()) ) ); loginUserInfo = new JObject( new JProperty("curUserID", ks["ID"].ToString()), new JProperty("UserTypeId", ks["VenueTypeID"].ToString()), new JProperty("UserTypeParentId", KeyManager.UserTypeId_BuissiensUser), new JProperty("ONLINE_CODE", ks["ONLINE_CODE"].ToString()) ); } } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SystemUsersManager, "根据用户id查询用户,User_Id=" + userID + ",错误信息:" + e.Message, loginUserInfo.ToString()); } LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_SystemUsersManager, "根据用户id查询用户,User_Id=" + userID, loginUserInfo.ToString()); return ja.ToString(); }
//只获取场所信息,不获取页面信息 public static string GetVenuesInfoListOnly() { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tv.ContactEmial,tv.ContactPhone,tv.ContactPosition,tv.ID,tv.SequenceTopThree,tv.VenueAddress,tv.VenueContact,tv.VenueCreateTime,tv.VenueDescript,tv.VenueImage,tv.VenueLat,tv.VenueLng,tv.VenueManager,tv.VenueName,tv.VenuePayType,tv.VenueStar,tv.HomeImg,tv.LogoImg,tv.Video,tv.Phone,tv.PostCode,tv.Fax,tv.WebSite,tv.VenueTypeID,tsd.DA_Name AS VenueTypeName ,tsd.DA_Code AS VenueTypeNameCode FROM tbl_venue AS tv INNER JOIN (SELECT tp.VenueID FROM tbl_page AS tp WHERE tp.PagePublish=1 GROUP BY tp.VenueID) AS tpv ON tpv.VenueID=tv.ID LEFT JOIN tbl_sys_dictionary AS tsd ON tv.VenueTypeID=tsd.DA_Id ORDER BY tv.VenueTypeID,tv.SequenceTopThree is NULL,tv.SequenceTopThree LIKE '' ,tv.VenueName,tv.SequenceTopThree"); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var vks in kss) { int veneuID = int.Parse(vks["ID"].ToString()); String meetingInfo = "[]"; meetingInfo = GetMeetingInfoByVenueId(veneuID); JArray arrMeetingInfo = JArray.Parse(meetingInfo); string RoomNumber = ""; string MeetingNumber = ""; string MeetingArea = ""; string Country = ""; string District = ""; string AverageConsumption = ""; string MeetRoomCapacity = ""; string venueAttr = GetVenueAttributeByVenueId(veneuID); JArray arrVenueAttr = JArray.Parse(venueAttr); foreach (JObject objVenueAttr in arrVenueAttr) { if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_RoomNumber) { RoomNumber = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_MeetingNumber) { MeetingNumber = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_MeetingArea) { MeetingArea = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_Country) { Country = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_District) { District = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_AverageConsumption) { AverageConsumption = (objVenueAttr["VenueAttributeValue"].ToString()); } else if (int.Parse(objVenueAttr["VenueAttributeKey"].ToString()) == KeyManager.VenueAttr_MeetRoomCapacity) { MeetRoomCapacity = (objVenueAttr["VenueAttributeValue"].ToString()); } } ja.Add( new JObject( new JProperty("VenueID", vks["ID"].ToString()), new JProperty("SequenceTopThree", vks["SequenceTopThree"].ToString()), new JProperty("VenueManager", vks["VenueManager"].ToString()), new JProperty("VenueName", vks["VenueName"].ToString()), new JProperty("VenueLat", vks["VenueLat"].ToString()), new JProperty("VenueLng", vks["VenueLng"].ToString()), new JProperty("VenueAddress", vks["VenueAddress"].ToString()), new JProperty("VenueContact", vks["VenueContact"].ToString()), new JProperty("VenuePayType", vks["VenuePayType"].ToString()), new JProperty("VenueTypeName", vks["VenueTypeName"].ToString()), new JProperty("VenueTypeNameCode", vks["VenueTypeNameCode"].ToString()), new JProperty("VenueTypeID", vks["VenueTypeID"].ToString()), new JProperty("VenueStar", vks["VenueStar"].ToString()), new JProperty("VenueDescript", vks["VenueDescript"].ToString()), new JProperty("VenueImage", vks["VenueImage"].ToString()), new JProperty("Phone", vks["Phone"].ToString()), new JProperty("PostCode", vks["PostCode"].ToString()), new JProperty("Fax", vks["Fax"].ToString()), new JProperty("HomeImg", vks["HomeImg"].ToString()), new JProperty("LogoImg", vks["LogoImg"].ToString()), new JProperty("Video", vks["Video"].ToString()), new JProperty("ContactEmial", vks["ContactEmial"].ToString()), new JProperty("ContactPhone", vks["ContactPhone"].ToString()), new JProperty("ContactPosition", vks["ContactPosition"].ToString()), new JProperty("WebSite", vks["WebSite"].ToString()), new JProperty("RoomNumber", RoomNumber), new JProperty("MeetingNumber", MeetingNumber), new JProperty("MeetingArea", MeetingArea), new JProperty("Country", Country), new JProperty("District", District), new JProperty("AverageConsumption", AverageConsumption), new JProperty("MeetRoomCapacity", MeetRoomCapacity), new JProperty("MeetingRoomInfos", arrMeetingInfo), new JProperty("OtherAttibute", arrVenueAttr) ) ); } } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "查询手册场所列表,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static String GetVenueAttributeByVenueId(int venueId) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT vatt.ID,vatt.VenueAttributeKey,sd.DA_Name,sd.DA_Code, vatt.VenueAttributeValue,vatt.VenueID FROM tbl_venue_attribute AS vatt LEFT JOIN tbl_sys_dictionary AS sd ON vatt.VenueAttributeKey=sd.DA_Id where vatt.VenueID={0}", venueId); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("VenueAttributeKey", ks["VenueAttributeKey"].ToString()), new JProperty("DA_Name", ks["DA_Name"].ToString()), new JProperty("DA_Code", ks["DA_Code"].ToString()), new JProperty("VenueAttributeValue", ks["VenueAttributeValue"].ToString()), new JProperty("VenueID", ks["VenueID"].ToString()) ) ); } } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据场所id获取该场所的其他属性,venueId=" + venueId + ";错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string ModifyVenues(string venueInfo, string loginUserInfo) { string returnStr = ""; JObject objVenue = JObject.Parse(venueInfo); Boolean ishasVenue = false; try { using (venuesEntities db = new venuesEntities()) { if (objVenue["loginName"].ToString() != "" && objVenue["loginName"].ToString() != null) { string strSql1 = string.Format("SELECT vv.VenueManager FROM tbl_venue AS vv WHERE vv.VenueManager='{0}' AND vv.ID!={1}", objVenue["loginName"].ToString(), int.Parse(objVenue["venueID"].ToString())); ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql1); foreach (var ks in results) { ishasVenue = true; } } if (!ishasVenue) { int venueID=int.Parse(objVenue["venueID"].ToString()); if (venueID != 0) { tbl_venue tbv = db.tbl_venue.First<tbl_venue>(a => a.ID.Equals(venueID)); tbv.VenueTypeID = int.Parse(objVenue["venueTypeID"].ToString()); tbv.VenuePayType = objVenue["payType"].ToString(); //tbv.VenuePassword = KeyManager.Default_Pwd; tbv.VenueName = objVenue["venueName"].ToString(); tbv.VenueManager = objVenue["loginName"].ToString(); tbv.VenueLng = float.Parse(objVenue["site_Lng"].ToString()); tbv.VenueLat = float.Parse(objVenue["site_Lat"].ToString()); //tbv.VenueCreateTime = DateTime.Now; tbv.VenueContact = objVenue["contactPeople"].ToString(); tbv.VenueAddress = objVenue["address"].ToString(); tbv.VenueDescript = objVenue["descript"].ToString(); tbv.VenueImage = objVenue["smallImage"].ToString(); tbv.VenueStar = objVenue["star"].ToString(); tbv.Video = objVenue["Video"].ToString(); tbv.LogoImg = objVenue["LogoImg"].ToString(); tbv.HomeImg = objVenue["HomeImg"].ToString(); tbv.Phone = objVenue["Phone"].ToString(); tbv.PostCode = objVenue["PostCode"].ToString(); tbv.Fax = objVenue["Fax"].ToString(); //tbv.AverageConsumption = objVenue["AverageConsumption"].ToString(); //tbv.District = objVenue["District"].ToString(); //tbv.Country = objVenue["Country"].ToString(); //tbv.MeetRoomCapacity = objVenue["MeetRoomCapacity"].ToString(); tbv.WebSite = objVenue["WebSite"].ToString(); tbv.Email = objVenue["Email"].ToString(); tbv.ContactEmial = objVenue["ContactEmial"].ToString(); tbv.ContactPhone = objVenue["ContactPhone"].ToString(); tbv.ContactPosition = objVenue["ContactPosition"].ToString(); string otherStr = objVenue["otherAttribute"].ToString(); returnStr = KeyManager.RetrunSucceed; VenueAttributeManager.DeleteVenueAttributeByVenueId(venueID, loginUserInfo); if (otherStr != "[]") { JArray arrOtherVenue = JArray.Parse(objVenue["otherAttribute"].ToString()); foreach (JObject objOtherVenue in arrOtherVenue) { VenueAttributeManager.AddVenueAttribute(venueID, objOtherVenue.ToString(), loginUserInfo); } } //string venuePageRelation = objVenue["venuePageRelation"].ToString(); //if (venuePageRelation != "[]") //{ // returnStr = KeyManager.RetrunSucceed; // VenuePageRelationsManager.DealVenuePages(loginUserInfo, venueInfo); //} } if (db.SaveChanges() != 0) { returnStr = KeyManager.RetrunSucceed; } else { returnStr = KeyManager.RetrunUnSucceed; } } else { returnStr = "不成功,已有登录名为“" + objVenue["loginName"].ToString() + "”的场所用户。"; } } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "修改场所成功,venuesinfo=" + venueInfo + ";错误信息:" + e.Message, loginUserInfo); } return returnStr; }
public static string GetSaleThemeInfoByPageID(int pageId) { JObject ja = new JObject(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT ts.SalesTitle,ts.SalesSequence,tt.Sequence AS ThemeSequence,tt.ThemeImage,tt.ThemeName FROM tbl_sales AS ts LEFT JOIN tbl_theme_salespage AS tts ON ts.ID=tts.SalePageID LEFT JOIN tbl_theme AS tt ON tts.ThemeID=tt.ID WHERE ts.SalesPageID ={0}", pageId); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja = new JObject( new JProperty("SalesTitle", ks["SalesTitle"].ToString()), new JProperty("SalesSequence", ks["SalesSequence"].ToString()), new JProperty("ThemeSequence", ks["ThemeSequence"].ToString()), new JProperty("ThemeImage", ks["ThemeImage"].ToString()), new JProperty("ThemeName", ks["ThemeName"].ToString()) ); }; } } catch (Exception e) { // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据pageId获取该页面信息,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string SaveVenues(string venueInfo, string loginUserInfo) { string returnStr = ""; JObject objVenue = JObject.Parse(venueInfo); Boolean ishasVenue = false; JObject objUser = JObject.Parse(loginUserInfo); try { using (venuesEntities db = new venuesEntities()) { string strSql1 = string.Format("SELECT vv.VenueManager FROM tbl_venue AS vv WHERE vv.VenueManager='{0}'", objVenue["loginName"].ToString()); ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql1); foreach (var ks in results) { ishasVenue = true; } if (!ishasVenue) { tbl_venue tbv = new tbl_venue(); tbv.VenueTypeID = int.Parse(objVenue["venueTypeID"].ToString()); tbv.VenuePayType = objVenue["payType"].ToString(); tbv.VenuePassword =GeneralFuction.MD5Encrypt(KeyManager.Default_Pwd); tbv.VenueName = objVenue["venueName"].ToString(); tbv.VenueManager = objVenue["loginName"].ToString(); tbv.VenueLng = float.Parse(objVenue["site_Lng"].ToString()); tbv.VenueLat = float.Parse(objVenue["site_Lat"].ToString()); tbv.VenueCreateTime = DateTime.Now; tbv.VenueContact = objVenue["contactPeople"].ToString(); tbv.VenueAddress = objVenue["address"].ToString(); tbv.VenueDescript = objVenue["descript"].ToString(); tbv.VenueImage = objVenue["smallImage"].ToString(); tbv.VenueStar = objVenue["star"].ToString(); //tbv.AverageConsumption = objVenue["AverageConsumption"].ToString(); //tbv.District = objVenue["District"].ToString(); //tbv.Country = objVenue["Country"].ToString(); //tbv.MeetRoomCapacity = objVenue["MeetRoomCapacity"].ToString(); tbv.WebSite = objVenue["WebSite"].ToString(); tbv.Email = objVenue["Email"].ToString(); db.AddTotbl_venue(tbv); string otherStr=objVenue["otherAttribute"].ToString(); if (db.SaveChanges() != 0) { string strSql = "SELECT MAX(s.ID) as max FROM tbl_venue AS s"; int newVenueID = 0; ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql); foreach (var item in resultm) { newVenueID = int.Parse(item["max"].ToString()); } if (otherStr != "[]") { returnStr = KeyManager.RetrunSucceed; string attributeReturnStr = ""; JArray arrOtherVenue = JArray.Parse(objVenue["otherAttribute"].ToString()); foreach (JObject objOtherVenue in arrOtherVenue) { attributeReturnStr = VenueAttributeManager.AddVenueAttribute(newVenueID, objOtherVenue.ToString(), loginUserInfo); if (attributeReturnStr != KeyManager.RetrunSucceed) { returnStr = attributeReturnStr; DeleteVenuesByIDs(loginUserInfo, newVenueID.ToString());//如果新增不成功,则删除刚刚插入数据表的场所信息 VenueAttributeManager.DeleteVenueAttributeByVenueId(newVenueID, loginUserInfo); break; } } } //商户:场所管理(场所信息,会议室信息),资源管理,游客管理,页面管理,页面发布(商户发布) //string sysUserMenus = "" + KeyManager.MENUS.Menu_VenusManager + "," + KeyManager.MENUS.Menu_VisitorManager + "," + KeyManager.MENUS.Menu_ResourceManager + "," + KeyManager.MENUS.Menu_PagesManager + "," + KeyManager.MENUS.Menu_PagesPublishManager; //AuthorityManager.EditAuthorityByUserId(KeyManager.CUR_USERID, newVenueID, sysUserMenus, KeyManager.UserTypeId_BuissiensUser); returnStr = KeyManager.RetrunSucceed; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所成功,venuesinfo=" + venueInfo, loginUserInfo); } else { returnStr = KeyManager.RetrunUnSucceed; } } else { returnStr = "不成功,已有登录名为“" + objVenue["loginName"].ToString() + "”的场所用户。"; } } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所成功,venuesinfo=" + venueInfo + ";错误信息:" + e.Message, loginUserInfo); } return returnStr; }
public static string GetVenuesForSelect(string loginUserInfo) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = "SELECT vv.ID,vv.VenueName,vv.VenueManager,vv.VenueTypeID FROM tbl_venue as vv"; ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); ja.Add( new JObject( new JProperty("VenueName", "所有场所"), new JProperty("ID", "0"), new JProperty("VenueManager", "全部"), new JProperty("VenueTypeID", KeyManager.UserTypeId_BuissiensUser) ) ); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("VenueName", ks["VenueName"].ToString()), new JProperty("VenueManager", ks["VenueManager"].ToString()), new JProperty("VenueTypeID", ks["VenueTypeID"].ToString()) ) ); }; } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据条件查询场所信息,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
//pagetype 新闻页:42;促销页:41 public static string GetPageListByPagetype(int pagetype) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = ""; if (pagetype != 0) { strSql = string.Format("SELECT tp.ID,tp.PageCreateTime,tp.PageDescription,tp.PageModifyTime,tp.PageName,tp.PagePublish,tp.PageState,dd.DA_Name AS PageStateName,dd.DA_Code AS PageStateNameCode,tp.TemplateID,tp.VenueID,tp.PageTypeID,ts.DA_Name AS PageTypeName,ts.DA_Code AS PageTypeNameCode FROM tbl_page AS tp LEFT JOIN tbl_sys_dictionary AS dd ON dd.DA_Id=tp.PageState LEFT JOIN tbl_sys_dictionary AS ts ON tp.PageTypeID=ts.DA_Id WHERE tp.PageState!={0} AND tp.PagePublish={1} AND tp.PageTypeID={2} ", KeyManager.PageStatu_EditID, KeyManager.PagePublish_Yes, pagetype); } ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { int pageID = int.Parse(ks["ID"].ToString()); string pageInfoStr = GetPageInfoByPageID(pageID); JObject objPageInfo = JObject.Parse(pageInfoStr); string pageModuleStr = GetPageModulesInfo(pageID); JArray objPagesMdule = JArray.Parse(pageModuleStr); if (pagetype == KeyManager.PageType_SalesPage) { string saleInfoStr = GetSaleThemeInfoByPageID(pageID); JObject objSaleInfo = JObject.Parse(saleInfoStr); ja.Add( new JObject( new JProperty("SaleThemeInfo", objSaleInfo), new JProperty("PageInfo", objPageInfo), new JProperty("Modules", objPagesMdule) ) ); } else if (pagetype == KeyManager.PageType_NewsPage) { string newsInfoStr = GetNewsPageInfoByPageID(pageID); JObject objNewsInfo = JObject.Parse(newsInfoStr); ja.Add( new JObject( new JProperty("newPageInfo", objNewsInfo), new JProperty("PageInfo", objPageInfo), new JProperty("Modules", objPagesMdule) ) ); } else { ja.Add( new JObject( new JProperty("PageInfo", objPageInfo), new JProperty("Modules", objPagesMdule) ) ); } }; } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据页面类型获取当前需要发布的页面页面" + pagetype + ",错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string ModifyVenueSecquenceTop(string loginUserInfo, string venueInfo) { string returnStr = ""; JObject objVenue = JObject.Parse(venueInfo); try { using (venuesEntities db = new venuesEntities()) { int modVenueID = int.Parse(objVenue["modVenueID"].ToString()); int curVenueTypeID = int.Parse(objVenue["modVenueTypeID"].ToString()); string sequenceTop = objVenue["sequenceNum"].ToString(); //查找已设置为top前三的venue string strSql = "SELECT tv.ID FROM tbl_venue AS tv WHERE tv.VenueTypeID=" + curVenueTypeID + " AND tv.SequenceTopThree LIKE '" + sequenceTop + "'"; ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); Boolean isCancelSetTop = false; foreach (var ks in kss) { if (ks["ID"].ToString() != "0" ) { if( ks["ID"].ToString() == modVenueID.ToString()){ isCancelSetTop = true; } //修改已设置为top前三的排序字段为空 int delvenueID = int.Parse(ks["ID"].ToString()); //tbl_venue tbv = db.tbl_venue.First<tbl_venue>(a => a.ID.Equals(delvenueID)); //tbv.SequenceTopThree = ""; ModifyVenueSecquenceTopByVenueID(loginUserInfo,delvenueID, ""); } } if (modVenueID != 0 && !isCancelSetTop) { //修改新设置的venue为top前三的数值 //tbl_venue tbv = db.tbl_venue.First<tbl_venue>(a => a.ID.Equals(modVenueID)); //tbv.SequenceTopThree = sequenceTop; returnStr=ModifyVenueSecquenceTopByVenueID(loginUserInfo, modVenueID, sequenceTop); } //if (db.SaveChanges() != 0) //{ // returnStr = KeyManager.RetrunSucceed; //} //else //{ // returnStr = KeyManager.RetrunUnSucceed; //} } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "修改场所的Top顺序成功,venuesinfo=" + venueInfo + ";错误信息:" + e.Message, loginUserInfo); } return returnStr; }
//pagetype 为1,则代表获取的页面为内容页和首页;若为2,则代表获取的页面为新闻页;若为3,则代表获取的页面为促销页 public static string GetPageListByVenueId(int venueId) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = ""; if (venueId != 0) { strSql = string.Format("SELECT tp.ID,tp.PageCreateTime,tp.PageDescription,tp.PageModifyTime,tp.PageName,tp.PagePublish,tp.PageState,tp.Sequence,dd.DA_Name AS PageStateName,dd.DA_Code AS PageStateNameCode,tp.TemplateID,tp.VenueID,tp.PageTypeID,ts.DA_Name AS PageTypeName,ts.DA_Code AS PageTypeNameCode ,tt.TemplateColor,tt.TemplateDescription,tt.TemplateHeight,tt.TemplateImage,tt.TemplateCreateTime,tt.TemplateName,tt.TemplateType,tt.TemplateWidth FROM tbl_page AS tp LEFT JOIN tbl_sys_dictionary AS dd ON dd.DA_Id=tp.PageState LEFT JOIN tbl_sys_dictionary AS ts ON tp.PageTypeID=ts.DA_Id LEFT JOIN tbl_template AS tt ON tp.TemplateID=tt.ID WHERE tp.VenueID ={0} AND tp.PagePublish={2} AND tp.PageTypeID!={3} ORDER BY tp.VenueID,tp.Sequence", venueId, KeyManager.PageStatu_EditID, KeyManager.PagePublish_Yes, KeyManager.PageType_NewsPage); } ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { int pageID = int.Parse(ks["ID"].ToString()); string pageModuleStr = GetPageModulesInfo(pageID); JArray objPagesMdule = JArray.Parse(pageModuleStr); ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("PageDescription", ks["PageDescription"].ToString()), new JProperty("PageCreateTime", ks["PageCreateTime"].ToString()), new JProperty("PageModifyTime", ks["PageModifyTime"].ToString()), new JProperty("PageName", ks["PageName"].ToString()), new JProperty("PagePublish", ks["PagePublish"].ToString()), new JProperty("PageStateName", ks["PageStateName"].ToString()), new JProperty("PageStateNameCode", ks["PageStateNameCode"].ToString()), new JProperty("PageSequence", ks["Sequence"].ToString()), new JProperty("TemplateID", ks["TemplateID"].ToString()), new JProperty("Sequence", ks["Sequence"].ToString()), new JProperty("PageTypeID", ks["PageTypeID"].ToString()), new JProperty("PageTypeName", ks["PageTypeName"].ToString()), new JProperty("PageTypeNameCode", ks["PageTypeNameCode"].ToString()), new JProperty("TemplateColor", ks["TemplateColor"].ToString()), new JProperty("TemplateDescription", ks["TemplateDescription"].ToString()), new JProperty("TemplateHeight", ks["TemplateHeight"].ToString()), new JProperty("TemplateImage", ks["TemplateImage"].ToString()), new JProperty("TemplateName", ks["TemplateName"].ToString()), new JProperty("TemplateType", ks["TemplateType"].ToString()), new JProperty("TemplateWidth", ks["TemplateWidth"].ToString()), new JProperty("Modules", objPagesMdule) ) ); }; } } catch (Exception e) { // LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据venueId及发布状态获取该场所的所有页面信息,venueId=" + venueId + ",错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static String GetPageModuleAttributeByPageId( string loginUserInfo, int pageID) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tpma.ID,tpma.MAKey,td.DA_Name AS MAKeyName,tpma.MAValue,tpma.ModuleID,tpma.PageID,tpma.TmplateID FROM tbl_page_module_attribute AS tpma LEFT JOIN tbl_sys_dictionary AS td ON tpma.MAKey=td.DA_Id WHERE tpma.PageID={0}", pageID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { ja.Add( new JObject( new JProperty("ID", ks["ID"].ToString()), new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("PageID", ks["PageID"].ToString()), new JProperty("TmplateID", ks["TmplateID"].ToString()), new JProperty("MAKey", ks["MAKey"].ToString()), new JProperty("MAKeyName", ks["MAKeyName"].ToString()), new JProperty("MAValue", ks["MAValue"].ToString()) ) ); } } } catch (Exception e) { LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "根据页面id获取页面模块的其他属性,pageID=" + pageID + ";错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }
public static string GetPageModulesInfo(int pageID) { JArray ja = new JArray(); try { using (venuesEntities db = new venuesEntities()) { string strSql = string.Format("SELECT tpc.ContentSequence,tpc.ContentValue,tpc.ModuleID,tm.ModuleDepth,tm.ModuleHeight,tm.ModuleImage,tm.ModuleType,tsd.DA_Name AS ModuleTypeName,tsd.DA_Code AS ModuleTypeNameCode,tm.ModuleWidth,tm.ModuleX,tm.ModuleY FROM tbl_page_content AS tpc LEFT JOIN tbl_module AS tm ON tpc.ModuleID=tm.ID LEFT JOIN tbl_sys_dictionary AS tsd ON tm.ModuleType=tsd.DA_Id ,(SELECT tpc1.ModuleID,min(tpc1.ContentSequence) AS mcs FROM tbl_page_content AS tpc1 GROUP BY tpc1.ModuleID ) AS tpcn WHERE tpc.PageID={0} and tpc.ModuleID=tpcn.ModuleID and tpc.ContentSequence=tpcn.mcs ORDER BY tm.ModuleDepth", pageID); ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql); foreach (var ks in kss) { int moduleID = int.Parse(ks["ModuleID"].ToString()); int moduleTypeId = int.Parse(ks["ModuleType"].ToString()); string WordFont = ""; string WordSize = ""; string FontWeight = ""; string FontStyle = ""; string TextDecoration = ""; string FontColor = ""; string ImageScaleMode = ""; string FontBackgroundColor = ""; string FontBackgroundAlpha = ""; string FontVerticalAlign = ""; string FontTextAlign = ""; string MapLng = ""; string MapLat = ""; string pageModuleAttr = PageModuleAttributeManager.GetPageModuleAttributeByIds(moduleID, "", pageID); JArray arrPageMoudleAtt = JArray.Parse(pageModuleAttr); string moduleAttr = GetModuleAttributeByModuleId(moduleID); JArray arrModule = JArray.Parse(moduleAttr); JArray curModuleAtt = new JArray(); if (pageModuleAttr != "[]") { curModuleAtt = arrPageMoudleAtt; } else { curModuleAtt = arrModule; } foreach (JObject objModule in curModuleAtt) { if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontColor) { FontColor = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontStyle) { FontStyle = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontWeight) { FontWeight = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_ImageScaleMode) { ImageScaleMode = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_TextDecoration) { TextDecoration = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_WordFont) { WordFont = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_WordSize) { WordSize = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontBackgroundColor) { FontBackgroundColor = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontBackgroundAlpha) { FontBackgroundAlpha = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontTextAlign) { FontTextAlign = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_FontVerticalAlign) { FontVerticalAlign = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_MapLng) { MapLng = (objModule["MAValue"].ToString()); } else if (int.Parse(objModule["MAKey"].ToString()) == KeyManager.ModuleAttr_MapLat) { MapLat = (objModule["MAValue"].ToString()); } } if (moduleTypeId == KeyManager.ModuleType_Writing) { if (ks["ContentValue"].ToString() != "") { ja.Add( new JObject( new JProperty("ContentSequence", ks["ContentSequence"].ToString()), new JProperty("ContentValue", ks["ContentValue"].ToString()), new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("ModuleDepth", ks["ModuleDepth"].ToString()), new JProperty("ModuleHeight", ks["ModuleHeight"].ToString()), new JProperty("ModuleImage", ks["ModuleImage"].ToString()), new JProperty("ModuleType", ks["ModuleType"].ToString()), new JProperty("ModuleTypeName", ks["ModuleTypeName"].ToString()), new JProperty("ModuleTypeNameCode", ks["ModuleTypeNameCode"].ToString()), new JProperty("ModuleWidth", ks["ModuleWidth"].ToString()), new JProperty("ModuleX", ks["ModuleX"].ToString()), new JProperty("ModuleY", ks["ModuleY"].ToString()), new JProperty("WordFont", WordFont), new JProperty("WordSize", WordSize), new JProperty("FontWeight", FontWeight), new JProperty("FontStyle", FontStyle), new JProperty("TextDecoration", TextDecoration), new JProperty("FontColor", FontColor), new JProperty("FontBackgroundColor", FontBackgroundColor), new JProperty("FontBackgroundAlpha", FontBackgroundAlpha), new JProperty("FontTextAlign", FontTextAlign), new JProperty("FontVerticalAlign", FontVerticalAlign) ) ); } } else if (moduleTypeId == KeyManager.ModuleType_ImageGroup) { string imgLists = GetPageContentImageByModuleID(moduleID, pageID); JArray arrImages = JArray.Parse(imgLists); if (imgLists != "[]") { ja.Add( new JObject( new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("ModuleDepth", ks["ModuleDepth"].ToString()), new JProperty("ModuleHeight", ks["ModuleHeight"].ToString()), new JProperty("ModuleImage", ks["ModuleImage"].ToString()), new JProperty("ModuleType", ks["ModuleType"].ToString()), new JProperty("ModuleTypeName", ks["ModuleTypeName"].ToString()), new JProperty("ModuleTypeNameCode", ks["ModuleTypeNameCode"].ToString()), new JProperty("ModuleWidth", ks["ModuleWidth"].ToString()), new JProperty("ModuleX", ks["ModuleX"].ToString()), new JProperty("ModuleY", ks["ModuleY"].ToString()), new JProperty("ImageScaleMode", ImageScaleMode), new JProperty("ImageList", arrImages) ) ); } } else if (moduleTypeId == KeyManager.ModuleType_Viedo) { if (ks["ContentValue"].ToString() != "") { ja.Add( new JObject( new JProperty("ContentSequence", ks["ContentSequence"].ToString()), new JProperty("ContentValue", ks["ContentValue"].ToString()), new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("ModuleDepth", ks["ModuleDepth"].ToString()), new JProperty("ModuleHeight", ks["ModuleHeight"].ToString()), new JProperty("ModuleImage", ks["ModuleImage"].ToString()), new JProperty("ModuleType", ks["ModuleType"].ToString()), new JProperty("ModuleTypeName", ks["ModuleTypeName"].ToString()), new JProperty("ModuleTypeNameCode", ks["ModuleTypeNameCode"].ToString()), new JProperty("ModuleWidth", ks["ModuleWidth"].ToString()), new JProperty("ModuleX", ks["ModuleX"].ToString()), new JProperty("ModuleY", ks["ModuleY"].ToString()) ) ); } } else if (moduleTypeId == KeyManager.ModuleType_Map) { if (ks["ContentValue"].ToString() != "") { ja.Add( new JObject( new JProperty("ContentSequence", ks["ContentSequence"].ToString()), new JProperty("ContentValue", ks["ContentValue"].ToString()), new JProperty("ModuleID", ks["ModuleID"].ToString()), new JProperty("ModuleDepth", ks["ModuleDepth"].ToString()), new JProperty("ModuleHeight", ks["ModuleHeight"].ToString()), new JProperty("ModuleImage", ks["ModuleImage"].ToString()), new JProperty("ModuleType", ks["ModuleType"].ToString()), new JProperty("ModuleTypeName", ks["ModuleTypeName"].ToString()), new JProperty("ModuleTypeNameCode", ks["ModuleTypeNameCode"].ToString()), new JProperty("ModuleWidth", ks["ModuleWidth"].ToString()), new JProperty("ModuleX", ks["ModuleX"].ToString()), new JProperty("MapLng", MapLng), new JProperty("MapLat", MapLat), new JProperty("ModuleY", ks["ModuleY"].ToString()) ) ); } } } } } catch (Exception e) { //LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookPublishManager, "查询手册场所列表,错误信息:" + e.Message, loginUserInfo); } return ja.ToString(); }