private void cmdSuaChiDinh_Click(object sender, EventArgs e)
{
KnDangkyXn patientExam = CreatePatientExam();
if (patientExam != null)
{
if (!InValiUpdateChiDinh())
{
return;
}
var frm = new frm_Chidinh_Maukiemnghiem("MAUKIEMNGHIEM", 3);
frm.HosStatus = 0;
frm.Exam_ID = Utility.Int32Dbnull(-1, -1);
frm.objLuotkham = CreatePatientExam();
frm.m_eAction = action.Update;
frm.txtAssign_ID.Text = Utility.sDbnull(grdDetail.GetValue(KnChidinhChitiet.Columns.IdChidinh), "-1");
frm.ShowDialog();
if (!frm.m_blnCancel)
{
// LoadChiDinhCLS();
LoadChiDinh();
UpdateSumOfChiDinh();
}
ModifycommandAssignDetail();
}
ModifyCommand();
}
private void cmdThemChiDinh_Click(object sender, EventArgs e)
{
KnDangkyXn patientExam = CreatePatientExam();
if (patientExam != null)
{
var frm = new frm_Chidinh_Maukiemnghiem("MAUKIEMNGHIEM", 3);
frm.Exam_ID = Utility.Int32Dbnull(-1, -1);
frm.txtAssign_ID.Text = @"-100";
frm.objLuotkham = patientExam;
frm.m_eAction = action.Insert;
frm.HosStatus = 0;
frm.ShowDialog();
if (!frm.m_blnCancel)
{
LoadChiDinh();
UpdateSumOfChiDinh();
}
ModifycommandAssignDetail();
}
ModifyCommand();
}
public ActionResult UpdateDataChiDinhKiemNghiem(KnChidinhXn objChidinh, KnDangkyXn objLuotkham, KnChidinhChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
log.Trace("BEGIN UPDATE.................................................................");
if (objLuotkham == null)
{
objLuotkham = new Select().From(KnDangkyXn.Schema)
.Where(KnDangkyXn.Columns.MaDangky).IsEqualTo(objChidinh.MaDangky)
.And(KnDangkyXn.Columns.IdKhachhang).IsEqualTo(
Utility.Int32Dbnull(objChidinh.IdKhachhang)).ExecuteSingle <KnDangkyXn>();
}
objChidinh.NgaySua = globalVariables.SysDate;
objChidinh.NguoiSua = globalVariables.UserName;
objChidinh.MarkOld();
objChidinh.Save();
//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);
foreach (var knChidinhChitiet in arrAssignDetails)
{
if (knChidinhChitiet.IdChidinhChitiet <= 0)
{
knChidinhChitiet.NgayTao = globalVariables.SysDate;
knChidinhChitiet.NguoiTao = globalVariables.UserName;
knChidinhChitiet.IsNew = true;
knChidinhChitiet.Save();
}
else
{
knChidinhChitiet.NgaySua = globalVariables.SysDate;
knChidinhChitiet.NguoiSua = globalVariables.UserName;
knChidinhChitiet.MarkOld();
knChidinhChitiet.Save();
}
}
// 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 InsertDataChiDinhKn(KnChidinhXn objChidinh, KnDangkyXn objLuotkham, KnChidinhChitiet[] 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(KnDangkyXn.Schema)
.Where(KnDangkyXn.Columns.MaDangky).IsEqualTo(objChidinh.MaDangky)
.And(KnDangkyXn.Columns.IdKhachhang).IsEqualTo(
Utility.Int32Dbnull(objChidinh.IdKhachhang)).ExecuteSingle <KnDangkyXn>();
}
if (objLuotkham != null)
{
log.Trace("0.1. Bat dau sinh code");
objChidinh.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhKiemNghiem();
log.Trace("0.2. Bat dau them moi chi dinh CLS");
objChidinh.NgayTao = globalVariables.SysDate;
objChidinh.NguoiTao = globalVariables.UserName;
objChidinh.IsNew = true;
objChidinh.Save();
log.Trace("0.3 Da thuc hien xong cau SP");
log.Trace("1. Da them moi chi dinh CLS");
foreach (var knChidinhChitiet in arrAssignDetails)
{
if (knChidinhChitiet.IdChidinhChitiet <= 0)
{
log.Info("1.2 Bat dau them moi Id_chidinh=" + objChidinh.IdChidinh + "timeprocess in : " + globalVariables.SysDate.ToString());
var sp =
SPs.KnThemmoiChitietChidinh(knChidinhChitiet.IdChidinhChitiet,
objChidinh.IdChidinh, objChidinh.MaChidinh,
knChidinhChitiet.IdDichvu
, knChidinhChitiet.IdChitietdichvu, knChidinhChitiet.DonGia,
knChidinhChitiet.PhuThu, knChidinhChitiet.SoLuong,
knChidinhChitiet.Donvi, knChidinhChitiet.PpKiemnghiem,
knChidinhChitiet.Qcvn,
knChidinhChitiet.ThanhTien, knChidinhChitiet.NgayNhapmau,
knChidinhChitiet.Ketqua, knChidinhChitiet.NgaynhapKetqua,
knChidinhChitiet.NguoinhapKq, knChidinhChitiet.TrangthaiThanhtoan,
Utility.ByteDbnull(knChidinhChitiet.TrangThai),
knChidinhChitiet.ChitieuPhantich, knChidinhChitiet.MahoaMau,
knChidinhChitiet.NguoiTao, knChidinhChitiet.NgayTao,
knChidinhChitiet.NguoiSua, knChidinhChitiet.NgaySua,
knChidinhChitiet.IpMaytao, knChidinhChitiet.IpMaysua);
sp.Execute();
knChidinhChitiet.IdChidinhChitiet = Utility.Int64Dbnull(sp.OutputValues[0]);
knChidinhChitiet.MahoaMau = Utility.sDbnull(sp.OutputValues[1]);
log.Info("1.3 ket thuc them moi Id_chidinh=" + objChidinh.IdChidinh + "timeprocess out: " + globalVariables.SysDate.ToString());
}
}
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();
}
}
