智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2024-05-17 8c948b413969f5b1acbe03c7cd46def09ccbf335 
 WebAPI/Controllers/Sc_MouldRepairInBillListController.cs


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


        {


            try


            {


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


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


                {


                    objJsonResult.code = "0";


@@ -436,12 +437,21 @@




                ds = Sc_MouldMaintainPlanBillList_s(sWhere);




                //添加列名


                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


@@ -1013,13 +1023,24 @@




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




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


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


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


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






                    oBill.DetailColl.Add(oItemSub);




                }




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                //保存


                //保存完毕后处理


                bool bResult;


@@ -1163,12 +1184,20 @@


                    return objJsonResult;


                }




                //进行 会计期间 结账 的判断和控制


                string s = "";


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Kf_ICStockBillMain";


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








                //Type 1 审核  2  反审核


                if (Type == 1)


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


        }


        #endregion






        #region 调拨单列表


        #region 直接调拨单列表


        /// <summary>


        /// 调拨单列表


        /// </summary>


@@ -1589,7 +1617,7 @@


        }


        #endregion




        #region 调拨单  删除


        #region 直接调拨单  删除


        [Route("Kf_MoveStockBill/DelteteGetMoveStockBill")]


        [HttpGet]


        public object DelteteGetMoveStockBill(string HInterID, string user)


@@ -1631,7 +1659,21 @@


                }


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




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                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 +1712,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();


@@ -1793,10 +1872,23 @@


                }


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




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                oCN.BeginTran();


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


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


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




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


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






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


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


@@ -1997,6 +2089,17 @@


                    oBill.DetailColl.Add(oItemSub);




                }




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                //保存


                //保存完毕后处理


                bool bResult;


@@ -2201,6 +2304,17 @@


                }


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




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }






                oCN.BeginTran();


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


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


@@ -2306,6 +2420,17 @@


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //进行 会计期间 结账 的判断和控制


                string s = "";


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




@@ -2955,6 +3080,17 @@


                    oBill.DetailColl.Add(oItemSub);




                }




                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                //保存


                //保存完毕后处理


                bool bResult;


@@ -3098,6 +3234,16 @@


                    return objJsonResult;


                }




                //进行 会计期间 结账 的判断和控制


                string s = "";


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                ClsPub.CurUserName = user;


                BillOld.MvarItemKey = "Kf_ICStockBillMain";


@@ -3614,7 +3760,15 @@


                }


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






                //进行 会计期间 结账 的判断和控制


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                oCN.BeginTran();




@@ -5754,7 +5908,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 


@@ -5767,7 +5921,7 @@


                objJsonResult.code = "0";


                objJsonResult.count = 1;


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


                objJsonResult.data = null;


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = list;




            }


@@ -6089,8 +6243,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


@@ -6103,7 +6256,7 @@


                objJsonResult.code = "0";


                objJsonResult.count = 1;


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


                objJsonResult.data = null;


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = list;


            }


            catch (Exception e)


@@ -6201,7 +6354,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 模具报废入库单