using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace Redmine
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Conn_DB();
//MySqlConnection conn;
//string myConnectionString;
//myConnectionString = "server=xxx.xxx.xxx.xxx;uid=redmine;pwd=xxxxxxx;database=redmine;";
//try
//{
// conn = new MySql.Data.MySqlClient.MySqlConnection();
// conn.ConnectionString = myConnectionString;
// conn.Open();
// Label1.Text = "성공";
//}
//catch (MySql.Data.MySqlClient.MySqlException ex)
//{
// Label1.Text = ex.Message;
//}
}
private void Conn_DB()
{
//using 문을 사용하기 위한 Web.config
//<configuration>
// <connectionStrings>
// <add name="redmine" connectionString="SERVER=xxxxxxxxxxxx ;DATABASE=redmine;user
// id=redmine;PASSWORD=xxxxxxxxxxxxxx"/>
// <add name="ApplicationServices"
// connectionString="data source=.\SQLEXPRESS;Integrated //Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
// providerName="System.Data.SqlClient" />
//</connectionStrings>
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["redmine"].ToString()))
{
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
con.Open();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
//cmd.CommandText = "SELECT COUNT(*) FROM issues WHERE status_id='1' OR status_id='6' ORDER BY id DESC";
//cmd.CommandText = "SELECT id, status_id, SUBJECT, author_id, due_date, created_on, updated_on FROM issues WHERE status_id='1' OR status_id='6' ORDER BY id DESC LIMIT 50";
cmd.CommandText = "SELECT id, status_id, SUBJECT, author_id, IFNULL(due_date,'값이없습니다.'), created_on, updated_on FROM issues WHERE status_id='1' OR status_id='6' ORDER BY id DESC LIMIT 52";
MySqlDataReader DbReader = cmd.ExecuteReader();
Label1.Text += "<table border=0>";
Label1.Text += "<tr>";
Label1.Text += "<td width=60>";
Label1.Text += "<b>ID</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=60>";
Label1.Text += "<b>상태</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=500>";
Label1.Text += "<b>제목</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=60>";
Label1.Text += "<b>사용자</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=100>";
Label1.Text += "<b>종료날자</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=150>";
Label1.Text += "<b>생성날자</b>";
Label1.Text += "</td>";
Label1.Text += "<td width=150>";
Label1.Text += "<b>업데이트날자</b>";
Label1.Text += "</td>";
Label1.Text += "</tr>";
while (DbReader.Read())
{
//Response.Write("NO : " + DbReader_View.GetString(0) + "<br>"); //no
//Response.Write("IPAddress : " + DbReader_View.GetString(1) + "<br>"); //IpAddr
//Response.Write("SMS 메세지 : " + DbReader_View.GetString(2) + "<br>"); //Msg
//Response.Write("발송 시간 : " + DbReader_View.GetString(3) + "<p>"); //DateTime
// Label1.Text += "<hr>" + "ID : " + DbReader.GetString(0) + " 제목: " + DbReader.GetString(1) + "종료날자 : " + DbReader.GetString(2) +"상태 : " + DbReader.GetString(3) + "사용자 : " + DbReader.GetString(4) + "생성날자 : " + DbReader.GetString(5) + "업데이트날자 : " + DbReader.GetString(6) + "<p>";
//Label1.Text += "<hr>" + "ID : " + DbReader.GetString(0) + "<br>";
//Label1.Text += " 제목: " + DbReader.GetString(1) + "<br>";
//Label1.Text += "종료날자 : " + DbReader.GetString(2) + "<br>";
//Label1.Text += "상태 : " + DbReader.GetString(3) + "<p>";
//Label1.Text += "사용자 : " + DbReader.GetString(4) + "<p>";
//Label1.Text += "생성날자 : " + DbReader.GetString(5) + "<p>";
//Label1.Text += "업데이트날자 : " + DbReader.GetString(6) + "<p>";
//DbReader.GetString(4).Replace(int 15, var "사용자");
//DbReader.GetString(3).Replace("1", "신규");
Label1.Text += "<tr>";
Label1.Text += "<td>";
Label1.Text += "<a> " + DbReader.GetString(0) + "</a>";
Label1.Text += "</td>";
Label1.Text += "<td>";
if (DbReader.GetString(1) == "1")
{
Label1.Text += "<a>" + DbReader.GetString(1).Replace("1", "<font color=red>신규</font>") + "</a>";
}
else if (DbReader.GetString(1) == "6")
{
Label1.Text += "<a>" + DbReader.GetString(1).Replace("6", "<font color=blue>진행중</font>") + "</a>";
}
Label1.Text += "<td>";
Label1.Text += "<a href=https://www.duck.pe.kr/redmine/issues/" + DbReader.GetString(0) + " target=_blank>" + DbReader.GetString(2) + "</a>";
Label1.Text += "</td>";
Label1.Text += "<td>";
if (DbReader.GetString(3) == "15")
{
Label1.Text += "<a href=https://www.duck.pe.kr/redmine/issues/" + DbReader.GetString(0) + " target=_blank>" + DbReader.GetString(3).Replace("15", "<font color=red>미할당<font>") + "</a>";
}
else if (DbReader.GetString(3) == "184")
{
Label1.Text += "<a>" + DbReader.GetString(3).Replace("184", "ㅋㅋㅋ") + "</a>";
}
Label1.Text += "</td>";
Label1.Text += "<td>";
Label1.Text += "<a>" + DbReader.GetString(4) + "</a>";
Label1.Text += "</td>";
Label1.Text += "<td>";
Label1.Text += "<a>" + DbReader.GetString(5) + "</a>";
Label1.Text += "</td>";
Label1.Text += "<td>";
Label1.Text += "<a>" + DbReader.GetString(6) + "</a>";
Label1.Text += "</td>";
Label1.Text += "</tr>";
}
DbReader.Close();
con.Close();
Label1.Text += "</table>";
}
}
}
}
Rss Feed