private void LoadBeds()
{
IpdManager aIpdManager = new IpdManager();
txtseletedBed.DataSource = aIpdManager.GetAllBeds(cmbwardCabin.Text);
txtseletedBed.DisplayMember = "BedName";
txtseletedBed.ValueMember = "BedId";
//try
//{
// Conn obcon = new Conn();
// SqlConnection ob = new SqlConnection(obcon.strCon);
// SqlDataAdapter da = new SqlDataAdapter();
// da.SelectCommand = new SqlCommand();
// da.SelectCommand.Connection = ob;
// SqlCommand ds = da.SelectCommand;
// //ds.CommandText = "select* from tblBed where Ward=@Ward and Room=@Room and Status='Free'";
// ds.CommandText = "select * from ViewAllBeds";
// ds.CommandType = CommandType.Text;
// DataTable dt = new DataTable();
// da.Fill(dt);
// txtseletedBed.DataSource = dt;
// txtseletedBed.DisplayMember = "BedName";
// txtseletedBed.ValueMember = "ID";
//}
//catch
//{
//}
}
private void btnEdit_Click(object sender, EventArgs e)
{
Patient patient = new Patient();
//patient.OPID = pidSearchLookUpEdit.Properties.View.GetFocusedDisplayText();
//patient.OPID = pidSearchLookUpEdit.EditValue.ToString();
patient.OPID = pidSearchLookUpEdit.Properties.NullValuePrompt;
patient.PatientName = txtName.Text;
patient.FatherName = txtFatherName.Text;
patient.MotherName = txtMother.Text;
patient.Address = txtAddress.Text;
patient.Age = txtAge.Text;
patient.Mobile = txtPhone.Text;
patient.Gurdian = txtGurdian.Text;
patient.Phone = txtPhone.Text;
patient.Relation = txtRelation.Text;
patient.Gender = cmbGender.Text;
patient.BloodGroup = txtbloodGroup.Text;
patient.Religion = cmbReligion.Text;
patient.RefferedBy = cmbRefferBy.Text;
patient.Department = cmbDepartment.Text;
patient.Weight = txtWeight.Text;
patient.Nationality = txtNationality.Text;
patient.InputDate = dateTimePicker1.Value;
patient.DutyDoctorId = cmbDutydoctor.SelectedValue.ToString();
patient.Doctor = txtPrimaryDoctor.Text;
patient.RefferedBy = cmbRefferBy.Text;
MessageModel message = new IpdManager().UpdateAdmissionPatient(patient);
MessageBox.Show(message.MessageTitle, message.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAll();
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(pidSearchLookUpEdit.Properties.NullValuePrompt))
{
MetroFramework.MetroMessageBox.Show(this, "Patient not found!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DialogResult dr = MetroFramework.MetroMessageBox.Show(this, "Are you sure to delete row?", "Confirmation Message", MessageBoxButtons.YesNo, MessageBoxIcon.Stop);
if (dr == DialogResult.Yes)
{
Patient aPatient = new Patient();
//aPatient.OPID = pidSearchLookUpEdit.Properties.NullValuePrompt;
aPatient.OPID = txtOpid.Text;
MessageModel message = new IpdManager().DeleteAdmitedPatient(aPatient);
MetroFramework.MetroMessageBox.Show(this, message.MessageTitle, message.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
GetAllIpdPatient();
LoadData();
}
}
catch (Exception)
{
//throw;
}
}
public void GetIpRegID()
{
DataTable data = new DataTable();
data = new IpdManager().GetIpRegID();
txtReg.Text = data.Rows[0]["RegNo"].ToString();
}
public void LoadDataForIPD(string pslNo)
{
Patient patient = new Patient();
if (toggleSwitch1.IsOn)
{
patient = new OPD_Manager().GetPatientInformationBySl(pslNo);
}
else
{
patient = new IpdManager().GetPatientInformationBySl(pslNo);
}
txtName.Text = patient.PatientName;
txtFatherName.Text = patient.FatherName;
txtMotherName.Text = patient.MotherName;
txtAddress.Text = patient.Address;
txtAge.Text = patient.Age;
txtPhone.Text = patient.Phone;
txtMobile.Text = patient.Mobile;
txtGuirdian.Text = patient.Gurdian;
txtRelation.Text = patient.Relation;
txtGender.Text = patient.Gender;
txtBloodGroup.Text = patient.BloodGroup;
txtReligion.Text = patient.Religion;
txtCabinBed.Text = patient.SelectedBed;
}
private void GetAllCabin()
{
IpdManager aIpdManager = new IpdManager();
cmbwardCabin.DataSource = aIpdManager.GetAllCabin();
cmbwardCabin.DisplayMember = "CabinName";
cmbwardCabin.ValueMember = "Id";
}
private void LoadBedsNICU()
{
IpdManager aIpdManager = new IpdManager();
txtseletedBed.DataSource = aIpdManager.GetAllBedsNICU();
txtseletedBed.DisplayMember = "BedName";
txtseletedBed.ValueMember = "BedId";
}
private void PatientLoad()
{
var GetAllPatient = new IpdManager().GetAllDischargeIP();
cmbPatient.Properties.DataSource = GetAllPatient;
cmbPatient.Properties.ValueMember = "OPID";
cmbPatient.Properties.DisplayMember = "PatientName";
}
private void ConsultantLoad()
{
var GetConsultant = new IpdManager().GetAllConsultant();
txtConsult.DataSource = GetConsultant;
txtConsult.ValueMember = "DoctorID";
txtConsult.DisplayMember = "DoctorName";
}
private void GetAllPatientSlNo()
{
DataTable slNo = new DataTable();
slNo = new IpdManager().GetAllNICUpatientSl();
cmbPid.DataSource = slNo;
cmbPid.DisplayMember = "RegNo";
cmbPid.ValueMember = "RegNo";
}
private void btnSave_Click_1(object sender, EventArgs e)
{
//id=pidSearchLookUpEdit.Properties.View.GetFocusedDisplayText();
Patient patient = new Patient();
Service service = new Service();
patient.OPID = pidSearchLookUpEdit.Properties.View.GetFocusedDisplayText();
patient.PatientName = txtName.Text;
patient.FatherName = txtFatherName.Text;
patient.MotherName = txtMother.Text;
patient.Address = txtAddress.Text;
patient.Age = txtAge.Text;
patient.Mobile = txtAge.Text;
patient.Gurdian = txtGurdian.Text;
patient.Phone = txtPhone.Text;
patient.Relation = txtRelation.Text;
patient.Gender = cmbGender.Text;
patient.BloodGroup = txtbloodGroup.Text;
patient.Religion = cmbReligion.Text;
patient.AdmissionTime = admissionTime.Value;
patient.RefferedBy = cmbRefferBy.Text;
patient.Doctor = txtPrimaryDoctor.Text;
patient.Department = cmbDepartment.Text;
patient.PatientCondition = txtPinformation.Text;
patient.RegNo = txtReg.Text;
patient.WardOrCabin = "";
patient.Weight = txtWeight.Text;
patient.Nationality = txtNationality.Text;
var bed = txtseletedBed.SelectedValue;
patient.SelectedBed = "";
if (bed != null)
{
patient.SelectedBed = bed.ToString();
}
patient.InputDate = dateTimePicker1.Value;
patient.DutyDoctorId = cmbDutydoctor.SelectedValue.ToString();
patient.Doctor = txtPrimaryDoctor.Text;
patient.RefferedBy = cmbRefferBy.Text;
patient.RegNo = txtReg.Text;
service.OPID = pidSearchLookUpEdit.Properties.View.GetFocusedDisplayText();
service.ServiceId = "Serv-01";
service.Rate = Convert.ToDouble(txtRegFf.Text);
service.Total = Convert.ToDouble(txtRegFf.Text);
service.Qty = 1;
service.IssueDate = dateTimePicker1.Value;
MessageModel message = new IpdManager().SaveIpdPatient(patient, service);
MessageBox.Show(message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAll();
GetAllIpdPatient();
LoadData();
}
public void PatientInformationGetByOPID(string opid)
{
Patient patient = new IpdManager().GetPatientInformationBySl(opid);
txtName.Text = patient.PatientName;
txtGender.Text = patient.Gender;
txtBloodGroup.Text = patient.BloodGroup;
txtAdmissionDate.Text = patient.InputDate.ToString("d");
txtCabibBed.Text = patient.SelectedBed;
txtAge.Text = patient.Age;
}
private void PatientByOPID(string pid)
{
Patient patient = new IpdManager().GetPatientInformationBySl(pid);
txtFahterHusbandName.Text = patient.Gurdian;
txtAddress.Text = patient.Address;
txtAge.Text = patient.Age;
txtGender.Text = patient.Gender;
txtBloodGroup.Text = patient.BloodGroup;
txtContactNo.Text = patient.Mobile;
txtConsult.Text = patient.Doctor;
txtCabinBedNo.Text = patient.SelectedBed;
txtAdmissionOnDate.Text = patient.InputDate.ToString("d");
txtRegNo.Text = patient.RegNo;
txtWeight.Text = patient.Weight;
}
public void LoadDataForIPD(string pslNo)
{
try
{
Patient patient = new Patient();
if (radioBtnNicu.Checked)
{
NicuAddmission setup = new NICUBillManager().GetNICUPatientInfo(cmbPid.Text);
cmbPid.Text = setup.RegNo;
txtAge.Text = setup.Age;
txtName.Text = "Baby of" + " " + setup.MotherName;
txtFatherName.Text = setup.FatherName;
txtMotherName.Text = setup.MotherName;
admitDate.Value = setup.AdmitDate;
txtAddress.Text = setup.Address;
txtCabinBed.Text = setup.Bed;
txtBloodGroup.Text = setup.BabysBloodGroup;
txtPhone.Text = setup.ContactNo;
txtGender.Text = setup.Sex;
LoadPatientServiceNICU(cmbPid.Text, "NICU");
}
else
{
patient = new IpdManager().GetPatientInformationBySl(pslNo);
txtName.Text = patient.PatientName;
txtFatherName.Text = patient.FatherName;
txtMotherName.Text = patient.MotherName;
txtAddress.Text = patient.Address;
txtAge.Text = patient.Age;
txtPhone.Text = patient.Phone;
txtMobile.Text = patient.Mobile;
txtGuirdian.Text = patient.Gurdian;
txtRelation.Text = patient.Relation;
txtGender.Text = patient.Gender;
txtBloodGroup.Text = patient.BloodGroup;
txtReligion.Text = patient.Religion;
txtCabinBed.Text = patient.SelectedBed;
LoadPatientService(cmbPid.Text, "IPD");
}
}
catch (Exception)
{
//throw;
}
}
private void GetAllPatientSlNo(string status)
{
if (status == "IPD")
{
DataTable slNo = new DataTable();
slNo = new IpdManager().GetAllIpdPatientSl();
cmbPid.DataSource = slNo;
cmbPid.DisplayMember = "OPID";
cmbPid.ValueMember = "OPID";
}
else
{
var slNo = new OPD_Manager().GetAllOpdPatienSlNo();
cmbPid.DataSource = slNo;
cmbPid.DisplayMember = "OPID";
cmbPid.ValueMember = "OPID";
}
}
private void load()
{
if (radioBtnNicu.Checked)
{
DataTable slNo = new DataTable();
PatientService();
slNo = new IpdManager().GetAllNICUpatientSl();
cmbPid.DataSource = slNo;
cmbPid.DisplayMember = "RegNo";
cmbPid.ValueMember = "RegNo";
}
if (radioBtnIndoor.Checked)
{
PatientService();
GetAllPatientSlNo("IPD");
LoadPatientService(cmbPid.Text, "IPD");
}
}
private void btnConsultBill_Click(object sender, EventArgs e)
{
List <Patient> ListOfConsultBilling = new List <Patient>();
Service aService = new Service();
aService.AConsultBill = new ServiceManager().GetConsultBillServicesByPatientId(cmbPid.Text, IpBillingStatus, "Consult", dtpConsultBill.Value);
for (int i = 0; i < gridView.RowCount - 1; i++)
{
Patient consultBillService = new Patient();
consultBillService.ConsultBillServices = new ConsultBillService();
consultBillService.OPID = cmbPid.Text;
consultBillService.ConsultBillServices.ConsultId = gridView.GetRowCellValue(i, "ConsultId").ToString();
consultBillService.ConsultBillServices.ConsultBillDate = gridView.GetRowCellValue(i, "ConsultBillDate").ToString();
consultBillService.ConsultBillServices.ConQty = Convert.ToInt32(gridView.GetRowCellValue(i, "ConQty").ToString());
consultBillService.ConsultBillServices.ConFee = Convert.ToDouble(gridView.GetRowCellValue(i, "ConFee").ToString());
consultBillService.ConsultBillServices.VchNo = Convert.ToInt64(gridView.GetRowCellValue(i, "VchNo").ToString());
ListOfConsultBilling.Add(consultBillService);
}
MessageModel message = new IpdManager().SaveCosultBilling(ListOfConsultBilling, aService);
MessageBox.Show(message.MessageTitle, message.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void LoadAllData()
{
DataTable GetAllPaitentId = new IpdManager().GetAllIpdPatientSl();
cmbPid.DataSource = GetAllPaitentId;
cmbPid.DisplayMember = "OPID";
cmbPid.ValueMember = "OPID";
//..............................................
DataTable GetAllDoctor = new MedicalManager().GetAllDoctor();
cmbDoctor.DataSource = GetAllDoctor;
cmbDoctor.DisplayMember = "DoctorName";
cmbDoctor.ValueMember = "DoctorID";
DataTable GetAllDrug = new MedicalManager().GetAllDrug();
cmbDrug.DataSource = GetAllDrug;
cmbDrug.ValueMember = "ProductCode";
cmbDrug.DisplayMember = "ProductName";
//**************************************GetAllPatientFollowup
}
public void LoadMedicine()
{
try
{
Service service = new Service();
service.OPID = IpBillingSetup.cmbPid.Text;
service.OtReffNo = IpBillingSetup.txtOtReffNo.Text;
service.IssueDate = Convert.ToDateTime(dateTimePicker1.Text).Date;
service.GodownId = "2";
repositoryItemSearchLookUpEdit1.DataSource = new IpdManager().OT_StockMedicine(service);
repositoryItemSearchLookUpEdit1.DisplayMember = "ProductId";
repositoryItemSearchLookUpEdit1.ValueMember = "ProductId";
var list = new IpdManager().GetOtServiceConsumListByPatientId(service);
dt = new CustomLibry.CustomLibrary().ToDataTable(list);
gridControl1.DataSource = dt;
Int64 MaxID = new ServiceGateway().GetOtMaxValue();
gridView1.SetRowCellValue(gridView1.RowCount - 1, "VoucherNo", MaxID);
}
catch (Exception ex)
{
//new MailServer.MailServerConnection().SentMail(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(pidSearchLookUpEdit.Properties.NullValuePrompt))
{
MessageBox.Show("Patient not found!");
return;
}
DialogResult dr = MessageBox.Show("Are you sure to delete row?", "Confirmation Message", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
Patient aPatient = new Patient();
aPatient.OPID = pidSearchLookUpEdit.Properties.NullValuePrompt;
MessageModel message = new IpdManager().DeleteAdmitedPatient(aPatient);
MessageBox.Show(message.MessageTitle, message.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAll();
LoadData();
}
else
{
//Nothing to do
}
}
private void GenerateReg()
{
DataTable dt = new IpdManager().GetIpRegID();
txtReg.Text = dt.Rows[0][0].ToString();
}
private void btnSave_Click_1(object sender, EventArgs e)
{
try
{
//pidSearchLookUpEdit
Patient patient = new Patient();
Service service = new Service();
//patient.RefferedBy = cmbRefferBy.SelectedValue.ToString();
DAL.Model.OutdoorPatient aOutdoorPatient = new DAL.Model.OutdoorPatient();
aOutdoorPatient.Opid = txtOpid.Text;
aOutdoorPatient.ServiceDate = AdmissionDate.Value;
aOutdoorPatient.TreatementType = "IPD";
aOutdoorPatient.PatientName = txtName.Text;
aOutdoorPatient.GurdianName = txtGurdian.Text;
aOutdoorPatient.Address = txtAddress.Text;
if (txtAge.Text != null)
{
aOutdoorPatient.Age = Convert.ToInt32(txtAge.Text);
}
aOutdoorPatient.Phone = txtPhone.Text;
aOutdoorPatient.Mobile = txtPhone.Text;
aOutdoorPatient.Nationality = txtNationality.Text;
// aOutdoorPatient.Doctor = comPrimaryDoctor.Text;
aOutdoorPatient.Fees = txtRegFf.Text;
aOutdoorPatient.ContactPerson = txtGurdian.Text;
aOutdoorPatient.Gender = cmbGender.Text;
if (cmbbloodGroup.Text == "A+" || cmbbloodGroup.Text == "A-" || cmbbloodGroup.Text == "AB+" || cmbbloodGroup.Text == "AB-" || cmbbloodGroup.Text == "B+" || cmbbloodGroup.Text == "B-" || cmbbloodGroup.Text == "O+" || cmbbloodGroup.Text == "O-" || cmbbloodGroup.Text == "N/A")
{
aOutdoorPatient.BloodGroup = cmbbloodGroup.Text;
}
patient.OPID = txtOpid.Text;
patient.PatientName = txtName.Text;
patient.FatherName = txtFatherName.Text;
patient.MotherName = txtMother.Text;
patient.Address = txtAddress.Text;
patient.Area = cmbArea.Text;
patient.Age = txtAge.Text;
patient.Area = cmbArea.Text;
if (cmbMaritalStatus.Text == "Married" || cmbMaritalStatus.Text == "Single" || cmbMaritalStatus.Text == "Divorced" || txtAge.Text == "Separated" || cmbMaritalStatus.Text == "Widowed")
{
patient.MaritalStatus = cmbMaritalStatus.Text;
}
patient.Mobile = txtPhone.Text;
patient.Gurdian = txtGurdian.Text;
patient.Phone = txtPhone.Text;
if (cmbGender.Text == "Male" || cmbGender.Text == "Female" || cmbGender.Text == "Neuture")
{
patient.Gender = cmbGender.Text;
}
if (cmbbloodGroup.Text == "A+" || cmbbloodGroup.Text == "A-" || cmbbloodGroup.Text == "AB+" || cmbbloodGroup.Text == "AB-" || cmbbloodGroup.Text == "B+" || cmbbloodGroup.Text == "B-" || cmbbloodGroup.Text == "O+" || cmbbloodGroup.Text == "O-" || cmbbloodGroup.Text == "N/A")
{
patient.BloodGroup = cmbbloodGroup.Text;
}
patient.Religion = cmbReligion.Text;
patient.RefferedBy = cmbRefferBy.SelectedValue.ToString();
//patient.Doctor = comPrimaryDoctor.Text;
patient.Department = cmbDepartment.Text;
patient.PatientCondition = txtPatientCondition.Text;
patient.RegNo = txtReg.Text;
if (chkCabin.Checked == false)
{
var cabin = cmbwardCabin.SelectedValue;
patient.WardOrCabin = cabin.ToString();
}
else
{
var bed = txtseletedBed.SelectedValue;
patient.SelectedBed = "";
patient.PatientCondition = txtPatientCondition.Text;
if (bed != null)
{
patient.SelectedBed = bed.ToString();
}
}
patient.Weight = txtWeight.Text;
patient.Nationality = txtNationality.Text;
patient.InputDate = AdmissionDate.Value;
DateTime dt = AdmissionTime.Value;
TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
patient.AdmissionTime = st;
patient.DutyDoctorId = cmbDutydoctor.SelectedValue.ToString();
//patient.Doctor = comPrimaryDoctor.Text;
patient.RefferedBy = cmbRefferBy.Tag.ToString();
patient.RegNo = txtReg.Text;
service.OPID = txtOpid.Text;
service.ServiceId = "I-Serv-01";
service.Rate = Convert.ToDouble(txtRegFf.Text);
service.Total = Convert.ToDouble(txtRegFf.Text);
service.Qty = 1;
service.IssueDate = AdmissionDate.Value;
service.Catgory = "Hospital";
MessageModel message = new IpdManager().SaveIpdPatient(patient, service, aOutdoorPatient);
if (message.MessageTitle == "Successful")
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
GetAllIpdPatient();
LoadData();
}
else
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
//throw;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
DAL.Model.OutdoorPatient aOutdoorPatient = new DAL.Model.OutdoorPatient();
aOutdoorPatient.Opid = txtOpid.Text;
aOutdoorPatient.ServiceDate = AdmissionDate.Value;
aOutdoorPatient.TreatementType = "IPD";
aOutdoorPatient.PatientName = txtName.Text;
aOutdoorPatient.GurdianName = txtGurdian.Text;
aOutdoorPatient.Address = txtAddress.Text;
aOutdoorPatient.Age = Convert.ToInt32(txtAge.Text);
aOutdoorPatient.Phone = txtPhone.Text;
aOutdoorPatient.Mobile = txtPhone.Text;
aOutdoorPatient.Nationality = txtNationality.Text;
//aOutdoorPatient.Doctor = comPrimaryDoctor.Text;
aOutdoorPatient.Fees = txtRegFf.Text;
aOutdoorPatient.ContactPerson = txtGurdian.Text;
aOutdoorPatient.Gender = cmbGender.Text;
if (cmbbloodGroup.Text == "A+" || cmbbloodGroup.Text == "A-" || cmbbloodGroup.Text == "AB+" || cmbbloodGroup.Text == "AB-" || cmbbloodGroup.Text == "B+" || cmbbloodGroup.Text == "B-" || cmbbloodGroup.Text == "O+" || cmbbloodGroup.Text == "O-" || cmbbloodGroup.Text == "N/A")
{
aOutdoorPatient.BloodGroup = cmbbloodGroup.Text;
}
Patient patient = new Patient();
patient.OPID = txtOpid.Text;
patient.PatientName = txtName.Text;
patient.FatherName = txtFatherName.Text;
patient.MotherName = txtMother.Text;
patient.Address = txtAddress.Text;
patient.Age = txtAge.Text;
patient.Mobile = txtPhone.Text;
patient.Gurdian = txtGurdian.Text;
patient.Phone = txtPhone.Text;
patient.Area = cmbArea.Text;
patient.Gender = cmbGender.Text;
patient.BloodGroup = cmbbloodGroup.Text;
patient.Religion = cmbReligion.Text;
patient.RefferedBy = cmbRefferBy.Tag.ToString();
patient.Department = cmbDepartment.Text;
patient.Weight = txtWeight.Text;
patient.Nationality = txtNationality.Text;
patient.InputDate = AdmissionDate.Value;
DateTime dt = AdmissionTime.Value;
TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
patient.AdmissionTime = st; patient.DutyDoctorId = cmbDutydoctor.SelectedValue.ToString();
patient.Doctor = txtPrimaryDoctor.Text;
MessageModel message = new IpdManager().UpdateAdmissionPatient(patient, aOutdoorPatient);
if (message.MessageTitle == "Successfull")
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
GetAllIpdPatient();
LoadData();
}
else
{
MetroFramework.MetroMessageBox.Show(this, message.MessageTitle, message.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
//throw;
}
}
private void GetBedHistory(string PID)
{
DataTable dt = new IpdManager().GetBeadCabinHistoryNICU(PID);
gridControl3.DataSource = dt;
}
