private void button1_Click(object sender, EventArgs e)
{
string html_filename = Basic_HTB_Info.baseFilePath + "\\temp\\" + String.Format("{0}_{1}.htm", psi_id, pitem);
Field_Html_Print h_o = null;
Field_Html_Print h_o_xls = null;
if (prcx == "RCFJH")
{
h_o = new FieldJH_Html_Print(psi_id, pitem, prcx, conn, html_filename,new RC_F_GR(),false);
h_o_xls = new FieldJH_Html_Print(psi_id, pitem, prcx, conn, html_filename.Replace(".htm",".xls"), new RC_F_GR(), false);
}
else
{
h_o=new Field_Html_Print(psi_id, pitem, prcx, conn, html_filename,new RC_F_GR(),false);
h_o_xls = new Field_Html_Print(psi_id, pitem, prcx, conn, html_filename.Replace(".htm",".xls"), new RC_F_GR(), false);
}
Form_RC_OUT_RESULT out_r = new Form_RC_OUT_RESULT(h_o.html_filename);
out_r.MdiParent = this.MdiParent;
out_r.Show();
FileInfo info = new FileInfo(html_filename);
FileInfo info_xls = new FileInfo(html_filename.Replace(".htm",".xls"));
if (info.Exists)
{
if (MessageBox.Show("是否公布名單?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
info.CopyTo(Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}名單.htm", pitem), true);
info_xls.CopyTo(Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}名單.xls", pitem), true);
}
// MessageBox.Show("檔案CopyTo Temp");
}
}
private void DownXls_F_ITEM_NAME(String extra_filename)
{
FolderBrowserDialog fbd = new FolderBrowserDialog();
fbd.SelectedPath = Basic_HTB_Info.cfg.TempdataKey("path1");
if (fbd.ShowDialog() == DialogResult.OK)
{
Basic_HTB_Info.cfg.tempdata["path1"] = fbd.SelectedPath;
MPPFORM.ListBoxForm lbf = new MPPFORM.ListBoxForm();
using (OdbcConnection conn = new OdbcConnection(Basic_HTB_Info.Conn_Str))
{
conn.Open();
OdbcDataReader dr = new OdbcCommand("select fi_id,f_item,rcx from field_item;", conn).ExecuteReader();
while (dr.Read())
{
lbf.lb.Items.Add(String.Format("{0}:{1}:{2}", dr[0], dr[1], dr[2]));
}
if (lbf.ShowDialog() == DialogResult.OK)
{
foreach (string s in lbf.lb.CheckedItems)
{
string[] s_ar = s.Split(':');
string si_id = s_ar[0];
string item = s_ar[1];
string rcx = s_ar[2];
if (item.Contains("跳高"))
{
string f_name = String.Format("{0}\\{1}.{2}", fbd.SelectedPath, item, extra_filename);
Field_Html_Print rc_html_p = new FieldJH_Html_Print(si_id, item, rcx, conn, f_name,new RC_F_GR(),false);
}
else
{
string f_name = String.Format("{0}\\{1}.{2}", fbd.SelectedPath, item, extra_filename);
Field_Html_Print rc_html_p = new Field_Html_Print(si_id, item, rcx, conn, f_name,new RC_F_GR(),false);
}
}
}
conn.Close();
}
}
}
private void Form_Input_RC_Client_FormClosed(object sender, FormClosedEventArgs e)
{
if (Basic_HTB_Info.cfg.temp_dir != null)
{
Field_Html_Print h_o = null;
string html_filename = Basic_HTB_Info.cfg.temp_dir + "\\" + String.Format("{0}_{1}.htm", psi_id, pitem);
if (prcx == "RCFJH")
{
h_o = new FieldJH_Html_Print(psi_id, pitem, prcx, conn, html_filename, new RC_F_GR(), false);
}
else
{
h_o = new Field_Html_Print(psi_id, pitem, prcx, conn, html_filename, new RC_F_GR(), false);
}
try
{
String url = "ftp://" + Basic_HTB_Info.cfg.DB_HOST + "/" + String.Format("{0}_{1}.htm", psi_id, pitem);
MPPNET.MPPFtp.ftp_up_file(url, h_o.html_filename, "sportday", "701100", Encoding.GetEncoding(950));
}
catch (Exception ftp_e)
{
MessageBox.Show(ftp_e.Message + ":多於一個用戶登入;");
}
Form_RC_OUT_RESULT out_r = new Form_RC_OUT_RESULT(h_o.html_filename);
out_r.MdiParent = this.MdiParent;
out_r.Show();
}
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
}