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

    }
}