ext2.2打造全新功能grid系列--批量删除篇

happy100583

浏览: 124935 次
性别:
来自: 长沙

最近访客更多访客>>

naturegeng

wangtong1976

sherlock8264

lz798341622

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Ext JS

EXT CSS JavaScript json Ajax

CODE:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridMoreDelete.aspx.cs" Inherits="gridMoreDelete" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>批量删除篇</title>
<link rel="Stylesheet" type="text/css" href="ExtJS/resources/css/ext-all.css" />
<link rel="Stylesheet" type="text/css" href="ExtJS/resources/css/xtheme-green.css" />
<script type="text/javascript" src="ExtJS/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="ExtJS/ext-all.js"></script>
<script type="text/javascript" src="ExtJS/ext-lang-zh_CN.js"></script>
<style type="text/css">
.panel_icon { background-image:url(images/first.gif)}
.center_icon { background-image:url(images/house.png)}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function ready()
{
//添加下面这句，有助于当鼠标放在Ext自带的图标上时能够显示提示的功能
Ext.QuickTips.init();

var url = "jsonGrid.aspx?Param=select";
var sm = new Ext.grid.CheckboxSelectionModel();

var cm = new Ext.grid.ColumnModel
([
sm,new Ext.grid.RowNumberer({header:"编号",width:50}),
{header:"编号",dataIndex:"ID",width:10,hidden:true},
{header:"标题",dataIndex:"TypeCName",width:100,editor:new Ext.form.TextField()},
{header:"英文名称",dataIndex:"TypeEName",width:100,editor:new Ext.form.TextField()},
{header:"状态",dataIndex:"DelFlag",width:100,renderer:function(value) {if(value==false) {return "显示";} else {return "隐藏";}}},
{header:"添加日期",dataIndex:"AddDate",width:100,renderer:Ext.util.Format.dateRenderer('Y年m月d日')}
]);
cm.defaultSortable = true;
var fields =
[
{name:"ID"},
{name:"TypeCName"},
{name:"TypeEName"},
{name:"DelFlag"},
{name:"AddDate"}
];
var store = new Ext.data.Store
({
proxy:new Ext.data.HttpProxy({url:url}),
reader:new Ext.data.JsonReader({totalProperty:"totalPorperty",root:"root",fields:fields})
});
store.load({params:{start:0,limit:15}});

var pagingBar = new Ext.PagingToolbar
({
displayInfo:true,
emptyMsg:"没有数据显示",
displayMsg:"显示从{0}条数据到{1}条数据，共{2}条数据",
store:store,
pageSize:15,
items:
[
' ',
{
enableToggle: true,
text: '刷新',
cls: 'x-btn-text-icon details',icon:"images/plugin.gif",
toggleHandler: function(btn, pressed)
{
//动态加重新载数据列表
Ext.getCmp("MenuGridPanel").store.reload();
}
},
'-',
{
enableToggle: true,//TypeTable实体类 ID PID TypeEName TypeCName DelFlag AddDate
text: '批量删除',
cls: 'x-btn-text-icon details',icon:"images/plugin.gif",
toggleHandler: function(btn, pressed)
{
var rows = Ext.getCmp("MenuGridPanel").getSelections();
if(!(rows.length>=1))
{
Ext.Msg.alert("提示消息","请至少选择一行数据然后才能够删除。<br/>如果需要单行删除并需要确认，请选择[删除]按钮！<br/>暂时不支持该功能！");return false;
}
Ext.Msg.confirm("确认消息框","是否确定对选中的行进行删除操作，删除后不能够恢复，建议使用隐藏！",
function(btn,txt)
{
if(btn=="no")
return false;
else
{
var Ids = "";
for(var i=0;i<rows.length;i++)
{
Ids += rows[i].json.ID + ",";//获取批量删除所需要的ID
}
Ext.Ajax.request
({
url: 'jsonGrid.aspx?Param=deletemore',//批量删除
params:{IdsParam:Ids},
success: function(response, options)
{
var res = Ext.util.JSON.decode(response.responseText);
if(res.success=="")
{
Ext.Msg.alert("提示消息","错误消息","出现异常，可以查看日志了解详细信息！");
return;
}
else if(res.success=="1")
{
Ext.Msg.alert("提示消息","批量删除成功！");
Ext.getCmp("MenuGridPanel").store.reload();
}
else
{
Ext.Msg.alert("提示消息","批量删除失败！");
}
},
failure:function(){Ext.Msg.alert("错误消息","批量删除出现异常，可以查看日志了解详细信息！");}
});
}
});
}

}, ' '
]
});
var grid = new Ext.grid.GridPanel
({
id:"MenuGridPanel",
renderTo:document.body,
layout:"fit",
frame:true,
border:true,
width:700,
height:450,
autoScroll:true,
store:store,
sm:sm,
cm:cm,
viewConfig:{forceFit: true},
title:'<img style="height:auto; width:auto;" src="images/first.gif" /> Ext2.2全新功能版系列之--批量删除',
bbar:pagingBar
});
}
</script>
<script type="text/javascript">
Ext.onReady(ready);
</script>
</div>
</form>
</body>
</html>

CODE:

create procedure [dbo].[DeleteMoreRow]
(
@Ids nvarchar(500),
@Result int=null output
)
as
begin try
while charindex(',',@Ids) <> 0 --循环删除
begin
delete from TypeTable where ID in (substring(@Ids,1,charindex(',',@Ids)-1) )
set @Ids = stuff(@Ids,1,charindex(',',@Ids),'')
end
set @Result = 1 --操作成功返回1
end try
begin catch
set @Result = 2 --出现异常返回2
end catch

分享到：

Ext2.0学习 | ExtJS 常见问题

2009-06-26 16:57
浏览 1378
评论(0)
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论