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();
}
