/// <summary>
/// 删除指定用户装配用途权限
/// </summary>
/// <param name="workID">工号</param>
/// <param name="purposeID">用途编号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回true, 失败返回false</returns>
public bool DeletePurposeAuthority(string workID, int purposeID, out string error)
{
error = null;
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from r in dataContxt.ZPX_PersonnelAuthority
where r.WorkID == workID && r.PurposeID == purposeID
select r;
if (result.Count() == 0)
{
return(true);
}
ZPX_PersonnelAuthority obj = result.Single();
dataContxt.ZPX_PersonnelAuthority.DeleteOnSubmit(obj);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
/// <summary>
/// 给人员添加装配用途权限
/// </summary>
/// <param name="workID">人员工号</param>
/// <param name="purposeID">用途编号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回true, 失败返回false</returns>
public bool AddPurposeAuthority(string workID, int purposeID, out string error)
{
error = null;
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from r in dataContxt.View_ZPX_PersonnelAuthority
where r.工号 == workID && r.装配用途编号 == purposeID
select r;
if (result.Count() > 0)
{
error = string.Format("{0} 人员已经分配了 {1} 装配用途权限不允许重复分配", workID, purposeID);
return(false);
}
ZPX_PersonnelAuthority obj = new ZPX_PersonnelAuthority();
obj.WorkID = workID;
obj.PurposeID = purposeID;
dataContxt.ZPX_PersonnelAuthority.InsertOnSubmit(obj);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
