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);
}
