/// <summary>
/// 添加日志
/// </summary>
/// <param name="UserId">用户ID</param>
/// <returns></returns>
public static void addLog(int logTypeId, int logMenuId, string logInfo, string loginUserInfo)
{
using (venuesEntities db = new venuesEntities())
{
int userId = 0;
int usertypeId = 5;
if (loginUserInfo == "" || loginUserInfo == "{}" || loginUserInfo == null)
{
}
else
{
JObject objUser = JObject.Parse(loginUserInfo);
userId = int.Parse(objUser["curUserID"].ToString());
usertypeId = int.Parse(objUser["UserTypeId"].ToString());
}
tbl_sys_log log = new tbl_sys_log();
log.Log_TypeId = logTypeId;
log.Log_UserId = userId;
log.Log_MenuId = logMenuId;
log.Log_Info = logInfo;
log.Log_Timestamp = DateTime.Now;
log.Log_UserTypeId = usertypeId;
db.AddTotbl_sys_log(log);
db.SaveChanges();
}
}
/// <summary>
/// 根据日志id列表删除日志记录
/// </summary>
/// <param name="curUserID"></param>
/// <param name="logIds"></param>
/// <returns></returns>
public static string DeleteLogsByIDs(int curUserID, String logIds, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
List<string> logslist = new List<string>(logIds.Split(','));
foreach (String clogId in logslist)
{
if (clogId != "")
{
int curlogID = int.Parse(clogId);
tbl_sys_log su = db.tbl_sys_log.First<tbl_sys_log>(a => a.Log_Id.Equals(curlogID));
db.DeleteObject(su);
}
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_LogsManager, "删除日志成功，logIds=" + logIds, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_LogsManager, "删除日志失败，logIds=" + logIds + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static String DeleteADs( string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
//string strSql = string.Format("SELECT tad.ADImage,tad.ADName,tad.ID FROM tbl_ad AS tad");
//ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql);
//foreach (DbDataRecord item in results)
//{
// db.DeleteObject(item);
//};
//if (db.SaveChanges() != 0)
// returnStr = "成功!";
//else
ObjectQuery<tbl_ad> query = db.tbl_ad;
foreach (tbl_ad item in query)
{
db.DeleteObject(item);
}
db.SaveChanges();
returnStr = "成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "删除广告信息,错误信息：" + e.Message, loginUserInfo);
}
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_HandBookSetManager, "删除广告信息", loginUserInfo);
return returnStr;
}
public static string DeleteResourceByIDs(String fileIds, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
List<string> filelist = new List<string>(fileIds.Split(','));
foreach (String cId in filelist)
{
if (cId != "")
{
int curID = int.Parse(cId);
tbl_file bus = db.tbl_file.First<tbl_file>(a => a.ID.Equals(curID));
db.DeleteObject(bus);
}
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VenusManager, "根据资源id删除资源记录成功，fileIds=" + fileIds, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据资源id删除资源记录，fileIds=" + fileIds + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static String DeletePageModuleAttributeByPageAndModuleID(int mId, string loginUserInfo,int pageID)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
ObjectQuery<tbl_page_module_attribute> tva = db.tbl_page_module_attribute.Where("it.ModuleID==@v AND it.PageID==@u", new ObjectParameter("v", mId), new ObjectParameter("u", pageID));
ObjectResult<tbl_page_module_attribute> results = tva.Execute(MergeOption.NoTracking);
foreach (tbl_page_module_attribute item in results)
{
db.AttachTo("tbl_page_module_attribute", item);
db.DeleteObject(item);
};
if (db.SaveChanges() != 0)
returnStr = KeyManager.RetrunSucceed;
else
returnStr = KeyManager.RetrunUnSucceed;
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据moduleId和pageID删除页面模块其他属性,moduleId=" + mId + "，pageID="+pageID+"；错误信息：" + e.Message, loginUserInfo);
}
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_PagesManager, "根据moduleId和pageID删除页面模块其他属性,moduleId=" + mId + "，pageID=" + pageID, loginUserInfo);
return returnStr;
}
public static string DeletePageContentByPageID(int pageID,string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
ObjectQuery<tbl_page_content> tva = db.tbl_page_content.Where("it.PageID==@v", new ObjectParameter("v", pageID));
ObjectResult<tbl_page_content> results = tva.Execute(MergeOption.NoTracking);
foreach (tbl_page_content item in results)
{
db.AttachTo("tbl_page_content", item);
db.DeleteObject(item);
};
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_PagesManager, "删除页面内容成功，pageID=" + pageID, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "删除页面内容，pageID=" + pageID + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string DeleteMeetingRoomByIDs(String meetingIds, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
List<string> list = new List<string>(meetingIds.Split(','));
foreach (String cId in list)
{
if (cId != "")
{
int curMeetingID = int.Parse(cId);
tbl_venue_meetingroom bus = db.tbl_venue_meetingroom.First<tbl_venue_meetingroom>(a => a.ID.Equals(curMeetingID));
db.DeleteObject(bus);
}
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VenusManager, "删除会议室成功，meetingIds=" + meetingIds, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "删除会议室，meetingIds=" + meetingIds + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string AddModuleAttribute(int modlueID, string addInfo, string loginUserInfo)
{
string returnStr = "";
JObject objVenue = JObject.Parse(addInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_module_attribute tva = new tbl_module_attribute();
tva.ModuleID = modlueID;
tva.MAKey = int.Parse(objVenue["MAKey"].ToString());
tva.MAValue = objVenue["MAValue"].ToString();
db.AddTotbl_module_attribute(tva);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "新增模块其他属性,modlueID=" + modlueID + "addInfo=" + addInfo, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "新增模块其他属性，modlueID=" + modlueID + "addInfo=" + addInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string DeleteResourceByVenueID(int veneuID, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
if (veneuID != 0)
{
ObjectQuery<tbl_file> tva = db.tbl_file.Where("it.FileUserID==@v", new ObjectParameter("v", veneuID));
ObjectResult<tbl_file> results = tva.Execute(MergeOption.NoTracking);
foreach (tbl_file item in results)
{
db.AttachTo("tbl_file", item);
db.DeleteObject(item);
};
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VenusManager, "根据场所id删除资源记录成功，veneuID=" + veneuID, loginUserInfo);
}
else
returnStr = KeyManager.RetrunUnSucceed;
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据场所id删除资源记录，veneuID=" + veneuID + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string DeleteThemeByID(int themeId, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
if (themeId == 1)
{
returnStr = "此项为默认值，不可删除!";
}
else
{
tbl_theme bus = db.tbl_theme.First<tbl_theme>(a => a.ID.Equals(themeId));
db.DeleteObject(bus);
//删除主题关联的促销关联关系
ThemeSalesManager.DeleteThemeSalesByThemeId(themeId, loginUserInfo);
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_SalesManager, "根据促销主题id删除促销主题，themeId=" + themeId, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "根据促销主题id删除促销主题，themeId=" + themeId + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string AddVenuePages(int venueId, string addInfo, string loginUserInfo)
{
string returnStr = "";
JObject objVenue = JObject.Parse(addInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_venue_pages tva = new tbl_venue_pages();
tva.VenueID = venueId;
tva.PageID = int.Parse(objVenue["PageID"].ToString());
tva.PageTypeID = int.Parse(objVenue["PageTypeID"].ToString());
db.AddTotbl_venue_pages(tva);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所页面关联关系成功，venueId=" + venueId + ",addInfo=" + addInfo, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所页面关联失败，venueId=" + venueId + ",addInfo=" + addInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string DeleteGuestMessageByIDs(String guestMessageIds, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
List<string> glist = new List<string>(guestMessageIds.Split(','));
foreach (String cId in glist)
{
if (cId != "")
{
int curID = int.Parse(cId);
tbl_guest_message bus = db.tbl_guest_message.First<tbl_guest_message>(a => a.ID.Equals(curID));
db.DeleteObject(bus);
}
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VisitorManager, "根据游客留言id删除游客留言记录，guestMessageIds=" + guestMessageIds, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VisitorManager, "根据游客留言id删除游客留言记录，guestMessageIds=" + guestMessageIds + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
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 string DeleteSalesPageByID(int saleId,string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_sales bus = db.tbl_sales.First<tbl_sales>(a => a.ID.Equals(saleId));
int pageId = int.Parse(bus.SalesPageID.ToString());
db.DeleteObject(bus);
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
PageManager.DeletePageByID(pageId, loginUserInfo);//同时删除page表中的促销页信息
ThemeSalesManager.DeleteThemeSalesBySaleId(saleId, loginUserInfo);//同时删除主题与该促销页的关联关系
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_SalesManager, "根据促销id删除促销页面记录，saleId=" + saleId, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "根据促销id删除促销页面记录，saleId=" + saleId + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string AddPageModuleAttribute(string addInfo, string loginUserInfo,int pageID,int templateID)
{
string returnStr = "";
JObject objVenue = JObject.Parse(addInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
DeletePageModuleAttributeByPageModuleIDAndMAKey(int.Parse(objVenue["ModuleID"].ToString()), loginUserInfo, pageID, int.Parse(objVenue["MAKey"].ToString()));
tbl_page_module_attribute tva = new tbl_page_module_attribute();
tva.ModuleID = int.Parse(objVenue["ModuleID"].ToString());
tva.PageID = pageID;
tva.TmplateID = templateID;
tva.MAKey = int.Parse(objVenue["MAKey"].ToString());
tva.MAValue = objVenue["MAValue"].ToString();
db.AddTotbl_page_module_attribute(tva);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "新增页面模块其他属性, pageID=" + pageID + "addInfo=" + addInfo, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "新增页面模块其他属性， pageID=" + pageID + "addInfo=" + addInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string DeleteNewByID(int newId,string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_news bus = db.tbl_news.First<tbl_news>(a => a.ID.Equals(newId));
int pageId = int.Parse(bus.NewsPage.ToString());
db.DeleteObject(bus);
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
PageManager.DeletePageByID(pageId, loginUserInfo);
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_NewsManager, "删除新闻页面成功，newId=" + newId, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_NewsManager, "删除新闻页面，newId=" + newId + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string AddVenueAttribute(int venueId, string addInfo, string loginUserInfo)
{
string returnStr = "";
JObject objVenue = JObject.Parse(addInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_venue_attribute tva = new tbl_venue_attribute();
tva.VenueID = venueId;
tva.VenueAttributeKey = int.Parse(objVenue["otherValueNameId"].ToString());
tva.VenueAttributeValue = objVenue["otherValueContent"].ToString();
db.AddTotbl_venue_attribute(tva);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所其他属性成功，venueId=" + venueId + ",addInfo=" + addInfo, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增场所其他属性成功，venueId=" + venueId + ",addInfo=" + addInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
/// <summary>
/// 根据场所id列表删除场所记录
/// </summary>
/// <param name="curUserID"></param>
/// <param name="venuesIds"></param>
/// <returns></returns>
public static string DeleteVenuesByIDs(int curUserID, String venuesIds, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
List<string> venuelist = new List<string>(venuesIds.Split(','));
foreach (String cVenueId in venuelist)
{
if (cVenueId != "")
{
int curlogID = int.Parse(cVenueId);
tbl_sys_businessman bus = db.tbl_sys_businessman.First<tbl_sys_businessman>(a => a.Business_Id.Equals(cVenueId));
db.DeleteObject(bus);
}
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VenusManager, "删除场所成功，venuesIds=" + venuesIds, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "删除场所成功，venuesIds=" + venuesIds + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string AddThemeAndSale(int themeID, int saleID, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
if (saleID != 0)
{
tbl_theme_salespage tva = new tbl_theme_salespage();
tva.ThemeID = themeID;
tva.SalePageID = saleID;
db.AddTotbl_theme_salespage(tva);
}
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "新增主题与促销页面的关联关系，themeID=" + themeID + ",saleID=" + saleID, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "新增主题与促销页面的关联关系，themeID=" + themeID + ",saleID=" + saleID + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
/// <summary>
/// 删除指定用户
/// </summary>
/// <param name="UserId">用户ID</param>
/// <returns></returns>
public static String DeleteUser(int curUserId, int deleteUserId, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_sys_user su = db.tbl_sys_user.First<tbl_sys_user>(a => a.User_Id.Equals(deleteUserId));
db.DeleteObject(su);
AuthorityManager.deleteAllAuthoriyByUserID(deleteUserId, KeyManager.UserTypeId_SystemUser, loginUserInfo);
if (db.SaveChanges() != 0)
returnStr = "成功!";
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SystemUsersManager, "删除用户,deleteUserId=" + deleteUserId + "；错误信息：" + e.Message, loginUserInfo);
}
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_SystemUsersManager, "删除用户,deleteUserId=" + deleteUserId, loginUserInfo);
return returnStr;
}
public static string AddAds(string addInfo, string loginUserInfo)
{
string returnStr = "";
JObject objVenue = JObject.Parse(addInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
tbl_ad tva = new tbl_ad();
tva.ADImage = objVenue["ADImage"].ToString();
tva.ADName = objVenue["ADName"].ToString();
db.AddTotbl_ad(tva);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "新增广告信息,addInfo=" + addInfo, loginUserInfo);
}
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "新增广告信息,addInfo=" + addInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
public static string SaveHandBook(string mInfo, string loginUserInfo)
{
string returnStr = "";
JObject objInfo = JObject.Parse(mInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
if (int.Parse(objInfo["BookId"].ToString()) == 0)
{
tbl_book tbt = new tbl_book();
tbt.BookBackgroundImg = objInfo["BookBackgroundImg"].ToString();
tbt.BookCreateTIme = DateTime.Now;
tbt.BookFacebookLink = objInfo["BookFacebookLink"].ToString();
tbt.BookTwitterLink = objInfo["BookTwitterLink"].ToString();
tbt.BookWeiboLink = objInfo["BookWeiboLink"].ToString();
tbt.BookWeixinLink = objInfo["BookWeixinLink"].ToString();
db.AddTotbl_book(tbt);
}
else
{
int bookId = int.Parse(objInfo["BookId"].ToString());
tbl_book tsu = db.tbl_book.First<tbl_book>(a => a.ID.Equals(bookId));
tsu.BookBackgroundImg = objInfo["BookBackgroundImg"].ToString();
tsu.BookCreateTIme = DateTime.Now;
tsu.BookFacebookLink = objInfo["BookFacebookLink"].ToString();
tsu.BookTwitterLink = objInfo["BookTwitterLink"].ToString();
tsu.BookWeiboLink = objInfo["BookWeiboLink"].ToString();
tsu.BookWeixinLink = objInfo["BookWeixinLink"].ToString();
}
if (db.SaveChanges() != 0)
{
string adInfo = objInfo["ADInfo"].ToString();
returnStr = ADManager.DeleteADs(loginUserInfo);
if (adInfo != "[]")
{
JArray arrContent = JArray.Parse(objInfo["ADInfo"].ToString());
foreach (JObject objAd in arrContent)
{
returnStr = ADManager.AddAds(objAd.ToString(), loginUserInfo);
}
}
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
}
}
}
catch (Exception e)
{
returnStr = e.Message;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_HandBookSetManager, "手册保存，mInfo=" + mInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
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;
}
/// <summary>
/// 初始化用户权限
/// </summary>
/// <param name="addUserId"></param>
public static void AddAuthority(int addUserId)
{
using (venuesEntities db = new venuesEntities())
{
tbl_sys_authority au = new tbl_sys_authority();
au.AT_UserId = addUserId;
au.AT_MenuId = 1;
db.AddTotbl_sys_authority(au);
db.SaveChanges();
}
}
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;
}
public static string DeleteVenuTemplateByVenueID(int venueID, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
//string strSql = string.Format("SELECT tt.ID,tt.TemplateID,tt.VenueID FROM tbl_venue_template AS tt WHERE tt.VenueID={0}", venueID);
//ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql);
//foreach (var item in results)
//{
// //int deleteID = int.Parse(item["ID"].ToString());
// //tbl_venue_template tvt = db.tbl_venue_template.First<tbl_venue_template>(a => a.ID.Equals(deleteID));
// //db.DeleteObject(tvt);
// int deleteID = int.Parse(item["ID"].ToString());
// tbl_venue_template su = db.tbl_venue_template.First<tbl_venue_template>(a => a.ID.Equals(deleteID));
// db.DeleteObject(su);
// //db.AttachTo("tbl_venue_template", item);
// // db.DeleteObject(item);
//}
ObjectQuery<tbl_venue_template> query = db.tbl_venue_template.Where("it.VenueID = @id", new ObjectParameter("id", venueID));
foreach (tbl_venue_template item in query)
{
db.DeleteObject(item);
}
if (db.SaveChanges() != 0)
{
returnStr = "成功!";
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_LogsManager, "根据场所id，删除场所模板关联表中的关联信息，venueID=" + venueID, loginUserInfo);
}
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_ModulesManager, "根据场所id，删除场所模板关联表中的关联信息，venueID=" + venueID + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
protected void Page_Load(object sender, EventArgs e)
{
string path = System.Configuration.ConfigurationManager.AppSettings["FilePath"].ToString()+"\\files";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
HttpFileCollection files = Request.Files;
if (files.Count == 0)
{
Response.Write("请勿直接访问本文件");
Response.End();
}
// 只取第 1 个文件
HttpPostedFile file = files[0];
if (file != null && file.ContentLength > 0)
{
using (venuesEntities db = new venuesEntities())
{
tbl_file kf = new tbl_file();
float m = (float)file.ContentLength / 1048576;
kf.Size =float.Parse( Math.Round(m,2).ToString());
kf.FileNameLocal = file.FileName;
string serverName = DateTime.Now.ToString("yyyyMMdd_HHmmss") + Path.GetExtension(Request.Form["fileName"]).ToLower();
kf.FileNameServer = "files/"+ serverName;
kf.FileUploadTime = DateTime.Now;
kf.FileUserID = int.Parse(Request.Params.Get("curUserID"));
kf.UserVenueTypeID = Request.Params.Get("curUserTypeParentID");
kf.Ext = System.IO.Path.GetExtension(file.FileName.ToLower()).Substring(1);
kf.DescribeInfo = Request.Params.Get("descript");
db.AddTotbl_file(kf);
db.SaveChanges();
string savePath = path + "\\" + serverName;
file.SaveAs(savePath);
}
}
}
public static string AddSalePage(string mInfo, string loginUserInfo)
{
string returnStr = "";
JObject objInfo = JObject.Parse(mInfo);
JObject objUser = JObject.Parse(loginUserInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
DateTime curDate = DateTime.Now;
int curNewSeq = GetMaxSequence();
tbl_sales tn = new tbl_sales();
tn.SalesCreateTime =DateTime.Parse(objInfo["PageCreateTime"].ToString());
tn.SalesPageID = int.Parse(objInfo["PageID"].ToString());
tn.SalesTitle = objInfo["PageName"].ToString();
tn.UserID = int.Parse(objUser["curUserID"].ToString());
tn.SalesSequence = curNewSeq + 1;
tn.SalesPublishID = int.Parse(objInfo["PagePublishID"].ToString());
tn.SalesVenueName = objInfo["VenueName"].ToString();
int themeId =int.Parse(objInfo["ThemeID"].ToString());
db.AddTotbl_sales(tn);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
int curSalePageID = GetMaxSalePageID();
ThemeSalesManager.AddThemeAndSale(themeId, curSalePageID, loginUserInfo);
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
}
}
}
catch (Exception e)
{
returnStr = e.Message;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "新增促销页面，mInfo=" + mInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}
/// <summary>
/// 根据权限id，删除权限表
/// </summary>
public static void deleteAuthoriyByID(int authID, string loginUserInfo)
{
using (venuesEntities db = new venuesEntities())
{
try
{
string returnStr = "";
tbl_sys_authority su = db.tbl_sys_authority.First<tbl_sys_authority>(a => a.AT_Id.Equals(authID));
db.DeleteObject(su);
if (db.SaveChanges() != 0)
returnStr = "成功!";
else
returnStr = "不成功!";
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_Authority, "删除用户权限菜单，ID=" + authID + ",错误信息：" + e.Message, loginUserInfo);
}
}
}
/// <summary>
/// 删除指定用户
/// </summary>
/// <param name="UserId">用户ID</param>
/// <returns></returns>
public static String DeleteVenueAttributeByVenueId(int venueId, string loginUserInfo)
{
string returnStr = "";
try
{
using (venuesEntities db = new venuesEntities())
{
//string strSql = string.Format(" SELECT vatt.ID FROM tbl_venue_attribute AS vatt where vatt.VenueID={0}", venueId);
// ObjectQuery<DbDataRecord> kss= db.CreateQuery<DbDataRecord>(strSql);
// foreach (var ks in kss)
// {
// int cVenueAttId = int.Parse(ks["ID"].ToString());
// tbl_venue_attribute su = db.tbl_venue_attribute.First<tbl_venue_attribute>(a => a.ID.Equals(cVenueAttId));
// db.DeleteObject(su);
// }
//if (db.SaveChanges() != 0)
// returnStr = "成功!";
//else
// returnStr = "不成功!";
ObjectQuery<tbl_venue_attribute> tva = db.tbl_venue_attribute.Where("it.VenueID==@v", new ObjectParameter("v", venueId));
ObjectResult<tbl_venue_attribute> results = tva.Execute(MergeOption.NoTracking);
foreach (tbl_venue_attribute item in results)
{
db.AttachTo("tbl_venue_attribute", item);
db.DeleteObject(item);
};
if (db.SaveChanges() != 0 )
returnStr= "成功!";
else
returnStr = "不成功!";
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "根据场所id删除场所的其他属性,venueId=" + venueId + "；错误信息：" + e.Message, loginUserInfo);
}
LogManager.addLog(KeyManager.LogTypeId_Option, KeyManager.MENUS.Menu_VenusManager, "根据场所id删除场所的其他属性,venueId=" + venueId, loginUserInfo);
return returnStr;
}
