private void 자주사용한메뉴()
{
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.select_menu_click_log_last20();
l_grid.Rows.Clear();
if (dt != null && dt.Rows.Count > 0)
{
l_grid.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
l_grid.Rows[i].Cells["No"].Value = (i + 1).ToString();
l_grid.Rows[i].Cells["L_TOPMENU"].Value = dt.Rows[i]["TopName"].ToString();
l_grid.Rows[i].Cells["L_SUBMENU"].Value = dt.Rows[i]["SubName"].ToString();
l_grid.Rows[i].Cells["L_SUBMENU"].Tag = dt.Rows[i]["AsmName"].ToString();
}
}
}
catch (Exception ex)
{
Popup.pop오류리포트 msg = new Popup.pop오류리포트(ex.Message + " - " + ex.ToString());
msg.ShowDialog();
}
}
private void dgv_notice_grid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
//string sFrmName = dgv_notice_grid.Tag.ToString().Split('/')[0];
//string sMnuName = dgv_notice_grid.Tag.ToString().Split('/')[1];
//parentFrm.sub_Form(sFrmName, sMnuName);
//Debug.WriteLine(dgv_notice_grid.Rows[e.RowIndex].Cells[2].Value.ToString());
try
{
if (e.RowIndex > -1)
{
wnDm wDm = new wnDm();
DataTable dt = wDm.select_Notice(dgv_notice_grid.Rows[e.RowIndex].Cells[2].Value.ToString());
if (dt != null && dt.Rows.Count > 0)
{
noti_title.Text = dt.Rows[0]["TITLE"].ToString();
noti_comment.Text = dt.Rows[0]["CONTENT"].ToString();
noti_time.Text = dt.Rows[0]["INTIME"].ToString();
noti_writer.Text = dt.Rows[0]["STAFF_NM"].ToString();
}
}
}
catch (Exception ex)
{
Popup.pop오류리포트 msg = new Popup.pop오류리포트(ex.Message + " - " + ex.ToString());
msg.ShowDialog();
}
}
private void 북마크()
{
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
if (Common.p_strUserAdmin.Equals("5")) //권한통제자는 무조건 모든 메뉴 보여줌
{
dt = wDm.selectBookMarkMenu_admin();
}
else
{
dt = wDm.selectBookMarkMenu();
}
b_grid.Rows.Clear();
if (dt != null && dt.Rows.Count > 0)
{
b_grid.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
b_grid.Rows[i].Cells["B_TOPMENU"].Value = dt.Rows[i]["TopName"].ToString();
b_grid.Rows[i].Cells["B_SUBMENU"].Value = dt.Rows[i]["SubName"].ToString();
b_grid.Rows[i].Cells["B_SUBMENU"].Tag = dt.Rows[i]["AsmName"].ToString();
}
}
}
catch (Exception ex)
{
Popup.pop오류리포트 msg = new Popup.pop오류리포트(ex.Message + " - " + ex.ToString());
msg.ShowDialog();
}
}
private void button1_Click(object sender, EventArgs e)
{
//System.Threading.Thread.Sleep(500);
// button1.Text = "test";
//if (conLabel3.Location.Y > 0)
//{
// conLabel3.Animate(new YLocationEffect(), EasingFunctions.QuadEaseIn, 10, 2000, 0, false, 1);
//}
//else
//{
// conLabel3.Animate(new YLocationEffect(), EasingFunctions.QuadEaseIn, 5, 2000, 0, false, 1);
//}
//conLabel3.Animate(new YLocationEffect(), EasingFunctions.QuadEaseIn, 10, 2000, 0, false, -1);
//conLabel3.Location = new Point(conLabel3.Location.X, conLabel3.Location.Y + 10);
Popup.pop오류리포트 msg = new Popup.pop오류리포트();
msg.ShowDialog();
}
private void 마지막공지()
{
try
{
wnDm wDm = new wnDm();
DataTable dt = wDm.fn_last_Notice();
if (dt != null && dt.Rows.Count > 0)
{
noti_title.Text = dt.Rows[0]["TITLE"].ToString();
noti_comment.Text = dt.Rows[0]["CONTENT"].ToString();
noti_time.Text = dt.Rows[0]["INTIME"].ToString();
noti_writer.Text = dt.Rows[0]["STAFF_NM"].ToString();
}
}
catch (Exception ex)
{
Popup.pop오류리포트 msg = new Popup.pop오류리포트(ex.Message + " - " + ex.ToString());
msg.ShowDialog();
}
}
public void insert(String date, String title, String memo)
{
try
{
wnDm wDm = new wnDm();
wnAdo wAdo = new wnAdo();
StringBuilder sb = new StringBuilder();
sb.AppendLine(" insert into F_DATES (Title,date,Memo,color) values ('" + title + "','" + date + "','" + memo + "','" + scolor16 + "')");
SqlCommand sCommand = new SqlCommand(sb.ToString());
int qResult = wAdo.SqlCommandEtc(sCommand, "insert_RAW_CHK_EXAM_TB");
}
catch (Exception e)
{
wnLog.writeLog(wnLog.LOG_ERROR, e.Message + " - " + e.ToString());
Popup.pop오류리포트 msg = new pop오류리포트(e.Message + " - " + e.ToString());
msg.ShowDialog();
return;
}
}
private void clear()
{
try
{
wnDm wDm = new wnDm();
wnAdo wAdo = new wnAdo();
StringBuilder sb = new StringBuilder();
sb.AppendLine(" delete from F_DATES where Date='" + dtp.Value.ToString().Substring(0, 10) + "' ");
SqlCommand sCommand = new SqlCommand(sb.ToString());
int qResult = wAdo.SqlCommandEtc(sCommand, "insert_RAW_CHK_EXAM_TB");
}
catch (Exception e)
{
wnLog.writeLog(wnLog.LOG_ERROR, e.Message + " - " + e.ToString());
Popup.pop오류리포트 msg = new pop오류리포트(e.Message + " - " + e.ToString());
msg.ShowDialog();
return;
}
}