?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 RegisterDAL
    {
        public int InsertRegister(RegisterInfo entity)
        {
            DateTime dt = DateTime.Now;
            string num = dt.ToString("yyyyMMdd");
            string RegisterID = SQLHelper.GetMaxOrder("Register");
            //maxorder存放最大號
            string maxorder = num + RegisterID;
            string sql = "insert into Register values('" + maxorder + "','" + maxorder + "','" + entity.PatientInfo.PatientName + "','" + entity.CureType + "',convert(money,'" + entity.OfficeInfo.CureCost + "'),'" + entity.RegisterTypeInfo.RegisterTypeName + "',convert(money,'" + entity.RegisterTypeInfo.RegisterTypeCost + "'),'" + entity.OfficeInfo.OfficeName + "','" + entity.DoctorInfo.DoctorName + "','" + entity.OperateDate + "','" + entity.Operator + "')";
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public DataSet SelectRegister()
        {
            string sql = "select * from View_Register";
            return SQLHelper.Select(sql);
        }

        public DataSet Select(OfficeInfo entity1, RegisterTypeInfo entity2)
        {
            string sql = "select * from View_Register where 科室名稱='" + entity1.OfficeName + "'and 掛號名稱='"+entity2.RegisterTypeName+"'";
            return SQLHelper.Select(sql);
        }

        public DataSet SelectRegisterID(long id)
        {
            string sql = "select * from View_Register where 掛號編號>=" + id;
            return SQLHelper.Select(sql);
        }

        public DataSet SelectRegisterIDToo(long id)
        {
            string sql = "select * from View_Register where 掛號編號<=" + id;
            return SQLHelper.Select(sql);
        }

        public DataSet SelectRegisterTodayID(string OperateDate)
        {
            string sql = "select RegisterID from Register where OperateDate='" + OperateDate + "'";
            return SQLHelper.Select(sql);
        }
    }
}