private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { try { int pp = 0; if (this.listView1.SelectedItems.Count > 0) { string id = this.listView1.FocusedItem.SubItems[0].Text; DialogResult dr = MessageBox.Show("确认删除吗?", "提示", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { string sql = string.Format("delete from EBTime_Strategy where id='{0}'", id); mainForm.dba.DelDataBySQL(sql); timestrategies SELECTED = SingletonInfo.GetInstance().audit.TimeList.Find(C => C.ID.Equals(id)); SingletonInfo.GetInstance().audit.TimeList.Remove(SELECTED); pp = SingletonInfo.GetInstance().audit.TimeList.Count; // MessageBox.Show("策略数量:"+ pp.ToString()); FlashData(); } } else { MessageBox.Show("未选中任何行"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GetPlatformInfo() { string sqlstr = "select * from PlatformResource"; DataTable dt = mainForm.dba.getQueryInfoBySQL(sqlstr); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["platformType"].ToString() == "1") { SingletonInfo.GetInstance().CurrentURL = dt.Rows[i]["ipAddress"].ToString(); SingletonInfo.GetInstance().CurrentResourcecode = dt.Rows[i]["sourceCode"].ToString(); SingletonInfo.GetInstance().PlatformEBRName = dt.Rows[i]["platformName"].ToString(); SingletonInfo.GetInstance().PlatformContact = dt.Rows[i]["contact"].ToString(); SingletonInfo.GetInstance().PlatformPhoneNumber = dt.Rows[i]["phone"].ToString(); SingletonInfo.GetInstance().Longitude = dt.Rows[i]["longitude"].ToString(); SingletonInfo.GetInstance().Latitude = dt.Rows[i]["latitude"].ToString(); SingletonInfo.GetInstance().PlatformAddress = dt.Rows[i]["address"].ToString(); } else if (dt.Rows[i]["platformType"].ToString() == "-1") { SingletonInfo.GetInstance().SendTarAddress = dt.Rows[i]["ipAddress"].ToString(); } } } }
private void GetAuditData() { string sqlstr = "select * from EBTime_Strategy"; DataTable dt = mainForm.dba.getQueryInfoBySQL(sqlstr); for (int i = 0; i < dt.Rows.Count; i++) { timestrategies tt = new timestrategies(); tt.ID = dt.Rows[i][0].ToString(); tt.StartTime = dt.Rows[i][1].ToString(); tt.EndTime = dt.Rows[i][2].ToString(); tt.EvenType = dt.Rows[i][3].ToString(); SingletonInfo.GetInstance().audit.TimeList.Add(tt); } }
private void btn_AddEvent_Click(object sender, EventArgs e) { string StartTime = dtp_StartTime.Text; string EndTime = dtp_EndTime.Text; string EvenType = cbb_Type.SelectedValue.ToString(); string sql = string.Format("insert into EBTime_Strategy values('{0}','{1}','{2}') SELECT CAST(scope_identity() AS int)", StartTime, EndTime, EvenType); int ID = mainForm.dba.InsertDbBySQLRetID(sql); timestrategies pp = new timestrategies(); pp.ID = ID.ToString(); pp.StartTime = StartTime; pp.EndTime = EndTime; pp.EvenType = EvenType; SingletonInfo.GetInstance().audit.TimeList.Add(pp); FlashData(); }
/// <summary> /// 通用反馈 收到tar就回 /// </summary> private void CurrencyTarBack(EBD ebdb, string value) { try { ServerForm.DeleteFolder(ServerForm.strBeSendFileMakeFolder);//删除原有XML发送文件的文件夹下的XML XmlDocument xmlDoc = new XmlDocument(); responseXML rp = new responseXML(); //rp.SourceAreaCode = ServerForm.strSourceAreaCode; //rp.SourceType = ServerForm.strSourceType; //rp.SourceName = ServerForm.strSourceName; //rp.SourceID = ServerForm.strSourceID; //rp.sHBRONO = SingletonInfo.GetInstance().CurrentResourcecode; string fName = "10" + SingletonInfo.GetInstance().CurrentResourcecode + BBSHelper.GetSequenceCodes(); xmlDoc = rp.EBDResponse(ebdb, "EBDResponse", fName, value); string xmlSignFileName = "\\EBDB_" + fName + ".xml"; CreateXML(xmlDoc, ServerForm.strBeSendFileMakeFolder + xmlSignFileName); //进行签名 ServerForm.mainFrm.GenerateSignatureFile(ServerForm.strBeSendFileMakeFolder, fName); ServerForm.tar.CreatTar(ServerForm.strBeSendFileMakeFolder, ServerForm.sSendTarPath, fName);//使用新TAR string sSendTarName = ServerForm.sSendTarPath + "\\EBDT_" + fName + ".tar"; FileStream fsSnd = new FileStream(sSendTarName, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fsSnd); //时间戳 int datalen = (int)fsSnd.Length + 2; int bufferLength = 4096; long offset = 0; //开始上传时间 writeHeader(datalen.ToString(), "EBDT_" + fName + ".tar"); byte[] buffer = new byte[4096]; //已上传的字节数 int size = br.Read(buffer, 0, bufferLength); while (size > 0) { outputStream.Write(buffer, 0, size); offset += size; size = br.Read(buffer, 0, bufferLength); } outputStream.Write(Encoding.UTF8.GetBytes(sEndLine), 0, 2); outputStream.Flush();//提交写入的数据 fsSnd.Close(); } catch (Exception esb) { Console.WriteLine("401:" + esb.Message); } }
private void ServerSetForm_Load(object sender, EventArgs e) { txtZJPlat.Text = SingletonInfo.GetInstance().SendTarAddress; }