/// <summary> /// @xis 添加入库单 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <int> AddStockInAsync(t_stock_in model) { string sql_insert_stock_in = g_sqlMaker.Insert <t_stock_in>(i => new { i.in_user_id, i.order_sn, i.position_id, i.status, i.department_id, i.apply_status, i.apply_process }).ToSQL(); return(await g_dbHelper.ExecScalarAsync <int>(sql_insert_stock_in, model)); }
/// <summary> /// @xis 获取入库单详情 /// </summary> /// <param name="reqmodel"></param> /// <returns></returns> public async Task <Result> GetStockInDetailAsync(reqmodel <StockInDetailModel> reqmodel) { Result <StockInDetailResult> result = new Result <StockInDetailResult> { code = ErrorCodeConst.ERROR_100, status = ErrorCodeConst.ERROR_403 }; t_stock_in stock_in_model = await GetStockInByOrderSn(f => new { f.in_user_id, f.department_id, f.add_time, f.apply_status, f.position_id, f.order_sn }, reqmodel.Data.order_sn); if (stock_in_model == null) { result.code = ErrorCodeConst.ERROR_1038; return(result); } IUserServer userServer = new UserServerImpl(g_dbHelper, g_logServer); IDepartmentServer departmentServer = new DepartmentServerImpl(g_dbHelper, g_logServer); IAuditServer auditServer = new AuditServerImpl(g_dbHelper, g_logServer); t_user user_model = await userServer.GetUserById(s => new { s.real_name, s.job_number }, stock_in_model.in_user_id); t_department depart_model = await departmentServer.GetDepartment(s => new { s.department_name }, stock_in_model.department_id); result.data = new StockInDetailResult { add_time = stock_in_model.add_time.Value.ToString("yyyy-MM-dd hh:mm:ss") ?? "", applyer = user_model.real_name, apply_status = stock_in_model.apply_status, apply_status_desc = ((EnumApplyStatus)stock_in_model.apply_status).GetDesc(), audit_step_index = auditServer.GetApplyIndex(EnumOrderType.IN, stock_in_model.department_id, stock_in_model.position_id, stock_in_model.apply_process), job_number = user_model.job_number, order_sn = stock_in_model.order_sn, depart_name = depart_model.department_name, audit_list = await auditServer.GetApplyedLogByOrderSnAsync(EnumOrderType.IN, stock_in_model.order_sn, stock_in_model.department_id, stock_in_model.position_id), products = new List <StockInProductResult>() }; //获取入库的库存信息 List <t_stock_in_detail> stock_detail_list = await GetStockDetailsByOrderSn(f => new t_stock_in_detail { }, stock_in_model.order_sn); IFactoryServer factoryServer = new FactoryServerImpl(g_dbHelper, g_logServer); foreach (var item in stock_detail_list) { result.data.products.Add(new StockInProductResult { batch_number = item.batch_number, expiration_date = item.expiration_date, factory_id = item.factory_id, instructions = item.instructions, material_number = item.material_number, model_number = item.model_number, package_size = item.package_size, product_name = item.product_name, report_card_url = item.report_card_url, retest_date = item.retest_date, spare_parts = item.spare_parts, unit_name = item.unit_name, quantity = item.quantity, unit_price = item.unit_price, factory_name = (await factoryServer.GetFactoryById(f => new { f.factory_name }, item.factory_id)).factory_name }); } result.code = ErrorCodeConst.ERROR_200; result.status = ErrorCodeConst.ERROR_200; return(result); }
/// <summary> /// @xis 更新入库单 /// </summary> /// <param name="selector"></param> /// <param name="model"></param> /// <returns></returns> public async Task <bool> UpdateStockInByOrderSn(Func <t_stock_in, dynamic> selector, t_stock_in model) { string sql = g_sqlMaker.Update(selector).Where("order_sn", "=", "@order_sn").ToSQL(); return(await g_dbHelper.ExecAsync(sql, model) > 0); }
/// <summary> /// @xis 入库申请 /// </summary> /// <param name="reqmodel"></param> /// <returns></returns> public async Task <Result> StockInApplyAsync(reqmodel <StockInApplyModel> reqmodel) { const string modelname = "StockServerImpl.StockInApplyAsync"; Result result = new Result { code = ErrorCodeConst.ERROR_1037, status = ErrorCodeConst.ERROR_403 }; //入库单 t_stock_in stock_in = new t_stock_in { apply_status = (int)EnumApplyStatus.Progress, in_user_id = reqmodel.User.user_id, department_id = reqmodel.User.department_id, position_id = reqmodel.User.position_id, status = (int)EnumStatus.Enable, order_sn = MakeOrderSn("IN"), apply_process = reqmodel.User.position_id, add_time = DateTime.Now }; List <t_stock_in_detail> stock_detail_list = new List <t_stock_in_detail>(); List <t_stock> stock_add_list = new List <t_stock>(); List <t_stock> stock_update_list = new List <t_stock>(); #region 数据验证 if (reqmodel.Data.products.Count == 0) { result.code = ErrorCodeConst.ERROR_1042; return(result); } #endregion List <t_stock> stock_info_list = await GetStockByIds(s => new { s.id, s.freeze_quantity, s.rv }, reqmodel.Data.products.Select(s => s.id)); //检查库存 foreach (var item in reqmodel.Data.products) { //更新库存 t_stock es_stock = stock_info_list.FirstOrDefault(f => f.id == item.id); if (es_stock != null) { //添加已有的详细信息 stock_detail_list.Add(new t_stock_in_detail { order_sn = stock_in.order_sn, unit_price = item.unit_price, stock_id = item.id, quantity = item.quantity, batch_number = item.batch_number, expiration_date = item.expiration_date, instructions = item.instructions, material_number = item.material_number, model_number = item.model_number, package_size = item.package_size, product_name = item.product_name, report_card_url = item.report_card_url, retest_date = item.retest_date, spare_parts = item.spare_parts, unit_name = item.unit_name, factory_id = item.factory_id }); continue; } //添加新产品 stock_add_list.Add(new t_stock { add_time = DateTime.Now, batch_number = item.batch_number, expiration_date = item.expiration_date, instructions = item.instructions, material_number = item.material_number, model_number = item.model_number, package_size = item.package_size, product_name = item.product_name, report_card_url = item.report_card_url, retest_date = item.retest_date, spare_parts = item.spare_parts, state = (int)EnumState.Normal, status = (int)EnumStatus.Enable, unit_price = item.unit_price, util_name = item.unit_name, quantity = item.quantity,//在详情处清0 freeze_quantity = 0, factory_id = item.factory_id }); } try { g_dbHelper.Transaction(); bool insert_stock_in = await AddStockInAsync(stock_in) > 0; if (!insert_stock_in) { g_dbHelper.Rollback(); result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库单申请失败", $"用户:{reqmodel.User.user_name},添加入库单失败", models.enums.EnumLogType.Info); return(result); } if (stock_add_list.Count > 0) { foreach (var item in stock_add_list) { decimal quantity = item.quantity; item.quantity = 0; SVResult <int> add_result = await AddStock(item); if (!add_result.state) { g_dbHelper.Rollback(); result.code = add_result.code; g_logServer.Log(modelname, "入库单申请失败", $"用户:{reqmodel.User.user_name},添加新库存失败", models.enums.EnumLogType.Info); return(result); } stock_detail_list.Add(new t_stock_in_detail { order_sn = stock_in.order_sn, stock_id = add_result.data, batch_number = item.batch_number, expiration_date = item.expiration_date, factory_id = item.factory_id, instructions = item.instructions, material_number = item.material_number, model_number = item.model_number, package_size = item.package_size, product_name = item.product_name, report_card_url = item.report_card_url, retest_date = item.retest_date, spare_parts = item.spare_parts, unit_name = item.util_name, quantity = quantity, unit_price = item.unit_price, }); } } //if (stock_info_list.Count > 0) //{ // bool update_stock = await UpdateStock(u => new { u.freeze_quantity }, stock_info_list); // if (!update_stock) // { // g_dbHelper.Rollback(); // result.code = ErrorCodeConst.ERROR_1030; // g_logServer.Log(modelname, "入库单申请失败", $"用户:{reqmodel.User.user_name},更新库存失败", models.enums.EnumLogType.Info); // return result; // } //} SVResult <int> insert_stock_dtl_flag = await AddStockDetails(stock_detail_list); if (!insert_stock_dtl_flag.state) { g_dbHelper.Rollback(); result.code = insert_stock_dtl_flag.code; g_logServer.Log(modelname, "入库单申请失败", $"用户:{reqmodel.User.user_name},更新入库单详情失败", models.enums.EnumLogType.Info); return(result); } g_dbHelper.Commit(); } catch (Exception e) { g_dbHelper.Rollback(); g_logServer.Log(modelname, "入库单申请失败", $"用户:{reqmodel.User.user_name},错误信息:{e.Message}", models.enums.EnumLogType.Error); return(result); } result.code = ErrorCodeConst.ERROR_1036; result.status = ErrorCodeConst.ERROR_200; g_logServer.Log(modelname, "入库单申请成功", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn}", models.enums.EnumLogType.Info); return(result); }
/// <summary> /// @xis 入库审批 /// </summary> /// <param name="reqmodel"></param> /// <returns></returns> public async Task <Result> StockInAuditAsync(reqmodel <AuditModel> reqmodel) { const string modelname = "StockServerImpl.StockInAuditAsync"; Result result = new Result { code = ErrorCodeConst.ERROR_1037, status = ErrorCodeConst.ERROR_403 }; t_stock_in stock_in = await GetStockInByOrderSn(s => new { s.apply_process, s.apply_status, s.department_id }, reqmodel.Data.order_sn); if (stock_in == null) { result.code = ErrorCodeConst.ERROR_1038; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单不存在", EnumLogType.Info); return(result); } stock_in.order_sn = reqmodel.Data.order_sn; if (stock_in.apply_status == (int)EnumApplyStatus.Agree) { result.code = ErrorCodeConst.ERROR_1039; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},订单被审核完成", EnumLogType.Info); return(result); } if (stock_in.apply_status == (int)EnumApplyStatus.Reject) { result.code = ErrorCodeConst.ERROR_1041; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},订单被驳回", EnumLogType.Info); return(result); } IAuditServer auditServer = new AuditServerImpl(g_dbHelper, g_logServer); int? next_applyer = auditServer.GetNextApplyer(EnumOrderType.IN, stock_in.department_id, stock_in.apply_process); if (next_applyer == null) { result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},流程错误", EnumLogType.Info); return(result); } if (next_applyer != reqmodel.User.position_id) { result.code = ErrorCodeConst.ERROR_1035; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},无法进行审批", EnumLogType.Info); return(result); } t_apply_log apply_log = new t_apply_log { apply_status = reqmodel.Data.act, order_sn = reqmodel.Data.order_sn, user_id = reqmodel.User.user_id, position_id = reqmodel.User.position_id }; stock_in.apply_process = reqmodel.User.position_id; try { g_dbHelper.Transaction(); //审批记录更新 bool insert_apply_log_flag = await AddApplyLog(apply_log); if (!insert_apply_log_flag) { g_dbHelper.Rollback(); result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},添加审批记录失败", models.enums.EnumLogType.Info); return(result); } //审批状态更新 bool update_stock_in_flag; if (reqmodel.Data.act == 1) { stock_in.apply_status = (int)EnumApplyStatus.Agree; } else { //驳回 stock_in.apply_status = (int)EnumApplyStatus.Reject; } //最后一步或者拒绝则更新审批状态 EnumApplyStepFlag step_flag = auditServer.GetApplyStepFlag(EnumOrderType.IN, stock_in.department_id, reqmodel.User.position_id); if (step_flag == EnumApplyStepFlag.End || stock_in.apply_status == (int)EnumApplyStatus.Reject) { update_stock_in_flag = await UpdateStockInByOrderSn(u => new { u.apply_status, u.apply_process }, stock_in); } else { update_stock_in_flag = await UpdateStockInByOrderSn(u => new { u.apply_process }, stock_in); } if (!update_stock_in_flag) { g_dbHelper.Rollback(); result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},更新审批状态失败", models.enums.EnumLogType.Info); return(result); } //同意并且是最后一步审批,更新库存数量 if (step_flag == EnumApplyStepFlag.End && stock_in.apply_status == (int)EnumApplyStatus.Agree) { bool update_quality_flag = await StockInApplySuccess(stock_in.order_sn); if (!update_quality_flag) { g_dbHelper.Rollback(); result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库审批失败", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},更新库存数量失败", models.enums.EnumLogType.Info); return(result); } } g_dbHelper.Commit(); } catch (Exception ex) { g_dbHelper.Rollback(); result.code = ErrorCodeConst.ERROR_1030; g_logServer.Log(modelname, "入库审批异常", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn},异常信息:{ex.Message}", models.enums.EnumLogType.Error); return(result); } result.code = ErrorCodeConst.ERROR_1029; result.status = ErrorCodeConst.ERROR_200; g_logServer.Log(modelname, "入库审批成功", $"用户:{reqmodel.User.user_name},订单号:{stock_in.order_sn}", models.enums.EnumLogType.Info); return(result); }