public bool AddGuaHaoInfo(GuaHaoModel guaHaoModel) { if (guaHaoModel.getName().Equals("")) { this.errMessage = "病人姓名输入不能为空!"; return(false); } string sqlString = "insert into [t_guahao] (name,sex,age,subjectId,operateTime,operator) values ("; sqlString += SqlString.GetQuotedString(guaHaoModel.getName()) + ","; sqlString += SqlString.GetQuotedString(guaHaoModel.getSex()) + ","; sqlString += guaHaoModel.getAge() + ","; sqlString += guaHaoModel.getSubjectId() + ",'"; sqlString += guaHaoModel.getOperateTime() + "',"; sqlString += SqlString.GetQuotedString(guaHaoModel.getOperator()) + ")"; DataBase db = new DataBase(); if (db.InsertOrUpdate(sqlString) <= 0) { this.errMessage = "向数据库中加入挂号信息发生了错误!"; return(false); } return(true); }
protected void Btn_GuaHao_Click(object sender, EventArgs e) { GuaHaoModel guaHaoModel = new GuaHaoModel(); guaHaoModel.setName(this.Name.Text); guaHaoModel.setSex(this.Sex.SelectedValue); guaHaoModel.setAge(Int32.Parse(this.Age.Text)); guaHaoModel.setSubjectId(Int32.Parse(this.SubjectId.SelectedValue)); guaHaoModel.setOperator(Session["username"].ToString()); GuaHaoLogic guahaoLogic = new GuaHaoLogic(); if (guahaoLogic.AddGuaHaoInfo(guaHaoModel)) { Response.Write("<script>alert('挂号成功!');location.href='GuaHaoAdd.aspx';</script>"); } }