public int Update(string Account, string RoList, string CreateUser = "")
{
if (Account.Equals(""))
{
return(0);
}
using (ReportEntities db = new ReportEntities())
{
var items = db.RPT_UserRole.Where(p => p.UserAccount == Account);
if (items == null)
{
return(0);
}
foreach (var v in items)
{
db.RPT_UserRole.Remove(v);
}
string UserName = "";
if (CreateUser != "")
{
UserName = db.RPT_User.Where(p => p.UserAccount == Account).FirstOrDefault().UserName;
}
if (RoList.Equals(""))
{
return(0);
}
string[] sArray = RoList.Split(';');
RptRoleOP op = new RptRoleOP();
List <RPT_Role> RoleLst = op.GetList().ToList();
Hashtable data = new Hashtable();
foreach (string i in sArray)
{
foreach (RPT_Role j in RoleLst)
{
if (i.Equals(j.RoleCode))
{
data[i] = j.RoleName;
}
}
}
foreach (string i in sArray)
{
if (!i.Equals(""))
{
RPT_UserRole UserRole = new RPT_UserRole()
{
UserAccount = Account,
UserName = UserName,
RoleName = data[i].ToString(),
RoleCode = i,
CreateUser = CreateUser,
CreateTime = DateTime.Now
};
db.RPT_UserRole.Add(UserRole);
}
}
return(db.SaveChanges());
}
}
public int Create(RPT_Company data)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_Company.Add(data);
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Company.FirstOrDefault(p => p.ID == id);
if (exsit != null)
{
db.RPT_Company.Remove(exsit);
}
return(db.SaveChanges());
}
}
public int Create(RPT_Role data, List <RPT_UserRolePriv> list)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_Role.Add(data);
foreach (RPT_UserRolePriv userRole in list)
{
db.RPT_UserRolePriv.Add(userRole);
}
return(db.SaveChanges());
}
}
public int Update(RPT_Company data)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Company.FirstOrDefault(p => p.CompanyCode == data.SystemID);
if (exsit != null)
{
int id = exsit.ID;
exsit.CopyFrom(data);
exsit.ID = id;
}
return(db.SaveChanges());
}
}
public int Update(RPT_Menu data)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Menu.FirstOrDefault(p => p.MenuID == data.MenuID);
if (exsit != null)
{
int id = exsit.ID;
exsit.CopyFrom(data);
exsit.ID = id;
}
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.ID == id);
db.RPT_UserRolePriv.Where(p => p.UserRoleCode == item.RoleCode).ToList().ForEach(k =>
{
db.RPT_UserRolePriv.Remove(k);
});
if (item != null)
{
db.RPT_Role.Remove(item);
}
return(db.SaveChanges());
}
}
public int Update(RPT_Role data, List <RPT_UserRolePriv> list)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == data.RoleCode);
if (item != null)
{
item.RoleName = data.RoleName;
item.IsActive = data.IsActive;
item.RoleDesc = data.RoleDesc;
}
var items = db.RPT_UserRolePriv.Where(p => p.UserRoleCode == data.RoleCode);
foreach (var v in items)
{
db.RPT_UserRolePriv.Remove(v);
}
foreach (RPT_UserRolePriv userRole in list)
{
db.RPT_UserRolePriv.Add(userRole);
}
return(db.SaveChanges());
}
}