private bool DoAdd() { bool result = false; Model.news model = new Model.news(); BLL.news bll = new BLL.news(); model.title = txtTitle.Text.Trim(); model.is_hide = Convert.ToInt32(rblIsHide.SelectedValue); model.is_msg = Convert.ToInt32(rblIsMsg.SelectedValue); model.img = txtImg.Text; model.sort = Convert.ToInt32(txtSort.Text); model.click = Convert.ToInt32(txtClick.Text); if (string.IsNullOrEmpty(txtTime.Text)) { model.time = DateTime.Now; } else { model.time = Convert.ToDateTime(txtTime.Text); } //内容摘要提取内容前255个字符 if (string.IsNullOrEmpty(txtZhaiyao.Text.Trim())) { model.zhaiyao = Utils.DropHTML(txtContent.Value, 255); } else { model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 255); } //是否将编辑器远程图片保存到本地 if (siteConfig.fileremote == 1) { model.cont = AutoRemoteImageSave(txtContent.Value); } else { model.cont = txtContent.Value; } model.id = bll.Add(model); if (model.id > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加咨询内容:" + model.title); //记录日志 result = true; } return(result); }
private void ShowInfo(int _id) { Model.news model = new BLL.news().GetModel(_id); txtTitle.Text = model.title; rblIsHide.SelectedValue = model.is_hide.ToString(); rblIsMsg.SelectedValue = model.is_msg.ToString(); txtImg.Text = model.img; txtSort.Text = model.sort.ToString(); txtClick.Text = model.click.ToString(); txtTime.Text = model.time.ToString("yyyy-MM-dd HH:mm:ss"); txtZhaiyao.Text = model.zhaiyao; txtContent.InnerText = model.cont; }
private void get_news_list(HttpContext context) { int page = DTRequest.GetInt("page", 1); string keywords = DTRequest.GetString("keywords"); int count = 0; int pageSize = 4; int sum = new BLL.news().GetCount(""); if ((page - 1) * pageSize > sum) { //没有更多数据 context.Response.Write("{\"status\":0,\"msg\":\"没有更多数据\"}"); return; } DataSet ds = new BLL.news().GetList(pageSize, page, "title like '%" + keywords + "%'", "sort,time desc", out count); DataTable dt = ds.Tables[0]; dt.Columns.Add("zan", typeof(int)); dt.Columns.Add("collect", typeof(int)); dt.Columns.Add("view", typeof(int)); string[] arr = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { arr[i] = Convert.ToDateTime(dt.Rows[i]["time"].ToString()).ToString("yyyy-MM-dd HH:mm"); } dt.Columns.Remove("time"); dt.Columns.Add("time", typeof(string)); foreach (DataRow dr in dt.Rows) { dr["view"] = new BLL.news_view().GetCount("news_id=" + dr["id"].ToString() + " and isPN=2 and type=1"); dr["collect"] = new BLL.news_commend().GetCount("news_id=" + dr["id"].ToString()); dr["zan"] = new BLL.news_view().GetCount("news_id=" + dr["id"].ToString() + " and isPN=2 and type=2"); dr["time"] = arr[dt.Rows.IndexOf(dr)]; } string strJson = DTcms.Common.JsonHelper.DataTableToJSON(ds.Tables[0]); context.Response.Write(strJson); }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("news_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; //成功数量 int errorCount = 0; //失败数量 BLL.news bll = new BLL.news(); Repeater rptList = new Repeater(); if (this.rptList1.Visible == true) { rptList = this.rptList1; } else { rptList = this.rptList2; } //循环删除 for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { if (bll.Delete(id)) { sucCount++; } else { errorCount++; } } } AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "删除资讯成功" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("news_list.aspx", "keywords={0}", this.keywords)); }
//收藏列表,点赞列表 private void get_user_view_list(HttpContext context) { int uid = DTRequest.GetInt("uid", 0); int isPN = DTRequest.GetInt("isPN", 0); int type = DTRequest.GetInt("type", 0); DataTable dt = new BLL.news_view().GetList(0, "type=" + type + " and isPN=" + isPN + " and user_id=" + uid, "time desc").Tables[0]; dt.Columns.Add("title", typeof(string)); dt.Columns.Add("cont", typeof(string)); dt.Columns.Add("day", typeof(string)); foreach (DataRow dr in dt.Rows) { string title, cont; if (isPN == 1) { Model.product model = new BLL.product().GetModel(Convert.ToInt32(dr["news_id"])); title = model.title; if (model.cont.Length > 60) { cont = model.cont.Substring(0, 60) + "..."; } else { cont = model.cont; } } else { Model.news model = new BLL.news().GetModel(Convert.ToInt32(dr["news_id"])); title = model.title; if (model.zhaiyao.Length > 60) { cont = model.zhaiyao.Substring(0, 60) + "..."; } else { cont = model.zhaiyao; } } dr["title"] = title; dr["cont"] = cont; //时间隔计算 DateTime t1 = DateTime.Now; DateTime t2 = Convert.ToDateTime(dr["time"]); TimeSpan ts = t1.Subtract(t2); if (ts.Days > 3) { dr["day"] = Convert.ToDateTime(dr["time"]).ToString("yyyy-MM-dd"); } else if (ts.Days > 0) { dr["day"] = ts.Days + "天前"; } else if (ts.Hours > 0) { dr["day"] = ts.Hours + "小时前"; } else if (ts.Minutes > 0) { dr["day"] = ts.Minutes + "分钟前"; } else if (ts.Seconds > 0) { dr["day"] = ts.Seconds + "秒前"; } else { dr["day"] = "未知"; } } context.Response.Write(JsonHelper.DataTableToJSON(dt)); }