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