Beispiel #1
0
        /// <summary>
        /// 有用,创建分配公司关联表
        /// </summary>
        /// <param name="user"></param>
        /// <param name="rec"></param>
        /// <param name="details"></param>
        /// <param name="corpDetail"></param>
        /// <returns></returns>
        public ResultModel CreateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details,Model.CorpReceivable corpDetail)
        {
            ResultModel result = new ResultModel();

            try
            {
                DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
                using (System.Transactions.TransactionScope scope = new TransactionScope())
                {
                    rec.AllotType = (int)CashInAllotTypeEnum.Corp;
                    result = this.CreateMain(user, rec, ref details);
                    if (result.ResultStatus != 0)
                        return result;

                    foreach (Model.RecAllotDetail detail in details)
                    {
                        Model.CorpReceivable corpD = new CorpReceivable();
                        corpD.AllotId = detail.AllotId;
                        corpD.BlocId = corpDetail.BlocId;
                        corpD.CorpId = corpDetail.CorpId;
                        corpD.DetailId = detail.DetailId;
                        corpD.IsShare = corpDetail.IsShare;
                        corpD.RecId = detail.RecId;

                        result = corpRecDAL.Insert(user, corpD);
                        if (result.ResultStatus != 0)
                            return result;
                    }

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }

            return result;
        }
Beispiel #2
0
        public ResultModel UpdateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details, Model.CorpReceivable corpDetail)
        {
            ResultModel result = new ResultModel();

            try
            {
                DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
                using (System.Transactions.TransactionScope scope = new TransactionScope())
                {

                    result = this.UpdateMain(user, rec, ref details);
                    if (result.ResultStatus != 0)
                        return result;

                    result = corpRecDAL.Load(user, rec.ReceivableAllotId);
                    if (result.ResultStatus != 0)
                        return result;

                    List<Model.CorpReceivable> corpDetails = result.ReturnValue as List<Model.CorpReceivable>;
                    if (corpDetails == null || corpDetails.Count == 0)
                    {
                        result.ResultStatus = -1;
                        result.Message = "获取公司明细失败";
                        return result;
                    }

                    corpDetail.BlocId = corpDetails[0].BlocId;
                    corpDetail.CorpId = corpDetails[0].CorpId;

                    foreach (Model.RecAllotDetail detail in details)
                    {
                        Model.CorpReceivable corpD = new CorpReceivable();
                        corpD.AllotId = detail.AllotId;
                        corpD.BlocId = corpDetail.BlocId;
                        corpD.CorpId = corpDetail.CorpId;
                        corpD.DetailId = detail.DetailId;
                        corpD.IsShare = corpDetail.IsShare;
                        corpD.RecId = detail.RecId;

                        result = corpRecDAL.Insert(user, corpD);
                        if (result.ResultStatus != 0)
                            return result;
                    }

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }

            return result;
        }
Beispiel #3
0
        public ResultModel ReceivableStockUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId,int stockId,
            int stockNameId,int allotFrom)
        {
            ResultModel result = new ResultModel();
            DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
            DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
            DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL();
            DAL.StcokReceivableDAL stcokReceivableDAL = new StcokReceivableDAL();
            NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL();
            NFMT.WareHouse.DAL.StockLogDAL stockLogDAL=new WareHouse.DAL.StockLogDAL();
            Model.Receivable receivable = new Receivable();

            try
            {
                using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    decimal allotBala = 0;
                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        //allotBala += corpReceivable.AllotBala;
                    }

                    result = receivableallotDAL.Get(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot;
                    receivableAllot.AllotDesc = memo;
                    receivableAllot.AllotBala = allotBala;
                    receivableAllot.CurrencyId = curId;
                    receivableAllot.AllotFrom = allotFrom;

                    //更新收款分配表
                    result = receivableallotDAL.Update(user, receivableAllot);
                    if (result.ResultStatus != 0)
                        return result;

                    //作废公司收款分配
                    result = corpReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    //作废合约收款分配
                    result = contractReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    //作废库存收款分配
                    result = stcokReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    //获取合约Id
                    result = stockLogDAL.GetStockContractId(user, stockId);
                    if (result.ResultStatus != 0)
                        return result;

                    string contractStr = result.ReturnValue.ToString();

                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        result = corporationDAL.Get(user, corpReceivable.CorpId);
                        if (result.ResultStatus != 0)
                            return result;

                        User.Model.Corporation corp = result.ReturnValue as User.Model.Corporation;
                        corpReceivable.BlocId = corp.ParentId;

                        //写入公司收款分配
                        result = corpReceivableDAL.Insert(user, corpReceivable);
                        if (result.ResultStatus != 0)
                            return result;

                        int corpRefId = (int)result.ReturnValue;

                        Model.ContractReceivable contractReceivable = new ContractReceivable()
                        {
                            CorpRefId = corpRefId,
                            AllotId = allotId,
                            RecId = corpReceivable.RecId,
                            ContractId = Convert.ToInt32(contractStr.Split(',')[0]),
                            SubContractId = Convert.ToInt32(contractStr.Split(',')[1]),
                            //AllotBala = corpReceivable.AllotBala
                        };

                        //写入合约收款分配
                        result = contractReceivableDAL.Insert(user, contractReceivable);
                        if (result.ResultStatus != 0)
                            return result;

                        int contractRefId = (int)result.ReturnValue;

                        Model.StcokReceivable stcokReceivable = new StcokReceivable()
                        {
                            AllotId = allotId,
                            CorpRefId = corpRefId,
                            ContractRefId = contractRefId,
                            RecId = corpReceivable.RecId,
                            StockId = stockId,
                            StockNameId = stockNameId,
                            //AllotBala = corpReceivable.AllotBala
                        };

                        //写入库存收款分配
                        result = stcokReceivableDAL.Insert(user, stcokReceivable);
                        if (result.ResultStatus != 0)
                            return result;

                    }

                    scope.Complete();
                }

            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (result.ResultStatus != 0)
                    this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
                else if (this.Log.IsInfoEnabled)
                    this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
            }

            return result;
        }
