Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

zzr99

2021-10-18 8552aecdfdf50a4eba5bb5df30bc32c8f5882763

Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

 LMES/obj/x86/Release/LMES.csprojAssemblyReference.cache

Binary files differ

 LMES/obj/x86/Release/build.force

 Model/obj/x86/Release/Model.csprojAssemblyReference.cache

Binary files differ

 Model/obj/x86/Release/build.force

 WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs

@@ -162,6 +162,8 @@
                }
                //配件表体数据
                //按 },{来拆分数组 //去掉【和】
                if (msg4 != "undefined" && msg4 != "" && msg4 != "[]")
                {
                msg4 = msg4.Substring(1, msg4.Length - 2);
                msg4 = msg4.Replace("\\", "");
                msg4 = msg4.Replace("\n", "");  //\n
@@ -193,6 +195,7 @@
                    oBill.DetailColl.Add(oItemSub);

                }
                }
                //保存
                //保存完毕后处理
                bool bResult;

 WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs

@@ -157,6 +157,8 @@
                }
                //配件项表体数据
                //按 },{来拆分数组 //去掉【和】
                if (msg4 != "undefined" && msg4 != "" && msg4 != "[]")
                {
                msg4 = msg4.Substring(1, msg4.Length - 2);
                msg4 = msg4.Replace("\\", "");
                msg4 = msg4.Replace("\n", "");  //\n
@@ -188,6 +190,7 @@
                    oBill.DetailColl.Add(oItemSub);

                }
                }
                //保存
                //保存完毕后处理
                bool bResult;

 WebAPI/Controllers/WebAPIController.cs

@@ -1,6 +1,8 @@
using DAL;
using DBUtility;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Linq;
using SQLHelper;
using System;
@@ -2195,6 +2197,55 @@
            }
        }


        #region [查询菜单列表]
        [Route("Web/MenuList")]
        [HttpGet]
        public object MenuList()
        {
            try
            {
                List<Menu> mu = new List<Menu>();
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                ds = oCn.RunProcReturn("Select * from Gy_Menu Order by HItemID ", "Gy_Menu");
                //List<Menu> mu1 = ds.Tables[0].AsEnumerable().Select(t => new Menu()).ToList();
                //List<Menu> users = ModelConvertHelper<Menu>.ConvertToModel(ds.Tables[0]);
                //var dd = ToHierarchy.ToHierarchyList(users);
                //string json = JsonConvert.SerializeObject(dd);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)   //这里是循环所有
                {
                    if (ds.Tables[0].Rows[i]["HPartentID"].ToString()=="0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString())  //判断是否最外层根节点
                    {
                        Menu tbj = new Menu();
                        tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString();
                        tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString();
                        tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString();
                        tbj.HPartentID =ds.Tables[0].Rows[i]["HPartentID"].ToString();
                        tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString());
                        tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString();
                        mu.Add(tbj);
                    }
                }
                ToHierarchy.digui(ds.Tables[0], mu);
                

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data =Newtonsoft.Json.JsonConvert.SerializeObject(mu);
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }
        #endregion

    }

}

 WebAPI/Models/Menu.cs

New file
@@ -0,0 +1,20 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace WebAPI.Models
{
    public class Menu
    {
        //public int HitemID { get; set; }
        public string HitemID { get; set; }
        //public int? HPartentID { get; set; }
        public string HPartentID { get; set; }
        public string HNumber { get; set; }
        public string HName { get; set; }
        public int HLevel { get; set; }
        public string Hurl { get; set; }
        public List<Menu> childMenus { get; set; }
    }
}

 WebAPI/Models/ModelConvertHelper.cs

New file
@@ -0,0 +1,45 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Web;

