public void Upload(CCmnUploadData ud) { string re = ""; string msg = ""; uploadSAP(ud.Data as CPKCheckUpload, out re, out msg); }
public void uploadSAP(CPKCheckUpload uploadData, out string sapRe, out string sapMsg) { sapRe = ""; sapMsg = ""; CCmnUploadData ud = new CCmnUploadData(); ud.Guid = Guid.NewGuid().ToString(); ud.Data = uploadData; ud.IsUpload = 0; ud.CreateTime = DateTime.Now; ud.HU = uploadData.mHu; CSqliteDataService.saveToSqlite(ud); //upload SAPDataService.uploadPKCheck(uploadData, out sapRe, out sapMsg); if (sapRe != "S") { CSqliteDataService.updateMsgToSqlite(ud.Guid, sapMsg); playSoundWarn(); dmButton1_exception_query.BackColor = Color.OrangeRed; } else { CSqliteDataService.delUploadFromSqlite(ud.Guid); } }
public static void saveToSqlite(CCmnUploadData d) { string sql = string.Format("INSERT INTO UploadData(Guid,Data,IsUpload,CreateTime,HU) VALUES('{0}','{1}',0,'{2}','{3}')", d.Guid, JsonConvert.SerializeObject(d.Data), d.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), d.HU); int result = SqliteDBHelp.ExecuteSql(sql); if (result <= 0) { LogHelper.WriteLine(JsonConvert.SerializeObject(d.Data)); } }
private void btnReturn_Click(object sender, EventArgs e) { List <DataGridViewRow> rows = GetCheckedRows(); if (rows != null && rows.Count > 0) { if (MetroMessageBox.Show(this, "确认要清除记录吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.OK) { foreach (DataGridViewRow row in rows) { CCmnUploadData box = row.Tag as CCmnUploadData; CSqliteDataService.delUploadFromSqlite(box.Guid); } } } if (rows != null && rows.Count > 0) { MetroMessageBox.Show(this, "成功清除", "提示"); initData(); } }
private void btnReupload_Click(object sender, EventArgs e) { List <DataGridViewRow> rows = GetCheckedRows(); if (rows != null && rows.Count > 0) { Thread t = new Thread(new ThreadStart(() => { ShowLoading("正在上传..."); foreach (DataGridViewRow row in rows) { CCmnUploadData box = row.Tag as CCmnUploadData; CSqliteDataService.delUploadFromSqlite(box.Guid); mUploadMethod.Upload(box); } initData(); HideLoading(); })); t.IsBackground = true; t.Start(); } }
public static List <CCmnUploadData> GetAllUploadFromSqlite <T>() { List <CCmnUploadData> result = new List <CCmnUploadData>(); string sql = string.Format("SELECT Guid,Data,IsUpload,CreateTime,MSG,HU FROM UploadData order by CreateTime"); DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { CCmnUploadData ud = new CCmnUploadData(); 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(); ud.HU = row["HU"].ToString(); result.Add(ud); } return(result); } return(result); }
void UploadMsgFormMethod.Upload(CCmnUploadData ud) { CDianShangOutCheckUploadData box = ud.Data as CDianShangOutCheckUploadData; }