private void loadData() { BLL_NoticeBoard bll = new BLL_NoticeBoard(); DataTable dt = new DataTable(); dt = bll.GetList(1, "", " create_time desc").Tables[0]; foreach (DataRow item in dt.Rows) { ltlContent.Text = item["notice_content"].ToString(); ltlCreateTime.Text = pfunction.ConvertToLongDateTime(item["create_time"].ToString(), "yyyy年MM月dd日"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(notice_id)) { BLL_NoticeBoard bll = new BLL_NoticeBoard(); Model_NoticeBoard model = new Model_NoticeBoard(); model = bll.GetModel(notice_id); model.notice_title = this.txt_title.Text.TrimEnd(); model.notice_content = this.txt_content.Value; model.create_time = DateTime.Now; model.start_time = Convert.ToDateTime(this.txtStartTime.Value); model.end_time = Convert.ToDateTime(this.txtEndTime.Value); if (bll.Update(model)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('修改成功', { time: 1000, icon: 1},function(){parent.loadData();parent.layer.close(index)})})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('修改失败', {icon: 2})})})</script>"); return; } } else { BLL_NoticeBoard bll = new BLL_NoticeBoard(); Model_NoticeBoard model = new Model_NoticeBoard(); model.notice_title = this.txt_title.Text.TrimEnd(); model.notice_content = this.txt_content.Value; model.notice_id = Guid.NewGuid().ToString(); model.create_time = DateTime.Now; model.start_time = Convert.ToDateTime(this.txtStartTime.Value); model.end_time = Convert.ToDateTime(this.txtEndTime.Value); model.create_userid = loginUser.SysUser_ID; if (bll.Add(model)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('添加成功', { time: 1000, icon: 1},function(){parent.loadData();parent.layer.close(index)})})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('添加失败', {icon: 2})})})</script>"); return; } } } catch (Exception ex) { throw; } }
/// <summary> /// 公告 /// </summary> private void noticeBoard() { try { BLL_NoticeBoard bll = new BLL_NoticeBoard(); DataTable dt = new DataTable(); dt = bll.GetList(1, "", " create_time desc").Tables[0]; foreach (DataRow item in dt.Rows) { if (Convert.ToDateTime(item["start_time"]) <= DateTime.Now && Convert.ToDateTime(item["end_time"]) > DateTime.Now) { ClientScript.RegisterStartupScript(this.GetType(), "login", "<script>layer.open({type: 2,title: false,closeBtn: false,shade: false,area:['600px','80%'],content: 'noticeBoard.aspx'});</script>"); } } } catch (Exception) { } }
public static string delete(string notice_id) { try { BLL_NoticeBoard bll = new BLL_NoticeBoard(); if (bll.Delete(notice_id)) { return("1"); } else { return(""); } } catch (Exception ex) { return(""); } }
private void LoadData() { try { BLL_NoticeBoard bll = new BLL_NoticeBoard(); Model_NoticeBoard model = new Model_NoticeBoard(); model = bll.GetModel(notice_id); if (model != null) { this.txt_title.Text = model.notice_title; this.txt_content.Value = model.notice_content; this.txtStartTime.Value = pfunction.ConvertToLongDateTime(model.start_time.ToString(), "yyyy-MM-dd HH:mm"); this.txtEndTime.Value = pfunction.ConvertToLongDateTime(model.end_time.ToString(), "yyyy-MM-dd HH:mm"); } } catch (Exception ex) { throw; } }
public static string GetList(string key, int PageIndex, int PageSize) { try { key = key.Filter(); PageIndex = Convert.ToInt32(PageIndex.ToString().Filter()); DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strSql = string.Empty; string strSqlCount = string.Empty; string strWhere = "1=1 "; if (!string.IsNullOrEmpty(key)) { strWhere += " and notice_title like '%" + key + "%'"; } BLL_NoticeBoard bll = new BLL_NoticeBoard(); dt = bll.GetListByPage(strWhere, "create_time desc", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0]; int rCount = bll.GetRecordCount(strWhere); int inum = 0; for (int i = 0; i < dt.Rows.Count; i++) { inum++; listReturn.Add(new { inum = (i + 1), notice_id = dt.Rows[i]["notice_id"].ToString(), notice_title = dt.Rows[i]["notice_title"].ToString(), notice_content = pfunction.GetSubstring(dt.Rows[i]["notice_content"].ToString(), 200, true), create_time = pfunction.ConvertToLongDateTime(dt.Rows[i]["create_time"].ToString(), "yyyy-MM-dd HH:mm:ss"), start_time = pfunction.ConvertToLongDateTime(dt.Rows[i]["start_time"].ToString(), "yyyy-MM-dd HH:mm"), end_time = pfunction.ConvertToLongDateTime(dt.Rows[i]["end_time"].ToString(), "yyyy-MM-dd HH:mm"), }); } if (inum > 0) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = rCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = "error"//ex.Message.ToString() })); } }