/// <summary>
/// hàm thực hiện laod thông tin cảu Form hiện tại
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frm_themmoi_dichvu_kcb_Load(object sender, EventArgs e)
{
InitData();
if (m_enAction == action.Update)
{
GetData();
}
else
{
nmrSTT.Value = Utility.DecimaltoDbnull(
DmucDichvucl.CreateQuery().GetMax(DmucDichvukcb.Columns.SttHthi), 0);
}
m_blnLoaded = true;
//cboDepartment1_SelectedIndexChanged(cboDepartment1, e);
}
void GetData()
{
DmucDichvucl objDichVu = DmucDichvucl.FetchByID(Utility.Int32Dbnull(txtID.Text, -1));
if (objDichVu != null)
{
txtID.Text = objDichVu.IdDichvu.ToString();
txtServiceCode.Text = Utility.sDbnull(objDichVu.MaDichvu, "");
txtServiceName.Text = Utility.sDbnull(objDichVu.TenDichvu, "");
txtMaBHYT.Text = Utility.sDbnull(objDichVu.MaBhyt, "");
txtTenBHYT.Text = Utility.sDbnull(objDichVu.TenBhyt, "");
nmrDongia.Value = Utility.DecimaltoDbnull(objDichVu.DonGia, 0);
if (Utility.Int32Dbnull(objDichVu.IdKhoaThuchien, -1) > 0)
{
cboDepartment.SelectedIndex = Utility.GetSelectedIndex(cboDepartment, objDichVu.IdKhoaThuchien.Value.ToString());
}
if (Utility.Int32Dbnull(objDichVu.IdPhongThuchien, -1) > 0)
{
cboPhongthuchien.SelectedIndex = Utility.GetSelectedIndex(cboPhongthuchien, objDichVu.IdPhongThuchien.Value.ToString());
}
txtDonvitinh.SetCode(objDichVu.MaDonvichitieu);
txtQuychuan.SetCode(objDichVu.MaQuychuanSosanh);
txtNhominphoiBHYT.SetCode(objDichVu.NhomInphoiBHYT);
txtSongaytraKQ.Text = Utility.sDbnull(objDichVu.SongayTraketqua, 0);
txtThetichtoithieu.Text = Utility.sDbnull(objDichVu.ThetichToithieu, 0);
chkTinhthetichtheochitieu.Checked = Utility.Byte2Bool(objDichVu.TinhthetichTheochitieu);
chkCososanh.Checked = Utility.Byte2Bool(objDichVu.CoSosanh);
chkKiemnghiem.Checked = Utility.Byte2Bool(objDichVu.LaDvuKiemnghiem);
//chkKiemnghiem.Checked = txtDonvitinh.myCode != "-1" || txtQuychuan.myCode != "-1" || Utility.sDbnull( txtSongaytraKQ.Text) != ""
// || Utility.sDbnull(txtThetichtoithieu.Text) != ""
// || chkTinhthetichtheochitieu.Checked || chkCososanh.Checked;
txtDesc.Text = Utility.sDbnull(objDichVu.MotaThem, "");
txtchidan.Text = objDichVu.ChiDan;
txtServiceOrder.Value = Utility.DecimaltoDbnull(objDichVu.SttHthi, "1");
cbonhombaocao.SelectedIndex = Utility.GetSelectedIndex(cbonhombaocao, objDichVu.NhomBaocao);
cboNhomin.SelectedIndex = Utility.GetSelectedIndex(cboNhomin, objDichVu.NhomInCls);
chkTrangthai.Checked = Utility.Int16Dbnull(objDichVu.TrangThai, 0) == 1;
chkHaveDetail.Checked = objDichVu.HienthiChitiet == 1 ? true : false;
chkHighTech.Checked = objDichVu.DichvuKtc == 1 ? true : false;
cboServiceType.SelectedIndex = Utility.GetSelectedIndex(cboServiceType, Utility.sDbnull(objDichVu.IdLoaidichvu, "-1"));
chkKiemnghiem_CheckedChanged(chkKiemnghiem, new EventArgs());
}
}
void Insert()
{
try
{
DmucDichvucl objDichVu = new DmucDichvucl();
objDichVu.MotaThem = txtDesc.Text;
objDichVu.MaDonvichitieu = txtDonvitinh.myCode;
objDichVu.NhomInphoiBHYT = txtNhominphoiBHYT.myCode;
objDichVu.MaQuychuanSosanh = txtQuychuan.myCode;
objDichVu.SongayTraketqua = (byte)Utility.DecimaltoDbnull(txtSongaytraKQ.Text, 0);
objDichVu.ThetichToithieu = (int)Utility.DecimaltoDbnull(txtThetichtoithieu.Text, 0);
objDichVu.TinhthetichTheochitieu = Utility.Bool2byte(chkTinhthetichtheochitieu.Checked);
objDichVu.CoSosanh = Utility.Bool2byte(chkCososanh.Checked);
objDichVu.LaDvuKiemnghiem = Utility.Bool2byte(chkKiemnghiem.Checked);
objDichVu.IdKhoaThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.IdPhongThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.MaDichvu = Utility.sDbnull(txtServiceCode.Text, "");
objDichVu.TenDichvu = Utility.sDbnull(txtServiceName.Text, "");
objDichVu.MaBhyt = Utility.sDbnull(txtMaBHYT.Text, "");
objDichVu.TenBhyt = Utility.sDbnull(txtTenBHYT.Text, "");
objDichVu.IdLoaidichvu = Utility.sDbnull(cboServiceType.SelectedValue, "-1");
objDichVu.SttHthi = Utility.Int16Dbnull(txtServiceOrder.Value, 0);
objDichVu.DichvuKtc = chkHighTech.Checked ? Convert.ToInt16(1) : Convert.ToInt16(0);
objDichVu.HienthiChitiet = chkHaveDetail.Checked ? Convert.ToByte(1) : Convert.ToByte(0);
objDichVu.NgayTao = globalVariables.SysDate;
objDichVu.NguoiTao = globalVariables.UserName;
objDichVu.ChiDan = Utility.DoTrim(txtchidan.Text);
objDichVu.TrangThai = (byte)(chkTrangthai.Checked ? 1 : 0);
objDichVu.NhomInCls = Utility.sDbnull(cboNhomin.SelectedValue, "ALL");// getNhominCLS(cboNhomin.SelectedIndex);
objDichVu.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1");
objDichVu.DonGia = nmrDongia.Value;
objDichVu.IsNew = true;
objDichVu.Save();
ProcessData(objDichVu.IdDichvu);
}
catch
{
}
}
void Insert()
{
try
{
DmucDichvucl objDichVu = new DmucDichvucl();
objDichVu.MotaThem = txtDesc.Text;
objDichVu.IdKhoaThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.IdPhongThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.MaDichvu = Utility.sDbnull(txtServiceCode.Text, "");
objDichVu.TenDichvu = Utility.sDbnull(txtServiceName.Text, "");
objDichVu.IdLoaidichvu = Utility.sDbnull(cboServiceType.SelectedValue, "-1");
objDichVu.SttHthi = Utility.Int16Dbnull(txtServiceOrder.Value, 0);
objDichVu.DichvuKtc = chkHighTech.Checked ? Convert.ToInt16(1) : Convert.ToInt16(0);
objDichVu.HienthiChitiet = chkHaveDetail.Checked ? Convert.ToByte(1) : Convert.ToByte(0);
objDichVu.NgayTao = globalVariables.SysDate;
objDichVu.NguoiTao = globalVariables.UserName;
objDichVu.ChiDan = Utility.DoTrim(txtchidan.Text);
objDichVu.TrangThai = (byte)(chkTrangthai.Checked ? 1 : 0);
objDichVu.NhomInCls = Utility.sDbnull(cboNhomin.SelectedValue, "ALL");// getNhominCLS(cboNhomin.SelectedIndex);
objDichVu.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1");
objDichVu.DonGia = nmrDongia.Value;
objDichVu.IsNew = true;
objDichVu.Save();
ProcessData(objDichVu.IdDichvu);
}
catch
{
}
}
public void Insert(string IdLoaidichvu,string MaDichvu,string MaBhyt,string TenDichvu,string TenBhyt,decimal DonGia,byte TrangThai,short? DichvuKtc,short SttHthi,byte? HienthiChitiet,short? IdKhoaThuchien,short? IdPhongThuchien,string ChiDan,string NhomBaocao,string NhomInCls,string MotaThem,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,int? IdVungkhaosat,int? ThetichToithieu,byte? TinhthetichTheochitieu,string MaDonvichitieu,byte? CoSosanh,string MaQuychuanSosanh,byte? SongayTraketqua)
{
DmucDichvucl item = new DmucDichvucl();
item.IdLoaidichvu = IdLoaidichvu;
item.MaDichvu = MaDichvu;
item.MaBhyt = MaBhyt;
item.TenDichvu = TenDichvu;
item.TenBhyt = TenBhyt;
item.DonGia = DonGia;
item.TrangThai = TrangThai;
item.DichvuKtc = DichvuKtc;
item.SttHthi = SttHthi;
item.HienthiChitiet = HienthiChitiet;
item.IdKhoaThuchien = IdKhoaThuchien;
item.IdPhongThuchien = IdPhongThuchien;
item.ChiDan = ChiDan;
item.NhomBaocao = NhomBaocao;
item.NhomInCls = NhomInCls;
item.MotaThem = MotaThem;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.IdVungkhaosat = IdVungkhaosat;
item.ThetichToithieu = ThetichToithieu;
item.TinhthetichTheochitieu = TinhthetichTheochitieu;
item.MaDonvichitieu = MaDonvichitieu;
item.CoSosanh = CoSosanh;
item.MaQuychuanSosanh = MaQuychuanSosanh;
item.SongayTraketqua = SongayTraketqua;
item.Save(UserName);
}
private void LAOKHO_INPHIEU_BAOHIEM()
{
m_dtReportPhieuThu =
SPs.BhytLaythongtinInphoi(Utility.Int32Dbnull(-1), Utility.sDbnull(objLuotkham.MaLuotkham, ""),
Utility.Int32Dbnull(objLuotkham.IdBenhnhan, -1), 0).GetDataSet().Tables[0];
///load thông tin của việc lấy dữ liệu vào datatable trong phiếu thanh toán)
if (m_dtReportPhieuThu.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy bản ghi ", "Thông báo");
return;
}
if (m_dtReportPhieuThu.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin của bản ghi nào");
return;
}
if (!m_dtReportPhieuThu.Columns.Contains("Tyle"))
{
m_dtReportPhieuThu.Columns.Add("Tyle", typeof(string));
}
if (!m_dtReportPhieuThu.Columns.Contains("BHYT"))
{
m_dtReportPhieuThu.Columns.Add("BHYT", typeof(string));
}
if (!m_dtReportPhieuThu.Columns.Contains("BNTT"))
{
m_dtReportPhieuThu.Columns.Add("BNTT", typeof(string));
}
if (!m_dtReportPhieuThu.Columns.Contains("TyLe_BH"))
{
m_dtReportPhieuThu.Columns.Add("TyLe_BH", typeof(string));
}
if (!m_dtReportPhieuThu.Columns.Contains("Tyle_BN"))
{
m_dtReportPhieuThu.Columns.Add("Tyle_BN", typeof(string));
}
foreach (DataRow drv in m_dtReportPhieuThu.Rows)
{
drv["Tyle"] = (100 - objLuotkham.PtramBhyt) + " %";
drv["BHYT"] = objLuotkham.PtramBhyt + " %";
drv["BNTT"] = (100 - objLuotkham.PtramBhyt) + " %";
drv["TyLe_BH"] = objLuotkham.PtramBhyt + " %";
drv["Tyle_BN"] = (100 - objLuotkham.PtramBhyt) + " %";
}
m_dtReportPhieuThu.AcceptChanges();
foreach (DataRow drv in m_dtReportPhieuThu.Rows)
{
if (drv[KcbThanhtoanChitiet.Columns.IdLoaithanhtoan].ToString() == "1")
{
int Id_Loai_dvu = Utility.Int32Dbnull(drv["ID_LOAI_DVU"], -1);
drv["TEN_LOAI_DVU"] = string.Empty;
drv["ID_LOAI_DVU"] = Id_Loai_dvu;
drv["STT"] = 1;
}
if (drv[KcbThanhtoanChitiet.Columns.IdLoaithanhtoan].ToString() == "2")
{
int Id_Loai_dvu = Utility.Int32Dbnull(drv["ID_LOAI_DVU"], -1);
DmucDichvucl objService = DmucDichvucl.FetchByID(Id_Loai_dvu);
if (objService != null)
{
drv["TEN_LOAI_DVU"] = Utility.sDbnull(objService.TenDichvu);
drv["STT"] = Utility.sDbnull(objService.SttHthi);
}
}
if (drv[KcbThanhtoanChitiet.Columns.IdLoaithanhtoan].ToString() == "3")
{
int Drug_ID = Utility.Int32Dbnull(drv["ID_DVU"], -1);
DmucThuoc objDrug = DmucThuoc.FetchByID(Drug_ID);
if (objDrug != null)
{
if (objDrug.KieuThuocvattu == "THUOC")
{
drv["ID_LOAI_DVU"] = 1;
drv["STT"] = 1;
drv["TEN_LOAI_DVU"] = "Thuốc ";
}
else
{
drv["ID_LOAI_DVU"] = 2;
drv["STT"] = 2;
drv["TEN_LOAI_DVU"] = "Vật tư y tế ";
}
}
}
if (drv[KcbThanhtoanChitiet.Columns.IdLoaithanhtoan].ToString() == "5")
{
drv["ID_LOAI_DVU"] = 1;
drv["STT"] = 1;
drv["TEN_LOAI_DVU"] = "Chi phí thêm ";
}
}
m_dtReportPhieuThu.AcceptChanges();
// KyDong_PrintBaoHiem_DungTuyen(txtTieuDe.Text);
new INPHIEU_THANHTOAN_NGOAITRU().LAOKHOA_INPHIEU_BAOHIEM_NGOAITRU(m_dtReportPhieuThu, txtTieuDe.Text, dtNgayIn.Value);
}
public void Insert(string IdLoaidichvu,string MaDichvu,string TenDichvu,decimal DonGia,byte TrangThai,short? DichvuKtc,short SttHthi,byte? HienthiChitiet,short? IdKhoaThuchien,short? IdPhongThuchien,string ChiDan,string NhomBaocao,string NhomInCls,string MotaThem,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,int? IdVungkhaosat)
{
DmucDichvucl item = new DmucDichvucl();
item.IdLoaidichvu = IdLoaidichvu;
item.MaDichvu = MaDichvu;
item.TenDichvu = TenDichvu;
item.DonGia = DonGia;
item.TrangThai = TrangThai;
item.DichvuKtc = DichvuKtc;
item.SttHthi = SttHthi;
item.HienthiChitiet = HienthiChitiet;
item.IdKhoaThuchien = IdKhoaThuchien;
item.IdPhongThuchien = IdPhongThuchien;
item.ChiDan = ChiDan;
item.NhomBaocao = NhomBaocao;
item.NhomInCls = NhomInCls;
item.MotaThem = MotaThem;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.IdVungkhaosat = IdVungkhaosat;
item.Save(UserName);
}
void Insert()
{
try
{
DmucDichvucl objDichVu = new DmucDichvucl();
objDichVu.MotaThem = txtDesc.Text;
objDichVu.MaDonvichitieu = txtDonvitinh.myCode;
objDichVu.MaQuychuanSosanh = txtQuychuan.myCode;
objDichVu.SongayTraketqua = (byte) Utility.DecimaltoDbnull(txtSongaytraKQ.Text, 0);
objDichVu.ThetichToithieu = (int) Utility.DecimaltoDbnull(txtThetichtoithieu.Text, 0);
objDichVu.TinhthetichTheochitieu = Utility.Bool2byte(chkTinhthetichtheochitieu.Checked);
objDichVu.CoSosanh=Utility.Bool2byte(chkCososanh.Checked );
objDichVu.IdKhoaThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.IdPhongThuchien = Utility.Int16Dbnull(cboDepartment.SelectedValue, -1);
objDichVu.MaDichvu = Utility.sDbnull(txtServiceCode.Text, "");
objDichVu.TenDichvu = Utility.sDbnull(txtServiceName.Text, "");
objDichVu.MaBhyt = Utility.sDbnull(txtMaBHYT.Text, "");
objDichVu.TenBhyt = Utility.sDbnull(txtTenBHYT.Text, "");
objDichVu.IdLoaidichvu = Utility.sDbnull(cboServiceType.SelectedValue, "-1");
objDichVu.SttHthi = Utility.Int16Dbnull(txtServiceOrder.Value, 0);
objDichVu.DichvuKtc = chkHighTech.Checked ? Convert.ToInt16(1) : Convert.ToInt16(0);
objDichVu.HienthiChitiet = chkHaveDetail.Checked ? Convert.ToByte(1) : Convert.ToByte(0);
objDichVu.NgayTao = globalVariables.SysDate;
objDichVu.NguoiTao = globalVariables.UserName;
objDichVu.ChiDan = Utility.DoTrim(txtchidan.Text);
objDichVu.TrangThai = (byte)(chkTrangthai.Checked ? 1 : 0);
objDichVu.NhomInCls = Utility.sDbnull(cboNhomin.SelectedValue, "ALL");// getNhominCLS(cboNhomin.SelectedIndex);
objDichVu.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1");
objDichVu.DonGia = nmrDongia.Value;
objDichVu.IsNew = true;
objDichVu.Save();
ProcessData(objDichVu.IdDichvu);
}
catch
{
}
}
