// 입력
public int thrm_add(params object[] val)
{
int check = 1;
try
{
if (_DB.GetConnection() == true)
{
OracleCommand comm = new OracleCommand();
comm.Connection = _DB.Connection;
comm.CommandText = @"INSERT INTO tieas_cdg_hwy values(:empno, :resno, :name, :cname, :ename, :datasys1)";
comm.Parameters.Add("empno", val[0]);
comm.Parameters.Add("resno", val[1]);
comm.Parameters.Add("name", val[2]);
comm.Parameters.Add("cname", val[3]);
comm.Parameters.Add("ename", val[4]);
comm.Parameters.Add("datasys1", val[5]);
comm.Prepare();
var a = comm.ExecuteNonQuery();
Console.WriteLine(a + " row insert");
comm.Cancel();
comm.Dispose();
check = 0;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(check);
}
public void ShowData()
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
if (dtp != null)
{
dtp.Visible = false;
}
}
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select LIC_CODE, LIC_GRADE, LIC_ACQDATE, LIC_ORGAN from thrm_lic_hwy where LIC_EMPNO='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dataGridView1.Rows.Add(reader["LIC_CODE"], reader["LIC_GRADE"], reader["LIC_ACQDATE"], reader["LIC_ORGAN"], "");
}
}
}
}
}
public void ShowData()
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
if (dtp != null)
{
dtp.Visible = false;
}
}
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select CAR_COM, CAR_REGION, CAR_YYYYMM_F, CAR_YYYYMM_T, CAR_POS, CAR_DEPT, CAR_JOB, CAR_REASON from thrm_car_hwy where CAR_EMPNO='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dataGridView1.Rows.Add(reader["CAR_COM"], reader["CAR_POS"], reader["CAR_JOB"], reader["CAR_DEPT"], reader["CAR_REGION"], reader["CAR_YYYYMM_F"], reader["CAR_YYYYMM_T"], reader["CAR_REASON"]);
}
}
}
}
}
public void ShowData()
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
if (dtp != null)
{
dtp.Visible = false;
}
}
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select AWARD_DATE, AWARD_TYPE, AWARD_NO, AWARD_KIND, AWARD_ORGAN, AWARD_CONTENT, AWARD_INOUT, AWARD_POS, AWARD_DEPT from thrm_award_hwy where AWARD_EMPNO='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dataGridView1.Rows.Add(reader["AWARD_DATE"], reader["AWARD_TYPE"], reader["AWARD_NO"], reader["AWARD_KIND"], reader["AWARD_ORGAN"], reader["AWARD_CONTENT"], reader["AWARD_INOUT"], reader["AWARD_POS"], reader["AWARD_DEPT"], "");
}
}
}
}
}
// 입력
public int thrm_add(params object[] val)
{
int check = 1;
try
{
if (_DB.GetConnection() == true)
{
OracleCommand comm = new OracleCommand();
comm.Connection = _DB.Connection;
//CD_GRPCD, CD_CODE, CD_SEQ, CD_CODNMS, CD_USE, CD_SDATE, CD_EDATE
comm.CommandText = @"INSERT INTO tieas_cd_hwy values(:empno, :resno, :name, :cname, '', '', '', :ename, :datasys1, :datasys2)";
comm.Parameters.Add("empno", val[0]);
comm.Parameters.Add("resno", val[1]);
comm.Parameters.Add("name", val[2]);
comm.Parameters.Add("cname", val[3]);
comm.Parameters.Add("ename", val[4]);
comm.Parameters.Add("datasys1", Convert.ToDateTime(val[5]).ToString("yyyyMMdd"));
comm.Parameters.Add("datasys2", Convert.ToDateTime(val[6]).ToString("yyyyMMdd"));
comm.Prepare();
var a = comm.ExecuteNonQuery();
Console.WriteLine(a + " row insert");
comm.Cancel();
comm.Dispose();
check = 0;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(check);
}
public void ShowData()
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
if (dtp != null)
{
dtp.Visible = false;
}
}
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select EDU_LOE, EDU_ENTDATE, EDU_GRADATE, EDU_SCHNM, EDU_DEPT, EDU_DEGREE, EDU_GRADE, EDU_GRA, EDU_LAST from thrm_edu_hwy where EDU_EMPNO='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dataGridView1.Rows.Add(reader["EDU_LOE"], reader["EDU_ENTDATE"], reader["EDU_GRADATE"], reader["EDU_SCHNM"], reader["EDU_DEPT"], reader["EDU_DEGREE"], reader["EDU_GRADE"], reader["EDU_GRA"], reader["EDU_LAST"], "");
}
}
}
}
}
public void ShowData()
{
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = @"select BAS_NAME, BAS_RESNO, BAS_ADDR, BAS_HDPNO, BAS_ENTDATE, BAS_DEPT, BAS_POS, cd.cd_grpcd, cd.cd_code, cd.cd_codnm, dept_code, dept_name " +
"from thrm_bas_hwy bas, tieas_cd_hwy cd, thrm_dept_hwy dept " +
"where cd.cd_grpcd='POS' and cd.cd_code = bas.bas_pos and dept_code = bas_dept and bas.bas_empno='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
String entdate = reader["BAS_ENTDATE"].ToString().Substring(6, 2) + "/" + reader["BAS_ENTDATE"].ToString().Substring(4, 2) + "/" + reader["BAS_ENTDATE"].ToString().Substring(0, 4);
name_label.Text = Papago(reader["BAS_NAME"].ToString());
bth_label.Text = reader["BAS_RESNO"].ToString();
address_label.Text = Papago(reader["BAS_ADDR"].ToString());
phone_label.Text = reader["BAS_HDPNO"].ToString();
start_label.Text = entdate;
dept_label.Text = Papago(reader["DEPT_NAME"].ToString());
pos_label.Text = Papago(reader["CD_CODNM"].ToString());
}
}
}
}
}
public void ShowData()
{
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = @"SELECT TRUNC(SYSDATE - TO_DATE(bas.bas_entdate,'YYYYMMDD')) as START_DATE, BAS_NAME, BAS_RESNO, BAS_ADDR, BAS_DEPT, BAS_POS, cd.cd_grpcd, cd.cd_code, cd.cd_codnm, dept_code, dept_name " + "FROM DUAL, thrm_bas_hwy bas , tieas_cd_hwy cd, thrm_dept_hwy dept " +
"where cd.cd_grpcd='POS' and cd.cd_code = bas.bas_pos and dept_code = bas_dept and bas.bas_empno='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
name_label.Text = reader["BAS_NAME"].ToString();
bth_label.Text = reader["BAS_RESNO"].ToString();
address_label.Text = reader["BAS_ADDR"].ToString();
phone_label.Text = "";
start_label.Text = reader["START_DATE"].ToString() + "일";
dept_label.Text = reader["DEPT_NAME"].ToString();
pos_label.Text = reader["CD_CODNM"].ToString();
}
}
}
}
}
public void ShowData(String DB_Column, String DB_Tablename)
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
}
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select " + DB_Column + " from " + DB_Tablename;
Console.WriteLine(cmd.CommandText);
using (OracleDataReader reader = cmd.ExecuteReader())
{
//ArrayList rowList = new ArrayList();
object[] row;
while (reader.Read())
{
row = new object[reader.FieldCount + 1];
reader.GetValues(row);
// 안넣으면 get null 에러뜸
row[reader.FieldCount] = "";
// 체크박스는 여기서 알아서 넣어줘야할듯 강제로
dataGridView1.Rows.Add(row);
}
}
}
}
}
public void POS_ADD()
{
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = @"select cd_codnm, cd_code from tieas_cd_hwy where cd_grpcd='POS'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
using (OracleCommand cmd2 = new OracleCommand())
{
cmd2.Connection = _DB.Connection;
cmd2.CommandText = @"select count(*) as RESULT from thrm_bas_hwy bas, tieas_cd_hwy cd where bas.bas_pos = cd.cd_code and cd.cd_grpcd='POS' and cd.cd_code='" + reader["CD_CODE"].ToString() + "'";
using (OracleDataReader reader2 = cmd2.ExecuteReader())
{
while (reader2.Read())
{
PieSeries_Add(reader["CD_CODNM"].ToString(), Convert.ToInt32(reader2["RESULT"]));
}
}
}
}
}
}
}
}
public void DEPT_ADD(String Names, String dept_code)
{
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = @"select count(*) from thrm_bas_hwy where bas_dept='" + dept_code + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
PieSeries_Add(Names, Convert.ToInt32(reader[0]));
}
}
}
}
}
// :: 데이터베이스에 있는 코드를 콤보박스에 넣는 함수
// string GRPCD : 코드 그룹 이름
private ComboBox CODE_INPUT(string GRPCD)
{
ComboBox combo = new ComboBox();
OracleDBManager _db = new OracleDBManager();
if (_db.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _db.Connection;
// DEPT는 따로 else에서 처리
if (!GRPCD.Equals("DEPT"))
{
cmd.CommandText = "select * from tieas_cd_hwy where CD_GRPCD='" + GRPCD + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
combo.Items.Add(reader["CD_CODE"].ToString() + "-" + reader["CD_CODNMS"].ToString());
}
}
}
else
{
cmd.CommandText = "select * from thrm_dept_hwy";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
combo.Items.Add(reader["DEPT_CODE"].ToString() + "-" + reader["dept_name"].ToString());
}
}
}
}
}
combo.Tag = GRPCD;
CODE_STORE.Add(combo);
return(combo);
}
public void PIE_ADD()
{
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = @"select BAS_ENTDATE from thrm_bas_hwy";
using (OracleDataReader reader = cmd.ExecuteReader())
{
// thrm_bas_hwy 의 bas_enddate를 다 불러옴
while (reader.Read())
{
// MM만 뽑았음
String JoinDate = reader["BAS_ENTDATE"].ToString().Substring(4, 2);
// 개수를 뽑아야함. MM만 뽑았으니까 그거 count 돌리면될듯?
Date_List.Add(JoinDate);
}
}
}
}
}
public void ShowData()
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
if (dtp != null)
{
dtp.Visible = false;
}
}
if (_DB.GetConnection() == true)
{
Boolean itg_result;
string rel = "";
if (_DB.GetConnection() == true)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = _DB.Connection;
cmd.CommandText = "select FAM_REL, FAM_NAME, FAM_BTH, FAM_ITG from thrm_fam_hwy where fam_empno='" + insaSide.select_empno + "'";
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader["FAM_ITG"].Equals("Y"))
{
itg_result = true;
}
else
{
itg_result = false;
}
// 시간이없덩,, 임시로
switch (reader["FAM_REL"])
{
case "01":
rel = "아버지";
break;
case "02":
rel = "어머니";
break;
case "03":
rel = "형";
break;
case "04":
rel = "누나";
break;
case "05":
rel = "동생";
break;
}
dataGridView1.Rows.Add(rel, reader["FAM_NAME"], reader["FAM_BTH"], itg_result, "");
}
}
}
}
}
}
/*
* 인사기본사항
*/
public int thrm_bas_add(String empno, String resno, String name, String cname, String ename, String fix, String zip, String addr, String residence, String hdpno, String telno, String email, String mil_sta, String mil_mil, String mil_rnk, String mar,
String acc_bank1, String acc_name1, String acc_no1, String acc_bank2, String acc_name2, String acc_no2, String cont, String intern, int intern_no, String emp_sdate, String emp_edate, String entdate,
String resdate, String levdate, String reidate, String wsta, String sts, String pos, String dut, String dept, String rmk, String pos_dt, String dut_dt, String dept_dt, String intern_dt, String datasys1, String datasys2, String datasys3)
{
int check = 1;
try
{
if (_DB.GetConnection() == true)
{
OracleCommand comm = new OracleCommand();
comm.Connection = _DB.Connection;
comm.CommandText = @"INSERT INTO THRM_BAS_HWY values(:empno, :resno, :name, :cname, :ename, :fix, :zip, :addr, :residence, :hdpno, :telno, :email, :mil_sta, :mil_mil, :mil_rnk, :mar, " + // 15
":acc_bank1, :acc_name1, :acc_no1, :acc_bank2, :acc_name2, :acc_no2, :cont, :intern, :intern_no, :emp_sdate, :emp_edate, :entdate, " + // 12
":resdate, :levdate, :reidate, :wsta, :sts, :pos, :dut, :dept, :rmk, :pos_dt, :dut_dt, :dept_dt, :intern_dt, :datasys1, :datasys2, :datasys3)"; // 16
comm.Parameters.Add("empno", empno);
comm.Parameters.Add("resno", resno);
comm.Parameters.Add("name", name);
comm.Parameters.Add("cname", cname);
comm.Parameters.Add("ename", ename);
comm.Parameters.Add("fix", fix);
comm.Parameters.Add("zip", zip);
comm.Parameters.Add("addr", addr);
comm.Parameters.Add("residence", residence);
comm.Parameters.Add("hdpno", hdpno);
comm.Parameters.Add("telno", telno);
comm.Parameters.Add("email", email);
comm.Parameters.Add("mil_sta", mil_sta);
comm.Parameters.Add("mil_mil", mil_mil);
comm.Parameters.Add("mil_rnk", mil_rnk);
comm.Parameters.Add("mar", mar);
comm.Parameters.Add("acc_bank1", acc_bank1);
comm.Parameters.Add("acc_name1", acc_name1);
comm.Parameters.Add("acc_no1", acc_no1);
comm.Parameters.Add("acc_bank2", acc_bank2);
comm.Parameters.Add("acc_name2", acc_name2);
comm.Parameters.Add("acc_no2", acc_no2);
comm.Parameters.Add("cont", cont);
comm.Parameters.Add("intern", intern);
comm.Parameters.Add("intern_no", intern_no);
comm.Parameters.Add("emp_sdate", emp_sdate);
comm.Parameters.Add("emp_edate", emp_edate);
comm.Parameters.Add("entdate", entdate);
comm.Parameters.Add("resdate", resdate);
comm.Parameters.Add("levdate", levdate);
comm.Parameters.Add("reidate", reidate);
comm.Parameters.Add("wsta", wsta);
comm.Parameters.Add("sts", sts);
comm.Parameters.Add("pos", pos);
comm.Parameters.Add("dut", dut);
comm.Parameters.Add("dept", dept);
comm.Parameters.Add("rmk", rmk);
comm.Parameters.Add("pos_dt", pos_dt);
comm.Parameters.Add("dut_dt", dut_dt);
comm.Parameters.Add("dept_dt", dept_dt);
comm.Parameters.Add("intern_dt", intern_dt);
comm.Parameters.Add("datasys1", datasys1);
comm.Parameters.Add("datasys2", datasys2);
comm.Parameters.Add("datasys3", datasys3);
comm.Prepare();
comm.ExecuteNonQuery();
comm.Cancel();
comm.Dispose();
check = 0;
}
}
catch (Exception ex)
{
check = 1;
Console.WriteLine(ex);
}
return(check);
}
