智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
cwjbxqmz
2024-02-04 da1184528d1bcc9262f7faad5efddb7fd6d12669 
 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 设备维修工单列表


@@ -35,6 +39,7 @@


        {


            try


            {


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


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


                {


                    objJsonResult.code = "0";


@@ -46,10 +51,19 @@




                ds = Sb_EquipRepairWorkBill_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;


            }


            catch (Exception ex)


@@ -62,6 +76,60 @@


            }


        }


        #endregion




        #region 设备维修记录统计分析 


        /// <summary>


        /// 返回设备维修记录统计分析 列表


        ///参数：string sql。


        ///返回值：object。


        /// </summary>


        [Route("Sb_EquipRepairWorkReport/Statistics")]


        [HttpGet]


        public object Statistics(string DateYear, string HType, string user)


        {


            try


            {


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




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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "请选择有效年份";


                    return objJsonResult;


                }


                else


                {


                    ds = oCN.RunProcReturn("exec h_p_Sb_EquipRepairWorkBillReport '" + DateYear + "','" + HType + "'", "h_p_Sb_EquipRepairWorkBillReport");


                }




                //添加列名


                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 = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




      




        #region 设备维修工单列表sql语句


        public static DataSet Sb_EquipRepairWorkBill_s(string sWhere)


@@ -151,6 +219,7 @@


        {


            try


            {


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


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


                {


                    objJsonResult.code = "0";


@@ -162,10 +231,19 @@




                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;




            }


@@ -174,6 +252,59 @@


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion






        #region 设备故障记录统计分析 


        /// <summary>


        /// 返回设备故障记录统计分析 列表


        ///参数：string sql。


        ///返回值：object。


        /// </summary>


        [Route("Sb_EquipConkBookReport/Statistics")]


        [HttpGet]


        public object Statistics_Conk(string DateYear, string HType, string user)


        {


            try


            {


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




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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "请选择有效年份";


                    return objJsonResult;


                }


                else


                {


                    ds = oCN.RunProcReturn("exec h_p_Sb_EquipConkBookBillReport '" + DateYear + "','" + HType + "'", "h_p_Sb_EquipConkBookBillReport");


                }




                //添加列名


                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 = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -216,6 +347,7 @@


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


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


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


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






            //string UserName = "";


@@ -309,6 +441,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;


@@ -365,35 +521,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)


            {


@@ -1273,6 +1431,575 @@


        }


        #endregion




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


        [Route("Sb_EqpConkBookBill/CheckSb_EqpConkBookBill")]


        [HttpGet]


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


        {


            string sql = "";


            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;


                ds = oCN.RunProcReturn("select * from Sb_EquipConkBookBillMain where HInterID = " + int.Parse(HInterID), "Sb_EquipConkBookBillMain");


                string HBillNo = "";


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据不存在!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();


                }


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




                //Type 1 审核  2  反审核


                if (Type == 1)


                {


                    //审核前控制


                    sql = "exec h_p_Sb_EquipConkBookBill_BeforeCheckCtrl   " + int.Parse(HInterID) + ",'" + HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    if (!BillOld2.CheckBill(int.Parse(HInterID), HBillNo, "h_p_Sb_EquipConkBookBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    //反审核前控制


                    sql = "exec  h_p_Sb_EquipConkBookBill_BeforeUnCheckCtrl " + int.Parse(HInterID) + ",'" + HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }






                    if (BillOld2.AbandonCheck(int.Parse(HInterID), HBillNo, "h_p_Sb_EquipConkBookBill_AfterUnCheckCtrl", user, 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)


        {


            string sql = "";


            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;


                ds = oCN.RunProcReturn("select * from Sb_EquipRepairWorkBillMain where HInterID = " + int.Parse(HInterID), "Sb_EquipRepairWorkBillMain");


                string HBillNo = "";


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据不存在!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();


                }


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




                //Type 1 审核  2  反审核


                if (Type == 1)


                {


                    //审核前控制


                    sql = "exec h_p_Sb_EquipRepairWorkBill_BeforeCheckCtrl   " + int.Parse(HInterID) + ",'" + HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }






                    if (!BillOld3.CheckBill(int.Parse(HInterID), HBillNo, "h_p_Sb_EquipRepairWorkBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    //反审核前控制


                    sql = "exec  h_p_Sb_EquipRepairWorkBill_BeforeUnCheckCtrl " + int.Parse(HInterID) + ",'" + HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    if (BillOld3.AbandonCheck(int.Parse(HInterID), HBillNo, "h_p_Sb_EquipRepairWorkBill_AfterUnCheckCtrl", user, 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


    }


}