public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO BangKeChanDoan (BangKe_Id,MaICD,STT) ";
sql += "VALUES(@BangKe_Id,@MaICD,@STT)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
//command.Parameters.Add(new SQLiteParameter("@BangKeChiTiet_Id", );
command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id));
command.Parameters.Add(new SQLiteParameter("@MaICD", MaICD));
command.Parameters.Add(new SQLiteParameter("@STT", STT));
int result = command.ExecuteNonQuery();
return result;
}
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_MucHuongDoiTuong (MucHuong, DoiTuong) ";
sql += " VALUES(@MucHuong,@DoiTuong)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@DoiTuong", DoiTuong));
int result = command.ExecuteNonQuery();
return result;
}
/// <summary>
/// Hàm Insert Trans
/// </summary>
/// <param name="DAL"></param>
/// <returns></returns>
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_Thuoc (MaThuoc,TenThuoc,TenHoatChat,DonViTinh,QuyCach,NhaSanXuat,NuocSanXuat,SoDangKy,HanSuDung,NongDo,DangBaoChe,TieuChuan,NhomThuoc,DonGiaMua,DonGiaThau,DonGiaCSKCB,SoLuong,MaNhom1,MaNhom2,TrongDanhMucBHYT,TrongThau,Active,ThuocDieuTriK,TyLeThanhToan,MaNhaThau,Nam,STTBYT,MaThuocBYT,MaThuocBYT2,TenThuocBYT,GhiChu,HanSuDung_Str) ";
sql += "VALUES(@MaThuoc,@TenThuoc,@TenHoatChat,@DonViTinh,@QuyCach,@NhaSanXuat,@NuocSanXuat,@SoDangKy,@HanSuDung,@NongDo,@DangBaoChe,@TieuChuan,@NhomThuoc,@DonGiaMua,@DonGiaThau,@DonGiaCSKCB,@SoLuong,@MaNhom1,@MaNhom2,@TrongDanhMucBHYT,@TrongThau,@Active,@ThuocDieuTriK,@TyLeThanhToan,@MaNhaThau,@Nam,@STTBYT,@MaThuocBYT,@MaThuocBYT2,@TenThuocBYT,@GhiChu,@HanSuDung_Str)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaThuoc", MaThuoc));
command.Parameters.Add(new SQLiteParameter("@TenThuoc", TenThuoc));
command.Parameters.Add(new SQLiteParameter("@TenHoatChat", TenHoatChat));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@QuyCach", QuyCach));
command.Parameters.Add(new SQLiteParameter("@NhaSanXuat", NhaSanXuat));
command.Parameters.Add(new SQLiteParameter("@NuocSanXuat", NuocSanXuat));
command.Parameters.Add(new SQLiteParameter("@SoDangKy", SoDangKy));
command.Parameters.Add(new SQLiteParameter("@HanSuDung", HanSuDung));
command.Parameters.Add(new SQLiteParameter("@NongDo", NongDo));
command.Parameters.Add(new SQLiteParameter("@DangBaoChe", DangBaoChe));
command.Parameters.Add(new SQLiteParameter("@TieuChuan", TieuChuan));
command.Parameters.Add(new SQLiteParameter("@NhomThuoc", NhomThuoc));
command.Parameters.Add(new SQLiteParameter("@DonGiaMua", DonGiaMua));
command.Parameters.Add(new SQLiteParameter("@DonGiaThau", DonGiaThau));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@SoLuong", SoLuong));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@TrongThau", TrongThau));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@ThuocDieuTriK", ThuocDieuTriK));
command.Parameters.Add(new SQLiteParameter("@TyLeThanhToan", TyLeThanhToan));
command.Parameters.Add(new SQLiteParameter("@MaNhaThau", MaNhaThau));
command.Parameters.Add(new SQLiteParameter("@Nam", Nam));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaThuocBYT", MaThuocBYT));
command.Parameters.Add(new SQLiteParameter("@MaThuocBYT2", MaThuocBYT2));
command.Parameters.Add(new SQLiteParameter("@TenThuocBYT", TenThuocBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
command.Parameters.Add(new SQLiteParameter("@HanSuDung_Str", HanSuDung_Str));
int result = command.ExecuteNonQuery();
return result;
}
public int Insert(SQLiteDAL DAL)
{
//SQLiteConnection m_dbConnection = new SQLiteConnection(connectionString);
//m_dbConnection.Open();
string sql = "";
sql += "INSERT INTO DM_ICD (MaICD, TenICD, NgoaiDinhSuat, Active) ";
sql += " VALUES(@MaICD,@TenICD,@NgoaiDinhSuat,@Active)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaICD", MaICD));
command.Parameters.Add(new SQLiteParameter("@TenICD", TenICD));
command.Parameters.Add(new SQLiteParameter("@NgoaiDinhSuat", NgoaiDinhSuat));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_LuongCoSo (TuNgay, LuongCoSo) ";
sql += " VALUES(@TuNgay,@LuongCoSo)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@TuNgay", TuNgay));
command.Parameters.Add(new SQLiteParameter("@LuongCoSo", LuongCoSo));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += " UPDATE DM_VTYT ";
sql += " SET MaVTYT=@MaVTYT,TenVTYT=@TenVTYT,TenHoatChat=@TenHoatChat,DonViTinh=@DonViTinh,QuyCach=@QuyCach,NhaSanXuat=@NhaSanXuat,NuocSanXuat=@NuocSanXuat,SoDangKy=@SoDangKy,HanSuDung=@HanSuDung,SoLuong=@SoLuong,DonGiaMua=@DonGiaMua,DonGiaThau=@DonGiaThau,DonGiaCSKCB=@DonGiaCSKCB,MaNhom1=@MaNhom1,MaNhom2=@MaNhom2,TrongDanhMucBHYT=@TrongDanhMucBHYT,VTYTThayThe=@VTYTThayThe,VTYTDichVuKTC=@VTYTDichVuKTC,TrongThau=@TrongThau,Active=@Active,Nam=@Nam,STTBYT=@STTBYT,MaVTYTBYT=@MaVTYTBYT,TenVTYTBYT=@TenVTYTBYT,GhiChu=@GhiChu";
sql += " WHERE MaVTYT=@MaVTYT";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaVTYT", MaVTYT));
command.Parameters.Add(new SQLiteParameter("@TenVTYT", TenVTYT));
command.Parameters.Add(new SQLiteParameter("@TenHoatChat", TenHoatChat));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@QuyCach", QuyCach));
command.Parameters.Add(new SQLiteParameter("@NhaSanXuat", NhaSanXuat));
command.Parameters.Add(new SQLiteParameter("@NuocSanXuat", NuocSanXuat));
command.Parameters.Add(new SQLiteParameter("@SoDangKy", SoDangKy));
command.Parameters.Add(new SQLiteParameter("@HanSuDung", HanSuDung));
command.Parameters.Add(new SQLiteParameter("@DonGiaMua", DonGiaMua));
command.Parameters.Add(new SQLiteParameter("@DonGiaThau", DonGiaThau));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@SoLuong", SoLuong));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@TrongThau", TrongThau));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@VTYTThayThe", VTYTThayThe));
command.Parameters.Add(new SQLiteParameter("@VTYTDichVuKTC", VTYTDichVuKTC));
command.Parameters.Add(new SQLiteParameter("@Nam", Nam));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaVTYTBYT", MaVTYTBYT));
command.Parameters.Add(new SQLiteParameter("@TenVTYTBYT", TenVTYTBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
return result;
}
//Update Trans
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_DichVu SET MaDichVu=@MaDichVu,TenDichVu=@TenDichVu,MaLoaiDichVu=@MaLoaiDichVu,DonViTinh=@DonViTinh,DonGiaBHYT=@DonGiaBHYT,DonGiaCSKCB = @DonGiaCSKCB,MaNhom1=@MaNhom1,MaNhom2=@MaNhom2,";
sql += "TrongDanhMucBHYT=@TrongDanhMucBHYT,Active=@Active,DichVuKTC=@DichVuKTC,ThongTu=@ThongTu,STTBYT=@STTBYT,MaKhac=@MaKhac,MaLoaiChiPhi=@MaLoaiChiPhi,MaDichVuBYT=@MaDichVuBYT,GhiChu=@GhiChu ";
sql += "WHERE MaDichVu=@MaDichVu";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaDichVu", MaDichVu));
command.Parameters.Add(new SQLiteParameter("@TenDichVu", TenDichVu));
command.Parameters.Add(new SQLiteParameter("@MaLoaiDichVu", MaLoaiDichVu));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@DonGiaBHYT", DonGiaBHYT));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@DichVuKTC", DichVuKTC));
command.Parameters.Add(new SQLiteParameter("@ThongTu", ThongTu));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaKhac", MaKhac));
command.Parameters.Add(new SQLiteParameter("@MaLoaiChiPhi", MaLoaiChiPhi));
command.Parameters.Add(new SQLiteParameter("@MaDichVuBYT", MaDichVuBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
return result;
}
private void InsertDanhMucOnline()
{
//btnLamMoi.Enabled = false;
//btnThem.Enabled = false;
//btnXoa.Enabled = false;
//btnLamMoi.Enabled = false;
//btnGetDM.Enabled = false;
//btnSua.Enabled = false;
SystemConfig system = SystemConfig.Instance;
string token = system.GetToken();
if (string.IsNullOrEmpty(token))
{
MessageBox.Show("Vui lòng kiểm tra lại thông tin cấu hình!.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(token))
{
string URL = clsGetMa.GetTenThamSoWS();
string response = system.SendRequest(URL, "GET", string.Empty); //HttpRequest.WSRequest(URL1, "GET", string.Empty, token);
if (string.IsNullOrEmpty(response))
{
MessageBox.Show("Không lấy được dữ liệu.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//string str = XMLUtils.DeSerializeToObject<string>(response);
List<object> lstDMThuoc = clsGetMa.LayDanhSachFromWS(response);// XMLUtils.DeSerializeToList<DM_CSKCB>(response1);
int tongRecord = lstDMThuoc.Count;
// "Có " + tongRecord + " danh mục thuốc. Bạn có muốn tải về?"
if (MessageBox.Show(clsGetMa .ShowMessageGetDuLieu(tongRecord), "Thông báo", MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.No)
{
return;
}
SQLiteDAL DAL = new SQLiteDAL();
DAL.BeginTransaction();
// hst.Delete();
foreach (object t in lstDMThuoc)
{
int result= clsGetMa.XuLyTuWSSangCSDL(t,dtDM,DAL);
if (result == 0)
{
DAL.RollbackTransaction();
return;
}
}
// Close & Commit Trans
DAL.CommitTransaction();
LoadGridview();
MessageBox.Show("Đã Lấy Dữ Liệu Thành Công.");
//btnLamMoi.Enabled = true;
//btnThem.Enabled = true;
//btnXoa.Enabled = true;
//btnLamMoi.Enabled = true;
//btnGetDM.Enabled = true;
//btnSua.Enabled = true;
}
else
{
// "Access token is empty.";
}
}
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += " INSERT INTO DangKyKhamBenh (SoDKKCBBHYT,MaCSKCB,MaCSKCBBĐ,SoTheBHYT,TuNgay,DenNgay,HoTen,NgaySinh,GioiTinh,DiaChi,MaNoiSinhSong,LyDoVV,MaNoiChuyenDen,NgayDenKham,ChungNhanKhongCTT,GhiChu)";
sql += " VALUES(@SoDKKCBBHYT,@MaCSKCB,@MaCSKCBBĐ,@SoTheBHYT,@TuNgay,@DenNgay,@HoTen,@NgaySinh,@GioiTinh,@DiaChi,@MaNoiSinhSong,@LyDoVV,@MaNoiChuyenDen,@NgayDenKham,@ChungNhanKhongCTT,@GhiChu)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@SoDKKCBBHYT", SoDKKCBBHYT));
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaCSKCBBĐ", MaCSKCBBĐ));
command.Parameters.Add(new SQLiteParameter("@SoTheBHYT", SoTheBHYT));
command.Parameters.Add(new SQLiteParameter("@TuNgay", TuNgay));
command.Parameters.Add(new SQLiteParameter("@DenNgay", DenNgay));
command.Parameters.Add(new SQLiteParameter("@HoTen", HoTen));
command.Parameters.Add(new SQLiteParameter("@NgaySinh", NgaySinh));
command.Parameters.Add(new SQLiteParameter("@GioiTinh", GioiTinh));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@MaNoiSinhSong", MaNoiSinhSong));
command.Parameters.Add(new SQLiteParameter("@LyDoVV", LyDoVV));
command.Parameters.Add(new SQLiteParameter("@MaNoiChuyenDen", MaNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@NgayDenKham", NgayDenKham));
command.Parameters.Add(new SQLiteParameter("@ChungNhanKhongCTT", ChungNhanKhongCTT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
private void UpdateData()
{
SQLiteDAL DAL = new SQLiteDAL();
DAL.BeginTransaction();
clsBangKe objBangKe = new clsBangKe();
List<clsBangKeChiTiet> chitiets = new List<clsBangKeChiTiet>();
try
{
objBangKe.GetByKey(m_BangKe_Id);
FillBangKe(ref objBangKe);
int kq = objBangKe.Update(DAL);
if (kq > 0)
{
kq = objBangKe.DeleteBangKeChiTiet(m_BangKe_Id, DAL);
if (kq > 0)
{
FillBangKe(ref chitiets, m_BangKe_Id);
foreach (clsBangKeChiTiet ct in chitiets)
{
kq = ct.Insert(DAL);
if (kq <= 0)
{
DAL.RollbackTransaction();
return;
}
}
}
else
{
DAL.RollbackTransaction();
return;
}
}
else
{
DAL.RollbackTransaction();
return;
}
DAL.CommitTransaction();
//MessageBox.Show("Cập nhật bảng kê thành công", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
lblThongBao.Text = "Cập nhật bảng kê thành công.";
timerThongBao.Enabled = true;
}
catch (Exception ex)
{
DAL.RollbackTransaction();
m_BangKe_Id = 0;
txtSoHoSo.Text = "";
MessageBox.Show("Cập nhật bảng kê không thành công.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
//lblThongBao.Text = "Cập nhật bảng kê không thành công";
//timerThongBao.Enabled = true;
}
}
//Update trans
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_MauVaChePhamMau SET MaMauVaChePhamMau=@MaMauVaChePhamMau,TenMauVaChePhamMau=@TenMauVaChePhamMau,MaLoaiMauVaChePhamMau=@MaLoaiMauVaChePhamMau,DonViTinh=@DonViTinh,DonGiaBHYT=@DonGiaBHYT,MaNhom1=@MaNhom1,MaNhom2=@MaNhom2,";
sql += "TrongDanhMucBHYT=@TrongDanhMucBHYT,Active=@Active,ThongTu=@ThongTu,STTBYT=@STTBYT,MaMauVaChePhamMauBYT=@MaMauVaChePhamMauBYT,GhiChu=@GhiChu,DonGiaCSKCB=@DonGiaCSKCB ";
sql += "WHERE MaMauVaChePhamMau=@MaMauVaChePhamMau";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaMauVaChePhamMau", MaMauVaChePhamMau));
command.Parameters.Add(new SQLiteParameter("@TenMauVaChePhamMau", TenMauVaChePhamMau));
command.Parameters.Add(new SQLiteParameter("@MaLoaiMauVaChePhamMau", MaLoaiMauVaChePhamMau));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@DonGiaBHYT", DonGiaBHYT));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@ThongTu", ThongTu));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaMauVaChePhamMauBYT", MaMauVaChePhamMauBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
return result;
}
private void InsertData()
{
SQLiteDAL DAL = new SQLiteDAL();
DAL.BeginTransaction();
clsBangKe objBangKe = new clsBangKe();
List<clsBangKeChiTiet> chitiets = new List<clsBangKeChiTiet>();
try
{
FillBangKe(ref objBangKe);
int intBangKe_Id = objBangKe.Insert(DAL);
m_BangKe_Id = intBangKe_Id;
int kq = 0;
if (intBangKe_Id > 0)
{
FillBangKe(ref chitiets, intBangKe_Id);
foreach (clsBangKeChiTiet ct in chitiets)
{
kq = ct.Insert(DAL);
if (kq <= 0)
{
DAL.RollbackTransaction();
return;
}
}
}
else
{
DAL.RollbackTransaction();
return;
}
DAL.CommitTransaction();
//MessageBox.Show("Thêm mới bảng kê thành công", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
lblThongBao.Text = "Thêm mới bảng kê thành công.";
timerThongBao.Enabled = true;
}
catch (Exception ex)
{
DAL.RollbackTransaction();
MessageBox.Show("Thêm mới bảng kê không thành công.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
//lblThongBao.Text = "Thêm mới bảng kê không thành công";
//timerThongBao.Enabled = true;
}
}
public virtual int Update(SQLiteDAL DAL)
{
return 0;
}
public virtual int Insert(SQLiteDAL DA)
{
return 0;
}
/// <summary>
/// Ham update Trans
/// </summary>
/// <param name="DAL"></param>
/// <returns></returns>
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE BangKe ";
sql += "Set LoaiBangKe=@LoaiBangKe ,SoHoSo=@SoHoSo ,Khoa=@Khoa ,MaKhamChuaBenh=@MaKhamChuaBenh ,MaNguoiBenh=@MaNguoiBenh ,HoTen=@HoTen ,GioiTinh=@GioiTinh ,NgaySinh=@NgaySinh ,NamSinh=@NamSinh ,DiaChi=@DiaChi ,MaNoiSinhSong=@MaNoiSinhSong ,SoTheBHYT=@SoTheBHYT ,TuNgayBH=@TuNgayBH ,DenNgayBH=@DenNgayBH ,CoBHYT=@CoBHYT ,TreEmKhongTheBHYT=@TreEmKhongTheBHYT ,MucHuong=@MucHuong ,PhanTramDuocHuong=@PhanTramDuocHuong ,MaCSKCBBanDau=@MaCSKCBBanDau ,TenCSKCBBanDau=@TenCSKCBBanDau ,MaCSKCB=@MaCSKCB ,MaChiNhanh=@MaChiNhanh ,MaNoiChuyenDen=@MaNoiChuyenDen ,TenNoiChuyenDen=@TenNoiChuyenDen ,NgayDenKham=@NgayDenKham ,NgayKetThuc=@NgayKetThuc ,SoNgayDieuTri=@SoNgayDieuTri ,NgayQuyetToan=@NgayQuyetToan ,TuyenKhamBenh=@TuyenKhamBenh ,ChanDoan=@ChanDoan ,BenhKhac=@BenhKhac ,MaICD=@MaICD ,TongChiPhi=@TongChiPhi ,BHYTThanhToan=@BHYTThanhToan ,NguoiBenhTra=@NguoiBenhTra ,NguonKhac=@NguonKhac ,SoTienThanhToanToiDa=@SoTienThanhToanToiDa ,TienKham=@TienKham ,TienGiuong=@TienGiuong ,TienXN=@TienXN ,TienCDHA=@TienCDHA ,TienTDCN=@TienTDCN ,TienPTTT=@TienPTTT ,TienDichVuKTC=@TienDichVuKTC ,TienMau=@TienMau ,TienThuoc=@TienThuoc ,TienVTYT=@TienVTYT ,TienVTYTTH=@TienVTYTTH ,TienVTYTTT=@TienVTYTTT ,TienVanChuyen=@TienVanChuyen ,DVKTC_TinhToan=@DVKTC_TinhToan ,DVKTC_ThanhToan=@DVKTC_ThanhToan ,ChiPhiNgoaiDinhSuat=@ChiPhiNgoaiDinhSuat ,DaGuiBHYT=@DaGuiBHYT ,NgayGuiBHYT=@NgayGuiBHYT ,NguoiGuiBHYT=@NguoiGuiBHYT ,NgayTao=@NgayTao ,NguoiTao=@NguoiTao ,NgayCapNhat=@NgayCapNhat ,NguoiCapNhat=@NguoiCapNhat ,ChungNhanKhongCCT=@ChungNhanKhongCCT,BangKe_Id_BHXH=@BangKe_Id_BHXH ";
sql += "WHERE BangKe_Id=@BangKe_Id";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id));
command.Parameters.Add(new SQLiteParameter("@LoaiBangKe", LoaiBangKe));
command.Parameters.Add(new SQLiteParameter("@SoHoSo", SoHoSo));
command.Parameters.Add(new SQLiteParameter("@Khoa", Khoa));
command.Parameters.Add(new SQLiteParameter("@MaKhamChuaBenh", MaKhamChuaBenh));
command.Parameters.Add(new SQLiteParameter("@MaNguoiBenh", MaNguoiBenh));
command.Parameters.Add(new SQLiteParameter("@HoTen", HoTen));
command.Parameters.Add(new SQLiteParameter("@GioiTinh", GioiTinh));
command.Parameters.Add(new SQLiteParameter("@NgaySinh", NgaySinh));
command.Parameters.Add(new SQLiteParameter("@NamSinh", NamSinh));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@MaNoiSinhSong", MaNoiSinhSong));
command.Parameters.Add(new SQLiteParameter("@SoTheBHYT", SoTheBHYT));
command.Parameters.Add(new SQLiteParameter("@TuNgayBH", TuNgayBH));
command.Parameters.Add(new SQLiteParameter("@DenNgayBH", DenNgayBH));
command.Parameters.Add(new SQLiteParameter("@CoBHYT", CoBHYT));
command.Parameters.Add(new SQLiteParameter("@TreEmKhongTheBHYT", TreEmKhongTheBHYT));
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@PhanTramDuocHuong", PhanTramDuocHuong));
command.Parameters.Add(new SQLiteParameter("@MaCSKCBBanDau", MaCSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@TenCSKCBBanDau", TenCSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaChiNhanh", MaChiNhanh));
command.Parameters.Add(new SQLiteParameter("@MaNoiChuyenDen", MaNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@TenNoiChuyenDen", TenNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@NgayDenKham", NgayDenKham));
command.Parameters.Add(new SQLiteParameter("@NgayKetThuc", NgayKetThuc));
command.Parameters.Add(new SQLiteParameter("@SoNgayDieuTri", SoNgayDieuTri));
command.Parameters.Add(new SQLiteParameter("@NgayQuyetToan", NgayQuyetToan));
command.Parameters.Add(new SQLiteParameter("@TuyenKhamBenh", TuyenKhamBenh));
command.Parameters.Add(new SQLiteParameter("@ChanDoan", ChanDoan));
command.Parameters.Add(new SQLiteParameter("@BenhKhac", BenhKhac));
command.Parameters.Add(new SQLiteParameter("@MaICD", MaICD));
command.Parameters.Add(new SQLiteParameter("@TongChiPhi", TongChiPhi));
command.Parameters.Add(new SQLiteParameter("@BHYTThanhToan", BHYTThanhToan));
command.Parameters.Add(new SQLiteParameter("@NguoiBenhTra", NguoiBenhTra));
command.Parameters.Add(new SQLiteParameter("@NguonKhac", NguonKhac));
command.Parameters.Add(new SQLiteParameter("@SoTienThanhToanToiDa", SoTienThanhToanToiDa));
command.Parameters.Add(new SQLiteParameter("@TienKham", TienKham));
command.Parameters.Add(new SQLiteParameter("@TienGiuong", TienGiuong));
command.Parameters.Add(new SQLiteParameter("@TienXN", TienXN));
command.Parameters.Add(new SQLiteParameter("@TienCDHA", TienCDHA));
command.Parameters.Add(new SQLiteParameter("@TienTDCN", TienTDCN));
command.Parameters.Add(new SQLiteParameter("@TienPTTT", TienPTTT));
command.Parameters.Add(new SQLiteParameter("@TienDichVuKTC", TienDichVuKTC));
command.Parameters.Add(new SQLiteParameter("@TienMau", TienMau));
command.Parameters.Add(new SQLiteParameter("@TienThuoc", TienThuoc));
command.Parameters.Add(new SQLiteParameter("@TienVTYT", TienVTYT));
command.Parameters.Add(new SQLiteParameter("@TienVTYTTH", TienVTYTTH));
command.Parameters.Add(new SQLiteParameter("@TienVTYTTT", TienVTYTTT));
command.Parameters.Add(new SQLiteParameter("@TienVanChuyen", TienVanChuyen));
command.Parameters.Add(new SQLiteParameter("@DVKTC_TinhToan", DVKTC_TinhToan));
command.Parameters.Add(new SQLiteParameter("@DVKTC_ThanhToan", DVKTC_ThanhToan));
command.Parameters.Add(new SQLiteParameter("@ChiPhiNgoaiDinhSuat", ChiPhiNgoaiDinhSuat));
command.Parameters.Add(new SQLiteParameter("@DaGuiBHYT", DaGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NgayGuiBHYT", NgayGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NguoiGuiBHYT", NguoiGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NgayTao", NgayTao));
command.Parameters.Add(new SQLiteParameter("@NguoiTao", NguoiTao));
command.Parameters.Add(new SQLiteParameter("@NgayCapNhat", NgayCapNhat));
command.Parameters.Add(new SQLiteParameter("@NguoiCapNhat", NguoiCapNhat));
command.Parameters.Add(new SQLiteParameter("@ChungNhanKhongCCT", ChungNhanKhongCCT));
command.Parameters.Add(new SQLiteParameter("@BangKe_Id_BHXH", BangKe_Id_BHXH));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += " UPDATE DangKyKhamBenh ";
sql += " SET SoDKKCBBHYT=@SoDKKCBBHYT ,MaCSKCB =@MaCSKCB,MaCSKCBBĐ=@MaCSKCBBĐ,SoTheBHYT=@SoTheBHYT,TuNgay=@TuNgay,DenNgay=@DenNgay,HoTen=@HoTen,NgaySinh=@NgaySinh,GioiTinh=@GioiTinh,DiaChi=@DiaChi,MaNoiSinhSong=@MaNoiSinhSong,LyDoVV=@LyDoVV,MaNoiChuyenDen=@MaNoiChuyenDen,NgayDenKham=@NgayDenKham,ChungNhanKhongCTT=@ChungNhanKhongCTT,GhiChu=@GhiChu";
sql += " WHERE SoDKKCBBHYT=@SoDKKCBBHYT";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@SoDKKCBBHYT", SoDKKCBBHYT));
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaCSKCBBĐ", MaCSKCBBĐ));
command.Parameters.Add(new SQLiteParameter("@SoTheBHYT", SoTheBHYT));
command.Parameters.Add(new SQLiteParameter("@TuNgay", TuNgay));
command.Parameters.Add(new SQLiteParameter("@DenNgay", DenNgay));
command.Parameters.Add(new SQLiteParameter("@HoTen", HoTen));
command.Parameters.Add(new SQLiteParameter("@NgaySinh", NgaySinh));
command.Parameters.Add(new SQLiteParameter("@GioiTinh", GioiTinh));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@MaNoiSinhSong", MaNoiSinhSong));
command.Parameters.Add(new SQLiteParameter("@LyDoVV", LyDoVV));
command.Parameters.Add(new SQLiteParameter("@MaNoiChuyenDen", MaNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@NgayDenKham", NgayDenKham));
command.Parameters.Add(new SQLiteParameter("@ChungNhanKhongCTT", ChungNhanKhongCTT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
return result;
}
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += " INSERT INTO DM_VTYT (MaVTYT,TenVTYT,TenHoatChat,DonViTinh,QuyCach,NhaSanXuat,NuocSanXuat,SoDangKy,HanSuDung,SoLuong,DonGiaMua,DonGiaThau,DonGiaCSKCB,MaNhom1,MaNhom2,TrongDanhMucBHYT,VTYTThayThe,VTYTDichVuKTC,TrongThau,Active,Nam,STTBYT,MaVTYTBYT,TenVTYTBYT,GhiChu) ";
sql += " VALUES(@MaVTYT,@TenVTYT,@TenHoatChat,@DonViTinh,@QuyCach,@NhaSanXuat,@NuocSanXuat,@SoDangKy,@HanSuDung,@SoLuong,@DonGiaMua,@DonGiaThau,@DonGiaCSKCB,@MaNhom1,@MaNhom2,@TrongDanhMucBHYT,@VTYTThayThe,@VTYTDichVuKTC,@TrongThau,@Active,@Nam,@STTBYT,@MaVTYTBYT,@TenVTYTBYT,@GhiChu)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaVTYT", MaVTYT));
command.Parameters.Add(new SQLiteParameter("@TenVTYT", TenVTYT));
command.Parameters.Add(new SQLiteParameter("@TenHoatChat", TenHoatChat));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@QuyCach", QuyCach));
command.Parameters.Add(new SQLiteParameter("@NhaSanXuat", NhaSanXuat));
command.Parameters.Add(new SQLiteParameter("@NuocSanXuat", NuocSanXuat));
command.Parameters.Add(new SQLiteParameter("@SoDangKy", SoDangKy));
command.Parameters.Add(new SQLiteParameter("@HanSuDung", HanSuDung));
command.Parameters.Add(new SQLiteParameter("@DonGiaMua", DonGiaMua));
command.Parameters.Add(new SQLiteParameter("@DonGiaThau", DonGiaThau));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@SoLuong", SoLuong));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@TrongThau", TrongThau));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@VTYTThayThe", VTYTThayThe));
command.Parameters.Add(new SQLiteParameter("@VTYTDichVuKTC", VTYTDichVuKTC));
command.Parameters.Add(new SQLiteParameter("@Nam", Nam));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaVTYTBYT", MaVTYTBYT));
command.Parameters.Add(new SQLiteParameter("@TenVTYTBYT", TenVTYTBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_MucHuong (MucHuong, PhanTram, Active) ";
sql += " VALUES(@MucHuong,@PhanTram,@Active)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@PhanTram", PhanTram));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
//Insert trans
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_DichVu (MaDichVu,TenDichVu,MaLoaiDichVu,DonViTinh,DonGiaBHYT,DonGiaCSKCB,MaNhom1,MaNhom2,TrongDanhMucBHYT,Active,DichVuKTC,ThongTu,STTBYT,MaKhac,MaLoaiChiPhi,MaDichVuBYT,GhiChu) ";
sql += " VALUES(@MaDichVu,@TenDichVu,@MaLoaiDichVu,@DonViTinh,@DonGiaBHYT,@DonGiaCSKCB,@MaNhom1,@MaNhom2,@TrongDanhMucBHYT,@Active,@DichVuKTC,@ThongTu,@STTBYT,@MaKhac,@MaLoaiChiPhi,@MaDichVuBYT,@GhiChu)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaDichVu", MaDichVu));
command.Parameters.Add(new SQLiteParameter("@TenDichVu", TenDichVu));
command.Parameters.Add(new SQLiteParameter("@MaLoaiDichVu", MaLoaiDichVu));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@DonGiaBHYT", DonGiaBHYT));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@DichVuKTC", DichVuKTC));
command.Parameters.Add(new SQLiteParameter("@ThongTu", ThongTu));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaKhac", MaKhac));
command.Parameters.Add(new SQLiteParameter("@MaLoaiChiPhi", MaLoaiChiPhi));
command.Parameters.Add(new SQLiteParameter("@MaDichVuBYT", MaDichVuBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_MucHuong ";
sql += "SET MucHuong=@MucHuong,PhanTram=@PhanTram,Active=@Active ";
sql += "WHERE MucHuong=@MucHuong";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@PhanTram", PhanTram));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
/// <summary>
/// Hàm Insert Trans
/// </summary>
/// <param name="DAL"></param>
/// <returns></returns>
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO BangKeChiTiet (BangKe_Id,MaChiPhi,MaPhu,TenChiPhi,DonViTinh,SoLuong,PhanTramDuocHuong,DonGiaBHYT,ThanhTienBHYT,BHYTThanhToan,NguonKhac,NguoiBenhTra,ChiPhiNgoaiDinhSuat,MaNhom1,MaNhom2,MaLoaiChiPhi,VTYTDichVuKTC,DichVuKTC,GhiChu,TyLeThanhToan) ";
sql += "VALUES(@BangKe_Id,@MaChiPhi,@MaPhu,@TenChiPhi,@DonViTinh,@SoLuong,@PhanTramDuocHuong,@DonGiaBHYT,@ThanhTienBHYT,@BHYTThanhToan,@NguonKhac,@NguoiBenhTra,@ChiPhiNgoaiDinhSuat,@MaNhom1,@MaNhom2,@MaLoaiChiPhi,@VTYTDichVuKTC,@DichVuKTC,@GhiChu,@TyLeThanhToan)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
//command.Parameters.Add(new SQLiteParameter("@BangKeChiTiet_Id", );
command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id));
command.Parameters.Add(new SQLiteParameter("@MaChiPhi", MaChiPhi));
command.Parameters.Add(new SQLiteParameter("@MaPhu", MaPhu));
command.Parameters.Add(new SQLiteParameter("@TenChiPhi", TenChiPhi));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@SoLuong", SoLuong));
command.Parameters.Add(new SQLiteParameter("@PhanTramDuocHuong", PhanTramDuocHuong));
command.Parameters.Add(new SQLiteParameter("@DonGiaBHYT", DonGiaBHYT));
command.Parameters.Add(new SQLiteParameter("@ThanhTienBHYT", ThanhTienBHYT));
command.Parameters.Add(new SQLiteParameter("@BHYTThanhToan", BHYTThanhToan));
command.Parameters.Add(new SQLiteParameter("@NguonKhac", NguonKhac));
command.Parameters.Add(new SQLiteParameter("@NguoiBenhTra", NguoiBenhTra));
command.Parameters.Add(new SQLiteParameter("@ChiPhiNgoaiDinhSuat", ChiPhiNgoaiDinhSuat));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@MaLoaiChiPhi", MaLoaiChiPhi));
command.Parameters.Add(new SQLiteParameter("@VTYTDichVuKTC", VTYTDichVuKTC));
command.Parameters.Add(new SQLiteParameter("@DichVuKTC", DichVuKTC));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
command.Parameters.Add(new SQLiteParameter("@TyLeThanhToan", TyLeThanhToan));
int result = command.ExecuteNonQuery();
return result;
}
//Insert Trans
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO DM_CSKCB (MaCSKCB,MaTinh,TenCSKCB,CSKCBBanDau,XepHang,Active,DiaChi,Tuyen,Quy1Quy,CoDuLieu,MaCapTren) ";
sql += " VALUES(@MaCSKCB,@MaTinh,@TenCSKCB,@CSKCBBanDau,@XepHang,@Active,@DiaChi,@Tuyen,@Quy1Quy,@CoDuLieu,@MaCapTren)";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaTinh", MaTinh));
command.Parameters.Add(new SQLiteParameter("@TenCSKCB", TenCSKCB));
command.Parameters.Add(new SQLiteParameter("@CSKCBBanDau", CSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@XepHang", XepHang));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@Tuyen", Tuyen));
command.Parameters.Add(new SQLiteParameter("@Quy1Quy", Quy1Quy));
command.Parameters.Add(new SQLiteParameter("@CoDuLieu", CoDuLieu));
command.Parameters.Add(new SQLiteParameter("@MaCapTren", MaCapTren));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
//SQLiteConnection m_dbConnection = new SQLiteConnection(connectionString);
//m_dbConnection.Open();
string sql = "";
sql += "UPDATE DM_ICD ";
sql += "SET MaICD=@MaICD,TenICD=@TenICD,NgoaiDinhSuat=@NgoaiDinhSuat,Active=@Active ";
sql += "WHERE MaICD=@MaICD";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaICD", MaICD));
command.Parameters.Add(new SQLiteParameter("@TenICD", TenICD));
command.Parameters.Add(new SQLiteParameter("@NgoaiDinhSuat", NgoaiDinhSuat));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
int result = command.ExecuteNonQuery();
//m_dbConnection.Close();
return result;
}
//update trans
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_CSKCB SET MaCSKCB=@MaCSKCB,MaTinh=@MaTinh,TenCSKCB=@TenCSKCB,CSKCBBanDau=@CSKCBBanDau,XepHang=@XepHang,Active=@Active,DiaChi=@DiaChi,Tuyen=@Tuyen,Quy1Quy=@Quy1Quy,CoDuLieu=@CoDuLieu,MaCapTren =@MaCapTren ";
sql += "WHERE MaCSKCB=@MaCSKCB";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaTinh", MaTinh));
command.Parameters.Add(new SQLiteParameter("@TenCSKCB", TenCSKCB));
command.Parameters.Add(new SQLiteParameter("@CSKCBBanDau", CSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@XepHang", XepHang));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@Tuyen", Tuyen));
command.Parameters.Add(new SQLiteParameter("@Quy1Quy", Quy1Quy));
command.Parameters.Add(new SQLiteParameter("@CoDuLieu", CoDuLieu));
command.Parameters.Add(new SQLiteParameter("@MaCapTren", MaCapTren));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_LuongCoSo ";
sql += "SET TuNgay=@TuNgay,LuongCoSo=@LuongCoSo ";
sql += "WHERE LuongCoSo_Id=@LuongCoSo_Id";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@LuongCoSo_Id", LuongCoSo_Id));
command.Parameters.Add(new SQLiteParameter("@TuNgay", TuNgay));
command.Parameters.Add(new SQLiteParameter("@LuongCoSo", LuongCoSo));
int result = command.ExecuteNonQuery();
return result;
}
public int DeleteBangKeChiTiet(int BangKe_Id, SQLiteDAL DAL)
{
string sql = "Delete from BangKeChiTiet WHERE BangKe_Id=@BangKe_Id";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id));
int result = command.ExecuteNonQuery();
return result;
}
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_MucHuongDoiTuong ";
sql += "SET MucHuong=@MucHuong,DoiTuong=@DoiTuong ";
sql += "WHERE MucHuong=@MucHuong";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@DoiTuong", DoiTuong));
int result = command.ExecuteNonQuery();
return result;
}
/// <summary>
/// Hàm Insert Trans
/// </summary>
/// <param name="DAL"></param>
/// <returns></returns>
public int Insert(SQLiteDAL DAL)
{
string sql = "";
sql += "INSERT INTO BangKe (LoaiBangKe,SoHoSo,Khoa,MaKhamChuaBenh,MaNguoiBenh,HoTen,GioiTinh,NgaySinh,NamSinh,DiaChi,MaNoiSinhSong,SoTheBHYT,TuNgayBH,DenNgayBH,CoBHYT,TreEmKhongTheBHYT,MucHuong,PhanTramDuocHuong,MaCSKCBBanDau,TenCSKCBBanDau,MaCSKCB,MaChiNhanh,MaNoiChuyenDen,TenNoiChuyenDen,NgayDenKham,NgayKetThuc,SoNgayDieuTri,NgayQuyetToan,TuyenKhamBenh,ChanDoan,BenhKhac,MaICD,TongChiPhi,BHYTThanhToan,NguoiBenhTra,NguonKhac,SoTienThanhToanToiDa,TienKham,TienGiuong,TienXN,TienCDHA,TienTDCN,TienPTTT,TienDichVuKTC,TienMau,TienThuoc,TienVTYT,TienVTYTTH,TienVTYTTT,TienVanChuyen,DVKTC_TinhToan,DVKTC_ThanhToan,ChiPhiNgoaiDinhSuat,DaGuiBHYT,NgayGuiBHYT,NguoiGuiBHYT,NgayTao,NguoiTao,NgayCapNhat,NguoiCapNhat,ChungNhanKhongCCT,BangKe_Id_BHXH) ";
sql += "VALUES(@LoaiBangKe,@SoHoSo,@Khoa,@MaKhamChuaBenh,@MaNguoiBenh,@HoTen,@GioiTinh,@NgaySinh,@NamSinh,@DiaChi,@MaNoiSinhSong,@SoTheBHYT,@TuNgayBH,@DenNgayBH,@CoBHYT,@TreEmKhongTheBHYT,@MucHuong,@PhanTramDuocHuong,@MaCSKCBBanDau,@TenCSKCBBanDau,@MaCSKCB,@MaChiNhanh,@MaNoiChuyenDen,@TenNoiChuyenDen,@NgayDenKham,@NgayKetThuc,@SoNgayDieuTri,@NgayQuyetToan,@TuyenKhamBenh,@ChanDoan,@BenhKhac,@MaICD,@TongChiPhi,@BHYTThanhToan,@NguoiBenhTra,@NguonKhac,@SoTienThanhToanToiDa,@TienKham,@TienGiuong,@TienXN,@TienCDHA,@TienTDCN,@TienPTTT,@TienDichVuKTC,@TienMau,@TienThuoc,@TienVTYT,@TienVTYTTH,@TienVTYTTT,@TienVanChuyen,@DVKTC_TinhToan,@DVKTC_ThanhToan,@ChiPhiNgoaiDinhSuat,@DaGuiBHYT,@NgayGuiBHYT,@NguoiGuiBHYT,@NgayTao,@NguoiTao,@NgayCapNhat,@NguoiCapNhat,@ChungNhanKhongCCT,@BangKe_Id_BHXH);";
sql += " SELECT last_insert_rowid(); ";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
//command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id));
command.Parameters.Add(new SQLiteParameter("@LoaiBangKe", LoaiBangKe));
command.Parameters.Add(new SQLiteParameter("@SoHoSo", SoHoSo));
command.Parameters.Add(new SQLiteParameter("@Khoa", Khoa));
command.Parameters.Add(new SQLiteParameter("@MaKhamChuaBenh", MaKhamChuaBenh));
command.Parameters.Add(new SQLiteParameter("@MaNguoiBenh", MaNguoiBenh));
command.Parameters.Add(new SQLiteParameter("@HoTen", HoTen));
command.Parameters.Add(new SQLiteParameter("@GioiTinh", GioiTinh));
command.Parameters.Add(new SQLiteParameter("@NgaySinh", NgaySinh));
command.Parameters.Add(new SQLiteParameter("@NamSinh", NamSinh));
command.Parameters.Add(new SQLiteParameter("@DiaChi", DiaChi));
command.Parameters.Add(new SQLiteParameter("@MaNoiSinhSong", MaNoiSinhSong));
command.Parameters.Add(new SQLiteParameter("@SoTheBHYT", SoTheBHYT));
command.Parameters.Add(new SQLiteParameter("@TuNgayBH", TuNgayBH));
command.Parameters.Add(new SQLiteParameter("@DenNgayBH", DenNgayBH));
command.Parameters.Add(new SQLiteParameter("@CoBHYT", CoBHYT));
command.Parameters.Add(new SQLiteParameter("@TreEmKhongTheBHYT", TreEmKhongTheBHYT));
command.Parameters.Add(new SQLiteParameter("@MucHuong", MucHuong));
command.Parameters.Add(new SQLiteParameter("@PhanTramDuocHuong", PhanTramDuocHuong));
command.Parameters.Add(new SQLiteParameter("@MaCSKCBBanDau", MaCSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@TenCSKCBBanDau", TenCSKCBBanDau));
command.Parameters.Add(new SQLiteParameter("@MaCSKCB", MaCSKCB));
command.Parameters.Add(new SQLiteParameter("@MaChiNhanh", MaChiNhanh));
command.Parameters.Add(new SQLiteParameter("@MaNoiChuyenDen", MaNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@TenNoiChuyenDen", TenNoiChuyenDen));
command.Parameters.Add(new SQLiteParameter("@NgayDenKham", NgayDenKham));
command.Parameters.Add(new SQLiteParameter("@NgayKetThuc", NgayKetThuc));
command.Parameters.Add(new SQLiteParameter("@SoNgayDieuTri", SoNgayDieuTri));
command.Parameters.Add(new SQLiteParameter("@NgayQuyetToan", NgayQuyetToan));
command.Parameters.Add(new SQLiteParameter("@TuyenKhamBenh", TuyenKhamBenh));
command.Parameters.Add(new SQLiteParameter("@ChanDoan", ChanDoan));
command.Parameters.Add(new SQLiteParameter("@BenhKhac", BenhKhac));
command.Parameters.Add(new SQLiteParameter("@MaICD", MaICD));
command.Parameters.Add(new SQLiteParameter("@TongChiPhi", TongChiPhi));
command.Parameters.Add(new SQLiteParameter("@BHYTThanhToan", BHYTThanhToan));
command.Parameters.Add(new SQLiteParameter("@NguoiBenhTra", NguoiBenhTra));
command.Parameters.Add(new SQLiteParameter("@NguonKhac", NguonKhac));
command.Parameters.Add(new SQLiteParameter("@SoTienThanhToanToiDa", SoTienThanhToanToiDa));
command.Parameters.Add(new SQLiteParameter("@TienKham", TienKham));
command.Parameters.Add(new SQLiteParameter("@TienGiuong", TienGiuong));
command.Parameters.Add(new SQLiteParameter("@TienXN", TienXN));
command.Parameters.Add(new SQLiteParameter("@TienCDHA", TienCDHA));
command.Parameters.Add(new SQLiteParameter("@TienTDCN", TienTDCN));
command.Parameters.Add(new SQLiteParameter("@TienPTTT", TienPTTT));
command.Parameters.Add(new SQLiteParameter("@TienDichVuKTC", TienDichVuKTC));
command.Parameters.Add(new SQLiteParameter("@TienMau", TienMau));
command.Parameters.Add(new SQLiteParameter("@TienThuoc", TienThuoc));
command.Parameters.Add(new SQLiteParameter("@TienVTYT", TienVTYT));
command.Parameters.Add(new SQLiteParameter("@TienVTYTTH", TienVTYTTH));
command.Parameters.Add(new SQLiteParameter("@TienVTYTTT", TienVTYTTT));
command.Parameters.Add(new SQLiteParameter("@TienVanChuyen", TienVanChuyen));
command.Parameters.Add(new SQLiteParameter("@DVKTC_TinhToan", DVKTC_TinhToan));
command.Parameters.Add(new SQLiteParameter("@DVKTC_ThanhToan", DVKTC_ThanhToan));
command.Parameters.Add(new SQLiteParameter("@ChiPhiNgoaiDinhSuat", ChiPhiNgoaiDinhSuat));
command.Parameters.Add(new SQLiteParameter("@DaGuiBHYT", DaGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NgayGuiBHYT", NgayGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NguoiGuiBHYT", NguoiGuiBHYT));
command.Parameters.Add(new SQLiteParameter("@NgayTao", NgayTao));
command.Parameters.Add(new SQLiteParameter("@NguoiTao", NguoiTao));
command.Parameters.Add(new SQLiteParameter("@NgayCapNhat", NgayCapNhat));
command.Parameters.Add(new SQLiteParameter("@NguoiCapNhat", NguoiCapNhat));
command.Parameters.Add(new SQLiteParameter("@ChungNhanKhongCCT", ChungNhanKhongCCT));
command.Parameters.Add(new SQLiteParameter("@BangKe_Id_BHXH", BangKe_Id_BHXH));
int result = int.Parse(command.ExecuteScalar().ToString());
return result;
}
/// <summary>
/// Ham update Trans
/// </summary>
/// <param name="DAL"></param>
/// <returns></returns>
public int Update(SQLiteDAL DAL)
{
string sql = "";
sql += "UPDATE DM_Thuoc ";
sql += "SET MaThuoc=@MaThuoc,TenThuoc=@TenThuoc,TenHoatChat=@TenHoatChat,DonViTinh=@DonViTinh,";
sql += "QuyCach=@QuyCach,NhaSanXuat=@NhaSanXuat,NuocSanXuat=@NuocSanXuat,SoDangKy=@SoDangKy,HanSuDung=@HanSuDung,NongDo=@NongDo,DangBaoChe=@DangBaoChe,TieuChuan=@TieuChuan,NhomThuoc=@NhomThuoc,";
sql += "DonGiaMua=@DonGiaMua,DonGiaThau=@DonGiaThau,DonGiaCSKCB=@DonGiaCSKCB,SoLuong=@SoLuong,MaNhom1=@MaNhom1,MaNhom2=@MaNhom2,";
sql += "TrongDanhMucBHYT=@TrongDanhMucBHYT,TrongThau=@TrongThau,Active=@Active,ThuocDieuTriK=@ThuocDieuTriK,TyLeThanhToan=@TyLeThanhToan,MaNhaThau=@MaNhaThau,Nam=@Nam,STTBYT=@STTBYT,MaThuocBYT=@MaThuocBYT,MaThuocBYT2=@MaThuocBYT2,TenThuocBYT=@TenThuocBYT,GhiChu=@GhiChu,HanSuDung_Str=@HanSuDung_Str ";
sql += "WHERE MaThuoc=@MaThuoc";
SQLiteCommand command = new SQLiteCommand(sql, DAL.m_conn);
command.Transaction = DAL.m_trans;
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@Thuoc_Id", Thuoc_Id));
command.Parameters.Add(new SQLiteParameter("@MaThuoc", MaThuoc));
command.Parameters.Add(new SQLiteParameter("@TenThuoc", TenThuoc));
command.Parameters.Add(new SQLiteParameter("@TenHoatChat", TenHoatChat));
command.Parameters.Add(new SQLiteParameter("@DonViTinh", DonViTinh));
command.Parameters.Add(new SQLiteParameter("@QuyCach", QuyCach));
command.Parameters.Add(new SQLiteParameter("@NhaSanXuat", NhaSanXuat));
command.Parameters.Add(new SQLiteParameter("@NuocSanXuat", NuocSanXuat));
command.Parameters.Add(new SQLiteParameter("@SoDangKy", SoDangKy));
command.Parameters.Add(new SQLiteParameter("@HanSuDung", HanSuDung));
command.Parameters.Add(new SQLiteParameter("@NongDo", NongDo));
command.Parameters.Add(new SQLiteParameter("@DangBaoChe", DangBaoChe));
command.Parameters.Add(new SQLiteParameter("@TieuChuan", TieuChuan));
command.Parameters.Add(new SQLiteParameter("@NhomThuoc", NhomThuoc));
command.Parameters.Add(new SQLiteParameter("@DonGiaMua", DonGiaMua));
command.Parameters.Add(new SQLiteParameter("@DonGiaThau", DonGiaThau));
command.Parameters.Add(new SQLiteParameter("@DonGiaCSKCB", DonGiaCSKCB));
command.Parameters.Add(new SQLiteParameter("@SoLuong", SoLuong));
command.Parameters.Add(new SQLiteParameter("@MaNhom1", MaNhom1));
command.Parameters.Add(new SQLiteParameter("@MaNhom2", MaNhom2));
command.Parameters.Add(new SQLiteParameter("@TrongDanhMucBHYT", TrongDanhMucBHYT));
command.Parameters.Add(new SQLiteParameter("@TrongThau", TrongThau));
command.Parameters.Add(new SQLiteParameter("@Active", Active));
command.Parameters.Add(new SQLiteParameter("@ThuocDieuTriK", ThuocDieuTriK));
command.Parameters.Add(new SQLiteParameter("@TyLeThanhToan", TyLeThanhToan));
command.Parameters.Add(new SQLiteParameter("@MaNhaThau", MaNhaThau));
command.Parameters.Add(new SQLiteParameter("@Nam", Nam));
command.Parameters.Add(new SQLiteParameter("@STTBYT", STTBYT));
command.Parameters.Add(new SQLiteParameter("@MaThuocBYT", MaThuocBYT));
command.Parameters.Add(new SQLiteParameter("@MaThuocBYT2", MaThuocBYT2));
command.Parameters.Add(new SQLiteParameter("@TenThuocBYT", TenThuocBYT));
command.Parameters.Add(new SQLiteParameter("@GhiChu", GhiChu));
command.Parameters.Add(new SQLiteParameter("@HanSuDung_Str", HanSuDung_Str));
int result = command.ExecuteNonQuery();
return result;
}
public virtual int XuLyTuWSSangCSDL(object obj, DataTable tb, SQLiteDAL DAL)
{
return 0;
}
