Správičky 2 811 Blogy 948 Fórum 18 705

SqlLocalizer core 2.0

photo
core
27. 11. 2017 6:53:36
Body: 225
Najaktívnejší č.: 60

SqlLocalizer core 2.0

resource mi funguje ok ,ale co by ste mi odporucili mam tabulku chcem raz zobrazit bud anglicky text  alebo slovensky podla vyberu z menu.

CREATE TABLE Persons (
    ID int,
   slovensky varchar(255),
   anglicky varchar(255)
    );

[Reakcia]

photo
harrison314
27. 11. 2017 9:57:49
Body: 1155
Najaktívnejší č.: 24

RE: SqlLocalizer core 2.0

To si musis poriesit sam podla aktulanheo nastevnia cultury.

[Reakcia]

photo
Liero
27. 11. 2017 17:43:33
Body: 9570
Najaktívnejší č.: 6

RE: SqlLocalizer core 2.0

Sposob ktory si si vybral je zdanlivo najjednoduchsi (najjednoduchsia schema) ale je menej neprakticky na pouzitie. A praktickost pouzitia je dolezitejsia ako pociatocna jednoduchost.


Neprakticke je to preto, ze vyberat stlpec na zaklade nejakeho parametru (aktualneho jazyka) je tazsie ako pouzit tento parameter iba vo where podmienke, ale da sa to napr takto:

SELECT ID, CASE WHEN @cultureParam = 'EN-us' THEN Anglicky ELSE Slovensky END as 'Preklad'
FROM Persons

 

Ale co v pripade ze budes chciet pridat novy jazyk? Budes menit kazdy tabulku a kazdy select?

 

Tu je alternativny sposob: 

SELECT People.*, LocalizedResources.Value
FROM People
INNER JOIN LocalizedResources ON People.ResourceID = LocalizedResources.ResourceID
WHERE Culture=@cultureParam

Toto sa da dalej zjednodusit tak ze si vytvoris db funkciu ktora ti vrati preklad:

SELECT ID, dbo.Localize(ResourceID, @cultureParam)
FROM People

 

Pripadne mozes pouzit XML, alebo JSON stlpec v People tabulke a rovnako si vies spravit db funkciu na preklad

 

 

 

 

[Reakcia]

photo
bigdaddykush
23. 1. 2018 12:58:50
Body: 50
Najaktívnejší č.: 165

RE: SqlLocalizer core 2.0

BUY QUALITY REAL AND FAKE PASSPORTS USA GREEN CARD,CITIZENSHIP EU/USA/UK/CANADIAN ,DRIVERS LICENCE,ID CARDS,VISAS ETC CONTACT US ONLY ON Whatsapp..+1929357-4128
Guaranteed 24 hour passport,citizenship,Id cards,driver's license,diplomas,degrees,certificates service available. Tourist and business visa services available to residents of usa,uk,germany,france and all nationalities Worldwide.we are unique producers of Authentic High Quality passports, Real Genuine Data Base Registered and unregistered Passports and other Citizenship documents.I can guarantee you a new Identity starting from a clean new genuine Birth Certificate, ID card, Drivers License,Passports, Social security card with SSN, credit files, and credit cards, school diplomas, school degrees all in an entirely new name issued and registered in the government database system..

We use high quality equipment and materials to produce authentic and counterfeit documents.All secret features of real passports are carefully duplicated for our Registered and unregistered documents.we are unique producer of quality false and Real documents.We offer only original high-quality Registered and unregistered passports, driverâ??s licenses, ID cards, stamps, Visa, school Diplomas and other products for a number of countries like:USA, Australia, Belgium,Brazil, Canada, Italian,Finland, France, Germany, Israel, Mexico, Netherlands, South Africa,Spain, United Kingdom and worldwide.we do Registered and unregistered passport of all countries.visas,biometric passport,degrees,drivers license,I.D cards.Training certificates M GCSE, A-levels,

High School Diploma Certificates ,GMAT, MCAT, and LSAT Examination Certificates , Novelty Birth, Marriage, and Death Certificates , Novelty Passports and New Identity Packages , Replicated, False Degrees/Diplomas from most post-secondary institutions from around the world (we have over 3000 templates on file) all designed to look 100% identical to the original.Custom Printing (if we do not already have the template on file â?? simply email us a copy and we can make any alterations/modificatios nas per your directions).second, citizenship, identity, identification, documents, diplomatic,nationality, how to, where to, get, obtain, buy, purchase, make,build, a, passport, i.d,British, Honduras, UK, USA, us, u.s.,Canada, Canadian, foreign, visa, Swiss, card,
ids, document, getting,visas, cards, foreign .
How to contact us downlaod whatsapp and text the this number +1929357-4128 let us help you no emails.....we also
We offer high quality counterfeit bills for the following currencies;
Euro
US Dollar
British Pound
Indian Rupee
Australian Dollar
Canadian Dollar etc We do discrete delivery and shipping we also provide tracking number of OUR CLIENTS packageS...contact us now for more infos..whatsapp us at (929) 357-4128
ORDER ANY UNIVERSAL DOCUMENTS YOUR OF NEED in the list below and more...
PASSPORTS
ID card
Social security card
Drivers License
Canada Cards
United States Cards
Student Cards
International Cards
Private Cards
Adoption Certificates
Baptism Certificates
Birth Certificates
Death Certificates
Divorce Certificates
Marriage Certificates
Custom Certificates
High School Diplomas
G.E.D. Diplomas
Home School Diplomas
College Degrees
University Degrees
Trade Skill Certificates
Validate SSN Number
US green cards
Counterfeit dollars/euro
Spy Products
Voice Changers
Listening Devices
Invisible Ink
DMV Record Inquiry
Background Check
Investigate Anyone...just download whatsapp and text us..+1(929) 357-4128 or email us buyfakemoneyonline@gmail.com

[Reakcia]



Najaktívnejší užívatelia
1. 37770 b. photo vlko
2. 21430 b. photo T
3. 15955 b. photo spigi
4. 15450 b. photo Anonymous
5. 11120 b. photo dudok
6. 9570 b. photo Liero
7. 6910 b. photo siro
8. 6245 b. photo slavof
9. 5395 b. photo duracellko
10. 4620 b. photo xxxmatko