public static byte GetMaterialPostion(string _materialNo)
        {
            _materialNameTable = _materialInfoAdapter.GetMaterialNameByMaterialNo(_materialNo);

            foreach (var val in _materialNameTable)
            {
                if (val.Position > 0 && val.Position < 20)
                {
                    return(val.Position);
                }
            }
            return(0xFF);
        }
        public static string GetMaterialName(string _materialNo)
        {
            _materialNameTable = _materialInfoAdapter.GetMaterialNameByMaterialNo(_materialNo);

            foreach (var val in _materialNameTable)
            {
                if (!val.IsMaterialNameNull())
                {
                    return(val.MaterialName);
                }
            }
            return("");
        }
        public static Mubea_BTDataSet.MaterialsInfoDataTable GetMaterialInfos()
        {
            _materialInfoTable = _materialInfoAdapter.GetData();

            return(_materialInfoTable);
        }
        /// <summary>
        ///  common query, just use applydate as the filter
        /// </summary>
        /// <param name="_applyDate"></param>
        /// <returns></returns>
        public static Mubea_BTDataSet.MaterialsInfoDataTable GetMaterialInfo(string _materialNo)
        {
            _materialInfoTable = _materialInfoAdapter.GetMaterialInfoByMaterialNo(_materialNo);

            return(_materialInfoTable);
        }