public void Update(long IdChandoan, long IdKham, long IdBenhnhan, string MaLuotkham, short IdBacsikham, DateTime NgayChandoan, string NguoiTao, DateTime NgayTao, string NguoiSua, DateTime?NgaySua, int?IdKhoanoitru, long?IdBuonggiuong, short?IdBuong, short?IdGiuong, long?IdPhieudieutri, byte Noitru, int?IdPhongkham, string TenPhongkham, string Mach, string Nhietdo, string Huyetap, string Nhiptim, string Nhiptho, string Cannang, string Chieucao, string Nhommau, string Ketluan, string HuongDieutri, short?SongayDieutri, short?SoNgayhen, string TrieuchungBandau, string Chandoan, string ChandoanKemtheo, string MabenhChinh, string MabenhPhu, string IpMaytao, string IpMaysua, string TenMaytao, string TenMaysua, string PhanungSautiemchung, byte?KPL1, byte?KPL2, byte?KPL3, byte?KPL4, byte?KPL5, byte?KPL6, byte?KPL7, byte?KPL8, byte?KL1, byte?KL2, byte?KL3, string KetluanNguyennhan, string NhanXet, string ChongchidinhKhac, string ChedoDinhduong, string MotaBenhchinh, decimal?ChisoIbm, string NhanapMp, string NhanapMt, string ThilucMp, string ThilucMt)
{
KcbChandoanKetluan item = new KcbChandoanKetluan();
item.MarkOld();
item.IsLoaded = true;
item.IdChandoan = IdChandoan;
item.IdKham = IdKham;
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.IdBacsikham = IdBacsikham;
item.NgayChandoan = NgayChandoan;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.IdKhoanoitru = IdKhoanoitru;
item.IdBuonggiuong = IdBuonggiuong;
item.IdBuong = IdBuong;
item.IdGiuong = IdGiuong;
item.IdPhieudieutri = IdPhieudieutri;
item.Noitru = Noitru;
item.IdPhongkham = IdPhongkham;
item.TenPhongkham = TenPhongkham;
item.Mach = Mach;
item.Nhietdo = Nhietdo;
item.Huyetap = Huyetap;
item.Nhiptim = Nhiptim;
item.Nhiptho = Nhiptho;
item.Cannang = Cannang;
item.Chieucao = Chieucao;
item.Nhommau = Nhommau;
item.Ketluan = Ketluan;
item.HuongDieutri = HuongDieutri;
item.SongayDieutri = SongayDieutri;
item.SoNgayhen = SoNgayhen;
item.TrieuchungBandau = TrieuchungBandau;
item.Chandoan = Chandoan;
item.ChandoanKemtheo = ChandoanKemtheo;
item.MabenhChinh = MabenhChinh;
item.MabenhPhu = MabenhPhu;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.PhanungSautiemchung = PhanungSautiemchung;
item.KPL1 = KPL1;
item.KPL2 = KPL2;
item.KPL3 = KPL3;
item.KPL4 = KPL4;
item.KPL5 = KPL5;
item.KPL6 = KPL6;
item.KPL7 = KPL7;
item.KPL8 = KPL8;
item.KL1 = KL1;
item.KL2 = KL2;
item.KL3 = KL3;
item.KetluanNguyennhan = KetluanNguyennhan;
item.NhanXet = NhanXet;
item.ChongchidinhKhac = ChongchidinhKhac;
item.ChedoDinhduong = ChedoDinhduong;
item.MotaBenhchinh = MotaBenhchinh;
item.ChisoIbm = ChisoIbm;
item.NhanapMp = NhanapMp;
item.NhanapMt = NhanapMt;
item.ThilucMp = ThilucMp;
item.ThilucMt = ThilucMt;
item.Save(UserName);
}
/// <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.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();
}
}
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;
}
}
public void Update(long IdChandoan,long IdKham,long IdBenhnhan,string MaLuotkham,short IdBacsikham,DateTime NgayChandoan,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,int? IdKhoanoitru,int? IdBuongGiuong,short? IdBuongNoitru,short? IdGiuongNoitru,int? IdPhieudieutri,byte? Noitru,int? IdPhongkham,string TenPhongkham,string Mach,string Nhietdo,string Huyetap,string Nhiptim,string Nhiptho,string Cannang,string Chieucao,string Nhommau,string Ketluan,string HuongDieutri,short? SongayDieutri,string TrieuchungBandau,string Chandoan,string ChandoanKemtheo,string MabenhChinh,string MabenhPhu,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua)
{
KcbChandoanKetluan item = new KcbChandoanKetluan();
item.MarkOld();
item.IsLoaded = true;
item.IdChandoan = IdChandoan;
item.IdKham = IdKham;
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.IdBacsikham = IdBacsikham;
item.NgayChandoan = NgayChandoan;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.IdKhoanoitru = IdKhoanoitru;
item.IdBuongGiuong = IdBuongGiuong;
item.IdBuongNoitru = IdBuongNoitru;
item.IdGiuongNoitru = IdGiuongNoitru;
item.IdPhieudieutri = IdPhieudieutri;
item.Noitru = Noitru;
item.IdPhongkham = IdPhongkham;
item.TenPhongkham = TenPhongkham;
item.Mach = Mach;
item.Nhietdo = Nhietdo;
item.Huyetap = Huyetap;
item.Nhiptim = Nhiptim;
item.Nhiptho = Nhiptho;
item.Cannang = Cannang;
item.Chieucao = Chieucao;
item.Nhommau = Nhommau;
item.Ketluan = Ketluan;
item.HuongDieutri = HuongDieutri;
item.SongayDieutri = SongayDieutri;
item.TrieuchungBandau = TrieuchungBandau;
item.Chandoan = Chandoan;
item.ChandoanKemtheo = ChandoanKemtheo;
item.MabenhChinh = MabenhChinh;
item.MabenhPhu = MabenhPhu;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.Save(UserName);
}
public ActionResult LuuHoibenhvaChandoan(KcbChandoanKetluan objDiagInfo)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objDiagInfo.IsNew)
{
objDiagInfo.Save();
}
else
{
objDiagInfo.MarkOld();
objDiagInfo.Save();
}
}
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;
}
}
void cmdGhichandoan_Click(object sender, EventArgs e)
{
try
{
if (!isValidChandoan()) return;
KcbChandoanKetluan objKcbChandoanKetluan = new KcbChandoanKetluan();
if (m_enActChandoan == action.Update)
{
objKcbChandoanKetluan = KcbChandoanKetluan.FetchByID(Utility.Int32Dbnull(txtIdChandoan.Text, -1));
objKcbChandoanKetluan.MarkOld();
objKcbChandoanKetluan.IsNew = false;
}
else
{
objKcbChandoanKetluan = new KcbChandoanKetluan();
objKcbChandoanKetluan.IsNew = true;
}
objKcbChandoanKetluan.MaLuotkham = objLuotkham.MaLuotkham;
objKcbChandoanKetluan.IdBenhnhan = objLuotkham.IdBenhnhan;
objKcbChandoanKetluan.MabenhChinh = Utility.sDbnull(txtMaBenhChinh.Text, "");
objKcbChandoanKetluan.Nhommau = txtNhommau.Text;
objKcbChandoanKetluan.Nhietdo = Utility.sDbnull(txtNhietDo.Text);
objKcbChandoanKetluan.Huyetap = txtHa.Text;
objKcbChandoanKetluan.Mach = txtMach.Text;
objKcbChandoanKetluan.Nhiptim = Utility.sDbnull(txtNhipTim.Text);
objKcbChandoanKetluan.Nhiptho = Utility.sDbnull(txtNhipTho.Text);
objKcbChandoanKetluan.Chieucao = Utility.sDbnull(txtChieucao.Text);
objKcbChandoanKetluan.Cannang = Utility.sDbnull(txtCannang.Text);
objKcbChandoanKetluan.HuongDieutri = "";
objKcbChandoanKetluan.SongayDieutri = 0;
if (cboBSDieutri.SelectedIndex > 0)
objKcbChandoanKetluan.IdBacsikham = Utility.Int16Dbnull(cboBSDieutri.SelectedValue, -1);
else
{
objKcbChandoanKetluan.IdBacsikham = globalVariables.gv_intIDNhanvien;
}
string sMaICDPHU = GetDanhsachBenhphu();
objKcbChandoanKetluan.MabenhPhu = Utility.sDbnull(sMaICDPHU.ToString(), "");
objKcbChandoanKetluan.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objKcbChandoanKetluan.IdBuongNoitru = objLuotkham.IdBuong;
objKcbChandoanKetluan.IdGiuongNoitru = objLuotkham.IdGiuong;
objKcbChandoanKetluan.IdBuongGiuong = objLuotkham.IdRavien;
objKcbChandoanKetluan.IdKham = objPhieudieutri == null ? -1 : objPhieudieutri.IdPhieudieutri;
objKcbChandoanKetluan.NgayTao = dtpCreatedDate.Value;
objKcbChandoanKetluan.NguoiTao = globalVariables.UserName;
objKcbChandoanKetluan.NgayChandoan = dtpNgaychandoan.Value;
objKcbChandoanKetluan.Ketluan = "";
objKcbChandoanKetluan.Chandoan = Utility.ReplaceString(txtChanDoan.Text);
objKcbChandoanKetluan.ChandoanKemtheo = Utility.sDbnull(txtChanDoanKemTheo.Text);
objKcbChandoanKetluan.IdPhieudieutri = objPhieudieutri == null ? -1 : objPhieudieutri.IdPhieudieutri;
objKcbChandoanKetluan.Noitru = 1;
objKcbChandoanKetluan.Save();
DataRow[] arrDr = m_dtChandoanKCB.Select(KcbChandoanKetluan.Columns.IdChandoan + "=" + objKcbChandoanKetluan.IdChandoan.ToString());
if (arrDr.Length > 0)
{
Utility.FromObjectToDatarow(objKcbChandoanKetluan, ref arrDr[0]);
arrDr[0]["sNgay_chandoan"] = dtpNgaychandoan.Text;
Utility.GotoNewRowJanus(grdChandoan, KcbChandoanKetluan.Columns.IdChandoan, objKcbChandoanKetluan.IdChandoan.ToString());
m_dtChandoanKCB.AcceptChanges();
}
else
{
DataRow newDr = m_dtChandoanKCB.NewRow();
Utility.FromObjectToDatarow(objKcbChandoanKetluan, ref newDr);
newDr["sNgay_chandoan"] = dtpNgaychandoan.Text;
m_dtChandoanKCB.Rows.Add(newDr);
m_dtChandoanKCB.AcceptChanges();
Utility.GotoNewRowJanus(grdChandoan, KcbChandoanKetluan.Columns.IdChandoan, objKcbChandoanKetluan.IdChandoan.ToString());
}
EnableChandoan(false);
cmdGhichandoan.Enabled = cmdHuychandoan.Enabled = false;
ModifyCommmands();
grdChandoan_SelectionChanged(grdChandoan, e);
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
public ActionResult LuuHoibenhvaChandoan(KcbChandoanKetluan objDiagInfo,KcbDonthuocChitiet objChitiet,bool Luudulieutiemchung)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objChitiet != null)
{
objChitiet.IsNew = false;
if (objDiagInfo != null)
{
objChitiet.PhanungSautiem = objDiagInfo.PhanungSautiemchung;
objChitiet.Xutri = objDiagInfo.HuongDieutri;
objChitiet.KetQua = objDiagInfo.Ketluan;
objChitiet.KetluanNguyennhan = objDiagInfo.KetluanNguyennhan;
}
objChitiet.MarkOld();
objChitiet.Save();
}
if (objDiagInfo != null)
{
if (objDiagInfo.IsNew)
{
objDiagInfo.Save();
}
else
{
objDiagInfo.MarkOld();
objDiagInfo.Save();
}
if (Luudulieutiemchung && objChitiet == null)
{
new Update(KcbDonthuocChitiet.Schema)
.Set(KcbDonthuocChitiet.Columns.PhanungSautiem).EqualTo(objDiagInfo.PhanungSautiemchung)
.Set(KcbDonthuocChitiet.Columns.Xutri).EqualTo(objDiagInfo.HuongDieutri)
.Set(KcbDonthuocChitiet.Columns.KetQua).EqualTo(objDiagInfo.Ketluan)
.Set(KcbDonthuocChitiet.Columns.KetluanNguyennhan).EqualTo(objDiagInfo.KetluanNguyennhan)
.Where(KcbDonthuocChitiet.Columns.IdKham).IsEqualTo(objDiagInfo.IdKham)
.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.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);
}
}
public void Update(long IdChandoan,long IdKham,long IdBenhnhan,string MaLuotkham,short IdBacsikham,DateTime NgayChandoan,string NguoiTao,DateTime NgayTao,string NguoiSua,DateTime? NgaySua,int? IdKhoanoitru,long? IdBuonggiuong,short? IdBuong,short? IdGiuong,long? IdPhieudieutri,byte Noitru,int? IdPhongkham,string TenPhongkham,string Mach,string Nhietdo,string Huyetap,string Nhiptim,string Nhiptho,string Cannang,string Chieucao,string Nhommau,string Ketluan,string HuongDieutri,short? SongayDieutri,string TrieuchungBandau,string Chandoan,string ChandoanKemtheo,string MabenhChinh,string MabenhPhu,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua,string PhanungSautiemchung,byte? KPL1,byte? KPL2,byte? KPL3,byte? KPL4,byte? KPL5,byte? KPL6,byte? KPL7,byte? KPL8,byte? KL1,byte? KL2,byte? KL3,string KetluanNguyennhan,string NhanXet,string ChongchidinhKhac)
{
KcbChandoanKetluan item = new KcbChandoanKetluan();
item.MarkOld();
item.IsLoaded = true;
item.IdChandoan = IdChandoan;
item.IdKham = IdKham;
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.IdBacsikham = IdBacsikham;
item.NgayChandoan = NgayChandoan;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.IdKhoanoitru = IdKhoanoitru;
item.IdBuonggiuong = IdBuonggiuong;
item.IdBuong = IdBuong;
item.IdGiuong = IdGiuong;
item.IdPhieudieutri = IdPhieudieutri;
item.Noitru = Noitru;
item.IdPhongkham = IdPhongkham;
item.TenPhongkham = TenPhongkham;
item.Mach = Mach;
item.Nhietdo = Nhietdo;
item.Huyetap = Huyetap;
item.Nhiptim = Nhiptim;
item.Nhiptho = Nhiptho;
item.Cannang = Cannang;
item.Chieucao = Chieucao;
item.Nhommau = Nhommau;
item.Ketluan = Ketluan;
item.HuongDieutri = HuongDieutri;
item.SongayDieutri = SongayDieutri;
item.TrieuchungBandau = TrieuchungBandau;
item.Chandoan = Chandoan;
item.ChandoanKemtheo = ChandoanKemtheo;
item.MabenhChinh = MabenhChinh;
item.MabenhPhu = MabenhPhu;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.PhanungSautiemchung = PhanungSautiemchung;
item.KPL1 = KPL1;
item.KPL2 = KPL2;
item.KPL3 = KPL3;
item.KPL4 = KPL4;
item.KPL5 = KPL5;
item.KPL6 = KPL6;
item.KPL7 = KPL7;
item.KPL8 = KPL8;
item.KL1 = KL1;
item.KL2 = KL2;
item.KL3 = KL3;
item.KetluanNguyennhan = KetluanNguyennhan;
item.NhanXet = NhanXet;
item.ChongchidinhKhac = ChongchidinhKhac;
item.Save(UserName);
}