板材填了就减少库存 根据 板材规格 数量（张）和 发版套数 算出库存需要减少的量，减少库存 完成

username@email.com

9 天以前 fa8310bfd01c7f3123077d6d2f6a96a92645a034

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs

@@ -265,6 +265,64 @@
            return true;
        }



        /// <summary>
        /// 修改完结
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateWanjie(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_CorporateClients trueModel = model as Model.OA_CorporateClients;
            if (trueModel == null)
            {
                return false;
            }

            SqlParameter par = null;
            if (trueModel.LastOrderTime.HasValue)
            {
                par = new SqlParameter("@LastOrderTime", trueModel.LastOrderTime.Value);
            }
            else
            {
                par = new SqlParameter("@LastOrderTime", DBNull.Value);
            }
            SqlParameter par1 = null;
            if (trueModel.WanjieTime.HasValue)
            {
                par1 = new SqlParameter("@WanjieTime", trueModel.WanjieTime.Value);
            }
            else
            {
                par1 = new SqlParameter("@WanjieTime", DBNull.Value);
            }
           
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter("@Keyid",trueModel.Keyid),
                    
                    par,
                    
                       par1,
                       
                            new SqlParameter("@Shifouwanjie",trueModel.Shifouwanjie??0) ,
            };
            string sql = "Update [OA_CorporateClients] Set [Shifouwanjie]=@Shifouwanjie,[WanjieTime]=@WanjieTime,[LastOrderTime]=@LastOrderTime  where [Keyid] =@Keyid ";

            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }


        /// <summary>
        /// 转移客户
        /// </summary>
@@ -1206,7 +1264,100 @@

            try
            {
                IList<OA_CorporateClientsVisit> result = _dataBase.SelectModel<OA_CorporateClientsVisit>("  a.*,b.[Name] as CreaterName ", "OA_CorporateClientsVisit a left join EC_MemberBasic b on a.Creater = b.MemberId ", string.Format(" CorporateClientsid = '{0}'  order by a.[VisitTime] desc", CustomId)) as IList<OA_CorporateClientsVisit>;//执行查询
                IList<OA_CorporateClientsVisit> result = _dataBase.SelectModel<OA_CorporateClientsVisit>(" top 50  a.*,b.[Name] as CreaterName ", "OA_CorporateClientsVisit a left join EC_MemberBasic b on a.Creater = b.MemberId ", string.Format(" CorporateClientsid = '{0}'  order by a.[VisitTime] desc", CustomId)) as IList<OA_CorporateClientsVisit>;//执行查询
                return result;//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }




        /// <summary>
        /// 新增合作客户设计沟通
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertModelSheji(CY.Model.OA_CorporateClientsSheji trueModel)
        {
            //Model.OA_CorporateClients trueModel = model as Model.OA_CorporateClientsVist;
            if (trueModel == null)
            {
                return false;
            }

            SqlParameter par = null;
            if (trueModel.ShejiTime.HasValue)
            {
                par = new SqlParameter("@ShejiTime", trueModel.ShejiTime.Value);
            }
            else
            {
                par = new SqlParameter("@ShejiTime", DBNull.Value);
            }
            SqlParameter par1 = null;
            if (trueModel.CreateTime.HasValue)
            {
                par1 = new SqlParameter("@CreateTime", trueModel.CreateTime.Value);
            }
            else
            {
                par1 = new SqlParameter("@CreateTime", DBNull.Value);
            }
            SqlParameter par2 = null;
            if (trueModel.LastUpdateTime.HasValue)
            {
                par2 = new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime.Value);
            }
            else
            {
                par2 = new SqlParameter("@LastUpdateTime", DBNull.Value);
            }

            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                       new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@CorporateClientsid",trueModel.CorporateClientsid),
                    par,
                     new SqlParameter("@YinjianName",trueModel.YinjianName),
                      new SqlParameter("@JiaogaoCount",trueModel.JiaogaoCount.HasValue?trueModel.JiaogaoCount.Value:0),
                    new SqlParameter("@Remark",trueModel.Remark),
                    new SqlParameter("@Creater",trueModel.Creater),
                    par1,
                    new SqlParameter("@Updater",trueModel.Updater),
                    par2,

            };
            string sql = "Insert Into OA_CorporateClientsSheji ([Keyid],[CorporateClientsid],[ShejiTime],[YinjianName], [JiaogaoCount], [Remark],[Creater], [CreateTime],[Updater], [LastUpdateTime] )"
                                              + " Values (@Keyid,@CorporateClientsid,@ShejiTime, @YinjianName, @JiaogaoCount, @Remark, @Creater, @CreateTime, @Updater, @LastUpdateTime  )";

            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }


        /// <summary>
        /// 根据客户id查询设计沟通
        /// </summary>
        /// <param name="CustomId">编号</param>
        /// <returns></returns>
        public IEnumerable<OA_CorporateClientsSheji> SelectShejiListByCorId(Guid CustomId)
        {
            if (CustomId == null)
                return null;//错误数据返会空
            try
            {
                IList<OA_CorporateClientsSheji> result = _dataBase.SelectModel<OA_CorporateClientsSheji>(" top 50  a.*,b.[Name] as CreaterName ", "OA_CorporateClientsSheji a left join EC_MemberBasic b on a.Creater = b.MemberId ", string.Format(" CorporateClientsid = '{0}'  order by a.[ShejiTime] desc", CustomId)) as IList<OA_CorporateClientsSheji>;//执行查询
                return result;//返回结果
            }
            catch (Exception ex)
@@ -1577,5 +1728,22 @@
            return (null == result || result.Count == 0) ? null : result[0];//返回结果
        }



        /// <summary>
        /// 单个查询设计沟通
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_CorporateClientsSheji SelectShejiByKeyid(Guid Keyid)
        {
            if (Keyid == null)
                return null;//错误数据返会空 

            IList<OA_CorporateClientsSheji> result = _dataBase.SelectModel<OA_CorporateClientsSheji>(" a.* ", " OA_CorporateClientsSheji a ", string.Format(" a.Keyid='{0}'", Keyid)) as IList<OA_CorporateClientsSheji>;//执行查询

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

    }
}