public override IModel CreateModel(SqlDataReader dr) { CashInAllot cashinallot = new CashInAllot(); int indexAllotId = dr.GetOrdinal("AllotId"); cashinallot.AllotId = Convert.ToInt32(dr[indexAllotId]); int indexAllotBala = dr.GetOrdinal("AllotBala"); if (dr["AllotBala"] != DBNull.Value) { cashinallot.AllotBala = Convert.ToDecimal(dr[indexAllotBala]); } int indexAllotType = dr.GetOrdinal("AllotType"); if (dr["AllotType"] != DBNull.Value) { cashinallot.AllotType = Convert.ToInt32(dr[indexAllotType]); } int indexCurrencyId = dr.GetOrdinal("CurrencyId"); if (dr["CurrencyId"] != DBNull.Value) { cashinallot.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]); } int indexAllotDesc = dr.GetOrdinal("AllotDesc"); if (dr["AllotDesc"] != DBNull.Value) { cashinallot.AllotDesc = Convert.ToString(dr[indexAllotDesc]); } int indexAlloter = dr.GetOrdinal("Alloter"); if (dr["Alloter"] != DBNull.Value) { cashinallot.Alloter = Convert.ToInt32(dr[indexAlloter]); } int indexAllotTime = dr.GetOrdinal("AllotTime"); if (dr["AllotTime"] != DBNull.Value) { cashinallot.AllotTime = Convert.ToDateTime(dr[indexAllotTime]); } int indexAllotStatus = dr.GetOrdinal("AllotStatus"); if (dr["AllotStatus"] != DBNull.Value) { cashinallot.AllotStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexAllotStatus]); } int indexAllotFrom = dr.GetOrdinal("AllotFrom"); if (dr["AllotFrom"] != DBNull.Value) { cashinallot.AllotFrom = Convert.ToInt32(dr[indexAllotFrom]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { cashinallot.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { cashinallot.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { cashinallot.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { cashinallot.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return cashinallot; }
public ResultModel CreateDirectContract(UserModel user, CashInAllot allot, List<CashInContractDirect> directs, int subId) { ResultModel result = new ResultModel(); try { NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取子合约 result = subDAL.Get(user, subId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.ResultStatus = -1; result.Message = "子合约不存在,不能进行收款分配"; return result; } //判断合约状态 //获取合约对方抬头 result = subDAL.GetContractOutCorp(user, sub.SubId); if (result.ResultStatus != 0) return result; DataTable outCorpTable = result.ReturnValue as DataTable; if (outCorpTable == null || outCorpTable.Rows.Count == 0) { result.ResultStatus = -1; result.Message = "合约对方抬头不存在,收款分配失败"; return result; } List<int> outCorpIds = new List<int>(); foreach (DataRow dr in outCorpTable.Rows) { int outCorpId = 0; if (dr["CorpId"] == DBNull.Value || !int.TryParse(dr["CorpId"].ToString(), out outCorpId) || outCorpId <= 0) { result.ResultStatus = -1; result.Message = "合约对方抬头获取失败"; return result; } outCorpIds.Add(outCorpId); } List<Model.CashInCorp> cashCorps = new List<CashInCorp>(); foreach (CashInContractDirect direct in directs) { //判断收款分配到的对方抬头是否包含在合约抬头中 if (!outCorpIds.Contains(direct.AllotCorpId)) { result.ResultStatus = -1; result.Message = "收款分配选择的分配公司不在该合约对方抬头中,收款分配失败"; return result; } //判断收款登记的币种是否和合约币种相同 result = cashInDAL.Get(user, direct.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.ResultStatus = -1; result.Message = "收款登记不存在"; return result; } if (cashIn.CashInStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "收款登记状态错误,不能进行分配"; return result; } if (cashIn.CurrencyId != sub.SettleCurrency) { result.ResultStatus = -1; result.Message = "收款登记币种与合约币种不相同,分配错误"; return result; } CashInCorp cashCorp = new CashInCorp(); NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == direct.AllotCorpId); if (corp == null || corp.CorpId <= 0) { result.ResultStatus = -1; result.Message = "收款分配选择的分配公司不存在,分配失败"; return result; } cashCorp.AllotBala = direct.AllotBala; cashCorp.BlocId = corp.ParentId; cashCorp.CashInId = direct.CashInId; cashCorp.CorpId = corp.CorpId; cashCorp.DetailStatus = StatusEnum.已生效; cashCorp.IsShare = false; cashCorp.AllotId = 0; cashCorps.Add(cashCorp); } decimal sumBala = directs.Sum(temp => temp.AllotBala); allot.AllotBala = sumBala; allot.Alloter = user.EmpId; allot.AllotStatus = StatusEnum.已录入; allot.AllotTime = DateTime.Now; allot.AllotType = (int)NFMT.Funds.CashInAllotTypeEnum.Contract; allot.CurrencyId = sub.SettleCurrency; //新增主分配 result = cashInAllotDAL.Insert(user, allot); if (result.ResultStatus != 0) return result; int allotId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out allotId) || allotId <= 0) { result.ResultStatus = -1; result.Message = "收款分配新增失败"; return result; } //新增公司收款分配 foreach (Model.CashInCorp cd in cashCorps) { cd.AllotId = allotId; result = cashInCorpDAL.Insert(user, cd); if (result.ResultStatus != 0) return result; int refId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out refId) || refId <= 0) { result.ResultStatus = -1; result.Message = "公司收款分配新增失败"; return result; } CashInContract cashContract = new CashInContract(); cashContract.AllotBala = cd.AllotBala; cashContract.AllotId = cd.AllotId; cashContract.CashInId = cd.CashInId; cashContract.ContractId = sub.ContractId; cashContract.CorpRefId = refId; cashContract.DetailStatus = StatusEnum.已生效; cashContract.SubContractId = sub.SubId; result = this.cashincontractDAL.Insert(user, cashContract); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }