JS grid add delete save

<script type="text/javascript">
var $ = function(id){
return document.getElementById(id);
}

//全选
function checkAll(target) {
var checkeds = document.getElementsByName("b_id");
for (var i = 0; i < checkeds.length; i++) {
checkeds[i].checked = target.checked;
}
}

//刷新行号
function refreshRowNo() {
var tbody = $("tbody");
for (var i = 0; i < tbody.rows.length; i++) {
tbody.rows[i].cells[0].innerHTML = i + 1;
}
}

//添加行
function AddRow() {
var tbody = $("tbody");
var row = tbody.insertRow(tbody.rows.length);
row.insertCell(row.cells.length);
row.insertCell(row.cells.length).innerHTML = '<input type="checkbox" name="b_id" />';
row.insertCell(row.cells.length).innerHTML = '<input type="text" name="name" />';
row.insertCell(row.cells.length).innerHTML = '<input type="text" name="number" />';
row.insertCell(row.cells.length).innerHTML = '<input type="text" name="price" />';
row.insertCell(row.cells.length).innerHTML = '<input type="text" name="sum" />';

refreshRowNo();
}

//删除行
function DelRow() {
var checkeds = document.getElementsByName("b_id");
var ischeck = false;
for (var i = checkeds.length - 1; i >= 0; i--) {
if (checkeds[i].checked) {
ischeck = true;
break;
}
}
if (ischeck) {
if (confirm("确定删除选中行?")) {
for (var i = checkeds.length - 1; i >= 0; i--) {
if (checkeds[i].checked) {
var index = checkeds[i].parentNode.parentNode.rowIndex;
$("tbody").deleteRow(index - 1);
}
}
refreshRowNo();
}
} else {
alert("请选中需要删除的行!");
}
}

//保存
function Save() {
var detail = [],
tbody = $("tbody");
for (var i = 0; i < tbody.rows.length; i++) {
var name = tbody.rows[i].cells[2].childNodes[0].value;
var number = tbody.rows[i].cells[3].childNodes[0].value;
var price = tbody.rows[i].cells[4].childNodes[0].value;
var sum = tbody.rows[i].cells[5].childNodes[0].value;
var item = name + "^" + number + "^" + price + "^" + sum;
detail.push(item);
}
var detailstr = detail.join("|");
$("detail").value = detailstr;
$("myform").submit();
}

</script>

<form name="myform" action="AddOrder.aspx" method="post">
<input type="hidden" id="detail" name="detail" />
<ul>
<li>采购单编号:<input type="text" id="CGDBH" name="CGDBH" /></li>
<li>
供应商名称:<input type="text" id="GYSMC" name="GYSMC" />
<input type="button" οnclick="AddRow()" value="增加一行" />
<input type="button" οnclick="DelRow()" value="删除" />
<input type="button" οnclick="Save()" value="保存" />
</li>
</ul>
<table cellpadding="1" cellspacing="2">
<tr>
<th style="width:60px">序号</th>
<th style="width:20px"><input type="checkbox" οnclick="checkAll(this)" /></th>
<th style="width:120px">名称</th>
<th style="width:120px">数量</th>
<th style="width:120px">单价</th>
<th style="width:120px">总金额</th>
</tr>
<tbody id="tbody">
<tr>
<td>1</td>
<td><input type="checkbox" name="b_id" /></td>
<td><input type="text" name="name" /></td>
<td><input type="text" name="number" /></td>
<td><input type="text" name="price" /></td>
<td><input type="text" name="sum" /></td>
</tr>
</tbody>
</table>
</form>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
import tkinter as tk from openpyxl import load_workbook from tkinter import messagebox # 读取Excel表格数据 wb = load_workbook(filename=r'C:\Users\bing3_chen\Desktop\1.xlsx') ws = wb['總表'] # 创建GUI窗口 window = tk.Tk() window.title('物料进出库管理') window.geometry('400x200') # 进货函数 def add_inventory(): # 获取物料名称和数量 name = name_entry.get() quantity = int(quantity_entry.get()) # 查找相同名称的数据并进行加操作 found = False for row in ws.iter_rows(min_row=2, values_only=True): if row[0] == name: row[1] += quantity found = True break if not found: ws.append([name, quantity]) # 将修改后的数据写回Excel表格 wb.save(filename=r'C:\Users\bing3_chen\Desktop\1.xlsx') # 清空文本框 name_entry.delete(0, tk.END) quantity_entry.delete(0, tk.END) # 出货函数 def remove_inventory(): # 获取物料名称和数量 name = name_entry.get() quantity = int(quantity_entry.get()) # 查找相同名称的数据并进行减操作 found = False for row in ws.iter_rows(min_row=2, values_only=True): if row[0] == name: if row[1] >= quantity: row[1] -= quantity found = True else: messagebox.showerror('Error', '物料不足!') return if not found: messagebox.showerror('Error', '物料不存在!') return # 将修改后的数据写回Excel表格 wb.save(filename=r'C:\Users\bing3_chen\Desktop\1.xlsx') # 清空文本框 name_entry.delete(0, tk.END) quantity_entry.delete(0, tk.END) # 添加控件 tk.Label(window, text='物料名称:').grid(row=0, column=0) name_entry = tk.Entry(window) name_entry.grid(row=0, column=1) tk.Label(window, text='物料数量:').grid(row=1, column=0) quantity_entry = tk.Entry(window) quantity_entry.grid(row=1, column=1) tk.Button(window, text='进货', command=add_inventory).grid(row=2, column=0) tk.Button(window, text='出货', command=remove_inventory).grid(row=2, column=1) window.mainloop()
06-06

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值