/// <summary>
/// 上传零件记录
/// </summary>
public static void UploadMaterialTable()
{
try
{
string sql = string.Format("SELECT * FROM {0}", BaseVariable.ResultTableName);
//获取当前产品的数据表
DataTable table = LocalDbDAL.GetDataTable(sql);
if (table == null || table.Rows.Count == 0)
{
return;
}
//向服务器发送请求，数据上传并返回上传成功的数据TID
string IDs = ResultDAL.Upload(BaseVariable.DeviceEntity.ProductType, BaseVariable.ResultTableName, table);
if (!string.IsNullOrEmpty(IDs))
{
sql = string.Format("DELETE FROM {0} WHERE tid IN ({1});", BaseVariable.ResultTableName, IDs);
LocalDbDAL.ExecuteSql(sql);//上传后删除本地数据
CLog.WriteStationLog("Sys", "UploadMaterialTable:TID->{" + IDs + "},Time:{" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "}");
//string[] str = IDs.Split(',');
}
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
}
}
/// <summary>
/// 上传零件记录
/// </summary>
private void UploadTable()
{
this.Invoke((EventHandler) delegate
{
try
{
Cursor.Current = Cursors.WaitCursor;
progressBar.Value = 0;
progressBar.Maximum = 1;
string sql = string.Format("SELECT * FROM {0}", BaseVariable.ResultTableName);
//获取当前产品的数据表
DataTable table = LocalDbDAL.GetDataTable(sql);
if (table == null || table.Rows.Count < 1)
{
return;
}
//向服务器发送请求，数据上传并返回上传成功的数据TID
string IDs = ResultDAL.Upload(BaseVariable.DeviceEntity.ProductType, BaseVariable.ResultTableName, table);
if (!string.IsNullOrEmpty(IDs))
{
sql = string.Format("DELETE FROM {0} WHERE tid IN ({1});", BaseVariable.ResultTableName, IDs);
LocalDbDAL.ExecuteSql(sql);//上传后删除本地数据
string [] str = IDs.Split(',');
uploadnum += str.Length;
}
ProgressTip(1);//更新进度
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
}
});
}
