From d4f7212718f775586ffba74960d78dca5ee4aad2 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 19 九月 2024 09:03:37 +0800
Subject: [PATCH] 1.工艺参数点检:增加附件上传功能 2.设备工艺参数趋势图:根据流转卡的子表进站出站时间查询工艺参数(增加一个选择框 采集来源:(设备采集,手动输入)) 3.开工:增加设备启动点检,防错验证控制 .设备/模具:保养规程 表头增加 HErrWarDays int --预警天数 2.设备/模具:保养计划单增加HErrBeginTime datetime --预警开始时间点,审核时把子表 预警开始时间点, 填入 3.设备启动点检清单/启动点检清单:增加字段HDotCheckType varchar(50) --点检类型(设备,模具,作业指导书,检验指导书) HRelationID int --关联ID(设备内码或模具内码)
---
DAL/车间管理/ClsSc_WorkBeginDotCheckBillMain.cs | 34 +++++++++++++++++++---------------
1 files changed, 19 insertions(+), 15 deletions(-)
diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
index 06f8557..f0926b9 100644
--- "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
+++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
@@ -71,20 +71,22 @@
foreach (Model.ClsSc_WorkBeginDotCheckBillSub oSub in DetailColl)
{
string subSql = "insert into Sc_WorkBeginDotCheckBillSub " +
- "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
- ",HCheckNoteItemID,HCheckPostID,HCheckResult) " +
- " values(" +
- "" + omodel.HInterID.ToString() +
- "," + oSub.HEntryID.ToString() +
- "," + oSub.HSourceInterID +
- "," + oSub.HSourceEntryID +
- ",'" + oSub.HSourceBillNo +
- "','" + oSub.HSourceBillType +
- "','" + oSub.HRemark +
- "','" + oSub.HCheckNoteItemID +
- "','" + oSub.HCheckPostID +
- "','" + oSub.HCheckResult +
- "')";
+ "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
+ ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " +
+ " values(" +
+ "" + omodel.HInterID.ToString() +
+ "," + oSub.HEntryID.ToString() +
+ "," + oSub.HSourceInterID +
+ "," + oSub.HSourceEntryID +
+ ",'" + oSub.HSourceBillNo +
+ "','" + oSub.HSourceBillType +
+ "','" + oSub.HRemark +
+ "','" + oSub.HCheckNoteItemID +
+ "','" + oSub.HCheckPostID +
+ "','" + oSub.HCheckResult +
+ "','" + oSub.HDotCheckType +
+ "','" + oSub.HRelationID +
+ "')";
oCn.RunProc(subSql);
}
@@ -161,7 +163,7 @@
{
string subSql = "insert into Sc_WorkBeginDotCheckBillSub " +
"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
- ",HCheckNoteItemID,HCheckPostID,HCheckResult) " +
+ ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " +
" values(" +
"" + omodel.HInterID.ToString() +
"," + oSub.HEntryID.ToString() +
@@ -173,6 +175,8 @@
"','" + oSub.HCheckNoteItemID +
"','" + oSub.HCheckPostID +
"','" + oSub.HCheckResult +
+ "','" + oSub.HDotCheckType +
+ "','" + oSub.HRelationID +
"')";
oCn.RunProc(subSql);
}
--
Gitblit v1.9.1