/// <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); } }