using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Http;
|
using WebAPI.Models;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System.Diagnostics;
|
using System.Threading;
|
using System.Globalization;
|
namespace WebAPI.Controllers.SCGL.日计划管理
|
{
|
public class JIT_DayPlanPlatFormBillController : ApiController
|
{
|
List<PRD_Inventory> ListInventory;//库存明细
|
private json objJsonResult = new json();
|
public DataSet ds = new DataSet();
|
public WebServer webserver = new WebServer();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
Sc_WorkBillSortBillMain omdelMian = new Sc_WorkBillSortBillMain();
|
public static string BillType = "4610";
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
|
#region 生产日计划平台 查询
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillList")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillList(string sWhere, string user)
|
{
|
try
|
{
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_WorkBillSortBill_Query", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查看权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
|
|
ds = oCN.RunProcReturn($"exec h_p_JIT_Sc_WorkBillSortBill_Query '{omdelMian.HPlanBeginDate}',{(omdelMian.HProdORGID == null ? 0 : omdelMian.HProdORGID)},'{omdelMian.HSeOrderBillNo}'" +
|
$",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}" +
|
$",'{omdelMian.HMastersDate}','{omdelMian.sWheres}'", "h_p_JIT_Sc_WorkBillSortBill_Query");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 根据ID查询 齐套状态 和 锁定状态
|
/// </summary>
|
/// <param name="sWhere"></param>
|
/// <param name="user"></param>
|
/// <returns></returns>
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHinterIDList(string sWhere,int num)
|
{
|
try
|
{
|
if (num == 1)
|
{
|
ds = oCN.RunProcReturn($"select isnull(DATEDIFF(DAY,GETDATE(),CONVERT(varchar(10),max(HMasterDate),20))+1,0) DayNum from Sc_WorkBillSortBillSub where HInterID in ({sWhere}) and HMasterDate>=CONVERT(varchar(10),GETDATE(),20) and HLockedSub=1", "Sc_WorkBillSortBillSub");
|
}
|
else if (num == 2)
|
{
|
ds = oCN.RunProcReturn($"select CONVERT(varchar(10),HMasterDate,20) HMasterDate,HComplete,HInterID from Sc_WorkBillSortBillSub where HInterID in ({sWhere}) and HMasterDate>=CONVERT(varchar(10),GETDATE(),20) and (HComplete='齐套' or HComplete='未齐套') ", "Sc_WorkBillSortBillSub");
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 根据点击行标题时间查询缺料分析
|
/// </summary>
|
/// <param name="sWhere"></param>
|
/// <param name="user"></param>
|
/// <returns></returns>
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHDateTimeList")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHDateTimeList(string sWhere)
|
{
|
try
|
{
|
MaterialShorAnalysis Report = JsonConvert.DeserializeObject<MaterialShorAnalysis>(sWhere);
|
|
ds = oCN.RunProcReturn($"exec h_p_JIT_MaterialShorAnalysisReportList {Report.HORGID},'{Report.HBEGINDATE}','{Report.HENDDATE}' ", "h_p_JIT_PODemandPlanBill_ReportList");
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
//objJsonResult.list = columnNameList;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 保存
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBill_btnSave")]
|
[HttpPost]
|
public object JIT_DayPlanPlatFormBill_btnSave([FromBody] JObject sMainSub)
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
oCN.BeginTran();
|
//保存主表
|
objJsonResult = AddBillMain(msg1);
|
if (objJsonResult.code == "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = objJsonResult.Message;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "单据保存成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
public json AddBillMain(string msg1)
|
{
|
string[] sArray = msg1.Split(new string[] { "&和" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string user = sArray[1].ToString();
|
|
try
|
{
|
Stopwatch sw = new Stopwatch();//计时器
|
sw.Start();//开始计时
|
|
if (!DBUtility.ClsPub.Security_Log("Sc_WorkBillSortBill_Edit", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无保存权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
LogService.CustomWriteLog("1:"+msg2, DateTime.Now.ToString("yyyy-MM-dd"));
|
//JSON序列化转换字典集合
|
List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
|
List<object> jb = JsonConvert.DeserializeObject<List<object>>(msg2);
|
foreach (JObject item in jb)
|
{
|
Dictionary<string, string> dic = new Dictionary<string, string>();
|
foreach (var itm in item.Properties())
|
{
|
dic.Add(itm.Name, itm.Value.ToString());
|
}
|
list.Add(dic);
|
}
|
|
LogService.CustomWriteLog("2:", DateTime.Now.ToString("yyyy-MM-dd"));
|
int TrueCount = 0, SumCount = 0;
|
LogService.CustomWriteLog("list.Count:"+ list.Count, DateTime.Now.ToString("yyyy-MM-dd"));
|
|
string sReturn = "";
|
oSystemParameter.ShowBill(ref sReturn);
|
for (int i = 0; i < list.Count; i++)
|
{
|
TrueCount = 0;
|
SumCount = 0;
|
long HInterID = 0;
|
var HBillNo = "";
|
if (list[i]["单据号"].ToString() == "" && list[i]["hmainid"].ToString() == "")
|
{
|
LogService.CustomWriteLog("2.01:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
var HICMOBillNo = list[i]["生产订单号"].ToString();
|
var HOrderType = list[i]["订单类型"].ToString();
|
var HICMOEntrySEQ = list[i]["生产订单明细行号"].ToString();
|
var HWorkShopID = list[i]["HWorkShopID"].ToString();
|
var HSourceID = list[i]["HSourceID"].ToString();
|
var HYX = list[i]["优先级"].ToString();
|
var HProdORGID = list[i]["HProdORGID"].ToString();
|
var HMaterID = list[i]["HMaterID"].ToString();
|
var HMaterName = list[i]["物料名称"].ToString();
|
var HMaterModel = list[i]["规格型号"].ToString().Replace("'", "''");
|
var HUnitID = list[i]["HUnitID"].ToString();
|
var HSeOrderBillQty = list[i]["销售订单数量"].ToString();
|
//var HOrderNeedQty = list[i]["订单需求数量"].ToString();
|
var HSplitQty = list[i]["拆单数量"].ToString();
|
var HDayPlanSumQty = list[i]["日计划数量总量"].ToString();
|
var HPlanBeginDate = list[i]["计划开始日期"].ToString();
|
var HPlanEndDate = list[i]["计划结束日期"].ToString();
|
var HSeOrderBillNo = list[i]["销售订单号"].ToString();
|
var HICMOBillType = list[i]["生产订单单据类型"].ToString();
|
var HSourceStockInQty = list[i]["产线入库数量"].ToString();
|
var HLeftPlanQty = list[i]["未排数量"].ToString();
|
var HOrderLev = list[i]["订单等级"].ToString();
|
var HMainSourceInterID = list[i]["源单主内码"].ToString();
|
var HMainSourceEntryID = list[i]["源单子内码"].ToString();
|
var HPlanQty = list[i]["计划数量"].ToString();
|
var HEmpID = list[i]["HEmpID"].ToString();
|
var HWorkQty = list[i]["小时产能"].ToString();
|
|
LogService.CustomWriteLog("2.05:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
|
if (oSystemParameter.omodel.WMS_CampanyName != "添康科技") //系统参数 客户定制化名称 空白为通用
|
{
|
if (HSourceID == "" || HSourceID == "0")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"第{i + 1}行生产资源不能为空!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
|
$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain");
|
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"第{i + 1}行生产资源有重复,请修改!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//新增单据号 id
|
HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//获得一个新的单据号
|
HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id
|
|
string sql = $"insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," +
|
"HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," +
|
"HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HProdORGID," +
|
" HMaterID, HMaterName, HMaterModel, HUnitID, HSeOrderBillQty," +
|
" HOrderNeedQty, HSplitQty, HDayPlanSumQty,HPlanBeginDate," +
|
"HSeOrderBillNo,HICMOBillType,HSourceStockInQty,HLeftPlanQty,HOrderLev,HPreparatDate," +
|
"HMainSourceInterID,HMainSourceEntryID,HICMOInterID_Sec,HICMOEntryID_Sec,HPlanQty" +
|
",HICMOInterID,HICMOEntryID,HPlanEndDate,HEmpID,HWorkQty)values" +
|
$"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," +
|
$"'{BillType}',GETDATE(),1,'{user}',getdate(),'{HICMOBillNo}','{HOrderType}'," +
|
$"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HProdORGID == "" ? 0.ToString() : HProdORGID)}," +
|
$" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}," +
|
$" 0, {(HSplitQty == "" ? 0.ToString() : HSplitQty)}, {(HDayPlanSumQty == "" ? 0.ToString() : HDayPlanSumQty)},'{HPlanBeginDate}'," +
|
$"'{HSeOrderBillNo}','{HICMOBillType}',{(HSourceStockInQty == "" ? 0.ToString() : HSourceStockInQty)},{(HLeftPlanQty == "" ? 0.ToString() : HLeftPlanQty)},'{HOrderLev}',getdate()," +
|
$"{HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HPlanQty}," +
|
$"{HMainSourceInterID},{HMainSourceEntryID},'{HPlanEndDate}','{HEmpID}','{HWorkQty}')";
|
|
//LogService.Write("sql:" + sql);
|
//主表
|
oCN.RunProc(sql);
|
}
|
else
|
{
|
LogService.CustomWriteLog("2.0:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
HBillNo = list[i]["单据号"].ToString();
|
HInterID = int.Parse(list[i]["hmainid"].ToString());
|
var HMainSourceInterID = list[i]["源单主内码"].ToString();
|
var HMainSourceEntryID = list[i]["源单子内码"].ToString();
|
var HICMOBillNo = list[i]["生产订单号"].ToString();
|
var HICMOEntrySEQ = list[i]["生产订单明细行号"].ToString();
|
var HSourceID = list[i]["HSourceID"].ToString();
|
var HYX = list[i]["优先级"].ToString();
|
var HWorkQty = list[i]["小时产能"].ToString();
|
var HProdTimes = list[i]["生产周期"].ToString();
|
var HReadyTimes = list[i]["开工余量"].ToString();
|
var HLastBeginDate = list[i]["最迟开工日期"].ToString();
|
var HLastEndDate = list[i]["最迟完工日期"].ToString();
|
var HOrderNeedQty = list[i]["订单需求数量"].ToString();
|
var HOrderCommitDate = list[i]["订单交货期"].ToString();
|
var HPlanEndDate = list[i]["计划结束日期"].ToString();
|
var HSplitQty = list[i]["拆单数量"].ToString();
|
|
LogService.CustomWriteLog("2.1:"+i, DateTime.Now.ToString("yyyy-MM-dd"));
|
|
if (oSystemParameter.omodel.WMS_CampanyName != "添康科技") //系统参数 客户定制化名称 空白为通用
|
{
|
if (HSourceID == "" || HSourceID == "0")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"第{i + 1}行生产资源不能为空!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
var str = 0;
|
if (!int.TryParse(HYX, out str))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"第{i + 1}行优先级:{HYX},请输入数字!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
|
$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain");
|
|
if (ds.Tables[0].Rows.Count > 1)
|
{
|
LogService.CustomWriteLog("第" + i + 1 + "行生产资源有重复,请修改", DateTime.Now.ToString("yyyy-MM-dd"));
|
LogService.CustomWriteLog($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
|
$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", DateTime.Now.ToString("yyyy-MM-dd"));
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"第{i + 1}行生产资源有重复,请修改!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
LogService.CustomWriteLog("2.2:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
|
oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)},HYX={HYX}" +
|
$",HWorkQty={HWorkQty},HProdTimes={HProdTimes},HReadyTimes={HReadyTimes},HLastBeginDate='{HLastBeginDate}'" +
|
$",HLastEndDate='{HLastEndDate}',HOrderNeedQty={HOrderNeedQty},HOrderCommitDate='{HOrderCommitDate}',HPlanEndDate='{HPlanEndDate}',HSplitQty={HSplitQty}" +
|
$" where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["单据号"].ToString()}'");
|
}
|
|
oCN.RunProc($"update Sc_WorkBillSortBillMain set HDayPlanSumQty={list[i]["日计划数量总量"].ToString()} where HInterID={(HInterID==0?int.Parse(list[i]["hmainid"].ToString()):HInterID)} and HBillNo='{(HBillNo==""?list[i]["单据号"].ToString(): HBillNo)}'");
|
|
int SumDay = 0; //动态两月之差 DateTime.Now.AddMonths(1).AddDays(-1).Subtract(DateTime.Now).Days;
|
|
// 统计总天数
|
HashSet<DateTime> uniqueDates = new HashSet<DateTime>();
|
|
foreach (var key in list[i].Keys)
|
{
|
if (DateTime.TryParseExact(key, "yyyy-M-d", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime date))
|
{
|
uniqueDates.Add(date);
|
}
|
}
|
|
SumDay = uniqueDates.Count;
|
|
if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数 客户定制化名称 空白为通用
|
{
|
SumDay = 180;
|
}
|
|
LogService.CustomWriteLog("2.3:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
for (int j = 0; j < SumDay; j++)
|
{
|
//主表子表都有数据
|
if (list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString() != "")
|
{
|
SumCount += 1;
|
////保存子表
|
objJsonResult = AddBillSub(HInterID == 0 ? list[i]["hmainid"].ToString() : HInterID.ToString()
|
, HBillNo == "" ? list[i]["单据号"].ToString() : HBillNo
|
, DateTime.Parse(DateTime.Now.AddDays(j).ToString("yyyy-MM-dd").ToString())
|
, Math.Round(double.Parse(list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString()),1)
|
, list[i]);
|
if (objJsonResult.count == 1)
|
{
|
TrueCount += 1;
|
}
|
}
|
//主表有数据 子表无数据
|
if (j == SumDay-1 && SumCount == 0 && HInterID != 0 && HBillNo != "")
|
{
|
//LogService.CustomWriteLog("3:"+ HInterID+","+ HBillNo, DateTime.Now.ToString("yyyy-MM-dd"));
|
objJsonResult = AddBillSub(HInterID.ToString(), HBillNo, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0, list[i]);
|
}
|
}
|
|
LogService.CustomWriteLog("2.4:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
|
|
if (TrueCount != SumCount)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = objJsonResult.Message;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
|
}
|
|
LogService.CustomWriteLog("2.5:", DateTime.Now.ToString("yyyy-MM-dd"));
|
|
//同步日计划工单
|
oCN.RunProc("exec REALESE_SC_ICMOBILLSTATUS_TMP");
|
|
LogService.CustomWriteLog("2.6:", DateTime.Now.ToString("yyyy-MM-dd"));
|
sw.Stop();//结束计时
|
LogService.Write($"========================1.排产订单总用时：" + sw.Elapsed);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = null;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
public json AddBillSub(string HInterID, string HBillNo, DateTime date, double HQTY, Dictionary<string, string> dic)
|
{
|
//获取表格数据
|
ds = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBill_PC where 单据号='{HBillNo}'", "h_v_JIT_Sc_WorkBillSortBill_PC");
|
int count = 0;
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
//判断子表是否有当日的日期以及日期所对应的数量
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
if (DateTime.Parse(ds.Tables[0].Rows[i]["日计划生产日期"].ToString()) == date)
|
{
|
oCN.RunProc($"update Sc_WorkBillSortBillSub set HMasterDate='{date}',HQty={HQTY},HUseTimes={(dic["小时产能"]=="0"?0: HQTY / float.Parse(dic["小时产能"].ToString()))}" +
|
$" where HInterID={HInterID} and HEntryID={ds.Tables[0].Rows[i]["hsubid"].ToString()}");
|
count += 1;
|
}
|
}
|
}
|
|
if (count != 1)
|
{
|
//插入子表
|
oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," +
|
"HMasterDate,HQty,HUseTimes)" +
|
$"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," +
|
$" '{date}', {HQTY},{ ((dic["小时产能"] == "0.0000" ? 0 : dic["小时产能"] == "0" ? 0 : HQTY / float.Parse(dic["小时产能"].ToString())).ToString() == "非数字" ? 0 : dic["小时产能"] == "0.0000" ? 0 : dic["小时产能"] == "0" ? 0 : HQTY / float.Parse(dic["小时产能"].ToString())) })");
|
}
|
|
string sReturn = "";
|
oSystemParameter.ShowBill(ref sReturn);
|
if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数 客户定制化名称 空白为通用
|
{
|
//把排产订单完工日期反写到金蝶销售订单上
|
string sql = "exec h_p_JIT_UpdateEndDateToERP " + HInterID + ",'" + HBillNo + "'";
|
oCN.RunProc(sql);
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = null;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
#endregion
|
|
#region 生产日计划平台 齐套分析
|
|
#region 清单配料方式
|
public class PRD_PPBOM
|
{
|
/// <summary>
|
/// 日计划工单号
|
/// </summary>
|
public string HMainICMOBillNo { get; set; }
|
/// <summary>
|
/// 日计划工单FID
|
/// </summary>
|
public long HInterID { get; set; }
|
/// <summary>
|
/// 日计划明细FEntryID
|
/// </summary>
|
public long HEntryID { get; set; }
|
/// <summary>
|
/// 生产用料清单单号
|
/// </summary>
|
public string HBillNo { get; set; }
|
/// <summary>
|
/// 生产订单单号
|
/// </summary>
|
public string HICMOBillNo { get; set; }
|
/// <summary>
|
/// 生产订单内码
|
/// </summary>
|
public string HICMOInterID { get; set; }
|
/// <summary>
|
/// 父级物料ID
|
/// </summary>
|
public string FMaterialID { get; set; }
|
/// <summary>
|
/// 父级物料数量
|
/// </summary>
|
public decimal FQty { get; set; }
|
/// <summary>
|
/// 子项物料ID
|
/// </summary>
|
public string FMATERIALID2 { get; set; }
|
/// <summary>
|
/// 子项物料名称
|
/// </summary>
|
public string FNumber { get; set; }
|
/// <summary>
|
/// 需求数量
|
/// </summary>
|
public decimal FNeedQty { get; set; }
|
/// <summary>
|
/// 即时库存
|
/// </summary>
|
public decimal FBASEQTY { get; set; }
|
|
/// <summary>
|
/// 生产订单主码
|
/// </summary>
|
public string HICMOInterID_Sec { get; set; }
|
/// <summary>
|
/// 生产订单子码
|
/// </summary>
|
public string HICMOEntryID_Sec { get; set; }
|
|
/// <summary>
|
/// 日计划数量
|
/// </summary>
|
public string HQty { get; set; }
|
|
/// <summary>
|
/// 日计划日期
|
/// </summary>
|
public DateTime HMasterDate { get; set; }
|
|
/// <summary>
|
/// 订单等级
|
/// </summary>
|
public string HOrderLev { get; set; }
|
|
/// <summary>
|
/// 库存组织
|
/// </summary>
|
public string FStockOrgId { get; set; }
|
/// <summary>
|
/// 组织名称
|
/// </summary>
|
public string OrgFnumber { get; set; }
|
|
/// <summary>
|
/// 单位用量
|
/// </summary>
|
public decimal dwyl { get; set; }
|
|
/// <summary>
|
/// 预计消耗用量
|
/// </summary>
|
public decimal PlanCount { get; set; }
|
/// <summary>
|
/// 物料属性
|
/// </summary>
|
public int FErpClsID { get; set; }
|
|
/// <summary>
|
/// 车间
|
/// </summary>
|
public string HWorkShopID { get; set; }
|
|
/// <summary>
|
/// 车间编码
|
/// </summary>
|
public string FHWorkShopNumber { get; set; }
|
|
|
}
|
#endregion
|
|
#region 即时库存
|
public class PRD_Inventory
|
{
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
public string FMATERIALID { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string FNumber { get; set; }
|
/// <summary>
|
/// 即时库存
|
/// </summary>
|
public decimal FBASEQTY { get; set; }
|
|
/// <summary>
|
/// 库存组织
|
/// </summary>
|
public string FStockOrgId { get; set; }
|
|
/// <summary>
|
/// 库存货主类型
|
/// </summary>
|
public string FOwnerTypeId { get; set; }
|
/// <summary>
|
/// 库存货主
|
/// </summary>
|
public string FOwnerId { get; set; }
|
|
/// <summary>
|
/// 货主编码
|
/// </summary>
|
public string FOwnerNumber { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
public string FSTOCKID { get; set; }
|
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
public string FStockNumber { get; set; }
|
/// <summary>
|
/// 批号
|
/// </summary>
|
public string HLOT { get; set; }
|
/// <summary>
|
/// id
|
/// </summary>
|
public string HInventoryFID { get; set; }
|
}
|
#endregion
|
|
#region 车间仓库对照列表
|
public class PRD_WorkHouseCompar
|
{
|
/// <summary>
|
/// 组织
|
/// </summary>
|
public string FORGID { get; set; }
|
/// <summary>
|
/// 车间
|
/// </summary>
|
public string FWORKSHOPID { get; set; }
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
public string FSTOCKID { get; set; }
|
}
|
#endregion
|
|
#region 日计划+生产订单
|
public class DayPlanPickedModel
|
{
|
/// <summary>
|
/// 订单入库数量 按照生产订单明细行
|
/// </summary>
|
public decimal FCXStockInQty { get; set; }
|
/// <summary>
|
/// 主生产订单子内码
|
/// </summary>
|
public string FPRDMOENTYID { get; set; }
|
/// <summary>
|
/// 物料单位用量
|
/// </summary>
|
public decimal dwyl { get; set; }
|
/// <summary>
|
/// 已领数量
|
/// </summary>
|
public decimal FPickedQty { get; set; }
|
/// <summary>
|
/// 剩余可用数量
|
/// </summary>
|
public decimal FRemainPickedQty { get; set; }
|
/// <summary>
|
/// 物料
|
/// </summary>
|
public string FMATERIALID { get; set; }
|
|
}
|
#endregion
|
|
#region 存储临时需要插入数据
|
public class CompleteAnalysisTempModel
|
{
|
/// <summary>
|
/// 主生产订单主内码：FHMainICMOInterIDr
|
/// </summary>
|
public string FHMainICMOInterIDr { get; set; }
|
/// <summary>
|
/// 主生产订单子内码：FHMainICMOEntryID
|
/// </summary>
|
public string FHMainICMOEntryID { get; set; }
|
/// <summary>
|
/// 日计划订单单号：HMainICMOBillNo
|
/// </summary>
|
public string HMainICMOBillNo { get; set; }
|
/// <summary>
|
/// 日计划订单主内码：FHICMOInterID
|
/// </summary>
|
public string FHICMOInterID { get; set; }
|
/// <summary>
|
/// 日计划订单子内码：FHICMOEntryID
|
/// </summary>
|
public string FHICMOEntryID { get; set; }
|
/// <summary>
|
/// 子件物料：FHMaterID
|
/// </summary>
|
public string FHMaterID { get; set; }
|
|
/// <summary>
|
/// 库存组织：FHStockOrgID
|
/// </summary>
|
public string FHStockOrgID { get; set; }
|
|
/// <summary>
|
///生产组织：FHPRDORGID
|
/// </summary>
|
public string FHPRDORGID { get; set; }
|
|
/// <summary>
|
/// 生产订单号：FPRDBillNo
|
/// </summary>
|
public string FPRDBillNo { get; set; }
|
/// <summary>
|
/// 标识
|
/// </summary>
|
public string FIdentificat { get; set; }
|
/// <summary>
|
/// 货主名称：FOwnerName
|
/// </summary>
|
public string FOwnerName { get; set; }
|
/// <summary>
|
/// 货主编码：FOwnerId
|
/// </summary>
|
public string FOwnerId { get; set; }
|
/// <summary>
|
/// 货主类型：FOwnerTypeId
|
/// </summary>
|
public string FOwnerTypeId { get; set; }
|
/// <summary>
|
/// 齐套状态
|
/// </summary>
|
public string FComPlete { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public string FHUseQty { get; set; }
|
/// <summary>
|
/// 及时库存数量：FHStockQty
|
/// </summary>
|
public decimal FHStockQty { get; set; }
|
/// <summary>
|
///可用数量：FHLeftQty
|
/// </summary>
|
public decimal FHLeftQty { get; set; }
|
|
/// <summary>
|
/// 缺料数量
|
/// </summary>
|
public decimal FLackCount { get; set; }
|
/// <summary>
|
/// 占用数量
|
/// </summary>
|
public decimal FOccupyCount { get; set; }
|
/// <summary>
|
/// 占用领料数量
|
/// </summary>
|
public decimal FOccupyPickedCount { get; set; }
|
|
/// <summary>
|
/// 单位用量：FUnitDosage
|
/// </summary>
|
public decimal FUnitDosage { get; set; }
|
/// <summary>
|
/// 计划总数量：FSumPlanCount
|
/// </summary>
|
public decimal FSumPlanCount { get; set; }
|
/// <summary>
|
/// 齐套数量：FCompleteCount q
|
/// </summary>
|
public decimal FCompleteCount { get; set; }
|
public decimal FCompleteCount1 { get; set; }
|
/// <summary>
|
/// 日计划日期
|
/// </summary>
|
public DateTime FPlanDate { get; set; }
|
//物料类型
|
public int FErpClsID { get; set; }
|
//仓库
|
public string FStock { get; set; }
|
//车间
|
public string FWorkShop { get; set; }
|
//批号
|
public string HLOT { get; set; }
|
public string HInventoryFID { get; set; }
|
|
}
|
#endregion
|
|
[Route("JIT_DayPlanPlatFormBill/JIT_CompleteSetAnalysis")]
|
[HttpGet]
|
public object JIT_CompleteSetAnalysis(string sWhere, string user)
|
{
|
try
|
{
|
Stopwatch sw = new Stopwatch();
|
omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
|
string sql = $"exec JIT_qtfx {omdelMian.HProdORGID},{omdelMian.HWorkShopID},'{user}' ";
|
ds = oCN.RunProcReturn(sql, "JIT_qtfx");
|
//LogService.Write("齐套分析sql:" + sql);
|
List<PRD_PPBOM> BomList = new List<PRD_PPBOM>();
|
DataTable resulTable = ds.Tables[0];
|
|
if (ds.Tables[0].Rows.Count < 1 || ds == null)
|
{
|
//释放齐套操作 避免多人同时进行齐套分析
|
oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "没有需要进行齐套分析的数据";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (resulTable.Rows[0][0].ToString().Contains("失败"))
|
{
|
//释放齐套操作 避免多人同时进行齐套分析
|
oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = resulTable.Rows[0][0].ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
BomList = ds.ToModelList<PRD_PPBOM>();
|
}
|
|
string fDayPlanFids = string.Empty;
|
string fDayPlanFEntryids = string.Empty;
|
if (BomList.Count == 0)
|
{
|
//释放齐套操作 避免多人同时进行齐套分析
|
oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "没有需要进行齐套分析的数据";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
List<string> fidList = BomList.Select(x => x.HInterID.ToString()).Distinct().ToList();
|
List<string> fentryidList = BomList.Select(x => x.HEntryID.ToString()).Distinct().ToList();
|
fDayPlanFids = string.Join(",", fidList);
|
fDayPlanFEntryids = string.Join(",", fentryidList);
|
}
|
//LogService.Write("日计划工单ids" + fDayPlanFids);
|
|
sw.Start();//开始计时
|
|
//获取当前即时库存 库存数量+库存组织+物料+货主+仓库
|
//原查询即时库存方式：select * from h_v_jit_InventoryList
|
ds = oCN.RunProcReturn(@"
|
exec h_p_jit_Inventory_UsableList
|
", "h_p_jit_Inventory_UsableList");
|
ListInventory = ds.ToModelList<PRD_Inventory>();
|
//车间 仓库对照列表
|
ds = oCN.RunProcReturn(@"
|
SELECT DISTINCT T1.HOrgId FORGID,HWorkShopID FWORKSHOPID,HWHID FSTOCKID FROM Gy_WorkWarehouseBillMain T1
|
JOIN Gy_WorkWarehouseBillMainSub T2 ON T1.HInterID=T2.HInterID
|
", "Gy_WorkWarehouseBillMain");
|
List<PRD_WorkHouseCompar> pRD_WorkHouseCompar = ds.ToModelList<PRD_WorkHouseCompar>();
|
int i = 1;//用于进度条的加载
|
//日计划+生产订单子表编码ID
|
var DatePlanList = BomList.GroupBy(p => new { p.HMasterDate, p.HICMOEntryID_Sec }).Select(x => new PRD_PPBOM { HMasterDate = x.Key.HMasterDate, HICMOEntryID_Sec = x.Key.HICMOEntryID_Sec }).ToList();
|
//取应发数量 FMustQty 不要取值需求数量FNeedQty 领料数据
|
string LLsql = string.Format(@"exec h_p_jit_PPBOMList '{0}'", fDayPlanFids);
|
List<DayPlanPickedModel> DayPlanPickedModel = new List<DayPlanPickedModel>();
|
//LogService.Write("LLsql:" + LLsql);
|
ds = oCN.RunProcReturn(LLsql, "SC_WORKBILLSORTBILLMAIN");
|
//LogService.Write(JsonConvert.SerializeObject(ds));
|
DayPlanPickedModel = ds.ToModelList<DayPlanPickedModel>();
|
//LogService.Write(JsonConvert.SerializeObject(DayPlanPickedModel));
|
//CompleteAnalysisTempModel 用于存储临时需要插入数据
|
List<CompleteAnalysisTempModel> completeAnalysisTempModel = new List<CompleteAnalysisTempModel>();
|
//创建字典 用于储存物料 + 占用数量
|
Dictionary<string, decimal> occupyDic = new Dictionary<string, decimal>();
|
//LogService.Write($"齐套分析，数据准备阶段，用时" + sw.Elapsed + "总行数：" + BomList.Count);
|
//LogService.Write($"齐套分析，数据准备阶段，用时" + sw.Elapsed + "总需要循环的bom数量：" + DatePlanList.Count);
|
|
//第一个循环 日计划工单明细 一天+一个工单 一个循环
|
int o = 0;
|
foreach (var item in DatePlanList)
|
{
|
o++;
|
//LogService.Write("循环:" + o);
|
//日计划用料清单明细 每一天的实际用料情况
|
var _BomList = BomList.Where(x => x.HMasterDate == item.HMasterDate && x.HICMOEntryID_Sec == item.HICMOEntryID_Sec).ToList();
|
//每一个物料进行库存计算
|
foreach (var _item in _BomList)
|
{
|
//车间仓库 对照表 每个日计划同属一个车间 A,B
|
var _pRD_WorkHouseCompar = pRD_WorkHouseCompar.Where(c => c.FWORKSHOPID == _item.HWorkShopID).ToList();
|
decimal jskcQty = 0;//用于计算
|
decimal jskcQty2 = 0;//用于计算当时那个计算节点的即时库存
|
//计算当前这几个仓库总的库存量
|
if (_pRD_WorkHouseCompar.Count > 0)
|
{
|
foreach (var _WorkHouse in _pRD_WorkHouseCompar)
|
{
|
//库存数据匹配
|
List<PRD_Inventory> _ListInventory = ListInventory.Where(c => c.FNumber == _item.FNumber && c.FBASEQTY > 0 && c.FSTOCKID == _WorkHouse.FSTOCKID).ToList();
|
if (_ListInventory.Count > 0)
|
{
|
foreach (var Inventory in _ListInventory)
|
{
|
jskcQty += Inventory.FBASEQTY;
|
}
|
}
|
}
|
}
|
//找出物料被其它订单占用数量
|
decimal occupyMaterial = 0;
|
if (occupyDic.ContainsKey(_item.HWorkShopID + _item.FMATERIALID2))
|
{
|
occupyMaterial = occupyDic[_item.HWorkShopID + _item.FMATERIALID2];
|
}
|
//虚拟日计划用料清单 需求数量
|
decimal planNeed = _item.PlanCount; //不参与计算 用于记录
|
decimal need = _item.PlanCount;//参与计算
|
decimal FOccupyPickedCount = 0;//占用领料单数量
|
//找到领用数量
|
var _DayPlanPickedModel = DayPlanPickedModel.Where(c => c.FPRDMOENTYID == _item.HICMOEntryID_Sec && c.FMATERIALID == _item.FMATERIALID2).FirstOrDefault();
|
|
if (_DayPlanPickedModel.FRemainPickedQty >= need)
|
{
|
//领料数量满足了当前这个需求量 直接齐套 不需要去占用仓库
|
completeAnalysisTempModel.Add(new CompleteAnalysisTempModel
|
{
|
FHMainICMOInterIDr = _item.HICMOInterID_Sec,
|
FHMainICMOEntryID = _item.HICMOEntryID_Sec,
|
FHICMOInterID = _item.HInterID.ToString(),
|
FHICMOEntryID = _item.HEntryID.ToString(),
|
FHMaterID = _item.FMATERIALID2,
|
FErpClsID = _item.FErpClsID,
|
FHStockOrgID = _item.FStockOrgId,
|
FHPRDORGID = _item.FStockOrgId,
|
FPRDBillNo = _item.HICMOBillNo,
|
HMainICMOBillNo = _item.HMainICMOBillNo,
|
FOwnerTypeId = "",
|
FUnitDosage = _item.dwyl,//单位用量
|
FSumPlanCount = planNeed,//计划总数量
|
FCompleteCount1 = planNeed, //齐套数量
|
FLackCount = 0,//缺料数量
|
FHStockQty = jskcQty2,//即时库存
|
FHLeftQty = jskcQty,//可用数量
|
FOccupyCount = occupyMaterial,//占用数量
|
FOccupyPickedCount = planNeed,//占用领料数量
|
FComPlete = "齐套",
|
FPlanDate = item.HMasterDate, // 日计划日期
|
FWorkShop = _item.HWorkShopID //车间
|
});
|
//扣除剩余可用领料数量
|
_DayPlanPickedModel.FRemainPickedQty -= need;
|
//LogService.Write($"h" + need);
|
//循环下一个物料
|
continue;
|
}
|
else
|
{
|
//LogService.Write($"kxs" + need);
|
need -= _DayPlanPickedModel.FRemainPickedQty; //剩余需求数量
|
//LogService.Write($"i1" + need);
|
FOccupyPickedCount = _DayPlanPickedModel.FRemainPickedQty;
|
_DayPlanPickedModel.FRemainPickedQty = 0;
|
//LogService.Write($"i" + need);
|
}
|
if (_pRD_WorkHouseCompar.Count > 0)
|
{
|
//缺料数量 需求数量 - 实际库存 >0 ? 一个物料不管占用多少条 库存+货主 数据 缺料数量是同一个数量
|
decimal _fLackCount = need > jskcQty ? (need - jskcQty) : 0;
|
//LogService.Write($"j" + _fLackCount);
|
//LogHelper.Info("组织：" + _item.FStockOrgId + " ,及时库存" + jskcQty);
|
//总库存为0了 直接给出 缺料数量
|
if (jskcQty == 0)
|
{
|
completeAnalysisTempModel.Add(new CompleteAnalysisTempModel
|
{
|
FHMainICMOInterIDr = _item.HICMOInterID_Sec,
|
FHMainICMOEntryID = _item.HICMOEntryID_Sec,
|
FHICMOInterID = _item.HInterID.ToString(),
|
FHICMOEntryID = _item.HEntryID.ToString(),
|
FHMaterID = _item.FMATERIALID2,
|
FErpClsID = _item.FErpClsID,
|
FHStockOrgID = _item.FStockOrgId,
|
FHPRDORGID = _item.FStockOrgId,
|
FPRDBillNo = _item.HICMOBillNo,
|
HMainICMOBillNo = _item.HMainICMOBillNo,
|
FOwnerTypeId = "",
|
FUnitDosage = _item.dwyl,//单位用量
|
FSumPlanCount = planNeed,//计划总数量
|
FCompleteCount1 = FOccupyPickedCount, //齐套数量
|
FLackCount = need,//缺料数量
|
FHStockQty = jskcQty2,//即时库存
|
FHLeftQty = jskcQty,//可用数量
|
FOccupyCount = occupyMaterial,//占用数量
|
FOccupyPickedCount = FOccupyPickedCount,//占用领料数量
|
FComPlete = "未齐套",
|
FPlanDate = item.HMasterDate, // 日计划日期
|
FWorkShop = _item.HWorkShopID //车间
|
});
|
//终止该物料计算 进入下一个
|
continue;
|
}
|
|
//LogService.Write($"k" + 2);
|
foreach (var WorkHouse in _pRD_WorkHouseCompar)
|
{
|
//库存数据匹配
|
List<PRD_Inventory> _ListInventory = ListInventory.Where(c => c.FNumber == _item.FNumber && c.FBASEQTY > 0 && c.FSTOCKID == WorkHouse.FSTOCKID).ToList();
|
//需求数量 占用完后可以跳出车间仓库循环
|
if (need == 0)
|
break;
|
if (_ListInventory.Count > 0)
|
{
|
foreach (var Inventory in _ListInventory)
|
{
|
if (need == 0)
|
break;
|
//齐套数量
|
decimal fCompleteCount = need >= Inventory.FBASEQTY ? Inventory.FBASEQTY : need;
|
if (!occupyDic.ContainsKey(_item.HWorkShopID + _item.FMATERIALID2))
|
{
|
occupyDic.Add(_item.HWorkShopID + _item.FMATERIALID2, fCompleteCount);
|
}
|
else
|
{
|
occupyMaterial = occupyDic[_item.HWorkShopID + _item.FMATERIALID2];
|
occupyDic[_item.HWorkShopID + _item.FMATERIALID2] = occupyMaterial + fCompleteCount;
|
}
|
completeAnalysisTempModel.Add(new CompleteAnalysisTempModel
|
{
|
FHMainICMOInterIDr = _item.HICMOInterID_Sec,
|
FHMainICMOEntryID = _item.HICMOEntryID_Sec,
|
FHICMOInterID = _item.HInterID.ToString(),
|
FHICMOEntryID = _item.HEntryID.ToString(),
|
FHMaterID = _item.FMATERIALID2,
|
FHStockOrgID = _item.FStockOrgId,
|
FHPRDORGID = _item.FStockOrgId,
|
FErpClsID = _item.FErpClsID,
|
FPRDBillNo = _item.HICMOBillNo,
|
HMainICMOBillNo = _item.HMainICMOBillNo,
|
FOwnerTypeId = Inventory.FOwnerTypeId,
|
FOwnerId = Inventory.FOwnerId,
|
FUnitDosage = _item.dwyl,//单位用量
|
FSumPlanCount = planNeed,//计划总数量
|
FCompleteCount1 = fCompleteCount + FOccupyPickedCount, //齐套数量
|
FLackCount = _fLackCount,//缺料数量
|
FHStockQty = jskcQty2,//即时库存
|
FHLeftQty = jskcQty,//可用数量
|
FOccupyCount = occupyMaterial,//占用数量
|
FOccupyPickedCount = FOccupyPickedCount,//领料占用数量
|
FComPlete = jskcQty >= need ? "齐套" : "未齐套",
|
FPlanDate = item.HMasterDate, // 日计划日期
|
FStock = Inventory.FSTOCKID,//仓库
|
FWorkShop = _item.HWorkShopID, //车间
|
HLOT = Inventory.HLOT, //批号
|
HInventoryFID = Inventory.HInventoryFID //id
|
});
|
//扣减总库存数量
|
jskcQty = jskcQty >= fCompleteCount ? jskcQty - fCompleteCount : 0;
|
//剩余日计划需求数量
|
need = need >= Inventory.FBASEQTY ? need - Inventory.FBASEQTY : 0;
|
//扣减消耗库存
|
Inventory.FBASEQTY = Inventory.FBASEQTY - fCompleteCount;
|
}
|
}
|
}
|
}
|
//没有车间仓库数据 既没有可用库存 为未齐套
|
else
|
{
|
if (occupyDic.ContainsKey(_item.HWorkShopID + _item.FMATERIALID2))
|
{
|
occupyMaterial = occupyDic[_item.HWorkShopID + _item.FMATERIALID2];
|
}
|
completeAnalysisTempModel.Add(new CompleteAnalysisTempModel
|
{
|
FHMainICMOInterIDr = _item.HICMOInterID_Sec,
|
FHMainICMOEntryID = _item.HICMOEntryID_Sec,
|
FHICMOInterID = _item.HInterID.ToString(),
|
FHICMOEntryID = _item.HEntryID.ToString(),
|
FHMaterID = _item.FMATERIALID2,
|
FErpClsID = _item.FErpClsID,
|
FHStockOrgID = _item.FStockOrgId,
|
FHPRDORGID = _item.FStockOrgId,
|
FPRDBillNo = _item.HICMOBillNo,
|
HMainICMOBillNo = _item.HMainICMOBillNo,
|
FOwnerTypeId = "",
|
FUnitDosage = _item.dwyl,//单位用量
|
FSumPlanCount = planNeed,//计划总数量
|
FCompleteCount1 = planNeed - need, //齐套数量
|
FLackCount = need,//缺料数量
|
FHStockQty = jskcQty2,//即时库存
|
FHLeftQty = jskcQty,//可用数量
|
FOccupyCount = occupyMaterial,//占用数量
|
FOccupyPickedCount = FOccupyPickedCount,//占用领料数量
|
FComPlete = "未齐套",
|
FPlanDate = item.HMasterDate, // 日计划日期
|
FWorkShop = _item.HWorkShopID //车间
|
});
|
}
|
}
|
//Thread.Sleep(6000);
|
i++;
|
}
|
//LogService.Write($"齐套分析，数据准备完成，保存到Model实体，总行数：{completeAnalysisTempModel.Count}，耗时：" + sw.Elapsed);
|
List<string> sqlList = new List<string>();
|
DataTable insertDT = new DataTable();
|
insertDT.TableName = "JIT_MOMaterReadysBill";
|
insertDT.Columns.Add("FID", typeof(long));
|
insertDT.Columns.Add("FDOCUMENTSTATUS", typeof(string));
|
insertDT.Columns.Add("FHMAINICMOINTERIDR", typeof(long));
|
insertDT.Columns.Add("FHMAINICMOENTRYID", typeof(long));
|
insertDT.Columns.Add("FHICMOINTERID", typeof(long));
|
insertDT.Columns.Add("FHICMOENTRYID", typeof(long));
|
insertDT.Columns.Add("FHMATERID", typeof(long));
|
insertDT.Columns.Add("FHSTOCKORGID", typeof(long));
|
insertDT.Columns.Add("FHSTOCKQTY", typeof(decimal));
|
insertDT.Columns.Add("FHLEFTQTY", typeof(decimal));
|
insertDT.Columns.Add("FHPRDORGID", typeof(long));
|
insertDT.Columns.Add("FUNITDOSAGE", typeof(decimal));
|
insertDT.Columns.Add("FSUMPLANCOUNT", typeof(decimal));
|
insertDT.Columns.Add("FPRDBILLNO", typeof(string));
|
insertDT.Columns.Add("HMainICMOBillNo", typeof(string));
|
insertDT.Columns.Add("FOWNERID", typeof(long));
|
insertDT.Columns.Add("FOWNERTYPEID", typeof(string));
|
insertDT.Columns.Add("FPLANDATE", typeof(DateTime));
|
insertDT.Columns.Add("FCOMPLETE", typeof(string));
|
insertDT.Columns.Add("FLACKCOUNT", typeof(decimal));
|
insertDT.Columns.Add("FOCCUPYCOUNT", typeof(decimal));
|
insertDT.Columns.Add("FCOMPLETECOUNT1", typeof(decimal));
|
insertDT.Columns.Add("FERPCLSID", typeof(string));
|
insertDT.Columns.Add("FWORKSHOPID", typeof(long));
|
insertDT.Columns.Add("FSTOCKID", typeof(long));
|
insertDT.Columns.Add("FOCCUPYPICKEDCOUNT", typeof(decimal));
|
insertDT.Columns.Add("HLOT", typeof(long));
|
insertDT.Columns.Add("HInventoryFID", typeof(string));
|
int jdtmmm = 1;
|
ds = oCN.RunProcReturn("select max(HInterID)FID FROM JIT_MOMaterReadysBill", "JIT_MOMaterReadysBill");
|
int maxFid = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString());
|
foreach (var item in completeAnalysisTempModel)
|
{
|
DataRow dr = insertDT.NewRow();
|
dr["FID"] = maxFid + jdtmmm;
|
dr["FDOCUMENTSTATUS"] = "A";
|
dr["FHMAINICMOINTERIDR"] = item.FHMainICMOInterIDr;
|
dr["FHMAINICMOENTRYID"] = item.FHMainICMOEntryID;
|
dr["FHICMOINTERID"] = item.FHICMOInterID;
|
dr["FHICMOENTRYID"] = item.FHICMOEntryID;
|
dr["FHMATERID"] = item.FHMaterID;
|
dr["FHSTOCKORGID"] = item.FHStockOrgID;
|
dr["FHSTOCKQTY"] = item.FHStockQty;
|
dr["FHLEFTQTY"] = item.FHLeftQty;
|
dr["FHPRDORGID"] = item.FHPRDORGID;
|
dr["FUNITDOSAGE"] = item.FUnitDosage;
|
dr["FSUMPLANCOUNT"] = item.FSumPlanCount;
|
dr["FPRDBILLNO"] = item.FPRDBillNo;
|
dr["HMainICMOBillNo"] = item.HMainICMOBillNo;
|
dr["FOWNERID"] = item.FOwnerId == null ? "0" : item.FOwnerId;
|
dr["FOWNERTYPEID"] = item.FOwnerTypeId;
|
dr["FPLANDATE"] = item.FPlanDate.ToString("yyyy-MM-dd");
|
dr["FCOMPLETE"] = item.FComPlete;
|
dr["FLACKCOUNT"] = item.FLackCount;
|
dr["FOCCUPYCOUNT"] = item.FOccupyCount;
|
dr["FCOMPLETECOUNT1"] = item.FCompleteCount1;
|
dr["FERPCLSID"] = item.FErpClsID;
|
dr["FWORKSHOPID"] = item.FWorkShop == null ? "0" : item.FWorkShop;
|
dr["FSTOCKID"] = item.FStock == null ? "0" : item.FStock;
|
dr["FOCCUPYPICKEDCOUNT"] = item.FOccupyPickedCount;
|
dr["HLOT"] = item.HLOT == null? "0" : item.HLOT;
|
dr["HInventoryFID"] = item.HInventoryFID == null ? "0" : item.HInventoryFID;
|
insertDT.Rows.Add(dr);
|
jdtmmm++;
|
}
|
|
insertDT.EndLoadData(); // 灌入数据结束
|
//插入之前执行下清空语句(测试是否能够防止重复生成)
|
string deletesql = $"delete from JIT_MOMaterReadysBill where HICMOInterID in ({fDayPlanFids}) ";
|
oCN.RunProc(deletesql);
|
// 批量插入到数据库
|
foreach (DataRow item in insertDT.Rows)
|
{
|
oCN.RunProc("insert into JIT_MOMaterReadysBill(HInterID,HDocumentStatus,HMainICMOInterID,HMainICMOEntryID,HICMOInterID" +
|
", HICMOEntryID, HMaterID, HStockORGID, HStockQty, HLeftQty" +
|
", HProdORGID, HUnitDosage, HSumPlanQty, HICMOBillNo, HOwnerID" +
|
", HOwnerTypeID, HPlanDate, HComplete, HLackQty, HOccupyQty" +
|
", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo" +
|
",HLOT,HInventoryFID)values" +
|
$"({item["FID"].ToString()}, 1, {item["FHMAINICMOINTERIDR"].ToString()}, {item["FHMAINICMOENTRYID"].ToString()}, {item["FHICMOINTERID"].ToString()}" +
|
$", {item["FHICMOENTRYID"].ToString()}, {item["FHMATERID"].ToString()}, {item["FHSTOCKORGID"].ToString()}, {item["FHSTOCKQTY"].ToString()}, {item["FHLEFTQTY"].ToString()}" +
|
$" , {item["FHPRDORGID"].ToString()}, {item["FUNITDOSAGE"].ToString()}, {item["FSUMPLANCOUNT"].ToString()}, '{item["FPRDBILLNO"].ToString()}', {item["FOWNERID"].ToString()}" +
|
$", '{item["FOWNERTYPEID"].ToString()}', '{item["FPLANDATE"].ToString()}','{item["FCOMPLETE"].ToString()}', {item["FLACKCOUNT"].ToString()}, {item["FOCCUPYCOUNT"].ToString()}" +
|
$", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}'" +
|
$",{item["HLOT"].ToString()},'{item["HInventoryFID"].ToString()}')");
|
}
|
//LogService.Write("批量插入到数据库用时：" + sw.Elapsed);
|
//执行完成后 更新日计划工单状态
|
string updatesql = string.Format(@"
|
update Sc_WorkBillSortBillSub set HComplete = '未齐套' where HEntryID IN
|
(select distinct HICMOEntryID from JIT_MOMaterReadysBill
|
where isnull(HComplete,'未齐套') ='未齐套'
|
and HICMOEntryID in ({0})
|
)", fDayPlanFEntryids);
|
//LogService.Write(Context, updatesql);
|
oCN.RunProc(updatesql);
|
updatesql = string.Format(@"
|
update Sc_WorkBillSortBillSub set HComplete = '齐套'
|
where HEntryID IN ({0}) and HComplete <>'未齐套'
|
", fDayPlanFEntryids);
|
//LogService.Write(updatesql);
|
oCN.RunProc(updatesql);
|
//释放齐套操作 避免多人同时进行齐套分析
|
oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
|
sw.Stop();//结束计时
|
//LogService.Write("齐套分析运行总时长：" + sw.Elapsed);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "操作成功";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
LogService.Write("操作失败：" + e.Message.ToString());
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 提料运算
|
|
#region 日计划展开数据明细
|
public class DayPlanPpbom
|
{
|
|
/// <summary>
|
/// 日计划工单主ID
|
/// </summary>
|
public long FID { get; set; }
|
/// <summary>
|
/// 生产订单号
|
/// </summary>
|
public string FBILLNO { get; set; }
|
/// <summary>
|
/// 日计划明细日期
|
/// </summary>
|
public DateTime FHMASTERDATE { get; set; }
|
/// <summary>
|
/// 日计划明细数量
|
/// </summary>
|
public decimal FHQTY { get; set; }
|
/// <summary>
|
/// 齐套数
|
/// </summary>
|
public decimal FCOMPLETECOUNT { get; set; }
|
/// <summary>
|
/// 生产订单工单ID
|
/// </summary>
|
public long FPRDMOMAINID { get; set; }
|
/// <summary>
|
/// 子表ID
|
/// </summary>
|
public int FENTRYID { get; set; }
|
/// <summary>
|
/// 单位用料
|
/// </summary>
|
public decimal FNeedQty { get; set; }
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
public string FMATERIALID { get; set; }
|
/// <summary>
|
/// 提前天数
|
/// </summary>
|
public int FFIXLEADTIME { get; set; }
|
/// <summary>
|
///最大包装
|
/// </summary>
|
public decimal FMAXPOQTY { get; set; }
|
/// <summary>
|
/// 最小包装量
|
/// </summary>
|
public decimal FMINPOQTY { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string FNumber { get; set; }
|
/// <summary>
|
/// 实际需求
|
/// </summary>
|
public decimal NeedQty { get; set; }
|
|
/// <summary>
|
/// 库存组织
|
/// </summary>
|
public long FStockOrgId { get; set; }
|
//库存组织名称
|
public string FStockOrgName { get; set; }
|
/// <summary>
|
/// jit物料分类
|
/// </summary>
|
public string FJITmaterialGroup { get; set; }
|
/// <summary>
|
/// JIT物料需求供货周期
|
/// </summary>
|
public string FJITMaterielDemand { get; set; }
|
/// <summary>
|
/// JIT安全库存
|
/// </summary>
|
public string FJITSafeStock { get; set; }
|
|
/// <summary>
|
/// 物料属性
|
/// </summary>
|
public string FErpClsID { get; set; }
|
/// <summary>
|
/// 需求单号（销售订单号）
|
/// </summary>
|
public string FXQD { get; set; }
|
/// <summary>
|
/// 日计划工单单号
|
/// </summary>
|
public string FDAYPLANBILLNO { get; set; }
|
/// <summary>
|
/// 生产车间编码
|
/// </summary>
|
public string FWORKSHOPNUMBER { get; set; }
|
|
|
}
|
#endregion
|
|
#region 采购订单物料库存
|
public class PurchaseInventory
|
{
|
/// <summary>
|
/// 采购FID
|
/// </summary>
|
public long FID { get; set; }
|
//采购订单单号
|
public string FBillNo { get; set; }
|
/// <summary>
|
/// 采购子表标识
|
/// </summary>
|
public long FENTRYID { get; set; }
|
/// <summary>
|
/// 供应商id
|
/// </summary>
|
public long FSUPPLIERID { get; set; }
|
/// <summary>
|
/// 供应商名称
|
/// </summary>
|
public string FNUMBER { get; set; }
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
public string FMATERIALID { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string FMATERIALNUMBER { get; set; }
|
|
/// <summary>
|
/// 采购数量
|
/// </summary>
|
public decimal FQTY { get; set; }
|
|
/// <summary>
|
/// 采购组织
|
/// </summary>
|
public long FStockOrgId { get; set; }
|
/// <summary>
|
/// 采购组织名称
|
/// </summary>
|
public string FStockOrgName { get; set; }
|
/// <summary>
|
/// 组织编码
|
/// </summary>
|
public string FORGNumber { get; set; }
|
/// <summary>
|
/// 提前期
|
/// </summary>
|
public int FFIXLEADTIME { get; set; }
|
|
/// <summary>
|
/// 需求单号
|
/// </summary>
|
public string FXQD { get; set; }
|
/// <summary>
|
/// 采购订单上的创建人
|
/// </summary>
|
public string FCREATORID { get; set; }
|
/// <summary>
|
/// 采购订单上的创建人名称
|
/// </summary>
|
public string FName { get; set; }
|
/// <summary>
|
/// 采购订单上的采购日期
|
/// </summary>
|
public DateTime FDate { get; set; }
|
/// <summary>
|
/// 采购订单上的交货日期
|
/// </summary>
|
public DateTime FDeliveryDate { get; set; }
|
/// <summary>
|
/// 采购订单表头摘要
|
/// </summary>
|
public string F_QIMB_NOTE { get; set; }
|
/// <summary>
|
/// 采购订单表体备注
|
/// </summary>
|
public string FNOTE { get; set; }
|
//采购部门
|
public string FPURCHASEDEPTNUMBER { get; set; }
|
|
/// <summary>
|
/// 收料但是没入库部分 需要优先去扣除
|
/// </summary>
|
public decimal FReceiveNotInQty { get; set; }
|
/// <summary>
|
/// 采购订单数量
|
/// </summary>
|
public decimal FPURCHASEQTY { get; set; }
|
/// <summary>
|
/// 采购订单关联数量
|
/// </summary>
|
public decimal FJOINQTY { get; set; }
|
|
/// <summary>
|
/// 收料单数量
|
/// </summary>
|
public decimal FReceiveQty { get; set; }
|
}
|
#endregion
|
|
#region 提料计划临时储存
|
public class PODemandPlanTemp
|
{
|
/// <summary>
|
/// 日计划工单主ID
|
/// </summary>
|
public long FID { get; set; }
|
/// <summary>
|
/// 日计划工单编号
|
/// </summary>
|
public string FBILLNO { get; set; }
|
/// <summary>
|
/// 日计划明细日期
|
/// </summary>
|
public DateTime FHMASTERDATE { get; set; }
|
/// <summary>
|
/// 日计划明细数量
|
/// </summary>
|
public decimal FHQTY { get; set; }
|
/// <summary>
|
/// 生产订单工单ID
|
/// </summary>
|
public long FPRDMOMAINID { get; set; }
|
/// <summary>
|
/// 子表ID
|
/// </summary>
|
public int FENTRYID { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public decimal FQty { get; set; }
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
public string FMATERIALID { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string FNumber { get; set; }
|
|
/// <summary>
|
/// 采购FID
|
/// </summary>
|
public long PurchseFID { get; set; }
|
/// <summary>
|
/// 采购订单单号
|
/// </summary>
|
public string PurchseFBillNo { get; set; }
|
/// <summary>
|
/// 采购子表标识
|
/// </summary>
|
public long PurchseFentryID { get; set; }
|
/// <summary>
|
/// 供应商id
|
/// </summary>
|
public long FSUPPLIERID { get; set; }
|
/// <summary>
|
/// 供应商名称
|
/// </summary>
|
public string PurchseFNUMBER { get; set; }
|
|
/// <summary>
|
/// 日计划日期
|
/// </summary>
|
public DateTime OLDDATE { get; set; }
|
|
/// <summary>
|
/// 采购订单数量
|
/// </summary>
|
public decimal PurchseFqty { get; set; }
|
|
/// <summary>
|
/// 提前期
|
/// </summary>
|
public double FFIXLEADTIME { get; set; }
|
|
/// <summary>
|
/// 采购组织
|
/// </summary>
|
public long FStockOrgId { get; set; }
|
/// <summary>
|
/// 采购组织名称
|
/// </summary>
|
public string FStockOrgName { get; set; }
|
/// <summary>
|
/// 组织编码
|
/// </summary>
|
public string FORGNumber { get; set; }
|
|
/// <summary>
|
/// 物料属性
|
/// </summary>
|
public string FErpClsID { get; set; }
|
|
/// <summary>
|
/// 需求单号
|
/// </summary>
|
public string FXQD { get; set; }
|
/// <summary>
|
/// 采购订单上的创建人
|
/// </summary>
|
public string FCREATORID { get; set; }
|
/// <summary>
|
/// 采购订单上的创建人名称
|
/// </summary>
|
public string FName { get; set; }
|
/// <summary>
|
/// 采购订单上的采购日期
|
/// </summary>
|
public DateTime FDate { get; set; }
|
/// <summary>
|
/// 采购订单上的交货日期
|
/// </summary>
|
public DateTime FDeliveryDate { get; set; }
|
/// <summary>
|
/// 采购订单表头摘要
|
/// </summary>
|
public string F_QIMB_NOTE { get; set; }
|
/// <summary>
|
/// 采购订单表体备注
|
/// </summary>
|
public string FNOTE { get; set; }
|
|
/// <summary>
|
/// 采购部门
|
/// </summary>
|
public string FPURCHASEDEPTNUMBER { get; set; }
|
/// <summary>
|
/// 日计划工单单号
|
/// </summary>
|
public string FDAYPLANBILLNO { get; set; }
|
/// <summary>
|
/// 生产车间编码
|
/// </summary>
|
public string FWORKSHOPNUMBER { get; set; }
|
/// <summary>
|
/// 采购订单数量
|
/// </summary>
|
public decimal FPURCHASEQTY { get; set; }
|
/// <summary>
|
/// 采购订单关联数量
|
/// </summary>
|
public decimal FJOINQTY { get; set; }
|
}
|
#endregion
|
|
[Route("JIT_DayPlanPlatFormBill/JIT_TLYS")]
|
[HttpGet]
|
public object JIT_TLYS(string sWhere, string user,string HTLType)
|
{
|
try
|
{
|
omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
|
|
string fProWorkShopId = omdelMian.HWorkShopID.ToString();
|
var fPrdOrgId = omdelMian.HProdORGID;
|
string sqlName = "";//AIS20210811135644
|
//客户制定
|
string sErr = "";
|
if (oSystemParameter.ShowBill(ref sErr))
|
{
|
if (oSystemParameter.omodel.WMS_CampanyName == "帅威")
|
{
|
sqlName = "AIS20230129011339";
|
}
|
else if (oSystemParameter.omodel.WMS_CampanyName == "凯贝奈特")
|
{
|
sqlName = "AIS20210820164804";
|
}
|
else if (oSystemParameter.omodel.WMS_CampanyName == "添康科技")
|
{
|
sqlName = "AIS20240809105013";
|
}
|
else if (oSystemParameter.omodel.WMS_CampanyName == "宝工")
|
{
|
sqlName = "AIS20250102123554";
|
}
|
else
|
{
|
sqlName = "AIS20210811135644";
|
}
|
}
|
|
|
if (HTLType == "缺料")
|
{
|
objJsonResult = (json)JIT_QL(fProWorkShopId, fPrdOrgId, user, sqlName);
|
}
|
else if (HTLType == "生产用料清单")
|
{
|
objJsonResult=(json)JIT_PPBOM(fProWorkShopId, fPrdOrgId, user, sqlName);
|
}
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
LogService.Write("操作失败：" + e.Message.ToString());
|
oCN.RollBack();//事务回滚
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 通过缺料情况算提料
|
/// </summary>
|
/// <returns></returns>
|
public object JIT_QL(string HWorkShopID,int? HProdORGID,string user,string sqlName) {
|
try
|
{
|
|
oCN.BeginTran();
|
|
DataSet DaSet = oCN.RunProcReturn($"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},1", "JIT_MOMaterReadysBill");
|
|
if (DaSet.Tables[0].Rows[0][0].ToString() != "1")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有数据,请先齐套分析!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//Stopwatch sw = new Stopwatch();
|
//sw.Start();//开始计时
|
//提料计划预处理 清理提料计划单数据 更新采购订单提料计划数量
|
// string sql = string.Format(@"
|
// /*dialect*/
|
//exec [提料计划预处理]
|
//");
|
// DBServiceHelper.Execute(Context, sql);
|
////LogHelper.Info("[提料计划准备阶段]提料计划预处理sql：" + sql);
|
//采购订单数据
|
string sql = $@"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},2";
|
DataSet ds = oCN.RunProcReturn(sql, "t_PUR_POOrderEntry");
|
List<PurchaseInventory> PurchaseInventory = ds.ToModelList<PurchaseInventory>();
|
////LogHelper.Info("[提料计划准备阶段]可用采购订单数据sql：" + sql);
|
sql = string.Format($@"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},3");
|
////LogHelper.Info("[提料计划准备阶段]需要提料数据sql：" + sql);
|
ds = oCN.RunProcReturn( sql, "JIT_MOMaterReadysBill");
|
List<DayPlanPpbom> DayPlanPpbom = ds.ToModelList<DayPlanPpbom>();
|
//物料+库存组织分类
|
var MaterialIDList = DayPlanPpbom.GroupBy(p => new { p.FMATERIALID, p.FNumber,p.FStockOrgName, p.FStockOrgId }).Select(x => new PODemandPlanTemp { FMATERIALID = x.Key.FMATERIALID, FNumber=x.Key.FNumber, FStockOrgId = x.Key.FStockOrgId , FStockOrgName =x.Key.FStockOrgName }).ToList();
|
//提料计划数据集临时存储集合
|
List<PODemandPlanTemp> PODemandPlanTemp = new List<PODemandPlanTemp>();
|
//sql集合 更新采购订单占用的提料计划数量
|
List<string> sqlList = new List<string>();
|
|
//LogService.Write("1");
|
string Error = "";
|
foreach (var item in MaterialIDList)
|
{
|
//当前物料没有采购订单时 直接跳出
|
List<PurchaseInventory> _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
|
if (_PurchaseInventory.Count == 0)
|
{
|
Error+="[提料计划开始]当前物料无采购信息：" + item.FNumber + " 库存组织：" + item.FStockOrgName + " ";
|
continue;
|
}
|
|
//LogService.Write("1.1");
|
|
////LogHelper.Info(item.FMATERIALID.ToString());
|
//当前物料和库存组织对应的需进行提料计划的数据
|
List<DayPlanPpbom> _DayPlanPpbom = DayPlanPpbom.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId).ToList();
|
decimal FMINPOQTY = _DayPlanPpbom.FirstOrDefault().FMINPOQTY;//最小起订量
|
double FFIXLEADTIME = _DayPlanPpbom.FirstOrDefault().FFIXLEADTIME;//提前期
|
//double FFIXLEADTIME = 3;//提前期(2022-1-26 提前期改为3天 乃永刚反馈)
|
string FJITmaterialGroup = _DayPlanPpbom.FirstOrDefault().FJITmaterialGroup;//jit物料分类
|
string FJITMaterielDemand = _DayPlanPpbom.FirstOrDefault().FJITMaterielDemand; //JIT物料需求供货周期
|
string FJITSafeStock = _DayPlanPpbom.FirstOrDefault().FJITSafeStock; //JIT安全库存
|
decimal NeedQty = 0;
|
DateTime DATE = _DayPlanPpbom.FirstOrDefault().FHMASTERDATE;//第一个订货起始日期
|
int i = 0;
|
//记录在最小采购量需求下的日计划明细FentyrID
|
|
//LogService.Write("1.2");
|
|
List<int> FEntryIdList = new List<int>();
|
foreach (var _item in _DayPlanPpbom)
|
{
|
i++;
|
_PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
|
if (_PurchaseInventory.Count == 0)
|
{
|
break;
|
}
|
|
//LogService.Write("1.2.1");
|
|
if (NeedQty == 0)
|
{
|
DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-FFIXLEADTIME);
|
}
|
FEntryIdList.Add(_item.FENTRYID);
|
NeedQty += _item.NeedQty;
|
//LogService.Write(FJITmaterialGroup);
|
//LogService.Write(FEntryIdList.Count);
|
//LogService.Write(Convert.ToDouble(FJITMaterielDemand));
|
//LogService.Write(_DayPlanPpbom.Count);
|
//LogService.Write(i);
|
if ((FJITmaterialGroup == "总量控制规格类" || FJITmaterialGroup == "订单专用个性类") && FEntryIdList.Count < Convert.ToDouble(FJITMaterielDemand) && i < _DayPlanPpbom.Count) //订单专用个性类
|
{
|
continue;
|
}
|
|
//LogService.Write("1.2.2");
|
|
foreach (var Purchase in _PurchaseInventory)
|
{
|
if (Purchase.FQTY >= NeedQty)
|
{
|
foreach (int id in FEntryIdList)
|
{
|
var DayPlanPpbomls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = DayPlanPpbomls.FID,
|
FHMASTERDATE = DATE,
|
FQty = DayPlanPpbomls.NeedQty,
|
FBILLNO = DayPlanPpbomls.FBILLNO,
|
FENTRYID = DayPlanPpbomls.FENTRYID,
|
FMATERIALID = DayPlanPpbomls.FMATERIALID,
|
FNumber = DayPlanPpbomls.FNumber,
|
OLDDATE = DayPlanPpbomls.FHMASTERDATE,
|
FFIXLEADTIME = FFIXLEADTIME,
|
FErpClsID = DayPlanPpbomls.FErpClsID,
|
|
PurchseFID = Purchase.FID,
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO
|
});
|
//扣除日计划明细已被分配的数量
|
DayPlanPpbomls.NeedQty = 0;
|
}
|
|
//LogService.Write("1.2.3");
|
|
FEntryIdList.Clear();
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
|
//扣除当前行对应采购订单数量
|
var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
|
ls.FQTY -= NeedQty;
|
break;
|
}
|
else
|
{
|
//更新总需求数量
|
NeedQty = NeedQty - Purchase.FQTY;
|
//采购订单数量
|
decimal _NeedQty = Purchase.FQTY;
|
List<int> mmm = new List<int>();
|
foreach (int id in FEntryIdList)
|
{
|
var DayPlanPpbomls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
|
decimal Qty = DayPlanPpbomls.NeedQty;//订单数量
|
|
if (Qty > _NeedQty)
|
Qty = _NeedQty; //订单数量>采购订单数量 取采购订单
|
|
_NeedQty = _NeedQty - Qty;
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = DayPlanPpbomls.FID,
|
FHMASTERDATE = DATE,
|
FQty = Qty,
|
FBILLNO = DayPlanPpbomls.FBILLNO,
|
FENTRYID = DayPlanPpbomls.FENTRYID,
|
FMATERIALID = DayPlanPpbomls.FMATERIALID,
|
FNumber = DayPlanPpbomls.FNumber,
|
OLDDATE = DayPlanPpbomls.FHMASTERDATE,
|
FFIXLEADTIME = FFIXLEADTIME,
|
FErpClsID = DayPlanPpbomls.FErpClsID,
|
|
PurchseFID = Purchase.FID,
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
|
FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO
|
});
|
//更新计划数量（剩余需要排的） 继续去计算下一个采购订单
|
DayPlanPpbomls.NeedQty -= Qty;
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Qty}' where FENTRYID = {Purchase.FENTRYID}");
|
//更新Model
|
var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
|
ls.FQTY -= Qty;
|
if (_NeedQty <= 0)
|
{
|
foreach (var mm in mmm)
|
{
|
FEntryIdList.Remove(mm);
|
}
|
break;
|
}
|
mmm.Add(id);
|
}
|
}
|
}
|
|
//LogService.Write("1.2.4");
|
|
NeedQty = 0;
|
|
}
|
}
|
|
//var PODemandPlanList222 = PODemandPlanTemp.GroupBy(p => new PODemandPlanTemp { PurchseFNUMBER = p.PurchseFNUMBER, FHMASTERDATE = p.FHMASTERDATE }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE }).ToList();
|
var PODemandPlanList = PODemandPlanTemp.GroupBy(p => new { p.PurchseFNUMBER, p.FHMASTERDATE }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE }).ToList();
|
//LogHelper.Info($"提料计划，数据准备完成，保存到Model实体，总行数：{PODemandPlanTemp.Count}");
|
int tlmmm = 0;
|
JArray FinalyResult = new JArray();
|
|
//LogService.Write("2");
|
|
foreach (var item in PODemandPlanList)
|
{
|
tlmmm++;
|
|
DateTime date = item.FHMASTERDATE;
|
string PurchseFNUMBER = item.PurchseFNUMBER;
|
//JObject model = new JObject();
|
//model.Add("FHDate", date);
|
//model.Add("FDeliveryDate", date.AddDays(-3));//供应商预计发货日期
|
//model.Add("FSettleCurrId", new JObject() { ["Fnumber"] = "PRE001" });
|
//model.Add("FSupplierID", new JObject() { ["Fnumber"] = PurchseFNUMBER });
|
|
var HInterID = DBUtility.ClsPub.CreateBillID("4608", ref DBUtility.ClsPub.sExeReturnInfo);
|
var HBillNo = DBUtility.ClsPub.CreateBillCode("4608", ref DBUtility.ClsPub.sExeReturnInfo, true);
|
|
var dataUser = oCN.RunProcReturn("select Czymc from gy_czygl where Czybm = '" + user + "'", "gy_czygl");
|
string HMaker = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//制单人
|
string HUpDater = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//修改人
|
|
|
var dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
|
inner join "+ sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
|
where FNUMBER='" + PODemandPlanTemp[0].FORGNumber + "' and HItemID ='" + HProdORGID + "'", "Xt_ORGANIZATIONS");
|
long HPURCHASEORGID = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); //采购组织
|
|
var dataSup = oCN.RunProcReturn(@"select * from Gy_Supplier p
|
inner join " + sqlName + @"..t_BD_Supplier fp on p.HNumber=fp.FNUMBER and p.HUSEORGID=fp.FUSEORGID
|
where FNUMBER='" + item.PurchseFNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Supplier");
|
long HSupplierID = dataSup.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataSup.Tables[0].Rows[0]["HItemID"].ToString()); //供应商
|
|
long HSettleCurrId = 1;//货币 默认本地人民币
|
|
//主表
|
oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
|
",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
|
",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
|
",HRemark,HExplanation,HUpDater,HUpDateDate)" +
|
$"values({HInterID}, '{HBillNo}', {DateTime.Now.Year}, {DateTime.Now.Month}, '4608'" +
|
$", '4608','{date}',1, '{HMaker}',GETDATE()," +
|
$"{HPURCHASEORGID},'',{HPURCHASEORGID}, {HSupplierID}, {HSettleCurrId}" +
|
$",'','','{HUpDater}',getdate())");
|
|
JArray Fentity = new JArray();
|
List<PODemandPlanTemp> _PODemandPlanList = PODemandPlanTemp.Where(x => x.FHMASTERDATE == date && x.PurchseFNUMBER == PurchseFNUMBER).ToList();
|
//LogService.Write("测试listmodel：" + _PODemandPlanList[0].FORGNumber.ToString());
|
int i = 0;
|
foreach (var _item in _PODemandPlanList)
|
{
|
i++;
|
//if (!model.ToString().Contains("FHPURCHASEORGID"))
|
// model.Add("FHPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });
|
//JObject FentityModel = new JObject();
|
//FentityModel.Add("FHPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });//采购组织
|
//FentityModel.Add("FHMaterID", new JObject() { ["Fnumber"] = _item.FNumber });//物料
|
//FentityModel.Add("FHQty", _item.FQty);//数量
|
//FentityModel.Add("FHSourceInterID", _item.FID);//日计划工单FID
|
//FentityModel.Add("FHSourceEntryID", _item.FENTRYID);//日计划工单FENTRYID
|
//FentityModel.Add("FHSourceBillNo", _item.FBILLNO);//日计划工单单号
|
//FentityModel.Add("FHSourceBillType", "");//日计划工单类型
|
//FentityModel.Add("FDayPlanDate", _item.OLDDATE);//日计划工单类型
|
//FentityModel.Add("FHRelationQty", _item.PurchseFqty);//关联数量
|
//FentityModel.Add("FFIXLEADTIME", _item.FFIXLEADTIME);//提前期
|
//FentityModel.Add("FPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });//采购组织
|
//FentityModel.Add("FHPOOrderInterID", _item.PurchseFID);// 采购订单内码：FHPOOrderInterID
|
//FentityModel.Add("FHPOOrderEntryID", _item.PurchseFentryID); //采购订单子内码：FHPOOrderEntryID
|
//FentityModel.Add("FHPOOrderBillNo", _item.PurchseFBillNo); //采购订单号：FHPOOrderBillNo
|
//FentityModel.Add("FERPCLSID", _item.FErpClsID); //发料方式
|
//FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = "Pcs" }); //发料方式
|
//Fentity.Add(FentityModel);
|
|
|
var dataSet = oCN.RunProcReturn(@"select m.* from Gy_Material m
|
inner join " + sqlName + @"..T_BD_MATERIAL fm on m.HNumber = fm.FNUMBER and m.HUSEORGID=fm.FUSEORGID
|
where FNUMBER='" + _item.FNumber + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Material");
|
string HMaterID = "0"; //物料
|
string HMaterModel = ""; //物料代码
|
string HMaterName = ""; //物料名称
|
if (dataSet.Tables[0].Rows.Count != 0)
|
{
|
HMaterID = dataSet.Tables[0].Rows[0]["HItemID"].ToString(); //物料
|
HMaterModel = dataSet.Tables[0].Rows[0]["HNumber"].ToString(); //物料代码
|
HMaterName = dataSet.Tables[0].Rows[0]["HName"].ToString(); //物料名称
|
}
|
|
decimal HQty = _item.FQty; //数量
|
long HSourceInterID = _item.FID; //日计划工单FID
|
long HSourceEntryID = _item.FENTRYID;//日计划工单FENTRYID
|
string HSourceBillNo = _item.FBILLNO; //生产订单号
|
string HSourceBillType = ""; //日计划工单类型
|
DateTime HDayPlanDate = _item.OLDDATE; // 工单生产日期
|
decimal HRelationQty = _item.PurchseFqty; // 关联数量
|
double HFixleadTime = _item.FFIXLEADTIME; // 提前期
|
|
dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
|
inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
|
where FNUMBER='" + _item.FORGNumber + "' and HItemID ='" + HProdORGID + "'", "Xt_ORGANIZATIONS");
|
long HPURCHASEORGIDSub = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); // 采购组织
|
long HPOOrderInterID = _item.PurchseFID; // 采购订单内码
|
long HPOOrderEntryID = _item.PurchseFentryID; // 采购订单子内码
|
string HPOOrderBillNo = _item.PurchseFBillNo; // 采购订单号
|
string HErpClsID = _item.FErpClsID; // 物料属性
|
long HUnitID = 10101; // 计量单位 先按照本地来 默认 Pcs
|
string HSeOrderBillNo = _item.FXQD; // 销售订单号 需求单号
|
string HOrderEmpID = _item.FCREATORID; // 采购员
|
DateTime HPOOrderBillDate = _item.FDate; // 采购订单单据日期
|
DateTime HPOOrderBillDeliveryDate = _item.FDeliveryDate; // 采购订单交货日期
|
string HPOOrderBillRemark = _item.F_QIMB_NOTE; // 采购订单摘要
|
string HPOOrderBillNote = _item.FNOTE; // 采购订单表体备注
|
string HDayPlanBillNo = _item.FDAYPLANBILLNO; // 日计划工单号
|
|
dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
|
inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
|
where FNUMBER='" + _item.FWORKSHOPNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Department");
|
HWorkShopID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 生产车间
|
|
dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
|
inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
|
where FNUMBER='" + _item.FPURCHASEDEPTNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Department");
|
string HPurchaseDeptID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 采购部门
|
|
decimal HPURCHASEQTY = _item.FPURCHASEQTY; // 采购订单数量
|
decimal HJoinQty = _item.FJOINQTY; // 采购订单关联数量
|
|
oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
|
", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
|
", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
|
", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
|
", HRelationQty1, HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HPOOrderBillSEQ" +
|
", HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo, HPurchaseDeptID, HCloseTypeSub" +
|
", HCloseMan, HEntryCloseDate, HSendQty, HReciveQty, HCloseStatus" +
|
", HRemoveQty, HSeOrderBillNo, HUnReciveQty, HPOOrderBillDate, HPOOrderBillDeliveryDate" +
|
", HPOOrderBillRemark, HPOOrderBillNote)" +
|
$"values({HInterID}, {i}, '', {(HMaterID == null ? "0" : HMaterID)}, '{HMaterName}'" +
|
$", '{HMaterModel}', {HUnitID}, '{HErpClsID}', {HQty}, ''" +
|
$", {HPURCHASEORGIDSub}, '', {HFixleadTime}, '{HDayPlanBillNo}', {HSourceInterID}" +
|
$", {HSourceEntryID}, '{HSourceBillNo}', '{HSourceBillType}', {HWorkShopID}, '{HDayPlanDate}'" +
|
$", {HRelationQty}, {HPOOrderInterID},{HPOOrderEntryID}, '{HPOOrderBillNo}',0" +
|
$",0,0, '',{HPurchaseDeptID}, '0'" +
|
$", '','',0,0, '0'" +
|
$",0, '{HSeOrderBillNo}',0, '{HPOOrderBillDate}', '{HPOOrderBillDeliveryDate}'" +
|
$", '{HPOOrderBillRemark}', '{HPOOrderBillNote}')");
|
|
}
|
//model.Add("FEntity", Fentity);
|
//FinalyResult.Add(model);
|
// if ((tlmmm >= 20 || tlmmm == PODemandPlanList.Count) && (tlmmm % 20 == 0 || tlmmm == PODemandPlanList.Count))
|
// {
|
// //LogHelper.Info("提料计划新增批量执行，记录循环的当前条数" + tlmmm);
|
// JObject jsonRoot = new JObject()
|
// {
|
// ["Creator"] = "",
|
// ["NeedUpDateFields"] = new JArray(),
|
// ["NeedReturnFields"] = new JArray(),
|
// ["IsDeleteEntry"] = "false",
|
// ["SubSystemId"] = "",
|
// ["IsVerifyBaseDataField"] = "false",
|
// ["Model"] = FinalyResult
|
// };
|
// CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");
|
// var result = cloudClient.BatchSave("paez_PODemandPlan", jsonRoot.ToString());
|
// JObject saveObj = JObject.Parse(result);
|
// string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
|
// if (saveIsSuc != "TRUE")
|
// {
|
// //LogHelper.Error(jsonRoot.ToString());
|
// }
|
// FinalyResult = new JArray();
|
// }
|
// tlmmm++;
|
}
|
|
//LogService.Write("3");
|
if (Error != "")
|
{
|
oCN.Commit();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "运算成功!" + Error;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else if (tlmmm == PODemandPlanList.Count && tlmmm != 0)
|
{
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "运算成功!" + Error;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
oCN.RollBack();//事务回滚
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "运算失败!" + Error;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
////sw.Stop();//结束计时
|
//////LogHelper.Info("提料计划执行完成，运行总时长：" + sw.Elapsed);
|
//DBServiceHelper.ExecuteBatch(Context, sqlList);
|
|
//objJsonResult.code = "1";
|
//objJsonResult.count = 1;
|
//objJsonResult.Message = "提料运算成功！";
|
//objJsonResult.data = null;
|
//return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
LogService.Write("操作失败：" + e.Message.ToString());
|
oCN.RollBack();//事务回滚
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
/// <summary>
|
/// 通过生产用料清单 算缺料情况
|
/// </summary>
|
/// <returns></returns>
|
public object JIT_PPBOM(string fProWorkShopId,int? fPrdOrgId,string user,string sqlName) {
|
|
try
|
{
|
Stopwatch sw = new Stopwatch();
|
sw.Start();//开始计时
|
//提料计划预处理 清理提料计划单数据 更新采购订单提料计划数量 并且查询出需要进行运算的数据
|
|
oCN.BeginTran(); //开始事务
|
|
ds = oCN.RunProcReturn($"exec h_p_PROC_JIT_TLPLANYCL '{fProWorkShopId}','{fPrdOrgId}'", "h_p_PROC_JIT_TLPLANYCL");
|
List<DayPlanPpbom> DayPlanPpbom = ds.ToModelList<DayPlanPpbom>();
|
|
if (DayPlanPpbom.Count == 0)
|
{
|
oCN.RollBack();//回滚事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无数据运算!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//采购订单数据 （剩余收料数量）
|
|
//t2.FXQD t2.FSTOCKINQTY,t2.FReceiveQty 本地没有这些字段
|
string sql = string.Format(@"
|
select * from h_v_jit_POOrderList where FQTY>0 and FCloseStatus in('A')
|
and FMRPCLOSESTATUS in('A') and FBillTypeID in('83d822ca3e374b4ab01e5dd46a0062bd','6d01d059713d42a28bb976c90a121142') and FStockOrgId = '{0}'", fPrdOrgId);
|
|
ds = oCN.RunProcReturn(sql, "h_v_jit_POOrderList");
|
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
oCN.RollBack();//回滚事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查无采购订单数据!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
List<PurchaseInventory> PurchaseInventory = ds.ToModelList<PurchaseInventory>();
|
//物料+库存组织分类
|
var MaterialIDList = DayPlanPpbom.GroupBy(p => new { p.FMATERIALID, p.FStockOrgId }).Select(x => new PODemandPlanTemp { FMATERIALID = x.Key.FMATERIALID, FStockOrgId = x.Key.FStockOrgId }).ToList();
|
|
//提料计划数据集临时存储集合
|
List<PODemandPlanTemp> PODemandPlanTemp = new List<PODemandPlanTemp>();
|
//sql集合 更新采购订单占用的提料计划数量
|
List<string> sqlList = new List<string>();
|
|
foreach (var item in MaterialIDList)
|
{
|
//this.View.Session["ProcessRateValue"] = Convert.ToInt32((Convert.ToDecimal(75) / MaterialIDList.Count) * i);
|
//当前物料和库存组织对应的需进行提料计划的数据
|
List<DayPlanPpbom> _DayPlanPpbom = DayPlanPpbom.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId).ToList();
|
decimal NeedQty = 0;
|
foreach (var _item in _DayPlanPpbom)
|
{
|
//查询有没有可以用于提料的采购订单数据
|
var _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
|
if (_PurchaseInventory.Count == 0)
|
{
|
//无采购订单直接下一个物料
|
sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{_item.NeedQty},0) ";
|
sqlList.Add(sql);
|
break;
|
}
|
//需求数量
|
NeedQty = _item.NeedQty;
|
//增加一个销售订单号匹配的逻辑 优先循环
|
var PurchaseInventoryBySalOrder = _PurchaseInventory.Where(x => x.FXQD == _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
|
if (PurchaseInventoryBySalOrder.Count > 0)
|
{
|
foreach (var Purchase in PurchaseInventoryBySalOrder)
|
{
|
double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//提前期
|
DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
|
if (Purchase.FQTY >= NeedQty)
|
{
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = _item.FID,
|
FHMASTERDATE = _DATE,
|
FQty = NeedQty,
|
FBILLNO = _item.FBILLNO,
|
FENTRYID = _item.FENTRYID,
|
FMATERIALID = _item.FMATERIALID,
|
FNumber = _item.FNumber,
|
OLDDATE = _item.FHMASTERDATE,
|
FFIXLEADTIME = _FFIXLEADTIME,
|
FErpClsID = _item.FErpClsID,
|
FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
|
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
|
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY
|
|
});
|
//扣除日计划明细已被分配的数量
|
_item.NeedQty = 0;
|
//扣除当前行对应采购订单数量
|
Purchase.FQTY -= NeedQty;
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
|
//需求数量变为0
|
NeedQty = 0;
|
break;
|
}
|
else//采购订单数据不能满足订单所需数量
|
{
|
//采购订单数量
|
decimal _NeedQty = Purchase.FQTY;
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = _item.FID,
|
FHMASTERDATE = _DATE,
|
FQty = _NeedQty,
|
FBILLNO = _item.FBILLNO,
|
FENTRYID = _item.FENTRYID,
|
FMATERIALID = _item.FMATERIALID,
|
FNumber = _item.FNumber,
|
OLDDATE = _item.FHMASTERDATE,
|
FFIXLEADTIME = _FFIXLEADTIME,
|
FErpClsID = _item.FErpClsID,
|
FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
|
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
|
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY
|
});
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
|
//更新订单需求数量
|
NeedQty = NeedQty - Purchase.FQTY;
|
//扣除日计划明细已被分配的数量
|
_item.NeedQty -= _NeedQty;
|
//扣除当前行对应采购订单数量
|
Purchase.FQTY = 0;
|
}
|
}
|
}
|
if (NeedQty == 0)
|
continue;
|
var PurchaseInventoryElse = _PurchaseInventory.Where(x => x.FXQD != _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
|
foreach (var Purchase in PurchaseInventoryElse)
|
{
|
double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//提前期
|
DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
|
if (Purchase.FQTY >= NeedQty)
|
{
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = _item.FID,
|
FHMASTERDATE = _DATE,
|
FQty = _item.NeedQty,
|
FBILLNO = _item.FBILLNO,
|
FENTRYID = _item.FENTRYID,
|
FMATERIALID = _item.FMATERIALID,
|
FNumber = _item.FNumber,
|
OLDDATE = _item.FHMASTERDATE,
|
FFIXLEADTIME = _FFIXLEADTIME,
|
FErpClsID = _item.FErpClsID,
|
FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
|
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
|
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY
|
});
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
|
//扣除日计划明细已被分配的数量
|
_item.NeedQty = 0;
|
//扣除当前行对应采购订单数量
|
Purchase.FQTY -= NeedQty;
|
//需求数量变为0
|
NeedQty = 0;
|
break;
|
}
|
else//采购订单数据不能满足订单所需数量
|
{
|
//更新总需求数量
|
NeedQty = NeedQty - Purchase.FQTY;
|
//采购订单数量
|
decimal _NeedQty = Purchase.FQTY;
|
PODemandPlanTemp.Add(new PODemandPlanTemp
|
{
|
FID = _item.FID,
|
FHMASTERDATE = _DATE,
|
FQty = _NeedQty,
|
FBILLNO = _item.FBILLNO,
|
FENTRYID = _item.FENTRYID,
|
FMATERIALID = _item.FMATERIALID,
|
FNumber = _item.FNumber,
|
OLDDATE = _item.FHMASTERDATE,
|
FFIXLEADTIME = _FFIXLEADTIME,
|
FErpClsID = _item.FErpClsID,
|
FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
|
FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
|
|
PurchseFentryID = Purchase.FENTRYID,
|
FSUPPLIERID = Purchase.FSUPPLIERID,
|
PurchseFNUMBER = Purchase.FNUMBER,
|
PurchseFBillNo = Purchase.FBillNo,
|
PurchseFqty = Purchase.FQTY,
|
FStockOrgId = Purchase.FStockOrgId, //采购组织
|
FORGNumber = Purchase.FORGNumber,
|
FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
|
|
FXQD = _item.FXQD,
|
FCREATORID = Purchase.FCREATORID,
|
FName = Purchase.FName,
|
FDate = Purchase.FDate,
|
FDeliveryDate = Purchase.FDeliveryDate,
|
F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
|
FNOTE = Purchase.FNOTE,
|
FPURCHASEQTY = Purchase.FPURCHASEQTY,
|
FJOINQTY = Purchase.FJOINQTY
|
});
|
//更新采购订单
|
//sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
|
//扣除日计划明细已被分配的数量
|
_item.NeedQty -= _NeedQty;
|
//扣除当前行对应采购订单数量
|
Purchase.FQTY = 0;
|
}
|
}
|
if (NeedQty > 0)
|
{
|
sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE,HERRORTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{NeedQty},0,1) ";
|
sqlList.Add(sql);
|
}
|
}
|
}
|
|
//供应商，提料日期，生产车间，采购员 分组
|
var PODemandPlanList = PODemandPlanTemp.GroupBy(p => new { p.PurchseFNUMBER, p.FHMASTERDATE, p.FWORKSHOPNUMBER, p.FCREATORID }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE, FWORKSHOPNUMBER = x.Key.FWORKSHOPNUMBER, FCREATORID = x.Key.FCREATORID }).ToList();
|
|
LogService.Write("提料计划重算 ，数据准备完成，保存到Model实体 用时：" + sw.Elapsed + "总行数：" + PODemandPlanTemp.Count);
|
|
int tlmmm = 0;
|
JArray FinalyResult = new JArray();
|
foreach (var item in PODemandPlanList)
|
{
|
tlmmm++;
|
|
DateTime date = item.FHMASTERDATE;
|
long HSettleCurrId = 1;//货币 默认本地人民币
|
|
var dataSup = oCN.RunProcReturn(@"select * from Gy_Supplier p
|
inner join " + sqlName + @"..t_BD_Supplier fp on p.HNumber=fp.FNUMBER and p.HUSEORGID=fp.FUSEORGID
|
where FNUMBER='" + item.PurchseFNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Supplier");
|
long HSupplierID = dataSup.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataSup.Tables[0].Rows[0]["HItemID"].ToString()); //供应商
|
|
var dataUser = oCN.RunProcReturn("select Czymc from gy_czygl where Czybm = '" + user + "'", "gy_czygl");
|
string HMaker = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//制单人
|
string HUpDater = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//修改人
|
|
var dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
|
inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
|
where FNUMBER='" + PODemandPlanTemp[0].FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
|
long HPURCHASEORGID = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); //采购组织
|
|
string PurchseFNUMBER = item.PurchseFNUMBER;
|
string FWorkshopNumber = item.FWORKSHOPNUMBER;
|
string FCreatorID = item.FCREATORID;
|
|
var HInterID = DBUtility.ClsPub.CreateBillID("4608", ref DBUtility.ClsPub.sExeReturnInfo);
|
var HBillNo = DBUtility.ClsPub.CreateBillCode("4608", ref DBUtility.ClsPub.sExeReturnInfo, true);
|
//主表
|
oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
|
",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
|
",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
|
",HRemark,HExplanation,HUpDater,HUpDateDate)" +
|
$"values({HInterID}, '{HBillNo}', {DateTime.Now.Year}, {DateTime.Now.Month}, '4608'" +
|
$", '4608','{date}',1, '{HMaker}',GETDATE()," +
|
$"{HPURCHASEORGID},'',{HPURCHASEORGID}, {HSupplierID}, {HSettleCurrId}" +
|
$",'','','{HUpDater}',getdate())");
|
|
List<PODemandPlanTemp> _PODemandPlanList = PODemandPlanTemp.Where(x => x.FHMASTERDATE == date && x.PurchseFNUMBER == PurchseFNUMBER && x.FWORKSHOPNUMBER == FWorkshopNumber && x.FCREATORID == FCreatorID).ToList();
|
int i = 0;
|
foreach (var _item in _PODemandPlanList)
|
{
|
i++;
|
|
var dataSet = oCN.RunProcReturn(@"select m.* from Gy_Material m
|
inner join " + sqlName + @"..T_BD_MATERIAL fm on m.HNumber = fm.FNUMBER and m.HUSEORGID=fm.FUSEORGID
|
where FNUMBER='" + _item.FNumber + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Material");
|
string HMaterID = "0"; //物料
|
string HMaterModel = ""; //物料代码
|
string HMaterName = ""; //物料名称
|
if (dataSet.Tables[0].Rows.Count != 0)
|
{
|
HMaterID = dataSet.Tables[0].Rows[0]["HItemID"].ToString(); //物料
|
HMaterModel = dataSet.Tables[0].Rows[0]["HNumber"].ToString(); //物料代码
|
HMaterName = dataSet.Tables[0].Rows[0]["HName"].ToString(); //物料名称
|
}
|
|
decimal HQty = _item.FQty; //数量
|
long HSourceInterID = _item.FID; //日计划工单FID
|
long HSourceEntryID = _item.FENTRYID;//日计划工单FENTRYID
|
string HSourceBillNo = _item.FBILLNO; //生产订单号
|
string HSourceBillType = ""; //日计划工单类型
|
DateTime HDayPlanDate = _item.OLDDATE; // 工单生产日期
|
decimal HRelationQty = _item.PurchseFqty; // 关联数量
|
double HFixleadTime = _item.FFIXLEADTIME; // 提前期
|
|
dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
|
inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
|
where FNUMBER='" + _item.FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
|
long HPURCHASEORGIDSub = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); // 采购组织
|
long HPOOrderInterID = _item.PurchseFID; // 采购订单内码
|
long HPOOrderEntryID = _item.PurchseFentryID; // 采购订单子内码
|
string HPOOrderBillNo = _item.PurchseFBillNo; // 采购订单号
|
string HErpClsID = _item.FErpClsID; // 物料属性
|
long HUnitID = 10101; // 计量单位 先按照本地来 默认 Pcs
|
string HSeOrderBillNo = _item.FXQD; // 销售订单号 需求单号
|
string HOrderEmpID = _item.FCREATORID; // 采购员
|
DateTime HPOOrderBillDate = _item.FDate; // 采购订单单据日期
|
DateTime HPOOrderBillDeliveryDate = _item.FDeliveryDate; // 采购订单交货日期
|
string HPOOrderBillRemark = _item.F_QIMB_NOTE; // 采购订单摘要
|
string HPOOrderBillNote = _item.FNOTE; // 采购订单表体备注
|
string HDayPlanBillNo = _item.FDAYPLANBILLNO; // 日计划工单号
|
|
dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
|
inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
|
where FNUMBER='" + _item.FWORKSHOPNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
|
string HWorkShopID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 生产车间
|
|
dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
|
inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
|
where FNUMBER='" + _item.FPURCHASEDEPTNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
|
string HPurchaseDeptID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 采购部门
|
|
decimal HPURCHASEQTY = _item.FPURCHASEQTY; // 采购订单数量
|
decimal HJoinQty = _item.FJOINQTY; // 采购订单关联数量
|
|
oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
|
", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
|
", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
|
", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
|
", HRelationQty1, HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HPOOrderBillSEQ" +
|
", HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo, HPurchaseDeptID, HCloseTypeSub" +
|
", HCloseMan, HEntryCloseDate, HSendQty, HReciveQty, HCloseStatus" +
|
", HRemoveQty, HSeOrderBillNo, HUnReciveQty, HPOOrderBillDate, HPOOrderBillDeliveryDate" +
|
", HPOOrderBillRemark, HPOOrderBillNote)" +
|
$"values({HInterID}, {i}, '', {(HMaterID == null ? "0" : HMaterID)}, '{HMaterName}'" +
|
$", '{HMaterModel}', {HUnitID}, '{HErpClsID}', {HQty}, ''" +
|
$", {HPURCHASEORGIDSub}, '', {HFixleadTime}, '{HDayPlanBillNo}', {HSourceInterID}" +
|
$", {HSourceEntryID}, '{HSourceBillNo}', '{HSourceBillType}', {HWorkShopID}, '{HDayPlanDate}'" +
|
$", {HRelationQty}, {HPOOrderInterID},{HPOOrderEntryID}, '{HPOOrderBillNo}',0" +
|
$",0,0, '',{HPurchaseDeptID}, '0'" +
|
$", '','',0,0, '0'" +
|
$",0, '{HSeOrderBillNo}',0, '{HPOOrderBillDate}', '{HPOOrderBillDeliveryDate}'" +
|
$", '{HPOOrderBillRemark}', '{HPOOrderBillNote}')");
|
}
|
}
|
|
if (tlmmm == PODemandPlanList.Count)
|
{
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "运算成功!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
oCN.RollBack();//事务回滚
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "运算失败!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
LogService.Write("操作失败：" + e.Message.ToString());
|
oCN.RollBack();//事务回滚
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 锁定
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedDay")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHLockedDay(int HLockedDay,int HWorkShopID)
|
{
|
try
|
{
|
oCN.RunProc("update b set HLockedSub=0 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " +
|
$" where a.HWorkShopID={HWorkShopID}");
|
|
oCN.RunProc("update b set HLockedSub=1 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " +
|
$" where HMasterDate between DATEADD(day, -1, getdate()) " +
|
$"and DATEADD(day,{(HLockedDay - 1)},getdate()) and a.HWorkShopID={HWorkShopID}");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 解锁
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHUnlockDay")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHUnlockDay(int HWorkShopID)
|
{
|
try
|
{
|
oCN.RunProc("update b set HLockedSub=0 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " +
|
$" where a.HWorkShopID={HWorkShopID}");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 锁定工单
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedOrder")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHLockedOrder(string HInterIDs)
|
{
|
try
|
{
|
oCN.RunProc($"update Sc_WorkBillSortBillMain set HLockOrder = 1 where HInterID in ({HInterIDs})");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 解锁工单
|
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHUnlockOrder")]
|
[HttpGet]
|
public object JIT_DayPlanPlatFormBillHUnlockOrder(string HInterIDs)
|
{
|
try
|
{
|
oCN.RunProc($"update Sc_WorkBillSortBillMain set HLockOrder = 0 where HInterID in ({HInterIDs})");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 生产订单查询
|
[Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")]
|
[HttpGet]
|
public object JIT_ICMOBillList(string hmainid)
|
{
|
try
|
{
|
var list = hmainid.Split(',');
|
List<DataTable> listdt = new List<DataTable>();
|
DataTable dtable = new DataTable("dt");
|
for (int i = 0; i < list.Length; i++)
|
{
|
var listEvery = list[i].Split('_');
|
|
ds = oCN.RunProcReturn($"exec h_p_ICMOBillList_PrimarySubTable '{listEvery[0]}','{listEvery[1]}'", "h_p_ICMOBillList_PrimarySubTable");
|
|
var dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where 源单主内码 in({ds.Tables[0].Rows[0]["源单主内码"].ToString()}) and 源单子内码 in({ds.Tables[0].Rows[0]["源单子内码"].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList");
|
if (dt.Tables[0].Rows.Count > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "生产明细行重复,重复的生产订单号:" + dt.Tables[0].Rows[i]["生产订单号"].ToString() + ",明细行号:" + dt.Tables[0].Rows[i]["生产订单明细行号"].ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (i == 0)
|
{
|
//添加列名
|
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
|
{
|
dtable.Columns.Add(ds.Tables[0].Columns[j].ToString());
|
}
|
}
|
listdt.Add(ds.Tables[0]);
|
}
|
|
//获取集合数据
|
for (int i = 0; i < listdt.Count; i++)
|
{
|
DataRow row = dtable.NewRow();
|
for (int j = 0; j < listdt[i].Columns.Count; j++)
|
{
|
if (listdt[i].Columns[j].ColumnName == "计划数量")
|
{
|
row[j] = double.Parse(listdt[i].Rows[0][j].ToString()).ToString();
|
}
|
else
|
{
|
row[j] = listdt[i].Rows[0][j].ToString();
|
}
|
}
|
dtable.Rows.Add(row);
|
}
|
|
//添加动态日期
|
for (int j = 1; j <= 31; j++)
|
{
|
dtable.Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = dtable;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 数据准备 设置任务单相关信息
|
[Route("JIT_DayPlanPlatFormBill/ReadyData")]
|
[HttpGet]
|
public object ReadyData(string SWhere)
|
{
|
try
|
{
|
var list = SWhere.Split(',');
|
DataTable dt = new DataTable("date");
|
dt.Columns.Add("HICMOInterID", typeof(string));
|
dt.Columns.Add("HICMOEntryID", typeof(string));
|
dt.Columns.Add("小时产能", typeof(string));
|
dt.Columns.Add("生产周期", typeof(decimal));
|
dt.Columns.Add("开工余量", typeof(decimal));
|
dt.Columns.Add("最迟开工日期", typeof(DateTime));
|
dt.Columns.Add("最迟完工日期", typeof(DateTime));
|
dt.Columns.Add("订单需求数量", typeof(decimal));
|
dt.Columns.Add("订单交货期", typeof(DateTime));
|
|
for (int i = 0; i < list.Length; i++)
|
{
|
string HICMOInterID = list[i].Split(';')[0].ToString();
|
string HICMOEntryID = list[i].Split(';')[1].ToString();
|
string HSourceID = list[i].Split(';')[2].ToString();
|
|
Thread.Sleep(100);
|
ds = oCN.RunProcReturn("exec h_p_Sc_GetInfoByICMOBillNo " + HICMOInterID+","+ HICMOEntryID+","+ HSourceID, "h_p_Sc_GetInfoByICMOBillNo");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
|
}
|
else
|
{
|
DataRow dr = dt.NewRow();
|
dr["小时产能"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["产能"]);
|
dr["生产周期"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["生产周期"]);
|
dr["开工余量"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["开工余量"]);
|
dr["最迟开工日期"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["最迟开工日期"]);
|
dr["最迟完工日期"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["最迟完工日期"]);
|
dr["订单需求数量"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["订单需求数"]);
|
dr["订单交货期"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["订单交货期"]);
|
dr["HICMOInterID"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["HICMOInterID"]);
|
dr["HICMOEntryID"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["HICMOEntryID"]);
|
dt.Rows.Add(dr);
|
}
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = dt;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 缺料分析报表
|
public class MaterialShorAnalysis
|
{
|
public int? HORGID;
|
public DateTime HBEGINDATE;
|
public DateTime HENDDATE;
|
}
|
[Route("JIT_DayPlanPlatFormBill/MaterialShorAnalysisReport")]
|
[HttpGet]
|
public object MaterialShorAnalysisReport(string sWhere)
|
{
|
try
|
{
|
MaterialShorAnalysis Report = JsonConvert.DeserializeObject<MaterialShorAnalysis>(sWhere);
|
|
ds = oCN.RunProcReturn($"exec h_p_JIT_MaterialShorAnalysisReportList {Report.HORGID},'{Report.HBEGINDATE}','{Report.HENDDATE}' ", "h_p_JIT_PODemandPlanBill_ReportList");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 根据物料ID获取工艺路线 列表
|
[Route("JIT_DayPlanPlatFormBill/GetRoutingListByMater")]
|
[HttpGet]
|
public object GetRoutingListByMater(int HMaterID, string user)
|
{
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
|
int IsHavingPermissions = 1;
|
|
//判断是否有工艺路线编辑权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
|
{
|
IsHavingPermissions = 0;
|
}
|
|
ds = oCN.RunProcReturn("select * from h_v_JIT_GetRoutingList_Mater where HMaterID = " + HMaterID , "h_v_JIT_GetRoutingList_Mater");
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "当前物料没有维护工艺路线！请联系计划部进行维护";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.IsHavingPermissions = IsHavingPermissions;
|
return objJsonResult;
|
}
|
else
|
{
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.list = columnNameList;
|
objJsonResult.IsHavingPermissions = IsHavingPermissions;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 根据车间添加未排产生产订单
|
[Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillListByDept")]
|
[HttpGet]
|
public object JIT_ICMOBillListByDept(string HDeptID)
|
{
|
try
|
{
|
//获取显示系统参数
|
string sReturn = "";
|
oSystemParameter.ShowBill(ref sReturn);
|
|
//查询选择车间中未排产过的生产订单信息（添康科技--生产订单状态为下达）
|
ds = oCN.RunProcReturn($"exec h_p_JIT_ICMOBillListByDept '{HDeptID}'", "h_p_JIT_ICMOBillListByDept");
|
|
if (ds.Tables[0].Rows.Count > 0 && ds != null)
|
{
|
if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数 客户定制化名称 空白为通用
|
{
|
//数据表格添加动态日期
|
for (int j = 1; j <= 180; j++)
|
{
|
ds.Tables[0].Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
|
}
|
}
|
else
|
{
|
//数据表格添加动态日期
|
for (int j = 1; j <= 31; j++)
|
{
|
ds.Tables[0].Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
|
}
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查无数据，当前所选车间下暂无未排产且订单状态为下达的生产订单信息！";
|
objJsonResult.data = "";
|
return objJsonResult;
|
}
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 获取完工日期
|
[Route("JIT_DayPlanPlatFormBill/GetICMOCompletionDate")]
|
[HttpGet]
|
public object GetICMOCompletionDate(string HDeptID)
|
{
|
try
|
{
|
//更新日计划工单的完工日期
|
oCN.RunProc($"exec h_p_JIT_GetICMOCompletionDate '{HDeptID}'");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取完工日期成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 生产日计划平台 获取最早开工日期
|
[Route("JIT_DayPlanPlatFormBill/GetICMOEarlyDate")]
|
[HttpGet]
|
public object GetICMOEarlyDate(string HDeptID)
|
{
|
try
|
{
|
//更新生产订单的最早开工日期
|
oCN.RunProc($"exec h_p_JIT_GetICMOEarlyDate '{HDeptID}'");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取最早开工日期成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 通过物料匹配产品器具清单
|
[Route("JIT_DayPlanPlatFormBill/GetMouldByMater")]
|
[HttpGet]
|
public object GetMouldByMater(string HMaterID,string HSourceID)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("exec h_p_Gy_MaterialMouldByMater " + HMaterID + "," + HSourceID, "h_p_Gy_MaterialMouldByMater");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 通过资源匹配资源器具清单
|
[Route("JIT_DayPlanPlatFormBill/GetMouldBySource")]
|
[HttpGet]
|
public object GetMouldBySource(string HSourceID, string HMouldID)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_SourceMouldBillMainList where HSourceID = " + HSourceID + " and HMouldID = " + HMouldID, "h_v_Gy_SourceMouldBillMainList");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 排产后将器具占用时间写入数据库
|
[Route("JIT_DayPlanPlatFormBill/AddMouldOccupancyTime")]
|
[HttpGet]
|
public object AddMouldOccupancyTime(string HMouldID, string HSourceID, string HICMOInterID, string HICMOEntryID, string HMouldPCTime)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("exec h_p_JIT_AddMouldOccupancyTime " + HMouldID + "," + HSourceID + "," + HICMOInterID + "," + HICMOEntryID + ",'" + HMouldPCTime + "'", "h_p_JIT_AddMouldOccupancyTime");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
}
|
}
|
