本文整理汇总了C#中System.Data.Select.ExecuteSingle方法的典型用法代码示例。如果您正苦于以下问题:C# Select.ExecuteSingle方法的具体用法?C# Select.ExecuteSingle怎么用?C# Select.ExecuteSingle使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Select
的用法示例。
在下文中一共展示了Select.ExecuteSingle方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BindData
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
objLuotkham = sqlQuery.ExecuteSingle<KcbLuotkham>();
if (objLuotkham != null)
{
txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham);
txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru);
if (objLDepartment != null)
{
txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text =objPatientInfo.GioiTinh;// Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ";
}
NoitruPhanbuonggiuong objPhanbuonggiuong = noitru_nhapvien.LaythongtinBuonggiuongHtai(objLuotkham);
if (objPhanbuonggiuong != null)
{
dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa;
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong);
if (objRoom != null)
{
txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong);
txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong);
}
NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objNoitruDmucGiuongbenh != null)
{
txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong);
txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong);
}
}
DataTable dtGia = new dmucgiagiuong_busrule().dsGetList("-1").Tables[0];
dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," + NoitruGiabuonggiuong.Columns.TenGia;
txtGia.Init(dtGia, new System.Collections.Generic.List<string>() { NoitruGiabuonggiuong.Columns.IdGia, NoitruGiabuonggiuong.Columns.MaGia, NoitruGiabuonggiuong.Columns.TenGia });
m_dtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text));
Utility.SetDataSourceForDataGridEx_Basic(grdBuong, m_dtDataRoom, true, true, "1=1", "sluong_giuong_trong desc,ten_buong");
if (grdBuong.DataSource != null)
{
grdBuong.MoveFirst();
}
}
}
}
示例2: GetSysColor
/// <summary>
/// hàm thực hiện việc lấy màu của hệ thống
/// </summary>
/// <returns></returns>
public static string GetSysColor()
{
SqlQuery q = new Select().From(SysFormColor.Schema)
.Where(SysFormColor.Columns.SystemColorId).IsEqualTo(1);
string SysColor = "";
SysFormColor objSystemParameter = q.ExecuteSingle<SysFormColor>();
if (objSystemParameter != null)
{
SysColor = Utility.sDbnull(objSystemParameter.ColorValue);
}
return SysColor;
}
示例3: CreateManagementUnit
public static void CreateManagementUnit()
{
SqlQuery q = new Select().From(SysManagementUnit.Schema);
var objManagementUnit = q.ExecuteSingle<SysManagementUnit>();
if (objManagementUnit != null)
{
globalVariables.ParentBranch_Name = objManagementUnit.SParentBranchName;
globalVariables.Branch_Name = objManagementUnit.SName;
globalVariables.Branch_Phone = objManagementUnit.SPhone;
globalVariables.Branch_Address = objManagementUnit.SAddress;
}
}
示例4: LayThongTinGia
public static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam)
{
objPhanbuonggiuong.TuTuc = 0;
SqlQuery sqlQuery = new Select().From<NoitruQheDoituongBuonggiuong>()
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong)
.And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb);
NoitruQheDoituongBuonggiuong objRoomBedObjectType = sqlQuery.ExecuteSingle<NoitruQheDoituongBuonggiuong>();
if (objRoomBedObjectType != null)
{
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objRoomBedObjectType.DonGia);
objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuTraituyen);
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
{
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.KieuThue = "GIUONG";
}
}
else
{
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objLBed != null)
{
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0);
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.KieuThue = "GIUONG";
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
if (!THU_VIEN_CHUNG.IsBaoHiem( objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
}
}
objPhanbuonggiuong.TrongGoi = 0;// Utility.ByteDbnull(objPhanbuonggiuong.TrongGoi);
if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0)//Có giường thì mới tính
TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong,objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc));
}
示例5: XuLyChiKhauDacBietBHYT
public void XuLyChiKhauDacBietBHYT(KcbLuotkham objLuotkham, decimal v_DiscountRate)
{
KcbThanhtoanCollection paymentCollection =
new KcbThanhtoanController().FetchByQuery(
KcbThanhtoan.CreateQuery().AddWhere(KcbThanhtoan.Columns.MaLuotkham, Comparison.Equals,
objLuotkham.MaLuotkham).AND(KcbThanhtoan.Columns.IdBenhnhan,
Comparison.Equals,
objLuotkham.IdBenhnhan));
foreach (KcbThanhtoan payment in paymentCollection)
{
KcbThanhtoanChitietCollection paymentDetailCollection =
new KcbThanhtoanChitietController().FetchByQuery(
KcbThanhtoanChitiet.CreateQuery().AddWhere(KcbThanhtoanChitiet.Columns.IdThanhtoan,
Comparison.Equals, payment.IdThanhtoan).AND(
KcbThanhtoanChitiet.Columns.TuTuc,
Comparison.Equals, 0));
string IsDungTuyen = "DT";
DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objLuotkham.IdDoituongKcb);
if (objectType != null)
{
switch (objectType.MaDoituongKcb)
{
case "BHYT":
if (Utility.Int32Dbnull(objLuotkham.DungTuyen, "0") == 1) IsDungTuyen = "DT";
else
{
IsDungTuyen = "TT";
}
break;
default:
IsDungTuyen = "KHAC";
break;
}
}
foreach (KcbThanhtoanChitiet PaymentDetail in paymentDetailCollection)
{
SqlQuery sqlQuery = new Select().From(DmucBhytChitraDacbiet.Schema)
.Where(DmucBhytChitraDacbiet.Columns.IdDichvuChitiet).IsEqualTo(PaymentDetail.IdChitietdichvu)
.And(DmucBhytChitraDacbiet.Columns.MaLoaithanhtoan).IsEqualTo(PaymentDetail.IdLoaithanhtoan)
.And(DmucBhytChitraDacbiet.Columns.DungtuyenTraituyen).IsEqualTo(IsDungTuyen)
.And(DmucBhytChitraDacbiet.Columns.MaDoituongKcb).IsEqualTo(objLuotkham.MaDoituongKcb);
DmucBhytChitraDacbiet objDetailDiscountRate = sqlQuery.ExecuteSingle<DmucBhytChitraDacbiet>();
if (objDetailDiscountRate != null)
{
log.Info("Neu trong ton tai trong bang cau hinh chi tiet chiet khau void Id_Chitiet=" + PaymentDetail.IdChitiet);
PaymentDetail.PtramBhyt = objDetailDiscountRate.TileGiam;
PaymentDetail.BhytChitra = THU_VIEN_CHUNG.TinhBhytChitra(objDetailDiscountRate.TileGiam,
Utility.DecimaltoDbnull(
PaymentDetail.DonGia, 0));
PaymentDetail.BnhanChitra = THU_VIEN_CHUNG.TinhBnhanChitra(objDetailDiscountRate.TileGiam,
Utility.DecimaltoDbnull(
PaymentDetail.DonGia, 0));
}
else
{
PaymentDetail.PtramBhyt = v_DiscountRate;
PaymentDetail.BhytChitra = THU_VIEN_CHUNG.TinhBhytChitra(v_DiscountRate,
Utility.DecimaltoDbnull(
PaymentDetail.DonGia, 0));
PaymentDetail.BnhanChitra = THU_VIEN_CHUNG.TinhBnhanChitra(v_DiscountRate,
Utility.DecimaltoDbnull(
PaymentDetail.DonGia, 0));
}
log.Info("Thuc hien viec cap nhap thong tin lai gia can phai xem lại gia truoc khi thanh toan");
}
}
}
示例6: LayThongTinGia
public static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam)
{
objPhanbuonggiuong.TuTuc = 0;
NoitruGiabuonggiuong objGia=NoitruGiabuonggiuong.FetchByID(objPhanbuonggiuong.IdGia);
if (THU_VIEN_CHUNG.Laygiatrithamsohethong("NOITRU_APGIABUONGGIUONG_THEODANHMUCGIA", "0", true) == "0")
objGia = null;
NoitruDmucGiuongbenh objGiuong = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if(objGia!=null)
{
objPhanbuonggiuong.DonGia = (objPatientExam.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(objGia.GiaDichvu) : (objPatientExam.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(objGia.GiaBhyt) : Utility.DecimaltoDbnull(objGia.GiaKhac)));
objPhanbuonggiuong.PhuThu = (objPatientExam.MaDoituongKcb == "BHYT" ? (Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objGia.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objGia.PhuthuTraituyen)) : 0);
objPhanbuonggiuong.TuTuc = objGiuong.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objGiuong.TenGiuong);
objPhanbuonggiuong.GiaGoc = objPhanbuonggiuong.DonGia;
objPhanbuonggiuong.KieuThue = "GIUONG";
}
else if (objGiuong != null)
{
objPhanbuonggiuong.DonGia = (objPatientExam.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(objGiuong.GiaDichvu) : (objPatientExam.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(objGiuong.GiaBhyt) : Utility.DecimaltoDbnull(objGiuong.GiaKhac)));
objPhanbuonggiuong.PhuThu =(objPatientExam.MaDoituongKcb == "BHYT"? (Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objGiuong.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objGiuong.PhuthuTraituyen)):0);
objPhanbuonggiuong.TuTuc = objGiuong.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objGiuong.TenGiuong);
objPhanbuonggiuong.GiaGoc = objPhanbuonggiuong.DonGia;
objPhanbuonggiuong.KieuThue = "GIUONG";
}
else//Tìm vào các bảng quan hệ
{
SqlQuery sqlQuery = new Select().From<NoitruQheDoituongBuonggiuong>()
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong)
.And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb);
NoitruQheDoituongBuonggiuong objQhe = sqlQuery.ExecuteSingle<NoitruQheDoituongBuonggiuong>();
if (objQhe != null)
{
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objQhe.DonGia);
objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objQhe.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objQhe.PhuthuTraituyen);
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
{
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
objPhanbuonggiuong.KieuThue = "GIUONG";
}
}
else
{
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objLBed != null)
{
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0);
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.KieuThue = "GIUONG";
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
}
}
}
if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
objPhanbuonggiuong.TrongGoi = 0;
if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0)//Có giường thì mới tính
TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong,objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc));
}
示例7: UpdateLanKham
public ActionResult UpdateLanKham(KcbDanhsachBenhnhan objPatientInfo, KcbLuotkham objLuotkham, KcbDangkyKcb objRegExam, int KieuKham, decimal PtramBhytCu, decimal PtramBhytgoc )
{
ActionResult _ActionResult = ActionResult.Success;
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
SqlQuery query =
new Select().From(KcbLuotkham.Schema).Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(
objLuotkham.MaLuotkham).And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
objLuotkham.IdBenhnhan);
KcbLuotkham objExam = query.ExecuteSingle<KcbLuotkham>();
UpdatePatientInfo(objPatientInfo);
//decimal PtramBHYT = THU_VIEN_CHUNG.TinhPtramBHYT(objLuotkham);
//if (PtramBHYT != Utility.DecimaltoDbnull(objLuotkham.PtramBhyt))
//{
// objLuotkham.PtramBhyt = PtramBHYT;
//}
objLuotkham.MarkOld();
objLuotkham.IsNew = false;
objLuotkham.Save();
//int recordExam = new Update(KcbLuotkham.Schema)
// .Set(KcbLuotkham.Columns.NguoiLienhe).EqualTo(objLuotkham.NguoiLienhe)
// .Set(KcbLuotkham.Columns.TrangthaiCapcuu).EqualTo(objLuotkham.TrangthaiCapcuu)
// .Set(KcbLuotkham.Columns.LuongCoban).EqualTo(objLuotkham.LuongCoban)
// .Set(KcbLuotkham.Columns.TthaiChuyendi).EqualTo(objLuotkham.TthaiChuyendi)
// .Set(KcbLuotkham.Columns.DienthoaiLienhe).EqualTo(objLuotkham.DienthoaiLienhe)
// .Set(KcbLuotkham.Columns.DiachiLienhe).EqualTo(objLuotkham.DiachiLienhe)
// .Set(KcbLuotkham.Columns.TrieuChung).EqualTo(objLuotkham.TrieuChung)
// .Set(KcbLuotkham.Columns.MatheBhyt).EqualTo(objLuotkham.MatheBhyt)
// .Set(KcbLuotkham.Columns.MaNoicapBhyt).EqualTo(objLuotkham.MaNoicapBhyt)
// .Set(KcbLuotkham.Columns.MaQuyenloi).EqualTo(objLuotkham.MaQuyenloi)
// .Set(KcbLuotkham.Columns.NgaybatdauBhyt).EqualTo(objLuotkham.NgaybatdauBhyt)
// .Set(KcbLuotkham.Columns.NgayketthucBhyt).EqualTo(objLuotkham.NgayketthucBhyt)
// .Set(KcbLuotkham.Columns.NoicapBhyt).EqualTo(objLuotkham.NoicapBhyt)
// .Set(KcbLuotkham.Columns.IdDoituongKcb).EqualTo(objLuotkham.IdDoituongKcb)
// .Set(KcbLuotkham.Columns.IdLoaidoituongKcb).EqualTo(objLuotkham.IdLoaidoituongKcb)
// .Set(KcbLuotkham.Columns.TrangthaiNgoaitru).EqualTo(objLuotkham.TrangthaiNgoaitru)
// .Set(KcbLuotkham.Columns.MaKcbbd).EqualTo(objLuotkham.MaKcbbd)
// .Set(KcbLuotkham.Columns.NoiDongtrusoKcbbd).EqualTo(objLuotkham.NoiDongtrusoKcbbd)
// .Set(KcbLuotkham.Columns.MaDoituongBhyt).EqualTo(objLuotkham.MaDoituongBhyt)
// .Set(KcbLuotkham.Columns.IdKhoatiepnhan).EqualTo(objLuotkham.IdKhoatiepnhan)
// .Set(KcbLuotkham.Columns.DungTuyen).EqualTo(objLuotkham.DungTuyen)
// .Set(KcbLuotkham.Columns.NgayTiepdon).EqualTo(objLuotkham.NgayTiepdon)
// .Set(KcbLuotkham.Columns.MaDoituongKcb).EqualTo(objLuotkham.MaDoituongKcb)
// .Set(KcbLuotkham.Columns.MaKhoaThuchien).EqualTo(objLuotkham.MaKhoaThuchien)
// .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
// .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
// .Set(KcbLuotkham.Columns.PtramBhyt).EqualTo(objLuotkham.PtramBhyt)
// .Set(KcbLuotkham.Columns.SoBenhAn).EqualTo(objLuotkham.SoBenhAn)
// .Set(KcbLuotkham.Columns.DiaChi).EqualTo(objLuotkham.DiaChi)
// .Set(KcbLuotkham.Columns.DiachiBhyt).EqualTo(objLuotkham.DiachiBhyt)
// .Set(KcbLuotkham.Columns.Cmt).EqualTo(objLuotkham.Cmt)
// .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
// .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
// .Execute();
//Kiểm tra nếu % bị thay đổi thì cập nhật lại tất cả các bảng
if (PtramBhytCu != Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) || PtramBhytgoc != Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0))
_ActionResult= THU_VIEN_CHUNG.UpdatePtramBHYT(objLuotkham, -1);
if (_ActionResult == ActionResult.Cancel)//Báo không cho phép thay đổi phần trăm BHYT do đã có dịch vụ đã thanh toán
{
return _ActionResult;
}
if (objRegExam != null)
{
objRegExam.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objRegExam.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
AddRegExam(objRegExam,objLuotkham, false, KieuKham);
}
scope.Complete();
return ActionResult.Success;
}
}
}
catch (Exception ex)
{
log.Error("Loi trong qua trinh update thong tin benh nhan {0}", ex);
return ActionResult.Error;
}
}
示例8: GetDepartmentID
public static short GetDepartmentID(string sUserName)
{
short vDepartment_Id = -1;
try
{
SqlQuery sqlQuery = new Select().From(LStaff.Schema).Where(LStaff.Columns.Uid).IsEqualTo(sUserName);
LStaff objStaff = sqlQuery.ExecuteSingle<LStaff>();
if (objStaff != null)
{
vDepartment_Id = objStaff.DepartmentId;
}
}
catch (Exception ex)
{
vDepartment_Id = -1;
}
return vDepartment_Id;
}
示例9: SaveQheDoituongDichvuCSL
private void SaveQheDoituongDichvuCSL()
{
try
{
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdList.GetRows())
{
SqlQuery q =
new Select().From(QheDoituongThuoc.Schema).Where(QheDoituongThuoc.Columns.IdThuoc).
IsEqualTo(Utility.DecimaltoDbnull(gridExRow.Cells[QheDoituongThuoc.Columns.IdThuoc].Value, -1)).And(
QheDoituongThuoc.Columns.IdLoaidoituongKcb).IsEqualTo(
Utility.Int32Dbnull(gridExRow.Cells[DmucDoituongkcb.Columns.IdLoaidoituongKcb].Value, -1));
if (q.GetRecordCount() > 0)
{
new Update(QheDoituongThuoc.Schema)
.Set(QheDoituongThuoc.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(QheDoituongThuoc.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(QheDoituongThuoc.Columns.IdLoaithuoc).EqualTo(
Utility.Int32Dbnull(gridExRow.Cells[QheDoituongThuoc.Columns.IdLoaithuoc].Value, -1))
.Set(QheDoituongThuoc.Columns.DonGia).EqualTo(
Utility.DecimaltoDbnull(gridExRow.Cells[QheDoituongThuoc.Columns.DonGia].Value, 0))
.Set(QheDoituongThuoc.Columns.PhuthuDungtuyen).EqualTo(
Utility.DecimaltoDbnull(gridExRow.Cells[QheDoituongThuoc.Columns.PhuthuDungtuyen].Value, 0))
.Set(QheDoituongThuoc.Columns.PhuthuTraituyen).EqualTo(
Utility.DecimaltoDbnull(gridExRow.Cells[QheDoituongThuoc.Columns.PhuthuTraituyen].Value, 0))
.Set(QheDoituongThuoc.Columns.MaKhoaThuchien).EqualTo(Utility.sDbnull(cboKhoaTH.SelectedValue, ""))
.Where(QheDoituongThuoc.Columns.IdThuoc).IsEqualTo(id_thuoc)
.And(QheDoituongThuoc.Columns.IdLoaidoituongKcb).IsEqualTo(
Utility.Int32Dbnull(gridExRow.Cells[DmucDoituongkcb.Columns.IdLoaidoituongKcb].Value, -1)).Execute();
}
else
{
new QheDoituongThuocController().Insert(-1,
Utility.Int16Dbnull(
gridExRow.Cells[QheDoituongThuoc.Columns.IdLoaithuoc].Value, -1),
Utility.Int32Dbnull(
gridExRow.Cells[QheDoituongThuoc.Columns.IdThuoc].Value, -1),
0,"%",
Utility.DecimaltoDbnull(
gridExRow.Cells[QheDoituongThuoc.Columns.DonGia].Value, 0),
Utility.DecimaltoDbnull(
gridExRow.Cells[QheDoituongThuoc.Columns.PhuthuDungtuyen].Value, 0),
Utility.Int32Dbnull(
gridExRow.Cells[DmucDoituongkcb.Columns.IdLoaidoituongKcb].Value, -1),
Utility.DecimaltoDbnull(
gridExRow.Cells[QheDoituongThuoc.Columns.PhuthuTraituyen].Value, 0), "", globalVariables.UserName, globalVariables.SysDate, null, null, Utility.sDbnull(cboKhoaTH.SelectedValue, ""));
}
SqlQuery sqlQuery = new Select().From(DmucDoituongkcb.Schema)
.Where(DmucDoituongkcb.Columns.IdLoaidoituongKcb).IsEqualTo(1);
DmucDoituongkcb objectType = sqlQuery.ExecuteSingle<DmucDoituongkcb>();
if (objectType != null && objectType.MaDoituongKcb == "DV")
{
new Update(DmucThuoc.Schema)
.Set(DmucThuoc.Columns.DonGia)
.EqualTo(Utility.DecimaltoDbnull(gridExRow.Cells[QheDoituongThuoc.Columns.DonGia].Value, 0))
.Where(DmucThuoc.Columns.IdThuoc)
.IsEqualTo(Utility.Int32Dbnull(gridExRow.Cells[QheDoituongThuoc.Columns.IdThuoc].Value, -1)).Execute();
}
}
Utility.ShowMsg("Bạn thực hiện cập nhập giá thành công", "Thông báo");
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi trong quá trình cập nhập thông tin", "Thông báo lỗi", MessageBoxIcon.Error);
}
}
示例10: GetSysParamater
/// <summary>
/// hàm thực hiện lấy tham số hệ thống
/// </summary>
/// <param name="sName"></param>
/// <returns></returns>
public static SysSystemParameter GetSysParamater(string sName)
{
SqlQuery sqlQuery = new Select().From(SysSystemParameter.Schema)
.Where(SysSystemParameter.Columns.SName).IsEqualTo(sName);
SysSystemParameter objParameter = sqlQuery.ExecuteSingle<SysSystemParameter>();
return objParameter;
}
示例11: GetLuongCoBan
/// <summary>
/// hàm thực hiện lấy thông tin của lương cơ bản
/// </summary>
/// <returns></returns>
public static decimal GetLuongCoBan()
{
decimal BASICSALARY = 83000;
SqlQuery q = new Select().From(SysSystemParameter.Schema)
.Where(SysSystemParameter.Columns.SName).IsEqualTo("BASICSALARY");
SysSystemParameter objSysSystemParameter = q.ExecuteSingle<SysSystemParameter>();
if (objSysSystemParameter != null)
{
BASICSALARY = Utility.DecimaltoDbnull(objSysSystemParameter.SValue, 0);
}
return BASICSALARY;
}
示例12: LayThongTinGoiNgoaiTru
public static TThongtinGoiDvuBnhan LayThongTinGoiNgoaiTru(TPatientExam objPatientExam)
{
SqlQuery sqlQuery = new Select().From(TThongtinGoiDvuBnhan.Schema)
.Where(TThongtinGoiDvuBnhan.Columns.PatientCode).IsEqualTo(objPatientExam.PatientCode)
.And(TThongtinGoiDvuBnhan.Columns.PatientId).IsEqualTo(objPatientExam.PatientId)
.And(TThongtinGoiDvuBnhan.Columns.NoiTru).IsEqualTo(0);
TThongtinGoiDvuBnhan objThongtinGoiDvuBnhan = sqlQuery.ExecuteSingle<TThongtinGoiDvuBnhan>();
return objThongtinGoiDvuBnhan;
}
示例13: KiemTraDaInPhoiBHYT
private void KiemTraDaInPhoiBHYT()
{
try
{
SqlQuery sqlQuery = new Select().From(KcbPhieuDct.Schema)
.Where(KcbPhieuDct.Columns.MaLuotkham).IsEqualTo(Utility.sDbnull(txtPatient_Code.Text))
.And(KcbPhieuDct.Columns.IdBenhnhan).IsEqualTo(Utility.Int32Dbnull(txtPatient_ID.Text))
.And(KcbPhieuDct.Columns.LoaiThanhtoan).IsEqualTo(Utility.Int32Dbnull(KieuThanhToan.NgoaiTru));
if (sqlQuery.GetRecordCount() > 0)
{
pnlSuangayinphoi.Visible = true;
var objPhieuDct = sqlQuery.ExecuteSingle<KcbPhieuDct>();
if (objPhieuDct != null)
{
dtNgayInPhoi.Value = Convert.ToDateTime(objPhieuDct.NgayTao);
cmdHuyInPhoiBHYT.Enabled = true;
cmdCapnhatngayinphoiBHYT.Enabled = true;
lblMessage.Visible = true;
lblMessage.BackColor = getColorMessage;
Utility.SetMsg(lblMessage,
string.Format("Đã in phôi bởi {0}, vào lúc: {1}", objPhieuDct.NguoiTao,
objPhieuDct.NgayTao), false);
}
}
else
{
pnlSuangayinphoi.Visible = false;
dtNgayInPhoi.Value = globalVariables.SysDate;
cmdHuyInPhoiBHYT.Enabled = false;
dtNgayInPhoi.Enabled = true;
cmdCapnhatngayinphoiBHYT.Enabled = false;
if (Utility.sDbnull(txtObjectType_Code.Text) == "BHYT")
{
lblMessage.Visible = true;
Utility.SetMsg(lblMessage, string.Format("Bệnh nhân chưa in phôi bảo hiểm y tế"), true);
//lblMessage.BackColor = Color.Red;
}
else
{
lblMessage.Visible = false;
}
}
}
catch
{
}
}
示例14: Laygiatrithamsohethong
public static string Laygiatrithamsohethong(string ParamName,string defaultval,bool fromDB)
{
try
{
string reval = defaultval;
if (fromDB)
{
SqlQuery sqlQuery =
new Select().From(SysSystemParameter.Schema).Where(SysSystemParameter.Columns.SName).IsEqualTo(
ParamName);
SysSystemParameter objSystemParameter = sqlQuery.ExecuteSingle<SysSystemParameter>();
if (objSystemParameter != null) reval = objSystemParameter.SValue;
}
else
{
DataRow[] arrDR = globalVariables.gv_dtSysparams.Select(SysSystemParameter.SNameColumn.ColumnName + " ='" + ParamName + "'");
if (arrDR.Length > 0) reval = Utility.sDbnull(arrDR[0][SysSystemParameter.SValueColumn.ColumnName]);
}
return reval;
}
catch
{
return defaultval;
}
}
示例15: LayMaDviLamViec
/// <summary>
/// HÀM THỰC HIỆN VIỆC KIỂM TRA XEM BÁO CÁO ĐƠN VỊ NÀO
/// </summary>
/// <returns></returns>
public static string LayMaDviLamViec()
{
SqlQuery q = new Select().From(SysSystemParameter.Schema)
.Where(SysSystemParameter.Columns.SName).IsEqualTo("ACCOUNTNAME");
SysSystemParameter objParameter = q.ExecuteSingle<SysSystemParameter>();
if (objParameter != null) return objParameter.SValue;
else
{
return "DETMAY";
}
}