public static SysUserGroupCollection get_Groups(SysUser _user) { SysUserGroup grp = new SysUserGroup(); SysUserSysUserGroup sugrp = new SysUserSysUserGroup(); SysUserGroupCollection result = new SysUserGroupCollection(); string sql = "SELECT grp.* FROM " + grp.get_table() + " AS grp"; sql += " INNER JOIN " + sugrp.get_table() + " AS sugrp"; sql += " ON grp.id = sugrp.sysuser_group_id"; sql += " WHERE sugrp.sysuser_id = @sysuser_id"; grp.query.AddParameter("@sysuser_id", _user.id); DataTable dt = grp.query.get_DataTable(sql); foreach (DataRow row in dt.Rows) { grp = new SysUserGroup(); grp.LoadBy_array(row); result.Add(grp); } return(result); }
public override void Add(SysUserGroup item) { foreach (SysUserGroup g in this) { if (item.id == g.id) { throw new Exception(O2.Languages.Errors.SYSUSERGROUP_ALREADY_EXISTS.Replace("{G}", item.group)); } } if (sysuser_id > 0) { SysUserSysUserGroup obj = new SysUserSysUserGroup(); if (query != null) { obj.query = query; } obj.sysuser_id = sysuser_id; obj.sysuser_group_id = item.id; obj.Insert(); } innerList.Add(item); }
public override void InsertAll() { SysUserSysUserGroup sysusers_sysusers_group = new SysUserSysUserGroup(); string sysuser_group_ids = String.Empty; foreach (SysUserGroup g in this) { sysuser_group_ids += "," + g.id; } StringBuilder sql = new StringBuilder(); sql.Append("DELETE FROM " + sysusers_sysusers_group.get_table()); sql.Append(" WHERE sysuser_id = @sysuser_id"); if (!String.IsNullOrEmpty(sysuser_group_ids)) { sql.Append(" AND sysuser_group_id NOT IN (" + sysuser_group_ids.Substring(1) + ")"); } query.AddParameter("@sysuser_id", sysuser_id); query.ExecuteNonQuery(sql.ToString()); query.AddParameter("@sysuser_id", sysuser_id); DataTable dt = query.get_DataTable("SELECT * FROM " + sysusers_sysusers_group.get_table() + " WHERE sysuser_id = @sysuser_id"); foreach (SysUserGroup g in this) { bool exists_in_db = false; foreach (DataRow row in dt.Rows) { if (g.id == Convert.ToInt32(row["sysuser_group_id"])) { exists_in_db = true; break; } } if (!exists_in_db) { SysUserSysUserGroup obj = new SysUserSysUserGroup(); if (query != null) { obj.query = query; } obj.sysuser_id = sysuser_id; obj.sysuser_group_id = g.id; obj.Insert(); } } }
public override void RemoveAt(int index) { if (sysuser_id > 0) { SysUserSysUserGroup obj = new SysUserSysUserGroup(); if (query != null) { obj.query = query; } obj.LoadBy_sysuser_id_sysuser_group_id(sysuser_id, innerList[index].id); obj.Delete(); } innerList.RemoveAt(index); }
public override bool Remove(SysUserGroup item) { bool result = innerList.Remove(item); if (sysuser_id > 0) { SysUserSysUserGroup obj = new SysUserSysUserGroup(); if (query != null) { obj.query = query; } obj.LoadBy_sysuser_id_sysuser_group_id(sysuser_id, item.id); obj.Delete(); } return(result); }
public override void Insert(int index, SysUserGroup item) { if (sysuser_id > 0) { SysUserSysUserGroup obj = new SysUserSysUserGroup(); if (query != null) { obj.query = query; } obj.sysuser_id = sysuser_id; obj.sysuser_group_id = item.id; obj.Insert(); } innerList.Insert(index, item); }