货物类型 代码
var hwlx_httpProxy = new Ext.data.HttpProxy({
url : "Data/dangan/GetHwlx.aspx" });
var hwlx_create = new Ext.data.Record.create([{
name : "id",
mapping : "id"
}, {
name : "name",
mapping : "name",
type : "string"
}]); var hwlx_jsonReader = new Ext.data.JsonReader({
totalProperty : "totalProperty", // 总记录数
root : "data" // 所有的数据(json对象数组)
}, hwlx_create) var hwlx_Store = new Ext.data.Store({
proxy : hwlx_httpProxy,
reader : hwlx_jsonReader
});
hwlx_Store.load(); var combo_hwlx = new Ext.form.ComboBox({
store:hwlx_Store,
id:'cyf_hwlx',
name:'cyf_hwlx',
hiddenName:'cyf_hwlxhidden',
fieldLabel:'货物类型',
width:100,
emptyText:'请选择...',
triggerAction:'All',
valueField:'id',
displayField:'name',
selectOnFocus:true,
allowBlank:false,
mode:'local',
blankText:'请选择货物类型'
}); 送达站代码
var com_httpProxy = new Ext.data.HttpProxy({
url : "Data/dangan/GetCompany.aspx" });
var com_create = new Ext.data.Record.create([{
name : "companyid",
mapping : "companyid"
}, {
name : "companyname",
mapping : "companyname",
type : "string"
}]); var com_jsonReader = new Ext.data.JsonReader({
totalProperty : "totalProperty", // 总记录数
root : "data" // 所有的数据(json对象数组)
}, com_create) var sdz_Store = new Ext.data.Store({
proxy : com_httpProxy,
reader : com_jsonReader
});
sdz_Store.load(); var combo_sdz = new Ext.form.ComboBox({
store:sdz_Store,
id:'cyf_sdzmc',
name:'cyf_sdzmc',
hiddenName:'cyf_sdzmchidden',
fieldLabel:'送达站',
width:100,
emptyText:'请选择...',
triggerAction:'All',
valueField:'companyid',
displayField:'companyname',
selectOnFocus:true,
allowBlank:false,
mode:'local',
blankText:'请选择送达站'
}); {
columnWidth:.3,
layout:'form',
items:[
combo_sdz //送达站combox
]
},{
columnWidth:.3,
layout:'form',
items:[
combo_hwlx //货物类型combox
]
}
var hwlx_httpProxy = new Ext.data.HttpProxy({
url : "Data/dangan/GetHwlx.aspx" });
var hwlx_create = new Ext.data.Record.create([{
name : "id",
mapping : "id"
}, {
name : "name",
mapping : "name",
type : "string"
}]); var hwlx_jsonReader = new Ext.data.JsonReader({
totalProperty : "totalProperty", // 总记录数
root : "data" // 所有的数据(json对象数组)
}, hwlx_create) var hwlx_Store = new Ext.data.Store({
proxy : hwlx_httpProxy,
reader : hwlx_jsonReader
});
hwlx_Store.load(); var combo_hwlx = new Ext.form.ComboBox({
store:hwlx_Store,
id:'cyf_hwlx',
name:'cyf_hwlx',
hiddenName:'cyf_hwlxhidden',
fieldLabel:'货物类型',
width:100,
emptyText:'请选择...',
triggerAction:'All',
valueField:'id',
displayField:'name',
selectOnFocus:true,
allowBlank:false,
mode:'local',
blankText:'请选择货物类型'
}); 送达站代码
var com_httpProxy = new Ext.data.HttpProxy({
url : "Data/dangan/GetCompany.aspx" });
var com_create = new Ext.data.Record.create([{
name : "companyid",
mapping : "companyid"
}, {
name : "companyname",
mapping : "companyname",
type : "string"
}]); var com_jsonReader = new Ext.data.JsonReader({
totalProperty : "totalProperty", // 总记录数
root : "data" // 所有的数据(json对象数组)
}, com_create) var sdz_Store = new Ext.data.Store({
proxy : com_httpProxy,
reader : com_jsonReader
});
sdz_Store.load(); var combo_sdz = new Ext.form.ComboBox({
store:sdz_Store,
id:'cyf_sdzmc',
name:'cyf_sdzmc',
hiddenName:'cyf_sdzmchidden',
fieldLabel:'送达站',
width:100,
emptyText:'请选择...',
triggerAction:'All',
valueField:'companyid',
displayField:'companyname',
selectOnFocus:true,
allowBlank:false,
mode:'local',
blankText:'请选择送达站'
}); {
columnWidth:.3,
layout:'form',
items:[
combo_sdz //送达站combox
]
},{
columnWidth:.3,
layout:'form',
items:[
combo_hwlx //货物类型combox
]
}
SQLHelper sqlHelp = new SQLHelper();
JSONHelper json = new JSONHelper();
json.success = true;
string jsons = ""; DataSet ds = sqlHelp.GetDataSet("select companyid,companyname from company ");
foreach (DataRow row in ds.Tables[0].Rows)
{
json.AddItem("companyid", row["companyid"].ToString());
json.AddItem("companyname", row["companyname"].ToString());
json.ItemOk(); jsons = json.ToString();
}
Response.Write(jsons);这是货物类型的绑定代码 SQLHelper sqlHelp = new SQLHelper();
JSONHelper json = new JSONHelper();
json.success = true;
string jsons = ""; DataSet ds = sqlHelp.GetDataSet("select id,name from bm_hwlx ");
foreach (DataRow row in ds.Tables[0].Rows)
{
json.AddItem("id", row["id"].ToString());
json.AddItem("name", row["name"].ToString());
json.ItemOk(); jsons = json.ToString();
}
Response.Write(jsons);jsons 都是正常输入值
以下是company 表的json输出
{totalCount:3,success:true,error:"",singleInfo:"",data:[{"companyid":"100","companyname":"恩速"},{"companyid":"200","companyname":"闽通"},{"companyid":"300","companyname":"永杰"}]}