コード例 #1
0
        public int validateRmContainer(string rawMaterialId, string purchaseOrder, string heat)
        {
            var doc     = new LT_RM_CONTAINER();
            var isValid = doc.Count(where : "WHERE HEAT=:0 AND PURCHASE_ORDER=:1 AND RAW_MTRL_ID=:2", args: new object[] { heat, purchaseOrder, rawMaterialId });

            if (isValid == 0)
            {
                log.Error("Could not find target heat: (rawMtrlId: " + rawMaterialId + ", purchaseOrderId: " + purchaseOrder + ", heat: " + heat + ") was found in the DB:  " + ConstantsEnums.connectionStringName);
                throw new Exception("The information you entered was not found in as a single record on LT_RM_CONTAINER.");
            }
            else
            {
                log.Info("Validated RM Container Data: (rawMtrlId: " + rawMaterialId + ", purchaseOrderId: " + purchaseOrder + ", heat: " + heat + ") was found in the DB: " + ConstantsEnums.connectionStringName);
            }

            return(isValid);
        }
コード例 #2
0
        /// <summary>
        /// Validate a raw material heat
        /// </summary>
        /// <returns>string - heat</returns>
        public string validateHeat()
        {
            string _heat = promptForRename("Must provide a Heat to proceed.");

            //Validate that the receiver is in Visual before proceeding.
            var doc     = new LT_RM_CONTAINER();
            var isValid = doc.Count(where : "WHERE HEAT=:0", args: _heat);

            if (isValid != 1)
            {
                log.Error("Could not find target heat: (" + targetRenamed + ") in the DB: " + ConstantsEnums.connectionStringName);
                throw new Exception("The Heat you entered is not found in Raw Material Maintenance.");
            }
            else
            {
                log.Info("target file: (" + targetRenamed + ") was found in the DB: " + ConstantsEnums.connectionStringName);
            }
            return(_heat);
        }