Пример #1
0
        /// <summary>
        /// <para>기능 :  매장 업데이터</para>
        /// <para>진입 :  메시지 박스 yes클릭</para>
        /// <para>분기 :  1. 버튼 텍스트 == &quot;변경&quot;</para>
        /// <para>        2. queryResult >0</para>
        /// <para>로직 :  1. if 버튼 텍스트 == &quot;변경&quot;</para>
        /// <para>            2. readonlyTextBoxAndDatetimePicker</para>
        /// <para>            3. buttonEnableToggle</para>
        /// <para>            4. 버튼 텍스트 &quot;적용&quot;으로 변경</para>
        /// <para>            5. return</para>
        /// <para>        6. 매장 코드를 기준으로 queryRead &amp; crud.Read를 통해 st_table 객체 생성</para>
        /// <para>        7. st_table객체에 변경된 값 할당</para>
        /// <para>        8. 매장 코드를 기준 queryUpdate &amp; crud.Update 를 진행</para>
        /// <para>        9. if queryResult >0</para>
        /// <para>            10. buttonEnableToggle</para>
        /// <para>            11. readonlyTextBoxAndDatetimePicker</para>
        /// <para>            12. 성공 메시지박스</para>
        /// <para>            13. readStoreTablePattern</para>
        /// <para>            14. 버튼 텍스트 &quot;변경&quot;으로 변경</para>
        /// <para>        15. 메시지 박스 &quot;실패&quot;</para>
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void buttonUpdate_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("변경하시겟습니까?", "변경", MessageBoxButtons.YesNo) == DialogResult.Yes && st_code != null)
            {
                if (buttonUpdate.Text == "변경")
                {
                    // 검색시 항목 변경 가능 처리
                    readonlyTextBoxAndDatetimePicker(false);

                    buttonEnableToggle(true, buttonForCreateAndUpdateArray);

                    buttonUpdate.Text = "적용";
                    return;
                }
                string   queryUpdate = sqlQuery.Update_Set_("st_table", new St_table(), "St_code");
                string   queryRead   = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_code" }, new string[] { st_code });
                St_table storeRead   = crud.Read_MySql(queryRead, new St_table());

                St_table store = new St_table
                {
                    St_code          = storeRead.St_code,
                    St_date          = storeRead.St_date,
                    St_name          = textBoxStroeName.Text,
                    St_manager       = textBoxAdminName.Text,
                    St_zip           = textBoxAddressZip.Text,
                    St_addr1         = textBoxAddress.Text,
                    St_addr2         = textBoxAddress2.Text,
                    St_info1         = textBoxContractInformation.Text,
                    St_info2         = textBoxBasicInformation.Text,
                    St_contractdate  = dateTimePickerContractDate.Value,
                    St_contractdate2 = dateTimePickerContractDate2.Value,
                    St_ele_date      = dateTimePickerElectricityExpense.Value,
                    St_maint_date    = dateTimePickerManagementExpense.Value,
                    St_sudo_date     = dateTimePickerWaterExpense.Value
                };

                int result = crud.Update_MySql(queryUpdate, store);

                if (result > 0)
                {
                    buttonEnableToggle(false, buttonForCreateAndUpdateArray);

                    readonlyTextBoxAndDatetimePicker(true);

                    MessageBox.Show("성공");

                    readStoreTablePattern();

                    buttonUpdate.Text = "변경";

                    return;
                }
                MessageBox.Show("실패");
            }
        }
