public override IModel CreateModel(SqlDataReader dr) { Pledge pledge = new Pledge(); int indexPledgeId = dr.GetOrdinal("PledgeId"); pledge.PledgeId = Convert.ToInt32(dr[indexPledgeId]); int indexPledgeApplyId = dr.GetOrdinal("PledgeApplyId"); if (dr["PledgeApplyId"] != DBNull.Value) { pledge.PledgeApplyId = Convert.ToInt32(dr[indexPledgeApplyId]); } int indexPledger = dr.GetOrdinal("Pledger"); if (dr["Pledger"] != DBNull.Value) { pledge.Pledger = Convert.ToInt32(dr[indexPledger]); } int indexPledgeTime = dr.GetOrdinal("PledgeTime"); if (dr["PledgeTime"] != DBNull.Value) { pledge.PledgeTime = Convert.ToDateTime(dr[indexPledgeTime]); } int indexPledgeBank = dr.GetOrdinal("PledgeBank"); if (dr["PledgeBank"] != DBNull.Value) { pledge.PledgeBank = Convert.ToInt32(dr[indexPledgeBank]); } int indexMemo = dr.GetOrdinal("Memo"); if (dr["Memo"] != DBNull.Value) { pledge.Memo = Convert.ToString(dr[indexMemo]); } int indexPledgeStatus = dr.GetOrdinal("PledgeStatus"); if (dr["PledgeStatus"] != DBNull.Value) { pledge.PledgeStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexPledgeStatus]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { pledge.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { pledge.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { pledge.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { pledge.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return pledge; }
public ResultModel Complete(UserModel user, int pledgeApplyId) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = this.Get(user, pledgeApplyId); if (result.ResultStatus != 0) return result; Model.PledgeApply pledgeApply = result.ReturnValue as PledgeApply; if (pledgeApply == null) { result.ResultStatus = -1; result.Message = "该数据不存在,不能完成"; return result; } NFMT.Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL(); result = applyDAL.Get(user, pledgeApply.ApplyId); if (result.ResultStatus != 0) return result; NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply; if (apply.ApplyStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "非已生效状态的数据不允许完成"; return result; } DAL.PledgeDAL pledgeDAL = new PledgeDAL(); result = pledgeDAL.GetPledgeIdByApplyId(user, pledgeApplyId); if (result.ResultStatus != 0) return result; if (!string.IsNullOrEmpty(result.ReturnValue.ToString())) { Model.Pledge pledge = new Pledge(); foreach (string s in result.ReturnValue.ToString().Split(',')) { result = pledgeDAL.Get(user, Convert.ToInt32(s)); if (result.ResultStatus != 0) return result; pledge = result.ReturnValue as Model.Pledge; if (pledge.Status != StatusEnum.已完成) { result.ResultStatus = -1; result.Message = "该质押申请对应的质押并未全部完成"; return result; } } } result = applyDAL.Confirm(user, apply); if (result.ResultStatus == 0) 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 override IModel CreateModel(DataRow dr) { Pledge pledge = new Pledge(); pledge.PledgeId = Convert.ToInt32(dr["PledgeId"]); if (dr["PledgeApplyId"] != DBNull.Value) { pledge.PledgeApplyId = Convert.ToInt32(dr["PledgeApplyId"]); } if (dr["Pledger"] != DBNull.Value) { pledge.Pledger = Convert.ToInt32(dr["Pledger"]); } if (dr["PledgeTime"] != DBNull.Value) { pledge.PledgeTime = Convert.ToDateTime(dr["PledgeTime"]); } if (dr["PledgeBank"] != DBNull.Value) { pledge.PledgeBank = Convert.ToInt32(dr["PledgeBank"]); } if (dr["Memo"] != DBNull.Value) { pledge.Memo = Convert.ToString(dr["Memo"]); } if (dr["PledgeStatus"] != DBNull.Value) { pledge.PledgeStatus = (Common.StatusEnum)Convert.ToInt32(dr["PledgeStatus"]); } if (dr["CreatorId"] != DBNull.Value) { pledge.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { pledge.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { pledge.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { pledge.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } return pledge; }