条码生成模块新增按F7选择辅助属性功能，辅助属性View模块新增按物料过滤调用方法

yxj

2021-08-20 616f399430a993132d2dca9316c973f4ccc8605a

 WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs

@@ -86,7 +86,7 @@
                    UserName = oItem.HMaker;  //制单人
                    oItem.HBillType = "3903";
                    oItem.HBillSubType = "3903";

                    DBUtility.ClsPub.CurUserName = UserName;
                    //oItem.HInterID =0;
                    //oItem.HBillNo = "";
                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期
@@ -290,7 +290,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_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList");
                    ds = oCN.RunProcReturn("select 点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList");
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
@@ -298,7 +298,7 @@
                }
                else
                {
                    string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID from h_v_Sb_EquipDotCheckBillList where 1 = 1 ";
                    string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList where 1 = 1 ";
                    string sql = sql1 + sqlWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBillList");
                    objJsonResult.code = "0";
@@ -328,7 +328,7 @@
        #region 设备点检记录单PDA

        #region 根据设备条码查找设备档案信息PDA
        [Route("Mj_PDA_EquipDotCheckBill/txtHBarCode_KeyDown")]
        [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown")]
        [HttpGet]
        public object txtHBarCode_KeyDown(string HBarCode)
        {
@@ -372,7 +372,7 @@

        #region 设备点检记录提交PDA

        [Route("Mj_PDA_EquipDotCheckBill/SaveGetEquipDotCheckBillList")]
        [Route("Sb_PDA_EquipDotCheckBill/SaveGetEquipDotCheckBillList")]
        [HttpPost]
        public object SaveGetEquipDotCheckBillList([FromBody] JObject msg)
        {