/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { // 绑定下拉筐数据 this.BindItemDetails(); this.staffEntity = DotNetService.Instance.StaffService.GetEntity(UserInfo, this.StaffId); // 显示内容 this.ShowStaffEntity(); }
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; }
private void btnLikeAdd_Click(object sender, EventArgs e) { BaseStaffEntity entity = GetEntity(); entity.Id = null; FrmStaffAdd frmModuleAdd = new FrmStaffAdd(entity); frmModuleAdd.ShowDialog(); }
/// <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="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> 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="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> /// <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 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="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="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.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> /// <returns>保存成功</returns> private bool SaveEntity(bool closeForm) { // 设置鼠标繁忙状态,并保留原先的状态 Cursor holdCursor = this.Cursor; this.Cursor = Cursors.WaitCursor; bool returnValue = true; string statusCode = string.Empty; string statusMessage = string.Empty; // 转换数据 try { // 先处理是否创建了用户 string userId = string.Empty; if (this.chbCreateUser.Checked) { BaseUserEntity userEntity = this.GetUserEntity(); userId = DotNetService.Instance.UserService.AddUser(UserInfo, userEntity, out statusCode, out statusMessage); if (statusCode != StatusCode.OKAdd.ToString()) { MessageBox.Show(statusMessage, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); // 是否编号重复了,提高友善性 if (statusCode == StatusCode.ErrorCodeExist.ToString()) { this.txtCode.SelectAll(); this.txtCode.Focus(); } // 是否用户名重复了,提高友善性 if (statusCode == StatusCode.ErrorUserExist.ToString()) { this.txtUserName.SelectAll(); this.txtUserName.Focus(); } returnValue = false; } // 判断如果不能创建用户直接退出 if (returnValue == false) { return(returnValue); } } // 再处理员工信息 BaseStaffEntity staffEntity = this.GetStaffEntity(); if (this.chbCreateUser.Checked) { staffEntity.UserId = int.Parse(userId); } this.EntityId = DotNetService.Instance.StaffService.AddStaff(UserInfo, staffEntity, out statusCode, out statusMessage); // 添加员工的照片 if (!string.IsNullOrEmpty(this.EntityId)) { string pictureContent = string.Empty; pictureContent = this.ucPicture.Upload("StaffPicture", this.EntityId); //判断图片是否为空,如果为空说明没有图片不再执行 dfhjc if (pictureContent != "") { DotNetService.Instance.ParameterService.SetParameter(UserInfo, "Staff", this.EntityId, "StaffPictureId", pictureContent); } this.Changed = true; } if (BaseSystemInfo.ShowInformation) { // 添加成功,进行提示 MessageBox.Show(statusMessage, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); } if (statusCode == StatusCode.OKAdd.ToString() && closeForm) { // 自动关闭窗体了 this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { this.ProcessException(ex); } finally { // 设置鼠标默认状态,原来的光标状态 this.Cursor = holdCursor; } return(returnValue); }
/// <summary> /// 更新 /// </summary> /// <param name="baseStaffEntity">实体</param> public int Update(BaseStaffEntity baseStaffEntity) { return(this.UpdateEntity(baseStaffEntity)); }
public FrmStaffAdd(BaseStaffEntity entity) : this() { this.staffEntity = entity; }
public BaseStaffEntity GetEntity(int id) { BaseStaffEntity baseStaffEntity = new BaseStaffEntity(this.GetDataTable(new KeyValuePair <string, object>(BaseStaffEntity.FieldId, id))); return(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 == 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); }
// 这个是声明扩展方法 partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseStaffEntity baseStaffEntity);
/// <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); }