智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
2023-06-26 8106da5b9d9b0b598960dea5437913105db72ae2 
 WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs


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


using System.Data;


using System.Data.SqlClient;


using System.Web.Http;


using System.Windows.Forms;


using WebAPI.Models;




namespace WebAPI.Controllers


@@ -19,6 +20,7 @@


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


        DataSet ds;


        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();


              




        #region[新增单据-保存按钮]


        /// <summary>


@@ -37,6 +39,7 @@


            string msg3 = sArray[1].ToString();


            string msg4 = sArray[2].ToString();


            string msg5 = sArray[3].ToString();


            string HComputerName = SystemInformation.ComputerName; //设备名称    




            string UserName = "";


            ListModels oListModels = new ListModels();


@@ -98,12 +101,18 @@


                bool bResult;


                if (msg5 == "xz")


                {


                    LogService.Write("用户:" + msg4 + ",日期:" + DateTime.Now + ",新增工序流转卡单据:" + oBill.omodel.HBillNo);


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


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




                    oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "新增工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);


                }


                else


                {


                    LogService.Write("用户:" + msg4 + ",日期:" + DateTime.Now + ",修改工序流转卡单据:" + oBill.omodel.HBillNo);


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




                    oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "修改工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);


                }


                if (bResult)


                {


@@ -391,6 +400,7 @@


            string msg3 = sArray[1].ToString();


            string msg4 = sArray[2].ToString();


            string msg5 = sArray[3].ToString();


            string HComputerName = SystemInformation.ComputerName; //设备名称    




            string UserName = "";


            ListModels oListModels = new ListModels();


@@ -458,6 +468,8 @@




                        //保存完毕后处理


                        bool bResult;


                        LogService.Write("用户:" + msg4 + ",日期:" + DateTime.Now + ",新增工序流转卡单据:" + oBill.omodel.HBillNo);


                        oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "新增工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);




                        bResult = oBill.AddBill(ref sReturn);


                        if (bResult)


@@ -505,6 +517,7 @@


            string msg4 = sArray[2].ToString();//工艺路线


            string msg5 = sArray[3].ToString();//类型


            string msg6 = sArray[4].ToString();//用户


            string HComputerName = SystemInformation.ComputerName; //设备名称    




            ListModels oListModels = new ListModels();




@@ -578,6 +591,9 @@


                    bool bResult=false;


                    if (msg5 == "2")


                    {


                        LogService.Write("用户:" + msg6 + ",日期:" + DateTime.Now + ",新增工序流转卡单据:" + oBill.omodel.HBillNo);


                        oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg6 + "','" + HComputerName + "','" + "新增工序流转卡单据：" + oBill.omodel.HBillNo + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);




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


                    }


                    oBill.DetailColl.Clear();


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


                                                工作中心 HCenterName,HSupID,供应商代码 HSupNumber,供应商 HSupName,isEntrust HSupFlag,计划数量 HQty,加工单价 HOutPrice, 表体备注 HRemark,


                                            进站关联数量 HRelationQty_In,出站关联数量 HRelationQty_Out,委外工单数量 HRelationQty_WWOrder,不合格数量 HRelationQty_Bad,超额比例 HOverRate,


                                            良率 HPassRate,累计良率 HSumPassRate,图纸编号 HPicNum,本工序确认记录 HProcCheckNote,工艺参数 HTechnologyParameter,HDeptID,


                                            加工车间代码 HDeptNumber,加工车间 HDeptName


                                            加工车间代码 HDeptNumber,加工车间 HDeptName,出站报废关联数量 HRelationQty_OutBad


                                            from h_v_Sc_ProcessExchangeBillQuerySub");


                ds = oCN.RunProcReturn(sql+ " where hmainid="+ HInterID + "  order by cast(流水号 as int) ", "h_v_Sc_ProcessExchangeBillQuerySub");


                objJsonResult.code = "0";


@@ -824,9 +840,13 @@


                return objJsonResult;


            }




            string HComputerName = SystemInformation.ComputerName; //设备名称    




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




            string[] HBillNo = HInterID.Split(',');




            string HBillNo_S = "";




            foreach (var item in HBillNo)


            {


@@ -886,6 +906,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        objJsonResult.code = "0";


@@ -894,6 +915,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    HBillNo_S += oBill.omodel.HBillNo + ",";


                }


                else


                {


@@ -904,6 +926,12 @@


                    return objJsonResult;


                }


            }




            HBillNo_S = HBillNo_S.Substring(0, HBillNo_S.Length - 1);


            LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",删除工序流转卡单据:" + HBillNo_S);




            oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "删除工序流转卡单据：" + HBillNo_S + "','LMES-工序流转卡模块','" + DBUtility.ClsPub.IPAddress + "','删除单据'", ref DBUtility.ClsPub.sExeReturnInfo);




            foreach (var item in HBillNo)


            {


                bool IsDete = oBill.DeleteBill(long.Parse(item), ref DBUtility.ClsPub.sExeReturnInfo);


@@ -916,6 +944,17 @@


                    return objJsonResult;


                }


            }




            if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺")


            {


                ds = oCN.RunProcReturn("select  * from Sc_ProcessExchangeBillMain where HICMOInterID='" + oBill.omodel.HICMOInterID + "' and HICMOEntryID='" + oBill.omodel.HICMOEntryID + "'", "Sc_ProcessExchangeBillMain");




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


                {


                    oCN.RunProc("update AIS20220308151944..T_PRD_MOENTRY  set F_BSV_TEXT2 = '否' where  FID='" + oBill.omodel.HICMOInterID + "' and FENTRYID='" + oBill.omodel.HICMOEntryID + "'");


                }


            }




            objJsonResult.code = "0";


            objJsonResult.count = 1;


            objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;