using System;
|
using System.ComponentModel;
|
using System.Data;
|
using Kingdee.BOS.Core.Bill.PlugIn;
|
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
|
using Kingdee.BOS.Orm.DataEntity;
|
using Kingdee.BOS.ServiceHelper;
|
using ZD.Cloud.WebApi;
|
using System.Linq;
|
using Kingdee.BOS.Core.Bill.PlugIn.Args;
|
using Kingdee.K3.SCM.Core;
|
|
namespace Demo.BillView.PRD
|
{
|
/// <summary>
|
/// 日计划用料清单变更单 表单插件
|
/// </summary>
|
[Description("日计划用料清单变更单表单插件")]
|
[Kingdee.BOS.Util.HotUpdate]
|
public class Pro_DayPlanBG : AbstractBillPlugIn
|
{
|
CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");
|
|
public override void DataChanged(DataChangedEventArgs e)
|
{
|
base.DataChanged(e);
|
var model = this.View.Model;
|
decimal FHQty = Convert.ToDecimal(model.GetValue("FHQty"));
|
if (e.Field.Key.Contains("FUseRateNew"))
|
{
|
if (e.OldValue == e.NewValue || e.NewValue == null)
|
return;
|
decimal FNumerator = Convert.ToDecimal(model.GetValue("FNumerator", e.Row));//分子
|
decimal FDenominator = Convert.ToDecimal(model.GetValue("FDenominator", e.Row));//分母
|
decimal FUseRateNew = Convert.ToDecimal(model.GetValue("FUseRateNew", e.Row));//使用比例
|
decimal Hqty;
|
if (FNumerator == 0 || FDenominator == 0)
|
{
|
Hqty = Math.Ceiling(FHQty * (FUseRateNew / 100));
|
}
|
Hqty = Math.Ceiling((FNumerator / FDenominator) * FHQty * (FUseRateNew / 100));
|
this.View.Model.SetValue("FHQtyMustNew", Hqty, e.Row);//新计划数量
|
var m = e.Row;
|
//项次
|
var pro = model.GetValue("FReplaceGroup", m).ToString();
|
var entrys = model.DataObject.GetValue<DynamicObjectCollection>("FEntity");
|
//LogService.WriteAsync(entrys);
|
//查找到的同批项次
|
var finds = entrys.Where(entry => entry.GetValue<string>("FReplaceGroup") == pro && entry.GetValue<int>("Seq") != (m + 1));
|
if (finds.Count() == 0) return;
|
var seq = finds.First().GetValue<int>("Seq");
|
model.SetValue("FUseRateNew", 100 - Convert.ToDecimal(e.NewValue), seq - 1);
|
}
|
if (e.Field.Key.Contains("FHQtyMustNew"))
|
{
|
if (e.OldValue == e.NewValue || e.NewValue == null)
|
return;
|
var m = e.Row;
|
decimal FNumerator = Convert.ToDecimal(model.GetValue("FNumerator", e.Row));//分子
|
decimal FDenominator = Convert.ToDecimal(model.GetValue("FDenominator", e.Row));//分母
|
decimal FHQtyMustNew = Convert.ToDecimal(model.GetValue("FHQtyMustNew", e.Row));//新计划数量
|
decimal Hqty;
|
decimal zero = 0;
|
if (FNumerator == 0 || FDenominator == 0)
|
{
|
Hqty = Math.Ceiling(FHQtyMustNew / FHQty * 100);
|
}
|
Hqty = Math.Ceiling(FHQtyMustNew / ((FNumerator / FDenominator) * FHQty) * 100);
|
this.View.Model.SetValue("FUseRateNew", Hqty, e.Row);//新用料比例
|
}
|
}
|
|
public override void BeforeSave(BeforeSaveEventArgs e)
|
{
|
base.BeforeSave(e);
|
var entrys = this.View.Model.DataObject.GetValue<DynamicObjectCollection>("FEntity");
|
string resultMes = "";
|
foreach (var entry in entrys)
|
{
|
var fReplaceGroup = entry["FReplaceGroup"].ToString();
|
//LogService.WriteAsync(entrys);
|
//查找到的同批项次
|
var finds = entrys.Where(trys => trys.GetValue<string>("FReplaceGroup") == fReplaceGroup);
|
if (finds.Count() > 1) return;
|
|
string sql = string.Format(@"/*dialect*/
|
select count(*) from Sc_DayPlanPPBomBillSub a
|
join Sc_DayPlanPPBomBillMain b on a.FID = b.FID
|
where FREPLACEGROUP = '{0}' and FHMaterSubID<> '{1}' and(FPickedQty + FTranslateQty) > FHQty * ((100 - {2}) / 100.0) * FDwyl and a.FID = {3}", entry["FReplaceGroup"].ToString(), entry["FHMaterSubID_Id"].ToString(), entry["FUseRateNew"].ToString(), entry["FDayPlanId"].ToString());
|
int result = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
|
if (result > 0)
|
resultMes += $"行号:" + entry["Seq"].ToString() + ",存在替代料关系，使用比例变更后超出了领用数量";
|
}
|
if (resultMes != "")
|
{
|
e.Cancel = true;
|
this.View.ShowErrMessage(resultMes);
|
}
|
|
}
|
}
|
}
|
