DAL/internal/tbRoomRecord.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;
using DBUtility;

namespace DAL
{
    /// <summary>
    /// 数据访问类 tbRoomRecord ，此类请勿动，以方便表字段更改时重新生成覆盖
    /// </summary>
    public partial class tbRoomRecord
    {
        internal const string COMMAND_ADD = "INSERT INTO tbRoomRecord(RT_ID, RT_Name, R_Level, R_BedNumber, R_RoomID, R_Price, R_Computer, R_Tel, R_AirConditioning, R_Bath, RR_Name, RR_Sex, RR_Age, CT_ID, RR_CredentialsID, RR_Payment, RR_RealMoney, RR_Discount, RR_Deposit, RR_StartTime, RR_EndTime, RR_Remark, RR_AddTime, U_Account, H_Account) VALUES (@in_RT_ID, @in_RT_Name, @in_R_Level, @in_R_BedNumber, @in_R_RoomID, @in_R_Price, @in_R_Computer, @in_R_Tel, @in_R_AirConditioning, @in_R_Bath, @in_RR_Name, @in_RR_Sex, @in_RR_Age, @in_CT_ID, @in_RR_CredentialsID, @in_RR_Payment, @in_RR_RealMoney, @in_RR_Discount, @in_RR_Deposit, @in_RR_StartTime, @in_RR_EndTime, @in_RR_Remark, @in_RR_AddTime, @in_U_Account, @in_H_Account)";
        internal const string COMMAND_UPDATE = "UPDATE tbRoomRecord SET RT_ID=@in_RT_ID, RT_Name=@in_RT_Name, R_Level=@in_R_Level, R_BedNumber=@in_R_BedNumber, R_RoomID=@in_R_RoomID, R_Price=@in_R_Price, R_Computer=@in_R_Computer, R_Tel=@in_R_Tel, R_AirConditioning=@in_R_AirConditioning, R_Bath=@in_R_Bath, RR_Name=@in_RR_Name, RR_Sex=@in_RR_Sex, RR_Age=@in_RR_Age, CT_ID=@in_CT_ID, RR_CredentialsID=@in_RR_CredentialsID, RR_Payment=@in_RR_Payment, RR_RealMoney=@in_RR_RealMoney, RR_Discount=@in_RR_Discount, RR_Deposit=@in_RR_Deposit, RR_StartTime=@in_RR_StartTime, RR_EndTime=@in_RR_EndTime, RR_Remark=@in_RR_Remark, RR_AddTime=@in_RR_AddTime, U_Account=@in_U_Account, H_Account=@in_H_Account WHERE R_ID=@in_R_ID";
        internal const string COMMAND_DELETE = "DELETE FROM tbRoomRecord WHERE R_ID=@in_R_ID";
        internal const string COMMAND_EXISTS = "SELECT COUNT(1) FROM tbRoomRecord WHERE R_ID=@in_R_ID";
        internal const string COMMAND_GETMODEL = "SELECT * FROM tbRoomRecord WHERE R_ID=@in_R_ID";
        internal const string COMMAND_GETCOUNT = "SELECT COUNT(*) FROM tbRoomRecord";
        internal const string COMMAND_GETLIST = "SELECT * FROM tbRoomRecord";

        internal const string PARM_R_ID = "@in_R_ID";
        internal const string PARM_RT_ID = "@in_RT_ID";
        internal const string PARM_RT_NAME = "@in_RT_Name";
        internal const string PARM_R_LEVEL = "@in_R_Level";
        internal const string PARM_R_BEDNUMBER = "@in_R_BedNumber";
        internal const string PARM_R_ROOMID = "@in_R_RoomID";
        internal const string PARM_R_PRICE = "@in_R_Price";
        internal const string PARM_R_COMPUTER = "@in_R_Computer";
        internal const string PARM_R_TEL = "@in_R_Tel";
        internal const string PARM_R_AIRCONDITIONING = "@in_R_AirConditioning";
        internal const string PARM_R_BATH = "@in_R_Bath";
        internal const string PARM_RR_NAME = "@in_RR_Name";
        internal const string PARM_RR_SEX = "@in_RR_Sex";
        internal const string PARM_RR_AGE = "@in_RR_Age";
        internal const string PARM_CT_ID = "@in_CT_ID";
        internal const string PARM_RR_CREDENTIALSID = "@in_RR_CredentialsID";
        internal const string PARM_RR_PAYMENT = "@in_RR_Payment";
        internal const string PARM_RR_REALMONEY = "@in_RR_RealMoney";
        internal const string PARM_RR_DISCOUNT = "@in_RR_Discount";
        internal const string PARM_RR_DEPOSIT = "@in_RR_Deposit";
        internal const string PARM_RR_STARTTIME = "@in_RR_StartTime";
        internal const string PARM_RR_ENDTIME = "@in_RR_EndTime";
        internal const string PARM_RR_REMARK = "@in_RR_Remark";
        internal const string PARM_RR_ADDTIME = "@in_RR_AddTime";
        internal const string PARM_U_ACCOUNT = "@in_U_Account";
        internal const string PARM_H_ACCOUNT = "@in_H_Account";

        /// <summary>
        /// 为新增一条数据准备参数
        /// </summary>
        internal static IDbDataParameter[] PrepareAddParameters(Model.tbRoomRecord model)
        {
            IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_ADD);
            if (parms == null)
            {
                parms = new IDbDataParameter[]{
                    dbHelper.CreateDbParameter(PARM_R_ID, DbType.Int32, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_RT_ID, DbType.Int32, ParameterDirection.Input),