From 67bfff895914fe3d56f1c1c4c5e39efb5fec2a06 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 30 七月 2024 16:53:33 +0800
Subject: [PATCH] 设备工艺参数趋势图后端查询
---
WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs | 112 +++++++++++++++----------------------------------------
1 files changed, 31 insertions(+), 81 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs
index 465de7c..09b5cc9 100644
--- a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs
@@ -9,7 +9,7 @@
using WebAPI.Models;
namespace WebAPI.Controllers
{
- public class Gy_DepartmentController : ApiController
+ public class Gy_StockPlaceController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
@@ -17,84 +17,34 @@
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
DataSet ds;
-
- /// <summary>
- /// 杩斿洖閮ㄩ棬鍒楄〃
- ///鍙傛暟锛歴tring sql銆�
- ///杩斿洖鍊硷細object銆�
- /// </summary>
- [Route("Gy_Department/list")]
- [HttpGet]
- public object list(string sWhere)
- {
- try
- {
- if (sWhere == null || sWhere.Equals(""))
- {
- ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentList " + sWhere, "h_v_IF_DepartmentList");
- }
- else
- {
- string sql1 = "select * from h_v_IF_DepartmentList where 1 = 1 ";
- string sql = sql1 + sWhere;
- ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList");
- }
- 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;
- }
- }
-
-
- /// <summary>
- /// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍
- ///鍙傛暟锛歴tring sql銆�
- ///杩斿洖鍊硷細object銆�
- /// </summary>
- [Route("Gy_Department/cx")]
- [HttpGet]
- public object cx(long HInterID)
- {
- try
- {
- ds = oCN.RunProcReturn("select * from Gy_Department where hitemid = " + HInterID, "Gy_Department");
+ ///// <summary>
+ ///// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍
+ /////鍙傛暟锛歴tring sql銆�
+ /////杩斿洖鍊硷細object銆�
+ ///// </summary>
+ //[Route("Gy_Department/cx")]
+ //[HttpGet]
+ //public object cx(long HInterID)
+ //{
+ // try
+ // {
+ // ds = oCN.RunProcReturn("select * from Gy_Department where hitemid = " + HInterID, "Gy_Department");
- 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;
- }
- }
+ // 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;
+ // }
+ //}
/// <summary>
/// 閮ㄩ棬鍒楄〃鍒犻櫎鎸夐挳
@@ -109,7 +59,7 @@
DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View();
try
{
- if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true,User))
+ if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false,User))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -338,7 +288,7 @@
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_Department/AddBill1")]
+ [Route("Gy_StockPlaceController/AddBill1")]
[HttpPost]
public object AddBill1([FromBody] JObject oMain)
{
@@ -382,7 +332,7 @@
//鍒ゆ柇鏉冮檺
- if (!ClsPub.Security_Log(msg5, 1, true, msg4))
+ if (!ClsPub.Security_Log(msg5, 1, false, msg4))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
--
Gitblit v1.9.1