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