From 5049d1b4b5d74092f69aa3b3e4aa2fcfa8de808b Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 16 四月 2024 17:17:05 +0800
Subject: [PATCH] 1.组织架构模块,增加 用户编码 字段; (非必录) 2.网页版:供应商 增加 字段 材料类别 下拉框(主材,辅材) HMaterClass varchar(20) 网页版: 付款单 表头 增加 字段 发票编号 ,大写金额 (大写金额 在输入 金额后 自动 带出,可以网上找下 小写金额 转 大写 的 代码 ),付款事由; 网页版: 直接调拨单 增加 字段 项目编号 HProjectID (界面显示 项目编码,项目名称), 以及 可选择 工程项目 为 基础资料,表头 增加 字段 发票编号; 选择 表头 调入 调出 仓库后, 表体调入 调出 仓库为空的 也自动填充。

---
 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