Ejemplo n.º 1
0
        public bool InsertCTBenhNhan(CTBenhNhan CTBenhNhan)
        {
            DataClassesDataContext data = new DataClassesDataContext(Connection);

            data.CTBenhNhans.InsertOnSubmit(CTBenhNhan);
            try
            {
                data.SubmitChanges();
                return(true);
            }
            catch (Exception e)
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        public CTBenhNhan GetInfCTBenhNhan()
        {
            CTBenhNhan ctBN = new CTBenhNhan();

            ctBN.IDCTBenhNhan       = txtFileNumberPatient.Text + random.Next(5200);
            lblCTBenhNhan.Text      = ctBN.IDCTBenhNhan;
            ctBN.Comment            = txtComment.Text;
            ctBN.IDBenhNhan         = txtFileNumberPatient.Text;
            ctBN.NgayKham           = DateTime.Now;
            ctBN.NoiKham            = "HN";
            ctBN.TreatmentTime      = spin_TreamentWeek.Text;
            ctBN.TreatmentTimeFor   = spin_TreamentMonth.Text;
            ctBN.TreatmentTimeTotal = int.Parse(lblTotalTreament.Text);
            return(ctBN);
        }
Ejemplo n.º 3
0
        private void btnSavePrint_Click(object sender, System.EventArgs e)
        {
            try
            {
                //if (CheckValidatePatient())
                //{
                //    BenhNhan bn = GetInfBenhNhan();
                //    qlND.InsertBenhNhan(bn);

                CTBenhNhan ctbn = GetInfCTBenhNhan();
                qlND.InsertCTBenhNhan(ctbn);

                List <CTBenhNhanComplaint> listComplaint = GetInfCTBenhNhanComplaint();
                qlND.InsertListCTBenhNhanComplaint(listComplaint);

                List <CTBenhNhanConditionDicsJoint> listDiscJoint = GetInfCTBenhNhanConditionDicsJoint();
                qlND.InsertListCTBenhNhanConditionDicsJoint(listDiscJoint);

                CTBenhNhanCondition cTBenhNhanConditions = GetInfCTBenhNhanCondition();
                qlND.InsertCTBenhNhanCondition(cTBenhNhanConditions);

                List <CTBenhNhanConditionVertebral> listCTBenhNhanConditionVertebral = GetInfCTBenhNhanConditionVertebral();
                qlND.InsertListCTBenhNhanConditionVertebral(listCTBenhNhanConditionVertebral);

                List <CTBenhNhanExcercise> ListCTBenhNhanExcercises = GetInfCTBenhNhanExcercise();
                qlND.InsertListCTBenhNhanExcercise(ListCTBenhNhanExcercises);

                List <CTBenhNhanMRIImage> listCTBenhNhanMRIImage = GetInfCTBenhNhanMRIImage();
                qlND.InsertListCTBenhNhanMRIImage(listCTBenhNhanMRIImage);

                List <CTBenhNhanSnapShot> listCTBenhNhanSnapShot = GetInfCTBenhNhanSnapShot();
                qlND.InsertListCTBenhNhanSnapShot(listCTBenhNhanSnapShot);

                PrintPatient(txtFileNumberPatient.Text, lblCTBenhNhan.Text);
                //}
            }
            catch (Exception)
            {
                MessageBox.Show("Save error");
            }
        }
        private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            var rowHandle = gridView_CuocGoi.FocusedRowHandle;
            // Get the value for the given column - convert to the type you're expecting
            string IDBenhNhan   = gridView_CuocGoi.GetRowCellValue(rowHandle, "IDBenhNhan").ToString();
            string IDCTBenhNhan = gridView_CuocGoi.GetRowCellValue(rowHandle, "IDCTBenhNhan").ToString();
            //LoadList
            List <CTBenhNhanComplaint>          listComplaint          = qlND.GetDSCTBenhNhanComplaintByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanMRIImage>           listMRIImage           = qlND.GetDSCTBenhNhanMRIImageByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanCondition>          listCondition          = qlND.GetDSCTBenhNhanConditionByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanConditionDicsJoint> listConditionDicsJoint = qlND.GetDSCTBenhNhanConditionDicsJointByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanConditionVertebral> listConditionVertebral = qlND.GetDSCTBenhNhanConditionVertebralByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanExcercise>          listExcercise          = qlND.GetDSCTBenhNhanExcerciseByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanSnapShot>           listSnapShot           = qlND.GetDSCTBenhNhanSnapShotByIDCTBenhNhan(IDCTBenhNhan);
            CTBenhNhan cTBenhNhan = qlND.GetCTBenhNhanByIDCTBenhNhan(IDCTBenhNhan).SingleOrDefault();
            BenhNhan   benhNhan   = qlND.GetBenhNhanByID(IDBenhNhan);
            List <sp_GetDSExcerciseByIDCTBNResult> listEx = qlND.GetDSExcerciseByIDCTBN(IDCTBenhNhan);

            rptPatientMedical rptAll = new rptPatientMedical();

            //rptAll.parThangNam.Value = string.Format("DANH SÁCH CUỘC GỌI TỪ KHÁCH HÀNG THÁNG {0}/{1}", thang, nam);
            //rptAll.parThangNam.Visible = false;

            //rptAll.DataSource = list;
            //BindToBand
            DetailReportBand cTBenhNhanComplaint = rptAll.Bands["DetailReport_Complant"] as DetailReportBand;

            if (listComplaint.Count > 0)
            {
                cTBenhNhanComplaint.DataSource = listComplaint;
            }
            else
            {
                cTBenhNhanComplaint.Visible = false;
            }

            DetailReportBand cTBenhNhanMRIImage = rptAll.Bands["DetailReport_MRI"] as DetailReportBand;

            if (listMRIImage.Count > 0)
            {
                cTBenhNhanMRIImage.DataSource = listMRIImage;
            }
            else
            {
                cTBenhNhanMRIImage.Visible = false;
            }

            DetailReportBand cTBenhNhanDicsJoint = rptAll.Bands["DetailReport_DiscAndJoint"] as DetailReportBand;

            if (listConditionDicsJoint.Count > 0)
            {
                cTBenhNhanDicsJoint.DataSource = listConditionDicsJoint;
            }
            else
            {
                cTBenhNhanDicsJoint.Visible = false;
            }

            //List<CTBenhNhanCondition> listCondition = qlND.GetDSCTBenhNhanConditionByIDCTBenhNhan(lblCTBenhNhan.Text);
            ////DetailReportBand cTBenhNhanAnkle = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;
            ////cTBenhNhanAnkle.DataSource = cTBenhNhanConditions;
            //List<CTBenhNhanCondition> listCondition = new List<CTBenhNhanCondition>();
            //listCondition.Add(cTBenhNhanConditions);
            DetailReportBand DetailReport_Ankle      = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;
            DetailReportBand DetailReport_Elbow      = rptAll.Bands["DetailReport_Elbow"] as DetailReportBand;
            DetailReportBand DetailReport_Foot       = rptAll.Bands["DetailReport_Foot"] as DetailReportBand;
            DetailReportBand DetailReport_Hip        = rptAll.Bands["DetailReport_Hip"] as DetailReportBand;
            DetailReportBand DetailReport_Knee       = rptAll.Bands["DetailReport_Knee"] as DetailReportBand;
            DetailReportBand DetailReport_Posture    = rptAll.Bands["DetailReport_Posture"] as DetailReportBand;
            DetailReportBand DetailReport_Sacroiliac = rptAll.Bands["DetailReport_Sacroiliac"] as DetailReportBand;
            DetailReportBand DetailReport_Scoliosis  = rptAll.Bands["DetailReport_Scoliosis"] as DetailReportBand;
            DetailReportBand DetailReport_Shoulder   = rptAll.Bands["DetailReport_Shoulder"] as DetailReportBand;
            DetailReportBand DetailReport_Wrist      = rptAll.Bands["DetailReport_Wrist"] as DetailReportBand;

            if (listCondition.Count > 0)
            {
                if ((bool)listCondition[0].Ankle)
                {
                    DetailReport_Ankle.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Ankle.Visible = false;
                }

                if ((bool)listCondition[0].Elbow)
                {
                    DetailReport_Elbow.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Elbow.Visible = false;
                }

                if ((bool)listCondition[0].FootPlantar || (bool)listCondition[0].FootPronation || (bool)listCondition[0].FootSupination)
                {
                    DetailReport_Foot.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Foot.Visible = false;
                }

                if ((bool)listCondition[0].Hip)
                {
                    DetailReport_Hip.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Hip.Visible = false;
                }

                if ((bool)listCondition[0].KneeACL || (bool)listCondition[0].KneeDegeneration || (bool)listCondition[0].KneeMCL || (bool)listCondition[0].KneeMeniscus)
                {
                    DetailReport_Knee.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Knee.Visible = false;
                }

                if ((bool)listCondition[0].PostureHyperLordosis || (bool)listCondition[0].PostureKyphosis)
                {
                    DetailReport_Posture.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Posture.Visible = false;
                }

                if ((bool)listCondition[0].SacroiliacDegeneration || (bool)listCondition[0].SacroiliacInbalance || (bool)listCondition[0].SacroiliacInflammation || (bool)listCondition[0].SacroiliacNormail)
                {
                    DetailReport_Sacroiliac.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Sacroiliac.Visible = false;
                }

                if ((bool)listCondition[0].ScoliosisCervico || (bool)listCondition[0].ScoliosisCervival || (bool)listCondition[0].ScoliosisLumbar || (bool)listCondition[0].ScoliosisThoracic || (bool)listCondition[0].ScoliosisThoracolumbar)
                {
                    DetailReport_Scoliosis.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Scoliosis.Visible = false;
                }

                if ((bool)listCondition[0].ShoulderACJoint || (bool)listCondition[0].ShoulderAdhesive || (bool)listCondition[0].ShoulderBursitis || (bool)listCondition[0].ShoulderImpingement || (bool)listCondition[0].ShoulderRotator)
                {
                    DetailReport_Shoulder.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Shoulder.Visible = false;
                }

                if ((bool)listCondition[0].Wrist)
                {
                    DetailReport_Wrist.DataSource = listCondition;
                }
                else
                {
                    DetailReport_Wrist.Visible = false;
                }
            }
            else
            {
                DetailReport_Ankle.Visible      = false;
                DetailReport_Elbow.Visible      = false;
                DetailReport_Foot.Visible       = false;
                DetailReport_Hip.Visible        = false;
                DetailReport_Knee.Visible       = false;
                DetailReport_Posture.Visible    = false;
                DetailReport_Sacroiliac.Visible = false;
                DetailReport_Scoliosis.Visible  = false;
                DetailReport_Shoulder.Visible   = false;
                DetailReport_Wrist.Visible      = false;
            }
            DetailReportBand cTBenhNhanVertebral = rptAll.Bands["DetailReport_Vertebral"] as DetailReportBand;

            if (listConditionVertebral.Count > 0)
            {
                cTBenhNhanVertebral.DataSource = listConditionVertebral;
            }
            else
            {
                cTBenhNhanVertebral.Visible = false;
            }

            DetailReportBand cTBenhNhanSnap = rptAll.Bands["DetailReport_Snap"] as DetailReportBand;

            if (listSnapShot.Count > 0)
            {
                cTBenhNhanSnap.DataSource = listSnapShot;
            }
            else
            {
                cTBenhNhanSnap.Visible = false;
            }


            DetailReportBand DetailReport_Excercises = rptAll.Bands["DetailReport_Excercises"] as DetailReportBand;

            if (listEx.Count > 0)
            {
                DetailReport_Excercises.DataSource = listEx;
            }
            else
            {
                DetailReport_Excercises.Visible = false;
            }


            if (cTBenhNhan.Comment.Trim().Length > 0)
            {
                rptAll.parComment.Value   = cTBenhNhan.Comment.ToString();
                rptAll.parComment.Visible = false;
            }
            else
            {
                DetailReportBand DetailReport_Comment = rptAll.Bands["DetailReport_Comment"] as DetailReportBand;
                DetailReport_Comment.Visible = false;
                rptAll.parComment.Value      = cTBenhNhan.Comment.ToString();
                rptAll.parComment.Visible    = false;
            }

            string phone   = ConfigurationManager.AppSettings["Phone"].ToString();
            string address = ConfigurationManager.AppSettings["Address"].ToString();

            rptAll.parPhone.Value    = phone;
            rptAll.parPhone.Visible  = false;
            rptAll.parDiaChi.Value   = address;
            rptAll.parDiaChi.Visible = false;

            rptAll.parComment.Value         = cTBenhNhan.Comment.ToString();
            rptAll.parComment.Visible       = false;
            rptAll.parDate.Value            = cTBenhNhan.NgayKham.ToString();
            rptAll.parDate.Visible          = false;
            rptAll.parFileNumber.Value      = benhNhan.ID.ToString();
            rptAll.parFileNumber.Visible    = false;
            rptAll.parName.Value            = benhNhan.TenBN.ToString();
            rptAll.parName.Visible          = false;
            rptAll.parTreamentFor.Value     = cTBenhNhan.TreatmentTimeFor.ToString();
            rptAll.parTreamentFor.Visible   = false;
            rptAll.parTreamentTime.Value    = cTBenhNhan.TreatmentTime.ToString();
            rptAll.parTreamentTime.Visible  = false;
            rptAll.parTreamentTotal.Value   = cTBenhNhan.TreatmentTimeFor.ToString();
            rptAll.parTreamentTotal.Visible = false;


            ReportPrintTool tool = new ReportPrintTool(rptAll);

            //tool.PreviewForm.Shown += new EventHandler(PreviewForm_Shown);
            tool.ShowPreviewDialog();
        }
