internal protected int DeleteAllData_Dac(int iestterm_ref_id, int iest_dept_ref_id, int imap_version_id, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(7);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "DA";
paramArray[1] = CreateDataParameter("@iESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = iestterm_ref_id;
paramArray[2] = CreateDataParameter("@iEST_DEPT_REF_ID", SqlDbType.Int);
paramArray[2].Value = iest_dept_ref_id;
paramArray[3] = CreateDataParameter("@iMAP_VERSION_ID", SqlDbType.Int);
paramArray[3].Value = imap_version_id;
paramArray[4] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[4].Value = itxr_user;
paramArray[5] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[5].Direction = ParameterDirection.Output;
paramArray[6] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.Char, 1);
paramArray[6].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_BSC_MAP_TERM", "PKG_BSC_MAP_TERM.PROC_DELETE_ALL"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
internal protected int DeleteData_Dac(IDbConnection conn, IDbTransaction trx, int iestterm_ref_id, int ikpi_ref_id, int idatasource_id, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(7);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "D";
paramArray[1] = CreateDataParameter("@iESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = iestterm_ref_id;
paramArray[2] = CreateDataParameter("@iKPI_REF_ID", SqlDbType.Int);
paramArray[2].Value = ikpi_ref_id;
paramArray[3] = CreateDataParameter("@iDATASOURCE_ID", SqlDbType.Int);
paramArray[3].Value = idatasource_id;
paramArray[4] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[4].Value = itxr_user;
paramArray[5] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[5].Direction = ParameterDirection.Output;
paramArray[6] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[6].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, GetQueryStringByDb("usp_BSC_KPI_DATASOURCE", "PKG_BSC_KPI_DATASOURCE.PROC_DELETE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, int comp_id
, int estterm_ref_id
, int dept_ref_id
, string est_id)
{
string query = @"DELETE EST_DEPT_EST_DETAIL
WHERE (COMP_ID = @COMP_ID OR @COMP_ID = 0)
AND (ESTTERM_REF_ID = @ESTTERM_REF_ID OR @ESTTERM_REF_ID = 0)
AND (DEPT_REF_ID = @DEPT_REF_ID OR @DEPT_REF_ID = 0)
AND (EST_ID = @EST_ID OR @EST_ID ='' )";
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = estterm_ref_id;
paramArray[2] = CreateDataParameter("@DEPT_REF_ID", SqlDbType.Int);
paramArray[2].Value = dept_ref_id;
paramArray[3] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 12);
paramArray[3].Value = est_id;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, int comp_id
, string est_sche_id)
{
string query = @"DELETE EST_SCHE_INFO
WHERE COMP_ID = @COMP_ID
AND EST_SCHE_ID = @EST_SCHE_ID";
IDbDataParameter[] paramArray = CreateDataParameters(1);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@EST_SCHE_ID", SqlDbType.NVarChar, 20);
paramArray[1].Value = est_sche_id;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public int NHIT_DASHBOARD_MAIN_Delete(string GRP_ONE_CODE, string GRP_TWO_CODE, string GRP_THREE_CODE, string CR_YEAR, string CR_MONTH, string TG_GUBUN)
{
string qry = @"
DELETE
FROM NHIT_DASHBOARD_MAIN
WHERE
GRP_ONE_CODE = @GRP_ONE_CODE
AND GRP_TWO_CODE = @GRP_TWO_CODE
AND GRP_THREE_CODE = @GRP_THREE_CODE
AND CR_YEAR = @CR_YEAR
AND CR_MONTH = @CR_MONTH
AND TG_GUBUN = @TG_GUBUN ";
IDbDataParameter[] paramArray = CreateDataParameters(6);
paramArray[0] = CreateDataParameter("@GRP_ONE_CODE", SqlDbType.VarChar);
paramArray[0].Value = GRP_ONE_CODE;
paramArray[1] = CreateDataParameter("@GRP_TWO_CODE", SqlDbType.VarChar);
paramArray[1].Value = GRP_TWO_CODE;
paramArray[2] = CreateDataParameter("@GRP_THREE_CODE", SqlDbType.VarChar);
paramArray[2].Value = GRP_THREE_CODE;
paramArray[3] = CreateDataParameter("@CR_YEAR", SqlDbType.VarChar);
paramArray[3].Value = CR_YEAR;
paramArray[4] = CreateDataParameter("@CR_MONTH", SqlDbType.VarChar);
paramArray[4].Value = CR_MONTH;
paramArray[5] = CreateDataParameter("@TG_GUBUN", SqlDbType.VarChar);
paramArray[5].Value = TG_GUBUN;
return(DbAgentObj.ExecuteNonQuery(qry, paramArray, CommandType.Text));
}
internal protected int UpdateData_Dac(int iestterm_ref_id, int ikpi_ref_id, string iymd, int iest_level,
double iweight, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(9);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "U";
paramArray[1] = CreateDataParameter("@iESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = iestterm_ref_id;
paramArray[2] = CreateDataParameter("@iKPI_REF_ID", SqlDbType.Int);
paramArray[2].Value = ikpi_ref_id;
paramArray[3] = CreateDataParameter("@iYMD", SqlDbType.VarChar);
paramArray[3].Value = iymd;
paramArray[4] = CreateDataParameter("@iEST_LEVEL", SqlDbType.Int);
paramArray[4].Value = iest_level;
paramArray[5] = CreateDataParameter("@iWEIGHT", SqlDbType.Decimal);
paramArray[5].Value = iweight;
paramArray[6] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[6].Value = itxr_user;
paramArray[7] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[7].Direction = ParameterDirection.Output;
paramArray[8] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[8].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_BSC_KPI_QLT_TERM_WEIGHT", "PKG_BSC_KPI_QLT_TERM_WEIGHT.PROC_UPDATE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
public int Insert_DB(IDbConnection conn, IDbTransaction trx
, object emp_ref_id
, object role_ref_id)
{
string query = @"
INSERT INTO COM_EMP_ROLE_REL
(
EMP_REF_ID
, ROLE_REF_ID
)
VALUES
(
@EMP_REF_ID
, @ROLE_REF_ID
)
";
IDbDataParameter[] paramArray = CreateDataParameters(2);
paramArray[0] = CreateDataParameter("@EMP_REF_ID", SqlDbType.Int);
paramArray[0].Value = emp_ref_id;
paramArray[1] = CreateDataParameter("@ROLE_REF_ID", SqlDbType.Int);
paramArray[1].Value = role_ref_id;
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray);
return(affectedRow);
}
public int Delete(int estterm_ref_id
, int est_dept_ref_id
, string ymd)
{
int okCnt = 0;
string query = @"
DELETE FROM BSC_MAP_STG_MANUAL
WHERE ESTTERM_REF_ID = @ESTTERM_REF_ID
AND YMD = @YMD
AND EST_DEPT_REF_ID = @EST_DEPT_REF_ID
";
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[0].Value = estterm_ref_id;
paramArray[1] = CreateDataParameter("@EST_DEPT_REF_ID", SqlDbType.VarChar);
paramArray[1].Value = est_dept_ref_id;
paramArray[2] = CreateDataParameter("@YMD", SqlDbType.Int);
paramArray[2].Value = ymd;
okCnt = DbAgentObj.ExecuteNonQuery(query, paramArray);
return(okCnt);
}
internal protected IDataParameterCollection UpdateData_Dac(int iunit_type_ref_id, string iunit_type, string iunit, string iformat_string, int idecimal_point, string irounding_type, string iuse_yn, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(11);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "A";
paramArray[1] = CreateDataParameter("@iUNIT_TYPE_REF_ID", SqlDbType.Int);
paramArray[1].Value = iunit_type_ref_id;
paramArray[2] = CreateDataParameter("@iUNIT_TYPE", SqlDbType.VarChar);
paramArray[2].Value = iunit_type;
paramArray[3] = CreateDataParameter("@iUNIT", SqlDbType.VarChar);
paramArray[3].Value = iunit;
paramArray[4] = CreateDataParameter("@iFORMAT_STRING", SqlDbType.VarChar);
paramArray[4].Value = iformat_string;
paramArray[5] = CreateDataParameter("@iDECIMAL_POINT", SqlDbType.Int);
paramArray[5].Value = idecimal_point;
paramArray[6] = CreateDataParameter("@iROUNDING_TYPE", SqlDbType.VarChar);
paramArray[6].Value = irounding_type;
paramArray[7] = CreateDataParameter("@iUSE_YN", SqlDbType.Char);
paramArray[7].Value = iuse_yn;
paramArray[8] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[8].Value = itxr_user;
paramArray[9] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar);
paramArray[9].Direction = ParameterDirection.Output;
paramArray[10] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar);
paramArray[10].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_COM_UNIT_TYPE_INFO", "PKG_COM_UNIT_TYPE_INFO.PROC_UPDATE"), paramArray, CommandType.StoredProcedure, out col);
return(col);
}
protected internal bool RemovePDTAndAHPStgInfo_Dac(IDbConnection conn
, IDbTransaction trx
, int ver_id
, int estterm_ref_id
, int stg_ref_id)
{
string query = @"DELETE BSC_PDT_AHP_STG_INFO
WHERE (VER_ID = @VER_ID OR @VER_ID = 0)
AND (ESTTERM_REF_ID = @ESTTERM_REF_ID OR @ESTTERM_REF_ID = 0)
AND (STG_REF_ID = @STG_REF_ID OR @STG_REF_ID = 0)" ;
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@VER_ID", SqlDbType.Int);
paramArray[0].Value = ver_id;
paramArray[1] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = estterm_ref_id;
paramArray[2] = CreateDataParameter("@STG_REF_ID", SqlDbType.Int);
paramArray[2].Value = stg_ref_id;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return((affectedRow > 0) ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public bool LogPageTrace(int emp_ref_id, string userip, string useragnet, string pagePath)
{
string query = @"INSERT INTO COM_PAGE_TRACE (EMP_REF_ID, USERIP, USERAGENT, ACCESSPAGE, ACCESSDATE)
VALUES (@EMP_REF_ID, @USERIP, @USERAGENT, @ACCESSPAGE, GETDATE())" ;
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@EMP_REF_ID", SqlDbType.Int);
paramArray[0].Value = emp_ref_id;
paramArray[1] = CreateDataParameter("@USERIP", SqlDbType.VarChar);
paramArray[1].Value = userip;
paramArray[2] = CreateDataParameter("@USERAGENT", SqlDbType.VarChar);
paramArray[2].Value = useragnet;
paramArray[3] = CreateDataParameter("@ACCESSPAGE", SqlDbType.VarChar);
paramArray[3].Value = pagePath;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(query, paramArray, CommandType.Text);
return((affectedRow > 0) ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
internal protected int DeleteData_Dac
(IDbConnection con, IDbTransaction trx, string ibiz_type, int iemp_ref_id, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(6);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "D";
paramArray[1] = CreateDataParameter("@iBIZ_TYPE", SqlDbType.VarChar);
paramArray[1].Value = ibiz_type;
paramArray[2] = CreateDataParameter("@iEMP_REF_ID", SqlDbType.Int);
paramArray[2].Value = iemp_ref_id;
paramArray[3] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[3].Value = itxr_user;
paramArray[4] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[4].Direction = ParameterDirection.Output;
paramArray[5] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[5].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(con, trx, GetQueryStringByDb("usp_COM_APPROVAL_LINE_BASE", "PKG_COM_APPROVAL_LINE_BASE.PROC_DELETE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
internal protected int InsertData_Dac
(IDbConnection con, IDbTransaction trx, int iestterm_ref_id, int iversion_ref_id, string iymd, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(7);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "A";
paramArray[1] = CreateDataParameter("@iESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = iestterm_ref_id;
paramArray[2] = CreateDataParameter("@iVERSION_REF_ID", SqlDbType.Int);
paramArray[2].Value = iversion_ref_id;
paramArray[3] = CreateDataParameter("@iYMD", SqlDbType.VarChar);
paramArray[3].Value = iymd;
paramArray[4] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[4].Value = itxr_user;
paramArray[5] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[5].Direction = ParameterDirection.Output;
paramArray[6] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[6].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(con, trx, GetQueryStringByDb("usp_BSC_STG_TREE_TERM", "PKG_BSC_STG_TREE_TERM.PROC_INSERT"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
internal protected int DeleteData_Dac
(int iprj_ref_id, int iemp_ref_id, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(5);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "D";
paramArray[1] = CreateDataParameter("@iPRJ_REF_ID", SqlDbType.Int);
paramArray[1].Value = iprj_ref_id;
paramArray[2] = CreateDataParameter("@iEMP_REF_ID", SqlDbType.Int);
paramArray[2].Value = iemp_ref_id;
paramArray[3] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[3].Direction = ParameterDirection.Output;
paramArray[4] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[4].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_PRJ_RESOURCE", "PKG_PRJ_RESOURCE.PROC_DELETE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
internal protected int ReUsedData_Dac(int iestterm_ref_id, int istg_ref_id, Int32 itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(6);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "RU";
paramArray[1] = CreateDataParameter("@iESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = iestterm_ref_id;
paramArray[2] = CreateDataParameter("@iSTG_REF_ID", SqlDbType.Int);
paramArray[2].Value = istg_ref_id;
paramArray[3] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[3].Value = itxr_user;
paramArray[4] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[4].Direction = ParameterDirection.Output;
paramArray[5] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[5].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_BSC_STG_INFO", "PKG_BSC_STG_INFO.PROC_REUSED"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
public int ChgFlagRelBackDeptInfo(string asEmpRefID, string asDeptRefID)
{
IDbDataParameter[] paramArray = CreateDataParameters(2);
string s_query = @"
UPDATE REL_DEPT_EMP
SET REL_STATUS = 1
WHERE
EMP_REF_ID = CONVERT(INT,@EMP_REF_ID)
AND DEPT_REF_ID= CONVERT(INT,@DEPT_REF_ID)
";
string o_query = @"
UPDATE REL_DEPT_EMP
SET REL_STATUS = 1
WHERE
EMP_REF_ID = TO_NUMBER(@EMP_REF_ID)
AND DEPT_REF_ID= TO_NUMBER(@DEPT_REF_ID)
";
paramArray[0] = CreateDataParameter("@EMP_REF_ID", SqlDbType.VarChar);
paramArray[1] = CreateDataParameter("@DEPT_REF_ID", SqlDbType.VarChar);
paramArray[0].Value = asEmpRefID;
paramArray[1].Value = asDeptRefID;
return(DbAgentObj.ExecuteNonQuery(GetQueryStringByDb(s_query, o_query), paramArray));
}
public bool CopyStg(IDbConnection conn, IDbTransaction trx, object org_estterm_ref_id, object new_estterm_ref_id, object itxr_user)
{
this.Transaction_Message = "";
string strQuery = @"
IF NOT EXISTS (SELECT * FROM BSC_STG_INFO WHERE ESTTERM_REF_ID = @NEW_ESTTERM_REF_ID)
BEGIN
INSERT INTO BSC_STG_INFO
(ESTTERM_REF_ID, STG_REF_ID, UP_STG_ID, STG_CODE, STG_NAME
,STG_SET_DESC, STG_ETC, USE_YN, CREATE_DATE, CREATE_USER)
SELECT
@NEW_ESTTERM_REF_ID, STG_REF_ID, UP_STG_ID, CONVERT(VARCHAR, @NEW_ESTTERM_REF_ID) + '_' + CONVERT(VARCHAR, STG_REF_ID), STG_NAME
,STG_SET_DESC, STG_ETC, USE_YN, GETDATE(), @CREATE_USER
FROM BSC_STG_INFO
WHERE ESTTERM_REF_ID = @ORG_ESTTERM_REF_ID
END
";
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@ORG_ESTTERM_REF_ID", SqlDbType.Int);
paramArray[0].Value = org_estterm_ref_id;
paramArray[1] = CreateDataParameter("@NEW_ESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = new_estterm_ref_id;
paramArray[2] = CreateDataParameter("@CREATE_USER", SqlDbType.Int);
paramArray[2].Value = itxr_user;
if (DbAgentObj.ExecuteNonQuery(conn, trx, strQuery, paramArray, CommandType.Text) > 0)
{
return(true);
}
return(false);
}
internal protected int InsertData_Dac(int icategory_top_ref_id, string icategory_name, string icategory_desc, string iuse_yn, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(9);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "A";
paramArray[1] = CreateDataParameter("@iCATEGORY_TOP_REF_ID", SqlDbType.Int);
paramArray[1].Value = icategory_top_ref_id;
paramArray[2] = CreateDataParameter("@iCATEGORY_NAME", SqlDbType.VarChar);
paramArray[2].Value = icategory_name;
paramArray[3] = CreateDataParameter("@iCATEGORY_DESC", SqlDbType.VarChar);
paramArray[3].Value = icategory_desc;
paramArray[4] = CreateDataParameter("@iUSE_YN", SqlDbType.VarChar);
paramArray[4].Value = iuse_yn;
paramArray[5] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[5].Value = itxr_user;
paramArray[6] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[6].Direction = ParameterDirection.Output;
paramArray[7] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[7].Direction = ParameterDirection.Output;
paramArray[8] = CreateDataParameter("@oCATEGORY_MID_REF_ID", SqlDbType.Int);
paramArray[8].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_BSC_KPI_CATEGORY_MID", "PKG_BSC_KPI_CATEGORY_MID.PROC_INSERT"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
this.Icategory_mid_ref_id = (this.Transaction_Result == "N") ? 0 : int.Parse(GetOutputParameterValueBySP(col, "@oCATEGORY_MID_REF_ID").ToString());
return(affectedRow);
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, int comp_id
, string est_id
, string grade_id
, string scale_id)
{
string query = @"DELETE EST_SCOPE
WHERE (COMP_ID = @COMP_ID OR @COMP_ID = 0)
AND (EST_ID = @EST_ID OR @EST_ID ='' )
AND (GRADE_ID = @GRADE_ID OR @GRADE_ID ='' )
AND (SCALE_ID = @SCALE_ID OR @SCALE_ID ='' )";
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 12);
paramArray[1].Value = est_id;
paramArray[2] = CreateDataParameter("@GRADE_ID", SqlDbType.NVarChar, 6);
paramArray[2].Value = grade_id;
paramArray[3] = CreateDataParameter("@SCALE_ID", SqlDbType.NVarChar, 12);
paramArray[3].Value = scale_id;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
internal protected int DeleteData_Dac(int icategory_top_ref_id, int icategory_mid_ref_id, Int32 itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(6);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "D";
paramArray[1] = CreateDataParameter("@iCATEGORY_TOP_REF_ID", SqlDbType.Int);
paramArray[1].Value = icategory_top_ref_id;
paramArray[2] = CreateDataParameter("@iCATEGORY_MID_REF_ID", SqlDbType.Int);
paramArray[2].Value = icategory_mid_ref_id;
paramArray[3] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[3].Value = itxr_user;
paramArray[4] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[4].Direction = ParameterDirection.Output;
paramArray[5] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.Char, 1);
paramArray[5].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_BSC_KPI_CATEGORY_MID", "PKG_BSC_KPI_CATEGORY_MID.PROC_DELETE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, object comp_id
, object est_id
, object estterm_ref_id
, object estterm_sub_id)
{
string query = @"
DELETE FROM EST_DATA
WHERE COMP_ID = @COMP_ID
AND EST_ID = @EST_ID
AND ESTTERM_REF_ID = @ESTTERM_REF_ID
AND ESTTERM_SUB_ID = @ESTTERM_SUB_ID
";
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 12);
paramArray[1].Value = est_id;
paramArray[2] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[2].Value = estterm_ref_id;
paramArray[3] = CreateDataParameter("@ESTTERM_SUB_ID", SqlDbType.Int);
paramArray[3].Value = estterm_sub_id;
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, int emp_ref_id
, string pos_rnk_id
, DateTime start_date)
{
string query = @"DELETE EST_POS_RNK_EMP
WHERE EMP_REF_ID = @EMP_REF_ID
AND POS_RNK_ID = @POS_RNK_ID
AND START_DATE = @START_DATE";
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@EMP_REF_ID", SqlDbType.Int);
paramArray[0].Value = emp_ref_id;
paramArray[1] = CreateDataParameter("@POS_RNK_ID", SqlDbType.NVarChar, 12);
paramArray[1].Value = pos_rnk_id;
paramArray[2] = CreateDataParameter("@START_DATE", SqlDbType.DateTime);
paramArray[2].Value = start_date;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete(IDbConnection conn
, IDbTransaction trx
, int comp_id
, string rel_grp_pos_id)
{
string query = @"DELETE FROM EST_REL_GROUP_POS_DATA
WHERE (COMP_ID = @COMP_ID OR @COMP_ID = 0)
AND (REL_GRP_POS_ID = @REL_GRP_POS_ID OR @REL_GRP_POS_ID ='' ) ";
IDbDataParameter[] paramArray = CreateDataParameters(2);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@REL_GRP_POS_ID", SqlDbType.NVarChar, 20);
paramArray[1].Value = rel_grp_pos_id;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_DB(IDbConnection idc
, IDbTransaction idt
, object IDX, object UPDATE_USER)
{
string query = @"
-- BSC FAQ DELETE
UPDATE BSC_COMMUNICATION_FAQ
SET
ISDELETE = 'Y',
UPDATE_DATE = @UPDATEDATE,
UPDATE_USER = @UPDATE_USER
WHERE FAQ_REF_ID = @IDX
";
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@IDX", SqlDbType.Int);
paramArray[1] = CreateDataParameter("@UPDATEDATE", SqlDbType.Date);
paramArray[2] = CreateDataParameter("@UPDATE_USER", SqlDbType.Int);
paramArray[0].Value = IDX;
paramArray[1].Value = DateTime.Now;
paramArray[2].Value = UPDATE_USER;
int affectedRow = DbAgentObj.ExecuteNonQuery(idc, idt, query, paramArray, CommandType.Text);
return(affectedRow);
}
public int Update(IDbConnection conn
, IDbTransaction trx
, string pos_dut_id
, string pos_dut_name
, DateTime update_date
, int update_user)
{
string query = @"UPDATE EST_POSITION_DUT
SET POS_DUT_NAME = @POS_DUT_NAME
,UPDATE_DATE = @UPDATE_DATE
,UPDATE_USER = @UPDATE_USER
WHERE POS_DUT_ID = @POS_DUT_ID" ;
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@POS_DUT_ID", SqlDbType.NVarChar, 12);
paramArray[0].Value = pos_dut_id;
paramArray[1] = CreateDataParameter("@POS_DUT_NAME", SqlDbType.NVarChar, 200);
paramArray[1].Value = pos_dut_name;
paramArray[2] = CreateDataParameter("@UPDATE_DATE", SqlDbType.DateTime);
paramArray[2].Value = update_date;
paramArray[3] = CreateDataParameter("@UPDATE_USER", SqlDbType.Int);
paramArray[3].Value = update_user;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteData_DB(IDbConnection conn
, IDbTransaction trx
, object iestterm_ref_id
, object ikpi_ref_id
, object ikpi_target_version_id)
{
string query = @"
DELETE BSC_KPI_TARGET_GOAL
WHERE ESTTERM_REF_ID = @ESTTERM_REF_ID
AND KPI_REF_ID = @KPI_REF_ID
AND KPI_TARGET_VERSION_ID = @KPI_TARGET_VERSION_ID
";
IDbDataParameter[] paramArray = CreateDataParameters(3);
paramArray[0] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[0].Value = iestterm_ref_id;
paramArray[1] = CreateDataParameter("@KPI_REF_ID", SqlDbType.Int);
paramArray[1].Value = ikpi_ref_id;
paramArray[2] = CreateDataParameter("@KPI_TARGET_VERSION_ID", SqlDbType.Int);
paramArray[2].Value = ikpi_target_version_id;
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray);
return(affectedRow);
}
public int InsertDataFromTo(IDbConnection conn
, IDbTransaction trx
, object comp_id
, object estterm_ref_id_from
, object estterm_ref_id_to
, object create_date
, object create_user)
{
string query = @"INSERT INTO EST_DEPT_EST_DETAIL(COMP_ID
,ESTTERM_REF_ID
,DEPT_REF_ID
,EST_ID
,SCALE_ID
,EST_GRP_ID
,WEIGHT
,WEIGHT_TYPE
,CREATE_DATE
,CREATE_USER
,UPDATE_DATE
,UPDATE_USER
)
SELECT @COMP_ID
, @ESTTERM_REF_ID_TO
, DEPT_REF_ID
, EST_ID
, SCALE_ID
, EST_GRP_ID
, WEIGHT
, WEIGHT_TYPE
, @CREATE_DATE
, @CREATE_USER
, NULL
, NULL
FROM EST_DEPT_EST_DETAIL
WHERE COMP_ID = @COMP_ID
AND ESTTERM_REF_ID = @ESTTERM_REF_ID_FROM " ;
IDbDataParameter[] paramArray = CreateDataParameters(5);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@ESTTERM_REF_ID_FROM", SqlDbType.Int);
paramArray[1].Value = estterm_ref_id_from;
paramArray[2] = CreateDataParameter("@ESTTERM_REF_ID_TO", SqlDbType.Int);
paramArray[2].Value = estterm_ref_id_to;
paramArray[3] = CreateDataParameter("@CREATE_DATE", SqlDbType.DateTime);
paramArray[3].Value = create_date;
paramArray[4] = CreateDataParameter("@CREATE_USER", SqlDbType.Int);
paramArray[4].Value = create_user;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
internal protected int UpdateData_Dac
(int iexec_ref_id, int iprj_ref_id, int itask_ref_id, object iexec_date, decimal iamount, string iexec_content, int itxr_user)
{
IDbDataParameter[] paramArray = CreateDataParameters(10);
paramArray[0] = CreateDataParameter("@iTYPE", SqlDbType.VarChar);
paramArray[0].Value = "U";
paramArray[1] = CreateDataParameter("@iEXEC_REF_ID", SqlDbType.Int);
paramArray[1].Value = iexec_ref_id;
paramArray[2] = CreateDataParameter("@iPRJ_REF_ID", SqlDbType.Int);
paramArray[2].Value = iprj_ref_id;
paramArray[3] = CreateDataParameter("@iTASK_REF_ID", SqlDbType.Int);
paramArray[3].Value = itask_ref_id;
paramArray[4] = CreateDataParameter("@iEXEC_DATE", SqlDbType.DateTime);
paramArray[4].Value = (iexec_date == null) ? DBNull.Value : iexec_date;
paramArray[5] = CreateDataParameter("@iAMOUNT", SqlDbType.Decimal);
paramArray[5].Value = iamount;
paramArray[6] = CreateDataParameter("@iEXEC_CONTENT", SqlDbType.VarChar, 200);
paramArray[6].Value = iexec_content;
paramArray[7] = CreateDataParameter("@iTXR_USER", SqlDbType.Int);
paramArray[7].Value = itxr_user;
paramArray[8] = CreateDataParameter("@oRTN_MSG", SqlDbType.VarChar, 1000);
paramArray[8].Direction = ParameterDirection.Output;
paramArray[9] = CreateDataParameter("@oRTN_COMPLETE_YN", SqlDbType.VarChar, 1);
paramArray[9].Direction = ParameterDirection.Output;
IDataParameterCollection col;
int affectedRow = DbAgentObj.ExecuteNonQuery(GetQueryStringByDb("usp_PRJ_EXECUTION", "PKG_PRJ_EXECUTION.PROC_UPDATE"), paramArray, CommandType.StoredProcedure, out col);
this.Transaction_Message = GetOutputParameterValueBySP(col, "@oRTN_MSG").ToString();
this.Transaction_Result = GetOutputParameterValueBySP(col, "@oRTN_COMPLETE_YN").ToString();
return(affectedRow);
}
public int DeleteData_DB(IDbConnection conn
, IDbTransaction trx
, object estterm_ref_id
, object kpi_ref_id)
{
string query = @"
DELETE FROM BSC_KPI_RESULT
WHERE ESTTERM_REF_ID = @ESTTERM_REF_ID
AND KPI_REF_ID = @KPI_REF_ID
";
IDbDataParameter[] paramArray = CreateDataParameters(6);
paramArray[0] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[0].Value = estterm_ref_id;
paramArray[1] = CreateDataParameter("@KPI_REF_ID", SqlDbType.Int);
paramArray[1].Value = kpi_ref_id;
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray);
return(affectedRow);
}
public int Update(IDbConnection conn
, IDbTransaction trx
, string ctrl_id
, int dept_ref_id
, DateTime update_date
, int update_user)
{
string quey = @"UPDATE EST_CTRL_DEPT_MAP
SET UPDATE_DATE = @UPDATE_DATE
,UPDATE_USER = @UPDATE_USER
WHERE CTRL_ID = @CTRL_ID
AND DEPT_REF_ID = @DEPT_REF_ID" ;
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@CTRL_ID", SqlDbType.NVarChar, 20);
paramArray[0].Value = ctrl_id;
paramArray[1] = CreateDataParameter("@DEPT_REF_ID", SqlDbType.Int);
paramArray[1].Value = dept_ref_id;
paramArray[2] = CreateDataParameter("@UPDATE_DATE", SqlDbType.DateTime);
paramArray[2].Value = update_date;
paramArray[3] = CreateDataParameter("@UPDATE_USER", SqlDbType.Int);
paramArray[3].Value = update_user;
try
{
int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, quey, paramArray, CommandType.Text);
return(affectedRow);
}
catch (Exception ex)
{
throw ex;
}
}
