/// <summary>
/// hàm thưucj hiện việc cập nhập lại thông tin thành công
/// </summary>
private void UpdateData()
{
objBed = createBed();
objBed.MarkOld();
objBed.IsNew = false;
objBed.Save();
if (MyGetData != null)
{
MyGetData();
Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text));
}
if (chkApDungGia.Checked)
{
new Delete().From(NoitruQheDoituongBuonggiuong.Schema)
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows())
{
NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong();
objectType.DonGia = (objectType.MaDoituongKcb == "DV" ?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu)
: (objectType.MaDoituongKcb == "BHYT" ?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt) :
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac))
)
;
objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value, 0);
objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value, 0);
objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value);
SqlQuery sqlQuery =
new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo(
objectType.MaDoituongKcb);
DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle <DmucDoituongkcb>();
if (objectType1 != null)
{
objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb);
}
objectType.KieuThue = "GIUONG";
// DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID()
objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1);
objectType.IsNew = true;
objectType.Save();
}
}
Utility.SetMsg(lblMsg, "Bạn thực hiện sửa thông tin thành công", true);
if (chkthemmoilientuc.Checked)
{
ClearControl();
}
else
{
this.Close();
}
}
public void Insert(int IdBuong,int IdGiuong,decimal DonGia,decimal PhuthuDungtuyen,decimal? PhuthuTraituyen,string MotaThem,string MaDoituongKcb,int? IdLoaidoituongKcb,int? TuTuc,string KieuThue)
{
NoitruQheDoituongBuonggiuong item = new NoitruQheDoituongBuonggiuong();
item.IdBuong = IdBuong;
item.IdGiuong = IdGiuong;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.MotaThem = MotaThem;
item.MaDoituongKcb = MaDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.TuTuc = TuTuc;
item.KieuThue = KieuThue;
item.Save(UserName);
}
/// <summary>
/// hàm thưucj hiện việc cập nhập lại thông tin thành công
/// </summary>
private void UpdateData()
{
objBed= createBed();
objBed.MarkOld();
objBed.IsNew = false;
objBed.Save();
if (MyGetData != null)
{
MyGetData();
Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text));
}
if (chkApDungGia.Checked)
{
new Delete().From(NoitruQheDoituongBuonggiuong.Schema)
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows())
{
NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong();
objectType.DonGia = (objectType.MaDoituongKcb == "DV" ?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu)
: (objectType.MaDoituongKcb == "BHYT" ?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt) :
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac))
)
;
objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value,0);
objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value,0);
objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value);
SqlQuery sqlQuery =
new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo(
objectType.MaDoituongKcb);
DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle<DmucDoituongkcb>();
if (objectType1 != null)
{
objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb);
}
objectType.KieuThue = "GIUONG";
// DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID()
objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1);
objectType.IsNew = true;
objectType.Save();
}
}
Utility.SetMsg(lblMsg, "Bạn thực hiện sửa thông tin thành công", true);
if (chkthemmoilientuc.Checked)
{
ClearControl();
}
else
this.Close();
}
private void MultiInsertData()
{
try
{
Int16 STTHthi=Utility.Int16Dbnull(txt_STT_HTHI.Text);
for (int i = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCodefrom.Text), 0); i <= Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCode2.Text), 0); i++)
{
NoitruDmucGiuongbenh objBed = new NoitruDmucGiuongbenh();
objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue);
objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text);
objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value);
objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value);
objBed.MaGiuong = Utility.sDbnull(txtMa.Text)+i.ToString();
objBed.TenGiuong = Utility.sDbnull(txtTEN.Text)+ " "+i.ToString();
objBed.TenBhyt = Utility.sDbnull(txtTEN.Text) + " " + i.ToString();
objBed.MaDonvitinh = txtDonvitinh.myCode;
objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked);
objBed.GiaDichvu = Utility.DecimaltoDbnull(txtDongia.Text, 0);
objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0);
objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0);
objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
objBed.TrangThai = (byte?)(chkTrangThai.Checked ? 1 : 0);
NoitruDmucGiuongbenh objcheck = new Select().From(NoitruDmucGiuongbenh.Schema)
.Where(NoitruDmucGiuongbenh.Columns.MaGiuong).IsEqualTo(objBed.MaGiuong)
.And(NoitruDmucGiuongbenh.Columns.IdKhoanoitru).IsEqualTo(objBed.IdKhoanoitru)
.And(NoitruDmucGiuongbenh.Columns.IdBuong).IsEqualTo(objBed.IdBuong)
.ExecuteSingle<NoitruDmucGiuongbenh>();
if (objcheck != null)
{
if (chkAutoupdate.Checked)
{
objBed.IdGiuong = objcheck.IdGiuong;
objBed.MarkOld();
objBed.IsNew = false;
}
else
{
continue;
}
}
else
{
STTHthi += 1;
objBed.IsNew = true;
}
objBed.SttHthi = STTHthi;
objBed.Save();
if (objBed != null)
{
if (chkApDungGia.Checked)
{
new Delete().From(NoitruQheDoituongBuonggiuong.Schema)
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows())
{
NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong();
objectType.DonGia =(objectType.MaDoituongKcb=="DV"?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu)
:(objectType.MaDoituongKcb=="BHYT"?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt):
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac))
)
;
objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value,0);
objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value,0);
objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value);
// DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID()
SqlQuery sqlQuery =
new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo(
objectType.MaDoituongKcb);
DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle<DmucDoituongkcb>();
if (objectType1 != null)
{
objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb);
}
objectType.KieuThue = "GIUONG";
objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1);
objectType.IsNew = true;
objectType.Save();
}
}
}
}
if (MyGetData != null)
{
MyGetData();
Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text));
}
Utility.SetMsg(lblMsg, "Bạn thực hiện thêm mới thành công", true);
if (chkthemmoilientuc.Checked) ClearControl();
else
Close();
}
catch (Exception)
{
}
}
private void MultiInsertData()
{
try
{
Int16 STTHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text);
for (int i = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCodefrom.Text), 0); i <= Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCode2.Text), 0); i++)
{
NoitruDmucGiuongbenh objBed = new NoitruDmucGiuongbenh();
objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue);
objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text);
objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value);
objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value);
objBed.MaGiuong = Utility.sDbnull(txtMa.Text) + i.ToString();
objBed.MaBhyt = Utility.sDbnull(txtMaBHYT.Text) + i.ToString();
objBed.TenGiuong = Utility.sDbnull(txtTEN.Text) + " " + i.ToString();
objBed.TenBhyt = Utility.sDbnull(txtTEN.Text) + " " + i.ToString();
objBed.MaDonvitinh = txtDonvitinh.myCode;
objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked);
objBed.GiaDichvu = Utility.DecimaltoDbnull(txtDongia.Text, 0);
objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0);
objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0);
objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
objBed.TrangThai = (byte?)(chkTrangThai.Checked ? 1 : 0);
NoitruDmucGiuongbenh objcheck = new Select().From(NoitruDmucGiuongbenh.Schema)
.Where(NoitruDmucGiuongbenh.Columns.MaGiuong).IsEqualTo(objBed.MaGiuong)
.And(NoitruDmucGiuongbenh.Columns.IdKhoanoitru).IsEqualTo(objBed.IdKhoanoitru)
.And(NoitruDmucGiuongbenh.Columns.IdBuong).IsEqualTo(objBed.IdBuong)
.ExecuteSingle <NoitruDmucGiuongbenh>();
if (objcheck != null)
{
if (chkAutoupdate.Checked)
{
objBed.IdGiuong = objcheck.IdGiuong;
objBed.MarkOld();
objBed.IsNew = false;
}
else
{
continue;
}
}
else
{
STTHthi += 1;
objBed.IsNew = true;
}
objBed.SttHthi = STTHthi;
objBed.Save();
if (objBed != null)
{
if (chkApDungGia.Checked)
{
new Delete().From(NoitruQheDoituongBuonggiuong.Schema)
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows())
{
NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong();
objectType.DonGia = (objectType.MaDoituongKcb == "DV"?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu)
:(objectType.MaDoituongKcb == "BHYT"?
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt):
Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac))
)
;
objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value, 0);
objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value, 0);
objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value);
// DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID()
SqlQuery sqlQuery =
new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo(
objectType.MaDoituongKcb);
DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle <DmucDoituongkcb>();
if (objectType1 != null)
{
objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb);
}
objectType.KieuThue = "GIUONG";
objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID);
objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1);
objectType.IsNew = true;
objectType.Save();
}
}
}
}
if (MyGetData != null)
{
MyGetData();
Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text));
}
Utility.SetMsg(lblMsg, "Bạn thực hiện thêm mới thành công", true);
if (chkthemmoilientuc.Checked)
{
ClearControl();
}
else
{
Close();
}
}
catch (Exception)
{
}
}