private void EnqueueUploadData(UploadBoxInfo data) { SqliteUploadDataInfo ud = new SqliteUploadDataInfo(); ud.Guid = Guid.NewGuid().ToString(); ud.Data = data; ud.IsUpload = 0; ud.CreateTime = DateTime.Now; PackingBoxSqliteService.InsertUploadData(ud); UploadServer.GetInstance().CurrentUploadQueue.Push(ud); }
public static void InsertUploadData(SqliteUploadDataInfo ud) { string sql = string.Format(@"INSERT INTO UploadData(Guid,Data,IsUpload,CreateTime) VALUES('{0}','{1}',0,'{2}')", ud.Guid, JsonConvert.SerializeObject(ud.Data), ud.CreateTime.ToString("yyyy-MM-dd HH:mm:ss")); int result = SqliteDBHelp.ExecuteSql(sql); if (result <= 0) { LogHelper.WriteLine(JsonConvert.SerializeObject(ud.Data)); } }
private void uploadAgainButton_Click(object sender, EventArgs e) { List <PBBoxInfo> rowBoxList = new List <PBBoxInfo>(); List <DataGridViewRow> rows = GetCheckedRows(); if (rows != null && rows.Count > 0) { foreach (DataGridViewRow row in rows) { PBBoxInfo box = row.Tag as PBBoxInfo; if (box != null) { if (!rowBoxList.Exists(r => r.HU == box.HU)) { rowBoxList.Add(box); } } } } foreach (PBBoxInfo data in rowBoxList) { UploadBoxInfo box = new UploadBoxInfo(); box.EQUIP_HLA = SysConfig.DeviceInfo.EQUIP_HLA; box.LGNUM = SysConfig.LGNUM; box.LOUCENG = SysConfig.DeviceInfo.LOUCENG; box.SUBUSER = SysConfig.CurrentLoginUser.UserId; box.Box = data; SqliteUploadDataInfo ud = new SqliteUploadDataInfo(); ud.Guid = Guid.NewGuid().ToString(); ud.Data = box; ud.IsUpload = 0; ud.CreateTime = DateTime.Now; PackingBoxSqliteService.InsertUploadData(ud); UploadServer.GetInstance().CurrentUploadQueue.Push(ud); } if (rowBoxList.Count > 0) { MetroMessageBox.Show(this, "成功加入上传列表", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } }
public static List <SqliteUploadDataInfo> GetUnUploadDataList() { string sql = string.Format("DELETE FROM UploadData WHERE IsUpload=1;SELECT Guid,Data,IsUpload,CreateTime FROM UploadData WHERE IsUpload = 0"); DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { List <SqliteUploadDataInfo> result = new List <SqliteUploadDataInfo>(); foreach (DataRow row in dt.Rows) { SqliteUploadDataInfo ud = new SqliteUploadDataInfo(); ud.Guid = row["Guid"].ToString(); ud.Data = JsonConvert.DeserializeObject <UploadBoxInfo>(row["Data"].ToString()); ud.IsUpload = uint.Parse(row["IsUpload"].ToString()); ud.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); result.Add(ud); } return(result); } return(null); }
void uploadSap(YKBoxInfo box) { try { SqliteUploadDataInfo ud = new SqliteUploadDataInfo(); ud.Guid = Guid.NewGuid().ToString(); ud.Data = box; ud.IsUpload = 0; ud.CreateTime = DateTime.Now; YKBoxSqliteService.InsertUploadData(ud); SapResult result = SAPDataService.UploadYKBoxInfo(SysConfig.LGNUM, box); box.SapRemark = result.MSG; box.SapStatus = result.STATUS; bool xdSaveResult = YKBoxService.SaveBox(box); YKBoxSqliteService.SetUploaded(ud.Guid); } catch (Exception e) { Log4netHelper.LogError(e); } }
private void uploadAgainButton_Click(object sender, EventArgs e) { List <YKBoxInfo> rowBoxList = new List <YKBoxInfo>(); List <DataGridViewRow> rows = GetCheckedRows(); if (rows != null && rows.Count > 0) { foreach (DataGridViewRow row in rows) { YKBoxInfo box = row.Tag as YKBoxInfo; if (box != null) { if (!rowBoxList.Exists(r => r.Hu == box.Hu)) { rowBoxList.Add(box); } } } } foreach (YKBoxInfo data in rowBoxList) { SqliteUploadDataInfo ud = new SqliteUploadDataInfo(); ud.Guid = Guid.NewGuid().ToString(); ud.Data = data; ud.IsUpload = 0; ud.CreateTime = DateTime.Now; YKBoxSqliteService.InsertUploadData(ud); UploadServer.GetInstance().CurrentUploadQueue.Push(ud); } if (rowBoxList.Count > 0) { MetroMessageBox.Show(this, "成功加入上传列表", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } }