//사번검색
#region 사번검색(고정) -- 기본화면
//인사정보검색
private void insaSearch_Click(object sender, EventArgs e)
{
try
{
oHelper = new DBOracle_Helper();
sabunDataGridView.Rows.Clear();
string searchsql =
"select bas_empno, bas_name, bas_pos, cd_codnms, bas_dept, dept_name" +
" from thrm_bas_psy," +
" (select cd_grpcd, cd_code, cd_codnms from tieas_cd_psy where cd_grpcd = 'POS')," +
" thrm_dept_psy" +
" where bas_pos = cd_code" +
" and bas_dept = dept_code" +
" and bas_empno like '" + qry_empno.Text + "%'" +
" and bas_name like '" + qry_name.Text + "%'" +
" and dept_name like '" + qry_dept.Text + "%'" +
" order by bas_empno asc";
DataTable sabunSearch = oHelper.GetData(searchsql);
int cnt = 0;
foreach (DataRow item in sabunSearch.Rows)
{
sabunDataGridView.Rows.Add(item["BAS_EMPNO"].ToString(), item["BAS_NAME"].ToString(),
item["cd_codnms"].ToString(), item["dept_name"].ToString());
cnt++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public bool LoginCheck(string id, string password)
{
try
{
oHelper = new DBOracle_Helper();
{
string sql = "select login_empno, login_password from thrm_login_psy where login_empno = '" + id + "' and login_password = '******'";
DataTable loginInfo = oHelper.GetData(sql);
using (DataTableReader reader = new DataTableReader(loginInfo))
{
if (reader.HasRows)
{
return(true);
}
}
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
return(false);
}
private void InsaLogin_Load(object sender, EventArgs e)
{
//db호출
oHelper = new DBOracle_Helper();
}
