My Web Development Blog: липня 2010

вівторок, 27 липня 2010 р.

ExtJS grid wrap column

Добавляєм в наше апп метод:


App.Globals.wrapRenderer = function(val) {
    return '<div style="white-space:normal !important;">' + val + '</div>';
}

потім використовуємо:


...
{ 
 header: "Описание", 
 dataIndex: "DESCRIPTION",
 renderer: App.Globals.wrapRenderer, 
 width: 200 
},
...

середа, 21 липня 2010 р.

ExtJS app errors handling

Для того щоб будь-які помилки від сервера виводились в спеціальному вікні
можна зробити override метода request:


Ext.override(Ext.data.Connection, {
    request: Ext.data.Connection.prototype.request.createSequence(function(o) {
        if (!o.failure) {
            o.failure = function(response) {
                var msg = "Unknown server error";
                var resp = Ext.decode(response.responseText);

                if (resp && resp.Message) {
                    msg = resp.Message;
                }

                Ext.Msg.show({
                    title: "Server Error",
                    msg: msg,
                    minWidth: 300,
                    buttons: Ext.Msg.OK,
                    icon: Ext.Msg.ERROR
                });
            }
        }
    })
});

пʼятниця, 16 липня 2010 р.

MSSQL paging + sorting + filtering


CREATE PROCEDURE [TestTable_GetPagedAndSortedAndFiltered]
(
 @startRowIndex int,
 @maximumRows int,
 @order nvarchar(50),
 @ID int = null,
 @Name nvarchar(50) = null,
 @Size int = null,
 @From datetime = null,
 @To datetime = null
) 
AS
BEGIN

declare @lastKey int
declare @lastAsc sql_variant
declare @lastDesc sql_variant

set rowcount @startRowIndex

select
@lastAsc = OrderAsc,
@lastDesc = OrderDesc,
@lastKey = OrderKey
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
where 
((@ID is null) or (@ID = ID))
and
((@Name is null) or (Name like @Name))
and
((@Size is null) or (@Size = Size))
and
((@From is null) or (@From < Created))
and
((@To is null) or (dateadd(day,1,@To) > Created))
) as T
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount @maximumRows

select *
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
where
((@ID is null) or (@ID = ID))
and
((@Name is null) or (Name like @Name))
and
((@Size is null) or (@Size = Size))
and
((@From is null) or (@From < Created))
and
((@To is null) or (dateadd(day,1,@To) > Created))

)as T
where
(
 @lastAsc is null
 and
 @lastDesc is null
 and
 @lastKey is null
)
or
(
 @lastAsc is not null
 and
 (
  OrderAsc > @lastAsc
   or
  OrderAsc = @lastAsc
   and
  OrderKey >= @lastKey
 )
)
or
(
 @lastDesc is not null
 and
 (
  OrderDesc < @lastDesc
   or
  OrderDesc = @lastDesc
   and
  OrderKey >= @lastKey
 )
)
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount 0

END

MSSQL sort and filter procedure

Припустимо в нас є табличка:


CREATE TABLE [TestTable](
 [ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](50) NULL,
 [Size] [int] NULL,
 [Created] [datetime] NULL
)

Для сортування і фільтрації по всіх полях можна використати процедуру:


CREATE PROCEDURE [TestTable_GetPagedAndSorted]
(
 @startRowIndex int,
 @maximumRows int,
 @order nvarchar(50)
)
AS
BEGIN

declare @lastKey int
declare @lastAsc sql_variant
declare @lastDesc sql_variant

set rowcount @startRowIndex

select
@lastAsc = OrderAsc,
@lastDesc = OrderDesc,
@lastKey = OrderKey
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
) as T
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount @maximumRows

select *
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
)as T
where
(
 @lastAsc is null
 and
 @lastDesc is null
 and
 @lastKey is null
)
or
(
 @lastAsc is not null
 and
 (
  OrderAsc > @lastAsc
   or
  OrderAsc = @lastAsc
   and
  OrderKey > @lastKey
 )
)
or
(
 @lastDesc is not null
 and
 (
  OrderDesc < @lastDesc
   or
  OrderDesc = @lastDesc
   and
  OrderKey > @lastKey
 )
)
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount 0

END

MSSQL ORDER BY CASE

Припустимо в нас є табличка:


CREATE TABLE [TestTable](
 [ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](50) NULL,
 [Size] [int] NULL,
 [Created] [datetime] NULL
)

Сортувати її за значення певного параметра можна так:


declare @order nvarchar(50)
set @order = 'Created DESC'

select *
from TestTable
order by

case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
END,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END desc

субота, 10 липня 2010 р.

ExtJs VS2008 Project Template

Створив непоганий темплейт для студії:

кому цікаво - можу вислати:)

четвер, 8 липня 2010 р.

ExtJs store для json web-сервиса

Используя proxy из предыдущего поста, напишем и сохраним в файл
Ext.data.WsJsonStore.js следуючий код:


Ext.data.WsJsonStore = Ext.extend(Ext.data.JsonStore, {
    constructor: function(c) {
        var d = {
            root: 'd',
            proxy: new Ext.data.WsProxy({
                url: c.url
            })
        }
        Ext.data.WsJsonStore.superclass.constructor
         .call(this, Ext.apply(d, c));
    }
});

Потом, подключив оба файла, используем:


var store = new Ext.data.WsJsonStore({
   url:'url',
   fields: [fields],
   ...
});

ExtJs proxy для web-сервиса

В файл Ext.data.WsProxy.js сохраним такой код:


Ext.data.WsProxy = Ext.extend(Ext.data.HttpProxy, {
    constructor: function(c) {
        var d = {
            method: 'POST',
            headers: { 
              'Content-Type': 'application/json;charset=utf-8' 
            }
        }
        Ext.data.WsProxy.superclass.constructor
         .call(this, Ext.apply(d, c));
    }
});

Потом, подключив его, используем:


var proxy = new Ext.data.WsProxy({
    url:'url'
});

вівторок, 27 липня 2010 р.

середа, 21 липня 2010 р.

пʼятниця, 16 липня 2010 р.

субота, 10 липня 2010 р.

четвер, 8 липня 2010 р.

вівторок, 27 липня 2010 р.

середа, 21 липня 2010 р.

пʼятниця, 16 липня 2010 р.

субота, 10 липня 2010 р.

четвер, 8 липня 2010 р.