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