/// <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; }