1

zrg

2024-10-29 322bb33e8e17b72874befaadcdf08f6457836ba3

 WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs

@@ -318,6 +318,7 @@
                oCN.BeginTran();

                oCN.RunProc("delete from Sc_WorkBeginDotCheckBillMain where HInterID = " + HInterID);
                oCN.RunProc("delete from Sc_WorkBeginDotCheckBillSub where HInterID = " + HInterID);

                oCN.Commit();

@@ -824,6 +825,44 @@
        }
        #endregion

        #region 根据生产资源获取最新的模具
        [Route("Sc_WorkBeginDotCheckBill/Sc_WorkBeginDotCheckBill_HMould")]
        [HttpGet]
        public object Sc_WorkBeginDotCheckBill_HMould(string HSourceID, string User)
        {
            try
            {
                List<DataTable> tableList = new List<DataTable>();

                //查看权限
                if (!DBUtility.ClsPub.Security_Log("Sc_WorkBeginDotCheckBillMain_Edit", 1, false, User))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "查询失败!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ds = oCN.RunProcReturn("select top 1 a.*,b.HName 模具名称 from Sc_MouldUpperBillSub a left join Gy_MouldFileMain b on a.HMouldID=b.HInterID where a.HSourceID='" + HSourceID + "'order by HScanDate desc", "Sc_MouldUpperBillSub");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "查询成功！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 设备启动点检清单列表 查询       
        [Route("Sc_WorkBeginDotCheckBill/getGy_WorkBeginDotCheckListBillMainList")]
        [HttpGet]
@@ -1117,6 +1156,7 @@
                oCN.BeginTran();

                oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillMain where HInterID = " + HInterID);
                oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillSub where HInterID = " + HInterID);

                oCN.Commit();