/// <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>
private void GetTol()
{
CreateTolTxT();
string tol = FStreamHelper.GetTxT("Tol.txt");
if (!string.IsNullOrEmpty(tol))
{
tol = tol.Replace("----", "|");
tol = tol.Split('|')[1];
topTol = Convert.ToDouble(tol.Split(',')[0]);
botTol = Convert.ToDouble(tol.Split(',')[1]);
}
}
private void SetTolForm_Load(object sender, EventArgs e)
{
string tol = FStreamHelper.GetTxT("Tol.txt");
if (!string.IsNullOrEmpty(tol))
{
tol = tol.Replace("----", "|");
tol = tol.Split('|')[1];
TopTol = tol.Split(',')[0];
BotTol = tol.Split(',')[1];
txtBottol.Text = BotTol;
txtToptol.Text = TopTol;
}
}
/// <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>
/// 根据时间获取数据
/// </summary>
/// <param name="time1"></param>
/// <param name="time2"></param>
/// <returns></returns>
public DataTable GetDataInfobyDate(string time1, string time2)
{
DataTable dt = FStreamHelper.ExcelToDataTable(DataFilePath);
DataRow[] drs = dt.Select(string.Format("createtime = '{0}' and updatetime = '{1}'", time1, time2));
if (drs != null)
{
if (drs.Length > 0)
{
foreach (var item in drs)
{
dt.Rows.Remove(item);
}
}
}
return(dt);
}
/// <summary>
/// 根据id获取本地数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable GetDataInfobyId(string id)
{
DataTable dt = FStreamHelper.ExcelToDataTable(DataFilePath);
DataRow[] drs = dt.Select(string.Format("id = '{0}'", id));
DataTable newdt = dt.Clone();
if (drs != null)
{
if (drs.Length > 0)
{
foreach (var item in drs)
{
newdt.ImportRow(item);
}
}
}
return(newdt);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (txtToptol.Text == "0")
{
MsgBoxHelper.AlertMsgBox("上工差不能为0", "提示");
txtToptol.Focus();
return;
}
if (txtBottol.Text == "0")
{
MsgBoxHelper.AlertMsgBox("下工差不能为0", "提示");
txtBottol.Focus();
return;
}
TopTol = txtToptol.Text;
BotTol = txtBottol.Text;
FStreamHelper.WriteTxT(TopTol + "," + BotTol, "Tol.txt", false);
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <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));
}
/// <summary>
/// 获取所有二维码数据
/// </summary>
/// <returns></returns>
public DataTable GetCodeData()
{
return(FStreamHelper.ExcelToDataTable(DataFilePath));
}
