Ext.namespace('DsTruck'); DsTruck.MsKfJhEdit = function (config) { Ext.applyIf(this, config); this.initUIComponents(); window.DsTruck.MsKfJhEdit.superclass.constructor.call(this); }; Ext.extend(DsTruck.MsKfJhEdit, Ext.Panel, { ParentWin: null, OpStatus: 'add', StoreList: null, EditRecord: null, initUIComponents: function () { this.serialNo = 0; this.bodyDel = []; //#region 编辑form //枚举参照相关(编辑form) //表参照相关(编辑form) this.storeJhrCode = Ext.create('DsExt.ux.RefTableStore', { model: 'DsTruckMng.ux.UserRefModel', proxy: { url: '/CommMng/BasicDataRef/GetUserRefList' } }); this.storeJhrCode.load({ params: { condition: ""} }); this.comboxJhrCode = Ext.create('DsExt.ux.RefTableCombox', { fieldLabel: '进货人', store: this.storeJhrCode, name: 'JhrCode', valueField: 'UserCode', displayField: 'CodeAndName' }); this.storeSupplierCode = Ext.create('DsExt.ux.RefTableStore', { model: 'DsTruckMng.ux.CustomRefModel', proxy: { url: '/CommMng/BasicDataRef/GetCustomRefList' } }); this.storeSupplierCode.load({ params: { condition: "ISCUSTOM='1'"} }); this.comboxSupplier = Ext.create('DsExt.ux.RefTableCombox', { fieldLabel: '供应商', store: this.storeSupplierCode, name: 'Supplier', valueField: 'CustCode', // disabled: true, displayField: 'CodeAndName' }); //编辑form this.formEdit = Ext.widget('form', { region: 'center', frame: true, bodyPadding: 5, autoScroll: true, fieldDefaults: { margins: '2 2 2 2', labelAlign: 'right', flex: 1, labelWidth: 100, msgTarget: 'qtip' }, items: [ {//fieldset 1 xtype: 'fieldset', defaultType: 'textfield', layout: 'anchor', defaults: { anchor: '96%' }, items: [{ xtype: 'container', layout: 'hbox', defaultType: 'textfield', items: [{ fieldLabel: '录入日期', name: 'LrDate', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '记账日期', name: 'JzDate', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '用户编码', name: 'UserCode', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '用户姓名', name: 'UserName', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '时间戳', name: 'TimeMark', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '组织编码', name: 'OrgCode', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '组织名称', name: 'OrgName', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '单据类型', name: 'BillType', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '仓库编码', name: 'CkCode', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '仓库名称', name: 'CkName', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '进货人姓名', name: 'JhrName', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '配件类型', name: 'PluType', flex: 0, hidden: true, margins: '0' }, { fieldLabel: '单据号', allowBlank: false, disabled: true, name: 'BillNo' }, { fieldLabel: '进货日期', format: 'Y-m-d', xtype: 'datefield', allowBlank: false, name: 'JhDate' }, this.comboxJhrCode ] }, { xtype: 'container', layout: 'hbox', defaultType: 'textfield', items: [{ fieldLabel: '进货数量', xtype: 'numberfield', allowBlank: false, hidden: true, name: 'JhCount' }, { fieldLabel: '进货金额', xtype: 'numberfield', allowBlank: false, hidden: true, name: 'JhTotal' }, this.comboxSupplier, { fieldLabel: '备注', name: 'Remark' } ] } ]//end items(fieldset 1) }//end fieldset 1 ]//end root items }); //end this.formEdit //#endregion //#region 按钮Toolbar this.panelBtn = new Ext.Panel({ region: "north", tbar: [ { id: 'btnESave', text: "保存", iconCls: "btnsave", handler: function (button, event) { this.Save('0'); }, scope: this }, { id: 'btnESaveAndClose', text: "保存并关闭", handler: function (button, event) { this.Save('1'); }, scope: this }, { id: 'btnESaveAndNew', text: "保存并新建", handler: function (button, event) { this.Save('2'); }, scope: this }, '-', { text: "关闭", handler: function (button, event) { window.close(); }, scope: this }, { text: "新建", handler: function (button, event) { this.LoadData('add', ''); var basicForm = this.formEdit.getForm(); basicForm.findField('BillNo').setDisabled(false); }, scope: this }, '-', { id: 'btnEAccount', text: "记账", handler: function (button, event) { this.onAccountClick(button, event); }, scope: this }, '-', { text: "打印", iconCls: "btnprint", handler: function (button, event) { this.Print(); }, scope: this } ] }); //end 按钮Toolbar //#endregion //#region 明细表 //明细表表格相关 this.storePluCodeRef = Ext.create('DsExt.ux.RefTableStore', { model: 'DsTruckMng.ux.PluRefModel', proxy: { url: '/CommMng/BasicDataRef/GetPluRefList' } }); this.storePluCodeRef.load({ params: { condition: ""} }); this.comboxPluCodeRef = Ext.create('DsExt.ux.RefTableCombox', { store: this.storePluCodeRef, name: 'PluCode', valueField: 'PluCode', displayField: 'CodeAndName' }); //明细表-数据集 this.storeBodyList = Ext.create('Ext.data.Store', { model: 'MsKfJhBody', remoteSort: true, proxy: { type: 'ajax', url: '/TruckMng/MsKfJh/GetBodyList', reader: { id: 'BillNo,SerialNo', root: 'data', totalProperty: 'totalCount' } } }); //明细表表格 this.gridListCellEditing = Ext.create('Ext.grid.plugin.CellEditing', { clicksToEdit: 1 }); this.gridList = new Ext.grid.GridPanel({ store: this.storeBodyList, enableHdMenu: false, region: 'center', loadMask: { msg: "数据加载中,请稍等..." }, trackMouseOver: true, disableSelection: false, plugins: [this.gridListCellEditing], selType: 'cellmodel', tbar: [{ text: '增加明细', tooltip: '增加明细', iconCls: "btnadddetail", handler: function (button, event) { this.onAddDetailClick(button, event); }, scope: this }, '-', { text: '删除明细', tooltip: '删除明细', iconCls: "btndeletedetail", handler: function (button, event) { this.onDelDetailClick(button, event); }, scope: this }], columns: [{ sortable: true, dataIndex: 'BillNo', header: '单据号', hidden: true, width: 120 }, { sortable: true, dataIndex: 'SerialNo', header: '录入序号', width: 100 }, { sortable: true, dataIndex: 'PluCode', header: '配件编码', renderer: function (value, p, record) { if (value == null || value == '') return ''; else return value + '-' + record.data.PluName; }, editor: this.comboxPluCodeRef, width: 120 }, { sortable: true, dataIndex: 'PluName', header: '配件名称', hidden: true, width: 160 }, { sortable: true, dataIndex: 'Spec', header: '规格', width: 160 }, { sortable: true, dataIndex: 'Unit', header: '单位', width: 80 }, { sortable: true, dataIndex: 'Price', header: '单价', editor: { xtype: 'numberfield', allowBlank: false, selectOnFocus: true }, width: 120 }, { sortable: true, dataIndex: 'JhCount', header: '进货数量', editor: { xtype: 'numberfield', allowBlank: false, selectOnFocus: true }, width: 120 }, { sortable: true, dataIndex: 'JhTotal', header: '进货金额', editor: { xtype: 'numberfield', allowBlank: false, selectOnFocus: true }, width: 160 }, { sortable: true, dataIndex: 'Remark', header: '备注', editor: { xtype: 'textfield', selectOnFocus: true }, width: 200 }, { sortable: true, dataIndex: 'PcNo', header: '批次号', hidden: true, width: 120 }, { sortable: true, dataIndex: 'TyreType', header: '轮胎类型', hidden: true, width: 80 } ] }); //#endregion 明细表 //#region 布局 //控件布局 this.panelTop = new Ext.Panel({ layout: "border", region: "north", height: 115, items: [this.panelBtn, this.formEdit] }); Ext.apply(this, { items: [this.panelTop, this.gridList] }); //#endregion //绑定查询窗体 this.ParentWin = window.parent.opener; //初始化数据 this.InitData(); //绑定事件 this.gridList.on('edit', function (editor, e, eOpts) { this.gridAfterEdit(editor, e, eOpts); }, this); }, //end initUIComponents InitData: function () { this.opStatus = 'add'; var condition = ''; if (this.ParentWin) { var ret = this.ParentWin.OprationSwap(); this.opStatus = ret[0]; this.StoreList = ret[1]; this.editRecord = ret[2]; } if (this.opStatus == 'edit') condition = " BillNo='" + this.editRecord.get('BillNo') + "'"; this.LoadData(this.opStatus, condition); }, //end InitData LoadData: function (opstatus, condition) { this.serialNo = 0; this.bodyDel = []; this.opStatus = opstatus; Ext.Ajax.request({ waitMsg: '正在查询主表数据...', url: '/TruckMng/MsKfJh/GetData', params: { handle: opstatus, condition: condition }, 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; } var data = result.data; this.formEdit.getForm().reset(); this.formEdit.getForm().setValues(data); if (data.JzDate == null || data.JzDate == '') { this.setSaveBtnStatus(true); } else { this.setSaveBtnStatus(false); } } else { Ext.MessageBox.alert('请求出现错误,请重试', response.responseText); } }, scope: this }); var billno = '*'; if (this.opStatus == 'edit') { billno = this.editRecord.get('BillNo'); //alert(billno); this.formEdit.getForm().findField('BillNo').setDisabled(false); } this.storeBodyList.load({ params: { billno: billno} }); }, // end LoadDate Save: function (type) { var basicForm = this.formEdit.getForm(); if (!basicForm.isValid()) { return; } //判断表格数据是否合法 if (!validateEditorGridPanel(this.gridList)) { return; } basicForm.findField('BillNo').setDisabled(false); var data = basicForm.getValues(); basicForm.findField('BillNo').setDisabled(true); var bodydatas = []; for (var i = 0; i < this.storeBodyList.getCount(); i += 1) { var member = this.storeBodyList.getAt(i); bodydatas.push(member); } var jsonBody = ConvertRecordsToJson(bodydatas); var jsonDelBody = ConvertRecordsToJsonAll(this.bodyDel); Ext.Msg.wait('正在保存数据, 请稍侯..'); Ext.Ajax.request({ waitMsg: '正在保存数据...', url: '/TruckMng/MsKfJh/Save', scope: this, params: { opstatus: this.opStatus, data: Ext.JSON.encode(data), body: jsonBody, delbody: jsonDelBody }, callback: function (options, success, response) { if (success) { Ext.MessageBox.hide(); var jsonresult = Ext.JSON.decode(response.responseText); if (jsonresult.Success) { var returnData = jsonresult.Data; this.formEdit.getForm().setValues(returnData); if (this.opStatus == 'add') { var arrNewRecords = this.StoreList.add(returnData); this.editRecord = arrNewRecords[0]; } else if (this.opStatus == 'edit') { var editp = Ext.create('MsKfJhHead', returnData); this.editRecord.fields.each(function (field) { if (field.persist) { name = field.name; if (name != 'id') this.editRecord.set(name, editp.get(name)); } }, this); this.editRecord.commit(); } if (type == '0') { this.opStatus = 'edit'; basicForm.findField('BillNo').setDisabled(true); for (var j = 0; j < this.storeBodyList.getCount(); j += 1) { var memberbody = this.storeBodyList.getAt(j); memberbody.set("BillNo", this.editRecord.get('BillNo')); memberbody.commit(); }; } else if (type == '1') { window.close(); } else { this.LoadData('add', ''); basicForm.findField('BillNo').setDisabled(false); } } 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 }); } } }); }, //end save onAddDetailClick: function (button, event) { this.addDetail(); }, //end onAddDetailClick onDelDetailClick: function (button, event) { this.deleteDetail(); }, //onDelDetailClick gridAfterEdit: function (editor, e, eOpts) { //需要自己实现里面的事件 if (e.field == 'PluCode') { var records = DsStoreQueryBy(this.storePluCodeRef, 'PluCode', e.value); if (records.getCount() > 0) { var data = records.getAt(0).data; e.record.set('PluCode_Ref', data.PluName); e.record.set('PluName', data.PluName); e.record.set('Unit', data.Unit); e.record.set('Spec', data.Spec); e.record.set('PcNo', '*'); e.record.set('TyreType', '*'); e.record.set('Price', data.Price); } else { e.record.set('PluCode_Ref', ''); e.record.set('PluName', ''); e.record.set('Unit', ''); e.record.set('Spec', ''); e.record.set('PcNo', '*'); e.record.set('TyreType', '*'); } } else if (e.field = 'Price' || e.field == 'JhCount') { var unitPrice = e.record.data['Price']; var quantity = e.record.data['JhCount']; e.record.set('JhTotal', (unitPrice * quantity).toFixed(2)); } }, addDetail: function () { var newSerialno = DsGetNewSerialNo(this.storeBodyList, this.serialNo); this.serialNo = newSerialno; var record = Ext.create('MsKfJhBody', { BillNo: '*', SerialNo: newSerialno, PluCode: '', PluCode_Ref: '', PluName: '', Spec: '', Unit: '', Price: 0, JhCount: 0, JhTotal: 0, Remark: '', PcNo: '*', TyreType: "*", TyreType_Ref: "*" }); this.storeBodyList.add(record); var n = this.storeBodyList.getCount(); this.gridListCellEditing.startEditByPosition({ row: n - 1, column: 2 }); var selectedRecords = this.gridList.selModel.getSelection(); // alert(selectedRecords.length) }, deleteDetail: function () { this.serialNo = DsGetCurSerialNo(this.storeBodyList, this.serialNo); var selectedRecords = this.gridList.selModel.getSelection(); for (var i = 0; i < selectedRecords.length; i++) { var rec = selectedRecords[i]; if (rec.BillNo != "" || rec.BillNo != "*") //如果是新增但没有保存的数据,没有必要提交到后台 { this.bodyDel.push(rec); } alert(i); this.storeBodyList.remove(selectedRecords[i]); } // this.storeBodyList.remove(selectedRecords[i]); }, onAccountClick: function (button, event) { Ext.MessageBox.confirm('提示', '记账后数据无法修改,确认记账吗?', function (btn) { if (btn == 'yes') { this.Account(); } }, this); }, Account: function () { var basicForm = this.formEdit.getForm(); basicForm.findField('BillNo').setDisabled(false); var headdata = basicForm.getValues(); basicForm.findField('BillNo').setDisabled(true); Ext.MessageBox.wait("正在记账,请稍侯."); Ext.Ajax.request({ waitMsg: '正在记账...', scope: this, url: '/CommMng/PubSys/Account', params: { billno: headdata.BillNo, ywtype: '0'//headdata.YwType }, callback: function (options, success, response) { if (success) { var jsonresult = Ext.JSON.decode(response.responseText); if (jsonresult.Success) //成功 { var returnData = jsonresult.Data; this.formEdit.getForm().setValues(returnData); var editp = Ext.create('MsKfJhHead', returnData); this.editRecord.fields.each(function (field) { if (field.persist) { name = field.name; if (name != 'id') this.editRecord.set(name, editp.get(name)); } }, this); this.editRecord.commit(); this.setSaveBtnStatus(false); Ext.MessageBox.alert("提示", jsonresult.Message); } else //记账失败失败 { Ext.Msg.show({ title: '错误', msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK }); } } else { Ext.Msg.show({ title: '请重试', msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK }); } }, failure: function (response, options) { Ext.Msg.show({ title: '警告', msg: '服务器响应出错,请重试', icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK }); } }); //end Ext.Ajax.request }, setSaveBtnStatus: function (enable) { var btnESave = Ext.getCmp('btnESave'); var btnESaveAndClose = Ext.getCmp('btnESaveAndClose'); var btnESaveAndNew = Ext.getCmp('btnESaveAndNew'); var btnEbtnEAccount = Ext.getCmp('btnEAccount'); if (enable) { btnESave.enable(); btnESaveAndClose.enable(); btnESaveAndNew.enable(); btnEbtnEAccount.enable(); } else { btnESave.disable(); btnESaveAndClose.disable(); btnESaveAndNew.disable(); btnEbtnEAccount.disable(); } }, Print: function () { var basicForm = this.formEdit.getForm(); var billNo = basicForm.findField('BillNo').value; if (billNo == '*' || billNo == '') { Ext.Msg.show({ title: '错误', msg: '单据还没有保存,请保存后再打印', icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK }); return; } var printType = 'MSKFJH'; var sql1 = "SET LANGUAGE 'us_english' SELECT * FROM tMsKfJhHead WHERE BillNo = '" + billNo + "'"; var sql2 = "SET LANGUAGE 'us_english' SELECT * FROM tMsKfJhBody WHERE BillNo = '" + billNo + "'"; var sql3 = ""; var sql4 = ""; var sql5 = ""; var sql6 = ""; PrintComm(printType, sql1, sql2, sql3, sql4, sql5, sql6); } });