From f187e2cfc181982090b6ab0e8458113dba6ad47b Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期五, 13 九月 2024 11:30:00 +0800
Subject: [PATCH] 1.取样单增加打印功能 2.模具/设备的pda点检:两条进行提示,一条自动带出点检内容 3.设备工艺参数趋势图:根据流转卡的子表进站出站时间查询工艺参数(增加一个选择框 采集来源:(设备采集,手动输入))
---
WebAPI/Controllers/WebAPIController.cs | 102 ++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 96 insertions(+), 6 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 5c3dbdf..63e201a 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -81,6 +81,27 @@
}
}
+
+
+ /// <summary>
+ /// 鏍规嵁鏃堕棿鑾峰彇浜ч噺姹囨姤鍗曢泦鍚�
+ /// </summary>
+ /// <returns></returns>
+ [Route("Web/GetICMOBillWorkQtyStatus_Tmp")]
+ [HttpGet]
+ public object GetICMOBillWorkQtyStatus_Tmp()
+ {
+ DataSet ds = new DataSet();
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ ds = oCN.RunProcReturn("exec h_p_Sc_TodayWorkQtySumReport", "h_p_Sc_TodayWorkQtySumReport");
+ objjson.code = "1";
+ objjson.count = 1;
+ objjson.Message = "Sucess锛�";
+ objjson.data = ds.Tables[0];
+ return objjson;
+
+ }
+
[Route("Web/GetMAXNumPDA")]
[HttpGet]
public object GetMAXNumPDA(string HBillType)
@@ -7767,6 +7788,19 @@
}
}
+ /// <summary>
+ /// 宸ヨ壓鍝佸弬鏁板垎绫昏幏鍙栦俊鎭�
+ /// </summary>
+ /// <returns></returns>
+ [Route("GetGy_TechnologyTypeDetail")]
+ [HttpGet]
+ public ApiResult<DataSet> GetGy_TechnologyType(string HID)
+ {
+ var model = LuBaoSevice.GetGy_TechnologyType(HID);
+ return model;
+ }
+
+
#endregion
#region 瀹㈡埛鍒嗙被 璁剧疆鍒楄〃/淇濆瓨/缂栬緫/鍒犻櫎鏂规硶
@@ -11296,10 +11330,44 @@
return objjson; ;
}
}
-
-
-
#endregion
+
+ /// <summary>
+ /// 鑾峰彇鍩烘湰淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ [Route("Web/BaseInfo")]
+ [HttpGet]
+ public object GetBaseInfo()
+ {
+ try
+ {
+ ds = oCN.RunProcReturn("select * from xt_BaseInfo", "xt_BaseInfo");
+ if (ds is null)
+ {
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo;
+ objjson.data = null;
+ return objjson;
+ }
+ else
+ {
+ objjson.code = "0";
+ objjson.count = 1;
+ objjson.Message = "鑾峰彇鎴愬姛!";
+ objjson.data = ds.Tables[0];
+ return objjson;
+ }
+ }catch(Exception e)
+ {
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "鑾峰彇澶辫触" + e.Message;
+ objjson.data = null;
+ return objjson;
+ }
+ }
/// <summary>
/// 鑾峰彇鑱屽姟鍒楄〃
@@ -12900,6 +12968,14 @@
objjson.data = null;
return objjson;
}
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objjson.code = "0";
+ objjson.count = 1;
+ objjson.Message = "璇ヨ澶囨湁澶氫釜璁″垝鍗�,鎵嬪姩閫夌潃" ;
+ objjson.data = null;
+ return objjson;
+ }
else
{
objjson.code = "1";
@@ -12941,25 +13017,36 @@
switch (Type)
{
case "DJ":
- HView = "h_v_QJ_GetDotCheckItemList";
+ HView = "h_v_Sc_MouldDotCheckPlanBillList";
+ break;
+ case "BY":
+ HView = "h_v_Sc_MouldMaintainPlanBillList";
break;
default:
objjson.code = "0";
objjson.count = 0;
- objjson.Message = "璁惧妯″潡绫诲瀷閿欒锛�";
+ objjson.Message = "妯″叿妯″潡绫诲瀷閿欒锛�";
objjson.data = null;
return objjson;
}
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID);
- string sql = string.Format(@"Exec h_p_Sb_GetCheckItem_PDA '" + MouldProjectID + "','" + Type + "','" + HDate + "'");
+ string sql = string.Format(@"Exec h_p_Sb_GetCheckItemMouldFile_PDA '" + MouldProjectID + "','" + Type + "','" + HDate + "'");
ds = oCN.RunProcReturn(sql, HView);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "鑾峰彇澶辫触,鏌ユ棤鏁版嵁" + DBUtility.ClsPub.sErrInfo;
+ objjson.data = null;
+ return objjson;
+ }
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objjson.code = "0";
+ objjson.count = 1;
+ objjson.Message = "璇ユā鍏锋湁澶氫釜璁″垝鍗�,鎵嬪姩閫夌潃";
objjson.data = null;
return objjson;
}
@@ -13059,6 +13146,9 @@
case "YS":
HView = "h_v_Sb_EquipRepairCheckBillList";
break;
+ case "QD":
+ HView = "h_v_Sb_EquipRepairSignBillList";
+ break;
default:
objjson.code = "0";
objjson.count = 0;
--
Gitblit v1.9.1