public void Upload(CUploadData ud)
{
string re = "";
string msg = "";
uploadSAP(ud.Data as CCancelUpload, out re, out msg);
}
/// <summary>
/// 取出队列中第一个上传任务，进行上传，上传完成后删除这条
/// </summary>
public void Upload()
{
CUploadData task = null;
if (CurrentUploadQueue.Count > 0)
{
lock (_lockObject)
{
// 取出任务上传
task = CurrentUploadQueue.Dequeue() as CUploadData;
}
}
if (task != null)
{
//upload
SapResult re = SAPDataService.UploadJianHuoData(task.Data as CJianHuoUpload);
if (re.SUCCESS)
{
SqliteDataService.delUploadFromSqlite(task.Guid);
}
else
{
SqliteDataService.updateMsgToSqlite(task.Guid, re.MSG);
OnUploaded?.Invoke(task.Data as CJianHuoUpload, re);
}
}
}
private void savingDataThreadFunc()
{
while (true)
{
try
{
if (mCancel)
{
return;
}
CUploadData ud = getQueueData();
if (ud != null)
{
YKBoxInfo upData = ud.Data as YKBoxInfo;
if (upData != null)
{
//upload
string uploadRe = "";
string sapMsg = "";
SapResult result = SAPDataService.UploadYKBoxInfo(SysConfig.LGNUM, upData);
uploadRe = result.STATUS;
sapMsg = result.MSG;
if (uploadRe == "E")
{
SqliteDataService.updateMsgToSqlite(ud.Guid, sapMsg);
playSoundWarn();
}
else
{
SqliteDataService.delUploadFromSqlite(ud.Guid);
}
upData.SapRemark = result.MSG;
upData.SapStatus = result.STATUS;
//save
YKBoxService.SaveBox(upData);
if (upData.Status == "S" && uploadRe == "S")
{
updateBoxList(upData);
UpdateTotalInfo();
}
updateUploadCount();
updateExpButton();
}
}
Thread.Sleep(500);
}
catch (Exception)
{
//LogHelper.WriteLine(ex.Message + "\r\n" + ex.StackTrace.ToString());
}
}
}
public void saveData(CDianShangBox box)
{
if (box == null)
{
return;
}
try
{
CUploadData data = saveToSqlite(box);
//uplad to sap
string sapRe = "";
string sapMsg = "";
SAPDataService.uploadDianShangBox(box, ref sapRe, ref sapMsg);
box.sapRe = sapRe;
box.sapMsg = sapMsg;
if (sapRe == SUCCESS)
{
//save to local
LocalDataService.saveDianShangBox(box);
SqliteDataService.delUploadFromSqlite(data.Guid);
}
else
{
SqliteDataService.updateMsgToSqlite(data.Guid, sapMsg);
}
}
catch (Exception ex)
{
Log4netHelper.LogError(ex);
}
}
public void uploadSAP(CCancelUpload uploadData, out string sapRe, out string sapMsg)
{
sapRe = "";
sapMsg = "";
CUploadData ud = new CUploadData();
ud.Guid = Guid.NewGuid().ToString();
ud.Data = uploadData;
ud.IsUpload = 0;
ud.CreateTime = DateTime.Now;
SqliteDataService.saveToSqlite(ud);
//upload
SAPDataService.UploadCancelData(uploadData, ref sapRe, ref sapMsg);
if (sapRe != "S")
{
SqliteDataService.updateMsgToSqlite(ud.Guid, sapMsg);
playSoundWarn();
}
else
{
SqliteDataService.delUploadFromSqlite(ud.Guid);
}
}
public void Upload(CUploadData ud)
{
CDianShangBox box = ud.Data as CDianShangBox;
saveAndUpdate(box);
addgrid(box);
}
public static void saveToSqlite(CUploadData d)
{
string sql = string.Format("INSERT INTO UploadData(Guid,Data,IsUpload,CreateTime) VALUES('{0}','{1}',0,'{2}')", d.Guid, JsonConvert.SerializeObject(d.Data), d.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"));
int result = SqliteDBHelp.ExecuteSql(sql);
if (result <= 0)
{
LogHelper.WriteLine(JsonConvert.SerializeObject(d.Data));
}
}
public CUploadData saveToSqlite(CDianShangBox data)
{
CUploadData cu = new CUploadData();
cu.Guid = Guid.NewGuid().ToString();
cu.IsUpload = 0;
cu.Data = data;
cu.CreateTime = DateTime.Now;
SqliteDataService.saveToSqlite(cu);
return(cu);
}
private void btnReupload_Click(object sender, EventArgs e)
{
List <DataGridViewRow> rows = GetCheckedRows();
if (rows != null && rows.Count > 0)
{
foreach (DataGridViewRow row in rows)
{
CUploadData box = row.Tag as CUploadData;
SqliteDataService.delUploadFromSqlite(box.Guid);
mParent.addToSavingQueue(box.Data as YKBoxInfo);
}
MetroMessageBox.Show(this, "成功加入上传队列", "提示");
initData();
}
}
public void addToSavingQueue(YKBoxInfo uploadData)
{
CUploadData ud = new CUploadData();
ud.Guid = Guid.NewGuid().ToString();
ud.Data = uploadData;
ud.IsUpload = 0;
ud.CreateTime = DateTime.Now;
SqliteDataService.saveToSqlite(ud);
lock (savingDataLockObject)
{
savingData.Enqueue(ud);
}
updateUploadCount();
}
private void btnReturn_Click(object sender, EventArgs e)
{
if (grid.SelectedRows.Count > 0)
{
if (MetroMessageBox.Show(this, "确认要清除记录吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.OK)
{
foreach (DataGridViewRow row in grid.SelectedRows)
{
CUploadData box = row.Tag as CUploadData;
SqliteDataService.delUploadFromSqlite(box.Guid);
}
MetroMessageBox.Show(this, "成功清除", "提示");
initData();
}
}
}
CUploadData getQueueData()
{
CUploadData re = null;
try
{
lock (savingDataLockObject)
{
if (savingData.Count > 0)
{
return(savingData.Dequeue());
}
}
}
catch (Exception) { }
return(re);
}
private void btnReupload_Click(object sender, EventArgs e)
{
List <DataGridViewRow> rows = GetCheckedRows();
if (rows != null && rows.Count > 0)
{
foreach (DataGridViewRow row in rows)
{
CUploadData data = row.Tag as CUploadData;
SqliteDataService.delUploadFromSqlite(data.Guid);
CJJBox box = data.Data as CJJBox;
mParent.saveAndUpdate(box);
mParent.addgrid(box);
}
initData();
}
}
public void updateSAP(YKBoxInfo uploadData)
{
CUploadData ud = new CUploadData();
ud.Guid = Guid.NewGuid().ToString();
ud.Data = uploadData;
ud.IsUpload = 0;
ud.CreateTime = DateTime.Now;
SqliteDataService.saveToSqlite(ud);
YKBoxInfo upData = ud.Data as YKBoxInfo;
if (upData == null)
{
return;
}
string uploadRe = "";
string sapMsg = "";
SapResult result = SAPDataService.UploadYKBoxInfo(SysConfig.LGNUM, upData);
uploadRe = result.STATUS;
sapMsg = result.MSG;
if (uploadRe == "E")
{
SqliteDataService.updateMsgToSqlite(ud.Guid, sapMsg);
}
else
{
SqliteDataService.delUploadFromSqlite(ud.Guid);
}
upData.SapRemark = result.MSG;
upData.SapStatus = result.STATUS;
//save
YKBoxService.SaveBox(upData);
if (upData.Status == "S" && uploadRe == "S")
{
updateBoxList(upData);
UpdateTotalInfo();
}
}
private void logicCheck(ref CheckResult result)
{
try
{
Dictionary <string, CJianHuoContrastRe> re = contrastEpc();
bool conOK = isContrastReOK(re);
if (!conOK)
{
result.InventoryResult = false;
result.UpdateMessage("异常");
}
else
{
result.UpdateMessage(Consts.Default.RIGHT);
}
// add grid
addGrid(re);
//print
if (conOK)
{
PrintHelper.PrintRightTag(getPrintRightData());
}
else
{
PrintHelper.PrintErrorTag(getPrintErrorData());
}
//save upload
LocalDataService.SaveJianHuoInfo(mCurBoxNo, mCurJieHuoDan.PICK_LIST, re.Values.ToList());
CJianHuoUpload uploadData = getUploadData(re);
CUploadData cu = new CUploadData();
cu.Guid = Guid.NewGuid().ToString();
cu.IsUpload = 0;
cu.Data = uploadData;
cu.CreateTime = DateTime.Now;
SqliteDataService.saveToSqlite(cu);
UploadServer.GetInstance().AddToQueue(cu);
}
catch (Exception e)
{
Log4netHelper.LogError(e);
}
}
private void btnReupload_Click(object sender, EventArgs e)
{
if (grid.SelectedRows.Count > 0)
{
Thread t = new Thread(new ThreadStart(() =>
{
ShowLoading("正在上传...");
foreach (DataGridViewRow row in grid.SelectedRows)
{
CUploadData box = row.Tag as CUploadData;
SqliteDataService.delUploadFromSqlite(box.Guid);
mUploadMethod.Upload(box);
}
initData();
HideLoading();
}));
t.IsBackground = true;
t.Start();
}
}
public static List <CUploadData> GetAllUploadFromSqlite <T>()
{
List <CUploadData> result = new List <CUploadData>();
string sql = string.Format("SELECT Guid,Data,IsUpload,CreateTime,MSG FROM UploadData order by CreateTime");
DataTable dt = SqliteDBHelp.GetTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
CUploadData ud = new CUploadData();
ud.Guid = row["Guid"].ToString();
ud.Data = JsonConvert.DeserializeObject <T>(row["Data"].ToString());
ud.IsUpload = uint.Parse(row["IsUpload"].ToString());
ud.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
ud.MSG = row["MSG"].ToString();
result.Add(ud);
}
return(result);
}
return(result);
}
