From f0b6386d27d625ee2b7080878ece230998deac98 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 29 十二月 2025 09:21:08 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs | 148 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 148 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
index 5f07608..6914c54 100644
--- a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
+++ b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
@@ -4,7 +4,9 @@
using System;
using System.Collections.Generic;
using System.Data;
+using System.IO;
using System.Linq;
+using System.Text;
using System.Web;
using System.Web.Http;
using WebAPI.Models;
@@ -894,5 +896,151 @@
}
}
#endregion
+
+ #region 鍗曟嵁缈昏瘧 鏄犲皠 JSON鏂囦欢
+ internal Dictionary<string, string> LanguageDictionary = new Dictionary<string, string>
+ {
+ { "zh-Hans", "HFieldName"},
+ { "zh-Hant", "HFieldName"},
+ { "en", "HTranslationText_English"},
+ { "es", "HTranslationText_Spain"}
+ };
+
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="language">璇█</param>
+ /// <param name="forceUpdate">鏄惁寮哄埗鏇存柊</param>
+ /// <returns></returns>
+ [Route("Xt_grdAlignment_WMES/SelectMESLanguage_JSON")]
+ [HttpGet]
+ public object SelectMESLanguage_JSON(string language, bool forceUpdate)
+ {
+ try
+ {
+ // 鑾峰彇椤圭洰鏍圭洰褰�
+ string path = HttpContext.Current.Server.MapPath($"~/LanguagePack"); ;
+ string lang;
+ bool langSuccess = LanguageDictionary.TryGetValue(language, out lang);
+ if(langSuccess == false)
+ {
+ // 璁剧疆榛樿璇█涓轰腑鏂�
+ language = "zh-Hans";
+ lang = "HFieldName";
+ }
+ ds = oCN.RunProcReturn("select * from h_v_Xt_LanModuleList where 1=1", "h_v_Xt_LanModuleList");
+
+ // 濡傛灉鐩綍涓嶅瓨鍦ㄥ垯鍒涘缓鐩綍
+ if (!Directory.Exists(path))
+ {
+ Directory.CreateDirectory(path);
+ }
+ // 濡傛灉璇█鍖呬笉瀛樺湪鍒欏垱寤烘柊璇█鍖�
+ if(File.Exists($@"{path}\{language}.json") == false)
+ {
+ File.WriteAllText($@"{path}\{language}.json", "{}");
+ }
+
+
+ LogService.Write("璇█鍖呭湴鍧�: " + Path.Combine(path, $"{language}.json"));
+ string JsonStr1 = "";
+
+ using (StreamReader sr = new StreamReader(Path.Combine(path, $"{language}.json"), Encoding.UTF8))
+ {
+ string lines;
+ while ((lines = sr.ReadLine()) != null)//涓�琛屼竴琛屽幓璇伙紝濡傛灉璇诲彇杩欎竴琛岃祴鍊糽ines,骞朵笖lines= null璇佹槑璇诲彇瀹屼簡
+
+ {
+ JsonStr1 += lines;
+ }
+ }
+ JObject languagePack = JObject.Parse(JsonStr1);
+
+ // 鍒ゆ柇鐗堟湰鍙� 鐜板湪MSSQL瀵瑰簲琛ㄤ腑 鏃犵増鏈彿瀛楁 浣跨敤鏁版嵁鏉＄洰鏁版浛浠�
+ if(languagePack["_Version"] == null)
+ {
+ languagePack["_Version"] = 0;
+ }
+ LogService.Write("璇█鍖呬腑鏁版嵁鏉℃暟: " + languagePack["_Version"].ToString() + "\n鏁版嵁搴撲腑鏁版嵁鏉℃暟: " + ds.Tables[0].Rows.Count.ToString());
+ if (languagePack["_Version"].Value<int>() != ds.Tables[0].Rows.Count || forceUpdate == true)
+ {
+ // 鏇存柊鐗堟湰鍙�(鏁版嵁鏉＄洰鏁�)
+ languagePack["_Version"] = ds.Tables[0].Rows.Count;
+ // 缁熻姣忎釜瀛楃妯″潡涓� 瀛楁鐮佸嚭鐜扮殑娆℃暟 濡傛灉鍑虹幇澶氭锛屽垯鏄犲皠涓篔Array绫诲瀷
+ Dictionary<string, int> HFieldCodeDict = ds.Tables[0].AsEnumerable()
+ .GroupBy(row => new
+ {
+ HModuleCode = row.Field<string>("HModuleCode"),
+ HFieldCode = row.Field<string>("HFieldCode")
+ })
+ .Select(group => new {
+ HModuleCode = group.Key.HModuleCode,
+ HFieldCode = group.Key.HFieldCode,
+ rowNum = group.Count()
+ }).ToDictionary(
+ keySelector: p => $@"{p.HModuleCode}_{p.HFieldCode}",
+ elementSelector: p => p.rowNum
+ );
+
+ // 鐗堟湰鍙蜂笉涓�鑷� 鍒欒鍙栨暟鎹簱涓殑瀛楁锛屽皢瀛楁鍐欏叆鍒癹son瀵硅薄涓�
+ foreach (DataRow row in ds.Tables[0].Rows)
+ {
+ // 鑾峰彇鎵�鍦ㄦā鍧楀瓧绗︿覆
+ string HModuleCode = row["HModuleCode"].ToString();
+ // 娌℃湁妯″潡瀵硅薄鐨勮瘽锛屽垯鏂板缓涓�涓ā鍧楀璞�
+ if(languagePack[HModuleCode] == null)
+ {
+ languagePack[HModuleCode] = new JObject();
+ }
+
+ string HFieldCode = row["HFieldCode"].ToString();
+ int rowNum = 1;
+ HFieldCodeDict.TryGetValue($@"{row["HModuleCode"]}_{row["HFieldCode"]}", out rowNum);
+ // 鍒ゆ柇瀛楁鐮佹槧灏勪腑锛屾ā鍧楀搴旂殑瀛楁鐮� 鏄惁 鍞竴
+ if (rowNum == 1)
+ {
+ languagePack[HModuleCode][HFieldCode] = row[lang].ToString();
+ }else
+ {
+ if(languagePack[HModuleCode][HFieldCode] == null)
+ {
+ languagePack[HModuleCode][HFieldCode] = new JArray();
+ }
+
+ var targetJArray = (JArray)languagePack[HModuleCode][HFieldCode];
+ targetJArray.Add(row[lang].ToString());
+ }
+
+ }
+
+ // 鍏ㄩ噺鍐欏叆鍒癹son鏂囦欢涓�
+ File.WriteAllText($"{path}/{language}.json", languagePack.ToString(), System.Text.Encoding.UTF8);
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Success锛�";
+ objJsonResult.data = languagePack.ToString();
+ return objJsonResult;
+ } else
+ {
+ // 鐗堟湰鍙蜂竴鑷达紝 鍒欑洿鎺ヨ繑鍥炶鍙栫殑Json瀛楃涓�
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Success锛�";
+ objJsonResult.data = JsonStr1;
+ return objJsonResult;
+ }
+ }
+ catch(Exception e)
+ {
+ LogService.Write("Exception锛�" + e.ToString());
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.Message.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1