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();
}
