protected void btnOk_Click(object sender, EventArgs e) { string typeId = ddlTbType.SelectedValue; string title = txtTitle.Text; string infoConntent = txtContent.Text; string phone = txtPhone.Text; string contact = txtContact.Text; string email = txtEmail.Text; TbInfo info = new TbInfo(); info.InfoType = Convert.ToInt32(typeId); info.InfoTitle = title; info.InfoContact = contact; info.InfoContent = infoConntent; info.InfoPhone = phone; info.InfoEmail = email; info.InfoDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); info.InfoState = 1; info.InfoPayFor = 0; TBInfoService infoService = new TBInfoService(); int ok = infoService.AddTbInfo(info); if (ok > 0) lblMessage.Text = "<script> alert('发布成功'); </script>"; else lblMessage.Text = "<script> alert('发布失败'); </script>"; }
/// <summary> /// 得到最新的一条消息 /// </summary> /// <param name="payfor">付费状态</param> /// <param name="typeId">信息种类</param> /// <returns>查询得到的信息</returns> public TbInfo getLatestInfo(int payfor, int typeId) { string sql = "select top 1 tb_info.*, type_intro from tb_info inner join tb_type"+ " on tb_info.info_type = tb_type.id where info_payfor = " + payfor; if (typeId > 0) sql += "and info_type = " + typeId; sql += "order by id desc"; DataTable dt = DBHelper.GetDataTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; TbInfo info = new TbInfo(); info.Id = Convert.ToInt32(dr["id"]); info.InfoType = Convert.ToInt32(dr["info_type"]); info.InfoTitle = dr["info_title"].ToString(); info.InfoContent = dr["info_content"].ToString(); info.InfoContact = dr["info_linkman"].ToString(); info.InfoPhone = dr["info_phone"].ToString(); info.InfoEmail = dr["info_email"].ToString(); info.InfoDate = dr["info_date"].ToString(); info.InfoState = Convert.ToInt32(dr["info_state"]); info.InfoPayFor = Convert.ToInt32(dr["info_payfor"]); info.Tbtype.TypeIntro = dr["type_intro"].ToString(); return info; } return null; }
protected void btnOk_Click(object sender, EventArgs e) { string typeId = ddlTbType.SelectedValue; string title = txtTitle.Text; string infoContent = txtContent.Text; string phone = txtPhone.Text; string contact = txtContact.Text; string email = txtEmail.Text; TbInfo info = new TbInfo(); info.InfoType = Convert.ToInt32(typeId); info.InfoTitle = title; info.InfoContact = contact; info.InfoContent = infoContent; info.InfoPhone = phone; info.InfoEmail = email; info.Id = Convert.ToInt32(hfId.Value); TBInfoService infoService = new TBInfoService(); int ok = infoService.updateInfo(info); if (ok > 0) lblMessage.Text = "<script> alert('修改成功');location.href = '首页关键字检索.aspx'; </script>"; else lblMessage.Text = "<script> alert('修改失败'); </script>"; }
/// <summary> /// 插入数据 /// </summary> /// <param name="info">插入的数据</param> /// <returns>是否成功</returns> public int AddTbInfo(TbInfo info) { string sql = "insert into tb_info(info_type, info_title, info_content," + " info_linkman, info_phone, info_email, info_date, info_state, info_payfor)" + "values (@info_type, @info_title, @info_content, @info_linkman, @info_phone,"+ " @info_email, @info_date, @info_state, @info_payfor)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@info_type", info.InfoType), new SqlParameter("@info_title", info.InfoTitle), new SqlParameter("@info_content", info.InfoContent), new SqlParameter("@info_linkman", info.InfoContact), new SqlParameter("@info_phone", info.InfoPhone), new SqlParameter("@info_email", info.InfoEmail), new SqlParameter("@info_date", info.InfoDate), new SqlParameter("@info_state", info.InfoState), new SqlParameter("@info_payfor", info.InfoPayFor) }; return DBHelper.ExecuteCommand(sql, param); }
/// <summary> /// 按照信息类型和关键字搜索信息 /// </summary> /// <param name="typeId">信息类别</param> /// <param name="key">关键字</param> /// <returns>查询得到的信息</returns> public ArrayList getSearchInfo(int typeId, string key) { ArrayList list = new ArrayList(); string sql = "select tb_info.*, type_intro from tb_info inner join tb_type" + " on tb_info.info_type = tb_type.id where 1 = 1"; if (typeId > 0) sql += "and info_type = " + typeId; if (key != "") sql += "and info_title like '%" + key + "%'"; DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows) { TbInfo tb = new TbInfo(); tb.Id = Convert.ToInt32(dr["id"]); tb.InfoTitle = dr["info_title"].ToString(); tb.Tbtype.TypeIntro = dr["type_intro"].ToString(); tb.InfoDate = dr["info_date"].ToString(); tb.InfoContact = dr["info_linkman"].ToString(); list.Add(tb); } return list; }
/// <summary> /// 信息快速搜索 /// </summary> /// <param name="key">关键字</param> /// <param name="condition">查询条件(电话,标题……)</param> /// <param name="searchType">全字匹配还是模糊搜索</param> /// <returns></returns> public ArrayList SearchInfo(string key, string condition, int searchType) { string sql = string.Empty; ArrayList list = new ArrayList(); if (searchType == 0) sql = "select tb_info.*, type_intro from tb_info inner join tb_type" + " on tb_info.info_type = tb_type.id where " + condition + " = '"+ key + "'"; else sql = "select tb_info.*, type_intro from tb_info inner join tb_type" + " on tb_info.info_type = tb_type.id where " + condition +" like '%" + key + "%'"; DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows) { TbInfo tb = new TbInfo(); tb.Id = Convert.ToInt32(dr["id"]); tb.InfoTitle = dr["info_title"].ToString(); tb.Tbtype.TypeIntro = dr["type_intro"].ToString(); tb.InfoDate = dr["info_date"].ToString(); tb.InfoContact = dr["info_linkman"].ToString(); list.Add(tb); } return list; }
/// <summary> /// 修改信息 /// </summary> /// <param name="info">要修改的信息</param> /// <returns></returns> public int updateInfo(TbInfo info) { string sql = "update tb_info set info_type = @info_type, info_title = @info_title," + "info_content = @info_content, info_linkman = @info_linkman, info_phone = @info_phone," + " info_email = @info_email where id = @id"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@info_type", info.InfoType), new SqlParameter("@info_title", info.InfoTitle), new SqlParameter("@info_content", info.InfoContent), new SqlParameter("@info_linkman", info.InfoContact), new SqlParameter("@info_phone", info.InfoPhone), new SqlParameter("@info_email", info.InfoEmail), new SqlParameter("@id", info.Id) }; return DBHelper.ExecuteCommand(sql, param); }
/// <summary> /// 根据id查询数据 /// </summary> /// <param name="id">指定的id</param> /// <returns>查询到的数据</returns> public TbInfo getInfoById(int id) { TbInfo tb = new TbInfo(); string sql = "select tb_info.*, type_intro from tb_info inner join tb_type" + " on tb_info.info_type = tb_type.id where tb_info.id =" + id; DataTable dt = DBHelper.GetDataTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; tb.Id = Convert.ToInt32(dr["id"]); tb.Tbtype.TypeIntro = dr["type_intro"].ToString(); tb.InfoTitle = dr["info_title"].ToString(); tb.InfoDate = dr["info_date"].ToString(); tb.InfoContact = dr["info_linkman"].ToString(); tb.InfoContent = dr["info_content"].ToString(); tb.InfoPhone = dr["info_phone"].ToString(); tb.InfoEmail = dr["info_email"].ToString(); } return tb; }
/// <summary> /// 获取最新的五条免费信息,根据信息类别选择 /// </summary> /// <param name="typeId">信息类别</param> /// <returns></returns> public ArrayList getFreeInfo(int typeId) { ArrayList list = new ArrayList(); string sql = "select top 5 * from tb_info " + "where info_payfor = 0 and info_type = " + typeId + "order by id desc"; DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows) { TbInfo tb = new TbInfo(); tb.Id = Convert.ToInt32(dr["id"]); tb.InfoTitle = dr["info_title"].ToString(); //tb.Tbtype.TypeIntro = dr["type_intro"].ToString(); tb.InfoDate = dr["info_date"].ToString(); tb.InfoContact = dr["info_linkman"].ToString(); list.Add(tb); } return list; }
/// <summary> /// 首页付费信息查询 /// </summary> /// <returns>查询得到的信息</returns> public ArrayList getPayforInfo() { ArrayList list = new ArrayList(); string sql = "select top 8 tb_info.*, type_intro from tb_info inner join tb_type "+ "on tb_info.info_type = tb_type.id where info_payfor = 1 order by id desc"; DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows) { TbInfo tb = new TbInfo(); tb.Id = Convert.ToInt32(dr["id"]); tb.InfoTitle = dr["info_title"].ToString(); tb.Tbtype.TypeIntro = dr["type_intro"].ToString(); tb.InfoDate = dr["info_date"].ToString(); tb.InfoContact = dr["info_linkman"].ToString(); list.Add(tb); } return list; }