public FrmSendEmail(string id) : this() { this.EntityId = id; staffEntity = DotNetService.Instance.StaffService.GetEntity(UserInfo, EntityId); UserEntity = DotNetService.Instance.UserService.GetEntity(UserInfo, staffEntity.UserId.ToString()); this.txtEmailAddress.Text = UserEntity.Email; }
/// <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="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); }
public List<BaseStaffEntity> Convert2StaffEntitys(DataTable dt) { foreach (DataRow dr in dt.Rows) { int tempint = 0; BaseStaffEntity staff = new BaseStaffEntity(); staff.Age = dr[dataTable2ExcelField["Age".ToLower()]].ToString(); staff.BankCode = dr[dataTable2ExcelField["BankCode".ToLower()]].ToString(); staff.Birthday = dr[dataTable2ExcelField["Birthday".ToLower()]].ToString(); staff.CarCode = dr[dataTable2ExcelField["CarCode".ToLower()]].ToString(); staff.Code = dr[dataTable2ExcelField["Code".ToLower()]].ToString(); staff.CompanyId = dr[dataTable2ExcelField["CompanyId".ToLower()]].ToString(); staff.Competency = dr[dataTable2ExcelField["Competency".ToLower()]].ToString(); staff.CreateBy = dr[dataTable2ExcelField["CreateBy".ToLower()]].ToString(); staff.CreateOn = Convert.ToDateTime(dr[dataTable2ExcelField["CreateOn".ToLower()]]); staff.CreateUserId = dr[dataTable2ExcelField["CreateUserId".ToLower()]].ToString(); staff.Degree = dr[dataTable2ExcelField["Degree".ToLower()]].ToString(); staff.DeletionStateCode = Convert.ToInt32(dr[dataTable2ExcelField["DeletionStateCode".ToLower()]]); staff.DepartmentId = dr[dataTable2ExcelField["DepartmentId".ToLower()]].ToString(); staff.Description = dr[dataTable2ExcelField["Description".ToLower()]].ToString(); staff.DimissionCause = dr[dataTable2ExcelField["DimissionCause".ToLower()]].ToString(); staff.DimissionDate = dr[dataTable2ExcelField["DimissionDate".ToLower()]].ToString(); staff.DimissionWhither = dr[dataTable2ExcelField["DimissionWhither".ToLower()]].ToString(); staff.DutyId = dr[dataTable2ExcelField["DutyId".ToLower()]].ToString(); staff.Education = dr[dataTable2ExcelField["Education".ToLower()]].ToString(); staff.Email = dr[dataTable2ExcelField["Email".ToLower()]].ToString(); staff.EmergencyContact = dr[dataTable2ExcelField["EmergencyContact".ToLower()]].ToString(); staff.Enabled = Convert.ToInt32(dr[dataTable2ExcelField["Enabled".ToLower()]]); staff.Gender = dr[dataTable2ExcelField["Gender".ToLower()]].ToString(); staff.GraduationDate = dr[dataTable2ExcelField["GraduationDate".ToLower()]].ToString(); staff.HomeAddress = dr[dataTable2ExcelField["HomeAddress".ToLower()]].ToString(); staff.HomeFax = dr[dataTable2ExcelField["HomeFax".ToLower()]].ToString(); staff.HomePhone = dr[dataTable2ExcelField["HomePhone".ToLower()]].ToString(); staff.HomeZipCode = dr[dataTable2ExcelField["HomeZipCode".ToLower()]].ToString(); staff.Id = Convert.ToInt32(dr[dataTable2ExcelField["Id".ToLower()]]); staff.IDCard = dr[dataTable2ExcelField["IdCard".ToLower()]].ToString(); staff.IdentificationCode = dr[dataTable2ExcelField["IdentificationCode".ToLower()]].ToString(); if(int.TryParse(dr[dataTable2ExcelField["IsDimission".ToLower()]].ToString(),out tempint)) staff.IsDimission = tempint; staff.JoinInDate = dr[dataTable2ExcelField["JoinInDate".ToLower()]].ToString(); staff.Major = dr[dataTable2ExcelField["Major".ToLower()]].ToString(); staff.Mobile = dr[dataTable2ExcelField["Mobile".ToLower()]].ToString(); staff.ModifiedBy = dr[dataTable2ExcelField["ModifiedBy".ToLower()]].ToString(); staff.ModifiedOn = Convert.ToDateTime(dr[dataTable2ExcelField["ModifiedOn".ToLower()]]); staff.ModifiedUserId = dr[dataTable2ExcelField["ModifiedUserId".ToLower()]].ToString(); staff.Nation = dr[dataTable2ExcelField["Nation".ToLower()]].ToString(); staff.Nationality = dr[dataTable2ExcelField["Nationality".ToLower()]].ToString(); staff.NativePlace = dr[dataTable2ExcelField["NativePlace".ToLower()]].ToString(); staff.OfficeAddress = dr[dataTable2ExcelField["OfficeAddress".ToLower()]].ToString(); staff.OfficeFax = dr[dataTable2ExcelField["OfficeFax".ToLower()]].ToString(); staff.OfficePhone = dr[dataTable2ExcelField["OfficePhone".ToLower()]].ToString(); staff.OfficeZipCode = dr[dataTable2ExcelField["OfficeZipCode".ToLower()]].ToString(); staff.OICQ = dr[dataTable2ExcelField["OICQ".ToLower()]].ToString(); staff.Party = dr[dataTable2ExcelField["Party".ToLower()]].ToString(); staff.RealName = dr[dataTable2ExcelField["RealName".ToLower()]].ToString(); staff.School = dr[dataTable2ExcelField["School".ToLower()]].ToString(); staff.ShortNumber = dr[dataTable2ExcelField["ShortNumber".ToLower()]].ToString(); staff.SortCode = Convert.ToInt32(dr[dataTable2ExcelField["SortCode".ToLower()]]); staff.Telephone = dr[dataTable2ExcelField["Telephone".ToLower()]].ToString(); staff.TitleDate = dr[dataTable2ExcelField["TitleDate".ToLower()]].ToString(); staff.TitleId = dr[dataTable2ExcelField["TitleId".ToLower()]].ToString(); staff.TitleLevel = dr[dataTable2ExcelField["TitleLevel".ToLower()]].ToString(); tempint = Convert.ToInt32(dr[dataTable2ExcelField["UserId".ToLower()]]); if (tempint > 0) staff.UserId = tempint; staff.UserName = dr[dataTable2ExcelField["UserName".ToLower()]].ToString(); staff.WorkgroupId = dr[dataTable2ExcelField["WorkgroupId".ToLower()]].ToString(); staff.WorkingDate = dr[dataTable2ExcelField["WorkingDate".ToLower()]].ToString(); staff.WorkingProperty = dr[dataTable2ExcelField["WorkingProperty".ToLower()]].ToString(); staffs.Add(staff); //user.Code = dr["编号".ToLower()].ToString().Trim(); //user.RealName = dr["姓名".ToLower()].ToString().Trim(); //user.UserName = dr["登录名".ToLower()].ToString().Trim(); //user.QuickQuery = dr["快速查询".ToLower()].ToString().Trim(); //user.RoleId = DotNetService.Instance.RoleService.GetDataTableByRoleName(UserInfo, dr["默认角色".ToLower()].ToString()).Rows[0][BaseRoleEntity.FieldId].ToString().Trim(); //user.WorkCategory = dr["工作行业".ToLower()].ToString().Trim(); //user.CompanyId = DotNetService.Instance.OrganizeService.GetCompanyDTByName(UserInfo, dr["公司名称".ToLower()].ToString()).Rows[0][BaseOrganizeEntity.FieldId].ToString().Trim(); //user.CompanyName = dr["公司名称".ToLower()].ToString().Trim(); //user.DepartmentId = DotNetService.Instance.OrganizeService.GetDepartmentDTByName(UserInfo, dr["部门名称".ToLower()].ToString()).Rows[0][BaseOrganizeEntity.FieldId].ToString().Trim(); //user.DepartmentName = dr["部门名称".ToLower()].ToString().Trim(); //user.Gender = dr["性别".ToLower()].ToString().Trim(); //user.Mobile = dr["手机".ToLower()].ToString().Trim(); //user.Telephone = dr["电话号码".ToLower()].ToString().Trim(); //user.Birthday = dr["出生日期".ToLower()].ToString().Trim(); //user.Duty = dr["岗位".ToLower()].ToString().Trim(); //user.Title = dr["职称".ToLower()].ToString().Trim(); //user.UserPassword = dr["用户密码".ToLower()].ToString().Trim(); //user.OICQ = dr["QQ号码".ToLower()].ToString().Trim(); //user.Email = dr["电子邮件".ToLower()].ToString().Trim(); //user.Description = dr["描述".ToLower()].ToString().Trim(); //users.Add(user); } return staffs; }
/// <summary> /// 获取员工数据 /// </summary> /// <returns>员工实体</returns> private BaseStaffEntity GetStaffEntity() { BaseStaffEntity staffEntity = new BaseStaffEntity(); staffEntity.Code = this.txtCode.Text; staffEntity.UserId = BaseBusinessLogic.ConvertToInt(this.EntityId); staffEntity.RealName = this.txtRealName.Text; staffEntity.UserName = StringUtil.GetPinyin(staffEntity.RealName); if (this.cmbGender.SelectedValue != null) { staffEntity.Gender = this.cmbGender.Text; } staffEntity.Email = this.txtEmail.Text; staffEntity.Mobile = this.txtMobile.Text; staffEntity.Telephone = this.txtTelephone.Text; staffEntity.Enabled = this.chkEnabled.Checked ? 1 : 0; return staffEntity; }
/// <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="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); }
/// <summary> /// 更新 /// </summary> /// <param name="baseStaffEntity">实体</param> public int Update(BaseStaffEntity baseStaffEntity) { return this.UpdateEntity(baseStaffEntity); }
/// <summary> /// 员工实体转换为用户实体 /// </summary> /// <param name="staffEntity">员工实体</param> /// <param name="userInfo">用户实体</param> /// <returns>用户实体</returns> public BaseUserInfo ConvertToUserInfo(BaseStaffEntity staffEntity, BaseUserInfo userInfo) { // userInfo.Id = staffEntity.Id; userInfo.StaffId = staffEntity.Id.ToString(); userInfo.Code = staffEntity.Code; if (string.IsNullOrEmpty(userInfo.UserName)) { userInfo.UserName = staffEntity.UserName; } if (string.IsNullOrEmpty(userInfo.RealName)) { userInfo.RealName = staffEntity.RealName; } // 需要修正 userInfo.CompanyId = staffEntity.CompanyId; // userInfo.CompanyCode = staffEntity.CompanyCode; // userInfo.CompanyName = staffEntity.CompanyName; userInfo.SubCompanyId = staffEntity.SubCompanyId; userInfo.DepartmentId = staffEntity.DepartmentId; // userInfo.DepartmentCode = staffEntity.DepartmentCode; // userInfo.DepartmentName = staffEntity.DepartmentName; userInfo.WorkgroupId = staffEntity.WorkgroupId; // userInfo.WorkgroupCode = staffEntity.WorkgroupCode; // userInfo.WorkgroupName = staffEntity.WorkgroupName; return userInfo; }
/// <summary> /// 批量进行保存 /// </summary> /// <param name="dataSet">数据表</param> /// <returns>影响行数</returns> public override int BatchSave(DataTable dataTable) { int returnValue = 0; foreach (DataRow dataRow in dataTable.Rows) { // 删除状态 if (dataRow.RowState == DataRowState.Deleted) { string id = dataRow[BaseStaffEntity.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { returnValue += this.DeleteEntity(id); } } // 被修改过 if (dataRow.RowState == DataRowState.Modified) { string id = dataRow[BaseStaffEntity.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { BaseStaffEntity staffEntity = new BaseStaffEntity(dataRow); returnValue += this.UpdateEntity(staffEntity); } } // 添加状态 if (dataRow.RowState == DataRowState.Added) { BaseStaffEntity staffEntity = new BaseStaffEntity(dataRow); returnValue += this.AddEntity(staffEntity).Length > 0 ? 1 : 0; } if (dataRow.RowState == DataRowState.Unchanged) { continue; } if (dataRow.RowState == DataRowState.Detached) { continue; } } this.ReturnStatusCode = StatusCode.OK.ToString(); return returnValue; }
/// <summary> /// 批量保存 /// </summary> private void BatchSave() { // 去掉未修改的数据,提高运行速度 for (int i = this.DTStaff.Rows.Count - 1; i >= 0; i--) { if (this.DTStaff.Rows[i].RowState == DataRowState.Unchanged) { this.DTStaff.Rows.RemoveAt(i); } } List<BaseStaffEntity> staffEntites = new List<BaseStaffEntity>(); for (int i = 0; i < this.DTStaff.Rows.Count; i++) { BaseStaffEntity staffEntity = new BaseStaffEntity(this.DTStaff.Rows[i]); staffEntites.Add(staffEntity); } string statusCode = string.Empty; string statusMessage = string.Empty; DotNetService.Instance.StaffService.BatchUpdateAddress(this.UserInfo, staffEntites, out statusCode, out statusMessage); this.DTStaff = DotNetService.Instance.StaffService.GetAddressDataTable(UserInfo, this.OrganizeId, this.txtSearch.Text); // 绑定屏幕数据 this.BindData(); if (BaseSystemInfo.ShowInformation) { // 批量保存,进行提示 MessageBox.Show(AppMessage.MSG0012, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void ShowUser() { // 显示用户数据 this.txtUserName.Text = userEntity.UserName; this.txtRealName.Text = userEntity.RealName; this.txtCode.Text = userEntity.Code; this.txtMobile.Text = userEntity.Mobile; this.txtEmail.Text = userEntity.Email; if (userEntity.RoleId != null) { this.cmbRole.SelectedValue = userEntity.RoleId.ToString(); } this.ucCompany.SelectedId = userEntity.CompanyId; this.ucSubCompany.SelectedId = userEntity.SubCompanyId; this.ucDepartment.SelectedId = userEntity.DepartmentId; this.ucWorkgroup.SelectedId = userEntity.WorkgroupId; this.chbEnabled.Checked = (userEntity.Enabled == 1); this.txtDescription.Text = userEntity.Description; // 获取用户对应的员工信息 if (this.userEntity.Id != null) { // 加载员工 BaseStaffManager staffManager = new BaseStaffManager(UserInfo); this.staffEntity = new BaseStaffEntity(staffManager.GetDataTable(BaseStaffEntity.FieldUserId, userEntity.Id.ToString())); } }
public FrmStaffAdd(BaseStaffEntity entity) : this() { this.staffEntity = entity; }
/// <summary> /// 员工信息 /// </summary> /// <returns>实体</returns> private BaseStaffEntity GetStaffEntity() { BaseStaffEntity staffEntity = new BaseStaffEntity(); staffEntity.RealName = this.txtRealName.Text; if (this.cmbGender.SelectedValue == null) { staffEntity.Gender = null; } else { staffEntity.Gender = this.cmbGender.SelectedValue.ToString(); } if (this.dtpBirthday.Checked) { staffEntity.Birthday = this.dtpBirthday.Value.ToString(BaseSystemInfo.DateFormat); } else { staffEntity.Birthday = null; } staffEntity.Code = this.txtCode.Text; staffEntity.Party = null; if (this.cmbParty.SelectedValue != null && this.cmbParty.SelectedValue.ToString() != "") { staffEntity.Party = this.cmbParty.SelectedValue.ToString(); } staffEntity.Nationality = null; if (this.cmbNationality.SelectedValue != null && this.cmbNationality.SelectedValue.ToString() != "") { staffEntity.Nationality = this.cmbNationality.SelectedValue.ToString(); } staffEntity.CompanyId = null; if (!string.IsNullOrEmpty(this.ucCompany.SelectedId)) { staffEntity.CompanyId = this.ucCompany.SelectedId; } staffEntity.SubCompanyId = null; if (!string.IsNullOrEmpty(this.ucSubCompany.SelectedId)) { staffEntity.SubCompanyId = this.ucSubCompany.SelectedId; } staffEntity.DepartmentId = null; if (!string.IsNullOrEmpty(this.ucDepartment.SelectedId)) { staffEntity.DepartmentId = this.ucDepartment.SelectedId; } staffEntity.WorkgroupId = null; if (!string.IsNullOrEmpty(this.ucWorkgroup.SelectedId)) { staffEntity.WorkgroupId = this.ucWorkgroup.SelectedId; } staffEntity.DutyId = null; if (this.cmbDuty.SelectedValue != null && this.cmbDuty.SelectedValue.ToString() != "") { staffEntity.DutyId = this.cmbDuty.SelectedValue.ToString(); } staffEntity.TitleId = null; if (this.cmbTitle.SelectedValue != null && this.cmbTitle.SelectedValue.ToString() != "") { staffEntity.TitleId = this.cmbTitle.SelectedValue.ToString(); } if (this.dtpWorkingDate.Checked) { staffEntity.WorkingDate = this.dtpWorkingDate.Value.ToString(BaseSystemInfo.DateFormat); } else { staffEntity.WorkingDate = null; } if (this.dtpJoinInDate.Checked) { staffEntity.JoinInDate = this.dtpJoinInDate.Value.ToString(BaseSystemInfo.DateFormat); } else { staffEntity.JoinInDate = null; } staffEntity.IDCard = this.txtIdCard.Text; staffEntity.WorkingProperty = null; if (this.cmbWorkingProperty.SelectedValue != null && this.cmbWorkingProperty.SelectedValue.ToString() != "") { staffEntity.WorkingProperty = this.cmbWorkingProperty.SelectedValue.ToString(); } staffEntity.OICQ = this.txtOICQ.Text; staffEntity.OfficePhone = this.txtOfficePhone.Text; staffEntity.ShortNumber = this.txtShortNumber.Text; staffEntity.Email = this.txtEmail.Text; staffEntity.Mobile = this.txtMobile.Text; staffEntity.School = this.txtSchool.Text; staffEntity.Major = this.txtMajor.Text; staffEntity.Education = null; if (this.cmbEducation.SelectedValue != null && this.cmbEducation.SelectedValue.ToString() != "") { staffEntity.Education = this.cmbEducation.SelectedValue.ToString(); } staffEntity.Degree = null; if (this.cmbDegree.SelectedValue != null && this.cmbDegree.SelectedValue.ToString() != "") { staffEntity.Degree = this.cmbDegree.SelectedValue.ToString(); } staffEntity.BankCode = this.txtBankCode.Text; staffEntity.UserName = this.txtUserName.Text; staffEntity.HomeAddress = this.txtHomeAddress.Text; staffEntity.HomePhone = this.txtHomePhone.Text; staffEntity.CarCode = this.txtCarCode.Text; staffEntity.EmergencyContact = this.txtEmergencyContact.Text; staffEntity.Description = this.txtDescription.Text; staffEntity.DeletionStateCode = 0; staffEntity.Enabled = this.chbEnabled.Checked ? 1 : 0; if (this.cmbProvince.SelectedValue.ToString() != "-1") staffEntity.Province = this.cmbProvince.Text; else { staffEntity.Province = string.Empty; } if (this.cmbCity.SelectedValue.ToString() != "-1") staffEntity.City = this.cmbCity.Text; else { staffEntity.City = string.Empty; } if (this.cmbArea.SelectedValue.ToString() != "-1") staffEntity.Area = this.cmbArea.Text; else { staffEntity.Area = string.Empty; } return staffEntity; }
/// <summary> /// 扮演用户 /// </summary> /// <param name="id">用户主键</param> /// <returns>用户类</returns> public BaseUserInfo Impersonation(string id, out string statusCode) { BaseUserInfo userInfo = null; // 获得登录信息 DataTable dataTableLogOn = this.GetDataTableById(id); BaseUserEntity userEntity = new BaseUserEntity(); userEntity.GetSingle(dataTableLogOn); // 只允许登录一次,需要检查是否自己重新登录了,或者自己扮演自己了 if (!UserInfo.Id.Equals(id)) { if (BaseSystemInfo.CheckOnLine) { if (userEntity.UserOnLine > 0) { statusCode = StatusCode.ErrorOnLine.ToString(); return userInfo; } } } 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(staffEntity, userInfo); } statusCode = StatusCode.OK.ToString(); // 登录、重新登录、扮演时的在线状态进行更新 this.ChangeOnLine(id); return userInfo; }
/// <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 == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (DbHelper.CurrentDbType == DbTypes.Oracle) { sqlBuilder.SetFormula(BaseStaffEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == DbTypes.DB2) { sqlBuilder.SetFormula(BaseStaffEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.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 == DbTypes.SqlServer || DbHelper.CurrentDbType == DbTypes.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="staffEntity">实体</param> /// <param name="isUser">是否用户</param> /// <param name="statusCode">返回状态码</param> /// <returns>影响行数</returns> public int Update(BaseStaffEntity staffEntity, out string statusCode) { int returnValue = 0; // 检查编号是否重复 if (!string.IsNullOrEmpty(staffEntity.Code) && this.Exists(new KeyValuePair<string, object>(BaseStaffEntity.FieldCode, staffEntity.Code), new KeyValuePair<string, object>(BaseStaffEntity.FieldDeletionStateCode, 0), staffEntity.Id)) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } else { // 用户名是空的,不判断是否重复了 if (!String.IsNullOrEmpty(staffEntity.UserName) && this.Exists(new KeyValuePair<string, object>(BaseStaffEntity.FieldUserName, staffEntity.UserName), new KeyValuePair<string, object>(BaseStaffEntity.FieldDeletionStateCode, 0), staffEntity.Id)) { // 名称已重复 statusCode = StatusCode.ErrorUserExist.ToString(); } else { returnValue = this.UpdateEntity(staffEntity); // 按员工的修改信息,把用户信息进行修改 this.UpdateUser(staffEntity.Id.ToString()); if (returnValue > 0) { statusCode = StatusCode.OKUpdate.ToString(); } else { statusCode = StatusCode.ErrorDeleted.ToString(); } } } return returnValue; }
/// <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> /// 更新 /// </summary> /// <param name="staffEntity">实体类</param> /// <returns>影响行数</returns> public int UpdateAddress(BaseStaffEntity staffEntity, out string statusCode) { int returnValue = 0; // 检查是否已被其他人修改 //if (DbLogic.IsModifed(DbHelper, BaseStaffEntity.TableName, staffEntity.Id, staffEntity.ModifiedUserId, staffEntity.ModifiedOn)) //{ // // 数据已经被修改 // statusCode = StatusCode.ErrorChanged.ToString(); //} //else //{ // 进行更新操作 returnValue = this.UpdateEntity(staffEntity); if (returnValue == 1) { // 按员工的修改信息,把用户信息进行修改 this.UpdateUser(staffEntity.Id.ToString()); statusCode = StatusCode.OKUpdate.ToString(); } else { // 数据可能被删除 statusCode = StatusCode.ErrorDeleted.ToString(); } //} return returnValue; }
// 这个是声明扩展方法 partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseStaffEntity baseStaffEntity);
/// <summary> /// 按员工的修改信息,把用户信息进行修改 /// </summary> /// <param name="staffId">员工主键</param> /// <returns>影响行数</returns> public int UpdateUser(string staffId) { DataTable dataTable = this.GetDataTable(BaseStaffEntity.FieldId, staffId); BaseStaffEntity staffEntity = new BaseStaffEntity(dataTable); if (staffEntity.UserId > 0) { // 员工信息改变时,用户信息也跟着改变。 BaseUserManager userManager = new BaseUserManager(DbHelper, UserInfo); BaseUserEntity userEntity = userManager.GetEntity(staffEntity.UserId); // userEntity.Company = staffEntity.CompanyName; // userEntity.Department = staffEntity.DepartmentName; // userEntity.Workgroup = staffEntity.WorkgroupName; userEntity.UserName = staffEntity.UserName; userEntity.RealName = staffEntity.RealName; userEntity.Code = staffEntity.Code; userEntity.Email = staffEntity.Email; userEntity.Enabled = staffEntity.Enabled; // userEntity.Duty = staffEntity.DutyName; // userEntity.Title = staffEntity.TitleName; userEntity.Gender = staffEntity.Gender; userEntity.Birthday = staffEntity.Birthday; userEntity.Mobile = staffEntity.Mobile; } return 0; }
/// <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="staffEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <returns>主键</returns> public string Add(BaseStaffEntity staffEntity, out string statusCode) { string returnValue = string.Empty; if (!string.IsNullOrEmpty(staffEntity.UserName) && this.Exists(new KeyValuePair<string, object>(BaseStaffEntity.FieldUserName, staffEntity.UserName), new KeyValuePair<string, object>(BaseStaffEntity.FieldDeletionStateCode, 0))) { // 名称已重复 statusCode = StatusCode.ErrorUserExist.ToString(); } else { // 检查编号是否重复 if (!string.IsNullOrEmpty(staffEntity.Code) && this.Exists(new KeyValuePair<string, object>(BaseStaffEntity.FieldCode, staffEntity.Code), new KeyValuePair<string, object>(BaseStaffEntity.FieldDeletionStateCode, 0))) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } else { returnValue = this.AddEntity(staffEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } } return returnValue; }
/// <summary> /// 从Excel文件导入(员工) /// </summary> /// <param name="filePath"></param> /// <returns></returns> private bool DoImport(string filePath) { bool returnValue = false; // 鼠标忙碌状态 this.Cursor = Cursors.WaitCursor; try { //将Excel表转换为DataTable string error = ""; DataTable dataTable = new DataTable(); AsposeExcelTools.ExcelFileToDataTable(filePath, out dataTable, out error); //检查Excell转为DataTable是否成功 if (error != "") { MessageBox.Show(error, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } //是否有记录 if (dataTable.Rows.Count > 0) { //将第一行数据给数据列置名称,以便于识别和调用数据。 int columnsCount = 0; for (columnsCount = 0; columnsCount < dataTable.Columns.Count; columnsCount++) { dataTable.Columns[columnsCount].ColumnName = dataTable.Rows[0][columnsCount].ToString().Trim(); } //循环处理每行数据 int rowsCount = 0; int errorCount = 0; BaseStaffEntity tempentity; string statusCode = string.Empty; string statusMessage = string.Empty; DataTable dt = DotNetService.Instance.StaffService.GetDataTable(UserInfo); for (rowsCount = 1; rowsCount < dataTable.Rows.Count; rowsCount++) { //角色名称不允许导入重复项 bool exists = BaseBusinessLogic.Exists(dt, BaseStaffEntity.FieldRealName, dataTable.Rows[rowsCount][BaseStaffEntity.FieldRealName].ToString()); if (!exists) { //清空实体 tempentity = new BaseStaffEntity(); //给实体赋值(以下只导入部分字段, //如要导入更多信息,只需按下面格式添加不同的字段行就行了,注意导入的excel表中也要有相应的列) tempentity.RealName = dataTable.Rows[rowsCount][BaseStaffEntity.FieldRealName].ToString(); tempentity.Gender = dataTable.Rows[rowsCount][BaseStaffEntity.FieldGender].ToString(); tempentity.CompanyId = dataTable.Rows[rowsCount][BaseStaffEntity.FieldCompanyId].ToString(); tempentity.DepartmentId = dataTable.Rows[rowsCount][BaseStaffEntity.FieldDepartmentId].ToString(); tempentity.Code = dataTable.Rows[rowsCount][BaseStaffEntity.FieldCode].ToString(); tempentity.Mobile = dataTable.Rows[rowsCount][BaseStaffEntity.FieldMobile].ToString(); tempentity.Enabled = 1; tempentity.DeletionStateCode = 0; DotNetService.Instance.StaffService.AddStaff(UserInfo, tempentity, out statusCode, out statusMessage); } else { errorCount++; } } this.Changed = true; returnValue = true; MessageBox.Show("共有" + (dataTable.Rows.Count - 1) + "条记录," + (dataTable.Rows.Count - 1 - errorCount).ToString() + "条记录被成功导入!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { this.ProcessException(ex); } finally { // 设置鼠标默认状态 this.Cursor = Cursors.Default; } return returnValue; }
/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { // 绑定下拉筐数据 this.BindItemDetails(); this.staffEntity = DotNetService.Instance.StaffService.GetEntity(UserInfo, this.StaffId); // 显示内容 this.ShowStaffEntity(); }
/// <summary> /// 显示内容 /// </summary> public override void ShowEntity() { if (string.IsNullOrEmpty(this.EntityId)) { return; } staffEntity = DotNetService.Instance.StaffService.GetEntity(UserInfo, this.EntityId); userEntity = DotNetService.Instance.UserService.GetEntity(UserInfo, staffEntity.UserId.ToString()); // 将类转显示到页面 this.txtRealName.Tag = staffEntity.Id; this.txtRealName.Text = staffEntity.RealName; this.txtCompany.Tag = staffEntity.CompanyId; if (staffEntity.CompanyId != null) { BaseOrganizeEntity organizeEntity = DotNetService.Instance.OrganizeService.GetEntity(this.UserInfo, staffEntity.CompanyId); this.txtCompany.Text = organizeEntity.FullName; } this.txtDepartment.Tag = staffEntity.DepartmentId; if (staffEntity.DepartmentId != null) { BaseOrganizeEntity organizeEntity = DotNetService.Instance.OrganizeService.GetEntity(this.UserInfo, staffEntity.DepartmentId); this.txtDepartment.Text = organizeEntity.FullName; } this.txtDuty.Tag = staffEntity.DutyId; if (staffEntity.DutyId != null) { BaseItemDetailsEntity itemDetailsEntity = DotNetService.Instance.ItemDetailsService.GetEntity(this.UserInfo, "ItemsDuty", staffEntity.DutyId.ToString()); this.txtDuty.Text = itemDetailsEntity.ItemName; } this.txtOfficeTel.Text = staffEntity.OfficePhone; this.txtMobile.Text = staffEntity.Mobile; this.txtShortNumber.Text = staffEntity.ShortNumber; this.txtOICQ.Text = staffEntity.OICQ; this.txtEmail.Text = staffEntity.Email; this.txtDescription.Text = staffEntity.Description; this.txtSignature.Text = userEntity.Signature; // 获取图片部分,显示图片部分 string fileId = DotNetService.Instance.ParameterService.GetParameter(UserInfo, "Staff", staffEntity.Id.ToString(), "StaffPictureId"); if (!String.IsNullOrEmpty(fileId)) { this.ucPicture.PictureId = fileId; } this.btnSave.Enabled = false; this.txtOfficeTel.Focus(); }
/// <summary> /// 添加 /// </summary> /// <param name="baseStaffEntity">实体</param> /// <returns>主键</returns> public string Add(BaseStaffEntity baseStaffEntity) { return this.AddEntity(baseStaffEntity); }