public string UpdateBlockTime(IPS_Invoice model) { string message = ""; // 开启事务 using (IDbContextTransaction dbContextTransaction = iPSContext.Database.BeginTransaction()) { try { IPS_Invoice iPS_Invoice = GetWorkQueueDetail(model, string.Empty); iPS_Invoice.BLOCK = true; iPS_Invoice.BLOCKTIME = DateTime.Now; iPSContext.iPS_Invoices.Update(iPS_Invoice); iPSContext.SaveChanges(); message = "True"; //提交事务 dbContextTransaction.Commit(); } catch(Exception e) { message = "False"; //回滚 dbContextTransaction.Rollback(); } } return message; }
时间: 2024-02-10 10:27:04 浏览: 171
在你提供的代码中,参数 `model` 是通过方法 `UpdateBlockTime` 接收的。如果你说无法获取到参数,可能是因为参数 `model` 的值没有正确传递给该方法。
请确保在调用 `UpdateBlockTime` 方法时,传递了有效的 `IPS_Invoice` 对象作为参数。例如,你可以使用类似以下的代码进行调用:
```csharp
IPS_Invoice invoice = new IPS_Invoice();
// 设置 invoice 的属性值
string result = UpdateBlockTime(invoice);
```
另外,在你的代码中,你在更新 `iPS_Invoice` 对象后并调用了 `iPSContext.SaveChanges()` 方法保存更改。如果你说无法获取到参数,可能是因为在保存更改之前,`model` 参数的值并没有正确传递给 `GetWorkQueueDetail` 方法。请确保在调用 `GetWorkQueueDetail` 方法之前,`model` 参数的值已经正确设置。
如果上述方法仍然无法解决问题,请提供更多相关的代码或上下文信息,以便我能够更好地帮助你解决问题。
相关问题
<el-tabs v-if="orderInvoiceData.length" class='invoice_list' v-model="currentOrderTab" @tab-click="clickOrderTab"> <el-tab-pane :label="numToStr(order.order_info.order_no)" :name="numToStr(order.order_info.order_no)" :key="order.order_info.order_no" v-for="order in orderInvoiceData"> <el-tabs v-if="!order.order_info.is_error" tab-position="left" style="height:calc(100% - 96px);" v-model="currentInvoiceTab"> <el-tab-pane :label="invoice.invoice_info.label" :key="invoice.invoice_info.label" :name="invoice.invoice_info.name" v-for='(invoice, index) in order.invoiceList'> </el-tab-pane> </el-tabs> </el-tab-pane> </el-tabs> 如何点击第一个el-tabs时,触发第二个el-tabs
可以通过在第一个 `el-tabs` 的 `tab-click` 事件中,根据当前选中的订单信息来动态修改第二个 `el-tabs` 的 `v-model` 值,从而触发选中对应的标签页。具体实现代码如下:
```vue
<el-tabs v-if="orderInvoiceData.length" class='invoice_list' v-model="currentOrderTab" @tab-click="clickOrderTab">
<el-tab-pane :label="numToStr(order.order_info.order_no)" :name="numToStr(order.order_info.order_no)"
:key="order.order_info.order_no" v-for="order in orderInvoiceData">
<el-tabs v-if="!order.order_info.is_error" tab-position="left" style="height:calc(100% - 96px);"
v-model="currentInvoiceTab[index]">
<el-tab-pane :label="invoice.invoice_info.label" :key="invoice.invoice_info.label"
:name="invoice.invoice_info.name" v-for='(invoice, index) in order.invoiceList'>
</el-tab-pane>
</el-tabs>
</el-tab-pane>
</el-tabs>
```
```javascript
data() {
return {
currentOrderTab: '', // 第一个 el-tabs 的 v-model
currentInvoiceTab: [] // 第二个 el-tabs 的 v-model 数组,每个元素对应一个订单的标签页选中状态
}
},
methods: {
clickOrderTab(tab) {
// 获取当前选中的订单信息
const order = this.orderInvoiceData.find(item => item.order_info.order_no === Number(tab.name));
if (order && !order.order_info.is_error) {
// 根据当前订单信息修改第二个 el-tabs 的选中状态
this.currentInvoiceTab.splice(this.orderInvoiceData.indexOf(order), 1, order.invoiceList[0].invoice_info.name);
}
}
}
```
这段代码中,我们在 `data` 中新增了一个数组 `currentInvoiceTab`,用来存储每个订单对应的第二个 `el-tabs` 的选中状态。然后在点击第一个 `el-tabs` 的 `tab-click` 事件中,将当前选中的订单信息找出来,根据订单信息修改相应的 `currentInvoiceTab` 的元素值,从而触发第二个 `el-tabs` 的选中状态改变,达到自动切换到对应的标签页的效果。
检测一下以下的xml是否符合oracle规范,有没有错误<select id="selectInvoiceFlowDetailAndRelationByOriginalAccountLineNumber" parameterType="com.baiwang.docmanagement.model.dto.DocInvoiceFlowDetailDataDto" resultMap="invoiceDetailAndRelationMap"> SELECT detail.id, detail.parent_id, detail.account_line_number , relation.invoice_no , relation.invoice_code FROM ( SELECT id , account_line_number, parent_id FROM doc_invoice_flow_detail_data WHERE tenant_id = #{invoiceFlowDetail.tenantId,jdbcType=BIGINT} AND account_line_number IN <foreach close=")" collection="invoiceFlowDetail.accountLineNumberList" item="item" open="(" separator=","> #{item} </foreach> ) detail LEFT JOIN( SELECT invoice_no , invoice_code , flow_detail_id FROM doc_invoice_flow_relation_detail_data WHERE tenant_id = #{invoiceFlowDe2tail.tenantId,jdbcType=} ) relation ON detail.id = relation.flow_detail_id </select>
以下是格式化后的代码,没有语法错误,符合Oracle规范:
```xml
<select id="selectInvoiceFlowDetailAndRelationByOriginalAccountLineNumber"
parameterType="com.baiwang.docmanagement.model.dto.DocInvoiceFlowDetailDataDto"
resultMap="invoiceDetailAndRelationMap">
SELECT
detail.id,
detail.parent_id,
detail.account_line_number,
relation.invoice_no,
relation.invoice_code
FROM
(
SELECT
id,
account_line_number,
parent_id
FROM
doc_invoice_flow_detail_data
WHERE
tenant_id = #{invoiceFlowDetail.tenantId,jdbcType=BIGINT}
AND account_line_number IN
<foreach close=")" collection="invoiceFlowDetail.accountLineNumberList"
item="item" open="(" separator=",">
#{item}
</foreach>
) detail
LEFT JOIN (
SELECT
invoice_no,
invoice_code,
flow_detail_id
FROM
doc_invoice_flow_relation_detail_data
WHERE
tenant_id = #{invoiceFlowDetail.tenantId,jdbcType=BIGINT}
) relation ON detail.id = relation.flow_detail_id
</select>
```
阅读全文
相关推荐













