private void button2_Click(object sender, EventArgs e) { string ds_n = "0"; using (OdbcCommand cmd = new OdbcCommand(string.Format("select ds_n from field_item where fi_id={0}", psi_id), conn)) { OdbcDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ds_n = dr.GetString(0); } } String tempfilename=tempOutput(); Form_RC_OUT_RESULT out_r = new Form_RC_OUT_RESULT(tempfilename); out_r.MdiParent = this.MdiParent; out_r.Show(); FileInfo info = new FileInfo(tempfilename); FileInfo info_xls = new FileInfo(tempfilename.Replace(".htm",".xls")); if (info.Exists) { if (MessageBox.Show("是否公布名單?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { ///////////////// using (OdbcCommand cmd = new OdbcCommand(string.Format("update field_item set lock_item=1 where fi_id={0}", psi_id), conn)) { info.CopyTo(Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}賽果.htm", pitem), true); if (info_xls.Exists) { info_xls.CopyTo(Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}賽果.xls", pitem), true); } if (html_blankformat_filename != null) { FileInfo info_blnak = new FileInfo(html_blankformat_filename); info_blnak.CopyTo(Basic_HTB_Info.cfg.blanktable_to_public + string.Format("\\{0}.dat", pitem), true); } else { MessageBox.Show("檔案不存在"); } //////////////// try { MessageBox.Show( WebPost.postfile(ds_n, pitem, Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}賽果.htm", pitem))); } catch (Exception ex) { } MessageBox.Show(String.Format("{0}加鎖 更新{1}筆!", pitem, cmd.ExecuteNonQuery())); } /////////////////// } } }
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 Form_Input_RC_Client_FormClosed(object sender, FormClosedEventArgs e) { if (Basic_HTB_Info.cfg.temp_dir != null) { string html_filename = Basic_HTB_Info.cfg.temp_dir + "\\" + String.Format("{0}_{1}.htm", psi_id, pitem); RC_Html_Print h_o = new RC_Html_Print(psi_id, pitem, prcx, conn, html_filename,new RC_S_GR()); 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(); } } }
private void btn_RC_Html_Output_Click(object sender, EventArgs e) { RC_Html_Output h_o_xls = new RC_Html_Output(sport_id, sport_item, sport_rcx, conn, temp_Out_Html_filename.Replace(".htm",".xls"), new RC_S_GR()); RC_Html_Output h_o = new RC_Html_Output(sport_id, sport_item, sport_rcx, conn, temp_Out_Html_filename,new RC_S_GR()); Form_RC_OUT_RESULT out_r = new Form_RC_OUT_RESULT(h_o.html_filename); out_r.MdiParent = this.MdiParent; out_r.Show(); RC_Html_Output_BlankTable h_o_blanktable = new RC_Html_Output_BlankTable(sport_id, sport_item, sport_rcx, conn, temp_Out_Html_filename, new RC_S_GR()); }
private void btn_Print_RC_HTML_FORM_CLICK(object sender, EventArgs e) { string html_filename = Basic_HTB_Info.baseFilePath + "\\temp\\" + String.Format("{0}_{1}.htm", sport_id, sport_item); RC_Html_Print h_o = new RC_Html_Print(sport_id, sport_item, sport_rcx, conn, html_filename,new RC_S_GR()); 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); if (info.Exists) { if(MessageBox.Show("是否公布名單?","",MessageBoxButtons.YesNo)==DialogResult.Yes) { info.CopyTo(Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}名單.htm", sport_item), true); String tempfilename = Basic_HTB_Info.cfg.report_to_public + string.Format("\\{0}名單.xls", sport_item); RC_Html_Print rc_html_p = new RC_Html_Print(sport_id, sport_item, sport_rcx, conn, tempfilename, new RC_S_GR()); } } }
/// <summary> /// 輸出賽果,并輸出進級名單(Porm_Names_List) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_RC_Prom_Html_Output_Click(object sender, EventArgs e) { MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm(); string title_item = sport_item.Split('(')[0]; MessageBox.Show(title_item); using (OdbcDataReader dr = new OdbcCommand(String.Format("select si_id,s_item,rcx from sport_item where s_item like '{0}%' and lock_item is null ;", title_item), conn).ExecuteReader()) { while (dr.Read()) { if (dr[1].ToString().Contains("跳") || dr[1].ToString().Contains("球")) continue; lbf.lb.Items.Add(String.Format("{0}:{1}:{2}", dr[0], dr[1], dr[2])); } } if (lbf.ShowDialog() == DialogResult.OK && lbf.lb.SelectedIndex>-1) { string[] s_ar=lbf.lb.SelectedItem.ToString().Split(':'); if(s_ar.Length==3) { RC_Prom_Html_Output rp_o_xls = new RC_Prom_Html_Output(this.sport_id, this.sport_item, this.sport_rcx, s_ar[0], s_ar[1], s_ar[2], conn, out Porm_Names_List, temp_Out_Html_filename.Replace(".htm",".xls"), new RC_S_GR()); RC_Prom_Html_Output rp_o = new RC_Prom_Html_Output(this.sport_id, this.sport_item, this.sport_rcx, s_ar[0], s_ar[1], s_ar[2], conn, out Porm_Names_List, temp_Out_Html_filename,new RC_S_GR()); Form_RC_OUT_RESULT out_r = new Form_RC_OUT_RESULT(rp_o.html_filename); out_r.MdiParent = this.MdiParent; out_r.Show(); } } }