/// <summary> /// 根据工号从缓存获取实体 /// </summary> /// <param name="employeeNumber">工号</param> /// <returns></returns> public static BaseStaffEntity GetEntityByEmployeeNumberByCache(string employeeNumber) { BaseStaffEntity result = null; if (!string.IsNullOrEmpty(employeeNumber)) { var cacheKey = "StaffByEmployeeNumber" + employeeNumber; result = CacheUtil.Cache(cacheKey, () => new BaseStaffManager().GetEntityByEmployeeNumber(employeeNumber), true); } return(result); }
/// <summary> /// 批量打删除标志 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int SetDeleted(BaseUserInfo userInfo, string[] ids) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseUserManager userManager = new BaseUserManager(dbHelper, userInfo); BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); BaseStaffEntity staffEntity = null; for (int i = 0; i < ids.Length; i++) { // 删除相应的用户 staffEntity = staffManager.GetEntity(ids[i]); if (staffEntity.UserId != null) { userManager.SetDeleted(staffEntity.UserId); } // 删除职员 returnValue = staffManager.SetDeleted(ids[i], true); } BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>实体</returns> public BaseStaffEntity GetEntity(BaseUserInfo userInfo, string id) { BaseStaffEntity entity = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseStaffManager(dbHelper, userInfo); entity = manager.GetEntity(id); }); return(entity); }
/// <summary> /// 添加或更新(主键是否为0) /// </summary> /// <param name="entity">实体</param> /// <param name="identity">自增量方式,表主键是否采用自增的策略</param> /// <param name="returnId">返回主键,不返回程序允许速度会快,主要是为了主细表批量插入数据优化用的</param> /// <returns>主键</returns> public string AddOrUpdate(BaseStaffEntity entity, bool identity = true, bool returnId = true) { Identity = identity; ReturnId = returnId; if (entity.Id == 0) { entity.Id = AddEntity(entity).ToInt(); return(entity.Id.ToString()); } else { return(UpdateEntity(entity) > 0 ? entity.Id.ToString() : string.Empty); } }
/// <summary> /// 更新实体 /// </summary> /// <param name="baseStaffEntity">实体</param> public int UpdateEntity(BaseStaffEntity baseStaffEntity) { SQLBuilder sqlBuilder = new SQLBuilder(DbHelper); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, baseStaffEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseStaffEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseStaffEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseStaffEntity.FieldModifiedOn); sqlBuilder.SetWhere(BaseStaffEntity.FieldId, baseStaffEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 通过编号获取选项的显示内容 /// 这里是进行了内存缓存处理,减少数据库的I/O处理,提高程序的运行性能, /// 若有数据修改过,重新启动一下程序就可以了,这些基础数据也不是天天修改来修改去的, /// 所以没必要过度担忧,当然有需要时也可以写个刷新缓存的程序 /// </summary> /// <param name="id">主键</param> /// <returns>显示值</returns> public static string GetRealName(string id) { string result = id; if (!string.IsNullOrEmpty(id)) { List <BaseStaffEntity> entityList = GetEntities(); BaseStaffEntity staffEntity = entityList.FirstOrDefault(entity => entity.Id.HasValue && entity.Id.ToString().Equals(id)); if (staffEntity != null) { result = staffEntity.RealName; } } return(result); }
public static BaseStaffEntity GetObjectByCodeByCache(string code) { BaseStaffEntity result = null; System.Web.Caching.Cache cache = HttpRuntime.Cache; string cacheObject = "StaffByCode" + code; if (cache != null && cache[cacheObject] == null) { BaseStaffManager staffManager = new BaseStaffManager(); result = staffManager.GetObjectByCode(code); cache.Add(cacheObject, result, null, DateTime.Now.AddMinutes(10), TimeSpan.Zero, CacheItemPriority.Normal, null); System.Console.WriteLine(System.DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat) + " cache Staff"); } result = cache[cacheObject] as BaseStaffEntity; return(result); }
/// <summary> /// 更新通讯地址 /// </summary> /// <param name="userInfo">用户</param> /// <param name="staffEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int UpdateAddress(BaseUserInfo userInfo, BaseStaffEntity staffEntity, out string statusCode, out string statusMessage) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); statusCode = string.Empty; BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); // for (int i = 0; i < dataTable.Rows.Count; i++) // { returnValue += staffManager.UpdateAddress(staffEntity, out statusCode); // } statusMessage = staffManager.GetStateMessage(statusCode); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.StaffService_UpdateAddress, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 更新员工 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="status">状态</param> /// <param name="statusMessage">返回状消息</param> /// <returns>影响行数</returns> public int UpdateStaff(BaseUserInfo userInfo, BaseStaffEntity entity, out Status status, out string statusMessage) { var result = 0; var returnCode = Status.Ok; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { // 3.员工的修改 var manager = new BaseStaffManager(dbHelper, userInfo); result = manager.UniqueUpdate(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); }); status = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 更新员工 /// </summary> /// <param name="userInfo">用户</param> /// <param name="staffEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状消息</param> /// <returns>影响行数</returns> public int UpdateStaff(BaseUserInfo userInfo, BaseStaffEntity staffEntity, out string statusCode, out string statusMessage) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 if (!BaseSystemInfo.IsAuthorized(userInfo)) { throw new Exception(AppMessage.MSG0800); } int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); // 3.员工的修改 BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); returnValue = staffManager.Update(staffEntity, out statusCode); statusMessage = staffManager.GetStateMessage(statusCode); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.StaffService_UpdateStaff, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 添加员工 /// </summary> /// <param name="userInfo">用户</param> /// <param name="staffEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状消息</param> /// <returns>主键</returns> public string AddStaff(BaseUserInfo userInfo, BaseStaffEntity staffEntity, out string statusCode, out string statusMessage) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string returnValue = string.Empty; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); // 1.若添加用户成功,添加员工。 BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); returnValue = staffManager.Add(staffEntity, out statusCode); statusMessage = staffManager.GetStateMessage(statusCode); // 2.自己不用给自己发提示信息,这个提示信息是为了提高工作效率的 BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.StaffService_AddStaff, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 添加员工 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="status">状态</param> /// <param name="statusMessage">返回状消息</param> /// <returns>主键</returns> public string AddStaff(BaseUserInfo userInfo, BaseStaffEntity entity, out Status status, out string statusMessage) { var result = string.Empty; var returnCode = Status.Ok; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { // 1.若添加用户成功,添加员工。 var manager = new BaseStaffManager(dbHelper, userInfo); result = manager.UniqueAdd(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); // 2.自己不用给自己发提示信息,这个提示信息是为了提高工作效率的 }); status = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>实体</returns> public BaseStaffEntity GetEntity(BaseUserInfo userInfo, string id) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif BaseStaffEntity staffEntity = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); staffEntity = staffManager.GetEntity(id); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.StaffService_GetEntity, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(staffEntity); }
/// <summary> /// 更新通讯地址 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="status">状态</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int UpdateAddress(BaseUserInfo userInfo, BaseStaffEntity entity, out Status status, out string statusMessage) { var result = 0; var returnCode = Status.Ok; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseStaffManager(dbHelper, userInfo); // for (int i = 0; i < result.Rows.Count; i++) // { result += manager.UpdateAddress(entity, out returnCode); // } returnMessage = manager.GetStateMessage(returnCode); }); status = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 扮演用户 /// </summary> /// <param name="id">用户主键</param> /// <param name="status">状态</param> /// <returns>用户类</returns> public BaseUserInfo Impersonation(int id, out Status status) { BaseUserInfo userInfo = null; // 获得登录信息 var entity = new BaseUserLogonManager(DbHelper, UserInfo).GetEntityByUserId(id.ToString()); // 只允许登录一次,需要检查是否自己重新登录了,或者自己扮演自己了 if (!UserInfo.Id.Equals(id)) { if (BaseSystemInfo.CheckOnline) { if (entity.UserOnline > 0) { status = Status.ErrorOnline; return(userInfo); } } } var userEntity = GetEntity(id); userInfo = ConvertToUserInfo(userEntity); if (userEntity.IsStaff.Equals("1")) { // 获得员工的信息 var staffEntity = new BaseStaffEntity(); var staffManager = new BaseStaffManager(DbHelper, UserInfo); var dataTableStaff = staffManager.GetDataTableById(id.ToString()); staffEntity.GetSingle(dataTableStaff); userInfo = staffManager.ConvertToUserInfo(userInfo, staffEntity); } status = Status.Ok; // 登录、重新登录、扮演时的在线状态进行更新 var userLogonManager = new BaseUserLogonManager(DbHelper, UserInfo); userLogonManager.ChangeOnline(id); return(userInfo); }
/// <summary> /// 扮演用户 /// </summary> /// <param name="id">用户主键</param> /// <returns>用户类</returns> public BaseUserInfo Impersonation(string id, out string statusCode) { BaseUserInfo userInfo = null; // 获得登录信息 BaseUserLogOnEntity entity = new BaseUserLogOnManager(this.DbHelper, this.UserInfo).GetObject(id); // 只允许登录一次,需要检查是否自己重新登录了,或者自己扮演自己了 if (!UserInfo.Id.Equals(id)) { if (BaseSystemInfo.CheckOnLine) { if (entity.UserOnLine > 0) { statusCode = Status.ErrorOnLine.ToString(); return(userInfo); } } } BaseUserEntity userEntity = this.GetObject(id); userInfo = this.ConvertToUserInfo(userEntity); if (userEntity.IsStaff.Equals("1")) { // 获得员工的信息 BaseStaffEntity staffEntity = new BaseStaffEntity(); BaseStaffManager staffManager = new BaseStaffManager(DbHelper, UserInfo); DataTable dataTableStaff = staffManager.GetDataTableById(id); staffEntity.GetSingle(dataTableStaff); userInfo = staffManager.ConvertToUserInfo(userInfo, staffEntity); } statusCode = Status.OK.ToString(); // 登录、重新登录、扮演时的在线状态进行更新 BaseUserLogOnManager userLogOnManager = new BaseUserLogOnManager(this.DbHelper, this.UserInfo); userLogOnManager.ChangeOnLine(id); return(userInfo); }
/// <summary> /// 更新实体 /// </summary> /// <param name="entity">实体</param> public int UpdateEntity(BaseStaffEntity entity) { var sqlBuilder = new SqlBuilder(DbHelper); sqlBuilder.BeginUpdate(CurrentTableName); SetEntity(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(BaseStaffEntity.FieldUpdateUserId, UserInfo.UserId); sqlBuilder.SetValue(BaseStaffEntity.FieldUpdateUserName, UserInfo.UserName); sqlBuilder.SetValue(BaseStaffEntity.FieldUpdateBy, UserInfo.RealName); } sqlBuilder.SetDbNow(BaseStaffEntity.FieldUpdateTime); sqlBuilder.SetValue(BaseStaffEntity.FieldUpdateIp, Utils.GetIp()); sqlBuilder.SetWhere(PrimaryKey, entity.Id); //return sqlBuilder.EndUpdate(); var result = sqlBuilder.EndUpdate(); if (result > 0) { RemoveCache(entity.Id); } return(result); }
/// <summary> /// 添加 /// </summary> /// <param name="baseStaffEntity">实体</param> /// <returns>主键</returns> public string Add(BaseStaffEntity baseStaffEntity) { return(this.AddEntity(baseStaffEntity)); }
/// <summary> /// 设置实体 /// </summary> /// <param name="baseStaffEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, BaseStaffEntity baseStaffEntity) { SetEntityExpand(sqlBuilder, baseStaffEntity); sqlBuilder.SetValue(BaseStaffEntity.FieldUserId, baseStaffEntity.UserId); sqlBuilder.SetValue(BaseStaffEntity.FieldUserName, baseStaffEntity.UserName); sqlBuilder.SetValue(BaseStaffEntity.FieldRealName, baseStaffEntity.RealName); sqlBuilder.SetValue(BaseStaffEntity.FieldCode, baseStaffEntity.Code); sqlBuilder.SetValue(BaseStaffEntity.FieldGender, baseStaffEntity.Gender); sqlBuilder.SetValue(BaseStaffEntity.FieldSubCompanyId, baseStaffEntity.SubCompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldCompanyId, baseStaffEntity.CompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentId, baseStaffEntity.DepartmentId); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkgroupId, baseStaffEntity.WorkgroupId); sqlBuilder.SetValue(BaseStaffEntity.FieldQuickQuery, baseStaffEntity.QuickQuery); sqlBuilder.SetValue(BaseStaffEntity.FieldDutyId, baseStaffEntity.DutyId); sqlBuilder.SetValue(BaseStaffEntity.FieldIdentificationCode, baseStaffEntity.IdentificationCode); sqlBuilder.SetValue(BaseStaffEntity.FieldIDCard, baseStaffEntity.IDCard); sqlBuilder.SetValue(BaseStaffEntity.FieldBankCode, baseStaffEntity.BankCode); sqlBuilder.SetValue(BaseStaffEntity.FieldEmail, baseStaffEntity.Email); sqlBuilder.SetValue(BaseStaffEntity.FieldMobile, baseStaffEntity.Mobile); sqlBuilder.SetValue(BaseStaffEntity.FieldShortNumber, baseStaffEntity.ShortNumber); sqlBuilder.SetValue(BaseStaffEntity.FieldTelephone, baseStaffEntity.Telephone); sqlBuilder.SetValue(BaseStaffEntity.FieldOICQ, baseStaffEntity.OICQ); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePhone, baseStaffEntity.OfficePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeZipCode, baseStaffEntity.OfficeZipCode); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeAddress, baseStaffEntity.OfficeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeFax, baseStaffEntity.OfficeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldAge, baseStaffEntity.Age); sqlBuilder.SetValue(BaseStaffEntity.FieldBirthday, baseStaffEntity.Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldEducation, baseStaffEntity.Education); sqlBuilder.SetValue(BaseStaffEntity.FieldSchool, baseStaffEntity.School); sqlBuilder.SetValue(BaseStaffEntity.FieldGraduationDate, baseStaffEntity.GraduationDate); sqlBuilder.SetValue(BaseStaffEntity.FieldMajor, baseStaffEntity.Major); sqlBuilder.SetValue(BaseStaffEntity.FieldDegree, baseStaffEntity.Degree); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleId, baseStaffEntity.TitleId); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleDate, baseStaffEntity.TitleDate); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleLevel, baseStaffEntity.TitleLevel); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingDate, baseStaffEntity.WorkingDate); sqlBuilder.SetValue(BaseStaffEntity.FieldJoinInDate, baseStaffEntity.JoinInDate); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeZipCode, baseStaffEntity.HomeZipCode); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeAddress, baseStaffEntity.HomeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldHomePhone, baseStaffEntity.HomePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeFax, baseStaffEntity.HomeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldProvince, baseStaffEntity.Province); sqlBuilder.SetValue(BaseStaffEntity.FieldCarCode, baseStaffEntity.CarCode); sqlBuilder.SetValue(BaseStaffEntity.FieldCity, baseStaffEntity.City); sqlBuilder.SetValue(BaseStaffEntity.FieldArea, baseStaffEntity.Area); sqlBuilder.SetValue(BaseStaffEntity.FieldNativePlace, baseStaffEntity.NativePlace); sqlBuilder.SetValue(BaseStaffEntity.FieldParty, baseStaffEntity.Party); sqlBuilder.SetValue(BaseStaffEntity.FieldNation, baseStaffEntity.Nation); sqlBuilder.SetValue(BaseStaffEntity.FieldNationality, baseStaffEntity.Nationality); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingProperty, baseStaffEntity.WorkingProperty); sqlBuilder.SetValue(BaseStaffEntity.FieldCompetency, baseStaffEntity.Competency); sqlBuilder.SetValue(BaseStaffEntity.FieldEmergencyContact, baseStaffEntity.EmergencyContact); sqlBuilder.SetValue(BaseStaffEntity.FieldIsDimission, baseStaffEntity.IsDimission); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionDate, baseStaffEntity.DimissionDate); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionCause, baseStaffEntity.DimissionCause); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionWhither, baseStaffEntity.DimissionWhither); sqlBuilder.SetValue(BaseStaffEntity.FieldEnabled, baseStaffEntity.Enabled); sqlBuilder.SetValue(BaseStaffEntity.FieldDeletionStateCode, baseStaffEntity.DeletionStateCode); sqlBuilder.SetValue(BaseStaffEntity.FieldSortCode, baseStaffEntity.SortCode); sqlBuilder.SetValue(BaseStaffEntity.FieldDescription, baseStaffEntity.Description); }
// 这个是声明扩展方法 partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseStaffEntity baseStaffEntity);
/// <summary> /// 添加实体 /// </summary> /// <param name="baseStaffEntity">实体</param> public string AddEntity(BaseStaffEntity baseStaffEntity) { string sequence = string.Empty; if (baseStaffEntity.SortCode == null || baseStaffEntity.SortCode == 0) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); baseStaffEntity.SortCode = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, BaseStaffEntity.FieldId); if (!this.Identity) { sqlBuilder.SetValue(BaseStaffEntity.FieldId, baseStaffEntity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (DbHelper.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(BaseStaffEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(BaseStaffEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (baseStaffEntity.Id == null) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } baseStaffEntity.Id = int.Parse(sequence); } sqlBuilder.SetValue(BaseStaffEntity.FieldId, baseStaffEntity.Id); } } } this.SetEntity(sqlBuilder, baseStaffEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseStaffEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseStaffEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseStaffEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseStaffEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseStaffEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseStaffEntity.FieldModifiedOn); if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.SqlServer || DbHelper.CurrentDbType == CurrentDbType.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
public BaseStaffEntity GetEntity(int id) { BaseStaffEntity baseStaffEntity = new BaseStaffEntity(this.GetDataTable(new KeyValuePair <string, object>(BaseStaffEntity.FieldId, id))); return(baseStaffEntity); }
/// <summary> /// 设置实体 /// </summary> /// <param name="sqlBuilder">Sql语句生成器</param> /// <param name="entity">实体</param> private void SetEntity(SqlBuilder sqlBuilder, BaseStaffEntity entity) { SetEntityExtend(sqlBuilder, entity); sqlBuilder.SetValue(BaseStaffEntity.FieldUserId, entity.UserId); sqlBuilder.SetValue(BaseStaffEntity.FieldUserName, entity.UserName); sqlBuilder.SetValue(BaseStaffEntity.FieldEmployeeNumber, entity.EmployeeNumber); sqlBuilder.SetValue(BaseStaffEntity.FieldRealName, entity.RealName); sqlBuilder.SetValue(BaseStaffEntity.FieldChineseName, entity.ChineseName); sqlBuilder.SetValue(BaseStaffEntity.FieldEnglishName, entity.EnglishName); sqlBuilder.SetValue(BaseStaffEntity.FieldQuickQuery, entity.QuickQuery); sqlBuilder.SetValue(BaseStaffEntity.FieldCompanyId, entity.CompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldCompanyName, entity.CompanyName); sqlBuilder.SetValue(BaseStaffEntity.FieldSubCompanyId, entity.SubCompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldSubCompanyName, entity.SubCompanyName); sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentId, entity.DepartmentId); sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentName, entity.DepartmentName); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkgroupId, entity.WorkgroupId); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkgroupName, entity.WorkgroupName); sqlBuilder.SetValue(BaseStaffEntity.FieldDutyId, entity.DutyId); sqlBuilder.SetValue(BaseStaffEntity.FieldGender, entity.Gender); sqlBuilder.SetValue(BaseStaffEntity.FieldBirthday, entity.Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldAge, entity.Age); sqlBuilder.SetValue(BaseStaffEntity.FieldHeight, entity.Height); sqlBuilder.SetValue(BaseStaffEntity.FieldWeight, entity.Weight); sqlBuilder.SetValue(BaseStaffEntity.FieldIdentificationCode, entity.IdentificationCode); sqlBuilder.SetValue(BaseStaffEntity.FieldIdCard, entity.IdCard); sqlBuilder.SetValue(BaseStaffEntity.FieldNation, entity.Nation); sqlBuilder.SetValue(BaseStaffEntity.FieldEducation, entity.Education); sqlBuilder.SetValue(BaseStaffEntity.FieldSchool, entity.School); sqlBuilder.SetValue(BaseStaffEntity.FieldGraduationDate, entity.GraduationDate); sqlBuilder.SetValue(BaseStaffEntity.FieldMajor, entity.Major); sqlBuilder.SetValue(BaseStaffEntity.FieldDegree, entity.Degree); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleId, entity.TitleId); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleDate, entity.TitleDate); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleLevel, entity.TitleLevel); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingDate, entity.WorkingDate); sqlBuilder.SetValue(BaseStaffEntity.FieldJoinInDate, entity.JoinInDate); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePostCode, entity.OfficePostCode); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeAddress, entity.OfficeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePhone, entity.OfficePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeFax, entity.OfficeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldHomePostCode, entity.HomePostCode); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeAddress, entity.HomeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldHomePhone, entity.HomePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeFax, entity.HomeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldPlateNumber1, entity.PlateNumber1); sqlBuilder.SetValue(BaseStaffEntity.FieldPlateNumber2, entity.PlateNumber2); sqlBuilder.SetValue(BaseStaffEntity.FieldPlateNumber3, entity.PlateNumber3); sqlBuilder.SetValue(BaseStaffEntity.FieldRewardCard, entity.RewardCard); sqlBuilder.SetValue(BaseStaffEntity.FieldMedicalCard, entity.MedicalCard); sqlBuilder.SetValue(BaseStaffEntity.FieldUnionMember, entity.UnionMember); sqlBuilder.SetValue(BaseStaffEntity.FieldEmail, entity.Email); sqlBuilder.SetValue(BaseStaffEntity.FieldMobile, entity.Mobile); sqlBuilder.SetValue(BaseStaffEntity.FieldQq, entity.Qq); sqlBuilder.SetValue(BaseStaffEntity.FieldWeChat, entity.WeChat); sqlBuilder.SetValue(BaseStaffEntity.FieldShortNumber, entity.ShortNumber); sqlBuilder.SetValue(BaseStaffEntity.FieldTelephone, entity.Telephone); sqlBuilder.SetValue(BaseStaffEntity.FieldExtension, entity.Extension); sqlBuilder.SetValue(BaseStaffEntity.FieldEmergencyContact, entity.EmergencyContact); sqlBuilder.SetValue(BaseStaffEntity.FieldEmergencyMobile, entity.EmergencyMobile); sqlBuilder.SetValue(BaseStaffEntity.FieldEmergencyTelephone, entity.EmergencyTelephone); sqlBuilder.SetValue(BaseStaffEntity.FieldNativePlace, entity.NativePlace); sqlBuilder.SetValue(BaseStaffEntity.FieldBankName, entity.BankName); sqlBuilder.SetValue(BaseStaffEntity.FieldBankAccount, entity.BankAccount); sqlBuilder.SetValue(BaseStaffEntity.FieldBankUserName, entity.BankUserName); sqlBuilder.SetValue(BaseStaffEntity.FieldProvince, entity.Province); sqlBuilder.SetValue(BaseStaffEntity.FieldCity, entity.City); sqlBuilder.SetValue(BaseStaffEntity.FieldDistrict, entity.District); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentProvince, entity.CurrentProvince); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentCity, entity.CurrentCity); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentDistrict, entity.CurrentDistrict); sqlBuilder.SetValue(BaseStaffEntity.FieldParty, entity.Party); sqlBuilder.SetValue(BaseStaffEntity.FieldNationality, entity.Nationality); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingProperty, entity.WorkingProperty); sqlBuilder.SetValue(BaseStaffEntity.FieldCompetency, entity.Competency); sqlBuilder.SetValue(BaseStaffEntity.FieldMarriage, entity.Marriage); sqlBuilder.SetValue(BaseStaffEntity.FieldWeddingDate, entity.WeddingDate); sqlBuilder.SetValue(BaseStaffEntity.FieldDivorceDate, entity.DivorceDate); sqlBuilder.SetValue(BaseStaffEntity.FieldChild1Birthday, entity.Child1Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldChild2Birthday, entity.Child2Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldChild3Birthday, entity.Child3Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldChild4Birthday, entity.Child4Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldChild5Birthday, entity.Child5Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldIsDimission, entity.IsDimission); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionDate, entity.DimissionDate); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionCause, entity.DimissionCause); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionWhereabouts, entity.DimissionWhereabouts); sqlBuilder.SetValue(BaseStaffEntity.FieldExt1, entity.Ext1); sqlBuilder.SetValue(BaseStaffEntity.FieldExt2, entity.Ext2); sqlBuilder.SetValue(BaseStaffEntity.FieldExt3, entity.Ext3); sqlBuilder.SetValue(BaseStaffEntity.FieldExt4, entity.Ext4); sqlBuilder.SetValue(BaseStaffEntity.FieldExt5, entity.Ext5); sqlBuilder.SetValue(BaseStaffEntity.FieldDescription, entity.Description); sqlBuilder.SetValue(BaseStaffEntity.FieldSortCode, entity.SortCode); sqlBuilder.SetValue(BaseStaffEntity.FieldDeleted, entity.Deleted); sqlBuilder.SetValue(BaseStaffEntity.FieldEnabled, entity.Enabled); }
/// <summary> /// 添加 /// </summary> /// <param name="baseStaffEntity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主键</param> /// <returns>主键</returns> public string Add(BaseStaffEntity baseStaffEntity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(baseStaffEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主键</param> /// <returns>主键</returns> public string Add(BaseStaffEntity entity, bool identity = true, bool returnId = false) { this.Identity = identity; this.ReturnId = returnId; return(this.AddObject(entity)); }
// 这个是声明扩展方法 partial void SetObjectExpand(SQLBuilder sqlBuilder, BaseStaffEntity entity);
/// <summary> /// 更新 /// </summary> /// <param name="entity">实体</param> public int Update(BaseStaffEntity entity) { return(this.UpdateObject(entity)); }
/// <summary> /// 更新 /// </summary> /// <param name="baseStaffEntity">实体</param> public int Update(BaseStaffEntity baseStaffEntity) { return(this.UpdateEntity(baseStaffEntity)); }
/// <summary> /// 设置实体 /// </summary> /// <param name="entity">实体</param> private void SetObject(SQLBuilder sqlBuilder, BaseStaffEntity entity) { SetObjectExpand(sqlBuilder, entity); sqlBuilder.SetValue(BaseStaffEntity.FieldUserId, entity.UserId); sqlBuilder.SetValue(BaseStaffEntity.FieldUserName, entity.UserName); sqlBuilder.SetValue(BaseStaffEntity.FieldRealName, entity.RealName); sqlBuilder.SetValue(BaseStaffEntity.FieldCode, entity.Code); sqlBuilder.SetValue(BaseStaffEntity.FieldGender, entity.Gender); sqlBuilder.SetValue(BaseStaffEntity.FieldCompanyId, entity.CompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldCompanyName, entity.CompanyName); sqlBuilder.SetValue(BaseStaffEntity.FieldSubCompanyId, entity.SubCompanyId); sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentId, entity.DepartmentId); sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentName, entity.DepartmentName); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkgroupId, entity.WorkgroupId); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkgroupName, entity.WorkgroupName); sqlBuilder.SetValue(BaseStaffEntity.FieldQuickQuery, entity.QuickQuery); sqlBuilder.SetValue(BaseStaffEntity.FieldDutyId, entity.DutyId); sqlBuilder.SetValue(BaseStaffEntity.FieldIdentificationCode, entity.IdentificationCode); sqlBuilder.SetValue(BaseStaffEntity.FieldIDCard, entity.IDCard); sqlBuilder.SetValue(BaseStaffEntity.FieldBankCode, entity.BankCode); sqlBuilder.SetValue(BaseStaffEntity.FieldBankName, entity.BankName); // sqlBuilder.SetValue(BaseStaffEntity.FieldBankUserName, entity.BankUserName); sqlBuilder.SetValue(BaseStaffEntity.FieldRewarCard, entity.RewarCard); sqlBuilder.SetValue(BaseStaffEntity.FieldMedicalCard, entity.MedicalCard); sqlBuilder.SetValue(BaseStaffEntity.FieldUnionMember, entity.UnionMember); sqlBuilder.SetValue(BaseStaffEntity.FieldEmail, entity.Email); sqlBuilder.SetValue(BaseStaffEntity.FieldMobile, entity.Mobile); sqlBuilder.SetValue(BaseStaffEntity.FieldShortNumber, entity.ShortNumber); sqlBuilder.SetValue(BaseStaffEntity.FieldTelephone, entity.Telephone); sqlBuilder.SetValue(BaseStaffEntity.FieldExtension, entity.Extension); sqlBuilder.SetValue(BaseStaffEntity.FieldQQ, entity.QQ); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePhone, entity.OfficePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePostCode, entity.OfficePostCode); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeAddress, entity.OfficeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldOfficeFax, entity.OfficeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldAge, entity.Age); sqlBuilder.SetValue(BaseStaffEntity.FieldBirthday, entity.Birthday); sqlBuilder.SetValue(BaseStaffEntity.FieldHeight, entity.Height); sqlBuilder.SetValue(BaseStaffEntity.FieldWeight, entity.Weight); sqlBuilder.SetValue(BaseStaffEntity.FieldMarriage, entity.Marriage); sqlBuilder.SetValue(BaseStaffEntity.FieldEducation, entity.Education); sqlBuilder.SetValue(BaseStaffEntity.FieldSchool, entity.School); sqlBuilder.SetValue(BaseStaffEntity.FieldGraduationDate, entity.GraduationDate); sqlBuilder.SetValue(BaseStaffEntity.FieldMajor, entity.Major); sqlBuilder.SetValue(BaseStaffEntity.FieldDegree, entity.Degree); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleId, entity.TitleId); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleDate, entity.TitleDate); sqlBuilder.SetValue(BaseStaffEntity.FieldTitleLevel, entity.TitleLevel); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingDate, entity.WorkingDate); sqlBuilder.SetValue(BaseStaffEntity.FieldJoinInDate, entity.JoinInDate); sqlBuilder.SetValue(BaseStaffEntity.FieldHomePostCode, entity.HomePostCode); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeAddress, entity.HomeAddress); sqlBuilder.SetValue(BaseStaffEntity.FieldHomePhone, entity.HomePhone); sqlBuilder.SetValue(BaseStaffEntity.FieldHomeFax, entity.HomeFax); sqlBuilder.SetValue(BaseStaffEntity.FieldCarCode, entity.CarCode); sqlBuilder.SetValue(BaseStaffEntity.FieldProvince, entity.Province); sqlBuilder.SetValue(BaseStaffEntity.FieldCity, entity.City); sqlBuilder.SetValue(BaseStaffEntity.FieldDistrict, entity.District); sqlBuilder.SetValue(BaseStaffEntity.FieldNativePlace, entity.NativePlace); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentProvince, entity.CurrentProvince); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentCity, entity.CurrentCity); sqlBuilder.SetValue(BaseStaffEntity.FieldCurrentDistrict, entity.CurrentDistrict); sqlBuilder.SetValue(BaseStaffEntity.FieldParty, entity.Party); sqlBuilder.SetValue(BaseStaffEntity.FieldNation, entity.Nation); sqlBuilder.SetValue(BaseStaffEntity.FieldNationality, entity.Nationality); sqlBuilder.SetValue(BaseStaffEntity.FieldWorkingProperty, entity.WorkingProperty); sqlBuilder.SetValue(BaseStaffEntity.FieldCompetency, entity.Competency); sqlBuilder.SetValue(BaseStaffEntity.FieldEmergencyContact, entity.EmergencyContact); sqlBuilder.SetValue(BaseStaffEntity.FieldWeddingday, entity.Weddingday); sqlBuilder.SetValue(BaseStaffEntity.FieldDivorce, entity.Divorce); sqlBuilder.SetValue(BaseStaffEntity.FieldChildbirthday1, entity.Childbirthday1); sqlBuilder.SetValue(BaseStaffEntity.FieldChildbirthday2, entity.Childbirthday2); sqlBuilder.SetValue(BaseStaffEntity.FieldIsDimission, entity.IsDimission); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionDate, entity.DimissionDate); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionCause, entity.DimissionCause); sqlBuilder.SetValue(BaseStaffEntity.FieldDimissionWhither, entity.DimissionWhither); sqlBuilder.SetValue(BaseStaffEntity.FieldEnabled, entity.Enabled); sqlBuilder.SetValue(BaseStaffEntity.FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(BaseStaffEntity.FieldSortCode, entity.SortCode); sqlBuilder.SetValue(BaseStaffEntity.FieldDescription, entity.Description); }
// 这个是声明扩展方法 partial void SetEntityExtend(SqlBuilder sqlBuilder, BaseStaffEntity entity);