Пример #2
0
        //추가 처리 필요
        private void buttonAddStore_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("등록하시겟습니까?", "등록", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                if (buttonAddStore.Text == "등록")
                {
                    buttonEnableToggle(true, buttonForCreateAndUpdateArray);
                    dataGridViewEmployee.DataSource = null;
                    dataGridViewExpense.DataSource  = null;
                    readonlyTextBoxAndDatetimePicker(false);
                    clearDatetimePickerAndTextBox();
                    buttonAddStore.Text = "적용";
                    return;
                }
                if (buttonAddStore.Text == "적용")
                {
                    string   queryReadMaxStcode = sqlQuery.selectAllFrom_Where_Select_MINMAX_From_("st_table", "max", "st_code");
                    St_table store = crud.Read_MySql(queryReadMaxStcode, new St_table());
                    store.St_code          = (Convert.ToInt32(store.St_code) + 1).ToString();
                    store.St_name          = textBoxStroeName.Text;
                    store.St_manager       = textBoxAdminName.Text;
                    store.St_zip           = textBoxAddressZip.Text;
                    store.St_addr1         = textBoxAddress.Text;
                    store.St_addr2         = textBoxAddress2.Text;
                    store.St_info1         = textBoxContractInformation.Text;
                    store.St_info2         = textBoxBasicInformation.Text;
                    store.St_contractdate  = dateTimePickerContractDate.Value;
                    store.St_contractdate2 = dateTimePickerContractDate2.Value;
                    store.St_ele_date      = dateTimePickerElectricityExpense.Value;
                    store.St_maint_date    = dateTimePickerManagementExpense.Value;
                    store.St_sudo_date     = dateTimePickerWaterExpense.Value;
                    store.St_date          = DateTime.Now;
                    string queryCreate = sqlQuery.InsertInto__Values_(store);
                    int    result      = crud.Create_MySql(queryCreate, store);

                    if (result > 0)
                    {
                        buttonEnableToggle(false, buttonForCreateAndUpdateArray);
                        MessageBox.Show("성공");
                        readStoreTablePattern();
                        buttonAddStore.Text = "등록";
                        readonlyTextBoxAndDatetimePicker(true);
                        clearDatetimePickerAndTextBox();

                        return;
                    }
                    MessageBox.Show("실패");
                    clearDatetimePickerAndTextBox();
                }
            }
        }
