北京络捷斯特第三方物流信息系统技术解析(十) 作业管理-流通加工作业
2.2.3 流通加工作业
流通加工作业包括加工预处理和加工反馈两个三级模块,流通加工订单主要分为包装、组装、贴签这三种类型。
流通加工作业是基于前面的订单录入中加工订单进行进一步的作业处理。
流通加工作业,对不同加工类型会有不同的操作方式,当该加工类型是包装和组合时,出现的操作界面时相同的,当加工类型是贴签时,则操作界面与前面两者不相同,但基本信息界面都是一样。
流通加工作业订单要先进行预处理操作,当预处理完后,要进一步操作,在加工预处理出现界面进行加工反馈操作,当反馈完成后,整个操作流程才算完成。
加工作业查询界面截图:
2.2.3图(1)
加工预处理查询界面截图:
加工反馈查询界面截图:
流通加工作业功能实现:
第一步:数据库
1、 加工作业表和关系
2、 加工预处理表和关系
3、 加工反馈表和关系
表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) |
| 备注 |
EntryTime | date |
| 录入时间 |
RepairNo | Bit |
| 补录否 |
表2:加工预调度表(PW_MachiningWarningSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningSchedulingID | int | 主键 | 加工预调度ID |
MachiningOrdersInformationID | int | 外键 | 加工信息ID |
WorkPlanNumber | nchar(50) |
| 作业计划单号 |
MachiningTypeID | int |
| 加工类型ID |
表3:加工预拣货调度表(PW_MachiningWarningChooseGoodsSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningChooseGoodsSchedulingID | int | 主键 | 加工预拣货调度ID |
MachiningGoodsID | int | 外键 | 加工货品ID |
MachiningWarningSchedulingID | int | 外键 | 加工预调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
表4:加工预上架调度表(PW_MachiningWarningGroundingSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningGroundingSchedulingID | int | 主键 | 加工预上架调度ID |
MachiningGoodsID | int | 外键 | 加工货品ID |
MachiningWarningSchedulingID | int | 外键 | 加工预调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
表5:加工预资源调度表(PW_MachiningWarningResourceSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningResourceSchedulingID | int | 主键 | 加工预资源调度ID |
MachiningWarningSchedulingID | int | 外键 | 加工预调度ID |
NeedGrossWeight | decimal(18, 2) |
| 需要总重量 |
NeedGrossBulk | decimal(18, 2) |
| 需要总体积 |
表6:加工预作业表(PW_MachiningWarningWorkTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningWorkID | int | 主键 | 加工预作业ID |
MachiningWarningResourceSchedulingID | int | 外键 | 加工预资源调度ID |
WorkNumber | nchar(50) |
| 作业单号 |
OperateTypeID | int | 外键 | 操作类型ID |
表7:加工预贴签明细表(PW_MachiningWarningLabelDetailedTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWarningLabelDetailedID | int | 主键 | 加工预贴签明细ID |
MachiningWarningSchedulingID | int | 外键 | 加工预调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
MachiningQuantity | decimal(18, 2) |
| 加工数量 |
表7:加工调度表(PW_MachiningSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningSchedulingID | int | 主键 | 加工调度ID |
MachiningOrdersInformationID | int | 外键 | 加工信息ID |
WorkPlanNumber | nchar(50) |
| 作业计划单号 |
MachiningTypeID | int |
| 加工类型ID |
表8:加工拣货调度表(PW_MachiningChooseGoodsSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningChooseGoodsSchedulingID | int | 主键 | 加工拣贷调度ID |
MachiningSchedulingID | int | 外键 | 加工调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
表9:加工上架调度表ID(PW_MachiningGroundingSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningGroundingScheduling | int | 主键 | 加工上架调度ID |
MachiningSchedulingID | int | 外键 | 加工调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
表10:加工资源调度表(PW_MachiningResourceSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningResourceSchedulingID | int | 主键 | 加工资源调度ID |
MachiningSchedulingID | int | 外键 | 加工调度ID |
NeedGrossWeight | decimal(18, 2) |
| 需要总重量 |
NeedGrossBulk | decimal(18, 2) |
| 需要总体积 |
表11:加工作业表(PW_MachiningWorkTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningWorkID | int | 主键 | 加工作业ID |
MachiningResourceSchedulingID | int | 外键 | 加工资源调度ID |
WorkNumber | nchar(50) |
| 作业单号 |
OperateTypeID | int | 外键 | 操作类型ID |
表11:加工贴签调度表(PW_MachiningLabelSchedulingTable)
列名 | 数据类型 | 主键/外键 | 说明 |
MachiningLabelSchedulingID | int | 主键 | 加工贴签调度ID |
MachiningSchedulingID | int | 外键 | 加工调度ID |
StorageID | int | 外键 | 储位ID |
Batch | nchar(50) |
| 批次 |
QualityID | int | 外键 | 质量ID |
Quantity | decimal(18, 2) |
| 数量 |
MachiningTypeID | int | 外键 | 加工类型ID |
GoodsID | int | 外键 | 货品ID |
MachiningQuantity | decimal(18, 2) |
| 加工数量 |
第二步:控制器(Controllers)
Contrlles(控制器)代码:
#region 模糊查询基本信息
/// <summary>
/// 根据界面层传过来的参数查询加工订单的基本信息,如果界面没有传参过来,查询全部加工基本信息
/// </summary>
/// <param name="NeiRong">内容</param>
/// <returns>Json</returns>
public ActionResult ChaXunJiBenXinXi(string NeiRong)
{
var dtOrdersInformation = from tbOrdersInformation in myJGZY.PW_OrdersInformationTable //linq语法建立多表之间的关系
join tbMachiningOrdersDetailed in myJGZY.PW_MachiningOrdersDetailedTable on tbOrdersInformation.OrdersInformationID equals tbMachiningOrdersDetailed.MachiningOrdersInformationID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbMachiningOrdersDetailed.MachiningTypeID equals tbMachiningType.AttributeDetailedID
join tbStoreroom in myJGZY.SYS_StoreroomTable on tbMachiningOrdersDetailed.StoreroomID equals tbStoreroom.StoreroomID
join tbClient in myJGZY.SYS_ClientTable on tbOrdersInformation.ClientID equals tbClient.ClientID
join tbOrdersType in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbState in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.StateID equals tbState.AttributeDetailedID
join tbOrdersSource in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.OrdersSourceID equals tbOrdersSource.AttributeDetailedID
join tbPledgeBank in myJGZY.SYS_BankTable on tbOrdersInformation.PledgeBankID equals tbPledgeBank.BankID
select new
{
OrdersInformationID = tbOrdersInformation.OrdersInformationID,
MachiningOrdersDetailedID = tbMachiningOrdersDetailed.MachiningOrdersDetailedID,
MachiningTypeID = tbMachiningOrdersDetailed.MachiningTypeID,
OrdersMark = tbOrdersInformation.OrdersMark,
ClientID = tbOrdersInformation.ClientID,
ClientCode = tbClient.ClientCode,
MachiningType = tbMachiningType.AttributeDetailedName,
OrdersType = tbOrdersType.AttributeDetailedName,
State = tbState.AttributeDetailedName,
OrdersSource = tbOrdersSource.AttributeDetailedName,
StoreroomCoding = tbStoreroom.StoreroomCoding,
PledgeBank = tbPledgeBank.BankName,
Note = tbOrdersInformation.Note
};
if (NeiRong != "")//满足条件则按条件查询,条件不满足则查询全部
{
dtOrdersInformation = dtOrdersInformation.Where(tbOrders => tbOrders.OrdersMark.Contains(NeiRong.Trim()));
}
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrdersInformation)
{
Dictionary<string, object> itemOrdersInformation = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrdersInformation.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemOrdersInformation);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询库存、区和储位
/// <summary>
/// 根据界面层传过来的参数查询储位信息
/// </summary>
/// <param name="StoreroomID">库房ID</param>
/// <returns>Json</returns>
public ActionResult SelectStoreroom(int StoreroomID)
{
var dtZuoYe = from tbZuoYe in myJGZY.SYS_StoreroomTable
join tbDistrict in myJGZY.SYS_DistrictTable on tbZuoYe.StoreroomID equals tbDistrict.StoreroomID
join tbStorage in myJGZY.SYS_StorageTable on tbDistrict.DistrictID equals tbStorage.DistrictID
where tbZuoYe.StoreroomID == StoreroomID
select new
{
StoreroomID = tbZuoYe.StoreroomID,
DistrictID = tbDistrict.DistrictID,
DistrictCoding = tbDistrict.DistrictCoding,
DistrictName = tbDistrict.DistrictName,
Cubage = tbDistrict.Cubage,
BearWeight = tbDistrict.BearWeight,
StorageID = tbStorage.StorageID,
StorageNumber = tbStorage.StorageNumber
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 修改加工货品库存数量
/// <summary>
/// 修改加工货品出库数量,当加工货品上架时,库存数减少
/// </summary>
/// <param name="MachiningGoodsID">加工货品ID</param>
/// <param name="ShenYuShuLiang">剩余数量</param>
/// <returns>Json</returns>
public ActionResult UdataShuLian(int MachiningGoodsID, decimal ShenYuShuLiang)
{
var dtZuoYe = (from tbZuoYe in myJGZY.PW_MachiningGoodsTable
where tbZuoYe.MachiningGoodsID == MachiningGoodsID
select tbZuoYe).Single<Models.PW_MachiningGoodsTable>();
Decimal Quantity = Convert.ToDecimal(dtZuoYe.Quantity);
dtZuoYe.Quantity = Quantity - ShenYuShuLiang;
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
/// <summary>
/// 当取消加工货品上架时,恢复库存数量,库存增加
/// </summary>
/// <param name="MachiningGoodsID">加工货品ID</param>
/// <param name="ShenYuShuLiang">剩余数量</param>
/// <returns>Json</returns>
public ActionResult UdataQuantity(int MachiningGoodsID, decimal ShenYuShuLiang)
{
var dtZuoYe = (from tbZuoYe in myJGZY.PW_MachiningGoodsTable
where tbZuoYe.MachiningGoodsID == MachiningGoodsID
select tbZuoYe).Single<Models.PW_MachiningGoodsTable>();
Decimal Quantity = Convert.ToDecimal(dtZuoYe.Quantity);
dtZuoYe.Quantity = Quantity + ShenYuShuLiang;
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 查询加工预处理待调度货品
/// <summary>
/// 查询加工预处理所需要的待调度和待上架货品
/// </summary>
/// <param name="MachiningOrdersInformationID">加工订单信息ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningGoods(int MachiningOrdersInformationID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningGoodsTable
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQuality in myJGZY.SYS_AttributeDetailedTable on tbGoods.QualityID equals tbQuality.AttributeDetailedID
where tbZuoYe.MachiningOrdersInformationID == MachiningOrdersInformationID
select new
{
MachiningGoodsID = tbZuoYe.MachiningGoodsID,
MachiningOrdersInformationID = tbZuoYe.MachiningOrdersInformationID,
GoodsID = tbZuoYe.GoodsID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.Quantity,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Weight = tbGoods.Weight,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
QualityID = tbGoods.QualityID,
Quality = tbQuality.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID查询库存
/// <summary>
/// 点击界面查看库存,可以查询该货品在库存的信息和数量等
/// </summary>
/// <param name="GoodsID">货品ID</param>
/// <returns>Json</returns>
public ActionResult SelectInventory(int GoodsID)
{
var dtZuoYe = from tbZuoYe in myJGZY.SYS_InventoryTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbStorage.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQuality in myJGZY.SYS_AttributeDetailedTable on tbGoods.QualityID equals tbQuality.AttributeDetailedID
where tbStorage.GoodsID == GoodsID
select new
{
JustGradeMeasure = tbZuoYe.JustGradeMeasure,
InferiorGradeMeasure = tbZuoYe.InferiorGradeMeasure,
StorageID = tbZuoYe.StorageID,
DistrictID = tbStorage.DistrictID,
GoodsID = tbStorage.GoodsID,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Weight = tbGoods.Weight,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
QualityID = tbGoods.QualityID,
Quality = tbQuality.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工预作业
/// <summary>
/// 将加工预处理的作业信息查询出来
/// </summary>
/// <returns>Json</returns>
public ActionResult SelectMachiningWarningWork()
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningWarningWorkTable
join tbOperateType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.OperateTypeID equals tbOperateType.AttributeDetailedID
select new
{
MachiningWarningWorkID = tbZuoYe.MachiningWarningWorkID,
MachiningWarningResourceSchedulingID = tbZuoYe.MachiningWarningResourceSchedulingID,
WorkNumber = tbZuoYe.WorkNumber,
OperateTypeID = tbZuoYe.OperateTypeID,
OperateType = tbOperateType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 通过ID绑定基本信息
/// <summary>
/// 打开加工预处理界面时,将该订单的基本信息绑定在界面上
/// </summary>
/// <param name="MachiningOrdersInformationID">加工订单信息ID</param>
/// <returns>Json</returns>
public ActionResult BangDingDinDanXinXiByID(int MachiningOrdersInformationID)
{
var dtOrdersInformation = from tbOrdersInformation in myJGZY.PW_OrdersInformationTable
join tbMachiningOrdersDetailed in myJGZY.PW_MachiningOrdersDetailedTable on tbOrdersInformation.OrdersInformationID equals tbMachiningOrdersDetailed.MachiningOrdersInformationID
join tbStoreroom in myJGZY.SYS_StoreroomTable on tbMachiningOrdersDetailed.StoreroomID equals tbStoreroom.StoreroomID
join tbClient in myJGZY.SYS_ClientTable on tbOrdersInformation.ClientID equals tbClient.ClientID
join tbOrdersType in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbState in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.StateID equals tbState.AttributeDetailedID
join tbPledgeBank in myJGZY.SYS_BankTable on tbOrdersInformation.PledgeBankID equals tbPledgeBank.BankID
where tbOrdersInformation.OrdersInformationID == MachiningOrdersInformationID
select new
{
OrdersInformationID = tbOrdersInformation.OrdersInformationID,
StoreroomID = tbMachiningOrdersDetailed.StoreroomID,
OrdersMark = tbOrdersInformation.OrdersMark,
ClientID = tbOrdersInformation.ClientID,
ClientCode = tbClient.ClientCode,
OrdersType = tbOrdersType.AttributeDetailedName,
State = tbState.AttributeDetailedName,
StoreroomCoding = tbStoreroom.StoreroomCoding,
PledgeBank = tbPledgeBank.BankName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtOrdersInformation)
{
Dictionary<string, object> itemOrdersInformation = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemOrdersInformation.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemOrdersInformation);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工预调度和加工预资源调度
/// <summary>
/// 加工预处理查询界面,查询加工预处理的订单,界面层传过来参数则根据参数查询,反之查询全部。
/// </summary>
/// <param name="NeiRong">内容</param>
/// <returns>Json</returns>
public ActionResult SelectWarningOutboundTreatment(string NeiRong)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningWarningSchedulingTable
join tbOrdersInformation in myJGZY.PW_OrdersInformationTable on tbZuoYe.MachiningOrdersInformationID equals tbOrdersInformation.OrdersInformationID
join tbMachiningOrdersDetailed in myJGZY.PW_MachiningOrdersDetailedTable on tbZuoYe.MachiningOrdersInformationID equals tbMachiningOrdersDetailed.MachiningOrdersInformationID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbMachiningOrdersDetailed.MachiningTypeID equals tbMachiningType.AttributeDetailedID
join tbClient in myJGZY.SYS_ClientTable on tbOrdersInformation.ClientID equals tbClient.ClientID
join tbOrdersType in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbState in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.StateID equals tbState.AttributeDetailedID
join tbPledgeBank in myJGZY.SYS_BankTable on tbOrdersInformation.PledgeBankID equals tbPledgeBank.BankID
join tbWarningOutboundResourceScheduling in myJGZY.PW_MachiningWarningResourceSchedulingTable on tbZuoYe.MachiningWarningSchedulingID equals tbWarningOutboundResourceScheduling.MachiningWarningSchedulingID
select new
{
MachiningWarningSchedulingID = tbZuoYe.MachiningWarningSchedulingID,
OrdersInformationID = tbZuoYe.MachiningOrdersInformationID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
MachiningOrdersDetailedID = tbMachiningOrdersDetailed.MachiningOrdersDetailedID,
MachiningType = tbMachiningType.AttributeDetailedName,
WorkPlanNumber = tbZuoYe.WorkPlanNumber,
OrdersMark = tbOrdersInformation.OrdersMark,
ClientID = tbOrdersInformation.ClientID,
ClientCode = tbClient.ClientCode,
OrdersType = tbOrdersType.AttributeDetailedName,
State = tbState.AttributeDetailedName,
PledgeBank = tbPledgeBank.BankName,
NeedGrossWeight = tbWarningOutboundResourceScheduling.NeedGrossWeight,
NeedGrossBulk = tbWarningOutboundResourceScheduling.NeedGrossBulk
};
if (NeiRong != "")
{
dtZuoYe = dtZuoYe.Where(tbOrders => tbOrders.WorkPlanNumber.Contains(NeiRong.Trim()));
}
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询预拣货调度明细
/// <summary>
/// 界面层传参数过来,根据加工类型ID和加工预处理ID查询预处理后的拣货明细
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预处理ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningWarningChooseGoodsScheduling(int MachiningWarningSchedulingID,int MachiningTypeID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningWarningChooseGoodsSchedulingTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningWarningSchedulingID == MachiningWarningSchedulingID && tbZuoYe.MachiningTypeID == MachiningTypeID
select new
{
MachiningWarningChooseGoodsSchedulingID = tbZuoYe.MachiningWarningChooseGoodsSchedulingID,
MachiningWarningSchedulingID = tbZuoYe.MachiningWarningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.Quantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
QualityState = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工预上架调度明细
/// <summary>
/// 界面层传参数过来,根据加工类型ID和加工预处理ID查询预处理后的上架明细
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预处理ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningWarningGroundingScheduling(int MachiningWarningSchedulingID, int MachiningTypeID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningWarningGroundingSchedulingTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningWarningSchedulingID == MachiningWarningSchedulingID && tbZuoYe.MachiningTypeID == MachiningTypeID
select new
{
MachiningWarningGroundingSchedulingID = tbZuoYe.MachiningWarningGroundingSchedulingID,
MachiningWarningSchedulingID = tbZuoYe.MachiningWarningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.Quantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
QualityState = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工预贴签明细
/// <summary>
/// 当界面层传过来的参数符合要求时,则会查询加工贴签的明细信息
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预处理ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningWarningLabelDetailed(int MachiningWarningSchedulingID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningWarningLabelDetailedTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select new
{
MachiningWarningLabelDetailedID = tbZuoYe.MachiningWarningLabelDetailedID,
MachiningWarningSchedulingID = tbZuoYe.MachiningWarningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.MachiningQuantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
QualityState = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 新增加工预调度表
/// <summary>
/// 接收界面层参数,新增加工预处理信息,返回该数据的主键ID
/// </summary>
/// <param name="MachiningOrdersInformationID">加工信息ID</param>
/// <param name="WorkPlanNumber">作业计划单号</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <returns></returns>
public int InsertMachiningWarningScheduling(int MachiningOrdersInformationID, string WorkPlanNumber, int MachiningTypeID)
{
Models.PW_MachiningWarningSchedulingTable myZuoYe = new Models.PW_MachiningWarningSchedulingTable();
myZuoYe.MachiningOrdersInformationID = MachiningOrdersInformationID;
myZuoYe.WorkPlanNumber = WorkPlanNumber;
myZuoYe.MachiningTypeID = MachiningTypeID;
myJGZY.PW_MachiningWarningSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
int MachiningWarningSchedulingID = (from tbID in myJGZY.PW_MachiningWarningSchedulingTable select tbID.MachiningWarningSchedulingID).Max();
return MachiningWarningSchedulingID;//返回新增数据的主键ID值
}
else
{
return 0;
}
}
#endregion
#region 新增加工预拣货调度表
/// <summary>
/// 在进行预处理时,接收界面层传过来的参数,新增加工拣货的货品
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <param name="MachiningGoodsID">加工货品ID</param>
/// <returns></returns>
public ActionResult InsertMachiningWarningChooseGoodsScheduling(int MachiningWarningSchedulingID, int MachiningTypeID,
int StorageID, int GoodsID, decimal Batch,decimal Quantity,
int QualityID, int MachiningGoodsID)
{
//实例化数据库表
Models.PW_MachiningWarningChooseGoodsSchedulingTable myZuoYe = new Models.PW_MachiningWarningChooseGoodsSchedulingTable();
myZuoYe.MachiningWarningSchedulingID = MachiningWarningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myZuoYe.MachiningGoodsID = MachiningGoodsID;
myJGZY.PW_MachiningWarningChooseGoodsSchedulingTable.AddObject(myZuoYe);//新增数据进数据库表
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工预上架调度表
/// <summary>
/// 对加工订单进行预处理时,接收界面层参数,对加工的上架货品进行调度
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <param name="MachiningGoodsID">加工货品ID</param>
/// <returns></returns>
public ActionResult InsertMachiningWarningGroundingScheduling(int MachiningWarningSchedulingID, int MachiningTypeID,
int StorageID, int GoodsID, decimal Batch,decimal Quantity,
int QualityID, int MachiningGoodsID)
{
Models.PW_MachiningWarningGroundingSchedulingTable myZuoYe = new Models.PW_MachiningWarningGroundingSchedulingTable();
myZuoYe.MachiningWarningSchedulingID = MachiningWarningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myZuoYe.MachiningGoodsID = MachiningGoodsID;
myJGZY.PW_MachiningWarningGroundingSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工预贴签明细表
/// <summary>
/// 当加工类型是贴签时,对加工订单货品进行预处理贴签
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="MachiningQuantity">加工数量</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <returns></returns>
public ActionResult InsertMachiningWarningLabelDetailed(int MachiningWarningSchedulingID, int MachiningTypeID,
int StorageID, int GoodsID, decimal Batch,
decimal MachiningQuantity, decimal Quantity, int QualityID)
{
Models.PW_MachiningWarningLabelDetailedTable myZuoYe = new Models.PW_MachiningWarningLabelDetailedTable();
myZuoYe.MachiningWarningSchedulingID = MachiningWarningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.MachiningQuantity = MachiningQuantity;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myJGZY.PW_MachiningWarningLabelDetailedTable.AddObject(myZuoYe);//新增预处理的货品贴签
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工预资源调度表
/// <summary>
/// 加工预处理需要知道要用到多少资源,对该预处理进行一个资源汇总
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <param name="NeedGrossWeight">需要总重量</param>
/// <param name="NeedGrossBulk">需要总体积</param>
/// <returns></returns>
public int InsertMachiningWarningResourceScheduling(int MachiningWarningSchedulingID, decimal NeedGrossWeight, decimal NeedGrossBulk)
{
Models.PW_MachiningWarningResourceSchedulingTable myZuoYe = new Models.PW_MachiningWarningResourceSchedulingTable();
myZuoYe.MachiningWarningSchedulingID = MachiningWarningSchedulingID;
myZuoYe.NeedGrossWeight = NeedGrossWeight;
myZuoYe.NeedGrossBulk = NeedGrossBulk;
myJGZY.PW_MachiningWarningResourceSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
int MachiningWarningResourceSchedulingID = (from tbID in myJGZY.PW_MachiningWarningResourceSchedulingTable select tbID.MachiningWarningResourceSchedulingID).Max();
return MachiningWarningResourceSchedulingID;//新增该数据,返回该数据的主键ID值
}
else
{
return 0;
}
}
#endregion
#region 删除出库预处理表
/// <summary>
/// 点击界面删除图标,根据加工预调度ID将该数据从数据库删除,连带子表的数据一起删除
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <returns>Json</returns>
public ActionResult DelectMachiningWarningScheduling(int MachiningWarningSchedulingID)
{
var dtOrders = (from tbOrders in myJGZY.PW_MachiningWarningSchedulingTable
where tbOrders.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select tbOrders).Single<Models.PW_MachiningWarningSchedulingTable>();
myJGZY.DeleteObject(dtOrders);//删除该表的数据
int i = myJGZY.SaveChanges();//当删除成功时,i会大于0
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除加工预调度明细
/// <summary>
/// 根据加工预调度ID将加工预处理的拣货货品信息删除
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <returns>Json</returns>
public ActionResult DelectMachiningWarningChooseGoodsScheduling(int MachiningWarningSchedulingID)
{
var dtOrders = (from tbOrders in myJGZY.PW_MachiningWarningChooseGoodsSchedulingTable
where tbOrders.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select tbOrders).ToList<Models.PW_MachiningWarningChooseGoodsSchedulingTable>();
for (int j = 0; j < dtOrders.Count; j++)//货品信息可能有多条,要循环删除
{
myJGZY.DeleteObject(dtOrders[j]);
}
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除加工预上架明细
/// <summary>
/// 根据加工预调度ID将加工预处理的上架货品信息删除
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <returns>Json</returns>
public ActionResult DelectMachiningWarningGroundingScheduling(int MachiningWarningSchedulingID)
{
var dtOrders = (from tbOrders in myJGZY.PW_MachiningWarningGroundingSchedulingTable
where tbOrders.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select tbOrders).ToList<Models.PW_MachiningWarningGroundingSchedulingTable>();
for (int j = 0; j < dtOrders.Count; j++)//货品信息可能有多条,要循环删除
{
myJGZY.DeleteObject(dtOrders[j]);
}
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除加工预贴签明细
/// <summary>
/// 根据加工预调度ID将加工预处理的贴签货品信息删除
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <returns>Json</returns>
public ActionResult DelectMachiningWarningLabelDetailed(int MachiningWarningSchedulingID)
{
var dtOrders = (from tbOrders in myJGZY.PW_MachiningWarningLabelDetailedTable
where tbOrders.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select tbOrders).ToList<Models.PW_MachiningWarningLabelDetailedTable>();
for (int j = 0; j < dtOrders.Count; j++)//货品信息可能有多条,要循环删除
{
myJGZY.DeleteObject(dtOrders[j]);
}
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 删除加工预资源调度
/// <summary>
/// 根据加工预调度ID将加工预处理的所需资源删除
/// </summary>
/// <param name="MachiningWarningSchedulingID">加工预调度ID</param>
/// <returns></returns>
public ActionResult DelectMachiningWarningResourceScheduling(int MachiningWarningSchedulingID)
{
var dtOrders = (from tbOrders in myJGZY.PW_MachiningWarningResourceSchedulingTable
where tbOrders.MachiningWarningSchedulingID == MachiningWarningSchedulingID
select tbOrders).Single<Models.PW_MachiningWarningResourceSchedulingTable>();
myJGZY.DeleteObject(dtOrders);
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
//加工反馈部分//
#region 查询加工调度和加工资源调度
/// <summary>
/// 反馈查询界面,接收接收界面层传过来的参数,根据参数继续模糊查询
/// </summary>
/// <param name="NeiRong">内容</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningScheduling(string NeiRong)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningSchedulingTable
join tbOrdersInformation in myJGZY.PW_OrdersInformationTable on tbZuoYe.MachiningOrdersInformationID equals tbOrdersInformation.OrdersInformationID
join tbMachiningOrdersDetailed in myJGZY.PW_MachiningOrdersDetailedTable on tbOrdersInformation.OrdersInformationID equals tbMachiningOrdersDetailed.MachiningOrdersInformationID
join tbClient in myJGZY.SYS_ClientTable on tbOrdersInformation.ClientID equals tbClient.ClientID
join tbOrdersType in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.OrdersTypeID equals tbOrdersType.AttributeDetailedID
join tbState in myJGZY.SYS_AttributeDetailedTable on tbOrdersInformation.StateID equals tbState.AttributeDetailedID
join tbPledgeBank in myJGZY.SYS_BankTable on tbOrdersInformation.PledgeBankID equals tbPledgeBank.BankID
join tbWarningOutboundResourceScheduling in myJGZY.PW_MachiningResourceSchedulingTable on tbZuoYe.MachiningSchedulingID equals tbWarningOutboundResourceScheduling.MachiningSchedulingID
select new
{
MachiningSchedulingID = tbZuoYe.MachiningSchedulingID,
MachiningOrdersInformationID = tbZuoYe.MachiningOrdersInformationID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
MachiningOrdersDetailedID = tbMachiningOrdersDetailed.MachiningOrdersDetailedID,
WorkPlanNumber = tbZuoYe.WorkPlanNumber,
OrdersMark = tbOrdersInformation.OrdersMark,
ClientID = tbOrdersInformation.ClientID,
ClientCode = tbClient.ClientCode,
OrdersType = tbOrdersType.AttributeDetailedName,
State = tbState.AttributeDetailedName,
PledgeBank = tbPledgeBank.BankName,
NeedGrossWeight = tbWarningOutboundResourceScheduling.NeedGrossWeight,
NeedGrossBulk = tbWarningOutboundResourceScheduling.NeedGrossBulk
};
if (NeiRong != "")//当界面层传过来的参数不为空时,根据参数查询,当参数为空时,查询全部数据
{
dtZuoYe = dtZuoYe.Where(tbOrders => tbOrders.WorkPlanNumber.Contains(NeiRong.Trim()));
}
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工拣货调度明细
/// <summary>
/// 在反馈查询界面,当单击其中一条数据时,当加工类型是组合和包装时,可以将这条数据的拣货的明细查询出来
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningChooseGoodsScheduling(int MachiningSchedulingID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningChooseGoodsSchedulingTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningSchedulingID == MachiningSchedulingID
select new
{
MachiningChooseGoodsSchedulingID = tbZuoYe.MachiningChooseGoodsSchedulingID,
MachiningSchedulingID = tbZuoYe.MachiningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.Quantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
Quality = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工上架调度明细
/// <summary>
/// 在反馈查询界面,当单击其中一条数据时,当加工类型是组合和包装时,可以将这条数据的上架的明细查询出来
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningGroundingScheduling(int MachiningSchedulingID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningGroundingSchedulingTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningSchedulingID == MachiningSchedulingID
select new
{
MachiningGroundingScheduling = tbZuoYe.MachiningGroundingScheduling,
MachiningSchedulingID = tbZuoYe.MachiningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.Quantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
Quality = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 查询加工贴签调度明细
/// <summary>
/// 在反馈查询界面,当单击其中一条数据时,当加工类型贴签时,可以将这条数据的贴签的明细查询出来
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <returns>Json</returns>
public ActionResult SelectMachiningLabelScheduling(int MachiningSchedulingID)
{
var dtZuoYe = from tbZuoYe in myJGZY.PW_MachiningLabelSchedulingTable
join tbStorage in myJGZY.SYS_StorageTable on tbZuoYe.StorageID equals tbStorage.StorageID
join tbDistrict in myJGZY.SYS_DistrictTable on tbStorage.DistrictID equals tbDistrict.DistrictID
join tbGoods in myJGZY.SYS_GoodsTable on tbZuoYe.GoodsID equals tbGoods.GoodsID
join tbUnit in myJGZY.SYS_AttributeDetailedTable on tbGoods.UnitID equals tbUnit.AttributeDetailedID
join tbQualityState in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.QualityID equals tbQualityState.AttributeDetailedID
join tbMachiningType in myJGZY.SYS_AttributeDetailedTable on tbZuoYe.MachiningTypeID equals tbMachiningType.AttributeDetailedID
where tbZuoYe.MachiningSchedulingID == MachiningSchedulingID
select new
{
MachiningLabelSchedulingID = tbZuoYe.MachiningLabelSchedulingID,
MachiningSchedulingID = tbZuoYe.MachiningSchedulingID,
MachiningTypeID = tbZuoYe.MachiningTypeID,
StorageID = tbZuoYe.StorageID,
GoodsID = tbZuoYe.GoodsID,
QualityID = tbZuoYe.QualityID,
Batch = tbZuoYe.Batch,
Quantity = tbZuoYe.MachiningQuantity,
StorageNumber = tbStorage.StorageNumber,
DistrictCoding = tbDistrict.DistrictCoding,
GoodsCoding = tbGoods.GoodsCoding,
GoodsName = tbGoods.GoodsName,
Standard = tbGoods.Standard,
Model = tbGoods.Model,
UnitID = tbGoods.UnitID,
Unit = tbUnit.AttributeDetailedName,
Quality = tbQualityState.AttributeDetailedName,
MachiningType = tbMachiningType.AttributeDetailedName
};
List<Dictionary<string, object>> ListReturn = new List<Dictionary<string, object>>();
foreach (var item in dtZuoYe)
{
Dictionary<string, object> itemZuoYe = new Dictionary<string, object>();
foreach (System.Reflection.PropertyInfo p in item.GetType().GetProperties())
{
itemZuoYe.Add(p.Name, p.GetValue(item, null));
}
ListReturn.Add(itemZuoYe);
}
return Json(ListReturn, JsonRequestBehavior.AllowGet);
}
#endregion
#region 新增加工调度
/// <summary>
/// 预处理完成后,对预处理在进行反馈操作,新增一条反馈的信息
/// </summary>
/// <param name="MachiningOrdersInformationID">加工信息ID</param>
/// <param name="WorkPlanNumber">作业计划单号</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <returns>int</returns>
public int InsertMachiningScheduling(int MachiningOrdersInformationID, string WorkPlanNumber, int MachiningTypeID)
{
Models.PW_MachiningSchedulingTable myZuoYe = new Models.PW_MachiningSchedulingTable();
myZuoYe.MachiningOrdersInformationID = MachiningOrdersInformationID;
myZuoYe.WorkPlanNumber = WorkPlanNumber;
myZuoYe.MachiningTypeID = MachiningTypeID;
myJGZY.PW_MachiningSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
int MachiningSchedulingID = (from tbID in myJGZY.PW_MachiningSchedulingTable select tbID.MachiningSchedulingID).Max();
return MachiningSchedulingID;//当新增一行数据完成后,返回该数据的主键ID值
}
else
{
return 0;
}
}
#endregion
#region 新增加工拣货调度表
/// <summary>
/// 新增加工反馈的加工拣货明细信息,接收界面层层参数,新增数据
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <returns>Json</returns>
public ActionResult InsertMachiningChooseGoodsScheduling(int MachiningSchedulingID, int MachiningTypeID,int StorageID,
int GoodsID, decimal Batch, decimal Quantity,int QualityID)
{
Models.PW_MachiningChooseGoodsSchedulingTable myZuoYe = new Models.PW_MachiningChooseGoodsSchedulingTable();
myZuoYe.MachiningSchedulingID = MachiningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myJGZY.PW_MachiningChooseGoodsSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工上架调度表
/// <summary>
/// 新增加工反馈的加工上架明细信息,接收界面层层参数,新增数据
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <returns>Json</returns>
public ActionResult InsertMachiningGroundingScheduling(int MachiningSchedulingID, int MachiningTypeID,
int StorageID, int GoodsID, decimal Batch,
decimal Quantity, int QualityID)
{
Models.PW_MachiningGroundingSchedulingTable myZuoYe = new Models.PW_MachiningGroundingSchedulingTable();
myZuoYe.MachiningSchedulingID = MachiningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myJGZY.PW_MachiningGroundingSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工贴签明细表
/// <summary>
/// 当加工类型是贴签时,新增贴签明细信息,接收界面层参数,新增数据
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <param name="MachiningTypeID">加工类型ID</param>
/// <param name="StorageID">储位ID</param>
/// <param name="GoodsID">货品ID</param>
/// <param name="Batch">批次</param>
/// <param name="MachiningQuantity">加工数量</param>
/// <param name="Quantity">数量</param>
/// <param name="QualityID">质量ID</param>
/// <returns>Json</returns>
public ActionResult InsertMachiningLabelScheduling(int MachiningSchedulingID, int MachiningTypeID,
int StorageID, int GoodsID, decimal Batch,
decimal MachiningQuantity, decimal Quantity, int QualityID)
{
Models.PW_MachiningLabelSchedulingTable myZuoYe = new Models.PW_MachiningLabelSchedulingTable();
myZuoYe.MachiningSchedulingID = MachiningSchedulingID;
myZuoYe.MachiningTypeID = MachiningTypeID;
myZuoYe.StorageID = StorageID;
myZuoYe.GoodsID = GoodsID;
myZuoYe.Batch = Batch;
myZuoYe.MachiningQuantity = MachiningQuantity;
myZuoYe.Quantity = Quantity;
myZuoYe.QualityID = QualityID;
myJGZY.PW_MachiningLabelSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
return Json("true", JsonRequestBehavior.AllowGet);
}
else
{
return Json("false", JsonRequestBehavior.AllowGet);
}
}
#endregion
#region 新增加工资源调度表
/// <summary>
/// 加工反馈时所确定的资源,需要总数量和需要总体积
/// </summary>
/// <param name="MachiningSchedulingID">加工调度ID</param>
/// <param name="NeedGrossWeight">需要总数量</param>
/// <param name="NeedGrossBulk">需要总体积</param>
/// <returns>int</returns>
public int InsertMachiningResourceScheduling(int MachiningSchedulingID, decimal NeedGrossWeight, decimal NeedGrossBulk)
{
Models.PW_MachiningResourceSchedulingTable myZuoYe = new Models.PW_MachiningResourceSchedulingTable();
myZuoYe.MachiningSchedulingID = MachiningSchedulingID;
myZuoYe.NeedGrossWeight = NeedGrossWeight;
myZuoYe.NeedGrossBulk = NeedGrossBulk;
myJGZY.PW_MachiningResourceSchedulingTable.AddObject(myZuoYe);
int i = myJGZY.SaveChanges();
if (i > 0)
{
int MachiningResourceSchedulingID = (from tbID in myJGZY.PW_MachiningResourceSchedulingTable select tbID.MachiningResourceSchedulingID).Max();
return MachiningResourceSchedulingID;//返回该数据的主键ID值
}
else
{
return 0;
}
}
#endregion
第三步:视图层(Views)
流通加工作业界面效果图:
2.2.3图(9)
流通加工作业预处理界面效果图:
2.2.3图(10)
流通加工作业反馈界面效果图:
2.2.3图(10)
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 id="tbChuKuZuoYe" class="easyui-tabs" style="border-style: none; margin-top: -18px; margin-left: -17px; margin-right: -18px;">
<div title="加工作业" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 20px; margin-top: 5px;">
<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><input type="button" οnclick="ChaXun()" value="查 询" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></td>
<td><input type="button" οnclick="addJiaGongYuChuLi()" value="加工预处理" style="font-size: 18px;width:auto; font-family: 楷体; color: #CC33FF" /></td>
</tr>
</table>
<table id="tb加工作业" class="easyui-datagrid" style="width:auto; height:400px;" data-options="singleSelect:true,scrolling:true,
url:'/LiuTongJiaGongZuoYe/ChaXunJiBenXinXi?NeiRong='">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'OrdersInformationID',width:50,hidden:true,align:'center'">订单信息ID</th>
<th data-options="field:'MachiningOrdersDetailedID',width:50,hidden:true,align:'center'">订单加工信息ID</th>
<th data-options="field:'OrdersMark',width:120,editor:'true',align:'center'">订单号</th>
<th data-options="field:'ClientCode',width:100,editor:'true',align:'center'">客户码</th>
<th data-options="field:'OrdersSource',width:100,editor:'true',align:'center'">订单来源</th>
<th data-options="field:'MachiningTypeID',width:100,align:'center',hidden:'true'">加工类型ID</th>
<th data-options="field:'MachiningType',width:100,editor:'true',align:'center'">加工类型</th>
<th data-options="field:'StoreroomCoding',width:100,editor:'true',align:'center'">库房编码</th>
<th data-options="field:'State',width:100,editor:'true',align:'center'">状态</th>
<th data-options="field:'PledgeBank',width:120,editor:'true',align:'center'">质押银行</th>
<th data-options="field:'Note',width:120,editor:'true',align:'center'">备注</th>
</tr>
</thead>
</table>
</div>
<div title="加工预处理查询" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 20px; margin-top: 1px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="txtZuoYeJiHuaDan" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td><input type="button" οnclick="YuChuLiChaXun()" value="查 询" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></td>
<td><input type="button" οnclick="addJiaGongFanKui()" value="作业计划单反馈" style="font-size: 18px;width:auto; font-family: 楷体; color: #CC33FF" /></td>
</tr>
</table>
<table id="tb加工预处理" class="easyui-datagrid" style="width:auto; height:200px;" data-options="singleSelect:true,scrolling:true,
onClickRow:ChaXunMingXi,
url:'/LiuTongJiaGongZuoYe/SelectWarningOutboundTreatment?NeiRong='">
<thead>
<tr>
<th data-options="field:'MachiningWarningSchedulingID',width:50,align:'center',formatter:returnBtnXiuGai"><img src="../../Content/图片/修改.png" /></th>
<th data-options="field:'OrdersInformationID',width:100,align:'center',hidden:'true'">订单信息ID</th>
<th data-options="field:'MachiningOrdersDetailedID',width:100,align:'center',hidden:'true'">加工明细ID</th>
<th data-options="field:'MachiningTypeID',width:100,align:'center',hidden:'true'">加工类型ID</th>
<th data-options="field:'WorkPlanNumber',width:100,align:'center'">作业计划单号</th>
<th data-options="field:'OrdersMark',width:100,editor:'true',align:'center'">订单号</th>
<th data-options="field:'ClientCode',width:100,editor:'true',align:'center'">客户码</th>
<th data-options="field:'MachiningType',width:100,editor:'true',align:'center'">加工类型</th>
<th data-options="field:'State',width:100,editor:'true',align:'center'">状态</th>
<th data-options="field:'PledgeBank',width:100,editor:'true',align:'center'">质押银行</th>
<th data-options="field:'NeedGrossWeight',width:80,align:'center'">需要总重量</th>
<th data-options="field:'NeedGrossBulk',width:80,align:'center'">需要总体积</th>
<th data-options="field:'ID',width:50,align:'center',formatter:returnBtnShanChu"><img src="../../Content/图片/删除.jpg" /></th>
</tr>
</thead>
</table>
<table id="tb加工预处理明细" title="加工预处理明细" class="easyui-datagrid" style="width:auto; height:150px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'MachiningWarningChooseGoodsSchedulingID',width:100,align:'center',hidden:'true'">加工预拣货调度ID</th>
<th data-options="field:'MachiningWarningLabelDetailedID',width:100,align:'center',hidden:'true'">加工预贴签明细ID</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:100,editor:'true',align:'center'">区编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'GoodsCoding',width:100,editor:'true',align:'center'">货品编码</th>
<th data-options="field:'MachiningType',width:100,align:'center'">加工类型</th>
<th data-options="field:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,editor:'true',align:'center'">型号</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'QualityState',width:80,align:'center'">质量</th>
</tr>
</thead>
</table>
<div id="DD" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<table id="tb加工预上架调度明细" title="加工预上架调度明细" class="easyui-datagrid" style="width:auto; height:150px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'MachiningWarningGroundingSchedulingID',width:100,align:'center',hidden:'true'">加工预拣货调度ID</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:100,editor:'true',align:'center'">区编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'GoodsCoding',width:100,editor:'true',align:'center'">货品编码</th>
<th data-options="field:'MachiningType',width:100,align:'center'">加工类型</th>
<th data-options="field:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,editor:'true',align:'center'">型号</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'QualityState',width:80,align:'center'">质量</th>
</tr>
</thead>
</table>
</div>
</div>
<div title="加工反馈查询" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 20px; margin-top: 1px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="ZuoYeJiHuaDan" style="border-style: hidden hidden outset hidden; border-width: thin; width:150px; height:30px; " /></td>
<td><input type="button" οnclick="FanKuiChaXun()" value="查 询" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></td>
</tr>
</table>
<table id="tb加工反馈" class="easyui-datagrid" style="width:auto; height:200px;" data-options="singleSelect:true,scrolling:true,
onClickRow:FanKuiChaXunMingXi,
url:'/LiuTongJiaGongZuoYe/SelectMachiningScheduling?NeiRong='">
<thead>
<tr>
<th data-options="field:'MachiningSchedulingID',width:50,align:'center',formatter:returnBtnFKXiuGai"><img src="../../Content/图片/修改.png" /></th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">订单信息ID</th>
<th data-options="field:'MachiningTypeID',width:100,align:'center',hidden:'true'">加工类型ID</th>
<th data-options="field:'WorkPlanNumber',width:100,align:'center'">作业计划单号</th>
<th data-options="field:'OrdersMark',width:100,editor:'true',align:'center'">订单号</th>
<th data-options="field:'ClientCode',width:100,editor:'true',align:'center'">客户码</th>
<th data-options="field:'State',width:100,editor:'true',align:'center'">状态</th>
<th data-options="field:'PledgeBank',width:100,editor:'true',align:'center'">质押银行</th>
<th data-options="field:'NeedGrossWeight',width:80,align:'center'">需要总重量</th>
<th data-options="field:'NeedGrossBulk',width:80,align:'center'">需要总体积</th>
<th data-options="field:'ID',width:50,align:'center',formatter:returnBtnFKShanChu"><img src="../../Content/图片/删除.jpg" /></th>
</tr>
</thead>
</table>
<table id="tb加工反馈拣货明细" title="加工反馈拣货明细" class="easyui-datagrid" style="width:auto; height:150px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'MachiningChooseGoodsSchedulingID',width:100,align:'center',hidden:'true'">加工拣贷调度ID</th>
<th data-options="field:'MachiningLabelSchedulingID',width:100,align:'center',hidden:'true'">加工贴签调度ID</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:100,editor:'true',align:'center'">区编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'GoodsCoding',width:100,editor:'true',align:'center'">货品编码</th>
<th data-options="field:'MachiningType',width:100,align:'center'">加工类型</th>
<th data-options="field:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,editor:'true',align:'center'">型号</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quality',width:80,align:'center'">质量</th>
</tr>
</thead>
</table>
<div id="WW" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<table id="tb加工反馈上架明细" title="加工反馈上架明细" class="easyui-datagrid" style="width:auto; height:150px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'MachiningWarningGroundingSchedulingID',width:100,align:'center',hidden:'true'">加工预拣货调度ID</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:100,editor:'true',align:'center'">区编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'GoodsCoding',width:100,editor:'true',align:'center'">货品编码</th>
<th data-options="field:'MachiningType',width:100,align:'center'">加工类型</th>
<th data-options="field:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,editor:'true',align:'center'">型号</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quality',width:80,align:'center'">质量</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
<div id="tbJiaGongYuChuLiTieQian" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<div class="easyui-tabs" style="border-width: thick; border-style: none;">
<div title="贴签明细" style="padding:10px;width:auto; height:auto;border-style: none;">
<table>
<tr>
<td>区编码:<input type="text" id="TieQianQuBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " /></td>
<td>储位编码:<input type="text" id="TieQianChuWeiBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " /></td>
<td><input type="button" οnclick="TieQianXuanZe()" value="[选择]" style="color: #FF0000; border-style: none;" /></td>
</tr>
</table>
<table id="tb贴签明细" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onClickRow,onDblClickRow:onDblClickRow">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'AttributeDetailedID',width:100,align:'center',
formatter:function(value,row){
return row.AttributeDetailedName;
},
editor:{
type:'combobox',
options:{
valueField:'AttributeDetailedID',
textField:'AttributeDetailedName',
url:'/DingDanLuRu/cboBinDing?AttributeAssembleID=47'
}
}">质量状态</th>
<th data-options="field:'DanWeiID',width:100,align:'center',
formatter:function(value,row){
return row.Name;
},
editor:{
type:'combobox',
options:{
valueField:'AttributeDetailedID',
textField:'AttributeDetailedName',
url:'/DingDanLuRu/cboBinDing?AttributeAssembleID=37'
}
}">单位</th>
<th data-options="field:'Quantity',width:100,align:'center'">作业总数</th>
<th data-options="field:'DaiShangJiaShu',width:100,editor:'numberbox',align:'center'">待上架数</th>
</tr>
</thead>
</table>
</div>
<div title="资源调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
需要进行作业的货品总重量为:<input class="easyui-numberbox" id="HuoPinZongZhongliang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /><br />
需要进行作业的货品总体积为:<input class="easyui-numberbox" id="HuoPinZongTiji" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
</div>
<div>
<table class="easyui-datagrid" style="width:500px; height:100px;" data-options="singleSelect:true,scrolling:true,
url:'/LiuTongJiaGongZuoYe/SelectMachiningWarningWork'">
<thead>
<tr>
<th data-options="field:'MachiningWarningResourceSchedulingID',width:100,align:'center',hidden:'true'">加工预资源调度ID</th>
<th data-options="field:'OperateTypeID',width:100,align:'center',hidden:'true'">操作类型ID</th>
<th data-options="field:'WorkNumber',width:100,align:'center'">作业单号</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'MachiningWarningWorkID',width:90,align:'center',formatter:returnBtnZuoYeZiyuan"></th>
</tr>
</thead>
</table>
</div>
</div>
<div title="基本信息" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 30px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="txtZuoYeJiHuaDanhao" 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="txtDingDanhao" 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 type="text" id="txtKuHuma" 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="txtLeixing" 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 type="text" id="txtKuFangBianma" 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="txtZhuangtai" 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 type="text" id="txtZhiYaYinhang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div style="margin-left: 400px;"><input type="button" οnclick="JiaGogTieQianDiaoDu()" value="调度完成" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></div>
</div>
<div id="tbJiaGongYuChuLi" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<div class="easyui-tabs" style="border-width: thick; border-style: none;">
<div title="拣货调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
区编码:<input type="text" id="txtQuBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
储位编码:<input type="text" id="txtChuWeiBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
<input type="button" οnclick="XuanZe()" value="[选择]" style="color: #FF0000; border-style: none;" />
货品编码:<input type="text" id="txtHuoPinbianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
批次:<input type="text" id="txtpiCi" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
质量状态:<input class="easyui-combobox" id="cboZhiLiangZhuangtai" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
数量:<input type="text" id="txtShuliang" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
<input type="button" οnclick="JiaGongJianHuo()" value="拣货" style="font-size: 18px; font-family: 微软雅黑; font-weight: 200;" />
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">已拣货结果:</a>
<table id="tb加工已拣货" class="easyui-datagrid" style="width:auto; height:120px;" data-options="singleSelect:true,scrolling:true,">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'StorageID',width:100,align:'center',hidden:'true'">储位ID</th>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区编码</th>
<th data-options="field:'StorageNumber',width:100,editor:'true',align:'center'">储位编码</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'GoodsCoding',width:100,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'Standard',width:100,editor:'true',align:'center'">规格</th>
<th data-options="field:'Model',width:80,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,editor:'combobox',align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,editor:'true',align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,editor:'numberbox',align:'center'">应出数量</th>
<th data-options="field:'Quantity',width:80,editor:'numberbox',align:'center'">实出数量</th>
<th data-options="field:'QuXiao',width:80,align:'center',formatter:returnBtnQuXiao"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">待拣货结果:</a>
<table id="tb加工待拣货" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onClickRowQiYongEdit,onDblClickRow:JianHuoDblHuoPin">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,align:'center'">应出数量</th>
<th data-options="field:'ShuChuShuLian',width:100,editor:'numberbox',align:'center'">实出数量</th>
<th data-options="field:'Quantity',width:80,align:'center'">可分配数量</th>
<th data-options="field:'GoodsID',width:100,align:'center',formatter:returnBtnKuCun"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">库存:</a>
<table id="tb库存" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'pici',width:100,align:'center'">批次</th>
<th data-options="field:'Unit',width:100,align:'center'">单位</th>
<th data-options="field:'JustGradeMeasure',width:100,align:'center'">正品数</th>
<th data-options="field:'InferiorGradeMeasure',width:100,align:'center'">次品数</th>
</tr>
</thead>
</table>
</div>
<div>
<input type="button" value="打印储位分配单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
<input type="button" value="打印入库单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
</div>
</div>
<div title="上架调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
区编码:<input type="text" id="QuBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
储位编码:<input type="text" id="ChuWeiBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
<input type="button" οnclick="XuanZe()" value="[选择]" style="color: #FF0000; border-style: none;" />
货品编码:<input type="text" id="HuoPinBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
批次:<input type="text" id="PiCi" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
质量状态:<input class="easyui-combobox" id="ZhiLiangZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
数量:<input type="text" id="ShuLiang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
<input type="button" οnclick="JiaGongShangJia()" value="上架" style="font-size: 18px; font-family: 微软雅黑; font-weight: 200;" />
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">已上架货品:</a>
<table id="tb加工已上架" class="easyui-datagrid" style="width:auto; height:120px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'StorageID',width:100,align:'center',hidden:'true'">储位ID</th>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区编码</th>
<th data-options="field:'StorageNumber',width:100,editor:'true',align:'center'">储位编码</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'GoodsCoding',width:100,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'Standard',width:100,editor:'true',align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,editor:'combobox',align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,editor:'true',align:'center'">单位</th>
<th data-options="field:'Quantity',width:100,editor:'numberbox',align:'center'">数量</th>
<th data-options="field:'QuXiao',width:100,align:'center',formatter:returnBtnquXiao"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">待上架货品:</a>
<table id="tb加工待上架" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onClickRowQiYongEdit,onDblClickRow:DblHuoPin">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,align:'center'">应出数量</th>
<th data-options="field:'DaiShangJiaShu',width:100,editor:'numberbox',align:'center'">待上架数量</th>
</tr>
</thead>
</table>
</div>
<div>
<input type="button" value="打印储位分配单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
<input type="button" value="打印入库单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
</div>
</div>
<div title="资源调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
需要进行作业的货品总重量为:<input type="text" οnkeyup="PanDuanChengZhong()" id="txtHuoPinZongZhongLiang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /><br />
需要进行作业的货品总体积为:<input type="text" οnkeyup="PanDuanTiJi()" id="txtHuoPinZongTiJi" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
</div>
<div>
<table class="easyui-datagrid" style="width:500px; height:100px;" data-options="singleSelect:true,scrolling:true,
url:'/LiuTongJiaGongZuoYe/SelectMachiningWarningWork'">
<thead>
<tr>
<th data-options="field:'MachiningWarningResourceSchedulingID',width:100,align:'center',hidden:'true'">加工预资源调度ID</th>
<th data-options="field:'OperateTypeID',width:100,align:'center',hidden:'true'">操作类型ID</th>
<th data-options="field:'WorkNumber',width:100,align:'center'">作业单号</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'MachiningWarningWorkID',width:90,align:'center',formatter:returnBtnZuoYeZiyuan"></th>
</tr>
</thead>
</table>
</div>
</div>
<div title="基本信息" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 30px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="txtZuoYeJiHuaDanHao" 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="txtDingDanHao" 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 type="text" id="txtKuHuMa" 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="txtLeiXing" 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 type="text" id="txtKuFangBianMa" 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="txtZhuangTai" 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 type="text" id="txtZhiYaYinHang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div style="margin-left: 400px;"><input type="button" οnclick="JiaGongDiaoDu()" value="调度完成" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></div>
</div>
<div id="tbJiaGongFanKui" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<div class="easyui-tabs" style="border-width: thick; border-style: none;">
<div title="拣货反馈" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
区编码:<input type="text" id="Qubianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
储位编码:<input type="text" id="ChuWeibianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
<input type="button" οnclick="Xuanxe()" value="[选择]" style="color: #FF0000; border-style: none;" />
货品编码:<input type="text" id="HuoPinbianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
批次:<input type="text" id="piCi" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
质量状态:<input class="easyui-combobox" id="ZhiLiangZhuangtai" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
数量:<input type="text" id="Shuliang" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " />
<input type="button" οnclick="JiaGongFKJianHuo()" value="拣货" style="font-size: 18px; font-family: 微软雅黑; font-weight: 200;" />
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">已拣货结果:</a>
<table id="tb加工反馈已拣货" class="easyui-datagrid" style="width:auto; height:120px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'StorageID',width:100,align:'center',hidden:'true'">储位ID</th>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区编码</th>
<th data-options="field:'StorageNumber',width:100,editor:'true',align:'center'">储位编码</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'GoodsCoding',width:100,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'Standard',width:100,editor:'true',align:'center'">规格</th>
<th data-options="field:'Model',width:80,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,editor:'combobox',align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,editor:'true',align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,editor:'numberbox',align:'center'">应出数量</th>
<th data-options="field:'Quantity',width:80,editor:'numberbox',align:'center'">实出数量</th>
<th data-options="field:'QuXiao',width:80,align:'center',formatter:returnBtnFKQuXiao"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">待拣货结果:</a>
<table id="tb加工反馈待拣货" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onClickRowQiYongEdit,onDblClickRow:JianHuoFKDblHuoPin">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,align:'center'">应出数量</th>
<th data-options="field:'ShuChuShuLian',width:100,editor:'numberbox',align:'center'">实出数量</th>
<th data-options="field:'Quantity',width:80,align:'center'">可分配数量</th>
<th data-options="field:'GoodsID',width:100,align:'center',formatter:returnBtnFKKuCun"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">库存:</a>
<table id="tb拣货库存" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区</th>
<th data-options="field:'StorageNumber',width:100,align:'center'">储位</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'pici',width:100,align:'center'">批次</th>
<th data-options="field:'Unit',width:100,align:'center'">单位</th>
<th data-options="field:'JustGradeMeasure',width:100,align:'center'">正品数</th>
<th data-options="field:'InferiorGradeMeasure',width:100,align:'center'">次品数</th>
</tr>
</thead>
</table>
</div>
<div>
<input type="button" value="打印储位分配单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
<input type="button" value="打印入库单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
</div>
</div>
<div title="上架反馈" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
区编码:<input type="text" id="txtQuBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
储位编码:<input type="text" id="txtChuWeiBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
<input type="button" οnclick="Xuanxe()" value="[选择]" style="color: #FF0000; border-style: none;" />
货品编码:<input type="text" id="txtHuoPinBianMa" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
批次:<input type="text" id="txtPiCi" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
质量状态:<input class="easyui-combobox" id="cboZhiLiangZhuangTai" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
数量:<input type="text" id="txtShuLiangs" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
<input type="button" οnclick="JiaGongFKShangJia()" value="上架" style="font-size: 18px; font-family: 微软雅黑; font-weight: 200;" />
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">已上架货品:</a>
<table id="tb加工反馈已上架" class="easyui-datagrid" style="width:auto; height:120px;" data-options="singleSelect:true,scrolling:true">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'StorageID',width:100,align:'center',hidden:'true'">储位ID</th>
<th data-options="field:'DistrictCoding',width:100,align:'center'">区编码</th>
<th data-options="field:'StorageNumber',width:100,editor:'true',align:'center'">储位编码</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'GoodsCoding',width:100,align:'center'">货品编码</th>
<th data-options="field:'GoodsName',width:100,editor:'true',align:'center'">货品名称</th>
<th data-options="field:'Standard',width:100,editor:'true',align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,editor:'combobox',align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,editor:'true',align:'center'">单位</th>
<th data-options="field:'Quantity',width:100,editor:'numberbox',align:'center'">数量</th>
<th data-options="field:'QuXiao',width:100,align:'center',formatter:returnBtnFKquXiao"></th>
</tr>
</thead>
</table>
</div>
<div>
<a style="color: #FF0000;font-size: 18px; font-family: 微软雅黑; font-weight: 200;">待上架货品:</a>
<table id="tb加工反馈待上架" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onClickRowQiYongEdit,onDblClickRow:FKDblHuoPin">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,align:'center'">批次</th>
<th data-options="field:'QualityID',width:50,align:'center',hidden:'true'">质量状态ID</th>
<th data-options="field:'Quality',width:80,align:'center'">质量状态</th>
<th data-options="field:'UnitID',width:50,align:'center',hidden:'true'">单位ID</th>
<th data-options="field:'Unit',width:80,align:'center'">单位</th>
<th data-options="field:'Quantity',width:80,align:'center'">应出数量</th>
<th data-options="field:'DaiShangJiaShu',width:100,editor:'numberbox',align:'center'">待上架数量</th>
</tr>
</thead>
</table>
</div>
<div>
<input type="button" value="打印储位分配单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
<input type="button" value="打印入库单" style="font-size: 10px; font-family: 微软雅黑; font-weight: 200;" />
</div>
</div>
<div title="资源调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
需要进行作业的货品总重量为:<input type="text" οnkeyup="FKPanDuanChengZhong()" id="HuoPinZongZhongLiang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /><br />
需要进行作业的货品总体积为:<input type="text" οnkeyup="FKPanDuanTiJi()" id="HuoPinZongTiJi" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
</div>
<div>
<table class="easyui-datagrid" style="width:500px; height:100px;" data-options="singleSelect:true,scrolling:true,
url:'/LiuTongJiaGongZuoYe/SelectMachiningWarningWork'">
<thead>
<tr>
<th data-options="field:'MachiningWarningResourceSchedulingID',width:100,align:'center',hidden:'true'">加工预资源调度ID</th>
<th data-options="field:'OperateTypeID',width:100,align:'center',hidden:'true'">操作类型ID</th>
<th data-options="field:'WorkNumber',width:100,align:'center'">作业单号</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'MachiningWarningWorkID',width:90,align:'center',formatter:returnBtnZuoYeZiYuan"></th>
</tr>
</thead>
</table>
</div>
</div>
<div title="基本信息" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 30px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="ZuoYeJiHuaDanHao" 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="DingDanHao" 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 type="text" id="KuHuMa" 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="LeiXing" 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 type="text" id="KuFangBianMa" 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="ZhuangTai" 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 type="text" id="ZhiYaYinHang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
</table>
</div>
</div>
<div style="margin-left: 400px;"><input type="button" οnclick="JiaGongFanKuiDiaoDu()" value="反馈完成" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></div>
</div>
<div id="tbJiaGongFanKuiTieQian" class="easyui-panel" data-options="closed:true" style="border-style: none ;width:auto; height:auto;">
<div class="easyui-tabs" style="border-width: thick; border-style: none;">
<div title="贴签明细" style="padding:10px;width:auto; height:auto;border-style: none;">
<table>
<tr>
<td>区编码:<input type="text" id="FKQuBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " /></td>
<td>储位编码:<input type="text" id="FKChuWeiBianma" style="border-style: hidden hidden outset hidden; border-width: thin; width:80px; height:30px; " /></td>
<td><input type="button" οnclick="FKXuanxe()" value="[选择]" style="color: #FF0000; border-style: none;" /></td>
</tr>
</table>
<table id="tb反馈贴签明细" class="easyui-datagrid" style="width:auto; height:130px;" data-options="singleSelect:true,scrolling:true,
onClickRow:onFKClickRow,onDblClickRow:onDblClickRowOpenHuoPin">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'GoodsID',width:100,align:'center',hidden:'true'">货品ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:'Standard',width:100,align:'center'">规格</th>
<th data-options="field:'Model',width:100,align:'center'">型号</th>
<th data-options="field:'Batch',width:80,editor:'numberbox',align:'center'">批次</th>
<th data-options="field:'AttributeDetailedID',width:100,align:'center',
formatter:function(value,row){
return row.AttributeDetailedName;
},
editor:{
type:'combobox',
options:{
valueField:'AttributeDetailedID',
textField:'AttributeDetailedName',
url:'/DingDanLuRu/cboBinDing?AttributeAssembleID=47'
}
}">质量状态</th>
<th data-options="field:'DanWeiID',width:100,align:'center',
formatter:function(value,row){
return row.Name;
},
editor:{
type:'combobox',
options:{
valueField:'AttributeDetailedID',
textField:'AttributeDetailedName',
url:'/DingDanLuRu/cboBinDing?AttributeAssembleID=37'
}
}">单位</th>
<th data-options="field:'Quantity',width:100,align:'center'">作业总数</th>
<th data-options="field:'DaiShangJiaShu',width:100,editor:'numberbox',align:'center'">待处理数</th>
</tr>
</thead>
</table>
</div>
<div title="基本信息" style="padding:10px;width:auto; height:auto;border-style: none;">
<table style="margin-left: 30px;">
<tr>
<td align="right"><strong style="font-size: medium">作业计划单号:</strong></td><td>
<input type="text" id="ZuoYeJiHuaDanhao" 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="DingDanhao" 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 type="text" id="KuHuma" 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="Leixing" 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 type="text" id="KuFangBianma" 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="Zhuangtai" 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 type="text" id="ZhiYaYinhang" style="border-style: hidden hidden outset hidden; border-width: thin; width:200px; height:30px; " /></td>
</tr>
</table>
</div>
<div title="资源调度" style="padding:10px;width:auto; height:auto;border-style: none;">
<div>
需要进行作业的货品总重量为:<input type="text" id="HuoPinZongzhongliang" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " /><br />
需要进行作业的货品总体积为:<input type="text" id="HuoPinZongtiji" style="border-style: hidden hidden outset hidden; border-width: thin; width:100px; height:30px; " />
</div>
<div>
<table class="easyui-datagrid" style="width:500px; height:100px;" data-options="singleSelect:true,scrolling:true,
url:'/LiuTongJiaGongZuoYe/SelectMachiningWarningWork'">
<thead>
<tr>
<th data-options="field:'MachiningWarningResourceSchedulingID',width:100,align:'center',hidden:'true'">加工预资源调度ID</th>
<th data-options="field:'OperateTypeID',width:100,align:'center',hidden:'true'">操作类型ID</th>
<th data-options="field:'WorkNumber',width:100,align:'center'">作业单号</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'OperateType',width:100,editor:'true',align:'center'">操作类型</th>
<th data-options="field:'MachiningWarningWorkID',width:90,align:'center',formatter:returnBtnZuoYeZiyuan"></th>
</tr>
</thead>
</table>
</div>
</div>
</div>
<div style="margin-left: 400px;"><input type="button" οnclick="JiaGogFanKuiTieQianDiaoDu()" value="反馈完成" style="font-size: 18px;width:100px; font-family: 楷体; color: #CC33FF" /></div>
</div>
<div class="easyui-window" id="FKHuoPinXinXi" title="货品信息" style="border-style: none; width:600px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb反馈货品信息" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:DblFKHuoPinDatagrid">
<thead>
<tr>
<th data-options="field:'MachiningWarningLabelDetailedID',width:100,align:'center',hidden:'true'">加工贴签调度ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'GoodsID',width:80,hidden:true,align:'center'">货品ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:60,align:'center'">规格</th>
<th data-options="field:'Model',width:60,align:'center'">型号</th>
<th data-options="field:'UnitID',width:60,hidden:true,align:'center'">单位ID</th>
<th data-options="field:'Unit',width:60,align:'center'">单位</th>
<th data-options="field:'QualityID',width:80,hidden:true,align:'center'">质量ID</th>
<th data-options="field:'Quality',width:60,align:'center'">质量</th>
<th data-options="field:'Batch',width:60,align:'center'">批次</th>
<th data-options="field:'Quantity',width:60,align:'center'">数量</th>
</tr>
</thead>
</table>
</div>
<div class="easyui-window" id="FKChuWei" title="储位信息" style="border-style: none; width:450px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb反馈贴签储位" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:DblOpenFKChuWei">
<thead>
<tr>
<th data-options="field:'StorageID',width:80,hidden:true,align:'center'">储位ID</th>
<th data-options="field:'DistrictID',width:80,hidden:true,align:'center'">区ID</th>
<th data-options="field:'StorageNumber',width:80,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:80,align:'center'">区编码</th>
<th data-options="field:'DistrictName',width:60,align:'center'">区名称</th>
<th data-options="field:'Cubage',width:80,align:'center'">体积</th>
<th data-options="field:'BearWeight',width:80,align:'center'">承重</th>
</tr>
</thead>
</table>
</div>
<div class="easyui-window" id="ChuWei" title="储位信息" style="border-style: none; width:450px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb储位" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:DblOpenChuWei">
<thead>
<tr>
<th data-options="field:'StorageID',width:80,hidden:true,align:'center'">储位ID</th>
<th data-options="field:'DistrictID',width:80,hidden:true,align:'center'">区ID</th>
<th data-options="field:'StorageNumber',width:80,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:80,align:'center'">区编码</th>
<th data-options="field:'DistrictName',width:60,align:'center'">区名称</th>
<th data-options="field:'Cubage',width:80,align:'center'">体积</th>
<th data-options="field:'BearWeight',width:80,align:'center'">承重</th>
</tr>
</thead>
</table>
</div>
<div class="easyui-window" id="HuoPinXinXi" title="货品信息" style="border-style: none; width:600px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb货品信息" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:DblHuoPinDatagrid">
<thead>
<tr>
<th data-options="field:'MachiningGoodsID',width:100,align:'center',hidden:'true'">加工货品ID</th>
<th data-options="field:'MachiningOrdersInformationID',width:100,align:'center',hidden:'true'">加工信息ID</th>
<th data-options="field:'GoodsID',width:80,hidden:true,align:'center'">货品ID</th>
<th data-options="field:'Storeroom',width:100,align:'center',hidden:'true'">库房名称</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:60,align:'center'">规格</th>
<th data-options="field:'Model',width:60,align:'center'">型号</th>
<th data-options="field:'UnitID',width:60,hidden:true,align:'center'">单位ID</th>
<th data-options="field:'Unit',width:60,align:'center'">单位</th>
<th data-options="field:'QualityID',width:80,hidden:true,align:'center'">质量ID</th>
<th data-options="field:'Quality',width:60,align:'center'">质量</th>
<th data-options="field:'Batch',width:60,align:'center'">批次</th>
<th data-options="field:'Quantity',width:60,align:'center'">数量</th>
</tr>
</thead>
</table>
</div>
<div class="easyui-window" id="ChuWeiXinXi" title="储位信息" style="border-style: none; width:450px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb储位信息" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:DblChuWei">
<thead>
<tr>
<th data-options="field:'StorageID',width:80,hidden:true,align:'center'">储位ID</th>
<th data-options="field:'DistrictID',width:80,hidden:true,align:'center'">区ID</th>
<th data-options="field:'StorageNumber',width:80,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:80,align:'center'">区编码</th>
<th data-options="field:'DistrictName',width:60,align:'center'">区名称</th>
<th data-options="field:'Cubage',width:80,align:'center'">体积</th>
<th data-options="field:'BearWeight',width:80,align:'center'">承重</th>
</tr>
</thead>
</table>
</div>
<div class="easyui-window" id="TieQianChuWeiXinXi" title="储位信息" style="border-style: none; width:450px; height:250px; border-radius:15px 15px 0px 0px;"
data-options="draggable:false,resizable:false,collapsible:false,minimizable:false,maximizable:false,closed:true">
<table id="tb贴签储位信息" class="easyui-datagrid" style="width:auto; height:auto;"
data-options="scrolling:true,singleSelect:true,onDblClickRow:TieQianDblChuWei">
<thead>
<tr>
<th data-options="field:'StorageID',width:80,hidden:true,align:'center'">储位ID</th>
<th data-options="field:'DistrictID',width:80,hidden:true,align:'center'">区ID</th>
<th data-options="field:'StorageNumber',width:80,align:'center'">储位编码</th>
<th data-options="field:'DistrictCoding',width:80,align:'center'">区编码</th>
<th data-options="field:'DistrictName',width:60,align:'center'">区名称</th>
<th data-options="field:'Cubage',width:80,align:'center'">体积</th>
<th data-options="field:'BearWeight',width:80,align:'center'">承重</th>
</tr>
</thead>
</table>
</div>
</body>
</html>
jQuery代码:
<script type="text/javascript">
$(document).ready(function () {
XiaLaBangDing();<span><span class="comment">//HTML加载时,预先执行下拉框绑定方法</span><span> </span></span>
});
function XiaLaBangDing() {
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=47",
function (data) {
$("#cboZhiLiangZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=47",
function (data) {
$("#ZhiLiangZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=47",
function (data) {
$("#ZhiLiangZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=34",
function (data) {
$("#cboJiaGongLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=47",
function (data) {
$("#ZhiLiangZhuangtai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=47",
function (data) {
$("#cboZhiLiangZhuangTai").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
$.getJSON("/DingDanLuRu/cboBinDing?AttributeAssembleID=34",
function (data) {
$("#JiaGongLeiXing").combobox({ data: data, valueField: 'AttributeDetailedID',
textField: 'AttributeDetailedName'
});
});
}
function ChaXun() { //模糊查询加工订单信息
$.getJSON("/LiuTongJiaGongZuoYe/ChaXunJiBenXinXi?NeiRong=" + $("#txtdingdanhao").val(), function (data) {
$('#tb加工作业').datagrid('loadData', data);
});
}
function YuChuLiChaXun() { //入库预处理模糊查询
$.getJSON("/LiuTongJiaGongZuoYe/SelectWarningOutboundTreatment?NeiRong=" + $("#txtZuoYeJiHuaDan").val(), function (data) {
$('#tb加工预处理').datagrid('loadData', data);
});
}
function ChaXunMingXi() { //单击加工预处理datagrid,查询明细
var row = $("#tb加工预处理").datagrid('getSelected');
if (row.MachiningTypeID == 124) { //在加工预处理查询界面,当加工类型是贴签时,点击datagrid里的数据,可以将贴签的货品信息显示出来
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningWarningLabelDetailed?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
$("#tb加工预处理明细").datagrid('loadData', data);
});
$('#DD').panel('close');
} else { //在加工预处理查询界面,当加工类型是组合和包装时,点击datagrid里的数据,可以将拣货和上架的货品信息显示出来
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningWarningChooseGoodsScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID +
"&MachiningTypeID=" + row.MachiningTypeID,
function (data) {
$("#tb加工预处理明细").datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningWarningGroundingScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID +
"&MachiningTypeID=" + row.MachiningTypeID,
function (data) {
$("#tb加工预上架调度明细").datagrid('loadData', data);
});
$('#DD').panel('open');
}
}
var OrdersInformationID = 0;
var MachiningTypeID = 0;
var KuFangID = 0;
function addJiaGongYuChuLi() {
var row = $("#tb加工作业").datagrid('getSelected');
if (row != null) {
OrdersInformationID = row.OrdersInformationID;
MachiningTypeID = row.MachiningTypeID;
if (row.MachiningTypeID == 124) {
$('#tbChuKuZuoYe').tabs('add', { //添加新的选项卡
title: '加工预处理',
content: $('#tbJiaGongYuChuLiTieQian').panel('open'), //打开加工预处理贴签操作界面
closable: true
});
$('#tb贴签明细').datagrid('insertRow', { //新增一行空白行
index: 0,
row: {}
});
//加载货品信息
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) {
$('#tb货品信息').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingDinDanXinXiByID?MachiningOrdersInformationID=" + row.OrdersInformationID,
function (data) { //绑定基本信息
KuFangID = data[0].StoreroomID;
$('#txtDingDanhao').attr('value', data[0].OrdersMark);
$('#txtKuHuma').attr('value', data[0].ClientCode);
$('#txtLeixing').attr('value', data[0].OrdersType);
$('#txtKuFangBianma').attr('value', data[0].State);
$('#txtZhuangtai').attr('value', data[0].StoreroomCoding);
$('#txtZhiYaYinhang').attr('value', data[0].PledgeBank);
});
} else {
$('#tbChuKuZuoYe').tabs('add', { //添加新的选项卡
title: '加工预处理',
content: $('#tbJiaGongYuChuLi').panel('open'), //打开加工预处理组合和包装操作界面
closable: true
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) {
$('#tb加工待拣货').datagrid('loadData', data); //加载货品信息
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) {
$('#tb加工待上架').datagrid('loadData', data); //加载货品信息
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingDinDanXinXiByID?MachiningOrdersInformationID=" + row.OrdersInformationID,
function (data) { //绑定基本信息
KuFangID = data[0].StoreroomID;
$('#txtDingDanHao').attr('value', data[0].OrdersMark);
$('#txtKuHuMa').attr('value', data[0].ClientCode);
$('#txtLeiXing').attr('value', data[0].OrdersType);
$('#txtKuFangBianMa').attr('value', data[0].StoreroomCoding);
$('#txtZhuangTai').attr('value', data[0].State);
$('#txtZhiYaYinHang').attr('value', data[0].PledgeBank);
});
}
} else {
alert("请先选择一行数据!!!");
}
}
//定义一个全局变量,并把它赋值为未定义
var editIndex = undefined;
//启用单元格编辑状态
function onClickRowQiYongEdit(index) {
if (editIndex != index) {
$('#tb加工待拣货').datagrid('beginEdit', index);
$('#tb加工待拣货').datagrid('endEdit', editIndex);
$('#tb加工待上架').datagrid('beginEdit', index);
$('#tb加工待上架').datagrid('endEdit', editIndex);
$('#tb加工反馈待拣货').datagrid('beginEdit', index);
$('#tb加工反馈待拣货').datagrid('endEdit', editIndex);
$('#tb加工反馈待上架').datagrid('beginEdit', index);
$('#tb加工反馈待上架').datagrid('endEdit', editIndex);
editIndex = index;
}
}
function XuanZe() { //点击界面选择,根据库房ID查询储位信息
$.getJSON("/LiuTongJiaGongZuoYe/SelectStoreroom?StoreroomID=" + KuFangID,
function (data) {
$('#tb储位信息').datagrid('loadData', data);
});
$("#ChuWeiXinXi").window('open');
}
var StorageID = 0;
var Cubage = 0;
var BearWeight = 0;
function DblChuWei() {
var row = $("#tb储位信息").datagrid('getSelected');
if (row) {
StorageID = row.StorageID;
Cubage = row.Cubage;
BearWeight = row.BearWeight;
$('#txtChuWeiBianma').val(row.StorageNumber);
$('#txtQuBianma').val(row.DistrictCoding);
$('#ChuWeiBianMa').val(row.StorageNumber);
$('#QuBianMa').val(row.DistrictCoding);
$("#ChuWeiXinXi").window('close');
}
}
function PanDuanTiJi() { //加工预处理判断加工总体积与库存总体积
if (parseInt($("#txtHuoPinZongTiJi").val()) > parseInt(Cubage)) {
alert("货品总体积【" + parseInt($("#txtHuoPinZongTiJi").val()) + "】大于"
+ "库存总体积【" + parseInt(Cubage) + "】不允许加工");
}
}
function PanDuanChengZhong() { //加工预处理判断加工总重量与库存总承重
if (parseInt($("#txtHuoPinZongZhongLiang").val()) > parseInt(BearWeight)) {
alert("货品总重量【" + parseInt($("#txtHuoPinZongZhongLiang").val()) + "】大于"
+ "库存总承重【" + parseInt(BearWeight) + "】不允许加工");
}
}
function TieQianXuanZe() { //加工贴签储位信息
$.getJSON("/LiuTongJiaGongZuoYe/SelectStoreroom?StoreroomID=" + KuFangID,
function (data) {
$('#tb贴签储位信息').datagrid('loadData', data);
});
$("#TieQianChuWeiXinXi").window('open');
}
var StorageiD = 0;
function TieQianDblChuWei() {
var row = $("#tb贴签储位信息").datagrid('getSelected');
if (row) {
StorageiD = row.StorageID;
$('#TieQianChuWeiBianma').val(row.StorageNumber);
$('#TieQianQuBianma').val(row.DistrictCoding);
$("#TieQianChuWeiXinXi").window('close');
}
}
function JianHuoDblHuoPin() { //datagrid的双击事件
var rowHuoPinDatagrid = $('#tb加工待拣货').datagrid('getSelected');
$('#tb加工待拣货').datagrid('endEdit', editIndex);
var ZongShu = parseInt(rowHuoPinDatagrid.Quantity);
var ShangJiaShu = parseInt(rowHuoPinDatagrid.ShuChuShuLian);
if (ShangJiaShu > ZongShu) {
alert("待上架数【" + ShangJiaShu + "】大于作业总数【" + ZongShu + "】");
} else {
$("#txtHuoPinbianMa").val(rowHuoPinDatagrid.GoodsCoding);
$("#cboZhiLiangZhuangtai").combobox('setValue', rowHuoPinDatagrid.QualityID);
$("#txtShuliang").val(rowHuoPinDatagrid.ShuChuShuLian);
}
}
function JiaGongJianHuo() { //点击拣货按钮时,将待拣货的货品更新到已拣货的datagrid里
var rowHuoPinDatagrid = $('#tb加工待拣货').datagrid('getSelected');
$('#tb加工已拣货').datagrid('appendRow',
{ StorageID: StorageID,
MachiningGoodsID: rowHuoPinDatagrid.MachiningGoodsID,
MachiningOrdersInformationID: rowHuoPinDatagrid.MachiningOrdersInformationID,
StorageNumber: $('#txtChuWeiBianma').val(),
DistrictCoding: $('#txtQuBianma').val(),
Storeroom: rowHuoPinDatagrid.Storeroom,
GoodsID: rowHuoPinDatagrid.GoodsID,
GoodsCoding: $("#txtHuoPinbianMa").val(),
GoodsName: rowHuoPinDatagrid.GoodsName,
Standard: rowHuoPinDatagrid.Standard,
Model: rowHuoPinDatagrid.Model,
Batch: $("#txtpiCi").val(),
UnitID: rowHuoPinDatagrid.UnitID,
Unit: rowHuoPinDatagrid.Unit,
QualityID: $("#cboZhiLiangZhuangtai").combobox('getValue'),
Quality: $("#cboZhiLiangZhuangtai").combobox('getText'),
Quantity: $("#txtShuliang").val()
});
$.getJSON("/LiuTongJiaGongZuoYe/UdataShuLian?MachiningGoodsID=" + rowHuoPinDatagrid.MachiningGoodsID +
"&ShenYuShuLiang=" + $("#txtShuliang").val(),
function (data) { //拣货后改变库存数量
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + rowHuoPinDatagrid.MachiningOrdersInformationID,
function (data) {
$('#tb加工待拣货').datagrid('loadData', data);
});
}
});
}
function returnBtnQuXiao(GoodsID, row, rowIndex) {
return "<a href='javascript:QuXiao(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="取消" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
} //在已拣货datagrid里,点击取消按钮,可恢复库存数量
function QuXiao(GoodsID, rowIndex) {
var row = $('#tb加工已拣货').datagrid('getSelected');
$.getJSON("/LiuTongJiaGongZuoYe/UdataQuantity?MachiningGoodsID=" + row.MachiningGoodsID +
"&ShenYuShuLiang=" + row.Quantity, function (data) {
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersInformationID,
function (data) {
$('#tb加工待拣货').datagrid('loadData', data);
});
$('#tb加工已拣货').datagrid('cancelEdit', rowIndex)
.datagrid('deleteRow', rowIndex);
}
});
}
function returnBtnKuCun(GoodsID, row, rowIndex) {
return "<a href='javascript:KuCun(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="库存" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
}//在待拣货datagrid里,点击出库,可以查看出该货品在库存的详细信息
function KuCun(GoodsID, rowIndex) {
$.getJSON("/LiuTongJiaGongZuoYe/SelectInventory?GoodsID=" + GoodsID,
function (data) {
$('#tb库存').datagrid('loadData', data);
});
}
function DblHuoPin() { //待上架datagrid里的双击事件
var rowHuoPinDatagrid = $('#tb加工待上架').datagrid('getSelected');
$('#tb加工待上架').datagrid('endEdit', editIndex);
var ZongShu = parseInt(rowHuoPinDatagrid.Quantity);
var ShangJiaShu = parseInt(rowHuoPinDatagrid.DaiShangJiaShu);
if (ShangJiaShu > ZongShu) {
alert("待上架数【" + ShangJiaShu + "】大于作业总数【" + ZongShu + "】");
} else {
$("#HuoPinBianMa").val(rowHuoPinDatagrid.GoodsCoding);
$("#ZhiLiangZhuangTai").combobox('setValue', rowHuoPinDatagrid.QualityID);
$("#ShuLiang").val(rowHuoPinDatagrid.DaiShangJiaShu);
}
}
function JiaGongShangJia() { //点击上架按钮,将待上架货品更新到已上架datagrid里
var rowHuoPinDatagrid = $('#tb加工待上架').datagrid('getSelected');
$('#tb加工已上架').datagrid('appendRow',
{ StorageID: StorageID,
MachiningGoodsID: rowHuoPinDatagrid.MachiningGoodsID,
MachiningOrdersInformationID: rowHuoPinDatagrid.MachiningOrdersInformationID,
StorageNumber: $('#ChuWeiBianMa').val(),
DistrictCoding: $('#QuBianMa').val(),
GoodsID: rowHuoPinDatagrid.GoodsID,
GoodsCoding: $("#HuoPinBianMa").val(),
GoodsName: rowHuoPinDatagrid.GoodsName,
Standard: rowHuoPinDatagrid.Standard,
Model: rowHuoPinDatagrid.Model,
Batch: $("#PiCi").val(),
UnitID: rowHuoPinDatagrid.UnitID,
Unit: rowHuoPinDatagrid.Unit,
QualityID: $("#ZhiLiangZhuangTai").combobox('getValue'),
Quality: $("#ZhiLiangZhuangTai").combobox('getText'),
Quantity: $("#ShuLiang").val()
});
$.getJSON("/LiuTongJiaGongZuoYe/UdataShuLian?MachiningGoodsID=" + rowHuoPinDatagrid.MachiningGoodsID +
"&ShenYuShuLiang=" + $("#ShuLiang").val(),
function (data) { //上架后,改变库存数量
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + rowHuoPinDatagrid.MachiningOrdersInformationID,
function (data) {
$('#tb加工待上架').datagrid('loadData', data);
});
}
});
}
function returnBtnquXiao(GoodsID, row, rowIndex) {
return "<a href='javascript:quXiao(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="取消" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
} //点击已上架datagrid里的取消按钮,恢复库存数量
function quXiao(GoodsID, rowIndex) {
var row = $('#tb加工已上架').datagrid('getSelected');
$.getJSON("/LiuTongJiaGongZuoYe/UdataQuantity?MachiningGoodsID=" + row.MachiningGoodsID +
"&ShenYuShuLiang=" + row.Quantity, function (data) {
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersInformationID,
function (data) {
$('#tb加工待上架').datagrid('loadData', data);
});
$('#tb加工已上架').datagrid('cancelEdit', rowIndex)
.datagrid('deleteRow', rowIndex);
}
});
}
var EditIndex = undefined;
function endEditing() { //编辑状态,在datagrid里的下拉框,编辑结束后,显示下拉框的内容
if (EditIndex == undefined) { return true }
if ($('#tb贴签明细').datagrid('validateRow', EditIndex)) { //判定行状态
var ed = $('#tb贴签明细').datagrid('getEditor', { index: EditIndex, field: 'AttributeDetailedID' });
var dw = $('#tb贴签明细').datagrid('getEditor', { index: EditIndex, field: 'DanWeiID' });
if (ed == null) {
$('#tb贴签明细').datagrid('endEdit', EditIndex);
EditIndex = undefined;
return true;
} else {
var AttributeDetailedName = $(ed.target).combobox('getText');
$('#tb贴签明细').datagrid('getRows')[EditIndex]['AttributeDetailedName'] = AttributeDetailedName;
var Name = $(dw.target).combobox('getText');
$('#tb贴签明细').datagrid('getRows')[EditIndex]['Name'] = Name;
$('#tb贴签明细').datagrid('endEdit', EditIndex);
EditIndex = undefined;
return true;
}
} else {
return false;
}
}
function onClickRow(index) { //单击预联合已调度datagrid启用编辑
if (EditIndex != index) {
if (endEditing()) {
$('#tb贴签明细').datagrid('selectRow', index)
.datagrid('beginEdit', index);
EditIndex = index;
var row = $('#tb贴签明细').datagrid('getSelected');
} else {
$('#tb贴签明细').datagrid('selectRow', EditIndex);
}
}
}
function onDblClickRow() { //加工类型是贴签时,双击datagrid,打开货品信息
$('#HuoPinXinXi').window('open');
}
//双击行事件,把弹出窗口'#w产品资料'关闭,并获取双击那一行的数据,并把它的值赋值给‘双击单元格事件’中那一行
function DblHuoPinDatagrid() {
$('#HuoPinXinXi').window('close');
var rowShangPingDatagrid = $('#tb货品信息').datagrid('getSelected');
var rowMingXi = $('#tb贴签明细').datagrid('getSelected');
rowMingXi.MachiningGoodsID = rowShangPingDatagrid.MachiningGoodsID;
rowMingXi.MachiningOrdersInformationID = rowShangPingDatagrid.MachiningOrdersInformationID;
rowMingXi.GoodsID = rowShangPingDatagrid.GoodsID;
rowMingXi.Storeroom = rowShangPingDatagrid.Storeroom;
rowMingXi.GoodsCoding = rowShangPingDatagrid.GoodsCoding;
rowMingXi.GoodsName = rowShangPingDatagrid.GoodsName;
rowMingXi.Standard = rowShangPingDatagrid.Standard;
rowMingXi.Model = rowShangPingDatagrid.Model;
rowMingXi.DanWeiID = rowShangPingDatagrid.UnitID;
rowMingXi.Unit = rowShangPingDatagrid.Unit;
rowMingXi.AttributeDetailedID = rowShangPingDatagrid.QualityID;
rowMingXi.Quality = rowShangPingDatagrid.Quality;
rowMingXi.Batch = rowShangPingDatagrid.Batch;
rowMingXi.Quantity = rowShangPingDatagrid.Quantity;
rowMingXi.DaiShangJiaShu = "0.00";
var data = $('#tb贴签明细').datagrid('getData');
$('#tb贴签明细').datagrid('refreshRow', EditIndex); //refreshRow:刷新一行
if (EditIndex == data.rows.length - 1) {//添加一行空白行
$('#tb贴签明细').datagrid("insertRow", {
index: data.rows.length,
row: {}
});
}
}
var MachiningWarningSchedulingID = 0;
function JiaGongDiaoDu() { //加工调度
if (confirm("是否调度?")) { //新增加工预调度
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningScheduling?MachiningOrdersInformationID=" + OrdersInformationID +
"&WorkPlanNumber=" + $('#txtZuoYeJiHuaDanHao').val() +
"&MachiningTypeID=" + MachiningTypeID, function (data) {
MachiningWarningSchedulingID = data;//返回该数据的主键ID值
if (data != 0) {
var rowMingXi = $('#tb加工已拣货').datagrid('getData');//新增加工预处理的拣货信息
for (var i = 0; i < rowMingXi.rows.length; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningChooseGoodsScheduling?MachiningWarningSchedulingID=" + MachiningWarningSchedulingID +
"&MachiningTypeID=" + MachiningTypeID +
"&StorageID=" + rowMingXi.rows[i].StorageID +
"&GoodsID=" + rowMingXi.rows[i].GoodsID +
"&MachiningGoodsID=" + rowMingXi.rows[i].MachiningGoodsID +
"&Batch=" + rowMingXi.rows[i].Batch +
"&Quantity=" + rowMingXi.rows[i].Quantity +
"&QualityID=" + rowMingXi.rows[i].QualityID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
var row = $('#tb加工已上架').datagrid('getData'); //新增加工预处理的上架信息
for (var i = 0; i < rowMingXi.rows.length; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningGroundingScheduling?MachiningWarningSchedulingID=" + MachiningWarningSchedulingID +
"&MachiningTypeID=" + MachiningTypeID +
"&StorageID=" + row.rows[i].StorageID +
"&GoodsID=" + row.rows[i].GoodsID +
"&MachiningGoodsID=" + row.rows[i].MachiningGoodsID +
"&Batch=" + row.rows[i].Batch +
"&Quantity=" + row.rows[i].Quantity +
"&QualityID=" + row.rows[i].QualityID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningResourceScheduling?MachiningWarningSchedulingID=" + MachiningWarningSchedulingID +
"&NeedGrossWeight=" + $('#txtHuoPinZongZhongLiang').val() +
"&NeedGrossBulk=" + $('#txtHuoPinZongTiJi').val(), function (data) { //新增预处理所需要的资源
if (data != 0) {
alert("调度完成!");
$('#tb加工预处理').datagrid('reload');
var row = $('#tb加工已拣货').datagrid('getData');//调度完成后,清空datagrid里的数据
for (var i = 0; i < row.rows.length + 1; i++) {
$('#tb加工已拣货').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
var rowData = $('#tb加工已上架').datagrid('getData'); //调度完成后,清空datagrid里的数据
for (var i = 0; i < rowData.rows.length + 1; i++) {
$('#tb加工已上架').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
} else {
alert("调度失败!");
}
});
}
});
}
}
function JiaGogTieQianDiaoDu() { //加工预处理贴签调度
if (confirm("是否调度?")) { //加工类型是贴签时的预处理,新增加工预调度
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningScheduling?MachiningOrdersInformationID=" + OrdersInformationID +
"&WorkPlanNumber=" + $('#txtZuoYeJiHuaDanhao').val() +
"&MachiningTypeID=" + MachiningTypeID, function (data) {
MachiningWarningSchedulingID = data; //返回该数据的主键ID值
if (data != 0) {
var row = $('#tb贴签明细').datagrid('getData');//新增贴签的货品信息
for (var i = 0; i < row.rows.length - 1; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningLabelDetailed?MachiningWarningSchedulingID=" + MachiningWarningSchedulingID +
"&MachiningTypeID=" + MachiningTypeID +
"&StorageID=" + StorageiD +
"&GoodsID=" + row.rows[i].GoodsID +
"&Batch=" + row.rows[i].Batch +
"&Quantity=" + row.rows[i].Quantity +
"&MachiningQuantity=" + row.rows[i].DaiShangJiaShu +
"&QualityID=" + row.rows[i].AttributeDetailedID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningWarningResourceScheduling?MachiningWarningSchedulingID=" + MachiningWarningSchedulingID +
"&NeedGrossWeight=" + $('#HuoPinZongZhongliang').val() +
"&NeedGrossBulk=" + $('#HuoPinZongTiji').val(), function (data) {//新增预处理所需要的资源
if (data != 0) {
alert("调度完成!");
$('#tb加工预处理').datagrid('reload');
var rowData = $('#tb贴签明细').datagrid('getData');
for (var i = 0; i < rowData.rows.length; i++) {
$('#tb贴签明细').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
}
});
}
});
}
}
function returnBtnZuoYeZiyuan(WarehousingWarningWorkID, row, rowIndex) {
return "<a href='javascript:ZuoYeZiYuan(" + WarehousingWarningWorkID + "," + rowIndex + ")'>" + '<input type="button" value="作业资源" style="font-size: 15px;width:80px; font-family: 楷体;" />' + "</a>";
}
function returnBtnShanChu(MachiningWarningSchedulingID, row, rowIndex) {
return "<a href='javascript:ShanChu(" + MachiningWarningSchedulingID + "," + rowIndex + ")'>" + '<img src="../../Content/图片/删除.jpg" />' + "</a>";
} //在加工预处理查询界面,当点击删除图标时,可执行下面删除方法
function ShanChu(MachiningWarningSchedulingID, rowIndex) { //先删除主表信息,在将子表信息一起删除
if (confirm("是否删除?")) {
var row = $("#tb加工预处理").datagrid('getSelected');
$.getJSON("/LiuTongJiaGongZuoYe/DelectMachiningWarningScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/DelectMachiningWarningResourceScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
if (data == "true") {
if (row.MachiningTypeID == 124) { //当加工类型是贴签时,删除贴签的子表信息
$.getJSON("/LiuTongJiaGongZuoYe/DelectMachiningWarningLabelDetailed?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
if (data == "true") {
alert("删除成功!")
$('#tb加工预处理').datagrid('reload');
}
});
} else { //不是贴签就删除组合或包装的信息
$.getJSON("/LiuTongJiaGongZuoYe/DelectMachiningWarningChooseGoodsScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
if (data == "true") {
$('#tb加工预处理').datagrid('reload');
}
});
$.getJSON("/LiuTongJiaGongZuoYe/DelectMachiningWarningGroundingScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) {
if (data == "true") {
alert("删除成功!")
$('#tb加工预处理').datagrid('reload');
}
});
}
}
});
}
});
} else {
return null;
}
}
//&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&加工反馈部分&&&&&&&&&&&&&&&&&&&&&&&&//
function FanKuiChaXun() { //加工反馈模糊查询
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningScheduling?NeiRong=" + $("#ZuoYeJiHuaDan").val(), function (data) {
$('#tb加工反馈').datagrid('loadData', data);
});
}
function FanKuiChaXunMingXi() { //单击加工反馈datagrid,查询明细
var row = $("#tb加工反馈").datagrid('getSelected');
if (row.MachiningTypeID == 124) { //在加工反馈查询界面,当加工类型是贴签时,点击datagrid里的数据,可以将贴签的货品信息显示出来
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningLabelScheduling?MachiningSchedulingID=" + row.MachiningSchedulingID,
function (data) {
$("#tb加工反馈拣货明细").datagrid('loadData', data);
});
$("#WW").panel('close');
} else { //在加工反馈查询界面,当加工类型是组合和包装时,点击datagrid里的数据,可以将拣货和上架的货品信息显示出来
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningChooseGoodsScheduling?MachiningSchedulingID=" + row.MachiningSchedulingID,
function (data) {
$("#tb加工反馈拣货明细").datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGroundingScheduling?MachiningSchedulingID=" + row.MachiningSchedulingID,
function (data) {
$("#tb加工反馈上架明细").datagrid('loadData', data);
});
$("#WW").panel('open');
}
}
var OrdersInformationiD = 0;
var MachiningTypeiD = 0;
var MachiningOrdersInformationiD = 0;
function addJiaGongFanKui() {
var row = $("#tb加工预处理").datagrid('getSelected');
if (row != null) {
OrdersInformationiD = row.OrdersInformationID;
MachiningTypeiD = row.MachiningTypeID;
MachiningOrdersInformationiD = row.MachiningOrdersDetailedID;
if (row.MachiningTypeID == 124) { //当加工类型是贴签时,打开贴签选项卡
$('#tbChuKuZuoYe').tabs('add', { //添加新的选项卡
title: '加工反馈',
content: $('#tbJiaGongFanKuiTieQian').panel('open'),
closable: true
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingMachiningWarningLabelDetailed?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) { // 加载贴签货品信息
$('#tb反馈贴签明细').datagrid('loadData', data);
var row = $('#tb反馈贴签明细').datagrid('getData');
$('#tb反馈贴签明细').datagrid("insertRow", {
index: row.rows.length,
row: {}
});
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingMachiningWarningResourceScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) { //加载贴签资源
$('#HuoPinZongzhongliang').attr('value', data[0].NeedGrossWeight);
$('#HuoPinZongtiji').attr('value', data[0].NeedGrossBulk);
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) {
$('#tb反馈货品信息').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingDinDanXinXiByID?MachiningOrdersInformationID=" + row.OrdersInformationID,
function (data) { //加载基本信息
KuFangID = data[0].StoreroomID;
$('#ZuoYeJiHuaDanhao').attr('value', row.WorkPlanNumber);
$('#DingDanhao').attr('value', data[0].OrdersMark);
$('#KuHuma').attr('value', data[0].ClientCode);
$('#Leixing').attr('value', data[0].OrdersType);
$('#KuFangBianma').attr('value', data[0].StoreroomCoding);
$('#Zhuangtai').attr('value', data[0].State);
$('#KuFangBianma').attr('value', row.Storeroom);
$('#ZhiYaYinhang').attr('value', data[0].PledgeBank);
});
} else {
$('#tbChuKuZuoYe').tabs('add', { //添加新的选项卡
title: '加工反馈',
content: $('#tbJiaGongFanKui').panel('open'),
closable: true
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingMachiningWarningChooseGoodsScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) { //加载已拣货货品信息
$('#tb加工反馈已拣货').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingMachiningWarningGroundingScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) { //加载已上架货品信息
$('#tb加工反馈已上架').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) { //加载待拣货货品信息
$('#tb加工反馈待拣货').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + row.MachiningOrdersDetailedID,
function (data) { //加载待上架货品信息
$('#tb加工反馈待上架').datagrid('loadData', data);
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingMachiningWarningResourceScheduling?MachiningWarningSchedulingID=" + row.MachiningWarningSchedulingID,
function (data) { //加载反馈所需要的资源
$('#HuoPinZongZhongLiang').attr('value', data[0].NeedGrossWeight);
$('#HuoPinZongTiJi').attr('value', data[0].NeedGrossBulk);
});
$.getJSON("/LiuTongJiaGongZuoYe/BangDingDinDanXinXiByID?MachiningOrdersInformationID=" + row.OrdersInformationID,
function (data) { //加载基本信息
KuFangID = data[0].StoreroomID;
$('#ZuoYeJiHuaDanHao').attr('value', row.WorkPlanNumber);
$('#DingDanHao').attr('value', data[0].OrdersMark);
$('#KuHuMa').attr('value', data[0].ClientCode);
$('#LeiXing').attr('value', data[0].OrdersType);
$('#KuFangBianMa').attr('value', data[0].StoreroomCoding);
$('#ZhuangTai').attr('value', data[0].State);
$('#KuFangBianMa').attr('value', row.Storeroom);
$('#ZhiYaYinHang').attr('value', data[0].PledgeBank);
});
}
} else {
alert("请先选择一行数据!!!");
}
}
function Xuanxe() { //反馈组合和包装储位
$.getJSON("/LiuTongJiaGongZuoYe/SelectStoreroom?StoreroomID=" + KuFangID,
function (data) {
$('#tb储位').datagrid('loadData', data);
});
$("#ChuWei").window('open');
}
var FKStorageID = 0;
var TiJi = 0;
var ChengZhong = 0;
var DistrictID = 0;
function DblOpenChuWei() {
var row = $("#tb储位").datagrid('getSelected');
if (row) {
FKStorageID = row.StorageID;
TiJi = row.Cubage;
ChengZhong = row.BearWeight;
DistrictID = row.DistrictID;
$('#ChuWeibianma').val(row.StorageNumber);
$('#Qubianma').val(row.DistrictCoding);
$('#txtChuWeiBianMa').val(row.StorageNumber);
$('#txtQuBianMa').val(row.DistrictCoding);
$("#ChuWei").window('close');
}
}
function FKPanDuanTiJi() { //加工反馈判断加工总体积与库存总体积
if (parseInt($("#HuoPinZongTiJi").val()) > parseInt(TiJi)) {
alert("货品总体积【" + parseInt($("#HuoPinZongTiJi").val()) + "】大于"
+ "库存总体积【" + parseInt(TiJi) + "】不允许加工");
}
}
function FKPanDuanChengZhong() { //加工反馈判断加工总重量与库存总承重
if (parseInt($("#HuoPinZongZhongLiang").val()) > parseInt(ChengZhong)) {
alert("货品总重量【" + parseInt($("#HuoPinZongZhongLiang").val()) + "】大于"
+ "库存总承重【" + parseInt(ChengZhong) + "】不允许加工");
}
}
function FKXuanxe() { //反馈贴签储位
$.getJSON("/LiuTongJiaGongZuoYe/SelectStoreroom?StoreroomID=" + KuFangID,
function (data) {
$('#tb反馈贴签储位').datagrid('loadData', data);
});
$("#FKChuWei").window('open');
}
var FKStorageiD = 0;
function DblOpenFKChuWei() {
var row = $("#tb反馈贴签储位").datagrid('getSelected');
if (row) {
FKStorageiD = row.StorageID;
$('#FKChuWeiBianma').val(row.StorageNumber);
$('#FKQuBianma').val(row.DistrictCoding);
$("#FKChuWei").window('close');
}
}
function onDblClickRowOpenHuoPin() { //双击反馈贴签明细datagrid,打开货品信息
$('#FKHuoPinXinXi').window('open');
}
//双击行事件,把弹出窗口'#w产品资料'关闭,并获取双击那一行的数据,并把它的值赋值给‘双击单元格事件’中那一行
function DblFKHuoPinDatagrid() {
$('#FKHuoPinXinXi').window('close');
var rowShangPingDatagrid = $('#tb反馈货品信息').datagrid('getSelected');
var rowMingXi = $('#tb反馈贴签明细').datagrid('getSelected');
rowMingXi.MachiningWarningLabelDetailedID = rowShangPingDatagrid.MachiningWarningLabelDetailedID;
rowMingXi.MachiningOrdersInformationID = rowShangPingDatagrid.MachiningOrdersInformationID;
rowMingXi.GoodsID = rowShangPingDatagrid.GoodsID;
rowMingXi.Storeroom = rowShangPingDatagrid.Storeroom;
rowMingXi.GoodsCoding = rowShangPingDatagrid.GoodsCoding;
rowMingXi.GoodsName = rowShangPingDatagrid.GoodsName;
rowMingXi.Standard = rowShangPingDatagrid.Standard;
rowMingXi.Model = rowShangPingDatagrid.Model;
rowMingXi.DanWeiID = rowShangPingDatagrid.UnitID;
rowMingXi.Unit = rowShangPingDatagrid.Unit;
rowMingXi.AttributeDetailedID = rowShangPingDatagrid.QualityID;
rowMingXi.Quality = rowShangPingDatagrid.Quality;
rowMingXi.Batch = rowShangPingDatagrid.Batch;
rowMingXi.Quantity = rowShangPingDatagrid.Quantity;
rowMingXi.DaiShangJiaShu = "0.00";
var data = $('#tb反馈贴签明细').datagrid('getData');
$('#tb反馈贴签明细').datagrid('refreshRow', Editindex); //refreshRow:刷新一行
if (Editindex == data.rows.length - 1) {//添加一行空白行
$('#tb反馈贴签明细').datagrid("insertRow", {
index: data.rows.length,
row: {}
});
}
}
var Editindex = undefined;
function EndEditing() { //编辑状态,在datagrid里的下拉框,编辑结束后,显示下拉框的内容
if (Editindex == undefined) { return true }
if ($('#tb反馈贴签明细').datagrid('validateRow', Editindex)) { //判定行状态
var ed = $('#tb反馈贴签明细').datagrid('getEditor', { index: Editindex, field: 'AttributeDetailedID' });
var dw = $('#tb反馈贴签明细').datagrid('getEditor', { index: Editindex, field: 'DanWeiID' });
if (ed == null) {
$('#tb反馈贴签明细').datagrid('endEdit', Editindex);
Editindex = undefined;
//return true;
} else {
var AttributeDetailedName = $(ed.target).combobox('getText');
$('#tb反馈贴签明细').datagrid('getRows')[Editindex]['AttributeDetailedName'] = AttributeDetailedName;
var Name = $(dw.target).combobox('getText');
$('#tb反馈贴签明细').datagrid('getRows')[Editindex]['Name'] = Name;
$('#tb反馈贴签明细').datagrid('endEdit', Editindex);
Editindex = undefined;
}
return true;
} else {
return false;
}
}
function onFKClickRow(index) { //单击反馈已调度datagrid启用编辑
if (Editindex != index) {
if (EndEditing()) {
$('#tb反馈贴签明细').datagrid('selectRow', index)
.datagrid('beginEdit', index);
Editindex = index;
} else {
$('#tb反馈贴签明细').datagrid('selectRow', Editindex);
}
}
}
function JianHuoFKDblHuoPin() { //加工反馈待拣货datagrid里的双击事件
var rowHuoPinDatagrid = $('#tb加工反馈待拣货').datagrid('getSelected');
$('#tb加工反馈待拣货').datagrid('endEdit', editIndex);
var ZongShu = parseInt(rowHuoPinDatagrid.Quantity);
var ShangJiaShu = parseInt(rowHuoPinDatagrid.ShuChuShuLian);
if (ShangJiaShu > ZongShu) {
alert("待上架数【" + ShangJiaShu + "】大于作业总数【" + ZongShu + "】");
} else {
$("#HuoPinbianMa").val(rowHuoPinDatagrid.GoodsCoding);
$("#ZhiLiangZhuangtai").combobox('setValue', rowHuoPinDatagrid.QualityID);
$("#Shuliang").val(rowHuoPinDatagrid.ShuChuShuLian);
}
}
function JiaGongFKJianHuo() { //点击拣货按钮,将待拣货的货品信息更新到已拣货datagrid里
var rowHuoPinDatagrid = $('#tb加工反馈待拣货').datagrid('getSelected');
$('#tb加工反馈已拣货').datagrid('appendRow',
{ StorageID: FKStorageID,
MachiningGoodsID: rowHuoPinDatagrid.MachiningGoodsID,
MachiningOrdersInformationID: rowHuoPinDatagrid.MachiningOrdersInformationID,
StorageNumber: $('#ChuWeibianma').val(),
DistrictCoding: $('#Qubianma').val(),
Storeroom: rowHuoPinDatagrid.Storeroom,
GoodsID: rowHuoPinDatagrid.GoodsID,
GoodsCoding: $("#HuoPinbianMa").val(),
GoodsName: rowHuoPinDatagrid.GoodsName,
Standard: rowHuoPinDatagrid.Standard,
Model: rowHuoPinDatagrid.Model,
Batch: $("#piCi").val(),
UnitID: rowHuoPinDatagrid.UnitID,
Unit: rowHuoPinDatagrid.Unit,
QualityID: $("#ZhiLiangZhuangtai").combobox('getValue'),
Quality: $("#ZhiLiangZhuangtai").combobox('getText'),
Quantity: $("#Shuliang").val()
});
$.getJSON("/LiuTongJiaGongZuoYe/UdataShuLian?MachiningGoodsID=" + rowHuoPinDatagrid.MachiningGoodsID +
"&ShenYuShuLiang=" + $("#Shuliang").val(),
function (data) { //拣货后,改变库存数量
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + MachiningOrdersInformationiD,
function (data) {
$('#tb加工反馈待拣货').datagrid('loadData', data);
});
}
});
}
function returnBtnFKQuXiao(GoodsID, row, rowIndex) {
return "<a href='javascript:FKQuXiao(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="取消" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
} //点击反馈已拣货datagrid里的取消按钮后,可以恢复库存数量
function FKQuXiao(GoodsID, rowIndex) {
var row = $('#tb加工反馈已拣货').datagrid('getSelected');
$.getJSON("/LiuTongJiaGongZuoYe/UdataQuantity?MachiningGoodsID=" + row.MachiningGoodsID +
"&ShenYuShuLiang=" + row.Quantity, function (data) {
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + MachiningOrdersInformationiD,
function (data) {
$('#tb加工反馈待拣货').datagrid('loadData', data);
});
$('#tb加工反馈已拣货').datagrid('cancelEdit', rowIndex)
.datagrid('deleteRow', rowIndex);
}
});
}
function returnBtnFKKuCun(GoodsID, row, rowIndex) {
return "<a href='javascript:FKKuCun(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="库存" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
}//在待拣货的datagrid中,点击库存按钮,可以查询该货品的详细信息
function FKKuCun(GoodsID, rowIndex) {
$.getJSON("/LiuTongJiaGongZuoYe/SelectInventory?GoodsID=" + GoodsID,
function (data) {
$('#tb拣货库存').datagrid('loadData', data);
});
}
function FKDblHuoPin() { //加工反馈待上架datagrid里的双击事件
var rowHuoPinDatagrid = $('#tb加工反馈待上架').datagrid('getSelected');
$('#tb加工反馈待上架').datagrid('endEdit', editIndex);
var ZongShu = parseInt(rowHuoPinDatagrid.Quantity);
var ShangJiaShu = parseInt(rowHuoPinDatagrid.DaiShangJiaShu);
if (ShangJiaShu > ZongShu) {
alert("待上架数【" + ShangJiaShu + "】大于作业总数【" + ZongShu + "】");
} else {
$("#txtHuoPinBianMa").val(rowHuoPinDatagrid.GoodsCoding);
$("#cboZhiLiangZhuangTai").combobox('setValue', rowHuoPinDatagrid.QualityID);
$("#txtShuLiangs").val(rowHuoPinDatagrid.DaiShangJiaShu);
}
}
function JiaGongFKShangJia() { //加工反馈上架
var rowHuoPinDatagrid = $('#tb加工反馈待上架').datagrid('getSelected');
$('#tb加工反馈已上架').datagrid('appendRow',
{ StorageID: FKStorageID,
MachiningGoodsID: rowHuoPinDatagrid.MachiningGoodsID,
MachiningOrdersInformationID: rowHuoPinDatagrid.MachiningOrdersInformationID,
StorageNumber: $('#txtChuWeiBianMa').val(),
DistrictCoding: $('#txtQuBianMa').val(),
GoodsID: rowHuoPinDatagrid.GoodsID,
GoodsCoding: $("#txtHuoPinBianMa").val(),
GoodsName: rowHuoPinDatagrid.GoodsName,
Standard: rowHuoPinDatagrid.Standard,
Model: rowHuoPinDatagrid.Model,
Batch: $("#txtPiCi").val(),
UnitID: rowHuoPinDatagrid.UnitID,
Unit: rowHuoPinDatagrid.Unit,
QualityID: $("#cboZhiLiangZhuangTai").combobox('getValue'),
Quality: $("#cboZhiLiangZhuangTai").combobox('getText'),
Quantity: $("#txtShuLiangs").val()
});
$.getJSON("/LiuTongJiaGongZuoYe/UdataShuLian?MachiningGoodsID=" + rowHuoPinDatagrid.MachiningGoodsID +
"&ShenYuShuLiang=" + $("#txtShuLiangs").val(),
function (data) { //上架后,改变库存数量
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + MachiningOrdersInformationiD,
function (data) {
$('#tb加工反馈待上架').datagrid('loadData', data);
});
}
});
}
function returnBtnFKquXiao(GoodsID, row, rowIndex) {
return "<a href='javascript:FKquXiao(" + GoodsID + "," + rowIndex + ")'>" + '<input type="button" value="取消" style="font-size: 15px;width:60px; font-family: 楷体;" />' + "</a>";
} //点击反馈已上架datagrid里的取消按钮后,可以恢复库存数量
function FKquXiao(GoodsID, rowIndex) {
var row = $('#tb加工反馈已上架').datagrid('getSelected');
$.getJSON("/LiuTongJiaGongZuoYe/UdataQuantity?MachiningGoodsID=" + row.MachiningGoodsID +
"&ShenYuShuLiang=" + row.Quantity, function (data) {
if (data == "true") {
$.getJSON("/LiuTongJiaGongZuoYe/SelectMachiningGoods?MachiningOrdersInformationID=" + MachiningOrdersInformationiD,
function (data) {
$('#tb加工反馈待上架').datagrid('loadData', data);
});
$('#tb加工反馈已上架').datagrid('cancelEdit', rowIndex)
.datagrid('deleteRow', rowIndex);
}
});
}
function returnBtnZuoYeZiYuan(WarehousingWarningWorkID, row, rowIndex) {
return "<a href='javascript:ZuoYeZiYuan(" + WarehousingWarningWorkID + "," + rowIndex + ")'>" + '<input type="button" value="作业资源" style="font-size: 15px;width:80px; font-family: 楷体;" />' + "</a>";
}
var MachiningSchedulingID = 0;
function JiaGongFanKuiDiaoDu() { //加工反馈调度
if (confirm("是否调度?")) { //新增加工反馈信息
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningScheduling?MachiningOrdersInformationID=" + OrdersInformationiD +
"&WorkPlanNumber=" + $('#ZuoYeJiHuaDanHao').val() +
"&MachiningTypeID=" + MachiningTypeiD, function (data) {
MachiningSchedulingID = data;//返回该信息的主键ID
if (data != 0) {
var rowMingXi = $('#tb加工反馈已拣货').datagrid('getData'); //新增反馈已拣货货品信息
for (var i = 0; i < rowMingXi.rows.length; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningChooseGoodsScheduling?MachiningSchedulingID=" + MachiningSchedulingID +
"&MachiningTypeID=" + MachiningTypeiD +
"&StorageID=" + rowMingXi.rows[i].StorageID +
"&GoodsID=" + rowMingXi.rows[i].GoodsID +
"&Batch=" + rowMingXi.rows[i].Batch +
"&Quantity=" + rowMingXi.rows[i].Quantity +
"&QualityID=" + rowMingXi.rows[i].QualityID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
var row = $('#tb加工反馈已上架').datagrid('getData'); //新增反馈已上架货品信息
for (var i = 0; i < rowMingXi.rows.length; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningGroundingScheduling?MachiningSchedulingID=" + MachiningSchedulingID +
"&MachiningTypeID=" + MachiningTypeiD +
"&StorageID=" + row.rows[i].StorageID +
"&GoodsID=" + row.rows[i].GoodsID +
"&Batch=" + row.rows[i].Batch +
"&Quantity=" + row.rows[i].Quantity +
"&QualityID=" + row.rows[i].QualityID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningResourceScheduling?MachiningSchedulingID=" + MachiningSchedulingID +
"&NeedGrossWeight=" + $('#HuoPinZongZhongLiang').val() +
"&NeedGrossBulk=" + $('#HuoPinZongTiJi').val(), function (data) { //加工反馈所需要的资源
if (data != 0) {
$.getJSON("/RuKuZuoYe/UpdataQuTiJi?DistrictID=" + DistrictID +
"&TiJi=" + $("#HuoPinZongTiJi").val() +
"&ShuLiang=" + $('#HuoPinZongZhongLiang').val(), function (data) {
alert("调度完成!");
$('#tb加工反馈').datagrid('reload');
var row = $('#tb加工反馈已拣货').datagrid('getData');//反馈完成后,清空datagrid里的数据
for (var i = 0; i < row.rows.length + 1; i++) {
$('#tb加工反馈已拣货').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
var rowData = $('#tb加工反馈已上架').datagrid('getData'); //反馈完成后,清空datagrid里的数据
for (var i = 0; i < rowData.rows.length + 1; i++) {
$('#tb加工反馈已上架').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
});
} else {
alert("调度失败!");
}
});
}
});
}
}
function JiaGogFanKuiTieQianDiaoDu() { //加工反馈贴签调度
if (confirm("是否调度?")) { //加工类型是贴签时,新增加工反馈信息
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningScheduling?MachiningOrdersInformationID=" + OrdersInformationiD +
"&WorkPlanNumber=" + $('#ZuoYeJiHuaDanhao').val() +
"&MachiningTypeID=" + MachiningTypeiD, function (data) {
MachiningSchedulingID = data;
if (data != 0) {
var row = $('#tb反馈贴签明细').datagrid('getData'); //新增加工反馈贴签货品信息
for (var i = 0; i < row.rows.length - 1; i++) {
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningLabelScheduling?MachiningSchedulingID=" + MachiningSchedulingID +
"&MachiningTypeID=" + MachiningTypeiD +
"&StorageID=" + FKStorageiD +
"&GoodsID=" + row.rows[i].GoodsID +
"&Batch=" + row.rows[i].Batch +
"&Quantity=" + row.rows[i].Quantity +
"&MachiningQuantity=" + row.rows[i].DaiShangJiaShu +
"&QualityID=" + row.rows[i].AttributeDetailedID, function (data) {
if (data == "flase") {
alert("调度失败!");
}
});
}
$.getJSON("/LiuTongJiaGongZuoYe/InsertMachiningResourceScheduling?MachiningSchedulingID=" + MachiningSchedulingID +
"&NeedGrossWeight=" + $('#HuoPinZongzhongliang').val() +
"&NeedGrossBulk=" + $('#HuoPinZongtiji').val(), function (data) { //加工反馈所需要的资源
if (data != 0) {
alert("调度完成!");
$('#tb加工反馈').datagrid('reload');
var rowData = $('#tb反馈贴签明细').datagrid('getData');
for (var i = 0; i < rowData.rows.length; i++) {
$('#tb反馈贴签明细').datagrid('cancelEdit', 0).datagrid('deleteRow', 0);
}
}
});
}
});
}
}
</script>