智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
jhz
2022-07-26 1f49f98a07ae1c31a1967c5c36b382d6c855becd 
 WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs


@@ -31,21 +31,26 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/GetEqpRepairWorkBillList")]


        [HttpGet]


        public object GetEqpRepairWorkBillList(string sWhere)


        public object GetEqpRepairWorkBillList(string sWhere,string user)


        {


            try


            {


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ds = Sb_EquipRepairWorkBill_s(sWhere);


               


                   


              


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "返回记录成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "返回记录成功！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception ex)


            {


@@ -63,12 +68,12 @@


        {


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


            {


                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ "order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList");


                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ " order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList");


            }


            else


            {


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


                string sql = sql1 + sWhere+ "order by hmainid desc";


                string sql = sql1 + sWhere+ " order by hmainid desc";


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairWorkBillList");


            }


            


@@ -84,18 +89,26 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/GetEqpRepairCheckWorkBillList")]


        [HttpGet]


        public object GetEqpRepairCheckWorkBillList(string sWhere)


        public object GetEqpRepairCheckWorkBillList(string sWhere,string user)


        {


            try


            {


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ds = Sb_EquipRepairCheckWorkBill_s(sWhere);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "返回记录成功！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;




            }


            catch (Exception ex)


            {


@@ -118,7 +131,7 @@


            else


            {


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


                string sql = sql1 + sWhere+ "order by hmainid desc";


                string sql = sql1 + sWhere+ " order by hmainid desc";


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairCheckBillList");


            }


            


@@ -134,12 +147,21 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/GetEqpConkBookBillList")]


        [HttpGet]


        public object GetEqpConkBookBillList(string sWhere)


        public object GetEqpConkBookBillList(string sWhere,string user)


        {


            try


            {


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ds = Sb_EqpConkBookBillList_s(sWhere);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "返回记录成功！";


@@ -163,12 +185,12 @@


        {


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


            {


                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" + sWhere, "h_v_Sb_EquipConkBookBillList");


                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" , "h_v_Sb_EquipConkBookBillList");


            }


            else


            {


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


                string sql = sql1 + sWhere+ "order by hmainid desc";


                string sql = sql1 + sWhere+ " order by hmainid desc";


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipConkBookBillList");


            }


        }


@@ -193,12 +215,21 @@


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


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


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


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






            //string UserName = "";


            ListModels oListModels = new ListModels();


            try


            {


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                DLL.ClsSb_EquipRepairWorkBill oBill = new DLL.ClsSb_EquipRepairWorkBill();


                List<Models.ClsSb_EquipRepairWorkBillMain> lsmain = new List<Models.ClsSb_EquipRepairWorkBillMain>();


                msg2 = msg2.Replace("\\", "");


@@ -408,17 +439,17 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/DeltetEqpRepairWorkBill")]


        [HttpGet]


        public object DeltetEqpRepairWorkBill(string HInterID)


        public object DeltetEqpRepairWorkBill(string HInterID,string user)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


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


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -499,12 +530,21 @@


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


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


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


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






            //string UserName = "";


            ListModels oListModels = new ListModels();


            try


            {


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                DLL.ClsSb_EquipRepairCheckBill oBill = new DLL.ClsSb_EquipRepairCheckBill();


                List<Model.ClsSb_EquipRepairCheckBillMain> lsmain = new List<Model.ClsSb_EquipRepairCheckBillMain>();


                msg2 = msg2.Replace("\\", "");


@@ -688,17 +728,17 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/DeltetEqpRepairCheckBill")]


        [HttpGet]


        public object DeltetEqpRepairCheckBill(string HInterID)


        public object DeltetEqpRepairCheckBill(string HInterID,string user)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


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


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -779,12 +819,21 @@


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


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


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




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




            //string UserName = "";


            ListModels oListModels = new ListModels();


            try


            {


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                DLL.ClsSb_EquipConkBookBill oBill = new DLL.ClsSb_EquipConkBookBill();


                List<Model.ClsSb_EquipConkBookBillMain> lsmain = new List<Model.ClsSb_EquipConkBookBillMain>();


                msg2 = msg2.Replace("\\", "");


@@ -968,17 +1017,17 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/DeltetEqpConkBookBill")]


        [HttpGet]


        public object DeltetEqpConkBookBill(string HInterID)


        public object DeltetEqpConkBookBill(string HInterID,string user)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


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


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -1061,7 +1110,7 @@


                    return objJsonResult;


                }


                //得到信息


                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipMent  where HNumber= '" + HBarCode + "'", "Gy_EquipMent");


                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipFileBillMain  where HEquipFileNumber= '" + HBarCode + "'", "Gy_EquipFileBillMain");


                //写入信息


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


                {