Example #1
0
        public void InitData()
        {
            mainForm = this.ParentForm as frmMain;
            adoUtil = new AdoUtil(mainForm);
            student = new VoStudent();
            studentSmoke = new VoStudent();
            inbodyInfo = new VoInbody();
            smokeInfo = new VoSmokeInfo();

            // 로그인 여부 체크
            if (mainForm._isLogin == false)
            {
                mainForm.btnLogout.Visible = false;
                mainForm.btnLogout.Hide();

                mainForm.LoadLoginControl();

                return;
            }

            InitializeDataGridView();

            // 학교 검색
            GetSearchSchoolInfo(String.Empty);

            // 시리얼 포트 오픈
            OpenSerialPort(false);
        }
Example #2
0
        public bool InsertInbodyMeasureInfo(VoStudent student, VoInbody inbodyInfo)
        {
            bool result = true;

            MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = this._connectionString;

            MySqlCommand cmd = new MySqlCommand();
            MySqlTransaction tx = null;
            MySqlDataAdapter sqlAdapter = null;

            string querySelectInbodySeq = "select ifnull(max(Inbody_seq + 1), 0) as inbody_seq from inbody_info";

            string queryInsertInbodyInfo =
                "INSERT INTO INBODY_INFO(INBODY_SEQ, DATETIMES, Weight, Protein_Mass, Mineral_Mass, Body_Fat_Mass" +
                ", Total_Body_Water, Soft_Lean_Mass, Fat_Free_Mass, OSSEOUS, Skeletal_Muscle_Mass, BMI" +
                ", Percent_Body_Fat, Waist_Hip_Ratio, Target_Weight,Weight_Control, Fat_Control, Muscle_Control" +
                ", Fitness_Score, BMR, Neck, Chest, ABD, THIGHL, ACL, HIP, THIGHR, ACR, Protein_Max, Protein_Min" +
                ", Mineral_Max, Mineral_Min, Body_Fat_Mass_Max, Body_Fat_Mass_Min, Weight_Max, Weight_Min" +
                ", Skeletal_Muscle_Mass_Max, Skeletal_Muscle_Mass_Min, BMI_Max, BMI_Min, Percent_Body_Fat_Max" +
                ", Percent_Body_Fat_Min, Waist_Hip_Ratio_Max, Waist_Hip_Ratio_Min, BMR_MAX, BMR_MIN, FCHEST" +
                ", FABD, FACR, FACL, FTHIGHR, FTHIGHL, HEIGHT)" +
                "VALUES(@inbody_seq, @datetimes, @weight, @protein_Mass, @mineral_Mass, @body_Fat_Mass, @total_Body_Water" +
                ", @soft_Lean_Mass, @fat_Free_Mass, @oSSEOUS, @skeletal_Muscle_Mass, @bMI, @percent_Body_Fat, @waist_Hip_Ratio" +
                ", @target_Weight, @weight_Control, @fat_Control, @muscle_Control, @fitness_Score, @bMR, @neck, @chest, @aBD, @tHIGHL" +
                ", @aCL, @hIP, @tHIGHR, @aCR, @protein_Max, @protein_Min, @mineral_Max, @mineral_Min, @body_Fat_Mass_Max, @body_Fat_Mass_Min" +
                ", @weight_Max, @weight_Min, @skeletal_Muscle_Mass_Max, @skeletal_Muscle_Mass_Min, @bMI_Max, @bMI_Min, @percent_Body_Fat_Max" +
                ", @percent_Body_Fat_Min, @waist_Hip_Ratio_Max, @waist_Hip_Ratio_Min, @bMR_MAX, @bMR_MIN, @fCHEST, @fABD, @fACR, @fACL, @fTHIGHR" +
                ", @fTHIGHL, @hEIGHT)";

            string queryInsertMeasureInfo = @"	INSERT INTO MEASURE_INFO (member_id, school_id, inbody_seq, school_grade, school_grade_id, school_ban, measure_date, created_date)
                                                VALUES (@member_id, @school_id, @inbody_seq, @school_grade, @school_grade_id, @school_ban, @measure_date, now())";
            string queryUpdateMeasureInfo = @"	UPDATE MEASURE_INFO SET inbody_seq = @inbody_seq, measure_date = @measure_date, created_date = now()
                                                    , school_grade = @school_grade, school_grade_id = @school_grade_id, school_ban = @school_ban, school_id = @school_id
                                                WHERE measure_id = @measure_id";

            try
            {
                conn.Open();
                cmd.Connection = conn;
                tx = conn.BeginTransaction();

                if (result)
                {
                    cmd.CommandText = querySelectInbodySeq;

                    sqlAdapter = new MySqlDataAdapter(cmd.CommandText, conn);

                    DataTable dt = new DataTable();
                    sqlAdapter.Fill(dt);

                    if (dt.Rows.Count > 0)
                    {
                        cmd.CommandText = queryInsertInbodyInfo;
                        cmd.Parameters.Clear();

                        // Inbody 데이터 저장
                        inbodyInfo.Inbody_seq = dt.Rows[0][0].ToString();

                        cmd.Parameters.AddWithValue("@inbody_seq", inbodyInfo.Inbody_seq);
                        cmd.Parameters.AddWithValue("@datetimes", inbodyInfo.DateTimes);
                        cmd.Parameters.AddWithValue("@weight", inbodyInfo.Weight);
                        cmd.Parameters.AddWithValue("@protein_Mass", inbodyInfo.Protein_Mass);
                        cmd.Parameters.AddWithValue("@mineral_Mass", inbodyInfo.Mineral_Mass);
                        cmd.Parameters.AddWithValue("@body_Fat_Mass", inbodyInfo.Body_Fat_Mass);
                        cmd.Parameters.AddWithValue("@total_Body_Water", inbodyInfo.Total_Body_Water);
                        cmd.Parameters.AddWithValue("@soft_Lean_Mass", inbodyInfo.Soft_Lean_Mass);
                        cmd.Parameters.AddWithValue("@fat_Free_Mass", inbodyInfo.Fat_Free_Mass);
                        cmd.Parameters.AddWithValue("@oSSEOUS", inbodyInfo.OSSEOUS);
                        cmd.Parameters.AddWithValue("@skeletal_Muscle_Mass", inbodyInfo.Skeletal_Muscle_Mass);
                        cmd.Parameters.AddWithValue("@bMI", inbodyInfo.BMI);
                        cmd.Parameters.AddWithValue("@percent_Body_Fat", inbodyInfo.Percent_Body_Fat);
                        cmd.Parameters.AddWithValue("@waist_Hip_Ratio", inbodyInfo.Waist_Hip_Ratio);
                        cmd.Parameters.AddWithValue("@target_Weight", inbodyInfo.Target_Weight);
                        cmd.Parameters.AddWithValue("@weight_Control", inbodyInfo.Weight_Control);
                        cmd.Parameters.AddWithValue("@fat_Control", inbodyInfo.Fat_Control);
                        cmd.Parameters.AddWithValue("@muscle_Control", inbodyInfo.Muscle_Control);
                        cmd.Parameters.AddWithValue("@fitness_Score", inbodyInfo.Fitness_Score);
                        cmd.Parameters.AddWithValue("@bMR", inbodyInfo.BMR);
                        cmd.Parameters.AddWithValue("@neck", inbodyInfo.Neck);
                        cmd.Parameters.AddWithValue("@chest", inbodyInfo.Chest);
                        cmd.Parameters.AddWithValue("@aBD", inbodyInfo.ABD);
                        cmd.Parameters.AddWithValue("@tHIGHL", inbodyInfo.THIGHL);
                        cmd.Parameters.AddWithValue("@aCL", inbodyInfo.ACL);
                        cmd.Parameters.AddWithValue("@hIP", inbodyInfo.HIP);
                        cmd.Parameters.AddWithValue("@tHIGHR", inbodyInfo.THIGHR);
                        cmd.Parameters.AddWithValue("@aCR", inbodyInfo.ACR);
                        cmd.Parameters.AddWithValue("@protein_Max", inbodyInfo.Protein_Max);
                        cmd.Parameters.AddWithValue("@protein_Min", inbodyInfo.Protein_Min);
                        cmd.Parameters.AddWithValue("@mineral_Max", inbodyInfo.Mineral_Max);
                        cmd.Parameters.AddWithValue("@mineral_Min", inbodyInfo.Mineral_Min);
                        cmd.Parameters.AddWithValue("@body_Fat_Mass_Max", inbodyInfo.Body_Fat_Mass_Max);
                        cmd.Parameters.AddWithValue("@body_Fat_Mass_Min", inbodyInfo.Body_Fat_Mass_Min);
                        cmd.Parameters.AddWithValue("@weight_Max", inbodyInfo.Weight_Max);
                        cmd.Parameters.AddWithValue("@weight_Min", inbodyInfo.Weight_Min);
                        cmd.Parameters.AddWithValue("@skeletal_Muscle_Mass_Max", inbodyInfo.Skeletal_Muscle_Mass_Max);
                        cmd.Parameters.AddWithValue("@skeletal_Muscle_Mass_Min", inbodyInfo.Skeletal_Muscle_Mass_Min);
                        cmd.Parameters.AddWithValue("@bMI_Max", inbodyInfo.BMI_Max);
                        cmd.Parameters.AddWithValue("@bMI_Min", inbodyInfo.BMI_Min);
                        cmd.Parameters.AddWithValue("@percent_Body_Fat_Max", inbodyInfo.Percent_Body_Fat_Max);
                        cmd.Parameters.AddWithValue("@percent_Body_Fat_Min", inbodyInfo.Percent_Body_Fat_Min);
                        cmd.Parameters.AddWithValue("@waist_Hip_Ratio_Max", inbodyInfo.Waist_Hip_Ratio_Max);
                        cmd.Parameters.AddWithValue("@waist_Hip_Ratio_Min", inbodyInfo.Waist_Hip_Ratio_Min);
                        cmd.Parameters.AddWithValue("@bMR_MAX", inbodyInfo.BMR_MAX);
                        cmd.Parameters.AddWithValue("@bMR_MIN", inbodyInfo.BMR_MIN);
                        cmd.Parameters.AddWithValue("@fCHEST", inbodyInfo.FCHEST);
                        cmd.Parameters.AddWithValue("@fABD", inbodyInfo.FABD);
                        cmd.Parameters.AddWithValue("@fACR", inbodyInfo.FACR);
                        cmd.Parameters.AddWithValue("@fACL", inbodyInfo.FACL);
                        cmd.Parameters.AddWithValue("@fTHIGHR", inbodyInfo.FTHIGHR);
                        cmd.Parameters.AddWithValue("@fTHIGHL", inbodyInfo.FTHIGHL);
                        cmd.Parameters.AddWithValue("@hEIGHT", inbodyInfo.HEIGHT);

                        cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        result = false;
                    }
                }

                if (result)
                {
                    // 측정 정보 기록
                    bool isUpdateMeasureInfo = false;

                    // 학생 측정 이력 정보 조회
                    int studentId = Int32.Parse(student.ID);
                    DataTable dt = SelectSchoolMemberHistoryInfo(studentId);

                    if (dt != null && dt.Rows.Count > 0)
                    {
                        // 가장 마지막 측정일 정보를 가져온다.
                        student.LastMeasureDate = Convert.ToDateTime(dt.Rows[0]["measure_date"].ToString()).ToString("yyyy-MM-dd");
                        student.UpdateMeasureSeq = dt.Rows[0]["measure_id"].ToString();
                    }

                    // 이전 측정 정보 기록이 있을 때
                    if (!String.IsNullOrWhiteSpace(student.LastMeasureDate))
                    {
                        DateTime now_date = DateTime.Now;
                        DateTime last_measure_date = DateTime.Parse(student.LastMeasureDate);

                        // 이전 측정 정보 기록일이 현재의 월과 같은 경우에는 업데이트
                        if (now_date.Year == last_measure_date.Year && now_date.Month == last_measure_date.Month)
                        {
                            isUpdateMeasureInfo = true;
                        }
                    }

                    if (result)
                    {
                        // UPDATE
                        if (isUpdateMeasureInfo)
                        {
                            cmd.CommandText = queryUpdateMeasureInfo;
                            cmd.Parameters.Clear();

                            cmd.Parameters.AddWithValue("@inbody_seq", inbodyInfo.Inbody_seq);
                            cmd.Parameters.AddWithValue("@measure_date", student.Measure_Date);
                            cmd.Parameters.AddWithValue("@school_id", student.SchoolID);
                            cmd.Parameters.AddWithValue("@school_grade", student.Grade);
                            cmd.Parameters.AddWithValue("@school_grade_id", student.Grade_ID);
                            cmd.Parameters.AddWithValue("@school_ban", student.ClassNumber);
                            cmd.Parameters.AddWithValue("@measure_id", student.UpdateMeasureSeq);
                        }
                        else
                        {
                            cmd.CommandText = queryInsertMeasureInfo;
                            cmd.Parameters.Clear();

                            cmd.Parameters.AddWithValue("@member_id", student.ID);
                            cmd.Parameters.AddWithValue("@school_id", student.SchoolID);
                            cmd.Parameters.AddWithValue("@inbody_seq", inbodyInfo.Inbody_seq);
                            cmd.Parameters.AddWithValue("@school_grade", student.Grade);
                            cmd.Parameters.AddWithValue("@school_grade_id", student.Grade_ID);
                            cmd.Parameters.AddWithValue("@school_ban", student.ClassNumber);
                            cmd.Parameters.AddWithValue("@measure_date", student.Measure_Date);
                        }

                        cmd.ExecuteNonQuery();
                    }
                }

                if (result)
                {
                    tx.Commit();
                }
                else
                {
                    tx.Rollback();
                }
            }
            catch (Exception e)
            {
                if (tx != null)
                {
                    tx.Rollback();
                }

                _mainForm._isError = true;
                _mainForm.ShowNotice(e.Message);
                return false;
            }
            finally
            {
                conn.Close();

                if (tx != null)
                {
                    tx.Dispose();
                }
            }

            return result;
        }
Example #3
0
        private void btnInbodyComplete_Click(object sender, EventArgs e)
        {
            isFirstShowInbodyNotice = true;

            if (String.IsNullOrWhiteSpace(student.ID))
            {
                mainForm.ShowNotice("학생이 선택되지 않았습니다.");
                return;
            }

            // Inbody
            if (String.IsNullOrWhiteSpace(this.txtWeight.Text))
            {
                mainForm.ShowNotice("인바디 측정이 진행되지 않았습니다.");
                return;
            }

            bool isSuccess = adoUtil.InsertInbodyMeasureInfo(student, inbodyInfo);

            if (isSuccess)
            {
                mainForm.ShowNotice("정상적으로 처리되었습니다.");

                progressBar1.Value = 0;
                lblInbodyPercent.Text = "0%";
                txtHeight.Text = "";
                txtWeight.Text = "";
                txtBMI.Text = "";

                inbodyInfo = new VoInbody();

                // 학생 정보 재조회
                dgvMember_SelectionChanged(dgvMember, null);
            }
        }