?? registerdal.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 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);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -