/// <summary> /// 删除记录 /// </summary> /// <param name="GroupId"></param> public static void Delete(int GroupId) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_Groups.Single(p => p.Group_Id == GroupId); BD.Weblog_Groups.DeleteOnSubmit(temp); BD.SubmitChanges(); }
/// <summary> /// 根据logid来获取用户域名 /// </summary> /// <param name="logId">日记ID</param> /// <returns></returns> public static string GetUserDomainByLogID(int logId) { BlogDataDataContext BD = new BlogDataDataContext(); //string domain = ""; //int userId = -1; Weblog_Log temp = null; var WL = BD.Weblog_Logs.Where(p => p.Log_Id == logId); if (WL.Count() > 0) { temp = WL.First(); var WU = BD.Weblog_Users.Where(p => p.User_Id == temp.Log_UserId); if (WU.Count() > 0) { return WU.First().User_DomainName; } else { return ""; } } else { return ""; } }
/// <summary> /// 删除记录 /// </summary> /// <param name="CssId"></param> public static void Delete(int CssId) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_UserCsses.Single(p => p.UserCss_Id == CssId); BD.Weblog_UserCsses.DeleteOnSubmit(temp); BD.SubmitChanges(); }
/// <summary> /// 插入新的RssLink /// </summary> /// <param name="WURL"></param> public static bool InsertRssLink(Weblog_UserRssLink WURL) { BlogDataDataContext BD = new BlogDataDataContext(); BD.Weblog_UserRssLinks.InsertOnSubmit(WURL); BD.SubmitChanges(); return true; }
/// <summary> /// 删除主题 /// </summary> /// <param name="Id"></param> public static void Delete(int Id) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_Themes.Single(p => p.Theme_Id == Id); BD.Weblog_Themes.DeleteOnSubmit(temp); BD.SubmitChanges(); }
public static IEnumerable<View_WeblogUserRecommend> GetAll() { BlogDataDataContext BD = new BlogDataDataContext(); return BD.View_WeblogUserRecommends.OrderByDescending(p=>p.Recommend_Id); }
public static IEnumerable<View_WeblogUserRecommend> GetByPageIndex(Int32 PageIndex,Int32 Length) { BlogDataDataContext BD = new BlogDataDataContext(); return BD.View_WeblogUserRecommends.Where(p=>p.Recommend_ThemeId==PageIndex).OrderByDescending(p=>p.Recommend_CreateTime); }
public static void Edit(Weblog_Recommend WR) { BlogDataDataContext BD = new BlogDataDataContext(); var temp= BD.Weblog_Recommends.Single(p=>p.Recommend_Id==WR.Recommend_Id); temp.Recommend_LogId = WR.Recommend_LogId; BD.SubmitChanges(); }
//通过学号选 public static IEnumerable<View_WeblogUserXSJBXX> SearchByXH(string XH) { BlogDataDataContext BD = new BlogDataDataContext(); //return BD.View_WeblogUserXSJBXXes.Single(p=>p.XH==XH); return BD.View_WeblogUserXSJBXXes.Where(p => p.XH == XH); }
public static void DeleteById(int Id) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_CssFiles.Where(p => p.CssFile_Id == Id); BD.Weblog_CssFiles.DeleteAllOnSubmit(temp); BD.SubmitChanges(); }
/// <summary> /// myself:要利用Linq2Sql的延迟 /// </summary> /// <param name="PageIndex"></param> /// <param name="Length"></param> /// <param name="Count"></param> /// <returns></returns> public static IEnumerable<Weblog_User> GetAllPaged(int PageIndex, int Length, out int Count) { BlogDataDataContext BD = new BlogDataDataContext(); var users = BD.Weblog_Users.Select(p => p).Where(p => p.User_TxzId < 200000).OrderByDescending(p => p.CreateTime); Count = users.Count(); return users.Skip((PageIndex - 1) * Length).Take(Length); }
public static bool CheckExist(int Id) { BlogDataDataContext BD = new BlogDataDataContext(); if (BD.Weblog_CssFiles.Where(p => p.CssFile_Id == Id).Count() == 1) return true; else return false; }
/// <summary> /// 修改主题 /// </summary> /// <param name="WT"></param> public static void Update(Weblog_Theme WT) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_Themes.Single(p => p.Theme_Id == WT.Theme_Id); temp.Theme_Intro = WT.Theme_Intro; temp.Theme_Name = WT.Theme_Name; BD.SubmitChanges(); }
public static bool Insert(Weblog_RecommendTheme WRT) { BlogDataDataContext BD = new BlogDataDataContext(); BD.Weblog_RecommendThemes.InsertOnSubmit(WRT); BD.SubmitChanges(); return true; }
public static void Edit(Weblog_Notice WN) { BlogDataDataContext BD = new BlogDataDataContext(); Weblog_Notice notice = BD.Weblog_Notices.Where(p => p.Notice_Type == 1).First(); notice.Notice_Content = System.Web.HttpContext.Current.Server.HtmlEncode(WN.Notice_Content).Replace("\n", "<br />"); notice.Notice_CreateTime = DateTime.Now; BD.SubmitChanges(); }
public static View_WeblogUserLog GetByIDAndFiid(int ID,int FiiD) { BlogDataDataContext BD = new BlogDataDataContext(); var ret = BD.View_WeblogUserLogs.Where(p => p.Log_Id == ID &&p.User_FIID==FiiD&& p.Log_IsVisible == true && p.Log_IsDraft == false && p.Log_CreateTime <= DateTime.Now); if (ret.Count() > 0) return ret.First(); return null; }
public static View_BlogUserFriend GetByNickName(string NickName) { BlogDataDataContext BD = new BlogDataDataContext(); return BD.View_BlogUserFriends.Single(p => p.User_NickName == NickName); //return BD.View_BlogUserFriends.select(p => p.User_NickName == NickName); }
/// <summary> /// 读出总数 /// </summary> /// <returns></returns> public static Int32 GetCount() { BlogDataDataContext BD = new BlogDataDataContext(); return BD.View_WeblogUserRecommends.Count(); }
public static bool CheckHasCssFile(int BlogUserId) { BlogDataDataContext BD = new BlogDataDataContext(); if (BD.Weblog_UserCsses.Where(p => p.UserCss_UserId == BlogUserId).Count() >= 1) return true; else return false; }
/// <summary> /// 根据LogID来获取文章种类的名字 /// </summary> /// <param name="LogID"></param> /// <returns></returns> public static View_WeblogLogCategory GetByLogID(int LogID) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.View_WeblogLogCategorys.Where(p => p.Log_Id == LogID && p.Log_IsDraft == false && p.Log_IsVisible == true && p.Log_CreateTime <= DateTime.Now); if (temp.Count() > 0) return temp.First(); else return null; }
/// <summary> /// 根据Cate_Id获取文章种类 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static Weblog_Category SelectByID(int ID) { BlogDataDataContext BD = new BlogDataDataContext(); var temp= BD.Weblog_Categorys.Where(p => p.Cate_Id == ID); if (temp.Count() > 0) return temp.First(); else return null; }
public static View_WeblogThemeDetail GetByBlogUserId(int BlogUserId) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.View_WeblogThemeDetails.Where(p => p.User_Id == BlogUserId); if (temp.Count() >= 1) return temp.First(); else return null; }
/// <summary> ///返回Css文件路径集合 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public static View_WeblogCssFilePath GetCssFilePathByUserId(int UserId) { BlogDataDataContext BD = new BlogDataDataContext(); var temp= BD.View_WeblogCssFilePaths.Where(p => p.User_Id == UserId); if (temp.Count() >= 1) return temp.First(); else return null; }
/// <summary> /// 更新记录 /// </summary> /// <param name="WUC"></param> public static void Update(Weblog_UserCss WUC) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.Weblog_UserCsses.Single(p => p.UserCss_Id == WUC.UserCss_Id); temp.UserCss_CssFileId = WUC.UserCss_CssFileId; temp.UserCss_Used = WUC.UserCss_Used; temp.UserCss_UserId = WUC.UserCss_UserId; BD.SubmitChanges(); }
public static int? GetModIDByFiid(int FiiD) { BlogDataDataContext BD = new BlogDataDataContext(); var temp= BD.View_CommonFunctions.Where(p => p.FI_ID == FiiD); if (temp.Count() > 0) return temp.First().FI_MODID; else return 0; }
public static int? GetFIID(int TxzID,int FuncID,int ModID) { BlogDataDataContext BD = new BlogDataDataContext(); var temp = BD.View_CommonFunctions.Select(p => p).Where(p => p.FI_FuncID == FuncID && p.FI_MODID == ModID && p.FI_OwnerID == TxzID); if (temp.Count() > 0) return temp.First().FI_ID; else return 0; }
{ /// <summary> /// 根据FIID 获取通行证ID /// </summary> /// <param name="FIID"></param> /// <returns></returns> public static int? GetTxzIDByFIID(int FIID) { BlogDataDataContext BD = new BlogDataDataContext(); var temp=BD.View_CommonFunctions.Where(p => p.FI_ID == FIID && p.FI_FuncID == 3); if (temp.Count() > 0) return temp.First().FI_OwnerID; else return 0; }
/// <summary> /// 根据Id获取 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Weblog_CssFile GetById(int Id) { BlogDataDataContext BD = new BlogDataDataContext(); var temp= BD.Weblog_CssFiles.Where(p => p.CssFile_Id == Id); if (temp.Count() == 0) return new Weblog_CssFile(); else return temp.First(); }
/// <summary> /// 根据用户UID来获取评论总数 /// </summary> /// <param name="FIID"></param> /// <returns></returns> public static int GetCommentCountByUID(int? UID) { BlogDataDataContext BD = new BlogDataDataContext(); int tempCount = 0; foreach (Weblog_Log WL in BWeblog_log.GetByBlogUID(Convert.ToInt32(UID))) { tempCount += BD.View_WeblogUserComments.Where(p => p.Comment_LogId == WL.Log_Id).Count(); } return tempCount; }
/// <summary> /// 根据ID获取日志 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static Weblog_Log GetByID(int ID) { BlogDataDataContext BD = new BlogDataDataContext(); //AddViewCount(ID); Weblog_Log temp = null; var ret = BD.Weblog_Logs.Select(p => p).Where(p => p.Log_Id == ID && p.Log_IsVisible == true && p.Log_IsDraft == false && p.Log_CreateTime <= DateTime.Now); if (ret.Count() > 0) temp = ret.First(); return temp; }