Пример #3
0
        /// <summary>
        /// <para>종류 :  버튼클릭 이벤트</para>
        /// <para>기능 :  매장 삭제</para>
        /// <para>진입 :  1. 삭제 체크된 매장List.Count() > 0</para>
        /// <para>분기 :  1. 메시지 박스 Yes클릭</para>
        /// <para>        2. queryResult > 0</para>
        /// <para>로직 :  1. 체크된 매장수 0보다 클 경우 진입</para>
        /// <para>            2. 메시지 박스에 삭제 체크된 매장이름을 띄우며 재확인 요청</para>
        /// <para>                3. 승인 시 매장List를 돌며 반복 삭제 진행</para>
        /// <para>                4. 해당 매장 이름을 이용하여 queryRead와 queryDelete를 만들고 Crud.Read를 통해 조회, 그결과를 바탕으로 Crud.Delete를 진행</para>
        /// <para>                    5. Crud.Delete반환 결과에 따라 성공시 매장이름 기록, 실패시 이전에 성공한 매장이름을 보여주며 실패 메시지박스 출력. 그 후 readStoreTablePattern메서드를 활용하여 테이블 새로고침 후 return</para>
        /// <para>                6. 실패가 없을시 삭제에 성공한 모든 매장이름을 메시지 박스로 출력</para>
        /// <para>                7. readStoreTablePattern메서드를 활용하여 테이블 새로고침</para>
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void buttonDeleteStore_Click(object sender, EventArgs e)
        {
            //체크 박스 추가
            //체크 된 사용자 이름 list에 담기
            //list를 돌면서 패턴 실행
            //패턴
            //list[i]를 통해 st_code를 얻음
            //query를 생성하고 crud,delete를 통해 삭제처리
            //결과에 따라 성공/실패 분기
            //
            string checkedNames = "";

            if (setCheckedStoreName.Count > 0)
            {
                //삭제 체크된 이름들 출력
                foreach (var v in setCheckedStoreName)
                {
                    checkedNames += v + " ";
                }

                if (MessageBox.Show(checkedNames + "선택", "주의", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    string resultName = "";
                    foreach (var v in setCheckedStoreName)
                    {
                        string   queryRead = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_name" }, new string[] { v });
                        St_table store     = crud.Read_MySql(queryRead, new St_table());

                        string queryDelete = sqlQuery.deleteFrom_Where_("st_table", "st_code");
                        int    queryResult = crud.Delete_MySql(queryDelete, store);

                        if (queryResult > 0)
                        {
                            resultName += v + " ";
                            continue;
                        }
                        MessageBox.Show($"({ resultName})삭제 성공, ({v})삭제 실패");
                        //매장목록 새로고침
                        readStoreTablePattern();

                        return;
                    }
                    MessageBox.Show(resultName + "삭제 성공");
                    //매장목록 새로고침
                    readStoreTablePattern();
                }
            }
        }
Пример #4
0
        /// <summary>
        /// <para>기능 :  실적관리 페이지로 이동</para>
        /// <para>진입 :  </para>
        /// <para>분기 :  </para>
        /// <para>로직 :  1. 매장 코드를 바탕으로 queryRead&amp;Crud.Read 로 st_table 객체 얻음</para>
        /// <para>        2. st_table.st_name을 상단 중앙 라벨에 할당하고 보이도록 설정</para>
        /// <para>        3. 실적패널 보이고 다른패널 안보이게</para>
        /// <para>        4. buttonColorChange</para>
        /// <para>        5. 유저컨트롤2(실적관리) 실적관리 콘트롤에 더함</para>
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void buttonResultManegeTemp_Click(object sender, EventArgs e)
        {
            string   queryReadSt_table = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_code" }, new string[] { employee.st_code });
            St_table st_table          = crud.Read_MySql(queryReadSt_table, new St_table());

            //매장명 세팅 및 보이기
            labelStroeNameVisibleAfterClickResult.Text    = st_table.St_name;
            labelStroeNameVisibleAfterClickResult.Visible = true;


            panelResultManage.Visible = true;
            panelResultManage.BringToFront();
            panelEmployeeManage.Visible = false;

            buttonColorChange(sender);

            UserControl2 userControl2 = new UserControl2(employee, sqlQuery, crud, tempFuncForWinform);

            userControl2.Dock = DockStyle.Fill;

            panelResultManage.Controls.Clear();

            panelResultManage.Controls.Add(userControl2);
        }
Пример #5
0
        private void dataGridViewStore_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            resetToDefault();

            if (e.RowIndex >= 0 && e.ColumnIndex >= 1)
            {
                // 검색시 항목 변경 불가 처리
                readonlyTextBoxAndDatetimePicker(true);
                buttonEnableToggle(false, buttonForCreateAndUpdateArray);

                // 셀 클릭시 해당 row의 매장명 저장
                string selectedStoreName = ((sender as DataGridView).Rows[e.RowIndex].Cells["매장명"].Value.ToString());

                // 해당 매장명 row 클릭시 해당 매장명을 통해 데이터 조회 후 오른쪽에 데이터를 뿌림
                string   queryReadStoreSelected = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_name" }, new string[] { selectedStoreName });
                St_table store = crud.Read_MySql(queryReadStoreSelected, new St_table());
                st_code = store.St_code;
                textBoxStroeName.Text                  = store.St_name;
                textBoxAdminName.Text                  = store.St_manager;
                textBoxAddressZip.Text                 = store.St_zip;
                textBoxAddress.Text                    = store.St_addr1;
                textBoxAddress2.Text                   = store.St_addr2;
                textBoxContractInformation.Text        = store.St_info1;
                textBoxBasicInformation.Text           = store.St_info2;
                dateTimePickerContractDate.Value       = store.St_contractdate;
                dateTimePickerContractDate2.Value      = store.St_contractdate2;
                dateTimePickerManagementExpense.Value  = store.St_maint_date;
                dateTimePickerElectricityExpense.Value = store.St_ele_date;
                dateTimePickerWaterExpense.Value       = store.St_sudo_date;



                // Panel_Main_Third datatable할당
                string columnResult = "MONTH(st_exp_date) AS MONTH, SUM(ST_EXP_BASIC) AS ST_EXP_BASIC, SUM(ST_EXP_COUPON) AS ST_EXP_COUPON, SUM(ST_EXP_AD) AS ST_EXP_AD, SUM(ST_EXP_ACCE) AS ST_EXP_ACCE, SUM(ST_EXP_QUICK) AS ST_EXP_QUICK, SUM(ST_EXP_CONS) AS ST_EXP_CONS, SUM(ST_EXP_ARTI) AS ST_EXP_ARTI";
                string queryTemp    = sqlQuery.select_Sum__From_Where_GroupBy_(columnResult, "st_expense", "st_code", st_code, "Month(st_exp_date)");
                //string queryReadExpense = sqlQuery.select_From_Where("st_expense", new string[] { "st_exp_basic", "st_exp_coupon", "st_exp_ad", "st_exp_acce", "st_exp_quick", "st_exp_cons", "st_exp_arti" }, "st_code", new string[] { store.St_code });
                DataSet dataSetExpense = crud.ReadToGrid_MySql(queryTemp);

                dataSetExpense.Tables[0].Columns["MONTH"].ColumnName         = "월";
                dataSetExpense.Tables[0].Columns["st_exp_basic"].ColumnName  = "일반";
                dataSetExpense.Tables[0].Columns["st_exp_coupon"].ColumnName = "쿠폰";
                dataSetExpense.Tables[0].Columns["st_exp_ad"].ColumnName     = "광고비";
                dataSetExpense.Tables[0].Columns["st_exp_acce"].ColumnName   = "액세사리";
                dataSetExpense.Tables[0].Columns["st_exp_quick"].ColumnName  = "퀵";
                dataSetExpense.Tables[0].Columns["st_exp_cons"].ColumnName   = "택배";
                dataSetExpense.Tables[0].Columns["st_exp_arti"].ColumnName   = "용품판매";

                tempFuncForWinform.setDataGridView(dataSetExpense, dataGridViewExpense);

                // Panel_Main_Forth datatable 할당
                string  queryReadEmployee = sqlQuery.select_From_Where("st_employee", new string[] { "st_emp_level", "st_emp_member", "st_emp_state", "st_emp_time", "st_emp_year", "st_emp_etc" }, "st_code", new string[] { store.St_code });
                DataSet dataSetEmployee   = crud.ReadToGrid_MySql(queryReadEmployee);

                dataSetEmployee.Tables[0].Columns["st_emp_level"].ColumnName  = "직급";
                dataSetEmployee.Tables[0].Columns["st_emp_member"].ColumnName = "이름";
                dataSetEmployee.Tables[0].Columns["st_emp_state"].ColumnName  = "상태";
                dataSetEmployee.Tables[0].Columns["st_emp_time"].ColumnName   = "근무시간";
                dataSetEmployee.Tables[0].Columns["st_emp_year"].ColumnName   = "년차";
                dataSetEmployee.Tables[0].Columns["st_emp_etc"].ColumnName    = "비고";

                dataGridViewEmployee.Columns.Clear();

                DataColumn dataColumn = new DataColumn();
                dataColumn.ColumnName = "No";
                dataSetEmployee.Tables[0].Columns.Add(dataColumn);
                dataColumn.SetOrdinal(0);

                tempFuncForWinform.setDataGridView(dataSetEmployee, dataGridViewEmployee);
                for (int i = 0; i < dataSetEmployee.Tables[0].Rows.Count; i++)
                {
                    dataGridViewEmployee.Rows[i].Cells[0].Value = i + 1;
                }
                ;
                dataColumn.ReadOnly = true;

                //Panel_Select_Employee 할당

                string  queryReadEmployeePanel = sqlQuery.select_From_Where("st_employee", new string[] { "st_emp_level", "st_emp_member" }, "st_code", new string[] { store.St_code });
                DataSet dataSetEmployeePanel   = crud.ReadToGrid_MySql(queryReadEmployeePanel);


                dataSetEmployeePanel.Tables[0].Columns["st_emp_level"].ColumnName  = "직급";
                dataSetEmployeePanel.Tables[0].Columns["st_emp_member"].ColumnName = "이름";

                labelEmployeeCount.Text = $"매장직원 : {dataSetEmployee.Tables[0].Rows.Count} 명";

                dataGridViewSelectEmployee.Columns.Clear();

                tempFuncForWinform.setDataGridView(dataSetEmployeePanel, dataGridViewSelectEmployee);



                //관리비 남은 날짜 표시
                //과거
                if (DateTime.Now.Month == dateTimePickerManagementExpense.Value.Month)
                {
                    if (DateTime.Now.Day == dateTimePickerManagementExpense.Value.Day)
                    {
                        labelManagementCostDateLeft.Text = "0";
                        return;
                    }
                    if (DateTime.Now.Day < dateTimePickerManagementExpense.Value.Day)
                    {
                        labelManagementCostDateLeft.Text = (dateTimePickerManagementExpense.Value.Day - DateTime.Now.Day).ToString();
                        return;
                    }
                    labelManagementCostDateLeft.Text = (DateTime.DaysInMonth(dateTimePickerManagementExpense.Value.Year, dateTimePickerManagementExpense.Value.Month) - DateTime.Now.Day + dateTimePickerManagementExpense.Value.Day).ToString();
                    return;
                }
                labelManagementCostDateLeft.Text = (DateTime.DaysInMonth(dateTimePickerManagementExpense.Value.Year, dateTimePickerManagementExpense.Value.Month) - DateTime.Now.Day - 1 + dateTimePickerManagementExpense.Value.Day).ToString();
            }
        }
