修改采购申请付款，结账的不能申请

username@email.com

5 小时以前 31c1cc0e839b72c26c8aaa5a9a7b61b81ecf3307

修改采购申请付款，结账的不能申请

 CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs

@@ -94,6 +94,20 @@
        }



        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid)
        {
            
            return _IOA_FukuanshenqingDAL.GetModelListByshifoushenqing(keyid);
        }



        /// <summary>
        /// 根据formid获得信息
        /// </summary>

 CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs

@@ -34,5 +34,14 @@
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        int InserModelbackid(OA_Fukuanshenqing oA_Fukuanshenqing);



        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid);
    }
}

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs

@@ -249,6 +249,41 @@
        }




        /// <summary>
        /// 查询是否申请了付款
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid)
        {
            try
            {
                string condition = "  ";
                if (keyid > 0)
                {
                    condition = "    b.[ApprovalStatus] != 2   and (  a.DindanId = '" + keyid + "' or a.DindanId like CONCAT('%','," + keyid + ",','%') or a.DindanId like CONCAT('','" + keyid + ",','%')  or a.DindanId like CONCAT('%','," + keyid + "','') )    ";
                }
                else
                {
                    return null;
                }

                //  return null;//错误数据返会空 

                IList<OA_Fukuanshenqing> result = _dataBase.SelectModel<OA_Fukuanshenqing>("a.*", " OA_Fukuanshenqing a inner join [OA_WorkPlan] b on CAST(a.[Keyid] AS varchar(50)) = b.[PlanComplany] and b.[PlanDataType] =16  ", condition) as IList<OA_Fukuanshenqing>;//执行查询

                return (null == result || result.Count == 0) ? null : result[0];//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }



        /// <summary>
        /// 全部查询
        /// </summary>

 CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs

@@ -95,6 +95,18 @@
                    pa.PageSize = 1000;
                    pa.PageIndex = 1;
                    var models = _OA_ProcurementBLL.getModelList(pa, CurrentUser.MemberId,orderIdStr).ToList();


                    foreach (var oA_Procurement in models)
                    {
                        if(oA_Procurement.ClearingStatusId == 204)
                        {
                            JavaScript.MessageBox("有采购单已经付款！", this,true,false);
                            return;
                        }
                        _oA_FukuanshenqingBLL.GetModelListByshifoushenqing(oA_Procurement.Keyid.Value);
                    }

                    if (models.Count > 0)
                    {
                        var sss = _OA_SuppliersBLL.getSingleSupplier(models[0].SuppliersId.Value.ToString());