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; } }