admin/zulin1.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class admin_zulin1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string id = Request.QueryString["id"].ToString().Trim();
        string bianhao = Request.QueryString["bianhao"].ToString().Trim();
        string xuehao = Request.QueryString["xuehao"].ToString().Trim();
        string yajin = this.TextBox1.Text;

        try
        {
            int.Parse(yajin);
        }
        catch (Exception) 
        {
            Response.Write("<script>javascript:alert('押金必须是整数');</script>");
            return;
        }
        string strsql = "delete from yuyue where id=" + id + "";
        strsql += " Insert into zulin(bianhao,xuehao,yajin)values('" + bianhao + "','" + xuehao + "'," + yajin + ")";
        strsql += " Update diandongche set zhuangtai='租赁中' where bianhao='" + bianhao + "'";
        int result;
        sqlConn conn = new sqlConn();
        result = conn.hsgexucute(strsql);
        if (result>0)
        {
            Response.Write("<script language=javascript>alert('租赁成功！');location='zulin.aspx'</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('租赁失败');</script>");
        }
    }
}