addhomerepair.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");

        }
        else
        {
            DataSet ds = null;
            int p_int_newCode = 0;
            string P_string_newcode = "";
            ds = bc.ExecDS("select * from homerepair order by ID");
            if (ds.Tables[0].Rows.Count == 0)
            {
                labID.Text = DateTime.Now.ToString("yyyy-MM-dd") + "BX100001";
            }
            else
            {
                //   Response.Write(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["fixID"]) ;
                // Response.End();


                P_string_newcode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["ID"]);
                //  Response.Write(P_string_newcode);
                //Response.End();
                p_int_newCode = Convert.ToInt32(P_string_newcode.Substring(12, 6)) + 1;

                P_string_newcode = DateTime.Now.ToString("yyyy-MM-dd") + "BX" + p_int_newCode.ToString();
                labID.Text = P_string_newcode;
            }
        }
            
      
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {


        string valsql = "select count(*) from homerepair where repairText='" + txttitle.Text + "' and code='" + Session["code"].ToString()+"'" ;
      //  Response.Write(valsql);
      //  Response.End();
        int count = (int)bc.ExecCscalar(valsql);
        if (count > 0)
        {
            Response.Write("<script>alert('你已提交过相同的报修服务');location='homerepair.aspx';</script>");
            return;
        }




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



        string sqlstr = "insert into homeRepair(ID,code,repairDate,repairText,sign,repairMemo) values('";
        sqlstr = sqlstr +repairID+"','"+ Id + "','" + repairdate + "','" + repairtitle + "',0,'" + repairMemo + "')";
      //  Response.Write(sqlstr);
      //  Response.End();

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

        bc.Closeconn();
        
    }
}