/// <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); } }); }