Beispiel #4
0
        public ResultModel ReceivableCorpUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId)
        {
            ResultModel result = new ResultModel();
            DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
            DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
            Model.Receivable receivable = new Receivable();

            try
            {
                using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    decimal allotBala = 0;
                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        //allotBala += corpReceivable.AllotBala;
                    }

                    result = receivableallotDAL.Get(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot;
                    receivableAllot.AllotDesc = memo;
                    receivableAllot.AllotBala = allotBala;

                    result = receivableallotDAL.Update(user, receivableAllot);
                    if (result.ResultStatus != 0)
                        return result;

                    result = corpReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        corpReceivable.AllotId = allotId;
                        result = corpReceivableDAL.Insert(user, corpReceivable);
                        if (result.ResultStatus != 0)
                            return result;
                    }

                    scope.Complete();
                }

            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (result.ResultStatus != 0)
                    this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
                else if (this.Log.IsInfoEnabled)
                    this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
            }

            return result;
        }
Beispiel #5
0
        public ResultModel ReceivableCorpCreateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo)
        {
            ResultModel result = new ResultModel();
            DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
            DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
            Model.Receivable receivable = new Receivable();

            try
            {
                using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    decimal allotBala = 0;
                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        //allotBala += corpReceivable.AllotBala;
                    }

                    Model.ReceivableAllot receivableAllot = new ReceivableAllot()
                    {
                        AllotFrom = NFMT.Data.DetailProvider.Details(NFMT.Data.StyleEnum.分配来源)["Receivable"].StyleDetailId,
                        AllotBala = allotBala,
                        CurrencyId = curId,
                        AllotDesc = memo,
                        EmpId = user.EmpId,
                        AllotTime = DateTime.Now
                    };

                    result = receivableallotDAL.Insert(user, receivableAllot);
                    if (result.ResultStatus != 0)
                        return result;

                    int receivableAllotId = (int)result.ReturnValue;

                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        corpReceivable.AllotId = receivableAllotId;
                        result = corpReceivableDAL.Insert(user, corpReceivable);
                        if (result.ResultStatus != 0)
                            return result;
                    }

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (result.ResultStatus != 0)
                    this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
                else if (this.Log.IsInfoEnabled)
                    this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
            }

            return result;
        }
Beispiel #6
0
        public ResultModel ReceivableAllotUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId, int contractId, int subId)
        {
            ResultModel result = new ResultModel();
            DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
            DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL();
            DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
            NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL();
            Model.Receivable receivable = new Receivable();

            try
            {
                using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    decimal allotBala = 0;
                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        //allotBala += corpReceivable.AllotBala;
                    }

                    result = receivableallotDAL.Get(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot;
                    receivableAllot.AllotDesc = memo;
                    receivableAllot.AllotBala = allotBala;

                    //更新分配信息
                    result = receivableallotDAL.Update(user, receivableAllot);
                    if (result.ResultStatus != 0)
                        return result;

                    //作废所有allotId下的合约收款分配
                    result = contractReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    //作废所有allotId下的公司收款分配
                    result = corpReceivableDAL.InvalidAll(user, allotId);
                    if (result.ResultStatus != 0)
                        return result;

                    foreach (Model.CorpReceivable corpReceivable in corpReceivables)
                    {
                        corpReceivable.AllotId = allotId;
                        result = corporationDAL.Get(user, corpReceivable.CorpId);
                        if (result.ResultStatus != 0)
                            return result;

                        //获取公司信息
                        NFMT.User.Model.Corporation corp = result.ReturnValue as NFMT.User.Model.Corporation;
                        if (corp == null)
                            return result;

                        corpReceivable.BlocId = corp.ParentId;

                        //写入公司收款分配表
                        result = corpReceivableDAL.Insert(user, corpReceivable);
                        if (result.ResultStatus != 0)
                            return result;

                        int refId = (int)result.ReturnValue;

                        Model.ContractReceivable contractReceivable = new ContractReceivable()
                        {
                            CorpRefId = refId,
                            AllotId = corpReceivable.AllotId,
                            RecId = corpReceivable.RecId,
                            ContractId = contractId,
                            SubContractId = subId,
                            //AllotBala = corpReceivable.AllotBala
                        };

                        //写入合约收款分配表
                        result = contractReceivableDAL.Insert(user, contractReceivable);
                        if (result.ResultStatus != 0)
                            return result;
                    }

                    scope.Complete();
                }

            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (result.ResultStatus != 0)
                    this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
                else if (this.Log.IsInfoEnabled)
                    this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
            }

            return result;
        }