From a9f282b625e6cebb93c02946eb9a1d5bd699544b Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期日, 28 四月 2024 16:44:28 +0800 Subject: [PATCH] 新增采购退料模块、生产退料模块扫描源单调用方法,上传生成单据调用方法 --- WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs index 47060bc..69c2f00 100644 --- a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs +++ b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs @@ -134,12 +134,15 @@ HGridString = HGridString.Substring(0, HGridString.Length - 1); oCN.RunProc("Delete from Xt_grdAlignment_WMES where HUserName='" + user + "' and HModName='" + HModName + "' "); - oCN.RunProc("insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" + + + string sql = "insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" + ",HFontSize,HHeadTextHeight,HTextHeight,HSortFlag,HSelTotal,HColumnWidth,HPageSize" + ") values('" + user + "','" + HModName + "','" + HGridString + "'," + (omdelMian.HFixCols == "" ? "0" : omdelMian.HFixCols) + "," + (omdelMian.HFontSize == "" ? "0" : omdelMian.HFontSize) + ",0" + ",0,'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" + - "," + (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + "," + (omdelMian.HPageSize == "" ? "0" : omdelMian.HPageSize) + ")"); + "," + (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + "," + ((omdelMian.HPageSize == null || omdelMian.HPageSize == "") ? "0" : omdelMian.HPageSize) + ")"; + + oCN.RunProc(sql); objJsonResult.code = "1"; -- Gitblit v1.9.1