/// <summary> /// 更新数据 /// </summary> /// <param name="message">实体集</param> /// <returns>列新结果</returns> public int Update(Tunnel.Model.Tunnel_Message message) { string strSQL = string.Format("UPDATE Tunnel_Message SET MesTitle='{1}',MesContent='{2}',ModiDate='{3}' WHERE MesID={0}", message.MesID, message.MesTitle, message.MesContent, message.ModiDate); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 页面数据绑定 /// </summary> public void PageBind() { if (Id == 0) { return; } Tunnel.Model.Tunnel_Message model = new Tunnel.Model.Tunnel_Message(); List <Tunnel.Model.Tunnel_Message> modelList = new List <Tunnel.Model.Tunnel_Message>(); model = tbll.GetMessageModel(Id); modelList.Add(model); Repeater1.DataSource = modelList; Repeater1.DataBind(); }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="message">实体集</param> /// <returns>新增结果</returns> public int Add(Tunnel.Model.Tunnel_Message message) { string strSQL = string.Format("INSERT INTO Tunnel_Message (MesTitle,MesContent,MesDate,MesUser) " + "VALUES ('{0}','{1}','{2}','{3}')", message.MesTitle, message.MesContent, message.MesDate, message.MesUser); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 获得信息实体集 /// </summary> /// <param name="mesID">信息编号</param> /// <returns>信息实体集</returns> public Tunnel.Model.Tunnel_Message GetMessageModel(int mesID) { Tunnel.Model.Tunnel_Message mes = new Tunnel.Model.Tunnel_Message(); string strSQL = string.Format("SELECT * FROM Tunnel_Message WHERE MesID={0}", mesID); using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSQL)) { if (reader.Read()) { mes.MesID = Convert.ToInt32(reader["MesID"]); mes.MesTitle = reader["MesTitle"].ToString(); mes.MesContent = reader["MesContent"].ToString(); mes.MesDate = Convert.ToDateTime(reader["MesDate"]); mes.MesUser = Convert.ToInt32(reader["MesUser"]); } } return(mes); }
/// <summary> /// 获得分页集合 /// </summary> /// <param name="pb">页类</param> /// <param name="count">总数</param> /// <returns>集合</returns> public List <Tunnel.Model.Tunnel_Message> GetList(PageBase pb, ref int count) { DataTable dt = m_Message.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_Message> modelList = new List <Tunnel.Model.Tunnel_Message>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_Message model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_Message(); model.MesID = Convert.ToInt32(dt.Rows[n]["MesID"].ToString()); model.MesTitle = dt.Rows[n]["MesTitle"].ToString(); model.MesContent = dt.Rows[n]["MesContent"].ToString(); model.MesDate = Convert.ToDateTime(dt.Rows[n]["MesDate"]); model.MesUser = Convert.ToInt32(dt.Rows[n]["MesUser"].ToString()); modelList.Add(model); } } return(modelList); }
/// <summary> /// 修改 /// </summary> /// <param name="message">信息集合</param> /// <returns>修改结果</returns> public int Update(Tunnel.Model.Tunnel_Message message) { return(m_Message.Update(message)); }
/// <summary> /// 添加 /// </summary> /// <param name="message">信息集合</param> /// <returns>添加结果</returns> public int Add(Tunnel.Model.Tunnel_Message message) { return(m_Message.Add(message)); }