/// <summary>
/// 添加部门名称中的项
/// </summary>
private void SetComboxDepartment()
{
//清空_cbxDepartment中部门名称的值
_cboDepartment.Items.Clear();
string[] depts = UserInformationDetailsManagementBLL.GetDepartmentNames();
//需判断是否为空
if (depts != null)
{
foreach (string dept in depts)
{
//逐行添加部门名称
_cboDepartment.Items.Add(dept);
}
}
}
/// <summary>
/// 获取用户详细信息
/// </summary>
private void GetUsersInfoDetails()
{
//定义接受用户详细信息实体的数组
UserInformationDetails[] ents = UserInformationDetailsManagementBLL.GetUserInformationDetails();
//若为空，则返回
if (ents == null)
{
return;
}
//记录条数
int rowsCount = ents.Length;
this.fpUserInformationDetails.ActiveSheet.Rows.Count = rowsCount + _fpRowsTitleCount;
this.fpUserInformationDetails.ActiveSheet.Columns.Count = _fpColumnsTitleCount;
this.fpUserInformationDetails.ActiveSheet.Columns[1].Visible = false;
for (int i = 0; i < rowsCount; i++)
{
//选择
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 0].CellType = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 0].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 0].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
//ID
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 1].Text = ents[i].Id.ToString();
//姓名
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 2].Text = ents[i].Name;
//手机号码
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 3].Text = DisPlayPhoneNumber(ents[i].PhoneNumber);
//电话号码
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 4].Text = ents[i].TelePhoneNumber;
//Email
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 5].Text = ents[i].Email;
//所属部门
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 6].Text = ents[i].Depratment;
//职位
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 7].Text = ents[i].Position;
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 8].Text = ents[i].IsInform == 0 ? "否" : "是";
//备注
this.fpUserInformationDetails.ActiveSheet.Cells[i + 2, 9].Text = ents[i].Remarks;
}
//设置焦点
this.fpUserInformationDetails.ActiveSheet.SetActiveCell(1, 0);
//记录当前farpoint的记录条数
_fpRowsCount = this.fpUserInformationDetails.ActiveSheet.Rows.Count;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnModify_Click(object sender, EventArgs e)
{
if (_userSel.Count == 0)
{
//管理界面没有选择时，返回
return;
}
//定义用户登录信息实体，接收旧值，添加到窗体中。旧值来源于管理界面的选择值。可以直接取值，也可从数据库取值，暂不考虑效率，以下代码从数据库取值。
UserInformationDetails ent = UserInformationDetailsManagementBLL.GetUserLoginInformationByID(_userSel[0]);
//修改
UserInformationDetailsInput uidi = new UserInformationDetailsInput(ent);
uidi.ShowDialog();
//刷新显示的用户信息
GetUsersInfoDetails();
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnDel_Click(object sender, EventArgs e)
{
if (Alert.confirm(LibCommon.Const.DELETE_STUFF_INFO, LibCommon.Const.NOTES, MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
//获取登录用户记录条数
int n = UserInformationDetailsManagementBLL.GetRecordCountFromTable();
//从数据末尾删除数据
for (int i = n - 1; i >= 0; i--)
{
if (this.fpUserInformationDetails.ActiveSheet.Cells[2 + i, 0].CellType is FarPoint.Win.Spread.CellType.CheckBoxCellType)
{
if (this.fpUserInformationDetails.ActiveSheet.Cells[2 + i, 0].Value != null)
{
if ((bool)this.fpUserInformationDetails.ActiveSheet.Cells[2 + i, 0].Value)
{
this.fpUserInformationDetails.ActiveSheet.Rows.Remove(2 + i, 1);
//删除一行数据后,在数据末尾加一行
//this.fpUserInformationDetails.ActiveSheet.Rows.Add(n - 1 + 2, 1);
//this.fpUserLoginInformation.ActiveSheet.Rows[n - 1 + 2].BackColor = Color.Red;//显示颜色直观显示追加行位置，方便调试观察，代码在后期删除
}
}
}
}
//遍历 记录用户信息的数组，删除数据库中的数据
foreach (int id in _userSel)
{
UserInformationDetailsManagementBLL.DeleteUserLoginInformationByID(id);
}
_userSel.Clear();
//设置删除按钮是否启用
this.tsBtnDel.Enabled = (_userSel.Count >= 1) ? true : false;
//设置修改按钮是否启用
this.tsBtnModify.Enabled = (_userSel.Count == 1) ? true : false;
//刷新数据
fpUserInformationDetails.Refresh();
//设置焦点
this.fpUserInformationDetails.ActiveSheet.SetActiveCell(UserInformationDetailsManagementBLL.GetRecordCountFromTable() + 1, 0);
//记录当前farpoint的记录条数
_fpRowsCount = this.fpUserInformationDetails.ActiveSheet.Rows.Count;
}
}
/// <summary>
/// 点击确定按钮出发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOK_Click(object sender, EventArgs e)
{
//定义接收界面信息的实体
UserInformationDetails ent = new UserInformationDetails();
//姓名
ent.Name = _txtName.Text;
//手机号码
ent.PhoneNumber = _txtPhoneNumber.Text;
//电话号码
ent.TelePhoneNumber = _txtTel.Text;
//邮箱
ent.Email = _txtEmail.Text;
ent.IsInform = rbtnInformNo.Checked == true ? 0 : 1;
//部门
if (_cboDepartment.SelectedItem != null)
{
ent.Depratment = _cboDepartment.SelectedItem.ToString();
}
//职称
ent.Position = _txtPosition.Text;
//备注
ent.Remarks = _rtxtRemark.Text;
//姓名不能存在特殊字符，且不能为空
if (LibCommon.Validator.checkSpecialCharacters(ent.Name) || LibCommon.Validator.IsEmptyOrBlank(ent.Name))
{
Alert.alert(LibCommon.Const.NAME_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
_txtName.Focus();
//解决return后，窗体消失的bug
DialogResult = DialogResult.None;
return;
}
//检查手机号码，可以为空但不能格式错误
//if (_txtPhoneNumber.Text != "")
//{
// if (!LibCommon.Validator.checkIsPhoneNumber(_txtPhoneNumber.Text))
// {
// Alert.alert(LibCommon.Const.PHONE_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
// this._txtPhoneNumber.Focus();
// return;
// }
//}
//检查电话号码，可以为空但不能格式错误
//if (_txtTel.Text != "")
//{
// if (!LibCommon.Validator.checkIsIsTelePhone(_txtTel.Text))
// {
// Alert.alert(LibCommon.Const.TEL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
// this._txtTel.Focus();
// return;
// }
//}
//检查邮箱，可以为空但不能格式错误
if (_txtEmail.Text != "")
{
if (!LibCommon.Validator.checkIsEmailAddress(_txtEmail.Text))
{
Alert.alert(LibCommon.Const.EMAIL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this._txtEmail.Focus();
return;
}
}
//添加
if (_strIsAddOrModify == "add")
{
//添加用户详细信息
UserInformationDetailsManagementBLL.InsertUserInformationDetailsIntoTable(ent);
}
//修改。操作是仍需记录管理界面赋值的Id，（_userSel[0])中存放
else if (_strIsAddOrModify == "modify")
{
//修改用户详细信息
UserInformationDetailsManagementBLL.UpdataUserInformationDetails(ent, UserInformationDetailsManagement._userSel[0]);
}
this.Close();
}
/// <summary>
/// 加载预警数据
/// </summary>
public void LoadValue(string strTime)
{
// 所有绿色预警
_ents1 = PreWarningLastedResultQueryBLL.QueryLastedPreWarningResult(strTime);
// 所有红色和黄色预警
_ents2 = PreWarningLastedResultQueryBLL.QueryHoldWarningResult();
//List<PreWarningResultEntity> LibBusiness.PreWarningLastedResultQueryBLL.MergePreWarningInfo(_ents1);
if (_ents2.Count > _warningRecord.Count)
{
var ds = UserInformationDetailsManagementBLL.GetNeedSendMessageUsers();
foreach (var i in _ents2)
{
var sign = true;
foreach (var j in _warningRecord)
{
if (i.TunnelID == j.TunnelID)
{
sign = false;
}
}
if (sign)
{
var outBrustStr = "";
var overLimitStr = "";
if (i.OutBrustWarningResult.WarningResult == 0)
{
outBrustStr = "红色突出预警";
}
else if (i.OutBrustWarningResult.WarningResult == 1)
{
outBrustStr = "黄色突出预警";
}
if (i.OverLimitWarningResult.WarningResult == 0)
{
overLimitStr = "红色超限预警";
}
else if (i.OverLimitWarningResult.WarningResult == 0)
{
overLimitStr = "黄色超限预警";
}
var message = i.TunelName + " " + i.DateTime + " " + i.Date_Shift + " " + outBrustStr + " " +
overLimitStr;
var TypeStr = "";
var CopyRightToCOMStr = "";
var CopyRightStr = "//上海迅赛信息技术有限公司,网址www.xunsai.com//";
short port = 11;
var isture = SetShortMessage.Sms_Connection(CopyRightStr, port, Convert.ToInt16(9600), TypeStr,
CopyRightToCOMStr);
if (isture == 1)
{
for (var k = 0; k < ds.Tables[0].Rows.Count; k++)
{
var number =
ds.Tables[0].Rows[k][UserInformationDetailsManagementDbConstNames.USER_PHONENUMBER]
.ToString();
SetShortMessage.Sms_Send(number, message);
}
}
}
}
_warningRecord = new List <LibEntity.PreWarningResultQuery>(_ents2);
}
else
{
_warningRecord = new List <LibEntity.PreWarningResultQuery>(_ents2);
}
//var workingfaceEntNormal = new List<PreWarningResultQueryWithWorkingfaceEnt>();
//var workingfaceEntWarning = new List<PreWarningResultQueryWithWorkingfaceEnt>();
//workingfaceEntNormal = PreWarningLastedResultQueryBLL.MergePreWarningInfo(_ents1);
//workingfaceEntWarning = PreWarningLastedResultQueryBLL.MergePreWarningInfo(_ents2);
#region 除垃圾数据
while (_fpPreWaringLastedValue.ActiveSheet.Rows.Count > FROZEN_ROW_COUNT)
{
_fpPreWaringLastedValue.ActiveSheet.Rows.Remove(FROZEN_ROW_COUNT, 1);
}
//提醒语音字符串清空
_strPreWarningTxt = "";
#endregion
#region 添加标题数据
//计算时间
cells[1, 5].Value = strTime;
//管理员
cells[1, 1].Value = CurrentUser.CurLoginUserInfo.LoginName;
cells[1, 1].Locked = false;
//添加计算机名称
//this._fpPreWaringLastedValue.ActiveSheet.Cells[1, 6].Value = GetComputerName();
//编号
cells[1, 9].Value = DateTime.Now.ToShortDateString();
cells[1, 9].Locked = false;
//其他
cells[1, 12].Value = "";
#endregion
//清空提示文档
try
{
var swnull = new StreamWriter(Application.StartupPath + "\\NoticeTxt.txt", false, Encoding.UTF8);
swnull.Write(_strPreWarningTxt);
swnull.Close();
}
catch (Exception ex)
{
Alert.alert(ex.ToString());
}
var valueCount = _ents2.Count;
for (var i = 0; i < valueCount; i++)
{
addRow2Fp(FROZEN_ROW_COUNT + i, _ents2[i]);
}
valueCount = _ents1.Count;
var iTmpRowCount = FROZEN_ROW_COUNT + _ents2.Count;
for (var i = 0; i < valueCount; i++)
{
addRow2Fp(iTmpRowCount + i, _ents1[i]);
}
try
{
_speaker.Stop();
if (_strPreWarningTxt == "")
{
return;
}
var sw = new StreamWriter(Application.StartupPath + "\\NoticeTxt.txt", false, Encoding.UTF8);
sw.Write(_strPreWarningTxt);
sw.Close();
//启动语音报警程序
if (_chkAddPreWarningVoice.Checked)
{
var thread = new Thread(SpeakerThreadFunction);
thread.Start();
}
}
catch (Exception ex)
{
Alert.alert(ex.ToString());
}
}
