From 0b87973581d38e17586d9c2e948bf7685d25cf97 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期一, 18 三月 2024 16:56:58 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/仓存管理/领料发货/Kf_StockOutRequestBillController.cs | 41 +++++++++++++++++++++++++++++++++++++++-- 1 files changed, 39 insertions(+), 2 deletions(-) diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs" index 10a1822..82efd80 100644 --- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs" +++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_StockOutRequestBillController.cs" @@ -165,7 +165,7 @@ ,HDeleteMan,HDeleteDate,HCloseMan,HCloseDate ,HRemark,HExplanation,HInnerBillNo,HERPInterID,HERPBillType ,HSTOCKORGID,HAPPLYTYPE,HOWNERTYPEIDHEAD,HBIZTYPE) - values(" + HInterID + ",'" + HBillNo + "','" + HDate + "','" + 1242 + "','" +1242 + "'," + HBillStatus + "," + DateTime.Now.Year + "," + DateTime.Now.Month + "," + HSupID + + values(" + HInterID + ",'" + HBillNo + "','" + HDate + "','" + 1242 + "','" + 1242 + "'," + HBillStatus + "," + DateTime.Now.Year + "," + DateTime.Now.Month + "," + HSupID + "," + HWHID + "," + HEmpID + "," + HMangerID + "," + HSecManagerID + "," + HKeeperID + "," + HDeptID + ",'" + HMaker + "','" + HMakeDate + "','" + HChecker + "','" + HCheckDate + "','" + HUpDater + "','" + HUpDateDate + "','" + HDeleteMan + "','" + HDeleteDate + "','" + HCloseMan + "','" + HCloseDate + "','" @@ -175,7 +175,7 @@ else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //淇敼 oCn.RunProc("update Kf_StockOutRequestBillMain set " + - "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + "' where HInterID=" + HInterID); + "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + " where HInterID=" + HInterID); //鍒犻櫎瀛愯〃 oCn.RunProc("delete from Kf_StockOutRequestBillSub where HInterID='" + HInterID + "'"); @@ -286,6 +286,43 @@ #endregion + #region 鍑哄簱鐢宠鍗曞垪琛� + [Route("Kf_StockOutRequestBill/cx")] + [HttpGet] + public object cx(long HInterID) + { + try + { + + ds = oCn.RunProcReturn("select * from h_v_IF_StockOutRequestBillList where hmainid =" + HInterID, "h_v_IF_StockOutRequestBillList"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "false锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + 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 + /// <summary> ///鍒犻櫎鍔熻兘 /// </summary> -- Gitblit v1.9.1