销售订单：反审核时判断单价是否存在行关闭的记录

duhe

2024-03-26 9a754dafa74cf185a5f9362435dc8a3d3551a83b

 WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs

@@ -1011,5 +1011,50 @@
            }
        }
        #endregion

        #region 收款单 根据客户获取关联职员
        [Route("YS_ReceiveBill/getRelationEmpByCusID")]
        [HttpGet]
        public object getRelationEmpByCusID(long HCusID)
        {
            try
            {
                string sql = @"select b.HEmpID HEmpID,e.HName HEmpName,b.HDeptID HDeptID,d.HName HDeptName,d.HEmpID HManagerID,e1.HName HManagerName
                            from Gy_UserCustomerRelation as a
                            left join Gy_Czygl as b on a.HUserID = b.Czybm
                            left join Gy_Employee as e on b.HEmpID = e.HItemID
                            left join Gy_Department as d on b.HDeptID = d.HItemID
                            left join Gy_Employee as e1 on d.HEmpID = e1.HItemID
                            where a.HCusID = " + HCusID;
                ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");


                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();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}