public bool ChiTietCanLamSangUpDate(ChiTietCanLamSangEntites obj) { var dal = new ChiTietCanLamSangDAL(); if (dal.ChiTietCanLamSangUpDate(obj)) return true; return false; }
public bool ChiDinhCLSInsert(ChiTietCanLamSangEntites obj) { var dal = new ChiTietCanLamSangDAL(); if (dal.ChiDinhCLSInsert(obj)) return true; return false; }
ChiTietCanLamSangEntites NewCLS() { ChiTietCanLamSangEntites obj = new ChiTietCanLamSangEntites(); obj.MaChiTietCanLamSang = lblMaCLS.Text; obj.BacSiThucHien = txtBacSiThucHien.Text; obj.NhanVienNhapLieu = txtNguoiNhap.Text; obj.ThoiGianLayMau = dtNgayLayMau.Value; obj.ThoiGianTraKQ = dtNgayKQ.Value; obj.KetQuaCLS = txtKetQua.Text; return obj; }
ChiTietCanLamSangEntites NewChiDinh() { ChiTietCanLamSangEntites obj = new ChiTietCanLamSangEntites(); obj.MaBenhNhan = lblMaBN.Text; obj.MaChiTietCanLamSang = txtMaCLS.Text; obj.MaPhongKham = ((PhongKhamEntity)cbbPhongKham.SelectedItem).MaPhongKham; obj.ThoiGianThucHien = dtNgay.Value; obj.TenXetNghiem = txtTenXN.Text; obj.BacSiChiDinh = txtBacSi.Text; return obj; }
// public bool ChiTietCanLamSangUpDate(ChiTietCanLamSangEntites obj) { try { SqlConnection conn = ConnectionDB.GetConnect(); conn.Open(); SqlCommand cmd = new SqlCommand("ChiTietCanLamSangUpDate", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaChiTietCanLamSang", obj.MaChiTietCanLamSang)); cmd.Parameters.Add(new SqlParameter("@ThoiGianLayMau", obj.ThoiGianLayMau)); cmd.Parameters.Add(new SqlParameter("@ThoiGianTraKQ", obj.ThoiGianTraKQ)); cmd.Parameters.Add(new SqlParameter("@BacSiThucHien", obj.BacSiThucHien)); cmd.Parameters.Add(new SqlParameter("@KetQuaCLS", obj.KetQuaCLS)); cmd.Parameters.Add(new SqlParameter("@NhanVienNhapLieu", obj.NhanVienNhapLieu)); cmd.ExecuteNonQuery(); conn.Close(); } catch { return false; } return true; }
public bool ChiDinhCLSUpDate(ChiTietCanLamSangEntites obj) { try { SqlConnection conn = ConnectionDB.GetConnect(); conn.Open(); SqlCommand cmd = new SqlCommand("ChiDinhCLSUpDate", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaChiTietCanLamSang", obj.MaChiTietCanLamSang)); cmd.Parameters.Add(new SqlParameter("@MaBenhNhan", obj.MaBenhNhan)); cmd.Parameters.Add(new SqlParameter("@MaPhongKham", obj.MaPhongKham)); cmd.Parameters.Add(new SqlParameter("@TenXetNghiem", obj.TenXetNghiem)); cmd.Parameters.Add(new SqlParameter("@ThoiGianThucHien", obj.ThoiGianThucHien)); cmd.Parameters.Add(new SqlParameter("@BacSiChiDinh", obj.BacSiChiDinh)); cmd.ExecuteNonQuery(); conn.Close(); } catch { return false; } return true; }