智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ch
2022-06-28 93b9f26c4581fa9d39f064a453fc21a67d582152 
 WebAPI/Controllers/WebAPIController.cs


@@ -177,7 +177,7 @@




                objjson.code = "0";


                objjson.count = 0;


                objjson.Message = "登录异常！"+e.Message;


                objjson.Message = "登录异常！" + e.Message;


                objjson.data = null;


                return objjson; ;


            }


@@ -258,7 +258,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "删除失败！"; 


                    objJsonResult.Message = "删除失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -778,7 +778,7 @@


        /// <returns></returns>


        [Route("Web/GetStockPlaceList_Json_NEW")]


        [HttpGet]


        public object GetStockPlaceList_Json_NEW(string StockPlace, Int64 HWhID,Int64 HOrgID)


        public object GetStockPlaceList_Json_NEW(string StockPlace, Int64 HWhID, Int64 HOrgID)


        {


            WebS.WebService1 oWeb = new WebS.WebService1();


            sWhere = " Where HStopFlag=0  and HEndFlag=1 and HUSEORGID = " + HOrgID + "";


@@ -1004,7 +1004,7 @@


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn("Select HItemID,HNumber 班组代码,HName 班组 from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");


                ds = oCN.RunProcReturn("Select HItemID,班组代码 班组代码,班组名称 班组 from h_v_GroupList where 1=1 " + sWhere + " Order by HItemID ", "h_v_GroupList");


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


                {


                    objjson.code = "0";


@@ -1686,7 +1686,7 @@


        /// <returns></returns>


        [Route("DeltetGy_BadReason")]


        [HttpGet]


        public object DeltetGy_BadReason(string HItemID,string user)


        public object DeltetGy_BadReason(string HItemID, string user)


        {


            DataSet ds;


            //string ModRightNameCheck = "Sc_ProcessReport_check";


@@ -2148,7 +2148,7 @@




        [Route("Web/GetClassTimePrjGroupBillList_Json")]


        [HttpGet]


        public object GetClassTimePrjGroupBillList_Json(string sWhere,string user)


        public object GetClassTimePrjGroupBillList_Json(string sWhere, string user)


        {


            if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user))


            {


@@ -2202,6 +2202,58 @@


                return objjson;


            }


        }


        /// <summary>


        /// 核算方式组编辑


        /// </summary>


        /// <param name="sWhere"></param>


        /// <param name="user"></param>


        /// <returns></returns>


        [Route("Web/GetClassTimePrjGroupBillEdit_Json")]


        [HttpGet]


        public object GetClassTimePrjGroupBillEdit_Json(string sWhere)


        {


            //if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


            //    objJsonResult.Message = "没有查看权限";


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                string sql = "select a.HNumber,a.HName,a.HDeptID,b.HName as 仓库名称 from  Gy_ClassTimePrjGroup a left join Gy_Department b on a.HDeptID = b.HItemID where a.hitemid = " + sWhere;


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


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


                {


                    objjson.code = "0";


                    objjson.count = 0;


                    objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;


                    objjson.data = null;


                    return objjson;


                }


                else


                {


                    objjson.code = "1";


                    objjson.count = 1;


                    objjson.Message = "获取成功!";


                    objjson.data = ds.Tables[0];


                    return objjson;


                }


            }


            catch (Exception ex)


            {




                objjson.code = "0";


                objjson.count = 0;


                objjson.Message = "获取失败" + ex.ToString();


                objjson.data = null;


                return objjson;


            }


        }






        #region 删除核算方式组


        /// <summary>


        /// 核算方式列表删除按钮


@@ -2250,9 +2302,9 @@


        /// <returns></returns>


        [Route("Web/SaveGetClassTimePrjGroupList")]


        [HttpGet]


        public object SaveGetClassTimePrjGroupList(string HNumber,string HName,string HDeptID,string refSav,string user,string HItem)


        public object SaveGetClassTimePrjGroupList(string HNumber, string HName, string HDeptID, string refSav, string user, string HItem)


        {


           




            try


            {


                int HItemID = int.Parse(HItem);


@@ -2265,18 +2317,18 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string sql="";


                if (refSav== "Add")


                string sql = "";


                if (refSav == "Add")


                {


                  sql = "Insert Into Gy_ClassTimePrjGroup   " +


                "(HNumber,HName,HStopflag,HRemark,HShortNumber,HParentID,HLevel" +


                ",HEndFlag,HHelpCode,HDeptID,HGroupID,HUseFlag" +


                ") " +


                " values('" + HNumber + "','" + HName + "','','',0,0,0,0,''," + HDeptID + ",0,'未使用'" + ") ";


                    sql = "Insert Into Gy_ClassTimePrjGroup   " +


                  "(HNumber,HName,HStopflag,HRemark,HShortNumber,HParentID,HLevel" +


                  ",HEndFlag,HHelpCode,HDeptID,HGroupID,HUseFlag" +


                  ") " +


                  " values('" + HNumber + "','" + HName + "','','',0,0,0,0,''," + HDeptID + ",0,'未使用'" + ") ";


                }


                else


                {


                    sql = "UpDate Gy_ClassTimePrjGroup set HNumber='" + HNumber + "',HName='" + HName + "',HDeptID=" + HDeptID+ " where HItemID="+ HItemID;


                    sql = "UpDate Gy_ClassTimePrjGroup set HNumber='" + HNumber + "',HName='" + HName + "',HDeptID=" + HDeptID + " where HItemID=" + HItemID;


                }


                oCN.RunProc(sql);


                objJsonResult.code = "1";


@@ -2762,7 +2814,7 @@


        [HttpGet]


        public object GetMaintainItemtemByMouldProjectID(int MouldProjectID)


        {


            




            if (MouldProjectID <= 0)


            {


                objjson.code = "0";


@@ -2874,7 +2926,7 @@


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                string sql = string.Format(@"select * from h_v_Sc_MouldDotCheckRuleBillList ");


                ds = oCN.RunProcReturn(sql+sWhere, "h_v_Sc_MouldDotCheckRuleBillList");


                ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_MouldDotCheckRuleBillList");


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


                {


                    objjson.code = "0";


@@ -2902,7 +2954,7 @@


            }


        }




         /// <summary>


        /// <summary>


        /// 根据设备显示设备保养规程项目


        /// </summary>


        /// <returns></returns>


@@ -2980,7 +3032,7 @@


                                                from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID 


                                                left join Gy_Maintain m on m.HItemID=t.HMaintainItemID


                                                left join Gy_Employee e on e.HItemID=t.HManagerID


                                                where a.HInterID=" + EquipProjectID );


                                                where a.HInterID=" + EquipProjectID);


                string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a  


                                    left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID 


                                                left join h_v_IF_Material m on b.HMaterID=m.HItemID


@@ -3112,8 +3164,8 @@


                return objjson;


            }


        }


        


        






        /// <summary>


        /// 获取维修项目列表


        /// </summary>


@@ -3338,7 +3390,7 @@


            WebS.WebService1 oWebs = new WebS.WebService1();


            try


            {


                ds = oWebs.GetKf_PonderationBillMain_TempList_New (HBillType, sHMaker, HOrgID);


                ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID);


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


                {


                    objJsonResult.code = "0";