C# BlogDataDataContext.SubmitChanges方法代碼示例

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

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

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

 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>
 /// 刪除主題
 /// </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();
 }

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

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

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

        }

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

 /// <summary>
 /// 根據ID來刪除RssLink
 /// </summary>
 /// <param name="ID"></param>
 /// <returns></returns>
 public static bool DeleteRssLinkByID(int UID,int ID)
 {
     BlogDataDataContext BD = new BlogDataDataContext();
     Weblog_UserRssLink temp = null;
     var WURL = BD.Weblog_UserRssLinks.Where(p => p.Weblog_UserRssLinkId == ID&&p.Weblog_UserId==UID);
     if (WURL.Count()>0)
     {
         temp = WURL.First();
         BD.Weblog_UserRssLinks.DeleteOnSubmit(temp);
         BD.SubmitChanges();
         return true;
     }
     return false;
 }

        /// <summary>
        /// 插入新的文章種類
        /// </summary>
        /// <param name="WC"></param>
        /// <returns></returns>
        public static bool Insert(Weblog_Category WC)
        {
            BlogDataDataContext BD = new BlogDataDataContext();

            try
            {
                BD.Weblog_Categorys.InsertOnSubmit(WC);
                BD.SubmitChanges();
            }
            catch (Exception)
            {
                return false;
            }
            return true;
        }

 /// <summary>
 /// 修改數據
 /// </summary>
 /// <param name="WG"></param>
 public static void Update(Weblog_Group WG)
 {
     BlogDataDataContext BD = new BlogDataDataContext();
     var temp = BD.Weblog_Groups.Single(p=>p.Group_Id==WG.Group_Id);
     temp.Group_AdministratorsCount = WG.Group_AdministratorsCount;
     temp.Group_ClassId = WG.Group_ClassId;
     temp.Group_Competence = WG.Group_Competence;
     temp.Group_CreateTime = WG.Group_CreateTime;
     temp.Group_FounderId = WG.Group_FounderId;
     temp.Group_ImageUrl = WG.Group_ImageUrl;
     temp.Group_Introduce = WG.Group_Introduce;
     temp.Group_IsCertificateWhileJoin = WG.Group_IsCertificateWhileJoin;
     temp.Group_IsViewByStrangers = WG.Group_IsViewByStrangers;
     temp.Group_Keywords = WG.Group_Keywords;
     temp.Group_MembersCount = WG.Group_MembersCount;
     temp.Group_Name = WG.Group_Name;
     temp.Group_Notice = WG.Group_Notice;
     temp.Group_TopicCount = WG.Group_TopicCount;
     temp.Group_Url = WG.Group_Url;
     BD.SubmitChanges();
 }

 /// <summary>
 /// 更新RSS鏡像是否審核通過
 /// </summary>
 /// <param name="ID">RssLinkID</param>
 /// <returns></returns>
 public static bool UpdateRssLinkByID(int ID)
 {
     BlogDataDataContext BD = new BlogDataDataContext();
     Weblog_UserRssLink temp = null;
     var WURL = BD.Weblog_UserRssLinks.Where(p => p.Weblog_UserRssLinkId == ID);
     if (WURL.Count()>0)
     {
         temp = WURL.First();
         if (temp.Weblog_UserRssIsPassed==true)
         {
             temp.Weblog_UserRssIsPassed = false;
         }
         else
         {
             temp.Weblog_UserRssIsPassed = true;
         }
         BD.SubmitChanges();
         return true;
     }
     return false;
 }

 public static void Update(Weblog_Log WL)
 {
     BlogDataDataContext BD = new BlogDataDataContext();
     Weblog_Log temp = BD.Weblog_Logs.Single(p => p.Log_Id == WL.Log_Id);
     temp.Log_CateId = WL.Log_CateId;
     temp.Log_Title = WL.Log_Title;
     temp.Log_Content = WL.Log_Content;
     temp.Log_IsDraft = WL.Log_IsDraft;
     temp.Log_LastModiTime = WL.Log_LastModiTime;
     temp.Log_IsTop = WL.Log_IsTop;
     temp.Log_IsPasssword = WL.Log_IsPasssword;
     temp.Log_IsEnRePly = WL.Log_IsEnRePly;
     temp.Log_IsIndexShow = WL.Log_IsIndexShow;
     temp.Log_PassWord = WL.Log_PassWord;
     temp.Log_KeyWords = WL.Log_KeyWords;
     temp.Log_CreateTime = WL.Log_CreateTime;
     BD.SubmitChanges();
 }