private void buttonSelectDate_Click(object sender, EventArgs e) {//추가 query 필요 : 매장, 판매자 ,가입자명, 전화번호, string querySelectDate = $"SELECT R.RESULT_OPEN_DATE, R.AGENT, T.ST_NAME, E.ST_EMP_MEMBER, U.USER_NAME, R.USER_OPEN_NUMBER, R.USER_PREVIOUS_COM, R.NOTE FROM ST_EMP_RESULT AS R INNER JOIN ST_TABLE AS T ON R.ST_CODE=T.ST_CODE AND R.RESULT_OPEN_DATE LIKE '{textBoxDate.Text}%' INNER JOIN USER_T AS U ON R.USER_CODE = U.USER_CODE INNER JOIN ST_EMPLOYEE AS E ON R.ST_EMP_CODE = E.ST_EMP_CODE"; DataSet dataSetSelectDate = crud.ReadToGrid_MySql(querySelectDate); dataSetSelectDate.Tables[0].Columns["RESULT_OPEN_DATE"].ColumnName = "개통일"; dataSetSelectDate.Tables[0].Columns["AGENT"].ColumnName = "대리점"; dataSetSelectDate.Tables[0].Columns["ST_NAME"].ColumnName = "매장"; dataSetSelectDate.Tables[0].Columns["ST_EMP_MEMBER"].ColumnName = "판매자"; dataSetSelectDate.Tables[0].Columns["USER_NAME"].ColumnName = "가입자명"; dataSetSelectDate.Tables[0].Columns["USER_OPEN_NUMBER"].ColumnName = "개통번호"; dataSetSelectDate.Tables[0].Columns["USER_PREVIOUS_COM"].ColumnName = "통신사"; dataSetSelectDate.Tables[0].Columns["NOTE"].ColumnName = "비고"; tempFuncForWinform.setDataGridView(dataSetSelectDate, dataGridViewSelectDate); dataGridViewSelectDate.DefaultCellStyle.Format = "yyyy-MM-dd"; }
/// <summary> /// <para>기능 : 등록, 수정, 삭제시 테이블 리셋하기 위함</para> /// <para>진입 : </para> /// <para>분기 : </para> /// <para>로직 : 1. queryString과 Crud.ReadToGrid를 사용하여 검색된 개통일DataSet을 얻음</para> /// <para>로직 : 2. 컬럼명 한글로 변경</para> /// <para>로직 : 3. 체크박스 컬럼 추가</para> /// <para>로직 : 4. 필요한 컬럼 Readonly</para> /// <para>로직 : 5. 개통일 시간 제외 날짜까지만 출력</para> /// </summary> //등록, 수정, 삭제시 테이블 리셋하기 위함 public void readResultTablePattern() { //추가 query 필요 : 매장, 판매자 ,가입자명, 전화번호 string querySelectDate = $"SELECT R.RESULT_OPEN_DATE, R.AGENT, T.ST_NAME, E.ST_EMP_MEMBER, U.USER_NAME, R.USER_OPEN_NUMBER, R.USER_PREVIOUS_COM, R.NOTE FROM ST_EMP_RESULT AS R INNER JOIN ST_TABLE AS T ON R.ST_CODE=T.ST_CODE AND R.RESULT_OPEN_DATE LIKE '{textBoxDate.Text}%' INNER JOIN USER_T AS U ON R.USER_CODE = U.USER_CODE INNER JOIN ST_EMPLOYEE AS E ON R.ST_EMP_CODE = E.ST_EMP_CODE"; DataSet dataSetSelectDate = crud.ReadToGrid_MySql(querySelectDate); dataSetSelectDate.Tables[0].Columns["RESULT_OPEN_DATE"].ColumnName = "개통일"; dataSetSelectDate.Tables[0].Columns["AGENT"].ColumnName = "대리점"; dataSetSelectDate.Tables[0].Columns["ST_NAME"].ColumnName = "매장"; dataSetSelectDate.Tables[0].Columns["ST_EMP_MEMBER"].ColumnName = "판매자"; dataSetSelectDate.Tables[0].Columns["USER_NAME"].ColumnName = "가입자명"; dataSetSelectDate.Tables[0].Columns["USER_OPEN_NUMBER"].ColumnName = "개통번호"; dataSetSelectDate.Tables[0].Columns["USER_PREVIOUS_COM"].ColumnName = "통신사"; dataSetSelectDate.Tables[0].Columns["NOTE"].ColumnName = "비고"; dataGridViewSelectDate.Columns.Clear(); tempFuncForWinform.setDataGridView(dataSetSelectDate, dataGridViewSelectDate); DataGridViewCheckBoxColumn datagridviewcheckBoxColumm = new DataGridViewCheckBoxColumn(); datagridviewcheckBoxColumm.ValueType = typeof(bool); dataGridViewSelectDate.Columns.Insert(0, datagridviewcheckBoxColumm); dataGridViewSelectDate.ReadOnly = false; dataGridViewSelectDate.Columns[0].Width = 30; //check박스 제외 리드온리 설정, 전체를 리드온리하고 check박스만 풀경우 가 적용이 안됨 for (int i = 1; i < 9; i++) { dataGridViewSelectDate.Columns[i].ReadOnly = true; } dataGridViewSelectDate.DefaultCellStyle.Format = "yyyy-MM-dd"; setCheckedResult.Clear(); dataGridViewSelectDate.ClearSelection(); }
private void StoreManage_Load(object sender, EventArgs e) { ////1. 왼쪽 메뉴 버튼 동적 생성 //List<string> menuList = getMenuList(); //foreach (var m in menuList) //{ // makebutton(this, coord, dictButtonProperty); //} //2. Panel_Top_Left 현재시간 할당 labelCurrentDate.Text = DateTime.Now.ToString("yyyy - MM - dd : tt hh : mm"); //3. Panel_Top_Right 관리자 이름 할당 string queryReadEmp = sqlQuery.SelectAllFrom_Where_("st_employee", new string[] { "st_emp_code" }, new string[] { id }); Employee emp = crud.Read_MySql(queryReadEmp, new Employee()); if (emp.st_emp_level == 1) { labelAdminName.Text = emp.st_emp_member + " (관리자)"; } else { labelAdminName.Text = emp.st_emp_member + " (비관리자)"; } //4. Panel_Left_Second datatable 할당 //string queryReadStore = sqlQuery.select_From_Where("st_table", new string[] { "st_name", "st_manager"},"st_manager", new string[] {id}); string queryReadStore = sqlQuery.select_From_("st_table", new string[] { "st_name", "st_manager" }); DataSet dataSetStore = crud.ReadToGrid_MySql(queryReadStore); //컬럼이름 할당 dataSetStore.Tables[0].Columns["st_name"].ColumnName = "매장명"; dataSetStore.Tables[0].Columns["st_manager"].ColumnName = "관리자"; tempFuncForWinform.setDataGridView(dataSetStore, dataGridViewStore); //check박스 컬럼 추가 DataGridViewCheckBoxColumn dgvCmb = new DataGridViewCheckBoxColumn(); dgvCmb.ValueType = typeof(bool); dgvCmb.Name = ""; dataGridViewStore.Columns.Insert(0, dgvCmb); dataGridViewStore.ClearSelection(); dataGridViewStore.Columns[0].Width = 30; dataGridViewStore.ReadOnly = false; dataGridViewStore.Columns[1].ReadOnly = true; dataGridViewStore.Columns[2].ReadOnly = true; //5. panel_Main_First 매장명, 관리자명 할당 및 textbox border color 변환 //border color 어디? //6. Panel_Main_Second_1 textbox border color 변환 //7. Panel_Main_Second_4 가능하다면 db로부터 날짜를 할당, LeftDate 변경 // datepicker init dateTimePickerContractDate.Value = DateTime.Now; dateTimePickerContractDate2.Value = dateTimePickerContractDate.Value.AddYears(1); dateTimePickerManagementExpense.Value = DateTime.Now; dateTimePickerElectricityExpense.Value = DateTime.Now; dateTimePickerWaterExpense.Value = DateTime.Now; // 텍스트 가운데 정렬 textBoxSetting(); //로드시 readonly readonlyTextBoxAndDatetimePicker(true); //로드시 enable buttonEnableToggle(false, buttonForCreateAndUpdateArray); //폰트설정 labelSetting(); dateTimePickerSetting(); }