Пример #1
0
        public M_Vendor_Entity M_Vendor_Select(M_Vendor_Entity mve)
        {
            DataTable dtVendor = mvdl.M_Vendor_Select(mve);

            if (dtVendor.Rows.Count > 0)
            {
                mve.ShoguchiFlg        = dtVendor.Rows[0]["ShoguchiFlg"].ToString();
                mve.VendorName         = dtVendor.Rows[0]["VendorName"].ToString();
                mve.VendorShortName    = dtVendor.Rows[0]["VendorShortName"].ToString(); // Add By SawLay
                mve.VendorKana         = dtVendor.Rows[0]["VendorKana"].ToString();
                mve.VendorLongName1    = dtVendor.Rows[0]["VendorLongName1"].ToString();
                mve.VendorLongName2    = dtVendor.Rows[0]["VendorLongName2"].ToString();
                mve.VendorPostName     = dtVendor.Rows[0]["VendorPostName"].ToString();
                mve.VendorPositionName = dtVendor.Rows[0]["VendorPositionName"].ToString();
                mve.VendorStaffName    = dtVendor.Rows[0]["VendorStaffName"].ToString();
                mve.ZipCD1             = dtVendor.Rows[0]["ZipCD1"].ToString();
                mve.ZipCD2             = dtVendor.Rows[0]["ZipCD2"].ToString();
                mve.Address1           = dtVendor.Rows[0]["Address1"].ToString();
                mve.Address2           = dtVendor.Rows[0]["Address2"].ToString();
                mve.MailAddress1       = dtVendor.Rows[0]["MailAddress1"].ToString();
                mve.TelephoneNO        = dtVendor.Rows[0]["TelephoneNO"].ToString();
                mve.FaxNO             = dtVendor.Rows[0]["FaxNO"].ToString();
                mve.PayeeCD           = dtVendor.Rows[0]["PayeeCD"].ToString();
                mve.payeeName         = dtVendor.Rows[0]["payeeName"].ToString();
                mve.MoneyPayeeCD      = dtVendor.Rows[0]["MoneyPayeeCD"].ToString();
                mve.moneypayeeName    = dtVendor.Rows[0]["moneypayeeName"].ToString();
                mve.PaymentCloseDay   = dtVendor.Rows[0]["PaymentCloseDay"].ToString();
                mve.PaymentPlanKBN    = dtVendor.Rows[0]["PaymentPlanKBN"].ToString();
                mve.PaymentPlanDay    = dtVendor.Rows[0]["PaymentPlanDay"].ToString();
                mve.HolidayKBN        = dtVendor.Rows[0]["HolidayKBN"].ToString();
                mve.TaxTiming         = dtVendor.Rows[0]["TaxTiming"].ToString();
                mve.TaxFractionKBN    = dtVendor.Rows[0]["TaxFractionKBN"].ToString();
                mve.AmountFractionKBN = dtVendor.Rows[0]["AmountFractionKBN"].ToString();
                mve.BankCD            = dtVendor.Rows[0]["BankCD"].ToString();
                mve.BankName          = dtVendor.Rows[0]["BankName"].ToString();
                mve.BranchCD          = dtVendor.Rows[0]["BranchCD"].ToString();
                mve.BranchName        = dtVendor.Rows[0]["BranchName"].ToString();
                mve.KouzaKBN          = dtVendor.Rows[0]["KouzaKBN"].ToString();
                mve.KouzaNO           = dtVendor.Rows[0]["KouzaNO"].ToString();
                mve.KouzaMeigi        = dtVendor.Rows[0]["KouzaMeigi"].ToString();
                mve.KouzaCD           = dtVendor.Rows[0]["KouzaCD"].ToString();
                mve.KouzaName         = dtVendor.Rows[0]["KouzaName"].ToString();
                mve.NetFlg            = dtVendor.Rows[0]["NetFlg"].ToString();
                mve.EDIFlg            = dtVendor.Rows[0]["EDIFlg"].ToString();
                mve.EDIVendorCD       = dtVendor.Rows[0]["EDIVendorCD"].ToString();
                mve.StaffCD           = dtVendor.Rows[0]["StaffCD"].ToString();
                mve.StaffName         = dtVendor.Rows[0]["StaffName"].ToString();
                mve.AnalyzeCD1        = dtVendor.Rows[0]["AnalyzeCD1"].ToString();
                mve.AnalyzeCD2        = dtVendor.Rows[0]["AnalyzeCD2"].ToString();
                mve.AnalyzeCD3        = dtVendor.Rows[0]["AnalyzeCD3"].ToString();
                mve.DisplayOrder      = dtVendor.Rows[0]["DisplayOrder"].ToString();
                mve.DisplayNote       = dtVendor.Rows[0]["DisplayNote"].ToString();
                mve.NotDisplyNote     = dtVendor.Rows[0]["NotDisplyNote"].ToString();
                mve.DeleteFlg         = dtVendor.Rows[0]["DeleteFlg"].ToString();

                return(mve);
            }
            return(null);
        }
