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