public Model.General.ReturnValueInfo DeleteRoleUser(DataRightsRole_drr_Info Entity)
{
ReturnValueInfo returnInfo = new ReturnValueInfo();
returnInfo.boolValue = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
foreach (Sys_UserMaster_usm_Info item in Entity.RoleUserList)
{
DataRightsRoleUser_dru info = db.DataRightsRoleUser_drus.SingleOrDefault <DataRightsRoleUser_dru>(t => t.dru_cRoleNumber == Entity.drr_cNumber && t.dur_cUserLoginID == item.usm_cUserLoginID);
db.DataRightsRoleUser_drus.DeleteOnSubmit(info);
}
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
catch (Exception Ex)
{
returnInfo.boolValue = false;
returnInfo.messageText = Ex.Message;
}
return(returnInfo);
}
public ReturnValueInfo SaveRoleUser(DataRightsRole_drr_Info Entity)
{
ReturnValueInfo returnInfo = new ReturnValueInfo();
returnInfo.boolValue = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
//IEnumerable<DataRightsRoleUser_dru> delTab = from t in db.DataRightsRoleUser_drus
// where t.dru_cRoleNumber == Entity.drr_cNumber
// select t;
//db.DataRightsRoleUser_drus.DeleteAllOnSubmit(delTab);
foreach (Sys_UserMaster_usm_Info item in Entity.RoleUserList)
{
DataRightsRoleUser_dru addTab = new DataRightsRoleUser_dru();
addTab.dru_cRoleNumber = Entity.drr_cNumber;
addTab.dur_cUserLoginID = item.usm_cUserLoginID;
db.DataRightsRoleUser_drus.InsertOnSubmit(addTab);
}
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
catch (Exception Ex)
{
returnInfo.boolValue = false;
returnInfo.messageText = Ex.Message;
}
return(returnInfo);
}
public ReturnValueInfo SaveUserRole(string userNumber, List <string> roleNumList)
{
ReturnValueInfo returnInfo = new ReturnValueInfo();
returnInfo.boolValue = false;
if (roleNumList == null || roleNumList.Count == 0)
{
returnInfo.boolValue = true;
return(returnInfo);
}
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
foreach (string roleNum in roleNumList)
{
DataRightsRoleUser_dru info = new DataRightsRoleUser_dru();
info.dru_cRoleNumber = roleNum;
info.dur_cUserLoginID = userNumber;
db.DataRightsRoleUser_drus.InsertOnSubmit(info);
}
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
catch (Exception Ex)
{
returnInfo.boolValue = false;
returnInfo.messageText = Ex.Message;
}
return(returnInfo);
}
public ReturnValueInfo SaveUserToRole(List <Sys_UserMaster_usm_Info> userList, List <DataRightsRole_drr_Info> roleList, bool iClearUserRole, bool iClearRoleUser)
{
ReturnValueInfo returnInfo = new ReturnValueInfo();
returnInfo.boolValue = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
if (iClearUserRole)
{
//删除用户之前所有角色
foreach (Sys_UserMaster_usm_Info item in userList)
{
IEnumerable <DataRightsRoleUser_dru> deleteTab = from t in db.DataRightsRoleUser_drus
where t.dur_cUserLoginID == item.usm_cUserLoginID
select t;
if (deleteTab != null && deleteTab.Count() > 0)
{
db.DataRightsRoleUser_drus.DeleteAllOnSubmit(deleteTab);
db.SubmitChanges();
}
}
}
if (iClearRoleUser)
{
foreach (DataRightsRole_drr_Info item in roleList)
{
IEnumerable <DataRightsRoleUser_dru> deleteTab = from t in db.DataRightsRoleUser_drus
where t.dru_cRoleNumber == item.drr_cNumber
select t;
if (deleteTab != null && deleteTab.Count() > 0)
{
db.DataRightsRoleUser_drus.DeleteAllOnSubmit(deleteTab);
db.SubmitChanges();
}
}
}
foreach (DataRightsRole_drr_Info role in roleList)
{
foreach (Sys_UserMaster_usm_Info User in userList)
{
DataRightsRoleUser_dru tab = db.DataRightsRoleUser_drus.FirstOrDefault(t => t.dur_cUserLoginID == User.usm_cUserLoginID && t.dru_cRoleNumber == role.drr_cNumber);
if (tab == null)
{
tab = new DataRightsRoleUser_dru();
tab.dru_cRoleNumber = role.drr_cNumber;
tab.dur_cUserLoginID = User.usm_cUserLoginID;
db.DataRightsRoleUser_drus.InsertOnSubmit(tab);
}
}
}
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnInfo);
}