public void InsertAssignDetail(KcbChidinhcl objAssignInfo, KcbLuotkham objPatientExam, KcbChidinhclsChitiet[] assignDetail)
{
if (objPatientExam == null)
{
return;
}
foreach (KcbChidinhclsChitiet objAssignDetail in assignDetail)
{
log.Info("Them moi thong tin cua phieu chi dinh chi tiet voi ma phieu Assign_ID=" +
objAssignInfo.IdChidinh);
TinhCLS.TinhGiaChiDinhCLS(objPatientExam, objAssignDetail);
objAssignDetail.IdDoituongKcb = Utility.Int16Dbnull(objPatientExam.IdDoituongKcb);
objAssignDetail.IdChidinh = Utility.Int32Dbnull(objAssignInfo.IdChidinh);
objAssignDetail.IdKham = Utility.Int32Dbnull(objAssignInfo.IdKham, -1);
decimal PtramBHYT = Utility.DecimaltoDbnull(objPatientExam.PtramBhyt, 0);
TinhCLS.GB_TinhPhtramBHYT(objAssignDetail, objPatientExam, PtramBHYT);
objAssignDetail.MaLuotkham = objAssignInfo.MaLuotkham;
objAssignDetail.IdBenhnhan = objAssignInfo.IdBenhnhan;
if (Utility.Int32Dbnull(objAssignDetail.SoLuong) <= 0)
{
objAssignDetail.SoLuong = 1;
}
if (objAssignDetail.IdChitietchidinh <= 0)
{
objAssignDetail.IsNew = true;
objAssignDetail.Save();
}
else
{
objAssignDetail.MarkOld();
objAssignDetail.IsNew = false;
objAssignDetail.Save();
}
}
}
public void InsertAssignDetail(KcbChidinhcl objKcbChidinhcls, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] assignDetail)
{
using (var scope = new TransactionScope())
{
if (objLuotkham == null) return;
foreach (KcbChidinhclsChitiet objAssignDetail in assignDetail)
{
log.Info("Them moi thong tin cua phieu chi dinh chi tiet voi ma phieu Assign_ID=" +
objKcbChidinhcls.IdChidinh);
TinhCLS.TinhGiaChiDinhCLS(objLuotkham, objAssignDetail);
objAssignDetail.IdDoituongKcb = Utility.Int16Dbnull(objLuotkham.IdDoituongKcb);
objAssignDetail.IdChidinh = Utility.Int32Dbnull(objKcbChidinhcls.IdChidinh);
objAssignDetail.IdKham = Utility.Int32Dbnull(objKcbChidinhcls.IdKham, -1);
decimal PtramBHYT = Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0);
TinhCLS.GB_TinhPhtramBHYT(objAssignDetail, objLuotkham, PtramBHYT);
objAssignDetail.MaLuotkham = objKcbChidinhcls.MaLuotkham;
objAssignDetail.IdBenhnhan = objKcbChidinhcls.IdBenhnhan;
if (Utility.Int32Dbnull(objAssignDetail.SoLuong) <= 0) objAssignDetail.SoLuong = 1;
if (objAssignDetail.IdChitietchidinh <= 0)
{
objAssignDetail.IsNew = true;
objAssignDetail.Save();
}
else
{
objAssignDetail.MarkOld();
objAssignDetail.IsNew = false;
objAssignDetail.Save();
}
}
scope.Complete();
}
}
void SearchData()
{
try
{
dtChidinh = SPs.KnMaukiemnghiemTimkiemchitieu(Utility.Int64Dbnull(txtidchidinh.Text)).GetDataSet().Tables[0];
if (dtChidinh != null && dtChidinh.Rows.Count > 0)
{
id_dichvu = Utility.Int32Dbnull(dtChidinh.Rows[0][VKcbChidinhcl.Columns.IdDichvu], 0);
IdChitietdichvu = Utility.Int32Dbnull(dtChidinh.Rows[0][VKcbChidinhcl.Columns.IdChitietdichvu], 0);
co_chitiet = Utility.Int32Dbnull(dtChidinh.Rows[0][VKcbChidinhcl.Columns.CoChitiet], 0);
id_chidinh = Utility.Int32Dbnull(dtChidinh.Rows[0]["id_chidinh"], 0);
ma_luotkham = Utility.sDbnull(dtChidinh.Rows[0]["ma_dangky"], "");
MaChidinh = Utility.sDbnull(dtChidinh.Rows[0]["ma_chidinh"], "");
MaBenhpham = Utility.sDbnull(dtChidinh.Rows[0]["ma_benhpham"], "");
txtPatient_Name.Text = Utility.sDbnull(dtChidinh.Rows[0]["ten_khachhang"], "");
txtDiaChi.Text = Utility.sDbnull(dtChidinh.Rows[0]["dia_chi"], "");
objChidinh = KcbChidinhcl.FetchByID(id_chidinh);
HienthiNhapketqua(id_dichvu, co_chitiet);
}
else
{
Utility.ShowMsg("Không tìm thấy dữ liệu chỉ định kiểm nghiệm để nhập kết quả. Liên hệ IT để được trợ giúp");
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi:" + ex.Message);
}
}
public void InsertAssignDetail(KcbChidinhcl objChidinh, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] assignDetail)
{
using (var scope = new TransactionScope())
{
if (objLuotkham == null)
{
return;
}
foreach (KcbChidinhclsChitiet objChidinhCtiet in assignDetail)
{
log.Info("1.1 Them moi thong tin cua phieu chi dinh chi tiet voi ma phieu Id_chidinh=" +
objChidinh.IdChidinh);
objChidinhCtiet.IdDoituongKcb = Utility.Int16Dbnull(objLuotkham.IdDoituongKcb);
objChidinhCtiet.IdChidinh = Utility.Int32Dbnull(objChidinh.IdChidinh);
objChidinhCtiet.IdKham = Utility.Int32Dbnull(objChidinh.IdKham, -1);
decimal ptramBHYT = Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0);
TinhCLS.GB_TinhPhtramBHYT(objChidinhCtiet, objLuotkham, Utility.Byte2Bool(objChidinh.Noitru), ptramBHYT);
objChidinhCtiet.MaLuotkham = objChidinh.MaLuotkham;
objChidinhCtiet.IdBenhnhan = objChidinh.IdBenhnhan;
if (Utility.DecimaltoDbnull(objChidinhCtiet.SoLuong) <= 0)
{
objChidinhCtiet.SoLuong = 1;
}
if (objChidinhCtiet.IdChitietchidinh <= 0)
{
log.Info("1.2 Bat dau them moi Id_chidinh=" + objChidinh.IdChidinh + "timeprocess in : " + globalVariables.SysDate.ToString());
var sp = SPs.SpKcbThemmoiChitietChidinh(objChidinhCtiet.IdChitietchidinh, objChidinhCtiet.IdKham, objChidinhCtiet.IdChidinh, objChidinhCtiet.IdChidinhChuyengoi
, objChidinhCtiet.IdDichvu, objChidinhCtiet.IdChitietdichvu, objChidinhCtiet.PtramBhytGoc, objChidinhCtiet.PtramBhyt, objChidinhCtiet.GiaDanhmuc, objChidinhCtiet.MadoituongGia
, objChidinhCtiet.DonGia, objChidinhCtiet.PhuThu, objChidinhCtiet.NguoiTao, objChidinhCtiet.IdLoaichidinh, objChidinhCtiet.NgayTao, objChidinhCtiet.TrangthaiThanhtoan
, objChidinhCtiet.NgayThanhtoan, objChidinhCtiet.TrangthaiHuy, objChidinhCtiet.TuTuc, objChidinhCtiet.LoaiChietkhau, objChidinhCtiet.IdDoituongKcb
, objChidinhCtiet.IdBenhnhan, objChidinhCtiet.MaLuotkham, objChidinhCtiet.SoLuong, objChidinhCtiet.TrangThai, objChidinhCtiet.TrangthaiBhyt, objChidinhCtiet.HienthiBaocao
, objChidinhCtiet.BhytChitra, objChidinhCtiet.BnhanChitra, objChidinhCtiet.IdThanhtoan, objChidinhCtiet.IdKhoaThuchien, objChidinhCtiet.IdPhongThuchien
, objChidinhCtiet.TileChietkhau, objChidinhCtiet.TienChietkhau, objChidinhCtiet.KieuChietkhau, objChidinhCtiet.IdGoi, objChidinhCtiet.TrongGoi
, objChidinhCtiet.IdBacsiThuchien, objChidinhCtiet.NguoiThuchien, objChidinhCtiet.NgayThuchien, objChidinhCtiet.ImgPath1, objChidinhCtiet.ImgPath2, objChidinhCtiet.ImgPath3, objChidinhCtiet.ImgPath4
, objChidinhCtiet.FTPImage, objChidinhCtiet.KetQua, objChidinhCtiet.ChidinhGoidichvu, objChidinhCtiet.NguonThanhtoan, objChidinhCtiet.IpMaytao, objChidinhCtiet.TenMaytao
, objChidinhCtiet.ChitieuPhantich, objChidinhCtiet.MahoaMau, objChidinhCtiet.MauUutien, objChidinhCtiet.NgayhenTrakq, objChidinhCtiet.ThetichkhoiluongMau, objChidinhCtiet.TinhtrangMau
);
sp.Execute();
objChidinhCtiet.IdChitietchidinh = Utility.Int64Dbnull(sp.OutputValues[0]);
objChidinhCtiet.MahoaMau = Utility.sDbnull(sp.OutputValues[1]);
log.Info("1.3 ket thuc them moi Id_chidinh=" + objChidinh.IdChidinh + "timeprocess out: " + globalVariables.SysDate.ToString());
}
else
{
SPs.SpKcbCapnhatChitietChidinh(objChidinhCtiet.IdChitietchidinh, objChidinhCtiet.SoLuong, objChidinhCtiet.NgaySua, objChidinhCtiet.NguoiSua
, objChidinhCtiet.IpMaysua, objChidinhCtiet.TenMaysua).Execute();
}
}
scope.Complete();
}
}
/// <summary>
/// ham thực hiện viecj in phiếu cỉnh định
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuChiDinh_Click(object sender, EventArgs e)
{
if (grdDetail.CurrentRow != null)
{
int v_AssignId = Utility.Int32Dbnull(grdDetail.GetValue(KcbChidinhclsChitiet.Columns.IdChidinh), -1);
KcbChidinhcl objAssignInfo = KcbChidinhcl.FetchByID(v_AssignId);
if (objAssignInfo != null)
{
frm_INPHIEU_CLS frm = new frm_INPHIEU_CLS();
frm.objAssignInfo = KcbChidinhcl.FetchByID(v_AssignId);
frm.ShowDialog();
}
}
}
public ActionResult InsertDataChiDinhCLS(KcbChidinhcl objKcbChidinhcls, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objKcbChidinhcls != null)
{
if (objLuotkham == null)
{
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChidinhcls.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objKcbChidinhcls.IdBenhnhan)).ExecuteSingle<KcbLuotkham>();
}
if (objLuotkham != null)
{
objKcbChidinhcls.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objKcbChidinhcls.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objKcbChidinhcls.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objKcbChidinhcls.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objKcbChidinhcls.MaKhoaChidinh = globalVariables.MA_KHOA_THIEN;
objKcbChidinhcls.IsNew = true;
objKcbChidinhcls.Save();
InsertAssignDetail(objKcbChidinhcls, objLuotkham, arrAssignDetails);
}
else
{
return ActionResult.Error;
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin {0}", exception);
return ActionResult.Error;
}
}
public ActionResult UpdateDataChiDinhCLS(KcbChidinhcl objChidinh, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
log.Trace("BEGIN UPDATE.................................................................");
if (objLuotkham == null)
{
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objChidinh.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objChidinh.IdBenhnhan)).ExecuteSingle <KcbLuotkham>();
}
SPs.SpKcbCapnhatChidinh(objChidinh.IdChidinh, objChidinh.NgayChidinh, objChidinh.IdBacsiChidinh, objChidinh.IdPhongChidinh, objChidinh.NguoiSua
, objChidinh.NgaySua, objChidinh.MaChidinh, objChidinh.IpMaysua, objChidinh.TenMaysua, objChidinh.NguoigiaoMau
, objChidinh.NguoinhanMau, objChidinh.MotaThem, objChidinh.LastActionName).Execute();
log.Trace("1. Da cap nhat chi dinh dich vu CLS");
if (Utility.Int32Dbnull(objChidinh.IdKham) > 0)
{
SPs.SpKcbCapnhatBacsiKham(objChidinh.IdKham, objChidinh.IdBacsiChidinh, 1).Execute();
}
log.Info("Cap nhap lai thong tin cua phieu chi dinh voi Id_chidinh=" + objChidinh.IdChidinh);
InsertAssignDetail(objChidinh, objLuotkham, arrAssignDetails);
log.Trace("1. Da cap nhat chi tiet chi dinh dich vu CLS");
}
scope.Complete();
log.Trace("END UPDATE.................................................................");
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin ", exception);
return(ActionResult.Error);
}
finally
{
GC.Collect();
}
}
public ActionResult InsertDataChiDinhCLS(KcbChidinhcl objAssignInfo, KcbLuotkham objPatientExam, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objAssignInfo != null)
{
if (objPatientExam == null)
{
objPatientExam = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objAssignInfo.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objAssignInfo.IdBenhnhan)).ExecuteSingle <KcbLuotkham>();
}
if (objPatientExam != null)
{
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
InsertAssignDetail(objAssignInfo, objPatientExam, arrAssignDetails);
}
else
{
return(ActionResult.Error);
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin {0}", exception);
return(ActionResult.Error);
}
}
public ActionResult UpdateDataChiDinhCLS(KcbChidinhcl objAssignInfo, KcbLuotkham objPatientExam, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPatientExam == null)
{
objPatientExam = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objAssignInfo.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objAssignInfo.IdBenhnhan)).ExecuteSingle <KcbLuotkham>();
}
new Update(KcbChidinhcl.Schema)
.Set(KcbChidinhcl.Columns.IdBacsiChidinh).EqualTo(globalVariables.gv_intIDNhanvien)
.Set(KcbChidinhcl.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbChidinhcl.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Where(KcbChidinhcl.Columns.IdChidinh).IsEqualTo(Utility.Int32Dbnull(objAssignInfo.IdChidinh)).Execute();
if (Utility.Int32Dbnull(objAssignInfo.IdKham) > 0)
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(globalVariables.gv_intIDNhanvien)
.Where(KcbDangkyKcb.IdKhamColumn).IsEqualTo(objAssignInfo.IdKham).Execute();
}
log.Info("Cap nhap lai thong tin cua phieu chi dinh voi Assign_ID=" + objAssignInfo.IdChidinh);
InsertAssignDetail(objAssignInfo, objPatientExam, arrAssignDetails);
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin ", exception);
return(ActionResult.Error);
}
}
public bool Destroy(object IdChidinh)
{
return(KcbChidinhcl.Destroy(IdChidinh) == 1);
}
public ActionResult UpdateDataChiDinhCLS(KcbChidinhcl objKcbChidinhcls, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objLuotkham == null)
{
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChidinhcls.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objKcbChidinhcls.IdBenhnhan)).ExecuteSingle<KcbLuotkham>();
}
new Update(KcbChidinhcl.Schema)
.Set(KcbChidinhcl.Columns.IdBacsiChidinh).EqualTo(objKcbChidinhcls.IdBacsiChidinh)
.Set(KcbChidinhcl.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbChidinhcl.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Where(KcbChidinhcl.Columns.IdChidinh).IsEqualTo(Utility.Int32Dbnull(objKcbChidinhcls.IdChidinh)).Execute();
if (Utility.Int32Dbnull(objKcbChidinhcls.IdKham) > 0)
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objKcbChidinhcls.IdBacsiChidinh)
.Where(KcbDangkyKcb.IdKhamColumn).IsEqualTo(objKcbChidinhcls.IdKham).Execute();
}
log.Info("Cap nhap lai thong tin cua phieu chi dinh voi Assign_ID=" + objKcbChidinhcls.IdChidinh);
InsertAssignDetail(objKcbChidinhcls, objLuotkham, arrAssignDetails);
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin ", exception);
return ActionResult.Error;
}
}
public DataTable LaythongtininphieuchidinhCLS(KcbChidinhcl objKcbChidinhcls)
{
return SPs.KcbThamkhamLaythongtinclsInphieuTach(objKcbChidinhcls.MaChidinh, objKcbChidinhcls.MaLuotkham,
Utility.Int32Dbnull(objKcbChidinhcls.IdBenhnhan)).GetDataSet().
Tables[0];
}
/// <summary>
/// hàm thực hiện việc khởi tạo thông tin của phiếu chỉ định cận lâm sàng
/// </summary>
/// <returns></returns>
private KcbChidinhcl CreateAssignInfo()
{
var objKcbChidinhcls = new KcbChidinhcl();
objKcbChidinhcls.MaChidinh = string.Empty;
objKcbChidinhcls.MaLuotkham = objLuotkham.MaLuotkham;
objKcbChidinhcls.IdBenhnhan = Utility.Int64Dbnull(objLuotkham.IdBenhnhan, -1);
objKcbChidinhcls.IdBacsiChidinh = Utility.Int16Dbnull(cbobacSyChiDinh.SelectedValue,globalVariables.gv_intIDNhanvien);
objKcbChidinhcls.IdKhoaChidinh = (Int16)globalVariables.idKhoatheoMay;
objKcbChidinhcls.NguoiTao = globalVariables.UserName;
objKcbChidinhcls.NgayTao = globalVariables.SysDate;
objKcbChidinhcls.NgayChidinh = dtRegDate.Value.Date;
objKcbChidinhcls.ChidinhGoidichvu = chidinhgoi;
objKcbChidinhcls.ChidinhChiphithem = chidinhchiphithem;
objKcbChidinhcls.IdKham = Exam_ID;
if (HosStatus == 0)
{
if (ObjRegExam != null)
{
objKcbChidinhcls.IdPhongChidinh = Utility.Int16Dbnull(ObjRegExam.IdPhongkham);
}
else
{
objKcbChidinhcls.IdPhongChidinh = (Int16)globalVariables.idKhoatheoMay;
}
}
else
{
}
if (objPhieudieutriNoitru != null)
{
objKcbChidinhcls.IdDieutri = objPhieudieutriNoitru.IdPhieudieutri;
objKcbChidinhcls.IdKhoadieutri = objPhieudieutriNoitru.IdKhoanoitru;
objKcbChidinhcls.IdBuongGiuong = objPhieudieutriNoitru.IdBuongGiuong;
objKcbChidinhcls.IdPhongChidinh = objPhieudieutriNoitru.IdKhoanoitru;
}
objKcbChidinhcls.Noitru = (byte?)HosStatus;
if (m_eAction == action.Update)
{
objKcbChidinhcls.IdChidinh = Utility.Int32Dbnull(txtAssign_ID.Text, -1);
objKcbChidinhcls.NgaySua = globalVariables.SysDate;
objKcbChidinhcls.NguoiSua = globalVariables.UserName;
objKcbChidinhcls.IpMaysua = globalVariables.gv_strIPAddress;
objKcbChidinhcls.TenMaysua = globalVariables.gv_strComputerName;
}
else
{
objKcbChidinhcls.IpMaytao = globalVariables.gv_strIPAddress;
objKcbChidinhcls.TenMaytao = globalVariables.gv_strComputerName;
}
return objKcbChidinhcls;
}
public void Insert(long? IdKham,long? IdBuongGiuong,int? IdDieutri,int? IdKhoadieutri,string MaLuotkham,long IdBenhnhan,DateTime NgayChidinh,short? IdBacsiChidinh,short? IdPhongChidinh,DateTime? NgayThanhtoan,byte TrangthaiThanhtoan,byte? TrangThai,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,byte? TinhtrangIn,string Barcode,byte? Noitru,short? IdKhoaChidinh,string MaKhoaChidinh,string MaChidinh,short? IdDoituongKcb,byte? IdLoaidoituongKcb,string MaDoituongKcb,byte? ChidinhGoidichvu,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.MaLuotkham = MaLuotkham;
item.IdBenhnhan = IdBenhnhan;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.ChidinhGoidichvu = ChidinhGoidichvu;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.Save(UserName);
}
public void Insert(long?IdKham, long?IdBuongGiuong, long?IdDieutri, int?IdKhoadieutri, string MaLuotkham, long IdBenhnhan, DateTime NgayChidinh, short?IdBacsiChidinh, short?IdPhongChidinh, DateTime?NgayThanhtoan, byte TrangthaiThanhtoan, byte?TrangThai, string NguoiTao, DateTime?NgayTao, string NguoiSua, DateTime?NgaySua, byte?TinhtrangIn, string Barcode, byte?Noitru, short?IdKhoaChidinh, string MaKhoaChidinh, string MaChidinh, string MaBenhpham, short?IdDoituongKcb, byte?IdLoaidoituongKcb, string MaDoituongKcb, byte?KieuChidinh, long?IdLichsuDoituongKcb, string MatheBhyt, string IpMaytao, string IpMaysua, string TenMaytao, string TenMaysua, string NguoigiaoMau, string NguoinhanMau, string MotaThem, byte?DaBangiaomau, int?LuongmauHoaly, int?LuongmauVisinh, int?LuongmauGui, byte?LuuMau, string DieukienLuumau, byte?ThanhlyMau, DateTime?NgayThanhly, string NguoiThanhly, string LastActionName)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.MaLuotkham = MaLuotkham;
item.IdBenhnhan = IdBenhnhan;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.MaBenhpham = MaBenhpham;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.KieuChidinh = KieuChidinh;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.NguoigiaoMau = NguoigiaoMau;
item.NguoinhanMau = NguoinhanMau;
item.MotaThem = MotaThem;
item.DaBangiaomau = DaBangiaomau;
item.LuongmauHoaly = LuongmauHoaly;
item.LuongmauVisinh = LuongmauVisinh;
item.LuongmauGui = LuongmauGui;
item.LuuMau = LuuMau;
item.DieukienLuumau = DieukienLuumau;
item.ThanhlyMau = ThanhlyMau;
item.NgayThanhly = NgayThanhly;
item.NguoiThanhly = NguoiThanhly;
item.LastActionName = LastActionName;
item.Save(UserName);
}
public bool Delete(object IdChidinh)
{
return(KcbChidinhcl.Delete(IdChidinh) == 1);
}
public static ActionResult Thembenhnhan(KcbDanhsachBenhnhan objdanhsachbenhnhan, KcbLuotkham objluotkham,
KcbChidinhcl objchidinh, KcbDangkyKcb objDangkyKcb,
KcbChidinhclsChitiet[] objchidinhchitiet,
ref string errMsg)
{
Logger log = LogManager.GetCurrentClassLogger();
try
{
var option = new TransactionOptions
{
IsolationLevel = IsolationLevel.Snapshot, Timeout = TimeSpan.FromMinutes(5)
};
using (var trans = new TransactionScope())
{
using (var shs = new SharedDbConnectionScope())
{
log.Trace("1.Bắt đầu thêm mới bệnh nhân " + objdanhsachbenhnhan.TenBenhnhan + "");
string PatientCode =
THU_VIEN_CHUNG.KCB_SINH_MALANKHAM(
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)));
// Them moi thong tin benh nhan
SqlQuery objdbenhnhan = new Select().From(KcbDanhsachBenhnhan.Schema)
.Where(KcbDanhsachBenhnhan.Columns.IdBenhnhan).IsEqualTo(objdanhsachbenhnhan.IdBenhnhan);
if (objdbenhnhan.GetRecordCount() > 0)
{
objdanhsachbenhnhan.MarkOld();
objdanhsachbenhnhan.IsLoaded = true;
}
else
{
objdanhsachbenhnhan.IsNew = true;
}
objdanhsachbenhnhan.Save();
log.Trace("2. Đã thêm mới Bệnh nhân");
// them moi lan kham cho benh nhan
objluotkham.MaLuotkham = Utility.sDbnull(PatientCode, "");
SqlQuery sqlPatientExam = new Select().From(KcbLuotkham.Schema).Where(
KcbLuotkham.Columns.MaLuotkham)
.IsEqualTo(objluotkham.MaLuotkham);
if (sqlPatientExam.GetRecordCount() > 0)
{
objluotkham.MarkOld();
objluotkham.IsLoaded = true;
}
else
{
objluotkham.IsNew = true;
objluotkham.MaLuotkham = PatientCode;
objluotkham.IdBenhnhan = objdanhsachbenhnhan.IdBenhnhan;
}
objluotkham.Save();
log.Trace("3. Đã thêm mới Lượt khám Bệnh nhân");
DataTable dtCheck =
SPs.SpKcbKiemtraTrungMaLuotkham(objluotkham.IdBenhnhan, objluotkham.MaLuotkham).
GetDataSet().Tables[0];
if (dtCheck != null && dtCheck.Rows.Count > 0)
{
log.Trace("3.1 Đã phát hiện trùng mã Bệnh nhân-->Lấy lại mã mới");
string patientCode =
THU_VIEN_CHUNG.KCB_SINH_MALANKHAM(
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)));
SPs.SpKcbCapnhatLuotkhamMaluotkham(patientCode, objluotkham.MaLuotkham,
objluotkham.IdBenhnhan).Execute();
log.Trace("3.2 Cập nhập mã lượt khám này được sử dụng rồi");
// SPs.SpKcbCapnhatMaluotkhamLichsudoituongKcb(patientCode, objLichsuKcb.IdLichsuDoituongKcb).Execute();
// log.Trace("3.2 Đã Cập nhật lại mã lượt khám mới");
objluotkham.MaLuotkham = patientCode;
}
SPs.SpKcbCapnhatDmucLuotkham(objluotkham.MaLuotkham,
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)), 1, 2,
globalVariables.UserName).Execute();
log.Trace("4. Đã đánh dấu mã lượt khám đã được sử dụng trong hệ thống");
// Them moi thong tin chi dinh cho benh nhan
if (objDangkyKcb != null)
{
SqlQuery sqldangkykcb = new Select().From(KcbDangkyKcb.Schema).Where(
KcbDangkyKcb.Columns.IdKham)
.IsEqualTo(Utility.Int64Dbnull(objDangkyKcb.IdKham, -1));
if (sqldangkykcb.GetRecordCount() > 0)
{
objDangkyKcb.MarkOld();
objDangkyKcb.IsLoaded = true;
}
else
{
objDangkyKcb.IsNew = true;
objDangkyKcb.MaLuotkham = PatientCode;
objDangkyKcb.IdBenhnhan = objdanhsachbenhnhan.IdBenhnhan;
}
objDangkyKcb.Save();
}
SqlQuery sqlAssignInfo = new Select().From(KcbChidinhcl.Schema)
.Where(KcbChidinhcl.Columns.IdChidinh).IsEqualTo(objchidinh.IdChidinh);
if (objDangkyKcb != null)
{
objchidinh.IdKham = objDangkyKcb.IdKham;
}
objchidinh.IdDoituongKcb = 3;
objchidinh.MaDoituongKcb = "KSK";
objchidinh.IdLoaidoituongKcb = 2;
if (sqlAssignInfo.GetRecordCount() > 0)
{
objchidinh.MarkOld();
objchidinh.IsLoaded = true;
}
else
{
objchidinh.IsNew = true;
objchidinh.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLSKSK();
}
objchidinh.IdBenhnhan = objluotkham.IdBenhnhan;
objchidinh.MaLuotkham = objluotkham.MaLuotkham;
objchidinh.NguoiSua = globalVariables.UserName;
objchidinh.NgaySua = DateTime.Now;
if (string.IsNullOrEmpty(objchidinh.MaKhoaChidinh))
{
objchidinh.MaKhoaChidinh = Utility.sDbnull(objluotkham.MaKhoaThuchien);
}
objchidinh.Save();
log.Trace("5. Đã thêm mới phiếu chỉ định cho bệnh nhân");
if (Utility.Int32Dbnull(objchidinh.IdChidinh) > 0)
{
foreach (KcbChidinhclsChitiet objAssignDetail in objchidinhchitiet)
{
// Them chi tiet chi dinh cho benh nhan
SqlQuery sqlAssignDetail = new Select().From(KcbChidinhclsChitiet.Schema)
.Where(KcbChidinhclsChitiet.Columns.IdChitietchidinh).IsEqualTo(
objAssignDetail.IdChitietchidinh);
if (sqlAssignDetail.GetRecordCount() > 0)
{
objAssignDetail.MarkOld();
objAssignDetail.IsLoaded = true;
}
else
{
objAssignDetail.IsNew = true;
}
objAssignDetail.IdDoituongKcb = Utility.Int16Dbnull(objluotkham.IdDoituongKcb);
objAssignDetail.MaLuotkham = objchidinh.MaLuotkham;
objAssignDetail.IdBenhnhan = objchidinh.IdBenhnhan;
objAssignDetail.IdKham = objchidinh.IdKham;
objAssignDetail.IdChidinh = Utility.Int32Dbnull(objchidinh.IdChidinh);
// objAssignDetail.IdKham = -1;
objAssignDetail.IpMaytao = globalVariables.gv_strIPAddress;
objAssignDetail.PtramBhyt =
Utility.DecimaltoDbnull(objluotkham.PtramBhyt);
objAssignDetail.IdBacsiThuchien = globalVariables.IdKhoaNhanvien;
// objAssignDetail.IsNew = true;
objAssignDetail.Save();
log.Info(
"Them moi thong tin cua phieu chi dinh chi tiet voi ma phieu Assign_ID=" +
objchidinh.IdChidinh);
}
log.Trace("6. Đã thêm mới chi tiết phiếu chỉ định cho bệnh nhân");
}
else
{
log.Trace("7. Lỗi thêm bệnh nhân vào hệ thống");
return(ActionResult.Error);
}
}
trans.Complete();
log.Trace("8. Thêm bệnh nhân có ID_Benhnhan " + objdanhsachbenhnhan.IdBenhnhan +
" vào hệ thống thành công");
errMsg = @"Thêm mới thành công bệnh nhân";
return(ActionResult.Success);
}
}
catch (Exception ex)
{
errMsg = "Lỗi thêm mới bệnh nhân : " + ex.Message;
log.Error(ex.Message);
return(ActionResult.Error);
}
}
public DataTable LaythongtininphieuchidinhCLS(KcbChidinhcl objChidinh)
{
return(SPs.KcbThamkhamLaythongtinclsInphieuTach(objChidinh.MaChidinh, objChidinh.MaLuotkham,
Utility.Int32Dbnull(objChidinh.IdBenhnhan)).GetDataSet().
Tables[0]);
}
public ActionResult SaoChepPhieuDieuTri(NoitruPhieudieutri[] lstPhieudieutri, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrChidinhCLSChitiet, KcbDonthuocChitiet[] arrDonthuocChitiet)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
foreach (NoitruPhieudieutri objTreatment in lstPhieudieutri)
{
objTreatment.NguoiTao = globalVariables.UserName;
objTreatment.NgayTao = DateTime.Now;
objTreatment.TthaiBosung = 0;
objTreatment.IdBacsi = globalVariables.gv_intIDNhanvien;
objTreatment.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objTreatment.MaLuotkham = objLuotkham.MaLuotkham;
objTreatment.IdBenhnhan = objTreatment.IdBenhnhan;
objTreatment.IdBuongGiuong = objLuotkham.IdRavien;
objTreatment.TrangThai = 0;
objTreatment.TthaiIn = 0;
objTreatment.IpMaytao = globalVariables.gv_strIPAddress;
objTreatment.TenMaytao = globalVariables.gv_strComputerName;
objTreatment.GioDieutri = Utility.GetFormatDateTime(globalVariables.SysDate, "hh:mm:ss");
objTreatment.IsNew = true;
objTreatment.Save();
if (arrChidinhCLSChitiet.Length > 0)
{
KcbChidinhcl objAssignInfo = new KcbChidinhcl();
objAssignInfo.IdDieutri = objTreatment.IdPhieudieutri;
objAssignInfo.IdBuongGiuong = objTreatment.IdBuongGiuong;
objAssignInfo.MaLuotkham = objTreatment.MaLuotkham;
objAssignInfo.IdBenhnhan = Utility.Int32Dbnull(objTreatment.IdBenhnhan);
objAssignInfo.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objAssignInfo.Noitru = 1;
objAssignInfo.IdKhoadieutri = objTreatment.IdKhoanoitru;
objAssignInfo.IdKhoaChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.IdKham = -1;
objAssignInfo.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objAssignInfo.IdPhongChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.Barcode = string.Empty;
objAssignInfo.NgayChidinh = objTreatment.NgayDieutri.Value;
objAssignInfo.NguoiTao = globalVariables.UserName;
objAssignInfo.NgayTao = globalVariables.SysDate;
objAssignInfo.IpMaytao = globalVariables.gv_strIPAddress;
objAssignInfo.TenMaytao = globalVariables.gv_strComputerName;
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
List <KcbChidinhclsChitiet> lstChidinhCLSChitiet = new List <KcbChidinhclsChitiet>();
foreach (KcbChidinhclsChitiet objAssignDetail in arrChidinhCLSChitiet)
{
KcbChidinhclsChitiet objDetail = KcbChidinhclsChitiet.FetchByID(objAssignDetail.IdChitietchidinh);
if (objDetail != null)
{
objDetail.IdChitietchidinh = -1;
objDetail.IdChidinh = objAssignInfo.IdChidinh;
objDetail.IdKham = -1;
objDetail.TrangthaiThanhtoan = 0;
objDetail.NgayThanhtoan = null;
objDetail.TrangthaiHuy = 0;
objDetail.ImgPath1 = string.Empty;
objDetail.ImgPath2 = string.Empty;
objDetail.ImgPath3 = string.Empty;
objDetail.ImgPath4 = string.Empty;
objDetail.TrangThai = 0;
//objDetail.MotaThem = null;
objDetail.TrangthaiBhyt = 0;
objDetail.IdThanhtoan = -1;
objDetail.IdKhoaThuchien = (short)objAssignInfo.IdKhoadieutri;
objDetail.IdPhongThuchien = objDetail.IdKhoaThuchien;
objDetail.IdGoi = -1;
objDetail.IdBacsiThuchien = -1;
objDetail.NgayThuchien = null;
objDetail.NguoiThuchien = null;
//objDetail.KetLuan = null;
objDetail.KetQua = null;
//objDetail.DeNghi = null;
//objDetail.MaVungkhaosat = null;
objDetail.NguoiTao = globalVariables.UserName;
objDetail.NgayTao = globalVariables.SysDate;
objDetail.IpMaytao = globalVariables.gv_strIPAddress;
objDetail.TenMaytao = globalVariables.gv_strComputerName;
objDetail.IsNew = true;
lstChidinhCLSChitiet.Add(objDetail);
}
new KCB_CHIDINH_CANLAMSANG().InsertAssignDetail(objAssignInfo, objLuotkham, lstChidinhCLSChitiet.ToArray <KcbChidinhclsChitiet>());
}
}
if (arrDonthuocChitiet.Length > 0)
{
var query = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
let y = donthuoc.IdDonthuoc
select y).Distinct();
foreach (var pres_id in query.ToList())
{
KcbDonthuoc objPresInfo = KcbDonthuoc.FetchByID(Utility.Int32Dbnull(pres_id));
if (objPresInfo != null)
{
objPresInfo.Noitru = 1;
List <KcbDonthuocChitiet> lstDonthuocchitiet = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
where donthuoc.IdDonthuoc == pres_id
select donthuoc).ToList <KcbDonthuocChitiet>();
SaoChepDonThuocTheoPhieuDieuTri(objPresInfo, objTreatment, lstDonthuocchitiet.ToArray <KcbDonthuocChitiet>());
}
}
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
return(ActionResult.Error);
}
}
public void Insert(long? IdKham,long? IdBuongGiuong,long? IdDieutri,int? IdKhoadieutri,long IdBenhnhan,string MaLuotkham,DateTime NgayChidinh,short? IdBacsiChidinh,short? IdPhongChidinh,DateTime? NgayThanhtoan,byte TrangthaiThanhtoan,byte? TrangThai,byte? TinhtrangIn,string Barcode,byte? Noitru,short? IdKhoaChidinh,string MaKhoaChidinh,string MaChidinh,string MaBenhpham,short? IdDoituongKcb,byte? IdLoaidoituongKcb,string MaDoituongKcb,byte? KieuChidinh,long? IdLichsuDoituongKcb,string MatheBhyt,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua,string NguoigiaoMau,string NguoinhanMau,string MotaThem,byte? DaBangiaomau,int? LuongmauHoaly,int? LuongmauVisinh,int? LuongmauGui,byte? LuuMau,string DieukienLuumau,byte? ThanhlyMau,DateTime? NgayThanhly,string NguoiThanhly,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,string LastActionName)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.MaBenhpham = MaBenhpham;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.KieuChidinh = KieuChidinh;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.NguoigiaoMau = NguoigiaoMau;
item.NguoinhanMau = NguoinhanMau;
item.MotaThem = MotaThem;
item.DaBangiaomau = DaBangiaomau;
item.LuongmauHoaly = LuongmauHoaly;
item.LuongmauVisinh = LuongmauVisinh;
item.LuongmauGui = LuongmauGui;
item.LuuMau = LuuMau;
item.DieukienLuumau = DieukienLuumau;
item.ThanhlyMau = ThanhlyMau;
item.NgayThanhly = NgayThanhly;
item.NguoiThanhly = NguoiThanhly;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.LastActionName = LastActionName;
item.Save(UserName);
}
public ActionResult InsertDataChiDinhCls(KcbChidinhcl objChidinh, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objChidinh != null)
{
log.Trace("BEGIN INSERTING..........................................................");
if (objLuotkham == null)
{
log.Trace("Lieu co the vao day duoc khong..........................................................");
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objChidinh.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objChidinh.IdBenhnhan)).ExecuteSingle <KcbLuotkham>();
}
if (objLuotkham != null)
{
log.Trace("0.1. Bat dau sinh code");
objChidinh.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objChidinh.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objChidinh.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objChidinh.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objChidinh.MaKhoaChidinh = globalVariables.MA_KHOA_THIEN;
log.Trace("0.2. Bat dau them moi chi dinh CLS");
var sp = SPs.SpKcbThemmoiChidinh(objChidinh.IdChidinh, objChidinh.IdKham, objChidinh.IdBuongGiuong, objChidinh.IdDieutri, objChidinh.IdKhoadieutri
, objChidinh.MaLuotkham, objChidinh.IdBenhnhan, objChidinh.NgayChidinh, objChidinh.IdBacsiChidinh, objChidinh.IdPhongChidinh, objChidinh.NgayThanhtoan
, objChidinh.TrangthaiThanhtoan, Utility.ByteDbnull(objChidinh.TrangThai, 0), objChidinh.NguoiTao, objChidinh.NgayTao, objChidinh.TinhtrangIn, objChidinh.Barcode, objChidinh.Noitru
, objChidinh.IdKhoaChidinh, objChidinh.MaKhoaChidinh, objChidinh.MaChidinh, objChidinh.MaBenhpham, objChidinh.IdDoituongKcb, objChidinh.IdLoaidoituongKcb
, objChidinh.MaDoituongKcb, objChidinh.KieuChidinh, objChidinh.IdLichsuDoituongKcb, objChidinh.MatheBhyt, objChidinh.IpMaytao, objChidinh.TenMaytao
, objChidinh.NguoigiaoMau, objChidinh.NguoinhanMau, objChidinh.MotaThem, objChidinh.DaBangiaomau, objChidinh.LuongmauHoaly, objChidinh.LuongmauVisinh, objChidinh.LuongmauGui
, objChidinh.LuuMau, objChidinh.DieukienLuumau, objChidinh.ThanhlyMau, objChidinh.NgayThanhly, objChidinh.NguoiThanhly, objChidinh.LastActionName);
sp.Execute();
log.Trace("0.3 Da thuc hien xong cau SP");
objChidinh.IdChidinh = Utility.Int64Dbnull(sp.OutputValues[0]);
log.Trace("1. Da them moi chi dinh CLS");
SPs.SpKcbCapnhatBacsiKham(objChidinh.IdKham, objChidinh.IdBacsiChidinh, 1).Execute();
InsertAssignDetail(objChidinh, objLuotkham, arrAssignDetails);
log.Trace("2. Da them moi chi tiet chi dinh CLS");
}
else
{
return(ActionResult.Error);
}
}
}
scope.Complete();
log.Trace("FINISH INSERTING..........................................................");
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.Error(string.Format("Loi khi them moi chi dinh dich vu CLS {0}", exception.Message));
return(ActionResult.Error);
}
finally
{
GC.Collect();
}
}
public ActionResult SaoChepPhieuDieuTri(NoitruPhieudieutri[] lstPhieudieutri, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrChidinhCLSChitiet, KcbDonthuocChitiet[] arrDonthuocChitiet)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
foreach (NoitruPhieudieutri objTreatment in lstPhieudieutri)
{
objTreatment.NguoiTao = globalVariables.UserName;
objTreatment.NgayTao = DateTime.Now;
objTreatment.TthaiBosung = 0;
objTreatment.IdBacsi = globalVariables.gv_intIDNhanvien;
objTreatment.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objTreatment.MaLuotkham = objLuotkham.MaLuotkham;
objTreatment.IdBenhnhan = objTreatment.IdBenhnhan;
objTreatment.IdBuongGiuong = objLuotkham.IdRavien;
objTreatment.TrangThai = 0;
objTreatment.TthaiIn = 0;
objTreatment.IpMaytao = globalVariables.gv_strIPAddress;
objTreatment.TenMaytao = globalVariables.gv_strComputerName;
objTreatment.GioDieutri = Utility.GetFormatDateTime(globalVariables.SysDate, "hh:mm:ss");
objTreatment.IsNew = true;
objTreatment.Save();
if (arrChidinhCLSChitiet.Length > 0)
{
KcbChidinhcl objAssignInfo = new KcbChidinhcl();
objAssignInfo.IdDieutri = objTreatment.IdPhieudieutri;
objAssignInfo.IdBuongGiuong = objTreatment.IdBuongGiuong;
objAssignInfo.MaLuotkham = objTreatment.MaLuotkham;
objAssignInfo.IdBenhnhan = Utility.Int32Dbnull(objTreatment.IdBenhnhan);
objAssignInfo.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objAssignInfo.Noitru = 1;
objAssignInfo.IdKhoadieutri = objTreatment.IdKhoanoitru;
objAssignInfo.IdKhoaChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.IdKham=-1;
objAssignInfo.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objAssignInfo.IdPhongChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.Barcode = string.Empty;
objAssignInfo.NgayChidinh = objTreatment.NgayDieutri.Value;
objAssignInfo.NguoiTao = globalVariables.UserName;
objAssignInfo.NgayTao = globalVariables.SysDate;
objAssignInfo.IpMaytao = globalVariables.gv_strIPAddress;
objAssignInfo.TenMaytao = globalVariables.gv_strComputerName;
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
List<KcbChidinhclsChitiet> lstChidinhCLSChitiet=new List<KcbChidinhclsChitiet>();
foreach (KcbChidinhclsChitiet objAssignDetail in arrChidinhCLSChitiet)
{
KcbChidinhclsChitiet objDetail = KcbChidinhclsChitiet.FetchByID(objAssignDetail.IdChitietchidinh);
if (objDetail != null)
{
objDetail.IdChitietchidinh = -1;
objDetail.IdChidinh = objAssignInfo.IdChidinh;
objDetail.IdKham = -1;
objDetail.TrangthaiThanhtoan = 0;
objDetail.NgayThanhtoan = null;
objDetail.TrangthaiHuy = 0;
objDetail.ImgPath1 = string.Empty;
objDetail.ImgPath2 = string.Empty;
objDetail.ImgPath3 = string.Empty;
objDetail.ImgPath4 = string.Empty;
objDetail.TrangThai =0;
//objDetail.MotaThem = null;
objDetail.TrangthaiBhyt = 0;
objDetail.IdThanhtoan = -1;
objDetail.IdKhoaThuchien =(short) objAssignInfo.IdKhoadieutri;
objDetail.IdPhongThuchien = objDetail.IdKhoaThuchien;
objDetail.IdGoi = -1;
objDetail.IdBacsiThuchien = -1;
objDetail.NgayThuchien = null;
objDetail.NguoiThuchien = null;
//objDetail.KetLuan = null;
objDetail.KetQua = null;
//objDetail.DeNghi = null;
//objDetail.MaVungkhaosat = null;
objDetail.NguoiTao = globalVariables.UserName;
objDetail.NgayTao = globalVariables.SysDate;
objDetail.IpMaytao = globalVariables.gv_strIPAddress;
objDetail.TenMaytao = globalVariables.gv_strComputerName;
objDetail.IsNew=true;
lstChidinhCLSChitiet.Add(objDetail);
}
new KCB_CHIDINH_CANLAMSANG().InsertAssignDetail(objAssignInfo, objLuotkham, lstChidinhCLSChitiet.ToArray<KcbChidinhclsChitiet>());
}
}
if (arrDonthuocChitiet.Length > 0)
{
var query = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
let y = donthuoc.IdDonthuoc
select y).Distinct();
foreach (var pres_id in query.ToList())
{
KcbDonthuoc objPresInfo = KcbDonthuoc.FetchByID(Utility.Int32Dbnull(pres_id));
if (objPresInfo != null)
{
objPresInfo.Noitru = 1;
List<KcbDonthuocChitiet> lstDonthuocchitiet = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
where donthuoc.IdDonthuoc == pres_id
select donthuoc).ToList<KcbDonthuocChitiet>();
SaoChepDonThuocTheoPhieuDieuTri(objPresInfo, objTreatment, lstDonthuocchitiet.ToArray<KcbDonthuocChitiet>());
}
}
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
return ActionResult.Error;
}
}
/// <summary>
/// hàm thực hiện việc khởi tạo thông tin của phiếu chỉ định cận lâm sàng
/// </summary>
/// <returns></returns>
private KcbChidinhcl TaoPhieuchidinh()
{
KcbChidinhcl objKcbChidinhcls = null;
objKcbChidinhcls = KcbChidinhcl.FetchByID(Utility.Int32Dbnull(txtAssign_ID.Text, -1));
if (objKcbChidinhcls != null)
{
objKcbChidinhcls.IsNew = false;
objKcbChidinhcls.MarkOld();
}
else
{
objKcbChidinhcls = new KcbChidinhcl();
objKcbChidinhcls.IsNew = true;
}
objKcbChidinhcls.IdLichsuDoituongKcb = objLuotkham.IdLichsuDoituongKcb;
objKcbChidinhcls.MatheBhyt = objLuotkham.MatheBhyt;
objKcbChidinhcls.MaChidinh = string.Empty;
objKcbChidinhcls.MaLuotkham = objLuotkham.MaLuotkham;
objKcbChidinhcls.IdBenhnhan = Utility.Int64Dbnull(objLuotkham.IdBenhnhan, -1);
objKcbChidinhcls.IdBacsiChidinh = Utility.Int16Dbnull(txtBacsi.MyID, globalVariables.gv_intIDNhanvien);
objKcbChidinhcls.IdKhoaChidinh = (Int16)globalVariables.idKhoatheoMay;
objKcbChidinhcls.NguoiTao = globalVariables.UserName;
objKcbChidinhcls.NgayTao = globalVariables.SysDate;
objKcbChidinhcls.NgayChidinh = dtRegDate.Value.Date;
objKcbChidinhcls.KieuChidinh = kieu_chidinh;
objKcbChidinhcls.IdKham = Exam_ID;
if (HosStatus == 0)
{
if (ObjRegExam != null)
{
objKcbChidinhcls.IdPhongChidinh = Utility.Int16Dbnull(ObjRegExam.IdPhongkham);
}
else
{
objKcbChidinhcls.IdPhongChidinh = (Int16)globalVariables.idKhoatheoMay;
}
}
else
{
}
if (objPhieudieutriNoitru != null)
{
objKcbChidinhcls.IdDieutri = objPhieudieutriNoitru.IdPhieudieutri;
objKcbChidinhcls.IdKhoadieutri = objPhieudieutriNoitru.IdKhoanoitru;
objKcbChidinhcls.IdBuongGiuong = objPhieudieutriNoitru.IdBuongGiuong;
objKcbChidinhcls.IdPhongChidinh = objPhieudieutriNoitru.IdKhoanoitru;
}
objKcbChidinhcls.Noitru = (byte?)HosStatus;
if (m_eAction == action.Update)
{
objKcbChidinhcls.NgaySua = globalVariables.SysDate;
objKcbChidinhcls.NguoiSua = globalVariables.UserName;
objKcbChidinhcls.IpMaysua = globalVariables.gv_strIPAddress;
objKcbChidinhcls.TenMaysua = globalVariables.gv_strComputerName;
}
else
{
objKcbChidinhcls.IpMaytao = globalVariables.gv_strIPAddress;
objKcbChidinhcls.TenMaytao = globalVariables.gv_strComputerName;
}
return objKcbChidinhcls;
}
private void BtnTestTypeClick(object sender, EventArgs e)
{
try
{
int count;
var btn = (UIButton)sender;
var sql =
new Select().From(KcbDanhsachBenhnhan.Schema.Name)
.Where(KcbDanhsachBenhnhan.Columns.Pid)
.IsEqualTo(txtPID.Text.Trim())
.ExecuteSingle<KcbDanhsachBenhnhan>();
patientId = Utility.Int32Dbnull(sql.IdBenhnhan);
idnhomdv = Utility.Int16Dbnull(btn.Tag);
count = KcbChidinhcl.CreateQuery().WHERE(KcbChidinhcl.Columns.IdBenhnhan, patientId).
WHERE(KcbChidinhcl.Columns.IdLoaidichvu, idnhomdv).GetRecordCount();
if (count > 0)
{
//Utility.ShowMsg("Loại Xét Nghiệm đã được đăng ký");
//Todo: focus vào test đã đăng ký
for (int i = 0; i < grdTestInfo.RowCount; i++)
{
string idloaidv = Utility.sDbnull(grdTestInfo.GetRow(i).Cells["id_loaidichvu"].Value);
if ((idloaidv) == (string)btn.Tag)
{
grdTestInfo.MoveTo(i);
dtResultDetail = SPs.DmucLaydanhmucDichvuCLSChitiet(Utility.Int16Dbnull(idloaidv)).GetDataSet().Tables[0];
grdDichVuChiTiet.DataSource = dtResultDetail;
break;
}
}
return;
}
string vBarcode = "";
DataRow drTestType = Utility.GetDataRow(dtTestTypeList, VDmucDichvucl.Columns.IdDichvu, btn.Tag);
{
vBarcode = CommonBussines.GetBarcodeForPatient(patientId, idnhomdv, drTestType[VDmucDichvucl.Columns.SttHthiLoaidvu].ToString());
if (vBarcode == "-1")
{
Utility.ShowMsg("Không tìm được Barcode");
return;
}
}
var obj = new KcbChidinhcl();
obj.IdLoaidichvu = Utility.Int16Dbnull(idnhomdv);
obj.Barcode = vBarcode;
obj.IdBenhnhan = patientId;
obj.NgayTao = DateTime.Now;
obj.NguoiTao = globalVariables.UserName;
obj.Barcode = vBarcode;
obj.IdDoituongKcb = Utility.Int16Dbnull(cbodoituong.SelectedValue);
obj.NgayChidinh = DateTime.Now;
obj.IsNew = true;
obj.Save();
short id = Utility.Int16Dbnull(btn.Tag);
dtResultDetail = SPs.DmucLaydanhmucDichvuCLSChitiet(id).GetDataSet().Tables[0];
grdDichVuChiTiet.DataSource = dtResultDetail;
DataRow dr = dtTestInfo.NewRow();
dr[KcbChidinhcl.Columns.IdChidinh] = KcbChidinhcl.CreateQuery().WHERE(KcbChidinhcl.Columns.IdBenhnhan, patientId).
WHERE(KcbChidinhcl.Columns.IdLoaidichvu, idnhomdv).GetMax(KcbChidinhcl.Columns.IdChidinh);
dr[KcbChidinhcl.Columns.NgayChidinh] = obj.NgayChidinh;
dr[KcbChidinhcl.Columns.Barcode] = obj.Barcode;
dr[KcbChidinhcl.Columns.IdBenhnhan] = obj.IdBenhnhan;
dr[KcbChidinhcl.Columns.IdLoaidichvu] = obj.IdLoaidichvu;
dr[KcbChidinhcl.Columns.NguoiTao] = obj.NguoiSua;
dr[DmucDichvucl.Columns.TenDichvu] = drTestType[DmucDichvucl.Columns.TenDichvu].ToString();
dtTestInfo.Rows.InsertAt(dr, 0);
grdTestInfo.SelectionChanged -= grdTestInfo_SelectionChanged;
dtTestInfo.AcceptChanges();
grdTestInfo.SelectionChanged += grdTestInfo_SelectionChanged;
grdTestInfo.MoveFirst();
grdTestInfo.DataSource = dtTestInfo;
// Todo: xử lý sau khi nhấn nút đăng ký
//Nếu ô đăng ký test có dl thì chuyển sang
//if (flpTestGroup.Controls.Count > 0) flpTestGroup.Focus();
//else flpStandardTest.Focus();
//LoadRegisteredTestType();
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
finally { FocusButtonDetail(); }
}
