public static string UpdatePSChiTietThuoc(PSChiTietThuoc pschitietthuoc) { string query = "UPDATE current.pschitietthuoc SET Idpsthuoc=@Idpsthuoc,Iddienbien=@Iddienbien,mabn=@mabn,maba=@maba,makhoa=@makhoa,mahh=@mahh,dongia=@dongia,soluong=@soluong,thanhtien=@thanhtien WHERE ID=@ID"; try { conn.Open(); NpgsqlCommand cmd = new NpgsqlCommand(query, conn); cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = pschitietthuoc.ID; cmd.Parameters.Add("@Idpsthuoc", NpgsqlDbType.Varchar).Value = pschitietthuoc.Idpsthuoc; cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = pschitietthuoc.Iddienbien; cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mabn; cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = pschitietthuoc.Maba; cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = pschitietthuoc.Makhoa; cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mahh; cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pschitietthuoc.Dongia; cmd.Parameters.Add("@soluong", NpgsqlDbType.Numeric).Value = pschitietthuoc.Soluong; cmd.Parameters.Add("@thanhtien", NpgsqlDbType.Numeric).Value = pschitietthuoc.Thanhtien; cmd.ExecuteNonQuery(); conn.Close(); return(tb.update_successed); } catch (Exception e) { conn.Close(); return(e.Message); } }
public static string PhatThuoc(PSChiTietThuoc pschitietthuoc) { // return JsonConvert.SerializeObject(pschitietthuoc); var mathuoc = pschitietthuoc.Mahh; var soluong = pschitietthuoc.Soluong; try { PSTonKho pstonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc); var xuattam = pstonkho.Xuattam - soluong; if (xuattam >= 0) { pstonkho.Xuattam = xuattam; } if (pstonkho.Xuattam >= pstonkho.Xuat + soluong) { pstonkho.Xuat = pstonkho.Xuat + soluong; } pstonkho.Toncuoi = pstonkho.Tondau + pstonkho.Xuattam; PSTonKhoRepository.UpdatePSTonKho(pstonkho); return(JsonConvert.SerializeObject(PSTonKhoRepository.ShowPSTonKho(mathuoc))); } catch (Exception e) { conn.Close(); return(e.Message); } }
public static string AddPSChiTietThuoc(PSChiTietThuoc pschitietthuoc) { string query = "INSERT INTO current.pschitietthuoc(Idpsthuoc,Iddienbien,mabn,maba,makhoa,mahh,dongia,soluong,thanhtien) VALUES(@Idpsthuoc,@Iddienbien,@mabn,@maba,@makhoa,@mahh,@dongia,@soluong,@thanhtien)"; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); try { var dongia = pschitietthuoc.Dongia; var soluong = pschitietthuoc.Soluong; conn.Open(); cmd.Parameters.Add("@Idpsthuoc", NpgsqlDbType.Varchar).Value = pschitietthuoc.Idpsthuoc; cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = pschitietthuoc.Iddienbien; cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mabn; cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = pschitietthuoc.Maba; cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = pschitietthuoc.Makhoa; cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mahh; cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pschitietthuoc.Dongia; cmd.Parameters.Add("@soluong", NpgsqlDbType.Numeric).Value = pschitietthuoc.Soluong; cmd.Parameters.Add("@thanhtien", NpgsqlDbType.Numeric).Value = dongia * soluong; cmd.ExecuteNonQuery(); conn.Close(); return(tb.add_successed); } catch (Exception e) { conn.Close(); return(e.Message); } }
public string ThongTinPSChiTietThuoc(int id) { PSChiTietThuoc psctt = PSChiTietThuocProcessor.ThongTinPSChiTietThuoc(id); if (psctt.ID == 0) { return("NULL"); } return(JsonConvert.SerializeObject(psctt)); }
public static PSChiTietThuoc ShowPSChiTietThuoc(int id) { PSChiTietThuoc pschitietthuoc = new PSChiTietThuoc(); string query = "SELECT * FROM current.pschitietthuoc WHERE ID=@ID"; try { conn.Open(); NpgsqlCommand cmd = new NpgsqlCommand(query, conn); cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = id; var reader = cmd.ExecuteReader(); while (reader.Read()) { pschitietthuoc = new PSChiTietThuoc(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetDouble(7), reader.GetInt64(8), reader.GetDouble(9)); } conn.Close(); } catch (Exception e) { conn.Close(); Console.WriteLine(e.Message); } return(pschitietthuoc); }
public string SuaPSChiTietThuoc([FromBody] PSChiTietThuoc pschitietthuoc) { return(PSChiTietThuocProcessor.SuaPSChiTietThuoc(pschitietthuoc)); }
public string ThemPSChiTietThuoc([FromBody] PSChiTietThuoc pschitietthuoc) { //return JsonConvert.SerializeObject(pschitietthuoc); return(PSChiTietThuocProcessor.ThemPSChiTietThuoc(pschitietthuoc)); }
public string XuatTam([FromBody] PSChiTietThuoc pschitietthuoc) { // return JsonConvert.SerializeObject(pschitietthuoc); return(QuanLyTonKhoRepository.XuatTam(pschitietthuoc)); }
public static string HuyXuatTam(PSChiTietThuoc pschitietthuoc) { // return JsonConvert.SerializeObject(pschitietthuoc); try { DienBien dienbien = DienBienRepository.ShowDienBienFromDB(pschitietthuoc.Iddienbien); //kiểm tra diễn biến có tòn tại ko if (dienbien.Iddienbien == null) { return("Mã diễn biên không tôn tại"); } if (dienbien.Mabn != pschitietthuoc.Mabn) { } if (dienbien.Maba != pschitietthuoc.Maba) { } if (dienbien.Makhoa != pschitietthuoc.Makhoa) { } var mathuoc = pschitietthuoc.Mahh; var dongia = pschitietthuoc.Dongia; var soluong = pschitietthuoc.Soluong; var thanhtien = pschitietthuoc.Thanhtien; //kiem tra ma thuoc co ton tai trong pstonkho var thuoctonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc); // lấy thông tin từ bảng pstonkho if (thuoctonkho.Mahh == null) { return("Mã thuốc không tôn tại trong tồn kho"); } if (dongia != thuoctonkho.Dongia) { return("Sai đơn giá"); } //kiem tra thanh tien var sotien = dongia * soluong; /* if (thanhtien != sotien) * { * // return sotien + "khác" + thanhtien + ": client và server tính khác nhau"; * }*/ //kiểm tra lại số thuốc trong pstonkho lần nữa PSTonKho pstonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc); //if (pstonkho.Xuattam + soluong <= pstonkho.Tondau) pstonkho.Xuattam -= soluong; pstonkho.Tondau += soluong; PSTonKhoRepository.UpdatePSTonKho(pstonkho); return(JsonConvert.SerializeObject(PSTonKhoRepository.ShowPSTonKho(mathuoc))); } catch (Exception e) { conn.Close(); return(e.Message); } }
public string PhatThuoc([FromBody] PSChiTietThuoc pschitietthuoc) { return(QuanLyTonKhoRepository.PhatThuoc(pschitietthuoc)); }
public static string SuaPSChiTietThuoc(PSChiTietThuoc pschitietthuoc) { return(PSChiTietThuocRepository.UpdatePSChiTietThuoc(pschitietthuoc)); }
public static string ThemPSChiTietThuoc(PSChiTietThuoc pschitietthuoc) { return(PSChiTietThuocRepository.AddPSChiTietThuoc(pschitietthuoc)); }