private void MenuExportTXT_Click(object sender, EventArgs e)
{
string vFileName = "msmq.txt";
string vFileFullPath = string.Format("{0}{1}", gFilePath, vFileName);
List <string> vMSMQList = MSMQHelper.GetLocalMSMQInfo();
if (vMSMQList == null || vMSMQList.Count == 0)
{
UpdateStatusMessage(gEmptyErrorMsg, null);
return;
}
if (!Directory.Exists(gFilePath))
{
Directory.CreateDirectory(gFilePath);
}
if (File.Exists(vFileFullPath))
{
File.Delete(vFileFullPath);
}
using (StreamWriter sw = new StreamWriter(vFileFullPath, false, Encoding.UTF8))
{
for (int vIndex = 0; vIndex < vMSMQList.Count(); vIndex++)
{
sw.WriteLine(vMSMQList[vIndex]);
}
}
UpdateStatusMessage("MSMQ TXT檔已匯出", null);
}
public ImportFileForm(string pFilePath, MSMQHelper.FileTypes pFileType)
{
InitializeComponent();
gOriMSMQValueList = MSMQHelper.GetLocalMSMQInfo();
if (gOriMSMQValueList != null)
{
lBoxLocalMSMQ.DataSource = gOriMSMQValueList.Select(item => (string)item.Clone()).ToList <string>();
}
this.lbStatus.Text = "匯入畫面啟動成功";
Thread vThread = new Thread(new ParameterizedThreadStart(this.ReadFile));
vThread.IsBackground = true;
vThread.Start(new FileInfo(pFilePath, pFileType));
}
private void MenuExportCSV_Click(object sender, EventArgs e)
{
string vFileName = "msmq.csv";
string vFileFullPath = string.Format("{0}{1}", gFilePath, vFileName);
List <string> vMSMQList = MSMQHelper.GetLocalMSMQInfo();
if (vMSMQList == null || vMSMQList.Count == 0)
{
UpdateStatusMessage(gEmptyErrorMsg, null);
return;
}
IWorkbook wb = new HSSFWorkbook();
ISheet ws = wb.CreateSheet("MSMQ");
//excel title
ws.CreateRow(0);
ws.GetRow(0).CreateCell(0).SetCellValue("MSMQ Name");
//excel data
for (int vIndex = 0; vIndex < vMSMQList.Count(); vIndex++)
{
ws.CreateRow(vIndex + 1);
ws.GetRow(vIndex + 1).CreateCell(0).SetCellValue(vMSMQList[vIndex]);//只有一筆資料列
}
if (!Directory.Exists(gFilePath))
{
Directory.CreateDirectory(gFilePath);
}
if (File.Exists(vFileFullPath))
{
File.Delete(vFileFullPath);
}
using (FileStream file = new FileStream(vFileFullPath, FileMode.CreateNew))
{
wb.Write(file);
}
UpdateStatusMessage("MSMQ CSV檔已匯出", null);
}
private void LoadMSMQInformation()
{
lBoxMSMQ.DataSource = MSMQHelper.GetLocalMSMQInfo();
}
