北京络捷斯特第三方物流信息系统技术解析(七) 订单查询
2.2 订单查询
订单查询包括有“订单跟踪“和“订单查询”两块,是对前面订单录入的订单进行查询和跟踪。
订单查询效果截图:
2.2.1 订单跟踪
该模块的主要功能是对后面的作业后的订单进行一个跟踪操作。可以对这些订单进行删除等操作。
订单跟踪功能实现:
第一步:数据库
1、表和关系
表1:订单信息表(PW_OrdersInformationTable)
列名 | 数据类型 | 主键/外键 | 说明 |
OrdersInformationID | int | 主键 | 订单信息ID |
OrdersMark | nchar(50) |
| 订单号 |
ClientID | int | 外键 | 客户ID |
ClientInstructMark | nchar(50) |
| 客户指令号 |
PurchaseOrdersNumber | nchar(50) |
| 采购订单号 |
OrdersTypeID | int | 外键 | 订单类型ID |
UrgencyDegreeID | int | 外键 | 紧急程度ID |
OrdersSourceID | int | 外键 | 订单来源ID |
PledgeBankID | int | 外键 | 质押银行ID |
Note | nchar(50) |
| 备注 |
表2:客户表(SYS_ClientTable)
列名 | 数据类型 | 主键/外键 | 说明 |
ClientID | int | 主键 | 客户ID |
ClientAccounts | nchar(50) |
| 客户帐号 |
ClientCode | nchar(50) |
| 客户码 |
ClientUnitName | nchar(50) |
| 客户单位名称 |
ClientManager | nchar(50) |
| 客户经理 |
ClientManagerPhone | nchar(50) |
| 客户经理电话 |
Linkman | nchar(50) |
| 联系人 |
LinkmanPhone | nchar(50) |
| 联系人电话 |
ClientPostcode | nchar(50) |
| 客户邮编 |
ClientFax | nchar(50) |
| 客户传真 |
ClientAddress | nchar(50) |
| 客户地址 |
ClientCompanyID | int | 外键 | 客户公司ID |
ClientRank | int | 外键 | 客户级别ID |
第二步:控制器(Controllers)
2.2(图3)
2.2(图4)
Contrlles(控制器)代码:
#region 查询订单信息
/// <summary>
/// 查询出入库、出库、加工的基本信息,显示在同一界面
/// </summary>
/// <returns>Json</returns>
public ActionResult SelectOrdersInformation()
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersInformationTable //linq多表之间的连接关系
join tbClient in myDDCX.SYS_ClientTable on tbOrders.ClientID equals tbClient.ClientID
join tbOrdersType in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbExecuteState in myDDCX.SYS_AttributeDetailedTable on tbOrders.ExecuteStateID equals tbExecuteState.AttributeDetailedID
join tbUrgencyDegree in myDDCX.SYS_AttributeDetailedTable on tbOrders.UrgencyDegreeID equals tbUrgencyDegree.AttributeDetailedID
join tbOrdersSource in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersSourceID equals tbOrdersSource.AttributeDetailedID
join tbState in myDDCX.SYS_AttributeDetailedTable on tbOrders.StateID equals tbState.AttributeDetailedID
select new
{
OrdersInformationID = tbOrders.OrdersInformationID,
OrdersMark = tbOrders.OrdersMark,
ClientID = tbOrders.ClientID,
ClientCode = tbClient.ClientCode,
ClientInstructMark = tbOrders.ClientInstructMark,
PurchaseOrdersNumber = tbOrders.PurchaseOrdersNumber,
OrdersTypeID = tbOrders.OrdersTypeID,
OrdersType = tbOrdersType.AttributeDetailedName,
UrgencyDegreeID = tbOrders.UrgencyDegreeID,
UrgencyDegree = tbUrgencyDegree.AttributeDetailedName,
OrdersSourceID = tbOrders.OrdersSourceID,
OrdersSource = tbOrdersSource.AttributeDetailedName,
OrderTime = tbOrders.OrderTime,
StateID = tbOrders.StateID,
State = tbState.AttributeDetailedName,
ExecuteStateID = tbOrders.ExecuteStateID,
ExecuteState = tbExecuteState.AttributeDetailedName,
OrdersPriorLevel = tbOrders.OrdersPriorLevel,
Note = tbOrders.Note,
EntryTime = tbOrders.EntryTime
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.EntryTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("RiQi", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 不定条件查询订单信息
/// <summary>
/// 接收界面层参数,多条件查询订单信息,三个参数不同组合都可以查询出数据
/// </summary>
/// <param name="DingDanHao">订单号</param>
/// <param name="KeHuMa">客户码</param>
/// <param name="ID">执行状态ID</param>
/// <returns>Json</returns>
public ActionResult MistinessSelectOrdersInformation(string DingDanHao, string KeHuMa, string ID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersInformationTable
join tbClient in myDDCX.SYS_ClientTable on tbOrders.ClientID equals tbClient.ClientID
join tbOrdersType in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbExecuteState in myDDCX.SYS_AttributeDetailedTable on tbOrders.ExecuteStateID equals tbExecuteState.AttributeDetailedID
join tbUrgencyDegree in myDDCX.SYS_AttributeDetailedTable on tbOrders.UrgencyDegreeID equals tbUrgencyDegree.AttributeDetailedID
join tbOrdersSource in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersSourceID equals tbOrdersSource.AttributeDetailedID
join tbState in myDDCX.SYS_AttributeDetailedTable on tbOrders.StateID equals tbState.AttributeDetailedID
select new
{
OrdersInformationID = tbOrders.OrdersInformationID,
OrdersMark = tbOrders.OrdersMark,
ClientID = tbOrders.ClientID,
ClientCode = tbClient.ClientCode,
ClientInstructMark = tbOrders.ClientInstructMark,
PurchaseOrdersNumber = tbOrders.PurchaseOrdersNumber,
OrdersTypeID = tbOrders.OrdersTypeID,
OrdersType = tbOrdersType.AttributeDetailedName,
UrgencyDegreeID = tbOrders.UrgencyDegreeID,
UrgencyDegree = tbUrgencyDegree.AttributeDetailedName,
OrdersSourceID = tbOrders.OrdersSourceID,
OrdersSource = tbOrdersSource.AttributeDetailedName,
OrderTime = tbOrders.OrderTime,
StateID = tbOrders.StateID,
State = tbState.AttributeDetailedName,
ExecuteStateID = tbOrders.ExecuteStateID,
ExecuteState = tbExecuteState.AttributeDetailedName,
OrdersPriorLevel = tbOrders.OrdersPriorLevel,
Note = tbOrders.Note,
EntryTime = tbOrders.EntryTime
};
if (ID.ToString() != "")//linq方法,当满足这个条件时,系统会根据这个条件查询数据库表
{
int id = Convert.ToInt32(ID);
dtOrders = dtOrders.Where(tbOrders => tbOrders.ExecuteStateID == id);
}
if (KeHuMa != "")//当满足这个条件时,系统会自动叠加上面的条件一起查询。
{
dtOrders = dtOrders.Where(tbOrders => tbOrders.ClientCode == KeHuMa.Trim());
}
if (DingDanHao != "") //当满足这个条件时,会叠加上面两个条件查询。这三个条件的参数如果不为空值,会根据三个条件查询,
//如果其中有一个为空值则会根据两个条件查询,依次类推,当全为空值时,查询全部数据。
{
dtOrders = dtOrders.Where(tbOrders => tbOrders.OrdersMark == DingDanHao.Trim());
}
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.EntryTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("RiQi", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 删除订单信息
/// <summary>
/// 根据ID删除订单信息,当删除了该订单信息,会相应删除子表信息
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>Json</returns>
public ActionResult DelectOrdersInformation(int OrdersInformationID)
{
var dtOrders = (from tbOrders in myDDCX.PW_OrdersInformationTable
where tbOrders.OrdersInformationID == OrdersInformationID
select tbOrders).Single<Models.PW_OrdersInformationTable>();
myDDCX.DeleteObject(dtOrders);//从数据库删除这条数据
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除入库订单信息和入库明细
/// <summary>
/// 根据订单信息ID,删除入库订单信息,返回要删除数据的主键ID值
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>int</returns>
public int DelectOrdersWarehousingInformation(int OrdersInformationID)
{
try {
var dtOrders = (from tbOrders in myDDCX.PW_OrdersWarehousingInformationTable
where tbOrders.OrdersInformationID == OrdersInformationID
select tbOrders).Single<Models.PW_OrdersWarehousingInformationTable>();
int ID = dtOrders.OrdersWarehousingInformationID;//获取将要删除的数据的主键ID
myDDCX.DeleteObject(dtOrders);//从数据库删除这条数据
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return ID;//返回主键ID值
}
else
{
return 0;
}
}
catch (Exception e) {
return 0;
}
}
/// <summary>
/// 通过上面返回的主键ID值,删除入库订单信息的子表(入库货品明细表)
/// </summary>
/// <param name="OrdersWarehousingInformationID">入库订单信息ID</param>
/// <returns>Json</returns> public ActionResult DelectOrdersWarehousingDetailed(int OrdersWarehousingInformationID)
{
var dtOrders = (from tbOrders in myDDCX.PW_OrdersWarehousingDetailedTable
where tbOrders.OrdersWarehousingInformationID == OrdersWarehousingInformationID
select tbOrders).ToList<Models.PW_OrdersWarehousingDetailedTable>();
for (int i = 0; i < dtOrders.Count;i++ )//货品信息有多条,要循环删除
{
myDDCX.DeleteObject(dtOrders[i]);
}
int j = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (j > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除出库订单信息和出库明细
/// <summary>
/// 根据订单信息ID,删除出库订单信息,返回要删除数据的主键ID值
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>int</returns>
public int DelectOrdersOutboundInformation(int OrdersInformationID)
{
try
{
var dtOrders = (from tbOrders in myDDCX.PW_OrdersOutboundInformationTable
where tbOrders.OrdersInformationID == OrdersInformationID
select tbOrders).Single<Models.PW_OrdersOutboundInformationTable>();
int ID = dtOrders.OrdersOutboundInformationID;//获取将要删除的数据的主键ID
myDDCX.DeleteObject(dtOrders);//从数据库删除这条数据
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return ID;//返回主键ID值
}
else
{
return 0;
}
}
catch (Exception e)
{
return 0;
}
}
/// <summary>
/// 通过上面返回的主键ID值,删除出库订单信息的子表(出库货品明细表)
/// </summary>
/// <param name="OrdersOutboundInformationID"></param>
/// <returns>Json</returns>
public ActionResult DelectOrdersOutboundDetailed(int OrdersOutboundInformationID)
{
var dtOrders = (from tbOrders in myDDCX.PW_OrdersOutboundDetailedTable
where tbOrders.OrdersOutboundInformationID == OrdersOutboundInformationID
select tbOrders).ToList<Models.PW_OrdersOutboundDetailedTable>();
for (int j = 0; j < dtOrders.Count; j++)//货品信息有多条,要循环删除
{
myDDCX.DeleteObject(dtOrders[j]);
}
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除加工订单信息和加工明细
/// <summary>
/// 根据订单信息ID,删除加工订单信息,返回要删除数据的主键ID值
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>int</returns>
public int DelectMachiningOrdersDetailed(int OrdersInformationID)
{
try
{
var dtOrders = (from tbOrders in myDDCX.PW_MachiningOrdersDetailedTable
where tbOrders.MachiningOrdersInformationID == OrdersInformationID
select tbOrders).Single<Models.PW_MachiningOrdersDetailedTable>();
int ID = dtOrders.MachiningOrdersDetailedID;//获取将要删除的数据的主键ID
myDDCX.DeleteObject(dtOrders);//从数据库删除这条数据
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return ID;//返回主键ID值
}
else
{
return 0;
}
}
catch (Exception e)
{
return 0;
}
}
/// <summary>
/// 通过上面返回的主键ID值,删除加工订单信息的子表(加工货品明细表)
/// </summary>
/// <param name="MachiningOrdersDetailedID">加工订单信息ID</param>
/// <returns>Json</returns>
public ActionResult DelectMachiningGoods(int MachiningOrdersDetailedID)
{
var dtOrders = (from tbOrders in myDDCX.PW_MachiningGoodsTable
where tbOrders.MachiningOrdersInformationID == MachiningOrdersDetailedID
select tbOrders).ToList<Models.PW_MachiningGoodsTable>();
for (int j = 0; j < dtOrders.Count; j++)//货品信息有多条,要循环删除
{
myDDCX.DeleteObject(dtOrders[j]);
}
int i = myDDCX.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
第三步:视图层(Views)
订单跟踪效果截图:
HTML代码:
<!DOCTYPE html>
<html>
<head>
<meta content="text/javascript;charset=utf-8"/> //<head>标签里的是jQuery包的引用
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/themes/default/easyui.css"/>
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/themes/icon.css"/>
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/demo/demo.css"/>
<script type="text/javascript" src="../../Content/themes/jquery-easyui-1.3.3/jquery.min.js"></script>
<script type="text/javascript" src="../../Content/themes/jquery-easyui-1.3.3/jquery.easyui.min.js"></script>
</head>
<body>
<div class="easyui-tabs" style="border-style: none; margin-top: -18px; margin-left: -17px; margin-right: -18px;">
<div title="订 单 跟 踪">
<div class="easyui-panel" style="border-style: none; width:auto; height:460px; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">订单号:</strong></td><td>
<input type="text" id="txtdingDanhao" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">客户码:</strong></td><td>
<input class="easyui-combogrid" id="cbokeHuma" style="border-width: thin; width:200px; height:30px; "
data-options="panelWidth: 270, idField: 'ClientID', textField: 'ClientCode',
url: '/DingDanLuRu/SelectClientTable',
columns: [[{ field: 'ClientCode', title: '客户码', width: 80 },
{ field: 'ClientUnitName', title: '客户单位名称', width: 100 },
{ field: 'ClientAccounts', title: '客户账号', width: 80}]]" /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">执行状态:</strong></td><td>
<input class="easyui-combobox" id="cbozhiXingZhuangtai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td><input type="button" οnclick="MistinessSelectOrdersInformation()" value="查 询" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></td>
</tr>
</table>//数据表格datagrid当rownumbers为‘true’时,显示序号,pagination为‘true’,显示分页,pageSize为当前显示数据数,loadFilter分页方法,上下页按钮方法,方法代码在jQuery写
<table id="tb订单跟踪" class="easyui-datagrid" style="width:auto; height:auto;" data-options="singleSelect:true,scrolling:true,
rownumbers:true,pagination:true,pageSize:10,loadFilter: Filter,
url: '/DingDanChaXun/SelectOrdersInformation',
rowStyler:function(index,row){
if (index%2==0){
return 'background-color:#D1EEEE';
}
}">
<thead>
<tr>
<th data-options="field:'OrdersInformationID',width:50,align:'center',formatter:returnBtnShanChu"><img src="../../Content/图片/删除.jpg" /></th> //formatter属性,如果在jQuery没写代码方法界面会报错
<th data-options="field:'OrdersWarehousingInformationID',width:100,align:'center',hidden:'true'">入库订单信息ID</th>
<th data-options="field:'OrdersMark',width:150,align:'center'"><strong style="font-size: medium">订 单 号</strong></th>
<th data-options="field:'ClientCode',width:150,align:'center'"><strong style="font-size: medium">客 户 码</strong></th>
<th data-options="field:'OrdersTypeID',width:50,align:'center',hidden:true"><strong style="font-size: medium">订单类型ID</strong></th>
<th data-options="field:'OrdersType',width:150,align:'center'"><strong style="font-size: medium">订 单 类 型</strong></th>
<th data-options="field:'RiQi',width:150,align:'center'"><strong style="font-size: medium">录 入 时 间</strong></th>
<th data-options="field:'ExecuteState',width:150,align:'center'"><strong style="font-size: medium">执 行 状 态</strong></th>
<th data-options="field:'id',width:80,align:'center',formatter:returnBtnXiangQing"></th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</body>
</html>
jQuery代码:
<script type="text/javascript">
$(document).ready(function () {
XiaLaBangDing();//HTML加载时,预先执行下拉框绑定方法
});
}
function XiaLaBangDing() { //下拉绑定 $.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=25",
function (data) {
$("#cbozhiXingZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
}
function MistinessSelectOrdersInformation() { //多条件组合,不定条件查询
var DingDanHao = $('#txtdingDanhao').val();
var KeHuMa = $('#cbokeHuma').combogrid('getText');
var ID = $('#cbozhiXingZhuangtai').combobox('getValue');
$("#tb订单跟踪").datagrid({ url: "/DingDanChaXun/MistinessSelectOrdersInformation?DingDanHao=" + DingDanHao + "&KeHuMa=" + KeHuMa + "&ID=" + ID });
}
function returnBtnShanChu(OrdersInformationID, row, rowIndex) {
return "<a href='javascript:ShanChu(" + OrdersInformationID + "," + rowIndex + ")'>" + '<img src="../../Content/图片/删除.jpg" />' + "</a>";//点击订单跟踪界面的删除按钮图标,执行下面删除方法
}
function ShanChu(OrdersInformationID, rowIndex) {
var row = $("#tb订单跟踪").datagrid('getSelected');
var ID = row.OrdersTypeID; //获取订单类型ID,不同订单类型删除不同订单
try {
switch (ID) {
case 82: //入库订单删除,既是删除订单信息表的数据,亦删除入库订单下的子数据库表信息
if (confirm("是否删除?")) {
$.getJSON("/DingDanChaXun/DelectOrdersInformation?OrdersInformationID=" + OrdersInformationID,
function (data) { //删除订单信息表的一条数据
if (data == "true") {
$.getJSON("/DingDanChaXun/DelectOrdersWarehousingInformation?OrdersInformationID=" + OrdersInformationID,
function (data) { //删除入库订单信息表的一条数据
if (data != null) {
$.getJSON("/DingDanChaXun/DelectOrdersWarehousingDetailed?OrdersWarehousingInformationID=" + data,
function (data) { //删除该订单的货品信息
if (data == "true") {
alert("删除成功!");
$('#tb订单跟踪').datagrid('reload');
}
});
}
});
}
});
} else {
return null;
}
break;
case 83: //出库订单删除,既是删除订单信息表的数据,亦删除出库订单下的子数据库表信息
if (confirm("是否删除?")) {
$.getJSON("/DingDanChaXun/DelectOrdersInformation?OrdersInformationID=" + OrdersInformationID,
function (data) {//删除订单信息表的一条数据
if (data == "true") {
$.getJSON("/DingDanChaXun/DelectOrdersOutboundInformation?OrdersInformationID=" + OrdersInformationID,
function (data) { //删除出库订单信息表的一条数据
if (data != null) {
$.getJSON("/DingDanChaXun/DelectOrdersOutboundDetailed?OrdersOutboundInformationID=" + data,
function (data) {//删除该订单的货品信息
if (data == "true") {
alert("删除成功!");
$('#tb订单跟踪').datagrid('reload');
}
});
}
});
}
});
} else {
return null;
}
break;
case 271: //加工订单删除,既是删除订单信息表的数据,亦删除加工订单下的子数据库表信息
if (confirm("是否删除?")) {//删除订单信息表的一条数据
$.getJSON("/DingDanChaXun/DelectOrdersInformation?OrdersInformationID=" + OrdersInformationID,
function (data) {
if (data == "true") {//删除订单信息表的一条数据
$.getJSON("/DingDanChaXun/DelectMachiningOrdersDetailed?OrdersInformationID=" + OrdersInformationID,
function (data) {//删除加工订单信息表的一条数据
if (data != 0) {
$.getJSON("/DingDanChaXun/DelectMachiningGoods?OrdersInformationID=" + data,
function (data) {//删除该订单的货品信息
if (data == "true") {
alert("删除成功!");
$('#tb订单跟踪').datagrid('reload');
$('#tb订单查询').datagrid('reload');
}
});
}
});
}
});
} else {
return null;
}
break;
}
} catch (e) {
return null;
}
}
</script>
<script type="text/javascript">//分页控件方法
function getData() {
var rows = [];
var row = $('#tb订单跟踪').datagrid('getData');
for (var i = 1; i <= row.rows.length; i++) {
rows.push({
OrdersWarehousingInformationID: '入库订单信息ID' + i,
OrdersMark: '订 单 号 ' + i,
ClientCode: '客 户 码' + i,
OrdersTypeID: '订单类型ID' + i,
OrdersType: '订 单 类 型' + i,
RiQi: '录 入 时 间' + i,
ExecuteState: '执 行 状 态' + i
});
}
return rows;
}
function Filter(data) {
if (typeof data.length == 'number' && typeof data.splice == 'function') { // is array
data = {
total: data.length,
rows: data
}
}
var dg = $('#tb订单跟踪');
var opts = dg.datagrid('options');
var pager = dg.datagrid('getPager');
pager.pagination({
onSelectPage: function (pageNum, pageSize) {
opts.pageNumber = pageNum;
opts.pageSize = pageSize;
pager.pagination('refresh', {
pageNumber: pageNum,
pageSize: pageSize
});
dg.datagrid('loadData', data);
}
});
if (!data.originalRows) {
data.originalRows = (data.rows);
}
var start = (opts.pageNumber - 1) * parseInt(opts.pageSize);
var end = start + parseInt(opts.pageSize);
data.rows = (data.originalRows.slice(start, end));
return data;
}
$(function () {
var pager = $('#tb订单跟踪').datagrid('getPager'); //分页控件属性
pager.pagination({
buttons: [{
iconCls: 'icon-search',
handler: function () {
alert('search');
}
}],
// onRefresh: function () {
// $("#tb订单跟踪").datagrid({ url: "/DingDanChaXun/SelectOrdersInformation" });
// },
displayMsg: "从 {from} 到 {to} 共 {total} 项",
beforePageText: "页", afterPageText: "共{pages}页"
});
});
</script>
2.2.2 订单查询
查询出订单录入中录入的入库、出库、加工订单,对这些订单进行查看操作。
订单查询界面截图:
订单查询功能实现:
第一步:数据库
1、表和关系
表1:订单信息表(PW_OrdersInformationTable)
列名 | 数据类型 | 主键/外键 | 说明 |
OrdersInformationID | int | 主键 | 订单信息ID |
OrdersMark | nchar(50) |
| 订单号 |
ClientID | int | 外键 | 客户ID |
ClientInstructMark | nchar(50) |
| 客户指令号 |
PurchaseOrdersNumber | nchar(50) |
| 采购订单号 |
OrdersTypeID | int | 外键 | 订单类型ID |
UrgencyDegreeID | int | 外键 | 紧急程度ID |
OrdersSourceID | int | 外键 | 订单来源ID |
PledgeBankID | int | 外键 | 质押银行ID |
Note | nchar(50) |
| 备注 |
表2:客户表(SYS_ClientTable)
列名 | 数据类型 | 主键/外键 | 说明 |
ClientID | int | 主键 | 客户ID |
ClientAccounts | nchar(50) |
| 客户帐号 |
ClientCode | nchar(50) |
| 客户码 |
ClientUnitName | nchar(50) |
| 客户单位名称 |
ClientManager | nchar(50) |
| 客户经理 |
ClientManagerPhone | nchar(50) |
| 客户经理电话 |
Linkman | nchar(50) |
| 联系人 |
LinkmanPhone | nchar(50) |
| 联系人电话 |
ClientPostcode | nchar(50) |
| 客户邮编 |
ClientFax | nchar(50) |
| 客户传真 |
ClientAddress | nchar(50) |
| 客户地址 |
ClientCompanyID | int | 外键 | 客户公司ID |
ClientRank | int | 外键 | 客户级别ID |
第二步:控制器(Controllers)
2.2(图9)
2.2(图10)
Contrlles(控制器)代码:
#region 查询订单信息
/// <summary>
/// 查询出入库、出库、加工的基本信息,显示在同一界面
/// </summary>
/// <returns>Json</returns>
public ActionResult SelectOrdersInformation()
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersInformationTable //linq多表之间的连接关系
join tbClient in myDDCX.SYS_ClientTable on tbOrders.ClientID equals tbClient.ClientID
join tbOrdersType in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbExecuteState in myDDCX.SYS_AttributeDetailedTable on tbOrders.ExecuteStateID equals tbExecuteState.AttributeDetailedID
join tbUrgencyDegree in myDDCX.SYS_AttributeDetailedTable on tbOrders.UrgencyDegreeID equals tbUrgencyDegree.AttributeDetailedID
join tbOrdersSource in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersSourceID equals tbOrdersSource.AttributeDetailedID
join tbState in myDDCX.SYS_AttributeDetailedTable on tbOrders.StateID equals tbState.AttributeDetailedID
select new
{
OrdersInformationID = tbOrders.OrdersInformationID,
OrdersMark = tbOrders.OrdersMark,
ClientID = tbOrders.ClientID,
ClientCode = tbClient.ClientCode,
ClientInstructMark = tbOrders.ClientInstructMark,
PurchaseOrdersNumber = tbOrders.PurchaseOrdersNumber,
OrdersTypeID = tbOrders.OrdersTypeID,
OrdersType = tbOrdersType.AttributeDetailedName,
UrgencyDegreeID = tbOrders.UrgencyDegreeID,
UrgencyDegree = tbUrgencyDegree.AttributeDetailedName,
OrdersSourceID = tbOrders.OrdersSourceID,
OrdersSource = tbOrdersSource.AttributeDetailedName,
OrderTime = tbOrders.OrderTime,
StateID = tbOrders.StateID,
State = tbState.AttributeDetailedName,
ExecuteStateID = tbOrders.ExecuteStateID,
ExecuteState = tbExecuteState.AttributeDetailedName,
OrdersPriorLevel = tbOrders.OrdersPriorLevel,
Note = tbOrders.Note,
EntryTime = tbOrders.EntryTime
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.EntryTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("RiQi", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定订单信息
/// <summary>
/// 接收界面参数,根据订单信息ID查询子表数据
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingOrdersInformationByID(int OrdersInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersInformationTable //linq多表之间的连接关系
join tbClient in myDDCX.SYS_ClientTable on tbOrders.ClientID equals tbClient.ClientID
join tbOrdersType in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbExecuteState in myDDCX.SYS_AttributeDetailedTable on tbOrders.ExecuteStateID equals tbExecuteState.AttributeDetailedID
join tbUrgencyDegree in myDDCX.SYS_AttributeDetailedTable on tbOrders.UrgencyDegreeID equals tbUrgencyDegree.AttributeDetailedID
join tbOrdersSource in myDDCX.SYS_AttributeDetailedTable on tbOrders.OrdersSourceID equals tbOrdersSource.AttributeDetailedID
join tbState in myDDCX.SYS_AttributeDetailedTable on tbOrders.StateID equals tbState.AttributeDetailedID
join tbPledgeBank in myDDCX.SYS_BankTable on tbOrders.PledgeBankID equals tbPledgeBank.BankID
where tbOrders.OrdersInformationID == OrdersInformationID
select new
{
OrdersInformationID = tbOrders.OrdersInformationID,
OrdersMark = tbOrders.OrdersMark,
ClientID = tbOrders.ClientID,
ClientCode = tbClient.ClientCode,
ClientInstructMark = tbOrders.ClientInstructMark,
PurchaseOrdersNumber = tbOrders.PurchaseOrdersNumber,
OrdersTypeID = tbOrders.OrdersTypeID,
OrdersType = tbOrdersType.AttributeDetailedName,
UrgencyDegreeID = tbOrders.UrgencyDegreeID,
UrgencyDegree = tbUrgencyDegree.AttributeDetailedName,
OrdersSourceID = tbOrders.OrdersSourceID,
OrdersSource = tbOrdersSource.AttributeDetailedName,
OrderTime = tbOrders.OrderTime,
StateID = tbOrders.StateID,
State = tbState.AttributeDetailedName,
ExecuteStateID = tbOrders.ExecuteStateID,
ExecuteState = tbExecuteState.AttributeDetailedName,
OrdersPriorLevel = tbOrders.OrdersPriorLevel,
PledgeBankID = tbPledgeBank.BankID,
PledgeBank = tbPledgeBank.BankName,
Note = tbOrders.Note,
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成(键名,键值)的格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.OrderTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("XiaDaShiJian", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定入库订单信息
/// <summary>
/// 接收界面参数,通过订单信息ID,查询入库订单信息
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingOrdersInformationTableByID(int OrdersInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersWarehousingInformationTable
join tbStoreroom in myDDCX.SYS_StoreroomTable on tbOrders.StoreroomID equals tbStoreroom.StoreroomID
join tbWarehousingType in myDDCX.SYS_AttributeDetailedTable on tbOrders.WarehousingTypeID equals tbWarehousingType.AttributeDetailedID
join tbWarehousingWay in myDDCX.SYS_AttributeDetailedTable on tbOrders.WarehousingWayID equals tbWarehousingWay.AttributeDetailedID
where tbOrders.OrdersInformationID == OrdersInformationID
select new
{
OrdersWarehousingInformationID = tbOrders.OrdersWarehousingInformationID,
StoreroomID = tbOrders.StoreroomID,
Storeroom = tbStoreroom.StoreroomName,
WarehousingTypeID = tbOrders.WarehousingTypeID,
WarehousingType = tbWarehousingType.AttributeDetailedName,
WarehousingWayID = tbOrders.WarehousingWayID,
WarehousingWay = tbWarehousingWay.AttributeDetailedName,
PredictWarehousingTime = tbOrders.PredictWarehousingTime,
Note = tbOrders.Note,
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.PredictWarehousingTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("RuKuShiJian", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定入库明细
/// <summary>
/// 通过入库订单信息ID,将入库订单的货品信息查询出来
/// </summary>
/// <param name="OrdersWarehousingInformationID">入库订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingOrdersWarehousingDetailed(int OrdersWarehousingInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersWarehousingDetailedTable
join tbGoods in myDDCX.SYS_GoodsTable on tbOrders.GoodsID equals tbGoods.GoodsID
join tbUnit in myDDCX.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQuality in myDDCX.SYS_AttributeDetailedTable on tbGoods.QualityID equals tbQuality.AttributeDetailedID
where tbOrders.OrdersWarehousingInformationID == OrdersWarehousingInformationID
select new
{
OrdersWarehousingDetailedID = tbOrders.OrdersWarehousingDetailedID,
GoodsID = tbGoods.GoodsID,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Weight = tbGoods.Weight,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
BarCode = tbGoods.BarCode,
QualityID = tbGoods.QualityID,
Quality = tbQuality.AttributeDetailedName,
Batch = tbOrders.Batch,
Quantity = tbOrders.Quantity,
Note = tbOrders.Note
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定出库订单信息
/// <summary>
/// 接收界面参数,通过订单信息ID,查询出库订单信息
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingOrdersOutboundInformationTable(int OrdersInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersOutboundInformationTable
join tbStoreroom in myDDCX.SYS_StoreroomTable on tbOrders.StoreroomID equals tbStoreroom.StoreroomID
join tbOutboundType in myDDCX.SYS_AttributeDetailedTable on tbOrders.OutboundTypeID equals tbOutboundType.AttributeDetailedID
join tbOutboundWay in myDDCX.SYS_AttributeDetailedTable on tbOrders.OutboundWayID equals tbOutboundWay.AttributeDetailedID
where tbOrders.OrdersInformationID == OrdersInformationID
select new
{
OrdersOutboundInformationID = tbOrders.OrdersOutboundInformationID,
StoreroomID = tbOrders.StoreroomID,
Storeroom = tbStoreroom.StoreroomName,
OutboundTypeID = tbOrders.OutboundTypeID,
OutboundType = tbOutboundType.AttributeDetailedName,
OutboundWayID = tbOrders.OutboundWayID,
OutboundWay = tbOutboundWay.AttributeDetailedName,
EstimatedOutboundTime = tbOrders.EstimatedOutboundTime,
Note = tbOrders.Note,
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
string RiQi = item.EstimatedOutboundTime.ToString().Substring(0, 13);//转换日期格式
itemOrder.Add("ChuKuShiJian", RiQi);
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定出库明细
/// <summary>
/// 通过出库订单信息ID,将出库订单的货品查询出来
/// </summary>
/// <param name="OrdersOutboundInformationID">出库订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingOrdersOutboundDetailed(int OrdersOutboundInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_OrdersOutboundDetailedTable
join tbGoods in myDDCX.SYS_GoodsTable on tbOrders.GoodsID equals tbGoods.GoodsID
join tbUnit in myDDCX.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQuality in myDDCX.SYS_AttributeDetailedTable on tbGoods.QualityID equals tbQuality.AttributeDetailedID
where tbOrders.OrdersOutboundInformationID == OrdersOutboundInformationID
select new
{
OrdersWarehousingDetailedID = tbOrders.OrdersOutboundDetailedID,
GoodsID = tbGoods.GoodsID,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
BarCode = tbGoods.BarCode,
QualityID = tbGoods.QualityID,
Quality = tbQuality.AttributeDetailedName,
Batch = tbOrders.Batch,
Quantity = tbOrders.Quantity,
Note = tbOrders.Note
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定加工信息
/// <summary>
/// 接收界面参数,通过订单信息ID,查询加工订单信息
/// </summary>
/// <param name="OrdersInformationID">订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingMachiningOrdersDetailed(int OrdersInformationID)
{
var dtOrders = from tbOrders in myDDCX.PW_MachiningOrdersDetailedTable
join tbMachiningType in myDDCX.SYS_AttributeDetailedTable on tbOrders.MachiningTypeID equals tbMachiningType.AttributeDetailedID
join tbStoreroom in myDDCX.SYS_StoreroomTable on tbOrders.StoreroomID equals tbStoreroom.StoreroomID
where tbOrders.MachiningOrdersInformationID == OrdersInformationID
select new
{
MachiningOrdersDetailedID = tbOrders.MachiningOrdersDetailedID,
OrdersInformationID = tbOrders.MachiningOrdersInformationID,
MachiningTypeID = tbOrders.MachiningTypeID,
StoreroomID = tbOrders.StoreroomID,
MachiningType = tbMachiningType.AttributeDetailedName,
Storeroom = tbStoreroom.StoreroomName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定加工明细
/// <summary>
/// 通过加工订单信息ID,查询加工订单的货品信息
/// </summary>
/// <param name="MachiningOrdersDetailedID">加工订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BindingMachiningGoodsTable(int MachiningOrdersDetailedID)
{
var dtOrders = from tbOrders in myDDCX.PW_MachiningGoodsTable
join tbGoods in myDDCX.SYS_GoodsTable on tbOrders.GoodsID equals tbGoods.GoodsID
join tbUnit in myDDCX.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQuality in myDDCX.SYS_AttributeDetailedTable on tbGoods.QualityID equals tbQuality.AttributeDetailedID
where tbOrders.MachiningOrdersInformationID == MachiningOrdersDetailedID
select new
{
MachiningGoodsID = tbOrders.MachiningGoodsID,
GoodsID = tbGoods.GoodsID,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Weight = tbGoods.Weight,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
BarCode = tbGoods.BarCode,
QualityID = tbGoods.QualityID,
Quality = tbQuality.AttributeDetailedName,
Batch = tbOrders.Batch,
Quantity = tbOrders.Quantity
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrders)//将数据遍历循环转换成列表格式
{
Dictionary<string, object> itemOrder = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrder.Add(p.Name, p.GetValue(item, null));//将数据遍历循环转换成(键名,键值)的格式
}
ListReturn.Add(itemOrder);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
第三步:视图层(Views)
订单查询效果截图:
HTML代码:
<!DOCTYPE html>
<html>
<head>
<meta content="text/javascript;charset=utf-8"/> //<head>标签里的是jQuery包的引用
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/themes/default/easyui.css"/>
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/themes/icon.css"/>
<link rel="stylesheet" type="text/css" href="../../Content/themes/jquery-easyui-1.3.3/demo/demo.css"/>
<script type="text/javascript" src="../../Content/themes/jquery-easyui-1.3.3/jquery.min.js"></script>
<script type="text/javascript" src="../../Content/themes/jquery-easyui-1.3.3/jquery.easyui.min.js"></script>
</head>
<body>
<div class="easyui-tabs" style="border-style: none; margin-top: -18px; margin-left: -17px; margin-right: -18px;">
<div title="订 单 查 询">
<div class="easyui-panel" style="border-style: none; width:auto; height:460px; border-radius:15px 15px 0px 0px;">
<table id="tb订单查询" class="easyui-datagrid" style="width:auto; height:auto;" data-options="singleSelect:true,scrolling:true,
rownumbers:true,pagination:true,pageSize:10,loadFilter: pagerFilter,
//datagrid的序号属性、分页属性,分页显示数目,上下页翻转方法loadFilter,在jQuery里没有写方法代码,界面会出错。
url: '/DingDanChaXun/SelectOrdersInformation',rowStyler:function(index,row){
if (index%2==0){
return 'background-color:#D1EEEE';
}
}">
<thead>
<tr>
<th data-options="field:'OrdersInformationID',width:90,align:'center',formatter:returnBtnChaKan"></th>
<th data-options="field:'OrdersWarehousingInformationID',width:100,align:'center',hidden:'true'">入库订单信息ID</th>
<th data-options="field:'OrdersMark',width:100,align:'center'"><strong style="font-size: medium">订 单 号</strong></th>
<th data-options="field:'ClientCode',width:200,align:'center'"><strong style="font-size: medium">客 户 码</strong></th>
<th data-options="field:'OrdersTypeID',width:50,align:'center',hidden:true"><strong style="font-size: medium">订单类型ID</strong></th>
<th data-options="field:'OrdersType',width:100,align:'center'"><strong style="font-size: medium">订 单 类 型</strong></th>
<th data-options="field:'RiQi',width:200,align:'center'"><strong style="font-size: medium">录 入 时 间</strong></th>
<th data-options="field:'ExecuteState',width:100,align:'center'"><strong style="font-size: medium">执 行 状 态</strong></th>
</tr>
</thead>
</table>
</div>
</div>
</div>
<div class="easyui-window" id="RuKuDingDanChaXun" title="▷ 当前位置:订单查询" style="border-width: thin; border-style: none; width:800px; height:400px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<div class="easyui-tabs" style="border-style: none;">
<div title="订单信息">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">订单号:</strong></td><td>
<input type="text" id="txtDingDanHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">客户码:</strong></td><td>
<input type="text" id="txtKeHuMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">客户指令号:</strong></td><td>
<input type="text" id="txtKeHuZhiLingHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">采购订单号:</strong></td><td>
<input type="text" id="txtCaiGouDanHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单类型:</strong></td><td>
<input class="easyui-combobox" id="cboDingDanLeiXing" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">紧急程度:</strong></td><td>
<input class="easyui-combobox" id="cboJinJiChengDu" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单来源:</strong></td><td>
<input class="easyui-combobox" id="cboDingDanLaiYuan" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">下达时间:</strong></td><td>
<input class="easyui-datebox" id="datXiaDaShiJian" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">状态:</strong></td><td>
<input class="easyui-combobox" id="cboZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">执行状态:</strong></td><td>
<input class="easyui-combobox" id="cboZhiXingZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单优先级:</strong></td><td>
<input type="text" id="txtDingDanYouXianJi" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">质押银行:</strong></td><td>
<input type="text" id="txtZhiYaYinHang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
</table>
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">备注:</strong></td><td>
<input type="text" id="txtBeiZhu" style="border-style: hidden hidden outset hidden; border-width: thin; width:400px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div title="订单入库信息">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">库房:</strong></td><td>
<input type="text" id="txtKuFang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
<td align="right"><strong style="font-size: medium">入库类型:</strong></td><td>
<input class="easyui-combobox" id="cboRuKuLeiXing" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">入库方式:</strong></td><td>
<input class="easyui-combobox" id="cboRuKuFangShi" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">预计入库时间:</strong></td><td>
<input class="easyui-datebox" id="txtYuJiRuKuShiJian" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
</table>
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">备注:</strong></td><td>
<input type="text" id="txtRuKuBeiZhu" style="border-style: hidden hidden outset hidden; border-width: thin; width:400px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div title="订单货品">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-top: 10px; margin-left: 10px;"></table>
<table id="tb入库订单货品" class="easyui-datagrid" style="width:auto; height:auto;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'OrdersWarehousingDetailedID',width:50,align:'center'"><img src="../../Content/图片/删除.jpg" /></th>
<th data-options="field:'GoodsCoding',width:80,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:80,align:'center'">货品名称</th>
<th data-options="field:'Standard',width:80,align:'center'">规格</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quality',width:80,align:'center'">质量</th>
<th data-options="field:'Quantity',width:80,align:'center'">数量</th>
<th data-options="field:'Note',width:100,align:'center'">备注</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div class="easyui-window" id="ChuKuDingDanChaXun" title="▷ 当前位置:订单查询" style="border-width: thin; border-style: none; width:800px; height:400px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<div class="easyui-tabs" style="border-style: none;">
<div title="订单信息">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">订单号:</strong></td><td>
<input type="text" id="DingDanHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">客户码:</strong></td><td>
<input type="text" id="KeHuMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">客户指令号:</strong></td><td>
<input type="text" id="KeHuZhiLingHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">采购订单号:</strong></td><td>
<input type="text" id="CaiGouDanHao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单类型:</strong></td><td>
<input class="easyui-combobox" id="DingDanLeiXing" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">紧急程度:</strong></td><td>
<input class="easyui-combobox" id="JinJiChengDu" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单来源:</strong></td><td>
<input class="easyui-combobox" id="DingDanLaiYuan" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">下达时间:</strong></td><td>
<input class="easyui-datebox" id="XiaDaShiJian" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">状态:</strong></td><td>
<input class="easyui-combobox" id="ZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">执行状态:</strong></td><td>
<input class="easyui-combobox" id="ZhiXingZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单优先级:</strong></td><td>
<input type="text" id="DingDanYouXianJi" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">质押银行:</strong></td><td>
<input type="text" id="ZhiYaYinHang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
</table>
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">备注:</strong></td><td>
<input type="text" id="BeiZhu" style="border-style: hidden hidden outset hidden; border-width: thin; width:400px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div title="订单出库信息">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">库房:</strong></td><td>
<input type="text" id="KuFang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
<td align="right"><strong style="font-size: medium">出库类型:</strong></td><td>
<input class="easyui-combobox" id="cboChuKuLeiXing" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">出库方式:</strong></td><td>
<input class="easyui-combobox" id="cboChuKuFangShi" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">预计出库时间:</strong></td><td>
<input class="easyui-datebox" id="cboYuJiChuKuShiJian" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
</table>
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">备注:</strong></td><td>
<input type="text" id="txtChuKuBeiZhu" style="border-style: hidden hidden outset hidden; border-width: thin; width:400px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div title="订单货品">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-top: 10px; margin-left: 10px;"></table>
<table id="tb出库订单货品" class="easyui-datagrid" style="width:auto; height:auto;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'OrdersWarehousingDetailedID',width:50,align:'center'"><img src="../../Content/图片/删除.jpg" /></th>
<th data-options="field:'GoodsCoding',width:80,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:80,align:'center'">货品名称</th>
<th data-options="field:'Standard',width:80,align:'center'">规格</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quality',width:80,align:'center'">质量</th>
<th data-options="field:'Quantity',width:80,align:'center'">数量</th>
<th data-options="field:'Note',width:100,align:'center'">备注</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div class="easyui-window" id="JiaGongDingDanChaXun" title="▷ 当前位置:订单查询" style="border-width: thin; border-style: none; width:800px; height:400px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<div class="easyui-tabs" style="border-width: thick; border-style: none;">
<div title="订单信息">
<div class="easyui-panel" style="border-style: none; width:auto; height:auto; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">订单号:</strong></td><td>
<input type="text" id="txtDingDanhao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">客户码:</strong></td><td>
<input type="text" id="txtKeHuma" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">客户指令号:</strong></td><td>
<input type="text" id="txtKeHuZhiLinghao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">采购订单号:</strong></td><td>
<input type="text" id="txtCaiGouDanhao" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单类型:</strong></td><td>
<input class="easyui-combobox" id="cboDingDanLeixing" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">紧急程度:</strong></td><td>
<input class="easyui-combobox" id="cboJinJiChengdu" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单来源:</strong></td><td>
<input class="easyui-combobox" id="cboDingDanLaiyuan" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">下达时间:</strong></td><td>
<input class="easyui-datebox" id="datXiaDaShijian" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">状态:</strong></td><td>
<input class="easyui-combobox" id="cboZhuangtai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">执行状态:</strong></td><td>
<input class="easyui-combobox" id="cboZhiXingZhuangtai" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
</tr>
<tr>
<td align="right"><strong style="font-size: medium">订单优先级:</strong></td><td>
<input type="text" id="txtDingDanYouXianji" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td> </td>
<td align="right"><strong style="font-size: medium">质押银行:</strong></td><td>
<input type="text" id="txtZhiYaYinhang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
<td><input type="button" value="••" style="font-size: 13px;width:30px;height:30px; font-family: 楷体; color: #000000; font-weight: bold;" /></td>
</tr>
</table>
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">备注:</strong></td><td>
<input type="text" id="txtBeizhu" style="border-style: hidden hidden outset hidden; border-width: thin; width:400px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div title="订单货品">
<div class="easyui-panel" style="border-style: none; width:auto; height:450px; border-radius:15px 15px 0px 0px;">
<table style="margin-left: 20px; margin-top: 10px;">
<tr>
<td align="right"><strong style="font-size: medium">库房:</strong></td>
<td><input type="text" id="txtKufang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /></td>
<td align="right"><strong style="font-size: medium">加工类型:</strong></td>
<td><input type="text" id="txtJiaGongLeiXing" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /></td>
</tr>
</table>
<table id="tb加工订单货品" class="easyui-datagrid" style="width:auto; height:auto;" data-options="singleSelect:true,scrolling:true,fit:true">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:50,align:'center'"><img src="../../Content/图片/删除.jpg" /></th>
<th data-options="field:'GoodsCoding',width:100,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:100,align:'center'">货品名称</th>
<th data-options="field:'Batch',width:100,align:'center'">批次</th>
<th data-options="field:'Unit',width:100,align:'center'">单位</th>
<th data-options="field:'Quality',width:100,align:'center'">质量</th>
<th data-options="field:'Quantity',width:100,align:'center'">数量</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
jQuery代码:
<script type="text/javascript">
$(document).ready(function () {
XiaLaBangDing();//HTML加载时,预先执行下拉框绑定方法
});
}
function XiaLaBangDing() { //绑定各个订单下拉框的值
//*********************入库查看界面下拉绑定******************//
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=22",
function (data) {
$("#cboDingDanLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=23",
function (data) {
$("#cboJinJiChengDu").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=24",
function (data) {
$("#cboDingDanLaiYuan").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=4",
function (data) {
$("#cboZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=25",
function (data) {
$("#cboZhiXingZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=26",
function (data) {
$("#cboRuKuLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=27",
function (data) {
$("#cboRuKuFangShi").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
//*********************出库查看界面下拉绑定******************//
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=22",
function (data) {
$("#DingDanLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=23",
function (data) {
$("#JinJiChengDu").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=24",
function (data) {
$("#DingDanLaiYuan").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=4",
function (data) {
$("#ZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=25",
function (data) {
$("#ZhiXingZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=28",
function (data) {
$("#cboChuKuLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=29",
function (data) {
$("#cboChuKuFangShi").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
//*********************加工查看界面下拉绑定******************//
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=22",
function (data) {
$("#cboDingDanLeixing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=23",
function (data) {
$("#cboJinJiChengdu").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=24",
function (data) {
$("#cboDingDanLaiyuan").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=4",
function (data) {
$("#cboZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=25",
function (data) {
$("#cboZhiXingZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=34",
function (data) {
$("#cboJiaGongLeixing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
}
function returnBtnChaKan(OrdersInformationID, row, rowIndex) {
return "<a href='javascript:ChaKan(" + OrdersInformationID + "," + rowIndex + ")'>" + '<input type="button" value="【查看】" style="font-size: 15px;width:80px; font-family: 楷体;" />' + "</a>";
}//点击查询界面的查看按钮,执行查看订单信息方法
function ChaKan(OrdersInformationID, rowIndex) {
var row = $("#tb订单查询").datagrid('getSelected');
var ID = row.OrdersTypeID; //获取订单类型ID,根据不同ID查看不同订单信息
try {
switch (ID) {
case 82: //查看入库订单信息
$('#RuKuDingDanChaXun').window('open'); //打开查看界面
$.getJSON("/DingDanChaXun/BindingOrdersInformationByID?OrdersInformationID=" + OrdersInformationID,
function (data) {
$('#txtDingDanHao').attr('value', data[0].OrdersMark);
$('#txtKeHuMa').attr('value', data[0].ClientCode);
$('#txtKeHuZhiLingHao').attr('value', data[0].ClientInstructMark);
$('#txtCaiGouDanHao').attr('value', data[0].PurchaseOrdersNumber);
$('#cboDingDanLeiXing').combobox('setValue', data[0].OrdersTypeID);
$('#cboJinJiChengDu').combobox('setValue', data[0].UrgencyDegreeID);
$('#cboDingDanLaiYuan').combobox('setValue', data[0].OrdersSourceID);
$('#datXiaDaShiJian').datebox('setValue', data[0].XiaDaShiJian);
$('#cboZhuangTai').combobox('setValue', data[0].StateID);
$('#cboZhiXingZhuangTai').combobox('setValue', data[0].ExecuteStateID);
$('#txtDingDanYouXianJi').attr('value', data[0].OrdersPriorLevel);
$('#txtZhiYaYinHang').attr('value', data[0].PledgeBank);
$('#txtBeiZhu').attr('value', data[0].Note);
$.getJSON("/DingDanChaXun/BindingOrdersInformationTableByID?OrdersInformationID=" + OrdersInformationID,
function (data) {//查看订单入库信息
$('#txtKuFang').attr('value', data[0].Storeroom);
$('#cboRuKuLeiXing').combobox('setValue', data[0].WarehousingTypeID);
$('#cboRuKuFangShi').combobox('setValue', data[0].WarehousingWayID);
$('#txtYuJiRuKuShiJian').datebox('setValue', data[0].RuKuShiJian);
$('#txtRuKuBeiZhu').attr('value', data[0].Note);
$("#tb入库订单货品").datagrid({ url: "/DingDanChaXun/BindingOrdersWarehousingDetailed?OrdersWarehousingInformationID=" + data[0].OrdersWarehousingInformationID });//查看订单入库货品信息
});
});
break;
case 83: //查看出库订单信息
$('#ChuKuDingDanChaXun').window('open'); //打开查看界面
$.getJSON("/DingDanChaXun/BindingOrdersInformationByID?OrdersInformationID=" + OrdersInformationID,
function (data) {
$('#DingDanHao').attr('value', data[0].OrdersMark);
$('#KeHuMa').attr('value', data[0].ClientCode);
$('#KeHuZhiLingHao').attr('value', data[0].ClientInstructMark);
$('#CaiGouDanHao').attr('value', data[0].PurchaseOrdersNumber);
$('#DingDanLeiXing').combobox('setValue', data[0].OrdersTypeID);
$('#JinJiChengDu').combobox('setValue', data[0].UrgencyDegreeID);
$('#DingDanLaiYuan').combobox('setValue', data[0].OrdersSourceID);
$('#XiaDaShiJian').datebox('setValue', data[0].XiaDaShiJian);
$('#ZhuangTai').combobox('setValue', data[0].StateID);
$('#ZhiXingZhuangTai').combobox('setValue', data[0].ExecuteStateID);
$('#DingDanYouXianJi').attr('value', data[0].OrdersPriorLevel);
$('#ZhiYaYinHang').attr('value', data[0].PledgeBank);
$('#BeiZhu').attr('value', data[0].Note);
$.getJSON("/DingDanChaXun/BindingOrdersOutboundInformationTable?OrdersInformationID=" + OrdersInformationID,
function (data) {//查看订单出库信息
$('#KuFang').attr('value', data[0].Storeroom);
$('#cboChuKuLeiXing').combobox('setValue', data[0].OutboundTypeID);
$('#cboChuKuFangShi').combobox('setValue', data[0].OutboundWayID);
$('#cboYuJiChuKuShiJian').datebox('setValue', data[0].ChuKuShiJian);
$('#txtChuKuBeiZhu').attr('value', data[0].Note);
$("#tb出库订单货品").datagrid({ url: "/DingDanChaXun/BindingOrdersOutboundDetailed?OrdersOutboundInformationID=" + data[0].OrdersOutboundInformationID });//查看订单出库货品信息
});
});
break;
case 271: //查看加工订单信息
$('#JiaGongDingDanChaXun').window('open'); //打开查看界面
$.getJSON("/DingDanChaXun/BindingOrdersInformationByID?OrdersInformationID=" + OrdersInformationID,
function (data) {
$('#txtDingDanhao').attr('value', data[0].OrdersMark);
$('#txtKeHuma').attr('value', data[0].ClientCode);
$('#txtKeHuZhiLinghao').attr('value', data[0].ClientInstructMark);
$('#txtCaiGouDanhao').attr('value', data[0].PurchaseOrdersNumber);
$('#cboDingDanLeixing').combobox('setValue', data[0].OrdersTypeID);
$('#cboJinJiChengdu').combobox('setValue', data[0].UrgencyDegreeID);
$('#cboDingDanLaiyuan').combobox('setValue', data[0].OrdersSourceID);
$('#datXiaDaShijian').datebox('setValue', data[0].XiaDaShiJian);
$('#cboZhuangtai').combobox('setValue', data[0].StateID);
$('#cboZhiXingZhuangtai').combobox('setValue', data[0].ExecuteStateID);
$('#txtDingDanYouXianji').attr('value', data[0].OrdersPriorLevel);
$('#txtZhiYaYinhang').attr('value', data[0].PledgeBank);
$('#txtBeizhu').attr('value', data[0].Note);
$.getJSON("/DingDanChaXun/BindingMachiningOrdersDetailed?OrdersInformationID=" + data[0].OrdersInformationID,
function (data) {//查看订单加工货品信息
$('#txtKufang').attr('value', data[0].Storeroom);
$('#txtJiaGongLeiXing').attr('value', data[0].MachiningType);
$("#tb加工订单货品").datagrid({ url: "/DingDanChaXun/BindingMachiningGoodsTable?MachiningOrdersDetailedID=" + data[0].MachiningOrdersDetailedID });
});
});
break;
}
} catch (e) {
return null;
}
}
<p><span style="color:blue;"><</span><span style="color:maroon;">script</span> <span style="color:red;">type</span><span style="color:blue;">="text/javascript"></span> <span style="color:darkgreen;">//</span>分页控件代码</p><p> <span style="color:blue;">function</span>getData() {</p><p> <span style="color:blue;">var</span>rows = [];</p><p> <span style="color:blue;">var</span> row= $(<span style="color:maroon;">'#tb</span><span style="color:maroon;">订单查询'</span>).datagrid(<span style="color:maroon;">'getData'</span>);</p><p> <span style="color:blue;">for</span> (<span style="color:blue;">var</span> i = 1; i <= row.rows.length; i++) {</p><p> rows.push({</p><p> OrdersWarehousingInformationID:<span style="color:maroon;">'</span><span style="color:maroon;">入库订单信息ID'</span> + i,</p><p> <span style="color:darkgreen;">//SiteName:$.fn.datebox.defaults.formatter(new Date()),</span></p><p> OrdersMark: <span style="color:maroon;">'</span><span style="color:maroon;">订 单 号 '</span> + i,</p><p> ClientCode: <span style="color:maroon;">'</span><span style="color:maroon;">客 户 码'</span> + i,</p><p> OrdersTypeID: <span style="color:maroon;">'</span><span style="color:maroon;">订单类型ID'</span> + i,</p><p> OrdersType: <span style="color:maroon;">'</span><span style="color:maroon;">订 单 类 型'</span> + i,</p><p> RiQi: <span style="color:maroon;">'</span><span style="color:maroon;">录 入 时 间'</span> + i,</p><p> ExecuteState: <span style="color:maroon;">'</span><span style="color:maroon;">执 行 状 态'</span> + i</p><p> });</p><p> }</p><p> <span style="color:blue;">return</span>rows;//获取数据行数</p><p> }</p><p> <span style="color:blue;">function</span>pagerFilter(data) { //执行上下页翻转</p><p> <span style="color:blue;">if</span> (<span style="color:blue;">typeof</span> data.length == <span style="color:maroon;">'number'</span>&& <span style="color:blue;">typeof</span> data.splice == <span style="color:maroon;">'function'</span>) { <span style="color:darkgreen;">// is array</span></p><p> data = {</p><p> total: data.length,</p><p> rows: data</p><p> }</p><p> }</p><p> <span style="color:blue;">var</span> dg= $(<span style="color:maroon;">'#tb</span><span style="color:maroon;">订单查询'</span>);</p><p> <span style="color:blue;">var</span>opts = dg.datagrid(<span style="color:maroon;">'options'</span>);</p><p> <span style="color:blue;">var</span>pager = dg.datagrid(<span style="color:maroon;">'getPager'</span>);</p><p> pager.pagination({</p><p> onSelectPage: <span style="color:blue;">function</span> (pageNum, pageSize) {</p><p> opts.pageNumber = pageNum;</p><p> opts.pageSize = pageSize;</p><p> pager.pagination(<span style="color:maroon;">'refresh'</span>, {</p><p> pageNumber: pageNum,</p><p> pageSize: pageSize</p><p> });</p><p> dg.datagrid(<span style="color:maroon;">'loadData'</span>, data);</p><p> }</p><p> });</p><p> <span style="color:blue;">if</span>(!data.originalRows) {</p><p> data.originalRows = (data.rows);</p><p> }</p><p> <span style="color:blue;">var</span> start = (opts.pageNumber - 1) *parseInt(opts.pageSize);</p><p> <span style="color:blue;">var</span> end= start + parseInt(opts.pageSize);</p><p> data.rows =(data.originalRows.slice(start, end));</p><p> <span style="color:blue;">return</span>data;</p><p> }</p><p> $(<span style="color:blue;">function</span>() {</p><p> <span style="color:blue;">var</span>pager = $(<span style="color:maroon;">'#tb</span><span style="color:maroon;">订单查询'</span>).datagrid(<span style="color:maroon;">'getPager'</span>); <span style="color:darkgreen;">// getthe pager of datagrid</span></p><p> pager.pagination({ <span style="color:darkgreen;">//</span>分页属性的重写
</p><p> buttons: [{</p><p> iconCls: <span style="color:maroon;">'icon-search'</span>,</p><p> handler: <span style="color:blue;">function</span> () {</p><p> alert(<span style="color:maroon;">'search'</span>);</p><p> }</p><p> }],</p><p> onRefresh: <span style="color:blue;">function</span>() {</p><p> $(<span style="color:maroon;">"#tb</span><span style="color:maroon;">订单查询"</span>).datagrid(<span style="color:maroon;">'reload'</span>);</p><p> },</p><p> displayMsg: <span style="color:maroon;">"</span><span style="color:maroon;">从 {from} </span>到 {to} 共 {total} 项",</p><p> beforePageText: <span style="color:maroon;">"</span><span style="color:maroon;">页"</span>, afterPageText: <span style="color:maroon;">"</span><span style="color:maroon;">共{pages}</span>页"</p><p> });</p><p> });</p><p><span style="color:blue;"></</span><span style="color:maroon;">script</span><span style="color:blue;">></span></p>
此文章只供学习参考,禁止用于商业用途