Example #1
0
        /// <summary>
        /// 通过字典编码和父类ID,获取相应的字典名称。
        /// </summary>
        /// <param name="parentID">父类ID</param>
        /// <param name="dictCode">字典编码</param>
        /// <returns></returns>
        public static string GetDictNameByID(string parentID, string dictCode)
        {
            string retValue = "";

            retValue = EntityOperate <string> .ExecSqlString(string.Format("select DictName from GI_CODEDICT where ParentID = '{0}' and DictCode = '{1}'", parentID, dictCode)) + "";

            return(retValue);
        }
Example #2
0
        /// <summary>
        /// 更新用户默认系统
        /// </summary>
        /// <param name="_GI_USERSYS"></param>
        public void UpdateDefaultUserSysApp(GI_UserSYS _GI_USERSYS)
        {
            EntityOperate <GI_UserSYS> .ExecSqlString(string.Format("update GI_USERSYS set ISDEFAULT = 0 where USERID = '{0}' and SYSID <> '{1}'", _GI_USERSYS.UserID, _GI_USERSYS.SYSID));

            EntityOperate <GI_UserSYS> .ExecSqlString(string.Format("update GI_USERSYS set ISDEFAULT = 1 where USERID = '{0}' and SYSID = '{1}'", _GI_USERSYS.UserID, _GI_USERSYS.SYSID));
        }