public FIELD_Html_Basic(string si_id, string s_item, string rcx, OdbcConnection conn, string file_name,iGR pGR,bool blankformat)
{
this.conn = conn;
this.s_item = s_item;
this.si_id = si_id;
aagr = pGR;
if (rcx != null)
{
this.rcx = rcx;
}
else
{
if (s_item.Contains("跳高"))
{
this.rcx = "RCFJH";
}
else
{
this.rcx="RCFIE";
}
}
string col_span = null;
string c_fieldnames = null;
if (rcx == "RCFJH")
{
fieldnames = "frc_id,rcx,rank,s_number,number,classno,name,h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,h16,rc,note";
c_fieldnames = "名次,次序,比賽號,姓名,班級,";
c_fieldnames += "h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,h16,";
c_fieldnames += "成績,備註";
}
else if (rcx == "RCFIE")
{
fieldnames = "frc_id,rcx,rank,s_number,number,classno,name,h1,h2,h3,b3,h4,h5,b5,h6,rc,note";
c_fieldnames = "名\n次,次\n序,比賽\n號,姓名,班級,一,二,三,B3,四,五,B5,六,成績,備註";
}
else
{
throw new Exception("RCFJH,RCFIE");
}
Basic_HTB_Info.Adjust_FieldName(ref fieldnames, ref c_fieldnames, ref col_span);
th_ar = c_fieldnames.Split(',');
colspan_ar = col_span.Split(',');
html_filename = file_name;
}
public RC_Html_Output(string si_id,string s_item,string rcx,OdbcConnection conn,string file_name,iGR pGR):base(si_id,s_item,rcx,conn,file_name,pGR)
{
StreamWriter sw = new StreamWriter(html_filename,false,Encoding.Default);
if (file_name.ToLower().Contains(".htm")) {
sw.WriteLine(RC_Html_EXCEL_TAG.html_head);
}
else
{
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>",s_item);
sw.WriteLine("<table border=1 width=100%><tr>{0}",TH_STR());
using (OdbcDataReader dr = new OdbcCommand(String.Format("select rc_id,{0} from sport_rc where si_id='{1}' order by rc;", fieldnames,si_id), conn).ExecuteReader())
{
SortedList slist = new SortedList();
while (dr.Read())
{
string key = null;
if (dr["note"].ToString().Contains("GR"))
{
key = String.Format("-{0}-{1}",dr["rc"] , dr["rc_id"]);
}
else if (dr["note"].ToString().Trim() == "")
{
key = String.Format("-{0}-{1}", dr["rc"], dr["rc_id"]);
}
else if (dr["rc"].ToString().Trim() == "")
{
key = String.Format("ZZZZZZZZZ-{0}-{1}", dr["rc"], dr["rc_id"]);
}
else
{
key = String.Format("{0}-{1}-{2}", dr["note"].ToString().TrimStart(), dr["rc"], dr["rc_id"]);
}
string val = "<tr>";
for (int i = 3; i < dr.FieldCount; i++)
{
val += string.Format("<td colspan={0}>{1} ", colspan_ar[i - 3], dr[i]);
}
slist.Add(key, val);
}
for (int i = 0; i < slist.Count; i++)
{
sw.WriteLine("{0}",slist.GetByIndex(i));
}
}
sw.WriteLine("</table><br><hr>");
sw.WriteLine(GR_STR(si_id,conn,rcx));
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_END);
sw.Flush();
sw.Close();
sw.Dispose();
}
/// <summary>
/// 進級結果并輸出進級名單porm_list
/// </summary>
/// <param name="si_id"></param>
/// <param name="s_item"></param>
/// <param name="rcx"></param>
/// <param name="p_si_id"></param>
/// <param name="p_s_item"></param>
/// <param name="p_rcx"></param>
/// <param name="conn"></param>
/// <param name="porm_list">進級名單porm_list</param>
/// <param name="file_name"></param>
/// <param name="pGR"></param>
public RC_Prom_Html_Output(string si_id,string s_item,string rcx,string p_si_id,string p_s_item,string p_rcx,OdbcConnection conn,out List<string> porm_list,string file_name,iGR pGR):base(si_id,s_item,rcx,conn,file_name,pGR)
{
int p_cnt = 0;
if (p_s_item.Contains("(初賽)")) p_cnt = group_p_cnt * 4;
if (p_s_item.Contains("(複賽)")) p_cnt = group_p_cnt * 2;
if (p_s_item.Contains("(決賽)")) p_cnt = group_p_cnt;
MPPFORM.InputStrBox inputtxt = new MPPFORM.InputStrBox("進級人數:",p_cnt.ToString());
if (inputtxt.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
int out_int=p_cnt;
if (int.TryParse(inputtxt.textbox_str, out out_int))
{
p_cnt = out_int;
System.Windows.Forms.MessageBox.Show("人數修改為:" + p_cnt);
}
else
{
System.Windows.Forms.MessageBox.Show("數字格式錯誤:"+inputtxt.textbox_str+" 使用默認值:"+p_cnt);
}
}
StreamWriter sw = new StreamWriter(html_filename, false, Encoding.Default);
if (file_name.ToLower().Contains(".htm"))
{
sw.WriteLine(RC_Html_EXCEL_TAG.html_head);
}
else
{
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>", s_item);
sw.WriteLine("<table border=1 width=100%><tr>{0}",TH_STR());
string[] f_ar = fieldnames.Split(',');
using (OdbcDataReader dr = new OdbcCommand(String.Format("select rc_id,{0} from sport_rc where si_id='{1}' order by rc;", fieldnames, si_id), conn).ExecuteReader())
{
DataTable dt = new DataTable();
dt.Columns.Add("rc_key"); dt.Columns.Add("rc_id");
foreach (string s in f_ar) dt.Columns.Add(s);
while (dr.Read())
{
DataRow d_row=dt.NewRow();
string key = null;
if (dr["rc"].ToString().Trim() == "" ) { key = "NULL"; }
else if (dr["note"].ToString().Contains("GR") || dr["note"].ToString() == "")
{
key = String.Format("{0}-{1}", dr["rc"], dr["rc_id"]);
}
else
{
key = String.Format("{0}-{1}-{2}", dr["note"], dr["rc"], dr["rc_id"]);
}
d_row["rc_key"] = key;
for (int i = 0; i < dr.FieldCount; i++)
d_row[dr.GetName(i)] = dr[i];
d_row["grk"] = d_row["rank"];
dt.Rows.Add(d_row);
}
DataView dv =dt.DefaultView;
dv.Sort = "rc_key";
int drv_cnt = 0;
porm_list = new List<string>();
string[] porm_road_s=null;
if(group_p_cnt==7)
{
porm_road_s= new String[]{ ",4;,5;,3;,6;,2;,7;,8", "二,4;一,4;一,5;二,5;二,3;一,3;一,6;二,6;二,2;一,2;二,7;一,7;一,8;二,8" };
}else if(group_p_cnt==6)
{
porm_road_s = new String[] { ",4;,5;,3;,6;,2;,7;,8", "二,4;一,4;一,5;二,5;二,3;一,3;一,6;二,6;二,2;一,2;二,7;一,7;一,8;二,8" };
}
else
{
porm_road_s =new String[]{",4;,5;,3;,6;,2;,1;,7;,8","二,4;一,4;一,5;二,5;二,3;一,3;一,6;二,6;二,2;一,2;一,1;二,1;二,7;一,7;一,8;二,8",
"三,4;二,4;一,4;一,5;二,5;三,5;三,3;二,3;一,3;一,6;二,6;三,6;三,2;二,2;一,2;一,1;二,1;三,1;一,7;二,7;三,7;一,8;二,8;三,8",
"四,4;三,4;二,4;一,4;一,5;二,5;三,5;四,5;四,3;三,3;二,3;一,3;一,6;二,6;三,6;四,6;四,2;三,2;二,2;一,2;一,1;二,1;三,1;四,1;四,7;三,7;二,7;一,7;一,8;二,8;三,8;四,8"
};
}
int temp_ = p_cnt / group_p_cnt - 1;
if (temp_ < 0) temp_ = 0;
string[] porm_road=porm_road_s[temp_].Split(';');
foreach (DataRowView drv in dv)
{
drv_cnt++;
sw.WriteLine("<tr>");
if (drv["rank"].ToString().Trim() != "") { sw.Write("<td>{0} ", drv_cnt); } else { sw.Write("<td> "); }
for (int j = 5; j < dv.Table.Columns.Count; j++)
{
sw.Write("<td colspan={0}>{1} ", colspan_ar[j-4],drv[j]);
}
if (drv_cnt <= p_cnt)
{
sw.Write("Q");
porm_list.Add(string.Format("{0},{1},{2}", p_si_id, porm_road[(drv_cnt - 1)],drv["rc_id"]));
}
}
}
sw.WriteLine("</table><br><br>");
sw.WriteLine(GR_STR(si_id,conn,rcx));
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_END);
sw.Flush();
sw.Close();
sw.Dispose();
}
public RC_Html_Print(string si_id, string s_item, string rcx, OdbcConnection conn,string file_name,iGR pGR)
: base(si_id, s_item, rcx,conn,file_name,pGR)
{
// html_filename = Basic_HTB_Info.baseFilePath + "\\temp\\" + String.Format("{0}_{1}.htm", si_id, s_item);
StreamWriter sw = new StreamWriter(html_filename,false,Encoding.GetEncoding(950));
if (file_name.ToLower().Contains(".htm"))
{
sw.WriteLine(RC_Html_EXCEL_TAG.html_head);
}
else
{
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>",s_item);
sw.WriteLine("<table border=1 width=100%><tr>{0}",TH_STR());
string gr_out_str=GR_STR(si_id, conn,rcx);
int group_cnt = 0;
using (OdbcDataReader dr = new OdbcCommand(String.Format("select rc_id,{0} from sport_rc where si_id='{1}' order by group_id,road;", fieldnames, si_id), conn).ExecuteReader())
{
string group_str = null;
bool group_flag=false;
for(int i=0;i<dr.FieldCount;i++) if(dr.GetName(i)=="group_id"){group_flag=true;break;}
while (dr.Read())
{
if (group_flag)
{
if (group_str == null) group_str = dr["group_id"].ToString(); if (group_str != dr["group_id"].ToString())
{
sw.WriteLine("</table><br>");
group_str = dr["group_id"].ToString();
group_cnt++;
if (group_cnt % 2 == 0)
{
sw.WriteLine(gr_out_str);
sw.WriteLine("<br class=break>");
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>", s_item);
}
sw.WriteLine("<table border=1 width=100%><tr>{0}",TH_STR());
}
}
sw.Write( "<tr>");
for(int i=3; i<dr.FieldCount;i++)
sw.Write("<td colspan={0}>{1} ",colspan_ar[i-3], dr[i]);
}
}
sw.WriteLine("</table><br><br>");
sw.WriteLine(gr_out_str);
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_END);
sw.Flush();
sw.Close();
sw.Dispose();
}
public RC_Html_Basic(string si_id,string s_item,string rcx,OdbcConnection conn,string file_name,iGR pGR)
{
string col_span = null;
string c_fieldnames = null;
c_fieldnames = Basic_HTB_Info.Get_Signflag_s(rcx);
fieldnames = Basic_HTB_Info.signflag_sql[rcx].ToString();
aagr = pGR;
Basic_HTB_Info.Adjust_FieldName(ref fieldnames, ref c_fieldnames, ref col_span);
th_ar = c_fieldnames.Split(',');
colspan_ar = col_span.Split(',');
html_filename = file_name;
this.conn = conn;
this.s_item = s_item;
this.rcx = rcx;
}
public Field_Html_Print(string si_id, string s_item, string rcx, OdbcConnection conn, string file_name,iGR pGR,bool blankformat)
: base(si_id, s_item, rcx, conn, file_name,pGR,blankformat)
{
// html_filename = Basic_HTB_Info.baseFilePath + "\\temp\\" + String.Format("{0}_{1}.htm", si_id, s_item);
StreamWriter sw = new StreamWriter(html_filename, false, Encoding.GetEncoding(950));
if (!blankformat)
{
if (file_name.ToLower().Contains(".htm"))
{
sw.WriteLine(RC_Html_EXCEL_TAG.html_head);
}
else
{
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
//sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>", s_item);
sw.WriteLine("<table border=1 width=100%><tr>{0}", TH_STR());
string gr_out_str = GR_STR(si_id, conn, rcx);
main_content(si_id, s_item, rcx, gr_out_str, conn, sw);
sw.WriteLine("</table><br><hr>");
sw.WriteLine(gr_out_str);
if(!blankformat)
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_END);
sw.Flush();
sw.Close();
sw.Dispose();
}
public FieldJH_Html_Print(string si_id, string s_item, string rcx, OdbcConnection conn, string file_name,iGR pgr,bool blankformat)
: base(si_id, s_item, rcx, conn, file_name,pgr,blankformat)
{
}
public Field_Html_Output(string si_id, string s_item, string rcx, OdbcConnection conn, string file_name,iGR pGR,bool blankformat)
: base(si_id, s_item, rcx, conn, file_name,pGR,blankformat)
{
StreamWriter sw = new StreamWriter(html_filename, false, Encoding.Default);
if (file_name.ToLower().Contains(".htm"))
{
sw.WriteLine(RC_Html_EXCEL_TAG.html_head);
}
else
{
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
}
//sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_HEAD);
sw.WriteLine("<B><center>成績公告<br>{0}</center></b>", s_item);
sw.WriteLine("<table border=1 width=100%>{0}", TH_STR());
string gr_out_str = GR_STR(si_id, conn, rcx);
main_content(si_id, s_item, rcx, gr_out_str, conn, sw);
sw.WriteLine("</table><br><hr>");
sw.WriteLine(GR_STR(si_id, conn, rcx));
sw.WriteLine(RC_Html_EXCEL_TAG.EXCEL_END);
sw.Flush();
sw.Close();
sw.Dispose();
}
