public KcbDangkyKcbCollection FetchAll()
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection();
Query qry = new Query(KcbDangkyKcb.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public KcbDangkyKcbCollection FetchByQuery(Query qry)
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public KcbDangkyKcbCollection FetchAll()
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection();
Query qry = new Query(KcbDangkyKcb.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// hàm thực hiện việc tính phần trăm của khám bệnh
/// </summary>
/// <param name="objPatientExam"></param>
public static void TinhPtramBHYTForKham(KcbLuotkham objPatientExam)
{
SqlQuery sqlQuery = new Select().From(KcbDangkyKcb.Schema)
.Where(KcbDangkyKcb.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
.And(KcbDangkyKcb.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan);
KcbDangkyKcbCollection objRegExamCollection = sqlQuery.ExecuteAsCollection <KcbDangkyKcbCollection>();
foreach (KcbDangkyKcb objRegExam in objRegExamCollection)
{
// decimal PtramBHYT = Utility.DecimaltoDbnull(objPatientExam.PtramBhyt, 0);
THU_VIEN_CHUNG.TinhToanKhamPtramBHYT(objPatientExam, objRegExam);
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.BhytChitra).EqualTo(objRegExam.BhytChitra)
.Set(KcbDangkyKcb.Columns.BnhanChitra).EqualTo(objRegExam.BnhanChitra)
.Set(KcbDangkyKcb.Columns.PhuThu).EqualTo(objRegExam.PhuThu)
.Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(objRegExam.IdKham).Execute();
}
}
public KcbDangkyKcbCollection FetchByQuery(Query qry)
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public KcbDangkyKcbCollection FetchByID(object IdKham)
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection().Where("id_kham", IdKham).Load();
return coll;
}
public KcbDangkyKcbCollection FetchByID(object IdKham)
{
KcbDangkyKcbCollection coll = new KcbDangkyKcbCollection().Where("id_kham", IdKham).Load();
return(coll);
}
