public QheCamchidinhChungphieuCollection FetchAll()
{
QheCamchidinhChungphieuCollection coll = new QheCamchidinhChungphieuCollection();
Query qry = new Query(QheCamchidinhChungphieu.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public static string Insert(DmucThuoc objThuoc, QheCamchidinhChungphieuCollection lstQhe)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
objThuoc.Save();
if (!objThuoc.IsNew)
{
}
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvu).IsEqualTo(objThuoc.IdThuoc)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvuCamchidinhchung).IsEqualTo(objThuoc.IdThuoc)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
foreach (QheCamchidinhChungphieu obj in lstQhe)
{
obj.IdDichvu = objThuoc.IdThuoc;
}
lstQhe.SaveAll();
}
scope.Complete();
}
return(string.Empty);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string Insert(DmucDichvuclsChitiet objClsChitiet, QheCamchidinhChungphieuCollection lstQhe, QheDichvuMauketquaCollection lstqhemauKq)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
objClsChitiet.Save();
if (!objClsChitiet.IsNew)
{
new Update(KcbChidinhclsChitiet.Schema)
.Set(KcbChidinhclsChitiet.Columns.IdDichvu).EqualTo(objClsChitiet.IdDichvu)
.Where(KcbChidinhclsChitiet.Columns.IdChitietdichvu).IsEqualTo(objClsChitiet.IdChitietdichvu)
.Execute();
//new Update(KcbThanhtoanChitiet.Schema)
// .Set(KcbThanhtoanChitiet.Columns.IdDichvu).EqualTo(objClsChitiet.IdDichvu)
// .Set(KcbThanhtoanChitiet.Columns.TenChitietdichvu).EqualTo(objClsChitiet.TenChitietdichvu)
// .Where(KcbThanhtoanChitiet.Columns.IdLoaithanhtoan).IsEqualTo(2)
// .And(KcbThanhtoanChitiet.Columns.IdChitietdichvu).IsEqualTo(objClsChitiet.IdChitietdichvu)
// .Execute();
}
new Delete().From(QheDichvuMauketqua.Schema)
.Where(QheDichvuMauketqua.Columns.IdDichvuChitiet).IsEqualTo(objClsChitiet.IdChitietdichvu)
.Execute();
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvu).IsEqualTo(objClsChitiet.IdChitietdichvu)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvuCamchidinhchung).IsEqualTo(objClsChitiet.IdChitietdichvu)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
foreach (QheCamchidinhChungphieu obj in lstQhe)
{
obj.IdDichvu = objClsChitiet.IdChitietdichvu;
}
lstQhe.SaveAll();
foreach (QheDichvuMauketqua obj in lstqhemauKq)
{
obj.IdDichvuChitiet = objClsChitiet.IdChitietdichvu;
}
lstqhemauKq.SaveAll();
}
scope.Complete();
}
return(string.Empty);
}
catch (Exception ex)
{
return(ex.Message);
}
}
private QheCamchidinhChungphieuCollection GetQheCamchidinhChungphieuCollection()
{
QheCamchidinhChungphieuCollection lst = new QheCamchidinhChungphieuCollection();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdDmucthuoc.GetCheckedRows())
{
QheCamchidinhChungphieu objQheNhanvienDanhmuc = new QheCamchidinhChungphieu();
objQheNhanvienDanhmuc.IdDichvu = -1;
objQheNhanvienDanhmuc.Loai = 1;
objQheNhanvienDanhmuc.IdDichvuCamchidinhchung = Utility.Int32Dbnull(gridExRow.Cells[QheCamchidinhChungphieu.Columns.IdDichvu].Value);
objQheNhanvienDanhmuc.IsNew = true;
lst.Add(objQheNhanvienDanhmuc);
}
return lst;
}
public static string Insert(DmucThuoc objThuoc, QheCamchidinhChungphieuCollection lstQhe)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
objThuoc.Save();
if (!objThuoc.IsNew)
{
}
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvu).IsEqualTo(objThuoc.IdThuoc)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
new Delete().From(QheCamchidinhChungphieu.Schema)
.Where(QheCamchidinhChungphieu.Columns.IdDichvuCamchidinhchung).IsEqualTo(objThuoc.IdThuoc)
.And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0)
.Execute();
foreach (QheCamchidinhChungphieu obj in lstQhe)
{
obj.IdDichvu = objThuoc.IdThuoc;
}
lstQhe.SaveAll();
}
scope.Complete();
}
return string.Empty;
}
catch (Exception ex)
{
return ex.Message;
}
}
private QheCamchidinhChungphieuCollection GetQheCamchidinhChungphieuCollection()
{
QheCamchidinhChungphieuCollection lst = new QheCamchidinhChungphieuCollection();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdDanhsachCamChidinhChungphieu.GetCheckedRows())
{
QheCamchidinhChungphieu objQheNhanvienDanhmuc = new QheCamchidinhChungphieu();
objQheNhanvienDanhmuc.IdDichvu = -1;
objQheNhanvienDanhmuc.Loai = 0;
objQheNhanvienDanhmuc.IdDichvuCamchidinhchung = Utility.Int32Dbnull(gridExRow.Cells[VDmucDichvuclsChitiet.Columns.IdChitietdichvu].Value);
objQheNhanvienDanhmuc.IsNew = true;
lst.Add(objQheNhanvienDanhmuc);
}
return lst;
}
public QheCamchidinhChungphieuCollection FetchByQuery(Query qry)
{
QheCamchidinhChungphieuCollection coll = new QheCamchidinhChungphieuCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public QheCamchidinhChungphieuCollection FetchByID(object IdDichvu)
{
QheCamchidinhChungphieuCollection coll = new QheCamchidinhChungphieuCollection().Where("id_dichvu", IdDichvu).Load();
return coll;
}
