public ResultModel Update(UserModel user, int repoApplyId, List<int> stockIds, string memo, int deptId) { ResultModel result = new ResultModel(); //获取质押申请 try { DAL.StockDAL stockDAL = new StockDAL(); DAL.RepoApplyDetailDAL detailDAL = new RepoApplyDetailDAL(); NFMT.Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //验证质押申请 result = repoapplyDAL.Get(user, repoApplyId); if (result.ResultStatus != 0) return result; Model.RepoApply repoApply = result.ReturnValue as Model.RepoApply; if (repoApply == null || repoApply.RepoApplyId <= 0) { result.ResultStatus = -1; result.Message = "质押申请获取失败"; return result; } //获取主申请 result = applyDAL.Get(user, repoApply.ApplyId); if (result.ResultStatus != 0) return result; NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply; if (apply == null || apply.ApplyId <= 0) { result.ResultStatus = -1; result.Message = "主申请获取失败"; return result; } //更新主申请 NFMT.User.Model.Department dept = NFMT.User.UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == deptId); if (dept == null || dept.DeptId <= 0) { result.ResultStatus = -1; result.Message = "申请部门不存在"; return result; } apply.ApplyDesc = memo; apply.ApplyDept = dept.DeptId; //apply.ApplyDeptName = dept.DeptName; result = applyDAL.Update(user, apply); if (result.ResultStatus != 0) return result; //获了质押申请明细 result = detailDAL.Load(user, repoApply.RepoApplyId); if (result.ResultStatus != 0) return result; List<Model.RepoApplyDetail> details = result.ReturnValue as List<Model.RepoApplyDetail>; if (details == null) { result.ResultStatus = -1; result.Message = "明细获取失败"; return result; } //作废明细 foreach (Model.RepoApplyDetail detail in details) { if (detail.DetailStatus == StatusEnum.已生效) detail.DetailStatus = StatusEnum.已录入; result = detailDAL.Invalid(user, detail); if (result.ResultStatus != 0) return result; } //获取库存 foreach (int stockId in stockIds) { result = stockDAL.Get(user, stockId); if (result.ResultStatus != 0) return result; Model.Stock stock = result.ReturnValue as Model.Stock; if (stock == null || stock.StockId <= 0) { result.ResultStatus = -1; result.Message = "库存获取失败"; return result; } if (stock.StockStatus != StockStatusEnum.质押库存) { result.ResultStatus = -1; result.Message = "库存非质押状态,不能进行回购操作"; return result; } //添加明细 Model.RepoApplyDetail detail = new RepoApplyDetail(); detail.DetailStatus = StatusEnum.已生效; detail.RepoApplyId = repoApply.RepoApplyId; detail.StockId = stock.StockId; result = detailDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel RepoApplyInvalid(UserModel user, int repoApplyId) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //获取回购申请 NFMT.WareHouse.DAL.RepoApplyDAL repoApplyDAL = new RepoApplyDAL(); result = repoApplyDAL.Get(user, repoApplyId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.RepoApply repoApply = result.ReturnValue as NFMT.WareHouse.Model.RepoApply; //获取申请主表 NFMT.Operate.BLL.ApplyBLL applyBLL = new Operate.BLL.ApplyBLL(); result = applyBLL.Get(user, repoApply.ApplyId); if (result.ResultStatus != 0) return result; NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply; //作废申请主表 result = applyBLL.Invalid(user, apply); if (result.ResultStatus != 0) return result; //作废回购申请明细 NFMT.WareHouse.DAL.RepoApplyDetailDAL repoApplyDetailDAL = new RepoApplyDetailDAL(); result = repoApplyDetailDAL.Invalid(user, repoApplyId, string.Empty); if (result.ResultStatus != 0) return result; NFMT.WareHouse.DAL.StockExclusiveDAL stockExclusiveDAL = new StockExclusiveDAL(); result = stockExclusiveDAL.Invalid(user, apply.ApplyId, repoApplyId, string.Empty); if (result.ResultStatus != 0) return result; scope.Complete(); } } catch (Exception ex) { result.Message = string.Format("操作失败,{0}", ex.Message); result.ResultStatus = -1; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }
public ResultModel RepoApplyUpdateHandle(UserModel user, NFMT.Operate.Model.Apply apply, int repoApplyId, List<Model.RepoApplyDetail> details) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { NFMT.Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); result = applyDAL.Get(user, apply.ApplyId); if (result.ResultStatus != 0) return result; NFMT.Operate.Model.Apply applyRes = result.ReturnValue as NFMT.Operate.Model.Apply; if (applyRes == null) { result.ResultStatus = -1; result.Message = "获取申请失败"; return result; } applyRes.ApplyTime = apply.ApplyTime; applyRes.EmpId = apply.EmpId; applyRes.ApplyDept = apply.ApplyDept; applyRes.ApplyCorp = apply.ApplyCorp; applyRes.ApplyDesc = apply.ApplyDesc; result = applyDAL.Update(user, applyRes); if (result.ResultStatus != 0) return result; NFMT.WareHouse.DAL.RepoApplyDetailDAL repoApplyDetailDAL = new RepoApplyDetailDAL(); result = repoApplyDetailDAL.InvalidAll(user, repoApplyId); if (result.ResultStatus != 0) return result; foreach (Model.RepoApplyDetail detail in details) { result = repoApplyDetailDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }
public ResultModel Confirm(UserModel user, int repoApplyId) { ResultModel result = new ResultModel(); try { DAL.StockDAL stockDAL = new StockDAL(); DAL.RepoApplyDAL repoApplyDAL = new RepoApplyDAL(); Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); DAL.RepoApplyDetailDAL detailDAL = new RepoApplyDetailDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //验证回购申请 result = repoApplyDAL.Get(user, repoApplyId); if (result.ResultStatus != 0) return result; Model.RepoApply repoApply = result.ReturnValue as Model.RepoApply; if (repoApply == null || repoApply.RepoApplyId <= 0) { result.ResultStatus = -1; result.Message = "回购申请不存在"; return result; } //验证主申请 result = applyDAL.Get(user, repoApply.ApplyId); if (result.ResultStatus != 0) return result; Operate.Model.Apply apply = result.ReturnValue as Operate.Model.Apply; if (apply == null || apply.ApplyId <= 0) { result.ResultStatus = -1; result.Message = "主申请不存在"; return result; } //验证是否执行完成 result = repoapplyDAL.CheckStockOutCanConfirm(user, repoApply.RepoApplyId); if (result.ResultStatus != 0) return result; Common.StatusEnum status = (Common.StatusEnum)result.ReturnValue; //获取已生效回购申请明细 result = detailDAL.Load(user, repoApply.RepoApplyId); if (result.ResultStatus != 0) return result; List<Model.RepoApplyDetail> details = result.ReturnValue as List<Model.RepoApplyDetail>; if (details == null) { result.ResultStatus = -1; result.Message = "获取回购申请明细失败"; return result; } //主申请更新状态至已完成 if (status == StatusEnum.已完成) result = applyDAL.Confirm(user, apply); else if (status == StatusEnum.部分完成) result = applyDAL.PartiallyConfirm(user, apply); else { result.ResultStatus = -1; result.Message = "更新主申请状态失败"; return result; } if (result.ResultStatus != 0) return result; //回购申请明细更新状态至已完成 foreach (Model.RepoApplyDetail detail in details) { //回购申请明细更新状态至已完成 result = detailDAL.Confirm(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel RepoApplyCreateHandle(UserModel user, Operate.Model.Apply apply, RepoApply repoApply, List<RepoApplyDetail> details) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //写入申请主表 NFMT.Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); result = applyDAL.Insert(user, apply); if (result.ResultStatus != 0) return result; int applyId = (int)result.ReturnValue; repoApply.ApplyId = applyId; //写入回购申请表 NFMT.WareHouse.DAL.RepoApplyDAL repoApplyDAL = new RepoApplyDAL(); result = repoApplyDAL.Insert(user, repoApply); if (result.ResultStatus != 0) return result; int repoApplyId = (int)result.ReturnValue; //List<Model.StockExclusive> listStockExclusives = new List<StockExclusive>(); //写入回购申请明细表 NFMT.WareHouse.DAL.RepoApplyDetailDAL detailDAL = new RepoApplyDetailDAL(); foreach (Model.RepoApplyDetail detail in details) { detail.RepoApplyId = repoApplyId; result = detailDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }
public ResultModel Invalid(UserModel user, int repoApplyId) { ResultModel result = new ResultModel(); DAL.StockDAL stockDAL = new StockDAL(); DAL.RepoApplyDAL repoApplyDAL = new RepoApplyDAL(); Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); DAL.RepoApplyDetailDAL detailDAL = new RepoApplyDetailDAL(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //验证出库申请 result = repoApplyDAL.Get(user, repoApplyId); if (result.ResultStatus != 0) return result; Model.RepoApply repoApply = result.ReturnValue as Model.RepoApply; if (repoApply == null || repoApply.RepoApplyId <= 0) { result.ResultStatus = -1; result.Message = "回购申请不存在"; return result; } //获取主申请实体 result = applyDAL.Get(user, repoApply.ApplyId); if (result.ResultStatus != 0) return result; Operate.Model.Apply apply = result.ReturnValue as Operate.Model.Apply; if (apply == null || apply.ApplyId <= 0) { result.ResultStatus = -1; result.Message = "主申请不存在"; return result; } //获取申请明细 result = detailDAL.Load(user, repoApply.RepoApplyId); if (result.ResultStatus != 0) return result; List<RepoApplyDetail> details = result.ReturnValue as List<RepoApplyDetail>; if (details == null) { result.ResultStatus = -1; result.Message = "申请明细获取失败"; return result; } //作废主申请 result = applyDAL.Invalid(user, apply); if (result.ResultStatus != 0) return result; //作废申请明细 foreach (Model.RepoApplyDetail detail in details) { if (detail.DetailStatus == StatusEnum.已生效) detail.DetailStatus = StatusEnum.已录入; result = detailDAL.Invalid(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; return result; } return result; }
public ResultModel ConfirmCancel(UserModel user, int repoApplyId) { ResultModel result = new ResultModel(); try { DAL.RepoApplyDAL repoApplyDAL = new RepoApplyDAL(); DAL.RepoApplyDetailDAL repoApplyDetailDAL = new RepoApplyDetailDAL(); Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { //验证回购申请 result = repoApplyDAL.Get(user, repoApplyId); if (result.ResultStatus != 0) return result; Model.RepoApply repoApply = result.ReturnValue as Model.RepoApply; if (repoApply == null || repoApply.RepoApplyId <= 0) { result.ResultStatus = -1; result.Message = "回购申请不存在"; return result; } //验证主申请 result = applyDAL.Get(user, repoApply.ApplyId); if (result.ResultStatus != 0) return result; Operate.Model.Apply apply = result.ReturnValue as Operate.Model.Apply; if (apply == null || apply.ApplyId <= 0) { result.ResultStatus = -1; result.Message = "主申请不存在"; return result; } //主申请状态更新至已生效 result = applyDAL.ConfirmCancel(user, apply); if (result.ResultStatus != 0) return result; //回购申请明细,在已完成状态下的更新至已生效 //获取已关闭的明细 result = repoApplyDetailDAL.Load(user, repoApply.RepoApplyId, Common.StatusEnum.已完成); if (result.ResultStatus != 0) return result; List<Model.RepoApplyDetail> details = result.ReturnValue as List<Model.RepoApplyDetail>; if (details == null) { result.ResultStatus = -1; result.Message = "获取申请明细失败"; return result; } foreach (Model.RepoApplyDetail detail in details) { result = repoApplyDetailDAL.ConfirmCancel(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel RepoUpdateHandle(UserModel user, int repoId, string sids, string memo) { ResultModel result = new ResultModel(); DAL.RepoDetailDAL repoDetailDAL = new RepoDetailDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new StockDAL(); NFMT.WareHouse.Model.Stock stock = new Stock(); NFMT.WareHouse.DAL.RepoApplyDetailDAL repoApplyDetailDAL = new RepoApplyDetailDAL(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = repoDAL.Get(user, repoId); if (result.ResultStatus != 0) return result; Model.Repo repo = result.ReturnValue as Model.Repo; if (repo == null) { result.ResultStatus = -1; return result; } repo.Memo = memo; //更新回购 result = repoDAL.Update(user, repo); if (result.ResultStatus != 0) return result; //作废所有该回购下的明细 result = repoDetailDAL.InvalidAll(user, repoId); if (result.ResultStatus != 0) return result; string[] splits = sids.Split(','); if (splits != null && splits.Length > 0) { foreach (string str in splits) { //获取库存信息 result = stockDAL.Get(user, Convert.ToInt32(str)); if (result.ResultStatus != 0) return result; stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null) { result.ResultStatus = -1; return result; } result = repoApplyDetailDAL.GetDetailId(user, repo.RepoApplyId, Convert.ToInt32(str)); if (result.ResultStatus != 0) return result; int detailId = (int)result.ReturnValue; //写入质押明细表 result = repoDetailDAL.Insert(user, new RepoDetail() { RepoId = repoId, RepoApplyDetailId = detailId, StockId = Convert.ToInt32(str), RepoWeight = stock.GrossAmount, Unit = stock.UintId }); if (result.ResultStatus != 0) return result; } scope.Complete(); } } } catch (Exception ex) { result.Message = ex.Message; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }