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("发布成功");
}
