homeadminAddhomefen.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;
using System.Data.SqlClient;

public partial class adminAddhomefen : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd1, cmd2; //表示要对 SQL Server 数据库执行的一个 Transact-SQL 语句或存储过程。
    SqlDataReader dr;   //意思是把查询的结果DataReader对象赋值给对象reader.功能是为了实现某种数据操作功能,然后把它显示出来.

    protected void Page_Load(object sender, EventArgs e)
    {
        // 下载于www.51aspx.com
    }
    protected void enter_Click(object sender, EventArgs e)
    {
        conn = sqldata.createCon();
        conn.Open();
        int eareID = Convert.ToInt32(this.ddlEare.SelectedValue);
        int floodID = Convert.ToInt32(this.ddlFlood.SelectedValue);
        string homeNo = Convert.ToString(this.homeHao.Text);
        string sql1 = "select homeID from (eare inner join flood on eare.eareID=flood.eareID)inner join home on flood.floodID=home.floodID and eare.eareID=@eareID and flood.floodID=@floodID and homeNo=@homeNo";
        cmd1 = new SqlCommand(sql1, conn);
        SqlParameter id1 = new SqlParameter("@eareID", SqlDbType.Int, 4);
        SqlParameter id2 = new SqlParameter("@floodID", SqlDbType.Int, 4);
        SqlParameter id3 = new SqlParameter("@homeNo", SqlDbType.VarChar, 4);
        id1.Value = eareID;
        id2.Value = floodID;
        id3.Value = homeNo;
        cmd1.Parameters.Add(id1);
        cmd1.Parameters.Add(id2);
        cmd1.Parameters.Add(id3);
        dr = cmd1.ExecuteReader();
        int homeID = 0;
        if (dr.Read())
        {
            homeID = Convert.ToInt32(dr["homeID"].ToString());
            conn.Close();
            string homefen = Convert.ToString(this.homeFen.Text);
            conn.Open();
            string sql2 = "update home set homefen='" + homefen + "' where homeID='" + homeID + "'";
            cmd2 = new SqlCommand(sql2, conn);
            SqlParameter id4 = new SqlParameter("@homefen", SqlDbType.VarChar, 5);
            id4.Value = homefen;
            cmd2.Parameters.Add(id4);
            if (cmd2.ExecuteNonQuery() > 0)
            {
                ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "info", "alert('添加成功！');", true);
                this.homeHao.Text = "";
                this.homeFen.Text = "";
            }
            else