/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_ArticleMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMS_Article("); strSql.Append("ArticleSysNo,CateSysNo,Source,DR,TS,OrderID,Author)"); strSql.Append(" values ("); strSql.Append("@ArticleSysNo,@CateSysNo,@Source,@DR,@TS,@OrderID,@Author)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@ArticleSysNo",SqlDbType.Int,4), new SqlParameter("@CateSysNo",SqlDbType.Int,4), new SqlParameter("@Source",SqlDbType.NVarChar,100), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime), new SqlParameter("@OrderID",SqlDbType.Int,4), new SqlParameter("@Author",SqlDbType.NVarChar,100), }; if (model.ArticleSysNo != AppConst.IntNull) parameters[0].Value = model.ArticleSysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.CateSysNo != AppConst.IntNull) parameters[1].Value = model.CateSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.Source != AppConst.StringNull) parameters[2].Value = model.Source; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.DR != AppConst.IntNull) parameters[3].Value = model.DR; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.TS != AppConst.DateTimeNull) parameters[4].Value = model.TS; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.OrderID != AppConst.IntNull) parameters[5].Value = model.OrderID; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.Author != AppConst.StringNull) parameters[6].Value = model.Author; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); return SqlHelper.ExecuteNonQuery(cmd,parameters); }
protected void BindArticle() { CMS_ArticleMod m_cms = CMS_ArticleBll.GetInstance().GetModel(sysno); SYS_ArticleMod m_article = SYS_ArticleBll.GetInstance().GetModel(m_cms.ArticleSysNo); Dictionary <int, SYS_ArticleContentMod> m_content = SYS_ArticleContentBll.GetInstance().GetContentByArticle(m_cms.ArticleSysNo); Dictionary <int, string[]> m_neighbour = CMS_ArticleBll.GetInstance().GetNeighbour(sysno, m_cms.CateSysNo); ltrTitle.Text = m_article.Title; ltrContent.Text = m_content[1].Context; #region 设置前一篇后一篇 switch (m_neighbour.Count) { case 0: ltrPre.Text = "已经是第一篇了"; ltrAft.Text = "已经是最后一篇了"; lnkPreTop.Enabled = false; lnkPreBtm.Enabled = false; lnkAftTop.Enabled = false; lnkAftBtm.Enabled = false; break; case 1: if (int.Parse(m_neighbour[0][2]) > m_cms.OrderID || (int.Parse(m_neighbour[0][2]) == m_cms.OrderID && int.Parse(m_neighbour[0][2]) < m_article.SysNo)) { ltrPre.Text = m_neighbour[0][1]; ltrAft.Text = "已经是最后一篇了"; lnkPreTop.NavigateUrl = "Content.aspx?id=" + m_neighbour[0][0]; lnkPreBtm.NavigateUrl = "Content.aspx?id=" + m_neighbour[0][0]; lnkAftTop.Enabled = false; lnkAftBtm.Enabled = false; } else { ltrPre.Text = "已经是第一篇了"; ltrAft.Text = m_neighbour[1][1]; lnkPreTop.Enabled = false; lnkPreBtm.Enabled = false; lnkAftTop.NavigateUrl = "Content.aspx?id=" + m_neighbour[1][0]; lnkAftBtm.NavigateUrl = "Content.aspx?id=" + m_neighbour[1][0]; } break; case 2: ltrPre.Text = m_neighbour[0][1]; ltrAft.Text = m_neighbour[1][1]; lnkPreTop.NavigateUrl = "Content.aspx?id=" + m_neighbour[0][0]; lnkPreBtm.NavigateUrl = "Content.aspx?id=" + m_neighbour[0][0]; lnkAftTop.NavigateUrl = "Content.aspx?id=" + m_neighbour[1][0]; lnkAftBtm.NavigateUrl = "Content.aspx?id=" + m_neighbour[1][0]; break; } #endregion }
/// <summary> /// 得到一个对象实体 /// </summary> public CMS_ArticleMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, ArticleSysNo, CateSysNo, Source, DR, TS, OrderID, Author from CMS_Article"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; CMS_ArticleMod model = new CMS_ArticleMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["ArticleSysNo"].ToString() != "") { model.ArticleSysNo = int.Parse(ds.Tables[0].Rows[0]["ArticleSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["CateSysNo"].ToString() != "") { model.CateSysNo = int.Parse(ds.Tables[0].Rows[0]["CateSysNo"].ToString()); } model.Source = ds.Tables[0].Rows[0]["Source"].ToString(); if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } if (ds.Tables[0].Rows[0]["OrderID"].ToString() != "") { model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString()); } model.Author = ds.Tables[0].Rows[0]["Author"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Delete() { try { CMS_ArticleMod m_famous = CMS_ArticleBll.GetInstance().GetModel(int.Parse(Request.QueryString["delete"])); m_famous.DR = (int)AppEnum.State.deleted; CMS_ArticleBll.GetInstance().Update(m_famous); ltrNotice.Text = "该记录已删除!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch { ltrError.Text = "系统错误,删除失败!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';", true); } }
protected void Unnamed3_Click(object sender, EventArgs e) { SYS_ArticleMod m_article = new SYS_ArticleMod(); Dictionary<int, SYS_ArticleContentMod> m_content = new Dictionary<int, SYS_ArticleContentMod>(); CMS_ArticleMod m_cms = new CMS_ArticleMod(); if (type == "EDIT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { SysNo = int.Parse(Request.QueryString["id"]); } m_cms = CMS_ArticleBll.GetInstance().GetModel(SysNo); m_article = SYS_ArticleBll.GetInstance().GetModel(m_cms.ArticleSysNo); m_content = SYS_ArticleContentBll.GetInstance().GetContentByArticle(m_cms.ArticleSysNo); } try { if (drpCate.SelectedValue == "0") { ltrError.Text = "请选择分类!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } m_article.Title = txtTitle.Text; if (type == "EDIT") { m_content[1].Context = txtContext.Text; } m_article.Description = txtDesc.Text; m_article.KeyWords = txtKeyWords.Text; m_article.Cost = int.Parse(txtPoint.Text); m_cms.CateSysNo = int.Parse(drpCate.SelectedValue); m_cms.Source = txtSource.Text; m_cms.Author = txtAuthor.Text; if (txtOrder.Text.Trim() != "") { m_cms.OrderID = int.Parse(txtOrder.Text.Trim()); } else { m_cms.OrderID = 0; } } catch { ltrError.Text = "输入资料格式有误,请检查!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } try { if (type == "ADD") { m_article.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo; m_article.Limited = (int)AppEnum.ArticleLimit.everyone; m_article.ReadCount = 0; m_article.TS = DateTime.Now; m_article.DR = (int)AppEnum.State.normal; m_cms.ArticleSysNo = SYS_ArticleBll.GetInstance().Add(m_article); m_cms.TS = DateTime.Now; m_cms.DR = (int)AppEnum.State.normal; CMS_ArticleBll.GetInstance().Add(m_cms); SYS_ArticleContentMod m_newcontent = new SYS_ArticleContentMod(); m_newcontent.ArticleSysNo = m_cms.ArticleSysNo; m_newcontent.Context = txtContext.Text; m_newcontent.Page = 1; m_newcontent.TS = DateTime.Now; m_newcontent.DR = (int)AppEnum.State.normal; SYS_ArticleContentBll.GetInstance().Add(m_newcontent); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } else if (type == "EDIT") { CMS_ArticleBll.GetInstance().Update(m_cms); SYS_ArticleBll.GetInstance().Update(m_article); SYS_ArticleContentBll.GetInstance().Update(m_content[1]); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } else if (type == "INPUT") { m_cms.ArticleSysNo = SYS_ArticleBll.GetInstance().Add(m_article); CMS_ArticleBll.GetInstance().Add(m_cms); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } ltrNotice.Text = "该记录已保存成功!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch (Exception ex) { ltrError.Text = "系统错误,保存失败!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); LogManagement.getInstance().WriteException(ex, "Article.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(CMS_ArticleMod model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(CMS_ArticleMod model) { dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CMS_ArticleMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMS_Article("); strSql.Append("ArticleSysNo,CateSysNo,Source,DR,TS,OrderID,Author)"); strSql.Append(" values ("); strSql.Append("@ArticleSysNo,@CateSysNo,@Source,@DR,@TS,@OrderID,@Author)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@ArticleSysNo", SqlDbType.Int, 4), new SqlParameter("@CateSysNo", SqlDbType.Int, 4), new SqlParameter("@Source", SqlDbType.NVarChar, 100), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@Author", SqlDbType.NVarChar, 100), }; if (model.ArticleSysNo != AppConst.IntNull) { parameters[0].Value = model.ArticleSysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.CateSysNo != AppConst.IntNull) { parameters[1].Value = model.CateSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.Source != AppConst.StringNull) { parameters[2].Value = model.Source; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.DR != AppConst.IntNull) { parameters[3].Value = model.DR; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.TS != AppConst.DateTimeNull) { parameters[4].Value = model.TS; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.OrderID != AppConst.IntNull) { parameters[5].Value = model.OrderID; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.Author != AppConst.StringNull) { parameters[6].Value = model.Author; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(CMS_ArticleMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CMS_Article set "); strSql.Append("ArticleSysNo=@ArticleSysNo,"); strSql.Append("CateSysNo=@CateSysNo,"); strSql.Append("Source=@Source,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS,"); strSql.Append("OrderID=@OrderID,"); strSql.Append("Author=@Author"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4), new SqlParameter("@ArticleSysNo", SqlDbType.Int, 4), new SqlParameter("@CateSysNo", SqlDbType.Int, 4), new SqlParameter("@Source", SqlDbType.NVarChar, 100), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime), new SqlParameter("@OrderID", SqlDbType.Int, 4), new SqlParameter("@Author", SqlDbType.NVarChar, 100) }; if (model.SysNo != AppConst.IntNull) { parameters[0].Value = model.SysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.ArticleSysNo != AppConst.IntNull) { parameters[1].Value = model.ArticleSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.CateSysNo != AppConst.IntNull) { parameters[2].Value = model.CateSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.Source != AppConst.StringNull) { parameters[3].Value = model.Source; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) { parameters[4].Value = model.DR; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) { parameters[5].Value = model.TS; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.OrderID != AppConst.IntNull) { parameters[6].Value = model.OrderID; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); if (model.Author != AppConst.StringNull) { parameters[7].Value = model.Author; } else { parameters[7].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[7]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(CMS_ArticleMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CMS_Article set "); strSql.Append("ArticleSysNo=@ArticleSysNo,"); strSql.Append("CateSysNo=@CateSysNo,"); strSql.Append("Source=@Source,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS,"); strSql.Append("OrderID=@OrderID,"); strSql.Append("Author=@Author"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo",SqlDbType.Int,4), new SqlParameter("@ArticleSysNo",SqlDbType.Int,4), new SqlParameter("@CateSysNo",SqlDbType.Int,4), new SqlParameter("@Source",SqlDbType.NVarChar,100), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime), new SqlParameter("@OrderID",SqlDbType.Int,4), new SqlParameter("@Author",SqlDbType.NVarChar,100) }; if (model.SysNo != AppConst.IntNull) parameters[0].Value = model.SysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.ArticleSysNo != AppConst.IntNull) parameters[1].Value = model.ArticleSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.CateSysNo != AppConst.IntNull) parameters[2].Value = model.CateSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.Source != AppConst.StringNull) parameters[3].Value = model.Source; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) parameters[4].Value = model.DR; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) parameters[5].Value = model.TS; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.OrderID != AppConst.IntNull) parameters[6].Value = model.OrderID; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); if (model.Author != AppConst.StringNull) parameters[7].Value = model.Author; else parameters[7].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[7]); return SqlHelper.ExecuteNonQuery(cmd, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public CMS_ArticleMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, ArticleSysNo, CateSysNo, Source, DR, TS, OrderID, Author from CMS_Article"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int,4 ) }; parameters[0].Value = SysNo; CMS_ArticleMod model = new CMS_ArticleMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["ArticleSysNo"].ToString() != "") { model.ArticleSysNo = int.Parse(ds.Tables[0].Rows[0]["ArticleSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["CateSysNo"].ToString() != "") { model.CateSysNo = int.Parse(ds.Tables[0].Rows[0]["CateSysNo"].ToString()); } model.Source = ds.Tables[0].Rows[0]["Source"].ToString(); if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } if (ds.Tables[0].Rows[0]["OrderID"].ToString() != "") { model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString()); } model.Author = ds.Tables[0].Rows[0]["Author"].ToString(); return model; } else { return null; } }
protected void PrepareForm() { #region 项绑定 DataTable parent = CMS_CategoryBll.GetInstance().GetCates(0); DataTable m_dt = new DataTable(); m_dt.Columns.Add("SysNo"); m_dt.Columns.Add("Name"); for (int i = 0; i < parent.Rows.Count; i++) { DataTable tmp = CMS_CategoryBll.GetInstance().GetCates(int.Parse(parent.Rows[i]["SysNo"].ToString())); for (int j = 0; j < tmp.Rows.Count; j++) { DataTable tmpp = CMS_CategoryBll.GetInstance().GetCates(int.Parse(tmp.Rows[j]["SysNo"].ToString())); for (int k = 0; k < tmpp.Rows.Count; k++) { DataRow m_dr = m_dt.NewRow(); m_dr["SysNo"] = tmpp.Rows[k]["SysNo"]; m_dr["Name"] = parent.Rows[i]["Name"].ToString() + "-" + tmp.Rows[j]["Name"].ToString() + "-" + tmpp.Rows[k]["Name"].ToString(); m_dt.Rows.Add(m_dr); } } } drpCate.DataSource = m_dt; drpCate.DataTextField = "Name"; drpCate.DataValueField = "SysNo"; drpCate.DataBind(); drpCate.Items.Insert(0, new ListItem("请选择", "0")); #endregion if (type == "ADD") { } else if (type == "EDIT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { try { SysNo = int.Parse(Request.QueryString["id"]); CMS_ArticleMod m_cms = CMS_ArticleBll.GetInstance().GetModel(SysNo); SYS_ArticleMod m_article = SYS_ArticleBll.GetInstance().GetModel(m_cms.ArticleSysNo); Dictionary <int, SYS_ArticleContentMod> m_content = SYS_ArticleContentBll.GetInstance().GetContentByArticle(m_cms.ArticleSysNo); txtSysNo.Text = m_cms.SysNo.ToString(); txtContext.Text = m_content[1].Context; txtDesc.Text = m_article.Description; txtKeyWords.Text = m_article.KeyWords; txtOrder.Text = m_cms.OrderID.ToString(); txtPoint.Text = m_article.Cost.ToString(); txtSource.Text = m_cms.Source; txtTitle.Text = m_article.Title; txtAuthor.Text = m_cms.Author; drpCate.SelectedIndex = drpCate.Items.IndexOf(drpCate.Items.FindByValue(m_cms.CateSysNo.ToString())); } catch { Response.Redirect("../Error.aspx?msg="); return; } } } else if (type == "INPUT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { try { int articleSysno = int.Parse(Request.QueryString["id"]); SYS_ArticleMod m_article = SYS_ArticleBll.GetInstance().GetModel(articleSysno); SYS_ArticleContentMod m_content = SYS_ArticleContentBll.GetInstance().GetModel(articleSysno); txtSysNo.Text = "自动生成"; txtTitle.Text = m_article.Title; txtContext.Text = m_content.Context; txtDesc.Text = m_article.Description; txtKeyWords.Text = m_article.KeyWords; txtPoint.Text = m_article.Cost.ToString(); txtOrder.Text = "0"; txtTitle.Enabled = false; txtContext.Enabled = false; txtDesc.Enabled = false; txtKeyWords.Enabled = false; txtPoint.Enabled = false; } catch { Response.Redirect("../Error.aspx?msg="); return; } } } }
protected void Unnamed3_Click(object sender, EventArgs e) { SYS_ArticleMod m_article = new SYS_ArticleMod(); Dictionary <int, SYS_ArticleContentMod> m_content = new Dictionary <int, SYS_ArticleContentMod>(); CMS_ArticleMod m_cms = new CMS_ArticleMod(); if (type == "EDIT") { if (Request.QueryString["id"] != null && Request.QueryString["id"] != "") { SysNo = int.Parse(Request.QueryString["id"]); } m_cms = CMS_ArticleBll.GetInstance().GetModel(SysNo); m_article = SYS_ArticleBll.GetInstance().GetModel(m_cms.ArticleSysNo); m_content = SYS_ArticleContentBll.GetInstance().GetContentByArticle(m_cms.ArticleSysNo); } try { if (drpCate.SelectedValue == "0") { ltrError.Text = "请选择分类!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } m_article.Title = txtTitle.Text; if (type == "EDIT") { m_content[1].Context = txtContext.Text; } m_article.Description = txtDesc.Text; m_article.KeyWords = txtKeyWords.Text; m_article.Cost = int.Parse(txtPoint.Text); m_cms.CateSysNo = int.Parse(drpCate.SelectedValue); m_cms.Source = txtSource.Text; m_cms.Author = txtAuthor.Text; if (txtOrder.Text.Trim() != "") { m_cms.OrderID = int.Parse(txtOrder.Text.Trim()); } else { m_cms.OrderID = 0; } } catch { ltrError.Text = "输入资料格式有误,请检查!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); return; } try { if (type == "ADD") { m_article.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo; m_article.Limited = (int)AppEnum.ArticleLimit.everyone; m_article.ReadCount = 0; m_article.TS = DateTime.Now; m_article.DR = (int)AppEnum.State.normal; m_cms.ArticleSysNo = SYS_ArticleBll.GetInstance().Add(m_article); m_cms.TS = DateTime.Now; m_cms.DR = (int)AppEnum.State.normal; CMS_ArticleBll.GetInstance().Add(m_cms); SYS_ArticleContentMod m_newcontent = new SYS_ArticleContentMod(); m_newcontent.ArticleSysNo = m_cms.ArticleSysNo; m_newcontent.Context = txtContext.Text; m_newcontent.Page = 1; m_newcontent.TS = DateTime.Now; m_newcontent.DR = (int)AppEnum.State.normal; SYS_ArticleContentBll.GetInstance().Add(m_newcontent); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } else if (type == "EDIT") { CMS_ArticleBll.GetInstance().Update(m_cms); SYS_ArticleBll.GetInstance().Update(m_article); SYS_ArticleContentBll.GetInstance().Update(m_content[1]); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } else if (type == "INPUT") { m_cms.ArticleSysNo = SYS_ArticleBll.GetInstance().Add(m_article); CMS_ArticleBll.GetInstance().Add(m_cms); LogManagement.getInstance().WriteTrace(m_cms.SysNo, "Article.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } ltrNotice.Text = "该记录已保存成功!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch (Exception ex) { ltrError.Text = "系统错误,保存失败!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true); LogManagement.getInstance().WriteException(ex, "Article.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username); } }