Exemplos de UserApp.FildSql em C# (CSharp)

Exemplo n.º 1

        public ActionResult GetTreeSelectJson()
        {
            string            sql  = @"SELECT  * FROM Sys_User WHERE 1=1 and F_Account <> 'admin' order by F_CreatorTime desc";
            List <UserEntity> list = userApp.FildSql(sql);

            return(Content(list.ToJson()));
        }

Exemplo n.º 2

Arquivo: TaskDistributingController.cs Projeto: zhaopeifa/SHHP

        public ActionResult GetUserEnableGridByOutworker()
        {
            var list = userApp.FildSql("SELECT * FROM Sys_User WHERE F_IsOutworker=1").Select(d => new KeyValuePair <string, string>(d.F_Id, d.F_RealName)).ToList();

            return(Content(list.ToJson()));
        }