下推保存实现

WYB

2021-04-07 f212d34d050fcb7d368661ac3b90c956f1602ec9

下推保存实现

 WebAPI/Controllers/Sc_ProcessMangementController.cs

@@ -251,31 +251,50 @@
                List<WebAPI.Models.Sc_ProcessPlanViewModel> ls = new List<WebAPI.Models.Sc_ProcessPlanViewModel>();
                ls = oListModels.getObjectByJson_SendWorkSub(msg3);
                int i = 0;
                Model.ClsSc_ProcessSendWorkSub sendworksub = new Model.ClsSc_ProcessSendWorkSub();
                List<Model.ClsSc_ProcessSendWorkSub> lss = new List<Model.ClsSc_ProcessSendWorkSub>();
                foreach (WebAPI.Models.Sc_ProcessPlanViewModel oItemSub in ls)
                {
                    
                    //foreach (var item in collection)
                    //{

                    //}
                    //i++;
                    //if (oItemSub.HQty <= 0)
                    //{
                    //    objJsonResult.code = "0";
                    //    objJsonResult.count = 0;
                    //    objJsonResult.Message = "保存失败！第" + i.ToString() + "行数量不大于0无法保存！";
                    //    objJsonResult.data = 1;
                    //    return objJsonResult;
                    //}
                    //if (oItemSub.HQty > oItemSub.HRelationQty)
                    //{
                    //    objJsonResult.code = "0";
                    //    objJsonResult.count = 0;
                    //    objJsonResult.Message = "保存失败！第" + i.ToString() + "行数量不能大于未关联数量！";
                    //    objJsonResult.data = 1;
                    //    return objJsonResult;
                    //}
                    i++;
                    Model.ClsSc_ProcessSendWorkSub sendworksub = new Model.ClsSc_ProcessSendWorkSub();
                    sendworksub.HProcID = oItemSub.hprocid.Value;//--工序ID
                    sendworksub.HProcPlanBillNo = oItemSub.工序计划单号; //--工序计划单号
                    sendworksub.HProcPlanEntryID = oItemSub.hsubid.Value; //--工序计划单子ID
                    sendworksub.HProcPlanInterID = oItemSub.hmainid.Value; //--工序计划单ID
                    sendworksub.HICMOInterID = oItemSub.hicmointerid.Value; //--任务单ID
                    sendworksub.HICMOBillNo = oItemSub.任务单号;  //--任务单号
                    sendworksub.HSeOrderBillNo = oItemSub.销售订单号; //--销售订单号
                    sendworksub.HSeOrderEntryID = oItemSub.销售订单子ID.Value; //--销售子ID
                    sendworksub.HSeOrderInterID = oItemSub.销售订单主ID.Value; //--销售订单主ID
                    sendworksub.HPlanTimes = (float)oItemSub.计划加工时间; //--计划工时
                    sendworksub.HPlanEndDate = oItemSub.计划完工日期.Value; //--计划完工日期
                    sendworksub.HPlanBeginDate = oItemSub.计划开工日期.Value; //--计划开工日期
                    sendworksub.HQty = (double)oItemSub.计划数量; //--派工数量
                    sendworksub.HWorkerNumber = oItemSub.操作员代码; //--操作工代码
                    sendworksub.HWorkerID = oItemSub.HWorkerID.Value; //--操作工ID
                    sendworksub.HGroupNumber = oItemSub.班组代码; //班组代码
                    sendworksub.HGroupID = oItemSub.HGroupID.Value;  //--班组ID
                    sendworksub.HSourceNumber = oItemSub.生产资源; //--生产资源代码
                    //--生产资源ID
                    sendworksub.HProcNumber = oItemSub.工序代码; //--工序代码
                    sendworksub.HRemark = oItemSub.表体备注;  //--备注

                    if (oItemSub.计划数量 <= 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！第" + i.ToString() + "行数量不大于0无法保存！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    if (Convert.ToInt32( sendworksub.HQty) > Convert.ToInt32( oItemSub.计划数量))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！第" + i.ToString() + "行派工数量不能大于计划单数量！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    //if (DBUtility.ClsPub.isStrNull(oItemSub.HBatChNo) == "")
                    //{
                    //    objJsonResult.code = "0";
@@ -285,14 +304,31 @@
                    //    return objJsonResult;
                    //}

                    //oItemSub.HEntryID = i;
                    //oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                    //oItemSub.HRemark = "";
                    //oItemSub.HCloseMan = "";
                    //oItemSub.HCloseType = false;
                    //Sendwork.DetailColl.Add(oItemSub);
                    sendworksub.HEntryID = i;
                    sendworksub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                    sendworksub.HRemark = "";
                    sendworksub.HCloseMan = "";
                    sendworksub.HCloseType = false;
                    sendworksub.HSourceBillType = oItemSub.HBillType;
                    lss.Add(sendworksub);//先把数据存放到派工单子表集合里
                


                }
                if (lss.Count > 0)
                {
                    //然后再循环保存到派工单子表的集合里
                    foreach (Model.ClsSc_ProcessSendWorkSub Itemsendwork in lss)
                    {
                        Sendwork.DetailColl.Add(Itemsendwork);
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！lss集合小于0";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                //保存
                //保存完毕后处理

 WebAPI/Models/Sc_ProcessPlanViewModel.cs

@@ -7,83 +7,83 @@
{
    public class Sc_ProcessPlanViewModel
    {
//      [hmainid], 
//[日期],
// [单据号], 
//[HMaterID],
// [物料代码], 
//[物料名称], 
//[规格型号], 
//[单位], 
//[hunitid], 
//[计量单位代码], 
//[计量单位], 
//[生产数量], 
//[计划开工日期], 
//[计划完工日期], 
//[摘要], 
//[表头备注], 
//[内部单据号], 
//[hicmointerid], 
//[任务单号], 
//[制单人], 
//[制单日期], 
//[审核人], 
//[审核日期], 
//[修改人], 
//[修改日期], 
//[关闭人], 
//[关闭日期],
// [关闭类型], 
//[作废人],
// [作废日期],
//[hsubid],
// [工序计划单号],
// [工序号],
// [hprocid], 
//[工序代码],
// [工序], 
//[加工说明], 
//[开工固天],
// [开工固数],
// [HCenterID],
// [工作中心代码],
// [工作中心], 
//[HDeptID], 
//[加工车间代码], 
//[加工车间],
// [HGroupID], 
//[班组代码], 
//[班组名称], 
//[HWorkerID], 
//[操作员代码], 
//[操作员],
// [HSourceID], 
//[资源代码], 
//[生产资源], 
//[计划数量], 
//[关联数量], 
//[时间单位], 
//[计划加工时间], 
//[工序计划开工日期], 
//[工序计划完工日期], 
//[准备时间], 
//[排队时间], 
//[转移时间], 
//[表体备注],
// [批次], 
//[源单主内码], 
//[源单子内码], 
//[源单单号], 
//[源单类型], 
//[销售订单主ID], 
//[销售订单子ID], 
//[销售订单号], 
//[HBillType],
// [单据类型], 
//[HBillSubType], 
//[HQtyDecimal],
// [HPriceDecimal]
        public Int64? hmainid;  //      [hmainid], 
        public DateTime? 日期;  //[日期],
        public string 单据号;      // [单据号], 
        public Int64? HMaterID;//[HMaterID],
        public string 物料代码;  // [物料代码], 
        public string 物料名称;//[物料名称], 
        public string 规格型号;//[规格型号], 
        public string 单位;//[单位], 
        public Int64? hunitid;//[hunitid], 
        public string 计量单位代码;//[计量单位代码], 
        public string 计量单位;//[计量单位], 
        public decimal 生产数量;//[生产数量], 
        public DateTime? 计划开工日期;//[计划开工日期], 
        public DateTime? 计划完工日期;//[计划完工日期], 
        public string 摘要;//[摘要], 
        public string 表头备注;//[表头备注], 
        public string 内部单据号;//[内部单据号], 
        public Int64? hicmointerid;//[hicmointerid], 
        public string 任务单号;//[任务单号], 
        public string 制单人;//[制单人], 
        public DateTime? 制单日期;//[制单日期], 
        public string 审核人;//[审核人], 
        public DateTime? 审核日期;//[审核日期], 
        public string 修改人;//[修改人], 
        public DateTime? 修改日期;//[修改日期], 
        public string 关闭人;//[关闭人], 
        public DateTime? 关闭日期;//[关闭日期],
        public bool 关闭类型;// [关闭类型], 
        public string 作废人;//[作废人],
        public DateTime? 作废日期;// [作废日期],
        public Int64? hsubid;//[hsubid],
        public string 工序计划单号;// [工序计划单号],
        public Int64? 工序号;// [工序号],
        public Int64? hprocid;// [hprocid], 
        public string 工序代码;//[工序代码],
        public string 工序;// [工序], 
        public string 加工说明;//[加工说明], 
        public decimal 开工固天;//[开工固天],
        public decimal 开工固数;// [开工固数],
        public Int64? HCenterID;// [HCenterID],
        public string 工作中心代码;// [工作中心代码],
        public string 工作中心;// [工作中心], 
        public Int64? HDeptID;//[HDeptID], 
        public string 加工车间代码;//[加工车间代码], 
        public string 加工车间;//[加工车间],
        public Int64? HGroupID;// [HGroupID], 
        public string 班组代码;//[班组代码], 
        public string 班组名称;//[班组名称], 
        public Int64? HWorkerID;//[HWorkerID], 
        public string 操作员代码;//[操作员代码], 
        public string 操作员;//[操作员],
        public Int64? HSourceID;// [HSourceID], 
        public string 资源代码;//[资源代码], 
        public string 生产资源;//[生产资源], 
        public decimal 计划数量;//[计划数量], 
        public decimal 关联数量;//[关联数量], 
        public string 时间单位;//[时间单位], 
        public decimal 计划加工时间;//[计划加工时间], 
        public DateTime? 工序计划开工日期;//[工序计划开工日期], 
        public DateTime? 工序计划完工日期;//[工序计划完工日期], 
        public decimal 准备时间;//[准备时间], 
        public decimal 排队时间;//[排队时间], 
        public decimal 转移时间;//[转移时间], 
        public string 表体备注;//[表体备注],
        public string 批次;// [批次], 
        public Int64? 源单主内码;//[源单主内码], 
        public Int64? 源单子内码;//[源单子内码], 
        public string 源单单号;//[源单单号], 
        public string 源单类型;//[源单类型], 
        public Int64? 销售订单主ID;//[销售订单主ID], 
        public Int64? 销售订单子ID;//[销售订单子ID], 
        public string 销售订单号;//[销售订单号], 
        public string HBillType;//[HBillType],
        public string 单据类型;// [单据类型], 
        public string HBillSubType;//[HBillSubType], 
        public Int64? HQtyDecimal;//[HQtyDecimal],
        public Int64? HPriceDecimal;// [HPriceDecimal]

    }
}

 WebAPI/Properties/PublishProfiles/API.pubxml.user

@@ -157,10 +157,10 @@
      <publishTime>11/24/2014 11:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>04/06/2021 11:06:14</publishTime>
      <publishTime>04/07/2021 17:34:23</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>04/06/2021 11:06:14</publishTime>
      <publishTime>04/07/2021 17:34:23</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>02/04/2021 21:35:21</publishTime>
@@ -334,7 +334,7 @@
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>04/06/2021 11:11:08</publishTime>
      <publishTime>04/07/2021 17:34:29</publishTime>
    </File>
  </ItemGroup>
</Project>