/// <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>
/// <param name="i_name"></param>
public static void NewList_Del(string site, string i_name)
{
Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path);
string sql = string.Format(@"DELETE FROM ICO
WHERE SITE = '{0}' AND I_NAME = '{1}'", site, i_name);
db.intExcute_Query(sql);
}
/// <summary>
/// 사이트에 신규 심볼을 추가한다.
/// </summary>
/// <param name="site"></param>
/// <param name="i_name"></param>
public static void NewList_Add(string site, string i_name)
{
Function.Db.SQLite db = new Function.Db.SQLite(vari.db_path);
string 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);
}
/// <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]);
}
public static void PLC_ValueMng_Save(string PLCType, string AddType, DataTable dtMng)
{
if (AddType == null || AddType.Equals(string.Empty))
{
return;
}
Function.Db.SQLite db = new Function.Db.SQLite(sqldb_path);
try
{
db.BeginTransaction();
string sql = string.Format(@"DELETE FROM PLC_Value_Mng
WHERE PLCTYPE = '{0}'
AND ADDTYPE = '{1}'", PLCType, AddType);
db.intExcute_Query(sql);
foreach (DataRow dr in dtMng.Rows)
{
sql = string.Format(@"INSERT INTO PLC_Value_Mng(
PLCType, ADDType, Priority,
Mng_Type, Address, Address_Length,
Value, ValueType, Condition,
isUse, Desc)
VALUES
( '{0}', '{1}', {2},
'{3}', '{4}', '{5}',
'{6}', '{7}', '{8}',
'{9}', '{10}' )", PLCType, AddType, dr["Priority"],
dr["Mng_Type"], dr["Address"], dr["Address_Length"],
dr["Value"], dr["ValueType"], dr["Condition"],
dr["isUse"], dr["Desc"]);
db.intExcute_Query(sql);
}
db.CommitTransaction();
}
catch
{
db.RollBackTransaction();
throw;
}
}
public static void Address_Set(string PLCType, string AddType, DataTable dtAdd)
{
if (AddType == null || AddType.Equals(string.Empty))
{
return;
}
Function.Db.SQLite db = new Function.Db.SQLite(sqldb_path);
try
{
db.BeginTransaction();
string sql = string.Format(@"DELETE FROM PLC_Addresses
WHERE PLCTYPE = '{0}'
AND ADDTYPE = '{1}'", PLCType, AddType);
db.intExcute_Query(sql);
foreach (DataRow dr in dtAdd.Rows)
{
sql = string.Format(@"INSERT INTO PLC_Addresses(
PLCType, ADDType, Address,
Value, HexValue, Priority,
Desc, Desc2, AddGroup)
VALUES
( '{0}', '{1}', '{2}',
'{3}', '{4}', {5},
'{6}', '{7}', '{8}' )", PLCType, AddType, dr["Address"],
dr["Value"], dr["hexValue"], dr["Priority"],
dr["Desc"], dr["Desc2"], dr["AddGroup"]);
db.intExcute_Query(sql);
}
db.CommitTransaction();
}
catch
{
db.RollBackTransaction();
throw;
}
}
