日计划导入增加删除用料清单审核状态验证 齐套信息明细 颜色渲染更改

王 垚

2021-03-06 d3835d49a3c673a37c78a79600320e287d4d320b

日计划导入增加删除用料清单审核状态验证
齐套信息明细 颜色渲染更改

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

@@ -20,6 +20,7 @@
        bool did = false;
        string FHICMOInterID = "";//日计划工单内码
        string tempName = "JIT_MOMaterReadysBill";//表名称

        public override void OnLoad(EventArgs e)
        {
            LogHelper.Info("[齐套分析明细加载列表]");
@@ -66,6 +67,7 @@
                did = true;
            }
        }

        private void ChangeColor()
        {
            Entity entity = this.View.BillBusinessInfo.GetEntity("FEntity");
@@ -79,6 +81,10 @@
                {
                    grid.SetRowBackcolor("#71FF98CB", _i);
                }
                else
                {
                    grid.SetRowBackcolor("#ffffff", _i);
                }
                _i++;
            }
        }

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

@@ -277,6 +277,23 @@
                    this.View.ShowErrMessage(_result);
                    return;
                }
                //校验生产用料清单是否审核
                foreach (DynamicObject current in entityDataObjoct)
                {
                    //根据生产订单号和物料查询是否存在明细 +生产订单明细行号
                    sql = string.Format(@"/*dialect*/SELECT FBILLNO FROM T_PRD_PPBOM T1
WHERE T1.FMOBILLNO = '{0}'  AND T1.FMATERIALID = '{1}' AND T1.FMOENTRYSEQ = '{2}' and FDOCUMENTSTATUS <>'C'                          
", Convert.ToString(current["FSCOrderNo"]), Convert.ToString(current["FMatrailId_Id"]), Convert.ToString(current["FSRCBILLENTRYSEQ"]));
                    DataTable dt = new DataTable();
                    dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
                    if (dt.Rows.Count > 0)
                        _result += "序号：" + Convert.ToString(current["SEQ"]) + ",生产订单号：" + Convert.ToString(current["FSCOrderNo"]) + ",生产订单明细行号：" + Convert.ToString(current["FSRCBILLENTRYSEQ"]) + "物料" + (current["FMatrailId"] as DynamicObject)["Number"] + "对应的生产用料清单：" + dt.Rows[0][0] + "未审核";
                }
                if (_result != "")
                {
                    this.View.ShowErrMessage(_result);
                    return;
                }
                foreach (DynamicObject current in entityDataObjoct)
                {
                    if (Convert.ToInt32(current["FNoScheduled"]) < 0)

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

@@ -15,15 +15,6 @@

namespace Demo.DynamicForm.PRD
{
    /// <summary>
    /// 插件示例：引入销售出库单，建立与销售订单的关联
    /// </summary>
    /// <remarks>
    /// 要求：
    /// 1. 需要引入单据体的源单类型、源单编号字段
    /// 2. 本插件挂在销售出库单的保存操作上
    /// 出库关联销售订单
    /// </remarks>
    [Description("送货计划单插件关联提料计划单")]
    [HotUpdate]
    public class Pro_TlPushAudit : AbstractOperationServicePlugIn