智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
zrg
2026-04-08 66f365ce763f761a5baec453347a4c16178d1713 
 WebAPI/Controllers/Sc_MouldRepairInBillListController.cs


@@ -768,15 +768,15 @@


        {


            try


            {




                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);




                string HBeginDate = dic["HBeginDate"].ToString();//开始日期


                string HEndDate = dic["HEndDate"].ToString();//结束日期


                string HMouldNo = dic["HMouldNo"].ToString();//模具编码


                string HName = dic["HName"].ToString();//模具名称




                ds = oCN.RunProcReturn("exec h_P_Sc_MouldLifeUsePicReport '" + HBeginDate + "'," + HEndDate + ",'" + HMouldNo + "','" + HName + "'", "h_P_Sc_MouldLifeUsePicReport");


                LogService.Write("exec h_P_Sc_MouldLifeUsePicReport '" + HBeginDate + "','" + HEndDate + "','" + HMouldNo + "','" + HName + "'");




                ds = oCN.RunProcReturn("exec h_P_Sc_MouldLifeUsePicReport '" + HBeginDate + "','" + HEndDate + "','" + HMouldNo + "','" + HName + "'", "h_P_Sc_MouldLifeUsePicReport");


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


                //添加列名


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


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


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


                //}


            }


            catch (Exception e)


            {


@@ -1449,7 +1448,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        oCN.RollBack();


@@ -1459,7 +1458,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        oCN.RollBack();


@@ -1472,7 +1471,7 @@


                    if (!oBill.CheckBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_MoveStockBill_AfterCheckCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -1503,7 +1502,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -1512,7 +1511,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -1527,7 +1526,7 @@


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -1784,6 +1783,62 @@


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "执行失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 直接调拨单列表分页列表


        [Route("Kf_MoveStockBill/page")]


        [HttpGet]


        public json Sc_MouldProdOutBillPage(string sWhere, string user, int page, int size, string Type)


        {


            try


            {


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


                //列表进入时判断权限，选源单进入不判断权限




                if (!DBUtility.ClsPub.Security_Log("Kf_MoveStockBillQuery", 3, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "您没有该模块权限,请与管理员联系！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }






                sWhere = sWhere.Replace("'", "''");


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


                {


                    ds = oCn.RunProcReturn("exec h_p_IF_MoveStockBillList " + page + "," + size + ",'','" + Type + "'", "h_p_IF_MoveStockBillList");


                }


                else


                {


                    ds = oCn.RunProcReturn("exec h_p_IF_MoveStockBillList " + page + "," + size + ",'" + sWhere + "','" + Type + "'", "h_p_IF_MoveStockBillList");


                }




                //添加列名


                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列对象的列名


                }




                objJsonResult.code = "0";


                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());


                objJsonResult.Message = "成功！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "查询列表信息失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -6058,6 +6113,7 @@


            ListModels oListModels = new ListModels();


            try


            {


                string sErrMsg = "";


                if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


@@ -6083,6 +6139,17 @@


                    //oItem.HInnerBillNo = "";  //  --内部单据号


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


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


                   if(oSystemParameter.ShowBill(ref sErrMsg) == true)


                   {


                        // if(oSystemParameter.omodel.WMS_CampanyName == "华舟")


                        // {


                        //     oItem.HRepairManID = oItem.HEmpID;


                        // }else


                        // {


                            oItem.HRepairManID = 0;


                        // }


                   }


                    


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


                    {


                        objJsonResult.code = "0";


@@ -6290,19 +6357,20 @@


                //==================================================================================  




                bool IsDete = oBill.DeleteBill(lngBillKey, oBill.omodel.HBillNo, "h_p_Sc_MouldConkBookBill_AfterDelCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo);


                if (IsDete)




                var oDelDs = oCn.RunProcReturn($"exec h_p_Sc_MouldConkBookBill_AfterDelCtrl {lngBillKey},{oBill.omodel.HBillNo}, {user}, {oBill.omodel.HMouldID}", "h_p_Sc_MouldConkBookBill_AfterDelCtrl");


                if (!IsDete || oDelDs == null)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.count = 0;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {




                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


@@ -9463,6 +9531,7 @@


        public object CheckSc_MouldDotCheckPlanBill(string HInterID, int Type, string user)


        {


            DAL.ClsSc_MouldDotCheckPlanBill BillOld = new DAL.ClsSc_MouldDotCheckPlanBill();


            oCN.BeginTran();//开始事务


            try


            {


                //判断是否有审核权限


@@ -9472,6 +9541,7 @@


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无权限审核!";


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }




@@ -9481,11 +9551,11 @@


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                oCN.BeginTran();//开始事务




                //查看是否已审核,关闭,作废


                if (BillOld.ShowBill(Convert.ToInt32(HInterID), ref DBUtility.ClsPub.sExeReturnInfo))


@@ -9496,6 +9566,7 @@


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据已关闭!不能再次审核！";


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;


                    }


                    if (BillOld.omodel.HDeleteMan.Trim() != "")


@@ -9504,6 +9575,7 @@


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据已作废!不能再次审核！";


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;


                    }


                    if (Type == 1)  //审核判断


@@ -9514,6 +9586,7 @@


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已审核!不能再次审核！";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


                    }


@@ -9525,6 +9598,7 @@


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据未审核!不需要反审核!";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


                    }


@@ -9535,6 +9609,7 @@


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }




@@ -9547,7 +9622,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        oCN.RollBack();


@@ -9557,7 +9632,7 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        oCN.RollBack();


@@ -9568,14 +9643,12 @@


                    if (!BillOld.CheckBill(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sc_MouldDotCheckPlanBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;


                    }




                    //自动生成点检计划单


                    oCN.RunProc("exec h_p_Sc_MouldDotCheckPlan_Auto " + HInterID);


                }


                else


                {


@@ -9585,18 +9658,20 @@


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;




                    }


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;


                    }


                    //===========================================================         


@@ -9604,14 +9679,20 @@


                    if (!BillOld.AbandonCheck(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sc_MouldDotCheckPlanBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        oCN.RollBack();


                        return objJsonResult;


                    }                    


                }




                oCN.Commit();//提交事务


                if (Type == 1)


                {


                    // 在提交事务后再尝试生成器具点检计划单 预防死锁


                    oCN.RunProc("exec h_p_Sc_MouldDotCheckPlan_Auto " + HInterID);


                }




                objJsonResult.code = "0";


                objJsonResult.count = 1;


@@ -9622,6 +9703,7 @@


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "执行失败！" + e.ToString();