派生自 MES-WEB-API
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2022-05-30 8f24e47d5d9e2f292bf98fa448378658e0d3f58a 
 WebAPI/Controllers/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Sc_MESBeginStepWorkBillController.cs


@@ -41,7 +41,7 @@




        [Route("Sc_MESBeginStepWorkBill/GetMESBeginStepWorkBill")]


        [HttpGet]


        public object GetMESBeginStepWorkBill(string sWhere,string user)


        public object GetMESBeginStepWorkBill(string sWhere, string user)


        {


            try


            {


@@ -84,7 +84,7 @@


            {


                LogService.Write("执行了1");


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


                string sql = sql1 + sWhere+ " order by hmainid desc ";


                string sql = sql1 + sWhere + " order by hmainid desc ";


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


            }




@@ -802,7 +802,7 @@


                    oItemSub.HOtherItem4 = "";


                    oItemSub.HOtherItem5 = "";


                    oItemSub.HPackType = "";


                    oItemSub.HBatchNo="";


                    oItemSub.HBatchNo = "";


                    //oItemSub.HRelationMoney = 0;   //关联金额


                    //oItemSub.HRepairID = 0;       //维修项目


                    //oItemSub.HRepairExplanation ="";   //维修要求


@@ -1028,7 +1028,7 @@




                oCN.BeginTran();


                //删除工序汇报子表


                string sql1 = string.Format(@"delete Sc_ProcessReportSub  where HInterID='"+HInterID+"' and   HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'");


                string sql1 = string.Format(@"delete Sc_ProcessReportSub  where HInterID='" + HInterID + "' and   HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'");


                oCN.RunProc(sql1);


                //删除工序汇报主表


                string sql = string.Format(@"delete Sc_ProcessReportMain  where HInterID='" + HInterID + "'");


@@ -1057,7 +1057,7 @@


        #region æŠ¥å·¥å¹³å°æŠ¥æ£€ç”³è¯·ä¿å­˜


        [Route("Sc_MESBeginStepWorkBill/SaveGetMESProductReportBillList")]


        [HttpGet]


        public object SaveGetMESProductReportBillList(string ScMaxWork, string HSourceBillType, string workcode, int HSourceID, int HICMOInterID, int HICMOEntryID, string HMaker, string Czybm,string HProcID)


        public object SaveGetMESProductReportBillList(string ScMaxWork, string HSourceBillType, string workcode, int HSourceID, int HICMOInterID, int HICMOEntryID, string HMaker, string Czybm, string HProcID)


        {


            ListModels oListModels = new ListModels();


            try


@@ -1125,7 +1125,7 @@


                //model.HPRDORGID = DBUtility.ClsPub.isLong(ds0.Tables[0].Rows[0]["HPRDORGID"]);


                model.HMainSourceInterID = HICMOInterID;


                model.HMainSourceEntryID = HICMOEntryID;


                






                //oWebs.Timeout = 30000;


                bool flag = oWebs.set_SaveICMOProductReportBill_LayuiYqn(model, workcode, HSourceID, sHSourceType, HProcID, ref DBUtility.ClsPub.sErrInfo);


@@ -1182,7 +1182,7 @@


            try


            {


                //判断是否有编辑权限


                if (!DBUtility.ClsPub.Security_Log("MES_ProcExchReport_Edit",1,false,user))


                if (!DBUtility.ClsPub.Security_Log("MES_ProcExchReport_Edit", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -1467,7 +1467,7 @@


            try


            {


                //根据选择资源ID获取当前生产工单、责任人


                ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where convert(varchar(50),hmainid)+'-'+convert(varchar(50),HEntryID)='" + sBillBarCode + "'", "h_v_IF_ICMOBillList");


                ds = oCN.RunProcReturn("select f1.F_YQN_XSDD é”€å”®è®¢å•ç¼–号, f1.F_zzzz_Text4 é”€å”®ç‰©æ–™åç§°,* from h_v_IF_ICMOBillList a left join AIS20200908101915zs..T_PRD_MOENTRY f1 on a.HERPEntryID=f1.FENTRYID where convert(varchar(50),a.hmainid)+'-'+convert(varchar(50),a.HEntryID)='" + sBillBarCode + "'", "h_v_IF_ICMOBillList");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "1";


@@ -1585,35 +1585,38 @@


                if (oBill.omodel.HInterID == 0)


                {


                    oCN.BeginTran();


                    //修改金蝶生产单的状态


                    oCN.RunProc("update AIS20200908101915zs..T_PRD_MOENTRY_A set FSTATUS=4,FPLANCONFIRMDATE=getdate() where FENTRYID=" + (EntyID).Split('-')[1]);


                    //访问金蝶


                    var loginRet = InvokeHelper.Login();


                    var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                    if (isSuccess == 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "操作失败,金蝶账号登录异常。" + loginRet;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    var json = new


                    {


                        //CreateOrgId = 0,


                        Numbers = BillNo,


                        Ids = (EntyID).Split('-')[0],


                        PkEntryIds = (EntyID).Split('-')[1]


                    };


                    var result = InvokeHelper.ExcuteOperation("PRD_MO", "ToStart", JsonConvert.SerializeObject(json));


                    if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "对应金蝶云生产订单更改开工状态失败！" + result;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //执行保存


                    //var loginRet = InvokeHelper.Login();


                    //var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                    //if (isSuccess == 0)


                    //{


                    //    objJsonResult.code = "0";


                    //    objJsonResult.count = 0;


                    //    objJsonResult.Message = "操作失败,金蝶账号登录异常。" + loginRet;


                    //    objJsonResult.data = null;


                    //    return objJsonResult;


                    //}


                    //var json = new


                    //{


                    //    //CreateOrgId = 0,


                    //    Numbers = BillNo,


                    //    //Ids = (EntyID).Split('-')[0],


                    //    PkEntryIds = (EntyID).Split('-')[1]


                    //};


                    //Console.Write("json=" + json);


                    //var result = InvokeHelper.ExcuteOperation("PRD_MO", "ToStart", JsonConvert.SerializeObject(json));


                    //if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")


                    //{


                    //    oCN.RollBack();


                    //    objJsonResult.code = "0";


                    //    objJsonResult.count = 0;


                    //    objJsonResult.Message = "对应金蝶云生产订单更改开工状态失败！" + result;


                    //    objJsonResult.data = null;


                    //    return objJsonResult;


                    //}


                    ////执行保存


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


                    if (bResult)


                    {


@@ -1652,4 +1655,4 @@


        }


        #endregion


    }


}


}