修改更新与删除脚本
1. 在visual studio 2017的“解决方案资源管理器”中，找到领域层“abp.tplms.web.mvc”项目中的wwwroot目录下的view-resources\views\instock目录中的找到index.js文件。如下图。
2. 在index.js文件中，写入相应的脚本代码。代码如下：
//-----------------------系统管理-->入库单管理----------------------//
var editindex = undefined;
var mainindex = undefined;
//刷新数据
function initable() {
$("#dginso").datagrid({
url: "/instock/list",
title: "入库单管理",
pagination: true,
pagesize: 10,
pagelist: [10, 20, 30],
fit: true,
fitcolumns: false,
loadmsg: "正在加载入库单信息...",
nowarp: false,
border: false,
idfield: "id",
sortname: "id",
sortorder: "asc",
frozencolumns: [[//冻结列
{ field: "ck", checkbox: true, align: "left", width: 50 }
]],
columns: [[
{ title: "编号", field: "id", width: 50, sortable: true },
{ title: "入库单号", field: "no", width: 100, sortable: true },
{title: "状态", field: "status", width: 50 },
{ title: '到货日期', field: 'receivetime', width: 100, align: 'center' },
{ title: "货主", field: "ownercode", width: 150, sortable: true },
{ title: "预计到货时间", field: "predeliverytime", width: 100, sortable: false },
{ title: '客户', field: 'customername', width: 120, align: 'center' },
{ title: '收货人',field: 'oper', width: 100, align: 'center' },
{ title: '审核人',field: 'checker', width: 120, align: 'center' },
{ title: '件数', field: 'packageqty', width: 100, align: 'center' },
{ title: '创建时间', field: 'creationtime', width: 100, align: 'center' }
]]
});
}
//显示送货单数据
function showcargo() {
abp.log.warn('货物信息列表日志...');
$("#dgcargo").datagrid({
url: "/cargo/list",
title: "货物管理管理",
pagination: true,
pagesize: 10,
pagelist: [10, 20, 30],
fit: true,
fitcolumns: false,
loadmsg: "正在加载货物信息...",
nowarp: false,
border: false,
idfield: "id",
sortname: "id",
sortorder: "asc",
frozencolumns: [[//冻结列
{ field: "ck", checkbox: true, align: "left", width: 50 }
]],
columns: [[
{ title: "编号", field: "id", width: 50, sortable: true },
{ title: "供应商", field: "supplierid", width: 80, sortable: true },
{ title: "hscode", field: "hscode", width: 100, sortable: true },
{ title: "货物代码", field: "cargocode", width: 100, sortable: true },
{ title: "货物名称", field: "cargoname", width: 80, sortable: false },
{ title: "规格型号", field: "spcf", width: 100, sortable: false },
{ title: "产销国", field: "country", width: 80, sortable: false },
{ title: "计量单位", field: "unit", width: 100, sortable: false },
{ title: "包装", field: "package", width: 100, sortable: false },
{ title: "单价", field: "price", width: 100, sortable: false },
{ title: "币制", field: "curr", width: 80, sortable: false },
{
title: "长宽高", field: "length", width: 100, sortable: false, formatter: function (value, row, index) {
return row.length + '*' + row.width + '*' + row.height;
}
},
{ title: "体积", field: "vol", width: 80, sortable: false },
{ title: "备注", field: "remark", width: 80, sortable: false },
{ title: '创建时间', field: 'creationtime', width: 100, align: 'center' }
]]
});
abp.log.warn('3货物信息列表日志...');
}
function showcargoinfo() {
$("#divimportcargo").dialog({
closed: false,
title: "选择货物信息",
modal: true,
width: 820,
height: 550,
collapsible: true,
minimizable: true,
maximizable: true,
resizable: true
});
showcargo();
$("#dgcargo").datagrid("clearchecked");
$("#dgcargo").datagrid("clearselections");
}
function reloaded() { //reload
$("#reload").click(function () {
//
$('#dginso').datagrid('reload');
});}
//修改点击按钮事件
function updinsoinfo() {
$("#edit").click(function () {
//判断选择的中
var row = $("#dginso").datagrid('getselected');
if (row) {
$.messager.confirm('编辑', '您想要编辑吗？', function (r) {
if (r) {
//先绑定
showino(row);
//打开对话框编辑
$("#divaddupdino").dialog({
closed: false,
title: "修改入库单",
modal: true,
width: 820,
height: 550,
collapsible: true,
minimizable: true,
maximizable: true,
resizable: true,
});
defaulttab();
showdetail(row.no);
}
});
setenabled(row.status);
} else {
$.messager.alert('提示', ' 请选择要编辑的行！', 'warning');
}
});
}
//删除入库单
function deleteinso() {
$("#del").click(function () {
var rows = $("#dginso").datagrid("getselections");
if (rows.length > 0) {
$.messager.confirm("提示", "确定要删除吗?", function (res) {
if (res) {
var codes = []; //重要不是{}
for (var i = 0; i < rows.length; i++) {
codes.push(rows[i].id);
}
$.post("/instock/delete", { "ids": codes.join(',') }, function (data) {
if (data == "ok") {
$.messager.alert("提示", "删除成功！");
$("#dginso").datagrid("clearchecked");
$("#dginso").datagrid("clearselections");
$("#dginso").datagrid("load", {});
}
else if (data == "no") {
$.messager.alert("提示", "删除失败！");
return;
}
});
}
});
}
})
}
//清空文本框
function clearall() {
$("#divaddupdino input").each(function () {
$(this).val("");
});
$("#predeliverytimeupdate").val(getnowformatdate());
$("#statusupdate").val("0");
$("#nwtupdate").val("0");
$("#gwtupdate").val("0");
$("#packageqtyupdate").val("0");
}
function getno() {
$.get(abp.apppath + "api/services/app/instockorder/getno", function (data) {
$("#updno").val(data);
});
}
//获取当前时间，格式yyyy-mm-dd
function getnowformatdate() {
var date = new date();
var seperator1 = "-";
var year = date.getfullyear();
var month = date.getmonth() + 1;
var strdate = date.getdate();
if (month >= 1 && month <= 9) {
month = "0" + month;
}
if (strdate >= 0 && strdate <= 9) {
strdate = "0" + strdate;
}
var currentdate = year + seperator1 + month + seperator1 + strdate;
return currentdate;
}
//将表单数据转为json
function form2json(id) {
var arr = $("#" + id).serializearray()
var jsonstr = "";
jsonstr += '{';
for (var i = 0; i < arr.length; i++) {
jsonstr += '"' + arr[i].name + '":"' + arr[i].value + '",'
}
jsonstr = jsonstr.substring(0, (jsonstr.length - 1));
jsonstr += '}'
var json = json.parse(jsonstr)
return json
}
function setenabled(status) {
//var status = $("#statusupdate").val()
if (status == "提交") {
$("#btnsave").prop('disabled', true);
}
else {
$("#btnsave").removeattr("disabled");
}
}
function defaulttab() {
//默认显示第一个tab
$('#box').tabs('select', "入库单");
}
//弹出 导入送货单的的对话框
function showinsodialog() {
$("#add").click(function () {
$.messager.confirm('编辑', '您想要创建入库单吗？', function (r) {
if (r) {
//打开对话框编辑
$("#divaddupdino").dialog({
closed: false,
title: "新增入库单",
modal: true,
width: 820,
height: 550,
collapsible: true,
minimizable: true,
maximizable: true,
resizable: true,
});
}
defaulttab();
getno();
clearall();
showdetail("");
});
});
$("#btnsave").click(function () {
//保存
var id = $("#idupdate").val();
if (id == "" || id == undefined) {
//验证
$.messager.confirm('确认', '您确认要保存吗？', function (r) {
if (r) {
var postdata = getino();
if (postdata.no == "" || postdata.customercode == "" || postdata.customername=="" || postdata.ownername=="") {
$.messager.alert('提示', ' 请填写相关必填项！', 'warning');
return;
}
$.post("/instock/add", postdata, function (data) {
if (data == "ok") {
// $("#divaddupddo").dialog("close");
$.messager.alert("提示", "保存成功！");
initable();
collapserows();
}
else if (data == "no") {
$.messager.alert("提示", "保存失败！");
return;
}
});
}
})
}
else {
savedetail();
initable();
collapserows();
}
});
}
//添加明细
function showdetail(no) {
var lastindex;
$("#dginod").datagrid({
url: "/instock/getdetail?no=" + no,
title: "入库单明细",
pagination: false,
fit: true,
fitcolumns: false,
loadmsg: "正在加载入库单明细信息...",
toolbar: [
{ text: '添加明细', iconcls: 'icon-add', handler: function () { showcargoinfo(); } },
{ text: '添加库位', iconcls: 'icon-edit', handler: function () { subgridaddrow(); } },
{ text: '删除', iconcls: 'icon-remove', handler: function () { deviceinfodeleteclick(); } },
'-'
],
nowarp: false,
border: false,
idfield: "id",
sortname: "id",
sortorder: "asc",
singleselect: true,
iconcls: 'icon-edit',
columns: [[
{ title: "编号", field: "seqno", width: 50, sortable: true },
{ title: "入库单号", field: "instockno", width: 100, sortable: true },
{ title: "hscode", field: "hscode", width: 80, sortable: false },
{ title: "货物代码", field: "cargocode", width: 100, sortable: true },
{ title: "货物名称", field: "cargoname", width: 160, sortable: false },
{ title: "规格型号", field: "spcf", width: 80, sortable: false },
{
title: "数量", field: "qty", width: 100, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 4
}
}
},
{
title: "长", field: "length", width: 70, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 2
}
}
},
{ title: "宽", field: "width", width: 70, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 2
}
}
},
{
title: "高", field: "height", width: 70, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 2
}
}
},
{ title: "产销国", field: "country", width: 70, align: 'center' },
{
title: "单价", field: "price", width: 100, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 2
}
}
},
{
title: "总价", field: "totalamt", width: 100, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 2
}
}
},
{ title: "包装", field: "package", width: 70, align: 'center' },
{ title: "计量单位", field: "unit", width: 70, align: 'center' },
{
title: "总体积", field: "vol", width: 70, align: 'center', editor: {
type: 'numberbox', options: {
required: true, min: 0, precision: 4
}
}
},
{ title: "品牌", field: "brand", width: 70, align: 'center' }
]],
onclickrow: function (index, rowdata) {
if (mainindex!=undefined) {
$('#dginod').datagrid('collapserow', mainindex);
}
if (lastindex != index) {
$('#dginod').datagrid('endedit', lastindex);
editrow(index);
}
lastindex = index;
},
onbeginedit: function (rowindex, rowdata) {
setediting(rowindex);
}
});
}
//计算报价小计
function setediting(rowindex) {
var editors = $('#dginod').datagrid('geteditors', rowindex);
var priceeditor = editors[4];
var qtyeditor = editors[0];
var lengtheditor = editors[1];
var widtheditor = editors[2];
var heighteditor = editors[3];
var totalvoleditor = editors[6];
var totalamteditor = editors[5];
priceeditor.target.numberbox({
onchange: function () { calculate();}
});
qtyeditor.target.numberbox({
onchange: function () {
calculate();
calculatevol();
}
});
lengtheditor.target.numberbox({
onchange: function () { calculatevol(); }
});
widtheditor.target.numberbox({
onchange: function () { calculatevol(); }
});
heighteditor.target.numberbox({
onchange: function () { calculatevol(); }
});
function calculate() {
var cost = (priceeditor.target.val()) * (qtyeditor.target.val());
console.log(cost);
totalamteditor.target.numberbox("setvalue", cost);
}
function calculatevol() {
var vol = (lengtheditor.target.val() / 100.0) * (widtheditor.target.val() / 100.0)
* (heighteditor.target.val() / 100.0)* (qtyeditor.target.val());
console.log(vol);
totalvoleditor.target.numberbox("setvalue", vol);
}
}
function editrow(index) {
$('#dginod').datagrid('selectrow', index)
.datagrid('beginedit', index);
}
function endedit() {
var rows = $('#dginod').datagrid('getrows');
if (rows==undefined) {
return;
}
for (var i = 0; i < rows.length; i++) {
$('#dginod').datagrid('endedit', i);
}
}
//设置入库单明细数据
function setgriddetail(effectrow) {
if ($('#dginod').datagrid('getchanges').length) {
var inserted = $('#dginod').datagrid('getchanges', "inserted");
var deleted = $('#dginod').datagrid('getchanges', "deleted");
var updated = $('#dginod').datagrid('getchanges', "updated");
if (inserted.length) {
effectrow["inserted"] = json.stringify(inserted);
}
if (deleted.length) {
effectrow["deleted"] = json.stringify(deleted);
}
if (updated.length) {
effectrow["updated"] = json.stringify(updated);
}
}
return effectrow;
}
function savedetail() {
endedit();
$.messager.confirm('确认', '您确认要修改吗？', function (r) {
var effectrow = new object();
var postdata = getino();
if (postdata.id) {
effectrow["postdata"] = json.stringify(postdata);
}
effectrow = setgriddetail(effectrow);
$.post("/instock/update", effectrow, function (data) {
if (data.success) {
$.messager.alert("提示", data.result);
$('#dginod').datagrid('acceptchanges');
}
else {
$.messager.alert("提示", data.result);
return;
}
}, "json")
;
})
}
function init() {
$("#predeliverytimeupdate").val(getnowformatdate());
$("#creationtimeupdate").val(getnowformatdate());
$("#btncancle").click(function () {
$("#divaddupdino").dialog("close");
$('#dginso').datagrid('reload');
});
$("#btncancledo").click(function () {
$("#divimportcargo").dialog("close");
$('#dginso').datagrid('reload');
});
$("#btnimportdo").click(function () {
//保存
var rows = $('#dgcargo').datagrid('getselections');
if (rows.length > 0) {
//验证
$.messager.confirm('确认', '您确认要保存所选择的货物信息吗？', function (r) {
if (r) {
var obj_no = $("#updno").val();
var ids = [];//重要不是{}
for (var i = 0; i < rows.length; i++) {
ids.push(rows[i].id);
}
var postdata = {
"ids": ids.join(','),
"no": obj_no
};
$.post("/instock/importcargo", postdata, function (data) {
if (data == "ok") {
$.messager.alert("提示", "保存货物信息成功！");
showdetail(obj_no);
}
else if (data == "no") {
$.messager.alert("提示", "保存货物信息失败！");
return;
}
});
}
})
}
});
$("#btnsubmit").click(function () {
//保存
var id = $("#idupdate").val();
if (id == "" || id == undefined) {
$.messager.alert("提示", "入库单没有保存，请先保存！");
return;
}
//验证
$.messager.confirm('确认', '您确认要提交入库单吗？', function (r) {
if (r) {
var postdata = {
"id": id
};
$.post("/instockmgr/submit", postdata, function (data) {
if (data == "ok") {
$.messager.alert("提示", "入库单已经提交成功！");
$("#statusupdate").val("提交");
setenabled("提交");
}
else if (data == "no") {
$.messager.alert("提示", "入库单提交失败！");
return;
}
});
}
})
});
}
function getino() {
var postdata = {
"no": $("#updno").val(),
"deliveryno": "",
"predeliverytime": $("#predeliverytimeupdate").val(),
"customercode": $("#customercodeupdate").val(),
"ownername": $("#ownernameupdate").val(),
"ownercode": $("#ownercodeupdate").val(),
"customername": $("#customernameupdate").val(),
"creationtime": $("#creationtimeupdate").val(),
"checktime": $("#checktimeupdate").val(),
"warehousetype": $("#warehousetypeupdate").val(),
"warehouseno": $("#warehousenoupdate").val(),
"oper": $("#operupdate").val(),
"receiver": $("#receiverupdate").val(),
"nwt": $("#nwtupdate").val(),
"remark": $("#remarkupdate").val(),
"receivetime": $("#receivetimeupdate").val(),
"status": $("#statusupdate").val(),
"gwt": $("#gwtupdate").val(),
"checker": $("#checkerupdate").val(),
"packageqty": $("packageqtyupdate").val(),
"lastupdatetime": "",
"lastoper":""
};
var id = $("#idupdate").val();
if (!(id=="" || id==undefined)) {
postdata.id = id;
}
return postdata;
}
function showino(row)
{
$("#idupdate").val(row.id);
$("#updno").val(row.no);
$("#predeliverytimeupdate").val(row.predeliverytime);
$("#customercodeupdate").val(row.customercode);
$("#customernameupdate").val(row.customername);
$("#ownercodeupdate").val(row.ownercode);
$("#ownernameupdate").val(row.ownername);
$("#creationtimeupdate").val(row.creationtime);
$("#checktimeupdate").val(row.checktime);
$("#warehousetypeupdate").val(row.warehousetype);
$("#warehousenoupdate").val(row.warehouseno);
$("#operupdate").val(row.oper);
$("#receiverupdate").val(row.receiver);
$("#nwtupdate").val(row.nwt);
$("#remarkupdate").val(row.remark);
$("#receivetimeupdate").val(row.receivetime);
$("#statusupdate").val(row.status);
$("#gwtupdate").val(row.gwt);
$("#checkerupdate").val(row.checker);
}
//------------------------系统管理-->入库单管理结束--------------------------//
3. 在visual studio 2017的“解决方案资源管理器”中，找到“abp.tplms.web.mvc”项目中的views目录下的instock目录中的index.cshtml文件。双击打开此文件，把以下代码删除或注释。
<div id="dg-detail-button"> <a href="#" id="add" class="easyui-linkbutton" data-options="iconcls:'icon-add'" style="width:100px; " onclick="showcargoinfo()">添加明细</a> <a href="#" id="addloc" class="easyui-linkbutton" data-options="iconcls:'icon-add'" style="width:100px; " onclick="subgridaddrow()">添加库位</a> <a href="#" id="del" class="easyui-linkbutton" data-options="iconcls:'icon-remove'" style="width:100px; ">删除</a> </div>
4. 修改代码，如下图。
<td>创建时间：</td> <td> <input type="text" id="creationtimeupdate" name="ucreationtime" class="form-control input-sm" /> </td>
黄山市民网：https://www.huangshanshimin.com/
