日计划用料清单变更单rowchange事件

王 垚

2021-03-01 b7cf501ec0fbf33aba3d2230bec8219b820b7835

 src/BLL/Demo.BillView/PRD/Pro_DayPlanBG.cs

@@ -36,9 +36,10 @@
            double FHQty = Convert.ToDouble(model.GetValue("FHQty"));
            if (e.Field.Key.Contains("FUseRateNew"))
            {
                if (e.OldValue == e.NewValue)
                if (e.OldValue == e.NewValue||e.NewValue==null)
                    return;
                var m = e.Row;
              

                double FNumerator = Convert.ToDouble(model.GetValue("FNumerator", e.Row));//分子
                double FDenominator = Convert.ToDouble(model.GetValue("FDenominator", e.Row));//分母
                double FUseRateNew = Convert.ToDouble(model.GetValue("FUseRateNew", e.Row));//使用比例
@@ -49,16 +50,26 @@
                }
                Hqty = Math.Ceiling((FNumerator / FDenominator) * FHQty * (FUseRateNew / 100));
                this.View.Model.SetValue("FHQtyMustNew", Hqty, e.Row);//新计划数量
                

                int FentryID = Convert.ToInt32(model.GetEntryPKValue("FEntity",e.Row));//明细表id
                //查询同项次的序号
                string sql = 
                    $"select top 1 FSEQ from Sc_DayPlanPPBomBillSubBG where FReplaceGroup in(select FReplaceGroup from Sc_DayPlanPPBomBillSubBG where FEntryID = {FentryID} )and FEntryID<> { FentryID} ";
                int Fseq = DBServiceHelper.ExecuteScalar<int>(Context,sql,0);
                if (Fseq > 0) {
                    this.View.Model.SetValue("FUseRateNew", 100 - FUseRateNew, Fseq - 1);//新计划数量
                }
                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.ToDouble(e.NewValue), seq - 1);
                //int FentryID = Convert.ToInt32(model.GetEntryPKValue("FEntity",e.Row));//明细表id
                ////查询同项次的序号
                //string sql = 
                //    $"select top 1 FSEQ from Sc_DayPlanPPBomBillSubBG where FReplaceGroup in(select FReplaceGroup from Sc_DayPlanPPBomBillSubBG where FEntryID = {FentryID} )and FEntryID<> { FentryID} ";
                //int Fseq = DBServiceHelper.ExecuteScalar<int>(Context,sql,0);
                //if (Fseq > 0) {
                //    this.View.Model.SetValue("FUseRateNew", 100 - FUseRateNew, Fseq - 1);//新计划数量
                //}
            }
            if (e.Field.Key.Contains("FHQtyMustNew"))
            {
@@ -76,16 +87,16 @@
                Hqty = Math.Ceiling(FHQtyMustNew / ((FNumerator / FDenominator) * FHQty) * 100);
                this.View.Model.SetValue("FUseRateNew", Hqty, e.Row);//新计划数量

                int FentryID = Convert.ToInt32(model.GetEntryPKValue("FEntity", e.Row));//明细表id
                //查询同项次的序号
                string sql =
                    $"select top 1 FSEQ from Sc_DayPlanPPBomBillSubBG where FReplaceGroup in(select FReplaceGroup from Sc_DayPlanPPBomBillSubBG where FEntryID = {FentryID} )and FEntryID<> { FentryID} ";
                int Fseq = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
                if (Fseq > 0)
                {
                    double FUseRateNew = Convert.ToDouble(model.GetValue("FUseRateNew", e.Row));//使用比例
                    this.View.Model.SetValue("FUseRateNew", 100 - FUseRateNew, Fseq - 1);//新计划数量
                }
                //int FentryID = Convert.ToInt32(model.GetEntryPKValue("FEntity", e.Row));//明细表id
                ////查询同项次的序号
                //string sql =
                //    $"select top 1 FSEQ from Sc_DayPlanPPBomBillSubBG where FReplaceGroup in(select FReplaceGroup from Sc_DayPlanPPBomBillSubBG where FEntryID = {FentryID} )and FEntryID<> { FentryID} ";
                //int Fseq = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
                //if (Fseq > 0)
                //{
                //    double FUseRateNew = Convert.ToDouble(model.GetValue("FUseRateNew", e.Row));//使用比例
                //    this.View.Model.SetValue("FUseRateNew", 100 - FUseRateNew, Fseq - 1);//新计划数量
                //}
            }
        }