DAL/editable/tbRoomRecord.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;
using System.Data.SqlClient;
namespace DAL
{
    /// <summary>
    /// 数据访问类 tbRoomRecord
    /// <summary>
    public partial class tbRoomRecord : DALHelper
    {

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.tbRoomRecord model)
        {
            string strAdd = "INSERT INTO tbRoomRecord(R_ID,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_Deposit, RR_StartTime, RR_EndTime, RR_Remark, RR_AddTime, U_Account, H_Account) VALUES (@in_R_ID,@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_Deposit, @in_RR_StartTime, @in_RR_EndTime, @in_RR_Remark, @in_RR_AddTime, @in_U_Account, @in_H_Account)";

            IDbDataParameter[] parms4tbRoomRecord = PrepareAddParameters(model);
            return dbHelper.ExecuteNonQuery(CommandType.Text, strAdd, parms4tbRoomRecord);
        }
        /// <summary>
        /// 增加一条数据,带事务
        /// </summary>
        private int Add(IDbTransaction trans,Model.tbRoomRecord model)
        {
            string strAdd = "INSERT INTO tbRoomRecord(R_ID,RT_ID, 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_Deposit, RR_StartTime, RR_EndTime, RR_Remark, RR_AddTime, U_Account, H_Account) VALUES (@in_R_ID,@in_RT_ID, @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_Deposit, @in_RR_StartTime, @in_RR_EndTime, @in_RR_Remark, @in_RR_AddTime, @in_U_Account, @in_H_Account)";

            IDbDataParameter[] parms4tbRoomRecord = PrepareAddParameters(model);
            return dbHelper.ExecuteNonQuery(trans,CommandType.Text, strAdd, parms4tbRoomRecord);
        }
        /// <summary>
        /// 增加数据
        /// </summary>
        public void Add(List<Model.tbRoomRecord> listModel)
        {
            using (SqlConnection con = new SqlConnection(dbHelper.ConnectionString))
            {
                con.Open();//打开连接
                SqlTransaction trans = con.BeginTransaction();//开始事务
                try
                {
                    for (int i = 0; i < listModel.Count; i++)
                    {
                        string strAdd = "INSERT INTO tbRoomRecord(R_ID,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_Deposit, RR_StartTime, RR_EndTime, RR_Remark, RR_AddTime, U_Account, H_Account) VALUES (@in_R_ID,@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_Deposit, @in_RR_StartTime, @in_RR_EndTime, @in_RR_Remark, @in_RR_AddTime, @in_U_Account, @in_H_Account)";

                        IDbDataParameter[] parms4tbRoomRecord = PrepareAddParameters(listModel[i]);
                        dbHelper.ExecuteNonQuery(trans, CommandType.Text, strAdd, parms4tbRoomRecord);
                    }

                    string strSql = "UPDATE tbRoom SET RS_ID=@in_RS_ID WHERE R_ID=@in_R_ID";
                    IDbDataParameter[] parms = DBUtility.DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, strSql);
                    if (parms == null)
                    {
                        parms = new IDbDataParameter[]{
                    dbHelper.CreateDbParameter("@in_RS_ID", DbType.Int32, ParameterDirection.Input),
                    dbHelper.CreateDbParameter("@in_R_ID", DbType.Int32, ParameterDirection.Input)};