/// <summary> /// 修改部门类别信息 /// </summary> /// <param name="deptType">部门类别数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool UpdateDeptType(HR_DeptType deptType, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_DeptType where a.TypeID == deptType.TypeID select a; if (result.Count() != 1) { error = "请检查填写信息!"; return(false); } HR_DeptType deptTypeList = result.Single(); deptTypeList.TypeName = deptType.TypeName; deptTypeList.Remark = deptType.Remark; deptTypeList.Recorder = deptType.Recorder; deptTypeList.RecordTime = deptType.RecordTime; dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 添加部门类别信息 /// </summary> /// <param name="deptType">部门类别数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool AddDeptType(HR_DeptType deptType, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_DeptType where a.TypeName == deptType.TypeName || a.TypeID == deptType.TypeID select a; if (result.Count() > 0) { error = "请检查部门编号和部门名称,不能重复添加!"; return(false); } dataContxt.HR_DeptType.InsertOnSubmit(deptType); dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
private void btnAdd_Click(object sender, EventArgs e) { if (txtDeptName.Text.Trim() == "") { MessageDialog.ShowErrorMessage("类别不允许为空"); return; } if (txtDeptCode.Text.Trim() == "") { MessageDialog.ShowErrorMessage("类别编号不允许为空"); return; } HR_DeptType deptType = new HR_DeptType(); deptType.TypeID = Convert.ToInt32(txtDeptCode.Text); deptType.TypeName = txtDeptName.Text; deptType.Remark = txtRemark.Text; deptType.Recorder = BasicInfo.LoginID; deptType.RecordTime = ServerTime.Time; if (!m_deptTypeServer.AddDeptType(deptType, out error)) { MessageDialog.ShowErrorMessage(error); return; } RefreshControl(); }
private void btnUpdate_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageDialog.ShowPromptMessage("请选择需要修改的数据行!"); return; } else if (dataGridView1.SelectedRows.Count > 1) { MessageDialog.ShowPromptMessage("系统不允许同时修改多行数据!"); return; } if (txtDeptName.Text.Trim() == "") { MessageDialog.ShowErrorMessage("部门类别不允许为空"); return; } int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["类别编号"].Value); HR_DeptType deptType = new HR_DeptType(); deptType.TypeID = id; deptType.TypeName = txtDeptName.Text; deptType.Remark = txtRemark.Text; deptType.Recorder = BasicInfo.LoginID; deptType.RecordTime = ServerTime.Time; if (!m_deptTypeServer.UpdateDeptType(deptType, out error)) { MessageDialog.ShowErrorMessage(error); return; } RefreshControl(); }