From 2c647b75d3550f87c0fe0fbe72527af779c238fb Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 19 九月 2024 13:59:48 +0800 Subject: [PATCH] 钉钉同步设备维修记录 模具维修记录 保养记录 --- WebAPI/Controllers/数据同步/钉钉同步/DD_DataSynchronizationController.cs | 8 ++++++-- 1 files changed, 6 insertions(+), 2 deletions(-) diff --git "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs" "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs" index 44f4ba3..9d3c298 100644 --- "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs" +++ "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs" @@ -2295,6 +2295,7 @@ ",'','0','" + oItem.HMouldID + "','" + oItem.HRepairBeginDate + "'" + ",'" + oItem.HRepairEndDate + "'" + ",'" + oItem.HInstanceID + "','',0,0,'OK')"; + LogService.Write(sql_main); oCN.RunProc(sql_main); int i = 1; foreach (Sc_MouldMaintainBillSub oItem_Detail in oItem.DetailColMouldMaintain) @@ -2310,6 +2311,7 @@ ",'" + oItem.HEmpID + "'" + ",'','','" + oItem_Detail.HMaintainResult + "'" + ",'0','0','','',0,0,'')"; + LogService.Write(sql_sub); oCN.RunProc(sql_sub); i += 1; } @@ -2344,7 +2346,7 @@ ",'灏忔椂','" + oItem.HPlanTimes + "','" + oItem.HTimes + "','" + oItem.HEmpID + "',0" + ",'" + oItem.HDeptID + "','','" + oItem.HInstanceID + "','" + oItem.HMouldID + "'" + ",'0','鍐呴儴缁翠慨','','" + oItem.HNewDesignLife + "','',0,0)"; - + LogService.Write(sql_main); oCN.RunProc(sql_main); int i = 1; foreach (Sc_MouldRepairWorkBillSub oItem_Detail in oItem.DetailColMouldRepair) @@ -2356,6 +2358,7 @@ "('" + HInterID + "'," + i + ",'','','','" + oItem_Detail.HRemark + "'" + ",0,0,'','',0,0" + ",0,'" + oItem_Detail.HRepairExplanation + "','" + oItem.HEmpID + "',0)"; + LogService.Write(sql_sub); oCN.RunProc(sql_sub); i += 1; } @@ -2627,7 +2630,7 @@ ",'" + oItem.HEquipID + "','0','" + oItem.HTimes + "','" + oItem.HEmpID + "','" + oItem.HEmpID + "','" + oItem.HTimes + "'" + ",'" + oItem.HDeptID + "','" + oItem.HExplanation + "','" + oItem.HInstanceID + "','',''" + ",'" + oItem.HRepairContent + "','灏忔椂','','0',0)"; - + LogService.Write(sql_main); oCN.RunProc(sql_main); int i = 1; foreach (Sc_MouldRepairWorkBillSub oItem_Detail in oItem.DetailColMouldRepair) @@ -2639,6 +2642,7 @@ "values('" + HInterID + "'," + i + ",'','','','" + oItem_Detail.HRemark + "'" + ",0,0,'','',0,0" + ",0,'" + oItem.HEmpID + "','" + oItem_Detail.HRepairExplanation + "','" + oItem.HEmpID + "')"; + LogService.Write(sql_sub); oCN.RunProc(sql_sub); i += 1; } -- Gitblit v1.9.1