Hl.DataDalSql/BizItemPart/BizServiceInfoItemPartVirtual.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using Hl.Code;
namespace Hl.DataDalSql
{
    /// <summary>
    /// 服务业务信息-项目或配件[出单][DAL]  
    /// </summary>
    public class BizServiceInfoItemPartVirtual : DataDalInterface.BizServiceInfoItemPartVirtual
    {
        #region "访问"

        /// <summary>
        /// DbHelper
        /// </summary>
        private Hl.DataDbHelper.DbHelper DbHelper = Hl.DataDbHelper.DbUlitity.Instance();

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServiceInfoItemPartVirtual] ([ServiceId],[ServiceNo],[ServiceType],[ItemPartId],[ItemPartNo],[ItemPartName],[ItemPartTypeId],[ItemPartTypeNo],[ItemPartTypeName],[ItemPartPrice],[ItemPartCount],[ItemPartMoney],[ItemPartHours],[ItemPartRebateRate],[RepairManId],[RepairManNo],[ReceiverId],[ReceiverNo],[ReceiverDate],[CheckerId],[CheckerNo],[AdmTeamId],[AdmTeamNo],[StartDate],[CloseDate],[CreateDate],[UpdateDate],[OperatorId],[OperatorNo],[ConfirmFlag],[Serial],[Level],[Note],[Genre],[Status]) VALUES(@ServiceId,@ServiceNo,@ServiceType,@ItemPartId,@ItemPartNo,@ItemPartName,@ItemPartTypeId,@ItemPartTypeNo,@ItemPartTypeName,@ItemPartPrice,@ItemPartCount,@ItemPartMoney,@ItemPartHours,@ItemPartRebateRate,@RepairManId,@RepairManNo,@ReceiverId,@ReceiverNo,@ReceiverDate,@CheckerId,@CheckerNo,@AdmTeamId,@AdmTeamNo,@StartDate,@CloseDate,@CreateDate,@UpdateDate,@OperatorId,@OperatorNo,@ConfirmFlag,@Serial,@Level,@Note,@Genre,@Status) Select @@IDENTITY";

        /// <summary>
        /// 删除一条记录
        /// </summary>
        private const string DeleteCmdText = "DELETE [BizServiceInfoItemPartVirtual] Where [Id]=@Id";

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServiceInfoItemPartVirtual] SET [ServiceId]=@ServiceId,[ServiceNo]=@ServiceNo,[ServiceType]=@ServiceType,[ItemPartId]=@ItemPartId,[ItemPartNo]=@ItemPartNo,[ItemPartName]=@ItemPartName,[ItemPartTypeId]=@ItemPartTypeId,[ItemPartTypeNo]=@ItemPartTypeNo,[ItemPartTypeName]=@ItemPartTypeName,[ItemPartPrice]=@ItemPartPrice,[ItemPartCount]=@ItemPartCount,[ItemPartMoney]=@ItemPartMoney,[ItemPartHours]=@ItemPartHours,[ItemPartRebateRate]=@ItemPartRebateRate,[RepairManId]=@RepairManId,[RepairManNo]=@RepairManNo,[ReceiverId]=@ReceiverId,[ReceiverNo]=@ReceiverNo,[ReceiverDate]=@ReceiverDate,[CheckerId]=@CheckerId,[CheckerNo]=@CheckerNo,[AdmTeamId]=@AdmTeamId,[AdmTeamNo]=@AdmTeamNo,[StartDate]=@StartDate,[CloseDate]=@CloseDate,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[OperatorId]=@OperatorId,[OperatorNo]=@OperatorNo,[ConfirmFlag]=@ConfirmFlag,[Serial]=@Serial,[Level]=@Level,[Note]=@Note,[Genre]=@Genre,[Status]=@Status WHERE [Id]=@Id";

        /// <summary>
        /// 查询一条记录
        /// </summary>
        private const string SelectCmdText = "SELECT * FROM [BizServiceInfoItemPartVirtual] WHERE [Id]=@Id";

        #endregion

        #region "参数"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private IDbDataParameter[] InsertParameters()
        {
            IDbDataParameter[] paramlist = (IDbDataParameter[])Hl.DataDbHelper.DbUlitity.GetCacheParameters(InsertCmdText);
            if (paramlist == null)
            {
                paramlist = new SqlParameter[]{
                    new SqlParameter("@ServiceId",SqlDbType.Int,4),
                    new SqlParameter("@ServiceNo",SqlDbType.NVarChar,50),
                    new SqlParameter("@ServiceType",SqlDbType.Int,4),