智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2023-11-15 cec6e468204b60d611baf9e985d38c43b6826ac3 
 WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs


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


using Newtonsoft.Json.Linq;


using DBUtility;


using Newtonsoft.Json.Linq;


using System;


using System.Collections.Generic;


using System.Data;


@@ -9,7 +10,9 @@


    public class Sb_EquipDotCheckPlanBillController : ApiController


    {


        private json objJsonResult = new json();


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


        public DataSet ds = new DataSet();


        public DAL.ClsSb_EquipDotCheckPlanBill BillOld = new DAL.ClsSb_EquipDotCheckPlanBill(); 




        #region 设备点检计划表




@@ -19,16 +22,46 @@


        /// <returns></returns>


        [Route("Sb_EquipDotCheckPlanBill/GetEquipDotCheckPlanBillList")]


        [HttpGet]


        public object GetEquipDotCheckPlanBillList(string sWhere)


        public object GetEquipDotCheckPlanBillList(string sWhere,string user)


        {


            try


            {


                ds = Sb_EquipDotCheckPlanBillList_s(sWhere);


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBillList", 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_Sb_EquipDotCheckPlanBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckPlanBillList");


                }


                else


                {


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


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


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


                }




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


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


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


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


            }


            catch (Exception ex)


            {


@@ -64,12 +97,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_EquipDotCheckPlanBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                DAL.ClsSb_EquipDotCheckPlanBill oBill = new DAL.ClsSb_EquipDotCheckPlanBill();


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


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


@@ -188,17 +230,17 @@


        /// <returns></returns>


        [Route("Sb_EquipDotCheckPlanBill/DeltetEquipDotCheckPlanBillList")]


        [HttpGet]


        public object DeltetEquipDotCheckPlanBillList(string HInterID)


        public object DeltetEquipDotCheckPlanBillList(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_EquipDotCheckPlanBill_Delete", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -274,7 +316,7 @@


            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };


        }


        #endregion


        #region[设备点检计划表编辑时获取表题数据]


        #region[设备点检计划表编辑时获取表体数据]


        [Route("Sb_EquipDotCheckPlanBill/Sb_EquipDotCheckPlanBillListProjectDetai")]


        [HttpGet]


        public object Sb_EquipDotCheckPlanBillListProjectDetai(string sqlWhere)


@@ -285,7 +327,7 @@


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


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


                {


                    ds = oCN.RunProcReturn("select 点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,HManagerID from h_v_Sb_EquipDotCheckPlanBillList_Edit", "h_v_Sb_EquipDotCheckPlanBillList_Edit");


                    ds = oCN.RunProcReturn("select 点检项目ID  HDotCheckItemID,点检项目代码  HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人代码 HManagerCode,负责人 HManagerName from h_v_Sb_EquipDotCheckPlanBillList", "h_v_Sb_EquipDotCheckPlanBillList");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -293,9 +335,9 @@


                }


                else


                {


                    string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID from h_v_Sb_EquipDotCheckPlanBillList_Edit where 1 = 1 ";


                    string sql1 = "select 点检项目ID  HDotCheckItemID,点检项目代码  HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人代码 HManagerCode,负责人 HManagerName from h_v_Sb_EquipDotCheckPlanBillList where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


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


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -313,7 +355,156 @@


        }


        #endregion




        #region 设备点检计划单审核/反审核功能


        [Route("Sb_EquipDotCheckPlanBill/CheckSb_EquipDotCheckPlanBill")]


        [HttpGet]


        public object CheckSb_EquipMaintainRuleBill(string HInterID, int Type, string user)


        {


            try


            {


                //判断是否有删除权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无权限审核!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (string.IsNullOrWhiteSpace(HInterID))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                oCN.BeginTran();//开始事务




                //Type 1 审核  2  反审核


                if (Type == 1)


                {


                    if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


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


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




                oCN.Commit();//提交事务




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "执行成功！";


                objJsonResult.data = null;


                return objJsonResult; ;




            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "执行失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 设备点检计划单关闭/反关闭功能


        [Route("Sb_EquipDotCheckPlanBill/CloseSb_EquipDotCheckPlanBill")]


        [HttpGet]


        public object CloseSb_EquipMaintainRuleBill(string HInterID, int Type, string user)


        {


            try


            {


                //判断是否有删除权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无权限关闭!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (string.IsNullOrWhiteSpace(HInterID))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;




                oCN.BeginTran();//开始事务




                //Type 1 关闭  2  反关闭


                if (Type == 1)


                {


                    if (!BillOld.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (!BillOld.CancelClose(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




                oCN.Commit();//提交事务




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "执行成功！";


                objJsonResult.data = null;


                return objJsonResult; ;




            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "执行失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion