private DataTable GetHRInfo(Low_Object_Type object_type)
{
string strProvider = ConfigurationManager.ConnectionStrings["Low_HR_DB"].ProviderName;
DataTable dt = new DataTable();
if (strProvider == "System.Data.SqlClient")
{
SqlConnection objCon = new SqlConnection();
objCon.ConnectionString = ConfigurationManager.ConnectionStrings["Low_HR_DB"].ConnectionString;
objCon.Open();
if (objCon.State == ConnectionState.Open)
{
SqlCommand objCmd = new SqlCommand(GetHRQuery(object_type), objCon);
SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
objDA.Fill(dt);
objCon.Close();
objCon.Dispose();
return(dt);
}
else
{
objCon.Dispose();
return(null);
}
}
else if (strProvider == "System.Data.OracleClient")
{
OracleConnection objCon = new OracleConnection();
objCon.ConnectionString = ConfigurationManager.ConnectionStrings["Low_HR_DB"].ConnectionString;
objCon.Open();
if (objCon.State == ConnectionState.Open)
{
OracleCommand objCmd = new OracleCommand(GetHRQuery(object_type), objCon);
OracleDataAdapter objDA = new OracleDataAdapter(objCmd);
objDA.Fill(dt);
objCon.Close();
objCon.Dispose();
return(dt);
}
else
{
objCon.Dispose();
return(null);
}
}
else
{
return(null);
}
}
private string GetHRQuery(Low_Object_Type object_type)
{
string strEmp = ConfigurationManager.AppSettings["Object.Table.EMP"].ToString();
string strDept = ConfigurationManager.AppSettings["Object.Table.DEPT"].ToString();
string strQry = "";
if (object_type == Low_Object_Type.Employee)
{
//strQry = "SELECT DEPT_REF_ID,DEPT_NAME,EMP_REF_ID,EMP_NAME,RANK_CODE,RANK_NAME,CLASS_CODE,CLASS_NAME,DUTY_CODE,DUTY_NAME,GROUP_CODE,GROUP_NAME,USE_YN FROM " + strObject;
strQry = string.Format(@"
SELECT A.DEPT_CODE
,B.DEPT_NAME
,A.EMP_CODE
,A.EMP_NAME
,A.POS_RANK_CD
,A.POS_RANK_NM
,A.POS_CLS_CD
,A.POS_CLS_NM
,A.POS_DUTY_CD
,A.POS_DUTY_NM
,A.POS_GRP_CD
,A.POS_GRP_NM
,A.EMP_USEYN
FROM {0} A
LEFT OUTER JOIN {1} B ON B.DEPT_CODE = A.DEPT_CODE", strEmp, strDept);
}
else if (object_type == Low_Object_Type.Department)
{
//strQry = "SELECT DEPT_REF_ID,DEPT_NAME,UP_DEPT_ID,DEPT_TYPE,USE_YN FROM "+ strObject + " WHERE USE_YN='Y'";
strQry = string.Format(@"
SELECT DEPT_CODE
,DEPT_NAME
,UP_DEPT_CODE
,DEPT_TYPE_CODE
,DEPT_TYPE_NAME
,DEPT_USEYN
FROM {0}", strDept);
}
else
{
strQry = "";
}
return(strQry);
}
