public KcbChandoanKetluanCollection FetchAll()
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection();
Query qry = new Query(KcbChandoanKetluan.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public KcbChandoanKetluanCollection FetchByQuery(Query qry)
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public KcbChandoanKetluanCollection FetchAll()
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection();
Query qry = new Query(KcbChandoanKetluan.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public KcbChandoanKetluanCollection FetchByID(object IdChandoan)
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection().Where("id_chandoan", IdChandoan).Load();
return(coll);
}
public KcbChandoanKetluanCollection FetchByQuery(Query qry)
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public KcbChandoanKetluanCollection FetchByID(object IdChandoan)
{
KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection().Where("id_chandoan", IdChandoan).Load();
return coll;
}
/// <summary>
/// hàm thực hiện việc update thông tin xác nhận gói
/// </summary>
/// <param name="objThongtinGoiDvuBnhan"></param>
/// <returns></returns>
public ActionResult UpdateExamInfo(KcbChandoanKetluan objDiagInfo, KcbDangkyKcb objRegExam,
KcbLuotkham objPatientExam)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objDiagInfo.IsNew)
{
objDiagInfo.Save();
}
else
{
objDiagInfo.MarkOld();
objDiagInfo.Save();
}
SqlQuery sqlQuery = new Select().From(
KcbChandoanKetluan.Schema)
.Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
.And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).OrderAsc(
KcbChandoanKetluan.Columns.NgayChandoan);
KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>();
var query = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.Chandoan)
where (y != "")
select y).ToArray();
string cdchinh = string.Join(";", query);
//KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection<KcbChandoanKetluanCollection>();
var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.ChandoanKemtheo)
where (y != "")
select y).ToArray();
string cdphu = string.Join(";", querychandoanphu);
var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhchinh.MabenhChinh)
where (y != "")
select y).ToArray();
string mabenhchinh = string.Join(";", querybenhchinh);
var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhphu.MabenhPhu)
where (y != "")
select y).ToArray();
string mabenhphu = string.Join(";", querybenhphu);
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh)
.Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu)
.Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh)
.Set(KcbLuotkham.Columns.ChandoanKemtheo).EqualTo(cdphu)
.Set(KcbLuotkham.Columns.TrieuChung).EqualTo(objPatientExam.TrieuChung)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.Locked).EqualTo(objPatientExam.Locked)
.Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(objPatientExam.NguoiKetthuc)
.Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(objPatientExam.NgayKetthuc)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute();
//Tạm bỏ tránh việc bị cập nhật sai bác sĩ chỉ định nếu bác sĩ đó chỉ lưu thông tin kết luận
//SPs.KcbThamkhamCappnhatBsyKham(Utility.Int32Dbnull(objRegExam.IdKham, -1), objPatientExam.MaLuotkham,
// Utility.Int32Dbnull(objPatientExam.IdBenhnhan, -1),
// Utility.Int32Dbnull(objDiagInfo.DoctorId, -1)).Execute();
if (objRegExam != null)
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.NguoiSua).EqualTo(globalVariables.UserName)
//.Set(KcbDangkyKcb.Columns.IpMacSua).EqualTo(BusinessHelper.GetMACAddress())
//.Set(KcbDangkyKcb.Columns.IpMaySua).EqualTo(BusinessHelper.GetIP4Address())
.Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objDiagInfo.IdBacsikham)
.Set(KcbDangkyKcb.Columns.TrangThai).EqualTo(objRegExam.TrangThai)
.Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(Utility.Int32Dbnull(objRegExam.IdKham, -1)).
Execute();
}
}
scope.Complete();
// Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1);
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception);
return(ActionResult.Error);
}
}
public ActionResult CapnhatChandoan(KcbChandoanKetluan objKcbChandoanKetluan)
{
try
{
if (objKcbChandoanKetluan == null)
{
return(ActionResult.Cancel);
}
using (TransactionScope scope = new TransactionScope())
{
using (SharedDbConnectionScope sh = new SharedDbConnectionScope())
{
if (objKcbChandoanKetluan.IsNew)
{
objKcbChandoanKetluan.Save();
}
else
{
objKcbChandoanKetluan.MarkOld();
objKcbChandoanKetluan.Save();
}
SqlQuery sqlQuery = new Select().From(KcbChandoanKetluan.Schema)
.Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objKcbChandoanKetluan.MaLuotkham)
.And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objKcbChandoanKetluan.IdBenhnhan).OrderAsc(
KcbChandoanKetluan.Columns.NgayChandoan);
KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>();
var query = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.Chandoan)
where (y != "")
select y).ToArray();
string cdchinh = string.Join(";", query);
var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.ChandoanKemtheo)
where (y != "")
select y).ToArray();
string cdphu = string.Join(";", querychandoanphu);
var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhchinh.MabenhChinh)
where (y != "")
select y).ToArray();
string mabenhchinh = string.Join(";", querybenhchinh);
var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhphu.MabenhPhu)
where (y != "")
select y).ToArray();
string mabenhphu = string.Join(";", querybenhphu);
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh)
.Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu)
.Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChandoanKetluan.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objKcbChandoanKetluan.IdBenhnhan).Execute();
}
scope.Complete();
// Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1);
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception);
return(ActionResult.Error);
}
}
/// <summary>
/// hàm thực hiện việc update thông tin xác nhận gói
/// </summary>
/// <param name="objThongtinGoiDvuBnhan"></param>
/// <returns></returns>
public ActionResult UpdateExamInfo(KcbChandoanKetluan objDiagInfo, KcbDangkyKcb objRegExam,
KcbLuotkham objPatientExam)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objDiagInfo != null)
{
log.Trace("1.1 Bat dau ket thuc benh nhan: " + objDiagInfo.MaLuotkham);
if (objDiagInfo.IsNew)
{
// objDiagInfo.Save();
SPs.SpKcbThemmoiChandoanKetluan(objDiagInfo.IdChandoan, objDiagInfo.IdKham,
objDiagInfo.IdBenhnhan,
objDiagInfo.MaLuotkham, objDiagInfo.IdBacsikham, objDiagInfo.NgayChandoan,
objDiagInfo.NguoiTao,
objDiagInfo.NgayTao, objDiagInfo.IdKhoanoitru, objDiagInfo.IdBuonggiuong,
objDiagInfo.IdBuong, objDiagInfo.IdGiuong
, objDiagInfo.IdPhieudieutri, objDiagInfo.Noitru, objDiagInfo.IdPhongkham,
objDiagInfo.TenPhongkham, objDiagInfo.Mach, objDiagInfo.Nhietdo, objDiagInfo.Huyetap
, objDiagInfo.Nhiptim, objDiagInfo.Nhiptho, objDiagInfo.Cannang,
objDiagInfo.Chieucao, objDiagInfo.Nhommau, objDiagInfo.Ketluan, objDiagInfo.ChedoDinhduong,
objDiagInfo.HuongDieutri, objDiagInfo.SongayDieutri, objDiagInfo.TrieuchungBandau
, objDiagInfo.Chandoan, objDiagInfo.ChandoanKemtheo, objDiagInfo.MabenhChinh,
objDiagInfo.MabenhPhu, objDiagInfo.MotaBenhchinh, objDiagInfo.IpMaytao, objDiagInfo.TenMaytao,
objDiagInfo.PhanungSautiemchung, objDiagInfo.KPL1
, objDiagInfo.KPL2, objDiagInfo.KPL3, objDiagInfo.KPL4, objDiagInfo.KPL5,
objDiagInfo.KPL6, objDiagInfo.KPL7, objDiagInfo.KPL8, objDiagInfo.KL1,
objDiagInfo.KL2, objDiagInfo.KL3, objDiagInfo.KetluanNguyennhan, objDiagInfo.NhanXet
, objDiagInfo.ChongchidinhKhac, objDiagInfo.SoNgayhen, objDiagInfo.ChisoIbm, objDiagInfo.ThilucMp, objDiagInfo.ThilucMt, objDiagInfo.NhanapMp, objDiagInfo.NhanapMt
).Execute();
}
else
{
SPs.SpKcbCapnhatChandoanKetluan(objDiagInfo.IdChandoan, objDiagInfo.IdBacsikham,
objDiagInfo.NgayChandoan, objDiagInfo.NguoiSua, objDiagInfo.NgaySua,
objDiagInfo.IdPhieudieutri
, objDiagInfo.Noitru, objDiagInfo.IdPhongkham, objDiagInfo.TenPhongkham,
objDiagInfo.Mach, objDiagInfo.Nhietdo, objDiagInfo.Huyetap, objDiagInfo.Nhiptim,
objDiagInfo.Nhiptho, objDiagInfo.Cannang, objDiagInfo.Chieucao
, objDiagInfo.Nhommau, objDiagInfo.Ketluan, objDiagInfo.ChedoDinhduong, objDiagInfo.HuongDieutri,
objDiagInfo.SongayDieutri, objDiagInfo.TrieuchungBandau, objDiagInfo.Chandoan,
objDiagInfo.ChandoanKemtheo, objDiagInfo.MabenhChinh
, objDiagInfo.MabenhPhu, objDiagInfo.MotaBenhchinh, objDiagInfo.IpMaysua, objDiagInfo.TenMaysua,
objDiagInfo.PhanungSautiemchung, objDiagInfo.KPL1
, objDiagInfo.KPL2, objDiagInfo.KPL3, objDiagInfo.KPL4, objDiagInfo.KPL5,
objDiagInfo.KPL6, objDiagInfo.KPL7, objDiagInfo.KPL8, objDiagInfo.KL1,
objDiagInfo.KL2, objDiagInfo.KL3, objDiagInfo.KetluanNguyennhan, objDiagInfo.NhanXet,
objDiagInfo.ChongchidinhKhac, objDiagInfo.SoNgayhen, objDiagInfo.ChisoIbm, objDiagInfo.ThilucMp, objDiagInfo.ThilucMt, objDiagInfo.NhanapMp, objDiagInfo.NhanapMt).Execute();
}
}
log.Trace("1.2 Luu xong chan doan cua benh nhan: " + objDiagInfo.MaLuotkham);
SqlQuery sqlQuery = new Select().From(
KcbChandoanKetluan.Schema)
.Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
.And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan)
.And(KcbChandoanKetluan.Columns.IdKham).IsEqualTo(objRegExam.IdKham).OrderAsc(
KcbChandoanKetluan.Columns.NgayChandoan);
KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>();
var query = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.Chandoan)
where (y != "")
select y).ToArray();
string cdchinh = string.Join(";", query);
//KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection<KcbChandoanKetluanCollection>();
var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(chandoan.ChandoanKemtheo)
where (y != "")
select y).ToArray();
string cdphu = string.Join(";", querychandoanphu);
var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhchinh.MabenhChinh)
where (y != "")
select y).ToArray();
string mabenhchinh = string.Join(";", querybenhchinh);
var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable()
let y = Utility.sDbnull(benhphu.MabenhPhu)
where (y != "")
select y).ToArray();
string mabenhphu = string.Join(";", querybenhphu);
SPs.KcbLuotkhamTrangthaiketthuckham(objPatientExam.IdBenhnhan,
objPatientExam.MaLuotkham, objPatientExam.TrangthaiNgoaitru, objPatientExam.Noitru,
mabenhchinh, mabenhphu, objPatientExam.KetLuan, objPatientExam.HuongDieutri, cdchinh
, cdphu, objPatientExam.Locked, objPatientExam.SongayDieutri, objPatientExam.TrieuChung,
globalVariables.UserName, globalVariables.SysDate, globalVariables.gv_strIPAddress,
globalVariables.gv_strComputerName, objDiagInfo.IdBacsikham, objRegExam.TrangThai,
objRegExam.IdKham).Execute();
log.Trace("1.3 Update thanh cong trang thai cua benh nhan: " + objDiagInfo.MaLuotkham);
//new Update(KcbLuotkham.Schema)
// .Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh)
// .Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu)
// .Set(KcbLuotkham.Columns.KetLuan).EqualTo(objPatientExam.KetLuan)
// .Set(KcbLuotkham.Columns.HuongDieutri).EqualTo(objPatientExam.HuongDieutri)
// .Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh)
// .Set(KcbLuotkham.Columns.SongayDieutri).EqualTo(objPatientExam.SongayDieutri)
// .Set(KcbLuotkham.Columns.ChandoanKemtheo).EqualTo(cdphu)
// .Set(KcbLuotkham.Columns.TrieuChung).EqualTo(objPatientExam.TrieuChung)
// .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
// .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
// .Set(KcbLuotkham.Columns.Locked).EqualTo(objPatientExam.Locked)
// .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(objPatientExam.NguoiKetthuc)
// .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(objPatientExam.NgayKetthuc)
// .Set(KcbLuotkham.Columns.TrangthaiNgoaitru).EqualTo(objPatientExam.TrangthaiNgoaitru)
// .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
// .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute();
////Tạm bỏ tránh việc bị cập nhật sai bác sĩ chỉ định nếu bác sĩ đó chỉ lưu thông tin kết luận
////SPs.KcbThamkhamCappnhatBsyKham(Utility.Int32Dbnull(objRegExam.IdKham, -1), objPatientExam.MaLuotkham,
//// Utility.Int32Dbnull(objPatientExam.IdBenhnhan, -1),
//// Utility.Int32Dbnull(objDiagInfo.DoctorId, -1)).Execute();
//if (objRegExam != null)
//{
// new Update(KcbDangkyKcb.Schema)
// .Set(KcbDangkyKcb.Columns.NgaySua).EqualTo(globalVariables.SysDate)
// .Set(KcbDangkyKcb.Columns.NguoiSua).EqualTo(globalVariables.UserName)
// .Set(KcbDangkyKcb.Columns.IpMaysua).EqualTo(globalVariables.gv_strIPAddress)
// .Set(KcbDangkyKcb.Columns.TenMaysua).EqualTo(globalVariables.gv_strComputerName)
// .Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objDiagInfo.IdBacsikham)
// .Set(KcbDangkyKcb.Columns.TrangThai).EqualTo(objRegExam.TrangThai)
// .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(Utility.Int32Dbnull(objRegExam.IdKham, -1)).
// Execute();
//}
sh.Dispose();
}
scope.Complete();
// Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1);
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.Error("Loi trong qua trinh ket thuc benh nhan", exception);
return(ActionResult.Error);
}
}
