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


@@ -1030,6 +1030,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;


@@ -1173,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)


@@ -1225,6 +1244,8 @@


                    }


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




                    //更新及时库存表   减少调入库存,增加调出库存


                    ds = oCN.RunProcReturn("exec h_KF_UPDateICinventory_Move  '"+ oBill.omodel.HInterID + "','"+ oBill.omodel.HBillType+ "','1'", "h_KF_UPDateICinventory_Move");




                    //审核单据


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


@@ -1277,6 +1298,8 @@


                    }


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




                    //更新及时库存表   增加调入库存,减少调出库存


                    ds = oCN.RunProcReturn("exec h_KF_UPDateICinventory_Move  '" + oBill.omodel.HInterID + "','" + oBill.omodel.HBillType + "','2'", "h_KF_UPDateICinventory_Move");




                    //反审核单据


                    if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_MoveStockBill_AfterUnCheckCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


@@ -1640,6 +1663,16 @@


                }


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




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


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




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


@@ -1843,6 +1876,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();


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


@@ -2051,6 +2093,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;


@@ -2255,6 +2308,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);


@@ -2360,6 +2424,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;


                }




@@ -3009,6 +3084,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;


@@ -3152,6 +3238,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";


@@ -3204,7 +3300,6 @@


                    }


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




               


                    //审核单据


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


                    {


@@ -3255,7 +3350,6 @@


                        return objJsonResult;


                    }


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






                    //反审核单据


                    if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_ICStockBill_AfterUnCheckCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


@@ -3668,7 +3762,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();




@@ -4496,7 +4598,7 @@


                {




                    //ds = oCN.RunProcReturn("select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark   from Sc_MouldRepairCheckBillSub", "Sc_MouldRepairCheckBillSub");


                    ds = oCN.RunProcReturn("select  HRepairCheckID,验收项目代码 HRepairCheckCode,验收项目 HRepairCheckName,验收内容 HRepairCheckContent,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldRepairCheckBillList_Edit", "h_v_Sc_MouldRepairCheckBillList_Edit");


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




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


@@ -4507,7 +4609,7 @@


                {




                    //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark  from Sc_MouldRepairCheckBillSub where 1 = 1 ";


                    string sql1 = "select  HRepairCheckID,验收项目代码 HRepairCheckCode,验收项目 HRepairCheckName,验收内容 HRepairCheckContent,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 ";


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


                    string sql = sql1 + sqlWhere;


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




@@ -4935,6 +5037,7 @@




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


                List<Model.ClsSc_MouldMaintainPlanBillMain> lsmain = new List<Model.ClsSc_MouldMaintainPlanBillMain>();




                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Gy_MouldMaintainPlanBillMain(msg2);


@@ -4944,6 +5047,8 @@


                    UserName = oItem.HMaker;  //制单人


                    oItem.HBillType = "3818";


                    oItem.HBillSubType = "3818";


                    oItem.HMainSourceInterID = oItem.HMouldMaintainRuleID;


                    oItem.HMainSourceBillNo = oItem.HMouldMaintainRuleNo;




                    //oItem.HInterID =0;


                    //oItem.HBillNo = "";


@@ -6499,6 +6604,124 @@


        }


        #endregion




        #region 器具点检计划单审核/反审核功能


        [Route("Sc_MouldDotCheckPlanBill/CheckSc_MouldDotCheckPlanBill")]


        [HttpGet]


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


        {


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


            try


            {


                //判断是否有审核权限


                if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckPlanBill_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;


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




                //Type 1 审核  2  反审核


                if (Type == 1)


                {


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //自动生成点检计划单


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


                }


                else


                {


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


                    {


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


                    }


                    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("Sc_MouldDotCheckPlanBill/GetPlanList")]


        [HttpGet]


        public object GetPlanList_Check(string sqlWhere)


        {


            DataSet ds;


            try


            {


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


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


                {


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                }


                else


                {


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


                    string sql = sql1 + sqlWhere;


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何计划！" + e.ToString();


                objJsonResult.data = null;


            }


            return objJsonResult;


        }


        #endregion




        #endregion