智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2023-08-15 ea265f82980af78b21ff611456bde1ab3d2bf7a9 
 WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs


@@ -7,6 +7,7 @@


using System.Net;


using System.Net.Http;


using System.Web.Http;


using ViewAPI;


using WebAPI.Models;




namespace WebAPI.Controllers.MJGL


@@ -28,8 +29,9 @@


        {


            try


            {


                Log.LogInfo("成功！"); //记录提交数据


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, true, user))


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -37,24 +39,25 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                Log.LogInfo("有权限");


                ds = Sc_GetMouldProdInHouseBill(sWhere,Organization);


                if (ds == null)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查询数据异常，请与管理员联系！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "返回记录成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }




                //if (ds.Tables[0].Rows.Count != 0 || ds != null)


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


                //objJsonResult.Message = "无数据";


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


            }


            catch (Exception ex)


            {


@@ -68,14 +71,16 @@




        public static DataSet Sc_GetMouldProdInHouseBill(string sWhere, string Organization)


        {


            LogService.Write(sWhere+";"+ Organization);


            string sql1 = string.Format(@"select * from h_v_Sc_MouldProdInHouseBillList where 库存组织='" + Organization + "'");


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


            {


                return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by 日期 desc", "h_v_Sc_MouldProdInHouseBillList");


                return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by 制单日期 desc", "h_v_Sc_MouldProdInHouseBillList");


            }


            else


            {


                string sql = sql1 + sWhere+ "order by 日期 desc";


                string sql = sql1 + sWhere+ "order by 制单日期 desc";


                Log.LogInfo(sql);


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList");


            }


        }


@@ -92,7 +97,7 @@


        public object set_DeleteBill(string HInterID,string user)


        {


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Delete", 1, true, user))


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Delete", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


@@ -139,9 +144,22 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //删除前查找当前单据的所有器具ID


                //string swhere = "";


                //DataSet ds = oCn.RunProcReturn("select HMaterID from Sc_MouldStockBillSub where HinterID=" + HInterID, "Sc_MouldStockBillSub");


                //for (var i = 0; i < ds.Tables[0].Rows.Count; i++)


                //{


                //    swhere = swhere + ds.Tables[0].Rows[i]["HMaterID"].ToString() + ",";


                //}


                //swhere = swhere.Substring(0, swhere.Length - 1);


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


                


                if (IsDete)


                {


                    //删除成功修改器具档案位置


                    //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  0,0,'{swhere}' ");


                    string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                    oCn.RunProc(sql);


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


@@ -161,7 +179,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -186,7 +204,7 @@


            try


            {


                //审核权限


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName))


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -293,7 +311,7 @@


            try


            {


                //审核权限


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName))


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -419,7 +437,7 @@


                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,


                                          批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,


                                          实收数量 HQty, 单价 HPrice, 金额 HMoney,hwhid1 HWHID, 收料仓库代码 HWHCode,收料仓库 HWHName,


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位  


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName


                                          FROM h_v_Sc_MouldProdInHouseBillList"), "h_v_Sc_MouldProdInHouseBillList");


                    


                }


@@ -430,7 +448,7 @@


                    string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,


                                          批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,


                                          实收数量 HQty, 单价 HPrice, 金额 HMoney,hwhid1 HWHID, 收料仓库代码 HWHCode,收料仓库 HWHName,


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位  


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName 


                                          FROM h_v_Sc_MouldProdInHouseBillList where 1=1");


                    string sql = sql1 + sqlWhere;


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


@@ -479,11 +497,12 @@




            string UserName = "";


            string s = "";


            long mouldid;


            ListModels oListModels = new ListModels();


            try


            {


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Edit", 1, true, msg4))


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -594,7 +613,7 @@




                    i++;


                    oItemSub.HEntryID = i;




                    mouldid = oItemSub.HMaterID;


                    //oItemSub.HRepairCheckID = 0;   //验收项目ID


                    //oItemSub.HRepairCheckContent = ""; //验收内容


                    //oItemSub.HManagerID = 0;   //负责人ID


@@ -621,10 +640,25 @@


                {


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


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


                    //修改器具档案位置


                    string sql = string.Format($"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ");


                    DataSet db = oCn.RunProcReturn(sql, "h_p_Sc_MouldChangeFileStatus");


                    if (db.Tables[0].Rows[0]["issuccess"].ToString() == "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "器具位置同步失败！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                }


                else


                {


                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                    //修改成功


                    //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  1,{oBill.omodel.HInterID.ToString()},' ' ");


                    string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                    oCn.RunProc(sql);


                }


                if (bResult)


                {


@@ -656,13 +690,13 @@


        #endregion




        #region 器具采购入库单审核/反审核


        [Route("Sc_MouldProdInHouseBill/AuditMouldProdInHouseBill")]


        [Route("Sc_MouldProdInHouseBill/AuditMouldProdInHouseBills")]


        [HttpGet]


        public object AuditMouldProdInHouseBill(string HInterID, string user, int flag)


        public object AuditMouldProdInHouseBills(string HInterID, string user, int flag)


        {


            //flag=1 审核；  flag=2 反审核


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, true, user))


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;