コード例 #1
0
        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);
        }
コード例 #2
0
ファイル: UserField.cs プロジェクト: ngochoanhbr/dahuco
        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);
        }
コード例 #3
0
ファイル: UserField.cs プロジェクト: ngochoanhbr/dahuco
 public static IList <UserFieldInfo> GetUsingFieldList(int modelID)
 {
     return(UserField.GetFieldListByModelID(modelID, true));
 }