/// <summary>
/// 删除岗位编制信息
/// </summary>
/// <param name="deptPost">岗位编制信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true，失败返回False</returns>
public bool DeleteDeptPost(HR_DeptPost deptPost, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_DeptPost
where a.PostID == deptPost.PostID && a.DeptCode == deptPost.DeptCode
select a;
if (result.Count() != 1)
{
error = "信息有误，请重新选择！";
return(false);
}
dataContxt.HR_DeptPost.DeleteAllOnSubmit(result);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改减少部门岗位的在职人员数
/// </summary>
/// <param name="deptCode">部门编号</param>
/// <param name="postCode">岗位编号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool UpdateLessDeptPost(string deptCode, int postCode, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_DeptPost
where a.PostID == postCode && a.DeptCode == deptCode
select a;
if (result.Count() > 0)
{
HR_DeptPost deptPostList = result.Single();
deptPostList.ExistAmount = result.Single().ExistAmount - 1;
if (deptPostList.ExistAmount < 0)
{
deptPostList.ExistAmount = 0;
}
dataContxt.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtExistCount.Text == "0")
{
HR_DeptPost deptPost = new HR_DeptPost();
deptPost.DeptCode = m_departmentServer.GetDeptCode(SelectedNode.Text.Split(' ')[1].ToString());
deptPost.PostID = m_postServer.GetOperatingPostByPostName(cmbWorkPost.Text).岗位编号;
if (!m_postServer.DeleteDeptPost(deptPost, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
}
}
else
{
MessageDialog.ShowPromptMessage("此岗位有在岗人员，不能删除！");
return;
}
string[] s = SelectedNode.Text.Split(' ');
IQueryable <View_HR_DeptPost> postNum = m_postServer.GetDeptPostByDeptCode(s[1].ToString());
DataTable dt = GlobalObject.GeneralFunction.ConvertToDataTable <View_HR_DeptPost>(postNum);
dgvPostNum.DataSource = dt;
}
/// <summary>
/// 批量添加/更新部门工作岗位
/// </summary>
/// <param name="deptPost">工作岗位信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool AddDeptPost(DataTable deptPost, out string error)
{
error = "";
string strTemp = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
for (int i = 0; i < deptPost.Rows.Count; i++)
{
strTemp = deptPost.Rows[i]["班组"].ToString().Trim() + " " + deptPost.Rows[i]["岗位名称"].ToString().Trim();
var result = from a in dataContxt.HR_DeptPost
where a.PostID == GetOperatingPostByPostName(deptPost.Rows[i]["岗位名称"].ToString()).岗位编号 &&
a.DeptCode == new OrganizationServer().GetDeptCode(deptPost.Rows[i]["班组"].ToString())
select a;
if (result.Count() > 0)
{
HR_DeptPost deptPostList = result.Single();
deptPostList.NumberOfPeople = Convert.ToInt32(deptPost.Rows[i]["编制人数"].ToString());
deptPostList.Recorder = BasicInfo.LoginID;
deptPostList.RecordTime = ServerTime.Time;
deptPostList.Remark = deptPost.Rows[i]["备注"] == DBNull.Value ? "" : deptPost.Rows[i]["备注"].ToString();
}
else
{
HR_DeptPost deptPostList = new HR_DeptPost();
deptPostList.DeptCode = new OrganizationServer().GetDeptCode(deptPost.Rows[i]["班组"].ToString());
deptPostList.PostID = Convert.ToInt32(GetOperatingPostByPostName(deptPost.Rows[i]["岗位名称"].ToString()));
deptPostList.ExistAmount = 0;
deptPostList.NumberOfPeople = Convert.ToInt32(deptPost.Rows[i]["编制人数"].ToString());
deptPostList.Recorder = BasicInfo.LoginID;
deptPostList.RecordTime = ServerTime.Time;
deptPostList.Remark = deptPost.Rows[i]["备注"] == DBNull.Value ? "" : deptPost.Rows[i]["备注"].ToString();
dataContxt.HR_DeptPost.InsertOnSubmit(deptPostList);
}
strTemp = "";
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = strTemp + "; " + ex.Message;
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cmbWorkPost.SelectedIndex == -1)
{
MessageDialog.ShowPromptMessage("请选择岗位！");
return;
}
if (numNumberOfPeople.Value == 0m)
{
MessageDialog.ShowPromptMessage("设定的部门岗位编制人数不能为0！");
return;
}
HR_DeptPost deptPost = new HR_DeptPost();
deptPost.DeptCode = m_departmentServer.GetDeptCode(SelectedNode.Text.Split(' ')[1].ToString());
deptPost.ExistAmount = 0;
deptPost.NumberOfPeople = Convert.ToInt32(numNumberOfPeople.Value);
deptPost.PostID = m_postServer.GetOperatingPostByPostName(cmbWorkPost.Text).岗位编号;
deptPost.Recorder = BasicInfo.LoginID;
deptPost.RecordTime = ServerTime.Time;
deptPost.Remark = txtRemark.Text;
if (!m_postServer.AddDeptPost(deptPost, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
string[] s = SelectedNode.Text.Split(' ');
IQueryable <View_HR_DeptPost> postNum = m_postServer.GetDeptPostByDeptCode(s[1].ToString());
DataTable dt = GlobalObject.GeneralFunction.ConvertToDataTable <View_HR_DeptPost>(postNum);
dgvPostNum.DataSource = dt;
}
/// <summary>
/// 添加/更新部门工作岗位
/// </summary>
/// <param name="deptPost">工作岗位信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool AddDeptPost(HR_DeptPost deptPost, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_DeptPost
where a.PostID == deptPost.PostID && a.DeptCode == deptPost.DeptCode
select a;
if (result.Count() > 0)
{
HR_DeptPost deptPostList = result.Single();
deptPostList.NumberOfPeople = deptPost.NumberOfPeople;
deptPostList.Recorder = deptPost.Recorder;
deptPostList.RecordTime = deptPost.RecordTime;
deptPostList.Remark = deptPost.Remark;
deptPostList.ExistAmount = deptPost.NumberOfPeople;
}
else
{
dataContxt.HR_DeptPost.InsertOnSubmit(deptPost);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
