addhomereport.aspx.cs

后台管理模块有：小区管理、设备管理、楼盘管理、收费管理、停车管理、用户管理 小区基本信息 添加周边设施 编辑周边设施 添加公告 编辑公告 楼盘信息添加 编辑楼盘信息 房产信息添加 房产信息查

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class addhomerepair : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();//定义一个公共类的实例
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Convert.ToString(Session["code"]) == "")
        {
            Response.Redirect("../login.aspx");

        }
            
       
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {

  　　　string Id = Convert.ToString(Session["code"]);//用户编号
        string repairtitle = txttitle.Text.Trim() ;//报修标题
        string repairdate = selectdate.Text;//日期
        string repairMemo = FreeTextBox1.Text;//详细内容




        string valsql = "select count(*) from homereport where reportText='" + txttitle.Text.Trim() + "' and code='" + Session["code"].ToString()+"'" ;

        int count = (int)bc.ExecCscalar(valsql);
        if (count > 0)
        {
            Response.Write("<script>alert('已有此投诉');</script>");
            return;
        }




        string sqlstr = "insert into homeReport(code,reportDate,reportText,sign,reportMemo) values('";
        sqlstr = sqlstr + Id + "','" + repairdate + "','" + repairtitle + "',0,'" + repairMemo + "')";
        //Response.Write(sqlstr);
        //Response.End();

        if (bc.ExecSql(sqlstr))
        {
            Response.Write("<script>alert('投诉信息添加成功！');location='homereport.aspx';</script>");
        }
        else
        {
            Response.Write("<script>alert('添加失败！');</script>");
        }

        bc.Closeconn();//关闭数据库连接
        
    }
}