注释联系单会计合理判断

wtt

2024-06-11 3f42797486d817c0ff03cd8bb6729bc80b434941

 WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs

@@ -5523,16 +5523,16 @@

            //判断会计期是否合理
            string s = "";
            int sYear = 0;
            int sPeriod = 0;
            if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = s;
                objJsonResult.data = null;
                return objJsonResult;
            }
            //int sYear = 0;
            //int sPeriod = 0;
            //if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false)
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = s;
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}

            ListModels oListModels = new ListModels();
            try
@@ -6290,7 +6290,7 @@

        #region 工作联系单回复
        /// <summary>
        /// 异常反馈单
        /// 工作联系单
        /// </summary>
        /// <param name="msg"></param>
        /// <returns></returns>
@@ -6319,16 +6319,16 @@

            //判断会计期是否合理
            string s = "";
            int sYear = 0;
            int sPeriod = 0;
            if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = s;
                objJsonResult.data = null;
                return objJsonResult;
            }
            //int sYear = 0;
            //int sPeriod = 0;
            //if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false)
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = s;
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}

            ListModels oListModels = new ListModels();
            try
@@ -6466,6 +6466,50 @@
        }
        #endregion

        #region 工作联系单根据源单ID查看是否有对应联系单
        [Route("Sc_MESTransFerWorkBill/GetOA_WorkLinkBillListBySourceID")]
        [HttpGet]
        public object GetOA_WorkLinkBillListBySourceID(string HRelationInterID, string HRelationEntryID)
        {
            try
            {
                List<object> columnNameList = new List<object>();

                string sql = string.Format(@"select A.*,D.HName HDeptName,e.HName HEvaluateStatusName
                                        from OA_WorkLinkBillMain A 
                                        left join Gy_Department D on A.HDeptID=D.HItemID
                                        left join Gy_EvaluateStatus AS e ON A.HEvaluateStatusID = e.HItemID
                                        where A.HRelationInterID='" + HRelationInterID + "' and A.HRelationEntryID= '"+ HRelationEntryID+"'"); ;
                ds = oCN.RunProcReturn(sql, "OA_WorkLinkBillMain");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    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;
            }

        }
        #endregion

        #endregion
    }
}