partial void Deletenormal_class(normal_class instance);
partial void Insertnormal_class(normal_class instance);
partial void Updatenormal_class(normal_class instance);
private void detach_normal_class(normal_class entity) { this.SendPropertyChanging(); entity.normal_channel = null; }
private void getClassSinglePageListBody(normal_class _class, ref System.Collections.ArrayList ContentList, int _pagecount, int _page) { string whereStr = string.Empty; string _pagestr = ContentList[0].ToString(); whereStr = " [ClassId] in (SELECT ID FROM [normal_class] WHERE [IsOut]=0 and id=" + _class.Id + ")"; whereStr += " AND [IsPass]=1 AND [ChannelId]=" + _class.ChannelId; int _pagesize = (_class.PageSize < 1) ? 5 : _class.PageSize; System.Collections.ArrayList TagArray = WeiXin.Core.Strings.GetHtmls(_pagestr, "{$zuxia:class(", "{$/zuxia:class}", false, false); if (TagArray.Count > 0)//标签存在 { string LoopBody = string.Empty; string TempStr = string.Empty; string FiledsStr = string.Empty; int StartTag, EndTag; StartTag = TagArray[0].ToString().IndexOf(")}", 0); FiledsStr = TagArray[0].ToString().Substring(0, StartTag).ToLower(); if (!("," + FiledsStr + ",").Contains(",adddate,")) FiledsStr += ",adddate"; EndTag = TagArray[0].ToString().Length; LoopBody = "{$zuxia:class(" + TagArray[0].ToString() + "{$/zuxia:class}"; TempStr = TagArray[0].ToString().Substring(StartTag + 2, EndTag - StartTag - 2).Replace("<#foreach content>", "<#foreach collection=\"${contents}\" var=\"field\" index=\"i\">");//需要循环的部分 ContentList.Add(LoopBody); if (_pagecount > 0) { if (_page == 0) { for (int i = 1; i < _pagecount + 1; i++) { NameValueCollection orders = new NameValueCollection(); orders.Add("AddDate", "desc"); orders.Add("Id", "desc"); string wStr = WeiXin.Core.SqlHelp.GetMultiOrderPagerSQL("Id,ChannelId,ClassId,[IsPass],[FirstPage]," + FiledsStr, "module_" + _class.normal_channel.Type, _pagesize, i, orders, whereStr); DataSet dtContent = ArticleBll.GetArticleBySql2(wStr); ContentList.Add(operateContentTag(_class.normal_channel.Type, dtContent, TempStr)); dtContent.Clear(); dtContent.Dispose(); } } else { _page = _page == 0 ? 1 : _page; NameValueCollection orders = new NameValueCollection(); orders.Add("AddDate", "desc"); orders.Add("Id", "desc"); string wStr = WeiXin.Core.SqlHelp.GetMultiOrderPagerSQL("Id,ChannelId,ClassId,[IsPass],[FirstPage]," + FiledsStr, "module_" + _class.normal_channel.Type, _pagesize, _page, orders, whereStr); DataSet dtContent = ArticleBll.GetArticleBySql2(wStr); ContentList.Add(operateContentTag(_class.normal_channel.Type, dtContent, TempStr)); dtContent.Clear(); dtContent.Dispose(); } } else ContentList.Add(" "); } }
private System.Collections.ArrayList getClassSinglePage(normal_class _class, int _pagecount, int _page, int eid) { string pId = string.Empty; string _pagestr = string.Empty; //得到模板方案组ID/模板内容 _pagestr = GetClassListContent(eid, _class.normal_channel.Type, "class", _class.ChannelId); ReplacePublicTag(ref _pagestr); // ReplaceChannelClassLoopTag(ref _pagestr); // ReplaceClassTag(ref _pagestr, _class.Id); // ReplaceContentLoopTag(ref _pagestr); System.Collections.ArrayList ContentList = new System.Collections.ArrayList(); ContentList.Add(_pagestr); getClassSinglePageListBody(_class, ref ContentList, _pagecount, _page); return ContentList; }
/// <summary> /// 修改栏目 /// </summary> /// <param name="c"></param> /// <returns></returns> public int UpdateClass(normal_class c) { string sql = string.Format(@"update normal_class set title='{0}',pagesize={1}, templateid={3}, contenttemp={4} where id={2}", c.Title, c.PageSize, c.Id,c.TemplateId,c.ContentTemp); return SqlHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql); }
/// <summary> /// 添加栏目 /// </summary> /// <param name="c"></param> /// <returns></returns> public int InsertClass(normal_class c) { db.normal_class.InsertOnSubmit(c); db.SubmitChanges(); return c.Id; }