Пример #6
0
        /// <summary>
        /// <para>기능 : 실적 상세 테이블 생성</para>
        /// <para>진입 : </para>
        /// <para>분기 : 1. needQuery == true</para>
        /// <para>로직 : 1. needQuery == true</para>
        /// <para>로직 : ----2. 선택된 개통번호 selectedUser_phone_number에 저장</para>
        /// <para>로직 : ----3. sqlQuery.SelectAllFrom_Where_와 Crud.Read를 사용하여 st_emp_result를 얻음</para>
        /// <para>로직 : ----4. sqlQuery.SelectAllFrom_Where_와 Crud.Read를 사용하여 user_t를 얻음</para>
        /// <para>로직 : ----5. sqlQuery.SelectAllFrom_Where_와 Crud.Read를 사용하여 st_table을 얻음</para>
        /// <para>로직 : ----6. 각 항목별 데이터 할당</para>
        /// <para>로직 : ----7. 각 항목 Readonly</para>
        /// <para>로직 : ----return</para>
        /// <para>로직 : 8. 빈 DataSet에 빈 DataTable 추가</para>
        /// <para>로직 : 9. tempFuncForWinform.setDataGridView</para>
        /// <para>로직 : 10. 기타 테이블 설정 적용</para>
        /// </summary>
        /// <param name="needQuery"></param>
        /// <param name="e"></param>
        public void makeDetailTable(bool needQuery, DataGridViewCellEventArgs e)
        {
            //true 시 만들어진 테이블에 데이터 할당, false시 빈 테이블 생성
            if (needQuery)
            {
                string userName = dataGridViewSelectDate.Rows[e.RowIndex].Cells["가입자명"].Value.ToString();
                string storeName = dataGridViewSelectDate.Rows[e.RowIndex].Cells["매장"].Value.ToString();
                string salerName = dataGridViewSelectDate.Rows[e.RowIndex].Cells["판매자"].Value.ToString();

                selectedUser_phone_number = dataGridViewSelectDate.Rows[e.RowIndex].Cells["개통번호"].Value.ToString();

                string querySelectResult = sqlQuery.SelectAllFrom_Where_("st_emp_result", new string[] { "user_open_number" }, new string[] { selectedUser_phone_number });
                St_emp_result st_emp_result = crud.Read_MySql(querySelectResult, new St_emp_result());

                string querySelectUser = sqlQuery.SelectAllFrom_Where_("user_t", new string[] { "user_code" }, new string[] { st_emp_result.user_code });
                User_t user_t = crud.Read_MySql(querySelectUser, new User_t());

                string querySelectStore = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_code" }, new string[] { employee.st_code });
                St_table st_table = crud.Read_MySql(querySelectStore, new St_table());

                //개통일
                dataGridViewSelectionDateDetail[1, 0].Value = st_emp_result.result_open_date.ToString("yyyy-MM-dd");

                //가입자명
                dataGridViewSelectionDateDetail[1, 1].Value = userName;
                //은행 user_bank user_t
                dataGridViewSelectionDateDetail[1, 2].Value = user_t.user_bank;
                //모델명
                dataGridViewSelectionDateDetail[1, 3].Value = st_emp_result.result_ph_m;

                DataGridViewComboBoxCell comboPreviousCom = new DataGridViewComboBoxCell();
                comboPreviousCom.Items.Add("1");
                comboPreviousCom.Items.Add("SKT");
                comboPreviousCom.Items.Add("KT");
                comboPreviousCom.Items.Add("LG");
                dataGridViewSelectionDateDetail[1, 4] = comboPreviousCom;

                //이전통신사 combo
                comboPreviousCom.Value = st_emp_result.user_previous_com;
                //공시지원금
                dataGridViewSelectionDateDetail[1, 5].Value = st_emp_result.subsidy_price;
                //리베이트/NET
                dataGridViewSelectionDateDetail[1, 6].Value = st_emp_result.net_rebate;
                //보험가입유무
                dataGridViewSelectionDateDetail[1, 7].Value = st_emp_result.insurance_YN;
                //송금금액
                dataGridViewSelectionDateDetail[1, 8].Value = st_emp_result.send_price;
                //현금파냄 금액
                dataGridViewSelectionDateDetail[1, 9].Value = st_emp_result.cash_sale_price;
                //모바일 개통시간
                dataGridViewSelectionDateDetail[3, 0].Value = st_emp_result.result_open_m_date.ToString("yyyy-MM-dd");
                //가입자 생년 user_birth user_t
                dataGridViewSelectionDateDetail[3, 1].Value = user_t.user_birth;
                //계좌번호 user_bank_number user_t
                dataGridViewSelectionDateDetail[3, 2].Value = user_t.user_bank_number;
                //일련번호
                dataGridViewSelectionDateDetail[3, 3].Value = st_emp_result.result_serial_number;
                //현/카/할
                dataGridViewSelectionDateDetail[3, 4].Value = st_emp_result.user_pur_type;
                //할부원금
                dataGridViewSelectionDateDetail[3, 5].Value = st_emp_result.installment_price;

                DataGridViewComboBoxCell comboPricePlan = new DataGridViewComboBoxCell();
                comboPricePlan.Items.Add("1");
                comboPricePlan.Items.Add("1만원");
                comboPricePlan.Items.Add("2만원");
                comboPricePlan.Items.Add("3만원");
                dataGridViewSelectionDateDetail[3, 6] = comboPricePlan;

                //요금제 combo
                comboPricePlan.Value = st_emp_result.price_plan;
                //유심후납
                dataGridViewSelectionDateDetail[3, 7].Value = st_emp_result.late_payment_usim;
                //예정일
                dataGridViewSelectionDateDetail[3, 8].Value = st_emp_result.due_date.ToString("yyyy-MM-dd");
                //카드판매금액
                dataGridViewSelectionDateDetail[3, 9].Value = st_emp_result.card_sale_price;

                DataGridViewComboBoxCell comboAgent = new DataGridViewComboBoxCell();
                comboAgent.Items.Add("1");
                comboAgent.Items.Add("스포");
                comboAgent.Items.Add("모다");
                comboAgent.Items.Add("아이원");
                dataGridViewSelectionDateDetail[5, 0] = comboAgent;

                //대리점 combo
                comboAgent.Value = st_emp_result.agent;
                //요금제변경일 user_plan_date user_t
                dataGridViewSelectionDateDetail[5, 1].Value = user_t.user_plan_date;
                //예금주 bank_userName user_t
                dataGridViewSelectionDateDetail[5, 2].Value = user_t.bank_userName;
                //고객명? 없음
                dataGridViewSelectionDateDetail[5, 3].Value = null;
                //출고가
                dataGridViewSelectionDateDetail[5, 4].Value = st_emp_result.release_price;
                //선납금
                dataGridViewSelectionDateDetail[5, 5].Value = st_emp_result.prepayments;
                //빈칸
                //정산금
                dataGridViewSelectionDateDetail[5, 7].Value = st_emp_result.user_calculate;
                //현금
                dataGridViewSelectionDateDetail[5, 8].Value = st_emp_result.cash;
                //기타차감
                dataGridViewSelectionDateDetail[5, 9].Value = st_emp_result.etc_offset;

                DataGridViewComboBoxCell comboStoreName = new DataGridViewComboBoxCell();
                comboStoreName.Items.Add("서울 강서");
                comboStoreName.Items.Add("원구 행주");
                comboStoreName.Items.Add("서울 마곡");
                comboStoreName.Items.Add("김포 공항");
                comboStoreName.Items.Add(st_table.St_name);
                dataGridViewSelectionDateDetail[7, 0] = comboStoreName;

                //매장 combo
                comboStoreName.Value = storeName;
                //빈칸
                //CIA? 없음
                dataGridViewSelectionDateDetail[7, 2].Value = null;
                //개통번호
                dataGridViewSelectionDateDetail[7, 3].Value = st_emp_result.user_open_number;
                //빈칸
                //빈칸
                //정책추가
                dataGridViewSelectionDateDetail[7, 6].Value = st_emp_result.add_policy;
                //유심선납
                dataGridViewSelectionDateDetail[7, 7].Value = st_emp_result.prepayments_usim;
                //카드
                dataGridViewSelectionDateDetail[7, 8].Value = st_emp_result.card;
                //세후금액
                dataGridViewSelectionDateDetail[7, 9].Value = st_emp_result.after_tax_price;
                //판매자
                dataGridViewSelectionDateDetail[9, 0].Value = salerName;
                //빈칸
                //비고
                dataGridViewSelectionDateDetail[9, 2].Value = st_emp_result.note;
                //약정유형
                dataGridViewSelectionDateDetail[9, 3].Value = st_emp_result.user_agree_type;
                //빈칸
                //MNP수수료
                dataGridViewSelectionDateDetail[9, 5].Value = st_emp_result.mnp_commission;
                //구두추가
                dataGridViewSelectionDateDetail[9, 6].Value = st_emp_result.sound_policy;
                //부가서비스추가/차감
                dataGridViewSelectionDateDetail[9, 7].Value = st_emp_result.addition_service;
                //마진
                dataGridViewSelectionDateDetail[9, 9].Value = st_emp_result.profit_margin;

                dataGridViewSelectionDateDetail.ReadOnly = true;
                return;
            }

            DataSet dataSet = new DataSet();
            dataSet.Tables.Add(new DataTable());
            tempFuncForWinform.setDataGridView(dataSet, dataGridViewSelectionDateDetail);
            dataGridViewSelectionDateDetail.DataSource = null;
            dataGridViewSelectionDateDetail.ColumnHeadersVisible = false;
            dataGridViewInit();
            dataGridViewSelectionDateDetail.ClearSelection();
            dataGridViewSelectionDateDetail.SelectionMode = DataGridViewSelectionMode.CellSelect;
            dataGridViewSelectionDateDetail.ReadOnly = true;

        }
