From 99bcfefdb20187000fc89a8f2654745ad2f0e371 Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期二, 12 五月 2026 15:39:09 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs | 577 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 577 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
index 46a56ad..44680f8 100644
--- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
@@ -12,8 +12,11 @@
using System.Web.Http;
using WebAPI.Controllers.SCGL.鏃ヨ鍒掔鐞�;
using WebAPI.Models;
+using WebAPI.Utility;
+
namespace WebAPI.Controllers
{
+ [Permission(HModName = "Gy_BadResult")]
public class Gy_BadReasonController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
@@ -28,6 +31,8 @@
/// </summary>
[Route("Gy_BadReason/list")]
[HttpGet]
+ [Permission(HModName = "Gy_BadResult", Operate = "_Query")]
+
public object list(string sWhere,string user)
{
try
@@ -89,6 +94,74 @@
return objJsonResult;
}
}
+ #region 涓嶈壇鍘熷洜瀛樺偍杩囩▼
+ /// <summary>
+ /// 杩斿洖涓嶈壇鍘熷洜鍒楄〃
+ /// </summary>
+ [Route("Gy_BadReason/list_1")]
+ [HttpGet]
+ [Permission(HModName = "Gy_BadResult", Operate = "_Query")]
+ public object list_1(string sWhere, string user,int HMaterID,string HBillType,string OrgID)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+ //鏌ョ湅鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Query", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ sWhere = "and 1=1";
+ }
+ else
+ sWhere = sWhere.Replace("'","''");
+ ds = oCN.RunProcReturn("exec h_p_IF_BadReasonList " + HMaterID +",'"+ HBillType + "'," + OrgID + ",'" + sWhere +"'"+ " ", "h_p_IF_BadReasonList");
+
+
+
+ //娣诲姞鍒楀悕
+ 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鍒楀璞＄殑鍒楀悕
+ }
+
+ //if (ds.Tables[0].Rows.Count != 0 || ds != null)
+ //{
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = columnNameList;
+ return objJsonResult;
+ //}
+ //else
+ //{
+ //objJsonResult.code = "0";
+ //objJsonResult.count = 0;
+ //objJsonResult.Message = "鏃犳暟鎹�";
+ //objJsonResult.data = null;
+ //return objJsonResult;
+ //}
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
#region 涓嶈壇鍘熷洜瀹℃牳銆佸弽瀹℃牳
/// <summary>
@@ -100,6 +173,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_BadReason")]
[HttpGet]
+ [Permission(HModName = "Gy_BadResult", Operate = "_Check")]
public object AuditGy_BadReason(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -491,6 +565,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_BadReason")]
[HttpGet]
+ [Permission(HModName = "Gy_BadResult", Operate = "_Stop")]
public object StopGy_BadReason(int HInterID, int IsStop, string CurUserName)
{
try
@@ -1668,6 +1743,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_InspectValueList")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectValue", Operate = "_Query")]
public object Gy_InspectValueList(string sWhere, string user)
{
try
@@ -1721,6 +1797,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_InspectValue")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectValue", Operate = "_Check")]
public object AuditGy_InspectValue(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -1896,6 +1973,7 @@
[Route("Gy_BadReason/AuditGy_InspectValue_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectValue", Operate = "_Check")]
public object AuditGy_InspectValue_BT(string HNumber, int IsAudit, string CurUserName, string HOrgID)
{
try
@@ -2080,6 +2158,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_InspectValue")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectValue", Operate = "_Close")]
public object StopGy_InspectValue(int HInterID, int IsStop, string CurUserName)
{
try
@@ -2262,6 +2341,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_InspectMethodList")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectMethod", Operate = "_Query")]
public object Gy_InspectMethodList(string sWhere, string user)
{
try
@@ -2315,6 +2395,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_InspectMethod")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectMethod", Operate = "_Check")]
public object AuditGy_InspectMethod(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -2402,6 +2483,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_InspectMethod_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectMethod", Operate = "_Check")]
public object AuditGy_InspectMethod_BT(string HNumber, int IsAudit, string CurUserName, string HOrgID)
{
try
@@ -2496,6 +2578,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_InspectMethod")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectMethod", Operate = "_Close")]
public object StopGy_InspectMethod(int HInterID, int IsStop, string CurUserName)
{
try
@@ -2791,6 +2874,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_QualityStdList")]
[HttpGet]
+ [Permission(HModName = "Gy_QualityStd", Operate = "_Query")]
public object Gy_QualityStdList(string sWhere, string user)
{
try
@@ -2844,6 +2928,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_QualityStd")]
[HttpGet]
+ [Permission(HModName = "Gy_QualityStd", Operate = "_Check")]
public object AuditGy_QualityStd(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -2930,6 +3015,7 @@
[Route("Gy_BadReason/AuditGy_QualityStd_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_QualityStd", Operate = "_Check")]
public object AuditGy_QualityStd_BT(string HNumber, int IsAudit, string CurUserName,string HOrgID)
{
try
@@ -3025,6 +3111,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_QualityStd")]
[HttpGet]
+ [Permission(HModName = "Gy_QualityStd", Operate = "_Close")]
public object StopGy_QualityStd(int HInterID, int IsStop, string CurUserName)
{
try
@@ -3121,6 +3208,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_BadTypeList")]
[HttpGet]
+ [Permission(HModName = "Gy_BadType")]
public object Gy_BadTypeList(string sWhere, string user)
{
try
@@ -3174,6 +3262,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_BadType")]
[HttpGet]
+ [Permission(HModName = "Gy_BadType", Operate = "_Check")]
public object AuditGy_BadType(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -3361,6 +3450,7 @@
[Route("Gy_BadReason/AuditGy_BadType_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_BadType", Operate = "_Check")]
public object AuditGy_BadType_BT(string HNumber, int IsAudit, string CurUserName,string HOrgID)
{
try
@@ -3555,6 +3645,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_BadType")]
[HttpGet]
+ [Permission(HModName = "Gy_BadType", Operate = "_Stop")]
public object StopGy_BadType(int HInterID, int IsStop, string CurUserName)
{
try
@@ -3749,6 +3840,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_InspectInstruMentList")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Query")]
public object Gy_InspectInstruMentList(string sWhere, string user)
{
try
@@ -3802,6 +3894,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_InspectInstruMent")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Check")]
public object AuditGy_InspectInstruMent(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -3976,6 +4069,7 @@
[Route("Gy_BadReason/AuditGy_InspectInstruMent_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Check")]
public object AuditGy_InspectInstruMent_BT(string HNumber, int IsAudit, string CurUserName, string HOrgID)
{
try
@@ -4160,6 +4254,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_InspectInstruMent")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Close")]
public object StopGy_InspectInstruMent(int HInterID, int IsStop, string CurUserName)
{
try
@@ -4342,6 +4437,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_InspectBasisList")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectBasis", Operate = "_Query")]
public object Gy_InspectBasisList(string sWhere, string user)
{
try
@@ -4395,6 +4491,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_InspectBasis")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectBasis", Operate = "_Check")]
public object AuditGy_InspectBasis(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -4481,6 +4578,7 @@
[Route("Gy_BadReason/AuditGy_InspectBasis_BT")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectBasis", Operate = "_Check")]
public object AuditGy_InspectBasis_BT(string HNumber, int IsAudit, string CurUserName, string HOrgID)
{
try
@@ -4576,6 +4674,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_InspectBasis")]
[HttpGet]
+ [Permission(HModName = "Gy_InspectBasis", Operate = "_Close")]
public object StopGy_InspectBasis(int HInterID, int IsStop, string CurUserName)
{
try
@@ -4670,6 +4769,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_PostSkillList")]
[HttpGet]
+ [Permission(HModName = "Gy_PostSkill_Query")]
public object Gy_PostSkillList(string sWhere, string user)
{
try
@@ -4723,6 +4823,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_PostSkill")]
[HttpGet]
+ [Permission(HModName = "Gy_PostSkill_Check")]
public object AuditGy_PostSkill(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -4919,6 +5020,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_PostSkill")]
[HttpGet]
+ [Permission(HModName = "Gy_PostSkill_Close")]
public object StopGy_PostSkill(int HInterID, int IsStop, string CurUserName)
{
try
@@ -5113,6 +5215,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_PostList")]
[HttpGet]
+ [Permission(HModName = "Gy_Post_Query")]
public object Gy_PostList(string sWhere, string user)
{
try
@@ -5166,6 +5269,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_Post")]
[HttpGet]
+ [Permission(HModName = "Gy_Post_Check")]
public object AuditGy_Post(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -5362,6 +5466,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_Post")]
[HttpGet]
+ [Permission(HModName = "Gy_Post_Close")]
public object StopGy_Post(int HInterID, int IsStop, string CurUserName)
{
try
@@ -5554,6 +5659,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_StockMoveStyleList")]
[HttpGet]
+ [Permission(HModName = "Gy_StockMoveStyle_Query")]
public object Gy_StockMoveStyleList(string sWhere, string user)
{
try
@@ -5607,6 +5713,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_StockMoveStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockMoveStyle_Check")]
public object AuditGy_StockMoveStyle(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -5702,6 +5809,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_StockMoveStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockMoveStyle_Close")]
public object StopGy_StockMoveStyle(int HInterID, int IsStop, string CurUserName)
{
try
@@ -5796,6 +5904,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_StockInStyleList")]
[HttpGet]
+ [Permission(HModName = "Gy_StockInStyle_Query")]
public object Gy_StockInStyleList(string sWhere, string user)
{
try
@@ -5849,6 +5958,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_StockInStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockInStyle_Check")]
public object AuditGy_StockInStyle(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -5944,6 +6054,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_StockInStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockInStyle_Close")]
public object StopGy_StockInStyle(int HInterID, int IsStop, string CurUserName)
{
try
@@ -6038,6 +6149,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_StockOutStyleList")]
[HttpGet]
+ [Permission(HModName = "Gy_StockOutStyle_Query")]
public object Gy_StockOutStyleList(string sWhere, string user)
{
try
@@ -6091,6 +6203,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_StockOutStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockOutStyle_Check")]
public object AuditGy_StockOutStyle(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -6186,6 +6299,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_StockOutStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_StockOutStyle_Close")]
public object StopGy_StockOutStyle(int HInterID, int IsStop, string CurUserName)
{
try
@@ -6280,6 +6394,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_AreaSetList")]
[HttpGet]
+ [Permission(HModName = "Gy_AreaSet_Query")]
public object Gy_AreaSetList(string sWhere, string user)
{
try
@@ -6333,6 +6448,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_AreaSet")]
[HttpGet]
+ [Permission(HModName = "Gy_AreaSet_Check")]
public object AuditGy_AreaSet(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -6428,6 +6544,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_AreaSet")]
[HttpGet]
+ [Permission(HModName = "Gy_AreaSet_Close")]
public object StopGy_AreaSet(int HInterID, int IsStop, string CurUserName)
{
try
@@ -6522,6 +6639,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_SellStyleList")]
[HttpGet]
+ [Permission(HModName = "Gy_SellStyle_Query")]
public object Gy_SellStyleList(string sWhere, string user)
{
try
@@ -6575,6 +6693,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_SellStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_SellStyle_Check")]
public object AuditGy_SellStyle(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -6670,6 +6789,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_SellStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_SellStyle_Close")]
public object StopGy_SellStyle(int HInterID, int IsStop, string CurUserName)
{
try
@@ -6764,6 +6884,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_PoStockStyleList")]
[HttpGet]
+ [Permission(HModName = "Gy_PoStockStyle_Query")]
public object Gy_PoStockStyleList(string sWhere, string user)
{
try
@@ -6817,6 +6938,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_PoStockStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_PoStockStyle_Check")]
public object AuditGy_PoStockStyle(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -6912,6 +7034,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_PoStockStyle")]
[HttpGet]
+ [Permission(HModName = "Gy_PoStockStyle_Close")]
public object StopGy_PoStockStyle(int HInterID, int IsStop, string CurUserName)
{
try
@@ -7006,6 +7129,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_SupTypeList")]
[HttpGet]
+ [Permission(HModName = "Gy_SupType_Query")]
public object Gy_SupTypeList(string sWhere, string user)
{
try
@@ -7059,6 +7183,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_SupType")]
[HttpGet]
+ [Permission(HModName = "Gy_SupType_Check")]
public object AuditGy_SupType(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -7154,6 +7279,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_SupType")]
[HttpGet]
+ [Permission(HModName = "Gy_SupType_Close")]
public object StopGy_SupType(int HInterID, int IsStop, string CurUserName)
{
try
@@ -7693,6 +7819,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_CusTypeList")]
[HttpGet]
+ [Permission(HModName = "Gy_CusType_Query")]
public object Gy_CusTypeList(string sWhere, string user)
{
try
@@ -7746,6 +7873,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_CusType")]
[HttpGet]
+ [Permission(HModName = "Gy_CusType_Check")]
public object AuditGy_CusType(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -7841,6 +7969,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_CusType")]
[HttpGet]
+ [Permission(HModName = "Gy_CusType_Close")]
public object StopGy_CusType(int HInterID, int IsStop, string CurUserName)
{
try
@@ -7936,6 +8065,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_StockCheckItemList")]
[HttpGet]
+ [Permission(HModName = "Gy_StockCheckItem_Query")]
public object Gy_StockCheckItemList(string sWhere, string user)
{
try
@@ -7989,6 +8119,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_StockCheckItem")]
[HttpGet]
+ [Permission(HModName = "Gy_StockCheckItem_Check")]
public object AuditGy_StockCheckItem(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -8084,6 +8215,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_StockCheckItem")]
[HttpGet]
+ [Permission(HModName = "Gy_StockCheckItem_Close")]
public object StopGy_StockCheckItem(int HInterID, int IsStop, string CurUserName)
{
try
@@ -8178,6 +8310,7 @@
/// <returns></returns>
[Route("Gy_BadReason/Gy_ProjectMoneyList")]
[HttpGet]
+ [Permission(HModName = "Gy_ProjectMoney_Query")]
public object Gy_ProjectMoneyList(string sWhere, string user)
{
try
@@ -8231,6 +8364,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_ProjectMoney")]
[HttpGet]
+ [Permission(HModName = "Gy_ProjectMoney_Check")]
public object AuditGy_ProjectMoney(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -8423,6 +8557,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_ProjectMoney")]
[HttpGet]
+ [Permission(HModName = "Gy_ProjectMoney_Close")]
public object StopGy_ProjectMoney(int HInterID, int IsStop, string CurUserName)
{
try
@@ -9547,6 +9682,7 @@
#region 寮傚父绫诲瀷 鏌ヨ,瀹℃牳锛屽弽瀹℃牳锛岀鐢紝鍙嶇鐢�
[Route("Gy_BadReason/Gy_ErrTypeList")]
[HttpGet]
+ [Permission(HModName = "Gy_ErrType", Operate = "_Query")]
public object Gy_ErrTypeList(string sWhere, string user)
{
try
@@ -9600,6 +9736,7 @@
/// <returns></returns>
[Route("Gy_BadReason/AuditGy_ErrType")]
[HttpGet]
+ [Permission(HModName = "Gy_ErrType", Operate = "_Check")]
public object AuditGy_ErrType(int HInterID, int IsAudit, string CurUserName)
{
try
@@ -9693,6 +9830,7 @@
/// <returns></returns>
[Route("Gy_BadReason/StopGy_ErrType")]
[HttpGet]
+ [Permission(HModName = "Gy_ErrType", Operate = "_Stop")]
public object StopGy_ErrType(int HInterID, int IsStop, string CurUserName)
{
try
@@ -14352,5 +14490,444 @@
}
#endregion
+
+
+
+ #region 璐圭敤椤圭洰 鏌ヨ,瀹℃牳锛屽弽瀹℃牳锛岀鐢紝鍙嶇鐢�
+ /// <summary>
+ /// 渚涘簲鍟嗗垎绫� 鏌ヨ
+ /// </summary>
+ /// <param name="sWhere"></param>
+ /// <param name="user"></param>
+ /// <returns></returns>
+ [Route("Gy_BadReason/Gy_ItemMoneyList")]
+ [HttpGet]
+ public object Gy_ItemMoneyList(string sWhere, string user)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+ //鏌ョ湅鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_ProjectMoney_Query", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ string sql1 = "SELECT * from h_v_Gy_ItemMoney_1 where 1 = 1";
+ string sql = sql1 + sWhere + " order by 璐圭敤椤圭洰浠ｇ爜 ";
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_ItemMoney_1");
+
+ //娣诲姞鍒楀悕
+ 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;
+ }
+ }
+
+ /// <summary>
+ /// 椤圭洰璐圭敤 瀹℃牳銆佸弽瀹℃牳
+ /// </summary>
+ /// <param name="HInterID">鍗曟嵁ID</param>
+ /// <param name="IsAudit">瀹℃牳(0),鍙嶅鏍�(1)</param>
+ /// <param name="CurUserName">瀹℃牳浜�</param>
+ /// <returns></returns>
+ [Route("Gy_BadReason/AuditGy_ItemMoney")]
+ [HttpGet]
+ public object AuditGy_ItemMoney(int HInterID, int IsAudit, string CurUserName)
+ {
+ try
+ {
+ //瀹℃牳鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log_second("Gy_ItemMoney_Check", 1, false, CurUserName))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ var ds = oCN.RunProcReturn("select * from Gy_ItemMoney_1 where HItemID=" + HInterID, "Gy_ItemMoney_1");
+ if (ds.Tables[0].Rows.Count > 0)
+ {
+ if (IsAudit == 0) //瀹℃牳鍒ゆ柇
+ {
+ if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ if (IsAudit == 1) //鍙嶅鏍稿垽鏂�
+ {
+ if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ oCN.BeginTran();
+
+ if (IsAudit == 0) //瀹℃牳鍒ゆ柇
+ {
+ //瀹℃牳鍓嶆帶鍒�=========================================
+ string sql1 = "exec h_p_Gy_ItemMoney_BeforeCheckCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_Gy_ItemMoney_BeforeCheckCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:瀹℃牳鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ oCN.RunProc("update Gy_ItemMoney_1 set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
+
+ //瀹℃牳鍚庢帶鍒�=========================================
+ string sql2 = "exec h_p_Gy_ItemMoney_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql2, "h_p_Gy_ItemMoney_AfterCheckCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:瀹℃牳鍚庡垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "瀹℃牳鎴愬姛";
+ objJsonResult.data = null;
+ }
+ if (IsAudit == 1) //鍙嶅鏍稿垽鏂�
+ {
+
+ //鍙嶅鏍稿墠鎺у埗=========================================
+ string sql1 = "exec h_p_Gy_ItemMoney_BeforeUnCheckCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_Gy_ItemMoney_BeforeUnCheckCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:鍙嶅鏍稿墠鍒ゆ柇澶辫触锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ oCN.RunProc("update Gy_ItemMoney_1 set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
+
+ //鍙嶅鏍稿悗鎺у埗=========================================
+ string sql2 = "exec h_p_Gy_ItemMoney_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql2, "h_p_Gy_ItemMoney_AfterUnCheckCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:鍙嶅鏍稿悗鍒ゆ柇澶辫触锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶅鏍告垚鍔�";
+ objJsonResult.data = null;
+ }
+ oCN.Commit();
+
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瀹℃牳澶辫触鎴栬�呭弽瀹℃牳澶辫触锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+
+
+ /// <summary>
+ /// 椤圭洰璐圭敤 绂佺敤銆佸弽绂佺敤
+ /// </summary>
+ /// <param name="HInterID">鍗曟嵁ID</param>
+ /// <param name="IsStop">绂佺敤(0),鍙嶇鐢�(1)</param>
+ /// <param name="CurUserName">瀹℃牳浜�</param>
+ /// <returns></returns>
+ [Route("Gy_BadReason/StopGy_ItemMoney")]
+ [HttpGet]
+ public object StopGy_ItemMoney(int HInterID, int IsStop, string CurUserName)
+ {
+ try
+ {
+ //瀹℃牳鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log_second("Gy_ItemMoney_Close", 1, false, CurUserName))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "绂佺敤澶辫触锛佹棤鏉冮檺锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ var ds = oCN.RunProcReturn("select * from Gy_ItemMoney_1 where HItemID=" + HInterID, "Gy_SupType");
+ if (ds.Tables[0].Rows.Count > 0)
+ {
+ if (IsStop == 0) //绂佺敤鍒ゆ柇
+ {
+ if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁宸茬鐢�!涓嶈兘鍐嶆绂佺敤锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ if (IsStop == 1) //鍙嶇鐢ㄥ垽鏂�
+ {
+ if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁鏈鐢�!涓嶉渶瑕佸弽绂佺敤!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ oCN.BeginTran();
+
+ if (IsStop == 0) //绂佺敤鍒ゆ柇
+ {
+
+ //绂佺敤鍓嶆帶鍒�=========================================
+ string sql1 = "exec h_p_Gy_ProjectMoney_BeforeStopCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_Gy_ProjectMoney_BeforeStopCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "绂佺敤澶辫触!鍘熷洜:绂佺敤鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "绂佺敤澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ oCN.RunProc("update Gy_ItemMoney_1 set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
+
+ //绂佺敤鍚庢帶鍒�=========================================
+ string sql2 = "exec h_p_Gy_ProjectMoney_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql2, "h_p_Gy_ProjectMoney_AfterStopCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "绂佺敤澶辫触!鍘熷洜:绂佺敤鍚庡垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "绂佺敤澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "绂佺敤鎴愬姛";
+ objJsonResult.data = null;
+ }
+ if (IsStop == 1) //鍙嶇鐢ㄥ垽鏂�
+ {
+
+ //鍙嶇鐢ㄥ墠鎺у埗=========================================
+ string sql1 = "exec h_p_Gy_ProjectMoney_BeforeUnStopCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_Gy_ProjectMoney_BeforeUnStopCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶇鐢ㄥけ璐�!鍘熷洜:鍙嶇鐢ㄥ墠鍒ゆ柇澶辫触锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶇鐢ㄥけ璐�!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ oCN.RunProc("update Gy_ItemMoney_1 set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
+
+ //鍙嶇鐢ㄥ悗鎺у埗=========================================
+ string sql2 = "exec h_p_Gy_ProjectMoney_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'";
+ ds = oCN.RunProcReturn(sql2, "h_p_Gy_ProjectMoney_AfterUnStopCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶇鐢ㄥけ璐�!鍘熷洜:鍙嶇鐢ㄥ悗鍒ゆ柇澶辫触锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�";
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶇鐢ㄥけ璐�!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==================================================================================
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶇鐢ㄦ垚鍔�";
+ objJsonResult.data = null;
+ }
+ oCN.Commit();
+
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "绂佺敤澶辫触鎴栬�呭弽绂佺敤澶辫触锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1