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