async Task Lodate() { var json = await ex.getDataBFO(@"select [AccountName],[Password],[No_] ,[E-Mail]as Mail,[Name],Customer.Role as Roles from [Customer] where [AccountName]='" + Username.Text + "' and [Password]='" + Password.Text + "' and [Customer].[Role]='0' ");//where [EmpNo_]='" + mabs.ToString() + "'and [DateBook] ='" + today + "' foreach (var item in json) { loginabc.AccountName = item["AccountName"].ToString(); loginabc.Password = item["Password"].ToString(); loginabc.Mail = item["Mail"].ToString(); loginabc.CusNo_ = item["No_"].ToString(); loginabc.Name = item["Name"].ToString(); loginabc.Role = item["Roles"].ToString(); menuList2.Add(loginabc); } var json2 = await ex.getDataBFO(@" select Employee.AccountName as AccountName ,Employee.Password as Password,Employee.EmpNo_ as EmpNO, Employee.[E-Mail] as MaiEmp, Employee.Name as EmPName,Employee.Role as Roles from [Employee] where [AccountName]='" + Username.Text + "' and [Password]='" + Password.Text + "'and Employee.[Role]='1'"); foreach (var item in json2) { loginabc.AccountName = item["AccountName"].ToString(); loginabc.Password = item["Password"].ToString(); loginabc.Name = item["EmPName"].ToString(); loginabc.Role = item["Roles"].ToString(); loginabc.EmpNo_ = item["EmpNO"].ToString(); menuList2.Add(loginabc); } foreach (LoginModels dc in menuList2) { try { if (dc.AccountName == Username.Text && dc.Password == Password.Text && dc.Role == "0") { await App.PersonRepo.AddNewPersonAsync(dc.AccountName, dc.Password, dc.CusNo_, dc.EmpNo_, dc.Role); CCode = dc.CusNo_.ToString(); Mailc = dc.Mail.ToString(); Name_cus = dc.Name.ToString(); navigationService.setLogin(); } else if (dc.AccountName == Username.Text && dc.Password == Password.Text && dc.Role == "1") { await App.PersonRepo.AddNewPersonAsync(dc.AccountName, dc.Password, dc.CusNo_, dc.EmpNo_, dc.Role); EmPNo = dc.EmpNo_.ToString(); navigationService.setLoginbs(); } else { await DisplayAlert("thong bao", "Tài khoản hoặc mật khẩu không đúng ?", "ok"); } } catch (Exception ex) { await DisplayAlert("Thông báo", ex.Message, "ok"); } } }
async Task LoadData(string mabs, string today)// hom nay { var id_dtor = Views.Login.EmPNo; var id_dtor2 = App.Empo; if (id_dtor != null) { sql = @"SELECT[BookNo_] ,[CusNo_] ,[NameCus] ,[Name] ,[Phone] as Phone_Cus ,[Adr] ,[DateBook],[TimeBook],[EmpNo_] ,[NameEmp] ,[Phone No_] as Phone_Emp ,[CliNo_],[NameCli],[SubCliNo_],[TimeShift],[TimeShift2],[NameTime],[TrangThai] FROM[BFOCLINIC].[dbo].[Book] where EmpNo_ = '" + id_dtor + "' and DateBook = '" + today + "'"; } else { sql = @"SELECT[BookNo_] ,[CusNo_] ,[NameCus] ,[Name] ,[Phone] as Phone_Cus ,[Adr] ,[DateBook],[TimeBook],[EmpNo_] ,[NameEmp] ,[Phone No_] as Phone_Emp ,[CliNo_],[NameCli],[SubCliNo_],[TimeShift],[TimeShift2],[NameTime],[TrangThai] FROM[BFOCLINIC].[dbo].[Book] where EmpNo_ = '" + id_dtor2 + "' and DateBook = '" + today + "'"; } var json = await ex.getDataBFO(sql); foreach (var item in json) { _cldh = new BookModel2(); _cldh.TimeBook = DateTime.Parse(item["TimeBook"].ToString()); _cldh.DateBook = DateTime.Parse(item["DateBook"].ToString()); _cldh.date = _cldh.DateBook.ToString("yyyy/MM/dd"); _cldh.time = _cldh.TimeBook.ToString("hh:mm:ss"); _cldh.EmpNo_ = item["EmpNo_"].ToString(); _cldh.TrangThai = item["TrangThai"].ToString(); menuList2.Add(_cldh); } }
public async Task Loadata() { string sql = @"SELECT [CliNo_] ,[Name] ,[Adr] ,[Phone] ,[Mail] ,[Descrip] FROM [Clinic]"; try { var json = await ex.getDataBFO(sql); foreach (var item in json) { varClinic = new ClinicModel(); varClinic.Name = item["Name"].ToString(); varClinic.CliNo_ = item["CliNo_"].ToString(); varClinic.Address = item["Adr"].ToString(); varClinic.Phone = item["Phone"].ToString(); varClinic.Email = item["Mail"].ToString(); varClinic.Description = item["Descrip"].ToString(); listClinic.Add(varClinic); } mylist.ItemsSource = listClinic; } catch (Exception ex) { await DisplayAlert("thong bao", ex.ToString(), "ÖK"); } }
// get du lieu async Task LoadData(string prono_, string cusNo_) { var abc = prono_; var json = await ex.getDataBFO(@"SELECT [ProLineNo_] ,[DisProLine].[DisNo_] as DisNo_ ,[DisProLine].[Diagnose] as Diagnose ,[DisProLine].[StaringDate] as StaringDate ,[Duration] ,[DisProLine].[Descrip] as Descrip ,DisPro.CusNo_ as CusNo_ FROM[DisProLine],DisPro where DisPro.ProNo_ = '" + prono_ + "' and DisProLine.ProLineNo_='" + abc + "' "); foreach (var item in json) { DisProModelss _cldh = new DisProModelss(); _cldh = new DisProModelss(); _cldh.ProLineNo_ = item["ProLineNo_"].ToString(); _cldh.DisNo_ = item["DisNo_"].ToString(); _cldh.Diagnose = item["Diagnose"].ToString(); _cldh.StaringDate = DateTime.Parse(item["StaringDate"].ToString()); _cldh.staringdate = _cldh.StaringDate.ToString("dd/MM/yyyy"); _cldh.Duration = DateTime.Parse(item["Duration"].ToString()); _cldh.duration = _cldh.Duration.ToString("dd/MM/yyyy"); _cldh.Descrip = item["Descrip"].ToString(); _cldh.CusNo_ = item["CusNo_"].ToString(); menuList2.Add(_cldh); } }
async Task LoadData() { /*** docNo_ mã chuẩn đoán * symptoms chịu chứng * DisNo_ mã bệnh * nameofDis tên bệnh * kết luận của bác sĩ summary * treatments phuong phap dieu chỉ ***/ var json = await ex.getDataBFO(@"Select DisPro.ProNo_ as ProNo_ ,Employee.[EmpNo_] as ID_Emp ,Employee.Name as Name_Emp , CusNo_ ,Customer.Name as Name_Cus , Customer.[Date of Birth] as DateBirth_Cus ,Customer.[Address] as Address ,Customer.[Phone No_] as Phone , [StaringDate] ,[EndingDate] ,Employee.[CliNo_] as CLiNo_ ,Clinic.Name as CliName ,Clinic.Adr as CliAdr ,Clinic.Phone as CliPhone FROM [DisPro], Employee, Customer, Clinic where DisPro.EmpNo_=Employee.EmpNo_ and DisPro.CusNo_= '" + cusno + "' and DisPro.CliNo_= Clinic.CliNo_ and Customer.No_='" + cusno + "'or DisPro.EmpNo_=Employee.EmpNo_ and DisPro.CusNo_= '" + cusno2 + "' and DisPro.CliNo_= Clinic.CliNo_ and Customer.No_='" + cusno2 + "'"); foreach (var item in json) { DisProfileModels _cldh = new DisProfileModels(); _cldh = new DisProfileModels(); _cldh.ID_Emp = item["ID_Emp"].ToString(); _cldh.Name_Emp = item["Name_Emp"].ToString(); _cldh.CusNo_ = item["CusNo_"].ToString(); _cldh.Name_Cus = item["Name_Cus"].ToString(); _cldh.DateBirth_Cus = DateTime.Parse(item["DateBirth_Cus"].ToString()); _cldh.dateofbirth = _cldh.DateBirth_Cus.ToString("yyyy/MM/dd"); _cldh.StaringDate = DateTime.Parse(item["StaringDate"].ToString()); _cldh.straidate = _cldh.StaringDate.ToString("yyyy/MM/dd"); _cldh.EndingDate = DateTime.Parse(item["EndingDate"].ToString()); _cldh.endingdate = _cldh.EndingDate.ToString("yyyy/MM/dd"); _cldh.CliNo_ = item["CLiNo_"].ToString(); _cldh.CliName = item["CliName"].ToString(); _cldh.CliAdr = item["CliAdr"].ToString(); _cldh.CliPhone = item["CliPhone"].ToString(); _cldh.ProNo_ = item["ProNo_"].ToString(); _cldh.Address = item["Address"].ToString(); _cldh.Phone = item["Phone"].ToString(); menuList2.Add(_cldh); } }
async Task LoadData(string prono_) { var abc = prono_; var json = await ex.getDataBFO(@"SELECT PresLine.[PrecLineNo_] as PrecLineNo_ , PresLine.[MedicineNo_] as MedicineNo_ , Item.[Name] as Name, Item.[Base Unit of Measure] as [Base_Unit_of_Measure], PresLine.[Dosage] as Dosage, PresLine.[Amount] as Amount , Item.Origination as Origination , Item.Pharmacodynamic as Pharmacodynamic FROM [PresLine], [Pres], Item where Pres.ProNo_ = '" + prono_ + "' and PresLine.PrecLineNo_= '" + abc + "' and PresLine.[MedicineNo_]= Item.No_"); foreach (var item in json) { ItemModel _cldh = new ItemModel(); _cldh = new ItemModel(); _cldh.PrecLineNo_ = item["PrecLineNo_"].ToString(); _cldh.MedicineNo_ = item["MedicineNo_"].ToString(); _cldh.Name = item["Name"].ToString(); _cldh.Base_Unit_of_Measure = item["Base_Unit_of_Measure"].ToString(); _cldh.Dosage = item["Dosage"].ToString(); _cldh.Amount = item["Amount"].ToString(); _cldh.Origination = item["Origination"].ToString(); _cldh.Pharmacodynamic = item["Pharmacodynamic"].ToString(); menuList2.Add(_cldh); } }
//lay thong tin book public async void getInfoCs(string id_cli, string id_fal) { string sql = @"SELECT Faculty.Name, Clinic.Name, Clinic.Adr FROM Faculty,Clinic WHERE Faculty.FalNo_='" + id_fal + @"' and Clinic.CliNo_='" + id_cli + @"'"; try { var json = await ex.getDataBFO(sql); foreach (var item in json) { name_fal_p = item["Name"].ToString(); name_cli_p = item["Name1"].ToString(); address_cli_p = item["Adr"].ToString(); } } catch (Exception ex) { Console.WriteLine("eamilservice error" + ex.ToString()); } }