Hl.DataDalSql/BizHistory/BizServiceInfoHistory.cs

（开头部分） 36KB

这里只显示每个文件的开头 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 BizServiceInfoHistory : DataDalInterface.BizServiceInfoHistory
    {
        #region "访问"

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServiceInfoHistory] ([ServiceId],[ServiceNo],[VehicleId],[VehicleNo],[LinkManId],[LinkManNo],[DateQuotation],[DateEnterPlan],[DateEnter],[DateOutPlan],[DateOut],[FinalCheckUserId],[FinalCheckUserNo],[FinalCheckDate],[FinalCheckNote],[OutStockCheckUserId],[OutStockCheckUserNo],[OutStockCheckDate],[RepairCheckUserId],[RepairCheckUserNo],[RepairCheckDate],[RepairCheckNote],[BillCheckUserId],[BillCheckUserNo],[BillCheckDate],[BillCheckNote],[InsuranceCompanyId],[InsuranceCompanyNo],[DispatchReportFlag],[DispatchReportNote],[AdvisorAssistantId],[AdvisorAssistantNo],[AdvisorServiceId],[AdvisorServiceNo],[MileageBeforeEnter],[OilMassBeforeEnter],[ItemsRebateRate],[PaintRebateRate],[PartsRebateRate],[ItemsRebateRateVirtual],[PaintRebateRateVirtual],[PartsRebateRateVirtual],[AllowanceMoney],[AllowanceNote],[AllowanceMoneyVirtual],[ManageFee],[BusinessCost],[PreTakefee],[PreTakeNote],[InvoiceAmount],[InvoiceAmountFax],[SettleMoney],[SettleMoneyVirtual],[PreSettleNote],[QuoterId],[QuoterNo],[OperatorId],[OperatorNo],[InvoiceTaxRateReal],[InvoiceTaxRateFlag],[RepairStyle],[ServiceType],[ServiceNote],[VirtualBillFlag],[ArchiveUndo],[ServiceConfirm],[ServiceStatus],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@ServiceId,@ServiceNo,@VehicleId,@VehicleNo,@LinkManId,@LinkManNo,@DateQuotation,@DateEnterPlan,@DateEnter,@DateOutPlan,@DateOut,@FinalCheckUserId,@FinalCheckUserNo,@FinalCheckDate,@FinalCheckNote,@OutStockCheckUserId,@OutStockCheckUserNo,@OutStockCheckDate,@RepairCheckUserId,@RepairCheckUserNo,@RepairCheckDate,@RepairCheckNote,@BillCheckUserId,@BillCheckUserNo,@BillCheckDate,@BillCheckNote,@InsuranceCompanyId,@InsuranceCompanyNo,@DispatchReportFlag,@DispatchReportNote,@AdvisorAssistantId,@AdvisorAssistantNo,@AdvisorServiceId,@AdvisorServiceNo,@MileageBeforeEnter,@OilMassBeforeEnter,@ItemsRebateRate,@PaintRebateRate,@PartsRebateRate,@ItemsRebateRateVirtual,@PaintRebateRateVirtual,@PartsRebateRateVirtual,@AllowanceMoney,@AllowanceNote,@AllowanceMoneyVirtual,@ManageFee,@BusinessCost,@PreTakefee,@PreTakeNote,@InvoiceAmount,@InvoiceAmountFax,@SettleMoney,@SettleMoneyVirtual,@PreSettleNote,@QuoterId,@QuoterNo,@OperatorId,@OperatorNo,@InvoiceTaxRateReal,@InvoiceTaxRateFlag,@RepairStyle,@ServiceType,@ServiceNote,@VirtualBillFlag,@ArchiveUndo,@ServiceConfirm,@ServiceStatus,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServiceInfoHistory] SET [ServiceId]=@ServiceId,[ServiceNo]=@ServiceNo,[VehicleId]=@VehicleId,[VehicleNo]=@VehicleNo,[LinkManId]=@LinkManId,[LinkManNo]=@LinkManNo,[DateQuotation]=@DateQuotation,[DateEnterPlan]=@DateEnterPlan,[DateEnter]=@DateEnter,[DateOutPlan]=@DateOutPlan,[DateOut]=@DateOut,[FinalCheckUserId]=@FinalCheckUserId,[FinalCheckUserNo]=@FinalCheckUserNo,[FinalCheckDate]=@FinalCheckDate,[FinalCheckNote]=@FinalCheckNote,[OutStockCheckUserId]=@OutStockCheckUserId,[OutStockCheckUserNo]=@OutStockCheckUserNo,[OutStockCheckDate]=@OutStockCheckDate,[RepairCheckUserId]=@RepairCheckUserId,[RepairCheckUserNo]=@RepairCheckUserNo,[RepairCheckDate]=@RepairCheckDate,[RepairCheckNote]=@RepairCheckNote,[BillCheckUserId]=@BillCheckUserId,[BillCheckUserNo]=@BillCheckUserNo,[BillCheckDate]=@BillCheckDate,[BillCheckNote]=@BillCheckNote,[InsuranceCompanyId]=@InsuranceCompanyId,[InsuranceCompanyNo]=@InsuranceCompanyNo,[DispatchReportFlag]=@DispatchReportFlag,[DispatchReportNote]=@DispatchReportNote,[AdvisorAssistantId]=@AdvisorAssistantId,[AdvisorAssistantNo]=@AdvisorAssistantNo,[AdvisorServiceId]=@AdvisorServiceId,[AdvisorServiceNo]=@AdvisorServiceNo,[MileageBeforeEnter]=@MileageBeforeEnter,[OilMassBeforeEnter]=@OilMassBeforeEnter,[ItemsRebateRate]=@ItemsRebateRate,[PaintRebateRate]=@PaintRebateRate,[PartsRebateRate]=@PartsRebateRate,[ItemsRebateRateVirtual]=@ItemsRebateRateVirtual,[PaintRebateRateVirtual]=@PaintRebateRateVirtual,[PartsRebateRateVirtual]=@PartsRebateRateVirtual,[AllowanceMoney]=@AllowanceMoney,[AllowanceNote]=@AllowanceNote,[AllowanceMoneyVirtual]=@AllowanceMoneyVirtual,[ManageFee]=@ManageFee,[BusinessCost]=@BusinessCost,[PreTakefee]=@PreTakefee,[PreTakeNote]=@PreTakeNote,[InvoiceAmount]=@InvoiceAmount,[InvoiceAmountFax]=@InvoiceAmountFax,[SettleMoney]=@SettleMoney,[SettleMoneyVirtual]=@SettleMoneyVirtual,[PreSettleNote]=@PreSettleNote,[QuoterId]=@QuoterId,[QuoterNo]=@QuoterNo,[OperatorId]=@OperatorId,[OperatorNo]=@OperatorNo,[InvoiceTaxRateReal]=@InvoiceTaxRateReal,[InvoiceTaxRateFlag]=@InvoiceTaxRateFlag,[RepairStyle]=@RepairStyle,[ServiceType]=@ServiceType,[ServiceNote]=@ServiceNote,[VirtualBillFlag]=@VirtualBillFlag,[ArchiveUndo]=@ArchiveUndo,[ServiceConfirm]=@ServiceConfirm,[ServiceStatus]=@ServiceStatus,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

        /// <summary>
        /// 查询一条记录
        /// </summary>
        private const string SelectCmdText = "SELECT * FROM [BizServiceInfoHistory] 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("@VehicleId",SqlDbType.Int,4),
后面还有 535 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。