public override void BeforeSave(Kingdee.BOS.Core.Bill.PlugIn.Args.BeforeSaveEventArgs e)
{
DynamicObject BillHead = this.Model.DataObject;
if (BillHead["SZXY_SFDEntry"] is DynamicObjectCollection entry)
{
foreach (var item in entry.Where(m => !Convert.ToString(m["F_SZXY_SFNO"]).IsNullOrEmptyOrWhiteSpace()))
{
DateTime Stime = Convert.ToDateTime(item["F_SZXY_STIME"]);
DateTime Etime = Convert.ToDateTime(item["F_SZXY_ETIME"]);
int S = DateTime.Compare(Stime, Etime);
if (S > 0)
{
throw new Exception($"开始时间不能大于结束时间！！");
}
int E = DateTime.Compare(Etime, Stime);
if (E < 0)
{
throw new Exception($"结束时间不能大于开始时间！！");
}
}
}
base.BeforeSave(e);
}
public override void BeforeSave(Kingdee.BOS.Core.Bill.PlugIn.Args.BeforeSaveEventArgs e)
{
// 获取销售出库单明细行
DynamicObjectCollection col1 = this.View.Model.DataObject["SAL_OUTSTOCKENTRY"] as DynamicObjectCollection;
// 遍历物料明细行
for (int i = 0; i < col1.Count; i++)
{
// 获取当前行的物料编码信息
DynamicObject materialObj = col1[i]["MaterialID"] as DynamicObject;
if (materialObj != null)
{
// 获取当前物料的内码
long materialId = Convert.ToInt64(materialObj["Id"]);
// 获取当前物料行的批号
String lotNo = Convert.ToString(col1[i]["Lot_Text"]);
// 通过该销售订单单号获取生产入库单中该物料的全部的入库重量
StringBuilder tmpSQL0 = new StringBuilder();
tmpSQL0.AppendFormat(@"/*dialect*/SELECT
SUM (E.FREALQTY) INNUM,
SUM (E.F_SCFG_GENUM) GENUM,
SUM (F_SCFG_M2NUM) M2NUM,
SUM (F_SCFG_ZHANGNUM) ZHANGNUM
FROM
T_SP_INSTOCKENTRY E
LEFT JOIN T_SP_INSTOCK S ON E.FID = S.FID
WHERE
S.FDOCUMENTSTATUS = 'C'
AND E.FLOT_TEXT = '{0}'
AND E.FMATERIALID = '{1}'", lotNo, materialId);
DynamicObjectCollection col0 = DBUtils.ExecuteDynamicObject(this.Context, tmpSQL0.ToString());
if (col0 != null && col0.Count > 0)
{
// 该物料的全部实际入库重量
double realInWeight = Convert.ToDouble(col0[0]["INNUM"]); // 该物料全部已入库的数量
// 获取当前物料行的订单单号
String saleBillNo = Convert.ToString(col0[0]["SoorDerno"]);
// 查询该物料历史出库总数量
StringBuilder querySQL0 = new StringBuilder();
querySQL0.AppendFormat(@"/*dialect*/ SELECT SUM(FREALQTY) OUTNUM,
SUM(F_SCFG_M2NUM) M2NUM,
SUM(F_SCFG_ZHANGNUM) ZHANGNUM,
SUM(F_SCFG_GENUM) GENUM
FROM T_SAL_OUTSTOCKENTRY E
LEFT JOIN T_SAL_OUTSTOCKENTRY_R ER ON E.FID = ER.FID
LEFT JOIN T_SAL_OUTSTOCK S ON S.FID = E.FID
WHERE S.FDOCUMENTSTATUS = 'C' AND ER.FSOORDERNO = '{0}' AND E.FMATERIALID = {1} ", saleBillNo, materialId);
DynamicObjectCollection col00 = DBUtils.ExecuteDynamicObject(this.Context, querySQL0.ToString());
if (col00 != null && col00.Count > 0)
{
// 该物料在该订单中已出库数量
double realOutWeight = Convert.ToDouble(col00[0]["OUTNUM"]);
// 销售出库单中的物料出库数量
double realWeight = Convert.ToDouble(col1[i]["RealQty"]);
// 根据物料条码查找条码主档中的数量字段得到公斤数，根据动态换算关系计算5个计量单位的数量，并赋值到各个字段上
StringBuilder tmpSQL2 = new StringBuilder();
tmpSQL2.AppendFormat(@"/*dialect*/ SELECT * FROM T_scfg_MaterialConvert MC LEFT JOIN T_BD_UNIT_L UL ON UL.FUNITID = MC.FUNITID WHERE MC.FMATERIALNUMBER = '{0}' AND F_SCFG_LOTNO = '{1}' ", materialId, lotNo);//批号 对应简单生产入库的出库
DynamicObjectCollection col2 = DBUtils.ExecuteDynamicObject(this.Context, tmpSQL2.ToString());
if (col2 != null && col2.Count > 0)
{
// 遍历当前物料的标准称重单位（公斤）与其他称重单位的转换参数
foreach (DynamicObject obj2 in col2)
{
// 目标称重单位数量
double rate1 = Convert.ToDouble(obj2["FQTY"]);
// 计算公斤数量转换为各个称重单位的数值
double realOtherWeight = Math.Round((double)(realWeight * rate1), 2, MidpointRounding.AwayFromZero);
StringBuilder tmpSQL3 = new StringBuilder();
String where = "";
String key = "";
switch (Convert.ToString(obj2["FNAME"]))
{
case "平方米":
where = "F_SCFG_M2NUM";
key = "M2NUM";
break;
case "张":
where = "F_SCFG_ZHANGNUM";
key = "ZHANGNUM";
break;
case "个":
where = "F_SCFG_GENUM";
key = "GENUM";
break;
default:
break;
}
if (!String.IsNullOrWhiteSpace(where) && !String.IsNullOrWhiteSpace(key))
{
if ((0 == realOutWeight) && (realWeight == realInWeight))
{
this.View.Model.SetValue(where, Convert.ToDouble(col0[0][key]), i);
}
else
{
if ((realOutWeight + realWeight) < realInWeight)
{
this.View.Model.SetValue(where, realOtherWeight, i);
}
else
{
// 需要进行平尾差操作
this.View.Model.SetValue(where, Convert.ToDouble(col0[0][key]) - Convert.ToDouble(col00[0][key]), i);
}
}
}
}
}
}
}
}
}
base.BeforeSave(e);
}
public override void BeforeSave(Kingdee.BOS.Core.Bill.PlugIn.Args.BeforeSaveEventArgs e)
{
// 获取销售出库单明细行
DynamicObjectCollection col1 = this.View.Model.DataObject["SAL_OUTSTOCKENTRY"] as DynamicObjectCollection;
// 遍历物料明细行
for (int i = 0; i < col1.Count; i++)
{
// 获取当前行的物料编码信息
DynamicObject materialObj = col1[i]["MaterialID"] as DynamicObject;
if (materialObj != null)
{
// 获取当前物料的内码
long materialId = Convert.ToInt64(materialObj["Id"]);
// 获取当前物料行的批号
String lotNo = Convert.ToString(col1[i]["Lot_Text"]);
// 根据物料条码查找条码主档中的数量字段得到公斤数，根据动态换算关系计算5个计量单位的数量，并赋值到各个字段上
StringBuilder tmpSQL2 = new StringBuilder();
tmpSQL2.AppendFormat(@"/*dialect*/ SELECT * FROM T_scfg_MaterialConvert MC LEFT JOIN T_BD_UNIT_L UL ON UL.FUNITID = MC.FUNITID WHERE MC.FMATERIALNUMBER = '{0}' AND F_SCFG_LOTNO = '{1}' ", materialId, lotNo);//批号 对应简单生产入库的出库
DynamicObjectCollection col2 = DBUtils.ExecuteDynamicObject(this.Context, tmpSQL2.ToString());
// 销售出库单中的物料出库数量
double realWeight = Convert.ToDouble(col1[i]["RealQty"]);
if (col2 != null && col2.Count > 0)
{
// 遍历当前物料的标准称重单位（公斤）与其他称重单位的转换参数
foreach (DynamicObject obj2 in col2)
{
// 目标称重单位数量
double rate1 = Convert.ToDouble(obj2["FQTY"]);
// 计算公斤数量转换为各个称重单位的数值
double realOtherWeight = Math.Round((double)(realWeight * rate1), 2, MidpointRounding.AwayFromZero);
StringBuilder tmpSQL3 = new StringBuilder();
String where = "";
String key = "";
switch (Convert.ToString(obj2["FNAME"]))
{
case "平方米":
where = "F_SCFG_M2NUM";
key = "M2NUM";
break;
case "张":
where = "F_SCFG_ZHANGNUM";
key = "ZHANGNUM";
break;
case "个":
where = "F_SCFG_GENUM";
key = "GENUM";
break;
case "箱":
where = "F_SCFG_MULNUM";
key = "MULNUM";
break;
default:
break;
}
if (!String.IsNullOrWhiteSpace(where) && !String.IsNullOrWhiteSpace(key))
{
this.View.Model.SetValue(where, Convert.ToDouble(realOtherWeight), i);
}
if (where.Equals("F_SCFG_MULNUM"))
{
this.View.Model.SetValue(where, Convert.ToDouble(Math.Ceiling(realOtherWeight)), i);
}
}
}
}
}
base.BeforeSave(e);
}