智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2024-05-27 918f9175edd2d64cb0f9fb459f987e3cbee3ea38 
 WebAPI/Controllers/Sc_MouldRepairInBillListController.cs


@@ -1013,8 +1013,8 @@




                    oItemSub.HCloseType = false;   //关闭类型




                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceInterID = 0;     // 源单主内码


                    //oItemSub.HSourceEntryID = 0;   //源单子内码






                    oBill.DetailColl.Add(oItemSub);


@@ -1065,7 +1065,7 @@


        }


        #endregion




        #region 其他入库单 编辑页面初始化


        #region 直接调拨单 编辑页面初始化


        [Route("Kf_MoveStockBill/Kf_MoveStockBillEdit")]


        [HttpGet]


        public object Kf_MoveStockBillEdit(long HInterID)


@@ -1105,7 +1105,7 @@


        }


        #endregion




        #region 其它入库单审核/反审核功能


        #region 直接调拨单 审核/反审核功能


        [Route("Kf_MoveStockBill/CheckKf_MoveStockBill")]


        [HttpGet]


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


@@ -1303,7 +1303,7 @@


        }


        #endregion




        #region 其它入库单关闭/反关闭功能


        #region 直接调拨单 关闭/反关闭功能


        [Route("Kf_MoveStockBill/CloseKf_MoveStockBill")]


        [HttpGet]


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


@@ -1409,7 +1409,7 @@


        }


        #endregion




        #region 其他入库单 作废/反作废功能


        #region 直接调拨单 作废/反作废功能


        [Route("Kf_MoveStockBill/DropKf_MoveStockBill")]


        [HttpGet]


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


@@ -1539,8 +1539,7 @@


        }


        #endregion






        #region 调拨单列表


        #region 直接调拨单列表


        /// <summary>


        /// 调拨单列表


        /// </summary>


@@ -1589,7 +1588,7 @@


        }


        #endregion




        #region 调拨单  删除


        #region 直接调拨单  删除


        [Route("Kf_MoveStockBill/DelteteGetMoveStockBill")]


        [HttpGet]


        public object DelteteGetMoveStockBill(string HInterID, string user)


@@ -1632,6 +1631,10 @@


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




                oCN.BeginTran();




                //直接调拨单 删除  撤销 回填  调拨申请单  关联数量


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




                oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);


                oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);




@@ -1670,6 +1673,43 @@


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 直接调拨单  根据主内码与子内码获取调拨申请单数据


        [Route("Kf_MoveStockBill/loadKf_MoveStockBillMain_Push")]


        [HttpGet]


        public object loadKf_MoveStockBillMain_Push(long HInterID, long HSubID)


        {


            try


            {




                ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockRequestBillList_Litee where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_MoveStockRequestBillList_Litee");


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "未查询到源单信息！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    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();


@@ -1796,13 +1836,17 @@




                oCN.BeginTran();


                //销售出库删除回填销售订单关联数量


                //oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + HInterID);


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




                //oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);


                //oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);


                //销售出库删除回填收货通知单关联数量


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




                string sql = "exec h_p_WMS_ICStockBillAndWMS_Delete " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','1205'";


                oCn.RunProc(sql);




                oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);


                oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);




                //string sql = "exec h_p_WMS_ICStockBillAndWMS_Delete " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','1205'";


                //oCn.RunProc(sql);




                //删除后控制==================================================================================      


                string sql2 = "exec h_p_Kf_SellOutBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


@@ -2789,57 +2833,6 @@


        }


        #endregion








        /// <summary>


        /// 产品入库单列表


        /// </summary>


        /// <returns></returns>


        [Route("Kf_ProductInBill/GetProductInBill")]


        [HttpGet]


        public object GetProductInBill(string sWhere,string user)


        {


            try


            {


                //判断是否有查询权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }






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


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where 1=1  order by hmainid desc", "h_v_IF_ProductInBillList");


                }


                else


                {


                    string sql = "select * from h_v_IF_ProductInBillList where 1 = 1 " + sWhere + " order by hmainid desc";


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


                }




             


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


               


            }


            catch (Exception ex)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        #region 条码明细


        [Route("Kf_ICStockBillSub_WMS/Kf_ICStockBillSub_WMS_List")]


        [HttpGet]


