protected string ViewTitle(int _kindId, int _parentId) { string str = "错误,暂无找到该信息标题!"; switch (_kindId) { case (int)Channel.Article: DtCms.BLL.Article abll = new DtCms.BLL.Article(); DtCms.Model.Article amodel = abll.GetModel(_parentId); if (amodel != null) { str = amodel.Title; } break; case (int)Channel.Pictures: DtCms.BLL.Pictures pbll = new DtCms.BLL.Pictures(); DtCms.Model.Pictures pmodel = pbll.GetModel(_parentId); if (pmodel != null) { str = pmodel.Title; } break; case (int)Channel.Downloads: DtCms.BLL.Downloads dbll = new DtCms.BLL.Downloads(); DtCms.Model.Downloads dmodel = dbll.GetModel(_parentId); if (dmodel != null) { str = dmodel.Title; } break; } return(str); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_Article("); strSql.Append("ClassId,Title,Author,Form,Keyword,Zhaiyao,Daodu,ImgUrl,Content,Click,IsMsg,IsTop,IsRed,IsHot,IsSlide,IsLock,AddTime)"); strSql.Append(" values ("); strSql.Append("@ClassId,@Title,@Author,@Form,@Keyword,@Zhaiyao,@Daodu,@ImgUrl,@Content,@Click,@IsMsg,@IsTop,@IsRed,@IsHot,@IsSlide,@IsLock,@AddTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Author", SqlDbType.NVarChar, 50), new SqlParameter("@Form", SqlDbType.NVarChar, 50), new SqlParameter("@Keyword", SqlDbType.NVarChar, 100), new SqlParameter("@Zhaiyao", SqlDbType.NVarChar, 250), new SqlParameter("@Daodu", SqlDbType.NVarChar, 250), new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 250), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@IsMsg", SqlDbType.Int, 4), new SqlParameter("@IsTop", SqlDbType.Int, 4), new SqlParameter("@IsRed", SqlDbType.Int, 4), new SqlParameter("@IsHot", SqlDbType.Int, 4), new SqlParameter("@IsSlide", SqlDbType.Int, 4), new SqlParameter("@IsLock", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime) }; parameters[0].Value = model.ClassId; parameters[1].Value = model.Title; parameters[2].Value = model.Author; parameters[3].Value = model.Form; parameters[4].Value = model.Keyword; parameters[5].Value = model.Zhaiyao; parameters[6].Value = model.Daodu; parameters[7].Value = model.ImgUrl; parameters[8].Value = model.Content; parameters[9].Value = model.Click; parameters[10].Value = model.IsMsg; parameters[11].Value = model.IsTop; parameters[12].Value = model.IsRed; parameters[13].Value = model.IsHot; parameters[14].Value = model.IsSlide; parameters[15].Value = model.IsLock; parameters[16].Value = model.AddTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DtCms.Model.Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Article("); strSql.Append("Title,Author,Form,Keyword,Zhaiyao,ClassId,ImgUrl,Daodu,Content,Click,IsMsg,IsTop,IsRed,IsHot,IsSlide,IsLock,AddTime)"); strSql.Append(" values ("); strSql.Append("@Title,@Author,@Form,@Keyword,@Zhaiyao,@ClassId,@ImgUrl,@Daodu,@Content,@Click,@IsMsg,@IsTop,@IsRed,@IsHot,@IsSlide,@IsLock,@AddTime)"); OleDbParameter[] parameters = { new OleDbParameter("@Title", OleDbType.VarWChar, 200), new OleDbParameter("@Author", OleDbType.VarWChar, 50), new OleDbParameter("@Form", OleDbType.VarWChar, 100), new OleDbParameter("@Keyword", OleDbType.VarWChar, 100), new OleDbParameter("@Zhaiyao", OleDbType.VarWChar, 250), new OleDbParameter("@ClassId", OleDbType.Integer, 4), new OleDbParameter("@ImgUrl", OleDbType.VarWChar, 250), new OleDbParameter("@Daodu", OleDbType.VarWChar, 250), new OleDbParameter("@Content", OleDbType.VarWChar), new OleDbParameter("@Click", OleDbType.Integer, 4), new OleDbParameter("@IsMsg", OleDbType.Integer, 4), new OleDbParameter("@IsTop", OleDbType.Integer, 4), new OleDbParameter("@IsRed", OleDbType.Integer, 4), new OleDbParameter("@IsHot", OleDbType.Integer, 4), new OleDbParameter("@IsSlide", OleDbType.Integer, 4), new OleDbParameter("@IsLock", OleDbType.Integer, 4), new OleDbParameter("@AddTime", OleDbType.Date) }; parameters[0].Value = model.Title; parameters[1].Value = model.Author; parameters[2].Value = model.Form; parameters[3].Value = model.Keyword; parameters[4].Value = model.Zhaiyao; parameters[5].Value = model.ClassId; parameters[6].Value = model.ImgUrl; parameters[7].Value = model.Daodu; parameters[8].Value = model.Content; parameters[9].Value = model.Click; parameters[10].Value = model.IsMsg; parameters[11].Value = model.IsTop; parameters[12].Value = model.IsRed; parameters[13].Value = model.IsHot; parameters[14].Value = model.IsSlide; parameters[15].Value = model.IsLock; parameters[16].Value = model.AddTime; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
//保存 protected void btnSave_Click(object sender, EventArgs e) { DtCms.BLL.Article bll = new DtCms.BLL.Article(); DtCms.Model.Article model = bll.GetModel(this.Id); model.Title = txtTitle.Text.Trim(); model.Author = txtAuthor.Text.Trim(); model.Form = txtForm.Text.Trim(); model.Keyword = txtKeyword.Text.Trim(); model.Zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 250); model.Daodu = Utils.DropHTML(txtDaodu.Text, 250); model.ClassId = int.Parse(ddlClassId.SelectedValue); model.ImgUrl = txtImgUrl.Text.Trim(); model.Content = txtContent.Value; model.Click = int.Parse(txtClick.Text.Trim()); model.IsMsg = 0; model.IsTop = 0; model.IsRed = 0; model.IsHot = 0; model.IsSlide = 0; if (cblItem.Items[0].Selected == true) { model.IsMsg = 1; } if (cblItem.Items[1].Selected == true) { model.IsTop = 1; } if (cblItem.Items[2].Selected == true) { model.IsRed = 1; } if (cblItem.Items[3].Selected == true) { model.IsHot = 1; } if (cblItem.Items[4].Selected == true) { model.IsSlide = 1; } bll.Update(model); //保存日志 SaveLogs("[资讯模块]编辑文章:" + model.Title); JscriptPrint("文章编辑成功啦!", "List.aspx", "Success"); }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(Request.Params["id"] as string, out Id)) { Server.Transfer("error.aspx"); return; } DtCms.BLL.Article bll = new DtCms.BLL.Article(); if (!bll.Exists(Id)) { Server.Transfer("error.aspx"); return; } model = bll.GetModel(Id); //浏览数+1 bll.UpdateField(this.Id, "Click=Click+1"); }
//赋值操作 private void ShowInfo(int _id) { DtCms.BLL.Article bll = new DtCms.BLL.Article(); DtCms.Model.Article model = bll.GetModel(_id); txtTitle.Text = model.Title; txtAuthor.Text = model.Author; txtForm.Text = model.Form; txtKeyword.Text = model.Keyword; txtZhaiyao.Text = model.Zhaiyao; ddlClassId.SelectedValue = model.ClassId.ToString(); txtImgUrl.Text = model.ImgUrl; txtDaodu.Text = model.Daodu; txtContent.Value = model.Content; txtClick.Text = model.Click.ToString(); if (model.IsMsg == 1) { cblItem.Items[0].Selected = true; } if (model.IsTop == 1) { cblItem.Items[1].Selected = true; } if (model.IsRed == 1) { cblItem.Items[2].Selected = true; } if (model.IsHot == 1) { cblItem.Items[3].Selected = true; } if (model.IsSlide == 1) { cblItem.Items[4].Selected = true; } }
//设置操作 protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { int id = Convert.ToInt32(((Label)e.Item.FindControl("lb_id")).Text); DtCms.BLL.Article bll = new DtCms.BLL.Article(); DtCms.Model.Article model = bll.GetModel(id); switch (e.CommandName.ToLower()) { case "ibtnmsg": if (model.IsMsg == 1) { bll.UpdateField(id, "IsMsg=0"); } else { bll.UpdateField(id, "IsMsg=1"); } break; case "ibtntop": if (model.IsTop == 1) { bll.UpdateField(id, "IsTop=0"); } else { bll.UpdateField(id, "IsTop=1"); } break; case "ibtnred": if (model.IsRed == 1) { bll.UpdateField(id, "IsRed=0"); } else { bll.UpdateField(id, "IsRed=1"); } break; case "ibtnhot": if (model.IsHot == 1) { bll.UpdateField(id, "IsHot=0"); } else { bll.UpdateField(id, "IsHot=1"); } break; case "ibtnslide": if (model.IsSlide == 1) { bll.UpdateField(id, "IsSlide=0"); } else { bll.UpdateField(id, "IsSlide=1"); } break; } RptBind("Id>0" + CombSqlTxt(this.kindId, this.classId, this.keywords, this.property), "AddTime desc"); }
/// <summary> /// 得到一个对象实体 /// </summary> public DtCms.Model.Article GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,ClassId,Title,Author,Form,Keyword,Zhaiyao,Daodu,ImgUrl,Content,Click,IsMsg,IsTop,IsRed,IsHot,IsSlide,IsLock,AddTime from dt_Article "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DtCms.Model.Article model = new DtCms.Model.Article(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["ClassId"].ToString() != "") { model.ClassId = int.Parse(ds.Tables[0].Rows[0]["ClassId"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Author = ds.Tables[0].Rows[0]["Author"].ToString(); model.Form = ds.Tables[0].Rows[0]["Form"].ToString(); model.Keyword = ds.Tables[0].Rows[0]["Keyword"].ToString(); model.Zhaiyao = ds.Tables[0].Rows[0]["Zhaiyao"].ToString(); model.Daodu = ds.Tables[0].Rows[0]["Daodu"].ToString(); model.ImgUrl = ds.Tables[0].Rows[0]["ImgUrl"].ToString(); model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); if (ds.Tables[0].Rows[0]["Click"].ToString() != "") { model.Click = int.Parse(ds.Tables[0].Rows[0]["Click"].ToString()); } if (ds.Tables[0].Rows[0]["IsMsg"].ToString() != "") { model.IsMsg = int.Parse(ds.Tables[0].Rows[0]["IsMsg"].ToString()); } if (ds.Tables[0].Rows[0]["IsTop"].ToString() != "") { model.IsTop = int.Parse(ds.Tables[0].Rows[0]["IsTop"].ToString()); } if (ds.Tables[0].Rows[0]["IsRed"].ToString() != "") { model.IsRed = int.Parse(ds.Tables[0].Rows[0]["IsRed"].ToString()); } if (ds.Tables[0].Rows[0]["IsHot"].ToString() != "") { model.IsHot = int.Parse(ds.Tables[0].Rows[0]["IsHot"].ToString()); } if (ds.Tables[0].Rows[0]["IsSlide"].ToString() != "") { model.IsSlide = int.Parse(ds.Tables[0].Rows[0]["IsSlide"].ToString()); } if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "") { model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_Article set "); strSql.Append("ClassId=@ClassId,"); strSql.Append("Title=@Title,"); strSql.Append("Author=@Author,"); strSql.Append("Form=@Form,"); strSql.Append("Keyword=@Keyword,"); strSql.Append("Zhaiyao=@Zhaiyao,"); strSql.Append("Daodu=@Daodu,"); strSql.Append("ImgUrl=@ImgUrl,"); strSql.Append("Content=@Content,"); strSql.Append("Click=@Click,"); strSql.Append("IsMsg=@IsMsg,"); strSql.Append("IsTop=@IsTop,"); strSql.Append("IsRed=@IsRed,"); strSql.Append("IsHot=@IsHot,"); strSql.Append("IsSlide=@IsSlide,"); strSql.Append("IsLock=@IsLock"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Author", SqlDbType.NVarChar, 50), new SqlParameter("@Form", SqlDbType.NVarChar, 50), new SqlParameter("@Keyword", SqlDbType.NVarChar, 100), new SqlParameter("@Zhaiyao", SqlDbType.NVarChar, 250), new SqlParameter("@Daodu", SqlDbType.NVarChar, 250), new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 250), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@IsMsg", SqlDbType.Int, 4), new SqlParameter("@IsTop", SqlDbType.Int, 4), new SqlParameter("@IsRed", SqlDbType.Int, 4), new SqlParameter("@IsHot", SqlDbType.Int, 4), new SqlParameter("@IsSlide", SqlDbType.Int, 4), new SqlParameter("@IsLock", SqlDbType.Int, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.ClassId; parameters[2].Value = model.Title; parameters[3].Value = model.Author; parameters[4].Value = model.Form; parameters[5].Value = model.Keyword; parameters[6].Value = model.Zhaiyao; parameters[7].Value = model.Daodu; parameters[8].Value = model.ImgUrl; parameters[9].Value = model.Content; parameters[10].Value = model.Click; parameters[11].Value = model.IsMsg; parameters[12].Value = model.IsTop; parameters[13].Value = model.IsRed; parameters[14].Value = model.IsHot; parameters[15].Value = model.IsSlide; parameters[16].Value = model.IsLock; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DtCms.Model.Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Article set "); strSql.Append("Title=@Title,"); strSql.Append("Author=@Author,"); strSql.Append("Form=@Form,"); strSql.Append("Keyword=@Keyword,"); strSql.Append("Zhaiyao=@Zhaiyao,"); strSql.Append("ClassId=@ClassId,"); strSql.Append("ImgUrl=@ImgUrl,"); strSql.Append("Daodu=@Daodu,"); strSql.Append("Content=@Content,"); strSql.Append("Click=@Click,"); strSql.Append("IsMsg=@IsMsg,"); strSql.Append("IsTop=@IsTop,"); strSql.Append("IsRed=@IsRed,"); strSql.Append("IsHot=@IsHot,"); strSql.Append("IsSlide=@IsSlide,"); strSql.Append("IsLock=@IsLock,"); strSql.Append("AddTime=@AddTime"); strSql.Append(" where Id=@Id "); OleDbParameter[] parameters = { new OleDbParameter("@Title", OleDbType.VarWChar, 200), new OleDbParameter("@Author", OleDbType.VarWChar, 50), new OleDbParameter("@Form", OleDbType.VarWChar, 100), new OleDbParameter("@Keyword", OleDbType.VarWChar, 100), new OleDbParameter("@Zhaiyao", OleDbType.VarWChar, 250), new OleDbParameter("@ClassId", OleDbType.Integer, 4), new OleDbParameter("@ImgUrl", OleDbType.VarWChar, 250), new OleDbParameter("@Daodu", OleDbType.VarWChar, 250), new OleDbParameter("@Content", OleDbType.VarWChar), new OleDbParameter("@Click", OleDbType.Integer, 4), new OleDbParameter("@IsMsg", OleDbType.Integer, 4), new OleDbParameter("@IsTop", OleDbType.Integer, 4), new OleDbParameter("@IsRed", OleDbType.Integer, 4), new OleDbParameter("@IsHot", OleDbType.Integer, 4), new OleDbParameter("@IsSlide", OleDbType.Integer, 4), new OleDbParameter("@IsLock", OleDbType.Integer, 4), new OleDbParameter("@AddTime", OleDbType.Date), new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.Author; parameters[2].Value = model.Form; parameters[3].Value = model.Keyword; parameters[4].Value = model.Zhaiyao; parameters[5].Value = model.ClassId; parameters[6].Value = model.ImgUrl; parameters[7].Value = model.Daodu; parameters[8].Value = model.Content; parameters[9].Value = model.Click; parameters[10].Value = model.IsMsg; parameters[11].Value = model.IsTop; parameters[12].Value = model.IsRed; parameters[13].Value = model.IsHot; parameters[14].Value = model.IsSlide; parameters[15].Value = model.IsLock; parameters[16].Value = model.AddTime; parameters[17].Value = model.Id; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Article model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Article model) { return(dal.Add(model)); }
//保存 protected void btnSave_Click(object sender, EventArgs e) { try { DtCms.BLL.Article bll = new DtCms.BLL.Article(); DtCms.Model.Article model = bll.GetModel(this.Id); //保存用户头像 if (!string.IsNullOrEmpty(FileUpload1.FileName)) { if (FileUpload1.PostedFile.ContentLength / 1024 > 100) { JscriptPrint("上传的视频过大,视频文件要低于100MB!", "", ""); } else { string ext = FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.')); string spath = @"video/" + DateTime.Now.ToString("yyyyMMddhhmmss") + ext;//相对路径 if (ext.ToLower() == ".swf") { FileUpload1.SaveAs(Server.MapPath(spath)); model.ImgUrl = spath; } else { JscriptPrint("只支持swf视频文件!", "", ""); } } } model.Title = txtTitle.Text.Trim(); model.Author = txtAuthor.Text.Trim(); model.Form = txtForm.Text.Trim(); model.Keyword = txtKeyword.Text.Trim(); model.Zhaiyao = StringPlus.DropHTML(txtZhaiyao.Text, 250); model.Daodu = StringPlus.DropHTML(txtDaodu.Text, 250); model.ClassId = int.Parse(ddlClassId.SelectedValue); model.Content = FCKeditor.Value; model.Click = int.Parse(txtClick.Text.Trim()); model.IsMsg = 0; model.IsTop = 0; model.IsRed = 0; model.IsHot = 0; model.IsSlide = 0; if (cblItem.Items[0].Selected == true) { model.IsMsg = 1; } if (cblItem.Items[1].Selected == true) { model.IsTop = 1; } if (cblItem.Items[2].Selected == true) { model.IsRed = 1; } if (cblItem.Items[3].Selected == true) { model.IsHot = 1; } if (cblItem.Items[4].Selected == true) { model.IsSlide = 1; } bll.Update(model); JscriptPrint("编辑成功啦!", "List.aspx", "Success"); } catch (Exception) { JscriptPrint("视频文件过大!", "", ""); } }