1

llj

4 天以前 99bcfefdb20187000fc89a8f2654745ad2f0e371

 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));//获取到DataColumn列对象的列名
                }

                //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