public EditSyncConfigDialog(SyncConfigViewModel syncConfig)
{
InitializeComponent();
DataContext = this;
if (null != syncConfig)
{
SyncConfig = syncConfig;
}
}
/// <summary>
/// 修改同步配置
/// </summary>
/// <param name="syncConfig"></param>
/// <returns></returns>
private int ModifySyncConfig(SyncConfigViewModel syncConfig)
{
var row = SQLite.ExecuteNonQuery("UPDATE media_sync_config SET PC_PATH = @PcPath, MOBILE_PATH = @MobilePath, ENABLE = @Enable WHERE ID = @Id",
new List <SQLiteParameter> {
new SQLiteParameter("@PcPath", syncConfig.PcPath),
new SQLiteParameter("@MobilePath", syncConfig.MobilePath),
new SQLiteParameter("@Enable", syncConfig.Enable),
new SQLiteParameter("@Id", syncConfig.Id)
});
return(row);
}
/// <summary>
/// 新增同步配置
/// </summary>
/// <param name="syncConfig"></param>
/// <returns></returns>
private int SaveSyncConfig(SyncConfigViewModel syncConfig)
{
if (string.IsNullOrEmpty(syncConfig.PcPath) || string.IsNullOrEmpty(syncConfig.MobilePath))
{
return(0);
}
var row = SQLite.ExecuteNonQuery("INSERT INTO media_sync_config(ID, PC_PATH, MOBILE_PATH, ENABLE) VALUES ((SELECT IFNULL(MAX(ID), 0)+1 FROM media_sync_config), @PcPath, @MobilePath, @Enable)",
new List <SQLiteParameter> {
new SQLiteParameter("@PcPath", syncConfig.PcPath),
new SQLiteParameter("@MobilePath", syncConfig.MobilePath),
new SQLiteParameter("@Enable", syncConfig.Enable)
});
if (row > 0)
{
//查询最新添加的记录ID
var newID = SQLite.sqlone("SELECT MAX(id) FROM media_sync_config", null);
syncConfig.Id = Convert.ToInt32(newID);
}
return(row);
}
