/// <summary>
/// 根据id删除本地数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteInfobyId(string id)
{
DataTable dt = FStreamHelper.ExcelToDataTable(DataFilePath);
DataRow drt = dt.Select("id = '" + id + "'")[0];
dt.Rows.Remove(drt);
return(FStreamHelper.ToExcel(dt, string.Empty, "sheet1", DataFilePath));
}
/// <summary>
/// 保存新数据到本地
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool InsertCodeData(object data)
{
DataTable dt = FStreamHelper.ExcelToDataTable(DataFilePath);
DataTable newdt = FDataHelper.JArrToDT(data.ToString());
if (newdt.Rows.Count > 0)
{
foreach (var item in newdt.Rows)
{
dt.Rows.Add(item);
}
}
return(FStreamHelper.ToExcel(dt, string.Empty, "sheet1", DataFilePath));
}
/// <summary>
/// 根据id更新本地数据
/// </summary>
/// <param name="id"></param>
/// <param name="data"></param>
/// <returns></returns>
public bool UpdateInfobyId(string id, object data)
{
DataTable dt = FStreamHelper.ExcelToDataTable(DataFilePath);
DataRow[] drt = dt.Select("id = '" + id + "'");
if (drt != null)
{
if (drt.Length > 0)
{
foreach (var item in drt)
{
dt.Rows.Remove(item);
}
}
}
DataTable newdt = FDataHelper.JArrToDT(data.ToString());
foreach (var item in newdt.Rows)
{
dt.Rows.Add(item);
}
return(FStreamHelper.ToExcel(dt, string.Empty, "sheet1", DataFilePath));
}