@@ -2864,392 +2857,6 @@


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        /// <summary>


        ///产品入库单删除功能


        /// </summary>


        /// <returns></returns>


        [Route("Kf_ProductInBill/DeltetProductInBill")]


        [HttpGet]


        public object DeltetProductInBill(string HInterID)


        {


            try


            {


                oCN.BeginTran();


                oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);


                oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);


                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "删除成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        #region 生产入库单审核/反审核功能


        [Route("Kf_ProductInBill/CheckKf_ProductInBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (string.IsNullOrWhiteSpace(HInterID))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Kf_ICStockBillMain";


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




                //Type 1 审核  2  反审核


                if (Type == 1)


                {


                    //判断单据是否已经审核


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已审核!不需要再审核!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //审核单据


                    if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    //判断单据是否已经反审核


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //反审核单据


                    if (BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();


                        //DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl");


                        ////if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0)


                        ////{


                        ////    objJsonResult.code = "0";


                        ////    objJsonResult.count = 1;


                        ////    objJsonResult.Message = "该任务单已下推流转卡，不允许反审核" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]);


                        ////    objJsonResult.data = null;


                        ////    return objJsonResult;


                        ////}


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




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




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                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




        #region 生产入库单关闭/反关闭功能


        [Route("Kf_ProductInBill/CloseKf_ProductInBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有删除权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无权限关闭!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (string.IsNullOrWhiteSpace(HInterID))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Kf_ICStockBillMain";


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




                //Type 1 关闭  2  反关闭


                if (Type == 1)


                {


                    //判断单据是否已经关闭


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


                        if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已关闭!不需要再关闭!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //关闭单据


                    if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    //判断单据是否已经反关闭


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已反关闭!不需要再反关闭!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //反关闭单据


                    if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




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




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                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




        #region 生产入库单 作废/反作废功能


        [Route("Kf_ProductInBill/DropKf_ProductInBill")]


        [HttpGet]


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


        {


            try


            {


                //判断是否有作废权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无权限作废!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (string.IsNullOrWhiteSpace(HInterID))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Kf_ICStockBillMain";


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




                //Type 1 作废  2  反作废


                if (Type == 1)


                {


                    //判断单据是否已经作废


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据不存在！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已审核!不能进行作废!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已作废!不需要再作废!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //作废单据


                        if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                }


                else


                {


                    //判断单据是否已经反作废


                    DataSet ds;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


                    {


                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已审核!不能进行作废!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据未作废!不需要再反作废!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反作废单据


                        if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                }




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




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                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;


            }


@@ -6191,7 +5798,7 @@


            {


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


                //获取点检项目编辑数据


                ds = oCN.RunProcReturn("select HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckBillSub a left join Gy_Employee e on a.HManagerID=e.HItemID where 1=1 " + sqlWhere, "Sc_MouldDotCheckBillSub");


                ds = oCN.RunProcReturn("select * from h_v_Sc_MouldDotCheckBill_Edit where 1=1 " + sqlWhere, "h_v_Sc_MouldDotCheckBill_Edit");


                //获取配件项目编辑数据


                ds1 = oCN.RunProcReturn(@"select b.HMaterID,  mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID


                    ,u2.hnumber HUnitNumber,u2.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark 


@@ -6204,7 +5811,7 @@


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.data = null;


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = list;




            }


@@ -6526,8 +6133,7 @@


            {


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


                //获取点检项目编辑数据


                ds = oCN.RunProcReturn(@"select a.HDotCheckItemID,HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckPlanBillSub a 


                  left join Gy_Employee e on a.HManagerID=e.HItemID


                ds = oCN.RunProcReturn(@"select * from h_v_Sc_MouldDotCheckPlanBill_Edit


                        where 1=1 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub");


                ////获取配件项目编辑数据


                //ds1 = oCN.RunProcReturn(@"select b.HMaterID,  mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID


@@ -6540,7 +6146,7 @@


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.data = null;


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = list;


            }


            catch (Exception e)


@@ -6638,7 +6244,48 @@




        #endregion






        #region 根据器具条码查找器具档案信息PDA


        [Route("QJ_PDA_MouldDotCheckBill/txtHBarCode_KeyDown")]


        [HttpGet]


        public object txtHBarCode_KeyDown(string HBarCode)


        {


            try


            {


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //得到信息


                ds = oCN.RunProcReturn("select top 1 * from Gy_MouldFileMain  where HNumber= '" + HBarCode + "'", "Gy_MouldFileMain");


                //写入信息


                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 模具报废入库单