Ejemplo n.º 5
0
        public void PrintPatient(string IDBenhNhan, string IDCTBenhNhan)
        {
            //var rowHandle = gridView_CuocGoi.FocusedRowHandle;
            //// Get the value for the given column - convert to the type you're expecting
            //string IDBenhNhan = gridView_CuocGoi.GetRowCellValue(rowHandle, "IDBenhNhan").ToString();
            //string IDCTBenhNhan = gridView_CuocGoi.GetRowCellValue(rowHandle, "IDCTBenhNhan").ToString();
            //LoadList
            List <CTBenhNhanComplaint>          listComplaint          = qlND.GetDSCTBenhNhanComplaintByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanMRIImage>           listMRIImage           = qlND.GetDSCTBenhNhanMRIImageByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanCondition>          listCondition          = qlND.GetDSCTBenhNhanConditionByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanConditionDicsJoint> listConditionDicsJoint = qlND.GetDSCTBenhNhanConditionDicsJointByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanConditionVertebral> listConditionVertebral = qlND.GetDSCTBenhNhanConditionVertebralByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanExcercise>          listExcercise          = qlND.GetDSCTBenhNhanExcerciseByIDCTBenhNhan(IDCTBenhNhan);
            List <CTBenhNhanSnapShot>           listSnapShot           = qlND.GetDSCTBenhNhanSnapShotByIDCTBenhNhan(IDCTBenhNhan);
            CTBenhNhan cTBenhNhan = qlND.GetCTBenhNhanByIDCTBenhNhan(IDCTBenhNhan).SingleOrDefault();
            BenhNhan   benhNhan   = qlND.GetBenhNhanByID(IDBenhNhan);
            List <sp_GetDSExcerciseByIDCTBNResult> listEx = qlND.GetDSExcerciseByIDCTBN(IDCTBenhNhan);

            rptPatientMedical rptAll = new rptPatientMedical();

            //rptAll.parThangNam.Value = string.Format("DANH SÁCH CUỘC GỌI TỪ KHÁCH HÀNG THÁNG {0}/{1}", thang, nam);
            //rptAll.parThangNam.Visible = false;

            //rptAll.DataSource = list;
            //BindToBand
            DetailReportBand cTBenhNhanComplaint = rptAll.Bands["DetailReport_Complant"] as DetailReportBand;

            cTBenhNhanComplaint.DataSource = listComplaint;
            DetailReportBand cTBenhNhanMRIImage = rptAll.Bands["DetailReport_MRI"] as DetailReportBand;

            cTBenhNhanMRIImage.DataSource = listMRIImage;
            DetailReportBand cTBenhNhanDicsJoint = rptAll.Bands["DetailReport_DiscAndJoint"] as DetailReportBand;

            cTBenhNhanDicsJoint.DataSource = listConditionDicsJoint;

            //DetailReportBand cTBenhNhanAnkle = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;
            //cTBenhNhanAnkle.DataSource = listCondition;
            DetailReportBand DetailReport_Ankle = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;

            DetailReport_Ankle.DataSource = listCondition;
            DetailReportBand DetailReport_Elbow = rptAll.Bands["DetailReport_Elbow"] as DetailReportBand;

            DetailReport_Elbow.DataSource = listCondition;
            DetailReportBand DetailReport_Foot = rptAll.Bands["DetailReport_Foot"] as DetailReportBand;

            DetailReport_Foot.DataSource = listCondition;
            DetailReportBand DetailReport_Hip = rptAll.Bands["DetailReport_Hip"] as DetailReportBand;

            DetailReport_Hip.DataSource = listCondition;
            DetailReportBand DetailReport_Knee = rptAll.Bands["DetailReport_Knee"] as DetailReportBand;

            DetailReport_Knee.DataSource = listCondition;
            DetailReportBand DetailReport_Posture = rptAll.Bands["DetailReport_Posture"] as DetailReportBand;

            DetailReport_Posture.DataSource = listCondition;
            DetailReportBand DetailReport_Sacroiliac = rptAll.Bands["DetailReport_Sacroiliac"] as DetailReportBand;

            DetailReport_Sacroiliac.DataSource = listCondition;
            DetailReportBand DetailReport_Scoliosis = rptAll.Bands["DetailReport_Scoliosis"] as DetailReportBand;

            DetailReport_Scoliosis.DataSource = listCondition;
            DetailReportBand DetailReport_Shoulder = rptAll.Bands["DetailReport_Shoulder"] as DetailReportBand;

            DetailReport_Shoulder.DataSource = listCondition;
            DetailReportBand DetailReport_Wrist = rptAll.Bands["DetailReport_Wrist"] as DetailReportBand;

            DetailReport_Wrist.DataSource = listCondition;

            DetailReportBand cTBenhNhanVertebral = rptAll.Bands["DetailReport_Vertebral"] as DetailReportBand;

            cTBenhNhanVertebral.DataSource = listConditionVertebral;
            DetailReportBand cTBenhNhanSnap = rptAll.Bands["DetailReport_Snap"] as DetailReportBand;

            cTBenhNhanSnap.DataSource = listSnapShot;
            DetailReportBand DetailReport_Excercises = rptAll.Bands["DetailReport_Excercises"] as DetailReportBand;

            DetailReport_Excercises.DataSource = listEx;
            //DetailReportBand cTBenhNhanComment = rptAll.Bands["DetailReport_Comment"] as DetailReportBand;
            //cTBenhNhanComment.DataSource = cTBenhNhan.Comment;


            rptAll.parComment.Value         = cTBenhNhan.Comment.ToString();
            rptAll.parComment.Visible       = false;
            rptAll.parDate.Value            = cTBenhNhan.NgayKham.ToString();
            rptAll.parDate.Visible          = false;
            rptAll.parFileNumber.Value      = benhNhan.ID.ToString();
            rptAll.parFileNumber.Visible    = false;
            rptAll.parName.Value            = benhNhan.TenBN.ToString();
            rptAll.parName.Visible          = false;
            rptAll.parTreamentFor.Value     = cTBenhNhan.TreatmentTimeFor.ToString();
            rptAll.parTreamentFor.Visible   = false;
            rptAll.parTreamentTime.Value    = cTBenhNhan.TreatmentTime.ToString();
            rptAll.parTreamentTime.Visible  = false;
            rptAll.parTreamentTotal.Value   = cTBenhNhan.TreatmentTimeFor.ToString();
            rptAll.parTreamentTotal.Visible = false;


            ReportPrintTool tool = new ReportPrintTool(rptAll);

            //tool.PreviewForm.Shown += new EventHandler(PreviewForm_Shown);
            tool.ShowPreviewDialog();
        }
