//public static DataSet GetPatientAndTestInfo(string sophieu, string name, int gioitinh, DateTime fromtestdate,
// DateTime toTestdate, bool check, int testTypeId, int HasTest)
//{
// return
// SPs.GetPatientAndTestInfoVnio(sophieu, name, gioitinh, fromtestdate, toTestdate, check, testTypeId, HasTest)
// .GetDataSet();
//}
//public static DataTable GetResultByMaBenhNhan(string sophieu, DateTime fromtestdate,
// DateTime toTestdate, bool check, int testTypeId, int HasTest, string maBenhNhan)
//{
// try
// {
// return
// SPs.GetResultDetailVnioV3(sophieu, fromtestdate, toTestdate, check, testTypeId, HasTest, maBenhNhan)
// .GetDataSet().Tables[0];
// }
// catch (Exception)
// {
// return null;
// }
//}
//public static DataSet GetResultDetailV(string sophieu, DateTime testdate, bool check)
//{
// return SPs.GetResultDetailVnioV2(sophieu, testdate, check, -100).GetDataSet();
//}
//Insert Yêu cầu XN
public static ActionResult InsertYeuCauXn(TblYeucauXetnghiemVnio[] arrYeucauxetnghiem)
{
try
{
using (var scope = new TransactionScope())
{
using (var sp = new SharedDbConnectionScope())
{
foreach (TblYeucauXetnghiemVnio objYeucauXetnghiem in arrYeucauxetnghiem)
{
TblYeucauXetnghiemVnioCollection objYeucauXetnghiemCollection =
new TblYeucauXetnghiemVnioController().FetchByQuery(
TblYeucauXetnghiemVnio.CreateQuery().AddWhere(
TblYeucauXetnghiemVnio.Columns.IdCanLamSangThucHien, Comparison.Equals,
objYeucauXetnghiem.IdCanLamSangThucHien));
if (objYeucauXetnghiemCollection.Count <= 0)
{
objYeucauXetnghiem.IsNew = true;
objYeucauXetnghiem.Save();
}
else
{
new Update(TblYeucauXetnghiemVnio.Schema)
.Set(TblYeucauXetnghiemVnio.Columns.Id).EqualTo(objYeucauXetnghiem.Id)
.Set(TblYeucauXetnghiemVnio.Columns.YeuCauXetNghiemId).EqualTo(
objYeucauXetnghiem.YeuCauXetNghiemId)
.Set(TblYeucauXetnghiemVnio.Columns.ThucHienCho).EqualTo(
objYeucauXetnghiem.ThucHienCho)
.Set(TblYeucauXetnghiemVnio.Columns.TrangThaiThucHien).EqualTo(
objYeucauXetnghiem.TrangThaiThucHien)
.Set(TblYeucauXetnghiemVnio.Columns.MaBenhNhan).EqualTo(
objYeucauXetnghiem.MaBenhNhan)
.Set(TblYeucauXetnghiemVnio.Columns.Barcode).EqualTo(objYeucauXetnghiem.Barcode)
.Set(TblYeucauXetnghiemVnio.Columns.TestTypeId).EqualTo(
objYeucauXetnghiem.TestTypeId)
.Set(TblYeucauXetnghiemVnio.Columns.Sophieu).EqualTo(
objYeucauXetnghiem.Sophieu)
.Set(TblYeucauXetnghiemVnio.Columns.TestDate).EqualTo(
objYeucauXetnghiem.TestDate)
.Set(TblYeucauXetnghiemVnio.Columns.IsTestName).EqualTo(
objYeucauXetnghiem.IsTestName)
.Where(TblYeucauXetnghiemVnio.Columns.IdCanLamSangThucHien).IsEqualTo(
objYeucauXetnghiem.IdCanLamSangThucHien)
.Execute();
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
return(ActionResult.Error);
}
}
public void Insert(short? IdCanLamSangThucHien,short? ThucHienCho,short? TrangThaiThucHien,short? YeuCauXetNghiemId,long? Id,string MaBenhNhan,string Barcode,int? TestTypeId,string Sophieu,DateTime? TestDate,bool? IsTestName,bool? SendStatus)
{
TblYeucauXetnghiemVnio item = new TblYeucauXetnghiemVnio();
item.IdCanLamSangThucHien = IdCanLamSangThucHien;
item.ThucHienCho = ThucHienCho;
item.TrangThaiThucHien = TrangThaiThucHien;
item.YeuCauXetNghiemId = YeuCauXetNghiemId;
item.Id = Id;
item.MaBenhNhan = MaBenhNhan;
item.Barcode = Barcode;
item.TestTypeId = TestTypeId;
item.Sophieu = Sophieu;
item.TestDate = TestDate;
item.IsTestName = IsTestName;
item.SendStatus = SendStatus;
item.Save(UserName);
}
