Admin/tuifang.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_tuifang : System.Web.UI.Page
{
    SqlHelper insert = new SqlHelper();
    Alert js = new Alert();
    protected void Page_Load(object sender, EventArgs e)
    {
        string bianhao = Request.QueryString["bianhao"].ToString();
        string xiaofei = Request.QueryString["shijifeiyong"].ToString();
        string strsql = "Update ruzhu set Flag='已退房',zongxiaofei="+xiaofei+"  where bianhao='" + bianhao + "' and Flag='已入住'";
        strsql += " Update kefang set Flag='空闲' where bianhao='" + bianhao + "'";
        insert.RunSql(strsql);
        Alert.AlertAndRedirect("退房成功", "kefangtuifang.aspx");
    }
}