作者: admin

  • SQL SERVER 2008 R2 实现 sequence

    SQL SERVER 2008 R2 使用存储过程实现类似Oracle的sequence的功能:

    -- Create the sequencing table that is used to hold the sequence values.
    
    CREATE TABLE SQL_SERVER_SEQUENCE (
    NAME VARCHAR(30) NOT NULL,
    VALUE BIGINT DEFAULT 0 NOT NULL,
    CONSTRAINT PK_SQL_SERVER_SEQUENCE PRIMARY KEY (NAME)
    );
    -- Create the stored procedure that is responsible for incrementing the sequence and return it.
    ALTER PROCEDURE SQL_SERVER_SEQUENCE_NEXTVAL
    @name VARCHAR(30)
    AS
    BEGIN
    DECLARE @value BIGINT
    BEGIN TRANSACTION
    UPDATE SQL_SERVER_SEQUENCE
    SET @value = value = value + 1
    WHERE name = @name;
    COMMIT TRANSACTION
    SELECT @value AS NEXTVAL
    END;

    创建后,在表SQL_SERVER_SEQUENCE中添加一行

    如:NAME    VALUE

             yypz        0

    用法:

    SQL_SERVER_SEQUENCE_NEXTVAL 'yypz'
  • SQL Server使用信任连接

    SQL Server使用信任连接可以实现在连接数据库时不用密码:

    Server=localhost;Database=EIMS;Trusted_Connection=True;

  • ASP.NET MVC 显示HTML后缀

    如果想要在ASP.NET MVC 显示HTML后缀,可以在web.config中添加如下配置:

    <validation validateIntegratedModeConfiguration="false" />
        <modules runAllManagedModulesForAllRequests="true" />
    </system.webServer>

  • win8.1如何去掉桌面右键intel图形

    按 Win+R 打开注册表,输入 Regedit 回车,打开注册表编辑器,打开以下路径:
    HKEY_CLASSES_ROOT\Directory\Background\shellex\ContextMenuHandlers下删除igfxcui项即可.

  • centos6.5 通过yum安装nginx 提示 No package nginx available

    centos6.5 通过yum安装nginx 提示 No package nginx available

    解决办法如下:

    需要先安装epel源:

    yum install epel-release

    安装epel源之后,再安装nginx

    yum -y install nginx

    安装完成之后,执行下面的命令来启动nginx:

    service nginx start 
  • CentOS查看进程的内存占用

    CentOS查看进程的内存占用,并按大小排序

    ps -eo pmem,pcpu,rss,vsize,args | sort -k 1 -r | less

  • 让APACHE2支持PHP7

    让APACHE2支持PHP7:

    sudo apt-get install libapache2-mod-php
    service apache2 restart

    for php5.5

    apt-get install  libapache2-mod-php5

    PHP安装 sqlite 

    sudo apt-get install php7.0-sqlite
    sudo service apache2 restart

    PHP安装 mbstring

    sudo apt-get install php7.0-mbstring
    sudo service apache2 restart

    PHP安装 curl

    sudo apt-get install php7.0-curl
    sudo service apache2 restart
  • Entity framework 中比较日期 

    Entity framework 中比较日期 ,使用linq的写法:

    var totalCount = db.CallLog.Where(x => x.CallTime.Year == DateTime.Now.Year && x.CallTime.Month == DateTime.Now.Month && x.CallTime.Day == DateTime.Now.Day).Count();

    分别比较年月日,虽然不好看,但是可以正常工作。

  • EntityFramework Linq查询使用int.parse报错

    EntityFramework Linq 查询中不能使用int.parse,否则报错,报错信息如下:

    报错信息:LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method

    var data = from v in db.Vip
                join b in db.Business on v.BusinessId equals b.Id
                where v.Level == int.Parse(level) // 这样写会报错
                select new VipInfoModel
                {
                    VipName = v.VipName,
                    Level = v.Level.Value,
                    BusinessId = v.BusinessId.Value,
                    BusinessName = b.Name,
                    DisplayName = b.DisplayName
                };

    解决方案:把int.parse拿到外面

    var _level = int.Parse(level);
    var data = from v in db.Vip
                join b in db.Business on v.BusinessId equals b.Id
                where v.Level == _level
               select new VipInfoModel
                {
                    VipName = v.VipName,
                    Level = v.Level.Value,
                    BusinessId = v.BusinessId.Value,
                    BusinessName = b.Name,
                    DisplayName = b.DisplayName
                };
  • 安卓4.4及4.4以上 全屏代码

    安卓4.4及4.4以上 全屏代码,加在onCreate中:

    //全屏开始
    supportActionBar?.hide() // 隐藏标题栏
    window.setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN) //设置全屏
    //设置屏幕长亮
    window.setFlags(WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON,
    WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON)
    setContentView(R.layout.activity_main)
    
    // 这个组合不好用,当在触摸屏幕时还是会出现系统导航栏(home, back等)
    val mUIFlag = (View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LOW_PROFILE
    or View.SYSTEM_UI_FLAG_FULLSCREEN
    or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION)
    
    // 4.4以及上全屏
    val mUIFlag2 =(
    View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
    or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION // hide nav bar
    
    or View.SYSTEM_UI_FLAG_FULLSCREEN // hide status bar
    
    or View.SYSTEM_UI_FLAG_IMMERSIVE)
    
    //取消全屏
    val cancelFullScreenFlag = (View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN)
    
    window.decorView.systemUiVisibility = mUIFlag2
    // 全屏结束

    项目中的代码

    override fun onCreate(savedInstanceState: Bundle?) {
    super.onCreate(savedInstanceState)
    
    //全屏开始
    supportActionBar?.hide() // 隐藏标题栏
    window.setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN) //设置全屏
    //设置屏幕长亮
    window.setFlags(WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON,
    WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON)
    setContentView(R.layout.activity_main)
    
    // 这个组合不好用,当在触摸屏幕时还是会出现系统导航栏(home, back等)
    val mUIFlag = (View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LOW_PROFILE
    or View.SYSTEM_UI_FLAG_FULLSCREEN
    or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION)
    
    // 4.4以及上全屏
    val mUIFlag2 =(
    View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
    or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION // hide nav bar
    
    or View.SYSTEM_UI_FLAG_FULLSCREEN // hide status bar
    
    or View.SYSTEM_UI_FLAG_IMMERSIVE)
    
    //取消全屏
    val cancelFullScreenFlag = (View.SYSTEM_UI_FLAG_LAYOUT_STABLE
    or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
    or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN)
    
    window.decorView.systemUiVisibility = mUIFlag2
    // 全屏结束
    
    
    //注册onLongClick监听器
    super.findViewById<LinearLayout>(R.id.changeBkgArea).setOnLongClickListener(PicOnLongClick())
    super.findViewById<LinearLayout>(R.id.settingArea).setOnLongClickListener(OnLongClickSetting())
    
    loadConfig()
        loadBackgroundImage()
        startGetCommandLoop()
    }