Ext.namespace('DsTruck');

DsTruck.MsWl_HH_ZY = function (config) {
    Ext.applyIf(this, config);
    this.initUIComponents();
    window.DsTruck.MsWl_HH_ZY.superclass.constructor.call(this);
};

Ext.extend(DsTruck.MsWl_HH_ZY, Ext.Panel, {
    PageSize: 200,
    OprationStatus: null, //仅当弹出界面时使用
    SelectedRecord: null,
    VISIBLERANGE: 4,
    OPERATERANGE: 4,

    initUIComponents: function () {
        this.bodyDel = [];
        this.Amount_ALL = 0;
        this.SettlementType = "";

        //////////////定义下拉菜单 计费方式BillingType
        Ext.define('BillingTypeMd', {
            extend: 'Ext.data.Model',
            fields: [
              { name: 'BillingType', type: 'string' },
              { name: 'BillingTypeREF', type: 'string' }
            ]
        });
        var BillingTypeData = [{ "BillingType": "0", "BillingTypeREF": "吨/公里" },
                          { "BillingType": "1", "BillingTypeREF": "车/公里" }
                          ];
        this.storeBillingType = Ext.create('Ext.data.Store', {
            model: 'BillingTypeMd',
            data: BillingTypeData
        });
        this.comboxBillingType = Ext.create('DsExt.ux.RefEnumCombox', {
            //fieldLabel: '收付类型',
            forceSelection: true,
            store: this.storeBillingType,
            name: 'BillingType',
            valueField: 'BillingType',
            displayField: 'BillingTypeREF'
        });

        //////////////

        //定义数据集
        this.storeList = Ext.create('Ext.data.Store', {
            pageSize: this.PageSize,
            model: 'HH_ZYmb',
            remoteSort: true,
            proxy: {
                type: 'ajax',
                url: '/TruckMng/MsWl_HH_ZY/GetDataList',
                reader: {
                    id: 'GID',
                    root: 'data',
                    totalProperty: 'totalCount'
                }
            }
        });
        this.storeList_2 = Ext.create('Ext.data.Store', {
            pageSize: this.PageSize,
            model: 'HH_ZYmb',
            groupField: 'TruckNo',
            remoteSort: true,
            //groupField: 'HTH',
            proxy: {
                type: 'ajax',
                url: '/TruckMng/MsWl_HH_ZY/GetDataList_2',
                reader: {
                    id: 'GID',
                    root: 'data',
                    totalProperty: 'totalCount'
                }
            }
        });

        this.cellEditing = Ext.create('Ext.grid.plugin.CellEditing', {
            clicksToEdit: 1
        });
        this.MainCB = Ext.create('Ext.selection.CheckboxModel', { checkOnly: true });
        Ext.grid.RowNumberer = Ext.extend(Ext.grid.RowNumberer, {
            width: 50
        });
        //定义Grid
        this.gridList = new Ext.grid.GridPanel({
            store: this.storeList,
            enableHdMenu: false,
            region: 'center',
            loadMask: { msg: "数据加载中，请稍等..." },
            trackMouseOver: true,
            disableSelection: false,
            selModel: this.MainCB,
            stripeRows: true,
            viewConfig: {
                enableTextSelection: true,
                getRowClass: function (record, rowIndex, rowParams, store) {
                    var feeStatus = record.get('HZSTATUS');
                    return DsTruck.MsChFeeGetRowClass(feeStatus);
                }
            },
            stateful: true,
            plugins: [this.cellEditing],

            columns: [new Ext.grid.RowNumberer()
            ,
        {
            sortable: true, hidden: true,
            dataIndex: 'GID',
            header: 'GID',
            width: 80
        },
            {
                sortable: true, hidden: true,
                dataIndex: 'OrgCode',
                header: 'OrgCode',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'HZSTATUS_REF',
                header: '业务状态',
                width: 60/*,
                editor: {
                    xtype: 'textfield'
                }*/
            }, {
                sortable: true, align: 'right',
                dataIndex: 'AmountPaid_1_Ref',
                header: '已收款',
                width: 60
            }, {
                sortable: true, align: 'right',
                dataIndex: 'AmountPaid_2_Ref',
                header: '已付款',
                width: 60
            },
            {
                sortable: true,
                dataIndex: 'Destination',
                header: '目的地',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true,
                dataIndex: 'ExpDate',
                header: '发车日期',
                width: 80,
                renderer: Ext.util.Format.dateRenderer('Y-m-d'),
                editor: {
                    format: 'Y-m-d',
                    xtype: 'datefield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true,
                dataIndex: 'TruckNo',
                header: '车号',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true,
                dataIndex: 'ContractNo',
                header: '合同号',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true, //hidden: true,
                dataIndex: 'MBLNO',
                header: '装运单号',
                width: 100,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true,
                dataIndex: 'CargoQty',
                header: '货物数量',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Tons',
                header: '吨数(折合)',
                width: 80, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Distance',
                header: '中烟运行距离',
                width: 90,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Pay_Distance',
                header: '结算距离',
                width: 90,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'BillingType',
                header: '计费方式',
                width: 90,
                renderer: function (value, p, record) {
                    if (value == null || value == '') return '';
                    else return record.data.BillingTypeREF;
                },
                editor: this.comboxBillingType

            },
            {
                sortable: true,
                dataIndex: 'Price_1', //原收费费率
                header: '物流部费率(元/吨公里)',
                tooltip: "中烟业务操作部从物流公司收费的收费费率",
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Price_2', //原付费费率
                header: '操作部费率(元/吨公里)',
                tooltip: "中烟业务操作部向车队付费的付费费率",
                width: 80,
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                value = usMoney(value, 4, '', true);
                return value;
                 },
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Price_3', //新增加
                header: '中烟公司费率(元/吨公里)',
                tooltip: "中烟公司向物流部付费的付费费率",
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Amount_1',
                header: '操作应收物流',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'agio_Amount_1',
                header: '操作收物流考核金额',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'TaxAmount_1',
                header: '含税收款金额',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Paid_Amount_1',
                header: '已收',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Remain_Amount_1',
                header: '未收',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Tax',
                header: '税款',
                width: 80, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Amount_2',
                header: '操作应付车队',
                width: 80, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'agio_Amount_2',
                header: '操作付车队考核金额',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'Amount_3',
                header: '中烟应付物流',
                width: 80, align: 'right'
            },
            {
                sortable: true,
                dataIndex: 'agio_Amount_3',
                header: '中烟应付物流考核金额',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }, align: 'right'
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'TaxAmount_2',
                header: '含税实际应付',
                width: 80
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Pay_Amount_2',
                header: '业务应付',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Paid_Amount_2',
                header: '已付',
                width: 80,
                editor: {
                    xtype: 'textfield',
                    selectOnFocus: true
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Remain_Amount_2',
                header: '未付',
                width: 80,
                editor: {
                    xtype: 'textfield'
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'In_Province',
                header: 'In_Province',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'In_Province_REF',
                header: '省内/省外',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'PROVINCENAME',
                header: '省名',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'AreaName',
                header: '隶属区域',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'Remark',
                header: '备注',
                width: 180,
                editor: {
                    xtype: 'textfield'
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'HZSTATUS',
                header: 'HZSTATUS',
                width: 180
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Property',
                header: 'Property',
                width: 180
            }],
            // paging bar on the bottom
            bbar: Ext.create('Ext.PagingToolbar', {
                store: this.storeList,
                displayInfo: true,
                displayMsg: '当前显示 {0} - {1}条记录 /共 {2}条记录',
                emptyMsg: "没有数据"
            })
        });


        this.cellEditing_2 = Ext.create('Ext.grid.plugin.CellEditing', {
            clicksToEdit: 1
        });
        this.MainCB_2 = Ext.create('Ext.selection.CheckboxModel', { checkOnly: true });
        Ext.grid.RowNumberer_2 = Ext.extend(Ext.grid.RowNumberer, {
            width: 50
        });
        var _this = this;
        var groupingFeature = Ext.create('Ext.grid.feature.Grouping');
        var SummaryFeature = Ext.create('Ext.grid.feature.Summary');

        this.gridList_2 = new Ext.grid.GridPanel({
            store: this.storeList_2,
            enableHdMenu: false,
            region: 'center',
            loadMask: { msg: "数据加载中，请稍等..." },
            trackMouseOver: true,
            disableSelection: false,
            selModel: this.MainCB_2,
            plugins: [this.cellEditing_2],
            features: [{
                id: 'group',
                //ftype: 'grouping',
                ftype: 'groupingsummary',
                groupHeaderTpl: '{name}',
                hideGroupedHeader: false,
                enableGroupingMenu: true
            }],
            columns: [new Ext.grid.RowNumberer_2()
            ,
        {
            sortable: true, hidden: true,
            dataIndex: 'GID',
            header: 'GID',
            width: 80
        },
            {
                sortable: true, hidden: true,
                dataIndex: 'OrgCode',
                header: 'OrgCode',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'Destination',
                header: '目的地',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true,
                dataIndex: 'ExpDate',
                header: '发车日期',
                width: 80,
                renderer: Ext.util.Format.dateRenderer('Y-m-d')
            },
            {
                sortable: true,
                dataIndex: 'TruckNo',
                header: '车号',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true,
                dataIndex: 'BizProperty_REF',
                header: '运营模式',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true,
                dataIndex: 'OWNER_REF',
                header: '拥有者',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true,
                dataIndex: 'ContractNo',
                header: '合同号',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'MBLNO',
                header: '装运号',
                width: 80/*,
                editor: {
                    xtype: 'textfield'
                }*/
            },
            {
                sortable: true,
                dataIndex: 'CargoQty',
                header: '货物数量',
                width: 80,
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true,
                dataIndex: 'Tons',
                header: '吨数(折合)',
                width: 80,
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true,
                dataIndex: 'Distance',
                header: '中烟运行距离',
                width: 80,
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true,
                dataIndex: 'Pay_Distance',
                header: '结算距离',
                width: 80,
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true,
                dataIndex: 'Price_1',
                header: '收款费率(元/吨公里)',
                width: 80,
                editor: {
                    xtype: 'textfield'
                }
            },
            {
                sortable: true,
                dataIndex: 'Price_2',
                header: '付款费率(元/吨公里)',
                width: 80,
                editor: {
                    xtype: 'textfield'
                }
            },
            {
                sortable: true,
                dataIndex: 'Amount_1',
                header: '收款金额',
                width: 110,
                editor: {
                    xtype: 'textfield'
                },
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Tax_Amount_1',
                header: '含税收款金额',
                width: 80,
                editor: {
                    xtype: 'textfield'
                },
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true,
                dataIndex: 'Amount_2',
                header: '付款金额',
                width: 110,
                editor: {
                    xtype: 'textfield'
                },
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'Tax_Amount_2',
                header: '含税付款金额',
                width: 80,
                editor: {
                    xtype: 'textfield'
                },
                summaryType: 'sum', align: 'right',
                summaryRenderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                },
                renderer: function (value, cellmeta, record, rowIndex, columnIndex, store) {
                    value = usMoney(value, 2, '', true);
                    return value;
                }
            },
            {
                sortable: true, hidden: true,
                dataIndex: 'In_Province',
                header: 'In_Province',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'In_Province_REF',
                header: '省内/省外',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'PROVINCENAME',
                header: '省名',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'AreaName',
                header: '隶属区域',
                width: 80
            },
            {
                sortable: true,
                dataIndex: 'Remark',
                header: '备注',
                width: 180,
                editor: {
                    xtype: 'textfield'
                }
            }],
            // paging bar on the bottom
            bbar: Ext.create('Ext.PagingToolbar', {
                store: this.storeList_2,
                displayInfo: true,
                displayMsg: '当前显示 {0} - {1}条记录 /共 {2}条记录',
                emptyMsg: "没有数据"
            })
        });
        /*
        this.gridList.addListener('itemdblclick', function (dataview, record, item, index, e, b) {
        this.SelectedRecord = record;
        this.OprationStatus = 'edit';
        DsOpenEditWin('/TruckMng/MsWlTruck/Edit');
        }, this);
        */
        //#region formSearch

        this.storeCompany = Ext.create('DsExt.ux.RefTableStore', {
            model: 'companymb', proxy: { url: '/CommMng/BasicDataRef/GetcompanyList' }
        });
        this.storeCompany.load({ params: { condition: ""} });
        this.comboxCompany = Ext.create('DsExt.ux.RefTableCombox', {
            fieldLabel: '所属分公司',
            forceSelection: true,
            store: this.storeCompany,
            name: 'OrgCode', id: "Company",
            valueField: 'code',
            displayField: 'name'
        });
        this.storeProperty = Ext.create('DsExt.ux.RefEnumStore', {});
        this.storeProperty.load({ params: { enumTypeId: 99033} });
        this.comboxProperty = Ext.create('DsExt.ux.RefEnumCombox', {
            fieldLabel: '车辆性质', id: "Property",
            store: this.storeProperty,
            name: 'Property'
        });

        this.formSearch = Ext.widget('form', {
            frame: true,
            region: 'center',
            bodyPadding: 5,
            fieldDefaults: {
                margins: '2 2 2 2',
                labelAlign: 'right',
                flex: 1,
                labelWidth: 90,
                msgTarget: 'qtip'
            },

            items: [
                {//fieldset 1
                    xtype: 'container',
                    defaultType: 'textfield',
                    layout: 'anchor',
                    defaults: {
                        anchor: '100%'
                    },
                    items: [{
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [{
                            fieldLabel: '车牌号',
                            name: 'TruckNo'
                        }, {
                            fieldLabel: '从..发车日',
                            format: 'Y-m-d', id: "EXPDATE_min",
                            xtype: 'datefield',
                            name: 'EXPDATE_min'
                        }, {
                            fieldLabel: '到..发车日',
                            format: 'Y-m-d',
                            xtype: 'datefield',
                            name: 'EXPDATE_max'
                        }, {
                            fieldLabel: '合同号',
                            name: 'ContractNo'
                        }, {
                            fieldLabel: '装运号',
                            name: 'MBLNO'
                        }
                       ]
                    }, {
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [this.comboxCompany,
                        this.comboxProperty
                        , {
                            fieldLabel: '目的地',
                            name: 'TARGET'
                        }, {
                            fieldLabel: '省名',
                            name: 'PROVINCENAME'
                        }
                        , {
                            fieldLabel: '隶属区域',
                            name: 'AREANAME'
                        }
                           ]
                    }
                    ]
                }
            ]

        });

        //#endregion formSearch

        me = this;
        this.formSetPrice = Ext.widget('form', {
            frame: true,
            region: 'center',
            bodyPadding: 5,
            fieldDefaults: {
                margins: '2 2 2 2',
                labelAlign: 'right',
                flex: 2,
                labelWidth: 90,
                msgTarget: 'qtip'
            },

            items: [
                {//fieldset 1
                    xtype: 'container',
                    defaultType: 'textfield',
                    layout: 'anchor',
                    defaults: {
                        anchor: '100%'
                    },
                    items: [{
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [{
                            fieldLabel: '操作部收物流费率',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Price_1'
                        }, {
                            fieldLabel: '中烟付物流费率',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Price_3'
                        }]
                    }, {
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [{
                            fieldLabel: '操作部付车队费率',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Price_2'
                        }, {
                            fieldLabel: '业务应付',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Pay_Amount_2'
                        }]
                    }
                    ]//end items(fieldset 1)
                }//end fieldset 1   
            ]//end root items          
        });

        this.winSetPrice = Ext.create('Ext.window.Window', {
            title: "设定费率",
            width: 450,
            //height : 120,
            //plain : true,
            iconCls: "addcomm",
            resizable: false,
            // 是否可以拖动
            // draggable:false,
            collapsible: true, // 允许缩放条
            closeAction: 'close',
            closable: true,
            modal: 'true',
            buttonAlign: "center",
            bodyStyle: "padding:0 0 0 0",
            items: [this.formSetPrice],
            buttons: [{
                text: "设定费率(空白项不变)",
                minWidth: 70,
                handler: function () {
                    me.onSetPriceClick();
                }
            }, {
                text: "关闭",
                minWidth: 70,
                handler: function () {
                    me.winSetPrice.close();
                }
            }]
        });

        this.formSettlement = Ext.widget('form', {
            frame: true,
            region: 'center',
            bodyPadding: 5,
            fieldDefaults: {
                margins: '2 2 2 2',
                labelAlign: 'right',
                flex: 2,
                labelWidth: 90,
                msgTarget: 'qtip'
            },

            items: [
                {//fieldset 1
                    xtype: 'container',
                    defaultType: 'textfield',
                    layout: 'anchor',
                    defaults: {
                        anchor: '100%'
                    },
                    items: [{
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [{
                            fieldLabel: '结算费用',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Amount_ALL',
                            values: "0"
                        }]
                    }/*, {
                        xtype: 'container',
                        layout: 'hbox',
                        defaultType: 'textfield',
                        items: [{
                            fieldLabel: '付费费率',
                            //format: 'Y-m',
                            xtype: 'textfield',
                            name: 'Price_2'
                        }]
                    }*/
                    ]//end items(fieldset 1)
                }//end fieldset 1   
            ]//end root items          
        });

        this.winSettlement = Ext.create('Ext.window.Window', {
            title: "费用结算",
            width: 400,
            //height : 120,
            //plain : true,
            iconCls: "addcomm",
            resizable: false,
            // 是否可以拖动
            // draggable:false,
            collapsible: true, // 允许缩放条
            closeAction: 'close',
            closable: true,
            modal: 'true',
            buttonAlign: "center",
            bodyStyle: "padding:0 0 0 0",
            items: [this.formSettlement],
            buttons: [{
                text: "结算",
                id: "BUTTON",
                minWidth: 70,
                handler: function () {
                    me.onSettlementClick();
                }
            }, {
                text: "取消",
                minWidth: 70,
                handler: function () {
                    me.winSettlement.close();
                }
            }]
        });

        var menu1 = new Ext.menu.Menu({
            id: 'basicMenu',
            items: [{
                text: '运费审核汇总表',
                handler: clickHandler
            }, {
                text: '应付车队表',
                handler: clickHandler_YFCD
            }
    ]
        });

        function clickHandler() {
            panelTest.Print();
        };
        function clickHandler_YFCD() {
            panelTest.Print_YFCD();
        };

        var menu_Settlement = new Ext.menu.Menu({
            id: 'PriceMenu',
            items: [{
                text: '收费结算',
                handler: clickHandler_1
            }, {
                text: '付费结算',
                handler: clickHandler_2
            }, {
                text: '收费反结算',
                handler: clickHandler_3
            }, {
                text: '付费反结算',
                handler: clickHandler_4
            }]
        });

        var _this = this;
        function clickHandler_1() {
            SetPaid('AmountPaid_1', 'AmountPaid_1_Ref', "1", "是");
        };
        function clickHandler_2() {
            SetPaid('AmountPaid_2', 'AmountPaid_2_Ref', "1", "是");
        };
        function clickHandler_3() {
            SetPaid('AmountPaid_1', 'AmountPaid_1_Ref', "0", "否");
        };
        function clickHandler_4() {
            SetPaid('AmountPaid_2', 'AmountPaid_2_Ref', "0", "否");
        };

        function SetPaid(sf, sf_Ref, paid, paid_Ref) {
            selectedRecords = _this.gridList.selModel.getSelection();

            for (var i = 0; i < selectedRecords.length; i++) {
                var rec = selectedRecords[i];
                rec.set(sf, paid);
                rec.set(sf_Ref, paid_Ref);
            }
        }
        /*
        function clickHandler_1() {
        me.SettlementType = "1";
        var form = me.formSettlement.getForm();

        var edt_Amount_ALL = form.findField('Amount_ALL');
        var Amount_ALL = me.GetAmount_ALL("Remain_Amount_1");
        if (Amount_ALL == "" || Amount_ALL == undefined) {
        Amount_ALL = "0";
        }
        me.Amount_ALL = Amount_ALL;
        edt_Amount_ALL.setRawValue(Amount_ALL);
        edt_Amount_ALL.setFieldLabel("应收金额");
        Ext.getCmp("BUTTON").setText("结算应收");
        //form.findField('Type').setRawValue(me.Type); ;
        me.winSettlement.show();
        };
        function clickHandler_2() {
        me.SettlementType = "2";
        var form = me.formSettlement.getForm();

        var edt_Amount_ALL = form.findField('Amount_ALL');
        var Amount_ALL = me.GetAmount_ALL("Remain_Amount_2");
        if (Amount_ALL == "" || Amount_ALL == undefined) {
        Amount_ALL = "0";
        }
        me.Amount_ALL = Amount_ALL;
        edt_Amount_ALL.setRawValue(Amount_ALL);
        edt_Amount_ALL.setFieldLabel("应付金额");
        Ext.getCmp("BUTTON").setText("结算应付");
        //form.findField('Type').setRawValue(me.Type); ;
        me.winSettlement.show();
        };
        function clickHandler_3() {
        me.SettlementType = "3";
        var form = me.formSettlement.getForm();

        var edt_Amount_ALL = form.findField('Amount_ALL');
        var Amount_ALL = me.GetAmount_ALL("Paid_Amount_1");
        if (Amount_ALL == "" || Amount_ALL == undefined) {
        Amount_ALL = "0";
        }
        me.Amount_ALL = Amount_ALL;
        edt_Amount_ALL.setRawValue(Amount_ALL);
        edt_Amount_ALL.setFieldLabel("反结算应收金额");
        Ext.getCmp("BUTTON").setText("反结算应收");
        //form.findField('Type').setRawValue(me.Type); ;
        me.winSettlement.show();
        };
        function clickHandler_4() {
        me.SettlementType = "4";
        var form = me.formSettlement.getForm();

        var edt_Amount_ALL = form.findField('Amount_ALL');
        var Amount_ALL = me.GetAmount_ALL("Paid_Amount_2");
        if (Amount_ALL == "" || Amount_ALL == undefined) {
        Amount_ALL = "0";
        }
        me.Amount_ALL = Amount_ALL;
        edt_Amount_ALL.setRawValue(Amount_ALL);
        edt_Amount_ALL.setFieldLabel("反结算应付金额");
        Ext.getCmp("BUTTON").setText("反结算应付");
        //form.findField('Type').setRawValue(me.Type); ;
        me.winSettlement.show();
        };*/

        //查询工具条
        //var me = this;
        this.panelBtn = new Ext.Panel({
            region: "north",
            tbar: [{
                text: "设定费率", hidden: true,
                iconCls: "btncomm",
                handler: function (button, event) {
                    var form = this.formSetPrice.getForm();
                    this.winSetPrice.show();
                },
                scope: this
            }, { text: "结算", iconCls: "img_money_yen", hidden: true,
                menu: menu_Settlement, scope: this
            }/*, {
                text: "结算",
                iconCls: "img_money_yen",
                handler: function (button, event) {
                    var form = this.formSettlement.getForm();
                    var Amount_ALL = form.findField('Amount_ALL');
                    //_Amount_ALL = 0;
                    Amount_ALL.setRawValue(this.Amount_ALL)
                    this.winSettlement.show();
                },
                scope: this
            }*/, '-', //img_money_yen
                {
                text: "新建", hidden: true,
                iconCls: "btnadd",
                handler: function (button, event) {
                    this.onAddClick(button, event);
                },
                scope: this
            },
                {
                    text: "删除",
                    iconCls: "btndelete",
                    handler: function (button, event) {
                        this.onDeleteClick(button, event);
                    },
                    scope: this
                }, {
                    text: "保存修改",
                    iconCls: "btnsave",
                    handler: function (button, event) {
                        this.Save(button, event);
                    },
                    scope: this
                },
                '-',
                {
                    text: "执行查询",
                    iconCls: "btnrefresh",
                    handler: function (button, event) {
                        this.onRefreshClick(button, event);
                    },
                    scope: this
                },
                {
                    text: "重置条件",
                    iconCls: "btnreset",
                    handler: function (button, event) {
                        this.onResetClick(button, event);
                    },
                    scope: this
                }, '-',
                {
                    text: "提交审核",
                    iconCls: "btnoperation",
                    handler: function (button, event) {
                        this.onSubmitClick("提交审核");
                    },
                    scope: this
                }, {
                    text: "撤回提交",
                    iconCls: "btncancel",
                    handler: function (button, event) {
                        this.onSubmitClick("撤回提交");
                    },
                    scope: this
                }, '-', {
                    text: "导入路单",
                    iconCls: "btnexportexcel",
                    handler: function (button, event) {
                        var winAccess = new DsTruck.FileImport({});
                        winAccess.StoreList = this.storeList;
                        winAccess.show();
                    },
                    scope: this
                }, {
                    text: "导出Excel",
                    id: "btnExportExcel",
                    iconCls: 'btnexportexcel',
                    handler: function (button, event) {
                        this.onExportClick(button, event);
                    },
                    scope: this
                }, '-',
                { text: "打印报表", menu: menu1, scope: this }
                ]
        });

        this.panelTop = new Ext.Panel({
            layout: "border",
            region: "north",
            height: 100,
            items: [this.formSearch, this.panelBtn]
        });
        this.page_1 = new Ext.Panel({
            id: "page_1",
            title: "路单信息",
            //autoScroll: true,
            layout: "border",
            region: 'center',
            items: [this.gridList]
        });
        this.page_2 = new Ext.Panel({
            id: "page_2",
            title: "单车业务小计",
            layout: "border",
            region: 'center',
            items: [this.gridList_2]
        });
        this.MainTab = new Ext.tab.Panel({
            //layout: "border",
            region: "center", //split: true,
            items: [this.page_1, this.page_2
        ]
        });

        Ext.apply(this, {
            items: [this.panelTop, this.MainTab]
        });

        //集中绑定 事件
        this.storeList.on('beforeload', function (store) {
            var sql = this.getCondition();
            Ext.apply(store.proxy.extraParams, { condition: sql });
        }, this);
        this.storeList_2.on('beforeload', function (store) {
            var sql = this.getCondition();
            Ext.apply(store.proxy.extraParams, { condition: sql });
        }, this);

        this.cellEditing.on('beforeedit', function (editor, e) {
            return this.HZBeforeEdit(editor, e);
        }, this);
        this.gridList.on('edit', function (editor, e, eOpts) {
            this.HZAfterEdit(editor, e, eOpts);
        }, this);
        /*
        this.gridList.getSelectionModel().on('select', function (button, event) {
        this.onSelectFee(button, event);
        }, this);*/

        var sql = this.getCondition();
        this.storeList.load({
            params: { start: 0, limit: this.PageSize, sort: '', condition: sql },
            waitMsg: "正在查询数据...",
            scope: this
        });
        this.storeList_2.load({
            params: { start: 0, limit: this.PageSize, sort: '', condition: sql },
            waitMsg: "正在查询数据...",
            scope: this
        });


        var me = this;
        Ext.Ajax.request({
            waitMsg: '正在查询用户权限...',
            async: false,
            url: '/CommMng/BasicDataRef/GetAuthorityRange',
            params: {
                modName: "modJY_ZY",
                USERID: USERID
            },
            callback: function (options, success, response) {
                if (success) {
                    var result = Ext.JSON.decode(response.responseText);

                    rec = result.data;
                    //alert(rec.VISIBLERANGE);
                    //alert(rec.OPERATERANGE);
                    //可操作为0则全都不可操作，
                    //1 只能修改操作收物流应收考核
                    //2 只能修改操作付车队应付考核

                    me.VISIBLERANGE = rec.VISIBLERANGE;
                    me.OPERATERANGE = rec.OPERATERANGE;
                    /*
                    if (this.OPERATERANGE == '0') {
                    canedit = true;
                    } else
                    if (this.OPERATERANGE == '1') {
                    if (e.field == 'agio_Amount_1')
                    canedit = true;
                    if (e.field == 'agio_Amount_2')
                    canedit = false;
                    if (e.field == 'agio_Amount_3')
                    canedit = true;
                    } else
                    if (this.OPERATERANGE == '2') {
                    if (e.field == 'agio_Amount_1')
                    canedit = false;
                    if (e.field == 'agio_Amount_2')
                    canedit = true;
                    if (e.field == 'agio_Amount_3')
                    canedit = false;
                    }*/
                }
                else
                    Ext.MessageBox.alert('请求出现错误,请重试', response.responseText);
            },
            scope: this
        }); //request over
    }, //end initUIComponents

    onRefreshClick: function (button, event) {
        this.storeList.removeAll();
        this.storeList_2.removeAll();

        var sql = this.getCondition();
        this.storeList.load({
            params: { start: 0, limit: this.PageSize, sort: '', condition: sql },
            waitMsg: "正在查询数据...",
            scope: this
        });
        this.storeList_2.load({
            params: { start: 0, limit: this.PageSize, sort: '', condition: sql },
            waitMsg: "正在查询数据...",
            scope: this
        });
    },
    onResetClick: function (button, event) {
        this.formSearch.getForm().reset();
    },
    onAddClick: function (button, event) {

        function newID() {
            var guid = "";
            for (var i = 1; i <= 32; i++) {
                var n = Math.floor(Math.random() * 16.0).toString(16);
                guid += n;
                if ((i == 8) || (i == 12) || (i == 16) || (i == 20))
                    guid += "-";
            }
            return guid.toUpperCase();
        }
        var newid = newID();
        var record = Ext.create('HH_ZYmb', {
            'GID': '',
            'OrgCode': '',
            'Destination': '',
            'ExpDate': '',
            'TruckNo': '',
            'ContractNo': '',
            'MBLNO': '',
            'CargoQty': '0',
            'Tons': '0',

            'Distance': '0',
            'Pay_Distance': '0',
            'Price_1': '0',
            'Price_2': '0',
            'Amount_1': '0',
            'Amount_2': '0',
            'In_Province': '1',
            'In_Province_REF': '',
            'Remark': '',
            'Paid_Amount_1': '0',
            'Paid_Amount_2': '0',
            'Remain_Amount_1': '0',
            'Remain_Amount_2': '0',
            'HZSTATUS': '1',
            'HZSTATUS_REF': '',
            'BizProperty_REF': '',
            'OWNER_REF': ''
        });
        this.storeList.add(record);

        var n = this.storeList.getCount();
        this.cellEditing.startEditByPosition({ row: n - 1, column: 2 });

    },
    onDeleteClick: function (button, event) {
        var selectedRecords = this.gridList.selModel.getSelection();
        Ext.MessageBox.confirm('提示', '确定删除记录吗？', function (btn) {
            if (btn == 'yes') {
                for (var i = 0; i < selectedRecords.length; i++) {
                    var rec = selectedRecords[i];
                    if (rec.id != "")  //如果是新增但没有保存的数据，没有必要提交到后台
                    {
                        this.bodyDel.push(rec);
                    }
                    this.storeList.remove(selectedRecords[i]);
                }
            }
        }, this);
    }, //onDeleteClick          
    Save: function (button, event) {
        //费用
        var bodyList = [];
        for (i = 0; i < this.storeList.getCount(); i += 1) {
            var member = this.storeList.getAt(i);
            bodyList.push(member);
        };
        var jsonBody = ConvertRecordsToJson(bodyList);
        var jsonDelBody = ConvertRecordsToJsonAll(this.bodyDel);
        if (jsonBody == '' && jsonDelBody == '') {
            return;
        }
        Ext.Msg.wait('正在保存数据, 请稍侯..');
        Ext.Ajax.request({
            waitMsg: '正在保存数据...',
            url: '/TruckMng/MsWl_HH_ZY/Save',
            scope: this,
            params: {
                body: jsonBody,
                delbody: jsonDelBody
            },
            callback: function (options, success, response) {
                if (success) {
                    Ext.MessageBox.hide();
                    var jsonresult = Ext.JSON.decode(response.responseText);
                    if (jsonresult.Success) {
                        //alert("保存成功");
                        var returnData = jsonresult.Data;
                        this.storeList.commitChanges();

                    } else {
                        Ext.Msg.show({ title: '错误', msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK });
                    }
                } else {
                    Ext.Msg.show({ title: '请重试',
                        msg: '服务器响应出错',
                        icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK
                    });
                }
                //alert('03');
            }
        });
    },
    getCondition: function () {
        var form = this.formSearch.getForm();
        if (!form.isValid()) {
            Ext.Msg.alert('提示', '查询条件赋值错误，请检查。');
            return '';
        }

        var sql = '';

        var truckNo = form.findField('TruckNo').getValue();
        sql = sql + getAndConSql(sql, truckNo, "TruckNo like '%" + truckNo + "%'");

        var EXPDATE_min = form.findField('EXPDATE_min').getRawValue();
        sql = sql + getAndConSql(sql, EXPDATE_min, "EXPDATE >= '" + EXPDATE_min + "'");
        var EXPDATE_max = form.findField('EXPDATE_max').getRawValue();
        sql = sql + getAndConSql(sql, EXPDATE_max, "EXPDATE <= '" + EXPDATE_max + " 23:59:59'");

        var ContractNo = form.findField('ContractNo').getValue();
        sql = sql + getAndConSql(sql, ContractNo, "ContractNo like '%" + ContractNo + "%'");
        var MBLNO = form.findField('MBLNO').getValue();
        sql = sql + getAndConSql(sql, MBLNO, "MBLNO like '%" + MBLNO + "%'");

        var OrgCode = form.findField('OrgCode').getValue();
        sql = sql + getAndConSql(sql, OrgCode, " TruckNo in( select truckno from tmswltruck where OrgCode= '" + OrgCode + "') ");

        var Property = form.findField('Property').getValue();
        sql = sql + getAndConSql(sql, Property, " TruckNo in( select truckno from tmswltruck where Property= '" + Property + "') ");

        var AREANAME = form.findField('AREANAME').getValue();
        sql = sql + getAndConSql(sql, AREANAME, " Destination in(select name from City_Distance where areaname like '%" + AREANAME + "%') ");

        var TARGET = form.findField('TARGET').getValue();
        sql = sql + getAndConSql(sql, TARGET, " Destination like '%" + TARGET + "%'");

        var PROVINCENAME = form.findField('PROVINCENAME').getValue();
        sql = sql + getAndConSql(sql, PROVINCENAME, " Destination in(select name from City_Distance where ProvinceName like '%" + PROVINCENAME + "%' or name like '" + AREANAME + "') ");
        return sql;
    },
    onImportBsClick: function (button, event) {

        var winAccess = new DsTruck.FileImport({

        });
        winAccess.StoreList = this.storeList;
        winAccess.show();
        return;
    },
    OprationSwap: function () {
        var ret = new Array();
        ret[0] = this.OprationStatus;
        ret[1] = this.storeList;
        ret[2] = this.SelectedRecord;

        return ret;
    },
    onSetPriceClick: function (button, event) {
        var GIdSql = '';
        var selectedRecords = this.gridList.selModel.getSelection();
        var form = this.formSetPrice.getForm();

        for (var i = 0; i < selectedRecords.length; i++) {
            var rec = selectedRecords[i];

            if (rec.data.HZSTATUS == "1" || rec.data.HZSTATUS == "6") {
                var GID = "'" + rec.data.GID + "'";
                if (GIdSql == '') {
                    GIdSql = GID;
                } else {
                    GIdSql = GIdSql + "," + GID;
                }
            } else {
                alert("不能为提交审核/审核通过的业务设定费率");
                return;
            }
        }

        if (GIdSql == '') {
            Ext.Msg.show({ title: '提示', msg: '没有选择要设定费率的业务!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
            return;
        };

        GIdSql = "  (" + GIdSql + ")";

        var Price_1 = form.findField('Price_1').getValue();
        var Price_2 = form.findField('Price_2').getValue();
        var Price_3 = form.findField('Price_3').getValue();
        if (Price_2 = "") {
            Price_2 = Cut(parseFloat(Price_1), "0.01", 2);
        }
        var Pay_Amount_2 = form.findField('Pay_Amount_2').getValue();
        if (Price_1 != "") {
            if (parseFloat(Price_1) < 0) {
                alert("请输入正数");
                return;
            }
        }
        if (Price_2 != "") {
            if (parseFloat(Price_2) < 0) {
                alert("请输入正数");
                return;
            }
        }
        if (Pay_Amount_2 != "") {
            if (parseFloat(Pay_Amount_2) < 0) {
                alert("请输入正数");
                return;
            }
        }
        Ext.Ajax.request({
            waitMsg: '正在添加数据...',
            url: '/TruckMng/MsWl_HH_ZY/SetPrice',
            params: {
                Price_1: Price_1,
                Price_2: Price_2,
                Price_3: Price_3,
                Pay_Amount_2: Pay_Amount_2,
                GIdSql: GIdSql
            },
            callback: function (options, success, response) {
                if (success) {
                    var result = Ext.JSON.decode(response.responseText);
                    if (!result.Success) {
                        Ext.Msg.show({
                            title: '提示',
                            msg: result.Message,
                            icon: Ext.MessageBox.ERROR,
                            buttons: Ext.Msg.OK
                        });
                        return;
                    } else {
                        this.winSetPrice.close();
                        this.onRefreshClick();
                    }

                } else {
                    Ext.MessageBox.alert('请求出现错误,请重试', response.responseText);
                }
            },
            scope: this
        });
    },
    onSettlementClick: function (button, event) {
        var GIdSql = '';
        var selectedRecords = this.gridList.selModel.getSelection();
        var form = this.formSettlement.getForm();

        for (var i = 0; i < selectedRecords.length; i++) {
            var rec = selectedRecords[i];
            if (rec.data.HZSTATUS == "0") {
                var GID = "'" + rec.data.GID + "'";
                if (GIdSql == '') {
                    GIdSql = GID;
                } else {
                    GIdSql = GIdSql + "," + GID;
                }
            } else {
                alert("请先审核通过");
                return;
            }
        }

        if (GIdSql == '') {
            Ext.Msg.show({ title: '提示', msg: '没有选择要结算的业务!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
            return;
        };
        var Amount_Settlement = form.findField('Amount_ALL').getRawValue();
        if (parseFloat(Amount_Settlement) > parseFloat(this.Amount_ALL)) {
            alert("结算金额大于选定业务的可结算金额，请重新填写");
            return;
        }
        Ext.Ajax.request({
            waitMsg: '正在添加数据...',
            url: '/TruckMng/MsWl_HH_ZY/SetSettlement',
            params: {
                GIDList: GIdSql,
                Amount_Settlement: Amount_Settlement,
                Type: this.SettlementType
            },
            callback: function (options, success, response) {
                if (success) {
                    var result = Ext.JSON.decode(response.responseText);
                    if (!result.Success) {
                        Ext.Msg.show({
                            title: '提示',
                            msg: result.Message,
                            icon: Ext.MessageBox.ERROR,
                            buttons: Ext.Msg.OK
                        });
                        return;
                    } else {
                        this.winSettlement.close();
                        this.onRefreshClick();
                    }

                } else {
                    Ext.MessageBox.alert('请求出现错误,请重试', response.responseText);
                }
            },
            scope: this
        });
    },
    onSubmitClick: function (Operation) {
        var GIdSql = '';
        var selectedRecords = this.gridList.selModel.getSelection();
        var form = this.formSettlement.getForm();

        for (var i = 0; i < selectedRecords.length; i++) {
            var rec = selectedRecords[i];
            /*
            if (rec.data.HZSTATUS != "1") {
            alert("只能提交录入状态的业务");
            return;
            }*/
            if (rec.data.ISVOU != '是') {
                var GID = "'" + rec.data.GID + "'";
                if (GIdSql == '') {
                    GIdSql = GID;
                } else {
                    GIdSql = GIdSql + "," + GID;
                }
            }
        }

        if (GIdSql == '') {
            Ext.Msg.show({ title: '提示', msg: '没有选择业务!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
            return;
        };
        var _U = "";
        if (Operation == "提交审核") {
            _U = '/TruckMng/MsWl_HH_ZY/Submit';
        }
        if (Operation == "撤回提交") {
            _U = '/TruckMng/MsWl_HH_ZY/Repeal';
        }

        Ext.Ajax.request({
            waitMsg: '正在添加数据...',
            url: _U,
            params: {
                GIDList: GIdSql
            },
            callback: function (options, success, response) {
                if (success) {
                    var result = Ext.JSON.decode(response.responseText);
                    if (!result.Success) {
                        Ext.Msg.show({
                            title: '提示',
                            msg: result.Message,
                            icon: Ext.MessageBox.ERROR,
                            buttons: Ext.Msg.OK
                        });
                        return;
                    } else {
                        this.winSettlement.close();
                        this.onRefreshClick();
                    }

                } else {
                    Ext.MessageBox.alert('请求出现错误,请重试', response.responseText);
                }
            },
            scope: this
        });
    },
    onExportClick: function (button, event) {
        var _p = this.MainTab.getActiveTab().id;
        if (_p == "page_1") {
            GridExportExcelPage(this.gridList);
        }
        if (_p == "page_2") {
            GridExportExcelPage(this.gridList_2);
        }
    },
    GetAmount_ALL: function (FieldName) {
        //Ext.getCmp("zongshu").setText("1234"); 

        var selectedRecords = this.gridList.selModel.getSelection();
        var sum = 0;
        for (var i = 0; i < selectedRecords.length; i++) {
            var rec = selectedRecords[i];
            if (rec.get(FieldName) != "") {
                sum = sum + parseFloat(rec.get(FieldName));
            }
        }
        return sum.toString();
        //sum = sum.toFixed(2);
        //Ext.getCmp("zongshu").setText("  选中金额:" + sum);

    },
    HZBeforeEdit: function (editor, e) {

        var canedit = true;

        var HZSTATUS = e.record.get('HZSTATUS');
        if (HZSTATUS == "1" || HZSTATUS == "6") {
            canedit = true;
        }
        else {
            canedit = false;
        }

        if (e.field == 'agio_Amount_1' || e.field == 'agio_Amount_2' || e.field == 'agio_Amount_3') {

            if (this.OPERATERANGE == '0') {
                canedit = false;
            } else
                if (this.OPERATERANGE == '1') {
                    if (e.field == 'agio_Amount_1')
                        canedit = true;
                    if (e.field == 'agio_Amount_2')
                        canedit = false;
                    if (e.field == 'agio_Amount_3')
                        canedit = true;
                } else
                    if (this.OPERATERANGE == '2') {
                        if (e.field == 'agio_Amount_1')
                            canedit = false;
                        if (e.field == 'agio_Amount_2')
                            canedit = true;
                        if (e.field == 'agio_Amount_3')
                            canedit = true;
                    }
        }

        if (e.field == 'Price_1' || e.field == 'Remark' || e.field == 'MBLNO' || e.field == 'agio_Amount_1' || e.field == 'agio_Amount_2' || e.field == 'agio_Amount_3') {

        }
        else {
            var HZSTATUS = e.record.get('HZSTATUS');
            if (HZSTATUS == "1" || HZSTATUS == "6") {
                canedit = true;
            }
            else {
                canedit = false;
            }
        }

        if (e.field == 'Paid_Amount_1' || e.field == 'Paid_Amount_2') {
            var HZSTATUS = e.record.get('HZSTATUS');
            if (HZSTATUS == "0") {
                canedit = true;
            }
            else {
                canedit = false;
            }
        }
        return canedit;

    },
    HZAfterEdit: function (editor, e, eOpts) {
        //需要自己实现里面的事件
        if (e.value == e.originalValue) { return; }

        if (e.field == 'CargoQty') {
            if (e.value != "") {
                CargoQty = parseFloat(e.record.get('CargoQty'));
                Tons = CargoQty / 50;
                e.record.set('Tons', Tons);
            }
            this.SetAmount(e);
        }
        if (e.field == 'Distance' || e.field == 'Pay_Distance') {
            this.SetAmount(e);
        }

        if (e.field == 'Price_1' || e.field == 'agio_Amount_1') {
            this.SetAmount(e);
        }
        if (e.field == 'Price_2' || e.field == 'agio_Amount_2') {
            this.SetAmount(e);
        }
        if (e.field == 'Price_3' || e.field == 'agio_Amount_3') {
            this.SetAmount(e);
        }
        if (e.field == 'Pay_Amount_2') {
            if (e.value == "") Pay_Amount_2 = 0;
            if (e.value != "") {
                if (Property == '2') {
                    var Tax = Mul(parseFloat(e.record.get('Price_2')), 0.045);
                    Amount_2 = parseFloat(e.value) - Tax;
                    e.record.set('Tax', Tax);
                    e.record.set('Amount_2', Amount_2);
                    if (Paid_Amount_2 == 0) {
                        e.record.set('Remain_Amount_2', Amount_2);
                    }
                } else {
                    var Tax = 0;
                    Amount_2 = parseFloat(e.value);
                    e.record.set('Tax', Tax);
                    e.record.set('Amount_2', Amount_2);
                    if (Paid_Amount_2 == 0) {
                        e.record.set('Remain_Amount_2', Amount_2);
                    }
                }
            }
        }

        if (e.field == 'BillingType') {
            var BSrecords = DsStoreQueryBy(this.storeBillingType, 'BillingType', e.value);
            if (BSrecords.getCount() > 0) {
                var BSdata = BSrecords.getAt(0).data;
                e.record.set('BillingTypeREF', BSdata.BillingTypeREF);
                this.SetAmount(e);
            } else {
                e.record.set('BillingTypeREF', '');
            }
        }

    },
    SetAmount: function (e) {
        var CargoQty = parseFloat(e.record.get('CargoQty'));
        var Tons = parseFloat(e.record.get('Tons'));
        var Price_1 = parseFloat(e.record.get('Price_1'));
        var Price_2 = parseFloat(e.record.get('Price_2'));
        var Price_3 = parseFloat(e.record.get('Price_3'));
        var Distance = parseFloat(e.record.get('Distance'));
        var Pay_Distance = parseFloat(e.record.get('Pay_Distance'));
        var Amount_1 = parseFloat(e.record.get('Amount_1'));
        var Amount_2 = parseFloat(e.record.get('Amount_2'));
        var Paid_Amount_1 = parseFloat(e.record.get('Paid_Amount_1'));
        var Paid_Amount_2 = parseFloat(e.record.get('Paid_Amount_2'));
        var Remain_Amount_1 = parseFloat(e.record.get('Remain_Amount_1'));
        var Remain_Amount_2 = parseFloat(e.record.get('Remain_Amount_2'));
        var BillingType = parseFloat(e.record.get('BillingType'));
        var Pay_Amount_2 = parseFloat(e.record.get('Pay_Amount_2'));
        var Property = parseFloat(e.record.get('Property'));

        var agio_Amount_1 = parseFloat(e.record.get('agio_Amount_1'));
        var agio_Amount_2 = parseFloat(e.record.get('agio_Amount_2'));
        var TaxAmount_1 = parseFloat(e.record.get('TaxAmount_1'));
        var TaxAmount_2 = parseFloat(e.record.get('TaxAmount_2'));

        if (e.value != "") {
            Price_1 = parseFloat(e.record.get('Price_1'));
            if (BillingType == "0") {
                Amount_1 = Mul3(Tons, Distance, Price_1);
                e.record.set('Amount_1', Amount_1);
                if (Paid_Amount_1 == 0) {
                    e.record.set('Remain_Amount_1', Amount_1);
                }
            } else if (BillingType == "1") {
                Amount_1 = Mul(Distance, Price_1);
                e.record.set('Amount_1', Amount_1);
                if (Paid_Amount_1 == 0) {
                    e.record.set('Remain_Amount_1', Amount_1);
                }
            }
            e.record.set('Amount_1', Amount_1);
            if (Paid_Amount_1 == 0) {
                e.record.set('Remain_Amount_1', Amount_1);
            }

            //TaxAmount_1 = Mul(Mul((Amount_1 + agio_Amount_1), 0.93), 1.11);
            //e.record.set('TaxAmount_1', TaxAmount_1);
        }



        if (e.value != "") {
            Price_2 = parseFloat(e.record.get('Price_2'));
            if (BillingType == "0") {
                Amount_2 = Mul3(Tons, Distance, Price_2);
                e.record.set('Amount_2', Amount_2);
                if (Paid_Amount_2 == 0) {
                    e.record.set('Remain_Amount_2', Amount_2);
                }
            } else if (BillingType == "1") {
                Amount_2 = Mul(Distance, Price_2);
                e.record.set('Amount_2', Amount_2);
                if (Paid_Amount_2 == 0) {
                    e.record.set('Remain_Amount_2', Amount_2);
                }
            }
            e.record.set('Amount_2', Amount_2);
            if (Paid_Amount_2 == 0) {
                e.record.set('Remain_Amount_2', Amount_2);
            }

            //TaxAmount_2 = Mul(Mul((Amount_2 + agio_Amount_2), 0.93), 1.11);
            //e.record.set('TaxAmount_2', TaxAmount_2);
        }


        if (e.value != "") {
            Price_3 = parseFloat(e.record.get('Price_3'));
            if (BillingType == "0") {
                Amount_3 = Mul3(Tons, Distance, Price_3);
                e.record.set('Amount_3', Amount_3);
            } else if (BillingType == "1") {
                Amount_3 = Mul(Distance, Price_3);
                e.record.set('Amount_3', Amount_3);
            }
            e.record.set('Amount_3', Amount_3);
        }
    },
    Print: function () {
        //alert("print"); 
        var printType = 'YFSHHZB'; //运费审核汇总表
        var T = this.getCondition();
        if (T != "") { T = " where " + T; }
        var sql1 = " select Destination,orgcode,dbo.trimdate(expdate) expdate,TruckNo,dbo.[ZY_GetContractNo](TruckNo,expdate,Destination) contractno ";
        sql1 = sql1 + " ,(select AreaName from City_Distance WHERE Name LIKE hz.Destination) as AreaName ";
        sql1 = sql1 + " ,(select ProvinceName from City_Distance WHERE Name LIKE hz.Destination) as 省名 ";
        sql1 = sql1 + " ,dbo.[ZY_GetMBLNO](TruckNo,expdate,Destination) MBLNO,Price_1,sum(Amount_1) Amount_1,Price_2,sum(Amount_2) Amount_2 ";
        sql1 = sql1 + " ,case in_Province when 0 then '省外' else '省内' end in_Province_ref ";
        sql1 = sql1 + " ,sum(CargoQty) CargoQty,sum(tons) tons,Distance,sum(Paid_Amount_1) [Paid_Amount_1] ";
        sql1 = sql1 + " ,sum(Paid_Amount_2) [Paid_Amount_2],sum([Amount_1]-[Paid_Amount_1]) Remain_Amount_1,sum([Amount_2]-[Paid_Amount_2]) Remain_Amount_2 ,HZSTATUS ";
        sql1 = sql1 + " ,(select EnumValueName from tSysEnumValue where LangId=0 and EnumTypeID=99024 and EnumValueID=HZSTATUS) as HZSTATUS_REF ";
        sql1 = sql1 + " ,(select EnumValueName from tSysEnumValue where LangId=0 and EnumTypeID=99033 and EnumValueID=( ";
        sql1 = sql1 + " 	select BizProperty from tMsWlTruck where truckno=hz.truckno)) as BizProperty_REF ";
        sql1 = sql1 + " ,(select shortname from info_client where gid=( ";
        sql1 = sql1 + " 	select owner from tMsWlTruck where truckno=hz.truckno)) as OWNER_REF,sum(tax) tax,sum(Pay_Amount_2) Pay_Amount_2    ";

        sql1 = sql1 + " FROM [tMsWl_HH_ZY] hz " + T;
        sql1 = sql1 + "  group by Destination,expdate,TruckNo,Price_1,Price_2,orgcode,in_Province,Distance,HZSTATUS,tax,Pay_Amount_2 ";
        sql1 = sql1 + " order by  expdate"

        var sql2 = " select Destination 城市,orgcode,dbo.trimdate(expdate) 发运日期,TruckNo 车号,dbo.[ZY_GetContractNo](TruckNo,expdate,Destination) 合同号 ";
        sql2 = sql2 + " ,(select AreaName from City_Distance WHERE Name LIKE hz.Destination) as AreaName ";
        sql2 = sql2 + " ,(select ProvinceName from City_Distance WHERE Name LIKE hz.Destination) as 省名 ";
        sql2 = sql2 + " ,dbo.[ZY_GetMBLNO](TruckNo,expdate,Destination) 装运号,Price_1,sum(Amount_1) Amount_1,Price_2  ";
        sql2 = sql2 + " ,sum(Amount_2) Amount_2,Price_3 运价标准,sum(isnull(Amount_3,0)+isnull(agio_amount_3,0)) 运费总额 ";
        sql2 = sql2 + " ,case in_Province when 0 then '省外' else '省内' end 省际 ";
        sql2 = sql2 + " ,case BillingType when 0 then '吨公里' else '车公里' end 计费方式 ";
        sql2 = sql2 + " ,sum(CargoQty) [运量(万支)],sum(tons) 计费吨数,Distance 计费里程 ";
        sql2 = sql2 + " ,(select EnumValueName from tSysEnumValue where LangId=0 and EnumTypeID=99033 and EnumValueID=( ";
        sql2 = sql2 + " 	select BizProperty from tMsWlTruck where truckno=hz.truckno)) as 车辆性质 ";
        sql2 = sql2 + " ,(select shortname from info_client where gid=( ";
        sql2 = sql2 + " 	select owner from tMsWlTruck where truckno=hz.truckno)) as 车辆所属    ";
        sql2 = sql2 + " FROM [tMsWl_HH_ZY] hz " + T;
        sql2 = sql2 + "  group by Destination,expdate,TruckNo,Price_1,Price_2,Price_3,orgcode,in_Province,Distance,BillingType ";
        sql2 = sql2 + " order by  expdate"


        function GetDateStr(AddDayCount) {
            var dd = new Date();
            dd.setDate(dd.getDate() + AddDayCount); //获取AddDayCount天后的日期
            var y = dd.getFullYear();
            var m = dd.getMonth() + 1; //获取当前月份的日期
            var d = dd.getDate();
            return y + "-" + m; //+ "-" + d;
        }
        //alert(GetDateStr(+5));
        var printdate = GetDateStr(0);
        //var getmoneydate = GetDateStr(5);

        var sql3 = "select '" + printdate + "'";
        var sql4 = "";
        var sql5 = "";
        var sql6 = "";

        PrintComm(printType, sql1, sql2, sql3, sql4, sql5, sql6);
    }
    ,
    Print_YFCD: function () {
        //alert("print"); 
        var printType = 'ZY_Print_YFCD'; //应付车队表
        var T = this.getCondition();
        if (T != "") { T = " where " + T; }
        var sql1 = " select expdate 派车日期,truckno 车号,Destination 目的地,sum(CargoQty) 数量,sum(Tons) 吨数 ";
        sql1 = sql1 + " ,(select name from company where codename=(select orgcode from tmswltruck tt where tt.truckno=hz.truckno)) 车辆所属分公司";
        sql1 = sql1 + " ,Distance 里程,Price_2 费率,sum(Amount_2+agio_Amount_2) 应付运费,case sum(isnull(agio_Amount_2,0)) when 0 then '' else convert(varchar,sum(isnull(agio_Amount_2,0))) end 备注   from tMsWl_HH_ZY hz " + T;
        sql1 = sql1 + " group by expdate ,truckno,Destination,Distance,Price_2 ";
        sql1 = sql1 + " order by expdate"

        var sql2 = "";

        function GetDateStr(AddDayCount) {
            var dd = new Date();
            dd.setDate(dd.getDate() + AddDayCount); //获取AddDayCount天后的日期
            var y = dd.getFullYear();
            var m = dd.getMonth() + 1; //获取当前月份的日期
            var d = dd.getDate();
            return y + "-" + m; //+ "-" + d;
        }
        //alert(GetDateStr(+5));
        var printdate = GetDateStr(0);
        //var getmoneydate = GetDateStr(5);

        var _date = Ext.getCmp("EXPDATE_min").getRawValue();
        var _y = _date.substr(0, 4);
        var _m = _date.substr(5, 2);

        var _company = Ext.getCmp("Company").getRawValue();

        var _Property = Ext.getCmp("Property").getRawValue();

        var sql3 = "select '" + SHOWNAME + "' 姓名,'" + printdate + "' 打印日期,'" + _y + "' 年,'" + _m + "' 月,'" + _company + _Property + "' 性质";
        var sql4 = "";
        var sql5 = "";
        var sql6 = "";

        PrintComm(printType, sql1, sql2, sql3, sql4, sql5, sql6);
    }
});