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