public static IList <UserFieldInfo> GetFieldListWithValue(int intUserID, int intGroupID) { IList <UserFieldInfo> fieldListByModelID = UserField.GetFieldListByModelID(intGroupID, true); IList <UserFieldInfo> usingFieldList = UserField.GetUsingFieldList(intGroupID); UserGroupInfo cacheUserGroupById = UserGroup.GetCacheUserGroupById(intGroupID); if (cacheUserGroupById != null) { DataTable dataTable = BizBase.dbo.GetDataTable(string.Concat(new object[] { "SELECT * FROM cms_User AS A,", cacheUserGroupById.TableName, " AS B WHERE A.AutoID=", intUserID, " AND B.UserID=", intUserID })); if (dataTable.Rows.Count == 1) { foreach (UserFieldInfo current in fieldListByModelID) { if (dataTable.Columns.Contains(current.FieldName)) { current.Value = dataTable.Rows[0][current.FieldName].ToString(); } else { current.Value = current.DefaultValue; } } } } return(fieldListByModelID); }
public static bool DeleteByModelID(int modelID) { bool result; if (modelID <= 0) { result = false; } else { IList <UserFieldInfo> fieldListByModelID = UserField.GetFieldListByModelID(modelID); bool flag = BizBase.dbo.ExecSQL(" DELETE FROM cms_UserField WHERE UserGroupID=" + modelID); if (flag) { CacheUtils.Del("JsonLeeCMS_CacheForGetUserGroup"); result = true; } else { result = false; } } return(result); }
public static IList <UserFieldInfo> GetUsingFieldList(int modelID) { return(UserField.GetFieldListByModelID(modelID, true)); }