private void BindData() { isRefreshFlag = true; //获取进程表数据 List <EapProcess> list = Bll.GetBll().GetProcessStatus(); if (list == null || list.Count == 0) { return; } //系统时间(数据库DB时间) lblSystemTime.Text = list[0].DBTIME.ToString(); dgv.DataSource = list; isRefreshFlag = false; }
private void btnSave_Click(object sender, EventArgs e) { EapValueList edit_entity = GetEditEntity(); if (edit_entity == null) { return; } if (em == EditMode.Add) { string ret_add = Bll.GetBll().AddValueList(edit_entity); if (ret_add != string.Empty) { if (ret_add.Split(':')[0] == "ORA-00001") { Func.ShowMessage(MessageType.Error, "数据添加失败,原因:值列表ID[" + edit_entity.VLIST_ID + "]已经存在"); return; } Func.ShowMessage(MessageType.Error, "数据添加失败,原因[" + ret_add + "]"); return; } //写日志 Log.Write(MessageType.Information, "添加值列表数据成功,值列表ID[" + edit_entity.VLIST_ID + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "数据添加成功!"); this.Close(); } else if (em == EditMode.Edit) { string ret_edit = Bll.GetBll().ModifyValueList(edit_entity); if (ret_edit != string.Empty) { Func.ShowMessage(MessageType.Error, "数据修改失败,原因[" + ret_edit + "]"); return; } //写日志 Log.Write(MessageType.Information, "修改值列表数据成功,值列表ID[" + edit_entity.VLIST_ID + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "数据修改成功!"); this.Close(); } }
private void btnResetPwd_Click(object sender, EventArgs e) { EapUser reset_pwd = new EapUser(); reset_pwd.USER_ID = txtUserID.Text.Trim(); reset_pwd.PWD = Func.EncryptString("1", Config.GetConfig().DB_KEY); string ret = Bll.GetBll().UpdatePwd(reset_pwd); if (ret != string.Empty) { string msg = "重置密码失败,用户ID[" + reset_pwd.USER_ID + "],原因[" + ret + "]"; Func.ShowMessage(MessageType.Error, msg); Log.Write(MessageType.Error, msg, Eap.Config.GetConfig().user.USER_ID); return; } Func.ShowMessage(MessageType.Information, "重置密码成功,用户ID[" + reset_pwd.USER_ID + "]"); Log.Write(MessageType.Information, "重置密码成功,用户ID[" + reset_pwd.USER_ID + "]", Eap.Config.GetConfig().user.USER_ID); }
/// <summary> /// 绑定该用户生产线权限 /// </summary> private void BindTrimLine() { List <EapUserTrimLine> list_trim_line = Bll.GetBll().GetLineAuthoritybyUser(user.USER_ID); if (list_trim_line == null || list_trim_line.Count == 0) { return; } foreach (EapUserTrimLine sub in list_trim_line) { for (int i = 0; i < chk_Assembly_Line.Items.Count; i++) { if (sub.TRIM_LINE.Equals((chk_Assembly_Line.Items[i] as EapValueListDetail).VLIST_DETAIL_VALUE)) { chk_Assembly_Line.SetItemChecked(i, true); } } } }
private void btnDel_Click(object sender, EventArgs e) { if (dgvVList.SelectedCells.Count == 0) { Func.ShowMessage(MessageType.Warning, "没有选中删除数据!"); return; } if (!Func.ShowQuestion("确认要删除该记录数据?")) { return; } EapValueList del_entity = new EapValueList(); int iRowIdex = dgvVList.CurrentCell.RowIndex; del_entity.VLIST_ID = dgvVList.Rows[iRowIdex].Cells["VLIST_ID"].Value.ToString(); del_entity.VLIST_NAME = dgvVList.Rows[iRowIdex].Cells["VLIST_NAME"].Value.ToString(); string str = Bll.GetBll().DelValueList(del_entity.VLIST_ID); if (str != string.Empty) { if (str.Split(':')[0] == "ORA-02292") { Func.ShowMessage(MessageType.Error, "删除值列表数据失败!原因:值列表ID[" + del_entity.VLIST_ID + "]存在明细列表数据,无法删除"); return; } Func.ShowMessage(MessageType.Error, "删除值列表数据失败!原因[" + str + "]"); } else { //写日志 Log.Write(MessageType.Information, "删除值列表数据成功,值列表ID[" + del_entity.VLIST_ID + "],值列表名称[" + del_entity.VLIST_NAME + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "值列表数据删除成功"); page.PageNo = 1; BindData(); } }
private void btnSave_Click(object sender, EventArgs e) { EapValueListDetail edit_entity = GetEditEntity(); if (edit_entity == null) { return; } string ret_add = Bll.GetBll().AddValueListDetail(edit_entity); if (ret_add != string.Empty) { Func.ShowMessage(MessageType.Error, "数据添加失败,原因[" + ret_add + "]"); return; } //写日志 Log.Write(MessageType.Information, "添加值列表明细数据成功,值列表ID[" + edit_entity.VLIST_ID + "],值列表明细值[" + edit_entity.VLIST_DETAIL_VALUE + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "数据添加成功!"); this.Close(); }
private void btnSaveButton_Click(object sender, EventArgs e) { List <EapUserButtonRight> list_button_right = new List <EapUserButtonRight>(); EapMenu button_right_menu = null; GetUsetButtonRight(tvRightButton.Nodes, ref list_button_right, ref button_right_menu); if (button_right_menu != null) { string ret = Bll.GetBll().SaveUserButtonRight(user.USER_ID, list_button_right, button_right_menu); if (ret != string.Empty) { Func.ShowMessage(MessageType.Error, ret); Log.Write(MessageType.Error, "用户按钮授权失败,原因[" + ret + "]", Eap.Config.GetConfig().user.USER_ID); return; } } Func.ShowMessage(MessageType.Information, "用户按钮授权成功!"); Log.Write(MessageType.Information, "用户按钮授权成功!", Eap.Config.GetConfig().user.USER_ID); }
private void btnDelVListDetail_Click(object sender, EventArgs e) { if (dgvVListDetail.SelectedCells.Count == 0) { Func.ShowMessage(MessageType.Warning, "没有选中删除数据!"); return; } if (!Func.ShowQuestion("确认要删除该记录数据?")) { return; } EapValueListDetail del_entity = new EapValueListDetail(); del_entity.VLIST_ID = dgvVList.Rows[dgvVList.CurrentCell.RowIndex].Cells["VLIST_ID"].Value.ToString(); int iRowIndex = dgvVListDetail.CurrentCell.RowIndex; del_entity.VLIST_DETAIL_ID = decimal.Parse(dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_ID"].Value.ToString()); del_entity.VLIST_DETAIL_VALUE = decimal.Parse(dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_VALUE"].Value.ToString()); del_entity.VLIST_DETAIL_NAME = dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_NAME"].Value.ToString(); string str = Bll.GetBll().DelValueListDetail(del_entity); if (str != string.Empty) { Func.ShowMessage(MessageType.Error, "删除值列表明细数据失败!原因[" + str + "]"); } else { //写日志 string msg = "删除值列表明细数据成功,值列表ID[" + del_entity.VLIST_ID + "],值列表明细ID[" + del_entity.VLIST_DETAIL_ID + "],值列表明细值[" + del_entity.VLIST_DETAIL_VALUE + "],值列表明细名称[" + del_entity.VLIST_DETAIL_NAME + "]"; Log.Write(MessageType.Information, msg, Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "值列表明细数据删除成功"); BindValueListDetail(del_entity.VLIST_ID); } }
private void btnDel_Click(object sender, EventArgs e) { if (dgv.SelectedCells.Count == 0) { Func.ShowMessage(MessageType.Warning, "没有选中菜单"); return; } if (!Func.ShowQuestion("确认要删除该记录数据?")) { return; } //判断当前用户是否为admin(系统管理员) if (Config.GetConfig().user.USER_ID != "admin") { Func.ShowMessage(MessageType.Warning, "当前用户不是系统管理员admin,不能删除菜单"); return; } string menu_id = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["MENU_ID"].Value.ToString(); string str = Bll.GetBll().DelMenuByMenuId(menu_id); if (str != string.Empty) { Func.ShowMessage(MessageType.Error, "删除功能菜单数据失败!原因[" + str + "]"); } else { //写日志 Log.Write(MessageType.Information, "删除功能菜单数据成功,菜单编码[" + menu_id + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "功能菜单数据删除成功"); page.PageNo = 1; BindData(); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { if (dgv.SelectedCells.Count == 0) { Func.ShowMessage(MessageType.Warning, "没有选中一条数据"); return; } if (Func.ShowQuestion("确认要进行删除操作吗?") == true) { string DEPARTMENT_ID = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_ID"].Value.ToString(); string ret = Bll.GetBll().DeleteDEPARTMENT(DEPARTMENT_ID); if (ret != string.Empty) { Func.ShowMessage(MessageType.Warning, "删除失败," + ret); } //成功写入日志 Log.Write(MessageType.Information, "部门删除成功,删除ID[" + dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_ID"].Value.ToString() + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "删除成功"); BindData(); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEnter_Click(object sender, EventArgs e) { if (txtDEPARTMENT_CODE.Text.Trim() == string.Empty) { Func.ShowMessage(MessageType.Warning, "部门编号不能为空"); txtDEPARTMENT_CODE.Focus(); return; } if (txtDEPARTMENT_NAME.Text.Trim() == string.Empty) { Func.ShowMessage(MessageType.Warning, "部门名称不能为空"); txtDEPARTMENT_NAME.Focus(); return; } if (cmbASSEMBLY_LINE.Text.Trim() == string.Empty) { Func.ShowMessage(MessageType.Warning, "装配线不能为空"); cmbASSEMBLY_LINE.Focus(); return; } string ret; if (em == EditMode.Edit) { if (Bll.GetBll().RepeatDEPARTMENT(txtDEPARTMENT_NAME.Text.Trim(), entity.DEPARTMENT_ID)) { Func.ShowMessage(MessageType.Warning, "部门名称重复,请重新输入"); txtDEPARTMENT_NAME.Focus(); return; } entity.DEPARTMENT_CODE = txtDEPARTMENT_CODE.Text; entity.DEPARTMENT_NAME = txtDEPARTMENT_NAME.Text; entity.DEPARTMENT_TYPE = cmbDEPARTMENT_TYPE.Text; entity.ASSEMBLY_LINE = cmbASSEMBLY_LINE.Text; entity.STATUS = decimal.Parse(((EapItem)cmbStatus.SelectedItem).ID); ret = Bll.GetBll().UpdateDEPARTMENT(entity); if (ret != string.Empty) { Func.ShowMessage(MessageType.Information, "新增失败" + ret); return; } Func.ShowMessage(MessageType.Information, "保存成功"); //成功写入日志 Log.Write(MessageType.Information, "修改部门成功,问题id[" + entity.DEPARTMENT_ID + "], " + log + " 新数据:部门编号[" + txtDEPARTMENT_CODE.Text + "],部门名称[" + txtDEPARTMENT_NAME.Text + "],类型[" + cmbDEPARTMENT_TYPE.Text + "],装配线[" + cmbASSEMBLY_LINE.Text + "],状态[" + cmbStatus.Text + "] ", Config.GetConfig().user.USER_ID); this.Close(); } else { if (Bll.GetBll().RepeatDEPARTMENT(txtDEPARTMENT_NAME.Text.Trim(), 0)) { Func.ShowMessage(MessageType.Warning, "部门名称重复,请重新输入"); txtDEPARTMENT_NAME.Focus(); return; } entity = GetAddEntity(); ret = Bll.GetBll().AddDEPARTMENT(entity); if (ret != string.Empty) { Func.ShowMessage(MessageType.Information, "新增失败" + ret); return; } //成功写入日志 Log.Write(MessageType.Information, "新增部门成功,id=[" + entity.DEPARTMENT_ID + "],部门编号[" + entity.DEPARTMENT_CODE + "],部门名称[" + entity.DEPARTMENT_NAME + "],部门类型[" + entity.DEPARTMENT_TYPE + "],部门状态[" + entity.STATUS + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "新增成功"); this.Close(); } }
/// <summary> /// 生成权限菜单 /// </summary> private void GetMenuAuthority() { list_menu = Bll.GetBll().GetUserAuthority(); this.tvRightMenu.Nodes.Clear(); //清空所有节点 BindTransportTree(this.tvRightMenu.Nodes, ""); //创建树 }
/// <summary> /// 生成指定窗体权限按钮 /// </summary> private void GetButtonAuthority(EapMenu form_menu) { list_button = Bll.GetBll().GetFormUserAuthorityButton(form_menu); this.tvRightButton.Nodes.Clear(); //清空所有节点 CreateButtonTree(this.tvRightButton.Nodes, form_menu); //创建树 }