private void init_Combobox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_staff.ValueMember = "코드";
cmb_staff.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_ALL(cmb_staff, sqlQuery);
cmb_vat.ValueMember = "코드";
cmb_vat.DisplayMember = "명칭";
sqlQuery = comInfo.queryVatAll();
wConst.ComboBox_Read_ALL(cmb_vat, sqlQuery);
}
private void frm판매결재처리_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
lblSaving.BringToFront();
lblSearch.BringToFront();
sProgFolder = Path.GetDirectoryName(System.Environment.GetCommandLineArgs()[0]);
Read_Layout();
setting_Layout();
dtp일자.Text = DateTime.Now.ToString("yyyy-MM-dd");
dtpDay1.Text = DateTime.Now.ToString("yyyy-MM-dd");
string sqlQuery = "";
cmbS결재구분.ValueMember = "코드";
cmbS결재구분.DisplayMember = "명칭";
sqlQuery = " select '0' as 코드, '미결' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '1' as 코드, '완결' as 명칭 ";
wConst.ComboBox_Read_ALL(cmbS결재구분, sqlQuery);
this.init_InputBox(true);
btnSearch_Click(this, null);
}
private void pop원자재검색_Load(object sender, EventArgs e)
{
string sqlQuery = "";
if (strCUST_CD == null || strCUST_CD == "" && gubun == 2)
{
gubun = 1;
}
gubun = Properties.Settings.Default.rawSelect;
cmb_option.SelectedIndex = gubun;
cbo자재구분.ValueMember = "코드";
cbo자재구분.DisplayMember = "명칭";
StringBuilder sb = new StringBuilder();
sqlQuery = comInfo.queryRawList();
wConst.ComboBox_Read_ALL(cbo자재구분, sqlQuery);
//cbo자재구분.range = 2;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
// strCondition = this.makeSearchCondition();
this.bindData();
btnSearch.PerformClick();
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb연도.ValueMember = "코드";
cmb연도.DisplayMember = "명칭";
sqlQuery = " select '" + DateTime.Now.ToString("yyyy") + "' as 코드, '" + DateTime.Now.ToString("yyyy") + "년' as 명칭 ";
for (int kk = int.Parse(DateTime.Now.ToString("yyyy")) - 1; kk >= 2000; kk--)
{
sqlQuery += " union all ";
sqlQuery += " select '" + kk.ToString() + "' as 코드, '" + kk.ToString() + "년' as 명칭 ";
}
wConst.ComboBox_Read_NoBlank(cmb연도, sqlQuery);
cmbS연도.ValueMember = "코드";
cmbS연도.DisplayMember = "명칭";
wConst.ComboBox_Read_NoBlank(cmbS연도, sqlQuery);
cmb구분.ValueMember = "코드";
cmb구분.DisplayMember = "명칭";
sqlQuery = " select '1' as 코드, '판매' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '2' as 코드, '수금' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '3' as 코드, '현금' as 명칭 ";
wConst.ComboBox_Read_NoBlank(cmb구분, sqlQuery);
cmbS구분.ValueMember = "코드";
cmbS구분.DisplayMember = "명칭";
wConst.ComboBox_Read_ALL(cmbS구분, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_used_srch.ValueMember = "코드";
cmb_used_srch.DisplayMember = "명칭";
txt_used_yn.ValueMember = "코드";
txt_used_yn.DisplayMember = "명칭";
sqlQuery = comInfo.queryUsedYn(); //사용여부검색
wConst.ComboBox_Read_ALL(cmb_used_srch, sqlQuery);
wConst.ComboBox_Read_NoBlank(txt_used_yn, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmbS구분.ValueMember = "코드";
cmbS구분.DisplayMember = "명칭";
sqlQuery = " select '1' as 코드, '영업소접수만' as 명칭 "; //요청일자
sqlQuery += " union all ";
sqlQuery += " select '2' as 코드, '창고접수' as 명칭 "; //창고접수일자
sqlQuery += " union all ";
sqlQuery += " select '3' as 코드, '관리부접수' as 명칭 "; //관리부처리일자
wConst.ComboBox_Read_ALL(cmbS구분, sqlQuery);
}
private void frm온습도기모니터링_Load(object sender, EventArgs e)
{
lbl_start_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
lbl_end_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
set_BtnSetDateValue();
txt_place.TextAlign = HorizontalAlignment.Center;
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_tmp_loc.ValueMember = "코드";
cmb_tmp_loc.DisplayMember = "명칭";
sqlQuery = comInfo.querySensorLoc();
wConst.ComboBox_Read_ALL(cmb_tmp_loc, sqlQuery);
cmb_type_gbn.ValueMember = "코드";
cmb_type_gbn.DisplayMember = "명칭";
sqlQuery = comInfo.querySensorType();
wConst.ComboBox_Read_ALL(cmb_type_gbn, sqlQuery);
grd_setting();
timer1.Interval = 300000;
timer1.Tick += new EventHandler(timer1_Tick);
timer1.Start();
timer2.Tick += new EventHandler(timer2_Tick);
timer2.Interval = 1000; //스케쥴 간격을 5분으로 준 것이다.
timer2.Start(); //타이머를 발동시킨다.
timer3.Tick += new EventHandler(timer3_Tick);
timer3.Interval = 1000; //스케쥴 간격을 5분으로 준 것이다.
get_data();
Print_Sensor_Log();
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_cd.ValueMember = "코드";
cmb_cd.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_Blank(cmb_cd, sqlQuery);
cmb_cd2.ValueMember = "코드";
cmb_cd2.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_ALL(cmb_cd2, sqlQuery);
}
private void frm지출현황_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
end_date.Text = DateTime.Today.ToString("yyyy-MM-dd");
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_accu.ValueMember = "코드";
cmb_accu.DisplayMember = "명칭";
sqlQuery = comInfo.queryAccu();
wConst.ComboBox_Read_ALL(cmb_accu, sqlQuery);
}
private void frm설비카운트모니터링_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
txt_place.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2] + " 현황";
lbl_start_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
lbl_end_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
set_BtnSetDateValue();
grd_setting();
txt_place.TextAlign = HorizontalAlignment.Left;
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_tmp_loc.ValueMember = "코드";
cmb_tmp_loc.DisplayMember = "명칭";
sqlQuery = comInfo.querySensorLoc();
wConst.ComboBox_Read_ALL(cmb_tmp_loc, sqlQuery);
timer1.Interval = 1000;
timer1.Tick += new EventHandler(timer1_Tick);
timer1.Start();
timer2.Tick += new EventHandler(timer2_Tick);
timer2.Interval = 1000; //스케쥴 간격을 5분으로 준 것이다.
timer2.Start(); //타이머를 발동시킨다.
//timer3.Tick += new EventHandler(timer3_Tick);
//timer3.Interval = 1000; //스케쥴 간격을 5분으로 준 것이다.
timer4.Tick += new EventHandler(timer4_Tick);
timer4.Interval = 3500; //스케쥴 간격을 5분으로 준 것이다.
timer4.Start(); //타이머를 발동시킨다.
Print_Sensor_Log();
get_data();
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//불량유형 시작
cmb_cd_srch.Items.Add("전체 검색");
cmb_cd_srch.Items.Add("코드별 검색");
cmb_cd_srch.Items.Add("이름별 검색");
cmb_cd_srch.SelectedIndex = 0;
cmb_type.ValueMember = "코드";
cmb_type.DisplayMember = "명칭";
sqlQuery = comInfo.queryType();
wConst.ComboBox_Read_Blank(cmb_type, sqlQuery);
cmb_raw_mat_gbn.ValueMember = "코드";
cmb_raw_mat_gbn.DisplayMember = "명칭";
sqlQuery = comInfo.queryRawList();
wConst.ComboBox_Read_Blank(cmb_raw_mat_gbn, sqlQuery);
cmb_raw2.ValueMember = "코드";
cmb_raw2.DisplayMember = "명칭";
sqlQuery = comInfo.queryRawList();
wConst.ComboBox_Read_ALL(cmb_raw2, sqlQuery);
cmb_input_unit.ValueMember = "코드";
cmb_input_unit.DisplayMember = "명칭";
sqlQuery = comInfo.queryUnit();
wConst.ComboBox_Read_Blank(cmb_input_unit, sqlQuery);
cmb_output_unit.ValueMember = "코드";
cmb_output_unit.DisplayMember = "명칭";
wConst.ComboBox_Read_Blank(cmb_output_unit, sqlQuery);
cmb_used.ValueMember = "코드";
cmb_used.DisplayMember = "명칭";
sqlQuery = comInfo.queryUsedYn();
wConst.ComboBox_Read_NoBlank(cmb_used, sqlQuery);
cmb_line.ValueMember = "코드";
cmb_line.DisplayMember = "명칭";
sqlQuery = comInfo.queryLine();
wConst.ComboBox_Read_Blank(cmb_line, sqlQuery);
cmb_cust.ValueMember = "코드";
cmb_cust.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustUsed("2"); //구매처
wConst.ComboBox_Read_Blank(cmb_cust, sqlQuery);
cmb_raw_chk.ValueMember = "코드";
cmb_raw_chk.DisplayMember = "명칭";
sqlQuery = comInfo.queryCode("601"); //수입검사여부
wConst.ComboBox_Read_Blank(cmb_raw_chk, sqlQuery);
cmb_used_srch.ValueMember = "코드";
cmb_used_srch.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustUsedYnAll(); //사용여부검색
wConst.ComboBox_Read_NoBlank(cmb_used_srch, sqlQuery);
cmb_raw_stor.ValueMember = "코드";
cmb_raw_stor.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorageAll(); //기본창고 선택 ( 안사용될듯 삭제요망 )
wConst.ComboBox_Read_NoBlank(cmb_raw_stor, sqlQuery);
cmb_chugjong_txt.ValueMember = "코드";
cmb_chugjong_txt.DisplayMember = "명칭";
sqlQuery = comInfo.queryChugjongAll(); //축종
wConst.ComboBox_Read_NoBlank(cmb_chugjong_txt, sqlQuery);
cmb_class_txt.ValueMember = "코드";
cmb_class_txt.DisplayMember = "명칭";
sqlQuery = comInfo.queryClassAll(); //분류
wConst.ComboBox_Read_NoBlank(cmb_class_txt, sqlQuery);
cmb_country_txt.ValueMember = "코드";
cmb_country_txt.DisplayMember = "명칭";
sqlQuery = comInfo.queryCountryAll(); //원산지
wConst.ComboBox_Read_NoBlank(cmb_country_txt, sqlQuery);
cmb_grade_txt.ValueMember = "코드";
cmb_grade_txt.DisplayMember = "명칭";
sqlQuery = comInfo.queryGradeAll(); //등급
wConst.ComboBox_Read_NoBlank(cmb_grade_txt, sqlQuery);
cmb_pattern_gubun.ValueMember = "코드";
cmb_pattern_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryPatternAll(); //등급
wConst.ComboBox_Read_NoBlank(cmb_pattern_gubun, sqlQuery);
cmb_vat_cd.ValueMember = "코드";
cmb_vat_cd.DisplayMember = "명칭";
sqlQuery = comInfo.queryVat(); // 과세구분
wConst.ComboBox_Read_NoBlank(cmb_vat_cd, sqlQuery);
txt_box_amt.Text = "0";
txt_hamyang_txt.Text = "";
txt_label_nm_txt.Text = "";
txt_exprt_count.Text = ""; //유통일수 ( 삭제요망 )
}