在本机上怎么测都是正常的,可一放到服务器就显示不出了,我倒~现在用关键字和日期条件来查就可以,但只是用日期就查不出来.在本机上一步步调试,传值也没有什么问题,可就是不知道放到服务器就会变成那个样子的呢. 代码如下:Ext.onReady(function() {
Ext.QuickTips.init(); var h = window.location.href.split("?");
var xg = Ext.grid; var reader = new Ext.data.JsonReader({
root: "rows",
totalProperty: "totalCount",
fields: ['uid', 'uName', 'sendtime', 'msg', 'dtime']
}); var store = new Ext.data.GroupingStore({
id: "GroupStore",
reader: reader,
remoteStore: true,
sortInfo: { field: "sendtime", direction: "ASC" },
groupField: "dtime",
proxy: new Ext.data.HttpProxy({
url: "returnMsg.aspx?"+ h[1],
autoAbort: true,
//disableCaching: true,
timeout: 180000,
method: "POST"
})
});
store.load();
var grid = new xg.GridPanel({
store: store,
columns: [
{ header: "日期", hidden: true, sortable: true, width: 80, dataIndex: "dtime" },
{ header: "ID", hidden: true, sortable: true, width: 20, dataIndex: "uid" },
{ header: "发送人", sortable: true, width: 100, dataIndex: "uName" },
{ header: "发送时间", sortable: true, width: 100, dataIndex: "sendtime" }
],
view: new Ext.grid.GroupingView({
forceFit: true,
groupTexTpl: '{text} ({[values.rs.length]} {[values.rs.length > 1 ? "Items" : "Item"]})',
enableRowBody: true,
showPreview: true,
getRowClass: function(record, rowIndex, p, store) {
if (this.showPreview) {
p.body = '<div style="padding-top:5px;padding-bottom:5px;word-break:break-all;word-wrap:break-word">' + record.data.msg + '</div>';
return 'x-grid3-row-expanded';
}
return 'x-grid3-row-collapsed';
}
}),
loadMask: true,
collapsible: true,
animCollapse: false,
iconCls: 'icon-grid',
region: "center",
tbar: [{ text: "<font color='blue'><b>弹出查询窗口</b></font>", handler: windowshow}]
});
function windowshow() {
var login = new Ext.FormPanel({
labelWidth: 60,
labelAlign: 'right',
frame: true,
title: '查询条件',
defaultType: 'textfield',
monitorValid: true,
items: [{
width: 150,
fieldLabel: '按账号',
name: 'keyname',
id: 'keyname'
}, {
width: 150,
fieldLabel: '按内容',
name: 'keyword',
id: 'keyword'
},
{
width: 150,
fieldLabel: '开始日期',
xtype: 'datefield',
name: 'startdate',
id: 'startdate',
format: 'Y-m-d',
//disabledDays: [0, 6],
allowBlank: false, value: '<%=DateTime.Now.ToString("yyyy-MM-dd") %>'
},
{
width: 150,
fieldLabel: '结束日期',
xtype: 'datefield',
name: 'enddate',
id: 'enddate',
format: 'Y-m-d',
//disabledDays: [0, 6],
allowBlank: false, value: '<%=DateTime.Now.ToString("yyyy-MM-dd") %>'
}],
buttons: [{
text: '查找',
handler: search_submit
}]
}); var win = new Ext.Window({
layout: 'fit',
width: 250,
height: 215,
closable: true,
resizable: true,
plain: true,
//border: false,
items: [login]
});
win.show();
}
windowshow(); function search_submit() {
store.baseParams = {
keyname: document.getElementById('keyname').value,
keyword: document.getElementById('keyword').value,
startdate: document.getElementById('startdate').value,
enddate: document.getElementById('enddate').value
};
store.load();
} new Ext.Viewport({
enableTabScroll: true,
layout: "fit",
items: [grid]
});
});
if (Request.Params["keyname"] != null)
{
string query = HttpContext.Current.Request.Url.PathAndQuery;
StringBuilder cmd = new StringBuilder(); cmd.Append(sqlStr);
string keyname = Request.Params["keyname"].ToString();
string keyword = Request.Params["keyword"].ToString();
string startdate = Request.Params["startdate"].ToString();
string enddate = Request.Params["enddate"].ToString(); if (!startdate.Equals(""))
{
cmd.Append(" and sendtime >='" + startdate + "'");
} if (!enddate.Equals(""))
{
cmd.Append(" and sendtime <='" + enddate + " 23:59:59'");
} if (!keyname.Equals(""))
{
cmd.Append(" and STAFFNAME like '%" + keyname + "%'");
} if (!keyword.Equals(""))
{
cmd.Append(" and msg like '%" + keyword + "%'");
}
HttpContext.Current.Response.Write(GetTypeV(cmd.ToString()));
HttpContext.Current.Response.End();
}
Ext.QuickTips.init(); var h = window.location.href.split("?");
var xg = Ext.grid; var reader = new Ext.data.JsonReader({
root: "rows",
totalProperty: "totalCount",
fields: ['uid', 'uName', 'sendtime', 'msg', 'dtime']
}); var store = new Ext.data.GroupingStore({
id: "GroupStore",
reader: reader,
remoteStore: true,
sortInfo: { field: "sendtime", direction: "ASC" },
groupField: "dtime",
proxy: new Ext.data.HttpProxy({
url: "returnMsg.aspx?"+ h[1],
autoAbort: true,
//disableCaching: true,
timeout: 180000,
method: "POST"
})
});
store.load();
var grid = new xg.GridPanel({
store: store,
columns: [
{ header: "日期", hidden: true, sortable: true, width: 80, dataIndex: "dtime" },
{ header: "ID", hidden: true, sortable: true, width: 20, dataIndex: "uid" },
{ header: "发送人", sortable: true, width: 100, dataIndex: "uName" },
{ header: "发送时间", sortable: true, width: 100, dataIndex: "sendtime" }
],
view: new Ext.grid.GroupingView({
forceFit: true,
groupTexTpl: '{text} ({[values.rs.length]} {[values.rs.length > 1 ? "Items" : "Item"]})',
enableRowBody: true,
showPreview: true,
getRowClass: function(record, rowIndex, p, store) {
if (this.showPreview) {
p.body = '<div style="padding-top:5px;padding-bottom:5px;word-break:break-all;word-wrap:break-word">' + record.data.msg + '</div>';
return 'x-grid3-row-expanded';
}
return 'x-grid3-row-collapsed';
}
}),
loadMask: true,
collapsible: true,
animCollapse: false,
iconCls: 'icon-grid',
region: "center",
tbar: [{ text: "<font color='blue'><b>弹出查询窗口</b></font>", handler: windowshow}]
});
function windowshow() {
var login = new Ext.FormPanel({
labelWidth: 60,
labelAlign: 'right',
frame: true,
title: '查询条件',
defaultType: 'textfield',
monitorValid: true,
items: [{
width: 150,
fieldLabel: '按账号',
name: 'keyname',
id: 'keyname'
}, {
width: 150,
fieldLabel: '按内容',
name: 'keyword',
id: 'keyword'
},
{
width: 150,
fieldLabel: '开始日期',
xtype: 'datefield',
name: 'startdate',
id: 'startdate',
format: 'Y-m-d',
//disabledDays: [0, 6],
allowBlank: false, value: '<%=DateTime.Now.ToString("yyyy-MM-dd") %>'
},
{
width: 150,
fieldLabel: '结束日期',
xtype: 'datefield',
name: 'enddate',
id: 'enddate',
format: 'Y-m-d',
//disabledDays: [0, 6],
allowBlank: false, value: '<%=DateTime.Now.ToString("yyyy-MM-dd") %>'
}],
buttons: [{
text: '查找',
handler: search_submit
}]
}); var win = new Ext.Window({
layout: 'fit',
width: 250,
height: 215,
closable: true,
resizable: true,
plain: true,
//border: false,
items: [login]
});
win.show();
}
windowshow(); function search_submit() {
store.baseParams = {
keyname: document.getElementById('keyname').value,
keyword: document.getElementById('keyword').value,
startdate: document.getElementById('startdate').value,
enddate: document.getElementById('enddate').value
};
store.load();
} new Ext.Viewport({
enableTabScroll: true,
layout: "fit",
items: [grid]
});
});
if (Request.Params["keyname"] != null)
{
string query = HttpContext.Current.Request.Url.PathAndQuery;
StringBuilder cmd = new StringBuilder(); cmd.Append(sqlStr);
string keyname = Request.Params["keyname"].ToString();
string keyword = Request.Params["keyword"].ToString();
string startdate = Request.Params["startdate"].ToString();
string enddate = Request.Params["enddate"].ToString(); if (!startdate.Equals(""))
{
cmd.Append(" and sendtime >='" + startdate + "'");
} if (!enddate.Equals(""))
{
cmd.Append(" and sendtime <='" + enddate + " 23:59:59'");
} if (!keyname.Equals(""))
{
cmd.Append(" and STAFFNAME like '%" + keyname + "%'");
} if (!keyword.Equals(""))
{
cmd.Append(" and msg like '%" + keyword + "%'");
}
HttpContext.Current.Response.Write(GetTypeV(cmd.ToString()));
HttpContext.Current.Response.End();
}
我用了性能工具的Sql Server Profiler获取到sql字符串,执行也是正常的,值也有传过去呀.
可为什么在本地上一点问题都没有,却偏偏在放上服务器时才有问题呢.唉~~~~~~~,本来我还想编辑来着,CSDN提示没有权限.