Hl.DataDalSql/BizMarketing/BizMarketDataVehicleInfoInsurance.cs

（开头部分） 33KB

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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizMarketDataVehicleInfoInsurance] ([CustomerId],[CustomerNo],[FileNumber],[VehicleNo],[BrandId],[BrandNo],[VtypeId],[VtypeNo],[Source],[ChassisNumber],[EngineNumber],[LicenceDate],[RegisterDate],[ProductiveYear],[PassengerCapacity],[UseNature],[StandardLoad],[PurchasePrice],[VehicleColor],[VehicleStyle],[VehicleArea],[HistoryInsuranceList],[YearAverageMileage],[InsuranceCompanyId],[InsuranceCompanyNo],[InsuranceDateStart],[InsuranceDateClose],[MaintainDateStart],[MaintainDateClose],[MaintainMileage],[VechicleNote],[VehicleStatus],[ServiceAdvisorUserId],[ServiceAdvisorUserNo],[TelephoneTrackerId],[TelephoneTrackerNo],[TelephoneTrackLastDate],[TelephoneTrackFlag],[TelephoneJointerId],[TelephoneJointerNo],[InsuranceTrackerId],[InsuranceTrackerNo],[InsuranceTrackLastDate],[InsuranceTrackFlag],[InsuranceJointerId],[InsuranceJointerNo],[MaintainTrackerId],[MaintainTrackerNo],[MaintainTrackLastDate],[MaintainTrackFlag],[ReturnVisitorId],[ReturnVisitorNo],[ReturnVisitLastDate],[FirstEnterDate],[LastEnterDate],[ServiceTimesShop],[ServiceTimesTotal],[UpdateDate],[CreateDate],[AdmShopId]) VALUES(@CustomerId,@CustomerNo,@FileNumber,@VehicleNo,@BrandId,@BrandNo,@VtypeId,@VtypeNo,@Source,@ChassisNumber,@EngineNumber,@LicenceDate,@RegisterDate,@ProductiveYear,@PassengerCapacity,@UseNature,@StandardLoad,@PurchasePrice,@VehicleColor,@VehicleStyle,@VehicleArea,@HistoryInsuranceList,@YearAverageMileage,@InsuranceCompanyId,@InsuranceCompanyNo,@InsuranceDateStart,@InsuranceDateClose,@MaintainDateStart,@MaintainDateClose,@MaintainMileage,@VechicleNote,@VehicleStatus,@ServiceAdvisorUserId,@ServiceAdvisorUserNo,@TelephoneTrackerId,@TelephoneTrackerNo,@TelephoneTrackLastDate,@TelephoneTrackFlag,@TelephoneJointerId,@TelephoneJointerNo,@InsuranceTrackerId,@InsuranceTrackerNo,@InsuranceTrackLastDate,@InsuranceTrackFlag,@InsuranceJointerId,@InsuranceJointerNo,@MaintainTrackerId,@MaintainTrackerNo,@MaintainTrackLastDate,@MaintainTrackFlag,@ReturnVisitorId,@ReturnVisitorNo,@ReturnVisitLastDate,@FirstEnterDate,@LastEnterDate,@ServiceTimesShop,@ServiceTimesTotal,@UpdateDate,@CreateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizMarketDataVehicleInfoInsurance] SET [CustomerId]=@CustomerId,[CustomerNo]=@CustomerNo,[FileNumber]=@FileNumber,[VehicleNo]=@VehicleNo,[BrandId]=@BrandId,[BrandNo]=@BrandNo,[VtypeId]=@VtypeId,[VtypeNo]=@VtypeNo,[Source]=@Source,[ChassisNumber]=@ChassisNumber,[EngineNumber]=@EngineNumber,[LicenceDate]=@LicenceDate,[RegisterDate]=@RegisterDate,[ProductiveYear]=@ProductiveYear,[PassengerCapacity]=@PassengerCapacity,[UseNature]=@UseNature,[StandardLoad]=@StandardLoad,[PurchasePrice]=@PurchasePrice,[VehicleColor]=@VehicleColor,[VehicleStyle]=@VehicleStyle,[VehicleArea]=@VehicleArea,[HistoryInsuranceList]=@HistoryInsuranceList,[YearAverageMileage]=@YearAverageMileage,[InsuranceCompanyId]=@InsuranceCompanyId,[InsuranceCompanyNo]=@InsuranceCompanyNo,[InsuranceDateStart]=@InsuranceDateStart,[InsuranceDateClose]=@InsuranceDateClose,[MaintainDateStart]=@MaintainDateStart,[MaintainDateClose]=@MaintainDateClose,[MaintainMileage]=@MaintainMileage,[VechicleNote]=@VechicleNote,[VehicleStatus]=@VehicleStatus,[ServiceAdvisorUserId]=@ServiceAdvisorUserId,[ServiceAdvisorUserNo]=@ServiceAdvisorUserNo,[TelephoneTrackerId]=@TelephoneTrackerId,[TelephoneTrackerNo]=@TelephoneTrackerNo,[TelephoneTrackLastDate]=@TelephoneTrackLastDate,[TelephoneTrackFlag]=@TelephoneTrackFlag,[TelephoneJointerId]=@TelephoneJointerId,[TelephoneJointerNo]=@TelephoneJointerNo,[InsuranceTrackerId]=@InsuranceTrackerId,[InsuranceTrackerNo]=@InsuranceTrackerNo,[InsuranceTrackLastDate]=@InsuranceTrackLastDate,[InsuranceTrackFlag]=@InsuranceTrackFlag,[InsuranceJointerId]=@InsuranceJointerId,[InsuranceJointerNo]=@InsuranceJointerNo,[MaintainTrackerId]=@MaintainTrackerId,[MaintainTrackerNo]=@MaintainTrackerNo,[MaintainTrackLastDate]=@MaintainTrackLastDate,[MaintainTrackFlag]=@MaintainTrackFlag,[ReturnVisitorId]=@ReturnVisitorId,[ReturnVisitorNo]=@ReturnVisitorNo,[ReturnVisitLastDate]=@ReturnVisitLastDate,[FirstEnterDate]=@FirstEnterDate,[LastEnterDate]=@LastEnterDate,[ServiceTimesShop]=@ServiceTimesShop,[ServiceTimesTotal]=@ServiceTimesTotal,[UpdateDate]=@UpdateDate,[CreateDate]=@CreateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

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

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

AI 解读 AI

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

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