public int Add(M_Column c) { B_Log.Add(LogType.Add, "添加栏目:" + c.ColName); int num = this.ic.Add(c); this.ClearCache(); return num; }
public void BindTable(int colid) { ColumnM = ColumnBll.GetColumn(colid); ChannelM = ChannelBll.GetChannel(ColumnM.ChId); DataTable dt = new DataTable(); switch (ChannelM.ModelType) { case 1: dt = SysModelField.CollArticleDt(); break; case 2: dt = SysModelField.CollImageDt(); break; case 3: dt = SysModelField.CollDownLoadDt(); break; default: dt = BModelField.GetList(ChannelM.ModelType); DataRow dr = dt.NewRow(); dr["Alias"] = "标题"; dr["Name"] = "Title"; dt.Rows.InsertAt(dr, 0); DataRow dr2 = dt.NewRow(); dr2["Alias"] = "录入者"; dr2["Name"] = "UName"; dt.Rows.InsertAt(dr2,1); DataRow dr3 = dt.NewRow(); dr3["Alias"] = "责任编辑"; dr3["Name"] = "AdminUName"; dt.Rows.InsertAt(dr3,2); DataRow dr4 = dt.NewRow(); dr4["Alias"] = "添加日期"; dr4["Name"] = "AddTime"; dt.Rows.InsertAt(dr4,3); break; } lbFildList.DataSource = dt; lbFildList.DataTextField = "Alias"; lbFildList.DataValueField = "Name"; lbFildList.DataBind(); }
public int Update(M_Column model) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ColId", SqlDbType.Int, 4), new SqlParameter("@ChId", SqlDbType.Int, 4), new SqlParameter("@ColName", SqlDbType.NVarChar), new SqlParameter("@ColDirName", SqlDbType.NVarChar), new SqlParameter("@ColParentId", SqlDbType.Int, 4), new SqlParameter("@IsOuterColumn", SqlDbType.Bit, 1), new SqlParameter("@OuterColumnUrl", SqlDbType.VarChar, 255), new SqlParameter("@ColumnImgPath", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@Keyword", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.NVarChar), new SqlParameter("@IsAllowAddInfo", SqlDbType.Bit, 1), new SqlParameter("@ColumnTemplatePath", SqlDbType.NVarChar), new SqlParameter("@InfoTemplatePath", SqlDbType.NVarChar), new SqlParameter("@CommentTemplatePath", SqlDbType.NVarChar), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@IsAllowComment", SqlDbType.Bit, 1), new SqlParameter("@IsCheckComment", SqlDbType.Bit, 1), new SqlParameter("@InfoTableName", SqlDbType.NVarChar), new SqlParameter("@ScoreReward", SqlDbType.Int, 4), new SqlParameter("@PointCount", SqlDbType.Int, 4), new SqlParameter("@ChargeType", SqlDbType.Int, 4), new SqlParameter("@ChargeHourCount", SqlDbType.Int, 4), new SqlParameter("@ChargeViewCount", SqlDbType.Int, 4), new SqlParameter("@IsOpened", SqlDbType.Bit, 1), new SqlParameter("@GroupIdStr", SqlDbType.VarChar, 500), new SqlParameter("@ColumnPageType", SqlDbType.Int, 4), new SqlParameter("@InfoPageType", SqlDbType.Int, 4) }; commandParameters[0].Value = model.ColId; commandParameters[1].Value = model.ChId; commandParameters[2].Value = model.ColName; commandParameters[3].Value = model.ColDirName; commandParameters[4].Value = model.ColParentId; commandParameters[5].Value = model.IsOuterColumn; commandParameters[6].Value = model.OuterColumnUrl; commandParameters[7].Value = model.ColumnImgPath; commandParameters[8].Value = model.Description; commandParameters[9].Value = model.Keyword; commandParameters[10].Value = model.Content; commandParameters[11].Value = model.IsAllowAddInfo; commandParameters[12].Value = model.ColumnTemplatePath; commandParameters[13].Value = model.InfoTemplatePath; commandParameters[14].Value = model.CommentTemplatePath; commandParameters[15].Value = model.Sort; commandParameters[16].Value = model.IsAllowComment; commandParameters[17].Value = model.IsCheckComment; commandParameters[18].Value = model.InfoTableName; commandParameters[19].Value = model.ScoreReward; commandParameters[20].Value = model.PointCount; commandParameters[21].Value = model.ChargeType; commandParameters[22].Value = model.ChargeHourCount; commandParameters[23].Value = model.ChargeViewCount; commandParameters[24].Value = model.IsOpened; commandParameters[25].Value = model.GroupIdStr; commandParameters[26].Value = model.ColumnPageType; commandParameters[27].Value = model.InfoPageType; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Column_Update", commandParameters); return model.ColId; }
public string GetPageIdContent(string nextAddress, M_Collection collectionM, string contentRegex, string address, string contentStr, string imagePath) { string str; int num2; this.ColumnM = this.ColumnBll.GetColumn(collectionM.ColId); this.ChannelM = this.ChannelBll.GetChannel(this.ColumnM.ChId); if (collectionM.CharSet == "0") { str = "gb2312"; } else { str = "utf-8"; } string input = string.Empty; input = this.GetHtmlCode(address, str); int startIndex = address.LastIndexOf('.'); string pattern = address.Insert(startIndex, "((?:.|\n)*?)"); MatchCollection matchs = Regex.Matches(input, pattern, RegexOptions.IgnoreCase); string str5 = string.Empty; foreach (Match match in matchs) { str5 = str5 + match.Value + ","; } string[] strArray = null; if (str5 != "") { strArray = str5.Substring(0, str5.Length - 1).Split(new char[] { ',' }); } string str6 = string.Empty; if ((strArray == null) && (strArray.Length == 0)) { return string.Empty; } string[] strArray2 = new string[strArray.Length]; if (strArray.Length > 0) { for (num2 = 0; num2 < strArray.Length; num2++) { int num3 = 0; for (int i = 0; i < strArray.Length; i++) { if (strArray[num2] == strArray2[i]) { num3++; } } if (num3 == 0) { strArray2[num2] = strArray[num2]; } } } num2 = 0; while (num2 < strArray2.Length) { if (strArray2[num2] != "") { str6 = str6 + strArray2[num2] + ","; } num2++; } if (str6 != "") { strArray = str6.Substring(0, str6.Length - 1).Split(new char[] { ',' }); for (num2 = 1; num2 < (strArray.Length - 1); num2++) { if (strArray[num2] != "") { input = this.GetHtmlCode(strArray[num2], str); contentStr = contentStr + "{Ky:PAGE}" + this.GetContent(collectionM, this.GetRegValue(contentRegex, input)); } } } return contentStr; }
public bool AddCollectionData(string contentAddress, M_Collection collectionM) { bool flag = true; string fieldName = string.Empty; string fieldValue = string.Empty; string tableName = string.Empty; string content = this.GetContent(contentAddress, collectionM); this.ColumnM = this.ColumnBll.GetColumn(collectionM.ColId); this.ChannelM = this.ChannelBll.GetChannel(this.ColumnM.ChId); this.ModelM = this.InfoModelBll.GetModel(this.ChannelM.ModelType); tableName = this.ModelM.TableName.Replace("\"", ""); fieldName = content.Split(new char[] { '┃' })[0].ToString(); fieldValue = content.Split(new char[] { '┃' })[1].ToString(); fieldName = fieldName.Substring(0, fieldName.Length - 1); string str5 = ",colid,uid,usertype,adminuid,updatetime,IsRecommend,IsFocus,IsSideShow,IsTop,isAllowComment,IsCreated,HitCount,TemplatePath,SpecialIdStr,Status"; string str6 = ",expiretime,IsIrregular,IsHeader,StarLevel"; if (this.ModelM.ModelId == 1) { fieldName = fieldName + str5 + str6; } else { fieldName = fieldName + str5; } fieldValue = fieldValue.Substring(0, fieldValue.Length - 1); fieldValue = ((string.Concat(new object[] { fieldValue, "$", collectionM.ColId, "$" }) + "0$") + "1$" + "0$") + DateTime.Now.ToString() + "$"; string str7 = "0$"; string str8 = "0$"; string str9 = "0$"; string str10 = "0$"; string str11 = "0$"; string str12 = "0$"; string str13 = "0$"; string str14 = "0$"; string proterySet = collectionM.ProterySet; if (proterySet != "") { string[] strArray = proterySet.Split(new char[] { ',' }); for (int i = 0; i < (strArray.Length - 1); i++) { switch (int.Parse(strArray[i].ToString())) { case 0: str7 = "1$"; break; case 1: str8 = "1$"; break; case 2: str9 = "1$"; break; case 3: str10 = "1$"; break; case 4: str11 = "1$"; break; case 5: str12 = "1$"; break; case 6: str13 = "1$"; break; case 7: str14 = "1$"; break; } } } fieldValue = ((((fieldValue + str7 + str8 + str10 + str11 + str13 + str14) + collectionM.HiteCount + "$") + this.ColumnM.InfoTemplatePath + "$") + collectionM.SpecialId + "$") + "3"; if (this.ModelM.ModelId == 1) { fieldValue = (string.Concat(new object[] { fieldValue, "$", DateTime.Now.AddDays(500000.0), "$" }) + str12) + str9 + collectionM.StarLevel; } try { this.CollectionData(tableName, fieldName, fieldValue); } catch { flag = false; } return flag; }
public string GetContent(string contentAddress, M_Collection collectionM) { string contentStr = string.Empty; string htmlCode = string.Empty; string input = string.Empty; string str5 = string.Empty; string regStr = string.Empty; string charSet = collectionM.CharSet; string imagePath = string.Empty; if (charSet == "0") { charSet = "gb2312"; } else { charSet = "utf-8"; } string webSite = collectionM.WebSite; string fieldListSet = collectionM.FieldListSet; string contentPageSet = collectionM.ContentPageSet; string[] strArray = fieldListSet.Split(new char[] { '|' }); string[] strArray2 = new string[strArray.Length - 1]; this.ColumnM = this.ColumnBll.GetColumn(collectionM.ColId); this.ChannelM = this.ChannelBll.GetChannel(this.ColumnM.ChId); int num = 0; if (contentPageSet != "") { num = int.Parse(contentPageSet.Split(new char[] { '|' })[0].ToString().Split(new char[] { '┃' })[1].ToString()); } string str13 = string.Empty; string nextAddress = string.Empty; htmlCode = this.GetHtmlCode(contentAddress, charSet); for (int i = 0; i < strArray2.Length; i++) { regStr = this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()) + "((?:.|\n)*?)" + this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()); if (strArray[i].Split(new char[] { ',' })[0].ToString().ToLower() == "content") { contentStr = this.GetRegValue(regStr, htmlCode); contentStr = this.GetContent(collectionM, contentStr); switch (num) { case 1: str13 = this.TransferStr(contentPageSet.Split(new char[] { '|' })[1].Split(new char[] { '┃' })[1].ToString()) + "((?:.|\n)*?)" + this.TransferStr(contentPageSet.Split(new char[] { '|' })[2].Split(new char[] { '┃' })[1].ToString()); nextAddress = this.IsFullAddress(collectionM.WebSite, collectionM.ListPageUrl, this.GetHref(this.GetRegValue(str13, htmlCode))); if ((nextAddress != "") && (collectionM.WebSite != nextAddress)) { string[] strArray3 = nextAddress.Substring(0, nextAddress.Length - 1).Split(new char[] { ',' }); nextAddress = strArray3[strArray3.Length - 1]; contentStr = contentStr + this.GetPageCodeContent(nextAddress, str13, collectionM, regStr, contentStr); } break; case 2: nextAddress = contentPageSet.Split(new char[] { '|' })[1].Split(new char[] { '┃' })[1].ToString(); contentStr = contentStr + this.GetPageIdContent(nextAddress, collectionM, regStr, contentAddress, contentStr, imagePath); break; case 3: nextAddress = contentPageSet.Split(new char[] { '|' })[1].Split(new char[] { '┃' })[1].ToString(); contentStr = contentStr + this.GetListAddressContent(nextAddress, collectionM, regStr, contentStr); break; } if (contentStr == "") { contentStr = strArray[i].Split(new char[] { ',' })[3].ToString(); } contentStr = Regex.Replace(Regex.Replace(contentStr, this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()), "", RegexOptions.IgnoreCase), this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()), "", RegexOptions.IgnoreCase); } else if (strArray[i].Split(new char[] { ',' })[0].ToString().ToLower() == "addtime") { if ((((this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()) != "") && (this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()).Length != 0)) && (this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()) != "")) && (this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()).Length != 0)) { contentStr = this.RemoveHtml(this.GetRegValue(regStr, htmlCode).Replace(this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()), "").Replace(this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()), "").Replace("\r\n", "").Replace(" ", "")).Trim(); } else { contentStr = strArray[i].Split(new char[] { ',' })[3].ToString().Trim(); } } else { if ((((this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()) != "") && (this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()).Length != 0)) && (this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()) != "")) && (this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()).Length != 0)) { contentStr = this.RemoveHtml(this.GetRegValue(regStr, htmlCode).Replace(this.TransferStr(strArray[i].Split(new char[] { ',' })[1].ToString()), "").Replace(this.TransferStr(strArray[i].Split(new char[] { ',' })[2].ToString()), "").Trim()); } else { contentStr = this.RemoveHtml(this.GetRegValue(regStr, htmlCode)).Trim(); } if (contentStr == "") { contentStr = strArray[i].Split(new char[] { ',' })[3].ToString(); } } input = input + strArray[i].Split(new char[] { ',' })[0].ToString().ToLower() + ","; str5 = str5 + contentStr + "$"; } if (!Regex.Match(input, "uname", RegexOptions.IgnoreCase).Success) { input = input + "uname,"; str5 = str5 + "admin$"; } if (!Regex.Match(input, "addtime", RegexOptions.IgnoreCase).Success) { input = input + "addtime,"; str5 = str5 + DateTime.Now.ToString() + "$"; } if ((imagePath != string.Empty) && (imagePath.Length != 0)) { input = input + "ImgPath,"; str5 = str5 + "|" + imagePath + "$"; } return (input + "┃" + str5); }
protected void btnAddCateSave_Click(object sender, EventArgs e) { bool checkForm = CheckValidate(); if (checkForm) { if (Id > 0) { ArticleModel = ArticleBll.GetArticle(Id); } ArticleModel.Id = Id; ArticleModel.ShortContent = SiteBll.GetFiltering(txtShortContent.Text.Trim()); ArticleModel.ColId = Int32.Parse(Request.Form["ddlColId"].ToString()); ArticleModel.Title = txtTitle.Text.Trim(); ArticleModel.LongTitle = txtTitle.Text.Trim(); ArticleModel.UserCateId = Convert.ToInt32(ddlUserCate.SelectedValue.Trim()); #region 关键字 string tagIdStr = string.Empty; string nameStr = txtTagNameStr.Text.Trim(); if (nameStr.Length != 0) { if (nameStr.StartsWith("|")) nameStr = nameStr.Substring(1, nameStr.Length - 1); if (nameStr.EndsWith("|")) nameStr = nameStr.Substring(0, nameStr.Length - 1); B_Tag tagBll = new B_Tag(); DataRow dr = tagBll.AddTagStr(nameStr, ChannelModel.ModelType, UserBll.GetCookie().UserID, UserBll.GetCookie().LogName); if (dr != null) { tagIdStr = "|" + dr[0] + "|"; nameStr = "|" + dr[1] + "|"; } else { tagIdStr = ""; nameStr = ""; } } ArticleModel.TagIdStr = tagIdStr; ArticleModel.TagNameStr = nameStr; #endregion //保存状态Status if (((Button)sender).ID == "btnSaveCaoGao") { ArticleModel.Status = -1; } else if (((Button)sender).ID == "btnAddCateSave") { if (ChannelModel != null) { if (ChannelModel.VerifyType == 0) { ArticleModel.Status = 3; } } else { ArticleModel.Status = 0; } } ArticleModel.Author = txtAuthor.Text.Trim(); ArticleModel.Source = txtSource.Text.Trim(); ArticleModel.ShortContent = SiteBll.GetFiltering(txtShortContent.Text.Trim()); //录入者ID ,通过传值得到 ArticleModel.UId = UserModel.UserID; //录入者用户名,通过传值得到 ArticleModel.UName = UserModel.LogName; ArticleModel.UserType = 0; ArticleModel.TitleType = 1; ArticleModel.Content = SiteBll.GetFiltering(txtContent.Value); ArticleModel.Content = ArticleModel.Content.Replace(@"<div style=""page-break-after: always""><span style=""display: none""> </span></div>", "{Ky:PAGE}"); ArticleModel.PointCount = Convert.ToInt32(txtPoint.Text.Trim()); ArticleModel.AddTime = DateTime.Now; ArticleModel.UpdateTime = DateTime.Now; ArticleModel.ExpireTime = Convert.ToDateTime("9999-01-01"); ArticleModel.ViewEndTime = DateTime.Now.AddDays(10).ToString(); ArticleModel.IsOpened = Convert.ToInt32(hfIsOpened.Value); #region 继承栏目相关设置 if (Id <= 0) { if (!string.IsNullOrEmpty(Request.Form["ddlColId"]) && Request.Form["ddlColId"] != "-1") { ColumnModel = ColumnBll.GetColumn(int.Parse(Request.Form["ddlColId"].ToString())); ArticleModel.TemplatePath = ColumnModel.InfoTemplatePath; ArticleModel.PageType = ColumnModel.InfoPageType; ArticleModel.ChargeType = ColumnModel.ChargeType; ArticleModel.ChargeHourCount = ColumnModel.ChargeHourCount; ArticleModel.ChargeViewCount = ColumnModel.ChargeViewCount; ArticleModel.IsAllowComment = ColumnModel.IsAllowComment; } // ArticleModel.HitCount = 0; } #endregion //保存 if (Id > 0) ArticleBll.Update(ArticleModel); else { ArticleBll.Add(ArticleModel); #region 增加积分 //如果频道不需要审核,添加积分 if (ChannelModel.VerifyType == 0) { if (UserModel == null) return; if (UserGroupBll == null) return; string scale = UserGroupBll.Power_UserGroup("Contribute", 0, UserGroupModel.GroupPower); int score = int.Parse(scale) * ColumnModel.ScoreReward; B_Money moneyBll = new B_Money(); moneyBll.Integral(score, UserModel.UserID); } #endregion } Response.Redirect("InfoList.aspx?ChId=" + ChId + "&ColId=" + ArticleModel.ColId); } }
protected void Page_Load(object sender, EventArgs e) { litMsg.Text = ""; UserBll.CheckIsLogin(); UserModel = UserBll.GetUser(UserBll.GetCookie().LogName); UserGroupModel = UserGroupBll.GetModel(UserModel.GroupID); SiteModel = SiteBll.GetSiteModel(); if (SiteModel == null) Function.ShowMsg(0, "<li>全站参数获取错误</li><li><a href='javascript:history.back()'>返回上一级</a></li>"); if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { try { Id = Convert.ToInt32(Request.QueryString["Id"]); } catch { } } if (!string.IsNullOrEmpty(Request.QueryString["ChId"])) { ChId = int.Parse(Request.QueryString["ChId"]); } ChannelModel = ChId <= 0 ? null : ChannelBll.GetChannel(ChId); if (ChannelModel == null || ChId < 0) Function.ShowMsg(0, "<li>频道参数错误</li><li><a href='javascript:history.back()'>返回上一级</a></li>"); if (!UserGroupBll.Power_ColumnPower(ChId, 0, UserGroupModel.ColumnPower, 3)) Function.ShowMsg(0, "<li>本频道没有添加" + ChannelModel.TypeName + "的权限</li><li><a href='javascript:history.back()'>返回上一级</a></li>"); if (!ColumnBll.ChkHasColumnByChId(ChId)) Function.ShowMsg(0, "<li>本频道下没有栏目,不能添加" + ChannelModel.TypeName + "</li><li><a href='javascript:history.back()'>返回上一级</a></li>"); if (!string.IsNullOrEmpty(Request.QueryString["ColId"])) ColId = Convert.ToInt32(Request.QueryString["ColId"]); ColumnModel = ColId <= 0 ? null : ColumnBll.GetColumn(ColId); if (ColId > 0 && ColumnModel == null) Function.ShowMsg(0, "<li>所选栏目不存在或已经被删除</li><li><a href='javascript:history.back()'>返回上一级</a></li>"); B_InfoModel infoModelBll = new B_InfoModel(); M_InfoModel infoModel = infoModelBll.GetModel(ChannelModel.ModelType); FilePicPath.Text = infoModel.UploadPath + "|" + infoModel.UploadSize.ToString(); if (!IsPostBack) { UserCateBound(); ddlBind(); if (Id > 0) ShowInfo(Id); } }
protected void Page_Load(object sender, EventArgs e) { AdminBll.CheckMulitLogin(); AdminModel = AdminBll.GetLoginModel(); AdminUserModel = AdminBll.GetModel(AdminModel.UserId); litMsg.Text = ""; SiteModel = SiteBll.GetSiteModel(); InfoSiteModel = SiteBll.GetInfoModel(); if (SiteModel == null) { Function.ShowSysMsg(0, "<li>全站参数获取错误</li>"); } txtTemplatePath.Attributes.Add("readonly", ""); txtUpdateDateTime.Attributes.Add("readonly", ""); txtHeaderColor.Attributes.Add("readonly", ""); txtViewer.Attributes.Add("readonly", ""); HistoryTime = InfoSiteModel.HistoryTime; if (!string.IsNullOrEmpty(Request.QueryString["ChId"])) { try { ChannelId = int.Parse(Request.QueryString["ChId"]); } catch { } } if (!ColumnBll.ChkHasColumnByChId(ChannelId)) { Function.ShowSysMsg(0, "<li>本频道下没有栏目,不能添加信息</li><li>建议您先添加栏目</li><li><a href='info/SetColumn.aspx?ChId=" + ChannelId + "'>添加栏目</a> <a href='info/ColumnList.aspx?ChId=" + ChannelId + "'>栏目管理</a></li>"); } ChannelModel = ChannelId <= 0 ? null : ChannelBll.GetChannel(ChannelId); if (ChannelModel == null || ChannelModel.ModelType != 1) { Function.ShowSysMsg(0, "<li>频道参数错误</li>"); } //保存路径 InfoModel = InfoModelBll.GetModel(ChannelModel.ModelType); FilePicPath.Text = InfoModel.UploadPath + "|" + InfoModel.UploadSize.ToString(); if (!string.IsNullOrEmpty(Request.QueryString["ColId"])) { try { ColumnId = int.Parse(Request.QueryString["ColId"]); } catch { } } ColumnModel = ColumnId <= 0 ? null : ColumnBll.GetColumn(ColumnId); if (ColumnId > 0 && ColumnModel == null) { Function.ShowSysMsg(0, "<li>所选栏目不存在或已经被删除</li>"); } if (Request.QueryString["Id"] != null && Request.QueryString["Id"] != "") { try { ArticleId = int.Parse(Request.QueryString["Id"]); } catch { } } if (ArticleId > 0 && !AdminGroupBll.Power_Channel(ChannelId, ColumnId, AdminUserModel.GroupId, 3)) { Function.ShowSysMsg(0, "<li>你没有该栏目下的修改权限</li>"); } if (!IsPostBack) { txtUpdateDateTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); if (HistoryTime == 0) { txtExpireTime.Text = "9999-01-01"; } else { txtExpireTime.Text = DateTime.Now.AddDays(HistoryTime).ToString("yyyy-MM-dd"); } for (int i = 0; i <= 20; i++) { ddlHeaderSize.Items.Add(new ListItem(i + "px", i + "px")); ddlHeaderSize.SelectedValue = "12px"; } if (ArticleId > 0) litNav.Text = "<a href='ColumnList.aspx?Chid=" + ChannelId + "'>" + ChannelModel.ChName + "</a> >> 修改" + ChannelModel.TypeName; else litNav.Text = "<a href='ColumnList.aspx?Chid=" + ChannelId + "'>" + ChannelModel.ChName + "</a> >> 添加" + ChannelModel.TypeName; BindSpeacil(); BindGroup(); if (ArticleId > 0) { ShowInfo(ArticleId); } } }
protected void gvInfoList_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "setIsTop") { string temp = e.CommandArgument.ToString(); string[] array = temp.Split('|'); int id = int.Parse(array[1]); if (array[0] == "False") InfoOperBll.SetProperty(InfoModel.TableName, "istop", "1", id); else InfoOperBll.SetProperty(InfoModel.TableName, "istop", "0", id); } if (e.CommandName == "setIsRecommend") { string temp = e.CommandArgument.ToString(); string[] array = temp.Split('|'); int id = int.Parse(array[1]); if (array[0] == "False") InfoOperBll.SetProperty(InfoModel.TableName, "isrecommend", "1", id); else InfoOperBll.SetProperty(InfoModel.TableName, "isrecommend", "0", id); } if (e.CommandName == "ExitInfo") { int id = int.Parse(e.CommandArgument.ToString()); InfoOperBll.Cancel(InfoModel.TableName, id); } if(e.CommandName=="Anomaly") { int id = int.Parse(e.CommandArgument.ToString().Split('┃')[0]); string title = e.CommandArgument.ToString().Split('┃')[1].ToString(); string colName = string.Empty; ColumnModel = ColumnBll.GetColumn(ColumnId); colName = ColumnModel.ColName; AnomalyModel.InfoId = id; AnomalyModel.ChId = ChId; AnomalyModel.ColName = colName; AnomalyModel.Title = title; if(AnomalyBll.CheckHas(ChId,id)) { bool result = AnomalyBll.Add(AnomalyModel); if(result) Response.Write("<script>alert('设置成功');</script>"); else Response.Write("<script>alert('设置失败');</script>"); } else Response.Write("<script>alert('此条记录已设置为不规则了');</script>"); } Bind(); }
protected void Page_Load(object sender, EventArgs e) { AdminGroupBll.Power_Judge(48); AjaxPro.Utility.RegisterTypeForAjax(typeof(system_collection_EditObject)); if (!IsPostBack) { if (!(Request.QueryString["Id"] == null || Request.QueryString["Id"].Length == 0)) { #region 边辑赋值 BindSuperior(); int id = int.Parse(Request.QueryString["Id"].ToString()); CollectionM = CollectionBll.GetIdByCollection(id); BindTable(CollectionM.ColId); txtObjectName.Text = CollectionM.ObjectName; txtWebSite.Text = CollectionM.WebSite; ColumnM = ColumnBll.GetColumn(CollectionM.ColId); txtColumnId.Text = ColumnM.ColName; hidColumnId.Value = CollectionM.ColId.ToString(); if (CollectionM.SpecialId != null && CollectionM.SpecialId.Length!=0) { string[] specialIdArr = CollectionM.SpecialId.Split('|'); string notNullSpIdStr = string.Empty; for (int i = 0; i < specialIdArr.Length;i++ ) { if (specialIdArr[i].Length != 0) notNullSpIdStr = notNullSpIdStr + specialIdArr[i]+"|"; } string[] SpecialArr = notNullSpIdStr.Split('|'); string SpecialName = string.Empty; for (int i = 0; i < SpecialArr.Length - 1; i++) { SpecialM = SpecialBll.GetSpecial(int.Parse(SpecialArr[i])); if (i == SpecialArr.Length - 2) SpecialName = SpecialName + SpecialM.SpecialCName; else SpecialName = SpecialName + SpecialM.SpecialCName + ","; } txtSpecialId.Text = SpecialName; hidSpecialId.Value = CollectionM.SpecialId.ToString(); } string charSet = CollectionM.CharSet; if (charSet == "0") rdoCharSet.Items[0].Selected = true; else if (charSet == "1") rdoCharSet.Items[1].Selected = true; txtListUrl.Text = CollectionM.ListPageUrl; txtObjectDemo.Text = CollectionM.ObjectDemo; txtListStart.Text = CollectionM.ListStartCode; txtListEnd.Text = CollectionM.ListEndCode; txtLinkStart.Text = CollectionM.LinkStartCode; txtLinkEnd.Text = CollectionM.LinkEndCode; //分页设置 string pageSet = CollectionM.PageSet; if (pageSet != "") { string[] pageArr = pageSet.Split('|'); int rdoId = int.Parse(pageArr[0].Split('┃')[1]); switch (rdoId) { case 0: rdoPage0.Checked = true; break; case 1: rdoPage1.Checked = true; txtNextPageStart.Text = pageArr[1].Split('┃')[1]; txtNextPageEnd.Text = pageArr[2].Split('┃')[1]; break; case 2: rdoPage2.Checked = true; txtUrlStr.Text = pageArr[1].Split('┃')[1]; txtStartId.Text = pageArr[2].Split('┃')[1]; txtEndId.Text = pageArr[3].Split('┃')[1]; break; case 3: rdoPage3.Checked = true; txtUrlList.Text = pageArr[1].Split('┃')[1]; break; } } //内容分页设置 string conPageSet = CollectionM.ContentPageSet; if (conPageSet != "") { string[] pageArr = conPageSet.Split('|'); int rdoId = int.Parse(pageArr[0].Split('┃')[1]); switch (rdoId) { case 0: rdoConPage1.Checked = true; break; case 1: rdoConPage2.Checked = true; txtConPageStart.Text = pageArr[1].Split('┃')[1]; txtConPageEnd.Text = pageArr[2].Split('┃')[1]; break; case 2: rdoConPage3.Checked = true; txtConAddress.Text = pageArr[1].Split('┃')[1]; txtConStartId.Text = pageArr[2].Split('┃')[1]; txtConEndId.Text = pageArr[3].Split('┃')[1]; break; case 3: rdoConPage4.Checked = true; txtConPageAddress.Text = pageArr[1].Split('┃')[1]; break; } } //字段设置 string fieldList = CollectionM.FieldListSet; if (fieldList != "") { string[] fieldArr = fieldList.Split('|'); for (int i = 0; i < fieldArr.Length - 1; i++) { for (int j = 0; j < lbFildList.Items.Count; j++) { if (lbFildList.Items[j].Value == fieldArr[i].ToString().Split(',')[0].ToString()) lbFildList.Items[j].Selected = true; } } hidFieldValue.Value = fieldList; } //简单过滤规则 string simpleFilterRule = CollectionM.SimpleFilterRule; if (simpleFilterRule != "") { string[] simFilRuleArr = simpleFilterRule.Split(','); for (int i = 0; i < simFilRuleArr.Length - 1; i++) { for (int j = 0; j < chkSimpleFilter.Items.Count; j++) { if (chkSimpleFilter.Items[j].Value == simFilRuleArr[i]) { chkSimpleFilter.Items[j].Selected = true; } } } } //复杂过滤规则 string complexityFilterRule = CollectionM.ComplexityFilterRule; string[] superiorArr = complexityFilterRule.Split(','); if (complexityFilterRule != "") { for (int j = 0; j < superiorArr.Length; j++) { for (int i = 0; i < lbFilterRule.Items.Count; i++) { if (lbFilterRule.Items[i].Value == superiorArr[j]) { lbFilterRule.Items[i].Selected = true; } } } } //属性设置 string protery = CollectionM.ProterySet; if (protery != "") { string[] proteryArr = protery.Split(','); for (int i = 0; i < proteryArr.Length - 1; i++) { for (int j = 0; j < chkPropetry.Items.Count; j++) { if (chkPropetry.Items[j].Value == proteryArr[i]) chkPropetry.Items[j].Selected = true; } } } //评分等级 for (int i = 0; i < ddlStarLevel.Items.Count; i++) { if (ddlStarLevel.Items[i].Value == CollectionM.StarLevel) ddlStarLevel.Items[i].Selected = true; } txtHitCout.Text = CollectionM.HiteCount.ToString(); #endregion } } }
public void UpdateTemplate(M_Column model) { this.ic.UpdateTemplate(model); }
public int Update(M_Column c) { B_Log.Add(LogType.Add, string.Concat(new object[] { "修改栏目 编号:", c.ColId, ",栏目名称:", c.ColName })); int num = this.ic.Update(c); this.ClearCache(); return num; }
public M_Column GetColumn(int columnId) { DataRow[] rowArray = this.GetAll().Select("ColId=" + columnId + " And IsDeleted=0"); if (rowArray.Length > 0) { M_Column column = new M_Column(); DataRow row = rowArray[0]; column.ColId = (int) row["ColId"]; column.ChId = (int) row["ChId"]; column.ColParentId = (int) row["ColParentId"]; column.ColName = row["ColName"].ToString(); column.ColDirName = row["ColDirName"].ToString(); column.IsOuterColumn = (bool) row["IsOuterColumn"]; column.OuterColumnUrl = row["OuterColumnUrl"].ToString(); column.ColumnTemplatePath = row["ColumnTemplatePath"].ToString(); column.InfoTemplatePath = row["InfoTemplatePath"].ToString();//内容模板 column.CommentTemplatePath = row["CommentTemplatePath"].ToString(); column.Description = row["Description"].ToString(); column.IsAllowAddInfo = (bool) row["IsAllowAddInfo"]; column.Sort = (int) row["Sort"]; column.IsAllowComment = (bool) row["IsAllowComment"]; column.IsCheckComment = (bool) row["IsCheckComment"]; column.Keyword = row["Keyword"].ToString(); column.Content = row["Content"].ToString(); column.IsOpened = (bool) row["IsOpened"]; column.GroupIdStr = row["GroupIdStr"].ToString(); column.ScoreReward = (int) row["ScoreReward"]; column.PointCount = (int) row["PointCount"]; column.ChargeType = (int) row["ChargeType"]; column.ChargeHourCount = (int) row["ChargeHourCount"]; column.ChargeViewCount = (int) row["ChargeViewCount"]; column.ColumnPageType = (int) row["ColumnPageType"]; column.InfoPageType = (int) row["InfoPageType"]; column.IsDeleted = (bool) row["IsDeleted"]; column.AddTime = (DateTime) row["AddTime"]; return column; } return null; }
private string GetContent(M_Collection collectionM, string contentStr) { this.ColumnM = this.ColumnBll.GetColumn(collectionM.ColId); this.ChannelM = this.ChannelBll.GetChannel(this.ColumnM.ChId); this.ModelM = this.InfoModelBll.GetModel(this.ChannelM.ModelType); this.SiteModel = this.SiteBll.GetSiteModel(); B_ConvertImage image = new B_ConvertImage(this.SiteModel.Domain, this.ModelM.UploadPath); string simpleFilterRule = collectionM.SimpleFilterRule; string pattern = string.Empty; string complexityFilterRule = collectionM.ComplexityFilterRule; if (complexityFilterRule != "") { string[] strArray = complexityFilterRule.Split(new char[] { ',' }); for (int i = 0; i < strArray.Length; i++) { this.SuperiorM = this.SuperiorBll.GetIdBySuperior(int.Parse(strArray[i].ToString())); pattern = this.TransferStr(this.SuperiorM.StartCode) + "((?:.|\n)*?)" + this.TransferStr(this.SuperiorM.EndCode); contentStr = this.SuperiorHtml(contentStr, pattern); } } if (simpleFilterRule != "") { string[] strArray2 = simpleFilterRule.Split(new char[] { ',' }); for (int j = 0; j < (strArray2.Length - 1); j++) { switch (int.Parse(strArray2[j].ToString())) { case 0: contentStr = this.FilterObject(contentStr); break; case 1: contentStr = this.FilterScript(contentStr); break; case 2: contentStr = this.FilterStyle(contentStr); break; case 3: contentStr = this.FilterDiv(contentStr); break; case 4: contentStr = this.FilterSpan(contentStr); break; case 5: contentStr = this.FilterTableProtery(contentStr); break; case 6: contentStr = this.FilterImg(contentStr); break; case 7: contentStr = this.FilterFont(contentStr); break; case 8: contentStr = this.FilterA(contentStr); break; case 9: contentStr = this.RemoveHtml(contentStr); break; } } } contentStr = image.ConvertLocalImagePath(contentStr); contentStr = image.ConvertContent(contentStr); return contentStr; }
protected void Page_Load(object sender, EventArgs e) { AdminBll.CheckMulitLogin(); M_LoginAdmin loginAdminModel = AdminBll.GetLoginModel(); AdminModel = AdminBll.GetModel(loginAdminModel.UserId); SiteModel = SiteBll.GetSiteModel(); #region 频道,模型,栏目参数检验 if (!string.IsNullOrEmpty(Request.QueryString["ChId"])) { try { ChId = int.Parse(Request.QueryString["ChId"]); } catch { } } ChannelModel = ChannelBll.GetChannel(ChId); if (ChannelModel == null) { Function.ShowSysMsg(0, "<li>所属频道不存在或已经被删除</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } InfoModel = InfoModelBll.GetModel(ChannelModel.ModelType); if (InfoModel == null) { Function.ShowSysMsg(0, "<li>所属模型不存在或已经被删除</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } if (!string.IsNullOrEmpty(Request.QueryString["ColId"])) { try { ColumnId = int.Parse(Request.QueryString["ColId"]); } catch { } } ColumnModel = ColumnBll.GetColumn(ColumnId); if (ColumnId != 0 && ColumnModel == null) { Function.ShowSysMsg(0, "<li>所属栏目不存在或已经被删除</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } #endregion SetNav(); AuditingLevel = PowerGroupBll.Power_Auditing(ChId, AdminModel.GroupId); SetBtnStatus(); #region 获取搜索字段 if (!string.IsNullOrEmpty(Request.QueryString["FieldName"])) { FieldName = Request.QueryString["FieldName"]; } if (!string.IsNullOrEmpty(Request.QueryString["Keyword"])) { Keyword = Request.QueryString["Keyword"].Trim(); if (!IsPostBack) { txtKeyword.Text = Keyword; } } #endregion #region 设置审核参数 if (!string.IsNullOrEmpty(Request.QueryString["Status"])) { string status = Request.QueryString["Status"].ToLower(); if (status == "no") { switch (AuditingLevel) { default: Status = "-99"; break; case "1": Status = "0"; break; case "2": Status = "0,1"; break; case "3": Status = "0,1,2"; break; } } else { Status = "3"; } } #endregion #region 设置投稿参数 if (!string.IsNullOrEmpty(Request.QueryString["UserType"])) { try { UserType = int.Parse(Request.QueryString["UserType"]); } catch { } } #endregion if (!IsPostBack) { InitProperty(); BindColumn(); BindChannel(); Bind(); ddlsortName.Items[0].Text = ChannelModel.TypeName + "标题"; if (gvInfoList.Rows.Count > 0) gvInfoList.HeaderRow.Cells[1].Text = ChannelModel.TypeName + "标题"; } }
protected void Button2_Click(object sender, EventArgs e) { CheckValidate(); int sColId = int.Parse(Request.Form["ddlColId"]); #region 系统字段获取值 string sTitle = txtTitle.Text; string sTitleColor = txtTitleColor.Text; string sTitleFontType = ddlTitleFontType.SelectedValue; int sTitleType = 1; if (rbImg.Checked == true) { sTitleType = 2; } string sTitleImgPath = txtTitleImgPath.Text; int sUId = UserModel.UserID; string sUName = UserModel.LogName; string sUserType = "0"; int sAdminUId = 0; string sAdminUName = ""; int sStatus = 0; if (((Button)sender).ID == "btnSaveCaoGao") { sStatus = -1; } else if (((Button)sender).ID == "Button2") { if (ChannelModel != null) { if (ChannelModel.VerifyType == 0) { sStatus = 3; } } } int sHitCount = int.Parse(txtHitCount.Text); DateTime sAddTime = DateTime.Now; DateTime sUpdateTime = DateTime.Now; string sTemplatePath = txtTemplatePath.Text; int sPageType = int.Parse(rdBtnPageType.SelectedValue); int sIsCreated = 0; //if (chkBoxIsCreate.Checked) //{ // sIsCreated = 1; //} int sUserCateId = int.Parse(ddlUserCate.SelectedValue); int sPointCount = int.Parse(txtPointCount.Text); string rdBtnChargeType = Request.Form["ChargeType"]; int sChargeType = 0; if (rdBtnChargeType == "rdBtnChargeType1") { sChargeType = 1; } else if (rdBtnChargeType == "rdBtnChargeType2") { sChargeType = 2; } else if (rdBtnChargeType == "rdBtnChargeType3") { sChargeType = 3; } else if (rdBtnChargeType == "rdBtnChargeType4") { sChargeType = 4; } else if (rdBtnChargeType == "rdBtnChargeType5") { sChargeType = 5; } else if (rdBtnChargeType == "rdBtnChargeType6") { sChargeType = 6; } //继承栏目相关设置 ColumnModel = ColumnBll.GetColumn(sColId); int sChargeHourCount = int.Parse(txtChargeHourCount.Text); int sChargeViewCount = int.Parse(txtChargeViewCount.Text); int sIsOpened = int.Parse(rdBtnIsOpened.SelectedValue); string sGroupIdStr = ""; if (sIsOpened == 0) { sGroupIdStr = "|"; foreach (ListItem li in chkBoxGroupIdStr.Items) { if (li.Selected) { sGroupIdStr += li.Value + "|"; } } } int sIsDeleted = 0; int sIsRecommend = 0; //if (chkBoxIsRecommend.Checked) //{ // sIsRecommend = 1; //} int sIsTop = 0; //if (chkBoxIsTop.Checked) //{ // sIsTop = 1; //} int sIsFocus = 0; //if (chkBoxIsFocus.Checked) //{ // sIsFocus = 1; //} int sIsSideShow = 0; //if (chkBoxIsSideShow.Checked) //{ // sIsSideShow = 1; //} #region 关键字 string sTagIdStr = string.Empty; string sTagNameStr = txtTagNameStr.Text.Trim(); if (sTagNameStr.Length != 0) { if (sTagNameStr.StartsWith("|")) sTagNameStr = sTagNameStr.Substring(1, sTagNameStr.Length - 1); if (sTagNameStr.EndsWith("|")) sTagNameStr = sTagNameStr.Substring(0, sTagNameStr.Length - 1); B_Tag tagBll = new B_Tag(); DataRow dr = tagBll.AddTagStr(sTagNameStr, ChannelModel.ModelType, 0, "后台管理员"); if (dr != null) { sTagIdStr = "|" + dr[0] + "|"; sTagNameStr = "|" + dr[1] + "|"; } else { sTagIdStr = ""; sTagNameStr = ""; } } #endregion int sIsAllowComment =0; if (ColumnModel.IsAllowComment) { sIsAllowComment = 1; } string idStr = ""; string sSpecialIdStr = ""; for (int i = 0; i < lBoxTopicIdStr.Items.Count; i++) { if (lBoxTopicIdStr.Items[i].Selected) { idStr += lBoxTopicIdStr.Items[i].Value + "|"; } } if (idStr != "") { sSpecialIdStr = "|" + idStr; } //if (sIsCreated) //{ //} #endregion //定义DataTable DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("FieldName", typeof(string))); dt.Columns.Add(new DataColumn("FieldValue", typeof(string))); #region DataRow dr0 = dt.NewRow(); dr0[0] = "ColId"; dr0[1] = sColId; dt.Rows.Add(dr0); DataRow dr1 = dt.NewRow(); dr1[0] = "Title"; dr1[1] = sTitle; dt.Rows.Add(dr1); DataRow dr2 = dt.NewRow(); dr2[0] = "TitleColor"; dr2[1] = sTitleColor; dt.Rows.Add(dr2); DataRow dr3 = dt.NewRow(); dr3[0] = "TitleFontType"; dr3[1] = sTitleFontType; dt.Rows.Add(dr3); DataRow dr4 = dt.NewRow(); dr4[0] = "TitleType"; dr4[1] = sTitleType; dt.Rows.Add(dr4); DataRow dr5 = dt.NewRow(); dr5[0] = "TitleImgPath"; dr5[1] = sTitleImgPath; dt.Rows.Add(dr5); DataRow dr6 = dt.NewRow(); dr6[0] = "UId"; dr6[1] = sUId; dt.Rows.Add(dr6); DataRow dr7 = dt.NewRow(); dr7[0] = "UName"; dr7[1] = sUName; dt.Rows.Add(dr7); DataRow dr8 = dt.NewRow(); dr8[0] = "UserType"; dr8[1] = sUserType; dt.Rows.Add(dr8); DataRow dr9 = dt.NewRow(); dr9[0] = "AdminUId"; dr9[1] = sAdminUId; dt.Rows.Add(dr9); DataRow dr10 = dt.NewRow(); dr10[0] = "AdminUName"; dr10[1] = sAdminUName; dt.Rows.Add(dr10); DataRow dr11 = dt.NewRow(); dr11[0] = "Status"; dr11[1] = sStatus; dt.Rows.Add(dr11); DataRow dr12 = dt.NewRow(); dr12[0] = "HitCount"; dr12[1] = sHitCount; dt.Rows.Add(dr12); DataRow dr13 = dt.NewRow(); dr13[0] = "AddTime"; dr13[1] = sAddTime; dt.Rows.Add(dr13); DataRow dr14 = dt.NewRow(); dr14[0] = "UpdateTime"; dr14[1] = sUpdateTime; dt.Rows.Add(dr14); DataRow dr15 = dt.NewRow(); dr15[0] = "TemplatePath"; dr15[1] = sTemplatePath; dt.Rows.Add(dr15); DataRow dr16 = dt.NewRow(); dr16[0] = "PageType"; dr16[1] = sPageType; dt.Rows.Add(dr16); DataRow dr17 = dt.NewRow(); dr17[0] = "IsCreated"; dr17[1] = sIsCreated; dt.Rows.Add(dr17); DataRow dr18 = dt.NewRow(); dr18[0] = "UserCateId"; dr18[1] = sUserCateId; dt.Rows.Add(dr18); DataRow dr19 = dt.NewRow(); dr19[0] = "PointCount"; dr19[1] = sPointCount; dt.Rows.Add(dr19); DataRow dr20 = dt.NewRow(); dr20[0] = "ChargeType"; dr20[1] = sChargeType; dt.Rows.Add(dr20); DataRow dr21 = dt.NewRow(); dr21[0] = "ChargeHourCount"; dr21[1] = sChargeHourCount; dt.Rows.Add(dr21); DataRow dr22 = dt.NewRow(); dr22[0] = "ChargeViewCount"; dr22[1] = sChargeViewCount; dt.Rows.Add(dr22); DataRow dr23 = dt.NewRow(); dr23[0] = "IsOpened"; dr23[1] = sIsOpened; dt.Rows.Add(dr23); DataRow dr24 = dt.NewRow(); dr24[0] = "GroupIdStr"; dr24[1] = sGroupIdStr; dt.Rows.Add(dr24); DataRow dr25 = dt.NewRow(); dr25[0] = "IsDeleted"; dr25[1] = sIsDeleted; dt.Rows.Add(dr25); DataRow dr26 = dt.NewRow(); dr26[0] = "IsRecommend"; dr26[1] = sIsRecommend; dt.Rows.Add(dr26); DataRow dr27 = dt.NewRow(); dr27[0] = "IsTop"; dr27[1] = sIsTop; dt.Rows.Add(dr27); DataRow dr28 = dt.NewRow(); dr28[0] = "IsFocus"; dr28[1] = sIsFocus; dt.Rows.Add(dr28); DataRow dr29 = dt.NewRow(); dr29[0] = "IsSideShow"; dr29[1] = sIsSideShow; dt.Rows.Add(dr29); DataRow dr30 = dt.NewRow(); dr30[0] = "TagIdStr"; dr30[1] = sTagIdStr; dt.Rows.Add(dr30); DataRow dr31 = dt.NewRow(); dr31[0] = "TagNameStr"; dr31[1] = sTagNameStr; dt.Rows.Add(dr31); DataRow dr32 = dt.NewRow(); dr32[0] = "IsAllowComment"; dr32[1] = sIsAllowComment; dt.Rows.Add(dr32); DataRow dr33 = dt.NewRow(); dr33[0] = "SpecialIdStr"; dr33[1] = sSpecialIdStr; dt.Rows.Add(dr33); #endregion //以下是自动添加字段获得值 DataTable dt1 = new DataTable(); dt1 = BModelField.GetList(ChannelModel.ModelType); for (int i = 0; i < dt1.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr[0] = dt1.Rows[i]["Name"].ToString(); //联动获取数据开始 //二级联动 if (dt1.Rows[i]["Type"].ToString() == "ErLinkageType") { dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString()]; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = dt1.Rows[i]["Name"].ToString() + "_Id"; dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + "_Id"]; dt.Rows.Add(dr); string SmallName = BModelField.GetFieldContent(dt1.Rows[i]["Content"].ToString(), 2, 1); dr = dt.NewRow(); dr[0] = SmallName; dr[1] = Request.Form["txt_" + SmallName]; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = SmallName + "_Id"; dr[1] = Request.Form["txt_" + SmallName + "_Id"]; dt.Rows.Add(dr); } else { switch (dt1.Rows[i]["Type"].ToString()) { case "ListBoxType": if (Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""] == "" || Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""] == null) { dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""]; } else { dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""].Replace(" ", "").ToString(); } dr[1] = "," + dr[1] + ","; break; case "MultipleTextType": dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""]; break; default: dr[1] = Request.Form["txt_" + dt1.Rows[i]["Name"].ToString() + ""]; break; } dt.Rows.Add(dr); } } //添加信息 BInfoModel.AddInfoModel(dt, MInfoModel.TableName); ColumnModel = ColumnBll.GetColumn(int.Parse(Request.Form["ddlColId"].ToString())); if (ChannelModel.VerifyType == 0) { if (UserModel == null) return; if (UserGroupBll == null) return; string scale = UserGroupBll.Power_UserGroup("Contribute", 0, UserGroupModel.GroupPower); int score = int.Parse(scale) * ColumnModel.ScoreReward; B_Money moneyBll = new B_Money(); moneyBll.Integral(score, UserModel.UserID); } Function.ShowMsg(1, "<li>成功添加信息</li><li><a href='info/InfoList.aspx?ChId=" + ChannelId + "&ColId=" + sColId + "'>返回信息列表</a> <a href='info/AddInfo.aspx?ChId=" + ChannelId + "'>继续添加</a></li>"); }
protected void btnOK_Click(object sender, EventArgs e) { M_Column model = new M_Column(); model.ChId = ChId; model.ColId = ColumnId; if (litColIdStr.Text.IndexOf("|" + ddlColumn.SelectedValue + "|") != -1) { Function.ShowSysMsg(0, "<li>所属栏目不能为当前栏目或子栏目</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ColParentId = int.Parse(ddlColumn.SelectedValue); if (txtColName.Text.Trim().Length == 0) { Function.ShowSysMsg(0, "<li>栏目中文名必须填写</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ColName = txtColName.Text.Trim(); string dirName = txtColDirName.Text.Trim(); if (!Regex.IsMatch(dirName, @"^[a-zA-Z][0-9a-zA-Z]*$")) { Function.ShowSysMsg(0, "<li>栏目英文名必须以字母开头,必须是字母和数字组成</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ColDirName = dirName; if (ColumnId == 0) { B_KyCommon kyCommonBll = new B_KyCommon(); bool flag = kyCommonBll.CheckHas(dirName, "ColDirName", "KyColumn"); if (flag) { Function.ShowSysMsg(0, "<li>栏目英文名已经存在</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } } if(model.IsOuterColumn&&txtOuterColumnUrl.Text.Trim().Length==0) { Function.ShowSysMsg(0, "<li>设置栏目为外部栏目,外部链接地址必须填写</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.IsOuterColumn = rbIsOuterColumn0.Checked ? false : true; model.OuterColumnUrl = model.IsOuterColumn ? txtOuterColumnUrl.Text.Trim() : ""; if (txtColumnTemplatePath.Text.Trim().Length == 0) { Function.ShowSysMsg(0, "<li>栏目页模板必须选择</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ColumnTemplatePath = txtColumnTemplatePath.Text.Trim(); if (txtInfoTemplatePath.Text.Trim().Length == 0) { Function.ShowSysMsg(0, "<li>内容页模板必须选择</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.InfoTemplatePath = txtInfoTemplatePath.Text.Trim(); if (txtCommentTemplatePath.Text.Trim().Length == 0) { Function.ShowSysMsg(0, "<li>评论页模板必须选择</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.CommentTemplatePath = txtCommentTemplatePath.Text.Trim(); if (txtDescription.Text.Trim().Length > 255) { Function.ShowSysMsg(0, "<li>栏目描述不能超过255个字</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ColumnImgPath = txtColumnImgPath.Text.Trim(); model.Description = txtDescription.Text.Trim(); model.IsAllowAddInfo = bool.Parse(rblIsAllowAddInfo.SelectedValue); if (!Function.CheckNumber(txtSort.Text.Trim())) { Function.ShowSysMsg(0, "<li>栏目排序编号必须是0或整正数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.Sort = int.Parse(txtSort.Text.Trim()); model.IsAllowComment = bool.Parse(rblIsAllowComment.SelectedValue); model.IsCheckComment = bool.Parse(rblIsCheckComment.SelectedValue); if (txtKeyword.Text.Trim().Length > 100) { Function.ShowSysMsg(0, "<li>栏目META关键词不能超过100个字</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.Keyword = txtKeyword.Text.Trim(); if (txtContent.Text.Trim().Length > 300) { Function.ShowSysMsg(0, "<li>栏目META网页描述不能超过300个字</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.Content = txtContent.Text.Trim(); model.IsOpened = bool.Parse(rblIsOpened.SelectedValue); model.GroupIdStr = string.Empty; if (!Function.CheckNumber(txtScoreReward.Text.Trim())) { Function.ShowSysMsg(0, "<li>积分奖励必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ScoreReward = int.Parse(txtScoreReward.Text.Trim()); if (!Function.CheckNumber(txtPointCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>收费点数必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.PointCount = int.Parse(txtPointCount.Text.Trim()); if(rbChargeType1.Checked) { model.ChargeType = 1; } else if (rbChargeType2.Checked) { model.ChargeType = 2; if (!Function.CheckNumber(txtChargeHourCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费时间必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeHourCount = int.Parse(txtChargeHourCount.Text.Trim()); } else if (rbChargeType3.Checked) { model.ChargeType = 3; if (!Function.CheckNumber(txtChargeViewCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费浏览次数必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeViewCount = int.Parse(txtChargeViewCount.Text.Trim()); } else if(rbChargeType4.Checked) { model.ChargeType = 4; if (!Function.CheckNumber(txtChargeHourCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费时间必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeHourCount = int.Parse(txtChargeHourCount.Text.Trim()); if (!Function.CheckNumber(txtChargeViewCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费浏览次数必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeViewCount = int.Parse(txtChargeViewCount.Text.Trim()); } else if (rbChargeType5.Checked) { model.ChargeType = 5; if (!Function.CheckNumber(txtChargeHourCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费时间必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeHourCount = int.Parse(txtChargeHourCount.Text.Trim()); if (!Function.CheckNumber(txtChargeViewCount.Text.Trim())) { Function.ShowSysMsg(0, "<li>重复收费浏览次数必须是0或正整数</li><li><a href='javascript:window.history.back(-1)'>返回上一步</a></li>"); } model.ChargeViewCount = int.Parse(txtChargeViewCount.Text.Trim()); } else { model.ChargeType = 6; } model.ColumnPageType = int.Parse(rblColumnPageType.SelectedValue); model.InfoPageType = int.Parse(rblInfoPageType.SelectedValue); model.IsDeleted = false; model.AddTime = DateTime.Now; model.InfoTableName = string.Empty; int currColId = 0; if (ColumnId > 0) { currColId = ColumnBll.Update(model); } else { currColId = ColumnBll.Add(model); } for (int i = 0; i < cblGroupIdStr1.Items.Count; i++) { int groupId = int.Parse(cblGroupIdStr1.Items[i].Value); M_UserGroup userGroupModel = GroupBll.GetModel(groupId); string power = userGroupModel.ColumnPower; int a = cblGroupIdStr1.Items[i].Selected ? 1 : 0; int b = cblGroupIdStr2.Items[i].Selected ? 1 : 0; int c = cblGroupIdStr3.Items[i].Selected ? 1 : 0; power = GroupBll.ColumnPower_ColumnPower(ChId, currColId, power, a, b, c); userGroupModel.ColumnPower = power; GroupBll.Update(userGroupModel); } Response.Write("<script>parent.document.frames['LeftIframe'].location.reload();location.href('ColumnList.aspx?ChId=" + ChId + "');</script>"); }
public DataTable GetOption(string str) { ColumnM = ColumnBll.GetColumn(int.Parse(str)); ChannelM = ChannelBll.GetChannel(ColumnM.ChId); DataTable dt = new DataTable(); switch (ChannelM.ModelType) { case 1: dt = SysModelField.CollArticleDt(); break; case 2: dt = SysModelField.CollImageDt(); break; case 3: dt = SysModelField.CollDownLoadDt(); break; default: dt = BModelField.GetList(ChannelM.ModelType); DataRow dr = dt.NewRow(); dr["Alias"] = "标题"; dr["Name"] = "Title"; dt.Rows.InsertAt(dr, 0); DataRow dr2 = dt.NewRow(); dr2["Alias"] = "录入者"; dr2["Name"] = "UName"; dt.Rows.InsertAt(dr2,1); DataRow dr3 = dt.NewRow(); dr3["Alias"] = "责任编辑"; dr3["Name"] = "AdminUName"; dt.Rows.InsertAt(dr3,2); DataRow dr4 = dt.NewRow(); dr4["Alias"] = "添加日期"; dr4["Name"] = "AddTime"; dt.Rows.InsertAt(dr4,3); break; } return dt; }
public void UpdateTemplate(M_Column model) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ColId", SqlDbType.Int, 4), new SqlParameter("@ColumnTemplatePath", SqlDbType.NVarChar), new SqlParameter("@InfoTemplatePath", SqlDbType.NVarChar), new SqlParameter("@CommentTemplatePath", SqlDbType.NVarChar) }; commandParameters[0].Value = model.ColId; commandParameters[1].Value = model.ColumnTemplatePath; commandParameters[2].Value = model.InfoTemplatePath; commandParameters[3].Value = model.CommentTemplatePath; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Column_Update_Template", commandParameters); }
protected void btnSoftSaveAs_Click(object sender, EventArgs e) { bool flag = CheckValidate(); if (flag) { #region //添加软件 DownLoadmodel.Id = Id; if(Id>0) { DownLoadmodel = DownLoadBll.GetDownLoadData(Id); } if (!string.IsNullOrEmpty(Request.Form["ddlColId"])) DownLoadmodel.ColId = int.Parse(Request.Form["ddlColId"]); DownLoadmodel.Title = txtSoftName.Text.Trim(); DownLoadmodel.UserCateId = int.Parse(ddlUserCate.SelectedValue); DownLoadmodel.TitleFontType = 0; DownLoadmodel.TitleType = 1; DownLoadmodel.Edition = txtSoftEdition.Text.Trim(); DownLoadmodel.PlayAddress = txtSoftPlayAddress.Text.Trim(); DownLoadmodel.UId = UserModel.UserID; DownLoadmodel.UName = UserModel.LogName; DownLoadmodel.UserType = 0; #region 关键字 string tagIdStr = string.Empty; string nameStr = txtTagName.Text.Trim(); if (nameStr.Length != 0) { if (nameStr.StartsWith("|")) nameStr = nameStr.Substring(1, nameStr.Length - 1); if (nameStr.EndsWith("|")) nameStr = nameStr.Substring(0, nameStr.Length - 1); B_Tag tagBll = new B_Tag(); DataRow dr = tagBll.AddTagStr(nameStr, ChannelModel.ModelType, 0, "后台管理员"); if (dr != null) { tagIdStr = "|" + dr[0] + "|"; nameStr = "|" + dr[1] + "|"; } else { tagIdStr = ""; nameStr = ""; } } DownLoadmodel.TagIdStr = tagIdStr; DownLoadmodel.TagNameStr = nameStr; #endregion DownLoadmodel.AddTime = DateTime.Now; DownLoadmodel.UpdateTime = DateTime.Now; if (txtSoftOS.Text.Trim().Length == 0) DownLoadmodel.DownLoadOS = ""; else DownLoadmodel.DownLoadOS = "|" + txtSoftOS.Text.Trim() + "|"; DownLoadmodel.Language = ddlSoftLanguage.SelectedValue; DownLoadmodel.WarrantType = ddlSoftWarrantType.SelectedValue; DownLoadmodel.RegAddress = txtSoftRegAddress.Text.Trim(); if (ChannelModel.VerifyType == 0) DownLoadmodel.Status = 3; else DownLoadmodel.Status = 0; DownLoadmodel.Content = txtSoftRemark.Text.Trim(); DownLoadmodel.PointCount = int.Parse(txtSoftPoint.Text.Trim()); DownLoadmodel.IsDeleted = false; DownLoadmodel.DownLoadDisplePwd = txtSoftDisplePwd.Text.Trim(); DownLoadmodel.DownLoadType = ddlSoftType.SelectedValue; DownLoadmodel.DownLoadSize = txtSoftSize.Text.Trim(); if (Id <= 0) DownLoadmodel.IsOpened = 2; #region 继承栏目相关设置 if (Id <= 0) { if (!string.IsNullOrEmpty(Request.Form["ddlColId"]) && Request.Form["ddlColId"] != "-1") { ColumnModel = ColumnBll.GetColumn(int.Parse(Request.Form["ddlColId"].ToString())); DownLoadmodel.TemplatePath = ColumnModel.InfoTemplatePath; DownLoadmodel.PageType = ColumnModel.InfoPageType; DownLoadmodel.ChargeType = ColumnModel.ChargeType; DownLoadmodel.ChargeHourCount = ColumnModel.ChargeHourCount; DownLoadmodel.ChargeViewCount = ColumnModel.ChargeViewCount; } } #endregion #endregion if (Id > 0) Id = DownLoadBll.Update(DownLoadmodel); else Id = DownLoadBll.Add(DownLoadmodel); AddressModel.AddressId = Convert.ToInt32(hfAddressId.Value); AddressModel.AddressName = "下载地址1"; AddressModel.AddressNum = 1; AddressModel.AddressPath = txtSoftAddressPath.Text.Trim(); AddressModel.DownLoadDataId = Id; AddressModel.DownLoadServerID = -1; if (AddressModel.AddressId > 0) { AddressBll.Update(AddressModel); } else { AddressBll.Add(AddressModel); #region 增加积分 //如果频道不需要审核,添加积分 if (ChannelModel.VerifyType == 0) { if (UserModel == null) return; if (UserGroupBll == null) return; string scale = UserGroupBll.Power_UserGroup("Contribute", 0, UserGroupModel.GroupPower); int score = int.Parse(scale) * ColumnModel.ScoreReward; B_Money moneyBll = new B_Money(); moneyBll.Integral(score, UserModel.UserID); } #endregion } Response.Redirect("InfoList.aspx?ChId=" + ChId + "&ColId=" + DownLoadmodel.ColId); } }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetNoStore(); Response.ContentType = "application/xml"; if (!string.IsNullOrEmpty(Request.QueryString["chid"])) { try { chId = int.Parse(Request.QueryString["chid"]); } catch { } } if (!string.IsNullOrEmpty(Request.QueryString["colid"])) { try { colId =Request.QueryString["colid"]; } catch { } } if (colId == "0"&&chId==0) { return; } if (!string.IsNullOrEmpty(Request.QueryString["includesub"])) { includeSub = true; } int currChId = chId; if (colId != "0") { ColumnModel = ColumnBll.GetColumn(int.Parse(colId)); if (ColumnModel == null) Function.ShowMsg(0, "<li>所属栏目不存在或已经被删除</li>"); currChId = ColumnModel.ChId; } ChannelModel = ChannelBll.GetChannel(currChId); if (ChannelModel == null) Function.ShowMsg(0, "<li>所属频道不存在或已经被删除</li>"); bool isDisabled = ChannelModel.IsDisabled; if (isDisabled) Function.ShowMsg(0, "<li>所属频道已经被管理员禁用</li>"); M_InfoModel infoModel = InfoModelBll.GetModel(ChannelModel.ModelType); if(infoModel==null) Function.ShowMsg(0, "<li>所属模型不存在或已经被删除</li>"); MemoryStream ms = new MemoryStream(); XmlTextWriter xmlTW = new XmlTextWriter(ms,Encoding.UTF8); xmlTW.Formatting = Formatting.Indented; xmlTW.WriteStartDocument(); xmlTW.WriteStartElement("rss"); xmlTW.WriteAttributeString("version", "2.0"); xmlTW.WriteStartElement("channel"); if (chId == 0) { xmlTW.WriteElementString("title", ColumnModel.ColName); xmlTW.WriteElementString("link", CreateBll.GetColumnUrl(int.Parse(colId), 1)); xmlTW.WriteElementString("description", ColumnModel.Description); } else { xmlTW.WriteElementString("title", ChannelModel.ChName); xmlTW.WriteElementString("link", CreateBll.GetChannelUrl(chId)); xmlTW.WriteElementString("description", ChannelModel.Description); } if (includeSub) { colId = ColumnBll.GetChildIdByColumnId(int.Parse(colId)); } DataTable dt = InfoOperBll.GetRssInfoList(infoModel.TableName, chId,colId); foreach (DataRow dr in dt.Rows) { xmlTW.WriteStartElement("item"); xmlTW.WriteElementString("title", dr["title"].ToString()); xmlTW.WriteElementString("link",CreateBll.GetInfoUrl(dr)); xmlTW.WriteElementString("description", ""); xmlTW.WriteElementString("pubdate", dr["addtime"].ToString()); xmlTW.WriteEndElement(); } xmlTW.WriteEndElement(); xmlTW.WriteEndElement(); xmlTW.WriteEndDocument(); xmlTW.Flush(); byte[] buffer = ms.ToArray(); Response.Write(Encoding.UTF8.GetString(buffer)); Response.End(); xmlTW.Close(); ms.Close(); ms.Dispose(); }