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