From 7d67c0f7bb4c6221ee4f2fd2ee0f092de337cd85 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 26 三月 2026 15:02:59 +0800
Subject: [PATCH] 多语言翻译

---
 WebAPI/Controllers/WebAPIController.cs |  187 ++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 187 insertions(+), 0 deletions(-)

diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 9eb400c..69a9332 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -28,6 +28,7 @@
         public string sWhere = "";
         public WebServer webserver = new WebServer();
         public DataSet ds = new DataSet();
+        ClsCN oCN = new ClsCN();
 
         public static string GetSession(string sMsg)
         {
@@ -1233,5 +1234,191 @@
             oCn = null;
         }
 
+        #region 澶氳瑷�缈昏瘧 
+
+        #region 鑾峰彇鍩烘湰淇℃伅
+        [Route("Web/BaseInfo")]
+        [HttpGet]
+        public object GetBaseInfo()
+        {
+            try
+            {               
+                ds = oCN.RunProcReturn("select HItemID,HNumber,HCusName,HLogoLabel,HMenuLabel,HUserQty,ISNULL(HLogoTranslationText_English,HLogoLabel) HLogoTranslationText_English,ISNULL(HLogoTranslationText_Spain,HLogoLabel) HLogoTranslationText_Spain , ISNULL(HMenuTranslationText_English, HLogoLabel) HMenuTranslationText_English, ISNULL(HMenuTranslationText_Spain, HLogoLabel) HMenuTranslationText_Spain from xt_BaseInfo", "xt_BaseInfo");
+                if (ds is null)
+                {
+                    objjson.code = "0";
+                    objjson.count = 0;
+                    objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo;
+                    objjson.data = null;
+                    return objjson;
+                }
+                else
+                {
+                    objjson.code = "0";
+                    objjson.count = 1;
+                    objjson.Message = "鑾峰彇鎴愬姛!";
+                    objjson.data = ds.Tables[0];
+                    return objjson;
+                }
+            }
+            catch (Exception e)
+            {
+                objjson.code = "0";
+                objjson.count = 0;
+                objjson.Message = "鑾峰彇澶辫触" + e.Message;
+                objjson.data = null;
+                return objjson;
+            }
+        }
+        #endregion
+
+        #region 鍗曟嵁缈昏瘧 鍒濆鍖� 鏌ヨ
+        [Route("Xt_grdAlignment_WMES/SelectMESLanguage")]
+        [HttpGet]
+        public object SelectMESLanguage(string sWhere)
+        {
+            try
+            {
+                //鑾峰彇鍏叡鏁版嵁鐨勬暟閲�
+                int count = 0;
+                DataSet dataSet = oCN.RunProcReturn("select * from  h_v_Xt_LanModuleList where 1=1 and HModuleCode in('GYModel')", "h_v_Xt_LanModuleList");
+                if (dataSet.Tables[0].Rows.Count > 0)
+                {
+                    count = dataSet.Tables[0].Rows.Count;
+                }
+
+                //鏍规嵁鍗曟嵁妯″潡鍚嶇О 鍜� 缈昏瘧绫诲瀷 鍘� 妯″潡琛ㄩ噷鏌ヨ 濡傛灉娌℃湁鏁版嵁 灏辨柊澧�,濡傛灉鏈夋暟鎹氨涓嶄繚瀛�
+
+                ds = oCN.RunProcReturn("select * from  h_v_Xt_LanModuleList where 1=1 " + sWhere, "h_v_Xt_LanModuleList");
+
+                objJsonResult.code = "1";
+                objJsonResult.count = count;
+                objJsonResult.Message = "";
+                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("Xt_grdAlignment_WMES/SaveMESLanguage")]
+        [HttpPost]
+        public object SaveMESLanguage([FromBody] JObject sMainSub)
+        {
+            try
+            {
+                var _value = sMainSub["sMainSub"].ToString();
+                string msg1 = _value.ToString();
+                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+                string msg2 = sArray[0];
+                string HModName = sArray[1];
+                //濡傛灉娌℃湁鏁版嵁 灏辨柊澧�,濡傛灉鏈夋暟鎹氨涓嶄繚瀛�
+                //閫氳繃,杩涜鍒嗙粍
+                string[] data = msg2.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
+
+                oCN.BeginTran();
+
+                string HBillType = "3033";
+                long HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
+                //瀹氫箟涓�涓┖闆嗗悎 鍘� 鍒ゆ柇鏄惁鏈夐噸澶嶇殑id
+                string[] list = new string[data.Length];
+
+                //鍒ゆ柇鏄惁璺熷叕鍏卞瓧娈甸噸澶�
+                ds = oCN.RunProcReturn(" select * from  h_v_Xt_LanModuleList where  HModuleCode='GYModel'", "h_v_Xt_LanModuleList");
+                string[] Datalist = new string[ds.Tables[0].Rows.Count];
+
+                if (ds.Tables[0].Rows.Count > 0)
+                {
+                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
+                    {
+                        Datalist[i] = ds.Tables[0].Rows[i]["HFieldCode"].ToString() + ds.Tables[0].Rows[i]["HFieldName"].ToString();
+                    }
+                }
+
+                //瀹氫箟涓�涓� num 鍘诲畾涔� 褰撳墠鐨勭储寮�
+                int num = 0;
+
+                for (int i = 0; i < data.Length; i++)
+                {
+                    string[] Lable = data[i].Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
+
+                    if (Lable.Length == 3)
+                    {
+
+                        string HFieldCode = Lable[0];
+                        string HFieldName = Lable[1];
+                        string HFieldModelType = Lable[2];
+
+                        if (!list.Contains(HFieldCode + HFieldName) && !Datalist.Contains(HFieldCode + HFieldName))
+                        {
+
+                            list[num] = HFieldCode + HFieldName;
+                            num += 1;
+
+                            oCN.RunProc("insert into Xt_LanModuleSub(HInterID,HEntryID,HFieldModelType,HFieldCode,HFieldName)" +
+                              "values(" + HInterID + "," + num + ",'" + HFieldModelType + "','" + HFieldCode + "','" + HFieldName + "')");
+                        }
+                    }
+                }
+
+                oCN.RunProc("insert into Xt_LanModuleMain(HInterID,HBillType,HModuleName,HModuleCode)" +
+                 "values(" + HInterID + ",'" + HBillType + "','','" + HModName + "')");
+
+                oCN.Commit();
+
+                objJsonResult.code = "1";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "Sucess锛�";
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+            catch (Exception e)
+            {
+                oCN.RollBack();
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "Exception锛�" + e.ToString();
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+        #endregion
+
+        #region 鎶ラ敊淇℃伅 鏌ヨ
+        [Route("Xt_grdAlignment_WMES/SelectMessageError")]
+        [HttpGet]
+        public object SelectMessageError(string ErrorCode)
+        {
+            try
+            {
+                ds = oCN.RunProcReturn("select * from  Xt_MessageError where HErrorCode='" + ErrorCode + "'", "Xt_MessageError");
+
+                objJsonResult.code = "1";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "";
+                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
+
+        #endregion
+
     }
 }

--
Gitblit v1.9.1