Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
    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>");
        }
    }