public int mSysAuthMainDB(string AUTH_CD, string AUTH_NM, string MYBLOCK_FLAG, string MYCON_FLAG, string MYCOM_FLAG, string MYTEAM_FLAG, string USING_FLAG, string MEMO) { string sql = "" + " UPDATE [PLUS_MAIN].dbo.TM00_CODE_AUTH SET MYBLOCK_FLAG = " + MYBLOCK_FLAG + ", MYCON_FLAG = " + MYCON_FLAG + ", MYCOM_FLAG = " + MYCOM_FLAG + ", MYTEAM_FLAG = " + MYTEAM_FLAG + ", USING_FLAG = " + USING_FLAG + ", MEMO = '" + MEMO + "' " + " WHERE AUTH_CD = '" + AUTH_CD + "' "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int mSysCodeGrp(string SCODE_GRP, string SCODE_GRP_NM, string USING_FLAG, string SORT_NO, string MEMO) { string sql = "" + " UPDATE [PLUS_MAIN].dbo.TM00_CODE_SYS_GRP SET SCODE_GRP_NM = '" + SCODE_GRP_NM + "', USING_FLAG = " + USING_FLAG + ", SORT_NO = " + SORT_NO + ", MEMO = '" + MEMO + "' " + " WHERE SCODE_GRP = '" + SCODE_GRP + "' "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//수정 public int mSysAuthMemberDB(string DBNM, string AUTH_CD, string AUTH_NM, string MYBLOCK_FLAG, string MYCON_FLAG, string MYCOM_FLAG, string MYTEAM_FLAG, string USING_FLAG, string MEMO) { string con = "[PLUS-" + DBNM + "].dbo."; string sql = "" + " UPDATE " + con + "T00_CODE_AUTH SET MYBLOCK_FLAG = " + MYBLOCK_FLAG + ", MYCON_FLAG = " + MYCON_FLAG + ", MYCOM_FLAG = " + MYCOM_FLAG + ", MYTEAM_FLAG = " + MYTEAM_FLAG + ", USING_FLAG = " + USING_FLAG + ", MEMO = '" + MEMO + "' " + " WHERE AUTH_CD = '" + AUTH_CD + "' "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//MODIFY public int mMember(string MEMCO_CD, string MEMCO_NM, string USING_FLAG, string SORT_NO, string MEMO) { string sql = "" + " UPDATE [PLUS_MAIN].dbo.TM00_MEMCO " + " SET USING_FLAG = " + USING_FLAG + ", SORT_NO = " + SORT_NO + ", MEMO = '" + MEMO + "' " + " WHERE MEMCO_CD = " + MEMCO_CD + "AND MEMCO_NM = '" + MEMCO_NM + "' "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//INSERT TCODE_LAB public int aLaborLabTcodeSite(string DBNM, string LAB_NO, string SITE_CD, string TCODE, string TTYPE_SCD, string VALUE) { string con = "[PLUS-" + DBNM + "].dbo."; string sql = "" + " INSERT INTO " + con + "T01_LAB_TCODE_SITE(LAB_NO, SITE_CD, TCODE, TTYPE_SCD, VALUE) " + " VALUES(" + LAB_NO + ", " + SITE_CD + ", '" + TCODE + "', '" + TTYPE_SCD + "', '" + VALUE + "') "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//수정 public int mSysAuthSiteDB(string DBNM, string SITE_CD, string AUTH_CD, string LAB_APRV_FLAG, string USING_FLAG, string MEMO) { string con = "[PLUS-" + DBNM + "].dbo."; string sql = "" + " UPDATE " + con + "T00_CODE_AUTH_SITE SET LAB_APRV_FLAG = " + LAB_APRV_FLAG + ", USING_FLAG = " + USING_FLAG + ", MEMO = '" + MEMO + "' " + " WHERE SITE_CD = " + SITE_CD + " AND AUTH_CD = '" + AUTH_CD + "' "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//MODIFY public int mDevice(string DBNM, string SITE_CD, string DEV_CD, string DEVICE_ID, string DEV_TYPE_SCD, string DEV_IO_SCD, string DEV_NM, string IP, string SORT_NO, string USING_FLAG, string MEMO) { string con = "[PLUS-" + DBNM + "].dbo."; string sql = "" + " UPDATE " + con + "T00_DEVICE " + " SET DEVICE_ID = " + DEVICE_ID + ", DEV_TYPE_SCD = '" + DEV_TYPE_SCD + "', DEV_IO_SCD = '" + DEV_IO_SCD + "', DEV_NM = '" + DEV_NM + "', IP = '" + IP + "', USING_FLAG = " + USING_FLAG + ", SORT_NO = " + SORT_NO + ", MEMO = '" + MEMO + "' " + " WHERE DEV_CD = " + DEV_CD + " AND SITE_CD = " + SITE_CD + " "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int aComnCodeGrp(string CCODE_GRP, string CCODE_NM, string USING_FLAG, string SORT_NO, string MEMO, string INPUT_ID) { string sql = "" + " INSERT INTO [PLUS_MAIN].dbo.TM00_CODE_COMN_GRP (CCODE_GRP, CCODE_NM, USING_FLAG, SORT_NO, MEMO, INPUT_ID, INPUT_DT) " + " VALUES ('" + CCODE_GRP + "', '" + CCODE_NM + "', " + USING_FLAG + ", " + SORT_NO + ", '" + MEMO + "', " + INPUT_ID + ", GETDATE()) "; int reCnt = 0; if (sqlHelper != null) { reCnt = sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//MODIFY public int mSite(string SITE_CD, string SITE_NM, string USING_FLAG, string SORT_NO, string MEMO) { string sql = "" + " UPDATE [PLUS_MAIN].dbo.TM00_SITE " + " SET SITE_NM = '" + SITE_NM + "', USING_FLAG = " + USING_FLAG + ", SORT_NO =" + SORT_NO + ", MEMO = '" + MEMO + "' " + " WHERE SITE_CD = " + SITE_CD + " "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int mCodeT(string TCODE, string LIST_FLAG, string REQUIRED_FLAG, string NUMERIC_FLAG) { string sql = "" + " UPDATE PLUS_MAIN.dbo.TM00_CODE_T SET LIST_FLAG = " + LIST_FLAG + ", REQUIRED_FLAG = " + REQUIRED_FLAG + ", NUMERIC_FLAG = " + NUMERIC_FLAG + " WHERE TCODE = '" + TCODE + "'"; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
//UPDATE public int mTeamMemco(string SITE_CD, string TEAM_CD, string TEAM_NM, string USING_FLAG, string SORT_NO, string MEMO) { string dbNm = sDbNm(SITE_CD); string con = "[PLUS-" + dbNm + "].dbo."; string sql = "" + " UPDATE " + con + "T00_TEAM_SITE " + " SET TEAM_NM = '" + TEAM_NM + "',USING_FLAG = " + USING_FLAG + ", SORT_NO = " + SORT_NO + ", MEMO = '" + MEMO + "' " + " WHERE TEAM_CD = " + TEAM_CD + " AND SITE_CD = " + SITE_CD + " "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int mCompanyMain(string CO_CD, string CO_NM, string BIZ_NO, string CONST_CCD, string CO_TYPE_SCD, string OWNER_NM, string TEL, string ADDR) { string sql = "" + " UPDATE [PLUS_MAIN].dbo.TM00_COMPANY " + " SET CO_NM = '" + CO_NM + "', BIZ_NO = '" + BIZ_NO + "', CONST_CCD = " + CONST_CCD + ", CO_TYPE_SCD = '" + CO_TYPE_SCD + "', OWNER_NM = '" + OWNER_NM + "', TEL = '" + TEL + "', ADDR = '" + ADDR + "' " + " WHERE CO_CD = " + CO_CD + " "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int aMenuTop(string TOP_MENU_NM, string APP_FLAG, string USING_FLAG, string SORT_NO, string INPUT_ID) { string sql = "" + " INSERT INTO [PLUS_MAIN].dbo.TM00_MENU_TOP (TOP_MENU_NM, APP_FLAG, USING_FLAG, SORT_NO, INPUT_ID, INPUT_DT) " + " VALUES ('" + TOP_MENU_NM + "', " + APP_FLAG + ", " + USING_FLAG + ", '" + SORT_NO + "', " + INPUT_ID + ", GETDATE()) "; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }
public int mInOut(string DBNM, string LAB_NO, string SITE_CD, string REG_DATE, string IN_DT, string OUT_DT, string CO_CD, string TEAM_CD) { string con = "[PLUS-" + DBNM + "].dbo."; string sql = "" + " UPDATE " + con + "T01_INOUT_SITE SET IN_DT = '" + IN_DT + "', OUT_DT = '" + OUT_DT + "', CO_CD = " + CO_CD + ", TEAM_CD = " + TEAM_CD + "" + " WHERE LAB_NO = " + LAB_NO + " AND SITE_CD = " + SITE_CD + " AND REG_DATE = " + REG_DATE + ""; int reCnt = 0; if (_sqlHelper != null) { reCnt = _sqlHelper.ExecuteCommand(sql); } return(reCnt); }