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


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


using Newtonsoft.Json.Linq;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using Pub_Class;


using System;


using System.Collections.Generic;


@@ -22,6 +23,9 @@


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


        public DAL.ClsSb_EquipDotCheckBill BillNew = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类


        public DAL.ClsSb_EquipDotCheckBill BillOld = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类


        public DAL.ClsSb_EquipConkBookBill BillOld2 = new DAL.ClsSb_EquipConkBookBill();   //对应单据类


        public DAL.ClsSb_EquipRepairWorkBill BillOld3 = new DAL.ClsSb_EquipRepairWorkBill();   //对应单据类


        public DAL.ClsSb_EquipRepairCheckBill BillOld4 = new DAL.ClsSb_EquipRepairCheckBill();   //对应单据类






        #region 设备维修工单列表


@@ -31,21 +35,36 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/GetEqpRepairWorkBillList")]


        [HttpGet]


        public object GetEqpRepairWorkBillList(string sWhere)


        public object GetEqpRepairWorkBillList(string sWhere,string user)


        {


            try


            {


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


                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;


                




                //添加列名


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


                {


                    Type dataType = col.DataType;


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


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


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception ex)


            {


@@ -63,12 +82,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 +103,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 +145,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,16 +161,35 @@


        /// <returns></returns>


        [Route("Sb_EqpRepairWorkBill/GetEqpConkBookBillList")]


        [HttpGet]


        public object GetEqpConkBookBillList(string sWhere)


        public object GetEqpConkBookBillList(string sWhere,string user)


        {


            try


            {


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


                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);




                //添加列名


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


                {


                    Type dataType = col.DataType;


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


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


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;




            }


@@ -163,12 +209,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 +239,22 @@


            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();






            //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("\\", "");


@@ -278,6 +334,30 @@


                    oBill.DetailColl.Add(oItemSub);




                }




                //配件表体数据


                //按 },{来拆分数组 //去掉【和】


                //msg5 = msg5.Substring(1, msg5.Length - 2);


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


                msg5 = msg5.Replace("\n", "");  //\n


                                                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsSb_EquipRepairWorkBillSub_Mater> ls1 = new List<Model.ClsSb_EquipRepairWorkBillSub_Mater>();


                ls1 = JsonConvert.DeserializeObject<List<Model.ClsSb_EquipRepairWorkBillSub_Mater>>(msg5);


                int j = 0;


                foreach (Model.ClsSb_EquipRepairWorkBillSub_Mater oItemSub in ls1)


                {




                    j++;


                    oItemSub.HEntryID = i;


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;   //关闭类型                   


                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码    


                    oItemSub.HRelationQty = 0;     //关联数量


                    oBill.DetailColl_Mater.Add(oItemSub);




                }




                //保存


                //保存完毕后处理


                bool bResult;


@@ -334,35 +414,37 @@


        }


        #endregion




        #region[设备维修列表编辑时获取表体数据]


        #region[设备维修列表编辑时获取表体数据(维修列表、配件列表)]


        [Route("Sb_EqpRepairWorkBill/Sb_EqpRepairWorkBillListProjectDetai")]


        [HttpGet]


        public object Sb_EqpRepairWorkBillListProjectDetai(string sqlWhere)


        public object Sb_EqpRepairWorkBillListProjectDetai(string HInterID)


        {


            DataSet ds;


            DataSet ds, ds1;


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


            string sqlWhere = "";


            try


            {


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


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


                if (HInterID != "" || HInterID != null)


                {


                    //ds = oCN.RunProcReturn("select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark   from Sc_MouldRepairWorkBillSub", "Sc_MouldRepairWorkBillSub");


                    ds = oCN.RunProcReturn("select HRepairID,维修项目代码 HRepairCode,维修项目 HRepairName,HManagerID1 HManagerID,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1 HRepairID, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType  from h_v_Sc_EquipRepairWorkBillList_Edit", "h_v_Sc_EquipRepairWorkBillList_Edit");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                    sqlWhere = " and hmainid='" + HInterID + "'";


                }


                else


                {


                    //string sql1 = "select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark  from Sc_MouldRepairWorkBillSub where 1 = 1 ";


                    string sql1 = "select HRepairID,维修项目代码 HRepairCode,维修项目 HRepairName,HManagerID1 HManagerID,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1 HRepairID, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark ,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType from h_v_Sc_EquipRepairWorkBillList_Edit where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                    sqlWhere = HInterID;


                }


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


              


                ds = oCN.RunProcReturn("select HRepairID,维修项目代码 HRepairCode,维修项目 HRepairName,HManagerID1 HManagerID,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1 HRepairID, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType  from h_v_Sc_EquipRepairWorkBillList_Edit where 1 = 1 " + sqlWhere , "h_v_Sc_EquipRepairWorkBillList_Edit");


                string sql1 = "select * from h_v_Sb_EquipRepairWorkBillSub_Mater where 1 = 1 " + sqlWhere;


                ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipRepairWorkBillSub_Mater");


                list.Add(ds.Tables[0]);


                list.Add(ds1.Tables[0]);




                objJsonResult.code = "0";


                objJsonResult.count = 1;


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


                objJsonResult.list = list;




            }


            catch (Exception e)


            {


@@ -408,17 +490,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 +581,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 +779,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 +870,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 +1068,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 +1161,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)


                {


@@ -1224,6 +1324,459 @@


        }


        #endregion




        #region 设备故障登记单审核/反审核功能


        [Route("Sb_EqpConkBookBill/CheckSb_EqpConkBookBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_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 (!BillOld2.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (BillOld2.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_EqpConkBookBill/CloseSb_EqpConkBookBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_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 (!BillOld2.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (!BillOld2.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




        #region 设备维修记录单审核/反审核功能


        [Route("Sb_EquipRepairWorkBill/CheckSb_EquipRepairWorkBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBill_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 (!BillOld3.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (BillOld3.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_EquipRepairWorkBill/CloseSb_EquipRepairWorkBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBill_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 (!BillOld3.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (!BillOld3.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




        #region 设备维修验收单审核/反审核功能


        [Route("Sb_EquipRepairCheckBill/CheckSb_EquipRepairCheckBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_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 (!BillOld4.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (BillOld4.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_EquipRepairCheckBill/CloseSb_EquipRepairCheckBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_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 (!BillOld4.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    if (!BillOld4.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




        #endregion


    }


}