/// <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); } } } } } } } } }
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(); } }
public override void main_content(string si_id, string s_item, string rcx, string gr_out_str, OdbcConnection conn, StreamWriter sw) { // base.main_content(si_id, s_item, rcx, gr_out_str, conn, sw); using (OdbcDataReader dr = new OdbcCommand(String.Format("select frc_id,{0} from field_rc where fi_id='{1}' order by BIT_LENGTH( rank),rank;", fieldnames, si_id), conn).ExecuteReader()) { SortedList slist = new SortedList(); int cnt = 0; while (dr.Read()) { decimal temp_d = GETKEY(dr["rc"].ToString(),dr["note"].ToString(),cnt); cnt++; string val = "<tr>"; for (int i = 3; i < 8; i++) { if(dr.IsDBNull(i)||dr.GetString(i).Trim().Equals("")){ val += String.Format("<td align=\"right\" rowspan=2 colspan={0}>{1} ", colspan_ar[i - 3], dr[i]); }else{ val += String.Format("<td align=\"right\" rowspan=2 colspan={0}>{1}", colspan_ar[i - 3], dr[i]); } } String Silverf = "White"; for (int i = 8; i < dr.FieldCount - 2; i++) { for (int j = 0; j < 3; j++) { if (j < dr[i].ToString().Length) { val += String.Format("<td align=\"right\">{0}", dr[i].ToString().ToUpper()[j]); } else { val += String.Format("<td><font color={0}>.</font>",Silverf); } } if (i == 8 + 7) { val += String.Format("<td align=right rowspan=2>{0} <td rowspan=2>{1} <tr bgcolor=Silver>", dr["rc"], dr["note"]); Silverf = "Silver"; } } slist.Add(temp_d, val); } for (int i = 0; i < slist.Count; i++) { sw.WriteLine("{0}", slist.GetByIndex(i)); } } }