private void Menu_deleteData_Click(object sender, EventArgs e)
{
var b = RadGridViewProperties.IsSelectRow(this.radGridView1);
if (!b)
{
MessageBox.Show("请选择要删除的测试序列！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var testNumber = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show($"确认要删除测试序列{testNumber}的数据？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
var delRow = historyDataInfoManager.DeleteByWhere($"where TestSerialNumber = '{testNumber}'");
delRow += historyDataDetailManager.DeleteByWhere($"where TestSerialNumber = '{testNumber}'");
if (delRow > 0)
{
UserOperateRecord.UpdateOperateRecord($"删除历史数据-删除测试序列{testNumber}");
MessageBox.Show("删除数据完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
QueryHistoryBasicInfo();
}
private void EditInterfaceLibrary()
{
if (!RadGridViewProperties.IsSelectRow(this.radGridView1))
{
return;
}
var plugNo = this.radGridView1.CurrentRow.Cells[1].Value;
if (plugNo != null)
{
plugNo = plugNo.ToString();
}
else
{
MessageBox.Show("请选择要编辑的行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
RadUpdateInterface radUpdateInterface = new RadUpdateInterface("编辑接口库", plugNo.ToString(), true);
if (radUpdateInterface.ShowDialog() == DialogResult.OK)
{
QueryInterfaceInfo();
UserOperateRecord.UpdateOperateRecord($"编辑接口");
}
}
private void Menu_del_Click(object sender, EventArgs e)
{
var curIndex = this.radGridView1.CurrentRow.Index;
if (curIndex < 0)
{
MessageBox.Show("未选择要删除的角色！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var roleName = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
if (roleName == "管理员")
{
return;//系统管理员不可删除
}
if (MessageBox.Show("确定要删除该角色吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
var res = this.roleManager.DeleteByWhere($"where UserRole='{roleName}'");
if (res > 0)
{
UserOperateRecord.UpdateOperateRecord($"删除角色-{roleName}");
MessageBox.Show($"已删除角色'{roleName}'！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
QueryRoleInfo();
}
private void Btn_deleteProject_Click(object sender, EventArgs e)
{
var b = RadGridViewProperties.IsSelectRow(this.radGridView1);
if (!b)
{
MessageBox.Show("请选择要删除的项目！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var selectProject = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show($"确定要删除项目{selectProject}？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.OK)
{
return;
}
var delRow = projectInfoManager.DeleteByWhere($"where ProjectName = '{selectProject}'");
if (delRow > 0)
{
UserOperateRecord.UpdateOperateRecord($"删除项目{selectProject}");
MessageBox.Show($"已删除项目{selectProject}！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
QueryProjectInfo();
//this.DialogResult = DialogResult.OK;
operateType = OperateType.DeleteProject;
}
private void Menu_commit_Click(object sender, EventArgs e)
{
var curIndex = this.radGridView1.CurrentRow.Index;
if (curIndex < 0)
{
MessageBox.Show("未选择要删除的角色！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var roleName = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
if (roleName == "管理员")
{
return;//系统管理员不可编辑修改
}
var remark = this.radGridView1.CurrentRow.Cells[2].Value;
var remarkStr = "";
if (remark != null)
{
remarkStr = remark.ToString();
}
var id = GetRoleID(roleName);
EditRole editRole = new EditRole("编辑角色", roleName, remarkStr);
if (editRole.ShowDialog() == DialogResult.OK)
{
var date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.roleManager.UpdateFields($"UserRole='{editRole.roleName}',Remark='{editRole.roleRemark}',UpdateDate='{date}'", $"where ID='{id}'");
UserOperateRecord.UpdateOperateRecord($"修改角色-{editRole.roleName}");
QueryRoleInfo();
}
}
private void Tool_delete_Click(object sender, EventArgs e)
{
var b = RadGridViewProperties.IsSelectRow(this.radGridView1);
if (!b)
{
MessageBox.Show("请选择要删除的线束！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var LineStructName = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
//if (IsInterUsed(LineStructName))
//{
// MessageBox.Show($"线束{LineStructName}已被项目使用,删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
if (MessageBox.Show($"确认要删除线束{LineStructName}?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.OK)
{
return;
}
var delRow = lineStructLibraryDetailManager.DeleteByWhere($"where CableName = '{LineStructName}'");
if (delRow > 0)
{
MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK);
UserOperateRecord.UpdateOperateRecord($"删除线束库{LineStructName}");
QueryCableLibInfo();
}
}
private void Tool_add_Click(object sender, EventArgs e)
{
RadUpdateCable radUpdateCable = new RadUpdateCable("添加线束库库", "", false, "");
if (radUpdateCable.ShowDialog() == DialogResult.OK)
{
UserOperateRecord.UpdateOperateRecord($"添加线束库");
QueryCableLibInfo();
}
}
private void Tool_add_Click(object sender, EventArgs e)
{
RadUpdateInterface radUpdateInterface = new RadUpdateInterface("添加接口库", "", false);
if (radUpdateInterface.ShowDialog() == DialogResult.OK)
{
QueryInterfaceInfo();
UserOperateRecord.UpdateOperateRecord($"添加接口");
}
}
private void Tool_add_Click(object sender, EventArgs e)
{
AddConnector addConnector = new AddConnector("添加连接器", false, "", "", "");
if (addConnector.ShowDialog() == DialogResult.OK)
{
QueryConnectorInfo();
UserOperateRecord.UpdateOperateRecord($"添加连接器库");
}
}
private void Tool_delAll_Click(object sender, EventArgs e)
{
if (MessageBox.Show($"确认要删除所有线束?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.OK)
{
return;
}
var delRow = lineStructLibraryDetailManager.DeleteByWhere("");
if (delRow > 0)
{
MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK);
UserOperateRecord.UpdateOperateRecord($"删除所有线束");
QueryCableLibInfo();
}
}
private void Menu_delAll_Click(object sender, EventArgs e)
{
if (MessageBox.Show($"确定要删除所有项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) != DialogResult.OK)
{
return;
}
var delRow = projectInfoManager.DeleteByWhere("");
if (delRow > 0)
{
UserOperateRecord.UpdateOperateRecord($"删除所有项目");
MessageBox.Show($"已删除所有项目！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
QueryProjectInfo();
//this.DialogResult = DialogResult.OK;
operateType = OperateType.DeleteProject;
}
public bool AddUserOperateRecord(string OperateContext)
{
if (!string.IsNullOrEmpty(OperateContext))
{
UserOperateRecord userOperateRecord = new UserOperateRecord
{
UserID = Convert.ToInt32(HttpContext.Current.Session["UserID"].ToString()),
UserName = HttpContext.Current.Session["UserName"].ToString(),
OperateContext = OperateContext,
RecordTime = DateTime.Now,
};
gameClubEntities.UserOperateRecord.Add(userOperateRecord);
gameClubEntities.SaveChanges();
return(true);
}
return(false);
}
private void Menu_add_Click(object sender, EventArgs e)
{
EditRole editRole = new EditRole("新增角色", "", "");
if (editRole.ShowDialog() == DialogResult.OK)
{
this.roleEntity.ID = TablePrimaryKey.InsertRolePID();
this.roleEntity.UserRole = editRole.roleName;
this.roleEntity.Remark = editRole.roleRemark;
this.roleEntity.UpdateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var cCount = roleManager.Insert(this.roleEntity);
if (cCount > 0)
{
UserOperateRecord.UpdateOperateRecord($"新增角色-{roleEntity.UserRole}");
QueryRoleInfo();
}
}
}
private void Btn_login_Click(object sender, EventArgs e)
{
if (!LocalValidate())
{
return;
}
RemoteValidate();
SelectUserType();
UpdateUserCfg();
if (this.DialogResult == DialogResult.OK)
{
//登录成功
currentUserName = tbx_username.Text;
UserOperateRecord.UpdateOperateRecord($"登录系统");
this.Close();
}
}
private void Tool_delete_Click(object sender, EventArgs e)
{
if (!RadGridViewProperties.IsSelectRow(this.radGridView1))
{
return;
}
var plugNo = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
if (IsInterUsed(plugNo))
{
MessageBox.Show($"接口{plugNo}已被线束库使用,删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show($"确认要删除接口{plugNo}？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
plugLibraryDetailManager.DeleteByWhere($"where InterfaceNo='{plugNo}'");
QueryInterfaceInfo();
UserOperateRecord.UpdateOperateRecord($"删除接口{plugNo}");
}
}
private void Tool_delete_Click(object sender, EventArgs e)
{
int rowIndex = this.radGridView1.CurrentRow.Index;
if (rowIndex < 0)
{
return;
}
var connectorType = this.radGridView1.Rows[rowIndex].Cells[1].Value.ToString();
var delRow = connectorLibraryManager.DeleteByWhere($"ConnectorName = '{connectorType}'");
if (delRow > 0)
{
delRow = connectorLibraryDetailManager.DeleteByWhere($"ConnectorName = '{connectorType}'");
UserOperateRecord.UpdateOperateRecord($"删除连接器库{connectorType}");
MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
}
}
private void Tool_delete_Click(object sender, EventArgs e)
{
var currentRowIndex = this.radGridView1.CurrentRow.Index;
if (currentRowIndex < 0)
{
MessageBox.Show("请选择要删除的工装代号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var currentWorkWearCode = this.radGridView1.CurrentRow.Cells[1].Value.ToString();
var dRow = switchWorkWearLibraryManager.DeleteByWhere($"where SwitchWorkWearCode='{currentWorkWearCode}'");
if (dRow > 0)
{
UserOperateRecord.UpdateOperateRecord($"删除转接工装{currentWorkWearCode}");
MessageBox.Show($"已成功删除工装代号{currentWorkWearCode}！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show($"删除工装代号{currentWorkWearCode}失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Tool_add_Click(object sender, EventArgs e)
{
AddSwitchWorkWear addSwitchWorkWear = new AddSwitchWorkWear();
if (addSwitchWorkWear.ShowDialog() == DialogResult.OK)
{
this.radGridView1.Rows.AddNew();
int rCount = this.radGridView1.RowCount;
this.radGridView1.Rows[rCount - 1].Cells[0].Value = rCount;
this.radGridView1.Rows[rCount - 1].Cells[1].Value = addSwitchWorkWear.switchWorkWearCode;
this.radGridView1.Rows[rCount - 1].Cells[2].Value = addSwitchWorkWear.switchType;
this.radGridView1.Rows[rCount - 1].Cells[3].Value = addSwitchWorkWear.remark;
//save db
TSwitchWorkWearLibrary switchWorkWearLibrary = new TSwitchWorkWearLibrary();
switchWorkWearLibrary.ID = CableTestManager.Common.TablePrimaryKey.InsertSwitchWorkLibPID();
switchWorkWearLibrary.SwitchWorkWearCode = addSwitchWorkWear.switchWorkWearCode;
switchWorkWearLibrary.SwitchrType = addSwitchWorkWear.switchType;
switchWorkWearLibrary.Remark = addSwitchWorkWear.remark;
switchWorkWearLibraryManager.Insert(switchWorkWearLibrary);
UserOperateRecord.UpdateOperateRecord($"新增转接工装{switchWorkWearLibrary.SwitchWorkWearCode}");
}
}
private void CreateOrUpdateProject()
{
if (this.rtbProjectName.Text.Trim() == "")
{
MessageBox.Show("工程名称不能为空！", "提示", MessageBoxButtons.OK);
return;
}
if (this.rtbCurrentTestCable.Text.Trim() == "")
{
MessageBox.Show("请选择被测线束！", "提示", MessageBoxButtons.OK);
return;
}
if (!this.IsEditView)//new project ,check rename for project name
{
if (IsExistProject(this.rtbProjectName.Text.Trim()))
{
MessageBox.Show("项目名称已存在，请重新编辑项目名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (projectInfo.ConductTestThreshold == 0 || projectInfo.ShortCircuitTestThreshold == 0 || projectInfo.InsulateTestThreshold == 0)
{
MessageBox.Show("请设置本次试验的参数！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
projectInfo.ID = CableTestManager.Common.TablePrimaryKey.InsertProjectBInfoPID();
projectInfo.ProjectName = this.rtbProjectName.Text.Trim();
projectInfo.Remark = this.rtbProjectRemark.Text.Trim();
projectInfo.TestCableName = this.rtbCurrentTestCable.Text;
var iRow = 0;
var originCount = projectInfoManager.GetRowCount();
if (!this.IsEditView)
{
this.projectName = projectInfo.ProjectName;
//insert info
if (!IsExistProject(this.rtbProjectName.Text.Trim()))
{
iRow = projectInfoManager.Insert(projectInfo);
iRow = iRow - originCount;
UserOperateRecord.UpdateOperateRecord($"创建项目{projectInfo.ProjectName}");
}
}
else
{
//update
projectInfo.ID = GetProjectInfoID(this.projectName);
iRow = projectInfoManager.Update(projectInfo);
if (iRow > 0)
{
this.projectName = projectInfo.ProjectName;
UserOperateRecord.UpdateOperateRecord($"修改项目信息-项目{projectInfo.ProjectName}");
MessageBox.Show("更新成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("更新失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
this.Close();
this.DialogResult = DialogResult.OK;
}
private void CommitUserModify()
{
var username = this.tb_user.Text.Trim();
var oldPwd = this.tb_oldPwd.Text.Trim();
var newPwd = this.tb_newPwd.Text.Trim();
var confirmPwd = this.tb_confirmPwd.Text.Trim();
if (string.IsNullOrEmpty(username))
{
MessageBox.Show("用户名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(oldPwd))
{
MessageBox.Show("旧密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(newPwd))
{
MessageBox.Show("新密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(confirmPwd))
{
MessageBox.Show("确认密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var dt = userHelper.GetUserInfo(username).Tables[0];
if (dt.Rows.Count > 0)
{
//用户已存在
//用户不能是已经存在的其他用户名
if (username != userName)
{
MessageBox.Show("该用户名已存在，请重新输入用户名！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//验证旧密码
var loginResult = userHelper.Login(userName, oldPwd);
if (loginResult == UserHelper.LoginResult.Err_Password)
{
MessageBox.Show("旧密码错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (newPwd != confirmPwd)
{
MessageBox.Show("新密码与确认密码不一致！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var res = userHelper.ModifyUserPassword(userName, username, confirmPwd);
if (res == 1)
{
UserOperateRecord.UpdateOperateRecord($"修改密码");
MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void RegisterUser()
{
var username = this.tb_username.Text.Trim();
var userpwd = this.tb_pwd.Text.Trim();
var userRpwd = this.tb_repwd.Text.Trim();
var userType = this.cb_userType.Text.Trim();
if (string.IsNullOrEmpty(userType.ToString()))
{
MessageBox.Show("用户类型不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(username))
{
MessageBox.Show("用户名不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(userpwd))
{
MessageBox.Show("密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(userRpwd))
{
MessageBox.Show("确认密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataSet dataSet = userHelper.GetUserInfo(username);
if (dataSet.Tables[0].Rows.Count > 0)
{
MessageBox.Show("用户已存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tb_username.ForeColor = Color.Red;
return;
}
tb_username.ForeColor = Color.Black;
if (userpwd != userRpwd)
{
MessageBox.Show("两次密码不一致？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//校验密码复杂度
if (!RegexHelper.IsMatchPassword(userpwd))
{
//密码复杂度不满足
MessageBox.Show("密码必须包含数字、字母", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var registerResult = userHelper.Register(username, userpwd, userType);
if (registerResult == UserHelper.RegisterResult.Successful)
{
//注册成功
UserOperateRecord.UpdateOperateRecord($"新增用户-{username}");
MessageBox.Show("注册成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
this.DialogResult = DialogResult.OK;
}
else if (registerResult == UserHelper.RegisterResult.Err_Exist_user)
{
MessageBox.Show("用户已存在！", "提示", MessageBoxButtons.OK);
}
else if (registerResult == UserHelper.RegisterResult.Fail)
{
MessageBox.Show("注册失败！", "提示", MessageBoxButtons.OK);
}
}
