protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); message = messageBLL.GetModel(id); txtMessageTitle.Text = message.messagetitle; txtMessageContent.Text = message.messagecontent; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); message = messageBLL.GetModel(id); message.visitcount = message.visitcount + 1; messageBLL.Update(message); lblTitle.Text = message.messagetitle; lblTime.Text = message.createtime.ToString("yyyy-MM-dd HH:mm:ss"); lblVisitCount.Text = message.visitcount.ToString(); locContent.Text = message.messagecontent; } } }
/// <summary> /// 获得数据列表 /// </summary> public List <Model.tbMessage> DataTableToList(DataTable dt) { List <Model.tbMessage> modelList = new List <Model.tbMessage>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.tbMessage model; for (int n = 0; n < rowsCount; n++) { model = new Model.tbMessage(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.messagetitle = dt.Rows[n]["messagetitle"].ToString(); model.messagecontent = dt.Rows[n]["messagecontent"].ToString(); if (dt.Rows[n]["createtime"].ToString() != "") { model.createtime = DateTime.Parse(dt.Rows[n]["createtime"].ToString()); } if (dt.Rows[n]["userid"].ToString() != "") { model.userid = int.Parse(dt.Rows[n]["userid"].ToString()); } if (dt.Rows[n]["visitcount"].ToString() != "") { model.visitcount = int.Parse(dt.Rows[n]["visitcount"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 获得数据列表 /// </summary> public List<Model.tbMessage> DataTableToList(DataTable dt) { List<Model.tbMessage> modelList = new List<Model.tbMessage>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.tbMessage model; for (int n = 0; n < rowsCount; n++) { model = new Model.tbMessage(); if(dt.Rows[n]["id"].ToString()!="") { model.id=int.Parse(dt.Rows[n]["id"].ToString()); } model.messagetitle= dt.Rows[n]["messagetitle"].ToString(); model.messagecontent= dt.Rows[n]["messagecontent"].ToString(); if(dt.Rows[n]["createtime"].ToString()!="") { model.createtime=DateTime.Parse(dt.Rows[n]["createtime"].ToString()); } if(dt.Rows[n]["userid"].ToString()!="") { model.userid=int.Parse(dt.Rows[n]["userid"].ToString()); } if(dt.Rows[n]["visitcount"].ToString()!="") { model.visitcount=int.Parse(dt.Rows[n]["visitcount"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.tbMessage model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.tbMessage model) { return(dal.Add(model)); }