/// <summary>
/// 将当前"网址设置表"数据插入新表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int InsertWebsiteConfig2NewAndwho(DataTable data)
{
int result = 0;
try
{
string sql = "delete from t_website_config";
UpdateDBHelper db = new UpdateDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
sql = "INSERT INTO t_website_config(WebOrder,Name,URL)values(@WebOrder,@Name,@URL)";
SQLiteParameter[] parameters = null;
foreach (DataRow dr in data.Rows)
{
parameters = new SQLiteParameter[]{
new SQLiteParameter("@WebOrder",dr["WebOrder"]),
new SQLiteParameter("@Name",dr["Name"]),
new SQLiteParameter("@URL",dr["URL"])
};
result += db.ExecuteNonQuery(sql, parameters);
}
}
catch (Exception ex)
{
log.WriteLog(ex.ToString());
}
return result;
}
/// <summary>
/// 将当前"定时表"数据插入新表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int InsertDingshi2NewDingshi(DataTable data)
{
int result = 0;
try
{
string sql = "delete from t_dingshi";
UpdateDBHelper db = new UpdateDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
sql = "INSERT INTO t_dingshi(Id,Frequency,Time,ExecEvents,FilePath)values(@Id,@Frequency,@Time,@ExecEvents,@FilePath)";
SQLiteParameter[] parameters = null;
foreach (DataRow dr in data.Rows)
{
parameters = new SQLiteParameter[]{
new SQLiteParameter("@Id",dr["Id"]),
new SQLiteParameter("@Frequency",dr["Frequency"]),
new SQLiteParameter("@Time",dr["Time"]),
new SQLiteParameter("@ExecEvents",dr["ExecEvents"]),
new SQLiteParameter("@FilePath",dr["FilePath"])
};
result += db.ExecuteNonQuery(sql, parameters);
}
}
catch (Exception ex)
{
log.WriteLog(ex.ToString());
}
return result;
}
/// <summary>
/// 将当前"提醒表"数据插入新表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int InsertTixing2NewTixing(DataTable data)
{
int result = 0;
try
{
string sql = "delete from t_tixing";
UpdateDBHelper db = new UpdateDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
sql = "INSERT INTO t_tixing(Id,Time,Info)values(@Id,@Time,@Info)";
SQLiteParameter[] parameters = null;
foreach (DataRow dr in data.Rows)
{
parameters = new SQLiteParameter[]{
new SQLiteParameter("@Id",dr["Id"]),
new SQLiteParameter("@Time",dr["Time"]),
new SQLiteParameter("@Info",dr["Info"])
};
result += db.ExecuteNonQuery(sql, parameters);
}
}
catch (Exception ex)
{
log.WriteLog(ex.ToString());
}
return result;
}
/// <summary>
/// 将当前"设置表"数据插入新表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int InsertConfig2NewConfig(DataTable data)
{
int result = 0;
try
{
string sql = "delete from t_config";
UpdateDBHelper db = new UpdateDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
sql = "INSERT INTO t_config(Name,Value)values(@Name,@Value)";
SQLiteParameter[] parameters = null;
foreach (DataRow dr in data.Rows)
{
parameters = new SQLiteParameter[]{
new SQLiteParameter("@Name",dr["Name"]),
new SQLiteParameter("@Value",dr["Value"])
};
result += db.ExecuteNonQuery(sql, parameters);
}
}
catch (Exception ex)
{
log.WriteLog(ex.ToString());
}
return result;
}