using Kingdee.BOS;
|
using Kingdee.BOS.Core;
|
using Kingdee.BOS.Core.DynamicForm.PlugIn;
|
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
|
using Kingdee.BOS.Core.Validation;
|
using Kingdee.BOS.ServiceHelper;
|
using Kingdee.BOS.Util;
|
using System;
|
using System.ComponentModel;
|
|
namespace Demo.BillView.PRD
|
{
|
[Description("[日计划工单保存] 校验器"), HotUpdate]
|
public class SalOrderSaveVal : AbstractOperationServicePlugIn
|
{
|
public override void OnPreparePropertys(PreparePropertysEventArgs e)
|
{
|
base.OnPreparePropertys(e);
|
}
|
//自定义校验器
|
public override void OnAddValidators(AddValidatorsEventArgs e)
|
{
|
base.OnAddValidators(e);
|
TestValidator validator = new TestValidator();
|
validator.AlwaysValidate = true;
|
validator.EntityKey = "FBillHead";
|
e.Validators.Add(validator);
|
}
|
/// <summary>
|
/// 保存单据头校验器
|
/// </summary>
|
private class TestValidator : AbstractValidator
|
{
|
public override void Validate(ExtendedDataEntity[] dataEntities, ValidateContext validateContext, Context ctx)
|
{
|
//for循环,读取数据
|
foreach (var data in dataEntities)
|
{
|
var FID = data.DataEntity["Id"]?.ToString();//日计划工单FID
|
var FPRDMOENTYID = Convert.ToInt32(data.DataEntity["FPRDMOENTYID"]?.ToString());//生产订单明细 FentryID
|
var FSRCBILLENTRYSEQ = data.DataEntity["FSRCBILLENTRYSEQ"]?.ToString();//生产订单明细行号
|
var FSCOrderNo = data.DataEntity["FSCOrderNo"]?.ToString(); //生产订单号
|
var FDayPlanQuantity = Convert.ToDecimal(data.DataEntity["FDayPlanQuantity"]?.ToString()); //日计划数量总量
|
|
var FMOENTRYID = Convert.ToInt32(data.DataEntity["FMOENTRYID"]?.ToString());//生产订单明细 FMOENTRYID(新)
|
var FMoBillNo = data.DataEntity["FMoBillNo"]?.ToString();//生产订单号 FMOENTRYID(新)
|
var FMoSeq = 1;//生产订单明细行号(新)
|
|
if (FMOENTRYID == 0 || FMOENTRYID == FPRDMOENTYID)
|
{
|
var FOrderQuantity = DBServiceHelper.ExecuteScalar<decimal>(Context, "select Fqty from t_prd_moentry where fentryid ="+ FPRDMOENTYID.ToString(), 0);
|
string sql = $"select convert(decimal(18,2),sum(FDayPlanQuantity)) from Sc_WorkBillSortBillMain where FPRDMOENTYID = {FPRDMOENTYID} and (FMoEntryId = 0 or FMoEntryId = FPRDMOENTYID ) and FID <>{FID}";
|
decimal FOrderCount = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
|
LogService.Write("sql:" + sql);
|
LogService.Write("FOrderCount:" + FOrderCount);
|
|
bool isSave = FOrderCount + FDayPlanQuantity > FOrderQuantity;
|
if (isSave)
|
{
|
string err = $"生产订单号：{FSCOrderNo}，生产订单明细行号：{FSRCBILLENTRYSEQ}，生产订单数量：{FOrderQuantity}，已有日计划数量{FOrderCount}，本次计划数量：{FDayPlanQuantity}，将超出生产订单总数量";
|
//报错
|
validateContext.AddError(data.DataEntity,
|
new ValidationErrorInfo
|
("PurchaserId",//出错的字段Key，可以空
|
data.DataEntity["Id"].ToString(),// 出错的字段Key，可以空
|
data.DataEntityIndex, // 出错的数据包在全部数据包中的顺序
|
data.RowIndex,// 出错的数据行在全部数据行中的顺序，如果校验基于单据头，此为0
|
"001",//错误编码，可以任意设定一个字符，主要用于追查错误来源
|
"单据编号" + data.BillNo + err,//错误的详细提示信息
|
"保存" + data.BillNo,// 错误的简明提示信息
|
Kingdee.BOS.Core.Validation.ErrorLevel.Error// 错误级别：警告、错误...
|
));
|
}
|
}
|
else//新生产订单
|
{
|
string _sql = string.Format(@"
|
select convert(decimal(18,2),sum(FDayPlanQuantity)) from
|
(
|
select FDayPlanQuantity
|
from Sc_WorkBillSortBillMain t1
|
where FMOENTRYID ={0} and FID <>{1}
|
|
union
|
|
select FDayPlanQuantity
|
from Sc_WorkBillSortBillMain t1
|
where FPRDMOENTYID ={0} and FMOENTRYID in({0},0 )
|
and FID <> {1}
|
) t1", FMOENTRYID, FID);
|
LogService.Write("_sql:"+ _sql);
|
//string sql = $"select convert(decimal(18,2),sum(FDayPlanQuantity)) from Sc_WorkBillSortBillMain where FMoEntryId = {FMOENTRYID} and FID <>{FID}";
|
decimal FOrderCount = DBServiceHelper.ExecuteScalar<decimal>(Context, _sql, 0);
|
var FOrderQuantity = DBServiceHelper.ExecuteScalar<decimal>(Context, "select Fqty from t_prd_moentry where fentryid =" + FMOENTRYID.ToString(), 0);
|
//LogService.Write("FOrderCount:" + FOrderCount);
|
bool isSave = FOrderCount + FDayPlanQuantity > FOrderQuantity;
|
if (isSave)
|
{
|
string err = $"生产订单号：{FMoBillNo}，生产订单明细行号：{FMoSeq}，生产订单数量：{FOrderQuantity}，已有日计划数量{FOrderCount}，本次计划数量：{FDayPlanQuantity}，将超出生产订单总数量";
|
//报错
|
validateContext.AddError(data.DataEntity,
|
new ValidationErrorInfo
|
("PurchaserId",//出错的字段Key，可以空
|
data.DataEntity["Id"].ToString(),// 出错的字段Key，可以空
|
data.DataEntityIndex, // 出错的数据包在全部数据包中的顺序
|
data.RowIndex,// 出错的数据行在全部数据行中的顺序，如果校验基于单据头，此为0
|
"001",//错误编码，可以任意设定一个字符，主要用于追查错误来源
|
"单据编号" + data.BillNo + err,//错误的详细提示信息
|
"保存" + data.BillNo,// 错误的简明提示信息
|
Kingdee.BOS.Core.Validation.ErrorLevel.Error// 错误级别：警告、错误...
|
));
|
}
|
}
|
}
|
}
|
}
|
}
|
}
|
