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