手动用三层写医院随访添加信息内容

UI表现层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebSuifang
{
    public partial class WebAdd : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
          
        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            MODEL.a addmoder = new MODEL.a();
            addmoder.Name = txtName.Text;
            addmoder.Age = Convert.ToInt32(txtAge.Text);
            addmoder.Sex = txtSex.Text;
            addmoder.Adress = txtAddress.Text;
            addmoder.Height = Convert.ToInt32(txtHeight.Text);
            addmoder.Weights = Convert.ToInt32(txtWeight.Text);
            addmoder.Hblood = Convert.ToInt32(txtBloodPressure1.Text);
            addmoder.Fblood = Convert.ToInt32(txtBloodPressure2.Text);
            addmoder.Datetimes = Convert.ToDateTime(txtExamineTime.Text);
            addmoder.Nexttime = Convert.ToDateTime(txtNextTime.Text);
            BLL.a bll = new BLL.a();
            if (bll.Add(addmoder) > 0)
            {
                lblInfo.Text = "成功";
            }
            else
            {
                lblInfo.Text = "失败";
            }
        }
    }
}

 

BLL逻辑层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLL
{
    public class a
    {
        private readonly DAL.a dal = new DAL.a();
        public int Add(MODEL.a suifang)
        {
            return dal.Add(suifang);
        }
    }
}
DAL数据访问层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using WebSuifang.DataAccess;

namespace DAL
{
   public class a
    {
       public int Add(MODEL.a suifang)
       {
           StringBuilder sb1 = new StringBuilder();
           sb1.Append("insert into T_Websuifang");
           sb1.Append("(");
           sb1.Append("name,age,sex,adress,height,weights,hblood,fblood,datetimes,nexttime");
           sb1.Append(")");
           sb1.Append("values");
           sb1.Append("(");
           sb1.Append("@name,@age,@sex,@adress,@height,@weights,@hblood,@fblood,@datetimes,@nexttime");
           sb1.Append(")");
           SqlParameter[] param ={
                              new SqlParameter("@name",SqlDbType.VarChar),
                              new SqlParameter("@age",SqlDbType.Int),
                              new SqlParameter("@sex",SqlDbType.VarChar),
                              new SqlParameter("@adress",SqlDbType.VarChar),
                              new SqlParameter("@height",SqlDbType.Int),
                              new SqlParameter("@weights",SqlDbType.Int),
                              new SqlParameter("@hblood",SqlDbType.Int),
                              new SqlParameter("@fblood",SqlDbType.Int),
                              new SqlParameter("@datetimes",SqlDbType.Date),
                              new SqlParameter("@nexttime",SqlDbType.Date)
                              };
           param[0].Value = suifang.Name;
           param[1].Value = suifang.Age;
           param[2].Value = suifang.Sex;
           param[3].Value = suifang.Adress;
           param[4].Value = suifang.Height;
           param[5].Value = suifang.Weights;
           param[6].Value = suifang.Hblood;
           param[7].Value = suifang.Fblood;
           param[8].Value = suifang.Datetimes;
           param[9].Value = suifang.Nexttime;
           int rows = DbHelperSQL.ExecuteSql(sb1.ToString(), param);
           return rows;
       }
    }
}
DataAccess层中DbHelperSQL.cs代码

  public static int ExecuteSql(string SQLString, params SqlParameter[] cmdParms)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    try
                    {
                        //1)将数据库连接对象赋给cmd对象的connection属性（cmd.Connection=connection）
                        //2）将sql语句(SQLString)赋给cmd对象的CommandText属性(cmd.CommandText=SQLString)
                        //3)遍历参数数组(cmdParms),将每一个参数添加到cmd的Paramenters集合中
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        int rows = cmd.ExecuteNonQuery();
                        cmd.Parameters.Clear();
                        return rows;
                    }
                    catch (System.Data.SqlClient.SqlException e)
                    {
                        throw e;
                    }
                }
            }
        }

MODEL层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MODEL
{
   public class a
    {
        private int id;

        public int Id
        {
            get { return id; }
            set { id = value; }
        }
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        private int age;

        public int Age
        {
            get { return age; }
            set { age = value; }
        }
        private string sex;

        public string Sex
        {
            get { return sex; }
            set { sex = value; }
        }
        private string adress;

        public string Adress
        {
            get { return adress; }
            set { adress = value; }
        }
        private int height;

        public int Height
        {
            get { return height; }
            set { height = value; }
        }
        private int weights;

        public int Weights
        {
            get { return weights; }
            set { weights = value; }
        }
        private int hblood;

        public int Hblood
        {
            get { return hblood; }
            set { hblood = value; }
        }
        private int fblood;

        public int Fblood
        {
            get { return fblood; }
            set { fblood = value; }
        }
        private DateTime datetimes;

        public DateTime Datetimes
        {
            get { return datetimes; }
            set { datetimes = value; }
        }
        private DateTime nexttime;

        public DateTime Nexttime
        {
            get { return nexttime; }
            set { nexttime = value; }
        }
    }
}