public override IModel CreateModel(SqlDataReader dr)
{
RepoApplyDetail repoapplydetail = new RepoApplyDetail();
int indexDetailId = dr.GetOrdinal("DetailId");
repoapplydetail.DetailId = Convert.ToInt32(dr[indexDetailId]);
int indexRepoApplyId = dr.GetOrdinal("RepoApplyId");
repoapplydetail.RepoApplyId = Convert.ToInt32(dr[indexRepoApplyId]);
int indexStockId = dr.GetOrdinal("StockId");
if (dr["StockId"] != DBNull.Value)
{
repoapplydetail.StockId = Convert.ToInt32(dr[indexStockId]);
}
int indexDetailStatus = dr.GetOrdinal("DetailStatus");
if (dr["DetailStatus"] != DBNull.Value)
{
repoapplydetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]);
}
return repoapplydetail;
}
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 Load(UserModel user, int repoApplyId, Common.StatusEnum status = StatusEnum.已生效)
{
ResultModel result = new ResultModel();
try
{
string cmdText = string.Format("select * from dbo.St_RepoApplyDetail where RepoApplyId={0} and DetailStatus>={1}", repoApplyId, (int)StatusEnum.已生效);
DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.ConnectionStringNFMT, cmdText, null, CommandType.Text);
List<RepoApplyDetail> RepoApplyDetails = new List<RepoApplyDetail>();
foreach (DataRow dr in dt.Rows)
{
RepoApplyDetail repoapplydetail = new RepoApplyDetail();
repoapplydetail.DetailId = Convert.ToInt32(dr["DetailId"]);
repoapplydetail.RepoApplyId = Convert.ToInt32(dr["RepoApplyId"]);
if (dr["StockId"] != DBNull.Value)
{
repoapplydetail.StockId = Convert.ToInt32(dr["StockId"]);
}
if (dr["DetailStatus"] != DBNull.Value)
{
repoapplydetail.DetailStatus = (Common.StatusEnum)Enum.Parse(typeof(Common.StatusEnum), dr["DetailStatus"].ToString());
}
RepoApplyDetails.Add(repoapplydetail);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = RepoApplyDetails;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}