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

username@email.com

6 小时以前 31c1cc0e839b72c26c8aaa5a9a7b61b81ecf3307

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs

@@ -132,13 +132,14 @@
                                    new SqlParameter("@Creater",trueModel.Creater),
                                      new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming),
                                         new SqlParameter("@SupplierName",string.IsNullOrEmpty(trueModel.SupplierName)?"":trueModel.SupplierName),
                                          new SqlParameter("@Molingmoney",trueModel.Molingmoney.HasValue?trueModel.Molingmoney.Value:0),




            };
            string sql = "Insert Into OA_Fukuanshenqing ([FirmId],[SupplierId],[Fukuanshenqingstatus],[ApprovalStatus], [Fukuanmoney], [Bank],[AccountID], [Yishoumoney],[Youwufapiao], [Creater],[CreateTime],[Updater],[LastUpdateTime],[Fukuanyongtu],FukuanStatus,remark,DindanId,Huming,SupplierName)"
                                             + " Values (@FirmId,@SupplierId,@Fukuanshenqingstatus, @ApprovalStatus, @Fukuanmoney, @Bank, @AccountID, @Yishoumoney, @Youwufapiao, @Creater,@CreateTime,@Updater,@LastUpdateTime,@Fukuanyongtu,@FukuanStatus,@remark,@DindanId,@Huming,@SupplierName )";
            string sql = "Insert Into OA_Fukuanshenqing ([FirmId],[SupplierId],[Fukuanshenqingstatus],[ApprovalStatus], [Fukuanmoney], [Bank],[AccountID], [Yishoumoney],[Youwufapiao], [Creater],[CreateTime],[Updater],[LastUpdateTime],[Fukuanyongtu],FukuanStatus,remark,DindanId,Huming,SupplierName,Molingmoney)"
                                             + " Values (@FirmId,@SupplierId,@Fukuanshenqingstatus, @ApprovalStatus, @Fukuanmoney, @Bank, @AccountID, @Yishoumoney, @Youwufapiao, @Creater,@CreateTime,@Updater,@LastUpdateTime,@Fukuanyongtu,@FukuanStatus,@remark,@DindanId,@Huming,@SupplierName,@Molingmoney )";
            int id = 0;
            try
            {
@@ -163,8 +164,16 @@
            {
                return false;
            }
            SqlParameter KehuqianshouTime = null;
          
            SqlParameter ShuomingTime = null;
            if (trueModel.ShuomingTime.HasValue)
            {
                ShuomingTime = new SqlParameter("@ShuomingTime", trueModel.ShuomingTime);
            }
            else
            {
                ShuomingTime = new SqlParameter("@ShuomingTime", DBNull.Value);
            }


            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
@@ -189,9 +198,13 @@
                                    new SqlParameter("@Creater",trueModel.Creater),
                                     new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming),
                                       new SqlParameter("@SupplierName",string.IsNullOrEmpty(trueModel.SupplierName)?"":trueModel.SupplierName),
                                          new SqlParameter("@Kaipiaoshuoming",string.IsNullOrEmpty(trueModel.Kaipiaoshuoming)?"":trueModel.Kaipiaoshuoming),
                                           new SqlParameter("@Shuominger",string.IsNullOrEmpty(trueModel.Shuominger)?"":trueModel.Shuominger),
                                ShuomingTime,


            };
            string sql = "Update OA_Fukuanshenqing Set [FirmId]=@FirmId,[SupplierId]=@SupplierId,[Fukuanshenqingstatus]=@Fukuanshenqingstatus,[ApprovalStatus]=@ApprovalStatus, [Fukuanmoney]=@Fukuanmoney, [Bank]=@Bank,[AccountID]=@AccountID, [Yishoumoney]=@Yishoumoney,[Youwufapiao]=@Youwufapiao, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime,Fukuanyongtu=@Fukuanyongtu,FukuanStatus=@FukuanStatus,remark=@remark,DindanId=@DindanId,Huming=@Huming,SupplierName=@SupplierName where [Keyid] =@Keyid ";
            string sql = "Update OA_Fukuanshenqing Set [FirmId]=@FirmId,[SupplierId]=@SupplierId,[Fukuanshenqingstatus]=@Fukuanshenqingstatus,[ApprovalStatus]=@ApprovalStatus, [Fukuanmoney]=@Fukuanmoney, [Bank]=@Bank,[AccountID]=@AccountID, [Yishoumoney]=@Yishoumoney,[Youwufapiao]=@Youwufapiao, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime,Fukuanyongtu=@Fukuanyongtu,FukuanStatus=@FukuanStatus,remark=@remark,DindanId=@DindanId,Huming=@Huming,SupplierName=@SupplierName,Kaipiaoshuoming=@Kaipiaoshuoming,Shuominger=@Shuominger,ShuomingTime=@ShuomingTime where [Keyid] =@Keyid ";

            try
            {
@@ -236,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>