智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2024-05-22 6b58db539723a88c5d50ba90096389fa913136fd 
 WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs


@@ -1,4 +1,5 @@


using DBUtility;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using System;


using System.Collections.Generic;


@@ -27,36 +28,56 @@


        /// </summary>


        [Route("Gy_OrderBackInfo/list")]


        [HttpGet]


        public object list(string sWhere)


        public object list(string sWhere,string user)


        {


            try


            {


                List<object> columnNameList = new List<object>();


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Gy_OrderBackInfoList", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查看权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere, "h_v_Gy_OrderBackInfoList");


                    ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere+ " order by 反馈状态代码", "h_v_Gy_OrderBackInfoList");


                }


                else


                {


                    string sql1 = "select * from h_v_Gy_OrderBackInfoList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    string sql = sql1 + sWhere+ " order by 反馈状态代码";


                    ds = oCN.RunProcReturn(sql, "h_v_Gy_OrderBackInfoList");


                }


                if (ds == null || ds.Tables[0].Rows.Count == 0)




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "false！";


                    objJsonResult.data = null;


                    return objJsonResult;


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }




                //if (ds.Tables[0].Rows.Count != 0 || ds != null)


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


                //objJsonResult.Message = "无数据";


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


            }


            catch (Exception e)


            {


@@ -120,11 +141,20 @@


        /// </summary>


        [Route("Gy_OrderBackInfo/Delete_Json")]


        [HttpGet]


        public object Delete_Json(long HItemID, string User, string ModRightNameDelete)


        public object Delete_Json(long HItemID, string User)


        {


 


            try


            {


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Gy_OrderBackInfo_Delete", 1, false, User))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                ds = oCN.RunProcReturn("delete from Gy_OrderBackInfo where HItemID =  " + HItemID, "Gy_OrderBackInfo");


 


                objJsonResult.code = "1";


@@ -158,12 +188,18 @@


            {


                var _value = oMain["oMain"].ToString();


                string msg1 = _value.ToString();


                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


                string msg2 = sArray[0].ToString();


                string msg3 = sArray[1].ToString();


                string msg4 = sArray[2].ToString();


                string msg5 = sArray[3].ToString();




                


                //反序列化


                msg1 = "[" + msg1.ToString() + "]";


                msg2 = "[" + msg2.ToString() + "]";


                List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg2);


 


                List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg1);


 


                long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;


                long HItemID = int.Parse(msg3);


                string HNumber = list[0].HNumber;


                string HName = list[0].HName;


                string HShortNumber = list[0].HNumber;


@@ -172,7 +208,17 @@


                string HRemark = list[0].HRemark;


                bool HStopflag = list[0].HStopflag;


                bool HUseFlag = list[0].HUseFlag;


 




                //判断权限


                if (!ClsPub.Security_Log(msg5, 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (!DBUtility.ClsPub.AllowNumber(HNumber))


                {


                    objJsonResult.code = "0";


@@ -252,11 +298,11 @@


 


 


                //判断权限


                if (!ClsPub.Security_Log(msg5, 1, true, msg4))


                if (!ClsPub.Security_Log(msg5, 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有找到该功能模块！";


                    objJsonResult.Message = "无保存权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }