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; }