Пример #7
0
        /// <summary>
        /// <para>기능 : 실적 상세 테이블 클리어 </para>
        /// <para>진입 : </para>
        /// <para>분기 : </para>
        /// <para>로직 : 1. sqlquery.SelectAllFrom_Where_과 Crud.Read를 통해 st_table 생성</para>
        /// <para>로직 : 2. st_table을 통해 combobox보완</para>
        /// <para>로직 : 3. &quot;&quot;를 통해 입력컨트롤 클리어</para>
        /// <para>로직 : 5. 테이블 Readonly = false 설정</para>
        /// <para>로직 : 4. label Readonly 설정</para>
        /// <para>로직 : 6. if needReadOnly == true</para>
        /// <para>로직 : ----7. 테이블 readonly = true 설정</para>
        /// </summary>
        /// <param name="needReadOnly"></param>
        //false시 readonly 추가
        public void clearSelectedDetail(bool needReadOnly)
        {
            string querySelectStore = sqlQuery.SelectAllFrom_Where_("st_table", new string[] { "st_code" }, new string[] { employee.st_code });
            St_table st_table = crud.Read_MySql(querySelectStore, new St_table());

            //개통일
            dataGridViewSelectionDateDetail[1, 0].Value = "";

            //가입자명
            dataGridViewSelectionDateDetail[1, 1].Value = "";
            //은행 user_bank user_t
            dataGridViewSelectionDateDetail[1, 2].Value = "";
            //모델명
            dataGridViewSelectionDateDetail[1, 3].Value = "";

            DataGridViewComboBoxCell comboPreviousCom = new DataGridViewComboBoxCell();
            comboPreviousCom.Items.Add("1");
            comboPreviousCom.Items.Add("SKT");
            comboPreviousCom.Items.Add("KT");
            comboPreviousCom.Items.Add("LG");
            dataGridViewSelectionDateDetail[1, 4] = comboPreviousCom;

            //이전통신사 combo
            comboPreviousCom.Value = "SKT";
            //공시지원금
            dataGridViewSelectionDateDetail[1, 5].Value = "";
            //리베이트/NET
            dataGridViewSelectionDateDetail[1, 6].Value = "";
            //보험가입유무
            dataGridViewSelectionDateDetail[1, 7].Value = "";
            //송금금액
            dataGridViewSelectionDateDetail[1, 8].Value = "";
            //현금파냄 금액
            dataGridViewSelectionDateDetail[1, 9].Value = "";
            //모바일 개통시간
            dataGridViewSelectionDateDetail[3, 0].Value = "";
            //가입자 생년 user_birth user_t
            dataGridViewSelectionDateDetail[3, 1].Value = "";
            //계좌번호 user_bank_number user_t
            dataGridViewSelectionDateDetail[3, 2].Value = "";
            //일련번호
            dataGridViewSelectionDateDetail[3, 3].Value = "";
            //현/카/할
            dataGridViewSelectionDateDetail[3, 4].Value = "";
            //할부원금
            dataGridViewSelectionDateDetail[3, 5].Value = "";

            DataGridViewComboBoxCell comboPricePlan = new DataGridViewComboBoxCell();
            comboPricePlan.Items.Add("1");
            comboPricePlan.Items.Add("1만원");
            comboPricePlan.Items.Add("2만원");
            comboPricePlan.Items.Add("3만원");
            dataGridViewSelectionDateDetail[3, 6] = comboPricePlan;

            //요금제 combo
            comboPricePlan.Value = "1만원";
            //유심후납
            dataGridViewSelectionDateDetail[3, 7].Value = "";
            //예정일
            dataGridViewSelectionDateDetail[3, 8].Value = "";
            //카드판매금액
            dataGridViewSelectionDateDetail[3, 9].Value = "";

            DataGridViewComboBoxCell comboAgent = new DataGridViewComboBoxCell();
            comboAgent.Items.Add("1");
            comboAgent.Items.Add("스포");
            comboAgent.Items.Add("모다");
            comboAgent.Items.Add("아이원");
            dataGridViewSelectionDateDetail[5, 0] = comboAgent;

            //대리점 combo
            comboAgent.Value = "스포";
            //요금제변경일 user_plan_date user_t
            dataGridViewSelectionDateDetail[5, 1].Value = "";
            //예금주 bank_userName user_t
            dataGridViewSelectionDateDetail[5, 2].Value = "";
            //고객명? 없음
            dataGridViewSelectionDateDetail[5, 3].Value = null;
            //출고가
            dataGridViewSelectionDateDetail[5, 4].Value = "";
            //선납금
            dataGridViewSelectionDateDetail[5, 5].Value = "";
            //빈칸
            //정산금
            dataGridViewSelectionDateDetail[5, 7].Value = "";
            //현금
            dataGridViewSelectionDateDetail[5, 8].Value = "";
            //기타차감
            dataGridViewSelectionDateDetail[5, 9].Value = "";

            DataGridViewComboBoxCell comboStoreName = new DataGridViewComboBoxCell();
            comboStoreName.Items.Add("서울 강서");
            comboStoreName.Items.Add("원구 행주");
            comboStoreName.Items.Add("서울 마곡");
            comboStoreName.Items.Add("김포 공항");
            comboStoreName.Items.Add(st_table.St_name);

            dataGridViewSelectionDateDetail[7, 0] = comboStoreName;

            //매장 combo
            comboStoreName.Value = st_table.St_name;
            //빈칸
            //CIA? 없음
            dataGridViewSelectionDateDetail[7, 2].Value = null;
            //개통번호
            dataGridViewSelectionDateDetail[7, 3].Value = "";
            //빈칸
            //빈칸
            //정책추가
            dataGridViewSelectionDateDetail[7, 6].Value = "";
            //유심선납
            dataGridViewSelectionDateDetail[7, 7].Value = "";
            //카드
            dataGridViewSelectionDateDetail[7, 8].Value = "";
            //세후금액
            dataGridViewSelectionDateDetail[7, 9].Value = "";
            //판매자
            dataGridViewSelectionDateDetail[9, 0].Value = "";
            //빈칸
            //비고
            dataGridViewSelectionDateDetail[9, 2].Value = "";
            //약정유형
            dataGridViewSelectionDateDetail[9, 3].Value = "";
            //빈칸
            //MNP수수료
            dataGridViewSelectionDateDetail[9, 5].Value = "";
            //구두추가
            dataGridViewSelectionDateDetail[9, 6].Value = "";
            //부가서비스추가/차감
            dataGridViewSelectionDateDetail[9, 7].Value = "";
            //마진
            dataGridViewSelectionDateDetail[9, 9].Value = "";

            dataGridViewSelectionDateDetail.ReadOnly = false;

            //readonly 설정
            for (int i = 0; i < cellLabelArray.Length; i++)
            {
                dataGridViewSelectionDateDetail[2 * Convert.ToInt32(i / 10), i - 10 * Convert.ToInt32(i / 10)].ReadOnly = true;
            }

            if (needReadOnly)
            {
                dataGridViewSelectionDateDetail.ReadOnly = true;
            }

        }