/// <summary>
/// 属性窗口的值发生变化
/// </summary>
/// <param name="s"></param>
/// <param name="e"></param>
private void propertyGrid_PropertyValueChanged(object s, PropertyValueChangedEventArgs e)
{
//获取fp中的当前行
int currentRow = this._fpDepartmentInfo.ActiveSheet.ActiveCell.Row.Index;
//定义变量,接收修改的值
string changeValue = "";
//存在修改值时
if (e.ChangedItem.Value != null)
{
//修改值的标题
string ss = e.ChangedItem.Label.ToString();
//获取fp中修改值的列索引
int columnIndex = this._fpDepartmentInfo.ActiveSheet.Columns[ss].Index;
//获取修改的值
changeValue = e.ChangedItem.Value.ToString();
if (ss == _strDeptNameLable)
{
//检测特殊字符、是否为空、是否重复
if (LibCommon.Validator.checkSpecialCharacters(changeValue) ||
LibCommon.Validator.IsEmpty(changeValue) ||
DepartmentInformationManagementBLL.FindDeptInformationByDeptName(changeValue))
{
Alert.alert(LibCommon.Const.DEPT_NAME_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
//检查字符串的长度
if (changeValue.Length > _iDeptNameLength)
{
Alert.alert(LibCommon.Const.TXT_IS_WRONG1 + _iDeptNameLength + LibCommon.Const.TXT_IS_WRONG2, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
}
//验证邮箱
if (ss == _strDeptEmailLable)
{
//邮箱格式
if (!LibCommon.Validator.checkIsEmailAddress(changeValue))
{
Alert.alert(LibCommon.Const.DEPT_EMAIL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
//检查字符串的长度
if (changeValue.Length > _iDeptEmailLength)
{
Alert.alert(LibCommon.Const.TXT_IS_WRONG1 + _iDeptEmailLength + LibCommon.Const.TXT_IS_WRONG2, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
}
//验证电话
if (ss == _strDeptTelLable)
{
//验证电话格式
if (!LibCommon.Validator.checkIsIsTelePhone(changeValue))
{
Alert.alert(LibCommon.Const.DEPT_TEL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
//检查字符串的长度
if (changeValue.Length > _iDeptTelLength)
{
Alert.alert(LibCommon.Const.TXT_IS_WRONG1 + _iDeptTelLength + LibCommon.Const.TXT_IS_WRONG2, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
}
//验证人数必须是数字
if (ss == _strDeptStuffCount)
{
if (!LibCommon.Validator.IsNumeric(changeValue))
{
Alert.alert(LibCommon.Const.DEPT_STAFF_COUNT_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
fpDepartmentInfo_SelectionChanged(null, null);
return;
}
}
//Farpoint显示修改值
this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, columnIndex].Text = changeValue;
//部门名称
string name = "";
//部门电话
string tel = "";
//部门邮箱
string email = "";
//部门人数
string staff = "";
//备注
string remark = "";
//从FarPoint上取值,检查值是否为空
if (this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 1].Value != null)
{
name = this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 1].Value.ToString();
}
if (this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 2].Value != null)
{
tel = this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 2].Value.ToString();
}
if (this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 3].Value != null)
{
email = this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 3].Value.ToString();
}
if (this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 4].Value != null)
{
staff = this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 4].Value.ToString();
}
if (this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 5].Value != null)
{
remark = this._fpDepartmentInfo.ActiveSheet.Cells[currentRow, 5].Value.ToString();
}
//旧的 部门名称
string oldName = name;
if (ss == _strDeptNameLable)
{
oldName = e.OldValue.ToString();
}
//定义 部门信息实体 接收新修改的数据
LibEntity.Department userDeptInfo = new LibEntity.Department();
//部门名称
userDeptInfo.Name = name;
//人数
userDeptInfo.Staff = staff;
//邮箱
userDeptInfo.Email = email;
//电话
userDeptInfo.Tel = tel;
//备注
userDeptInfo.Remark = remark;
//更新数据库
DepartmentInformationManagementBLL.UpdateDepartmentInfomationDatabase(userDeptInfo, oldName);
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOK_Click(object sender, EventArgs e)
{
string name = _txtName.Text.ToString().Trim();
string tel = _txtTel.Text.ToString().Trim();
string email = _txtEmail.Text.ToString().Trim();
string staff = _txtStaffCount.Text.ToString().Trim();
//查询数据库中是否已存在该部门名称
if (LibCommon.Validator.checkSpecialCharacters(name) ||
LibCommon.Validator.IsEmpty(name) ||
DepartmentInformationManagementBLL.FindDeptInformationByDeptName(name))
{
//部门名称不能为空,且不能重复
Alert.alert(LibCommon.Const.DEPT_NAME_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
//设置焦点
_txtName.Focus();
return;
}
//验证电话格式
if (!LibCommon.Validator.checkIsIsTelePhone(tel) && tel != "")
{
Alert.alert(LibCommon.Const.DEPT_TEL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_txtTel.Focus();
return;
}
//邮箱格式
if (!LibCommon.Validator.checkIsEmailAddress(email) && email != "")
{
Alert.alert(LibCommon.Const.DEPT_EMAIL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_txtEmail.Focus();
return;
}
//定义默认的部门人数
int staffNumber = 0;
//部门人数可以为空,但不能为非数字
if (!int.TryParse(_txtStaffCount.Text.ToString().Trim(), out staffNumber) && staff != "")
{
//提示用户部门人数不为数字,并设置焦点
Alert.alert(LibCommon.Const.DEPT_STAFF_COUNT_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_txtStaffCount.Focus();
return;
}
//定义部门信息实体
LibEntity.Department ent = new LibEntity.Department();
//部门名称
ent.Name = _txtName.Text.ToString().Trim();
//部门邮箱
ent.Email = _txtEmail.Text.ToString().Trim();
//部门电话
ent.Tel = _txtTel.Text.ToString().Trim();
//部门人数
ent.Staff = staffNumber.ToString();
//备注
ent.Remark = _rtxtRemarks.Text.ToString().Trim();
//添加数据到数据库
DepartmentInformationManagementBLL.InsertDeptInfoIntoTable(ent);
this.Close();
}