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