标签：

var P033_Query = function () { var Designbusiness_Store = new Ext.data.JsonStore({ //专业数据集 url: "PdmP032.csx?tag=GetDesignbusiness", fields: ["STANDA_SCHEDULE_ID", "STANDA_SCHEDULE_NAME"], baseParams: { strWhere: " AND S_TYPE =‘E‘ " }, root: "data", id: "STANDA_SCHEDULE_ID", toValue: function (v) { var rec = Designbusiness_Store.getById(v); return rec ? rec.data.STANDA_SCHEDULE_NAME : v; }, autoLoad: true }); var Designbusiness = new Ext.form.SComboBox({ width: 150, triggerAction: "all", store: Designbusiness_Store, valueField: ‘STANDA_SCHEDULE_ID‘, displayField: ‘STANDA_SCHEDULE_NAME‘ }); var f_center_num = new Ext.form.NumberField({ name: ‘COST_CENTER_ID‘, allowDecimals: false, allowNegative: false }) var f_center_name = new ef.TextField({ }) var f_subject = new ef.TextField({ }) var sm = new Ext.grid.CheckboxSelectionModel({}); var gridColumns = new eg.ColumnModel({ columns: [ sm, { header: "内码", dataIndex: "ID", hidden: true }, { header: "本钱中心编码" + prj.necessaryField, dataIndex: "COST_CENTER_ID", width: 100, editor: new Ext.form.NumberField({ name: ‘COST_CENTER_ID‘, allowDecimals: false, allowNegative: false }) }, { header: "归属科目" + prj.necessaryField, dataIndex: "ACC_ATT", editor: new ef.TextField({ name: ‘ACC_ATT‘ }) }, { header: "登记时间", dataIndex: "DEF_DATE", format: Date.patterns.ISO8601Short, xtype: ‘datecolumn‘, hidden: true }, { header: "登记人", dataIndex: "DEF_USR_ID", renderer: userStore.toValue, hidden: true }, { header: "改削时间", dataIndex: "UPD_DATE", format: Date.patterns.ISO8601Short, xtype: ‘datecolumn‘, hidden: true }, { header: "改削人", dataIndex: "UPD_USR_ID", renderer: userStore.toValue, hidden: true } ] }); var p_store = new Ext.data.JsonStore({ //数据集 url: "PdmP033.csx?tag=GetJsonList", fields: ["ID", { name: "COST_CENTER_ID", allowBlank: false }, "UPD_USR_ID", "DEF_USR_ID", { name: "DEF_DATE", type: "date", dateFormat: Date.patterns.ISO8601Short }, { name: "UPD_DATE", type: "date", dateFormat: Date.patterns.ISO8601Short }], root: "data", baseParams: { sfields: ["COST_CENTER_ID"].join(prj.colSplit), sfieldtypes: [‘number‘].join(prj.colSplit), relations: [" = "].join(prj.colSplit), page: "1", }, id: "id", totalProperty: "totalCount" }) function getBaseParams(v) { var p = { svalues: [f_center_num.getValue()].join(prj.colSplit), limit: pagebar.pageSize }; Ext.apply(v.baseParams, p); } p_store.on(‘beforeload‘, getBaseParams); var pagebar = new prj.util.PagingToolbar(p_store, 20); var grid = new Ext.RSEGrid({ //数据显示面板 id: ‘P033_btn_panel_grid‘, border: false, store: p_store, sm: sm, cm: gridColumns, buttonAlign: ‘left‘, bbar: pagebar, region: ‘center‘ }); var searchBtn = new Ext.Button({ text: "搜索", iconCls: ‘Icon16_Search‘, handler: function () { grid.getStore().load({ params: { start: 0 } }); } }); var qtbr_1 = new Ext.Toolbar({ items: ["本钱中心编码", f_center_num,‘-‘, searchBtn] }) var query_panel = new Ext.Panel({ id: ‘P033_btn_panel‘, border: false, layout: "border", isLoad: true, items: [grid], tbar: [‘->‘], listeners: { render: function (p) { qtbr_1.render(p.tbar); } } }); query_panel.grid = grid; query_panel.load = function () { } query_panel.func = function () { }; return query_panel; }

public string GetJsonList() { try { S_VO v = new S_VO(Request); string sql = "SELECT * FROM DES_REV_NODE_CONFIG WHERE 1=1 {0}"; DbUtil.Query(string.Format(sql, v.getCondition()), v); return v.getJsonList(); } catch (Exception ex) { throw ex; } }