Files
2-BeiqiFutian-MES_Manage/webpage/SqlCommonDemo.htm
2026-05-29 13:44:19 +08:00

403 lines
18 KiB
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<link rel="stylesheet" type="text/css" href="../css/upload.css" />
<link href="../js/jquery.uploadify-v2.1.0/uploadify.css" rel="stylesheet" type="text/css" />
<script src="../js/jquery-1.4.1.js" type="text/javascript"></script>
<script src="../js/jquery-easyui-1.3.4/jquery.easyui.min.js" type="text/javascript"></script>
<script src="../js/jquery.uploadify-v2.1.0/swfobject.js" type="text/javascript"></script>
<script src="../js/jquery.uploadify-v2.1.0/jquery.uploadify.v2.1.0.js" type="text/javascript"></script>
<link href="../js/jquery-easyui-1.3.4/themes/default/easyui.css" rel="stylesheet"
type="text/css" />
<link href="../js/jquery-easyui-1.3.4/themes/icon.css" rel="stylesheet" type="text/css" />
<script src="../js/jquery-easyui-1.3.4/locale/easyui-lang-zh_CN.js" type="text/javascript"></script>
<link href="../css/sexybuttons.css" rel="stylesheet" type="text/css" />
<link href="../css/icon.css" rel="stylesheet" type="text/css" />
<link href="../css/common.css" rel="stylesheet" type="text/css" />
<script src="../js/imageupload.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
Init_role();
InitGrid();
});
function InitGrid() {
datagrid_collector = $('#datagrid_collector').datagrid({
url: '../submit/UserManage.ashx?type=Select',
title: '用户信息',
pagination: true, //显示分页工具条
pageSize: 10,
pageList: [10, 20, 30, 40], //,checkbox:true fit: true,
sortName: 'JSON_用户编号', //按哪个字段排序,将把这个提交给服务器
sortOrder: 'desc', //升序降序
fitColumns: true, //当横向数据多时是否会出现挤压。即是否会出现横向滚动条。如果想冻结列就得把这个属性设为false,如果为true会自动对齐数据列宽。当列多时就设为false。
nowarp: false, //当一个表格中数据过多时,是否会出现
idField: 'JSON_用户编号',
columns: [[
{ title: '用户编号', field: 'JSON_用户编号', width: 120, align: 'center', checkbox: true },
{ title: '用户名', field: 'JSON_用户名', width: 200, align: 'center' },
{ title: '密码', field: 'JSON_密码', width: 200, align: 'center' },
{ title: '用户姓名', field: 'JSON_用户姓名', width: 120, align: 'center' },
{ title: '员工编号', field: 'JSON_员工编号', width: 120, align: 'center' },
{ title: '班组', field: 'JSON_班组', width: 120, align: 'center' },
{ title: '工作岗位', field: 'JSON_工作岗位', width: 120, align: 'center' },
{ title: '联系电话', field: 'JSON_联系电话', width: 300, align: 'center' },
{ title: '角色编号', field: 'JSON_角色编号', width: 300, align: 'center' },
{ title: '角色名称', field: 'JSON_角色名称', width: 300, align: 'center' }
]],
onClickRow: function (rowIndex, rowData) {
userNum = rowData["JSON_用户编号"];
showpic(userNum);
},
toolbar: '#tab_toolbar'
});
}
//提交dialog
function submitCollectorForm() {
var Falg = $('#Hidden_editflag').val();
var url1;
var rows = $('#datagrid_collector').datagrid('getSelections');
if (Falg == 2) {
url1 = "../submit/UserManage.ashx?type=editCollector&selectId=" + rows[0].JSON_用户编号 + "&UserName=" + $('#UserName').val() + "&UserNum=" + $('#UserNum').val() + "&password=" + $('#password').val() + "&workernum=" + $('#workernum').val() + "&groupnum=" + $('#groupnum').val() + "&position=" + $('#position').val() + "&phoneNum=" + $('#phoneNum').val() + "&role=" + $('#role').combobox('getValue');
$.ajax({
type: "POST",
url: url1,
success: function (r) {
r = eval("(" + r + ")"); //注意要转化为对象
if (r.result == "1") {
$.messager.alert('提示信息', '数据处理成功');
$('#edit').dialog('close');
InitGrid();
}
else {
$.messager.alert('Warning', '失败!');
}
}
})
}
else {
url1 = "../submit/UserManage.ashx?type=addCollector&UserName=" + $('#UserName').val() + "&UserNum=" + $('#UserNum').val() + "&password=" + $('#password').val() + "&workernum=" + $('#workernum').val() + "&groupnum=" + $('#groupnum').val() + "&position=" + $('#position').val() + "&phoneNum=" + $('#phoneNum').val() + "&role=" + $('#role').combobox('getValue');
$.ajax({
type: "POST",
url: url1,
success: function (r) {
r = eval("(" + r + ")"); //注意要转化为对象
if (r.result == "1") {
$.messager.alert('提示信息', '数据处理成功');
$('#edit').dialog('close');
InitGrid();
}
else {
$.messager.alert('Warning', '失败!');
}
}
})
}
}
function OpenWin() {
$('#Hidden_editflag').val(1);
$("#edit").dialog("open"); //打开编辑dialog
}
//打开编辑窗口
function editdialog() {
$('#Hidden_editflag').val(2);
var rows = $('#datagrid_collector').datagrid('getSelections');
if (rows.length == 1)//如果选择为1一个才合法不可以编辑2个。
{
$("#edit").dialog("open");
$('#UserName').val(rows[0].JSON_用户姓名);
$('#UserNum').val(rows[0].JSON_用户名);
$('#password').val(rows[0].JSON_密码);
$('#workernum').val(rows[0].JSON_员工编号);
$('#groupnum').val(rows[0].JSON_班组);
$('#position').val(rows[0].JSON_工作岗位);
$('#phoneNum').val(rows[0].JSON_联系电话);
var num = rows[0].JSON_角色编号;
$('#role').combobox('setValue', num);
}
else if (rows.length >= 2) {
$.messager.alert('提示', '不能多选', 'warning');
}
else {
$.messager.alert('提示', '请选择您要修改的项目', 'warning');
}
}
//删除
function deleteCollector() {
var rows = $('#datagrid_collector').datagrid('getSelections'); //首先获得你所选择的行。
if (rows.length > 0) {//最少选择一行
$.messager.confirm('请确认', '您确定要删除你所选择的项目吗?', function (b) {
if (b) {//这里面b为如果你在前台选择“是”的话就为true
var ids = [];
for (var i = 0; i < rows.length; i++) {
ids.push(rows[i].JSON_用户编号); //这个地方跟你id值的 field内的内容一样。 将这一行的id值给ids数组了。后台接收的到是[1,2,3]这样一个数组,后台得写一个分割函数。
}
$.ajax({
url: '../submit/UserManage.ashx?type=CollectorDelete',
data: {
ids: ids.join(',')//这个方法给你返回去的是一个字符串。最后你写删除的存储过程语句的时候可以where可以用in12这种方法实现
},
dataType: 'json',
success: function (data) {
$('#datagrid_collector').datagrid('load'); //删除完刷新一下页面。因为这里不需要提交参数,所以得需要
$('#datagrid_collector').datagrid('unselectAll'); //取消选中,每次执行完操作,都应该注意:每次弄完都应该注意这个。
data = eval("(" + data + ")"); //注意要转化为对象
if (data.result == "1") {
$.messager.alert('提示信息', '删除成功');
}
else {
$.messager.alert('Warning', '删除失败!');
}
}
})
}
});
}
else {
$.messager.alert('提示', '请选择要删除的项目', 'warning'); //不能一条都不选
}
}
//取消操作
function removeEidt() {
$('#datagrid_collector').datagrid('unselectAll');
}
//清空
function clearCollectorForm() {
$('#form_edit').find('input').val('');
}
//初始化角色
function Init_role() {
$('#role').combobox({
url: '../submit/UserManage.ashx?type=Selectrole',
valueField: '角色编号',
textField: '角色名称',
mode: 'remote', //这个地方别忘了,这个地方决定你是否可以加载本地数据
required: true,
panelHeight: 80
});
}
//增加图片
function pic_add() {
var rows = $('#datagrid_collector').datagrid('getSelections'); //首先获得你所选择的行。
if (rows.length == 1) {//只可以选择一行
var userNum = rows[0].JSON_用户编号;
$.ajax({
type: "POST",
url: '../submit/UserManage.ashx?type=pic_add&filename=' + filename + "&UserNum=" + userNum,
success: function (r) {
r = eval("(" + r + ")"); //注意要转化为对象
if (r.result == "1") {
$.messager.alert('提示信息', '数据处理成功');
}
else {
$.messager.alert('提示信息', '失败');
}
}
})
}
else {
$.messager.alert('提示', '请选择要上传照片的员工', 'warning'); //不能一条都不选
}
}
//更新数据库后显示数据库中的图片
function showpic(userNum) {
$.ajax({
type: "POST",
url: '../submit/UserManage.ashx?type=showpic&filename=' + filename + "&UserNum=" + userNum,
success: function (r) {
if (r != "") {
filename = r;
$("#picturebox_img").attr("src", "UploadFile/" + filename);
}
else {
$("#picturebox_img").attr("src", "../images/noPhoto.jpg");
}
}
})
}
</script>
<title></title>
</head>
<body style="margin: 2px;" class="easyui-layout">
<div style="position: relative;">
<div class="full_dark" id="full_dark" style="display: none">
</div>
<div style="position: relative;">
<div class="imgLoad" style="display: none">
<div id="fileQueue">
</div>
<input type="file" name="uploadify" id="uploadify" />
<p>
<a href="javascript:$('#uploadify').uploadifyUpload()" class="btn1">上传</a><span class="null1">
</span><a href="#" onclick="colseWindow()" class="btn2">取消</a>
</p>
</div>
</div>
</div>
<div region="north" style="height: 300px;">
<table id="datagrid_collector" border="false">
</table>
</div>
<div region="center" id="div_tab_assembly_img" style="background: #eee;"
align="center">
<table>
<tr>
<td height="5px">
</td></tr>
<tr>
<td align="center" colspan="2">
<div style="border: 1px solid #000000; height: 200px; width:150px;">
<img id="picturebox_img" src="../images/noPhoto.jpg" style="height: 100%;
width: 100%" />
</div>
</td></tr>
<tr>
<td align="right">
<a id="A1" href="#" plain="true" class="easyui-linkbutton" icon="icon-edit" title="修改"
onclick="openWindow()">上传</a>
</td>
<td align="left">
<a id="add" href="#" plain="true" class="easyui-linkbutton" icon="icon-add" title="增加"
onclick="pic_add()">确定</a>
</td>
</tr></table>
</div>
<div id="tab_toolbar">
<table>
<tr>
<td>
<a id="a_add" href="#" plain="true" class="easyui-linkbutton" icon="icon-add" title="添加"
onclick="OpenWin()">添加</a>
</td>
<td>
<a id="a_edit" href="#" plain="true" class="easyui-linkbutton" icon="icon-edit" title="编辑"
onclick="editdialog()">编辑</a>
</td>
<td>
<a id="a_delete" href="#" plain="true" class="easyui-linkbutton" icon="icon-cancel"
title="删除" onclick="deleteCollector()">删除</a>
</td>
<td>
<a id="a_removeEdit" href="#" plain="true" class="easyui-linkbutton" icon="icon-undo"
onclick="removeEidt()">取消</a>
</td>
</tr>
</table>
</div>
<div id="edit" class="easyui-dialog" title="添加用户" style="width: 350px; height: 300px;"
modal="true" closed="true">
<form id="form_edit" name="form_edit" method="post">
<table class="table_edit">
<tr>
<td>
用户姓名:
</td>
<td>
<input id="UserName" name="UserName" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
用户名:
</td>
<td>
<input id="UserNum" name="UserNum" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
密码:
</td>
<td>
<input id="password" name="password" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
角色:
</td>
<td>
<input id="role" name="role" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
员工编号:
</td>
<td>
<input id="workernum" name="workernum" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
班组:
</td>
<td>
<input id="groupnum" name="groupnum" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
工作岗位:
</td>
<td>
<input id="position" name="position" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
联系电话:
</td>
<td>
<input id="phoneNum" name="phoneNum" type="text" class="easyui-validatebox" required="true" />
</td>
</tr>
<tr>
<td>
<a href="javascript:void(0);" class="easyui-linkbutton" iconcls="icon-save" onclick="submitCollectorForm()">
提交</a>
</td>
<td>
<a href="javascript:void(0);" class="easyui-linkbutton" iconcls="icon-redo" onclick="clearCollectorForm()">
清空</a>
</td>
</tr>
</table>
</form>
</div>
<div>
<input id="Hidden_editflag" name="Hidden_editflag" type="hidden" />
</div>
</body>
</html>