public bool blnIsExisted(int ID, string code, int objectType_Id, int Department_Id, int ExamType_ID,
int Doctor_ID)
{
try
{
DmucDichvukcbCollection v_DmucDichvukcb =
new DmucDichvukcbController().FetchByQuery(
DmucDichvukcb.CreateQuery().AddWhere(DmucDichvukcb.Columns.MaDichvukcb,
Comparison.Equals, txtCode.Text.Trim()).AND(
DmucDichvukcb.Columns.IdPhongkham,
Comparison.Equals, Department_Id).AND(
DmucDichvukcb.Columns.IdDoituongKcb,
Comparison.Equals, objectType_Id).AND(
DmucDichvukcb.Columns.IdKieukham,
Comparison.Equals, ExamType_ID).AND(
DmucDichvukcb.Columns.IdBacsy,
Comparison.Equals, Doctor_ID).AND(
DmucDichvukcb.Columns.IdDichvukcb,
Comparison.NotEquals, ID));
return(v_DmucDichvukcb.Count > 0);
return(true);
}
catch (Exception)
{
return(false);
}
}
public static ActionResult ChuyenPhong(long IdKham,string LydoChuyen, DmucDichvukcb objDichvuKcb)
{
try
{
ActionResult _ActionResult = ActionResult.Success;
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham)
.Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb)
.Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham)
.Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb)
.Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName)
.Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen)
.Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1)
.Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham)
.Execute();
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n"+ex.Message);
return ActionResult.Exception;
}
}
public static ActionResult ChuyenPhong(long IdKham, string LydoChuyen, DmucDichvukcb objDichvuKcb)
{
try
{
ActionResult _ActionResult = ActionResult.Success;
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham)
.Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb)
.Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham)
.Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb)
.Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName)
.Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen)
.Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1)
.Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham)
.Execute();
}
Scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message);
return(ActionResult.Exception);
}
}
public static ActionResult ChuyenPhong(long idKham, string lydoChuyen, DmucDichvukcb objDichvuKcb)
{
try
{
ActionResult actionResult = ActionResult.Success;
using (var scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
int sttkham = THU_VIEN_CHUNG.LaySothutuKCB(objDichvuKcb.IdPhongkham);
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham)
.Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(-1)
.Set(KcbDangkyKcb.Columns.SttKham).EqualTo(sttkham)
.Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb)
.Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham)
.Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb.ToUpper())
.Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName)
.Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate)
.Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(lydoChuyen)
.Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1)
.Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(idKham)
.Execute();
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message);
return(ActionResult.Exception);
}
}
/// <summary>
/// lấy thông tin của khi load sửa thông tin của Form
/// </summary>
private void GetData()
{
try
{
DmucDichvukcb Obj = DmucDichvukcb.FetchByID(Utility.Int32Dbnull(txtInsObject_ID.Text, -1));
if (Obj != null)
{
Id = Obj.IdDichvukcb;
cboDepartment1.SelectedIndex = Utility.GetSelectedIndex(cboDepartment1,
Obj.IdKhoaphong.ToString());
//cboDepartment1_SelectedIndexChanged(cboDepartment1, new EventArgs());
BindRoomDept(Obj.IdKhoaphong);
cboRoomDept.SelectedValue = Utility.Int32Dbnull(Obj.IdPhongkham);
//cboRoomDept.SelectedIndex = Utility.GetSelectedIndex(cboRoomDept,
// Obj.IdPhongkham.ToString());
//cboRoomDept_SelectedIndexChanged(cboRoomDept, new EventArgs());
BindStaffList(Obj.IdKhoaphong);
cboBacSy.SelectedValue = Utility.Int32Dbnull(Obj.IdBacsy);
//cboBacSy.SelectedIndex = Utility.GetSelectedIndex(cboBacSy,
// Obj.IdBacsy.
// ToString());
cboLoaiKham.SelectedIndex = Utility.GetSelectedIndex(cboLoaiKham,
Obj.IdKieukham.
ToString());
cboDoituong.SelectedIndex = Utility.GetSelectedIndex(cboDoituong,
Obj.IdDoituongKcb.
ToString());
// cboRoomDept.SelectedIndex = Utility.GetSelectedIndex(cboRoomDept,Obj.IdPhongkham)
txtDongia.Text = Utility.DecimaltoDbnull(Obj.DonGia, 0).ToString();
txtGiangoaigio.Text = Utility.DecimaltoDbnull(Obj.DongiaNgoaigio, 0).ToString();
txtPhuthungoaigio.Text = Utility.DecimaltoDbnull(Obj.PhuthuNgoaigio, 0).ToString();
txtPTDT.Text = Utility.DecimaltoDbnull(Obj.PhuthuDungtuyen, 0).ToString();
txtPTTT.Text = Utility.DecimaltoDbnull(Obj.PhuthuTraituyen, 0).ToString();
chkTutuc.Checked = Utility.Byte2Bool(Obj.TuTuc);
chkhoatdong.Checked = Utility.Byte2Bool(Obj.HoatDong);
txtmagiabhyt.Text = Utility.sDbnull(Obj.MaGia);
txtMaBhyt.Text = Utility.sDbnull(Obj.MaBhyt);
txtDesc.Text = Obj.MotaThem;
nmrSTT.Value = Utility.DecimaltoDbnull(Obj.SttHthi, 1);
txtCode.Text = Obj.MaDichvukcb;
txtName.Text = Obj.TenDichvukcb;
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi:" + ex.Message);
}
}
private void AutoLoadKieuKham()
{
try
{
if (Utility.Int32Dbnull(txtKieuKham.MyID, -1) == -1 || Utility.Int32Dbnull(txtPhongkham.MyID, -1) == -1)
{
_DmucDichvukcb = null;
return;
}
DataRow[] arrDr =
m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" +
txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=" + txtPhongkham.MyID.ToString().Trim());
//nếu ko có đích danh phòng thì lấy dịch vụ bất kỳ theo kiểu khám và đối tượng
if (arrDr.Length <= 0)
{
arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" +
txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=-1 ");
}
if (arrDr.Length <= 0)
{
_DmucDichvukcb = null;
return;
}
else
{
_DmucDichvukcb = new Select().From(DmucDichvukcb.Schema).Where(DmucDichvukcb.Columns.IdDichvukcb)
.IsEqualTo(arrDr[0][DmucDichvukcb.Columns.IdDichvukcb]).ExecuteSingle <DmucDichvukcb>();
return;
}
}
catch
{
_DmucDichvukcb = null;
}
finally
{
AutoLoad = false;
}
}
private static ActionResult CapnhatChiphiKCB(KcbLuotkham objLuotkham)
{
using (var Scope = new TransactionScope())
{
KcbDangkyKcbCollection objRegExamCollection =
new Select().From(KcbDangkyKcb.Schema).Where(KcbDangkyKcb.Columns.MaLuotkham).IsEqualTo(
objLuotkham.MaLuotkham).And(KcbDangkyKcb.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkyKcb.Columns.LaPhidichvukemtheo).IsEqualTo(0)
.ExecuteAsCollection <KcbDangkyKcbCollection>();
if (objRegExamCollection.Count > 0)
{
//CHUYỂN GIÁ KHÁM BỆNH VÀO PHÒNG
foreach (KcbDangkyKcb objRegExam in objRegExamCollection)
{
if (objRegExam.TrangthaiThanhtoan == 0)
{
DmucDichvukcb _DichvukcbCu =
DmucDichvukcb.FetchByID(objRegExam.IdDichvuKcb);
var _DichvukcbMoi =
new Select().From(DmucDichvukcb.Schema)
.Where(DmucDichvukcb.Columns.IdKhoaphong).IsEqualTo(_DichvukcbCu.IdKhoaphong)
.And(DmucDichvukcb.Columns.IdPhongkham).IsEqualTo(_DichvukcbCu.IdPhongkham)
.And(DmucDichvukcb.Columns.IdKieukham).IsEqualTo(_DichvukcbCu.IdKieukham)
.AndExpression(DmucDichvukcb.Columns.MaDoituongKcb).IsEqualTo(objLuotkham.MaDoituongKcb)
.Or(DmucDichvukcb.Columns.MaDoituongKcb).IsEqualTo("ALL").CloseExpression()
.ExecuteSingle <DmucDichvukcb>();
if (_DichvukcbMoi != null)
{
objRegExam.IdDichvuKcb = Utility.Int16Dbnull(_DichvukcbMoi.IdDichvukcb, -1);
if (Utility.Int32Dbnull(_DichvukcbMoi.TuTuc, 0) == 1)
{
objRegExam.TuTuc = 1; //Ke ca co trong bang quan he
}
if (objLuotkham.IdLoaidoituongKcb == 1) //Đối tượng dịch vụ-->ko cần phải đánh dấu tự túc
{
objRegExam.TuTuc = 0;
}
objRegExam.TenDichvuKcb = _DichvukcbMoi.TenDichvukcb;
objRegExam.DonGia = Utility.DecimaltoDbnull(_DichvukcbMoi.DonGia);
objRegExam.PhuThu = !Utility.Byte2Bool(objLuotkham.DungTuyen)
? Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuDungtuyen)
: Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuTraituyen);
objRegExam.PtramBhyt = objLuotkham.PtramBhyt;//% BHYT ngoại trú
if (Utility.Byte2Bool(objRegExam.KhamNgoaigio))
{
objRegExam.KhamNgoaigio = 1;
objRegExam.DonGia = Utility.DecimaltoDbnull(_DichvukcbMoi.DongiaNgoaigio, 0);
objRegExam.PhuThu = !Utility.Byte2Bool(objLuotkham.DungTuyen) ? Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuNgoaigio, 0) : Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuDungtuyen);
}
if (Utility.Int32Dbnull(objRegExam.TuTuc, 0) == 0)
{
objRegExam.BhytChitra = Utility.DecimaltoDbnull(objRegExam.DonGia) *
Utility.DecimaltoDbnull(objLuotkham.PtramBhyt) / 100;
objRegExam.BnhanChitra = Utility.DecimaltoDbnull(objRegExam.DonGia, 0) -
Utility.DecimaltoDbnull(objRegExam.BhytChitra, 0);
}
else
{
objRegExam.BhytChitra = 0;
objRegExam.BnhanChitra = Utility.DecimaltoDbnull(objRegExam.DonGia, 0);
}
}
}
else
{
return(ActionResult.Cancel);
}
}
objRegExamCollection.SaveAll();
}
Scope.Complete();
return(ActionResult.Success);
}
}
private void PerformActionInsert()
{
var objDmucDichvukcb = new DmucDichvukcb();
objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text, "");
objDmucDichvukcb.TenDichvukcb = Utility.sDbnull(txtName.Text, "");
objDmucDichvukcb.IdKieukham = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
objDmucDichvukcb.IdKhoaphong = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
objDmucDichvukcb.IdBacsy = Convert.ToInt16(cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1);
objDmucDichvukcb.MotaThem = Utility.DoTrim(txtDesc.Text);
objDmucDichvukcb.SttHthi = Utility.Int16Dbnull(nmrSTT.Value);
objDmucDichvukcb.IdDoituongKcb = Utility.Int16Dbnull(cboDoituong.SelectedValue, -1);
DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objDmucDichvukcb.IdDoituongKcb);
if (objectType != null)
objDmucDichvukcb.MaDoituongKcb = Utility.sDbnull(objectType.MaDoituongKcb, "");
else
objDmucDichvukcb.MaDoituongKcb = "ALL";
DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1));
if (objKieukham != null)
objDmucDichvukcb.NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, "");
else
objDmucDichvukcb.NhomBaocao = "-1";
objDmucDichvukcb.IdPhongkham = Utility.Int16Dbnull(cboRoomDept.SelectedValue);
objDmucDichvukcb.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
objDmucDichvukcb.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
objDmucDichvukcb.DonGia = Utility.DecimaltoDbnull(txtDongia.Text, 0);
objDmucDichvukcb.DongiaNgoaigio = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
objDmucDichvukcb.PhuthuNgoaigio = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
objDmucDichvukcb.TuTuc = Utility.Bool2byte(chkTutuc.Checked);
objDmucDichvukcb.IsNew = true;
objDmucDichvukcb.Save();
DataRow dr = m_dtDataRelation.NewRow();
dr[DmucDichvukcb.Columns.IdDichvukcb] = Utility.Int32Dbnull(
_Query.GetMax(DmucDichvukcb.Columns.IdDichvukcb), -1);
dr[DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue);
dr[DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1;
dr[DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
dr[DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
dr[DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text);
dr[DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1);
dr[DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked);
dr["ten_phong"] = cboRoomDept.Text;
dr[DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
dr[DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text;
dr[DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim();
dr[DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim();
dr["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text;
dr["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : "";
dr[DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng";
m_dtDataRelation.Rows.Add(dr);
//this.Close();
}
public void Insert(string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc,short? SttHthi,string MotaThem)
{
DmucDichvukcb item = new DmucDichvukcb();
item.MaDichvukcb = MaDichvukcb;
item.TenDichvukcb = TenDichvukcb;
item.IdKieukham = IdKieukham;
item.IdKhoaphong = IdKhoaphong;
item.IdBacsy = IdBacsy;
item.IdDoituongKcb = IdDoituongKcb;
item.IdPhongkham = IdPhongkham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.DongiaNgoaigio = DongiaNgoaigio;
item.PhuthuNgoaigio = PhuthuNgoaigio;
item.MaDoituongKcb = MaDoituongKcb;
item.IdPhikemtheo = IdPhikemtheo;
item.IdPhikemtheongoaigio = IdPhikemtheongoaigio;
item.NhomBaocao = NhomBaocao;
item.TuTuc = TuTuc;
item.SttHthi = SttHthi;
item.MotaThem = MotaThem;
item.Save(UserName);
}
private void AutoLoadKieuKham()
{
try
{
if (Utility.Int32Dbnull(txtKieuKham.MyID, -1) == -1 || Utility.Int32Dbnull(txtPhongkham.MyID, -1) == -1)
{
_DmucDichvukcb= null;
return;
}
//_DmucDichvukcb=new Select().From(DmucDichvukcb.Schema).
// Where(DmucDichvukcb.Columns.IdKieukham).IsEqualTo(Utility.Int32Dbnull(txtKieuKham.MyID, -1))
// .And(DmucDichvukcb.Columns.IdPhongkham).IsEqualTo(Utility.Int32Dbnull(txtPhongkham.MyID, -1))
// .And(DmucDichvukcb.Columns.DonGia).IsEqualTo(Utility.Int32Dbnull(txtPhongkham.MyID, -1))
DataRow[] arrDr =
m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" +
txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=" + txtPhongkham.MyID.ToString().Trim());
//nếu ko có đích danh phòng thì lấy dịch vụ bất kỳ theo kiểu khám và đối tượng
if (arrDr.Length <= 0)
arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" +
txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=-1 ");
if (arrDr.Length <= 0)
{
_DmucDichvukcb = null;
return ;
}
else
{
_DmucDichvukcb= new Select().From(DmucDichvukcb.Schema).Where(DmucDichvukcb.Columns.IdDichvukcb)
.IsEqualTo(arrDr[0][DmucDichvukcb.Columns.IdDichvukcb]).ExecuteSingle<DmucDichvukcb>();
return;
}
}
catch
{
_DmucDichvukcb= null;
}
finally
{
AutoLoad = false;
}
}
public void Update(int IdDichvukcb,string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc)
{
DmucDichvukcb item = new DmucDichvukcb();
item.MarkOld();
item.IsLoaded = true;
item.IdDichvukcb = IdDichvukcb;
item.MaDichvukcb = MaDichvukcb;
item.TenDichvukcb = TenDichvukcb;
item.IdKieukham = IdKieukham;
item.IdKhoaphong = IdKhoaphong;
item.IdBacsy = IdBacsy;
item.IdDoituongKcb = IdDoituongKcb;
item.IdPhongkham = IdPhongkham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.DongiaNgoaigio = DongiaNgoaigio;
item.PhuthuNgoaigio = PhuthuNgoaigio;
item.MaDoituongKcb = MaDoituongKcb;
item.IdPhikemtheo = IdPhikemtheo;
item.IdPhikemtheongoaigio = IdPhikemtheongoaigio;
item.NhomBaocao = NhomBaocao;
item.TuTuc = TuTuc;
item.Save(UserName);
}
private void PerformActionInsert()
{
var objDmucDichvukcb = new DmucDichvukcb();
objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text.Trim(), "");
objDmucDichvukcb.MaGia = Utility.sDbnull(txtmagiabhyt.Text.Trim(), "");
objDmucDichvukcb.HoatDong = chkhoatdong.Checked;
objDmucDichvukcb.TenDichvukcb = Utility.sDbnull(txtName.Text, "");
objDmucDichvukcb.IdKieukham = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
objDmucDichvukcb.IdKhoaphong = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
objDmucDichvukcb.IdBacsy = Convert.ToInt16(cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1);
objDmucDichvukcb.MotaThem = Utility.DoTrim(txtDesc.Text);
objDmucDichvukcb.SttHthi = Utility.Int16Dbnull(nmrSTT.Value);
objDmucDichvukcb.IdDoituongKcb = Utility.Int16Dbnull(cboDoituong.SelectedValue, -1);
DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objDmucDichvukcb.IdDoituongKcb);
if (objectType != null)
{
objDmucDichvukcb.MaDoituongKcb = Utility.sDbnull(objectType.MaDoituongKcb, "");
}
else
{
objDmucDichvukcb.MaDoituongKcb = "ALL";
}
DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1));
if (objKieukham != null)
{
objDmucDichvukcb.NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, "");
}
else
{
objDmucDichvukcb.NhomBaocao = "-1";
}
objDmucDichvukcb.IdPhongkham = Utility.Int16Dbnull(cboRoomDept.SelectedValue);
objDmucDichvukcb.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
objDmucDichvukcb.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
objDmucDichvukcb.DonGia = Utility.DecimaltoDbnull(txtDongia.Text, 0);
objDmucDichvukcb.DongiaNgoaigio = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
objDmucDichvukcb.PhuthuNgoaigio = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
objDmucDichvukcb.TuTuc = Utility.Bool2byte(chkTutuc.Checked);
objDmucDichvukcb.MaBhyt = Utility.sDbnull(txtMaBhyt.Text.Trim(), "");
objDmucDichvukcb.IsNew = true;
objDmucDichvukcb.Save();
DataRow dr = m_dtDataRelation.NewRow();
dr[DmucDichvukcb.Columns.IdDichvukcb] = Utility.Int32Dbnull(
_Query.GetMax(DmucDichvukcb.Columns.IdDichvukcb), -1);
dr[DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue);
dr[DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1;
dr[DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
dr[DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
dr[DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text);
dr[DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1);
dr[DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked);
dr[DmucDichvukcb.Columns.HoatDong] = Utility.Bool2byte(chkhoatdong.Checked);
dr["ten_phong"] = cboRoomDept.Text;
dr[DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
dr[DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text;
dr[DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim();
dr[DmucDichvukcb.Columns.MaBhyt] = txtMaBhyt.Text.Trim();
dr[DmucDichvukcb.Columns.MaGia] = txtmagiabhyt.Text.Trim();
dr[DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim();
dr["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text;
dr["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : "";
dr[DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng";
m_dtDataRelation.Rows.Add(dr);
//this.Close();
}
