protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = Request.QueryString["id"]; if (string.IsNullOrEmpty(id)) { this.ShowAlert("未传入有效的预约号", "OrderInfo.aspx"); return; } var data = Sql.Query <TeacherORDER>("id=@id", new System.Data.IDbDataParameter[] { Sql.CreateParameter("@id", id.AsInt()) }).FirstOrDefault(); if (data == null) { this.ShowAlert("未查询到预约信息,无法预约", "OrderInfo.aspx"); return; } if (data.yyzt != "已预约") { this.ShowAlert("状态不是已预约,无法操作", "OrderInfo.aspx"); return; } data.yyzt = "已完成"; Sql.Edit(data); this.ShowAlert("成功完成预约", "OrderInfo.aspx"); } }
protected void btnChangeClicked(object sender, EventArgs e) { string id = Request.QueryString["id"]; var pp = new System.Data.IDbDataParameter[2]; pp[0] = Sql.CreateParameter("@id", id); pp[1] = Sql.CreateParameter("@stu_code", Session["login_code"].AsString()); var data = Sql.Query <StuAsk>("id=@id and stu_code=@stu_code", pp).FirstOrDefault(); if (data == null) { this.ShowAlert("问题信息不存在", "Default.aspx"); return; } data.title = title.Text; data.content = content.Text; data.catagory = catagory.Text; //保存图片START string url = "/Upload/Photo/"; string fileName = FileUpload1.SaveFile(Server.MapPath(url)); if (!string.IsNullOrEmpty(fileName)) { data.imageUrl = url + fileName; } Sql.Edit(data); this.ShowAlert("保存成功", "StuAskCenter.aspx"); }
protected void btnChangeClicked(object sender, EventArgs e) { string code = Request.QueryString["code"]; var pp = new System.Data.IDbDataParameter[1]; pp[0] = Sql.CreateParameter("@code", code); var data = Sql.Query <AdminInfo>("code=@code", pp).FirstOrDefault(); if (data == null) { this.ShowAlert("用户信息不存在", "Default.aspx"); return; } data.name = name.Text; data.lxfs = lxfs.Text; //保存图片START string url = "/Upload/Photo/"; string fileName = FileUpload1.SaveFile(Server.MapPath(url)); if (!string.IsNullOrEmpty(fileName)) { data.photoUrl = url + fileName; } //保存图片END Sql.Edit(data); //重新设置缓存信息 Session["login_photo"] = data.photoUrl; Session["login_name"] = data.name; this.ShowAlert("修改信息成功", "ProfileInfo.aspx"); }
protected void btnConfirmClicked(object sender, EventArgs e) { string code = Session["login_code"].AsString(); var pp = new System.Data.IDbDataParameter[1]; pp[0] = Sql.CreateParameter("@code", code); var data = Sql.Query <StuInfo>("code=@code", pp).FirstOrDefault(); if (data == null) { this.ShowAlert("学生信息不存在", "Default.aspx"); return; } data.needs = needs.Text; data.pubDate = DateTime.Now; Sql.Edit(data); this.ShowAlert("发布成功"); }