private KHAMTHUONGXUYEN getKHAMTHUONGXUYENByForm()
{
KHAMTHUONGXUYEN ans = new KHAMTHUONGXUYEN();
ans.BACSIID = (int)cbxBacSi.EditValue;
ans.BENHNHANID = (int)cbxBenhNhan.EditValue;
ans.THOIGIAN = dateThoiGianKham.DateTime;
ans.BENHID = (int)cbxBenh.EditValue;
ans.CACHGIAIQUYET = cbxCachGiaiQuyet.SelectedIndex;
ans.CHANDOANSOBO = txtKetLuan.Text;
ans.TRIEUCHUNG = txtTrieuChung.Text;
// điều trị tại tuyến
if (ans.CACHGIAIQUYET == 1)
{
ans.THOIGIANVAO = dateThoiGianVao.DateTime;
ans.THOIGIANRA = dateThoiGianRa.DateTime;
ans.PHUONGPHAPDIEUTRI = txtPhuongPhap.Text;
}
// chuyển lên tuyến trên
if (ans.CACHGIAIQUYET == 2)
{
ans.BENHVIENID = (int)cbxBenhVien.EditValue;
ans.THOIGIANCHUYEN = dateThoiGianChuyen.DateTime;
}
return(ans);
}
public FrmRpChiPhiKhamChuaBenhQuanNhan(int _khamthuongxuyenID, string _nguoilapbangke, string _phutrachquany)
{
khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys(_khamthuongxuyenID));
nguoilapbangke = _nguoilapbangke;
phutrachquany = _phutrachquany;
InitializeComponent();
}
private void btnThem_Click(object sender, EventArgs e)
{
khamthuongxuyen = new KHAMTHUONGXUYEN();
ThamSoHeThong.khamthuongxuyen = khamthuongxuyen;
dgvCHITIETCAPTHUOCMain.DataSource = null;
dgvCHITIETMUONVATTUMain.DataSource = null;
ClearControl();
UpdateStateForm(1);
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of KHAMTHUONGXUYEN</returns>
internal List <KHAMTHUONGXUYEN> PopulateObjectsFromReader(IDataReader dataReader)
{
List <KHAMTHUONGXUYEN> list = new List <KHAMTHUONGXUYEN>();
while (dataReader.Read())
{
KHAMTHUONGXUYEN businessObject = new KHAMTHUONGXUYEN();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
public FrmChiTietKhamThuongXuyen(int _id)
{
InitializeComponent();
KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys(_id));
panelMain.Controls.Clear();
ucKhamThuongXuyen uc = new ucKhamThuongXuyen(khamthuongxuyen);
panelMain.Controls.Add(uc);
uc.Show();
}
public ucKhamThuongXuyen(KHAMTHUONGXUYEN _khamthuongxuyen)
{
khamthuongxuyen = _khamthuongxuyen;;
try
{
capthuoc = CAPTHUOCService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == _khamthuongxuyen.ID).FirstOrDefault();
muonvattu = MUONVATTUService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == _khamthuongxuyen.ID).FirstOrDefault();
}
catch
{
}
InitializeComponent();
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(KHAMTHUONGXUYEN businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[KHAMTHUONGXUYEN_Insert]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID));
sqlCommand.Parameters.Add(new SqlParameter("@BENHNHANID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHNHANID));
sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID));
sqlCommand.Parameters.Add(new SqlParameter("@THOIGIAN", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIAN));
sqlCommand.Parameters.Add(new SqlParameter("@BENHID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHID));
sqlCommand.Parameters.Add(new SqlParameter("@CHANDOANSOBO", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CHANDOANSOBO));
sqlCommand.Parameters.Add(new SqlParameter("@CACHGIAIQUYET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CACHGIAIQUYET));
sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANCHUYEN", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANCHUYEN));
sqlCommand.Parameters.Add(new SqlParameter("@BENHVIENID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHVIENID));
sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANVAO", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANVAO));
sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANRA", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANRA));
sqlCommand.Parameters.Add(new SqlParameter("@PHUONGPHAPDIEUTRI", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PHUONGPHAPDIEUTRI));
sqlCommand.Parameters.Add(new SqlParameter("@KETQUADIEUTRI", SqlDbType.VarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KETQUADIEUTRI));
sqlCommand.Parameters.Add(new SqlParameter("@CHIPHIKHAM", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CHIPHIKHAM));
sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU));
sqlCommand.Parameters.Add(new SqlParameter("@TRIEUCHUNG", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TRIEUCHUNG));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.ID = (int)sqlCommand.Parameters["@ID"].Value;
return(true);
}
catch //(Exception ex)
{
return(false); //throw new Exception("KHAMTHUONGXUYEN::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
private void UpdateDetail()
{
try
{
int muonvattuID = (int)dgvMUONVATTU.GetFocusedRowCellValue("ID");
MUONVATTU muonvattu = MUONVATTUService.GetByPrimaryKey(new MUONVATTUKeys(muonvattuID));
KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys((int)muonvattu.KHAMTHUONGXUYENID));
// cập nhât
txtNgay.Text = ((DateTime)khamthuongxuyen.THOIGIAN).ToString("dd/MM/yyyy");
txtBacSi.Text = BACSIService.GetByPrimaryKey(new BACSIKeys((int)khamthuongxuyen.BACSIID)).HOTEN;
txtBenhNhan.Text = BENHNHANService.GetByPrimaryKey(new BENHNHANKeys((int)khamthuongxuyen.BENHNHANID)).HOTEN;
txtBenh.Text = BENHService.GetByPrimaryKey(new BENHKeys((int)khamthuongxuyen.BENHID)).TEN;
}
catch
{
}
}
private void CapNhat(ref KHAMTHUONGXUYEN cu, KHAMTHUONGXUYEN moi)
{
cu.BACSIID = moi.BACSIID;
cu.BENHNHANID = moi.BENHNHANID;
cu.THOIGIAN = moi.THOIGIAN;
cu.BENHID = moi.BENHID;
cu.CACHGIAIQUYET = moi.CACHGIAIQUYET;
cu.KETQUADIEUTRI = moi.KETQUADIEUTRI;
cu.CHANDOANSOBO = moi.CHANDOANSOBO;
cu.THOIGIANVAO = moi.THOIGIANVAO;
cu.THOIGIANRA = moi.THOIGIANRA;
cu.PHUONGPHAPDIEUTRI = moi.PHUONGPHAPDIEUTRI;
cu.BENHVIENID = moi.BENHVIENID;
cu.THOIGIANCHUYEN = moi.THOIGIANCHUYEN;
cu.TRIEUCHUNG = moi.TRIEUCHUNG;
}
private void btnTra_Click(object sender, EventArgs e)
{
try
{
int muonvattuID = (int)dgvMUONVATTU.GetFocusedRowCellValue("ID");
MUONVATTU muonvattu = MUONVATTUService.GetByPrimaryKey(new MUONVATTUKeys(muonvattuID));
KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys((int)muonvattu.KHAMTHUONGXUYENID));
if (muonvattu.TRANGTHAI == 1)
{
MessageBox.Show("Thông tin mượn vật tư đã được trả", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (muonvattu.TRANGTHAI == 2)
{
MessageBox.Show("Chưa có vật tư nào được mượn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// cập nhật lại thông tin mượn vật tư
muonvattu.TRANGTHAI = 1;
muonvattu.NGAYTRA = DateTime.Now;
MUONVATTUService.Update(muonvattu);
// cập nhật lại kho
var listChiTiet = CHITIETMUONVATTUService.GetAllEntities().Where(p => p.MUONVATTUID == muonvattu.ID).ToList();
foreach (var item in listChiTiet)
{
VATTU vattu = VATTUService.GetByPrimaryKey(new VATTUKeys((int)item.VATTUID));
vattu.SOLUONG += item.SOLUONG;
VATTUService.Update(vattu);
}
MessageBox.Show("Xác nhận trả vật tư thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDgvMUONVATTU();
}
catch
{
MessageBox.Show("Chưa có thông tin mượn vật tư nào được chọn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>KHAMTHUONGXUYEN business object</returns>
public KHAMTHUONGXUYEN SelectByPrimaryKey(KHAMTHUONGXUYENKeys keys)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[KHAMTHUONGXUYEN_SelectByPrimaryKey]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
KHAMTHUONGXUYEN businessObject = new KHAMTHUONGXUYEN();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch //(Exception ex)
{
return(null); //throw new Exception("KHAMTHUONGXUYEN::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
private void UpdateDetail()
{
try
{
KHAMTHUONGXUYEN tg = khamthuongxuyen;
if (tg.ID == 0)
{
return;
}
ClearControl();
cbxBacSi.EditValue = (int)tg.BACSIID;
cbxBenhNhan.EditValue = (int)tg.BENHNHANID;
dateThoiGianKham.DateTime = (DateTime)tg.THOIGIAN;
cbxBenh.EditValue = (int)tg.BENHID;
cbxCachGiaiQuyet.SelectedIndex = (int)tg.CACHGIAIQUYET;
txtKetLuan.Text = tg.CHANDOANSOBO;
txtTrieuChung.Text = tg.TRIEUCHUNG;
if (tg.CACHGIAIQUYET == 1)
{
dateThoiGianVao.DateTime = (DateTime)tg.THOIGIANVAO;
dateThoiGianRa.DateTime = (DateTime)tg.THOIGIANRA;
txtPhuongPhap.Text = tg.PHUONGPHAPDIEUTRI;
}
if (tg.CACHGIAIQUYET == 2)
{
cbxBenhVien.EditValue = (int)tg.BENHVIENID;
dateThoiGianChuyen.DateTime = (DateTime)tg.THOIGIANCHUYEN;
}
LoadDgvCHITIETCAPTHUOC();
LoadDgvCHITIETMUONVATTU();
}
catch
{
}
}
public FrmInGiayGioiThieu(KHAMTHUONGXUYEN _khamthuongxuyen)
{
khamthuongxuyen = _khamthuongxuyen;
InitializeComponent();
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(KHAMTHUONGXUYEN businessObject, IDataReader dataReader)
{
businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.ID.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHNHANID.ToString())))
{
businessObject.BENHNHANID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHNHANID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BACSIID.ToString())))
{
businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BACSIID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIAN.ToString())))
{
businessObject.THOIGIAN = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIAN.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHID.ToString())))
{
businessObject.BENHID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHANDOANSOBO.ToString())))
{
businessObject.CHANDOANSOBO = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHANDOANSOBO.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CACHGIAIQUYET.ToString())))
{
businessObject.CACHGIAIQUYET = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CACHGIAIQUYET.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANCHUYEN.ToString())))
{
businessObject.THOIGIANCHUYEN = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANCHUYEN.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHVIENID.ToString())))
{
businessObject.BENHVIENID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHVIENID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANVAO.ToString())))
{
businessObject.THOIGIANVAO = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANVAO.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANRA.ToString())))
{
businessObject.THOIGIANRA = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANRA.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.PHUONGPHAPDIEUTRI.ToString())))
{
businessObject.PHUONGPHAPDIEUTRI = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.PHUONGPHAPDIEUTRI.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.KETQUADIEUTRI.ToString())))
{
businessObject.KETQUADIEUTRI = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.KETQUADIEUTRI.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHIPHIKHAM.ToString())))
{
businessObject.CHIPHIKHAM = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHIPHIKHAM.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.GHICHU.ToString())))
{
businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.GHICHU.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.TRIEUCHUNG.ToString())))
{
businessObject.TRIEUCHUNG = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.TRIEUCHUNG.ToString()));
}
}
private void btnLuuThongTin_Click(object sender, EventArgs e)
{
int exceptionHelp = 0;// -> giúp tạo ra exception
if (Check())
{
try
{
KHAMTHUONGXUYEN tg = getKHAMTHUONGXUYENByForm();
if (khamthuongxuyen.ID == 0)
{
bool kt = KHAMTHUONGXUYENService.Insert(tg);
if (kt == false)
{
exceptionHelp /= 0;
}
khamthuongxuyen = tg;
ThamSoHeThong.khamthuongxuyen = tg;
// thêm mới
muonvattu = new MUONVATTU();
ThamSoHeThong.muonvattu = muonvattu;
muonvattu.KHAMTHUONGXUYENID = khamthuongxuyen.ID;
muonvattu.BACSIMUONID = khamthuongxuyen.BACSIID;
muonvattu.NGAYMUON = khamthuongxuyen.THOIGIAN;
muonvattu.TRANGTHAI = 2; // Chưa mượn
MUONVATTUService.Insert(muonvattu);
capthuoc = new CAPTHUOC();
ThamSoHeThong.capthuoc = capthuoc;
capthuoc.KHAMTHUONGXUYENID = khamthuongxuyen.ID;
capthuoc.BACSIID = khamthuongxuyen.BACSIID;
capthuoc.NGAY = khamthuongxuyen.THOIGIAN;
CAPTHUOCService.Insert(capthuoc);
LoadDgvCHITIETCAPTHUOC();
LoadDgvCHITIETMUONVATTU();
MessageBox.Show("Thêm thông tin phiếu khám bệnh thường xuyên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
// cập nhật
CapNhat(ref khamthuongxuyen, tg);
bool kt = KHAMTHUONGXUYENService.Update(khamthuongxuyen);
if (kt == false)
{
exceptionHelp /= 0;
}
MessageBox.Show("Cập nhật thông tin phiếu khám bệnh thường xuyên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
if (khamthuongxuyen.ID == 0)
{
MessageBox.Show("Thêm phiếu khám bệnh thường xuyên thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Sửa thông tin phiếu khám bệnh thường xuyên thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
finally
{
if (cbxCachGiaiQuyet.SelectedIndex < 2)
{
UpdateStateForm(2);
}
else
{
UpdateStateForm(0);
}
UpdateDetail();
}
}
}
