Hl.DataDalSql/BizMarketing/BizServiceInfoHistoryBusinessTeamDetail.cs

（开头部分） 16KB

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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServiceInfoHistoryBusinessTeamDetail] ([TeamId],[TeamName],[ServiceId],[ServiceNo],[VehicleId],[VehicleNo],[SettleDate],[ServiceTypeId],[ServiceTypeNo],[FinalCheckId],[FinalCheckNo],[ServiceAdvisorId],[ServiceAdvisorNo],[ServiceRebateRate],[ItemTypeId],[ItemTypeNo],[ItemTax],[ItemRebateRate],[ItemMoney],[ItemMoneyDeduct],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@TeamId,@TeamName,@ServiceId,@ServiceNo,@VehicleId,@VehicleNo,@SettleDate,@ServiceTypeId,@ServiceTypeNo,@FinalCheckId,@FinalCheckNo,@ServiceAdvisorId,@ServiceAdvisorNo,@ServiceRebateRate,@ItemTypeId,@ItemTypeNo,@ItemTax,@ItemRebateRate,@ItemMoney,@ItemMoneyDeduct,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServiceInfoHistoryBusinessTeamDetail] SET [TeamId]=@TeamId,[TeamName]=@TeamName,[ServiceId]=@ServiceId,[ServiceNo]=@ServiceNo,[VehicleId]=@VehicleId,[VehicleNo]=@VehicleNo,[SettleDate]=@SettleDate,[ServiceTypeId]=@ServiceTypeId,[ServiceTypeNo]=@ServiceTypeNo,[FinalCheckId]=@FinalCheckId,[FinalCheckNo]=@FinalCheckNo,[ServiceAdvisorId]=@ServiceAdvisorId,[ServiceAdvisorNo]=@ServiceAdvisorNo,[ServiceRebateRate]=@ServiceRebateRate,[ItemTypeId]=@ItemTypeId,[ItemTypeNo]=@ItemTypeNo,[ItemTax]=@ItemTax,[ItemRebateRate]=@ItemRebateRate,[ItemMoney]=@ItemMoney,[ItemMoneyDeduct]=@ItemMoneyDeduct,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

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

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

AI 解读 AI

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

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