车间下架库存查询-网页、pda；周计划待排列表按日期排序

yusijie

2025-08-20 4292b7e65e843d6524f27f2fb06df0a812197790

车间下架库存查询-网页、pda；周计划待排列表按日期排序

 WebAPI/Controllers/MateOutController.cs

@@ -1165,6 +1165,53 @@
            }
        }

        //车间定位  è½¦é—´ä¸‹æž¶åº“存信息查询
        [Route("KF_ICInventory_WorkShop/GetWorkShopXJICInventory")]
        [HttpGet]
        public object GetWorkShopXJICInventory(string HCarBarCode, string HEquipBarCode, string HProcExBillNo,string HMaterNumber, long HWHID, long HSPID,string sWhere)
        {
            try
            {

                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                List<object> columnNameList = new List<object>();
                DataSet ds = oCN.RunProcReturn("exec h_p_KF_ICInventory_WorkShopByXJList '" + HCarBarCode + "','" + HEquipBarCode + "','" + HProcExBillNo + "','" + HMaterNumber + "'," + HWHID + "," + HSPID + ",'" + sWhere + "'", "h_p_KF_ICInventory_WorkShopByXJList");
                //添加列名
                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列对象的列名
                }

                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                    objJsonResult.list = columnNameList;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        [Route("MateOutBill/Delete_Json")]
        [HttpGet]
        public object Delete_Json(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType)

 WebAPI/Controllers/ÏîÄ¿¹ÜÀí/¹¤×÷Öܼƻ®/PM_WorkTaskWeekBillController.cs

@@ -47,7 +47,8 @@
                        ,单据类型 AS HSourceBillType
                        from h_v_PM_WorkTaskBillList
                        where å•æ®çŠ¶æ€ = '已审核'
                        and æŽ¥å•äºº = '" + user + "'";
                        and æŽ¥å•äºº = '" + user + "'"
                        + " order by æ—¥æœŸ asc";

                ds = oCn.RunProcReturn(sql, "h_v_PM_WorkTaskBillList");