智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
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


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


                }




                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


    }


}