|
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.ServiceModel;
- using RDH.Data.Models;
-
- namespace RDH.Data.BLL
- {
- public partial class UserInfoBLL : BaseOrclSnapshotBLL<UserInfo>, IUserInfoBLL
- {
- public UserInfoBLL() : base()
- {
- AliasTableName = "u";
- }
-
- internal override String TABLE_NAME { get { return "USER_INFO"; } }//TB_NAME
- internal override string ENTITY_NAME { get { return "UserInfo"; } }
- internal override String KEY_COLUMN { get { return "KEY"; } }//KEY_COLUMN
- internal override string SNAPSHOT_BASE { get { return "USER_INFO_BASE"; } }
-
- internal override void InitMaps()
- {
- ColumnPropMaps.Add("SNAPSHOT_KEY", "SnapshotKey");
- ColumnPropMaps.Add("KEY", "Key");
- ColumnPropMaps.Add("CREATE_BY", "CreateBy");
- ColumnPropMaps.Add("CREATE_TIME", "CreateTime");
- ColumnPropMaps.Add("USER_ID", "UserId");
- ColumnPropMaps.Add("PASSWORD", "Password");
- ColumnPropMaps.Add("IF_CARD_ID", "IfCardId");
- ColumnPropMaps.Add("PINGER_PRINT_DATA", "PingerPrintData");
- ColumnPropMaps.Add("LOING_TRY_TIMES", "LoingTryTimes");
- ColumnPropMaps.Add("IS_ACTIVE", "IsActive");
- ColumnPropMaps.Add("LOCATION_KEY", "LocationKey");
- ColumnPropMaps.Add("SECTION_KEY", "SectionKey");
- ColumnPropMaps.Add("NAME", "Name");
- ColumnPropMaps.Add("SEX", "Sex");
- ColumnPropMaps.Add("AGE", "Age");
- ColumnPropMaps.Add("MOBILE_PHONE", "MobilePhone");
- ColumnPropMaps.Add("TELPHONE", "Telphone");
- ColumnPropMaps.Add("ADDRESS", "Address");
- ColumnPropMaps.Add("IS_SUPPER_USER", "IsSupperUser");
- ColumnPropMaps.Add("FLAG", "Flag");
- ColumnPropMaps.Add("CLIENT_TIME", "ClientTime");
- ColumnPropMaps.Add("SERVER_TIME", "ServerTime");
- ColumnPropMaps.Add("EXT01", "Ext01");
- ColumnPropMaps.Add("EXT02", "Ext02");
- ColumnPropMaps.Add("EXT03", "Ext03");
- ColumnPropMaps.Add("EXT04", "Ext04");
- ColumnPropMaps.Add("EXT05", "Ext05");
- ColumnPropMaps.Add("EXT06", "Ext06");
- ColumnPropMaps.Add("EXT07", "Ext07");
- ColumnPropMaps.Add("EXT08", "Ext08");
- ColumnPropMaps.Add("EXT09", "Ext09");
- ColumnPropMaps.Add("EXT10", "Ext10");
- ColumnPropMaps.Add("SECTION_ID", "SectionId");
- ColumnPropMaps.Add("USER_CODE", "UserCode");//COLUMN_MAPS
- }
-
- internal override object GetParam(UserInfo userinfo)
- {
- return new
- {
- SnapshotKey = userinfo.SnapshotKey,
- Key = userinfo.Key,
- CreateBy = userinfo.CreateBy,
- CreateTime = userinfo.CreateTime,
- UserId = userinfo.UserId,
- Password = userinfo.Password,
- IfCardId = userinfo.IfCardId,
- PingerPrintData = userinfo.PingerPrintData,
- LoingTryTimes = userinfo.LoingTryTimes,
- IsActive = userinfo.IsActive,
- LocationKey = userinfo.LocationKey,
- SectionKey = userinfo.SectionKey,
- Name = userinfo.Name,
- Sex = userinfo.Sex,
- Age = userinfo.Age,
- MobilePhone = userinfo.MobilePhone,
- Telphone = userinfo.Telphone,
- Address = userinfo.Address,
- IsSupperUser = userinfo.IsSupperUser,
- Flag = userinfo.Flag,
- ClientTime = userinfo.ClientTime,
- ServerTime = userinfo.ServerTime,
- Ext01 = userinfo.Ext01,
- Ext02 = userinfo.Ext02,
- Ext03 = userinfo.Ext03,
- Ext04 = userinfo.Ext04,
- Ext05 = userinfo.Ext05,
- Ext06 = userinfo.Ext06,
- Ext07 = userinfo.Ext07,
- Ext08 = userinfo.Ext08,
- Ext09 = userinfo.Ext09,
- Ext10 = userinfo.Ext10,
- SectionId = userinfo.SectionId,
- UserCode = userinfo.UserCode, //Params
- };
- }
-
- public IEnumerable<UserInfo> ListUserInfo()
- {
- SqlBuilder sqlBuilder = new SqlBuilder(this);
- SectionBLL sectionBLL = new SectionBLL();
- TableJoinInfo sectionTable = new TableJoinInfo
- {
- LeftDal = this,
- LeftColumnName = "SECTION_ID",
- RightDal = sectionBLL,
- RightColumnName = sectionBLL.KEY_COLUMN,
- JoinType = TableJoinTypes.Left,
- };
- sqlBuilder.AppendSelectionTable(sectionTable);
- IEnumerable<UserInfo> ListUser = SqlMapper.Query<UserInfo, Section, UserInfo>(ConnectionFactory.Current.GetSessionConnection(),
- sqlBuilder.ToString(),
- (ui, sect) =>
- {
- ui.Section = sect;
- return ui;
- }, splitOn: sqlBuilder.GetSpiltors());
- return ListUser;
- }
-
- public UserInfo GetByUserId(string userId)
- {
- var sql = BuildBaseSql();
- return SqlMapper.Query<UserInfo>(ConnectionFactory.Current.GetSessionConnection(),
- sql + " WHERE USER_ID = :UserId",
- new { UserId = userId }).FirstOrDefault();
- }
-
- public UserInfo GetByRfId(string rfid)
- {
- var sql = BuildBaseSql();
- return SqlMapper.Query<UserInfo>(ConnectionFactory.Current.GetSessionConnection(),
- sql + " WHERE IF_CARD_ID = :IfIdCard",
- new { IfIdCard = rfid }).FirstOrDefault();
-
- }
- }
- }
|