namespace WebAPI.Models
{
    public class ModelConvertHelper<T> where T : new()
    {
        public static List<T> ConvertToModel(DataTable dt)
        {
            // å®šä¹‰é›†åˆ    
            List<T> ts = new List<T>();

            // èŽ·å¾—此模型的类型   
            Type type = typeof(T);
            string tempName = "";

            foreach (DataRow dr in dt.Rows)
            {
                T t = new T();
                // èŽ·å¾—此模型的公共属性      
                PropertyInfo[] propertys = t.GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    tempName = pi.Name;  // æ£€æŸ¥DataTable是否包含此列    

                    if (dt.Columns.Contains(tempName))
                    {
                        // åˆ¤æ–­æ­¤å±žæ€§æ˜¯å¦æœ‰Setter      
                        if (!pi.CanWrite) continue;

                        object value = dr[tempName];
                        if (value != DBNull.Value)
                            pi.SetValue(t, value, null);
                    }
                }
                ts.Add(t);
            }
            return ts;
        }
    }    
}

 WebAPI/Models/ToHierarchy.cs

New file
@@ -0,0 +1,50 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace WebAPI.Models
{
    public class ToHierarchy
    {
        public static List<Menu> ToHierarchyList(List<Menu> limits, string HPartentID/*int? HPartentID = 0*/)
        {
            List<Menu> newLimitList = new List<Menu>();
            newLimitList = limits.Where(t => t.HPartentID == HPartentID).ToList();
            for (int i = 0; i < newLimitList.Count; i++)
            {
                newLimitList[i].childMenus = ToHierarchyList(limits, newLimitList[i].HPartentID);//下一层级
            }
            return newLimitList;
        }


        public static void digui(DataTable dt, List<Menu> tree)
        {
            for (int m = 0; m < tree.Count; m++)
            {
                tree[m].childMenus = new List<Menu>();
                for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集
                {
                    if (tree[m].HitemID.ToString() == dt.Rows[i]["HPartentID"].ToString() && dt.Rows[i]["HitemID"].ToString() != dt.Rows[i]["HPartentID"].ToString())
                    {
                        Menu tbjson = new Menu();
                        tbjson.HitemID = dt.Rows[i]["HitemID"].ToString();
                        tbjson.HPartentID = dt.Rows[i]["HPartentID"].ToString();
                        tbjson.HNumber = dt.Rows[i]["HNumber"].ToString();
                        tbjson.HName = dt.Rows[i]["HName"].ToString();
                        tbjson.HLevel = tree[m].HLevel;
                        tbjson.Hurl = dt.Rows[i]["Hurl"].ToString();
                        tree[m].childMenus.Add(tbjson);
                    }
                }
                for (int i = 0; i < tree[m].childMenus.Count; i++)
                {
                    digui(dt, tree[m].childMenus);//再次用子集去循环，拿出子集的子集
                }
            }

        }
    }
}

 WebAPI/WebAPI.csproj

@@ -437,12 +437,15 @@
    <Compile Include="Models\ClsSc_MouldRepairOutBillMain.cs" />
    <Compile Include="Models\ClsSc_MouldRepairOutBillSub.cs" />
    <Compile Include="Models\ClsGy_ProcPrice.cs" />
    <Compile Include="Models\Menu.cs" />
    <Compile Include="Models\ModelConvertHelper.cs" />
    <Compile Include="Models\Pay_OtherBalBill.cs" />
    <Compile Include="Models\Pay_WorkTimesBillSub.cs" />
    <Compile Include="Models\Pay_WorkTimesBill.cs" />
    <Compile Include="Models\Pay_SingleBalBill.cs" />
    <Compile Include="Models\Pay_OtherBalBillSub.cs" />
    <Compile Include="Models\Pay_SingleBalBillSub.cs" />
    <Compile Include="Models\ToHierarchy.cs" />
    <Compile Include="Models\Xt_ORGANIZATIONS.cs" />
    <Compile Include="Models\ClsSb_EquipRepairWorkBillSub.cs" />
    <Compile Include="Models\ClsSc_ICMOBillWorkQtyStatus_Tmp.cs" />

 WorkM/Á÷ת¿¨¹ÜÀí/Sc_ProcessExchangeBillQuery.cs

@@ -1168,6 +1168,10 @@

        private void cf_Click(object sender, EventArgs e)
        {
            //智见特别控制
            MessageBox.Show("单据拆分功能已控制，请与管理员联系", "提示");
            return;
            //
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;