Hl.DataDalSql/BizTrack/BizVehicleTrackCsi.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>
    /// 车辆跟踪-Csi[DAL]  
    /// </summary>
    public class BizVehicleTrackCsi : DataDalInterface.BizVehicleTrackCsi
    {
        #region "访问"

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizVehicleTrackCsi] ([SerialNum],[ServiceId],[ServiceNo],[QuestionTypeId],[QuestionTypeNo],[RegisterDate],[ReplyLevel],[GmCommentNote],[GmCommentFlag],[BmCommentNote],[BmCommentFlag],[ResponsibleDeptId],[ResponsibleDeptNo],[ThingsThrough],[PersonPartyId],[PersonPartyNo],[PersonUpperId],[PersonUpperNo],[PersonHeaderId],[PersonHeaderNo],[PersonChargeId],[PersonChargeNo],[BmCheckFlag],[CmCheckFlag],[GmCheckFlag],[IsCase],[StepId],[StepNo],[QuestionDetail],[QuestionSettle],[QuestionBetter],[QuestionResult],[QuestionStatus],[OperatorId],[OperatorNo],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@SerialNum,@ServiceId,@ServiceNo,@QuestionTypeId,@QuestionTypeNo,@RegisterDate,@ReplyLevel,@GmCommentNote,@GmCommentFlag,@BmCommentNote,@BmCommentFlag,@ResponsibleDeptId,@ResponsibleDeptNo,@ThingsThrough,@PersonPartyId,@PersonPartyNo,@PersonUpperId,@PersonUpperNo,@PersonHeaderId,@PersonHeaderNo,@PersonChargeId,@PersonChargeNo,@BmCheckFlag,@CmCheckFlag,@GmCheckFlag,@IsCase,@StepId,@StepNo,@QuestionDetail,@QuestionSettle,@QuestionBetter,@QuestionResult,@QuestionStatus,@OperatorId,@OperatorNo,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizVehicleTrackCsi] SET [SerialNum]=@SerialNum,[ServiceId]=@ServiceId,[ServiceNo]=@ServiceNo,[QuestionTypeId]=@QuestionTypeId,[QuestionTypeNo]=@QuestionTypeNo,[RegisterDate]=@RegisterDate,[ReplyLevel]=@ReplyLevel,[GmCommentNote]=@GmCommentNote,[GmCommentFlag]=@GmCommentFlag,[BmCommentNote]=@BmCommentNote,[BmCommentFlag]=@BmCommentFlag,[ResponsibleDeptId]=@ResponsibleDeptId,[ResponsibleDeptNo]=@ResponsibleDeptNo,[ThingsThrough]=@ThingsThrough,[PersonPartyId]=@PersonPartyId,[PersonPartyNo]=@PersonPartyNo,[PersonUpperId]=@PersonUpperId,[PersonUpperNo]=@PersonUpperNo,[PersonHeaderId]=@PersonHeaderId,[PersonHeaderNo]=@PersonHeaderNo,[PersonChargeId]=@PersonChargeId,[PersonChargeNo]=@PersonChargeNo,[BmCheckFlag]=@BmCheckFlag,[CmCheckFlag]=@CmCheckFlag,[GmCheckFlag]=@GmCheckFlag,[IsCase]=@IsCase,[StepId]=@StepId,[StepNo]=@StepNo,[QuestionDetail]=@QuestionDetail,[QuestionSettle]=@QuestionSettle,[QuestionBetter]=@QuestionBetter,[QuestionResult]=@QuestionResult,[QuestionStatus]=@QuestionStatus,[OperatorId]=@OperatorId,[OperatorNo]=@OperatorNo,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

        /// <summary>
        /// 查询一条记录
        /// </summary>
        private const string SelectCmdText = "SELECT * FROM [BizVehicleTrackCsi] 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("@SerialNum",SqlDbType.NVarChar,50),
                    new SqlParameter("@ServiceId",SqlDbType.Int,4),
                    new SqlParameter("@ServiceNo",SqlDbType.NVarChar,50),