From 6ca4391a35cb940a5a27fd45811cce2d07f04b78 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期一, 17 三月 2025 16:58:31 +0800 Subject: [PATCH] 销售报价单 列表 和 编辑 页面; (见原型设计) 增加 客户拜访记录单 列表 和 编辑 页面; 工艺路线,产品工艺参数 车间管理:岗位技能清单,员工技能清单,设备启动点检清单列表,产品防错验证清单列表 质量管理:检验方案,安灯逐级呼叫规则,环境检测方案 增加; 保存前控制存储过程,保存后控制存储过程,审核前控制,审核后控制,删除前控制,删除后控制;作废前控制 作废后控制 --- WebAPI/Controllers/SBGL/Sb_EquipReportController.cs | 65 ++++++++++++++++++++++++++++++++ 1 files changed, 65 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Sb_EquipReportController.cs b/WebAPI/Controllers/SBGL/Sb_EquipReportController.cs index aee193a..65d928b 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipReportController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipReportController.cs @@ -357,5 +357,70 @@ #endregion + #region 璁惧宸ヨ壓鍙傛暟鎶ヨ〃 + + [Route("Sb_EquipReportController/Get_SB_EquipICMOTechParamList")] + [HttpGet] + public object Get_SB_EquipICMOTechParamList(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + + Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); + + string HEquipNumber = dic["HEquipNumber"].ToString();//璁惧缂栫爜 + string HEquipName = dic["HEquipName"].ToString();//璁惧鍚嶇О + string HMaterNumber = dic["HMaterNumber"].ToString();//鐗╂枡缂栫爜 + string HMaterName = dic["HMaterName"].ToString();//鐗╂枡鍚嶇О + string HMouldID = dic["HMouldID"].ToString();//妯″叿 + string HDate = dic["HDate"].ToString();//寮�濮嬫棩鏈� + string HDate1 = dic["HDate1"].ToString();//缁撴潫鏃ユ湡 + + ds = oCN.RunProcReturn("exec h_p_SB_EquipICMOTechParamReport '" + HEquipNumber + "','" + HEquipName + "','" + HMaterNumber + "','" + HMaterName + "','" + HMouldID + "','" + HDate + "','" + HDate1 + "'", "h_p_SB_EquipICMOTechParamReport"); + + if (ds.Tables.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈煡璇㈠埌鏁版嵁锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈煡璇㈠埌鏁版嵁锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //娣诲姞鍒楀悕 + 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));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + } } -- Gitblit v1.9.1