Пример #2
0
        public bool M_Vendor_Select(M_Vendor_Entity mve)
        {
            DataTable dt = mvdl.M_Vendor_Select(mve);

            if (dt.Rows.Count > 0)
            {
                mve.VendorCD           = dt.Rows[0]["VendorCD"].ToString();
                mve.VendorName         = dt.Rows[0]["VendorName"].ToString();
                mve.ShoguchiFlg        = dt.Rows[0]["ShoguchiFlg"].ToString();
                mve.VendorLongName1    = dt.Rows[0]["VendorLongName1"].ToString();
                mve.VendorLongName2    = dt.Rows[0]["VendorLongName2"].ToString();
                mve.VendorPostName     = dt.Rows[0]["VendorPostName"].ToString();
                mve.VendorPositionName = dt.Rows[0]["VendorPositionName"].ToString();
                mve.VendorStaffName    = dt.Rows[0]["VendorStaffName"].ToString();
                mve.VendorKana         = dt.Rows[0]["VendorKana"].ToString();
                mve.VendorFlg          = dt.Rows[0]["VendorFlg"].ToString();
                mve.PayeeFlg           = dt.Rows[0]["PayeeFlg"].ToString();
                mve.MoneyPayeeFlg      = dt.Rows[0]["MoneyPayeeFlg"].ToString();
                mve.PayeeCD            = dt.Rows[0]["PayeeCD"].ToString();
                mve.MoneyPayeeCD       = dt.Rows[0]["MoneyPayeeCD"].ToString();
                mve.ZipCD1             = dt.Rows[0]["ZipCD1"].ToString();
                mve.ZipCD2             = dt.Rows[0]["ZipCD2"].ToString();
                mve.Address1           = dt.Rows[0]["Address1"].ToString();
                mve.Address2           = dt.Rows[0]["Address2"].ToString();
                mve.MailAddress1       = dt.Rows[0]["MailAddress"].ToString();
                mve.TelephoneNO        = dt.Rows[0]["TelephoneNO"].ToString();
                mve.FaxNO             = dt.Rows[0]["FaxNO"].ToString();
                mve.PaymentCloseDay   = dt.Rows[0]["PaymentCloseDay"].ToString();
                mve.PaymentPlanKBN    = dt.Rows[0]["PaymentPlanKBN"].ToString();
                mve.PaymentPlanDay    = dt.Rows[0]["PaymentPlanDay"].ToString();
                mve.HolidayKBN        = dt.Rows[0]["HolidayKBN"].ToString();
                mve.BankCD            = dt.Rows[0]["BankCD"].ToString();
                mve.BranchCD          = dt.Rows[0]["BranchCD"].ToString();
                mve.KouzaKBN          = dt.Rows[0]["KouzaKBN"].ToString();
                mve.KouzaNO           = dt.Rows[0]["KouzaNO"].ToString();
                mve.KouzaMeigi        = dt.Rows[0]["KouzaMeigi"].ToString();
                mve.KouzaCD           = dt.Rows[0]["KouzaCD"].ToString();
                mve.TaxTiming         = dt.Rows[0]["TaxTiming"].ToString();
                mve.TaxFractionKBN    = dt.Rows[0]["TaxFractionKBN"].ToString();
                mve.AmountFractionKBN = dt.Rows[0]["AmountFractionKBN"].ToString();
                mve.NetFlg            = dt.Rows[0]["NetFlg"].ToString();
                mve.LastOrderDate     = dt.Rows[0]["LastOrderDate"].ToString();
                mve.StaffCD           = dt.Rows[0]["StaffCD"].ToString();
                mve.AnalyzeCD1        = dt.Rows[0]["AnalyzeCD1"].ToString();
                mve.AnalyzeCD2        = dt.Rows[0]["AnalyzeCD2"].ToString();
                mve.AnalyzeCD3        = dt.Rows[0]["AnalyzeCD3"].ToString();
                mve.DisplayOrder      = dt.Rows[0]["DisplayOrder"].ToString();
                mve.NotDisplyNote     = dt.Rows[0]["NotDisplyNote"].ToString();
                mve.DisplayNote       = dt.Rows[0]["DisplayNote"].ToString();
                mve.DeleteFlg         = dt.Rows[0]["DeleteFlg"].ToString();

                return(true);
            }
            else
            {
                return(false);
            }
        }