Guest User

Untitled

a guest
Feb 27th, 2019
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.98 KB | None | 0 0
  1.   public static string UsersLoginByEmail(string  email)
  2.         {
  3.             RETURN $@"select 1000000 *Osoba.Atr_ObiLp + Osoba.Atr_ObiNumer as Id ,osoba.Atr_Wartosc as SklepLogin ,Hasla.Atr_Wartosc as SklepHaslo,Hasla2.Atr_Wartosc as SklepHaslo2,StatusKontka.Atr_Wartosc as SklepStatus from cdn.Atrybuty as Osoba
  4.             join cdn.Atrybuty StatusKontka on  Osoba.Atr_ObiNumer=StatusKontka.Atr_ObiNumer and Osoba.atr_obilp=StatusKontka.atr_obilp and StatusKontka.Atr_ObiTyp=32 and StatusKontka.Atr_AtkId=56
  5.              join cdn.Atrybuty as Hasla with (nolock) on Osoba.Atr_ObiNumer = hasla.Atr_ObiNumer and Osoba.atr_obilp = hasla.atr_obilp and hasla.Atr_ObiSubLp = 8211 and hasla.Atr_AtkId = 53
  6.            left join cdn.Atrybuty as Hasla2  with (nolock) on Osoba.Atr_ObiNumer = hasla2.Atr_ObiNumer and Osoba.atr_obilp = hasla2.atr_obilp and hasla2.Atr_ObiSubLp = 8211 and hasla2.Atr_AtkId = 54
  7.            where Osoba.Atr_Wartosc='{email}' and Osoba.Atr_AtkId=55 and Osoba.Atr_ObiTyp=32
  8.        ";
  9.         }
Add Comment
Please, Sign In to add comment