officedal.cs

不错的一个做的医院管理系统源码

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Youzi.Model;
using Youzi.DBUtility;

namespace Youzi.DAL
{
    public class OfficeDAL
    {
        public DataSet SelectALL()
        {
            string sql = "select * from View_Office";
            return SQLHelper.SelectAll(sql);
        }

        public SqlDataReader Select(string OfficeName)
        {
            string sql = "select * from Office where OfficeName='" + OfficeName + "'";
            return SQLHelper.ExecuteDataQuery(sql);
        }

        public int Insert(OfficeInfo entity)
        {
            string sql = "insert into Office values('" + entity.OfficeName + "','" + entity.Director + "',convert(money,'" + entity.CureCost + "'),'" + entity.OperateDate + "','" + entity.Operator + "')";
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public int Delete(int id)
        {
            string sql = "delete from Office where OfficeID=" + id;
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public int Update(OfficeInfo entity)
        {
            string sql = "update Office set OfficeName='" + entity.OfficeName + "',Director='" + entity.Director + "',CureCost=convert(money,'" + entity.CureCost + "')where OfficeID='" + entity.OfficeID + "'";
            return SQLHelper.ExecuteNonQuery(sql);
        }
    }
}