智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2021-10-18 24338804205169eec8e80d491ce0b0602fc13a7d 
 WebAPI/Controllers/QC_ManagementController.cs


@@ -104,20 +104,20 @@


        /// <returns></returns>


        [Route("QC_Management/MES_QC_CheckProjectList_Json")]


        [HttpGet]


        public object MES_QC_CheckProjectList_Json(string sqlWhere)


        public object MES_QC_CheckProjectList_Json(string sWhere)


        {


            DataSet ds;


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                if (sqlWhere == null || sqlWhere.Equals(""))


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select top 500 * from h_v_Gy_QCCheckProjectList where HBillStatus>-1 ", "h_v_Gy_QCCheckProjectList");


                    ds = oCN.RunProcReturn("select  * from h_v_Gy_QCCheckProjectList", "h_v_Gy_QCCheckProjectList");


                }


                else


                {


                    string sql1 = "select * from h_v_Gy_QCCheckProjectList where HBillStatus>-1 ";


                    string sql = sql1 + sqlWhere;


                    string sql1 = "select * from h_v_Gy_QCCheckProjectList where 1=1";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Gy_QCCheckProjectList");


                }


            }


@@ -435,13 +435,59 @@




        #region 保存/编辑/删除方法




        #region 检验方案


        #region  检验方案编辑时获取表头数据


        [Route("QC_Management/MES_QC_CheckProjectListCheckDetai")]


        [HttpGet]


        public ApiResult<DataSet> MES_QC_CheckProjectListCheckDetai(string HID)


        {


            if (string.IsNullOrEmpty(HID))


                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };


            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();




            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_QCCheckProjectList_NEW  where hmainid= " + HID + " ", "h_v_Gy_QCCheckProjectList_NEW");


            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)


                return new ApiResult<DataSet> { code = -1, msg = "不存在生产汇报单号" };




            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };


        }


        #endregion




        #region 检验方案编辑时获取表体数据


        [Route("QC_Management/MES_QC_CheckProjectListProjectDetai")]


        [HttpGet]


        public object MES_QC_CheckProjectListProjectDetai(string HInterID)


        {


            DataSet ds;


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn(string.Format(@"select 次序号 HPrjNo,检验项目ID HQCCheckItemID,检验项目代码 HQCCheckItemNumber,检验项目 HQCCheckItemName,


                                                       检验标准 HQCStd,最大检验标准 HQCStdMax,检验单位 HQCUnit,表体备注 HRemark from h_v_Gy_QCCheckProjectList_NEW


                                                       where hinterid='"+HInterID+"'"), "h_v_Gy_QCCheckProjectList_NEW");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


            }


            return objJsonResult;


        }


        #endregion




        #region 检验方案保存


        /// <summary>


        /// 保存检验方案


        /// </summary>


        /// <param name="msg"></param>


        /// <returns></returns>


        [Route("SaveQCCheckProjectList")]


        [Route("QC_Management/SaveQCCheckProjectList")]


        [HttpPost]


        public object SaveQCCheckProjectList([FromBody] JObject msg)


        {


@@ -465,17 +511,17 @@


                {


                    //oItem.HMaker = "";


                    UserName = oItem.HMaker;


                    DBUtility.ClsPub.CurUserName = UserName;


                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


                    oItem.HBillType = "3302";


                    oItem.HBillSubType = "3302";


                    oItem.HBillType = "3320";


                    oItem.HBillSubType = "3320";


                    oItem.HBillStatus = 0;


                    oItem.HPeriod = 0;


                    oItem.HMaker = "";


                    oItem.HStandard = false;


                    oItem.HMainSourceInterID = oItem.HInterID;


                    oItem.HMaterTypeID = 0;


                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


                    {


@@ -518,7 +564,6 @@


                    oItemSub.HRelationQty = 0;


                    oItemSub.HRelationMoney = 0;


                    oItemSub.HCloseMan = "";


                    oItemSub.HRemark = "";


                    oBill.DetailColl.Add(oItemSub);




                }


@@ -527,7 +572,6 @@


                bool bResult;


                if (oBill.omodel.HInterID == 0)


                {


                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                }


                else


@@ -562,14 +606,90 @@


            }


        }




        #endregion




        #region  检验方案逻辑删除功能


        /// <summary>


        /// 检验方案逻辑删除功能


        /// </summary>


        /// <returns></returns>


        [Route("DeltetQCCheckProject")]


        [HttpGet]


        public object DeltetQCCheckProject(string HInterID)


        public object DeltetQCCheckProject(string HInterID,string UserName)


        {




            DBUtility.ClsPub.CurUserName = UserName;


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckProject_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "无删除权限！";


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


            lngBillKey = DBUtility.ClsPub.isLong(HInterID);


            if (lngBillKey == 0)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "单据ID为空！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            DAL.ClsGy_QCCheckProjectMain oBill = new DAL.ClsGy_QCCheckProjectMain();


            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))


            {


                if (oBill.omodel.HBillStatus > 1)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据当前处于不能删除状态,不能删除！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (oBill.omodel.HChecker != "")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据已经审核,不能删除！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                if (IsDete)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {




                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            else


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "单据未找到";


                objJsonResult.data = null;


                return objJsonResult;


            }








            DataSet ds;


            //string ModRightNameCheck = "Sc_ProcessReport_check";


            try


@@ -637,6 +757,10 @@


        }


        #endregion












        #region 来料检验


        /// <summary>


        /// 保存来料检验单