public void saveData(CJJBox box)
{
if (box == null)
{
return;
}
try
{
CUploadData data = saveToSqlite(box);
//uplad to sap
string sapRe = "";
string sapMsg = "";
SAPDataService.uploadJiaoJieDan(box, ref sapRe, ref sapMsg);
box.sapRe = sapRe;
box.sapMsg = sapMsg;
//save to local
LocalDataService.saveJiaoJieDan(box);
if (sapRe == "S")
{
SqliteDataService.delUploadFromSqlite(data.Guid);
}
else
{
SqliteDataService.updateMsgToSqlite(data.Guid, sapMsg);
}
}
catch (Exception ex)
{
Log4netHelper.LogError(ex);
}
}
/*
* private void savingDataThreadFunc()
* {
* while (true)
* {
* CUploadData upData = null;
* lock (savingDataLockObject)
* {
* if (savingData.Count > 0)
* {
* upData = savingData.Dequeue();
* }
* }
* if (upData != null)
* {
* SaveData(upData);
* }
*
* Thread.Sleep(1000);
* }
* }
*/
public void updateBoxList(CJJBox curBox)
{
if (curBox != null && !string.IsNullOrEmpty(curBox.hu))
{
mCurDanBoxList.RemoveAll(i => i.doc == mJiaoJieDan.doc && i.hu == curBox.hu);
mCurDanBoxList.Add(curBox);
}
}
public CUploadData saveToSqlite(CJJBox 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);
}
public void saveAndUpdate(CJJBox box)
{
if (box == null)
{
return;
}
saveData(box);
updateBoxList(box);
updateHuCount();
}
public override void StopInventory()
{
if (isInventory)
{
Invoke(new Action(() => {
label11_status.Text = "停止扫描";
}));
isInventory = false;
reader.StopInventory();
CheckResult checkResult = check(label17_currentHu.Text);
if (checkResult.InventoryResult)
{
checkResult.UpdateMessage(Consts.Default.RIGHT);
}
Invoke(new Action(() => {
lblInventoryRe.Text = checkResult.InventoryResult ? "正常" : "异常";
}));
CJJBox curBox = getCurBox(checkResult);
if (checkResult.Message.Contains(HAS_SAOMIAO_CHONGTOU) ||
checkResult.Message.Contains(WEI_SAO_DAO_XIANGHU) ||
checkResult.Message.Contains(Consts.Default.XIANG_MA_BU_YI_ZHI) ||
checkResult.Message.Contains(HAS_SAOMIAO_YICHANG))
{
}
else
{
//上传
saveAndUpdate(curBox);
}
//add grid
addgrid(curBox);
playSound(checkResult.InventoryResult);
if (checkResult.InventoryResult)
{
SetInventoryResult(1);
}
else
{
SetInventoryResult(1);
}
}
}
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();
}
}
private void initData()
{
grid.Rows.Clear();
List <CUploadData> list = SqliteDataService.GetExpUploadFromSqlite <CJJBox>();
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
CJJBox ju = item.Data as CJJBox;
if (ju != null)
{
grid.Rows.Insert(0, false, ju.hu, item.MSG);
grid.Rows[0].Tag = item;
}
}
}
}
CJJBox getCurBox(CheckResult cr)
{
CJJBox re = new CJJBox();
try
{
re.doc = mJiaoJieDan.doc;
re.user = SysConfig.CurrentLoginUser.UserId;
re.devno = SysConfig.DeviceInfo.EQUIP_HLA;
re.loucheng = SysConfig.DeviceInfo.LOUCENG;
re.hu = label17_currentHu.Text;
re.inventoryRe = cr.InventoryResult ? "S" : "E";
re.inventoryMsg = cr.Message;
re.epc = epcList.ToList();
re.tags = tagDetailList.ToList();
}
catch (Exception e)
{
Log4netHelper.LogError(e);
}
return(re);
}
public void addgrid(CJJBox box)
{
try
{
List <string> mats = box.tags.Select(i => i.MATNR).Distinct().ToList();
Invoke(new Action(() =>
{
foreach (var item in mats)
{
int c = box.tags.Count(i => i.MATNR == item && !i.IsAddEpc);
TagDetailInfo ti = box.tags.First(i => i.MATNR == item && !i.IsAddEpc);
grid.Rows.Insert(0, box.hu, ti.ZSATNR, ti.ZCOLSN, ti.ZSIZTX, c, box.inventoryMsg + " " + "SAP:" + box.sapMsg);
if (box.inventoryRe == "E" || box.sapRe == "E")
{
grid.Rows[0].DefaultCellStyle.BackColor = Color.OrangeRed;
}
}
}));
}
catch (Exception)
{
}
}
bool boxSame(string hu)
{
CJJBox box = mCurDanBoxList.FirstOrDefault(i => i.hu == hu);
return(LocalDataService.compareListStr(box.epc, epcList));
}
