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