Hl.DataDalSql/Adm/AdmUserBaseInfo.cs

（开头部分） 19KB

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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [AdmUserBaseInfo] ([NameCn],[NameEn],[Sex],[Nation],[Birthday],[HukouType],[PoliticalStatus],[MaritalStatus],[MedicalStatus],[Hometown],[MailingAddress],[ZipCode],[MobilePhone],[FixedPhone],[MobilePhoneUrgent],[FixedPhoneUrgent],[HighestEducation],[HighestDegree],[GraduatedSchool],[HighestOffice],[ProfessionalMajor],[ProfessionalCertificate],[WorkingYears],[EntrySources],[EntryDate],[IdNumber],[BaodaoDate],[CreateDate],[UpdateDate],[UserId],[UserNo]) VALUES(@NameCn,@NameEn,@Sex,@Nation,@Birthday,@HukouType,@PoliticalStatus,@MaritalStatus,@MedicalStatus,@Hometown,@MailingAddress,@ZipCode,@MobilePhone,@FixedPhone,@MobilePhoneUrgent,@FixedPhoneUrgent,@HighestEducation,@HighestDegree,@GraduatedSchool,@HighestOffice,@ProfessionalMajor,@ProfessionalCertificate,@WorkingYears,@EntrySources,@EntryDate,@IdNumber,@BaodaoDate,@CreateDate,@UpdateDate,@UserId,@UserNo) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [AdmUserBaseInfo] SET [NameCn]=@NameCn,[NameEn]=@NameEn,[Sex]=@Sex,[Nation]=@Nation,[Birthday]=@Birthday,[HukouType]=@HukouType,[PoliticalStatus]=@PoliticalStatus,[MaritalStatus]=@MaritalStatus,[MedicalStatus]=@MedicalStatus,[Hometown]=@Hometown,[MailingAddress]=@MailingAddress,[ZipCode]=@ZipCode,[MobilePhone]=@MobilePhone,[FixedPhone]=@FixedPhone,[MobilePhoneUrgent]=@MobilePhoneUrgent,[FixedPhoneUrgent]=@FixedPhoneUrgent,[HighestEducation]=@HighestEducation,[HighestDegree]=@HighestDegree,[GraduatedSchool]=@GraduatedSchool,[HighestOffice]=@HighestOffice,[ProfessionalMajor]=@ProfessionalMajor,[ProfessionalCertificate]=@ProfessionalCertificate,[WorkingYears]=@WorkingYears,[EntrySources]=@EntrySources,[EntryDate]=@EntryDate,[IdNumber]=@IdNumber,[BaodaoDate]=@BaodaoDate,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[UserId]=@UserId,[UserNo]=@UserNo WHERE [Id]=@Id";

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

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

AI 解读 AI

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

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