1

chenhaozhe

2025-08-08 05a1bcf2d3fb7033b09a0cb7f99dc0514eacf537

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_MatePriceController.cs

@@ -28,7 +28,7 @@
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldUpperBill_Query", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -37,8 +37,7 @@
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_Gy_MaterPrice where 1 = 1 ");

                string sql = sql1 + sWhere;
                string sql = sql1 + sWhere+ "order by åˆ›å»ºæ—¶é—´ DESC ";
                ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterPrice");

                //添加列名
@@ -76,7 +75,7 @@
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePriceSupList_Query", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -117,15 +116,15 @@
            string msg1 = sArray[0].ToString();
            string msg2 = sArray[1].ToString();

            ////编辑权限
            //if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePriceSupList_Edit", 1, false, msg2))
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = "无保存权限！";
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}
            //编辑权限
            if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Edit", 1, false, msg2))
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "无保存权限！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            ListModels oListModels = new ListModels();

            try
@@ -209,6 +208,8 @@
                if (oBill.oModel.HItemID == 0)
                {
                    bResult = oBill.AddNew();
                    DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) from Gy_MaterPrice" , "Gy_MaterPrice");
                    oBill.oModel.HItemID = Convert.ToInt64(Maxds.Tables[0].Rows[0][0]);
                }
                else
                {
@@ -229,7 +230,7 @@
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功！";
                    objJsonResult.data = 1;
                    objJsonResult.data = oBill.oModel.HItemID;
                    return objJsonResult;
                }
                else
@@ -262,7 +263,7 @@
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                //删除权限
                if (!DBUtility.ClsPub.Security_Log("Gy_MatePriceSupList_Delete", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log("Gy_MatePrice_Delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -319,17 +320,20 @@
        }
        #endregion


        #region å®¡æ ¸ã€åå®¡æ ¸

        [Route("Gy_MatePriceController/MatePriceCheck")]
        [HttpGet]
        public object MatePriceCheck(int HInterID, int IsAudit, string CurUserName)
        {
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HInterID);
            DAL.ClsGy_MatePrice_Ctl oBill = new DAL.ClsGy_MatePrice_Ctl();
            List<Model.ClsGy_MatePrice_Model> lsmain = new List<Model.ClsGy_MatePrice_Model>();
            try
            {
                //审核权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_TechnologyParameterUnit_Check", 1, false, CurUserName))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Check", 1, false, CurUserName))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -337,6 +341,42 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if(lngBillKey==0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
                //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))                    //根据HInterID获取该单据的数据
                //{
                //    if (oBill.oModel.HCheckEmp.Trim() != "")
                //    {
                //        objJsonResult.code = "0";
                //        objJsonResult.count = 0;
                //        objJsonResult.Message = "单据已关闭!不能再次审核！";
                //        objJsonResult.data = null;
                //        return objJsonResult;
                //    }
                //    //if (oBill.omodel.HDeleteMan.Trim() != "")
                //    //{
                //    //    objJsonResult.code = "0";
                //    //    objJsonResult.count = 0;
                //    //    objJsonResult.Message = "单据已作废!不能再次审核！";
                //    //    objJsonResult.data = null;
                //    //    return objJsonResult;
                //    //}
                //}
                //else
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                var ds = oCN.RunProcReturn("select * from Gy_MaterPrice where HItemID=" + HInterID, "Gy_MaterPrice");
                if (ds.Tables[0].Rows.Count > 0)
@@ -523,7 +563,7 @@
            try
            {
                //禁用权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_TechnologyParameterUnit_Stop", 1, false, CurUserName))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Stop", 1, false, CurUserName))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -704,7 +744,7 @@
            }
        }
        #endregion

        

    }
}