private void UpData(String boxGUID, QRBean boxBean) { DBOperation dBOperation = new DBOperation(); try { if (tbBoxID.Text == "") { throw new Exception("请先选择未上传的箱子的ID"); } DataSet dataSet = dBOperation.GetUploadCase(boxGUID); UploadData uploadData = new UploadData(); uploadData.tempDelId = BaseData.TempId; uploadData.parentCode = boxBean; foreach (DataRow Row in dataSet.Tables[0].Rows) { uploadData.childCodes.Add(QRanalyze.QRDecod(Row["FCapData"].ToString())); } String result = HttpRequest.UploadCapData(uploadData, Session.Id); RelationResult Result = JsonConvert.DeserializeObject <RelationResult>(result); if (Result.success) { dBOperation.UploadBoxTStatus(boxGUID); tbBoxID.Text = ""; tbBoxTag.Text = ""; boxGUID = ""; dgBox.DataSource = dBOperation.QueryNoUplaodBox().Tables[0]; dgBox.Columns["ID"].HeaderText = "未上传箱号ID"; dgBox.Columns["ID"].Width = 300; dgBox.Columns["FGuid"].HeaderText = "GUID编码"; dgBox.Columns["FGuid"].Width = 300; } else { throw new Exception(Result.message); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { dBOperation.Dispose(); } }
public Upload() { InitializeComponent(); DBOperation dBOperation = new DBOperation(); dgBox.DataSource = dBOperation.QueryNoUplaodBox().Tables[0]; dgBox.Columns["ID"].HeaderText = "未上传箱号ID"; dgBox.Columns["ID"].Width = 300; dgBox.Columns["FGuid"].HeaderText = "GUID编码"; dgBox.Columns["FGuid"].Width = 300; dBOperation.Dispose(); }
//数据采集触发 private void tbCaseNumber_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == 13) { String result = HttpRequest.ConfirmLowerCodeRelation(QRanalyze.QRDecod(tbCaseNumber.Text.Substring(tbCaseNumber.Text.Length - 35, 35)), Session.Id); RelationResult Result = JsonConvert.DeserializeObject <RelationResult>(result); if (!Result.success) { throw new Exception(Result.message); } if (Datas.Add(tbCaseNumber.Text.Substring(tbCaseNumber.Text.Length - 35, 35))) { capsum++; tbCapSum.Text = capsum.ToString(); DataSource.Rows.Add(capsum.ToString(), tbCaseNumber.Text.Substring(tbCaseNumber.Text.Length - 35, 35), DateTime.Now.ToString()); } else { MessageBox.Show(tbCaseNumber.Text + "重复扫描"); } //一箱数据采集完毕 if (Datas.Count == BaseData.CapSum) { DBOperation dBOperation = new DBOperation(); Guid BoxId = Guid.NewGuid(); dBOperation.AddBoxs(BoxId); dBOperation.CreatBoxOrder(BoxId, Datas); dBOperation.Dispose(); Datas.Clear(); DataSource.Clear(); capsum = 0; tbCapSum.Text = capsum.ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { tbCaseNumber.Text = ""; } }