智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-04-27 be02cd78719168e0717b9e4f1df0db580d5eaa16 
 WebAPI/Controllers/CJGL/Cj_StationInBillController.cs


@@ -1,4 +1,5 @@


using Newtonsoft.Json.Linq;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using Pub_Class;


using System;


using System.Collections;


@@ -71,8 +72,8 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                long HProcNo = list[0].HProcNo;//流水号


                if (HProcNo <= 0)


                string HProcNo = list[0].HProcNo;//流水号


                if (HProcNo == "")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -94,7 +95,7 @@


                long HInterID = list[0].HInterID;//递入type得到的单据ID


                string HBillNo = list[0].HBillNo;//递入type得到的单据号


                int HBillStatus = 0;


                string HMaker = list[0].HMaker;//制单人


                string HMaker = user;//制单人


                int HYear = 2021;


                double HPeriod = 1;


                string HRemark = list[0].HRemark;//备注


@@ -122,6 +123,7 @@


                string HSourceName = list[0].HSourceName;//生产资源名称


                long HCenterID = list[0].HCenterID;//工作中心ID


                string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号


                long HPRDOrgID = list[0].HPRDOrgID;//组织ID


                //单据完整性判断


                if (HMaterID <= 0)


                {


@@ -188,7 +190,7 @@


                    ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" +


                    ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +


                    ",HSupID,HQty,HPrice,HMoney,HPieceQty,HSourceName,HCenterID" +


                    ",HProcNo,HOrderProcNO,HMainInterID" +


                    ",HProcNo,HOrderProcNO,HMainInterID,HPRDOrgID" +


                    ") " +


                    " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" +


                    "," + HYear + "," + HPeriod + ",'" + HRemark + "'" +


@@ -196,7 +198,7 @@


                    ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID +


                    "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +


                    "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + ",'" + HSourceName + "'," + HCenterID +


                    ",'" + HProcNo + "','" + HOrderProcNO + "'," + HMainInterID +


                    ",'" + HProcNo + "','" + HOrderProcNO + "','" + HMainInterID + "'," + HPRDOrgID +


                    ") ");


                }


                else if ("Modify".Equals(eventType))


@@ -377,6 +379,51 @@


        #endregion






        #region 工序进站接收单流水号回车获取工序信息


        [Route("Cj_StationInBill/txtHProcNo_KeyDown_qiaoyi")]


        [HttpGet]


        public object txtHProcNo_KeyDown_qiaoyi(string sBillNo, string sProcNo)


        {


            try


            {


                if (sBillNo.Equals("") || sProcNo.Equals(""))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条形码不能为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //得到信息（委外标记为0时，流转标记为1时）


                ds = oCN.RunProcReturn("select top 2 * from h_v_Sc_ProcessExchangeBillList  where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=0 and 流转标记=1  and cast(工序号 as int)<='" + sProcNo + "' order by cast(工序号 as int) desc", "h_v_Sc_ProcessExchangeBillList");


                //Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList  where 单据号= '" + sBillNo + "' and 工序号='" + sProcNo + "' and 委外标记=0 and 流转标记=1 ", "h_v_Sc_ProcessExchangeBillList");


                //写入信息


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "工序号错误或者当前工序号不允许进站，请重新输入！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion








        #region 工序进站接收单根据职员代码模糊回车查询


@@ -461,6 +508,7 @@


        {


            try


            {


                List<object> columnNameList = new List<object>();


                //判断是否有查询权限


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


                {


@@ -482,12 +530,21 @@


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


                }




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




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


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


                //}


                //else


@@ -955,6 +1012,17 @@


                        return objJsonResult;


                    }




                    ds = oCn.RunProcReturn($"exec h_p_DelOutInBill {HInterID},'MES_StationInBill_DeleteRelationCtl'", "h_p_DelOutInBill");




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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "系统参数控制,已有下道工序,不能删除！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    //写入删除日志 


                    string WorkList = "删除进站单：" + oBill.omodel.HBillNo;


                    if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HProcExchInterID, oBill.omodel.HProcExchEntryID, ref DBUtility.ClsPub.sExeReturnInfo))


@@ -1030,5 +1098,61 @@


            }


        }


        #endregion




        #region 返回用户获取默认值列表


        [Route("Cj_StationInBill/GetDefValByUser")]


        [HttpGet]


        public object GetDefValByUser(string Czybm, string Czymc)


        {


            try


            {


                ////判断是否有查询权限


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


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "无查询权限!";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}




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


                {


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


                }


                else


                {


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


                    string sql = sql1 + " and 用户编码 ='" + Czybm + "' and 用户名称 ='" + Czymc + "'";


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


                }




                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 e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


    }


}