private void menu_Upgrade_RC(Object sender, EventArgs e)
{
MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm();
using(OdbcConnection conn=new OdbcConnection(Basic_HTB_Info.Conn_Str))
{
conn.Open();
OdbcDataReader dr = new OdbcCommand("select si_id,s_item,rcx from sport_item order by si_id ", 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]));
}
conn.Close();
}
if (lbf.ShowDialog() == DialogResult.OK)
{
string[] s_ar = lbf.lb.SelectedItem.ToString().Split(':');
string si_id=s_ar[0];
string item=s_ar[1];
string rcx = s_ar[2];
SportDayLib.Form_Input_RC f_RC = new Form_Input_RC(si_id, item,rcx,new Form_Input_RC_ACT_ForAdmin());
f_RC.MdiParent = this;
f_RC.Show();
}
}
private void menu_Upgrade_Field(Object sender, EventArgs e)
{
MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm();
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 order by fi_id;", conn).ExecuteReader();
while (dr.Read())
{
if (dr[1].ToString().Contains("跳") || dr[1].ToString().Contains("球"))
{
lbf.lb.Items.Add(String.Format("{0}:{1}:{2}", dr[0], dr[1], dr[2]));
}
}
conn.Close();
}
if (lbf.ShowDialog() == DialogResult.OK)
{
string[] s_ar = lbf.lb.SelectedItem.ToString().Split(':');
string si_id = s_ar[0];
string item = s_ar[1];
string rcx = s_ar[2];
Form_Input_FIELD_RC_ACT fact = null;
if (item.Contains("跳高"))
{
fact = new Form_Input_FIELDJUMPHIGH_RC_ACT_ForAdmin();
}
else
{
fact = new Form_Input_FIELD_RC_ACT_ForAdmin();
}
SportDayLib.Form_Input_Field_RC_Admin f_RC = new Form_Input_Field_RC_Admin(si_id, item, rcx, fact);
f_RC.MdiParent = this;
f_RC.Show();
}
}
private void menu_pulishtowebsite_field(Object sender, EventArgs e)
{
MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm();
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 where lock_item is null order by fi_id;", conn).ExecuteReader();
while (dr.Read())
{
if (dr[1].ToString().Contains("跳") || dr[1].ToString().Contains("球"))
{
lbf.lb.Items.Add(String.Format("{0}:{1}:{2}", dr[0], dr[1], dr[2]));
}
}
if (lbf.ShowDialog() == DialogResult.OK)
{
string[] s_ar = lbf.lb.SelectedItem.ToString().Split(':');
string si_id = s_ar[0];
dr = new OdbcCommand("select frc_id,fi_id,rank,group_id,road,s_number,number,classno,name,rc,grk,note from field_rc where fi_id=" + si_id, conn).ExecuteReader();
StringBuilder sb = new StringBuilder("[");
while (dr.Read())
{
sb.Append("{");
for (int i = 0; i < dr.FieldCount; i++)
{
if (!dr.IsDBNull(i))
{
if (i > 0) { sb.Append(","); }
if (i == 0) { sb.Append(String.Format("\"{0}\":\"{1}\"", Convert.ToChar(65 + i), dr.GetInt32(i)+2000)); }
else if (i < 2) { sb.Append(String.Format("\"{0}\":\"{1}\"", Convert.ToChar(65 + i), dr.GetValue(i))); }
else { sb.Append(String.Format("\"{0}\":\"{1}\"", Convert.ToChar(65 + i), dr.GetString(i).Replace(" ", "_").Trim())); }
}
}
sb.Append("}");
}
sb.Append("]");
MessageBox.Show(sb.ToString());
webpost.post(sb.ToString());
}
conn.Close();
}
}
private void button6_Click(object sender, EventArgs e)
{
int temp_int;
if (!int.TryParse(button6.Text,out temp_int)) return;
MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm();
using (OdbcConnection conn = new OdbcConnection(Basic_HTB_Info.Conn_Str))
{
conn.Open();
OdbcDataReader dr = new OdbcCommand("select si_id,s_item,rcx from sport_item where si_id= "+button6.Text, 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]));
}
conn.Close();
}
if (lbf.ShowDialog() == DialogResult.OK)
{
string[] s_ar = lbf.lb.SelectedItem.ToString().Split(':');
string si_id = s_ar[0];
string item = s_ar[1];
string rcx = s_ar[2];
SportDayLib.Form_Input_RC f_RC = new Form_Input_RC(si_id, item, rcx, new Form_Input_RC_ACT_ForAdmin());
f_RC.MdiParent = Basic_HTB_Info.cfg.MDIparent;
f_RC.Show();
}
}
private void LinkGRTB_Click(object sender, EventArgs e)
{
String si_id = sport_id;
int cnt = 0;
using (OdbcDataReader cnt_dr = new OdbcCommand("select count(*) from sport_gr where si_id="+si_id,conn).ExecuteReader())
{
cnt_dr.Read();
cnt = int.Parse(cnt_dr[0].ToString());
if (cnt > 0)
{
int temp_int= new OdbcCommand("delete from sport_gr where si_id=" + si_id, conn).ExecuteNonQuery();
}
}
MPPFORM.ListBoxFilterForm lbf = new MPPFORM.ListBoxFilterForm();
using (OdbcDataReader gr_dr = new OdbcCommand("select s_item,gr_rc,name,classno,gr_period,gr_date from sport_gr_tb order by s_item;",conn).ExecuteReader())
{
while (gr_dr.Read())
{
lbf.lb.Items.Add(String.Format("{0};{1};{2};{3};{4};{5}",gr_dr[0],gr_dr[1],gr_dr[2],gr_dr[3],gr_dr[4],gr_dr[5]));
}
}
if (lbf.ShowDialog() == DialogResult.OK)
{
String[] str = lbf.lb.SelectedItem.ToString().Split(';');
String[] value_s = new String[str.Length + 1];
value_s[0]=si_id;
int temp_int = 1;
foreach(String s in str)
{
value_s[temp_int] = s;
temp_int++;
}
Lib.inc_cmd("si_id,s_item, gr_rc, name, classno, gr_period, gr_date","sport_gr",value_s,conn);
}
}
/// <summary>
/// 進級名(insert)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Insert_Prom_Names_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)
{
string[] s_ar = lbf.lb.SelectedItem.ToString().Split(':');
if (s_ar.Length == 3)
{
string p_id = s_ar[0];
string p_item = s_ar[1];
button6.Text = p_id;
if (MessageBox.Show("del " + p_id + p_item+" records?", "p_item", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
using (OdbcCommand cmd = new OdbcCommand(String.Format("delete from sport_rc where si_id={0};", p_id), conn))
{
MessageBox.Show(String.Format("del {0} {1}筆",p_id,cmd.ExecuteNonQuery()));
if (Porm_Names_List != null)
{
MPPFORM.MsgBox msg = new MPPFORM.MsgBox(Porm_Names_List.ToArray());
msg.Show();
foreach (string s in Porm_Names_List)
{
string[] s_ar0 = s.Split(',');
string sql = String.Format("select s_number,number,classno,name from sport_rc where rc_id={0}", s_ar0[s_ar0.Length - 1]);
using (OdbcDataReader dr = new OdbcCommand(sql,conn).ExecuteReader())
{
if (dr.Read())
{
List<string> ls = new List<string>();
ls.Add(s_ar0[0]); ls.Add(s_ar0[1]); ls.Add(s_ar0[2]);
for (int i = 0; i < dr.FieldCount; i++) if (!dr.IsDBNull(i)) { ls.Add(dr.GetString(i)); } else { ls.Add(""); }//
Lib.inc_cmd("si_id,group_id,road,s_number,number,classno,name", "sport_rc", ls.ToArray(), conn);
}
}
}
}
}
}
}
}
}
/// <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();
}
}
}