Ejemplo n.º 6
0
        private void btnSavePrint_Click(object sender, System.EventArgs e)
        {
            try
            {
                if (CheckValidatePatient())
                {
                    BenhNhan bn = GetInfBenhNhan();
                    qlND.InsertBenhNhan(bn);

                    CTBenhNhan ctbn = GetInfCTBenhNhan();
                    qlND.InsertCTBenhNhan(ctbn);

                    List <CTBenhNhanComplaint> listComplaint = GetInfCTBenhNhanComplaint();
                    qlND.InsertListCTBenhNhanComplaint(listComplaint);

                    List <CTBenhNhanConditionDicsJoint> listDiscJoint = GetInfCTBenhNhanConditionDicsJoint();
                    qlND.InsertListCTBenhNhanConditionDicsJoint(listDiscJoint);

                    CTBenhNhanCondition cTBenhNhanConditions = GetInfCTBenhNhanCondition();
                    qlND.InsertCTBenhNhanCondition(cTBenhNhanConditions);

                    List <CTBenhNhanConditionVertebral> listCTBenhNhanConditionVertebral = GetInfCTBenhNhanConditionVertebral();
                    qlND.InsertListCTBenhNhanConditionVertebral(listCTBenhNhanConditionVertebral);

                    List <CTBenhNhanExcercise> ListCTBenhNhanExcercises = GetInfCTBenhNhanExcercise();
                    qlND.InsertListCTBenhNhanExcercise(ListCTBenhNhanExcercises);

                    List <CTBenhNhanMRIImage> listCTBenhNhanMRIImage = GetInfCTBenhNhanMRIImage();
                    qlND.InsertListCTBenhNhanMRIImage(listCTBenhNhanMRIImage);

                    List <CTBenhNhanSnapShot> listCTBenhNhanSnapShot = GetInfCTBenhNhanSnapShot();
                    qlND.InsertListCTBenhNhanSnapShot(listCTBenhNhanSnapShot);

                    //PrintPatient(txtFileNumberPatient.Text, lblCTBenhNhan.Text);
                    //Print
                    rptPatientMedical rptAll = new rptPatientMedical();

                    //rptAll.parThangNam.Value = string.Format("DANH SÁCH CUỘC GỌI TỪ KHÁCH HÀNG THÁNG {0}/{1}", thang, nam);
                    //rptAll.parThangNam.Visible = false;

                    //rptAll.DataSource = list;
                    //BindToBand
                    DetailReportBand cTBenhNhanComplaint = rptAll.Bands["DetailReport_Complant"] as DetailReportBand;
                    cTBenhNhanComplaint.DataSource = listComplaint;
                    DetailReportBand cTBenhNhanMRIImage = rptAll.Bands["DetailReport_MRI"] as DetailReportBand;
                    cTBenhNhanMRIImage.DataSource = listCTBenhNhanMRIImage;
                    DetailReportBand cTBenhNhanDicsJoint = rptAll.Bands["DetailReport_DiscAndJoint"] as DetailReportBand;
                    cTBenhNhanDicsJoint.DataSource = listDiscJoint;

                    //List<CTBenhNhanCondition> listCondition = qlND.GetDSCTBenhNhanConditionByIDCTBenhNhan(lblCTBenhNhan.Text);
                    ////DetailReportBand cTBenhNhanAnkle = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;
                    ////cTBenhNhanAnkle.DataSource = cTBenhNhanConditions;
                    List <CTBenhNhanCondition> listCondition = new List <CTBenhNhanCondition>();
                    listCondition.Add(cTBenhNhanConditions);
                    DetailReportBand DetailReport_Ankle = rptAll.Bands["DetailReport_Ankle"] as DetailReportBand;
                    DetailReport_Ankle.DataSource = listCondition;
                    DetailReportBand DetailReport_Elbow = rptAll.Bands["DetailReport_Elbow"] as DetailReportBand;
                    DetailReport_Elbow.DataSource = listCondition;
                    DetailReportBand DetailReport_Foot = rptAll.Bands["DetailReport_Foot"] as DetailReportBand;
                    DetailReport_Foot.DataSource = listCondition;
                    DetailReportBand DetailReport_Hip = rptAll.Bands["DetailReport_Hip"] as DetailReportBand;
                    DetailReport_Hip.DataSource = listCondition;
                    DetailReportBand DetailReport_Knee = rptAll.Bands["DetailReport_Knee"] as DetailReportBand;
                    DetailReport_Knee.DataSource = listCondition;
                    DetailReportBand DetailReport_Posture = rptAll.Bands["DetailReport_Posture"] as DetailReportBand;
                    DetailReport_Posture.DataSource = listCondition;
                    DetailReportBand DetailReport_Sacroiliac = rptAll.Bands["DetailReport_Sacroiliac"] as DetailReportBand;
                    DetailReport_Sacroiliac.DataSource = listCondition;
                    DetailReportBand DetailReport_Scoliosis = rptAll.Bands["DetailReport_Scoliosis"] as DetailReportBand;
                    DetailReport_Scoliosis.DataSource = listCondition;
                    DetailReportBand DetailReport_Shoulder = rptAll.Bands["DetailReport_Shoulder"] as DetailReportBand;
                    DetailReport_Shoulder.DataSource = listCondition;
                    DetailReportBand DetailReport_Wrist = rptAll.Bands["DetailReport_Wrist"] as DetailReportBand;
                    DetailReport_Wrist.DataSource = listCondition;

                    DetailReportBand cTBenhNhanVertebral = rptAll.Bands["DetailReport_Vertebral"] as DetailReportBand;
                    cTBenhNhanVertebral.DataSource = listCTBenhNhanConditionVertebral;
                    DetailReportBand cTBenhNhanSnap = rptAll.Bands["DetailReport_Snap"] as DetailReportBand;
                    cTBenhNhanSnap.DataSource = listCTBenhNhanSnapShot;


                    List <sp_GetDSExcerciseByIDCTBNResult> listEx2 = qlND.GetDSExcerciseByIDCTBN(lblCTBenhNhan.Text);
                    DetailReportBand DetailReport_Excercises       = rptAll.Bands["DetailReport_Excercises"] as DetailReportBand;
                    DetailReport_Excercises.DataSource = listEx2;



                    rptAll.parComment.Value         = ctbn.Comment.ToString();
                    rptAll.parComment.Visible       = false;
                    rptAll.parDate.Value            = ctbn.NgayKham.ToString();
                    rptAll.parDate.Visible          = false;
                    rptAll.parFileNumber.Value      = bn.ID.ToString();
                    rptAll.parFileNumber.Visible    = false;
                    rptAll.parName.Value            = bn.TenBN.ToString();
                    rptAll.parName.Visible          = false;
                    rptAll.parTreamentFor.Value     = ctbn.TreatmentTimeFor.ToString();
                    rptAll.parTreamentFor.Visible   = false;
                    rptAll.parTreamentTime.Value    = ctbn.TreatmentTime.ToString();
                    rptAll.parTreamentTime.Visible  = false;
                    rptAll.parTreamentTotal.Value   = ctbn.TreatmentTimeFor.ToString();
                    rptAll.parTreamentTotal.Visible = false;


                    ReportPrintTool tool = new ReportPrintTool(rptAll);
                    //tool.PreviewForm.Shown += new EventHandler(PreviewForm_Shown);
                    tool.ShowPreviewDialog();
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Save error");
            }
        }