private bool Invalidata() { string BarCode = globalVariables.SysDate.Year + globalVariables.SysDate.Month.ToString() + globalVariables.SysDate.Date + txtBarcode.Text; Utility.ResetMessageError(errorProvider1); if (!string.IsNullOrEmpty(txtBarcode.Text)) { if (Utility.Int32Dbnull(txtBarcode.Text, 0) < SystemParaBarcode.ParaBacode) { Utility.SetMessageError(errorProvider1, txtBarcode, "Số thứ tự của barcode không nhỏ hơn " + SystemParaBarcode.ParaBacode); txtBarcode.Focus(); return(false); } TTestInfoCollection testInfoCollection = new TTestInfoController().FetchByQuery(TTestInfo.CreateQuery().AddWhere(TTestInfo.Columns.Barcode, Comparison.Equals, txtBarcode.Text.Trim())); if (testInfoCollection.Count > 0) { Utility.SetMessageError(errorProvider1, txtBarcode, "Tồn tại " + SystemParaBarcode.ParaBacode); txtBarcode.Focus(); return(false); } } return(true); }
private bool InValiData() { v_patientId = Utility.Int32Dbnull(grdPatients.CurrentRow.Cells["colPatient_ID"].Value, -1); TTestInfoCollection testInfoCollection = new TTestInfoController().FetchByQuery(TTestInfo.CreateQuery().AND(TTestInfo.Columns.TestTypeId, Comparison.Equals, v_TestTypeInfo).AND( TTestInfo.Columns.PatientId, Comparison.Equals, v_patientId)); if (testInfoCollection.Count > 0) { return(true); } return(false); }
public static string InsertTestInfo(TTestInfo pitems) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { if (pitems.TestDate == null) { pitems.TestDate = DateTime.Now; } if (pitems.RequireDate == null) { pitems.RequireDate = DateTime.Now; } if (pitems.TestStatus == null) { pitems.TestStatus = 0; } int i = 0; Query _QueryRS = TTestInfo.CreateQuery(); TTestInfoCollection testInfoCollection = new TTestInfoController().FetchByQuery( TTestInfo.CreateQuery().AddWhere(TTestInfo.Columns.PatientId, Comparison.Equals, pitems.PatientId)); if (testInfoCollection.Count > 0) { pitems.ParaId = testInfoCollection[0].ParaId; } pitems.IsNew = true; pitems.Save(i); scope.Complete(); return(_QueryRS.GetMax(TTestInfo.Columns.TestId).ToString()); } } } catch (Exception ex) { throw ex; } }
public static string BarCodeTestInfo(int vPatient_ID, int testTyeId, int Para_ID) { var dataTable = new DataTable(); string sBarcode = ""; TTestInfoCollection testInfoController = new TTestInfoController().FetchByQuery(TTestInfo.CreateQuery().AddWhere(TTestInfo.Columns.PatientId, Comparison.Equals, vPatient_ID)); if (testInfoController.Count > 0) { sBarcode = testInfoController[0].Barcode; } else { dataTable = SPs.SpGetNewTestSID(globalVariables.SysDate, testTyeId, Para_ID).GetDataSet().Tables[0]; if (dataTable.Rows.Count > 0) { sBarcode = dataTable.Rows[0][0].ToString(); } } return(sBarcode); }