blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
杨乐
2022-01-19 76ffaf6c0b670ca779523ff22fbfb536bb45bf71 
 WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs


@@ -82,7 +82,7 @@




        #region 设备点检记录表 保存/编辑


        /// <summary>


        /// 保存模具维修单


        /// 点检记录表 保存


        /// </summary>


        /// <param name="msg"></param>


        /// <returns></returns>


@@ -223,7 +223,7 @@


        public object DeltetEquipDotCheckBillList(string HInterID)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //if (!DBUtility.ClsPub.Security_Log_second("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


@@ -318,7 +318,7 @@


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


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


                {


                    ds = oCN.RunProcReturn("select 点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList");


                    ds = oCN.RunProcReturn("select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 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 = "获取信息成功！";


@@ -326,7 +326,7 @@


                }


                else


                {


                    string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList where 1 = 1 ";


                    string sql1 = "select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 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";


@@ -371,7 +371,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)


                {


@@ -408,6 +408,7 @@


            string msg1 = _value.ToString();


            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


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


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




            string UserName = "";




@@ -464,9 +465,11 @@


                    oBill.omodel = oItem;


                }


                //子表体数据




                msg3 = msg3.Substring(1, msg3.Length - 2);


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


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


                List<Models.ClsSb_EquipDotCheckBillSub> ls = new List<Models.ClsSb_EquipDotCheckBillSub>();


                ls = oListModels.getObjectByJson_Sb_EquipDotCheckBillSubPDA(msg2);


                ls = oListModels.getObjectByJson_Sb_EquipDotCheckBillSubPDA(msg3);


                int i = 0;


                foreach (Models.ClsSb_EquipDotCheckBillSub oItemSub in ls)


                {