/// <summary> /// 신규 여부를 확인 하고 추가한다. /// </summary> /// <param name="site"></param> /// <param name="i_name"></param> /// <returns></returns> public static bool isNewList(string site, string i_name) { bool rtn; Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path); string sql = string.Format(@"SELECT COUNT(*) cnt FROM ICO WHERE SITE = '{0}' AND I_NAME = '{1}'", site, i_name); using (DataSet ds = db.dsExcute_Query(sql)) { rtn = Fnc.obj2int(ds.Tables[0].Rows[0]["cnt"]) < 1; } //신규 처리 if (rtn) { sql = string.Format(@"INSERT INTO ICO ( SITE, I_NAME, DATE ) VALUES ('{0}', '{1}', '{2}' )", site, i_name, Fnc.Date2String(DateTime.Now, Fnc.enDateType.DateTime)); db.intExcute_Query(sql); } return(rtn); }
public static bool isNewNotice(string site, string key, string title) { bool rtn; Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path); string sql = string.Format(@"SELECT COUNT(*) cnt FROM Notice WHERE SITE = '{0}' AND Key = '{1}'", site, key); using (DataSet ds = db.dsExcute_Query(sql)) { rtn = Fnc.obj2int(ds.Tables[0].Rows[0]["cnt"]) < 1; } //신규 처리 if (rtn) { sql = string.Format(@"INSERT INTO Notice ( SITE, Key, Title, DATE ) VALUES ('{0}', '{1}', '{2}', '{3}' )", site, key, title, Fnc.Date2String(DateTime.Now, Fnc.enDateType.DateTime)); db.intExcute_Query(sql); } return(rtn); }
public static DataTable ChatID_Get(string mtype) { Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path); string sql = string.Format(@"SELECT ChatID,DESC FROM telegram WHERE mType = '{0}'", mtype); return(db.dsExcute_Query(sql).Tables[0]); }
/// <summary> /// 해당 사이트의 목록을 가져온다. /// </summary> /// <param name="site"></param> /// <returns></returns> public static DataTable NewList_Get(string site) { Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path); string sql = string.Format(@"SELECT I_Name, 0 IsChk FROM ICO WHERE SITE = '{0}'", site); return(db.dsExcute_Query(sql).Tables[0]); }
/// <summary> /// 어드레스 타입 종류를 조회 한다. /// </summary> /// <param name="PLCType"></param> /// <returns></returns> public static DataTable AddType_Get(string PLCType) { Function.Db.SQLite db = new Function.Db.SQLite(sqldb_path); string sql = string.Format(@"SELECT PLCTYPE, ADDTYPE, DESC, '[' || ADDTYPE || ']' || DESC Expression FROM PLC_ADDTYPE WHERE PLCTYPE = '{0}' ORDER BY PRIORITY", PLCType); return(db.dsExcute_Query(sql).Tables[0]); }
// <summary> /// 어드레스 타입별 등록된 값 관리테이블을 가져온다. /// </summary> /// <param name="PLCType"></param> /// <param name="AddType"></param> /// <returns></returns> public static DataTable PLC_ValueMng_Get(string PLCType, string AddType) { Function.Db.SQLite db = new Function.Db.SQLite(sqldb_path); string sql = string.Format(@"SELECT * FROM PLC_Value_Mng WHERE PLCTYPE = '{0}' AND ADDTYPE = '{1}' ORDER BY PRIORITY", PLCType, AddType); return(db.dsExcute_Query(sql).Tables[0]); }