添加 模具维修检验单 派工单 APP 获取单据缓存接口 添加 APP 根据器具条码查找器具档案信息 应用程序接口

chenhaozhe

5 天以前 5c9033488d025bdf554e2e33b2a8030d3743faeb

 WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs

@@ -220,7 +220,7 @@
                string BillType = "3843";


                if (OperationType == 1)//新增
                if (OperationType == 1 || OperationType == 2)//新增
                {
                    //保存前控制
                    objJsonResult = BeforeSave_MouldRepairSendWorkBill(omodel.HInterID, omodel.HBillNo, 1);
@@ -247,7 +247,6 @@
                 ",'" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() +
                 "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMouldID.ToString() +
                  ", " + omodel.HSupID.ToString() + ",'" + omodel.HRepairType + "','" + omodel.HNewModel + "'," + omodel.HNewDesignLife.ToString() + ",'" + omodel.HMainSourceBillType + "'," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() +

                 ",1) ");
                }
                else if (OperationType == 3)
@@ -294,6 +293,7 @@
                ",HMainSourceEntryID=" + omodel.HMainSourceEntryID.ToString() +
                ",HNewDesignLife=" + omodel.HNewDesignLife.ToString() +
                " where HInterID=" + omodel.HInterID.ToString());


                    //删除子表
                    oCN.RunProc("delete from Sc_MouldRepairSendWorkBillSub where HInterID='" + omodel.HInterID.ToString() + "'");
@@ -949,5 +949,48 @@
            }
        }
        #endregion

        #region 根据器具条码查找器具档案信息PDA  查询条码档案列表
        [Route("Sc_PDA_MouldRepairCheckBill/txtHBarCode_KeyDown_List")]
        [HttpGet]
        public object txtHBarCode_KeyDown_List(string HBarCode)
        {
            try
            {
                if (HBarCode == null || HBarCode.Equals(""))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "条形码不能为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //得到信息
                ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_MouldFileList  where 条码编号= '" + HBarCode + "'", "h_v_Gy_EquipFileMainList");
                //写入信息
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到模具信息！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                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
    }
}